eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_IMP_015 dependencies on IGS_AD_PS_APPL_INST_INT

Line 435: UPDATE igs_ad_ps_appl_inst_int a

431: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
432: tabname => 'IGS_AD_APL_INT',
433: cascade => TRUE);
434:
435: UPDATE igs_ad_ps_appl_inst_int a
436: SET interface_run_id = p_interface_run_id
437: WHERE interface_appl_id IN (SELECT interface_appl_id
438: FROM igs_ad_apl_int
439: WHERE interface_run_id = p_interface_run_id

Line 445: UPDATE igs_ad_ps_appl_inst_int

441: AND status IN ('1','2','4'));
442:
443: -- If record failed only due to child record failure
444: -- then set status back to 1 and nullify error code/text
445: UPDATE igs_ad_ps_appl_inst_int
446: SET error_code = NULL,
447: error_text = NULL,
448: status = '1'
449: WHERE interface_run_id = p_interface_run_id

Line 455: tabname => 'IGS_AD_PS_APPL_INST_INT',

451: AND status = '4';
452:
453: -- Gather statistics of the table
454: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
455: tabname => 'IGS_AD_PS_APPL_INST_INT',
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

Line 475: FROM igs_ad_ps_appl_inst_int

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)
477: WHERE status IN ('1','2','4')
478: AND interface_ps_appl_inst_id IN (SELECT interface_ps_appl_inst_id
479: FROM igs_ad_ps_appl_inst_int

Line 479: FROM igs_ad_ps_appl_inst_int

475: FROM igs_ad_ps_appl_inst_int
476: WHERE interface_ps_appl_inst_id = a.interface_ps_appl_inst_id)
477: WHERE status IN ('1','2','4')
478: AND interface_ps_appl_inst_id IN (SELECT interface_ps_appl_inst_id
479: FROM igs_ad_ps_appl_inst_int
480: WHERE interface_run_id = p_interface_run_id
481: AND status IN ('1','2','4'));
482:
483: -- Call category entity import procedure

Line 489: UPDATE igs_ad_ps_appl_inst_int a

485: p_enable_log => p_enable_log,
486: p_rule => igs_ad_gen_016.find_source_cat_rule (p_source_type_id, 'APPLICATION'),
487: p_legacy_ind => p_legacy_ind);
488:
489: UPDATE igs_ad_ps_appl_inst_int a
490: SET (person_id,admission_appl_number,admission_application_type)
491: = (SELECT person_id,NVL(admission_appl_number,update_adm_appl_number),admission_application_type
492: FROM igs_ad_apl_int
493: WHERE interface_appl_id = a.interface_appl_id)

Line 529: FROM igs_ad_ps_appl_inst_int

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
530: WHERE interface_ps_appl_inst_id = a.interface_ps_appl_inst_id)
531: WHERE interface_ps_appl_inst_id IN (SELECT interface_ps_appl_inst_id
532: FROM igs_ad_ps_appl_inst_int
533: WHERE interface_run_id = p_interface_run_id

Line 532: FROM igs_ad_ps_appl_inst_int

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
530: WHERE interface_ps_appl_inst_id = a.interface_ps_appl_inst_id)
531: WHERE interface_ps_appl_inst_id IN (SELECT interface_ps_appl_inst_id
532: FROM igs_ad_ps_appl_inst_int
533: WHERE interface_run_id = p_interface_run_id
534: AND status IN ('1','4'));
535:
536: -- Gather statistics of the table

Line 803: FROM igs_ad_ps_appl_inst_int

799: SET interface_run_id = p_interface_run_id,
800: (person_id,admission_appl_number,nominated_course_cd,sequence_number,admission_Application_type)
801: = (SELECT person_id,admission_appl_number,nominated_course_cd,
802: NVL(sequence_number,update_adm_seq_number),admission_Application_type
803: FROM igs_ad_ps_appl_inst_int
804: WHERE interface_ps_appl_inst_id = a.interface_ps_appl_inst_id)
805: WHERE interface_ps_appl_inst_id IN (SELECT interface_ps_appl_inst_id
806: FROM igs_ad_ps_appl_inst_int
807: WHERE interface_run_id = p_interface_run_id

Line 806: FROM igs_ad_ps_appl_inst_int

802: NVL(sequence_number,update_adm_seq_number),admission_Application_type
803: FROM igs_ad_ps_appl_inst_int
804: WHERE interface_ps_appl_inst_id = a.interface_ps_appl_inst_id)
805: WHERE interface_ps_appl_inst_id IN (SELECT interface_ps_appl_inst_id
806: FROM igs_ad_ps_appl_inst_int
807: WHERE interface_run_id = p_interface_run_id
808: AND status IN ('1','4'));
809:
810: -- Gather statistics of the table

