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_GEN_011 dependencies on IGS_AD_APPL_LTR

Line 779: p_person_id IN igs_ad_appl_ltr.person_id%TYPE,

775: CURSOR c_igs_co_ou_co_ref_seq_num_s IS
776: SELECT igs_co_ou_co_ref_seq_num_s.NEXTVAL
777: FROM dual;
778: FUNCTION Admpl_Process_Person (
779: p_person_id IN igs_ad_appl_ltr.person_id%TYPE,
780: p_admission_appl_number IN igs_ad_appl.admission_appl_number%TYPE,
781: p_correspondence_type IN igs_ad_appl_ltr.correspondence_type%TYPE,
782: p_aal_sequence_number IN igs_ad_appl_ltr.sequence_number%TYPE,
783: p_admission_cat IN igs_ad_appl.admission_cat%TYPE,

Line 781: p_correspondence_type IN igs_ad_appl_ltr.correspondence_type%TYPE,

777: FROM dual;
778: FUNCTION Admpl_Process_Person (
779: p_person_id IN igs_ad_appl_ltr.person_id%TYPE,
780: p_admission_appl_number IN igs_ad_appl.admission_appl_number%TYPE,
781: p_correspondence_type IN igs_ad_appl_ltr.correspondence_type%TYPE,
782: p_aal_sequence_number IN igs_ad_appl_ltr.sequence_number%TYPE,
783: p_admission_cat IN igs_ad_appl.admission_cat%TYPE,
784: p_s_admission_process_type IN igs_ad_appl.s_admission_process_type%TYPE,
785: p_message_name OUT NOCOPY VARCHAR2

Line 782: p_aal_sequence_number IN igs_ad_appl_ltr.sequence_number%TYPE,

778: FUNCTION Admpl_Process_Person (
779: p_person_id IN igs_ad_appl_ltr.person_id%TYPE,
780: p_admission_appl_number IN igs_ad_appl.admission_appl_number%TYPE,
781: p_correspondence_type IN igs_ad_appl_ltr.correspondence_type%TYPE,
782: p_aal_sequence_number IN igs_ad_appl_ltr.sequence_number%TYPE,
783: p_admission_cat IN igs_ad_appl.admission_cat%TYPE,
784: p_s_admission_process_type IN igs_ad_appl.s_admission_process_type%TYPE,
785: p_message_name OUT NOCOPY VARCHAR2
786: ) RETURN BOOLEAN IS

Line 810: cp_correspondence_type igs_ad_appl_ltr.correspondence_type%TYPE

806: v_igs_co_ou_co_ref_seq_num_s igs_co_ou_co_ref.sequence_number%TYPE;
807: CURSOR c_apcl_slet (
808: cp_admission_cat igs_ad_appl.admission_cat%TYPE,
809: cp_s_admission_process_type igs_ad_appl.s_admission_process_type%TYPE,
810: cp_correspondence_type igs_ad_appl_ltr.correspondence_type%TYPE
811: ) IS
812: SELECT apcl.letter_reference_number
813: FROM igs_ad_prcs_cat_ltr apcl,
814: igs_co_s_ltr slet

Line 822: cp_correspondence_type igs_ad_appl_ltr.correspondence_type%TYPE

818: AND apcl.correspondence_type = slet.correspondence_type
819: AND apcl.letter_reference_number = slet.letter_reference_number
820: AND slet.closed_ind = 'N';
821: CURSOR c_sl (
822: cp_correspondence_type igs_ad_appl_ltr.correspondence_type%TYPE
823: ) IS
824: SELECT sl.letter_reference_number
825: FROM igs_co_s_ltr sl
826: WHERE sl.correspondence_type = cp_correspondence_type

Line 838: cp_person_id igs_ad_appl_ltr.person_id%TYPE,

834: FROM igs_co_itm cit
835: WHERE cit.correspondence_type = cp_correspondence_type
836: AND cit.create_dt = cp_create_dt;
837: CURSOR c_aal (
838: cp_person_id igs_ad_appl_ltr.person_id%TYPE,
839: cp_admission_appl_number igs_ad_appl.admission_appl_number%TYPE,
840: cp_correspondence_type igs_ad_appl_ltr.correspondence_type%TYPE,
841: cp_aal_sequence_number igs_ad_appl_ltr.sequence_number%TYPE
842: ) IS

Line 840: cp_correspondence_type igs_ad_appl_ltr.correspondence_type%TYPE,

836: AND cit.create_dt = cp_create_dt;
837: CURSOR c_aal (
838: cp_person_id igs_ad_appl_ltr.person_id%TYPE,
839: cp_admission_appl_number igs_ad_appl.admission_appl_number%TYPE,
840: cp_correspondence_type igs_ad_appl_ltr.correspondence_type%TYPE,
841: cp_aal_sequence_number igs_ad_appl_ltr.sequence_number%TYPE
842: ) IS
843: SELECT 'x'
844: FROM igs_ad_appl_ltr aal

Line 841: cp_aal_sequence_number igs_ad_appl_ltr.sequence_number%TYPE

837: CURSOR c_aal (
838: cp_person_id igs_ad_appl_ltr.person_id%TYPE,
839: cp_admission_appl_number igs_ad_appl.admission_appl_number%TYPE,
840: cp_correspondence_type igs_ad_appl_ltr.correspondence_type%TYPE,
841: cp_aal_sequence_number igs_ad_appl_ltr.sequence_number%TYPE
842: ) IS
843: SELECT 'x'
844: FROM igs_ad_appl_ltr aal
845: WHERE aal.person_id = cp_person_id

Line 844: FROM igs_ad_appl_ltr aal

840: cp_correspondence_type igs_ad_appl_ltr.correspondence_type%TYPE,
841: cp_aal_sequence_number igs_ad_appl_ltr.sequence_number%TYPE
842: ) IS
843: SELECT 'x'
844: FROM igs_ad_appl_ltr aal
845: WHERE aal.person_id = cp_person_id
846: AND aal.admission_appl_number = cp_admission_appl_number
847: AND aal.correspondence_type = cp_correspondence_type
848: AND aal.sequence_number = cp_aal_sequence_number

Line 1055: UPDATE igs_ad_appl_ltr

1051: p_correspondence_type,
1052: p_aal_sequence_number
1053: )
1054: LOOP
1055: UPDATE igs_ad_appl_ltr
1056: SET letter_reference_number = v_letter_reference_number,
1057: spl_sequence_number = v_spl_sequence_number
1058: WHERE CURRENT OF c_aal;
1059: END LOOP;

