APPS.IGS_AD_IMP_015 dependencies on IGS_AD_INSTHIST_INT

Line 472: UPDATE igs_ad_insthist_int a

468: WHERE interface_run_id = p_interface_run_id
469: AND status IN ('1','2','4'));
470:
471: -- Populating the application instance history interface table with the application instance context value
472: UPDATE igs_ad_insthist_int a
473: SET (person_id,admission_appl_number,nominated_course_cd,sequence_number)
474: = (SELECT person_id,admission_appl_number,nominated_course_cd,update_adm_seq_number
475: FROM igs_ad_ps_appl_inst_int
476: WHERE interface_ps_appl_inst_id = a.interface_ps_appl_inst_id)

Line 525: UPDATE igs_ad_insthist_int a

521: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
522: tabname => 'IGS_AD_APPHIST_INT',
523: cascade => TRUE);
524:
525: UPDATE igs_ad_insthist_int a
526: SET interface_run_id = p_interface_run_id,
527: (person_id,admission_appl_number,nominated_course_cd,sequence_number)
528: = (SELECT person_id,admission_appl_number,nominated_course_cd,NVL(sequence_number,update_adm_seq_number)
529: FROM igs_ad_ps_appl_inst_int

Line 538: tabname => 'IGS_AD_INSTHIST_INT',

534: AND status IN ('1','4'));
535:
536: -- Gather statistics of the table
537: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
538: tabname => 'IGS_AD_INSTHIST_INT',
539: cascade => TRUE);
540:
541: -- Call category entity import procedure
542: igs_ad_imp_027.prc_appl_hist (p_interface_run_id => p_interface_run_id,

Line 942: l_category_entity_ad_table(16).category_name := 'APPLICANT_HISTORY'; l_category_entity_ad_table(16).entity_name := 'IGS_AD_INSTHIST_INT';

938: l_category_entity_ad_table(12).category_name := 'TRANSCRIPT_DETAILS'; l_category_entity_ad_table(12).entity_name := 'IGS_AD_TUNDT_INT';
939: l_category_entity_ad_table(13).category_name := 'APPLICATION'; l_category_entity_ad_table(13).entity_name := 'IGS_AD_APL_INT';
940: l_category_entity_ad_table(14).category_name := 'APPLICATION'; l_category_entity_ad_table(14).entity_name := 'IGS_AD_PS_APPL_INST_INT';
941: l_category_entity_ad_table(15).category_name := 'APPLICANT_HISTORY'; l_category_entity_ad_table(15).entity_name := 'IGS_AD_APPHIST_INT';
942: l_category_entity_ad_table(16).category_name := 'APPLICANT_HISTORY'; l_category_entity_ad_table(16).entity_name := 'IGS_AD_INSTHIST_INT';
943: l_category_entity_ad_table(17).category_name := 'APPLICANT_OTHERINSTS_APPLIED'; l_category_entity_ad_table(17).entity_name := 'IGS_AD_OTHINST_INT';
944: l_category_entity_ad_table(18).category_name := 'APPLICANT_ACADEMIC_INTERESTS'; l_category_entity_ad_table(18).entity_name := 'IGS_AD_ACADINT_INT';
945: l_category_entity_ad_table(19).category_name := 'APPLICANT_INTENT'; l_category_entity_ad_table(19).entity_name := 'IGS_AD_APPINT_INT';
946: l_category_entity_ad_table(20).category_name := 'APPLICANT_SPECIAL_INTERESTS'; l_category_entity_ad_table(20).entity_name := 'IGS_AD_SPLINT_INT';

Line 1012: DELETE FROM igs_ad_insthist_int

1008: TO_CHAR(l_request_id));
1009: END IF;
1010:
1011: IF g_applicant_hist_inc THEN
1012: DELETE FROM igs_ad_insthist_int
1013: WHERE status = '1'
1014: AND interface_run_id = p_interface_run_id;
1015: COMMIT;
1016: END IF; -- g_applicant_hist_inc