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.

[Home] [Help]

APPS.IGS_FI_PRC_HOLDS dependencies on IGS_FI_CREDITS

Line 152: P_holds_final_balance OUT NOCOPY igs_fi_credits.amount%TYPE,

148: P_test_run IN VARCHAR2 ,
149: P_hold_type OUT NOCOPY igs_fi_hold_plan.hold_type%Type,
150: P_hold_plan_level OUT NOCOPY igs_fi_hold_plan.hold_plan_level%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

Line 208: FROM igs_fi_credits crd,

204: CURSOR c_credit_amnt(l_payment_due_date DATE) IS
205: SELECT crd.credit_id,
206: crd.amount,
207: crd.effective_date
208: FROM igs_fi_credits crd,
209: igs_fi_cr_types crt
210: WHERE TRUNC(crd.effective_date) between (TRUNC(p_process_start_date) + 1) AND TRUNC(l_payment_due_date)
211: AND crd.status = 'CLEARED'
212: AND crd.party_id = p_person_id

Line 276: l_credit_subac igs_fi_credits.amount%TYPE :=0;

272: l_invoice_amnt_rec c_invoice_amnt%ROWTYPE;
273: l_message_name fnd_new_messages.message_name%TYPE := NULL;
274: l_holds_balance igs_fi_balances.holds_balance%TYPE :=0;
275: l_payment_due_date igs_fi_person_holds.process_start_dT%TYPE;
276: l_credit_subac igs_fi_credits.amount%TYPE :=0;
277: l_tot_credits igs_fi_credits.amount%TYPE :=0;
278: l_charges igs_fi_inv_int.invoice_amount%TYPE :=0;
279: l_final_balance igs_fi_credits.amount%TYPE :=0;
280: l_ratio igs_fi_hold_plan.threshold_percent%TYPE;

Line 277: l_tot_credits igs_fi_credits.amount%TYPE :=0;

273: l_message_name fnd_new_messages.message_name%TYPE := NULL;
274: l_holds_balance igs_fi_balances.holds_balance%TYPE :=0;
275: l_payment_due_date igs_fi_person_holds.process_start_dT%TYPE;
276: l_credit_subac igs_fi_credits.amount%TYPE :=0;
277: l_tot_credits igs_fi_credits.amount%TYPE :=0;
278: l_charges igs_fi_inv_int.invoice_amount%TYPE :=0;
279: l_final_balance igs_fi_credits.amount%TYPE :=0;
280: l_ratio igs_fi_hold_plan.threshold_percent%TYPE;
281:

Line 279: l_final_balance igs_fi_credits.amount%TYPE :=0;

275: l_payment_due_date igs_fi_person_holds.process_start_dT%TYPE;
276: l_credit_subac igs_fi_credits.amount%TYPE :=0;
277: l_tot_credits igs_fi_credits.amount%TYPE :=0;
278: l_charges igs_fi_inv_int.invoice_amount%TYPE :=0;
279: l_final_balance igs_fi_credits.amount%TYPE :=0;
280: l_ratio igs_fi_hold_plan.threshold_percent%TYPE;
281:
282: -- Changes due to SFCR018
283: -- Call the local function to get the value of planned_credits_ind

Line 286: l_n_planned_credit igs_fi_credits.amount%TYPE :=0;

282: -- Changes due to SFCR018
283: -- Call the local function to get the value of planned_credits_ind
284: l_v_pln_cr_ind igs_fi_control_all.planned_credits_ind%TYPE := get_planned_credits_ind;
285: l_v_pln_cr_message fnd_new_messages.message_name%TYPE :=NULL;
286: l_n_planned_credit igs_fi_credits.amount%TYPE :=0;
287: -- Changes due to SFCR018
288:
289: l_n_threshold_amount igs_fi_hold_plan.threshold_amount%TYPE ;
290: l_n_threshold_percent igs_fi_hold_plan.threshold_percent%TYPE ;

Line 583: p_holds_final_balance IN igs_fi_credits.amount%TYPE,

579: p_process_start_dt IN igs_fi_person_holds.process_start_dT%TYPE ,
580: p_process_end_dt IN igs_fi_person_holds.process_end_dT%TYPE ,
581: p_offset_days IN NUMBER,
582: p_holds_charges IN igs_fi_inv_int.invoice_amount%TYPE,
583: p_holds_final_balance IN igs_fi_credits.amount%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,

Line 1092: l_holds_final_balance igs_fi_credits.amount%TYPE := 0;

1088: l_hold_type igs_fi_hold_plan.hold_type%TYPE;
1089: l_hold_plan_level igs_fi_hold_plan.hold_plan_level%TYPE;
1090: l_hold_plan_name igs_fi_hold_plan.hold_plan_name%TYPE;
1091: l_holds_charges igs_fi_inv_int.invoice_amount%TYPE := 0;
1092: l_holds_final_balance igs_fi_credits.amount%TYPE := 0;
1093: l_count PLS_INTEGER := 0;
1094: l_msg_str_0 VARCHAR2(1000) :=NULL;
1095: l_msg_str_1 VARCHAR2(1000) :=NULL;
1096: l_process_start_date igs_fi_person_holds.process_start_dT%TYPE;

Line 1719: FROM igs_fi_credits crd,