Line 837: FROM igs_ad_ps_appl_inst_int

833: UPDATE igs_ad_unitsets_int a
834: SET interface_run_id = p_interface_run_id,
835: (person_id,admission_appl_number,nominated_course_cd,sequence_number,admission_Application_type )
836: = (SELECT person_id,admission_appl_number,nominated_course_cd,NVL(sequence_number,update_adm_seq_number),admission_Application_type
837: FROM igs_ad_ps_appl_inst_int
838: WHERE interface_ps_appl_inst_id = a.interface_ps_appl_inst_id)
839: WHERE interface_ps_appl_inst_id IN (SELECT interface_ps_appl_inst_id
840: FROM igs_ad_ps_appl_inst_int
841: WHERE interface_run_id = p_interface_run_id

Line 840: FROM igs_ad_ps_appl_inst_int

836: = (SELECT person_id,admission_appl_number,nominated_course_cd,NVL(sequence_number,update_adm_seq_number),admission_Application_type
837: FROM igs_ad_ps_appl_inst_int
838: WHERE interface_ps_appl_inst_id = a.interface_ps_appl_inst_id)
839: WHERE interface_ps_appl_inst_id IN (SELECT interface_ps_appl_inst_id
840: FROM igs_ad_ps_appl_inst_int
841: WHERE interface_run_id = p_interface_run_id
842: AND status IN ('1','4'));
843:
844: -- Gather statistics of the table

Line 871: FROM igs_ad_ps_appl_inst_int

867: UPDATE igs_ad_edugoal_int a
868: SET interface_run_id = p_interface_run_id,
869: (person_id,admission_appl_number,nominated_course_cd,sequence_number,admission_Application_type )
870: = (SELECT person_id,admission_appl_number,nominated_course_cd,NVL(sequence_number,update_adm_seq_number),admission_Application_type
871: FROM igs_ad_ps_appl_inst_int
872: WHERE interface_ps_appl_inst_id = a.interface_ps_appl_inst_id)
873: WHERE interface_ps_appl_inst_id IN (SELECT interface_ps_appl_inst_id
874: FROM igs_ad_ps_appl_inst_int
875: WHERE interface_run_id = p_interface_run_id

Line 874: FROM igs_ad_ps_appl_inst_int

870: = (SELECT person_id,admission_appl_number,nominated_course_cd,NVL(sequence_number,update_adm_seq_number),admission_Application_type
871: FROM igs_ad_ps_appl_inst_int
872: WHERE interface_ps_appl_inst_id = a.interface_ps_appl_inst_id)
873: WHERE interface_ps_appl_inst_id IN (SELECT interface_ps_appl_inst_id
874: FROM igs_ad_ps_appl_inst_int
875: WHERE interface_run_id = p_interface_run_id
876: AND status IN ('1','4'));
877:
878: -- Gather statistics of the table

Line 940: l_category_entity_ad_table(14).category_name := 'APPLICATION'; l_category_entity_ad_table(14).entity_name := 'IGS_AD_PS_APPL_INST_INT';

936: l_category_entity_ad_table(10).category_name := 'TRANSCRIPT_DETAILS'; l_category_entity_ad_table(10).entity_name := 'IGS_AD_TXCPT_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';

Line 1040: DELETE FROM igs_ad_ps_appl_inst_int

1036: COMMIT;
1037: END IF; -- g_applicant_edu_goal_inc
1038:
1039: IF g_application_inc THEN
1040: DELETE FROM igs_ad_ps_appl_inst_int
1041: WHERE status = '1'
1042: AND interface_run_id = p_interface_run_id;
1043: COMMIT;
1044: END IF; -- g_application_inc