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_STD_ATTRS

Line 31: g_v_planned CONSTANT igs_fi_pp_std_attrs.plan_status_code%TYPE := 'PLANNED';

27: PRAGMA EXCEPTION_INIT(e_resource_busy, -54);
28:
29: g_v_ind_yes CONSTANT VARCHAR2(1) := 'Y';
30: g_v_ind_no CONSTANT VARCHAR2(1) := 'N';
31: g_v_planned CONSTANT igs_fi_pp_std_attrs.plan_status_code%TYPE := 'PLANNED';
32: g_v_active CONSTANT igs_fi_pp_std_attrs.plan_status_code%TYPE := 'ACTIVE';
33: g_v_monthly CONSTANT igs_fi_pp_templates.installment_period_code%TYPE := 'MONTHLY';
34: g_v_bi_monthly CONSTANT igs_fi_pp_templates.installment_period_code%TYPE := 'BI_MONTHLY';
35: g_v_quarterly CONSTANT igs_fi_pp_templates.installment_period_code%TYPE := 'QUARTERLY';

Line 32: g_v_active CONSTANT igs_fi_pp_std_attrs.plan_status_code%TYPE := 'ACTIVE';

28:
29: g_v_ind_yes CONSTANT VARCHAR2(1) := 'Y';
30: g_v_ind_no CONSTANT VARCHAR2(1) := 'N';
31: g_v_planned CONSTANT igs_fi_pp_std_attrs.plan_status_code%TYPE := 'PLANNED';
32: g_v_active CONSTANT igs_fi_pp_std_attrs.plan_status_code%TYPE := 'ACTIVE';
33: g_v_monthly CONSTANT igs_fi_pp_templates.installment_period_code%TYPE := 'MONTHLY';
34: g_v_bi_monthly CONSTANT igs_fi_pp_templates.installment_period_code%TYPE := 'BI_MONTHLY';
35: g_v_quarterly CONSTANT igs_fi_pp_templates.installment_period_code%TYPE := 'QUARTERLY';
36: g_v_line CONSTANT VARCHAR2(100) := '+'||RPAD('-',75,'-')||'+';

Line 90: FROM igs_fi_pp_std_attrs

86: l_org_id VARCHAR2(15);
87: --Cursor to validate if the Student has a Payment Plan with the status of ACTIVE.
88: CURSOR cur_pmt_active(cp_n_person_id igs_fi_parties_v.person_id%TYPE) IS
89: SELECT 'x'
90: FROM igs_fi_pp_std_attrs
91: WHERE person_id = cp_n_person_id
92: AND plan_status_code = g_v_active;
93:
94: --Cursor to validate if the Student has a Payment Plan with the status of PLANNED.

Line 98: FROM igs_fi_pp_std_attrs a

94: --Cursor to validate if the Student has a Payment Plan with the status of PLANNED.
95: --This cursor also selects the details of the Planned Payment Plans for a Student.
96: CURSOR cur_pmt_planned(cp_n_person_id igs_fi_parties_v.person_id%TYPE) IS
97: SELECT a.rowid,a.*
98: FROM igs_fi_pp_std_attrs a
99: WHERE a.person_id = cp_n_person_id
100: AND a.plan_status_code = g_v_planned
101: AND a.plan_start_date <= g_d_sysdate
102: FOR UPDATE NOWAIT;

Line 109: cp_n_std_plan_id igs_fi_pp_std_attrs.student_plan_id%TYPE,

105:
106: --Cursor to validate if the specified Payment Plan has the Start Date
107: --overlapping with the End Date of the previous plan.
108: CURSOR cur_validate_st_dt(cp_n_person_id igs_fi_parties_v.person_id%TYPE,
109: cp_n_std_plan_id igs_fi_pp_std_attrs.student_plan_id%TYPE,
110: cp_d_start_dt igs_fi_pp_std_attrs.plan_start_date%TYPE) IS
111: SELECT 'x'
112: FROM igs_fi_pp_std_attrs
113: WHERE person_id = cp_n_person_id

Line 110: cp_d_start_dt igs_fi_pp_std_attrs.plan_start_date%TYPE) IS

