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_WAIVERS dependencies on IGS_FI_CREDITS_ALL

Line 125: CURSOR cur_wav_crd(cp_n_person_id igs_fi_credits_all.party_id%TYPE,

121: Change History
122: Who When What
123:
124: ***************************************************************** */
125: CURSOR cur_wav_crd(cp_n_person_id igs_fi_credits_all.party_id%TYPE,
126: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
127: cp_n_fee_ci_seq igs_fi_credits_all.fee_ci_sequence_number%TYPE,
128: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS
129: SELECT crd.amount,

Line 126: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,

122: Who When What
123:
124: ***************************************************************** */
125: CURSOR cur_wav_crd(cp_n_person_id igs_fi_credits_all.party_id%TYPE,
126: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
127: cp_n_fee_ci_seq igs_fi_credits_all.fee_ci_sequence_number%TYPE,
128: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS
129: SELECT crd.amount,
130: crd.credit_id

Line 127: cp_n_fee_ci_seq igs_fi_credits_all.fee_ci_sequence_number%TYPE,

123:
124: ***************************************************************** */
125: CURSOR cur_wav_crd(cp_n_person_id igs_fi_credits_all.party_id%TYPE,
126: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
127: cp_n_fee_ci_seq igs_fi_credits_all.fee_ci_sequence_number%TYPE,
128: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS
129: SELECT crd.amount,
130: crd.credit_id
131: FROM igs_fi_credits_all crd

Line 128: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS

124: ***************************************************************** */
125: CURSOR cur_wav_crd(cp_n_person_id igs_fi_credits_all.party_id%TYPE,
126: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
127: cp_n_fee_ci_seq igs_fi_credits_all.fee_ci_sequence_number%TYPE,
128: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS
129: SELECT crd.amount,
130: crd.credit_id
131: FROM igs_fi_credits_all crd
132: WHERE crd.party_id = cp_n_person_id

Line 131: FROM igs_fi_credits_all crd

127: cp_n_fee_ci_seq igs_fi_credits_all.fee_ci_sequence_number%TYPE,
128: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS
129: SELECT crd.amount,
130: crd.credit_id
131: FROM igs_fi_credits_all crd
132: WHERE crd.party_id = cp_n_person_id
133: AND crd.fee_cal_type = cp_v_fee_cal_type
134: AND crd.fee_ci_sequence_number = cp_n_fee_ci_seq
135: AND crd.waiver_name = cp_v_waiver_name;

Line 137: CURSOR cur_chg_appl(cp_n_credit_id igs_fi_credits_all.credit_id%TYPE,

133: AND crd.fee_cal_type = cp_v_fee_cal_type
134: AND crd.fee_ci_sequence_number = cp_n_fee_ci_seq
135: AND crd.waiver_name = cp_v_waiver_name;
136:
137: CURSOR cur_chg_appl(cp_n_credit_id igs_fi_credits_all.credit_id%TYPE,
138: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
139: cp_n_fee_ci_seq igs_fi_credits_all.fee_ci_sequence_number%TYPE,
140: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS
141: SELECT SUM(appl.amount_applied) amt_appl

Line 138: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,

134: AND crd.fee_ci_sequence_number = cp_n_fee_ci_seq
135: AND crd.waiver_name = cp_v_waiver_name;
136:
137: CURSOR cur_chg_appl(cp_n_credit_id igs_fi_credits_all.credit_id%TYPE,
138: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
139: cp_n_fee_ci_seq igs_fi_credits_all.fee_ci_sequence_number%TYPE,
140: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS
141: SELECT SUM(appl.amount_applied) amt_appl
142: FROM igs_fi_applications appl,

Line 139: cp_n_fee_ci_seq igs_fi_credits_all.fee_ci_sequence_number%TYPE,

135: AND crd.waiver_name = cp_v_waiver_name;
136:
137: CURSOR cur_chg_appl(cp_n_credit_id igs_fi_credits_all.credit_id%TYPE,
138: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
139: cp_n_fee_ci_seq igs_fi_credits_all.fee_ci_sequence_number%TYPE,
140: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS
141: SELECT SUM(appl.amount_applied) amt_appl
142: FROM igs_fi_applications appl,
143: igs_fi_inv_int_all inv

Line 140: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS

136:
137: CURSOR cur_chg_appl(cp_n_credit_id igs_fi_credits_all.credit_id%TYPE,
138: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
139: cp_n_fee_ci_seq igs_fi_credits_all.fee_ci_sequence_number%TYPE,
140: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS
141: SELECT SUM(appl.amount_applied) amt_appl
142: FROM igs_fi_applications appl,
143: igs_fi_inv_int_all inv
144: WHERE appl.credit_id = cp_n_credit_id

Line 204: l_n_waiver_amount igs_fi_credits_all.amount%TYPE;

200: Change History
201: Who When What
202:
203: ***************************************************************** */
204: l_n_waiver_amount igs_fi_credits_all.amount%TYPE;
205: l_d_date DATE;
206: l_b_bool BOOLEAN;
207: l_v_message_name VARCHAR2(2000);
208: BEGIN

Line 293: igs_fi_credits_all crd,

289:
290: CURSOR cur_chgadj(cp_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE) IS
291: SELECT SUM(appl.amount_applied) amt_appl
292: FROM igs_fi_applications appl,
293: igs_fi_credits_all crd,
294: igs_fi_cr_types crt
295: WHERE appl.invoice_id = cp_n_invoice_id
296: AND appl.credit_id = crd.credit_id
297: AND crd.credit_type_id = crt.credit_type_id

Line 317: igs_fi_credits_all crd,

313: SELECT appl.amount_applied,
314: appl.application_id,
315: appl.credit_id
316: FROM igs_fi_applications appl,
317: igs_fi_credits_all crd,
318: igs_fi_cr_types_all crt
319: WHERE appl.invoice_id = cp_n_invoice_id
320: AND appl.credit_id = crd.credit_id
321: AND appl.application_type = 'APP'

Line 329: CURSOR cur_wav_adj(cp_n_credit_id igs_fi_credits_all.credit_id%TYPE,

325: AND crd.fee_ci_sequence_number = cp_n_fee_ci_seq
326: AND crd.waiver_name = cp_v_waiver_name
327: ORDER BY appl.application_id;
328:
329: CURSOR cur_wav_adj(cp_n_credit_id igs_fi_credits_all.credit_id%TYPE,
330: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
331: cp_n_fee_ci_seq igs_fi_credits_all.fee_ci_sequence_number%TYPE,
332: cp_n_invoice_id igs_fi_inv_int.invoice_id%TYPE) IS
333: SELECT igs_fi_gen_007.get_sum_appl_amnt(application_id) amt_appl

Line 330: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,

326: AND crd.waiver_name = cp_v_waiver_name
327: ORDER BY appl.application_id;
328:
329: CURSOR cur_wav_adj(cp_n_credit_id igs_fi_credits_all.credit_id%TYPE,
330: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
331: cp_n_fee_ci_seq igs_fi_credits_all.fee_ci_sequence_number%TYPE,
332: cp_n_invoice_id igs_fi_inv_int.invoice_id%TYPE) IS
333: SELECT igs_fi_gen_007.get_sum_appl_amnt(application_id) amt_appl
334: FROM igs_fi_applications appl,

Line 331: cp_n_fee_ci_seq igs_fi_credits_all.fee_ci_sequence_number%TYPE,

327: ORDER BY appl.application_id;
328:
329: CURSOR cur_wav_adj(cp_n_credit_id igs_fi_credits_all.credit_id%TYPE,
330: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
331: cp_n_fee_ci_seq igs_fi_credits_all.fee_ci_sequence_number%TYPE,
332: cp_n_invoice_id igs_fi_inv_int.invoice_id%TYPE) IS
333: SELECT igs_fi_gen_007.get_sum_appl_amnt(application_id) amt_appl
334: FROM igs_fi_applications appl,
335: igs_fi_inv_int_all inv

Line 343: FROM igs_fi_credits_all crd1,

339: AND inv.fee_ci_sequence_number = cp_n_fee_ci_seq
340: AND inv.transaction_type = 'WAIVER_ADJ'
341: AND appl.application_type = 'APP'
342: AND EXISTS (SELECT 'x'
343: FROM igs_fi_credits_all crd1,
344: igs_fi_applications appl1
345: WHERE appl1.credit_id = crd1.credit_id
346: AND crd1.credit_id = cp_n_credit_id
347: AND appl1.invoice_id = cp_n_invoice_id

Line 619: l_n_old_wav_amnt igs_fi_credits_all.amount%TYPE;

615: l_v_manage_acc igs_fi_control_all.manage_accounts%TYPE;
616: l_v_message_name VARCHAR2(2000);
617: l_v_ret_status VARCHAR2(1);
618:
619: l_n_old_wav_amnt igs_fi_credits_all.amount%TYPE;
620: l_n_new_wav_amnt igs_fi_credits_all.amount%TYPE;
621:
622: l_b_wavpgm BOOLEAN;
623: l_b_chr_err_account NUMBER;

Line 620: l_n_new_wav_amnt igs_fi_credits_all.amount%TYPE;

616: l_v_message_name VARCHAR2(2000);
617: l_v_ret_status VARCHAR2(1);
618:
619: l_n_old_wav_amnt igs_fi_credits_all.amount%TYPE;
620: l_n_new_wav_amnt igs_fi_credits_all.amount%TYPE;
621:
622: l_b_wavpgm BOOLEAN;
623: l_b_chr_err_account NUMBER;
624: l_v_var VARCHAR2(1);

Line 626: l_n_comp_wav_amnt igs_fi_credits_all.amount%TYPE;

622: l_b_wavpgm BOOLEAN;
623: l_b_chr_err_account NUMBER;
624: l_v_var VARCHAR2(1);
625:
626: l_n_comp_wav_amnt igs_fi_credits_all.amount%TYPE;
627: l_n_eligible_amnt igs_fi_credits_all.amount%TYPE;
628: l_n_diff_wav_amnt igs_fi_credits_all.amount%TYPE;
629: l_n_credit_id igs_fi_credits_all.credit_id%TYPE;
630: l_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE;

Line 627: l_n_eligible_amnt igs_fi_credits_all.amount%TYPE;

623: l_b_chr_err_account NUMBER;
624: l_v_var VARCHAR2(1);
625:
626: l_n_comp_wav_amnt igs_fi_credits_all.amount%TYPE;
627: l_n_eligible_amnt igs_fi_credits_all.amount%TYPE;
628: l_n_diff_wav_amnt igs_fi_credits_all.amount%TYPE;
629: l_n_credit_id igs_fi_credits_all.credit_id%TYPE;
630: l_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE;
631:

Line 628: l_n_diff_wav_amnt igs_fi_credits_all.amount%TYPE;

624: l_v_var VARCHAR2(1);
625:
626: l_n_comp_wav_amnt igs_fi_credits_all.amount%TYPE;
627: l_n_eligible_amnt igs_fi_credits_all.amount%TYPE;
628: l_n_diff_wav_amnt igs_fi_credits_all.amount%TYPE;
629: l_n_credit_id igs_fi_credits_all.credit_id%TYPE;
630: l_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE;
631:
632: l_v_finaid_wvr_flag igs_fi_control.waiver_notify_finaid_flag%TYPE;

Line 629: l_n_credit_id igs_fi_credits_all.credit_id%TYPE;

625:
626: l_n_comp_wav_amnt igs_fi_credits_all.amount%TYPE;
627: l_n_eligible_amnt igs_fi_credits_all.amount%TYPE;
628: l_n_diff_wav_amnt igs_fi_credits_all.amount%TYPE;
629: l_n_credit_id igs_fi_credits_all.credit_id%TYPE;
630: l_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE;
631:
632: l_v_finaid_wvr_flag igs_fi_control.waiver_notify_finaid_flag%TYPE;
633: l_n_tot_wav_amnt igs_fi_credits_all.amount%TYPE;

Line 633: l_n_tot_wav_amnt igs_fi_credits_all.amount%TYPE;

629: l_n_credit_id igs_fi_credits_all.credit_id%TYPE;
630: l_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE;
631:
632: l_v_finaid_wvr_flag igs_fi_control.waiver_notify_finaid_flag%TYPE;
633: l_n_tot_wav_amnt igs_fi_credits_all.amount%TYPE;
634: l_v_assgn_stat_code igs_fi_wav_std_pgms.assignment_status_code%TYPE;
635:
636: l_n_prc_cnt NUMBER;
637: BEGIN

Line 1038: CURSOR cur_crd(cp_n_person_id igs_fi_credits_all.party_id%TYPE,

1034: AND fwp.fee_cal_type = cp_v_fee_cal_type
1035: AND fwp.fee_ci_sequence_number = cp_n_fee_ci_seq
1036: AND fwp.waiver_method_code = 'MANUAL';
1037:
1038: CURSOR cur_crd(cp_n_person_id igs_fi_credits_all.party_id%TYPE,
1039: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE,
1040: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
1041: cp_n_fee_ci_seq igs_fi_credits_all.fee_ci_sequence_number%TYPE) IS
1042: SELECT credit_id,

Line 1039: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE,

1035: AND fwp.fee_ci_sequence_number = cp_n_fee_ci_seq
1036: AND fwp.waiver_method_code = 'MANUAL';
1037:
1038: CURSOR cur_crd(cp_n_person_id igs_fi_credits_all.party_id%TYPE,
1039: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE,
1040: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
1041: cp_n_fee_ci_seq igs_fi_credits_all.fee_ci_sequence_number%TYPE) IS
1042: SELECT credit_id,
1043: amount,

Line 1040: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,

1036: AND fwp.waiver_method_code = 'MANUAL';
1037:
1038: CURSOR cur_crd(cp_n_person_id igs_fi_credits_all.party_id%TYPE,
1039: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE,
1040: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
1041: cp_n_fee_ci_seq igs_fi_credits_all.fee_ci_sequence_number%TYPE) IS
1042: SELECT credit_id,
1043: amount,
1044: unapplied_amount

Line 1041: cp_n_fee_ci_seq igs_fi_credits_all.fee_ci_sequence_number%TYPE) IS

1037:
1038: CURSOR cur_crd(cp_n_person_id igs_fi_credits_all.party_id%TYPE,
1039: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE,
1040: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
1041: cp_n_fee_ci_seq igs_fi_credits_all.fee_ci_sequence_number%TYPE) IS
1042: SELECT credit_id,
1043: amount,
1044: unapplied_amount
1045: FROM igs_fi_credits_all

Line 1045: FROM igs_fi_credits_all

1041: cp_n_fee_ci_seq igs_fi_credits_all.fee_ci_sequence_number%TYPE) IS
1042: SELECT credit_id,
1043: amount,
1044: unapplied_amount
1045: FROM igs_fi_credits_all
1046: WHERE party_id = cp_n_person_id
1047: AND fee_cal_type = cp_v_fee_cal_type
1048: AND fee_ci_sequence_number = cp_n_fee_ci_seq
1049: AND waiver_name = cp_v_waiver_name

Line 1052: CURSOR cur_app(cp_n_credit_id igs_fi_credits_all.credit_id%TYPE) IS

1048: AND fee_ci_sequence_number = cp_n_fee_ci_seq
1049: AND waiver_name = cp_v_waiver_name
1050: AND unapplied_amount > 0;
1051:
1052: CURSOR cur_app(cp_n_credit_id igs_fi_credits_all.credit_id%TYPE) IS
1053: SELECT invoice_id
1054: FROM igs_fi_applications
1055: WHERE credit_id = cp_n_credit_id
1056: AND application_type = 'UNAPP'

Line 1574: l_n_waiver_amount IGS_FI_CREDITS_ALL.amount%TYPE;

1570: l_n_version_number igs_fi_balance_rules.version_number%TYPE;
1571: l_msg VARCHAR2(2000);
1572:
1573: l_v_process_mode VARCHAR2(6);
1574: l_n_waiver_amount IGS_FI_CREDITS_ALL.amount%TYPE;
1575:
1576: l_v_msg_data VARCHAR2(2000);
1577: l_n_msg_count NUMBER;
1578: l_org_id VARCHAR2(15);