eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_IMPORT_PVT dependencies on EGO_IMPORT_OPTION_SETS

Line 5682: l_import_xref_only EGO_IMPORT_OPTION_SETS.IMPORT_XREF_ONLY%TYPE;

5678: l_msg_text VARCHAR2(4000);
5679: dumm_status NUMBER;
5680: l_org_id NUMBER;
5681:
5682: l_import_xref_only EGO_IMPORT_OPTION_SETS.IMPORT_XREF_ONLY%TYPE;
5683: l_inventory_item_id MTL_SYSTEM_ITEMS_INTERFACE.INVENTORY_ITEM_ID%TYPE;
5684: l_transaction_id MTL_SYSTEM_ITEMS_INTERFACE.TRANSACTION_ID%TYPE;
5685: BEGIN
5686: Debug_Conc_Log('Starting Process_SSXref_Intf_Rows for batch_id='||TO_CHAR(p_data_set_id));

Line 5690: FROM EGO_IMPORT_BATCHES_B b, EGO_IMPORT_OPTION_SETS opt

5686: Debug_Conc_Log('Starting Process_SSXref_Intf_Rows for batch_id='||TO_CHAR(p_data_set_id));
5687: BEGIN
5688: SELECT b.SOURCE_SYSTEM_ID, NVL(opt.IMPORT_XREF_ONLY, 'N')
5689: INTO l_ss_id, l_import_xref_only
5690: FROM EGO_IMPORT_BATCHES_B b, EGO_IMPORT_OPTION_SETS opt
5691: WHERE b.BATCH_ID = p_data_set_id
5692: AND b.BATCH_ID = opt.BATCH_ID;
5693: EXCEPTION WHEN NO_DATA_FOUND THEN
5694: l_ss_id := get_pdh_source_system_id;

Line 6011: , p_instance_rev_policy IN EGO_IMPORT_OPTION_SETS.REVISION_IMPORT_POLICY%TYPE

6007: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
6008: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
6009: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
6010: , p_organization_code IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_CODE%TYPE
6011: , p_instance_rev_policy IN EGO_IMPORT_OPTION_SETS.REVISION_IMPORT_POLICY%TYPE
6012: )
6013: RETURN BOOLEAN IS
6014: l_temp VARCHAR2(1);
6015: BEGIN

Line 6071: FROM EGO_IMPORT_OPTION_SETS

6067:
6068: BEGIN
6069: -- See if the batch is GDSN Enabled
6070: SELECT NVL(ENABLED_FOR_DATA_POOL, 'N') INTO l_is_batch_GDSN_enabled
6071: FROM EGO_IMPORT_OPTION_SETS
6072: WHERE BATCH_ID = p_data_set_id;
6073:
6074: IF l_is_batch_GDSN_enabled = 'Y' AND p_bundle_id IS NOT NULL THEN
6075: FOR rec in item_group_cr LOOP

Line 6119: l_batch_rev_policy EGO_IMPORT_OPTION_SETS.REVISION_IMPORT_POLICY%TYPE;

6115: l_item_num_gen MTL_ITEM_CATALOG_GROUPS_B.ITEM_NUM_GEN_METHOD%TYPE;
6116: l_item_desc_gen MTL_ITEM_CATALOG_GROUPS_B.ITEM_DESC_GEN_METHOD%TYPE;
6117: l_organization_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE;
6118: l_organization_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
6119: l_batch_rev_policy EGO_IMPORT_OPTION_SETS.REVISION_IMPORT_POLICY%TYPE;
6120: l_instance_rev_policy MTL_SYSTEM_ITEMS_INTERFACE.REVISION_IMPORT_POLICY%TYPE;
6121: l_style_item_flag MTL_SYSTEM_ITEMS_INTERFACE.STYLE_ITEM_FLAG%TYPE;
6122: BEGIN
6123: SELECT

Line 6130: EGO_IMPORT_OPTION_SETS OPT

