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_PS_APLINSTUNT_PKG dependencies on IGS_AD_APPL

Line 98: v_person_id IGS_AD_APPL.person_id%TYPE;

94: p_deleting IN BOOLEAN DEFAULT FALSE
95: ) AS
96: v_message_name varchar2(30);
97: v_return_type VARCHAR2(1);
98: v_person_id IGS_AD_APPL.person_id%TYPE;
99: v_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE;
100: v_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE;
101: v_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE;
102: v_admission_cat IGS_AD_APPL.admission_cat%TYPE;

Line 99: v_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE;

95: ) AS
96: v_message_name varchar2(30);
97: v_return_type VARCHAR2(1);
98: v_person_id IGS_AD_APPL.person_id%TYPE;
99: v_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE;
100: v_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE;
101: v_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE;
102: v_admission_cat IGS_AD_APPL.admission_cat%TYPE;
103: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;

Line 102: v_admission_cat IGS_AD_APPL.admission_cat%TYPE;

98: v_person_id IGS_AD_APPL.person_id%TYPE;
99: v_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE;
100: v_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE;
101: v_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE;
102: v_admission_cat IGS_AD_APPL.admission_cat%TYPE;
103: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
104: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;
105: v_aa_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
106: v_aa_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;

Line 103: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;

99: v_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE;
100: v_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE;
101: v_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE;
102: v_admission_cat IGS_AD_APPL.admission_cat%TYPE;
103: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
104: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;
105: v_aa_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
106: v_aa_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
107: v_aa_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;

Line 104: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;

100: v_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE;
101: v_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE;
102: v_admission_cat IGS_AD_APPL.admission_cat%TYPE;
103: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
104: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;
105: v_aa_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
106: v_aa_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
107: v_aa_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
108: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;

Line 105: v_aa_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;

101: v_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE;
102: v_admission_cat IGS_AD_APPL.admission_cat%TYPE;
103: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
104: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;
105: v_aa_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
106: v_aa_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
107: v_aa_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
108: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
109: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;

Line 106: v_aa_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;

102: v_admission_cat IGS_AD_APPL.admission_cat%TYPE;
103: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
104: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;
105: v_aa_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
106: v_aa_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
107: v_aa_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
108: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
109: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
110: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;

Line 107: v_aa_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;

103: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
104: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;
105: v_aa_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
106: v_aa_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
107: v_aa_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
108: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
109: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
110: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
111: v_appl_dt IGS_AD_APPL.appl_dt%TYPE;

Line 108: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;

104: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;
105: v_aa_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
106: v_aa_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
107: v_aa_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
108: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
109: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
110: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
111: v_appl_dt IGS_AD_APPL.appl_dt%TYPE;
112: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;

Line 109: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;

105: v_aa_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
106: v_aa_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
107: v_aa_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
108: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
109: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
110: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
111: v_appl_dt IGS_AD_APPL.appl_dt%TYPE;
112: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;
113: v_adm_fee_status IGS_AD_APPL.adm_fee_status%TYPE;

Line 110: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;

106: v_aa_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
107: v_aa_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
108: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
109: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
110: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
111: v_appl_dt IGS_AD_APPL.appl_dt%TYPE;
112: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;
113: v_adm_fee_status IGS_AD_APPL.adm_fee_status%TYPE;
114: v_acai_adm_cal_type IGS_AD_PS_APPL_INST.adm_cal_type%TYPE;

Line 111: v_appl_dt IGS_AD_APPL.appl_dt%TYPE;

107: v_aa_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
108: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
109: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
110: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
111: v_appl_dt IGS_AD_APPL.appl_dt%TYPE;
112: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;
113: v_adm_fee_status IGS_AD_APPL.adm_fee_status%TYPE;
114: v_acai_adm_cal_type IGS_AD_PS_APPL_INST.adm_cal_type%TYPE;
115: v_acai_adm_ci_sequence_number

Line 112: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;

108: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
109: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
110: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
111: v_appl_dt IGS_AD_APPL.appl_dt%TYPE;
112: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;
113: v_adm_fee_status IGS_AD_APPL.adm_fee_status%TYPE;
114: v_acai_adm_cal_type IGS_AD_PS_APPL_INST.adm_cal_type%TYPE;
115: v_acai_adm_ci_sequence_number
116: IGS_AD_PS_APPL_INST.adm_ci_sequence_number%TYPE;

Line 113: v_adm_fee_status IGS_AD_APPL.adm_fee_status%TYPE;

109: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
110: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
111: v_appl_dt IGS_AD_APPL.appl_dt%TYPE;
112: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;
113: v_adm_fee_status IGS_AD_APPL.adm_fee_status%TYPE;
114: v_acai_adm_cal_type IGS_AD_PS_APPL_INST.adm_cal_type%TYPE;
115: v_acai_adm_ci_sequence_number
116: IGS_AD_PS_APPL_INST.adm_ci_sequence_number%TYPE;
117: v_offer_ind VARCHAR2(1);

Line 401: v_admission_cat IGS_AD_APPL.admission_cat%TYPE;

397: p_inserting IN BOOLEAN DEFAULT FALSE,
398: p_updating IN BOOLEAN DEFAULT FALSE,
399: p_deleting IN BOOLEAN DEFAULT FALSE
400: ) AS
401: v_admission_cat IGS_AD_APPL.admission_cat%TYPE;
402: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
403: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;
404: v_aa_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
405: v_aa_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;

Line 402: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;

398: p_updating IN BOOLEAN DEFAULT FALSE,
399: p_deleting IN BOOLEAN DEFAULT FALSE
400: ) AS
401: v_admission_cat IGS_AD_APPL.admission_cat%TYPE;
402: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
403: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;
404: v_aa_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
405: v_aa_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
406: v_aa_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;

Line 403: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;

399: p_deleting IN BOOLEAN DEFAULT FALSE
400: ) AS
401: v_admission_cat IGS_AD_APPL.admission_cat%TYPE;
402: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
403: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;
404: v_aa_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
405: v_aa_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
406: v_aa_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
407: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;

Line 404: v_aa_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;

400: ) AS
401: v_admission_cat IGS_AD_APPL.admission_cat%TYPE;
402: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
403: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;
404: v_aa_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
405: v_aa_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
406: v_aa_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
407: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
408: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;

Line 405: v_aa_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;

401: v_admission_cat IGS_AD_APPL.admission_cat%TYPE;
402: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
403: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;
404: v_aa_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
405: v_aa_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
406: v_aa_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
407: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
408: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
409: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;

Line 406: v_aa_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;

402: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
403: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;
404: v_aa_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
405: v_aa_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
406: v_aa_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
407: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
408: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
409: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
410: v_appl_dt DATE;

Line 407: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;

403: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;
404: v_aa_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
405: v_aa_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
406: v_aa_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
407: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
408: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
409: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
410: v_appl_dt DATE;
411: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;

Line 408: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;

404: v_aa_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
405: v_aa_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
406: v_aa_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
407: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
408: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
409: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
410: v_appl_dt DATE;
411: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;
412: v_adm_fee_status IGS_AD_APPL.adm_fee_status%TYPE;

Line 409: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;

405: v_aa_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
406: v_aa_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
407: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
408: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
409: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
410: v_appl_dt DATE;
411: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;
412: v_adm_fee_status IGS_AD_APPL.adm_fee_status%TYPE;
413: v_unit_restriction_ind VARCHAR2(1);

Line 411: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;

407: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
408: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
409: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
410: v_appl_dt DATE;
411: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;
412: v_adm_fee_status IGS_AD_APPL.adm_fee_status%TYPE;
413: v_unit_restriction_ind VARCHAR2(1);
414: v_unit_restriction_num NUMBER;
415: v_message_name varchar2(30);

Line 412: v_adm_fee_status IGS_AD_APPL.adm_fee_status%TYPE;

408: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
409: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
410: v_appl_dt DATE;
411: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;
412: v_adm_fee_status IGS_AD_APPL.adm_fee_status%TYPE;
413: v_unit_restriction_ind VARCHAR2(1);
414: v_unit_restriction_num NUMBER;
415: v_message_name varchar2(30);
416: CURSOR c_apcs (