eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_PBATCH_SET_LINES_PKG SQL Statements

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

Line: 4


PROCEDURE Insert_Row(
          X_Rowid                 IN OUT NOCOPY   VARCHAR2,
          X_Batch_Name                     VARCHAR2,
          X_Batch_Set_Id                   NUMBER,
          X_Batch_Set_Line_Id              NUMBER,
          X_Include_In_Set                 VARCHAR2 DEFAULT NULL,
          X_Printer                        VARCHAR2 DEFAULT NULL,
          X_Check_Stock_Id                 NUMBER DEFAULT NULL,
          X_Ce_Bank_Acct_Use_Id            NUMBER DEFAULT NULL,
          X_Vendor_Pay_Group               VARCHAR2 DEFAULT NULL,
          X_Hi_Payment_Priority            NUMBER DEFAULT NULL,
          X_Low_Payment_Priority           NUMBER DEFAULT NULL,
          X_Max_Payment_Amount             NUMBER DEFAULT NULL,
          X_Min_Check_Amount               NUMBER DEFAULT NULL,
          X_Max_Outlay                     NUMBER DEFAULT NULL,
          X_Pay_Only_When_Due_Flag         VARCHAR2 DEFAULT NULL,
          X_Payment_Currency_Code          VARCHAR2,
          X_Exchange_Rate_Type             VARCHAR2 DEFAULT NULL,
          X_Document_Order_Lookup_Code     VARCHAR2 DEFAULT NULL,
          X_Audit_Required_Flag            VARCHAR2 DEFAULT NULL,
          X_Interval                       NUMBER DEFAULT NULL,
          X_Volume_Serial_Number           VARCHAR2 DEFAULT NULL,
          X_Zero_Amounts_Allowed           VARCHAR2 DEFAULT NULL,
          X_Zero_Invoices_Allowed          VARCHAR2 DEFAULT NULL,
          X_Org_Id                         NUMBER DEFAULT NULL,
          X_Future_Pmts_Allowed            VARCHAR2 DEFAULT NULL,
          X_Transfer_Priority              VARCHAR2 DEFAULT NULL,
          X_Last_Update_Date               DATE,
          X_Last_Updated_By                NUMBER,
          X_Last_Update_Login              NUMBER DEFAULT NULL,
          X_Creation_Date                  DATE DEFAULT NULL,
          X_Created_By                     NUMBER DEFAULT NULL,
          X_Inactive_Date                  DATE DEFAULT NULL,
	  X_calling_sequence	  IN	   VARCHAR2,
	  X_attribute_category		   VARCHAR2, /* BUG 2124337 */
	  X_attribute1			   VARCHAR2,
	  X_attribute2			   VARCHAR2,
	  X_attribute3			   VARCHAR2,
	  X_attribute4			   VARCHAR2,
	  X_attribute5			   VARCHAR2,
	  X_attribute6			   VARCHAR2,
	  X_attribute7			   VARCHAR2,
	  X_attribute8			   VARCHAR2,
	  X_attribute9			   VARCHAR2,
	  X_attribute10			   VARCHAR2,
	  X_attribute11			   VARCHAR2,
	  X_attribute12			   VARCHAR2,
	  X_attribute13			   VARCHAR2,
	  X_attribute14			   VARCHAR2,
	  X_attribute15			   VARCHAR2, /* BUG 2124337 */
          X_Vendor_Id                      NUMBER,
          X_days_between_check_cycles      NUMBER
  ) IS
    l_batch_set_line_id      NUMBER;

Line: 58


    CURSOR C IS SELECT rowid FROM ap_pbatch_set_lines
                 WHERE batch_name = X_Batch_Name
                 AND   batch_set_line_id = l_Batch_Set_Line_Id;

Line: 68


       'AP_PBATCH_SET_LINES_PKG.INSERT_ROW<-'||X_Calling_Sequence;

Line: 80


         select ap_pbatch_set_lines_s.nextval
         into l_batch_set_line_id
         from sys.dual;

Line: 85


       debug_info := 'Insert into ap_pbatch_set_lines';

