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.JL_BR_AP_CONSOLID_INVOICES_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_Consolidated_Invoice_Id         NUMBER,
 		       X_Vendor_Id                       NUMBER,
 		       X_Invoice_Num                     VARCHAR2,
		       X_Set_Of_Books_Id                 NUMBER,
		       X_Invoice_Currency_Code           VARCHAR2,
		       X_Invoice_Amount                  NUMBER DEFAULT NULL,
		       X_Vendor_Site_Id                  NUMBER DEFAULT NULL,
		       X_Invoice_Date                    DATE DEFAULT NULL,
		       X_Description                     VARCHAR2 DEFAULT NULL,
		       X_Terms_Id                        NUMBER DEFAULT NULL,
		       X_Terms_Date                      DATE DEFAULT NULL,
		       X_Cancelled_Date                  DATE DEFAULT NULL,
		       X_Cancelled_By                    NUMBER DEFAULT NULL,
		       X_Cancelled_Amount                NUMBER DEFAULT NULL,
                       X_Amt_Applicable_To_Discount   NUMBER DEFAULT NULL,
		       X_Attribute_Category              VARCHAR2 DEFAULT NULL,
		       X_Attribute1                      VARCHAR2 DEFAULT NULL,
		       X_Attribute2                      VARCHAR2 DEFAULT NULL,
		       X_Attribute3                      VARCHAR2 DEFAULT NULL,
		       X_Attribute4                      VARCHAR2 DEFAULT NULL,
		       X_Attribute5                      VARCHAR2 DEFAULT NULL,
		       X_Attribute6                      VARCHAR2 DEFAULT NULL,
		       X_Attribute7                      VARCHAR2 DEFAULT NULL,
		       X_Attribute8                      VARCHAR2 DEFAULT NULL,
		       X_Attribute9                      VARCHAR2 DEFAULT NULL,
		       X_Attribute10                     VARCHAR2 DEFAULT NULL,
		       X_Attribute11                     VARCHAR2 DEFAULT NULL,
		       X_Attribute12                     VARCHAR2 DEFAULT NULL,
		       X_Attribute13                     VARCHAR2 DEFAULT NULL,
		       X_Attribute14                     VARCHAR2 DEFAULT NULL,
		       X_Attribute15                     VARCHAR2 DEFAULT NULL,
		       X_Last_Update_Date                DATE,
		       X_Last_Updated_By                 NUMBER,
		       X_Creation_Date                   DATE DEFAULT NULL,
		       X_Created_By                      NUMBER DEFAULT NULL,
		       X_Last_Update_Login               NUMBER DEFAULT NULL,
		       X_Pay_Group_Lookup_Code           VARCHAR2 DEFAULT NULL,
		       X_Pay_Group_Flag                  VARCHAR2 DEFAULT NULL,
		       X_Org_ID                          NUMBER DEFAULT NULL,
		       X_calling_sequence	      IN VARCHAR2
  ) IS
    CURSOR C IS SELECT rowid FROM JL_BR_AP_CONSOLID_INVOICES
                 WHERE consolidated_invoice_id = X_Consolidated_Invoice_Id;

Line: 55


       current_calling_sequence := 'JL_BR_AP_CONSOLID_INVOICES_PKG.INSERT_ROW<-' ||
                                    X_calling_sequence;

Line: 58


       debug_info := 'Insert into JL_BR_AP_CONSOLID_INVOICES';

Line: 59


       INSERT INTO JL_BR_AP_CONSOLID_INVOICES(
 		consolidated_invoice_id,
 		vendor_id,
 		invoice_num,
 		set_of_books_id,
 		invoice_currency_code,
 		invoice_amount,
 		vendor_site_id,
 		invoice_date,
 		description,
 		terms_id,
 		terms_date,
 		cancelled_date,
 		cancelled_by,
 		cancelled_amount,
 		amount_applicable_to_discount,
 		attribute_category,
 		attribute1,
 		attribute2,
 		attribute3,
 		attribute4,
 		attribute5,
 		attribute6,
 		attribute7,
 		attribute8,
 		attribute9,
 		attribute10,
 		attribute11,
 		attribute12,
 		attribute13,
 		attribute14,
 		attribute15,
 		last_update_date,
 		last_updated_by,
 		creation_date,
 		created_by,
 		last_update_login,
 		pay_group_lookup_code,
                pay_group_flag,
                org_id
             ) VALUES (
 		X_Consolidated_Invoice_Id,
 		X_Vendor_Id,
 		X_Invoice_Num,
 		X_Set_Of_Books_Id,
 		X_Invoice_Currency_Code,
 		X_Invoice_Amount,
 		X_Vendor_Site_Id,
 		X_Invoice_Date,
 		X_Description,
 		X_Terms_Id,
 		X_Terms_Date,
 		X_Cancelled_Date,
 		X_Cancelled_By,
 		X_Cancelled_Amount,
                X_Amt_Applicable_To_Discount,
 		X_Attribute_Category,
 		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,
 		X_Last_Update_Date,
 		X_Last_Updated_By,
 		X_Creation_Date,
 		X_Created_By,
 		X_Last_Update_Login,
 		X_Pay_Group_Lookup_Code,
 		X_Pay_Group_Flag,
                X_Org_ID
             );

Line: 165


  END Insert_Row;

Line: 200


		     X_Last_Update_Date                DATE,
		     X_Last_Updated_By                 NUMBER,
		     X_Creation_Date                   DATE DEFAULT NULL,
		     X_Created_By                      NUMBER DEFAULT NULL,
		     X_Last_Update_Login               NUMBER DEFAULT NULL,
		     X_Pay_Group_Lookup_Code           VARCHAR2 DEFAULT NULL,
		     X_Pay_Group_Flag                  VARCHAR2 DEFAULT NULL,
		     X_calling_sequence		IN     VARCHAR2
  ) IS
    CURSOR C IS
        SELECT *
        FROM   JL_BR_AP_CONSOLID_INVOICES
        WHERE  rowid = X_Rowid
        FOR UPDATE of Consolidated_Invoice_Id NOWAIT;

