APPS.IGS_AD_IMP_015 dependencies on IGS_UC_QUAL_INTS

Line 176: UPDATE igs_uc_qual_ints a

172: p_token_value => l_meaning);
173: END IF;
174:
175: -- Populating the interface table with the interface_run_id value
176: UPDATE igs_uc_qual_ints a
177: SET interface_run_id = p_interface_run_id,
178: person_id = (SELECT person_id
179: FROM igs_ad_interface
180: WHERE interface_id = a.interface_id)

Line 188: tabname => 'IGS_UC_QUAL_INTS',

184: AND status IN ('1','4'));
185:
186: -- Gather statistics of the table
187: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
188: tabname => 'IGS_UC_QUAL_INTS',
189: cascade => TRUE);
190:
191: -- Call category entity import procedure
192: igs_ad_imp_028.prc_pe_qual_details (p_interface_run_id => p_interface_run_id,

Line 927: l_category_entity_ad_table(01).category_name := 'PERSON_QUAL'; l_category_entity_ad_table(01).entity_name := 'IGS_UC_QUAL_INTS';

923:
924: BEGIN
925:
926: -- Define category - entity mapping
927: l_category_entity_ad_table(01).category_name := 'PERSON_QUAL'; l_category_entity_ad_table(01).entity_name := 'IGS_UC_QUAL_INTS';
928: l_category_entity_ad_table(02).category_name := 'PERSON_RECRUITMENT_DETAILS'; l_category_entity_ad_table(02).entity_name := 'IGS_AD_RECRUIT_INT';
929: l_category_entity_ad_table(03).category_name := 'INQUIRY_DETAILS'; l_category_entity_ad_table(03).entity_name := 'IGR_I_APPL_INT';
930: l_category_entity_ad_table(04).category_name := 'INQUIRY_ACADEMIC_INTEREST'; l_category_entity_ad_table(04).entity_name := 'IGR_I_LINES_INT';
931: l_category_entity_ad_table(05).category_name := 'INQUIRY_PACKAGE_ITEMS'; l_category_entity_ad_table(05).entity_name := 'IGR_I_PKG_INT';

Line 1159: DELETE FROM igs_uc_qual_ints

1155: COMMIT;
1156: END IF; -- g_person_recruit_dtls_inc
1157:
1158: IF g_person_qual_inc THEN
1159: DELETE FROM igs_uc_qual_ints
1160: WHERE status = '1'
1161: AND interface_run_id = p_interface_run_id;
1162: COMMIT;
1163: END IF; -- g_person_qual_inc