Line 1088: cp_person_id igs_ad_appl_ltr.person_id%TYPE,

1084: v_message_name VARCHAR2(30);
1085: v_false BOOLEAN DEFAULT FALSE;
1086: v_success_count NUMBER(5);
1087: CURSOR c_aa_aal (
1088: cp_person_id igs_ad_appl_ltr.person_id%TYPE,
1089: cp_admission_appl_number igs_ad_appl_ltr.admission_appl_number%TYPE,
1090: cp_correspondence_type igs_ad_appl_ltr.correspondence_type%TYPE
1091: ) IS
1092: SELECT aa.admission_cat,

Line 1089: cp_admission_appl_number igs_ad_appl_ltr.admission_appl_number%TYPE,

1085: v_false BOOLEAN DEFAULT FALSE;
1086: v_success_count NUMBER(5);
1087: CURSOR c_aa_aal (
1088: cp_person_id igs_ad_appl_ltr.person_id%TYPE,
1089: cp_admission_appl_number igs_ad_appl_ltr.admission_appl_number%TYPE,
1090: cp_correspondence_type igs_ad_appl_ltr.correspondence_type%TYPE
1091: ) IS
1092: SELECT aa.admission_cat,
1093: aa.s_admission_process_type,

Line 1090: cp_correspondence_type igs_ad_appl_ltr.correspondence_type%TYPE

1086: v_success_count NUMBER(5);
1087: CURSOR c_aa_aal (
1088: cp_person_id igs_ad_appl_ltr.person_id%TYPE,
1089: cp_admission_appl_number igs_ad_appl_ltr.admission_appl_number%TYPE,
1090: cp_correspondence_type igs_ad_appl_ltr.correspondence_type%TYPE
1091: ) IS
1092: SELECT aa.admission_cat,
1093: aa.s_admission_process_type,
1094: aal.sequence_number,

Line 1097: igs_ad_appl_ltr aal

1093: aa.s_admission_process_type,
1094: aal.sequence_number,
1095: aal.spl_sequence_number
1096: FROM igs_ad_appl aa,
1097: igs_ad_appl_ltr aal
1098: WHERE aa.person_id = cp_person_id
1099: AND aa.admission_appl_number = cp_admission_appl_number
1100: AND aal.person_id = aa.person_id
1101: AND aal.admission_appl_number = aa.admission_appl_number

