[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT manage_accounts
FROM igs_fi_control_all;
SELECT party_number
FROM hz_parties
WHERE party_id = cp_party_id;
SELECT inv.person_id,
inv.fee_type,
inv.course_cd,
inv.invoice_creation_date,
inv.fee_cat,
inv.fee_ci_sequence_number,
inv.fee_cal_type,
inv.effective_date,
inv.waiver_flag,
inv.waiver_reason,
inv.attendance_type,
inv.attendance_mode,
inv.currency_cd,
inv.invoice_amount charge_amount,
inv.invoice_number charge_number,
ft.s_fee_type,
invln.row_id invln_rowid,
invln.*
FROM igs_fi_inv_int inv,
igs_fi_invln_int invln,
igs_fi_fee_type ft
WHERE inv.invoice_id = invln.invoice_id
AND inv.fee_type = ft.fee_type
AND ft.s_fee_type IN (g_v_tutnfee,g_v_other,g_v_external,
g_v_ancillary,g_v_sponsor,g_v_aid_adj,g_v_document,
g_v_audit,g_v_special) -- Added audit and special fees.
AND invln.gl_posted_date IS NULL
ORDER BY inv.person_id, ft.s_fee_type, inv.invoice_number
FOR UPDATE OF invln.gl_posted_date NOWAIT;
SELECT crd.credit_id cr_id,
crd.credit_number,
crd.party_id,
crd.transaction_date trans_date,
crd.effective_date,
crd.fee_cal_type,
crd.fee_ci_sequence_number,
crd.currency_cd,
crd.description,
crd.credit_type_id,
crd.source_invoice_id,
cra.*,
cra.rowid cra_rowid,
crt.credit_class
FROM igs_fi_credits crd,
igs_fi_cr_activities cra,
igs_fi_cr_types crt
WHERE crd.credit_id = cra.credit_id
AND crd.credit_type_id = crt.credit_type_id
AND crt.credit_class IN (g_v_chgadj, g_v_spnsp)
AND cra.gl_posted_date IS NULL
FOR UPDATE OF cra.gl_posted_date NOWAIT;
SELECT title
FROM igs_ps_ver
WHERE course_cd = cp_course_cd;
SELECT party_id
FROM igs_fi_credits
WHERE source_invoice_id = cp_invoice_id;
SELECT person_id
FROM igs_fi_inv_int
WHERE invoice_id = cp_source_invoice_id
AND transaction_type = g_v_aid_adj;
igs_fi_com_recs_int_pkg.insert_row ( x_rowid => l_rowid ,
x_transaction_category => 'CHARGE' ,
x_transaction_header_id => l_rec_charges.invoice_id ,
x_transaction_number => l_rec_charges.charge_number ,
x_party_id => l_rec_charges.person_id ,
x_transaction_date => l_rec_charges.invoice_creation_date ,
x_effective_date => l_rec_charges.effective_date ,
x_fee_type => l_rec_charges.fee_type ,
x_s_fee_type => l_rec_charges.s_fee_type ,
x_fee_cal_type => l_rec_charges.fee_cal_type ,
x_fee_ci_sequence_number => l_rec_charges.fee_ci_sequence_number ,
x_fee_category => l_rec_charges.fee_cat ,
x_course_cd => l_rec_charges.course_cd ,
x_attendance_mode => l_rec_charges.attendance_mode ,
x_attendance_type => l_rec_charges.attendance_type ,
x_course_description => l_v_title ,
x_reversal_flag => l_rec_charges.waiver_flag,
x_reversal_reason => l_rec_charges.waiver_reason,
x_line_number => l_rec_charges.line_number,
x_transaction_line_id => l_rec_charges.invoice_lines_id,
x_charge_method_type => l_rec_charges.s_chg_method_type,
x_description => l_rec_charges.description,
x_charge_elements => l_rec_charges.chg_elements,
x_amount => l_rec_charges.amount,
x_credit_points => l_rec_charges.credit_points,
x_unit_offering_option_id => l_rec_charges.uoo_id,
x_cr_gl_code_combination_id => l_rec_charges.rev_gl_ccid,
x_dr_gl_code_combination_id => l_rec_charges.rec_gl_ccid,
x_credit_account_code => l_rec_charges.rev_account_cd,
x_debit_account_code => l_rec_charges.rec_account_cd,
x_org_unit_cd => l_rec_charges.org_unit_cd,
x_location_cd => l_rec_charges.location_cd,
x_gl_date => l_rec_charges.gl_date,
x_credit_type_id => NULL,
x_credit_class => NULL,
x_currency_cd => l_rec_charges.currency_cd,
x_extract_flag => NULL,
x_mode => 'R',
x_student_party_id => l_n_chg_stdnt_party,
x_source_invoice_id => NULL
);
igs_fi_invln_int_pkg.update_row( x_rowid => l_rec_charges.invln_rowid,
x_invoice_id => l_rec_charges.invoice_id,
x_line_number => l_rec_charges.line_number,
x_invoice_lines_id => l_rec_charges.invoice_lines_id,
x_attribute2 => l_rec_charges.attribute2,
x_chg_elements => l_rec_charges.chg_elements,
x_amount => l_rec_charges.amount,
x_unit_attempt_status => l_rec_charges.unit_attempt_status,
x_eftsu => l_rec_charges.eftsu,
x_credit_points => l_rec_charges.credit_points,
x_attribute_category => l_rec_charges.attribute_category,
x_attribute1 => l_rec_charges.attribute1,
x_s_chg_method_type => l_rec_charges.s_chg_method_type,
x_description => l_rec_charges.description,
x_attribute3 => l_rec_charges.attribute3,
x_attribute4 => l_rec_charges.attribute4,
x_attribute5 => l_rec_charges.attribute5,
x_attribute6 => l_rec_charges.attribute6,
x_attribute7 => l_rec_charges.attribute7,
x_attribute8 => l_rec_charges.attribute8,
x_attribute9 => l_rec_charges.attribute9,
x_attribute10 => l_rec_charges.attribute10,
x_rec_account_cd => l_rec_charges.rec_account_cd,
x_rev_account_cd => l_rec_charges.rev_account_cd,
x_rec_gl_ccid => l_rec_charges.rec_gl_ccid,
x_rev_gl_ccid => l_rec_charges.rev_gl_ccid,
x_org_unit_cd => l_rec_charges.org_unit_cd,
x_posting_id => l_rec_charges.posting_id,
x_attribute11 => l_rec_charges.attribute11,
x_attribute12 => l_rec_charges.attribute12,
x_attribute13 => l_rec_charges.attribute13,
x_attribute14 => l_rec_charges.attribute14,
x_attribute15 => l_rec_charges.attribute15,
x_attribute16 => l_rec_charges.attribute16,
x_attribute17 => l_rec_charges.attribute17,
x_attribute18 => l_rec_charges.attribute18,
x_attribute19 => l_rec_charges.attribute19,
x_attribute20 => l_rec_charges.attribute20,
x_error_string => l_rec_charges.error_string,
x_error_account => l_rec_charges.error_account,
x_location_cd => l_rec_charges.location_cd,
x_uoo_id => l_rec_charges.uoo_id,
x_gl_date => l_rec_charges.gl_date,
x_gl_posted_date => TRUNC(SYSDATE),
x_posting_control_id => l_rec_charges.posting_control_id,
x_mode => 'R' ,
x_unit_type_id => l_rec_charges.unit_type_id,
x_unit_level => l_rec_charges.unit_level
);
igs_fi_com_recs_int_pkg.insert_row( x_rowid => l_rowid ,
x_transaction_category => 'CREDIT' ,
x_transaction_header_id => l_rec_credits.cr_id ,
x_transaction_number => l_rec_credits.credit_number ,
x_party_id => l_rec_credits.party_id ,
x_transaction_date => l_rec_credits.trans_date ,
x_effective_date => l_rec_credits.effective_date ,
x_fee_type => NULL,
x_s_fee_type => NULL,
x_fee_cal_type => l_rec_credits.fee_cal_type ,
x_fee_ci_sequence_number => l_rec_credits.fee_ci_sequence_number ,
x_fee_category => NULL,
x_course_cd => NULL,
x_attendance_mode => NULL,
x_attendance_type => NULL,
x_course_description => NULL,
x_reversal_flag => NULL,
x_reversal_reason => NULL,
x_line_number => NULL,
x_transaction_line_id => l_rec_credits.credit_activity_id,
x_charge_method_type => NULL,
x_description => l_rec_credits.description,
x_charge_elements => NULL,
x_amount => l_rec_credits.amount,
x_credit_points => NULL,
x_unit_offering_option_id => NULL,
x_cr_gl_code_combination_id => l_rec_credits.cr_gl_ccid,
x_dr_gl_code_combination_id => l_rec_credits.dr_gl_ccid,
x_credit_account_code => l_rec_credits.cr_account_cd,
x_debit_account_code => l_rec_credits.dr_account_cd,
x_org_unit_cd => NULL,
x_location_cd => NULL,
x_gl_date => l_rec_credits.gl_date,
x_credit_type_id => l_rec_credits.credit_type_id,
x_credit_class => l_rec_credits.credit_class,
x_currency_cd => l_rec_credits.currency_cd,
x_extract_flag => NULL,
x_mode => 'R',
x_student_party_id => l_n_credit_stdnt_party,
x_source_invoice_id => l_rec_credits.source_invoice_id
);
igs_fi_cr_activities_pkg.update_row( x_rowid => l_rec_credits.cra_rowid,
x_credit_activity_id => l_rec_credits.credit_activity_id,
x_credit_id => l_rec_credits.credit_id,
x_status => l_rec_credits.status,
x_transaction_date => l_rec_credits.transaction_date,
x_amount => l_rec_credits.amount,
x_dr_account_cd => l_rec_credits.dr_account_cd,
x_cr_account_cd => l_rec_credits.cr_account_cd,
x_dr_gl_ccid => l_rec_credits.dr_gl_ccid,
x_cr_gl_ccid => l_rec_credits.cr_gl_ccid,
x_bill_id => l_rec_credits.bill_id,
x_bill_number => l_rec_credits.bill_number,
x_bill_date => l_rec_credits.bill_date,
x_posting_id => l_rec_credits.posting_id,
x_gl_date => l_rec_credits.gl_date,
x_gl_posted_date => TRUNC(SYSDATE),
x_posting_control_id => l_rec_credits.posting_control_id,
x_mode => 'R'
);