DBA Data[Home] [Help]

APPS.IGI_AP_INVOICE_PKG SQL Statements

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

Line: 18

        SELECT *
        FROM   AP_INVOICES
        WHERE  rowid = X_Rowid
        FOR UPDATE of  Invoice_Id NOWAIT;
Line: 28

      FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
Line: 53

PROCEDURE Update_Row  (X_Rowid                VARCHAR2
                        ,X_igi_sap_flag       VARCHAR2
                        ,X_Last_Update_Login    NUMBER
                        ,X_Last_Update_Date     DATE
                        ,X_Last_Updated_By      NUMBER
                        ) IS
                        BEGIN
 				UPDATE IGI_INVOICE_DISTRIBUTIONS_ALL
                                SET
                                igi_sap_flag            =       X_igi_sap_flag,
                                last_update_login       =       X_Last_Update_Login,
                                last_updated_by         =       X_Last_Updated_By,
                                last_update_date        =       X_Last_Update_Date
                                WHERE rowid = X_Rowid;
Line: 70

END Update_Row;