Line 1114: cp_correspondence_type igs_ad_appl_ltr.correspondence_type%TYPE,

1110: cp_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
1111: cp_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE,
1112: cp_admission_cat igs_ad_appl.admission_cat%TYPE,
1113: cp_s_admission_process_type igs_ad_appl.s_admission_process_type%TYPE,
1114: cp_correspondence_type igs_ad_appl_ltr.correspondence_type%TYPE,
1115: cp_adm_outcome_status igs_ad_ou_stat.adm_outcome_status%TYPE,
1116: cp_pgm_of_study igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
1117: cp_response_status igs_ad_ofr_resp_stat.adm_offer_resp_status%TYPE,
1118: cp_residency_class igs_pe_res_dtls_v.residency_class%TYPE,

Line 1134: igs_ad_appl_ltr aal,

1130: padv.county county,
1131: padv.country country,
1132: padv.postal_code postal_code
1133: FROM igs_ad_appl aa,
1134: igs_ad_appl_ltr aal,
1135: igs_ad_ps_appl_inst acaiv, --Bug 3150054 Replaced igs_ad_ps_appl_inst_aplinst_v with igs_ad_ps_appl_inst
1136: igs_ps_ver pv,
1137: igs_pe_addr_v padv,
1138: igs_pe_res_dtls_v prdv

Line 1172: cp_correspondence_type igs_ad_appl_ltr.correspondence_type%TYPE,

1168: /*
1169: ** Cursor was added for enhancement# 1818444.
1170: */
1171: CURSOR c_aa_aal_persid (
1172: cp_correspondence_type igs_ad_appl_ltr.correspondence_type%TYPE,
1173: cp_person_id igs_ad_appl_ltr.person_id%TYPE
1174: ) IS
1175: SELECT DISTINCT
1176: aa.admission_appl_number,

Line 1173: cp_person_id igs_ad_appl_ltr.person_id%TYPE

1169: ** Cursor was added for enhancement# 1818444.
1170: */
1171: CURSOR c_aa_aal_persid (
1172: cp_correspondence_type igs_ad_appl_ltr.correspondence_type%TYPE,
1173: cp_person_id igs_ad_appl_ltr.person_id%TYPE
1174: ) IS
1175: SELECT DISTINCT
1176: aa.admission_appl_number,
1177: aa.admission_cat,

Line 1182: igs_ad_appl_ltr aal,

1178: aa.s_admission_process_type,
1179: aal.sequence_number,
1180: aal.spl_sequence_number
1181: FROM igs_ad_appl aa,
1182: igs_ad_appl_ltr aal,
1183: igs_pe_addr_v padv
1184: WHERE aa.person_id = aal.person_id
1185: AND aa.person_id = padv.person_id (+)
1186: AND aal.person_id = cp_person_id

Line 1267: igs_ad_appl_ltr aal,

1263: aa.s_admission_process_type s_admission_process_type,
1264: aal.sequence_number sequence_number,
1265: aal.spl_sequence_number spl_sequence_number, padv.' || p_sortby ||
1266: ' FROM igs_ad_appl aa,
1267: igs_ad_appl_ltr aal,
1268: igs_pe_addr_v padv
1269: WHERE aa.person_id = aal.person_id
1270: AND aa.person_id = padv.person_id (+)
1271: AND aal.person_id = :1

Line 1323: igs_ad_appl_ltr aal,

1319: padv.county county,
1320: padv.country country,
1321: padv.postal_code postal_code
1322: FROM igs_ad_appl aa,
1323: igs_ad_appl_ltr aal,
1324: igs_ad_ps_appl_inst acaiv, --Bug 3150054 Replaced igs_ad_ps_appl_inst_aplinst_v with igs_ad_ps_appl_inst
1325: igs_ps_ver pv,
1326: igs_pe_addr_v padv,
1327: igs_pe_res_dtls_v prdv

Line 1609: cp_person_id IGS_AD_APPL_LTR_PHR.person_id%TYPE,

1605: v_value VARCHAR2(2000);
1606: v_sequence_number IGS_CO_S_PER_LT_PARM.sequence_number%TYPE;
1607:
1608: CURSOR c_aalp (
1609: cp_person_id IGS_AD_APPL_LTR_PHR.person_id%TYPE,
1610: cp_adm_appl_number IGS_AD_APPL_LTR_PHR.admission_appl_number%TYPE,
1611: cp_correspondence_type IGS_AD_APPL_LTR_PHR.correspondence_type%TYPE,
1612: cp_aal_sequence_number IGS_AD_APPL_LTR_PHR.aal_sequence_number%TYPE,
1613: cp_letter_parameter_type IGS_AD_APPL_LTR_PHR.letter_parameter_type%TYPE) IS

