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_INV_INT

Line 144: P_fee_cal_type IN igs_fi_inv_int.fee_cal_type%TYPE,

140:
141: FUNCTION holds_balance( p_person_id IN igs_pe_person_v.person_id%TYPE ,
142: p_person_number IN igs_pe_person_v.person_number%TYPE ,
143: p_hold_plan_name IN igs_fi_hold_plan.hold_plan_name%Type,
144: P_fee_cal_type IN igs_fi_inv_int.fee_cal_type%TYPE,
145: P_fee_ci_sequence_number IN igs_fi_inv_int.fee_ci_sequence_number%TYPE,
146: p_process_end_date IN igs_fi_person_holds.process_end_dT%TYPE ,
147: p_process_start_date IN igs_fi_person_holds.process_start_dT%TYPE ,
148: P_test_run IN VARCHAR2 ,

Line 145: P_fee_ci_sequence_number IN igs_fi_inv_int.fee_ci_sequence_number%TYPE,

141: FUNCTION holds_balance( p_person_id IN igs_pe_person_v.person_id%TYPE ,
142: p_person_number IN igs_pe_person_v.person_number%TYPE ,
143: p_hold_plan_name IN igs_fi_hold_plan.hold_plan_name%Type,
144: P_fee_cal_type IN igs_fi_inv_int.fee_cal_type%TYPE,
145: P_fee_ci_sequence_number IN igs_fi_inv_int.fee_ci_sequence_number%TYPE,
146: p_process_end_date IN igs_fi_person_holds.process_end_dT%TYPE ,
147: p_process_start_date IN igs_fi_person_holds.process_start_dT%TYPE ,
148: P_test_run IN VARCHAR2 ,
149: P_hold_type OUT NOCOPY igs_fi_hold_plan.hold_type%Type,

Line 151: P_holds_charges OUT NOCOPY igs_fi_inv_int.invoice_amount%TYPE,

147: p_process_start_date IN igs_fi_person_holds.process_start_dT%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)

Line 224: FROM igs_fi_inv_int inv

220: SELECT invoice_id,
221: invoice_amount amount,
222: invoice_amount_due ,
223: invoice_creation_date
224: FROM igs_fi_inv_int inv
225: WHERE fee_type = l_fee_type
226: AND fee_cal_type = p_fee_cal_type
227: AND fee_ci_sequence_number = p_fee_ci_sequence_number
228: AND TRUNC(invoice_creation_date) <= TRUNC(p_process_start_date)

Line 260: FROM igs_fi_inv_int_all chg,

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
259: SELECT NVL(SUM(chg.invoice_amount), 0)
260: FROM igs_fi_inv_int_all chg,
261: igs_fi_inv_wav_det wav
262: WHERE person_id = cp_n_person_id
263: AND chg.invoice_id = wav.invoice_id
264: AND wav.balance_type = 'HOLDS'

Line 278: l_charges igs_fi_inv_int.invoice_amount%TYPE :=0;

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:
282: -- Changes due to SFCR018

Line 472: --Get the charges records for the person FROM the charges table IGS_FI_INV_INT as on the p_process_start_date by getting the fee types for the passed hold plan

468: fnd_file.put_line(fnd_file.log,fnd_message.get());
469: RETURN FALSE;
470: END IF;
471:
472: --Get the charges records for the person FROM the charges table IGS_FI_INV_INT as on the p_process_start_date by getting the fee types for the passed hold plan
473: OPEN c_invoice_amnt(l_hold_plan_rec.fee_type);
474: LOOP
475: FETCH c_invoice_amnt INTO l_invoice_amnt_rec;
476:

Line 582: p_holds_charges IN igs_fi_inv_int.invoice_amount%TYPE,

578: p_hold_plan_level IN igs_fi_hold_plan.hold_plan_level%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,

Line 584: p_fee_cal_type IN igs_fi_inv_int.fee_cal_type%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,
588: p_d_last_inst_due_date IN igs_fi_pp_instlmnts.due_date%TYPE

Line 585: p_fee_ci_sequence_number IN igs_fi_inv_int.fee_ci_sequence_number%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,
588: p_d_last_inst_due_date IN igs_fi_pp_instlmnts.due_date%TYPE
589: )

Line 793: P_fee_cal_type IN igs_fi_inv_int.fee_cal_type%TYPE,

789: p_person_id_group IN igs_pe_persid_group_v.group_id%TYPE ,
790: P_process_start_date IN igs_fi_person_holds.process_start_dT%TYPE ,
791: P_process_end_date IN igs_fi_person_holds.process_end_dT%TYPE ,
792: P_hold_plan_name IN igs_fi_hold_plan.hold_plan_name%Type,
793: P_fee_cal_type IN igs_fi_inv_int.fee_cal_type%TYPE,
794: P_fee_ci_sequence_number IN igs_fi_inv_int.fee_ci_sequence_number%TYPE
795: )
796: RETURN BOOLEAN
797: IS

