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.IGF_SP_GEN_001 dependencies on IGS_FI_INV_INT_ALL

Line 41: p_v_course_cd IN igs_fi_inv_int_all.course_cd%TYPE,

37: p_v_fund_code IN igf_aw_fund_cat_all.fund_code%TYPE,
38: p_v_ld_cal_type IN igs_ca_inst_all.cal_type%TYPE,
39: p_n_ld_seq_number IN igs_ca_inst_all.sequence_number%TYPE,
40: p_v_fee_class IN igs_fi_fee_type_all.fee_class%TYPE,
41: p_v_course_cd IN igs_fi_inv_int_all.course_cd%TYPE,
42: p_v_unit_cd IN igs_ps_unit_ofr_opt.unit_cd%TYPE,
43: p_n_unit_ver_num IN igs_ps_unit_ofr_opt_all.version_number%TYPE,
44: x_eligible_amount OUT NOCOPY NUMBER,
45: x_new_spnsp_amount OUT NOCOPY NUMBER

Line 69: FROM igs_fi_inv_int_all inv

65: cp_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,
66: cp_n_fee_seq_number IN igs_ca_inst_all.sequence_number%TYPE
67: ) IS
68: SELECT inv.invoice_id, inv.invoice_amount
69: FROM igs_fi_inv_int_all inv
70: WHERE inv.person_id = cp_n_person_id
71: AND inv.fee_cal_type = cp_v_fee_cal_type
72: AND inv.fee_ci_sequence_number = cp_n_fee_seq_number
73: AND inv.transaction_type NOT IN ('RETENTION','REFUND','AID_ADJ','WAIVER_ADJ','SPONSOR','PAY_PLAN');

Line 83: FROM igs_fi_inv_int_all inv,

79: cp_n_fee_seq_number IN igs_ca_inst_all.sequence_number%TYPE,
80: cp_v_fee_class IN igs_fi_fee_type_all.fee_class%TYPE
81: ) IS
82: SELECT inv.invoice_id, inv.invoice_amount
83: FROM igs_fi_inv_int_all inv,
84: igs_fi_fee_type_all ft
85: WHERE inv.person_id = cp_n_person_id
86: AND inv.fee_cal_type = cp_v_fee_cal_type
87: AND inv.fee_ci_sequence_number = cp_n_fee_seq_number

Line 96: cp_v_course_cd IN igs_fi_inv_int_all.course_cd%TYPE

92: CURSOR cur_get_charges_with_coursecd ( cp_n_person_id IN hz_parties.party_id%TYPE,
93: cp_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,
94: cp_n_fee_seq_number IN igs_ca_inst_all.sequence_number%TYPE,
95: cp_v_fee_class IN igs_fi_fee_type_all.fee_class%TYPE,
96: cp_v_course_cd IN igs_fi_inv_int_all.course_cd%TYPE
97: ) IS
98: SELECT inv.invoice_id, inv.invoice_amount
99: FROM igs_fi_inv_int_all inv,
100: igs_fi_fee_type_all ft

Line 99: FROM igs_fi_inv_int_all inv,

95: cp_v_fee_class IN igs_fi_fee_type_all.fee_class%TYPE,
96: cp_v_course_cd IN igs_fi_inv_int_all.course_cd%TYPE
97: ) IS
98: SELECT inv.invoice_id, inv.invoice_amount
99: FROM igs_fi_inv_int_all inv,
100: igs_fi_fee_type_all ft
101: WHERE inv.person_id = cp_n_person_id
102: AND inv.fee_cal_type = cp_v_fee_cal_type
103: AND inv.fee_ci_sequence_number = cp_n_fee_seq_number

Line 118: FROM igs_fi_inv_int_all inv,

114: cp_v_unit_cd IN igs_ps_unit_ver_all.unit_cd%TYPE,
115: cp_n_unit_ver_num IN igs_ps_unit_ver_all.version_number%TYPE
116: ) IS
117: SELECT inv.invoice_id, inv.invoice_amount
118: FROM igs_fi_inv_int_all inv,
119: igs_fi_invln_int_all invln,
120: igs_fi_fee_type_all ft,
121: igs_ps_unit_ofr_opt_all uoo
122: WHERE inv.person_id = cp_n_person_id

Line 134: CURSOR cur_neg_chg_adj(cp_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE)

130: AND uoo.unit_cd = cp_v_unit_cd
131: AND uoo.version_number = cp_n_unit_ver_num;
132:
133:
134: CURSOR cur_neg_chg_adj(cp_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE)
135: IS
136: SELECT appl.amount_applied AS amount_applied
137: FROM igs_fi_applications appl,
138: igs_fi_credits_all crd,

