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_APL_INT

Line 410: UPDATE igs_ad_apl_int a

406: p_token_value => l_meaning);
407: END IF;
408:
409: -- Populating the interface table with the interface_run_id value
410: UPDATE igs_ad_apl_int a
411: SET interface_run_id = p_interface_run_id,
412: person_id = (SELECT person_id
413: FROM igs_ad_interface
414: WHERE interface_id = a.interface_id)

Line 422: UPDATE igs_ad_apl_int

418: AND status IN ('1','4'));
419:
420: -- If record failed only due to child record failure
421: -- then set status back to 1 and nullify error code/text
422: UPDATE igs_ad_apl_int
423: SET error_code = NULL,
424: error_text = NULL,
425: status = '1'
426: WHERE interface_run_id = p_interface_run_id

Line 432: tabname => 'IGS_AD_APL_INT',

428: AND status = '4';
429:
430: -- Gather statistics of the table
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

Line 438: FROM igs_ad_apl_int

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
440: AND update_adm_appl_number IS NULL
441: AND status IN ('1','2','4'));
442:

Line 463: FROM igs_ad_apl_int

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)
465: WHERE status IN ('1','2','4')
466: AND interface_appl_id IN (SELECT interface_appl_id
467: FROM igs_ad_apl_int

Line 467: FROM igs_ad_apl_int

463: FROM igs_ad_apl_int
464: WHERE interface_appl_id = a.interface_appl_id)
465: WHERE status IN ('1','2','4')
466: AND interface_appl_id IN (SELECT interface_appl_id
467: FROM igs_ad_apl_int
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

Line 492: FROM igs_ad_apl_int

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)
494: WHERE status IN ('1','4')
495: AND interface_run_id = p_interface_run_id;
496:

Line 513: FROM igs_ad_apl_int

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
514: WHERE interface_appl_id = a.interface_appl_id)
515: WHERE interface_appl_id IN (SELECT interface_appl_id
516: FROM igs_ad_apl_int
517: WHERE interface_run_id = p_interface_run_id

Line 516: FROM igs_ad_apl_int

512: = (SELECT person_id,NVL(admission_appl_number,update_adm_appl_number)
513: FROM igs_ad_apl_int
514: WHERE interface_appl_id = a.interface_appl_id)
515: WHERE interface_appl_id IN (SELECT interface_appl_id
516: FROM igs_ad_apl_int
517: WHERE interface_run_id = p_interface_run_id
518: AND status IN ('1','4'));
519:
520: -- Gather statistics of the table

Line 566: FROM igs_ad_apl_int

562: UPDATE igs_ad_othinst_int a
563: SET interface_run_id = p_interface_run_id,
564: (person_id,admission_appl_number,admission_Application_type)
565: = (SELECT person_id,NVL(admission_appl_number,update_adm_appl_number), admission_Application_type
566: FROM igs_ad_apl_int
567: WHERE interface_appl_id = a.interface_appl_id)
568: WHERE interface_appl_id IN (SELECT interface_appl_id
569: FROM igs_ad_apl_int
570: WHERE interface_run_id = p_interface_run_id

Line 569: FROM igs_ad_apl_int

565: = (SELECT person_id,NVL(admission_appl_number,update_adm_appl_number), admission_Application_type
566: FROM igs_ad_apl_int
567: WHERE interface_appl_id = a.interface_appl_id)
568: WHERE interface_appl_id IN (SELECT interface_appl_id
569: FROM igs_ad_apl_int
570: WHERE interface_run_id = p_interface_run_id
571: AND status IN ('1','4'));
572:
573: -- Gather statistics of the table

Line 600: FROM igs_ad_apl_int

596: UPDATE igs_ad_acadint_int a
597: SET interface_run_id = p_interface_run_id,
598: (person_id,admission_appl_number, admission_Application_type)
599: = (SELECT person_id,NVL(admission_appl_number,update_adm_appl_number),admission_Application_type
600: FROM igs_ad_apl_int
601: WHERE interface_appl_id = a.interface_appl_id)
602: WHERE interface_appl_id IN (SELECT interface_appl_id
603: FROM igs_ad_apl_int
604: WHERE interface_run_id = p_interface_run_id

Line 603: FROM igs_ad_apl_int

599: = (SELECT person_id,NVL(admission_appl_number,update_adm_appl_number),admission_Application_type
600: FROM igs_ad_apl_int
601: WHERE interface_appl_id = a.interface_appl_id)
602: WHERE interface_appl_id IN (SELECT interface_appl_id
603: FROM igs_ad_apl_int
604: WHERE interface_run_id = p_interface_run_id
605: AND status IN ('1','4'));
606:
607: -- Gather statistics of the table

Line 634: FROM igs_ad_apl_int

630: UPDATE igs_ad_appint_int a
631: SET interface_run_id = p_interface_run_id,
632: (person_id,admission_appl_number,admission_Application_type)
633: = (SELECT person_id,NVL(admission_appl_number,update_adm_appl_number),admission_Application_type
634: FROM igs_ad_apl_int
635: WHERE interface_appl_id = a.interface_appl_id)
636: WHERE interface_appl_id IN (SELECT interface_appl_id
637: FROM igs_ad_apl_int
638: WHERE interface_run_id = p_interface_run_id

Line 637: FROM igs_ad_apl_int

633: = (SELECT person_id,NVL(admission_appl_number,update_adm_appl_number),admission_Application_type
634: FROM igs_ad_apl_int
635: WHERE interface_appl_id = a.interface_appl_id)
636: WHERE interface_appl_id IN (SELECT interface_appl_id
637: FROM igs_ad_apl_int
638: WHERE interface_run_id = p_interface_run_id
639: AND status IN ('1','4'));
640:
641: -- Gather statistics of the table

Line 668: FROM igs_ad_apl_int

664: UPDATE igs_ad_splint_int a
665: SET interface_run_id = p_interface_run_id,
666: (person_id,admission_appl_number,admission_Application_type)
667: = (SELECT person_id,NVL(admission_appl_number,update_adm_appl_number),admission_Application_type
668: FROM igs_ad_apl_int
669: WHERE interface_appl_id = a.interface_appl_id)
670: WHERE interface_appl_id IN (SELECT interface_appl_id
671: FROM igs_ad_apl_int
672: WHERE interface_run_id = p_interface_run_id

Line 671: FROM igs_ad_apl_int

667: = (SELECT person_id,NVL(admission_appl_number,update_adm_appl_number),admission_Application_type
668: FROM igs_ad_apl_int
669: WHERE interface_appl_id = a.interface_appl_id)
670: WHERE interface_appl_id IN (SELECT interface_appl_id
671: FROM igs_ad_apl_int
672: WHERE interface_run_id = p_interface_run_id
673: AND status IN ('1','4'));
674:
675: -- Gather statistics of the table

Line 702: FROM igs_ad_apl_int

698: UPDATE igs_ad_spltal_int a
699: SET interface_run_id = p_interface_run_id,
700: (person_id,admission_appl_number,admission_Application_type)
701: = (SELECT person_id,NVL(admission_appl_number,update_adm_appl_number),admission_Application_type
702: FROM igs_ad_apl_int
703: WHERE interface_appl_id = a.interface_appl_id)
704: WHERE interface_appl_id IN (SELECT interface_appl_id
705: FROM igs_ad_apl_int
706: WHERE interface_run_id = p_interface_run_id

Line 705: FROM igs_ad_apl_int

701: = (SELECT person_id,NVL(admission_appl_number,update_adm_appl_number),admission_Application_type
702: FROM igs_ad_apl_int
703: WHERE interface_appl_id = a.interface_appl_id)
704: WHERE interface_appl_id IN (SELECT interface_appl_id
705: FROM igs_ad_apl_int
706: WHERE interface_run_id = p_interface_run_id
707: AND status IN ('1','4'));
708:
709: -- Gather statistics of the table

Line 736: FROM igs_ad_apl_int

732: UPDATE igs_ad_perstmt_int a
733: SET interface_run_id = p_interface_run_id,
734: (person_id,admission_appl_number)
735: = (SELECT person_id,NVL(admission_appl_number,update_adm_appl_number)
736: FROM igs_ad_apl_int
737: WHERE interface_appl_id = a.interface_appl_id)
738: WHERE interface_appl_id IN (SELECT interface_appl_id
739: FROM igs_ad_apl_int
740: WHERE interface_run_id = p_interface_run_id

Line 739: FROM igs_ad_apl_int

735: = (SELECT person_id,NVL(admission_appl_number,update_adm_appl_number)
736: FROM igs_ad_apl_int
737: WHERE interface_appl_id = a.interface_appl_id)
738: WHERE interface_appl_id IN (SELECT interface_appl_id
739: FROM igs_ad_apl_int
740: WHERE interface_run_id = p_interface_run_id
741: AND status IN ('1','4'));
742:
743: -- Gather statistics of the table

Line 769: FROM igs_ad_apl_int

765: UPDATE igs_ad_fee_int a
766: SET interface_run_id = p_interface_run_id,
767: (person_id,admission_appl_number)
768: = (SELECT person_id,NVL(admission_appl_number,update_adm_appl_number)
769: FROM igs_ad_apl_int
770: WHERE interface_appl_id = a.interface_appl_id)
771: WHERE interface_appl_id IN (SELECT interface_appl_id
772: FROM igs_ad_apl_int
773: WHERE interface_run_id = p_interface_run_id

Line 772: FROM igs_ad_apl_int

768: = (SELECT person_id,NVL(admission_appl_number,update_adm_appl_number)
769: FROM igs_ad_apl_int
770: WHERE interface_appl_id = a.interface_appl_id)
771: WHERE interface_appl_id IN (SELECT interface_appl_id
772: FROM igs_ad_apl_int
773: WHERE interface_run_id = p_interface_run_id
774: AND status IN ('1','4'));
775:
776: -- Gather statistics of the table

Line 939: l_category_entity_ad_table(13).category_name := 'APPLICATION'; l_category_entity_ad_table(13).entity_name := 'IGS_AD_APL_INT';

935: l_category_entity_ad_table(09).category_name := 'TEST_RESULTS'; l_category_entity_ad_table(09).entity_name := 'IGS_AD_TEST_SEGS_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';

Line 1103: DELETE FROM igs_ad_apl_int

1099: COMMIT;
1100: END IF; -- g_applicant_fee_dtls_inc
1101:
1102: IF g_application_inc THEN
1103: DELETE FROM igs_ad_apl_int
1104: WHERE status = '1'
1105: AND interface_run_id = p_interface_run_id;
1106: COMMIT;
1107: END IF; -- g_application_inc