APPS.PA_ASSIGN_ASSETS_PKG dependencies on PA_PROJECT_ASSET_ASSIGNMENTS

Line 31: CURSOR C IS SELECT rowid FROM pa_project_asset_assignments

27: X_Attribute14 VARCHAR2,
28: X_Attribute15 VARCHAR2
29: ) IS
30:
31: CURSOR C IS SELECT rowid FROM pa_project_asset_assignments
32: WHERE project_asset_id = X_Project_Asset_Id
33: AND task_id = nvl(X_Task_Id,0)
34: AND project_id = X_Project_Id;
35:

Line 38: INSERT INTO pa_project_asset_assignments(

34: AND project_id = X_Project_Id;
35:
36: BEGIN
37:
38: INSERT INTO pa_project_asset_assignments(
39: project_asset_id,
40: task_id,
41: project_id,
42: last_update_date,

Line 124: FROM pa_project_asset_assignments

120: ) IS
121:
122: CURSOR C IS
123: SELECT *
124: FROM pa_project_asset_assignments
125: WHERE rowid = X_Rowid
126: FOR UPDATE of task_id NOWAIT;
127:
128: Recinfo C%ROWTYPE;

Line 226: UPDATE pa_project_asset_assignments

222: X_Attribute15 VARCHAR2
223:
224: ) IS
225: BEGIN
226: UPDATE pa_project_asset_assignments
227: SET
228: project_asset_id = X_Project_Asset_Id,
229: task_id = X_Task_Id,
230: project_id = X_Project_Id,

Line 264: DELETE FROM pa_project_asset_assignments

260: X_Task_Id NUMBER,
261: X_Project_Id NUMBER
262: ) IS
263: BEGIN
264: DELETE FROM pa_project_asset_assignments
265: WHERE project_asset_id = X_project_asset_id
266: AND task_id = X_Task_Id
267: AND project_id = X_Project_Id;
268: