eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_RW_ICR_LINES_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 6


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 );

Line: 20


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 );

Line: 32


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 );

Line: 38


 |    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;

Line: 179


       arp_util.debug('arp_rw_icr_line_pkg.update_row()+' );

Line: 256


         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 );

Line: 266


    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  );

Line: 272


       arp_util.debug('arp_rw_icr_line_pkg.update_row()-' );

Line: 278


                arp_util.debug('EXCEPTION: arp_rw_icr_line_pkg.update_row' );

Line: 281


END update_row;

Line: 285


 |    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()+' );

Line: 336


       arp_util.debug('arp_rw_icr_line_pkg.validate_args_update_row()-' );

Line: 342


		 arp_util.debug('EXCEPTION: arp_rw_icr_line_pkg.validate_args_update_row' );

Line: 345


END validate_args_update_row;

Line: 349


 |    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);

Line: 482


       arp_util.debug('arp_rw_icr_line_pkg.insert_row()+' );

Line: 554


        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 );

Line: 565


    arp_cr_icr_lines_pkg.insert_p( l_row_id, l_icr_line_id, l_icr_lines_rec );

Line: 571


       arp_util.debug('arp_rw_icr_line_pkg.insert_row()-' );

Line: 577


                arp_util.debug('EXCEPTION: arp_rw_icr_line_pkg.insert_row' );

Line: 580


END insert_row;

Line: 584


 |    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()+' );

Line: 643


       arp_util.debug( 'arp_rw_icr_line_pkg.validate_args_insert_row()-' );

Line: 649


	        arp_util.debug('EXCEPTION: arp_rw_icr_line_pkg.validate_args_insert_row' );

Line: 652


END validate_args_insert_row;

Line: 656


 |    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()+' );

Line: 695


        arp_rw_icr_lines_pkg.validate_args_delete_row( p_row_id,
						       p_icr_line_id );

Line: 699


    arp_cr_icr_lines_pkg.delete_p( p_icr_id, p_icr_line_id );

Line: 702


       arp_util.debug( 'arp_rw_icr_line_pkg.delete_row()-' );

Line: 708


                 arp_util.debug( 'EXCEPTION: arp_rw_icr_line_pkg.delete_row' );

Line: 711


END delete_row;

Line: 715


 |    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()+' );

Line: 752


       arp_util.debug( 'arp_rw_icr_line_pkg.validate_args_delete_row()-' );

Line: 758


		 arp_util.debug('EXCEPTION: arp_rw_icr_line_pkg.validate_args_delete_row' );

Line: 761


END validate_args_delete_row;

Line: 869


	SELECT *
	FROM ar_interim_cash_receipt_lines
	WHERE rowid = p_row_id
	FOR UPDATE of CASH_RECEIPT_ID NOWAIT;

Line: 880


	FND_MESSAGE.Set_Name(  'FND', 'FORM_RECORD_DELETED');