APPS.PA_PROJ_ASSET_ASSIGN_PKG SQL Statements

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

Line: 4

  PROCEDURE Insert_Row(X_Rowid                   IN OUT NOCOPY VARCHAR2,

                       X_Project_Asset_Id               NUMBER,
                       X_Task_Id                        NUMBER,
                       X_Project_Id                     NUMBER,
                       X_Last_Update_Date               DATE,
                       X_Last_Updated_By                NUMBER,
                       X_Creation_Date                  DATE,
                       X_Created_By                     NUMBER,
                       X_Last_Update_Login              NUMBER
  		) IS
    CURSOR C IS SELECT rowid FROM pa_project_asset_assignments
                 WHERE  project_asset_id = X_project_asset_id AND
			project_id = X_project_id AND
			task_id = X_task_id;

Line: 22

       INSERT INTO pa_project_asset_assignments(
              project_asset_id,
              task_id,
              project_id,
              last_update_date,
              last_updated_by,
              creation_date,
              created_by,
              last_update_login
             ) VALUES (
              X_Project_Asset_Id,
              X_Task_Id,
              X_Project_Id,
              X_Last_Update_Date,
              X_Last_Updated_By,
              X_Creation_Date,
              X_Created_By,
              X_Last_Update_Login
             );

Line: 49

  END Insert_Row;

Line: 58

        SELECT *
        FROM   pa_project_asset_assignments
        WHERE  rowid = X_Rowid
        FOR UPDATE of project_asset_id, project_id, task_id  NOWAIT;

Line: 69

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

Line: 89

  PROCEDURE Update_Row(X_Rowid                          VARCHAR2,
                       X_Project_Asset_Id               NUMBER,
                       X_Task_Id                        NUMBER,
                       X_Project_Id                     NUMBER,
                       X_Last_Update_Date               DATE,
                       X_Last_Updated_By                NUMBER,
                       X_Last_Update_Login              NUMBER

  ) IS
  BEGIN
    UPDATE pa_project_asset_assignments
    SET
       project_asset_id                =     X_Project_Asset_Id,
       task_id                         =     X_Task_Id,
       project_id                      =     X_Project_Id,
       last_update_date                =     X_Last_Update_Date,
       last_updated_by                 =     X_Last_Updated_By,
       last_update_login               =     X_Last_Update_Login
    WHERE rowid = X_Rowid;

Line: 112

  END Update_Row;

Line: 114

  PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
  BEGIN
    DELETE FROM pa_project_asset_assignments
    WHERE rowid = X_Rowid;

Line: 122

  END Delete_Row;