11: X_Creation_Date DATE,
12: X_Created_By NUMBER,
13: X_Last_Update_Login NUMBER
14: ) IS
15: CURSOR C IS SELECT rowid FROM pa_project_asset_assignments
16: WHERE project_asset_id = X_project_asset_id AND
17: project_id = X_project_id AND
18: task_id = X_task_id;
19:
18: task_id = X_task_id;
19:
20: BEGIN
21:
22: INSERT INTO pa_project_asset_assignments(
23: project_asset_id,
24: task_id,
25: project_id,
26: last_update_date,
55: X_Project_Id NUMBER
56: ) IS
57: CURSOR C IS
58: SELECT *
59: FROM pa_project_asset_assignments
60: WHERE rowid = X_Rowid
61: FOR UPDATE of project_asset_id, project_id, task_id NOWAIT;
62: Recinfo C%ROWTYPE;
63:
95: X_Last_Update_Login NUMBER
96:
97: ) IS
98: BEGIN
99: UPDATE pa_project_asset_assignments
100: SET
101: project_asset_id = X_Project_Asset_Id,
102: task_id = X_Task_Id,
103: project_id = X_Project_Id,
112: END Update_Row;
113:
114: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
115: BEGIN
116: DELETE FROM pa_project_asset_assignments
117: WHERE rowid = X_Rowid;
118:
119: if (SQL%NOTFOUND) then
120: Raise NO_DATA_FOUND;