DBA Data[Home] [Help]

APPS.PA_ACTIONS_PUB dependencies on PA_TASKS

Line 2163: Pa_Tasks_Maint_Utils.CHECK_TASK_MGR_NAME_OR_ID (

2159: l_action_owner_id := p_action_owner_id_tbl(i_act);
2160: END IF;
2161:
2162: IF (l_action_owner_id IS NOT NULL ) THEN
2163: Pa_Tasks_Maint_Utils.CHECK_TASK_MGR_NAME_OR_ID (
2164: p_task_mgr_name => null
2165: ,p_task_mgr_id => l_action_owner_id
2166: ,p_project_id => p_project_id
2167: ,p_check_id_flag => 'Y'

Line 3111: PA_TASKS

3107: Cursor is_top_task (project_id NUMBER, fin_task_id NUMBER) IS
3108: SELECT
3109: TASK_NUMBER
3110: FROM
3111: PA_TASKS
3112: WHERE
3113: PROJECT_ID = project_id
3114: AND TASK_ID = TOP_TASK_ID
3115: AND TASK_ID = fin_task_id;

Line 3121: PA_TASKS

3117: Cursor is_lowest_task (project_id NUMBER, fin_task_id NUMBER) IS
3118: SELECT
3119: TASK_NUMBER
3120: FROM
3121: PA_TASKS
3122: WHERE
3123: PROJECT_ID = project_id
3124: AND TASK_ID = fin_task_id
3125: AND CHARGEABLE_FLAG = 'Y';