APPS.PO_COPYDOC_S6 SQL Statements

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

Line: 28

 PROCEDURE insert_rfq_vendors()
       used in blanket to RFQ copy  - dreddy 1388111
**************************************************************************/

PROCEDURE insert_rfq_vendors(x_po_header_id          IN  NUMBER,
                             x_po_vendor_id          IN  NUMBER,
                             x_po_vendor_site_id     IN  NUMBER,
                             x_po_vendor_contact_Id  IN  NUMBER
                             ) IS

BEGIN
    INSERT INTO PO_RFQ_VENDORS(
                   po_header_id,
                   sequence_num,
                   last_update_date,
                   last_updated_by,
                   last_update_login,
                   creation_date,
                   created_by,
                   vendor_id,
                   vendor_site_id,
                   vendor_contact_id,
                   print_flag,
                   print_count,
                   printed_date,
                   attribute_category,
                   attribute1,
                   attribute2,
                   attribute3,
                   attribute4,
                   attribute5,
                   attribute6,
                   attribute7,
                   attribute8,
                   attribute9,
                   attribute10,
                   attribute11,
                   attribute12,
                   attribute13,
                   attribute14,
                   attribute15
                   ) VALUES  (   x_po_header_id,
				 1,
                               	 sysdate,
                             	 fnd_global.user_id,
                              	 fnd_global.login_id,
                               	 sysdate,
                               	 fnd_global.user_id,
                                 x_po_vendor_id,
                               	 x_po_vendor_site_id,
                               	 x_po_vendor_contact_Id,
				 'Y',
				 null,
                               	 null,
                              	 null,
                               	 null,
                                 null,
                               	 null,
                                 null,
                               	 null,
                                 null,
                               	 null,
                               	 null,
                                 null,
                               	 null,
                                 null,
                               	 null,
                                 null,
                               	 null,
                                 null);

Line: 101

END insert_rfq_vendors;