106: --Cursor to validate if the specified Payment Plan has the Start Date
107: --overlapping with the End Date of the previous plan.
108: CURSOR cur_validate_st_dt(cp_n_person_id igs_fi_parties_v.person_id%TYPE,
109: cp_n_std_plan_id igs_fi_pp_std_attrs.student_plan_id%TYPE,
110: cp_d_start_dt igs_fi_pp_std_attrs.plan_start_date%TYPE) IS
111: SELECT 'x'
112: FROM igs_fi_pp_std_attrs
113: WHERE person_id = cp_n_person_id
114: AND student_plan_id <> cp_n_std_plan_id

Line 112: FROM igs_fi_pp_std_attrs

108: CURSOR cur_validate_st_dt(cp_n_person_id igs_fi_parties_v.person_id%TYPE,
109: cp_n_std_plan_id igs_fi_pp_std_attrs.student_plan_id%TYPE,
110: cp_d_start_dt igs_fi_pp_std_attrs.plan_start_date%TYPE) IS
111: SELECT 'x'
112: FROM igs_fi_pp_std_attrs
113: WHERE person_id = cp_n_person_id
114: AND student_plan_id <> cp_n_std_plan_id
115: AND TRUNC(plan_end_date) >= TRUNC(cp_d_start_dt);
116:

Line 119: CURSOR cur_pln_inst(cp_n_std_plan_id igs_fi_pp_std_attrs.student_plan_id%TYPE) IS

115: AND TRUNC(plan_end_date) >= TRUNC(cp_d_start_dt);
116:
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

Line 128: CURSOR cur_pln_due_dt(cp_n_std_plan_id igs_fi_pp_std_attrs.student_plan_id%TYPE) IS

124: AND rownum < 2;
125:
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;

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 555: FROM igs_fi_pp_std_attrs

551:
552: --Cursor used to validate if the Person has a Payment Plan with status as Planned.
553: CURSOR cur_pp_planned(cp_n_person_id igs_fi_parties_v.person_id%TYPE) IS
554: SELECT 'x'
555: FROM igs_fi_pp_std_attrs
556: WHERE person_id = cp_n_person_id
557: AND plan_status_code = g_v_planned;
558:
559: --Cursor used to validate if the Start Date passed as input to the process is eariler than

Line 564: FROM igs_fi_pp_std_attrs

560: --the End Date of any plan for the person.
561: CURSOR cur_validate_start_dt(cp_n_person_id igs_fi_parties_v.person_id%TYPE,
562: cp_d_start_date DATE) IS
563: SELECT 'x'
564: FROM igs_fi_pp_std_attrs
565: WHERE person_id = cp_n_person_id
566: AND TRUNC(cp_d_start_date) <= TRUNC(plan_end_date);
567:
568: --Declare a local PL/SQL Table to hold certain values for the creation of student payment plan record.

Line 607: attribute1 igs_fi_pp_std_attrs.attribute1%TYPE,

