DBA Data[Home] [Help]

APPS.PJI_REP_DFLT_DRILLDOWN_TXN dependencies on PA_TASKS

Line 324: ELSIF l_object_type = 'PA_TASKS' THEN

320:
321: IF l_object_type = 'PA_STRUCTURES' THEN
322: -- in this case the selected proj_element_id is a structure
323: x_task_id := NULL;
324: ELSIF l_object_type = 'PA_TASKS' THEN
325: -- in this case the selected proj_element_id is a task
326: x_task_id := p_wbs_element_id;
327: END IF;
328:

Line 545: ELSIF l_object_type = 'PA_TASKS' THEN

541: -- in this case the selected proj_element_id is a structure
542: x_task_id := NULL;
543: x_show_events_flag := 'Y';
544:
545: ELSIF l_object_type = 'PA_TASKS' THEN
546:
547: -- in this case the selected proj_element_id is a task
548: x_task_id := p_wbs_element_id;
549:

Line 553: FROM pa_tasks

549:
550: BEGIN
551: SELECT chargeable_flag, top_task_id
552: INTO l_chargeable_flag, l_top_task_id
553: FROM pa_tasks
554: WHERE task_id = p_wbs_element_id;
555: EXCEPTION WHEN OTHERS THEN
556: l_top_task_id := NULL;
557: l_chargeable_flag := NULL;