eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_CONTROL_ITEMS_UTILS dependencies on PA_TASKS

Line 1816: ,p_impacted_task_id IN pa_tasks.task_id%TYPE

1812: PROCEDURE Is_Create_CI_Version_Allowed
1813: ( p_project_id IN pa_budget_versions.project_id%TYPE
1814: ,p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE
1815: ,p_version_type IN pa_budget_versions.version_type%TYPE
1816: ,p_impacted_task_id IN pa_tasks.task_id%TYPE
1817: ,x_version_allowed_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1818: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1819: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1820: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 1851: CURSOR impacted_task_cur(c_impacted_task_id pa_tasks.task_id%TYPE) IS

1847:
1848: -- ---------------------------------------------------------------------------
1849:
1850:
1851: CURSOR impacted_task_cur(c_impacted_task_id pa_tasks.task_id%TYPE) IS
1852: SELECT parent_task_id,
1853: top_task_id
1854: FROM pa_tasks
1855: WHERE task_id = c_impacted_task_id;

Line 1854: FROM pa_tasks

1850:
1851: CURSOR impacted_task_cur(c_impacted_task_id pa_tasks.task_id%TYPE) IS
1852: SELECT parent_task_id,
1853: top_task_id
1854: FROM pa_tasks
1855: WHERE task_id = c_impacted_task_id;
1856:
1857: impacted_task_rec impacted_task_cur%ROWTYPE;
1858:

Line 1859: /*CURSOR cur_impact_task_level_M_top (c_task_id pa_tasks.task_id%TYPE) IS

1855: WHERE task_id = c_impacted_task_id;
1856:
1857: impacted_task_rec impacted_task_cur%ROWTYPE;
1858:
1859: /*CURSOR cur_impact_task_level_M_top (c_task_id pa_tasks.task_id%TYPE) IS
1860: SELECT COUNT(1)
1861: FROM DUAL
1862: WHERE EXISTS
1863: (SELECT 'X'

Line 1880: FROM pa_tasks t

1876: WHERE pra.budget_version_id = l_ci_apprv_cw_bv_id
1877: AND pra.project_id = p_project_id
1878: AND pra.project_assignment_id = -1
1879: AND EXISTS ( SELECT 1
1880: FROM pa_tasks t
1881: WHERE t.parent_task_id = p_impacted_task_id
1882: START WITH t.task_id = pra.task_id
1883: CONNECT BY PRIOR t.parent_task_id = t.task_id));
1884:

Line 1885: CURSOR cur_impact_task_level_L (c_top_task_id pa_tasks.task_id%TYPE) IS

1881: WHERE t.parent_task_id = p_impacted_task_id
1882: START WITH t.task_id = pra.task_id
1883: CONNECT BY PRIOR t.parent_task_id = t.task_id));
1884:
1885: CURSOR cur_impact_task_level_L (c_top_task_id pa_tasks.task_id%TYPE) IS
1886: SELECT COUNT(1)
1887: FROM DUAL
1888: WHERE EXISTS
1889: (SELECT 'X'

Line 1903: pa_tasks t

1899: FROM DUAL
1900: WHERE EXISTS
1901: (SELECT 'X'
1902: FROM pa_resource_assignments pra,
1903: pa_tasks t
1904: WHERE pra.budget_version_id = l_ci_apprv_cw_bv_id
1905: AND pra.project_id = p_project_id
1906: AND pra.project_assignment_id = -1
1907: AND t.task_id=pra.task_id

Line 2090: FROM pa_tasks

2086: ELSE
2087: BEGIN
2088: SELECT count(task_id)
2089: INTO l_count
2090: FROM pa_tasks
2091: WHERE parent_task_id = p_impacted_task_id;
2092:
2093: IF l_count = 0
2094: THEN

Line 3635: pa_tasks t where

3631: nvl(fpe.top_task_planning_level,'LOWEST')
3632: top_task_planning_level
3633: from
3634: pa_fp_elements fpe,
3635: pa_tasks t where
3636: fpe.proj_fp_options_id = c_fp_opt_id and
3637: fpe.element_type = c_ver_type and
3638: fpe.task_id = t.task_id and
3639: fpe.resource_list_member_id = 0 and

Line 3650: l_target_task_name pa_tasks.TASK_NAME%type;

3646: l_target_plan_level varchar2(1);
3647: l_error_msg_header_flag varchar2(1);
3648: l_message_code varchar2(100);
3649: l_target_task_id number;
3650: l_target_task_name pa_tasks.TASK_NAME%type;
3651: l_target_task_number pa_tasks.TASK_NUMBER%type;
3652: l_prj_rlm_id NUMBER;
3653: l_prj_rlm_id_target NUMBER;
3654: l_target_prj_plan_level varchar2(1);

Line 3651: l_target_task_number pa_tasks.TASK_NUMBER%type;

3647: l_error_msg_header_flag varchar2(1);
3648: l_message_code varchar2(100);
3649: l_target_task_id number;
3650: l_target_task_name pa_tasks.TASK_NAME%type;
3651: l_target_task_number pa_tasks.TASK_NUMBER%type;
3652: l_prj_rlm_id NUMBER;
3653: l_prj_rlm_id_target NUMBER;
3654: l_target_prj_plan_level varchar2(1);
3655: l_source_fp_opt_id NUMBER;

Line 3861: from pa_Tasks where task_id = l_target_task_id;

3857: begin
3858: select task_name,task_number into
3859: l_target_task_name,
3860: l_target_task_number
3861: from pa_Tasks where task_id = l_target_task_id;
3862: exception
3863: when no_data_found then
3864: l_target_task_name := NULL;
3865: l_target_task_number := NULL;

Line 4031: pa_tasks t where

4027: NVL(fpe.top_task_planning_level,'LOWEST')
4028: top_task_planning_level
4029: from
4030: pa_fp_elements fpe,
4031: pa_tasks t where
4032: fpe.proj_fp_options_id = c_fp_opt_id and
4033: fpe.element_type = c_ver_type and
4034: fpe.task_id = t.task_id and
4035: fpe.resource_list_member_id = 0 and

Line 4046: l_target_task_name pa_tasks.TASK_NAME%type;

4042: has been removed from the cursor
4043: NVL(fpe.top_task_planning_level,'LOWEST') = 'TOP' */
4044: l_message_code varchar2(100);
4045: l_target_task_id number;
4046: l_target_task_name pa_tasks.TASK_NAME%type;
4047: l_target_task_number pa_tasks.TASK_NUMBER%type;
4048: l_prj_rlm_id NUMBER;
4049: l_prj_rlm_id_target NUMBER;
4050: l_target_prj_plan_level varchar2(1);

Line 4047: l_target_task_number pa_tasks.TASK_NUMBER%type;

4043: NVL(fpe.top_task_planning_level,'LOWEST') = 'TOP' */
4044: l_message_code varchar2(100);
4045: l_target_task_id number;
4046: l_target_task_name pa_tasks.TASK_NAME%type;
4047: l_target_task_number pa_tasks.TASK_NUMBER%type;
4048: l_prj_rlm_id NUMBER;
4049: l_prj_rlm_id_target NUMBER;
4050: l_target_prj_plan_level varchar2(1);
4051: l_source_fp_opt_id NUMBER;

Line 4199: ,x_msg => 'getting the task info from pa_tasks table'

4195: l_target_plan_level = 'LOWEST' then
4196: IF p_pa_debug_mode = 'Y' THEN
4197: PA_DEBUG.write_log (x_module =>
4198: 'pa.plsql.Pa_Fp_Control_Items_Utils.chk_tsk_plan_level_mismatch'
4199: ,x_msg => 'getting the task info from pa_tasks table'
4200: ,x_log_level => 5);
4201: END IF;
4202: begin
4203: select task_name,task_number into

Line 4206: from pa_Tasks where task_id = tsk_rec.task_id;

4202: begin
4203: select task_name,task_number into
4204: l_target_task_name,
4205: l_target_task_number
4206: from pa_Tasks where task_id = tsk_rec.task_id;
4207: exception
4208: when no_data_found then
4209: l_target_task_name := NULL;
4210: l_target_task_number := NULL;