APPS.ARP_RATE_ADJUSTMENTS_PKG SQL Statements

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

Line: 7

PROCEDURE insert_p(
	p_radj_rec 	IN ar_rate_adjustments%ROWTYPE,
	p_radj_id	OUT NOCOPY  ar_rate_adjustments.rate_adjustment_id%TYPE ) IS
l_radj_id	ar_rate_adjustments.rate_adjustment_id%TYPE;

Line: 13

       arp_standard.debug( 'arp_rate_adjustments_pkg.insert_p()+' );

Line: 16

      SELECT AR_RATE_ADJUSTMENTS_s.nextval
      INTO   l_radj_id
      FROM   dual;

Line: 20

      INSERT INTO  AR_RATE_ADJUSTMENTS (
		rate_adjustment_id,
		cash_receipt_id,
		gain_loss,
		gl_date,
		new_exchange_date,
		new_exchange_rate,
		new_exchange_rate_type,
		old_exchange_date,
		old_exchange_rate,
		old_exchange_rate_type,
		gl_posted_date,
		posting_control_id,
		created_from,
 		    attribute_category,
 		    attribute1,
 		    attribute2,
 		    attribute3,
 		    attribute4,
 		    attribute5,
 		    attribute6,
 		    attribute7,
 		    attribute8,
 		    attribute9,
 		    attribute10,
 		    attribute11,
 		    attribute12,
 		    attribute13,
 		    attribute14,
 		    attribute15,
 		   request_id,
 		   program_application_id,
 		   program_id,
 		   program_update_date,
 		   created_by,
 		   creation_date,
 		   last_updated_by,
 		   last_update_date,
 		   last_update_login
                   ,org_id
 		 )
       VALUES (    l_radj_id,
                   p_radj_rec.cash_receipt_id,
                   p_radj_rec.gain_loss,
                   p_radj_rec.gl_date,
                   p_radj_rec.new_exchange_date,
                   p_radj_rec.new_exchange_rate,
                   p_radj_rec.new_exchange_rate_type,
                   p_radj_rec.old_exchange_date,
                   p_radj_rec.old_exchange_rate,
                   p_radj_rec.old_exchange_rate_type,
                   p_radj_rec.gl_posted_date,
                   p_radj_rec.posting_control_id,
                   p_radj_rec.created_from,
 		   p_radj_rec.attribute_category,
 		   p_radj_rec.attribute1,
 		   p_radj_rec.attribute2,
 		   p_radj_rec.attribute3,
 		   p_radj_rec.attribute4,
 		   p_radj_rec.attribute5,
 		   p_radj_rec.attribute6,
 		   p_radj_rec.attribute7,
 		   p_radj_rec.attribute8,
 		   p_radj_rec.attribute9,
 		   p_radj_rec.attribute10,
 		   p_radj_rec.attribute11,
 		   p_radj_rec.attribute12,
 		   p_radj_rec.attribute13,
 		   p_radj_rec.attribute14,
 		   p_radj_rec.attribute15,
 		   NVL( arp_standard.profile.request_id,
			p_radj_rec.request_id ),
 		   NVL( arp_standard.profile.program_application_id,
			p_radj_rec.program_application_id ),
 		   NVL( arp_standard.profile.program_id,
			p_radj_rec.program_id ),
		   DECODE( arp_standard.profile.program_id,
                           NULL, NULL,
                           SYSDATE
                         ),
		   arp_standard.profile.user_id,
 		   SYSDATE,
		   arp_standard.profile.user_id,
 		   SYSDATE,
		   NVL( arp_standard.profile.last_update_login,
		        p_radj_rec.last_update_login )
                  ,arp_standard.sysparm.org_id /* SSA changes anuj */
	       );

Line: 115

                        p_event_mode        => 'INSERT',
                        p_table_name        => 'AR_RATE_ADJUSTMENTS',
                        p_mode		    => 'SINGLE',
                        p_key_value         => l_radj_id
                       );

Line: 124

       arp_standard.debug( 'arp_rate_adjustments_pkg.insert_p()+' );

Line: 129

	       arp_standard.debug( 'EXCEPTION: arp_rate_adjustments_pkg.insert_p' );

Line: 132

END insert_p;