Line 794: P_fee_ci_sequence_number IN igs_fi_inv_int.fee_ci_sequence_number%TYPE

790: P_process_start_date IN igs_fi_person_holds.process_start_dT%TYPE ,
791: P_process_end_date IN igs_fi_person_holds.process_end_dT%TYPE ,
792: P_hold_plan_name IN igs_fi_hold_plan.hold_plan_name%Type,
793: P_fee_cal_type IN igs_fi_inv_int.fee_cal_type%TYPE,
794: P_fee_ci_sequence_number IN igs_fi_inv_int.fee_ci_sequence_number%TYPE
795: )
796: RETURN BOOLEAN
797: IS
798: /***************************************************************

Line 1074: --Cursor to SELECT distinct persons FROM igs_fi_inv_int if person id AND person group id are passsed as NULL

1070: SELECT person_id
1071: FROM igs_pe_prsid_grp_mem
1072: WHERE (TRUNC(end_date) IS NULL OR TRUNC(end_date) >= TRUNC(SYSDATE))
1073: AND group_id = p_person_id_group;
1074: --Cursor to SELECT distinct persons FROM igs_fi_inv_int if person id AND person group id are passsed as NULL
1075: CURSOR c_person_inv_int IS
1076: SELECT DISTINCT person_id
1077: FROM igs_fi_inv_int;
1078:

Line 1077: FROM igs_fi_inv_int;

1073: AND group_id = p_person_id_group;
1074: --Cursor to SELECT distinct persons FROM igs_fi_inv_int if person id AND person group id are passsed as NULL
1075: CURSOR c_person_inv_int IS
1076: SELECT DISTINCT person_id
1077: FROM igs_fi_inv_int;
1078:
1079: --Declare variables to store the values of cursors decalred above.
1080: l_person_group_rec c_person_group%ROWTYPE;
1081: l_person_inv_int_rec c_person_inv_int%ROWTYPE;

Line 1082: l_fee_cal_type igs_fi_inv_int.fee_cal_type%TYPE;

1078:
1079: --Declare variables to store the values of cursors decalred above.
1080: l_person_group_rec c_person_group%ROWTYPE;
1081: l_person_inv_int_rec c_person_inv_int%ROWTYPE;
1082: l_fee_cal_type igs_fi_inv_int.fee_cal_type%TYPE;
1083: l_fee_ci_sequence_number igs_fi_inv_int.fee_ci_sequence_number%TYPE;
1084: l_person_number igs_pe_person.person_number%TYPE :=NULL;
1085: l_person_name igs_pe_person_base_v.full_name%TYPE :=NULL;
1086: l_message_name fnd_new_messages.message_name%TYPE :=NULL;

Line 1083: l_fee_ci_sequence_number igs_fi_inv_int.fee_ci_sequence_number%TYPE;

1079: --Declare variables to store the values of cursors decalred above.
1080: l_person_group_rec c_person_group%ROWTYPE;
1081: l_person_inv_int_rec c_person_inv_int%ROWTYPE;
1082: l_fee_cal_type igs_fi_inv_int.fee_cal_type%TYPE;
1083: l_fee_ci_sequence_number igs_fi_inv_int.fee_ci_sequence_number%TYPE;
1084: l_person_number igs_pe_person.person_number%TYPE :=NULL;
1085: l_person_name igs_pe_person_base_v.full_name%TYPE :=NULL;
1086: l_message_name fnd_new_messages.message_name%TYPE :=NULL;
1087: l_message_name_1 fnd_new_messages.message_name%TYPE :=NULL;

Line 1091: l_holds_charges igs_fi_inv_int.invoice_amount%TYPE := 0;

1087: l_message_name_1 fnd_new_messages.message_name%TYPE :=NULL;
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;

Line 1745: FROM igs_fi_inv_int inv

1741: SELECT invoice_id,
1742: invoice_amount_due,
1743: invoice_creation_date,
1744: fee_type
1745: FROM igs_fi_inv_int inv
1746: WHERE fee_type = cp_c_fee_type
1747: AND fee_cal_type = l_fee_cal_type
1748: AND fee_ci_sequence_number = l_fee_ci_sequence_number
1749: AND TRUNC(invoice_creation_date) <= TRUNC(l_process_start_dt)

Line 1788: FROM igs_fi_inv_int_all chg,

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
1787: SELECT NVL(SUM(chg.invoice_amount), 0)
1788: FROM igs_fi_inv_int_all chg,
1789: igs_fi_inv_wav_det wav
1790: WHERE person_id = cp_n_person_id
1791: AND chg.invoice_id = wav.invoice_id
1792: AND wav.balance_type = 'HOLDS'