APPS.IGS_AD_IMP_015 dependencies on IGS_AD_APPHIST_INT

Line 460: UPDATE igs_ad_apphist_int a

456: cascade => TRUE);
457:
458: -- ONLY required to identify presence of history records for which application/instance is being updated
459: -- Populating the application history interface table with the application context value
460: UPDATE igs_ad_apphist_int a
461: SET (person_id,admission_appl_number)
462: = (SELECT person_id,update_adm_appl_number
463: FROM igs_ad_apl_int
464: WHERE interface_appl_id = a.interface_appl_id)

Line 509: UPDATE igs_ad_apphist_int a

505: p_token_value => l_meaning);
506: END IF;
507:
508: -- Populating the interface table with the interface_run_id value
509: UPDATE igs_ad_apphist_int a
510: SET interface_run_id = p_interface_run_id,
511: (person_id,admission_appl_number)
512: = (SELECT person_id,NVL(admission_appl_number,update_adm_appl_number)
513: FROM igs_ad_apl_int

Line 522: tabname => 'IGS_AD_APPHIST_INT',

518: AND status IN ('1','4'));
519:
520: -- Gather statistics of the table
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,

Line 941: l_category_entity_ad_table(15).category_name := 'APPLICANT_HISTORY'; l_category_entity_ad_table(15).entity_name := 'IGS_AD_APPHIST_INT';

937: l_category_entity_ad_table(11).category_name := 'TRANSCRIPT_DETAILS'; l_category_entity_ad_table(11).entity_name := 'IGS_AD_TRMDT_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';

Line 1047: DELETE FROM igs_ad_apphist_int

1043: COMMIT;
1044: END IF; -- g_application_inc
1045:
1046: IF g_applicant_hist_inc THEN
1047: DELETE FROM igs_ad_apphist_int
1048: WHERE status = '1'
1049: AND interface_run_id = p_interface_run_id;
1050: COMMIT;
1051: END IF; -- g_applicant_hist_inc