[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT fc.rowid, fc.*
FROM igs_fi_credits_all fc
WHERE credit_instrument = cp_cc
AND credit_card_status_code = cp_pending
AND credit_card_tangible_cd IS NOT NULL
FOR UPDATE NOWAIT;
SELECT aar.rowid, aar.*
FROM igs_ad_app_req aar
WHERE credit_card_number IS NOT NULL
AND credit_card_status_code = cp_pending
AND credit_card_tangible_cd IS NOT NULL
FOR UPDATE NOWAIT;
SELECT status
FROM iby_trans_all_v
WHERE tangibleid = cp_tangible_id AND
payeeid = cp_payee_id AND
reqtype = cp_capture
ORDER BY reqdate DESC;
SELECT party_number
FROM hz_parties
WHERE party_id = cp_person_id;
igs_fi_credits_pkg.update_row(
x_rowid => p_r_crd_row.rowid,
x_credit_id => p_r_crd_row.credit_id,
x_credit_number => p_r_crd_row.credit_number,
x_status => p_r_crd_row.status,
x_credit_source => p_r_crd_row.credit_source,
x_party_id => p_r_crd_row.party_id,
x_credit_type_id => p_r_crd_row.credit_type_id,
x_credit_instrument => p_r_crd_row.credit_instrument,
x_description => p_r_crd_row.description,
x_amount => p_r_crd_row.amount,
x_currency_cd => p_r_crd_row.currency_cd,
x_exchange_rate => p_r_crd_row.exchange_rate,
x_transaction_date => p_r_crd_row.transaction_date,
x_effective_date => p_r_crd_row.effective_date,
x_reversal_date => p_r_crd_row.reversal_date,
x_reversal_reason_code => p_r_crd_row.reversal_reason_code,
x_reversal_comments => p_r_crd_row.reversal_comments,
x_unapplied_amount => p_r_crd_row.unapplied_amount,
x_source_transaction_id => p_r_crd_row.source_transaction_id,
x_receipt_lockbox_number => p_r_crd_row.receipt_lockbox_number,
x_merchant_id => p_r_crd_row.merchant_id,
x_credit_card_code => p_r_crd_row.credit_card_code,
x_credit_card_holder_name => p_r_crd_row.credit_card_holder_name,
x_credit_card_number => p_r_crd_row.credit_card_number,
x_credit_card_expiration_date => p_r_crd_row.credit_card_expiration_date,
x_credit_card_approval_code => p_r_crd_row.credit_card_approval_code,
x_awd_yr_cal_type => p_r_crd_row.awd_yr_cal_type,
x_awd_yr_ci_sequence_number => p_r_crd_row.awd_yr_ci_sequence_number,
x_fee_cal_type => p_r_crd_row.fee_cal_type,
x_fee_ci_sequence_number => p_r_crd_row.fee_ci_sequence_number,
x_attribute_category => p_r_crd_row.attribute_category,
x_attribute1 => p_r_crd_row.attribute1,
x_attribute2 => p_r_crd_row.attribute2,
x_attribute3 => p_r_crd_row.attribute3,
x_attribute4 => p_r_crd_row.attribute4,
x_attribute5 => p_r_crd_row.attribute5,
x_attribute6 => p_r_crd_row.attribute6,
x_attribute7 => p_r_crd_row.attribute7,
x_attribute8 => p_r_crd_row.attribute8,
x_attribute9 => p_r_crd_row.attribute9,
x_attribute10 => p_r_crd_row.attribute10,
x_attribute11 => p_r_crd_row.attribute11,
x_attribute12 => p_r_crd_row.attribute12,
x_attribute13 => p_r_crd_row.attribute13,
x_attribute14 => p_r_crd_row.attribute14,
x_attribute15 => p_r_crd_row.attribute15,
x_attribute16 => p_r_crd_row.attribute16,
x_attribute17 => p_r_crd_row.attribute17,
x_attribute18 => p_r_crd_row.attribute18,
x_attribute19 => p_r_crd_row.attribute19,
x_attribute20 => p_r_crd_row.attribute20,
x_gl_date => p_r_crd_row.gl_date,
x_check_number => p_r_crd_row.check_number,
x_source_transaction_type => p_r_crd_row.source_transaction_type,
x_source_transaction_ref => p_r_crd_row.source_transaction_ref,
x_credit_card_status_code => l_c_cc_status,
x_credit_card_payee_cd => p_r_crd_row.credit_card_payee_cd,
x_credit_card_tangible_cd => p_r_crd_row.credit_card_tangible_cd,
x_source_invoice_id => p_r_crd_row.source_invoice_id,
x_tax_year_code => p_r_crd_row.tax_year_code,
x_waiver_name => p_r_crd_row.waiver_name
);
igs_ad_gen_015.update_igs_ad_app_req(
p_rowid => p_r_ad_app_row.rowid,
p_app_req_id => p_r_ad_app_row.app_req_id,
p_person_id => p_r_ad_app_row.person_id,
p_admission_appl_number => p_r_ad_app_row.admission_appl_number,
p_applicant_fee_type => p_r_ad_app_row.applicant_fee_type,
p_applicant_fee_status => p_r_ad_app_row.applicant_fee_status,
p_fee_date => p_r_ad_app_row.fee_date,
p_fee_payment_method => p_r_ad_app_row.fee_payment_method,
p_fee_amount => p_r_ad_app_row.fee_amount,
p_reference_num => p_r_ad_app_row.reference_num,
p_credit_card_code => p_r_ad_app_row.credit_card_code,
p_credit_card_holder_name => p_r_ad_app_row.credit_card_holder_name,
p_credit_card_number => p_r_ad_app_row.credit_card_number,
p_credit_card_expiration_date => p_r_ad_app_row.credit_card_expiration_date,
p_rev_gl_ccid => p_r_ad_app_row.rev_gl_ccid,
p_cash_gl_ccid => p_r_ad_app_row.cash_gl_ccid,
p_rev_account_cd => p_r_ad_app_row.rev_account_cd,
p_cash_account_cd => p_r_ad_app_row.cash_account_cd,
p_posting_control_id => p_r_ad_app_row.posting_control_id,
p_gl_date => p_r_ad_app_row.gl_date,
p_gl_posted_date => p_r_ad_app_row.gl_posted_date,
p_credit_card_tangible_cd => p_r_ad_app_row.credit_card_tangible_cd,
p_credit_card_payee_cd => p_r_ad_app_row.credit_card_payee_cd,
p_credit_card_status_code => l_c_cc_status,
p_mode => 'R'
);