APPS.EGO_ITEM_OPEN_INTERFACE_PVT dependencies on EGO_IMPORT_BATCHES_B

Line 27: l_source_system_id EGO_IMPORT_BATCHES_B.source_system_id%TYPE;

23: ,p_commit_flag IN NUMBER := 1
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;

Line 42: FROM ego_import_batches_b batch

38:
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

Line 300: l_source_system_id EGO_IMPORT_BATCHES_B.source_system_id%TYPE;

296: l_pk_item_rev_pairs_dst EGO_COL_NAME_VALUE_PAIR_ARRAY;
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;

Line 310: FROM ego_import_batches_b batch

306: BEGIN
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

Line 612: l_source_system_id EGO_IMPORT_BATCHES_B.source_system_id%TYPE;

608: p_del_rec_flag IN NUMBER := 1)
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

Line 623: ego_import_batches_b batch,

619: BEGIN
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