APPS.PA_PROJ_ASSET_ASSIGN_PKG dependencies on PA_PROJECT_ASSET_ASSIGNMENTS

Line 15: CURSOR C IS SELECT rowid FROM pa_project_asset_assignments

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:

Line 22: INSERT INTO pa_project_asset_assignments(

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,

Line 59: FROM pa_project_asset_assignments

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:

Line 99: UPDATE pa_project_asset_assignments

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,

Line 116: DELETE FROM pa_project_asset_assignments

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;