Line: 86


       INSERT INTO ap_pbatch_set_lines (
              batch_name,
              batch_set_id,
              batch_set_line_id,
              include_in_set,
              printer,
              check_stock_id,
              ce_bank_acct_use_id,
              vendor_pay_group,
              hi_payment_priority,
              low_payment_priority,
              max_payment_amount,
              min_check_amount,
              max_outlay,
              pay_only_when_due_flag,
              payment_currency_code,
              exchange_rate_type,
              document_order_lookup_code,
              audit_required_flag,
              interval,
              volume_serial_number,
              zero_amounts_allowed,
              zero_invoices_allowed,
              future_pmts_allowed,
              transfer_priority,
              inactive_date,
              last_update_date,
              last_updated_by,
              last_update_login,
              creation_date,
              created_by,
              attribute_category,		   /* BUG 2124337 */
	      attribute1,
	      attribute2,
	      attribute3,
	      attribute4,
	      attribute5,
	      attribute6,
	      attribute7,
	      attribute8,
	      attribute9,
	      attribute10,
	      attribute11,
	      attribute12,
	      attribute13,
	      attribute14,
	      attribute15,			  /* BUG 2124337 */
              vendor_id,
              org_id,
              days_between_check_cycles
             ) VALUES (

              X_Batch_Name,
              X_Batch_Set_Id,
              l_Batch_Set_Line_Id,
              X_Include_In_Set,
              X_Printer,
              X_Check_Stock_Id,
              X_Ce_Bank_Acct_Use_Id,
              X_Vendor_Pay_Group,
              X_Hi_Payment_Priority,
              X_Low_Payment_Priority,
              X_Max_Payment_amount,
              X_Min_Check_Amount,
              X_Max_Outlay,
              X_Pay_Only_When_Due_Flag,
              X_Payment_Currency_Code,
              X_Exchange_Rate_Type,
              X_Document_Order_Lookup_Code,
              X_Audit_Required_Flag,
              X_Interval,
              X_Volume_Serial_Number,
              X_Zero_Amounts_Allowed,
              X_Zero_Invoices_Allowed,
              X_Future_Pmts_Allowed,
              X_Transfer_Priority,
              X_Inactive_Date,
              X_Last_Update_Date,
              X_Last_Updated_By,
              X_Last_Update_Login,
              X_Creation_Date,
              X_Created_By,
              X_attribute_category,		   /* BUG 2124337 */
	      X_attribute1,
	      X_attribute2,
	      X_attribute3,
	      X_attribute4,
	      X_attribute5,
	      X_attribute6,
	      X_attribute7,
	      X_attribute8,
	      X_attribute9,
	      X_attribute10,
	      X_attribute11,
	      X_attribute12,
	      X_attribute13,
	      X_attribute14,
	      X_attribute15,			     /* BUG 2124337 */
              X_Vendor_Id,
              X_Org_Id,
              X_days_between_check_cycles
              );

Line: 214


  END Insert_Row;

Line: 266


        SELECT *
        FROM   ap_pbatch_set_lines
        WHERE  rowid = X_Rowid
        FOR UPDATE of Batch_Name NOWAIT;

Line: 288


      FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

Line: 439


  PROCEDURE Update_Row(
            X_Rowid                          VARCHAR2,
            X_Batch_Name                     VARCHAR2,
            X_Batch_Set_Id                   NUMBER,
            X_Batch_Set_Line_Id              NUMBER,
            X_Include_In_Set                 VARCHAR2 DEFAULT NULL,
            X_Printer                        VARCHAR2 DEFAULT NULL,
            X_Check_Stock_Id                 NUMBER DEFAULT NULL,
            X_Ce_Bank_Acct_Use_Id            NUMBER,
            X_Vendor_Pay_Group               VARCHAR2 DEFAULT NULL,
            X_Hi_Payment_Priority            NUMBER DEFAULT NULL,
            X_Low_Payment_Priority           NUMBER DEFAULT NULL,
            X_Max_Payment_Amount             NUMBER DEFAULT NULL,
            X_Min_Check_Amount               NUMBER DEFAULT NULL,
            X_Max_Outlay                     NUMBER DEFAULT NULL,
            X_Pay_Only_When_Due_Flag         VARCHAR2 DEFAULT NULL,
            X_Payment_Currency_Code          VARCHAR2,
            X_Exchange_Rate_Type             VARCHAR2 DEFAULT NULL,
            X_Document_Order_Lookup_Code     VARCHAR2 DEFAULT NULL,
            X_Audit_Required_Flag            VARCHAR2 DEFAULT NULL,
            X_Interval                       NUMBER DEFAULT NULL,
            X_Volume_Serial_Number           VARCHAR2 DEFAULT NULL,
            X_Zero_Amounts_Allowed           VARCHAR2 DEFAULT NULL,
            X_Zero_Invoices_Allowed          VARCHAR2 DEFAULT NULL,
            X_Org_Id                         NUMBER DEFAULT NULL,
            X_Future_Pmts_Allowed            VARCHAR2 DEFAULT NULL,
            X_transfer_priority              VARCHAR2 DEFAULT NULL,
            X_Last_Update_Date               DATE,
            X_Last_Updated_By                NUMBER,
            X_Last_Update_Login              NUMBER DEFAULT NULL,
            X_Creation_Date                  DATE DEFAULT NULL,
            X_Created_By                     NUMBER DEFAULT NULL,
            X_Inactive_Date                  DATE DEFAULT NULL,
            X_calling_sequence	IN	     VARCHAR2,
            X_attribute_category	     VARCHAR2, /* BUG 2124337 */
	    X_attribute1		     VARCHAR2,
	    X_attribute2		     VARCHAR2,
	    X_attribute3		     VARCHAR2,
	    X_attribute4		     VARCHAR2,
	    X_attribute5		     VARCHAR2,
	    X_attribute6		     VARCHAR2,
	    X_attribute7		     VARCHAR2,
	    X_attribute8		     VARCHAR2,
	    X_attribute9		     VARCHAR2,
	    X_attribute10		     VARCHAR2,
	    X_attribute11		     VARCHAR2,
	    X_attribute12		     VARCHAR2,
	    X_attribute13		     VARCHAR2,
	    X_attribute14		     VARCHAR2,
	    X_attribute15		     VARCHAR2,  /* BUG 2124337 */
            X_Vendor_Id                      NUMBER,
            X_days_between_check_cycles      NUMBER
  ) IS
    current_calling_sequence VARCHAR2(2000);

