APPS.PA_PROJECT_CORE dependencies on PA_LABOR_MULTIPLIERS

Line 357: -- delete from pa_labor_multipliers

353:
354: -- anlee
355: -- Commented out for performance bug 2800018
356: -- Delete labor multipliers
357: -- delete from pa_labor_multipliers
358: -- where (project_id = x_project_id
359: -- or task_id in (select task_id from pa_tasks
360: -- where project_id = x_project_id));
361:

Line 367: DELETE FROM PA_LABOR_MULTIPLIERS

363: open get_all_tasks ;
364: fetch get_all_tasks bulk collect into l_tasks_tbl;
365: close get_all_tasks ;
366:
367: DELETE FROM PA_LABOR_MULTIPLIERS
368: WHERE PROJECT_ID = x_project_id;
369:
370: -- commented for bug#3693197 and replaced with bulk delete
371: -- DELETE FROM PA_LABOR_MULTIPLIERS

Line 371: -- DELETE FROM PA_LABOR_MULTIPLIERS

367: DELETE FROM PA_LABOR_MULTIPLIERS
368: WHERE PROJECT_ID = x_project_id;
369:
370: -- commented for bug#3693197 and replaced with bulk delete
371: -- DELETE FROM PA_LABOR_MULTIPLIERS
372: -- WHERE ( TASK_ID IN (SELECT TASK_ID
373: -- FROM PA_TASKS
374: -- WHERE PROJECT_ID = x_project_id ));
375:

Line 378: DELETE FROM PA_LABOR_MULTIPLIERS

374: -- WHERE PROJECT_ID = x_project_id ));
375:
376: if nvl(l_tasks_tbl.last,0) > 0 then
377: forall i in l_tasks_tbl.first..l_tasks_tbl.last
378: DELETE FROM PA_LABOR_MULTIPLIERS
379: WHERE task_id = l_tasks_tbl(i);
380: end if ;
381:
382: -- anlee

Line 1632: -- delete from pa_labor_multipliers

1628: -- Delete billing assignments
1629: --x_err_stage := 'Delete billing assignmts for task '|| x_task_id;
1630: -- Delete labor multipliers
1631: -- x_err_stage := 'Delete labor multipliers for task '|| x_task_id;
1632: -- delete from pa_labor_multipliers
1633: -- where task_id in
1634: -- (select task_id
1635: -- from pa_tasks
1636: -- CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID

Line 1803: delete from pa_labor_multipliers

1799:
1800: -- Delete labor multipliers
1801: x_err_stage := 'Delete labor multipliers for task '|| x_task_id;
1802: forall i in l_task_id_tab.FIRST..l_task_id_tab.LAST
1803: delete from pa_labor_multipliers
1804: where task_id =l_task_id_tab(i) ;
1805:
1806: -- Delete job bill rate overrides
1807: x_err_stage := 'Delete job bill rate overrides for task '|| x_task_id;