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

Line 121: FROM igs_fi_pp_instlmnts

117: --Cursor to validate if the Payment Plan has some installments for which the
118: --due date is earlier than the System Date.
119: CURSOR cur_pln_inst(cp_n_std_plan_id igs_fi_pp_std_attrs.student_plan_id%TYPE) IS
120: SELECT 'x'
121: FROM igs_fi_pp_instlmnts
122: WHERE student_plan_id = cp_n_std_plan_id
123: AND TRUNC(due_date) < g_d_sysdate
124: AND rownum < 2;
125:

Line 130: FROM igs_fi_pp_instlmnts

126: --Cursor to validate if the Installment Due Date of the first installment is earlier than
127: --the Start Date of the Payment Plan.
128: CURSOR cur_pln_due_dt(cp_n_std_plan_id igs_fi_pp_std_attrs.student_plan_id%TYPE) IS
129: SELECT due_date
130: FROM igs_fi_pp_instlmnts
131: WHERE student_plan_id = cp_n_std_plan_id
132: ORDER BY due_date;
133:
134: --Cursor to validate if the Fee Type and Fee Calendar Instance combination is an active combination.

Line 151: l_d_due_dt igs_fi_pp_instlmnts.due_date%TYPE;

147: l_v_manage_acc igs_fi_control.manage_accounts%TYPE := NULL;
148: l_v_message_name fnd_new_messages.message_name%TYPE := NULL;
149: l_v_fee_cal_type igs_fi_inv_int.fee_cal_type%TYPE := NULL;
150: l_n_fee_ci_sequence_number igs_fi_inv_int.fee_ci_sequence_number%TYPE := NULL;
151: l_d_due_dt igs_fi_pp_instlmnts.due_date%TYPE;
152:
153: l_b_valid_param BOOLEAN := TRUE;
154:
155: l_v_var VARCHAR2(1);

Line 572: due_date igs_fi_pp_instlmnts.due_date%TYPE);

568: --Declare a local PL/SQL Table to hold certain values for the creation of student payment plan record.
569: TYPE temp_rec_type IS RECORD (
570: plan_line_num igs_fi_pp_tmpl_lns.plan_line_num%TYPE,
571: plan_amount igs_fi_pp_tmpl_lns.plan_amt%TYPE,
572: due_date igs_fi_pp_instlmnts.due_date%TYPE);
573:
574: TYPE temp_tbl_type IS TABLE OF temp_rec_type INDEX BY BINARY_INTEGER;
575: l_temp_plsql_tbl temp_tbl_type;
576:

Line 590: l_n_installment_id igs_fi_pp_instlmnts.installment_id%TYPE;

586: l_d_prev_due_dt DATE;
587: l_d_start_date DATE;
588: l_v_var VARCHAR2(1);
589: l_rowid ROWID;
590: l_n_installment_id igs_fi_pp_instlmnts.installment_id%TYPE;
591: l_n_student_plan_id igs_fi_pp_instlmnts.student_plan_id%TYPE;
592: l_v_person_number igs_fi_parties_v.person_number%TYPE;
593: l_n_person_id igs_fi_parties_v.person_id%TYPE;
594: l_v_sql VARCHAR2(32767);

Line 591: l_n_student_plan_id igs_fi_pp_instlmnts.student_plan_id%TYPE;

587: l_d_start_date DATE;
588: l_v_var VARCHAR2(1);
589: l_rowid ROWID;
590: l_n_installment_id igs_fi_pp_instlmnts.installment_id%TYPE;
591: l_n_student_plan_id igs_fi_pp_instlmnts.student_plan_id%TYPE;
592: l_v_person_number igs_fi_parties_v.person_number%TYPE;
593: l_n_person_id igs_fi_parties_v.person_id%TYPE;
594: l_v_sql VARCHAR2(32767);
595: l_v_status VARCHAR2(1);

Line 960: --a record in igs_fi_pp_instlmnts table.

956:
957: IF l_temp_plsql_tbl.EXISTS(l_n_cnt) THEN
958:
959: --Nullify the IN/OUT variables l_rowid and l_n_installment_id before inserting
960: --a record in igs_fi_pp_instlmnts table.
961: l_rowid := NULL;
962: l_n_installment_id := NULL;
963:
964: l_temp_plsql_tbl(l_n_cnt).plan_amount :=igs_fi_gen_gl.get_formatted_amount(l_temp_plsql_tbl(l_n_cnt).plan_amount);

