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 3112: PA_TASKS

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

Line 3122: PA_TASKS

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