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.

[Home] [Help]

APPS.EGO_IMPORT_PVT dependencies on EGO_IMPORT_OPTION_SETS

Line 5748: l_import_xref_only EGO_IMPORT_OPTION_SETS.IMPORT_XREF_ONLY%TYPE;

5744: l_msg_text VARCHAR2(4000);
5745: dumm_status NUMBER;
5746: l_org_id NUMBER;
5747:
5748: l_import_xref_only EGO_IMPORT_OPTION_SETS.IMPORT_XREF_ONLY%TYPE;
5749: l_inventory_item_id MTL_SYSTEM_ITEMS_INTERFACE.INVENTORY_ITEM_ID%TYPE;
5750: l_transaction_id MTL_SYSTEM_ITEMS_INTERFACE.TRANSACTION_ID%TYPE;
5751: BEGIN
5752: Debug_Conc_Log('Starting Process_SSXref_Intf_Rows for batch_id='||TO_CHAR(p_data_set_id));

Line 5756: FROM EGO_IMPORT_BATCHES_B b, EGO_IMPORT_OPTION_SETS opt

5752: Debug_Conc_Log('Starting Process_SSXref_Intf_Rows for batch_id='||TO_CHAR(p_data_set_id));
5753: BEGIN
5754: SELECT b.SOURCE_SYSTEM_ID, NVL(opt.IMPORT_XREF_ONLY, 'N')
5755: INTO l_ss_id, l_import_xref_only
5756: FROM EGO_IMPORT_BATCHES_B b, EGO_IMPORT_OPTION_SETS opt
5757: WHERE b.BATCH_ID = p_data_set_id
5758: AND b.BATCH_ID = opt.BATCH_ID;
5759: EXCEPTION WHEN NO_DATA_FOUND THEN
5760: l_ss_id := get_pdh_source_system_id;

Line 6093: , p_instance_rev_policy IN EGO_IMPORT_OPTION_SETS.REVISION_IMPORT_POLICY%TYPE

6089: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
6090: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
6091: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
6092: , p_organization_code IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_CODE%TYPE
6093: , p_instance_rev_policy IN EGO_IMPORT_OPTION_SETS.REVISION_IMPORT_POLICY%TYPE
6094: )
6095: RETURN BOOLEAN IS
6096: l_temp VARCHAR2(1);
6097: BEGIN

Line 6153: FROM EGO_IMPORT_OPTION_SETS

6149:
6150: BEGIN
6151: -- See if the batch is GDSN Enabled
6152: SELECT NVL(ENABLED_FOR_DATA_POOL, 'N') INTO l_is_batch_GDSN_enabled
6153: FROM EGO_IMPORT_OPTION_SETS
6154: WHERE BATCH_ID = p_data_set_id;
6155:
6156: IF l_is_batch_GDSN_enabled = 'Y' AND p_bundle_id IS NOT NULL THEN
6157: FOR rec in item_group_cr LOOP

Line 6201: l_batch_rev_policy EGO_IMPORT_OPTION_SETS.REVISION_IMPORT_POLICY%TYPE;

6197: l_item_num_gen MTL_ITEM_CATALOG_GROUPS_B.ITEM_NUM_GEN_METHOD%TYPE;
6198: l_item_desc_gen MTL_ITEM_CATALOG_GROUPS_B.ITEM_DESC_GEN_METHOD%TYPE;
6199: l_organization_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE;
6200: l_organization_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
6201: l_batch_rev_policy EGO_IMPORT_OPTION_SETS.REVISION_IMPORT_POLICY%TYPE;
6202: l_instance_rev_policy MTL_SYSTEM_ITEMS_INTERFACE.REVISION_IMPORT_POLICY%TYPE;
6203: l_style_item_flag MTL_SYSTEM_ITEMS_INTERFACE.STYLE_ITEM_FLAG%TYPE;
6204: BEGIN
6205: SELECT

Line 6212: EGO_IMPORT_OPTION_SETS OPT