1715: CURSOR c_credit_amount(l_process_start_date igs_fi_person_holds.process_start_dt%TYPE ) IS
1716: SELECT crd.credit_id,
1717: crd.amount,
1718: crd.effective_date
1719: FROM igs_fi_credits crd,
1720: igs_fi_cr_types crt
1721: WHERE TRUNC(crd.effective_date) between
1722: (TRUNC(l_process_start_date) + 1 )and TRUNC(SYSDATE)
1723: AND crd.status = 'CLEARED'

Line 1802: l_tot_amnt_all_subact igs_fi_credits.amount%TYPE := 0;

1798: l_credit_amount_rec c_credit_amount%ROWTYPE;
1799: l_total_balance_rec c_total_balance%ROWTYPE;
1800: l_hold_plan_name igs_fi_hold_plan.hold_plan_name%TYPE;
1801: l_message_name fnd_new_messages.message_name%TYPE := NULL;
1802: l_tot_amnt_all_subact igs_fi_credits.amount%TYPE := 0;
1803: l_non_ex_amnt_each_sc igs_fi_credits.amount%TYPE := 0;
1804: l_total_charges igs_fi_balances.holds_balance%TYPE := 0.0;
1805: l_final_balance_amnt igs_fi_balances.holds_balance%TYPE := 0.0;
1806: l_release_hold VARCHAR2(2) :='Y';

Line 1803: l_non_ex_amnt_each_sc igs_fi_credits.amount%TYPE := 0;

1799: l_total_balance_rec c_total_balance%ROWTYPE;
1800: l_hold_plan_name igs_fi_hold_plan.hold_plan_name%TYPE;
1801: l_message_name fnd_new_messages.message_name%TYPE := NULL;
1802: l_tot_amnt_all_subact igs_fi_credits.amount%TYPE := 0;
1803: l_non_ex_amnt_each_sc igs_fi_credits.amount%TYPE := 0;
1804: l_total_charges igs_fi_balances.holds_balance%TYPE := 0.0;
1805: l_final_balance_amnt igs_fi_balances.holds_balance%TYPE := 0.0;
1806: l_release_hold VARCHAR2(2) :='Y';
1807: l_msg_str_0 VARCHAR2(1000) :=NULL;

Line 1819: l_n_planned_credit igs_fi_credits.amount%TYPE;

1815:
1816: -- Changes due to SFCR018
1817: l_v_pln_cr_ind igs_fi_control_all.planned_credits_ind%TYPE := get_planned_credits_ind;
1818: l_v_pln_cr_message fnd_new_messages.message_name%TYPE :=NULL;
1819: l_n_planned_credit igs_fi_credits.amount%TYPE;
1820: -- Changes due to SFCR018
1821:
1822: l_c_message_name fnd_new_messages.message_name%TYPE := NULL;
1823: l_n_threshold_amount igs_fi_hold_plan.threshold_amount%TYPE ;

Line 1901: --loop across the table IGS_FI_CREDITS to get the amount for the person_id with the effective_date between the date range

1897: CLOSE c_waive_amount;
1898:
1899: l_total_charges := l_total_charges - l_n_waive_amount;
1900:
1901: --loop across the table IGS_FI_CREDITS to get the amount for the person_id with the effective_date between the date range
1902: OPEN c_credit_amount(l_hold_type_rec.process_start_dt);
1903: LOOP
1904: FETCH c_credit_amount INTO l_credit_amount_rec;
1905: EXIT WHEN c_credit_amount%NOTFOUND;

Line 1933: --another local variable at the end of this loop across the IGS_FI_CREDITS to sum up the total non-excluded credits defined for the hold plan.

1929: --5
1930: END LOOP;
1931: CLOSE c_credit_amount;
1932: --4
1933: --another local variable at the end of this loop across the IGS_FI_CREDITS to sum up the total non-excluded credits defined for the hold plan.
1934: l_tot_amnt_all_subact := l_tot_amnt_all_subact + l_non_ex_amnt_each_sc;
1935:
1936: -- Changes due to SFCR018 - To include planned credits also when the indicator is set as 'Y'
1937: IF l_v_pln_cr_ind = 'Y' THEN

Line 2678: FROM igs_fi_credits_all

2674: AND ROWNUM < 2;
2675:
2676: CURSOR cur_credit_number(cp_release_credit_id igs_fi_person_holds.release_credit_id%TYPE) IS
2677: SELECT credit_number
2678: FROM igs_fi_credits_all
2679: WHERE credit_id = cp_release_credit_id;
2680:
2681: l_rec_active_holds cur_active_holds%ROWTYPE;
2682: l_v_credit_number igs_fi_credits_all.credit_number%TYPE := NULL;

Line 2682: l_v_credit_number igs_fi_credits_all.credit_number%TYPE := NULL;

2678: FROM igs_fi_credits_all
2679: WHERE credit_id = cp_release_credit_id;
2680:
2681: l_rec_active_holds cur_active_holds%ROWTYPE;
2682: l_v_credit_number igs_fi_credits_all.credit_number%TYPE := NULL;
2683: l_d_last_conv_dt igs_fi_balance_rules.last_conversion_date%TYPE := NULL;
2684: l_n_version_number igs_fi_balance_rules.version_number%TYPE := NULL;
2685: l_n_release PLS_INTEGER := 0;
2686: l_v_message_name fnd_new_messages.message_name%TYPE := NULL;