Line: 231


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

Line: 358


  PROCEDURE Update_Row(X_Rowid                          VARCHAR2,

		       X_Consolidated_Invoice_Id         NUMBER,
 		       X_Vendor_Id                       NUMBER,
 		       X_Invoice_Num                     VARCHAR2,
		       X_Set_Of_Books_Id                 NUMBER,
		       X_Invoice_Currency_Code           VARCHAR2,
		       X_Invoice_Amount                  NUMBER DEFAULT NULL,
		       X_Vendor_Site_Id                  NUMBER DEFAULT NULL,
		       X_Invoice_Date                    DATE DEFAULT NULL,
		       X_Description                     VARCHAR2 DEFAULT NULL,
		       X_Terms_Id                        NUMBER DEFAULT NULL,
		       X_Terms_Date                      DATE DEFAULT NULL,
		       X_Cancelled_Date                  DATE DEFAULT NULL,
		       X_Cancelled_By                    NUMBER DEFAULT NULL,
		       X_Cancelled_Amount                NUMBER DEFAULT NULL,
		       X_Amt_Applicable_To_Discount   NUMBER DEFAULT NULL,
		       X_Attribute_Category              VARCHAR2 DEFAULT NULL,
		       X_Attribute1                      VARCHAR2 DEFAULT NULL,
		       X_Attribute2                      VARCHAR2 DEFAULT NULL,
		       X_Attribute3                      VARCHAR2 DEFAULT NULL,
		       X_Attribute4                      VARCHAR2 DEFAULT NULL,
		       X_Attribute5                      VARCHAR2 DEFAULT NULL,
		       X_Attribute6                      VARCHAR2 DEFAULT NULL,
		       X_Attribute7                      VARCHAR2 DEFAULT NULL,
		       X_Attribute8                      VARCHAR2 DEFAULT NULL,
		       X_Attribute9                      VARCHAR2 DEFAULT NULL,
		       X_Attribute10                     VARCHAR2 DEFAULT NULL,
		       X_Attribute11                     VARCHAR2 DEFAULT NULL,
		       X_Attribute12                     VARCHAR2 DEFAULT NULL,
		       X_Attribute13                     VARCHAR2 DEFAULT NULL,
		       X_Attribute14                     VARCHAR2 DEFAULT NULL,
		       X_Attribute15                     VARCHAR2 DEFAULT NULL,
		       X_Last_Update_Date                DATE,
		       X_Last_Updated_By                 NUMBER,
		       X_Creation_Date                   DATE DEFAULT NULL,
		       X_Created_By                      NUMBER DEFAULT NULL,
		       X_Last_Update_Login               NUMBER DEFAULT NULL,
		       X_Pay_Group_Lookup_Code           VARCHAR2 DEFAULT NULL,
		       X_Pay_Group_Flag                  VARCHAR2 DEFAULT NULL,
		       X_calling_sequence	IN	 VARCHAR2

  ) IS
    current_calling_sequence    VARCHAR2(2000);

Line: 406


    current_calling_sequence := 'JL_BR_AP_CONSOLID_INVOICES_PKG.UPDATE_ROW<-' ||
                                 X_calling_sequence;

Line: 408


    debug_info := 'Update JL_BR_AP_CONSOLID_INVOICES';

Line: 409


    UPDATE JL_BR_AP_CONSOLID_INVOICES
    SET
       consolidated_invoice_id	       =     X_Consolidated_Invoice_Id,
       vendor_id                       =     X_Vendor_Id,
       invoice_num                     =     X_Invoice_Num,
       set_of_books_id                 =     X_Set_Of_Books_Id,
       invoice_currency_code           =     X_Invoice_Currency_Code,
       invoice_amount                  =     X_Invoice_Amount,
       vendor_site_id                  =     X_Vendor_Site_Id,
       invoice_date                    =     X_Invoice_Date,
       description                     =     X_Description,
       terms_id                        =     X_Terms_Id,
       terms_date                      =     X_Terms_Date,
       cancelled_date                  =     X_Cancelled_Date,
       cancelled_by                    =     X_Cancelled_By,
       cancelled_amount                =     X_Cancelled_Amount,
       amount_applicable_to_discount   =     X_Amt_Applicable_To_Discount,
       attribute_category              =     X_Attribute_Category,
       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,
       last_update_date                =     X_Last_Update_Date,
       last_updated_by                 =     X_Last_Updated_By,
       creation_date                   =     X_Creation_Date,
       created_by                      =     X_Created_by,
       last_update_login               =     X_Last_Update_Login,
       pay_group_lookup_code	       =     X_Pay_Group_Lookup_Code,
       pay_group_flag    	       =     X_Pay_Group_Flag

    WHERE rowid = X_Rowid;

Line: 468


  END Update_Row;

Line: 470


  PROCEDURE Delete_Row(X_Rowid 				VARCHAR2,
		       X_calling_sequence	IN	VARCHAR2
  ) IS
    current_calling_sequence    VARCHAR2(2000);

Line: 478


    current_calling_sequence := 'JL_BR_AP_CONSOLID_INVOICES_PKG.DELETE_ROW<-' ||
                                 X_calling_sequence;

Line: 480


    debug_info := 'Delete from JL_BR_AP_CONSOLID_INVOICES';

Line: 481


    DELETE FROM JL_BR_AP_CONSOLID_INVOICES
    WHERE rowid = X_Rowid;

Line: 499


  END Delete_Row;