APPS.GMS_BUDGET_PUB dependencies on PA_TASKS

Line 156: from pa_tasks

152: cursor l_task_id_csr(p_project_id_in NUMBER,
153: p_task_id_in NUMBER)
154: IS
155: select 'X'
156: from pa_tasks
157: where project_id = p_project_id_in
158: and task_id = p_task_id_in;
159:
160: cursor l_task_number_csr(p_project_id_in NUMBER,

Line 164: from pa_tasks

160: cursor l_task_number_csr(p_project_id_in NUMBER,
161: p_task_number_in VARCHAR2)
162: is
163: select task_id
164: from pa_tasks
165: where task_number = p_task_number_in
166: and project_id = p_project_id_in;
167:
168: l_dummy VARCHAR2(1);

Line 944: and ( x_budget_funding_level = 'T' and exists (select 1 from pa_tasks pat

940: and gra.resource_assignment_id = gbl.resource_assignment_id
941: and gbv.project_id = x_project_id
942: and gbv.award_id = x_award_id
943: and budget_status_code = 'W' -- since we are dealing with a draft budget ONLY
944: and ( x_budget_funding_level = 'T' and exists (select 1 from pa_tasks pat
945: where pat.top_task_id = x_top_task_id
946: and pat.task_id = gra.task_id)
947: or x_budget_funding_level = 'P')
948: group by trunc(start_date), trunc(end_date)

Line 970: and ( x_budget_funding_level = 'T' and exists (select 1 from pa_tasks pat

966: and gra.resource_assignment_id = gbl.resource_assignment_id
967: and gbv.project_id = x_project_id
968: and gbv.award_id = x_award_id
969: and budget_status_code = 'W' -- since we are dealing with a draft budget ONLY
970: and ( x_budget_funding_level = 'T' and exists (select 1 from pa_tasks pat
971: where pat.top_task_id = x_top_task_id
972: and pat.task_id = gra.task_id)
973: or x_budget_funding_level = 'P')
974: group by trunc(start_date), trunc(end_date)

Line 1052: from pa_tasks

1048: null;
1049: else
1050: select top_Task_id
1051: into x_top_task_id
1052: from pa_tasks
1053: where task_id = x_task_id;
1054: end if;
1055:
1056: select decode(entry_level_code, 'P','P','T')

Line 4546: pa_tasks_pkg.verify_lowest_level_task( l_return_status_task,

4542: END IF;
4543:
4544: ELSIF l_budget_entry_method_rec.entry_level_code = 'L' -- then check whether it is lowest task
4545: THEN
4546: pa_tasks_pkg.verify_lowest_level_task( l_return_status_task,
4547: l_task_id);
4548: IF l_return_status_task <> 0 THEN
4549: gms_error_pkg.gms_message(x_err_name => 'GMS_TASK_IS_NOT_LOWEST',
4550: x_err_code => x_err_code,

Line 4560: pa_tasks_pkg.verify_lowest_level_task( l_return_status_task

4556: ELSIF l_budget_entry_method_rec.entry_level_code = 'M' -- then check whether it is a top or
4557: -- lowest level tasks
4558: THEN
4559: IF l_task_id <> pa_task_utils.get_top_task_id( l_task_id ) THEN
4560: pa_tasks_pkg.verify_lowest_level_task( l_return_status_task
4561: , l_task_id);
4562: IF l_return_status_task <> 0 THEN
4563: gms_error_pkg.gms_message(x_err_name => 'GMS_TASK_IS_NOT_TOP_OR_LOWEST',
4564: x_err_code => x_err_code,