APPS.IGI_AP_INV_DIST_PKG SQL Statements

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

Line: 18

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

Line: 26

        SELECT *
	FROM IGI_INVOICE_DISTRIBUTIONS_ALL
        WHERE  (invoice_id,distribution_line_number,org_id) =
               (SELECT invoice_id,distribution_line_number, org_id
                FROM   AP_INVOICE_DISTRIBUTIONS_ALL
                WHERE  rowid = X_Rowid)
        FOR UPDATE of  igi_sap_flag NOWAIT; */

Line: 34

        SELECT *
	FROM IGI_INVOICE_DISTRIBUTIONS_ALL
        WHERE  (invoice_id,invoice_line_number,distribution_line_number,org_id) =
               (SELECT invoice_id,invoice_line_number,distribution_line_number, org_id
                FROM   AP_INVOICE_DISTRIBUTIONS_ALL
                WHERE  rowid = X_Rowid)
        FOR UPDATE of  igi_sap_flag NOWAIT;

Line: 50

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

Line: 63

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

Line: 87

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: 104

			END Update_Row;