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 1782: ,p_impacted_task_id IN pa_tasks.task_id%TYPE

1778: PROCEDURE Is_Create_CI_Version_Allowed
1779: ( p_project_id IN pa_budget_versions.project_id%TYPE
1780: ,p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE
1781: ,p_version_type IN pa_budget_versions.version_type%TYPE
1782: ,p_impacted_task_id IN pa_tasks.task_id%TYPE
1783: ,x_version_allowed_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1784: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1785: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1786: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

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

1813:
1814: -- ---------------------------------------------------------------------------
1815:
1816:
1817: CURSOR impacted_task_cur(c_impacted_task_id pa_tasks.task_id%TYPE) IS
1818: SELECT parent_task_id,
1819: top_task_id
1820: FROM pa_tasks
1821: WHERE task_id = c_impacted_task_id;

Line 1820: FROM pa_tasks

1816:
1817: CURSOR impacted_task_cur(c_impacted_task_id pa_tasks.task_id%TYPE) IS
1818: SELECT parent_task_id,
1819: top_task_id
1820: FROM pa_tasks
1821: WHERE task_id = c_impacted_task_id;
1822:
1823: impacted_task_rec impacted_task_cur%ROWTYPE;
1824:

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

1821: WHERE task_id = c_impacted_task_id;
1822:
1823: impacted_task_rec impacted_task_cur%ROWTYPE;
1824:
1825: /*CURSOR cur_impact_task_level_M_top (c_task_id pa_tasks.task_id%TYPE) IS
1826: SELECT COUNT(1)
1827: FROM DUAL
1828: WHERE EXISTS
1829: (SELECT 'X'

Line 1846: FROM pa_tasks t

1842: WHERE pra.budget_version_id = l_ci_apprv_cw_bv_id
1843: AND pra.project_id = p_project_id
1844: AND pra.project_assignment_id = -1
1845: AND EXISTS ( SELECT 1
1846: FROM pa_tasks t
1847: WHERE t.parent_task_id = p_impacted_task_id
1848: START WITH t.task_id = pra.task_id
1849: CONNECT BY PRIOR t.parent_task_id = t.task_id));
1850:

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

1847: WHERE t.parent_task_id = p_impacted_task_id
1848: START WITH t.task_id = pra.task_id
1849: CONNECT BY PRIOR t.parent_task_id = t.task_id));
1850:
1851: CURSOR cur_impact_task_level_L (c_top_task_id pa_tasks.task_id%TYPE) IS
1852: SELECT COUNT(1)
1853: FROM DUAL
1854: WHERE EXISTS
1855: (SELECT 'X'

Line 1869: pa_tasks t

1865: FROM DUAL
1866: WHERE EXISTS
1867: (SELECT 'X'
1868: FROM pa_resource_assignments pra,
1869: pa_tasks t
1870: WHERE pra.budget_version_id = l_ci_apprv_cw_bv_id
1871: AND pra.project_id = p_project_id
1872: AND pra.project_assignment_id = -1
1873: AND t.task_id=pra.task_id

Line 2056: FROM pa_tasks

2052: ELSE
2053: BEGIN
2054: SELECT count(task_id)
2055: INTO l_count
2056: FROM pa_tasks
2057: WHERE parent_task_id = p_impacted_task_id;
2058:
2059: IF l_count = 0
2060: THEN

Line 3586: pa_tasks t where

3582: nvl(fpe.top_task_planning_level,'LOWEST')
3583: top_task_planning_level
3584: from
3585: pa_fp_elements fpe,
3586: pa_tasks t where
3587: fpe.proj_fp_options_id = c_fp_opt_id and
3588: fpe.element_type = c_ver_type and
3589: fpe.task_id = t.task_id and
3590: fpe.resource_list_member_id = 0 and

Line 3601: l_target_task_name pa_tasks.TASK_NAME%type;

3597: l_target_plan_level varchar2(1);
3598: l_error_msg_header_flag varchar2(1);
3599: l_message_code varchar2(100);
3600: l_target_task_id number;
3601: l_target_task_name pa_tasks.TASK_NAME%type;
3602: l_target_task_number pa_tasks.TASK_NUMBER%type;
3603: l_prj_rlm_id NUMBER;
3604: l_prj_rlm_id_target NUMBER;
3605: l_target_prj_plan_level varchar2(1);

Line 3602: l_target_task_number pa_tasks.TASK_NUMBER%type;

3598: l_error_msg_header_flag varchar2(1);
3599: l_message_code varchar2(100);
3600: l_target_task_id number;
3601: l_target_task_name pa_tasks.TASK_NAME%type;
3602: l_target_task_number pa_tasks.TASK_NUMBER%type;
3603: l_prj_rlm_id NUMBER;
3604: l_prj_rlm_id_target NUMBER;
3605: l_target_prj_plan_level varchar2(1);
3606: l_source_fp_opt_id NUMBER;

Line 3812: from pa_Tasks where task_id = l_target_task_id;

3808: begin
3809: select task_name,task_number into
3810: l_target_task_name,
3811: l_target_task_number
3812: from pa_Tasks where task_id = l_target_task_id;
3813: exception
3814: when no_data_found then
3815: l_target_task_name := NULL;
3816: l_target_task_number := NULL;

Line 3982: pa_tasks t where

3978: NVL(fpe.top_task_planning_level,'LOWEST')
3979: top_task_planning_level
3980: from
3981: pa_fp_elements fpe,
3982: pa_tasks t where
3983: fpe.proj_fp_options_id = c_fp_opt_id and
3984: fpe.element_type = c_ver_type and
3985: fpe.task_id = t.task_id and
3986: fpe.resource_list_member_id = 0 and

Line 3997: l_target_task_name pa_tasks.TASK_NAME%type;

3993: has been removed from the cursor
3994: NVL(fpe.top_task_planning_level,'LOWEST') = 'TOP' */
3995: l_message_code varchar2(100);
3996: l_target_task_id number;
3997: l_target_task_name pa_tasks.TASK_NAME%type;
3998: l_target_task_number pa_tasks.TASK_NUMBER%type;
3999: l_prj_rlm_id NUMBER;
4000: l_prj_rlm_id_target NUMBER;
4001: l_target_prj_plan_level varchar2(1);

Line 3998: l_target_task_number pa_tasks.TASK_NUMBER%type;

3994: NVL(fpe.top_task_planning_level,'LOWEST') = 'TOP' */
3995: l_message_code varchar2(100);
3996: l_target_task_id number;
3997: l_target_task_name pa_tasks.TASK_NAME%type;
3998: l_target_task_number pa_tasks.TASK_NUMBER%type;
3999: l_prj_rlm_id NUMBER;
4000: l_prj_rlm_id_target NUMBER;
4001: l_target_prj_plan_level varchar2(1);
4002: l_source_fp_opt_id NUMBER;

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

4146: l_target_plan_level = 'LOWEST' then
4147: IF p_pa_debug_mode = 'Y' THEN
4148: PA_DEBUG.write_log (x_module =>
4149: 'pa.plsql.Pa_Fp_Control_Items_Utils.chk_tsk_plan_level_mismatch'
4150: ,x_msg => 'getting the task info from pa_tasks table'
4151: ,x_log_level => 5);
4152: END IF;
4153: begin
4154: select task_name,task_number into

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

4153: begin
4154: select task_name,task_number into
4155: l_target_task_name,
4156: l_target_task_number
4157: from pa_Tasks where task_id = tsk_rec.task_id;
4158: exception
4159: when no_data_found then
4160: l_target_task_name := NULL;
4161: l_target_task_number := NULL;