[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE validate_args_insert_row(
p_row_id IN VARCHAR2,
p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,
p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
p_pay_from_customer IN
ar_interim_cash_receipts.pay_from_customer%TYPE,
p_site_use_id IN
ar_interim_cash_receipts.site_use_id%TYPE,
p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
p_payment_schedule_id IN
ar_payment_schedules.payment_schedule_id%TYPE,
p_currency_code IN ar_interim_cash_receipts.currency_code%TYPE,
p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
p_receipt_method_id IN
ar_interim_cash_receipts.receipt_method_id%TYPE,
p_remittance_bank_account_id IN
ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE );
PROCEDURE validate_args_update_row(
p_row_id IN VARCHAR2,
p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
p_pay_from_customer IN
ar_interim_cash_receipts.pay_from_customer%TYPE,
p_site_use_id IN
ar_interim_cash_receipts.site_use_id%TYPE,
p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
p_payment_schedule_id IN
ar_payment_schedules.payment_schedule_id%TYPE,
p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
p_receipt_method_id IN
ar_interim_cash_receipts.receipt_method_id%TYPE,
p_remittance_bank_account_id IN
ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE );
PROCEDURE update_bank_account_uses(
p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
p_bank_account_id IN ar_batches.remit_bank_acct_use_id%TYPE );
| update_row - Update a row in the AR_ICR table after checking for|
| uniqueness |
| |
| DESCRIPTION |
| This function updates a row in AR_ICR table after checking for |
| uniqueness for items of the receipt |
| |
| SCOPE - PUBLIC |
| |
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
| arp_util.debug - debug procedure |
| |
| ARGUMENTS : IN: |
| p_row_id - Row ID |
| p_cr_id - Cash receipt Id |
| p_receipt_number - Receipt Number |
| p_gl_date - GL Date |
| p_customer_id - Customer ID |
| p_receipt_amount - Receipt Amount |
| p_module_name - Module that called this procedure |
| p_module_version - Version of the module that called this |
| procedure |
| OUT: |
| |
| RETURNS : NONE |
| |
| NOTES - This procedure calls the check_unique_receipt procedure |
| |
| MODIFICATION HISTORY - 08/08/95 - Created by Ganesh Vaidee |
| |
| 10-21-96 OSTEINME Added new parameters p_factor_discount_amount|
| and p_customer_bank_account_id for Japan |
| project. |
| Also added new parameter |
| p_anticipated_clearing_date for bug 371373 |
| 10-28-96 OSTEINME added new parameter customer_bank_branch_id |
| 08-25-97 KLAWRANC Bug fix #462056. |
| Uncommented out NOCOPY call to update_bank_uses. |
| Changed call to pass |
| p_customer_bank_account_id. |
| 10-28-98 K.Murphy Cross Currency Lockbox. Added amount_applied |
| and trans_to_receipt_rate as parameters and updated|
| columns. |
| 12-24-98 D.Jancis Bug 750400: Added GL_DATE as it was not |
| being passed in thus not getting updated |
| 05-01-02 D.Jancis Enh 2074220: added application notes |
| procedures. |
| 12-24-02 K.Dhaliwal Bug 2707190 Added |
| application_ref_type,customer_reference and|
| customer_reason to update and insert |
| procedures. |
+===========================================================================*/
-- Bug fix: 597519 12/18/97
-- Problem: rate information is not being passed to server on commit
-- Changes: passing parameters exchange date, exchange rate and
-- exchange rate type to PROCEDURE update_row
--
PROCEDURE update_row(
p_row_id IN VARCHAR2,
p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
p_amount_applied IN
ar_interim_cash_receipts.amount_applied%TYPE,
p_trans_to_receipt_rate IN
ar_interim_cash_receipts.trans_to_receipt_rate%TYPE,
p_factor_discount_amount IN
ar_interim_cash_receipts.factor_discount_amount%TYPE,
p_receipt_method_id IN
ar_interim_cash_receipts.receipt_method_id%TYPE,
p_remittance_bank_account_id IN
ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,
p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
p_payment_schedule_id IN
ar_payment_schedules.payment_schedule_id%TYPE,
p_pay_from_customer IN
ar_interim_cash_receipts.pay_from_customer%TYPE,
p_customer_bank_account_id IN
ar_interim_cash_receipts.customer_bank_account_id%TYPE,
p_customer_bank_branch_id IN
ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
p_site_use_id IN ar_interim_cash_receipts.site_use_id%TYPE,
p_ussgl_transaction_code IN
ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
p_doc_sequence_id IN ar_interim_cash_receipts.doc_sequence_id%TYPE,
p_doc_sequence_value IN
ar_interim_cash_receipts.doc_sequence_value%TYPE,
p_anticipated_clearing_date IN
ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
p_attribute_category IN
ar_interim_cash_receipts.attribute_category%TYPE,
p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,
p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,
p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,
p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,
p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,
p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,
-- Bug fix: 597519 12/18/97
p_exchange_date IN ar_interim_cash_receipts.exchange_date%TYPE,
p_exchange_rate IN ar_interim_cash_receipts.exchange_rate%TYPE,
p_exchange_rate_type IN
ar_interim_cash_receipts.exchange_rate_type%TYPE,
-- Bug fix: 750400 12/24/98
p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
-- enh 2074220
p_application_notes IN
ar_interim_cash_receipts.application_notes%TYPE,
p_application_ref_type IN
ar_interim_cash_receipts.application_ref_type%TYPE,
p_customer_reference IN
ar_interim_cash_receipts.customer_reference%TYPE,
p_customer_reason IN ar_interim_cash_receipts.customer_reason%TYPE,
p_automatch_set_id IN ar_interim_cash_receipts.automatch_set_id%TYPE,
p_autoapply_flag IN ar_interim_cash_receipts.autoapply_flag%TYPE,
p_module_name IN VARCHAR2,
p_module_version IN VARCHAR2 ) IS
--
l_icr_rec ar_interim_cash_receipts%ROWTYPE;
arp_util.debug( 'arp_rw_icr_pkg.update_row()+' );
validate_args_update_row( p_row_id, l_icr_rec.cash_receipt_id,
l_icr_rec.special_type,
l_icr_rec.receipt_number,
l_icr_rec.batch_id,
l_icr_rec.pay_from_customer,
l_icr_rec.site_use_id,
l_icr_rec.customer_trx_id,
l_icr_rec.payment_schedule_id,
l_icr_rec.amount,
l_icr_rec.receipt_method_id,
l_icr_rec.remit_bank_acct_use_id );
arp_cr_icr_pkg.update_p( l_icr_rec, l_icr_rec.cash_receipt_id );
arp_rw_batches_check_pkg.update_batch_status( p_batch_id );
arp_util.debug( 'arp_rw_icr_pkg.update_row()-' );
arp_util.debug( 'EXCEPTION: arp_rw_icr_pkg.update_row' );
END update_row;
| validate_args_update_row |
| |
| DESCRIPTION |
| Validate arguments passed to update_row procedure |
| |
| SCOPE - PRIVATE |
| |
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
| arp_util.debug - debug procedure |
| |
| ARGUMENTS : IN: |
| p_receipt_number - Receipt Number |
| p_gl_date - GL Date |
| p_customer_id - Customer ID |
| p_receipt_amount - Receipt Amount |
| OUT: |
| |
| RETURNS : NONE |
| |
| NOTES - |
| |
| MODIFICATION HISTORY - Created by Ganesh Vaidee - 08/08/95 |
| |
+===========================================================================*/
PROCEDURE validate_args_update_row(
p_row_id IN VARCHAR2,
p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
p_pay_from_customer IN
ar_interim_cash_receipts.pay_from_customer%TYPE,
p_site_use_id IN
ar_interim_cash_receipts.site_use_id%TYPE,
p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
p_payment_schedule_id IN
ar_payment_schedules.payment_schedule_id%TYPE,
p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
p_receipt_method_id IN
ar_interim_cash_receipts.receipt_method_id%TYPE,
p_remittance_bank_account_id IN
ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE ) IS
BEGIN
IF PG_DEBUG in ('Y', 'C') THEN
arp_util.debug( 'arp_rw_icr_pkg.validate_args_update_row()+' );
arp_util.debug( 'arp_rw_icr_pkg.validate_args_update_row()-' );
'EXCEPTION: arp_rw_icr_pkg.validate_args_update_row' );
END validate_args_update_row;
| insert_row - Inserts a row into the QRC_ICR table after checking for|
| uniqueness |
| |
| DESCRIPTION |
| This function Inserts a row into the QRC_ICR table after checking for |
| uniqueness for items such of the receipt number |
| |
| SCOPE - PUBLIC |
| |
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
| arp_util.debug - debug procedure |
| |
| ARGUMENTS : IN: |
| p_receipt_number - Receipt Number |
| p_gl_date - GL Date |
| p_customer_id - Customer ID |
| p_receipt_amount - Receipt Amount |
| p_module_name - Module that called this procedure |
| p_module_version - Version of the module that called this |
| procedure |
| OUT: |
| p_row_id - Row ID |
| p_cr_id - Cash receipt Id |
| |
| RETURNS : NONE |
| |
| NOTES - This procedure calls the check_unique_receipt procedure |
| |
| MODIFICATION HISTORY - 08/08/95 - Created by Ganesh Vaidee |
| 10-21-96 OSTEINME Added new parameters p_factor_discount_amount|
| and p_customer_bank_account_id for Japan |
| project. |
| Also added new parameter |
| p_anticipated_clearing_date for bug 371373 |
| 10-28-96 OSTEINME added parameter customer_bank_branch_id |
| 10-28-98 K.Murphy Cross Currency Lockbox. Added amount_applied |
| and trans_to_receipt_rate as parameters and created|
| columns. |
| 05-01-02 D.Jancis Enh 2074220: added application notes |
| 12-24-02 K.Dhaliwal Bug 2707190 Added |
| application_ref_type,customer_reference and|
| customer_reason to update and insert |
| procedures. |
+===========================================================================*/
PROCEDURE insert_row(
p_row_id IN OUT NOCOPY VARCHAR2,
p_cr_id IN OUT NOCOPY ar_interim_cash_receipts.cash_receipt_id%TYPE,
p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
p_currency_code IN ar_interim_cash_receipts.currency_code%TYPE,
p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
p_amount_applied IN
ar_interim_cash_receipts.amount_applied%TYPE,
p_trans_to_receipt_rate IN
ar_interim_cash_receipts.trans_to_receipt_rate%TYPE,
p_factor_discount_amount
IN ar_interim_cash_receipts.factor_discount_amount%TYPE,
p_receipt_method_id IN
ar_interim_cash_receipts.receipt_method_id%TYPE,
p_remittance_bank_account_id IN
ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,
p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
p_payment_schedule_id IN
ar_payment_schedules.payment_schedule_id%TYPE,
p_exchange_date IN ar_interim_cash_receipts.exchange_date%TYPE,
p_exchange_rate IN ar_interim_cash_receipts.exchange_rate%TYPE,
p_exchange_rate_type IN
ar_interim_cash_receipts.exchange_rate_type%TYPE,
p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
p_anticipated_clearing_date IN
ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
p_pay_from_customer IN
ar_interim_cash_receipts.pay_from_customer%TYPE,
p_customer_bank_account_id IN
ar_interim_cash_receipts.customer_bank_account_id%TYPE,
p_customer_bank_branch_id IN
ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,
p_site_use_id IN ar_interim_cash_receipts.site_use_id%TYPE,
p_ussgl_transaction_code IN
ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
p_doc_sequence_id IN ar_interim_cash_receipts.doc_sequence_id%TYPE,
p_doc_sequence_value IN
ar_interim_cash_receipts.doc_sequence_value%TYPE,
p_attribute_category IN
ar_interim_cash_receipts.attribute_category%TYPE,
p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,
p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,
p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,
p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,
p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,
p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,
p_application_notes IN
ar_interim_cash_receipts.application_notes%TYPE,
p_application_ref_type IN
ar_interim_cash_receipts.application_ref_type%TYPE,
p_customer_reference IN
ar_interim_cash_receipts.customer_reference%TYPE,
p_customer_reason IN ar_interim_cash_receipts.customer_reason%TYPE,
p_automatch_set_id IN ar_interim_cash_receipts.automatch_set_id%TYPE,
p_autoapply_flag IN ar_interim_cash_receipts.autoapply_flag%TYPE,
p_module_name IN VARCHAR2,
p_module_version IN VARCHAR2 ) IS
--
l_row_id VARCHAR2(30);
arp_util.debug( 'arp_rw_icr_pkg.insert_row()+' );
validate_args_insert_row( p_row_id, p_cr_id,
l_icr_rec.special_type,
l_icr_rec.receipt_number,
l_icr_rec.receipt_date,
l_icr_rec.gl_date,
l_icr_rec.batch_id,
l_icr_rec.pay_from_customer,
l_icr_rec.site_use_id,
l_icr_rec.customer_trx_id,
l_icr_rec.payment_schedule_id,
l_icr_rec.currency_code,
l_icr_rec.amount,
l_icr_rec.receipt_method_id,
l_icr_rec.remit_bank_acct_use_id );
arp_cr_icr_pkg.insert_p( l_row_id, l_cr_id, l_icr_rec );
arp_rw_batches_check_pkg.update_batch_status( l_icr_rec.batch_id );
arp_util.debug( 'arp_rw_icr_pkg.insert_row()-' );
arp_util.debug( 'EXCEPTION: arp_rw_icr_pkg.insert_row' );
END insert_row;
| validate_args_insert_row |
| |
| DESCRIPTION |
| Validate arguments passed to insert_row procedure |
| |
| SCOPE - PRIVATE |
| |
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
| arp_util.debug - debug procedure |
| |
| ARGUMENTS : IN: |
| p_receipt_number - Receipt Number |
| p_gl_date - GL Date |
| p_pay_from_customer - Customer ID |
| p_receipt_amount - Receipt Amount |
| OUT: |
| |
| RETURNS : NONE |
| |
| NOTES - |
| |
| MODIFICATION HISTORY - Created by Ganesh Vaidee - 08/08/95 |
| |
+===========================================================================*/
PROCEDURE validate_args_insert_row(
p_row_id IN VARCHAR2,
p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,
p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
p_pay_from_customer IN
ar_interim_cash_receipts.pay_from_customer%TYPE,
p_site_use_id IN
ar_interim_cash_receipts.site_use_id%TYPE,
p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
p_payment_schedule_id IN
ar_payment_schedules.payment_schedule_id%TYPE,
p_currency_code IN ar_interim_cash_receipts.currency_code%TYPE,
p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
p_receipt_method_id IN
ar_interim_cash_receipts.receipt_method_id%TYPE,
p_remittance_bank_account_id IN
ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE ) IS
BEGIN
IF PG_DEBUG in ('Y', 'C') THEN
arp_util.debug( 'arp_rw_icr_pkg.validate_args_insert_row()+' );
arp_util.debug( 'arp_rw_icr_pkg.validate_args_insert_row()-' );
'EXCEPTION: arp_rw_icr_pkg.validate_args_insert_row' );
END validate_args_insert_row;
| Modified selection of the total applied |
| amount. This needs to consider the amount |
| applied from which will hold the amount in |
| receipt currency for cross currency apps. |
+===========================================================================*/
PROCEDURE get_applied_amount_total(
p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
p_applied_amount_total OUT NOCOPY ar_interim_cash_receipts.amount%TYPE,
p_applied_count_total OUT NOCOPY NUMBER,
p_module_name IN VARCHAR2,
p_module_version IN VARCHAR2 ) IS
BEGIN
IF PG_DEBUG in ('Y', 'C') THEN
arp_util.debug( 'arp_rw_icr_pkg.get_applied_amount_total()+' );
SELECT sum(nvl(amount_applied_from, nvl(payment_amount,0))), count(*)
INTO p_applied_amount_total,
p_applied_count_total
FROM ar_interim_cash_receipt_lines
WHERE cash_receipt_id = p_cr_id;
SELECT COUNT(*)
INTO l_count
FROM ar_interim_cash_receipts icr
WHERE ( p_row_id IS NULL
OR icr.rowid <> p_row_id )
AND ( p_cr_id IS NULL
OR icr.cash_receipt_id <> p_cr_id )
AND icr.receipt_number = p_receipt_number
AND icr.pay_from_customer = p_customer_id
AND icr.amount = p_receipt_amount
AND icr.factor_discount_amount = p_factor_discount_amount;
SELECT COUNT(*)
INTO l_count
FROM ar_cash_receipts cr
WHERE ( p_cr_id IS NULL
OR cr.cash_receipt_id <> p_cr_id )
AND cr.receipt_number = p_receipt_number
AND cr.pay_from_customer = p_customer_id
AND cr.amount = p_receipt_amount+p_factor_discount_amount
AND cr.reversal_category IS NULL;
SELECT count(*)
INTO l_count
FROM ar_interim_cash_receipt_lines icr
WHERE icr.cash_receipt_id = p_cr_id;
| update_bank_account_uses - Update ap_bank_account_uses table |
| |
| DESCRIPTION |
| Update ap_bank_account_uses table with passed in customer_id |
| |
| SCOPE - PRIVATE |
| |
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
| arp_util.debug - debug procedure |
| |
| ARGUMENTS : IN: |
| p_customer_id - customer id |
| p_bank_account_id - bank_account Id |
| |
| RETURNS : NONE |
| |
| NOTES - This procedure will be called by update_row procedure |
| |
| MODIFICATION HISTORY - 08/09/95 - Created by Ganesh Vaidee |
| |
+===========================================================================*/
PROCEDURE update_bank_account_uses(
p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
p_bank_account_id IN ar_batches.remit_bank_acct_use_id%TYPE ) IS
BEGIN
IF PG_DEBUG in ('Y', 'C') THEN
arp_util.debug( 'arp_rw_icr_pkg.update_bank_account_uses()+' );
arp_util.debug('update_bank_account_uses: ' || 'Customer ID : '||p_customer_id );
arp_util.debug('update_bank_account_uses: ' || 'Bank Account Id : '||p_bank_account_id );
arp_util.debug( 'arp_rw_icr_pkg.update_bank_account_uses()-' );
END update_bank_account_uses;
| delete_row - Deletes a row from the QRC_ICR table |
| |
| |
| DESCRIPTION |
| This function deletes a row from AR_INTERIM_CASH_RECEIPTS. |
| |
| |
| SCOPE - PUBLIC |
| |
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
| arp_util.debug - debug procedure |
| |
| ARGUMENTS : IN: |
| p_cr_id - Cash Receipt ID |
| p_row_id - Row Id |
| p_module_name - Module that called this procedure |
| p_module_version - Version of the module that called this |
| procedure |
| OUT: |
| |
| RETURNS : NONE |
| |
| NOTES - |
| |
| MODIFICATION HISTORY - 08/08/95 - Created by Ganesh Vaidee |
| 10-21-96 OSTEINME updated comments |
+===========================================================================*/
PROCEDURE delete_row(
p_row_id IN VARCHAR2,
p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
p_module_name IN VARCHAR2,
p_module_version IN VARCHAR2 ) IS
BEGIN
IF PG_DEBUG in ('Y', 'C') THEN
arp_util.debug( 'arp_rw_icr_pkg.delete_row()+' );
arp_cr_icr_lines_pkg.delete_fk( p_cr_id );
arp_cr_icr_pkg.delete_p( p_cr_id );
arp_util.debug( 'arp_rw_icr_pkg.delete_row()-' );
arp_util.debug('delete_row: ' ||
'EXCEPTION: arp_rw_icr_pkg.delete_row' );
END delete_row;
SELECT *
FROM ar_interim_cash_receipts
WHERE rowid = p_row_id
FOR UPDATE of CASH_RECEIPT_ID NOWAIT;
FND_MESSAGE.Set_Name( 'FND', 'FORM_RECORD_DELETED');