Line 146: CURSOR cur_waiver_credit(cp_n_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,

142: AND crd.credit_id = appl.credit_id
143: AND crd.credit_type_id = cr.credit_type_id
144: AND cr.credit_class = 'CHGADJ';
145:
146: CURSOR cur_waiver_credit(cp_n_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
147: cp_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,
148: cp_n_fee_seq_number IN igs_ca_inst_all.sequence_number%TYPE)
149: IS
150: SELECT igs_fi_gen_007.get_sum_appl_amnt (appl.application_id) amount_applied , application_id

Line 163: CURSOR cur_sponsor_credit(cp_n_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,

159: AND crd.fee_ci_sequence_number = cp_n_fee_seq_number
160: AND crd.credit_type_id = cr.credit_type_id
161: AND cr.credit_class = 'WAIVER';
162:
163: CURSOR cur_sponsor_credit(cp_n_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
164: cp_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,
165: cp_n_fee_seq_number IN igs_ca_inst.sequence_number%TYPE,
166: cp_v_ld_cal_type IN igs_ca_inst_all.cal_type%TYPE,
167: cp_n_ld_seq_number IN igs_ca_inst.sequence_number%TYPE,

Line 201: TYPE invoice_rec IS RECORD(invoice_id igs_fi_inv_int_all.invoice_id%TYPE,

197: );
198:
199:
200: -- PL/SQL record for the Invoice Information
201: TYPE invoice_rec IS RECORD(invoice_id igs_fi_inv_int_all.invoice_id%TYPE,
202: invoice_amount igs_fi_inv_int_all.invoice_amount%TYPE );
203: TYPE invoice_table_type IS TABLE OF invoice_rec INDEX BY PLS_INTEGER;
204: l_v_invoice_info invoice_table_type;
205: l_n_invoice_amt igs_fi_inv_int_all.invoice_amount%TYPE;

Line 202: invoice_amount igs_fi_inv_int_all.invoice_amount%TYPE );

198:
199:
200: -- PL/SQL record for the Invoice Information
201: TYPE invoice_rec IS RECORD(invoice_id igs_fi_inv_int_all.invoice_id%TYPE,
202: invoice_amount igs_fi_inv_int_all.invoice_amount%TYPE );
203: TYPE invoice_table_type IS TABLE OF invoice_rec INDEX BY PLS_INTEGER;
204: l_v_invoice_info invoice_table_type;
205: l_n_invoice_amt igs_fi_inv_int_all.invoice_amount%TYPE;
206: l_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE;

Line 205: l_n_invoice_amt igs_fi_inv_int_all.invoice_amount%TYPE;

201: TYPE invoice_rec IS RECORD(invoice_id igs_fi_inv_int_all.invoice_id%TYPE,
202: invoice_amount igs_fi_inv_int_all.invoice_amount%TYPE );
203: TYPE invoice_table_type IS TABLE OF invoice_rec INDEX BY PLS_INTEGER;
204: l_v_invoice_info invoice_table_type;
205: l_n_invoice_amt igs_fi_inv_int_all.invoice_amount%TYPE;
206: l_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE;
207: l_n_chgadj_amt igs_fi_inv_int_all.invoice_amount%TYPE;
208: l_n_net_invoice_amt igs_fi_inv_int_all.invoice_amount%TYPE;
209: l_n_wavapp_amt igs_fi_inv_int_all.invoice_amount%TYPE;

Line 206: l_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE;

202: invoice_amount igs_fi_inv_int_all.invoice_amount%TYPE );
203: TYPE invoice_table_type IS TABLE OF invoice_rec INDEX BY PLS_INTEGER;
204: l_v_invoice_info invoice_table_type;
205: l_n_invoice_amt igs_fi_inv_int_all.invoice_amount%TYPE;
206: l_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE;
207: l_n_chgadj_amt igs_fi_inv_int_all.invoice_amount%TYPE;
208: l_n_net_invoice_amt igs_fi_inv_int_all.invoice_amount%TYPE;
209: l_n_wavapp_amt igs_fi_inv_int_all.invoice_amount%TYPE;
210: l_n_spnsp_amt igs_fi_inv_int_all.invoice_amount%TYPE;

Line 207: l_n_chgadj_amt igs_fi_inv_int_all.invoice_amount%TYPE;

203: TYPE invoice_table_type IS TABLE OF invoice_rec INDEX BY PLS_INTEGER;
204: l_v_invoice_info invoice_table_type;
205: l_n_invoice_amt igs_fi_inv_int_all.invoice_amount%TYPE;
206: l_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE;
207: l_n_chgadj_amt igs_fi_inv_int_all.invoice_amount%TYPE;
208: l_n_net_invoice_amt igs_fi_inv_int_all.invoice_amount%TYPE;
209: l_n_wavapp_amt igs_fi_inv_int_all.invoice_amount%TYPE;
210: l_n_spnsp_amt igs_fi_inv_int_all.invoice_amount%TYPE;
211: l_n_eligible_spnsp_amt igs_fi_inv_int_all.invoice_amount%TYPE;

Line 208: l_n_net_invoice_amt igs_fi_inv_int_all.invoice_amount%TYPE;

204: l_v_invoice_info invoice_table_type;
205: l_n_invoice_amt igs_fi_inv_int_all.invoice_amount%TYPE;
206: l_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE;
207: l_n_chgadj_amt igs_fi_inv_int_all.invoice_amount%TYPE;
208: l_n_net_invoice_amt igs_fi_inv_int_all.invoice_amount%TYPE;
209: l_n_wavapp_amt igs_fi_inv_int_all.invoice_amount%TYPE;
210: l_n_spnsp_amt igs_fi_inv_int_all.invoice_amount%TYPE;
211: l_n_eligible_spnsp_amt igs_fi_inv_int_all.invoice_amount%TYPE;
212: l_new_spnsp_amount igs_fi_inv_int_all.invoice_amount%TYPE;

Line 209: l_n_wavapp_amt igs_fi_inv_int_all.invoice_amount%TYPE;

205: l_n_invoice_amt igs_fi_inv_int_all.invoice_amount%TYPE;
206: l_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE;
207: l_n_chgadj_amt igs_fi_inv_int_all.invoice_amount%TYPE;
208: l_n_net_invoice_amt igs_fi_inv_int_all.invoice_amount%TYPE;
209: l_n_wavapp_amt igs_fi_inv_int_all.invoice_amount%TYPE;
210: l_n_spnsp_amt igs_fi_inv_int_all.invoice_amount%TYPE;
211: l_n_eligible_spnsp_amt igs_fi_inv_int_all.invoice_amount%TYPE;
212: l_new_spnsp_amount igs_fi_inv_int_all.invoice_amount%TYPE;
213: l_n_cntr NUMBER;

Line 210: l_n_spnsp_amt igs_fi_inv_int_all.invoice_amount%TYPE;

206: l_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE;
207: l_n_chgadj_amt igs_fi_inv_int_all.invoice_amount%TYPE;
208: l_n_net_invoice_amt igs_fi_inv_int_all.invoice_amount%TYPE;
209: l_n_wavapp_amt igs_fi_inv_int_all.invoice_amount%TYPE;
210: l_n_spnsp_amt igs_fi_inv_int_all.invoice_amount%TYPE;
211: l_n_eligible_spnsp_amt igs_fi_inv_int_all.invoice_amount%TYPE;
212: l_new_spnsp_amount igs_fi_inv_int_all.invoice_amount%TYPE;
213: l_n_cntr NUMBER;
214: l_v_found VARCHAR(1);

Line 211: l_n_eligible_spnsp_amt igs_fi_inv_int_all.invoice_amount%TYPE;

207: l_n_chgadj_amt igs_fi_inv_int_all.invoice_amount%TYPE;
208: l_n_net_invoice_amt igs_fi_inv_int_all.invoice_amount%TYPE;
209: l_n_wavapp_amt igs_fi_inv_int_all.invoice_amount%TYPE;
210: l_n_spnsp_amt igs_fi_inv_int_all.invoice_amount%TYPE;
211: l_n_eligible_spnsp_amt igs_fi_inv_int_all.invoice_amount%TYPE;
212: l_new_spnsp_amount igs_fi_inv_int_all.invoice_amount%TYPE;
213: l_n_cntr NUMBER;
214: l_v_found VARCHAR(1);
215: BEGIN

Line 212: l_new_spnsp_amount igs_fi_inv_int_all.invoice_amount%TYPE;

208: l_n_net_invoice_amt igs_fi_inv_int_all.invoice_amount%TYPE;
209: l_n_wavapp_amt igs_fi_inv_int_all.invoice_amount%TYPE;
210: l_n_spnsp_amt igs_fi_inv_int_all.invoice_amount%TYPE;
211: l_n_eligible_spnsp_amt igs_fi_inv_int_all.invoice_amount%TYPE;
212: l_new_spnsp_amount igs_fi_inv_int_all.invoice_amount%TYPE;
213: l_n_cntr NUMBER;
214: l_v_found VARCHAR(1);
215: BEGIN
216: