APPS.ENG_ECN_APPROVAL_LISTS_PKG SQL Statements

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

Line: 5

PROCEDURE Insert_Row(X_Rowid                         IN OUT NOCOPY VARCHAR2,
                     X_Approval_List_Id              IN OUT NOCOPY NUMBER,
                     X_Approval_List_Name            VARCHAR2,
                     X_Disable_Date                  DATE DEFAULT NULL,
                     X_Description                   VARCHAR2 DEFAULT NULL,
                     X_Attribute_Category            VARCHAR2 DEFAULT NULL,
                     X_Attribute1                    VARCHAR2 DEFAULT NULL,
                     X_Attribute2                    VARCHAR2 DEFAULT NULL,
                     X_Attribute3                    VARCHAR2 DEFAULT NULL,
                     X_Attribute4                    VARCHAR2 DEFAULT NULL,
                     X_Attribute5                    VARCHAR2 DEFAULT NULL,
                     X_Attribute6                    VARCHAR2 DEFAULT NULL,
                     X_Attribute7                    VARCHAR2 DEFAULT NULL,
                     X_Attribute8                    VARCHAR2 DEFAULT NULL,
                     X_Attribute9                    VARCHAR2 DEFAULT NULL,
                     X_Attribute10                   VARCHAR2 DEFAULT NULL,
                     X_Attribute11                   VARCHAR2 DEFAULT NULL,
                     X_Attribute12                   VARCHAR2 DEFAULT NULL,
                     X_Attribute13                   VARCHAR2 DEFAULT NULL,
                     X_Attribute14                   VARCHAR2 DEFAULT NULL,
                     X_Attribute15                   VARCHAR2 DEFAULT NULL,
                     X_Creation_Date                 DATE,
                     X_Created_By                    NUMBER,
                     X_Last_Update_Login             NUMBER DEFAULT NULL,
                     X_Last_Update_Date              DATE,
                     X_Last_Updated_By               NUMBER
 ) IS
   CURSOR C IS SELECT rowid FROM eng_ecn_approval_lists
             WHERE approval_list_id = X_Approval_List_Id;

Line: 34

   CURSOR C2 IS SELECT eng_ecn_approval_lists_s.nextval FROM dual;

Line: 44

  INSERT INTO eng_ecn_approval_lists(
          approval_list_id,
          approval_list_name,
          disable_date,
          description,
          attribute_category,
          attribute1,
          attribute2,
          attribute3,
          attribute4,
          attribute5,
          attribute6,
          attribute7,
          attribute8,
          attribute9,
          attribute10,
          attribute11,
          attribute12,
          attribute13,
          attribute14,
          attribute15,
          creation_date,
          created_by,
          last_update_login,
          last_update_date,
          last_updated_by
         ) VALUES (
          X_Approval_List_Id,
          X_Approval_List_Name,
          X_Disable_Date,
          X_Description,
          X_Attribute_Category,
          X_Attribute1,
          X_Attribute2,
          X_Attribute3,
          X_Attribute4,
          X_Attribute5,
          X_Attribute6,
          X_Attribute7,
          X_Attribute8,
          X_Attribute9,
          X_Attribute10,
          X_Attribute11,
          X_Attribute12,
          X_Attribute13,
          X_Attribute14,
          X_Attribute15,
          X_Creation_Date,
          X_Created_By,
          X_Last_Update_Login,
          X_Last_Update_Date,
          X_Last_Updated_By
  );

Line: 120

END Insert_Row;

Line: 144

      SELECT *
      FROM   eng_ecn_approval_lists
      WHERE  rowid = X_Rowid
      FOR UPDATE of Approval_List_Id NOWAIT;

Line: 225

PROCEDURE Update_Row(X_Rowid                               VARCHAR2,
                     X_Approval_List_Id                    NUMBER,
                     X_Approval_List_Name                  VARCHAR2,
                     X_Disable_Date                        DATE DEFAULT NULL,
                     X_Description                         VARCHAR2 DEFAULT NULL ,
                     X_Attribute_Category                  VARCHAR2 DEFAULT NULL ,
                     X_Attribute1                          VARCHAR2 DEFAULT NULL ,
                     X_Attribute2                          VARCHAR2 DEFAULT NULL ,
                     X_Attribute3                          VARCHAR2 DEFAULT NULL ,
                     X_Attribute4                          VARCHAR2 DEFAULT NULL ,
                     X_Attribute5                          VARCHAR2 DEFAULT NULL ,
                     X_Attribute6                          VARCHAR2 DEFAULT NULL ,
                     X_Attribute7                          VARCHAR2 DEFAULT NULL ,
                     X_Attribute8                          VARCHAR2 DEFAULT NULL ,
                     X_Attribute9                          VARCHAR2 DEFAULT NULL ,
                     X_Attribute10                         VARCHAR2 DEFAULT NULL ,
                     X_Attribute11                         VARCHAR2 DEFAULT NULL ,
                     X_Attribute12                         VARCHAR2 DEFAULT NULL ,
                     X_Attribute13                         VARCHAR2 DEFAULT NULL ,
                     X_Attribute14                         VARCHAR2 DEFAULT NULL ,
                     X_Attribute15                         VARCHAR2 DEFAULT NULL ,
                     X_Last_Update_Login                   NUMBER DEFAULT NULL,
                     X_Last_Update_Date                    DATE,
                     X_Last_Updated_By                     NUMBER
) IS

/* Added for Bug 3511260 */

Cursor user_roles is
  select START_DATE,
         USER_ORIG_SYSTEM,USER_ORIG_SYSTEM_ID
  from WF_LOCAL_USER_ROLES
  where role_orig_system= 'ENG_LIST' and
        role_orig_system_id = X_Approval_List_Id;

Line: 264

  UPDATE eng_ecn_approval_lists
  SET
    approval_list_id                          =    X_Approval_List_Id,
    approval_list_name                        =    X_Approval_List_Name,
    disable_date                              =    X_Disable_Date,
    description                               =    X_Description,
    attribute_category                        =    X_Attribute_Category,
    attribute1                                =    X_Attribute1,
    attribute2                                =    X_Attribute2,
    attribute3                                =    X_Attribute3,
    attribute4                                =    X_Attribute4,
    attribute5                                =    X_Attribute5,
    attribute6                                =    X_Attribute6,
    attribute7                                =    X_Attribute7,
    attribute8                                =    X_Attribute8,
    attribute9                                =    X_Attribute9,
    attribute10                               =    X_Attribute10,
    attribute11                               =    X_Attribute11,
    attribute12                               =    X_Attribute12,
    attribute13                               =    X_Attribute13,
    attribute14                               =    X_Attribute14,
    attribute15                               =    X_Attribute15,
    last_update_login                         =    X_Last_Update_Login,
    last_update_date                          =    X_Last_Update_Date,
    last_updated_by                           =    X_Last_Updated_By
  WHERE rowid = X_rowid;

Line: 297

   select EMAIL_ADDRESS,FAX
   into lemail,lfax
   from WF_LOCAL_ROLES
   where NAME = l_username and
         ORIG_SYSTEM = 'ENG_LIST' and
         ORIG_SYSTEM_ID = X_Approval_List_Id;

Line: 324

   though the Role is re acttivated. Below code is added to update the User
  role relation in the table*/

  for c in user_roles loop

     wf_local_synch.propagate_user_role(

      p_user_orig_system     => c.USER_ORIG_SYSTEM,
      p_user_orig_system_id  => c.USER_ORIG_SYSTEM_ID,
      p_role_orig_system     => 'ENG_LIST',
      p_role_orig_system_id  => x_approval_List_Id,
      p_start_date           => c.START_DATE,
      p_overwrite            => TRUE,
      p_expiration_date      => X_Disable_Date);

Line: 341

END Update_Row;

Line: 343

PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
 x_approval_list_id number;

Line: 349

  select approval_list_id into x_approval_list_id
  from eng_ecn_approval_lists
  where  rowid = X_Rowid;

Line: 353

  DELETE FROM eng_ecn_approval_lists
  WHERE  rowid = X_Rowid;

Line: 360

  wf_event.AddParameterToList('DELETE','TRUE', mylist);

Line: 370

END Delete_Row;

Line: 375

  SELECT 1 INTO DUMMY FROM DUAL WHERE NOT EXISTS
    (SELECT 1 FROM ENG_ENGINEERING_CHANGES
       WHERE Approval_List_Id = X_Approval_List_Id
    );

Line: 389

  SELECT 1 INTO DUMMY FROM DUAL WHERE NOT EXISTS
    (SELECT 1 FROM ENG_ECN_APPROVAL_LISTS
       WHERE (Approval_List_Name = X_Approval_List_Name)
         AND ((X_Rowid is NULL) or (ROWID <> X_Rowid))
    );