|
Included in Windchill 9.1
|
Package
|
API (PROCEDURES/ FUNCTIONS)
|
Caller
|
|
Yes
|
pk_tib_open_item_import
|
submit_itemimportreq
n_org_id IN NUMBER,
ln_all_organizations IN NUMBER,
ln_validate_items IN NUMBER,
ln_process_items IN NUMBER,
ln_delete_processed_rows IN NUMBER,
ln_process_set IN NUMBER,
ln_createUpdate_items IN NUMBER,
out_chr_retcode OUT VARCHAR2,
out_chr_errbuf OUT VARCHAR2,
out_request_id OUT NUMBER,
out_status OUT VARCHAR2
|
APPS.pk_tib_open_item _import.Main, APPS .pk_tib_open_item _import.main_update
|
|
Yes
|
pk_tib_open_item_import
|
pro_pre_OpenItem
p_header_rec IN OUT TIB_INT_MTL_SYS_ITEMS_IFACE% ROWTYPE,
p_detail_rec1 IN OUT tib_mtl_item_revisio_tab_type1,
p_unique_id IN NUMBER,
p_return_status OUT VARCHAR2
|
APPS.pk_tib_open_item _import.OpenItem_ Validation
|
|
Yes
|
pk_tib_open_item_import
|
pro_post_OpenItem
p_header_rec IN TIB_INT_MTL_SYS_ITEMS_IFACE% ROWTYPE,
p_detail_rec1 IN tib_mtl_item_revisio_tab_type1,
p_unique_id IN NUMBER,
p_return_status IN OUT VARCHAR2
|
APPS.pk_tib_open_item _import.OpenItem_ Validation
|
|
Yes
|
pk_tib_open_item_import
|
OpenItem_Validation
out_errbuf OUT VARCHAR2,
out_retcode OUT VARCHAR2
|
APPS.pk_tib_open_item _import.main, APPS.pk_tib_open_item _import.main_update
|
|
Yes
|
pk_tib_open_item_import
|
main_update
out_errbuf OUT VARCHAR2,
out_retcode OUT VARCHAR2,
in_concurrent_flag IN VARCHAR2, -- should be set to 'Y' if submitted as a concurrent request.
-- if it is a normal Subscription Scenario
-- should be set to 'N' if only the profiles need to be set
-- i.e. In case of Subscription Reply Scenario
in_skip_validn_flag IN VARCHAR2, -- If 'Y' then skip the intermediate stage i.e. Data directly
-- inserted into the Interface Table.
-- Currently populate the value as 'N'
in_user_id IN NUMBER DEFAULT 0, -- User Id
in_resp_id IN NUMBER DEFAULT 0, -- Responsibility Id
in_resp_appl_id IN NUMBER DEFAULT 0, -- Responsibility Application Id
in_organization_id IN NUMBER,
in_all_organizations IN NUMBER, -- User has the option of entering.
in_validate_items IN NUMBER, -- User has the option of entering.
in_process_items IN NUMBER, -- User has the option of entering.
in_delete_processed_rows IN NUMBER, -- User has the option of entering.
in_process_set IN NUMBER, -- User has the option of entering.
in_createUpdate_items IN NUMBER -- User has the option of entering.
|
APPS.pk_tib_open_ item _import.main_adb_update
|
|
Yes
|
pk_tib_open_item_import
|
main
out_errbuf OUT VARCHAR2,
out_retcode OUT VARCHAR2,
in_concurrent_flag IN VARCHAR2, -- should be set to 'Y' if submitted as a concurrent request.
-- if it is a normal Subscription Scenario
-- should be set to 'N' if only the profiles need to be set
-- i.e. In case of Subscription Reply Scenario
in_skip_validn_flag IN VARCHAR2, -- If 'Y' then skip the intermediate stage i.e. Data directly
-- inserted into the Interface Table.
-- Currently populate the value as 'N'
in_user_id IN NUMBER DEFAULT 0, -- User Id
in_resp_id IN NUMBER DEFAULT 0, -- Responsibility Id
in_resp_appl_id IN NUMBER DEFAULT 0, -- Responsibility Application Id
in_organization_id IN NUMBER,
in_all_organizations IN NUMBER, -- User has the option of entering.
in_validate_items IN NUMBER, -- User has the option of entering.
in_process_items IN NUMBER, -- User has the option of entering.
in_delete_processed_rows IN NUMBER, -- User has the option of entering.
in_process_set IN NUMBER, -- User has the option of entering.
in_createUpdate_items IN NUMBER -- User has the option of entering.
|
APPS.pk_tib_open_item _import.main_adb_create
|
|
Yes
|
pk_tib_open_item_import
|
main_adb_create
out_var1 OUT VARCHAR2,
out_var2 OUT VARCHAR2,
out_var3 OUT VARCHAR2
|
TIBCO Adapter
|
|
Yes
|
pk_tib_open_item_import
|
main_adb_update
out_var1 OUT VARCHAR2,
out_var2 OUT VARCHAR2,
out_var3 OUT VARCHAR2
|
TIBCO Adapter
|
|
Yes
|
pk_tib_engchord_import
|
Pro_Post_ECO
p_eco_hdr_rec ENG_ECO_PUB.Eco_Rec_Type,
p_eco_ord_rev ENG_ECO_PUB.Eco_Revision_Tbl_Type,
p_eco_rev_itm ENG_ECO_PUB.Revised_Item_Tbl_Type,
p_eco_rev_comp BOM_BO_PUB.Rev_Component_Tbl_Type,
p_eco_ref_desg BOM_BO_PUB.Ref_Designator_Tbl_Type,
p_eco_subs_comp BOM_BO_PUB.Sub_Component_Tbl_Type,
p_eco_rev_opn BOM_RTG_PUB.Rev_Operation_Tbl_Type,
p_eco_opn_rsrc BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type,
p_eco_sub_rsrc BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type,
p_unique_id IN NUMBER,
p_return_status OUT VARCHAR2
|
APPS.pk_tib_engchord_ import.EngChOrd_ Validation
|
|
Yes
|
pk_tib_engchord_import
|
Pro_Pre_ECO
p_eco_hdr_rec ENG_ECO_PUB.Eco_Rec_Type,
p_eco_ord_rev ENG_ECO_PUB.Eco_Revision_Tbl_Type,
p_eco_rev_itm ENG_ECO_PUB.Revised_Item_Tbl_Type,
p_eco_rev_comp BOM_BO_PUB.Rev_Component_Tbl_Type,
p_eco_ref_desg BOM_BO_PUB.Ref_Designator_Tbl_Type,
p_eco_subs_comp BOM_BO_PUB.Sub_Component_Tbl_Type,
p_eco_rev_opn BOM_RTG_PUB.Rev_Operation_Tbl_Type,
p_eco_opn_rsrc BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type,
p_eco_sub_rsrc BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type,
p_unique_id IN NUMBER,
p_return_status OUT VARCHAR2
|
APPS.pk_tib_engchord_ import.EngChOrd_ Validation
|
|
Yes
|
pk_tib_engchord_import
|
EngChOrd_Validation
out_errbuf OUT VARCHAR2,
out_retcode OUT VARCHAR2
|
APPS.pk_tib_engchord_ import.main
|
|
Yes
|
pk_tib_engchord_import
|
main
out_errbuf OUT VARCHAR2,
out_retcode OUT VARCHAR2,
in_concurrent_flag IN VARCHAR2, -- should be set to Y if submitted as a concurrent request
in_skip_validn_flag IN VARCHAR2 -- If Y then skip the intermediate stage
|
APPS.pk_tib_engchord_ import.main_adb
|
|
Yes
|
pk_tib_engchord_import
|
main_adb
out_var1 OUT VARCHAR2,
out_var2 OUT VARCHAR2,
out_var3 OUT VARCHAR2
|
TIBCO Adapter
|
|
Yes
|
pk_tib_billsapi_import
|
Pro_Pre_BOM_API_1155
p_header_rec IN OUT Bom_Bo_Pub.Bom_Head_Rec_Type,
p_detail1_rec IN OUT Bom_Bo_Pub.Bom_Revision_Tbl_Type,
p_detail2_rec IN OUT Bom_Bo_Pub.Bom_Comps_Tbl_Type,
p_grand_detail21 IN OUT Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type,
p_grand_detail22 IN OUT Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type,
p_unique_id IN VARCHAR2,
p_return_status OUT VARCHAR2
|
APPS.pk_tib_billsapi_ import.BillsAPI_ Validation
|
|
Yes
|
pk_tib_billsapi_import
|
Pro_Post_BOM_API_1155
p_header_rec IN OUT Bom_Bo_Pub.Bom_Head_Rec_Type,
p_detail1_rec IN OUT Bom_Bo_Pub.Bom_Revision_Tbl_Type,
p_detail2_rec IN OUT Bom_Bo_Pub.Bom_Comps_Tbl_Type,
p_grand_detail21 IN OUT Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type,
p_grand_detail22 IN OUT Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type,
p_unique_id IN VARCHAR2,
p_return_status OUT VARCHAR2
|
APPS.pk_tib_billsapi_ import.BillsAPI_ Validation
|
|
Yes
|
pk_tib_billsapi_import
|
BillsAPI_Validation
out_errbuf OUT VARCHAR2,
out_retcode OUT VARCHAR2
|
APPS.pk_tib_billsapi_ import.main
|
|
Yes
|
pk_tib_billsapi_import
|
main
out_errbuf OUT VARCHAR2,
out_retcode OUT VARCHAR2,
in_concurrent_flag IN VARCHAR2, -- should be set to Y if subitted as a concurrent request
in_skip_validn_flag IN VARCHAR2 -- If Y then skip the intermediate stage
|
APPS.pk_tib_billsapi_ import.main_adb
|
|
Yes
|
pk_tib_billsapi_import
|
main_adb
out_var1 OUT VARCHAR2,
out_var2 OUT VARCHAR2,
out_var3 OUT VARCHAR2
|
TIBCO Adapter
|
|
Yes
|
PTC_RTG_API
|
RoutingsAPI_Validation
out_errbuf OUT VARCHAR2,
out_retcode OUT VARCHAR2
|
APPS.PTC_RTG_API
|
|
Yes
|
PTC_RTG_API
|
main
out_errbuf OUT VARCHAR2,
out_retcode OUT VARCHAR2,
in_concurrent_flag IN VARCHAR2, -- should be set to Y if subitted as a concurrent request
in_skip_validn_flag IN VARCHAR2 -- If Y then skip the intermediate stage
|
APPS.PTC_RTG_ API.main_adb
|
|
Yes
|
PTC_RTG_API
|
main_adb
out_var3
OUT VARCHAR2
|
TIBCO Adapter
|
|
Yes
|
PTC_RTG_BOM
|
BILLS_ALL
TIBCO_KEY_VALUE IN VARCHAR2
|
APPS.PTC_RTG_API. RoutingsAPI_Validation
|
|
Yes
|
pk_tib_log
|
log_interface_status
in_log_rec IN log_rec_type
|
Any methods from above list
|
|
Yes
|
pk_tib_engchord_import
|
IsSubstituteForDelete
in_tibco_key varchar2,
in_eco_name varchar2,
in_revised_item varchar2,
in_organization_code varchar2,
in_component_item varchar2,
in_substitute_item varchar2
|
APPS.pk_tib_engchord _import.DO_DIS_COMP
|
|
Yes
|
pk_tib_engchord_import
|
esi_GetEffectivity
in_tibco_key in varchar2,
in_eco_name in varchar2,
in_revised_item in varchar2,
in_organization_code in varchar2,
in_component_item in varchar2,
out_start_effectivity_date out date,
out_qty_per_assembly out number,
out_Op_seq_num out number,
out_FromEndItemUnitNumber out varchar2,
out_trans_type out varchar2,
out_revise_itm_rev out varchar2
|
APPS.pk_tib_engchord _import.DO_DIS_COMP
|
|
Yes
|
pk_tib_engchord_import
|
DO_DIS_COMP
N_TIBCO_KEY IN VARCHAR2,
IN_ECO_NAME IN VARCHAR2
|
APPS.pk_tib_engchord_ import.EngChOrd_ Validation
|