Line: 498


     'AP_PBATCH_SET_LINES_PKG.UPDATE_ROW<-'||X_Calling_Sequence;

Line: 501


    debug_info := 'Update ap_pbatch_set_lines';

Line: 502


    UPDATE ap_pbatch_set_lines
    SET
       batch_name                      =     X_Batch_Name,
       batch_set_id                    =     X_Batch_Set_Id,
       batch_set_line_id               =     X_Batch_Set_Line_Id,
       include_in_set                  =     X_Include_in_Set,
       printer                         =     X_Printer,
       check_stock_id                  =     X_Check_Stock_Id,
       vendor_pay_group                =     X_Vendor_Pay_Group,
       hi_payment_priority             =     X_Hi_Payment_Priority,
       low_payment_priority            =     X_Low_Payment_Priority,
       max_payment_amount              =     X_Max_Payment_Amount,
       min_check_amount                =     X_Min_Check_Amount,
       max_outlay                      =     X_Max_Outlay,
       pay_only_when_due_flag          =     X_Pay_Only_When_Due_Flag,
       payment_currency_code           =     X_Payment_Currency_Code,
       exchange_rate_type              =     X_Exchange_Rate_Type,
       document_order_lookup_code      =     X_Document_Order_Lookup_Code,
       audit_required_flag             =     X_Audit_Required_Flag,
       interval                        =     X_Interval,
       volume_serial_number            =     X_Volume_Serial_Number,
       zero_amounts_allowed            =     X_Zero_Amounts_Allowed,
       zero_invoices_allowed           =     X_Zero_Invoices_Allowed,
       future_pmts_allowed             =     X_Future_Pmts_Allowed,
       ce_bank_acct_use_id             =     X_Ce_Bank_Acct_Use_Id,
       transfer_priority               =     X_transfer_priority,
       inactive_date                   =     X_Inactive_Date,
       last_update_date                =     X_Last_Update_Date,
       last_updated_by                 =     X_Last_Updated_By,
       last_update_login               =     X_Last_Update_Login,
       attribute_category              =     X_attribute_category,	   /* BUG 2124337 */
       attribute1                      =     X_attribute1,
       attribute2                      =     X_attribute2,
       attribute3                      =     X_attribute3,
       attribute4                      =     X_attribute4,
       attribute5                      =     X_attribute5,
       attribute6                      =     X_attribute6,
       attribute7                      =     X_attribute7,
       attribute8                      =     X_attribute8,
       attribute9                      =     X_attribute9,
       attribute10                     =     X_attribute10,
       attribute11                     =     X_attribute11,
       attribute12                     =     X_attribute12,
       attribute13                     =     X_attribute13,
       attribute14                     =     X_attribute14,
       attribute15                     =     X_attribute15,		   /* BUG 2124337 */
       vendor_id                       =     X_Vendor_Id,
       days_between_check_cycles       =     X_days_between_check_cycles
    WHERE rowid = X_Rowid;

Line: 568


  END Update_Row;

Line: 571


  PROCEDURE Delete_Row(X_Rowid 				VARCHAR2,
		       X_calling_sequence	IN	VARCHAR2) IS

    current_calling_sequence VARCHAR2(2000);

Line: 581


     'AP_PBATCH_SET_LINES_PKG.DELETE_ROW<-'||X_Calling_Sequence;

Line: 583


    debug_info := 'Delete from ap_pbatch_set_lines';

Line: 584


    DELETE FROM ap_pbatch_set_lines
    WHERE rowid = X_Rowid;

Line: 601


  END Delete_Row;

Line: 618


    select count(1)
    into dummy
    from   ap_invoice_selection_criteria
    where batch_run_name = X_batch_run_name
    and batch_set_id = X_batch_set_id;

Line: 658


    select count(1)
    into dummy
    from   ap_invoice_selection_criteria
    where checkrun_name = X_batch_name||X_batch_run_name;