APPS.PA_TASKS_MAINT_PVT dependencies on PA_PROJECT_PUB

Line 2738: PA_PROJECT_PUB.CHECK_CHANGE_PARENT_OK(

2734:
2735: --dbms_output.put_line( 'In update task 14 '|| l_msg_count);
2736:
2737:
2738: PA_PROJECT_PUB.CHECK_CHANGE_PARENT_OK(
2739: p_api_version_number => 1.0,
2740: p_project_id => p_project_id,
2741: p_task_id => p_task_id,
2742: p_new_parent_task_id => p_parent_task_id,

Line 5889: IF (NVL(PA_PROJECT_PUB.G_ROLLUP_DEFER,'N')='Y')

5885: --dbms_output.put_line( 'In move task 5' );
5886: -- added for bug 16088808
5887: --If user deferred the rollup, then open cur_task_detail cursor instead of cur_tasks.
5888: --System should update new parent task id only for selected task not for all children of selected task.
5889: IF (NVL(PA_PROJECT_PUB.G_ROLLUP_DEFER,'N')='Y')
5890: THEN
5891: OPEN cur_task_detail;
5892: ELSE
5893: OPEN cur_tasks;

Line 5897: IF (NVL(PA_PROJECT_PUB.G_ROLLUP_DEFER,'N')='Y')

5893: OPEN cur_tasks;
5894: END IF;
5895: --FOR cur_tasks_rec IN cur_tasks LOOP
5896: Loop
5897: IF (NVL(PA_PROJECT_PUB.G_ROLLUP_DEFER,'N')='Y')
5898: THEN
5899: FETCH cur_task_detail INTO cur_tasks_rec;
5900: EXIT WHEN cur_task_detail%NOTFOUND;
5901: ELSE

Line 5905: IF ((NVL(PA_PROJECT_PUB.G_ROLLUP_DEFER,'N')='Y' and cur_task_detail%ROWCOUNT = 1) or (NVL(PA_PROJECT_PUB.G_ROLLUP_DEFER,'N')='N' and cur_tasks%ROWCOUNT = 1))

5901: ELSE
5902: FETCH cur_tasks INTO cur_tasks_rec;
5903: EXIT WHEN cur_tasks%NOTFOUND;
5904: END IF;
5905: IF ((NVL(PA_PROJECT_PUB.G_ROLLUP_DEFER,'N')='Y' and cur_task_detail%ROWCOUNT = 1) or (NVL(PA_PROJECT_PUB.G_ROLLUP_DEFER,'N')='N' and cur_tasks%ROWCOUNT = 1))
5906: THEN
5907: l_lowest_moving_wbs_level := cur_tasks_rec.wbs_level;
5908:
5909: --make the top task for p_task and its children as p_task