APPS.PA_TAX_CLIENT_EXTN_DRV SQL Statements

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

Line: 6

 | This Private Procedure Insert_Distrbution_Warning Inserts draft Invoice    |
 | distribution warning.                                                      |
 +----------------------------------------------------------------------------*/
  Procedure Insert_Distribution_Warning( P_Project_ID         in  number,
                                         P_User_ID            in  number,
                                         P_Request_ID         in  number,
                                         P_Error_Message_Code in  varchar2) is

    l_error_message   pa_lookups.meaning%TYPE;

Line: 28

      SELECT Meaning
        INTO l_error_message
        FROM PA_Lookups
       WHERE Lookup_Type = 'OUTPUT TAX'
         AND Lookup_Code = P_Error_Message_Code;

Line: 38

    INSERT INTO PA_DISTRIBUTION_WARNINGS
    (
      PROJECT_ID, DRAFT_INVOICE_NUM, LAST_UPDATE_DATE, LAST_UPDATED_BY,
      CREATION_DATE, CREATED_BY, REQUEST_ID, WARNING_MESSAGE
    )
    VALUES
    (
      P_Project_ID, pa_tax_client_extn_drv.G_Draft_Invoice_Num,sysdate,
      P_User_ID,sysdate, P_User_ID, P_Request_ID, l_error_message
    );

Line: 65

  END Insert_Distribution_Warning;

Line: 111

             Select 'x'
             into   l_dummy
             from   pa_output_tax_code_txn_v
             where  tax_code = l_tax_code
	     and org_id in (PA_MOAC_UTILS.GET_CURRENT_ORG_ID, -99)  /*Added condition for Bug 5255736*/
             and G_Invoice_Date between start_date_active and nvl(end_date_active,sysdate); /* Added for Bug 6521026 */

Line: 130

                  Insert_Distribution_Warning
                    (P_Project_ID   => P_Project_ID,
                     P_User_ID      => P_User_ID,
                     P_Request_ID   => P_Request_ID,
                     P_Error_Message_Code => 'INVALID_TAX_ID');