APPS.PA_ASSIGN_ASSETS_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               IN OUT NOCOPY 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,
                       X_Attribute_Category             VARCHAR2,
                       X_Attribute1                     VARCHAR2,
                       X_Attribute2                     VARCHAR2,
                       X_Attribute3                     VARCHAR2,
                       X_Attribute4                     VARCHAR2,
                       X_Attribute5                     VARCHAR2,
                       X_Attribute6                     VARCHAR2,
                       X_Attribute7                     VARCHAR2,
                       X_Attribute8                     VARCHAR2,
                       X_Attribute9                     VARCHAR2,
                       X_Attribute10                    VARCHAR2,
                       X_Attribute11                    VARCHAR2,
                       X_Attribute12                    VARCHAR2,
                       X_Attribute13                    VARCHAR2,
                       X_Attribute14                    VARCHAR2,
                       X_Attribute15                    VARCHAR2
  ) IS

    CURSOR C IS SELECT rowid FROM pa_project_asset_assignments
                 WHERE project_asset_id = X_Project_Asset_Id
		   AND task_id = nvl(X_Task_Id,0)
		   AND project_id = X_Project_Id;

Line: 38

       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,
              attribute_category,
              attribute1,
              attribute2,
              attribute3,
              attribute4,
              attribute5,
              attribute6,
              attribute7,
              attribute8,
              attribute9,
              attribute10,
              attribute11,
              attribute12,
              attribute13,
              attribute14,
              attribute15
             ) VALUES (
              X_Project_Asset_Id,
              nvl(X_Task_Id,0),
              X_Project_Id,
              X_Last_Update_Date,
              X_Last_Updated_By,
              X_Creation_Date,
              X_Created_By,
              X_Last_Update_Login,
              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
             );

Line: 97

  END Insert_Row;

Line: 123

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

Line: 135

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

Line: 200

  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,
                       X_Attribute_Category             VARCHAR2,
                       X_Attribute1                     VARCHAR2,
                       X_Attribute2                     VARCHAR2,
                       X_Attribute3                     VARCHAR2,
                       X_Attribute4                     VARCHAR2,
                       X_Attribute5                     VARCHAR2,
                       X_Attribute6                     VARCHAR2,
                       X_Attribute7                     VARCHAR2,
                       X_Attribute8                     VARCHAR2,
                       X_Attribute9                     VARCHAR2,
                       X_Attribute10                    VARCHAR2,
                       X_Attribute11                    VARCHAR2,
                       X_Attribute12                    VARCHAR2,
                       X_Attribute13                    VARCHAR2,
                       X_Attribute14                    VARCHAR2,
                       X_Attribute15                    VARCHAR2

  ) 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,
       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
    WHERE rowid = X_Rowid;

Line: 255

  END Update_Row;

Line: 258

  PROCEDURE Delete_Row(X_Rowid 				VARCHAR2,
		       X_project_asset_id 		NUMBER,
                       X_Task_Id                        NUMBER,
                       X_Project_Id                     NUMBER
	              ) IS
  BEGIN
    DELETE FROM pa_project_asset_assignments
    WHERE project_asset_id = X_project_asset_id
      AND task_id = X_Task_Id
      AND project_id = X_Project_Id;

Line: 273

  END Delete_Row;