APPS.IGS_FI_CRDAPI_UTIL dependencies on IGS_FI_PP_STD_ATTRS

Line 106: l_n_act_plan_id igs_fi_pp_std_attrs.student_plan_id%TYPE;

102: Change History
103: Who When What
104: ********************************************************************************************** */
105:
106: l_n_act_plan_id igs_fi_pp_std_attrs.student_plan_id%TYPE;
107: l_v_act_plan_name igs_fi_pp_std_attrs.payment_plan_name%TYPE;
108: l_n_pln_bal NUMBER;
109:
110: BEGIN

Line 107: l_v_act_plan_name igs_fi_pp_std_attrs.payment_plan_name%TYPE;

103: Who When What
104: ********************************************************************************************** */
105:
106: l_n_act_plan_id igs_fi_pp_std_attrs.student_plan_id%TYPE;
107: l_v_act_plan_name igs_fi_pp_std_attrs.payment_plan_name%TYPE;
108: l_n_pln_bal NUMBER;
109:
110: BEGIN
111: --Get the Student's Active Payment Plan's details.

Line 160: igs_fi_pp_std_attrs stt

156: CURSOR cur_pp_insts(cp_n_person_id NUMBER,
157: cp_v_plan_status VARCHAR2) IS
158: SELECT inst.rowid row_id, inst.*
159: FROM igs_fi_pp_instlmnts inst,
160: igs_fi_pp_std_attrs stt
161: WHERE stt.student_plan_id = inst.student_plan_id AND
162: stt.person_id = cp_n_person_id AND
163: stt.plan_status_code = cp_v_plan_status AND
164: inst.due_amt > 0

Line 173: FROM igs_fi_pp_std_attrs stt

169: --Cursor to fetch the details of Student's Active Payment Plan record.
170: CURSOR cur_pmt_plan(cp_n_person_id NUMBER,
171: cp_v_plan_status VARCHAR2) IS
172: SELECT stt.rowid row_id,stt.*
173: FROM igs_fi_pp_std_attrs stt
174: WHERE stt.person_id = cp_n_person_id AND
175: stt.plan_status_code = cp_v_plan_status;
176:
177: rec_cur_pmt_plan cur_pmt_plan%ROWTYPE;

Line 258: igs_fi_pp_std_attrs_pkg.update_row(

254: FETCH cur_pmt_plan INTO rec_cur_pmt_plan;
255: CLOSE cur_pmt_plan;
256:
257: --Close the Payment Plan specifying the System Date as plan end date.
258: igs_fi_pp_std_attrs_pkg.update_row(
259: x_rowid => rec_cur_pmt_plan.row_id,
260: x_student_plan_id => rec_cur_pmt_plan.student_plan_id,
261: x_person_id => rec_cur_pmt_plan.person_id,
262: x_payment_plan_name => rec_cur_pmt_plan.payment_plan_name,