6208: NVL(OPT.REVISION_IMPORT_POLICY, 'L')
6209: INTO l_organization_id, l_organization_code, l_batch_rev_policy
6210: FROM MTL_PARAMETERS MP,
6211: EGO_IMPORT_BATCHES_B ba,
6212: EGO_IMPORT_OPTION_SETS OPT
6213: WHERE BA.ORGANIZATION_ID = MP.ORGANIZATION_ID AND
6214: BA.BATCH_ID = OPT.BATCH_ID AND
6215: BA.BATCH_ID = p_data_set_id;
6216:

Line 6495: l_import_xref_only EGO_IMPORT_OPTION_SETS.IMPORT_XREF_ONLY%TYPE;

6491: IS
6492: l_org_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE;
6493: l_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
6494: l_ss_id EGO_IMPORT_BATCHES_B.SOURCE_SYSTEM_id%TYPE;
6495: l_import_xref_only EGO_IMPORT_OPTION_SETS.IMPORT_XREF_ONLY%TYPE;
6496: l_party_name VARCHAR2(1000);
6497: l_security_predicate VARCHAR2(4000);
6498: l_return_status VARCHAR2(100);
6499: l_sql VARCHAR2(32000);

Line 6503: l_enabled_for_data_pool EGO_IMPORT_OPTION_SETS.ENABLED_FOR_DATA_POOL%TYPE;

6499: l_sql VARCHAR2(32000);
6500:
6501: l_insert_date DATE;
6502: l_org VARCHAR2(100);
6503: l_enabled_for_data_pool EGO_IMPORT_OPTION_SETS.ENABLED_FOR_DATA_POOL%TYPE;
6504: BEGIN
6505: Debug_Conc_Log( 'Resolve_SSXref_on_Data_load - Entering' );
6506:
6507: Debug_Conc_Log( 'Resolve_SSXref_on_Data_load - Gather Statistics' );

Line 6523: EGO_IMPORT_OPTION_SETS OPT

6519: NVL(ENABLED_FOR_DATA_POOL, 'N')
6520: INTO l_org_id, l_org_code, l_ss_id, l_import_xref_only, l_enabled_for_data_pool
6521: FROM MTL_PARAMETERS MP,
6522: EGO_IMPORT_BATCHES_B BA,
6523: EGO_IMPORT_OPTION_SETS OPT
6524: WHERE BA.ORGANIZATION_ID = MP.ORGANIZATION_ID
6525: AND BA.BATCH_ID = p_data_set_id
6526: AND BA.BATCH_ID = OPT.BATCH_ID;
6527: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 8025: l_import_policy EGO_IMPORT_OPTION_SETS.REVISION_IMPORT_POLICY%TYPE;

8021: l_org_id EGO_IMPORT_BATCHES_B.ORGANIZATION_ID%TYPE;
8022: l_item_id NUMBER;
8023: l_revision MTL_ITEM_REVISIONS_B.REVISION%TYPE;
8024: l_error BOOLEAN;
8025: l_import_policy EGO_IMPORT_OPTION_SETS.REVISION_IMPORT_POLICY%TYPE;
8026:
8027: l_import_xref_only EGO_IMPORT_OPTION_SETS.IMPORT_XREF_ONLY%TYPE;
8028: l_party_name VARCHAR2(1000);
8029: l_security_predicate VARCHAR2(4000);

Line 8027: l_import_xref_only EGO_IMPORT_OPTION_SETS.IMPORT_XREF_ONLY%TYPE;

8023: l_revision MTL_ITEM_REVISIONS_B.REVISION%TYPE;
8024: l_error BOOLEAN;
8025: l_import_policy EGO_IMPORT_OPTION_SETS.REVISION_IMPORT_POLICY%TYPE;
8026:
8027: l_import_xref_only EGO_IMPORT_OPTION_SETS.IMPORT_XREF_ONLY%TYPE;
8028: l_party_name VARCHAR2(1000);
8029: l_security_predicate VARCHAR2(4000);
8030: l_return_status VARCHAR2(100);
8031: l_sql VARCHAR2(32000);

Line 8032: l_enabled_for_data_pool EGO_IMPORT_OPTION_SETS.ENABLED_FOR_DATA_POOL%TYPE;