603: l_v_pmt_plan_template CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PAYPLAN_TEMPLATE');
604: l_v_start_date CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','START_DT');
605:
606: TYPE dff_seg_values IS RECORD (
607: attribute1 igs_fi_pp_std_attrs.attribute1%TYPE,
608: attribute2 igs_fi_pp_std_attrs.attribute2%TYPE,
609: attribute3 igs_fi_pp_std_attrs.attribute3%TYPE,
610: attribute4 igs_fi_pp_std_attrs.attribute4%TYPE,
611: attribute5 igs_fi_pp_std_attrs.attribute5%TYPE,

Line 608: attribute2 igs_fi_pp_std_attrs.attribute2%TYPE,

604: l_v_start_date CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','START_DT');
605:
606: TYPE dff_seg_values IS RECORD (
607: attribute1 igs_fi_pp_std_attrs.attribute1%TYPE,
608: attribute2 igs_fi_pp_std_attrs.attribute2%TYPE,
609: attribute3 igs_fi_pp_std_attrs.attribute3%TYPE,
610: attribute4 igs_fi_pp_std_attrs.attribute4%TYPE,
611: attribute5 igs_fi_pp_std_attrs.attribute5%TYPE,
612: attribute6 igs_fi_pp_std_attrs.attribute6%TYPE,

Line 609: attribute3 igs_fi_pp_std_attrs.attribute3%TYPE,

605:
606: TYPE dff_seg_values IS RECORD (
607: attribute1 igs_fi_pp_std_attrs.attribute1%TYPE,
608: attribute2 igs_fi_pp_std_attrs.attribute2%TYPE,
609: attribute3 igs_fi_pp_std_attrs.attribute3%TYPE,
610: attribute4 igs_fi_pp_std_attrs.attribute4%TYPE,
611: attribute5 igs_fi_pp_std_attrs.attribute5%TYPE,
612: attribute6 igs_fi_pp_std_attrs.attribute6%TYPE,
613: attribute7 igs_fi_pp_std_attrs.attribute7%TYPE,

Line 610: attribute4 igs_fi_pp_std_attrs.attribute4%TYPE,

606: TYPE dff_seg_values IS RECORD (
607: attribute1 igs_fi_pp_std_attrs.attribute1%TYPE,
608: attribute2 igs_fi_pp_std_attrs.attribute2%TYPE,
609: attribute3 igs_fi_pp_std_attrs.attribute3%TYPE,
610: attribute4 igs_fi_pp_std_attrs.attribute4%TYPE,
611: attribute5 igs_fi_pp_std_attrs.attribute5%TYPE,
612: attribute6 igs_fi_pp_std_attrs.attribute6%TYPE,
613: attribute7 igs_fi_pp_std_attrs.attribute7%TYPE,
614: attribute8 igs_fi_pp_std_attrs.attribute8%TYPE,

Line 611: attribute5 igs_fi_pp_std_attrs.attribute5%TYPE,

607: attribute1 igs_fi_pp_std_attrs.attribute1%TYPE,
608: attribute2 igs_fi_pp_std_attrs.attribute2%TYPE,
609: attribute3 igs_fi_pp_std_attrs.attribute3%TYPE,
610: attribute4 igs_fi_pp_std_attrs.attribute4%TYPE,
611: attribute5 igs_fi_pp_std_attrs.attribute5%TYPE,
612: attribute6 igs_fi_pp_std_attrs.attribute6%TYPE,
613: attribute7 igs_fi_pp_std_attrs.attribute7%TYPE,
614: attribute8 igs_fi_pp_std_attrs.attribute8%TYPE,
615: attribute9 igs_fi_pp_std_attrs.attribute9%TYPE,

Line 612: attribute6 igs_fi_pp_std_attrs.attribute6%TYPE,

608: attribute2 igs_fi_pp_std_attrs.attribute2%TYPE,
609: attribute3 igs_fi_pp_std_attrs.attribute3%TYPE,
610: attribute4 igs_fi_pp_std_attrs.attribute4%TYPE,
611: attribute5 igs_fi_pp_std_attrs.attribute5%TYPE,
612: attribute6 igs_fi_pp_std_attrs.attribute6%TYPE,
613: attribute7 igs_fi_pp_std_attrs.attribute7%TYPE,
614: attribute8 igs_fi_pp_std_attrs.attribute8%TYPE,
615: attribute9 igs_fi_pp_std_attrs.attribute9%TYPE,
616: attribute10 igs_fi_pp_std_attrs.attribute10%TYPE,

Line 613: attribute7 igs_fi_pp_std_attrs.attribute7%TYPE,

609: attribute3 igs_fi_pp_std_attrs.attribute3%TYPE,
610: attribute4 igs_fi_pp_std_attrs.attribute4%TYPE,
611: attribute5 igs_fi_pp_std_attrs.attribute5%TYPE,
612: attribute6 igs_fi_pp_std_attrs.attribute6%TYPE,
613: attribute7 igs_fi_pp_std_attrs.attribute7%TYPE,
614: attribute8 igs_fi_pp_std_attrs.attribute8%TYPE,
615: attribute9 igs_fi_pp_std_attrs.attribute9%TYPE,
616: attribute10 igs_fi_pp_std_attrs.attribute10%TYPE,
617: attribute11 igs_fi_pp_std_attrs.attribute11%TYPE,

Line 614: attribute8 igs_fi_pp_std_attrs.attribute8%TYPE,

610: attribute4 igs_fi_pp_std_attrs.attribute4%TYPE,
611: attribute5 igs_fi_pp_std_attrs.attribute5%TYPE,
612: attribute6 igs_fi_pp_std_attrs.attribute6%TYPE,
613: attribute7 igs_fi_pp_std_attrs.attribute7%TYPE,
614: attribute8 igs_fi_pp_std_attrs.attribute8%TYPE,
615: attribute9 igs_fi_pp_std_attrs.attribute9%TYPE,
616: attribute10 igs_fi_pp_std_attrs.attribute10%TYPE,
617: attribute11 igs_fi_pp_std_attrs.attribute11%TYPE,
618: attribute12 igs_fi_pp_std_attrs.attribute12%TYPE,

Line 615: attribute9 igs_fi_pp_std_attrs.attribute9%TYPE,

611: attribute5 igs_fi_pp_std_attrs.attribute5%TYPE,
612: attribute6 igs_fi_pp_std_attrs.attribute6%TYPE,
613: attribute7 igs_fi_pp_std_attrs.attribute7%TYPE,
614: attribute8 igs_fi_pp_std_attrs.attribute8%TYPE,
615: attribute9 igs_fi_pp_std_attrs.attribute9%TYPE,
616: attribute10 igs_fi_pp_std_attrs.attribute10%TYPE,
617: attribute11 igs_fi_pp_std_attrs.attribute11%TYPE,
618: attribute12 igs_fi_pp_std_attrs.attribute12%TYPE,
619: attribute13 igs_fi_pp_std_attrs.attribute13%TYPE,

Line 616: attribute10 igs_fi_pp_std_attrs.attribute10%TYPE,

612: attribute6 igs_fi_pp_std_attrs.attribute6%TYPE,
613: attribute7 igs_fi_pp_std_attrs.attribute7%TYPE,
614: attribute8 igs_fi_pp_std_attrs.attribute8%TYPE,
615: attribute9 igs_fi_pp_std_attrs.attribute9%TYPE,
616: attribute10 igs_fi_pp_std_attrs.attribute10%TYPE,
617: attribute11 igs_fi_pp_std_attrs.attribute11%TYPE,
618: attribute12 igs_fi_pp_std_attrs.attribute12%TYPE,
619: attribute13 igs_fi_pp_std_attrs.attribute13%TYPE,
620: attribute14 igs_fi_pp_std_attrs.attribute14%TYPE,

Line 617: attribute11 igs_fi_pp_std_attrs.attribute11%TYPE,

613: attribute7 igs_fi_pp_std_attrs.attribute7%TYPE,
614: attribute8 igs_fi_pp_std_attrs.attribute8%TYPE,
615: attribute9 igs_fi_pp_std_attrs.attribute9%TYPE,
616: attribute10 igs_fi_pp_std_attrs.attribute10%TYPE,
617: attribute11 igs_fi_pp_std_attrs.attribute11%TYPE,
618: attribute12 igs_fi_pp_std_attrs.attribute12%TYPE,
619: attribute13 igs_fi_pp_std_attrs.attribute13%TYPE,
620: attribute14 igs_fi_pp_std_attrs.attribute14%TYPE,
621: attribute15 igs_fi_pp_std_attrs.attribute15%TYPE,

Line 618: attribute12 igs_fi_pp_std_attrs.attribute12%TYPE,

614: attribute8 igs_fi_pp_std_attrs.attribute8%TYPE,
615: attribute9 igs_fi_pp_std_attrs.attribute9%TYPE,
616: attribute10 igs_fi_pp_std_attrs.attribute10%TYPE,
617: attribute11 igs_fi_pp_std_attrs.attribute11%TYPE,
618: attribute12 igs_fi_pp_std_attrs.attribute12%TYPE,
619: attribute13 igs_fi_pp_std_attrs.attribute13%TYPE,
620: attribute14 igs_fi_pp_std_attrs.attribute14%TYPE,
621: attribute15 igs_fi_pp_std_attrs.attribute15%TYPE,
622: attribute16 igs_fi_pp_std_attrs.attribute16%TYPE,

Line 619: attribute13 igs_fi_pp_std_attrs.attribute13%TYPE,

615: attribute9 igs_fi_pp_std_attrs.attribute9%TYPE,
616: attribute10 igs_fi_pp_std_attrs.attribute10%TYPE,
617: attribute11 igs_fi_pp_std_attrs.attribute11%TYPE,
618: attribute12 igs_fi_pp_std_attrs.attribute12%TYPE,
619: attribute13 igs_fi_pp_std_attrs.attribute13%TYPE,
620: attribute14 igs_fi_pp_std_attrs.attribute14%TYPE,
621: attribute15 igs_fi_pp_std_attrs.attribute15%TYPE,
622: attribute16 igs_fi_pp_std_attrs.attribute16%TYPE,
623: attribute17 igs_fi_pp_std_attrs.attribute17%TYPE,

Line 620: attribute14 igs_fi_pp_std_attrs.attribute14%TYPE,

616: attribute10 igs_fi_pp_std_attrs.attribute10%TYPE,
617: attribute11 igs_fi_pp_std_attrs.attribute11%TYPE,
618: attribute12 igs_fi_pp_std_attrs.attribute12%TYPE,
619: attribute13 igs_fi_pp_std_attrs.attribute13%TYPE,
620: attribute14 igs_fi_pp_std_attrs.attribute14%TYPE,
621: attribute15 igs_fi_pp_std_attrs.attribute15%TYPE,
622: attribute16 igs_fi_pp_std_attrs.attribute16%TYPE,
623: attribute17 igs_fi_pp_std_attrs.attribute17%TYPE,
624: attribute18 igs_fi_pp_std_attrs.attribute18%TYPE,

Line 621: attribute15 igs_fi_pp_std_attrs.attribute15%TYPE,

617: attribute11 igs_fi_pp_std_attrs.attribute11%TYPE,
618: attribute12 igs_fi_pp_std_attrs.attribute12%TYPE,
619: attribute13 igs_fi_pp_std_attrs.attribute13%TYPE,
620: attribute14 igs_fi_pp_std_attrs.attribute14%TYPE,
621: attribute15 igs_fi_pp_std_attrs.attribute15%TYPE,
622: attribute16 igs_fi_pp_std_attrs.attribute16%TYPE,
623: attribute17 igs_fi_pp_std_attrs.attribute17%TYPE,
624: attribute18 igs_fi_pp_std_attrs.attribute18%TYPE,
625: attribute19 igs_fi_pp_std_attrs.attribute19%TYPE,

Line 622: attribute16 igs_fi_pp_std_attrs.attribute16%TYPE,

618: attribute12 igs_fi_pp_std_attrs.attribute12%TYPE,
619: attribute13 igs_fi_pp_std_attrs.attribute13%TYPE,
620: attribute14 igs_fi_pp_std_attrs.attribute14%TYPE,
621: attribute15 igs_fi_pp_std_attrs.attribute15%TYPE,
622: attribute16 igs_fi_pp_std_attrs.attribute16%TYPE,
623: attribute17 igs_fi_pp_std_attrs.attribute17%TYPE,
624: attribute18 igs_fi_pp_std_attrs.attribute18%TYPE,
625: attribute19 igs_fi_pp_std_attrs.attribute19%TYPE,
626: attribute20 igs_fi_pp_std_attrs.attribute20%TYPE);

Line 623: attribute17 igs_fi_pp_std_attrs.attribute17%TYPE,

619: attribute13 igs_fi_pp_std_attrs.attribute13%TYPE,
620: attribute14 igs_fi_pp_std_attrs.attribute14%TYPE,
621: attribute15 igs_fi_pp_std_attrs.attribute15%TYPE,
622: attribute16 igs_fi_pp_std_attrs.attribute16%TYPE,
623: attribute17 igs_fi_pp_std_attrs.attribute17%TYPE,
624: attribute18 igs_fi_pp_std_attrs.attribute18%TYPE,
625: attribute19 igs_fi_pp_std_attrs.attribute19%TYPE,
626: attribute20 igs_fi_pp_std_attrs.attribute20%TYPE);
627:

Line 624: attribute18 igs_fi_pp_std_attrs.attribute18%TYPE,

620: attribute14 igs_fi_pp_std_attrs.attribute14%TYPE,
621: attribute15 igs_fi_pp_std_attrs.attribute15%TYPE,
622: attribute16 igs_fi_pp_std_attrs.attribute16%TYPE,
623: attribute17 igs_fi_pp_std_attrs.attribute17%TYPE,
624: attribute18 igs_fi_pp_std_attrs.attribute18%TYPE,
625: attribute19 igs_fi_pp_std_attrs.attribute19%TYPE,
626: attribute20 igs_fi_pp_std_attrs.attribute20%TYPE);
627:
628: l_dff_seg_values dff_seg_values;

Line 625: attribute19 igs_fi_pp_std_attrs.attribute19%TYPE,

621: attribute15 igs_fi_pp_std_attrs.attribute15%TYPE,
622: attribute16 igs_fi_pp_std_attrs.attribute16%TYPE,
623: attribute17 igs_fi_pp_std_attrs.attribute17%TYPE,
624: attribute18 igs_fi_pp_std_attrs.attribute18%TYPE,
625: attribute19 igs_fi_pp_std_attrs.attribute19%TYPE,
626: attribute20 igs_fi_pp_std_attrs.attribute20%TYPE);
627:
628: l_dff_seg_values dff_seg_values;
629:

