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 41: ,ego_import_option_sets opt

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

Line 248: l_import_xref_only EGO_IMPORT_OPTION_SETS.import_xref_only%TYPE;

244:
245: l_temp_message VARCHAR2(2000);
246: l_retcode VARCHAR2(100);
247: l_source_system_id EGO_IMPORT_BATCHES_B.source_system_id%TYPE;
248: l_import_xref_only EGO_IMPORT_OPTION_SETS.import_xref_only%TYPE;
249: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
250: err_msg VARCHAR2(300); --Bug: 5473796
251: l_batch_id NUMBER := p_xset_id;
252: l_enabled_for_data_pool VARCHAR2(1);

Line 258: ,ego_import_option_sets opt

254: BEGIN
255: SELECT batch.source_system_id, NVL(opt.import_xref_only,'N'), NVL(opt.ENABLED_FOR_DATA_POOL,'N')
256: INTO l_source_system_id, l_import_xref_only, l_enabled_for_data_pool
257: FROM ego_import_batches_b batch
258: ,ego_import_option_sets opt
259: WHERE batch.batch_id = p_xset_id
260: AND batch.batch_id = opt.batch_id;
261: EXCEPTION
262: WHEN OTHERS THEN

Line 553: l_import_xref_only EGO_IMPORT_OPTION_SETS.import_xref_only%TYPE;

549: IS
550: l_retcode VARCHAR2(100);
551: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level;
552: l_source_system_id EGO_IMPORT_BATCHES_B.source_system_id%TYPE;
553: l_import_xref_only EGO_IMPORT_OPTION_SETS.import_xref_only%TYPE;
554: l_enabled_for_data_pool VARCHAR2(1);
555: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
556: err_msg VARCHAR2(300); --Bug: 5473796
557: l_temp_message VARCHAR2(2000);

Line 564: ego_import_option_sets opt

560: SELECT batch.source_system_id, NVL(opt.import_xref_only,'N'), NVL(opt.ENABLED_FOR_DATA_POOL,'N')
561: INTO l_source_system_id, l_import_xref_only, l_enabled_for_data_pool
562: FROM
563: ego_import_batches_b batch,
564: ego_import_option_sets opt
565: WHERE batch.batch_id = p_batch_id
566: AND batch.batch_id = opt.batch_id;
567: EXCEPTION
568: WHEN OTHERS THEN