APPS.INV_INTER_INVOICE SQL Statements

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

Line: 17

  PROCEDURE update_invoice_flag(p_header_id IN NUMBER, p_line_id IN NUMBER) IS
    x_return_status      VARCHAR2(30);

Line: 25

    l_module             VARCHAR2(50)   := 'INV_INTER_INVOICE.update_invoice_flag';

Line: 38

         'select  price_adjustment_id '
      || 'FROM oe_price_adjustments WHERE '
      || '( line_id =  :line_id OR '
      || '(header_id = :header_id AND line_id IS NULL) )'
      || 'AND nvl(interco_invoiced_flag,''N'') = ''N'' ';

Line: 54

          /*inv_log_util.TRACE('Calling OE_INVOICE_UTIL.Update_Interco_Invoiced_Flag for d_priceAdjustmentId :' || d_priceadjustmentid
          , l_module);*/

Line: 56

           print_debug('Calling OE_INVOICE_UTIL.Update_Interco_Invoiced_Flag for d_priceAdjustmentId :' || d_priceadjustmentid
          , l_module);

Line: 60

        oe_invoice_util.update_interco_invoiced_flag(d_priceadjustmentid, x_return_status);

Line: 80

        oe_msg_pub.add_exc_msg(g_pkg_name, 'Update_Invoiced_flag');

Line: 81

        /*inv_log_util.TRACE ('Unexpected Error occured while calling OE_INVOICE_UTIL.Update_Interco_Invoiced_Flag for d_priceAdjustmentId :'|| d_priceadjustmentid, l_module);        */

Line: 82

        print_debug('Unexpected Error occured while calling OE_INVOICE_UTIL.Update_Interco_Invoiced_Flag for d_priceAdjustmentId :'|| d_priceadjustmentid, l_module);

Line: 84

  END update_invoice_flag;