APPS.FA_INVOICE_TRANSACTIONS_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_Invoice_Transaction_Id         IN OUT NOCOPY NUMBER,
                       X_Book_Type_Code                 VARCHAR2,
                       X_Transaction_Type               VARCHAR2,
                       X_Date_Effective                 DATE,
			X_Calling_Fn			VARCHAR2,
			p_log_level_rec              IN FA_API_TYPES.log_level_rec_type default null) IS
    CURSOR C IS SELECT rowid FROM fa_invoice_transactions
                 WHERE invoice_transaction_id = X_Invoice_Transaction_Id;

Line: 13

      CURSOR C2 IS SELECT fa_invoice_transactions_s.nextval FROM sys.dual;

Line: 21

       INSERT INTO fa_invoice_transactions(

              invoice_transaction_id,
              book_type_code,
              transaction_type,
              date_effective
             ) VALUES (

              X_Invoice_Transaction_Id,
              X_Book_Type_Code,
              X_Transaction_Type,
              X_Date_Effective

             );

Line: 47

			(Called_Fn => 'FA_INVOICE_TRANSACTIONS_PKG.Insert_Row',
			Calling_Fn => X_Calling_Fn
			,p_log_level_rec => p_log_level_rec); */

Line: 51

			Calling_Fn => 'FA_INVOICE_TRANSACTIONS_PKG.Insert_Row'
			,p_log_level_rec => p_log_level_rec);

Line: 54

  END Insert_Row;

Line: 65

        SELECT *
        FROM   fa_invoice_transactions
        WHERE  rowid = X_Rowid
        FOR UPDATE of Invoice_Transaction_Id NOWAIT;

Line: 77

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

Line: 94

  PROCEDURE Update_Row(X_Rowid                          VARCHAR2,
                       X_Invoice_Transaction_Id         NUMBER,
                       X_Book_Type_Code                 VARCHAR2,
                       X_Transaction_Type               VARCHAR2,
                       X_Date_Effective                 DATE,
			X_Calling_Fn			VARCHAR2,
			p_log_level_rec  IN FA_API_TYPES.log_level_rec_type default null) IS
  BEGIN
    UPDATE fa_invoice_transactions
    SET
       invoice_transaction_id          =     X_Invoice_Transaction_Id,
       book_type_code                  =     X_Book_Type_Code,
       transaction_type                =     X_Transaction_Type,
       date_effective                  =     X_Date_Effective
    WHERE rowid = X_Rowid;

Line: 116

			(Calling_Fn => 'FA_INVOICE_TRANSACTIONS_PKG.Update_Row'
						,p_log_level_rec => p_log_level_rec);

Line: 119

  END Update_Row;

Line: 121

  PROCEDURE Delete_Row(X_Rowid VARCHAR2,
			X_Calling_Fn			VARCHAR2,
			p_log_level_rec  IN FA_API_TYPES.log_level_rec_type default null) IS
  BEGIN
    DELETE FROM fa_invoice_transactions
    WHERE rowid = X_Rowid;

Line: 134

			(Calling_Fn => 'FA_INVOICE_TRANSACTIONS_PKG.Delete_Row'
						,p_log_level_rec => p_log_level_rec);

Line: 137

  END Delete_Row;