[Home] [Help]
204: p_token_value => l_meaning);
205: END IF;
206:
207: -- Populating the interface table with the interface_run_id value
208: UPDATE igs_ad_recruit_int a
209: SET interface_run_id = p_interface_run_id,
210: person_id = (SELECT person_id
211: FROM igs_ad_interface
212: WHERE interface_id = a.interface_id)
216: AND status IN ('1','4'));
217:
218: -- Gather statistics of the table
219: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
220: tabname => 'IGS_AD_RECRUIT_INT',
221: cascade => TRUE);
222:
223: -- Call category entity import procedure
224: igs_ad_imp_014.prc_pe_recruitments_dtl (p_interface_run_id => p_interface_run_id,
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';
932: l_category_entity_ad_table(06).category_name := 'INQUIRY_INFORMATION_TYPES'; l_category_entity_ad_table(06).entity_name := 'IGR_I_INFO_INT';
1148: END;
1149: END IF;
1150:
1151: IF g_person_recruit_dtls_inc THEN
1152: DELETE FROM igs_ad_recruit_int
1153: WHERE status = '1'
1154: AND interface_run_id = p_interface_run_id;
1155: COMMIT;
1156: END IF; -- g_person_recruit_dtls_inc