8028: l_party_name VARCHAR2(1000);
8029: l_security_predicate VARCHAR2(4000);
8030: l_return_status VARCHAR2(100);
8031: l_sql VARCHAR2(32000);
8032: l_enabled_for_data_pool EGO_IMPORT_OPTION_SETS.ENABLED_FOR_DATA_POOL%TYPE;
8033: l_org VARCHAR2(100);
8034: BEGIN
8035: -- get the source_system_id for this batch
8036: Debug_Conc_Log( 'Resolve_Child_Entities START' );

Line 8045: FROM EGO_IMPORT_BATCHES_B BA, EGO_IMPORT_OPTION_SETS OPT

8041: NVL(OPT.REVISION_IMPORT_POLICY, 'L'),
8042: NVL(opt.IMPORT_XREF_ONLY, 'N'),
8043: NVL(opt.ENABLED_FOR_DATA_POOL, 'N')
8044: INTO l_ss_id, l_org_id, l_import_policy, l_import_xref_only, l_enabled_for_data_pool
8045: FROM EGO_IMPORT_BATCHES_B BA, EGO_IMPORT_OPTION_SETS OPT
8046: WHERE BA.BATCH_ID = p_data_set_id AND BA.BATCH_ID = OPT.BATCH_ID;
8047: EXCEPTION WHEN NO_DATA_FOUND THEN
8048: l_org := fnd_profile.value('EGO_USER_ORGANIZATION_CONTEXT');
8049: BEGIN

Line 9526: l_ssxref_only EGO_IMPORT_OPTION_SETS.IMPORT_XREF_ONLY%TYPE;

9522: l_request_id MTL_SYSTEM_ITEMS_INTERFACE.REQUEST_ID%TYPE;
9523: l_org_id MTL_SYSTEM_ITEMS_INTERFACE.ORGANIZATION_ID%TYPE;
9524: l_item_number MTL_SYSTEM_ITEMS_INTERFACE.ITEM_NUMBER%TYPE;
9525: l_item_id MTL_SYSTEM_ITEMS_INTERFACE.INVENTORY_ITEM_ID%TYPE;
9526: l_ssxref_only EGO_IMPORT_OPTION_SETS.IMPORT_XREF_ONLY%TYPE;
9527:
9528: l_is_pdh_batch BOOLEAN;
9529: l_is_reimport BOOLEAN;
9530: l_is_ssxref_only BOOLEAN;

Line 9548: FROM EGO_IMPORT_BATCHES_B BATCH, EGO_IMPORT_OPTION_SETS OPT

9544: , NVL( OPT.IMPORT_XREF_ONLY, 'N' )
9545: INTO l_batch_ss_id
9546: , l_org_id
9547: , l_ssxref_only
9548: FROM EGO_IMPORT_BATCHES_B BATCH, EGO_IMPORT_OPTION_SETS OPT
9549: WHERE BATCH.BATCH_ID = p_batch_id
9550: AND BATCH.ORGANIZATION_ID = p_organization_id
9551: AND BATCH.BATCH_ID = OPT.BATCH_ID;
9552: EXCEPTION

Line 12456: FROM EGO_IMPORT_OPTION_SETS

12452:
12453: BEGIN
12454: SELECT NVL(ADD_ALL_TO_CHANGE_FLAG,'N')
12455: INTO l_add_all_change_flag
12456: FROM EGO_IMPORT_OPTION_SETS
12457: WHERE BATCH_ID = p_batch_id;
12458: RETURN l_add_all_change_flag;
12459: EXCEPTION
12460: WHEN OTHERS THEN

Line 12922: FROM EGO_IMPORT_BATCHES_B b, EGO_IMPORT_OPTION_SETS opt

12918:
12919: -- Bug: 5262421, if IMPORT_XREF_ONLY is 'Y', then we will show 0 as after import count for AML
12920: BEGIN
12921: SELECT NVL(opt.IMPORT_XREF_ONLY, 'N') INTO l_import_xref_only
12922: FROM EGO_IMPORT_BATCHES_B b, EGO_IMPORT_OPTION_SETS opt
12923: WHERE b.BATCH_ID = p_set_process_id
12924: AND b.BATCH_ID = opt.BATCH_ID;
12925: EXCEPTION WHEN NO_DATA_FOUND THEN
12926: l_import_xref_only := 'N';