Line 1610: cp_adm_appl_number IGS_AD_APPL_LTR_PHR.admission_appl_number%TYPE,

1606: v_sequence_number IGS_CO_S_PER_LT_PARM.sequence_number%TYPE;
1607:
1608: CURSOR c_aalp (
1609: cp_person_id IGS_AD_APPL_LTR_PHR.person_id%TYPE,
1610: cp_adm_appl_number IGS_AD_APPL_LTR_PHR.admission_appl_number%TYPE,
1611: cp_correspondence_type IGS_AD_APPL_LTR_PHR.correspondence_type%TYPE,
1612: cp_aal_sequence_number IGS_AD_APPL_LTR_PHR.aal_sequence_number%TYPE,
1613: cp_letter_parameter_type IGS_AD_APPL_LTR_PHR.letter_parameter_type%TYPE) IS
1614: SELECT aalp.phrase_cd,

Line 1611: cp_correspondence_type IGS_AD_APPL_LTR_PHR.correspondence_type%TYPE,

1607:
1608: CURSOR c_aalp (
1609: cp_person_id IGS_AD_APPL_LTR_PHR.person_id%TYPE,
1610: cp_adm_appl_number IGS_AD_APPL_LTR_PHR.admission_appl_number%TYPE,
1611: cp_correspondence_type IGS_AD_APPL_LTR_PHR.correspondence_type%TYPE,
1612: cp_aal_sequence_number IGS_AD_APPL_LTR_PHR.aal_sequence_number%TYPE,
1613: cp_letter_parameter_type IGS_AD_APPL_LTR_PHR.letter_parameter_type%TYPE) IS
1614: SELECT aalp.phrase_cd,
1615: aalp.phrase_text

Line 1612: cp_aal_sequence_number IGS_AD_APPL_LTR_PHR.aal_sequence_number%TYPE,

1608: CURSOR c_aalp (
1609: cp_person_id IGS_AD_APPL_LTR_PHR.person_id%TYPE,
1610: cp_adm_appl_number IGS_AD_APPL_LTR_PHR.admission_appl_number%TYPE,
1611: cp_correspondence_type IGS_AD_APPL_LTR_PHR.correspondence_type%TYPE,
1612: cp_aal_sequence_number IGS_AD_APPL_LTR_PHR.aal_sequence_number%TYPE,
1613: cp_letter_parameter_type IGS_AD_APPL_LTR_PHR.letter_parameter_type%TYPE) IS
1614: SELECT aalp.phrase_cd,
1615: aalp.phrase_text
1616: FROM IGS_AD_APPL_LTR_PHR aalp

Line 1613: cp_letter_parameter_type IGS_AD_APPL_LTR_PHR.letter_parameter_type%TYPE) IS

1609: cp_person_id IGS_AD_APPL_LTR_PHR.person_id%TYPE,
1610: cp_adm_appl_number IGS_AD_APPL_LTR_PHR.admission_appl_number%TYPE,
1611: cp_correspondence_type IGS_AD_APPL_LTR_PHR.correspondence_type%TYPE,
1612: cp_aal_sequence_number IGS_AD_APPL_LTR_PHR.aal_sequence_number%TYPE,
1613: cp_letter_parameter_type IGS_AD_APPL_LTR_PHR.letter_parameter_type%TYPE) IS
1614: SELECT aalp.phrase_cd,
1615: aalp.phrase_text
1616: FROM IGS_AD_APPL_LTR_PHR aalp
1617: WHERE aalp.person_id = cp_person_id AND

Line 1616: FROM IGS_AD_APPL_LTR_PHR aalp

1612: cp_aal_sequence_number IGS_AD_APPL_LTR_PHR.aal_sequence_number%TYPE,
1613: cp_letter_parameter_type IGS_AD_APPL_LTR_PHR.letter_parameter_type%TYPE) IS
1614: SELECT aalp.phrase_cd,
1615: aalp.phrase_text
1616: FROM IGS_AD_APPL_LTR_PHR aalp
1617: WHERE aalp.person_id = cp_person_id AND
1618: aalp.admission_appl_number = cp_adm_appl_number AND
1619: aalp.correspondence_type = cp_correspondence_type AND
1620: aalp.aal_sequence_number = cp_aal_sequence_number AND