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.

[Home] [Help]

APPS.IGS_AD_TI_COMP dependencies on IGS_AD_APPL

Line 210: FROM igs_ad_appl_perstat aaps,

206: p_tracking_id IN igs_tr_step.tracking_id%TYPE,
207: p_tracking_step_id IN igs_tr_step.tracking_step_id%TYPE
208: ) IS
209: SELECT DISTINCT 1
210: FROM igs_ad_appl_perstat aaps,
211: igs_ad_per_stm_typ apst,
212: igs_tr_step ts
213: WHERE ts.tracking_id = p_tracking_id
214: AND ts.tracking_step_id = p_tracking_step_id

Line 685: p_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,

681:
682:
683:
684: CURSOR cur_appl_details( p_person_id igs_ad_ps_appl_inst.person_id%TYPE,
685: p_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
686: p_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
687: p_acad_ci_sequence_number igs_ad_appl.acad_ci_sequence_number%TYPE,
688: p_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE,
689: p_admission_cat igs_ad_appl.admission_cat%TYPE,

Line 686: p_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,

682:
683:
684: CURSOR cur_appl_details( p_person_id igs_ad_ps_appl_inst.person_id%TYPE,
685: p_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
686: p_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
687: p_acad_ci_sequence_number igs_ad_appl.acad_ci_sequence_number%TYPE,
688: p_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE,
689: p_admission_cat igs_ad_appl.admission_cat%TYPE,
690: p_s_admission_process_type igs_ad_appl.s_admission_process_type%TYPE ,

Line 687: p_acad_ci_sequence_number igs_ad_appl.acad_ci_sequence_number%TYPE,

683:
684: CURSOR cur_appl_details( p_person_id igs_ad_ps_appl_inst.person_id%TYPE,
685: p_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
686: p_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
687: p_acad_ci_sequence_number igs_ad_appl.acad_ci_sequence_number%TYPE,
688: p_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE,
689: p_admission_cat igs_ad_appl.admission_cat%TYPE,
690: p_s_admission_process_type igs_ad_appl.s_admission_process_type%TYPE ,
691: p_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE ,

Line 688: p_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE,

684: CURSOR cur_appl_details( p_person_id igs_ad_ps_appl_inst.person_id%TYPE,
685: p_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
686: p_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
687: p_acad_ci_sequence_number igs_ad_appl.acad_ci_sequence_number%TYPE,
688: p_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE,
689: p_admission_cat igs_ad_appl.admission_cat%TYPE,
690: p_s_admission_process_type igs_ad_appl.s_admission_process_type%TYPE ,
691: p_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE ,
692: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE )IS

Line 689: p_admission_cat igs_ad_appl.admission_cat%TYPE,

685: p_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
686: p_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
687: p_acad_ci_sequence_number igs_ad_appl.acad_ci_sequence_number%TYPE,
688: p_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE,
689: p_admission_cat igs_ad_appl.admission_cat%TYPE,
690: p_s_admission_process_type igs_ad_appl.s_admission_process_type%TYPE ,
691: p_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE ,
692: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE )IS
693:

Line 690: p_s_admission_process_type igs_ad_appl.s_admission_process_type%TYPE ,

686: p_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
687: p_acad_ci_sequence_number igs_ad_appl.acad_ci_sequence_number%TYPE,
688: p_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE,
689: p_admission_cat igs_ad_appl.admission_cat%TYPE,
690: p_s_admission_process_type igs_ad_appl.s_admission_process_type%TYPE ,
691: p_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE ,
692: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE )IS
693:
694: SELECT

Line 703: igs_ad_appl aa

699: FROM
700: igs_ad_ps_appl_inst apai,
701: igs_ad_ou_stat aos,
702: igs_ad_doc_stat ads,
703: igs_ad_appl aa
704: WHERE
705: apai.person_id = nvl(p_person_id,apai.person_id) AND
706: aa.acad_cal_type = nvl(p_acad_cal_type,aa.acad_cal_type) AND
707: aa.acad_ci_sequence_number = nvl(p_acad_ci_sequence_number,aa.acad_ci_sequence_number) AND

Line 744: l_admission_cat igs_ad_appl_all.admission_cat%TYPE;

740: l_acad_cal_type igs_ca_inst_all.cal_type%TYPE;
741: l_acad_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
742: l_adm_cal_type igs_ca_inst_all.cal_type%TYPE;
743: l_adm_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
744: l_admission_cat igs_ad_appl_all.admission_cat%TYPE;
745: l_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE;
746: l_count NUMBER;
747: l_records_not_found BOOLEAN := TRUE;
748:

Line 745: l_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE;

741: l_acad_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
742: l_adm_cal_type igs_ca_inst_all.cal_type%TYPE;
743: l_adm_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
744: l_admission_cat igs_ad_appl_all.admission_cat%TYPE;
745: l_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE;
746: l_count NUMBER;
747: l_records_not_found BOOLEAN := TRUE;
748:
749: lv_group_type IGS_PE_PERSID_GROUP_V.group_type%TYPE;

Line 864: igs_ad_appl aa

860: FROM
861: igs_ad_ps_appl_inst apai,
862: igs_ad_ou_stat aos,
863: igs_ad_doc_stat ads ,
864: igs_ad_appl aa
865: WHERE
866: apai.person_id IN ( '||lv_sql_stmt||') AND
867: aos.s_adm_outcome_status = ''PENDING'' AND
868: apai.adm_outcome_status = aos.adm_outcome_status AND

Line 909: igs_ad_appl aa

905: FROM
906: igs_ad_ps_appl_inst apai,
907: igs_ad_ou_stat aos,
908: igs_ad_doc_stat ads ,
909: igs_ad_appl aa
910: WHERE
911: apai.person_id IN ( '||lv_sql_stmt||') AND
912: aos.s_adm_outcome_status = ''PENDING'' AND
913: apai.adm_outcome_status = aos.adm_outcome_status AND