APPS.EGO_ITEM_OPEN_INTERFACE_PVT dependencies on EGO_IMPORT_OPTION_SETS

Line 28: l_import_xref_only EGO_IMPORT_OPTION_SETS.import_xref_only%TYPE;

24: ,p_default_flag IN NUMBER DEFAULT 1) IS
25:
26: l_retcode VARCHAR2(100);
27: l_source_system_id EGO_IMPORT_BATCHES_B.source_system_id%TYPE;
28: l_import_xref_only EGO_IMPORT_OPTION_SETS.import_xref_only%TYPE;
29: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
30: l_request_id NUMBER;
31: l_pro_flag_3 NUMBER;
32: l_enabled_for_data_pool VARCHAR2(1);

Line 43: ,ego_import_option_sets opt

39: BEGIN
40: SELECT batch.source_system_id, NVL(opt.import_xref_only,'N'), NVL(opt.ENABLED_FOR_DATA_POOL, 'N')
41: INTO l_source_system_id, l_import_xref_only, l_enabled_for_data_pool
42: FROM ego_import_batches_b batch
43: ,ego_import_option_sets opt
44: WHERE batch.batch_id = p_xset_id
45: AND batch.batch_id = opt.batch_id;
46: EXCEPTION
47: WHEN OTHERS THEN

Line 301: l_import_xref_only EGO_IMPORT_OPTION_SETS.import_xref_only%TYPE;

297:
298: l_temp_message VARCHAR2(2000);
299: l_retcode VARCHAR2(100);
300: l_source_system_id EGO_IMPORT_BATCHES_B.source_system_id%TYPE;
301: l_import_xref_only EGO_IMPORT_OPTION_SETS.import_xref_only%TYPE;
302: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
303: err_msg VARCHAR2(300); --Bug: 5473796
304: l_batch_id NUMBER := p_xset_id;
305: l_enabled_for_data_pool VARCHAR2(1);

Line 311: ,ego_import_option_sets opt

307: BEGIN
308: SELECT batch.source_system_id, NVL(opt.import_xref_only,'N'), NVL(opt.ENABLED_FOR_DATA_POOL,'N')
309: INTO l_source_system_id, l_import_xref_only, l_enabled_for_data_pool
310: FROM ego_import_batches_b batch
311: ,ego_import_option_sets opt
312: WHERE batch.batch_id = p_xset_id
313: AND batch.batch_id = opt.batch_id;
314: EXCEPTION
315: WHEN OTHERS THEN

Line 613: l_import_xref_only EGO_IMPORT_OPTION_SETS.import_xref_only%TYPE;

609: IS
610: l_retcode VARCHAR2(100);
611: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level;
612: l_source_system_id EGO_IMPORT_BATCHES_B.source_system_id%TYPE;
613: l_import_xref_only EGO_IMPORT_OPTION_SETS.import_xref_only%TYPE;
614: l_enabled_for_data_pool VARCHAR2(1);
615: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
616: err_msg VARCHAR2(300); --Bug: 5473796
617: l_temp_message VARCHAR2(2000);

Line 624: ego_import_option_sets opt

620: SELECT batch.source_system_id, NVL(opt.import_xref_only,'N'), NVL(opt.ENABLED_FOR_DATA_POOL,'N')
621: INTO l_source_system_id, l_import_xref_only, l_enabled_for_data_pool
622: FROM
623: ego_import_batches_b batch,
624: ego_import_option_sets opt
625: WHERE batch.batch_id = p_batch_id
626: AND batch.batch_id = opt.batch_id;
627: EXCEPTION
628: WHEN OTHERS THEN