[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 'x'
FROM igs_pe_persid_group_all
WHERE group_id = cp_n_pers_grp_id
AND TRUNC(create_dt) <= g_d_sysdate
AND NVL(closed_ind,g_v_ind_no) = g_v_ind_no;
SELECT 'x'
FROM igs_fi_pp_std_attrs
WHERE person_id = cp_n_person_id
AND plan_status_code = g_v_active;
SELECT a.rowid,a.*
FROM igs_fi_pp_std_attrs a
WHERE a.person_id = cp_n_person_id
AND a.plan_status_code = g_v_planned
AND a.plan_start_date <= g_d_sysdate
FOR UPDATE NOWAIT;
SELECT 'x'
FROM igs_fi_pp_std_attrs
WHERE person_id = cp_n_person_id
AND student_plan_id <> cp_n_std_plan_id
AND TRUNC(plan_end_date) >= TRUNC(cp_d_start_dt);
SELECT 'x'
FROM igs_fi_pp_instlmnts
WHERE student_plan_id = cp_n_std_plan_id
AND TRUNC(due_date) < g_d_sysdate
AND rownum < 2;
SELECT due_date
FROM igs_fi_pp_instlmnts
WHERE student_plan_id = cp_n_std_plan_id
ORDER BY due_date;
SELECT 'x'
FROM igs_fi_f_typ_ca_inst ftci,
igs_fi_fee_str_stat fst
WHERE ftci.fee_type = cp_v_fee_type
AND ftci.fee_cal_type = cp_v_fee_cal_type
AND ftci.fee_ci_sequence_number = cp_n_fee_ci_seq_number
AND ftci.fee_type_ci_status = fst.fee_structure_status
AND fst.s_fee_structure_status = g_v_active;
igs_fi_pp_std_attrs_pkg.update_row(
x_rowid => rec_cur_pmt_planned.rowid,
x_student_plan_id => rec_cur_pmt_planned.student_plan_id,
x_person_id => rec_cur_pmt_planned.person_id,
x_payment_plan_name => rec_cur_pmt_planned.payment_plan_name,
x_plan_start_date => rec_cur_pmt_planned.plan_start_date,
x_plan_end_date => rec_cur_pmt_planned.plan_end_date,
x_plan_status_code => g_v_active,
x_processing_fee_amt => rec_cur_pmt_planned.processing_fee_amt,
x_processing_fee_type => rec_cur_pmt_planned.processing_fee_type,
x_fee_cal_type => rec_cur_pmt_planned.fee_cal_type,
x_fee_ci_sequence_number => rec_cur_pmt_planned.fee_ci_sequence_number,
x_notes => rec_cur_pmt_planned.notes,
x_invoice_id => rec_cur_pmt_planned.invoice_id,
x_attribute_category => rec_cur_pmt_planned.attribute_category,
x_attribute1 => rec_cur_pmt_planned.attribute1,
x_attribute2 => rec_cur_pmt_planned.attribute2,
x_attribute3 => rec_cur_pmt_planned.attribute3,
x_attribute4 => rec_cur_pmt_planned.attribute4,
x_attribute5 => rec_cur_pmt_planned.attribute5,
x_attribute6 => rec_cur_pmt_planned.attribute6,
x_attribute7 => rec_cur_pmt_planned.attribute7,
x_attribute8 => rec_cur_pmt_planned.attribute8,
x_attribute9 => rec_cur_pmt_planned.attribute9,
x_attribute10 => rec_cur_pmt_planned.attribute10,
x_attribute11 => rec_cur_pmt_planned.attribute11,
x_attribute12 => rec_cur_pmt_planned.attribute12,
x_attribute13 => rec_cur_pmt_planned.attribute13,
x_attribute14 => rec_cur_pmt_planned.attribute14,
x_attribute15 => rec_cur_pmt_planned.attribute15,
x_attribute16 => rec_cur_pmt_planned.attribute16,
x_attribute17 => rec_cur_pmt_planned.attribute17,
x_attribute18 => rec_cur_pmt_planned.attribute18,
x_attribute19 => rec_cur_pmt_planned.attribute19,
x_attribute20 => rec_cur_pmt_planned.attribute20,
x_mode => 'R'
);
SELECT *
FROM igs_fi_pp_templates
WHERE payment_plan_name = cp_v_pmt_plan
AND NVL(closed_flag,g_v_ind_no) = g_v_ind_no;
SELECT *
FROM igs_fi_pp_tmpl_lns
WHERE payment_plan_name = cp_v_pmt_plan;
SELECT 'x'
FROM igs_fi_pp_std_attrs
WHERE person_id = cp_n_person_id
AND plan_status_code = g_v_planned;
SELECT 'x'
FROM igs_fi_pp_std_attrs
WHERE person_id = cp_n_person_id
AND TRUNC(cp_d_start_date) <= TRUNC(plan_end_date);
igs_fi_pp_std_attrs_pkg.insert_row(x_rowid => l_rowid,
x_student_plan_id => l_n_student_plan_id,
x_person_id => l_n_person_id,
x_payment_plan_name => p_v_payment_plan_name,
x_plan_start_date => TRUNC(l_d_start_date),
x_plan_end_date => l_d_prev_due_dt,
x_plan_status_code => g_v_planned,
x_processing_fee_amt => rec_cur_pmt_plan.processing_fee_amt,
x_processing_fee_type => rec_cur_pmt_plan.processing_fee_type,
x_fee_cal_type => l_v_fee_cal_type,
x_fee_ci_sequence_number => l_n_fee_ci_sequence_number,
x_notes => NULL,
x_invoice_id => NULL,
x_attribute_category => NULL,
x_attribute1 => l_dff_seg_values.attribute1,
x_attribute2 => l_dff_seg_values.attribute2,
x_attribute3 => l_dff_seg_values.attribute3,
x_attribute4 => l_dff_seg_values.attribute4,
x_attribute5 => l_dff_seg_values.attribute5,
x_attribute6 => l_dff_seg_values.attribute6,
x_attribute7 => l_dff_seg_values.attribute7,
x_attribute8 => l_dff_seg_values.attribute8,
x_attribute9 => l_dff_seg_values.attribute9,
x_attribute10 => l_dff_seg_values.attribute10,
x_attribute11 => l_dff_seg_values.attribute11,
x_attribute12 => l_dff_seg_values.attribute12,
x_attribute13 => l_dff_seg_values.attribute13,
x_attribute14 => l_dff_seg_values.attribute14,
x_attribute15 => l_dff_seg_values.attribute15,
x_attribute16 => l_dff_seg_values.attribute16,
x_attribute17 => l_dff_seg_values.attribute17,
x_attribute18 => l_dff_seg_values.attribute18,
x_attribute19 => l_dff_seg_values.attribute19,
x_attribute20 => l_dff_seg_values.attribute20,
x_mode => 'R'
);
igs_fi_pp_instlmnts_pkg.insert_row(
x_rowid => l_rowid,
x_installment_id => l_n_installment_id,
x_student_plan_id => l_n_student_plan_id,
x_installment_line_num => l_temp_plsql_tbl(l_n_cnt).plan_line_num,
x_due_day => TO_NUMBER(TO_CHAR(l_temp_plsql_tbl(l_n_cnt).due_date,'DD')),
x_due_month_code => TO_CHAR(l_temp_plsql_tbl(l_n_cnt).due_date,'MON'),
x_due_year => TO_NUMBER(TO_CHAR(l_temp_plsql_tbl(l_n_cnt).due_date,'YYYY')),
x_due_date => TRUNC(l_temp_plsql_tbl(l_n_cnt).due_date),
x_installment_amt => NVL(l_temp_plsql_tbl(l_n_cnt).plan_amount,0),
x_due_amt => NVL(l_temp_plsql_tbl(l_n_cnt).plan_amount,0),
x_penalty_flag => g_v_ind_no,
x_mode => 'R'
);
SELECT a.rowid,a.*
FROM igs_fi_pp_std_attrs a
WHERE (a.person_id = cp_n_person_id OR
cp_n_person_id IS NULL)
AND a.plan_status_code = g_v_active
FOR UPDATE NOWAIT;
SELECT a.rowid,a.*
FROM igs_fi_pp_instlmnts a
WHERE a.student_plan_id = cp_n_std_pln_id
FOR UPDATE NOWAIT;
igs_fi_pp_std_attrs_pkg.update_row(
x_rowid => rec_cur_pp_dtls.rowid,
x_student_plan_id => rec_cur_pp_dtls.student_plan_id,
x_person_id => rec_cur_pp_dtls.person_id,
x_payment_plan_name => rec_cur_pp_dtls.payment_plan_name,
x_plan_start_date => rec_cur_pp_dtls.plan_start_date,
x_plan_end_date => g_d_sysdate,
x_plan_status_code => l_v_closed,
x_processing_fee_amt => rec_cur_pp_dtls.processing_fee_amt,
x_processing_fee_type => rec_cur_pp_dtls.processing_fee_type,
x_fee_cal_type => rec_cur_pp_dtls.fee_cal_type,
x_fee_ci_sequence_number => rec_cur_pp_dtls.fee_ci_sequence_number,
x_notes => rec_cur_pp_dtls.notes,
x_invoice_id => rec_cur_pp_dtls.invoice_id,
x_attribute_category => rec_cur_pp_dtls.attribute_category,
x_attribute1 => rec_cur_pp_dtls.attribute1,
x_attribute2 => rec_cur_pp_dtls.attribute2,
x_attribute3 => rec_cur_pp_dtls.attribute3,
x_attribute4 => rec_cur_pp_dtls.attribute4,
x_attribute5 => rec_cur_pp_dtls.attribute5,
x_attribute6 => rec_cur_pp_dtls.attribute6,
x_attribute7 => rec_cur_pp_dtls.attribute7,
x_attribute8 => rec_cur_pp_dtls.attribute8,
x_attribute9 => rec_cur_pp_dtls.attribute9,
x_attribute10 => rec_cur_pp_dtls.attribute10,
x_attribute11 => rec_cur_pp_dtls.attribute11,
x_attribute12 => rec_cur_pp_dtls.attribute12,
x_attribute13 => rec_cur_pp_dtls.attribute13,
x_attribute14 => rec_cur_pp_dtls.attribute14,
x_attribute15 => rec_cur_pp_dtls.attribute15,
x_attribute16 => rec_cur_pp_dtls.attribute16,
x_attribute17 => rec_cur_pp_dtls.attribute17,
x_attribute18 => rec_cur_pp_dtls.attribute18,
x_attribute19 => rec_cur_pp_dtls.attribute19,
x_attribute20 => rec_cur_pp_dtls.attribute20,
x_mode => 'R');
igs_fi_pp_instlmnts_pkg.update_row(
x_rowid => rec_cur_pp_insts.rowid,
x_installment_id => rec_cur_pp_insts.installment_id,
x_student_plan_id => rec_cur_pp_insts.student_plan_id,
x_installment_line_num => rec_cur_pp_insts.installment_line_num,
x_due_day => rec_cur_pp_insts.due_day,
x_due_month_code => rec_cur_pp_insts.due_month_code,
x_due_year => rec_cur_pp_insts.due_year,
x_due_date => rec_cur_pp_insts.due_date,
x_installment_amt => l_n_inst_bal,
x_due_amt => 0,
x_penalty_flag => rec_cur_pp_insts.penalty_flag,
x_mode => 'R');