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_CA_INST

Line 35: p_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,

31: );
32:
33: PROCEDURE get_sponsor_amts (
34: p_n_person_id IN hz_parties.party_id%TYPE,
35: p_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,
36: p_n_fee_seq_number IN igs_ca_inst_all.sequence_number%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,

Line 36: p_n_fee_seq_number IN igs_ca_inst_all.sequence_number%TYPE,

32:
33: PROCEDURE get_sponsor_amts (
34: p_n_person_id IN hz_parties.party_id%TYPE,
35: p_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,
36: p_n_fee_seq_number IN igs_ca_inst_all.sequence_number%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,

Line 38: p_v_ld_cal_type IN igs_ca_inst_all.cal_type%TYPE,

34: p_n_person_id IN hz_parties.party_id%TYPE,
35: p_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,
36: p_n_fee_seq_number IN igs_ca_inst_all.sequence_number%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,

Line 39: p_n_ld_seq_number IN igs_ca_inst_all.sequence_number%TYPE,

35: p_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,
36: p_n_fee_seq_number IN igs_ca_inst_all.sequence_number%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,

Line 65: cp_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,

61:
62: -- cursor is used if Fee Class parameter has not been passed (Total Sponsor amount case)
63: CURSOR cur_get_all_charges (
64: cp_n_person_id IN hz_parties.party_id%TYPE,
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

Line 66: cp_n_fee_seq_number IN igs_ca_inst_all.sequence_number%TYPE

62: -- cursor is used if Fee Class parameter has not been passed (Total Sponsor amount case)
63: CURSOR cur_get_all_charges (
64: cp_n_person_id IN hz_parties.party_id%TYPE,
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

Line 78: cp_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,

74:
75: -- cursor is used if course code or unit code and version number parameters are not passed.
76: CURSOR cur_get_charges_no_coursecd (
77: cp_n_person_id IN hz_parties.party_id%TYPE,
78: cp_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,
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

Line 79: cp_n_fee_seq_number IN igs_ca_inst_all.sequence_number%TYPE,

75: -- cursor is used if course code or unit code and version number parameters are not passed.
76: CURSOR cur_get_charges_no_coursecd (
77: cp_n_person_id IN hz_parties.party_id%TYPE,
78: cp_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,
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,

Line 93: cp_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,

89: AND ft.fee_type = inv.fee_type
90: AND ft.fee_class = cp_v_fee_class;
91:
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

Line 94: cp_n_fee_seq_number IN igs_ca_inst_all.sequence_number%TYPE,

90: AND ft.fee_class = cp_v_fee_class;
91:
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

Line 111: cp_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,

107: AND ft.fee_class = cp_v_fee_class;
108:
109: CURSOR cur_get_charges_for_unit (
110: cp_n_person_id IN hz_parties.party_id%TYPE,
111: cp_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,
112: cp_n_fee_seq_number IN igs_ca_inst.sequence_number%TYPE,
113: cp_v_fee_class IN igs_fi_fee_type_all.fee_class%TYPE,
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

Line 112: cp_n_fee_seq_number IN igs_ca_inst.sequence_number%TYPE,

108:
109: CURSOR cur_get_charges_for_unit (
110: cp_n_person_id IN hz_parties.party_id%TYPE,
111: cp_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,
112: cp_n_fee_seq_number IN igs_ca_inst.sequence_number%TYPE,
113: cp_v_fee_class IN igs_fi_fee_type_all.fee_class%TYPE,
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

Line 147: cp_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,

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
151: FROM igs_fi_applications appl,

Line 148: cp_n_fee_seq_number IN igs_ca_inst_all.sequence_number%TYPE)

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
151: FROM igs_fi_applications appl,
152: igs_fi_credits_all crd,

Line 164: cp_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,

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,
168: cp_v_fund_code IN igf_aw_fund_cat_all.fund_code%TYPE)

Line 165: cp_n_fee_seq_number IN igs_ca_inst.sequence_number%TYPE,

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,
168: cp_v_fund_code IN igf_aw_fund_cat_all.fund_code%TYPE)
169: IS

Line 166: cp_v_ld_cal_type IN igs_ca_inst_all.cal_type%TYPE,

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,
168: cp_v_fund_code IN igf_aw_fund_cat_all.fund_code%TYPE)
169: IS
170: SELECT appl.amount_applied AS amount_applied, appl.credit_id as credit_id

Line 167: cp_n_ld_seq_number IN igs_ca_inst.sequence_number%TYPE,

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,
168: cp_v_fund_code IN igf_aw_fund_cat_all.fund_code%TYPE)
169: IS
170: SELECT appl.amount_applied AS amount_applied, appl.credit_id as credit_id
171: FROM igs_fi_applications appl,

Line 318: p_ld_cal_type IN igs_ca_inst.cal_type%TYPE,

314:
315:
316: FUNCTION check_unit_attempt
317: (p_person_id IN igs_pe_person.person_id%TYPE,
318: p_ld_cal_type IN igs_ca_inst.cal_type%TYPE,
319: p_ld_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
320: p_course_cd IN igs_ps_ver.course_cd%TYPE,
321: p_course_version_number IN igs_ps_ver.version_number%TYPE,
322: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,

Line 319: p_ld_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,

315:
316: FUNCTION check_unit_attempt
317: (p_person_id IN igs_pe_person.person_id%TYPE,
318: p_ld_cal_type IN igs_ca_inst.cal_type%TYPE,
319: p_ld_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
320: p_course_cd IN igs_ps_ver.course_cd%TYPE,
321: p_course_version_number IN igs_ps_ver.version_number%TYPE,
322: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,
323: p_unit_version_number IN igs_ps_unit_ver.version_number%TYPE,

Line 348: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,

344: CURSOR c_enroll (cp_person_id igs_pe_person.person_id%TYPE,
345: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
346: cp_unit_cd igs_en_su_attempt.unit_cd%TYPE,
347: cp_unit_version_number igs_en_su_attempt.version_number%TYPE,
348: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
349: cp_ld_ci_sequence_number igs_ca_inst.sequence_number%TYPE) IS
350: SELECT 'x'
351: FROM igs_en_su_attempt
352: WHERE person_id = cp_person_id

Line 349: cp_ld_ci_sequence_number igs_ca_inst.sequence_number%TYPE) IS

345: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
346: cp_unit_cd igs_en_su_attempt.unit_cd%TYPE,
347: cp_unit_version_number igs_en_su_attempt.version_number%TYPE,
348: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
349: cp_ld_ci_sequence_number igs_ca_inst.sequence_number%TYPE) IS
350: SELECT 'x'
351: FROM igs_en_su_attempt
352: WHERE person_id = cp_person_id
353: AND course_cd = cp_course_cd