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_FI_PRC_SP_FEES dependencies on IGS_EN_SU_ATTEMPT

Line 99: p_n_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,

95: p_v_fee_type IN igs_fi_f_typ_ca_inst.fee_type%TYPE,
96: p_v_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
97: p_n_fee_ci_sequence_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
98: p_v_course_cd IN igs_ps_ver.course_cd%TYPE,
99: p_n_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
100: p_n_amount IN igs_fi_invln_int.amount%TYPE,
101: p_v_transaction_type IN igs_fi_inv_int.transaction_type%TYPE,
102: p_v_currency_cd IN igs_fi_control.currency_cd%TYPE,
103: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,

Line 105: p_v_sua_status IN igs_en_su_attempt.unit_attempt_status%TYPE,

101: p_v_transaction_type IN igs_fi_inv_int.transaction_type%TYPE,
102: p_v_currency_cd IN igs_fi_control.currency_cd%TYPE,
103: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,
104: p_n_source_invoice_id IN igs_fi_inv_int.invoice_id%TYPE,
105: p_v_sua_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
106: p_n_invoice_id OUT NOCOPY igs_fi_inv_int.invoice_id%TYPE,
107: p_v_ret_status OUT NOCOPY VARCHAR2) AS
108: /******************************************************************
109: Created By : Priya Athipatla

Line 128: --Cursor to select the org unit cd and location cd from igs_en_su_attempt

124: SELECT description
125: FROM igs_fi_fee_type
126: WHERE fee_type = cp_v_fee_type;
127:
128: --Cursor to select the org unit cd and location cd from igs_en_su_attempt
129: CURSOR c_org_unit_cd(cp_person_id IN igs_en_su_attempt_all.person_id%TYPE,
130: cp_course_cd in igs_en_su_attempt_all.course_cd%TYPE,
131: cp_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE
132: ) IS

Line 129: CURSOR c_org_unit_cd(cp_person_id IN igs_en_su_attempt_all.person_id%TYPE,

125: FROM igs_fi_fee_type
126: WHERE fee_type = cp_v_fee_type;
127:
128: --Cursor to select the org unit cd and location cd from igs_en_su_attempt
129: CURSOR c_org_unit_cd(cp_person_id IN igs_en_su_attempt_all.person_id%TYPE,
130: cp_course_cd in igs_en_su_attempt_all.course_cd%TYPE,
131: cp_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE
132: ) IS
133: SELECT org_unit_cd ,location_cd

Line 130: cp_course_cd in igs_en_su_attempt_all.course_cd%TYPE,

126: WHERE fee_type = cp_v_fee_type;
127:
128: --Cursor to select the org unit cd and location cd from igs_en_su_attempt
129: CURSOR c_org_unit_cd(cp_person_id IN igs_en_su_attempt_all.person_id%TYPE,
130: cp_course_cd in igs_en_su_attempt_all.course_cd%TYPE,
131: cp_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE
132: ) IS
133: SELECT org_unit_cd ,location_cd
134: FROM igs_en_su_attempt su

Line 131: cp_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE

127:
128: --Cursor to select the org unit cd and location cd from igs_en_su_attempt
129: CURSOR c_org_unit_cd(cp_person_id IN igs_en_su_attempt_all.person_id%TYPE,
130: cp_course_cd in igs_en_su_attempt_all.course_cd%TYPE,
131: cp_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE
132: ) IS
133: SELECT org_unit_cd ,location_cd
134: FROM igs_en_su_attempt su
135: WHERE su.person_id = cp_person_id

Line 134: FROM igs_en_su_attempt su

130: cp_course_cd in igs_en_su_attempt_all.course_cd%TYPE,
131: cp_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE
132: ) IS
133: SELECT org_unit_cd ,location_cd
134: FROM igs_en_su_attempt su
135: WHERE su.person_id = cp_person_id
136: AND su.course_cd = cp_course_cd
137: AND su.uoo_id = cp_uoo_id;
138:

Line 171: l_v_derived_org_unit_cd igs_en_su_attempt_all.org_unit_cd%TYPE;

167: l_v_msg_data VARCHAR2(4000) := NULL;
168:
169: --local parameters to hold the org unit code and loaction code values from the cursor.
170: l_rec_cur_org_unit_cd c_org_unit_cd%ROWTYPE;
171: l_v_derived_org_unit_cd igs_en_su_attempt_all.org_unit_cd%TYPE;
172: --CUROSR
173: l_c_unit_level_detail c_unit_level_detail%ROWTYPE;
174:
175: l_n_waiver_amount NUMBER;

Line 183: -- To derive the org unit code and location code from igs_en_su_attempt table

179: OPEN cur_fee_type_desc(p_v_fee_type);
180: FETCH cur_fee_type_desc INTO l_v_fee_type_desc;
181: CLOSE cur_fee_type_desc;
182:
183: -- To derive the org unit code and location code from igs_en_su_attempt table
184: l_v_derived_org_unit_cd := NULL;
185: OPEN c_org_unit_cd(p_n_person_id,
186: p_v_course_cd,
187: p_n_uoo_id);

Line 329: FROM igs_en_su_attempt sua,

325: SELECT sua.cal_type,
326: sua.ci_sequence_number, sua.discontinued_dt,
327: sua.administrative_unit_status, sua.unit_attempt_status,
328: sua.no_assessment_ind
329: FROM igs_en_su_attempt sua,
330: igs_lookups_view lkp
331: WHERE sua.person_id = cp_n_person_id
332: AND sua.course_cd = cp_v_course_cd
333: AND sua.uoo_id = cp_n_uoo_id

Line 339: CURSOR cur_sua_status(cp_n_person_id igs_en_su_attempt.person_id%TYPE,

335: AND lkp.fee_ass_ind = cp_v_fee_ass_ind
336: AND sua.unit_attempt_status = lkp.lookup_code;
337:
338: -- Cursor to determine the SUA status
339: CURSOR cur_sua_status(cp_n_person_id igs_en_su_attempt.person_id%TYPE,
340: cp_n_uoo_id igs_en_su_attempt.uoo_id%TYPE,
341: cp_v_course_cd igs_en_su_attempt_all.course_cd%TYPE) IS
342: SELECT sua.unit_attempt_status,
343: sua.discontinued_dt,

Line 340: cp_n_uoo_id igs_en_su_attempt.uoo_id%TYPE,

336: AND sua.unit_attempt_status = lkp.lookup_code;
337:
338: -- Cursor to determine the SUA status
339: CURSOR cur_sua_status(cp_n_person_id igs_en_su_attempt.person_id%TYPE,
340: cp_n_uoo_id igs_en_su_attempt.uoo_id%TYPE,
341: cp_v_course_cd igs_en_su_attempt_all.course_cd%TYPE) IS
342: SELECT sua.unit_attempt_status,
343: sua.discontinued_dt,
344: sua.dcnt_reason_cd

Line 341: cp_v_course_cd igs_en_su_attempt_all.course_cd%TYPE) IS

337:
338: -- Cursor to determine the SUA status
339: CURSOR cur_sua_status(cp_n_person_id igs_en_su_attempt.person_id%TYPE,
340: cp_n_uoo_id igs_en_su_attempt.uoo_id%TYPE,
341: cp_v_course_cd igs_en_su_attempt_all.course_cd%TYPE) IS
342: SELECT sua.unit_attempt_status,
343: sua.discontinued_dt,
344: sua.dcnt_reason_cd
345: FROM igs_en_su_attempt sua

Line 345: FROM igs_en_su_attempt sua

341: cp_v_course_cd igs_en_su_attempt_all.course_cd%TYPE) IS
342: SELECT sua.unit_attempt_status,
343: sua.discontinued_dt,
344: sua.dcnt_reason_cd
345: FROM igs_en_su_attempt sua
346: WHERE sua.person_id = cp_n_person_id
347: AND sua.uoo_id = cp_n_uoo_id
348: AND sua.course_cd = cp_v_course_cd;
349:

Line 386: l_v_sua_status igs_en_su_attempt.unit_attempt_status%TYPE := NULL;

382: l_b_chg_decl_rev BOOLEAN;
383:
384: l_v_ret_level igs_fi_f_typ_ca_inst_all.retention_level_code%TYPE;
385: l_v_complete_withdr_ret igs_fi_f_typ_ca_inst_all.complete_ret_flag%TYPE;
386: l_v_sua_status igs_en_su_attempt.unit_attempt_status%TYPE := NULL;
387: l_d_disc_dt igs_en_su_attempt.discontinued_dt%TYPE := NULL;
388:
389: -- Cursor to get optional payment Indicator for a given fee type
390: CURSOR cur_optional_payment_ind(cp_fee_type igs_fi_fee_type_all.fee_type%TYPE) IS

Line 387: l_d_disc_dt igs_en_su_attempt.discontinued_dt%TYPE := NULL;

383:
384: l_v_ret_level igs_fi_f_typ_ca_inst_all.retention_level_code%TYPE;
385: l_v_complete_withdr_ret igs_fi_f_typ_ca_inst_all.complete_ret_flag%TYPE;
386: l_v_sua_status igs_en_su_attempt.unit_attempt_status%TYPE := NULL;
387: l_d_disc_dt igs_en_su_attempt.discontinued_dt%TYPE := NULL;
388:
389: -- Cursor to get optional payment Indicator for a given fee type
390: CURSOR cur_optional_payment_ind(cp_fee_type igs_fi_fee_type_all.fee_type%TYPE) IS
391: SELECT optional_payment_ind

Line 398: l_v_disc_reason igs_en_su_attempt.dcnt_reason_cd%TYPE;

394:
395: l_v_optional_payment_ind igs_fi_fee_type_all.optional_payment_ind%TYPE;
396: l_v_unit_transferred VARCHAR2(1);
397:
398: l_v_disc_reason igs_en_su_attempt.dcnt_reason_cd%TYPE;
399:
400: BEGIN
401: x_return_status := 'S';
402: