APPS.EGO_IMPORT_BATCHES_PKG dependencies on EGO_IMPORT_OPTION_SETS

Line 426: from EGO_IMPORT_OPTION_SETS

422: AND SSM.ORIG_SYSTEM = v_source_system_code;
423:
424: Cursor Ego_Ssm_Options_Csr(v_source_system_id IN NUMBER) IS
425: select *
426: from EGO_IMPORT_OPTION_SETS
427: WHERE SOURCE_SYSTEM_ID = v_source_system_id
428: AND BATCH_ID IS NULL;
429:
430: Cursor Ego_Ssm_Assignee_Csr(v_user_name in VARCHAR2) IS

Line 604: l_tmp_ssm_options_rec EGO_IMPORT_OPTION_SETS%ROWTYPE;

600: l_enabled_for_data_pool VARCHAR2(1) := p_enabled_for_data_pool;
601:
602: --l_tmp_import_batch_rec EGO_IMPORT_BATCHES_B%ROWTYPE;
603: l_tmp_batch_type_name VARCHAR2(30);
604: l_tmp_ssm_options_rec EGO_IMPORT_OPTION_SETS%ROWTYPE;
605: l_def_match_rule_rec Ego_Def_Match_Rule_Csr%ROWTYPE;
606:
607: l_tmp_change_order_type_id NUMBER;
608: l_tmp_change_notice VARCHAR2(10);

Line 687: select EGO_IMPORT_OPTION_SETS_S.nextval INTO l_option_set_id FROM dual;

683: END IF;
684:
685: -- 2. Generate Batch Option Set ID & Batch Id.
686: SELECT MTL_SYSTEM_ITEMS_INTF_SETS_S.nextval INTO l_batch_id FROM dual;
687: select EGO_IMPORT_OPTION_SETS_S.nextval INTO l_option_set_id FROM dual;
688:
689: -------------------------------------------------------
690: --- Initializing Input Params ---
691: -------------------------------------------------------

Line 948: INSERT INTO EGO_IMPORT_OPTION_SETS

944: X_LAST_UPDATE_DATE => sysdate,
945: X_LAST_UPDATED_BY => fnd_global.user_id,
946: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
947:
948: INSERT INTO EGO_IMPORT_OPTION_SETS
949: (OPTION_SET_ID,
950: SOURCE_SYSTEM_ID,
951: BATCH_ID,
952: MATCH_ON_DATA_LOAD,