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_HOLDS dependencies on IGS_FI_PP_INSTLMNTS

Line 155: p_d_last_inst_due_date OUT NOCOPY igs_fi_pp_instlmnts.due_date%TYPE)

151: P_holds_charges OUT NOCOPY igs_fi_inv_int.invoice_amount%TYPE,
152: P_holds_final_balance OUT NOCOPY igs_fi_credits.amount%TYPE,
153: p_offset_days OUT NOCOPY igs_fi_hold_plan.offset_days%TYPE,
154: p_n_student_plan_id OUT NOCOPY igs_fi_pp_std_attrs.student_plan_id%TYPE,
155: p_d_last_inst_due_date OUT NOCOPY igs_fi_pp_instlmnts.due_date%TYPE)
156: RETURN BOOLEAN
157: IS
158: /***************************************************************
159: Created By : bayadav

Line 244: CURSOR c_igs_fi_pp_instlmnts ( cp_n_student_plan_id igs_fi_pp_std_attrs.student_plan_id%TYPE,

240: (TRUNC(p_process_start_date) >= TRUNC(start_dt) AND TRUNC(end_dt) is null)
241: )
242: );
243:
244: CURSOR c_igs_fi_pp_instlmnts ( cp_n_student_plan_id igs_fi_pp_std_attrs.student_plan_id%TYPE,
245: cp_d_d_pay_det_date DATE
246: ) IS
247: SELECT SUM(installment_amt) installment_amt,
248: SUM(due_amt) due_amt,

Line 250: FROM igs_fi_pp_instlmnts

246: ) IS
247: SELECT SUM(installment_amt) installment_amt,
248: SUM(due_amt) due_amt,
249: MAX(due_date) due_date
250: FROM igs_fi_pp_instlmnts
251: WHERE student_plan_id = cp_n_student_plan_id
252: AND due_date <= cp_d_d_pay_det_date;
253:
254: rec_c_igs_fi_pp_instlmnts c_igs_fi_pp_instlmnts%ROWTYPE;

Line 254: rec_c_igs_fi_pp_instlmnts c_igs_fi_pp_instlmnts%ROWTYPE;

250: FROM igs_fi_pp_instlmnts
251: WHERE student_plan_id = cp_n_student_plan_id
252: AND due_date <= cp_d_d_pay_det_date;
253:
254: rec_c_igs_fi_pp_instlmnts c_igs_fi_pp_instlmnts%ROWTYPE;
255:
256: -- Cursor to calculate the total charge amount waived when a plan level is "Balance"
257: -- Added as part of Bug# 3192641
258: CURSOR c_waive_amount( cp_n_person_id NUMBER, cp_d_process_start_date DATE) IS

Line 346: OPEN c_igs_fi_pp_instlmnts( cp_n_student_plan_id => l_n_act_plan_id ,

342: l_d_pay_det_date := TRUNC(SYSDATE) - NVL(l_hold_plan_rec.offset_days,0);
343:
344: -- compute the sum of the installment amount and the due amount for the person
345:
346: OPEN c_igs_fi_pp_instlmnts( cp_n_student_plan_id => l_n_act_plan_id ,
347: cp_d_d_pay_det_date => l_d_pay_det_date
348: );
349: FETCH c_igs_fi_pp_instlmnts INTO rec_c_igs_fi_pp_instlmnts;
350: CLOSE c_igs_fi_pp_instlmnts;

Line 349: FETCH c_igs_fi_pp_instlmnts INTO rec_c_igs_fi_pp_instlmnts;

345:
346: OPEN c_igs_fi_pp_instlmnts( cp_n_student_plan_id => l_n_act_plan_id ,
347: cp_d_d_pay_det_date => l_d_pay_det_date
348: );
349: FETCH c_igs_fi_pp_instlmnts INTO rec_c_igs_fi_pp_instlmnts;
350: CLOSE c_igs_fi_pp_instlmnts;
351:
352: p_holds_charges := NVL(rec_c_igs_fi_pp_instlmnts.installment_amt,0);
353: p_holds_final_balance := NVL(rec_c_igs_fi_pp_instlmnts.due_amt,0);

Line 350: CLOSE c_igs_fi_pp_instlmnts;

346: OPEN c_igs_fi_pp_instlmnts( cp_n_student_plan_id => l_n_act_plan_id ,
347: cp_d_d_pay_det_date => l_d_pay_det_date
348: );
349: FETCH c_igs_fi_pp_instlmnts INTO rec_c_igs_fi_pp_instlmnts;
350: CLOSE c_igs_fi_pp_instlmnts;
351:
352: p_holds_charges := NVL(rec_c_igs_fi_pp_instlmnts.installment_amt,0);
353: p_holds_final_balance := NVL(rec_c_igs_fi_pp_instlmnts.due_amt,0);
354: p_n_student_plan_id := l_n_act_plan_id;

Line 352: p_holds_charges := NVL(rec_c_igs_fi_pp_instlmnts.installment_amt,0);

348: );
349: FETCH c_igs_fi_pp_instlmnts INTO rec_c_igs_fi_pp_instlmnts;
350: CLOSE c_igs_fi_pp_instlmnts;
351:
352: p_holds_charges := NVL(rec_c_igs_fi_pp_instlmnts.installment_amt,0);
353: p_holds_final_balance := NVL(rec_c_igs_fi_pp_instlmnts.due_amt,0);
354: p_n_student_plan_id := l_n_act_plan_id;
355: p_d_last_inst_due_date := rec_c_igs_fi_pp_instlmnts.due_date;
356:

Line 353: p_holds_final_balance := NVL(rec_c_igs_fi_pp_instlmnts.due_amt,0);

349: FETCH c_igs_fi_pp_instlmnts INTO rec_c_igs_fi_pp_instlmnts;
350: CLOSE c_igs_fi_pp_instlmnts;
351:
352: p_holds_charges := NVL(rec_c_igs_fi_pp_instlmnts.installment_amt,0);
353: p_holds_final_balance := NVL(rec_c_igs_fi_pp_instlmnts.due_amt,0);
354: p_n_student_plan_id := l_n_act_plan_id;
355: p_d_last_inst_due_date := rec_c_igs_fi_pp_instlmnts.due_date;
356:
357: -- if payment plan threshold amount is provided, assign the

Line 355: p_d_last_inst_due_date := rec_c_igs_fi_pp_instlmnts.due_date;

351:
352: p_holds_charges := NVL(rec_c_igs_fi_pp_instlmnts.installment_amt,0);
353: p_holds_final_balance := NVL(rec_c_igs_fi_pp_instlmnts.due_amt,0);
354: p_n_student_plan_id := l_n_act_plan_id;
355: p_d_last_inst_due_date := rec_c_igs_fi_pp_instlmnts.due_date;
356:
357: -- if payment plan threshold amount is provided, assign the
358: -- the c_hold_plan select value to the variable
359: IF l_hold_plan_rec.payment_plan_threshold_amt IS NOT NULL THEN

Line 588: p_d_last_inst_due_date IN igs_fi_pp_instlmnts.due_date%TYPE

584: p_fee_cal_type IN igs_fi_inv_int.fee_cal_type%TYPE,
585: p_fee_ci_sequence_number IN igs_fi_inv_int.fee_ci_sequence_number%TYPE,
586: p_test_run IN VARCHAR2,
587: p_n_student_plan_id IN igs_fi_pp_std_attrs.student_plan_id%TYPE,
588: p_d_last_inst_due_date IN igs_fi_pp_instlmnts.due_date%TYPE
589: )
590: RETURN BOOLEAN
591: IS
592: /***************************************************************

Line 1105: l_d_last_inst_due_date igs_fi_pp_instlmnts.due_date%TYPE;

1101: l_v_manage_acc igs_fi_control_all.manage_accounts%TYPE := NULL;
1102: l_v_message_name fnd_new_messages.message_name%TYPE :=NULL;
1103: l_n_offset_days igs_fi_hold_plan.offset_days%TYPE :=0;
1104: l_n_student_plan_id igs_fi_pp_std_attrs.student_plan_id%TYPE;
1105: l_d_last_inst_due_date igs_fi_pp_instlmnts.due_date%TYPE;
1106: l_n_fnd_user_id fnd_user.user_id%TYPE;
1107: l_v_person_number hz_parties.party_number%TYPE;
1108: l_v_person_name hz_person_profiles.person_name%TYPE;
1109: l_v_msg_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;

Line 1773: CURSOR c_igs_fi_pp_instlmnts ( cp_n_student_plan_id igs_fi_pp_std_attrs.student_plan_id%TYPE,

1769: AND holds_balance IS NOT NULL
1770: AND TRUNC(balance_date) <= TRUNC(cp_process_start_dt)
1771: ORDER BY balance_date DESC;
1772:
1773: CURSOR c_igs_fi_pp_instlmnts ( cp_n_student_plan_id igs_fi_pp_std_attrs.student_plan_id%TYPE,
1774: cp_d_inst_due_date igs_fi_pp_instlmnts.due_date%TYPE
1775: ) IS
1776: SELECT SUM(installment_amt) installment_amt,
1777: SUM(due_amt) due_amt

Line 1774: cp_d_inst_due_date igs_fi_pp_instlmnts.due_date%TYPE

1770: AND TRUNC(balance_date) <= TRUNC(cp_process_start_dt)
1771: ORDER BY balance_date DESC;
1772:
1773: CURSOR c_igs_fi_pp_instlmnts ( cp_n_student_plan_id igs_fi_pp_std_attrs.student_plan_id%TYPE,
1774: cp_d_inst_due_date igs_fi_pp_instlmnts.due_date%TYPE
1775: ) IS
1776: SELECT SUM(installment_amt) installment_amt,
1777: SUM(due_amt) due_amt
1778: FROM igs_fi_pp_instlmnts

Line 1778: FROM igs_fi_pp_instlmnts

1774: cp_d_inst_due_date igs_fi_pp_instlmnts.due_date%TYPE
1775: ) IS
1776: SELECT SUM(installment_amt) installment_amt,
1777: SUM(due_amt) due_amt
1778: FROM igs_fi_pp_instlmnts
1779: WHERE student_plan_id = cp_n_student_plan_id
1780: AND due_date <= cp_d_inst_due_date;
1781:
1782: rec_c_igs_fi_pp_instlmnts c_igs_fi_pp_instlmnts%ROWTYPE;

Line 1782: rec_c_igs_fi_pp_instlmnts c_igs_fi_pp_instlmnts%ROWTYPE;

1778: FROM igs_fi_pp_instlmnts
1779: WHERE student_plan_id = cp_n_student_plan_id
1780: AND due_date <= cp_d_inst_due_date;
1781:
1782: rec_c_igs_fi_pp_instlmnts c_igs_fi_pp_instlmnts%ROWTYPE;
1783:
1784: -- Cursor to get the total amount of waived charges
1785: -- Added as part of Bug# 3192641
1786: CURSOR c_waive_amount( cp_n_person_id NUMBER, cp_d_process_start_date DATE) IS

Line 1881: OPEN c_igs_fi_pp_instlmnts(l_hold_type_rec.student_plan_id,

1877: IF l_hold_type_rec.payment_plan_threshold_pcent IS NOT NULL THEN
1878: l_n_threshold_percent := l_hold_type_rec.payment_plan_threshold_pcent;
1879: l_n_threshold_amount := NULL;
1880: END IF;
1881: OPEN c_igs_fi_pp_instlmnts(l_hold_type_rec.student_plan_id,
1882: l_hold_type_rec.last_instlmnt_due_date
1883: );
1884: FETCH c_igs_fi_pp_instlmnts INTO rec_c_igs_fi_pp_instlmnts;
1885: CLOSE c_igs_fi_pp_instlmnts;

Line 1884: FETCH c_igs_fi_pp_instlmnts INTO rec_c_igs_fi_pp_instlmnts;

1880: END IF;
1881: OPEN c_igs_fi_pp_instlmnts(l_hold_type_rec.student_plan_id,
1882: l_hold_type_rec.last_instlmnt_due_date
1883: );
1884: FETCH c_igs_fi_pp_instlmnts INTO rec_c_igs_fi_pp_instlmnts;
1885: CLOSE c_igs_fi_pp_instlmnts;
1886: l_total_charges := rec_c_igs_fi_pp_instlmnts.installment_amt;
1887: l_final_balance_amnt := rec_c_igs_fi_pp_instlmnts.due_amt;
1888: ELSE

Line 1885: CLOSE c_igs_fi_pp_instlmnts;

1881: OPEN c_igs_fi_pp_instlmnts(l_hold_type_rec.student_plan_id,
1882: l_hold_type_rec.last_instlmnt_due_date
1883: );
1884: FETCH c_igs_fi_pp_instlmnts INTO rec_c_igs_fi_pp_instlmnts;
1885: CLOSE c_igs_fi_pp_instlmnts;
1886: l_total_charges := rec_c_igs_fi_pp_instlmnts.installment_amt;
1887: l_final_balance_amnt := rec_c_igs_fi_pp_instlmnts.due_amt;
1888: ELSE
1889:

Line 1886: l_total_charges := rec_c_igs_fi_pp_instlmnts.installment_amt;

1882: l_hold_type_rec.last_instlmnt_due_date
1883: );
1884: FETCH c_igs_fi_pp_instlmnts INTO rec_c_igs_fi_pp_instlmnts;
1885: CLOSE c_igs_fi_pp_instlmnts;
1886: l_total_charges := rec_c_igs_fi_pp_instlmnts.installment_amt;
1887: l_final_balance_amnt := rec_c_igs_fi_pp_instlmnts.due_amt;
1888: ELSE
1889:
1890: OPEN c_bal_amount(l_hold_type_rec.person_id, l_hold_type_rec.process_start_dt);

Line 1887: l_final_balance_amnt := rec_c_igs_fi_pp_instlmnts.due_amt;

1883: );
1884: FETCH c_igs_fi_pp_instlmnts INTO rec_c_igs_fi_pp_instlmnts;
1885: CLOSE c_igs_fi_pp_instlmnts;
1886: l_total_charges := rec_c_igs_fi_pp_instlmnts.installment_amt;
1887: l_final_balance_amnt := rec_c_igs_fi_pp_instlmnts.due_amt;
1888: ELSE
1889:
1890: OPEN c_bal_amount(l_hold_type_rec.person_id, l_hold_type_rec.process_start_dt);
1891: FETCH c_bal_amount INTO l_hold_bal_amt;