APPS.RCV_GAPLESS_NUMBERING SQL Statements

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

Line: 47

   SELECT        ROWID,
                 next_sequence_number
   FROM          rcv_gapless_invoice_numbers
   WHERE         (prefix = l_prefix OR (prefix IS NULL AND l_prefix IS NULL))
   AND           buying_company_code = l_buying_company_identifier
   AND           selling_company_code = l_selling_company_identifier
   AND           invoice_type = p_invoice_type
   FOR UPDATE OF next_sequence_number;

Line: 83

        SELECT      DISTINCT pv.vendor_id ,
                    pv.vendor_name,
                    pvs.vendor_site_code
        INTO        l_vendor_id,
                    l_vendor_name,
                    l_vendor_site_code
        FROM        po_vendor_sites_all pvs,
                    po_vendors          pv
        WHERE       vendor_site_id = p_vendor_site_id
        AND         pvs.vendor_id = pv.vendor_id;

Line: 104

                        asn_debug.put_line ( 'Error occured while selecting Vendor_id. Error message is =' || SQLERRM );

Line: 110

        SELECT      name
        INTO        l_organization_name
        FROM        hr_organization_units
        WHERE       organization_id = p_org_id;

Line: 124

                        asn_debug.put_line ( 'Error occured while selecting Organization Name. Error message is =' || SQLERRM );

Line: 131

        SELECT      organization_code
        INTO        l_organization_code
        FROM        mtl_parameters
        WHERE       organization_id = p_org_id;

Line: 151

                        asn_debug.put_line ( 'Error occured while selecting Organization Code. Error message is =' || SQLERRM );

Line: 253

     INSERT INTO rcv_gapless_invoice_numbers (prefix,
                                              buying_company_code,
                                              selling_company_code,
                                              invoice_type,
                                              next_sequence_number
                                             )
     VALUES (l_prefix,
             l_buying_company_identifier,  -- Bugfix 5197828
             l_selling_company_identifier, -- Bugfix 5197828
             p_invoice_type,
             1);

Line: 312

   UPDATE rcv_gapless_invoice_numbers
      SET next_sequence_number = l_next_sequence_number
    WHERE ROWID = l_rowid;