APPS.ENG_ENGINEERING_CHANGES_PKG SQL Statements

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

Line: 10

  select 1 into dummy from dual where not exists
    (select 1 from ENG_ENGINEERING_CHANGES
      where CHANGE_NOTICE = X_Change_Notice
        and ORGANIZATION_ID = X_Organization_Id
    	and ((X_Rowid IS NULL) OR (ROWID <> X_Rowid))
    );

Line: 24

PROCEDURE Delete_Row( X_Rowid VARCHAR2,
		      X_Change_Notice VARCHAR2,
		      X_Organization_Id NUMBER )IS
BEGIN
  delete from ENG_ENGINEERING_CHANGES
  where rowid = X_Rowid;

Line: 33

    Delete_ECO_Revisions( X_Change_Notice, X_Organization_Id);

Line: 35

END Delete_Row;

Line: 38

PROCEDURE Delete_ECO_Revisions( X_Change_Notice VARCHAR2,
				X_Organization_Id NUMBER ) IS
BEGIN
  delete from ENG_CHANGE_ORDER_REVISIONS
  where CHANGE_NOTICE = X_Change_Notice
    and ORGANIZATION_ID = X_Organization_Id;

Line: 44

END Delete_ECO_Revisions;