6126: NVL(OPT.REVISION_IMPORT_POLICY, 'L')
6127: INTO l_organization_id, l_organization_code, l_batch_rev_policy
6128: FROM MTL_PARAMETERS MP,
6129: EGO_IMPORT_BATCHES_B ba,
6130: EGO_IMPORT_OPTION_SETS OPT
6131: WHERE BA.ORGANIZATION_ID = MP.ORGANIZATION_ID AND
6132: BA.BATCH_ID = OPT.BATCH_ID AND
6133: BA.BATCH_ID = p_data_set_id;
6134:

Line 6413: l_import_xref_only EGO_IMPORT_OPTION_SETS.IMPORT_XREF_ONLY%TYPE;

6409: IS
6410: l_org_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE;
6411: l_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
6412: l_ss_id EGO_IMPORT_BATCHES_B.SOURCE_SYSTEM_id%TYPE;
6413: l_import_xref_only EGO_IMPORT_OPTION_SETS.IMPORT_XREF_ONLY%TYPE;
6414: l_party_name VARCHAR2(1000);
6415: l_security_predicate VARCHAR2(4000);
6416: l_return_status VARCHAR2(100);
6417: l_sql VARCHAR2(32000);

Line 6421: l_enabled_for_data_pool EGO_IMPORT_OPTION_SETS.ENABLED_FOR_DATA_POOL%TYPE;

6417: l_sql VARCHAR2(32000);
6418:
6419: l_insert_date DATE;
6420: l_org VARCHAR2(100);
6421: l_enabled_for_data_pool EGO_IMPORT_OPTION_SETS.ENABLED_FOR_DATA_POOL%TYPE;
6422: BEGIN
6423: Debug_Conc_Log( 'Resolve_SSXref_on_Data_load - Entering' );
6424:
6425: Debug_Conc_Log( 'Resolve_SSXref_on_Data_load - Gather Statistics' );

Line 6441: EGO_IMPORT_OPTION_SETS OPT

6437: NVL(ENABLED_FOR_DATA_POOL, 'N')
6438: INTO l_org_id, l_org_code, l_ss_id, l_import_xref_only, l_enabled_for_data_pool
6439: FROM MTL_PARAMETERS MP,
6440: EGO_IMPORT_BATCHES_B BA,
6441: EGO_IMPORT_OPTION_SETS OPT
6442: WHERE BA.ORGANIZATION_ID = MP.ORGANIZATION_ID
6443: AND BA.BATCH_ID = p_data_set_id
6444: AND BA.BATCH_ID = OPT.BATCH_ID;
6445: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 7923: l_import_policy EGO_IMPORT_OPTION_SETS.REVISION_IMPORT_POLICY%TYPE;

7919: l_org_id EGO_IMPORT_BATCHES_B.ORGANIZATION_ID%TYPE;
7920: l_item_id NUMBER;
7921: l_revision MTL_ITEM_REVISIONS_B.REVISION%TYPE;
7922: l_error BOOLEAN;
7923: l_import_policy EGO_IMPORT_OPTION_SETS.REVISION_IMPORT_POLICY%TYPE;
7924:
7925: l_import_xref_only EGO_IMPORT_OPTION_SETS.IMPORT_XREF_ONLY%TYPE;
7926: l_party_name VARCHAR2(1000);
7927: l_security_predicate VARCHAR2(4000);

Line 7925: l_import_xref_only EGO_IMPORT_OPTION_SETS.IMPORT_XREF_ONLY%TYPE;

7921: l_revision MTL_ITEM_REVISIONS_B.REVISION%TYPE;
7922: l_error BOOLEAN;
7923: l_import_policy EGO_IMPORT_OPTION_SETS.REVISION_IMPORT_POLICY%TYPE;
7924:
7925: l_import_xref_only EGO_IMPORT_OPTION_SETS.IMPORT_XREF_ONLY%TYPE;
7926: l_party_name VARCHAR2(1000);
7927: l_security_predicate VARCHAR2(4000);
7928: l_return_status VARCHAR2(100);
7929: l_sql VARCHAR2(32000);

Line 7930: l_enabled_for_data_pool EGO_IMPORT_OPTION_SETS.ENABLED_FOR_DATA_POOL%TYPE;

7926: l_party_name VARCHAR2(1000);
7927: l_security_predicate VARCHAR2(4000);
7928: l_return_status VARCHAR2(100);
7929: l_sql VARCHAR2(32000);
7930: l_enabled_for_data_pool EGO_IMPORT_OPTION_SETS.ENABLED_FOR_DATA_POOL%TYPE;
7931: l_org VARCHAR2(100);
7932: BEGIN
7933: -- get the source_system_id for this batch
7934: Debug_Conc_Log( 'Resolve_Child_Entities START' );

Line 7943: FROM EGO_IMPORT_BATCHES_B BA, EGO_IMPORT_OPTION_SETS OPT

7939: NVL(OPT.REVISION_IMPORT_POLICY, 'L'),
7940: NVL(opt.IMPORT_XREF_ONLY, 'N'),
7941: NVL(opt.ENABLED_FOR_DATA_POOL, 'N')
7942: INTO l_ss_id, l_org_id, l_import_policy, l_import_xref_only, l_enabled_for_data_pool
7943: FROM EGO_IMPORT_BATCHES_B BA, EGO_IMPORT_OPTION_SETS OPT
7944: WHERE BA.BATCH_ID = p_data_set_id AND BA.BATCH_ID = OPT.BATCH_ID;
7945: EXCEPTION WHEN NO_DATA_FOUND THEN
7946: l_org := fnd_profile.value('EGO_USER_ORGANIZATION_CONTEXT');
7947: BEGIN

Line 9423: l_ssxref_only EGO_IMPORT_OPTION_SETS.IMPORT_XREF_ONLY%TYPE;

9419: l_request_id MTL_SYSTEM_ITEMS_INTERFACE.REQUEST_ID%TYPE;
9420: l_org_id MTL_SYSTEM_ITEMS_INTERFACE.ORGANIZATION_ID%TYPE;
9421: l_item_number MTL_SYSTEM_ITEMS_INTERFACE.ITEM_NUMBER%TYPE;
9422: l_item_id MTL_SYSTEM_ITEMS_INTERFACE.INVENTORY_ITEM_ID%TYPE;
9423: l_ssxref_only EGO_IMPORT_OPTION_SETS.IMPORT_XREF_ONLY%TYPE;
9424:
9425: l_is_pdh_batch BOOLEAN;
9426: l_is_reimport BOOLEAN;
9427: l_is_ssxref_only BOOLEAN;

Line 9445: FROM EGO_IMPORT_BATCHES_B BATCH, EGO_IMPORT_OPTION_SETS OPT

9441: , NVL( OPT.IMPORT_XREF_ONLY, 'N' )
9442: INTO l_batch_ss_id
9443: , l_org_id
9444: , l_ssxref_only
9445: FROM EGO_IMPORT_BATCHES_B BATCH, EGO_IMPORT_OPTION_SETS OPT
9446: WHERE BATCH.BATCH_ID = p_batch_id
9447: AND BATCH.ORGANIZATION_ID = p_organization_id
9448: AND BATCH.BATCH_ID = OPT.BATCH_ID;
9449: EXCEPTION

Line 12336: FROM EGO_IMPORT_OPTION_SETS

12332:
12333: BEGIN
12334: SELECT NVL(ADD_ALL_TO_CHANGE_FLAG,'N')
12335: INTO l_add_all_change_flag
12336: FROM EGO_IMPORT_OPTION_SETS
12337: WHERE BATCH_ID = p_batch_id;
12338: RETURN l_add_all_change_flag;
12339: EXCEPTION
12340: WHEN OTHERS THEN

Line 12802: FROM EGO_IMPORT_BATCHES_B b, EGO_IMPORT_OPTION_SETS opt

12798:
12799: -- Bug: 5262421, if IMPORT_XREF_ONLY is 'Y', then we will show 0 as after import count for AML
12800: BEGIN
12801: SELECT NVL(opt.IMPORT_XREF_ONLY, 'N') INTO l_import_xref_only
12802: FROM EGO_IMPORT_BATCHES_B b, EGO_IMPORT_OPTION_SETS opt
12803: WHERE b.BATCH_ID = p_set_process_id
12804: AND b.BATCH_ID = opt.BATCH_ID;
12805: EXCEPTION WHEN NO_DATA_FOUND THEN
12806: l_import_xref_only := 'N';