The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE validate_args_insert_row(
p_row_id IN VARCHAR2,
p_icr_line_id IN
ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
p_cash_receipt_id IN
ar_interim_cash_receipts.cash_receipt_id%TYPE,
p_payment_schedule_id IN
ar_payment_schedules.payment_schedule_id%TYPE,
p_customer_trx_id IN
ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
p_batch_id IN ar_interim_cash_receipt_lines.batch_id%TYPE,
p_sold_to_customer IN
ar_interim_cash_receipt_lines.sold_to_customer%TYPE );
PROCEDURE validate_args_update_row(
p_row_id IN VARCHAR2,
p_icr_line_id IN
ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
p_payment_schedule_id IN
ar_payment_schedules.payment_schedule_id%TYPE,
p_customer_trx_id IN
ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
p_batch_id IN ar_interim_cash_receipt_lines.batch_id%TYPE,
p_sold_to_customer IN
ar_interim_cash_receipt_lines.sold_to_customer%TYPE );
PROCEDURE validate_args_delete_row(
p_row_id IN VARCHAR2,
p_icr_line_id IN
ar_interim_cash_receipt_lines.cash_receipt_line_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 such of the receipt |
| |
| SCOPE - PUBLIC |
| |
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
| arp_util.debug - debug procedure |
| |
| ARGUMENTS : IN: |
| p_row_id - Row ID |
| p_cr_line_id - Cash receipt line 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 |
| 08-12-97 KTANG add global attributes in parameter list |
| for global descriptive flexfield |
| 10/12/98 DJANCIS Added batch_id to call to update_p as it will be |
| needed to uniquely identify a row in interim |
| cash receipts lines. |
| 10-06-98 K.Murphy Cross Currency Lockbox. Added amount_applied_from |
| and trans_to_receipt_rate as parameters and updated|
| columns. |
| 12-24-02 K.Dhaliwal Bug 2707190 Added |
| application_ref_type,customer_reference and|
| customer_reason to update and insert |
| procedures. |
| 01-20-03 K.Dhaliwal Bug 2707190 Added Applied_Rec_App_ID |
+===========================================================================*/
PROCEDURE update_row(
p_row_id IN VARCHAR2,
p_icr_line_id IN
ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
p_cr_id IN
ar_interim_cash_receipt_lines.cash_receipt_id%TYPE,
p_payment_amount IN
ar_interim_cash_receipt_lines.payment_amount%TYPE,
p_amount_applied_from IN
ar_interim_cash_receipt_lines.amount_applied_from%TYPE,
p_trans_to_receipt_rate IN
ar_interim_cash_receipt_lines.trans_to_receipt_rate%TYPE,
p_payment_schedule_id IN
ar_payment_schedules.payment_schedule_id%TYPE,
p_customer_trx_id IN
ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
p_batch_id IN ar_interim_cash_receipt_lines.batch_id%TYPE,
p_sold_to_customer IN
ar_interim_cash_receipt_lines.sold_to_customer%TYPE,
p_discount_taken IN
ar_interim_cash_receipt_lines.discount_taken%TYPE,
p_due_date IN ar_interim_cash_receipt_lines.due_date%TYPE,
p_ussgl_transaction_code IN
ar_interim_cash_receipt_lines.ussgl_transaction_code%TYPE,
p_attribute_category IN
ar_interim_cash_receipt_lines.attribute_category%TYPE,
p_attribute1 IN ar_interim_cash_receipt_lines.attribute1%TYPE,
p_attribute2 IN ar_interim_cash_receipt_lines.attribute2%TYPE,
p_attribute3 IN ar_interim_cash_receipt_lines.attribute3%TYPE,
p_attribute4 IN ar_interim_cash_receipt_lines.attribute4%TYPE,
p_attribute5 IN ar_interim_cash_receipt_lines.attribute5%TYPE,
p_attribute6 IN ar_interim_cash_receipt_lines.attribute6%TYPE,
p_attribute7 IN ar_interim_cash_receipt_lines.attribute7%TYPE,
p_attribute8 IN ar_interim_cash_receipt_lines.attribute8%TYPE,
p_attribute9 IN ar_interim_cash_receipt_lines.attribute9%TYPE,
p_attribute10 IN ar_interim_cash_receipt_lines.attribute10%TYPE,
p_attribute11 IN ar_interim_cash_receipt_lines.attribute11%TYPE,
p_attribute12 IN ar_interim_cash_receipt_lines.attribute12%TYPE,
p_attribute13 IN ar_interim_cash_receipt_lines.attribute13%TYPE,
p_attribute14 IN ar_interim_cash_receipt_lines.attribute14%TYPE,
p_attribute15 IN ar_interim_cash_receipt_lines.attribute15%TYPE,
p_global_attribute_category IN
ar_interim_cash_receipt_lines.global_attribute_category%TYPE,
p_global_attribute1 IN
ar_interim_cash_receipt_lines.global_attribute1%TYPE,
p_global_attribute2 IN
ar_interim_cash_receipt_lines.global_attribute2%TYPE,
p_global_attribute3 IN
ar_interim_cash_receipt_lines.global_attribute3%TYPE,
p_global_attribute4 IN
ar_interim_cash_receipt_lines.global_attribute4%TYPE,
p_global_attribute5 IN
ar_interim_cash_receipt_lines.global_attribute5%TYPE,
p_global_attribute6 IN
ar_interim_cash_receipt_lines.global_attribute6%TYPE,
p_global_attribute7 IN
ar_interim_cash_receipt_lines.global_attribute7%TYPE,
p_global_attribute8 IN
ar_interim_cash_receipt_lines.global_attribute8%TYPE,
p_global_attribute9 IN
ar_interim_cash_receipt_lines.global_attribute9%TYPE,
p_global_attribute10 IN
ar_interim_cash_receipt_lines.global_attribute10%TYPE,
p_global_attribute11 IN
ar_interim_cash_receipt_lines.global_attribute11%TYPE,
p_global_attribute12 IN
ar_interim_cash_receipt_lines.global_attribute12%TYPE,
p_global_attribute13 IN
ar_interim_cash_receipt_lines.global_attribute13%TYPE,
p_global_attribute14 IN
ar_interim_cash_receipt_lines.global_attribute14%TYPE,
p_global_attribute15 IN
ar_interim_cash_receipt_lines.global_attribute15%TYPE,
p_global_attribute16 IN
ar_interim_cash_receipt_lines.global_attribute16%TYPE,
p_global_attribute17 IN
ar_interim_cash_receipt_lines.global_attribute17%TYPE,
p_global_attribute18 IN
ar_interim_cash_receipt_lines.global_attribute18%TYPE,
p_global_attribute19 IN
ar_interim_cash_receipt_lines.global_attribute19%TYPE,
p_global_attribute20 IN
ar_interim_cash_receipt_lines.global_attribute20%TYPE,
p_application_ref_type IN
ar_interim_cash_receipt_lines.application_ref_type%TYPE,
p_customer_reference IN
ar_interim_cash_receipt_lines.customer_reference%TYPE,
p_customer_reason IN
ar_interim_cash_receipt_lines.customer_reason%TYPE,
p_applied_rec_app_id IN
ar_interim_cash_receipt_lines.applied_rec_app_id%TYPE,
p_module_name IN VARCHAR2,
p_module_version IN VARCHAR2 ) IS
--
l_icr_lines_rec ar_interim_cash_receipt_lines%ROWTYPE;
arp_util.debug('arp_rw_icr_line_pkg.update_row()+' );
arp_rw_icr_lines_pkg.validate_args_update_row( p_row_id,
l_icr_lines_rec.cash_receipt_line_id,
l_icr_lines_rec.payment_schedule_id,
l_icr_lines_rec.customer_trx_id,
l_icr_lines_rec.batch_id,
l_icr_lines_rec.sold_to_customer );
arp_cr_icr_lines_pkg.update_p( l_icr_lines_rec,
l_icr_lines_rec.cash_receipt_line_id,
l_icr_lines_rec.batch_id,
l_icr_lines_rec.cash_receipt_id );
arp_util.debug('arp_rw_icr_line_pkg.update_row()-' );
arp_util.debug('EXCEPTION: arp_rw_icr_line_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_row_id, |
| p_icr_line_id |
| p_payment_schedule_id, |
| p_customer_trx_id, |
| p_batch_id, |
| p_sold_to_customer |
| OUT: |
| |
| RETURNS : NONE |
| |
| NOTES - |
| |
| MODIFICATION HISTORY - Created by Ganesh Vaidee - 08/08/95 |
| |
+===========================================================================*/
PROCEDURE validate_args_update_row(
p_row_id IN VARCHAR2,
p_icr_line_id IN
ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
p_payment_schedule_id IN
ar_payment_schedules.payment_schedule_id%TYPE,
p_customer_trx_id IN
ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
p_batch_id IN ar_interim_cash_receipt_lines.batch_id%TYPE,
p_sold_to_customer IN
ar_interim_cash_receipt_lines.sold_to_customer%TYPE ) IS
BEGIN
IF PG_DEBUG in ('Y', 'C') THEN
arp_util.debug('arp_rw_icr_line_pkg.validate_args_update_row()+' );
arp_util.debug('arp_rw_icr_line_pkg.validate_args_update_row()-' );
arp_util.debug('EXCEPTION: arp_rw_icr_line_pkg.validate_args_update_row' );
END validate_args_update_row;
| insert_row - Inserts a row into the ICR_LINES table after checking |
| uniqueness |
| |
| DESCRIPTION |
| This function Inserts a row into the ICR_LINES 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: |
| procedure |
| OUT: |
| p_row_id - Row ID |
| p_icr_line_id- cash receipt line ID |
| |
| RETURNS : NONE |
| |
| NOTES - |
| |
| MODIFICATION HISTORY - 08/08/95 - Created by Ganesh Vaidee |
| 08-12-97 KTANG add global attributes in parameter list |
| for global descriptive flexfield |
| 10-06-98 K.Murphy Cross Currency Lockbox. Added amount_applied_from |
| and trans_to_receipt_rate as parameters and created|
| columns. |
| 12-24-02 K.Dhaliwal Bug 2707190 Added |
| application_ref_type,customer_reference and|
| customer_reason to update and insert |
| procedures. |
| 01-20-03 K.Dhaliwal Bug 2707190 Added Applied_Rec_App_ID |
+===========================================================================*/
PROCEDURE insert_row(
p_row_id IN OUT NOCOPY VARCHAR2,
p_icr_line_id IN OUT NOCOPY
ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
p_cr_id IN ar_interim_cash_receipt_lines.cash_receipt_id%TYPE,
p_payment_amount IN
ar_interim_cash_receipt_lines.payment_amount%TYPE,
p_amount_applied_from IN
ar_interim_cash_receipt_lines.amount_applied_from%TYPE,
p_trans_to_receipt_rate IN
ar_interim_cash_receipt_lines.trans_to_receipt_rate%TYPE,
p_payment_schedule_id IN
ar_payment_schedules.payment_schedule_id%TYPE,
p_customer_trx_id IN
ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
p_batch_id IN ar_interim_cash_receipt_lines.batch_id%TYPE,
p_sold_to_customer IN
ar_interim_cash_receipt_lines.sold_to_customer%TYPE,
p_discount_taken IN
ar_interim_cash_receipt_lines.discount_taken%TYPE,
p_due_date IN ar_interim_cash_receipt_lines.due_date%TYPE,
p_ussgl_transaction_code IN
ar_interim_cash_receipt_lines.ussgl_transaction_code%TYPE,
p_attribute_category IN
ar_interim_cash_receipt_lines.attribute_category%TYPE,
p_attribute1 IN ar_interim_cash_receipt_lines.attribute1%TYPE,
p_attribute2 IN ar_interim_cash_receipt_lines.attribute2%TYPE,
p_attribute3 IN ar_interim_cash_receipt_lines.attribute3%TYPE,
p_attribute4 IN ar_interim_cash_receipt_lines.attribute4%TYPE,
p_attribute5 IN ar_interim_cash_receipt_lines.attribute5%TYPE,
p_attribute6 IN ar_interim_cash_receipt_lines.attribute6%TYPE,
p_attribute7 IN ar_interim_cash_receipt_lines.attribute7%TYPE,
p_attribute8 IN ar_interim_cash_receipt_lines.attribute8%TYPE,
p_attribute9 IN ar_interim_cash_receipt_lines.attribute9%TYPE,
p_attribute10 IN ar_interim_cash_receipt_lines.attribute10%TYPE,
p_attribute11 IN ar_interim_cash_receipt_lines.attribute11%TYPE,
p_attribute12 IN ar_interim_cash_receipt_lines.attribute12%TYPE,
p_attribute13 IN ar_interim_cash_receipt_lines.attribute13%TYPE,
p_attribute14 IN ar_interim_cash_receipt_lines.attribute14%TYPE,
p_attribute15 IN ar_interim_cash_receipt_lines.attribute15%TYPE,
p_global_attribute_category IN
ar_interim_cash_receipt_lines.global_attribute_category%TYPE,
p_global_attribute1 IN
ar_interim_cash_receipt_lines.global_attribute1%TYPE,
p_global_attribute2 IN
ar_interim_cash_receipt_lines.global_attribute2%TYPE,
p_global_attribute3 IN
ar_interim_cash_receipt_lines.global_attribute3%TYPE,
p_global_attribute4 IN
ar_interim_cash_receipt_lines.global_attribute4%TYPE,
p_global_attribute5 IN
ar_interim_cash_receipt_lines.global_attribute5%TYPE,
p_global_attribute6 IN
ar_interim_cash_receipt_lines.global_attribute6%TYPE,
p_global_attribute7 IN
ar_interim_cash_receipt_lines.global_attribute7%TYPE,
p_global_attribute8 IN
ar_interim_cash_receipt_lines.global_attribute8%TYPE,
p_global_attribute9 IN
ar_interim_cash_receipt_lines.global_attribute9%TYPE,
p_global_attribute10 IN
ar_interim_cash_receipt_lines.global_attribute10%TYPE,
p_global_attribute11 IN
ar_interim_cash_receipt_lines.global_attribute11%TYPE,
p_global_attribute12 IN
ar_interim_cash_receipt_lines.global_attribute12%TYPE,
p_global_attribute13 IN
ar_interim_cash_receipt_lines.global_attribute13%TYPE,
p_global_attribute14 IN
ar_interim_cash_receipt_lines.global_attribute14%TYPE,
p_global_attribute15 IN
ar_interim_cash_receipt_lines.global_attribute15%TYPE,
p_global_attribute16 IN
ar_interim_cash_receipt_lines.global_attribute16%TYPE,
p_global_attribute17 IN
ar_interim_cash_receipt_lines.global_attribute17%TYPE,
p_global_attribute18 IN
ar_interim_cash_receipt_lines.global_attribute18%TYPE,
p_global_attribute19 IN
ar_interim_cash_receipt_lines.global_attribute19%TYPE,
p_global_attribute20 IN
ar_interim_cash_receipt_lines.global_attribute20%TYPE,
p_application_ref_type IN
ar_interim_cash_receipt_lines.application_ref_type%TYPE,
p_customer_reference IN
ar_interim_cash_receipt_lines.customer_reference%TYPE,
p_customer_reason IN
ar_interim_cash_receipt_lines.customer_reason%TYPE,
p_applied_rec_app_id IN
ar_interim_cash_receipt_lines.applied_rec_app_id%TYPE,
p_module_name IN VARCHAR2,
p_module_version IN VARCHAR2 ) IS
--
l_row_id VARCHAR2(30);
arp_util.debug('arp_rw_icr_line_pkg.insert_row()+' );
arp_rw_icr_lines_pkg.validate_args_insert_row( p_row_id,
p_icr_line_id,
l_icr_lines_rec.cash_receipt_id,
l_icr_lines_rec.payment_schedule_id,
l_icr_lines_rec.customer_trx_id,
l_icr_lines_rec.batch_id,
l_icr_lines_rec.sold_to_customer );
arp_cr_icr_lines_pkg.insert_p( l_row_id, l_icr_line_id, l_icr_lines_rec );
arp_util.debug('arp_rw_icr_line_pkg.insert_row()-' );
arp_util.debug('EXCEPTION: arp_rw_icr_line_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_row_id - Row Id |
| p_icr_line_id - ICR Line ID |
| p_cash_receipt_id - ICR ID |
| p_payment_schedule_id - Payment schedules Id |
| p_customer_trx_id - Customer Trx Id |
| p_batch_id - Batch id of the interim cash receipt |
| p_sold_to_customer - Sold to customer ID from the invoice |
| side |
| OUT: |
| |
| RETURNS : NONE |
| |
| NOTES - |
| |
| MODIFICATION HISTORY - Created by Ganesh Vaidee - 08/08/95 |
| |
+===========================================================================*/
PROCEDURE validate_args_insert_row(
p_row_id IN VARCHAR2,
p_icr_line_id IN
ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
p_cash_receipt_id IN
ar_interim_cash_receipts.cash_receipt_id%TYPE,
p_payment_schedule_id IN
ar_payment_schedules.payment_schedule_id%TYPE,
p_customer_trx_id IN
ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
p_batch_id IN ar_interim_cash_receipt_lines.batch_id%TYPE,
p_sold_to_customer IN
ar_interim_cash_receipt_lines.sold_to_customer%TYPE ) IS
BEGIN
IF PG_DEBUG in ('Y', 'C') THEN
arp_util.debug( 'arp_rw_icr_lines_pkg.validate_args_insert_row()+' );
arp_util.debug( 'arp_rw_icr_line_pkg.validate_args_insert_row()-' );
arp_util.debug('EXCEPTION: arp_rw_icr_line_pkg.validate_args_insert_row' );
END validate_args_insert_row;
| delete_row - Deletes a row from the QRC_ICR_LINES table |
| |
| DESCRIPTION |
| This function deletes a row from the QRC_ICR_LINES |
| |
| SCOPE - PUBLIC |
| |
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
| arp_util.debug - debug procedure |
| |
| ARGUMENTS : IN: |
| procedure |
| OUT: |
| p_row_id - Row ID |
| p_icr_line_id- cash receipt line ID |
| |
| RETURNS : NONE |
| |
| NOTES - |
| |
| MODIFICATION HISTORY - 08/08/95 - Created by Ganesh Vaidee |
+===========================================================================*/
PROCEDURE delete_row(
p_row_id IN VARCHAR2,
p_icr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
p_icr_line_id IN
ar_interim_cash_receipt_lines.cash_receipt_line_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_line_pkg.delete_row()+' );
arp_rw_icr_lines_pkg.validate_args_delete_row( p_row_id,
p_icr_line_id );
arp_cr_icr_lines_pkg.delete_p( p_icr_id, p_icr_line_id );
arp_util.debug( 'arp_rw_icr_line_pkg.delete_row()-' );
arp_util.debug( 'EXCEPTION: arp_rw_icr_line_pkg.delete_row' );
END delete_row;
| validate_args_delete_row |
| |
| DESCRIPTION |
| Validate arguments passed to delete_row procedure |
| |
| SCOPE - PRIVATE |
| |
| EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
| arp_util.debug - debug procedure |
| |
| ARGUMENTS : IN: |
| p_row_id - Row Id |
| p_icr_line_id - ICR line ID |
| OUT: |
| |
| RETURNS : NONE |
| |
| NOTES - |
| |
| MODIFICATION HISTORY - Created by Ganesh Vaidee - 08/08/95 |
| |
+===========================================================================*/
PROCEDURE validate_args_delete_row(
p_row_id IN VARCHAR2,
p_icr_line_id IN
ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE ) IS
BEGIN
IF PG_DEBUG in ('Y', 'C') THEN
arp_util.debug( 'arp_rw_icr_lines_pkg.validate_args_delete_row()+' );
arp_util.debug( 'arp_rw_icr_line_pkg.validate_args_delete_row()-' );
arp_util.debug('EXCEPTION: arp_rw_icr_line_pkg.validate_args_delete_row' );
END validate_args_delete_row;
SELECT *
FROM ar_interim_cash_receipt_lines
WHERE rowid = p_row_id
FOR UPDATE of CASH_RECEIPT_ID NOWAIT;
FND_MESSAGE.Set_Name( 'FND', 'FORM_RECORD_DELETED');