Line 626: attribute20 igs_fi_pp_std_attrs.attribute20%TYPE);

622: attribute16 igs_fi_pp_std_attrs.attribute16%TYPE,
623: attribute17 igs_fi_pp_std_attrs.attribute17%TYPE,
624: attribute18 igs_fi_pp_std_attrs.attribute18%TYPE,
625: attribute19 igs_fi_pp_std_attrs.attribute19%TYPE,
626: attribute20 igs_fi_pp_std_attrs.attribute20%TYPE);
627:
628: l_dff_seg_values dff_seg_values;
629:
630: BEGIN

Line 739: desc_flex_name => 'IGS_FI_PP_STD_ATTRS_FLEX',

735: fnd_flex_descval.set_column_value(column_name => 'ATTRIBUTE20',column_value => '');
736:
737: --If DFF is defined with mandatory attributes, then the error message needs to be logged.
738: IF NOT fnd_flex_descval.validate_desccols(appl_short_name => 'IGS',
739: desc_flex_name => 'IGS_FI_PP_STD_ATTRS_FLEX',
740: values_or_ids => 'V',
741: validation_date => SYSDATE) THEN
742: fnd_file.put_line(fnd_file.log,fnd_flex_descval.error_message);
743: l_b_valid_param := FALSE;

Line 911: --For the Person being processed, create a record in the IGS_FI_PP_STD_ATTRS table.

