APPS.IGI_AP_INV_LINES_PKG SQL Statements

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

Line: 18

        SELECT *
	FROM AP_INVOICE_LINES_ALL
        WHERE  rowid = X_Rowid
        FOR UPDATE of  invoice_id NOWAIT;

Line: 25

        SELECT *
	FROM IGI_INVOICE_LINES_ALL
        WHERE  (invoice_id,line_number,org_id) =
               (SELECT invoice_id,line_number,org_id
                FROM   AP_INVOICE_LINES_ALL
                WHERE  rowid = X_Rowid)
        FOR UPDATE of  igi_sap_flag NOWAIT;

Line: 39

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

Line: 52

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

Line: 76

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_LINES_ALL
				SET
				igi_sap_flag		= 	X_igi_sap_flag,
				last_update_login	=	X_Last_Update_Login,
				last_updated_by		=	X_Last_Updated_By,
				last_updated_date	=	X_Last_Update_Date
				WHERE rowid = X_Rowid;

Line: 93

			END Update_Row;