Line 965: igs_fi_pp_instlmnts_pkg.insert_row(

961: l_rowid := NULL;
962: l_n_installment_id := NULL;
963:
964: l_temp_plsql_tbl(l_n_cnt).plan_amount :=igs_fi_gen_gl.get_formatted_amount(l_temp_plsql_tbl(l_n_cnt).plan_amount);
965: igs_fi_pp_instlmnts_pkg.insert_row(
966: x_rowid => l_rowid,
967: x_installment_id => l_n_installment_id,
968: x_student_plan_id => l_n_student_plan_id,
969: x_installment_line_num => l_temp_plsql_tbl(l_n_cnt).plan_line_num,

Line 1057: CURSOR cur_pp_insts(cp_n_std_pln_id igs_fi_pp_instlmnts.student_plan_id%TYPE) IS

1053:
1054: rec_cur_pp_dtls cur_pp_dtls%ROWTYPE;
1055:
1056: --Cursor to fetch the details of all the Installments of a Student Payment Plan.
1057: CURSOR cur_pp_insts(cp_n_std_pln_id igs_fi_pp_instlmnts.student_plan_id%TYPE) IS
1058: SELECT a.rowid,a.*
1059: FROM igs_fi_pp_instlmnts a
1060: WHERE a.student_plan_id = cp_n_std_pln_id
1061: FOR UPDATE NOWAIT;

Line 1059: FROM igs_fi_pp_instlmnts a

1055:
1056: --Cursor to fetch the details of all the Installments of a Student Payment Plan.
1057: CURSOR cur_pp_insts(cp_n_std_pln_id igs_fi_pp_instlmnts.student_plan_id%TYPE) IS
1058: SELECT a.rowid,a.*
1059: FROM igs_fi_pp_instlmnts a
1060: WHERE a.student_plan_id = cp_n_std_pln_id
1061: FOR UPDATE NOWAIT;
1062:
1063: l_n_balance igs_fi_pp_instlmnts.due_amt%TYPE;

Line 1063: l_n_balance igs_fi_pp_instlmnts.due_amt%TYPE;

1059: FROM igs_fi_pp_instlmnts a
1060: WHERE a.student_plan_id = cp_n_std_pln_id
1061: FOR UPDATE NOWAIT;
1062:
1063: l_n_balance igs_fi_pp_instlmnts.due_amt%TYPE;
1064: l_v_closed CONSTANT igs_fi_pp_std_attrs.plan_status_code%TYPE := 'CLOSED';
1065: l_n_inst_bal igs_fi_pp_instlmnts.installment_amt%TYPE;
1066: l_v_end_dt_msg VARCHAR2(2000);
1067: l_n_count NUMBER :=0;

Line 1065: l_n_inst_bal igs_fi_pp_instlmnts.installment_amt%TYPE;

1061: FOR UPDATE NOWAIT;
1062:
1063: l_n_balance igs_fi_pp_instlmnts.due_amt%TYPE;
1064: l_v_closed CONSTANT igs_fi_pp_std_attrs.plan_status_code%TYPE := 'CLOSED';
1065: l_n_inst_bal igs_fi_pp_instlmnts.installment_amt%TYPE;
1066: l_v_end_dt_msg VARCHAR2(2000);
1067: l_n_count NUMBER :=0;
1068: l_v_plan_name CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PLAN_NAME');
1069: l_v_plan_bal CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PLAN_BAL');

Line 1143: igs_fi_pp_instlmnts_pkg.update_row(

1139: --Calculate the value to be updated in the column installment_amt.
1140: l_n_inst_bal := NVL(rec_cur_pp_insts.installment_amt,0) - NVL(rec_cur_pp_insts.due_amt,0);
1141:
1142: l_n_inst_bal :=igs_fi_gen_gl.get_formatted_amount(l_n_inst_bal);
1143: igs_fi_pp_instlmnts_pkg.update_row(
1144: x_rowid => rec_cur_pp_insts.rowid,
1145: x_installment_id => rec_cur_pp_insts.installment_id,
1146: x_student_plan_id => rec_cur_pp_insts.student_plan_id,
1147: x_installment_line_num => rec_cur_pp_insts.installment_line_num,