907: --Student Payment Plans Table.
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,

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 1046: CURSOR cur_pp_dtls(cp_n_person_id igs_fi_pp_std_attrs.person_id%TYPE) IS

1042: --The following cursor will fetch a single record(ACTIVE Payment Plan details) if the input parameter to the cursor
1043: --i.e., cp_n_person_id is passed as not null. In case the input parameter to the cursor is passed as null,
1044: --the cursor returns multiple ACTIVE Payment Plan records for different Students.
1045: --(note: One Student Can have only one Active Payment Plan at a time).
1046: CURSOR cur_pp_dtls(cp_n_person_id igs_fi_pp_std_attrs.person_id%TYPE) IS
1047: SELECT a.rowid,a.*
1048: FROM igs_fi_pp_std_attrs a
1049: WHERE (a.person_id = cp_n_person_id OR
1050: cp_n_person_id IS NULL)

Line 1048: FROM igs_fi_pp_std_attrs a

1044: --the cursor returns multiple ACTIVE Payment Plan records for different Students.
1045: --(note: One Student Can have only one Active Payment Plan at a time).
1046: CURSOR cur_pp_dtls(cp_n_person_id igs_fi_pp_std_attrs.person_id%TYPE) IS
1047: SELECT a.rowid,a.*
1048: FROM igs_fi_pp_std_attrs a
1049: WHERE (a.person_id = cp_n_person_id OR
1050: cp_n_person_id IS NULL)
1051: AND a.plan_status_code = g_v_active
1052: FOR UPDATE NOWAIT;

Line 1064: l_v_closed CONSTANT igs_fi_pp_std_attrs.plan_status_code%TYPE := 'CLOSED';

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;
1068: l_v_plan_name CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PLAN_NAME');

Line 1094: --if so, update the Payment Plan status(plan_status_code column) of igs_fi_pp_std_attrs table to a

1090:
1091: --If the Payment Plan Outstanding Balance is less than or equal to the threshold amount parameter,
1092: --passed as input to this process.
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,

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,