DBA Data[Home] [Help]

APPS.IGS_FI_PAYMENT_PLANS dependencies on IGS_FI_PP_STD_ATTRS_PKG

Line 428: igs_fi_pp_std_attrs_pkg.update_row(

424: --If all the validations are thru and if the Student need not be skipped from processing,
425: --Update the Payment Plan record to set the Planned Status Code to 'ACTIVE' with appropriate
426: --FTCI details as derived above.
427: BEGIN
428: igs_fi_pp_std_attrs_pkg.update_row(
429: x_rowid => rec_cur_pmt_planned.rowid,
430: x_student_plan_id => rec_cur_pmt_planned.student_plan_id,
431: x_person_id => rec_cur_pmt_planned.person_id,
432: x_payment_plan_name => rec_cur_pmt_planned.payment_plan_name,

Line 912: igs_fi_pp_std_attrs_pkg.insert_row(x_rowid => l_rowid,

908: l_rowid := NULL;
909: l_n_student_plan_id := NULL;
910: rec_cur_pmt_plan.processing_fee_amt:=igs_fi_gen_gl.get_formatted_amount(rec_cur_pmt_plan.processing_fee_amt);
911: --For the Person being processed, create a record in the IGS_FI_PP_STD_ATTRS table.
912: igs_fi_pp_std_attrs_pkg.insert_row(x_rowid => l_rowid,
913: x_student_plan_id => l_n_student_plan_id,
914: x_person_id => l_n_person_id,
915: x_payment_plan_name => p_v_payment_plan_name,
916: x_plan_start_date => TRUNC(l_d_start_date),

Line 1097: igs_fi_pp_std_attrs_pkg.update_row(

1093: IF NVL(l_n_balance,0) <= NVL(p_n_tolerance_threshold,0) THEN
1094: --if so, update the Payment Plan status(plan_status_code column) of igs_fi_pp_std_attrs table to a
1095: --status of 'CLOSED' and also Update the End Date(plan_end_date column) of the Plan with the System Date.
1096: BEGIN
1097: igs_fi_pp_std_attrs_pkg.update_row(
1098: x_rowid => rec_cur_pp_dtls.rowid,
1099: x_student_plan_id => rec_cur_pp_dtls.student_plan_id,
1100: x_person_id => rec_cur_pp_dtls.person_id,
1101: x_payment_plan_name => rec_cur_pp_dtls.payment_plan_name,