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_FIN_PLAN_UTILS dependencies on PA_TASKS

Line 242: p_task_id IN pa_tasks.task_id%TYPE Default Null,

238: */
239:
240: FUNCTION Plan_Amount_Exists_Task_Res
241: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE ,
242: p_task_id IN pa_tasks.task_id%TYPE Default Null,
243: p_resource_list_member_id IN pa_resource_list_members.RESOURCE_LIST_MEMBER_ID%TYPE Default Null
244: ) RETURN VARCHAR2
245: IS
246: l_exists varchar2(1) := 'N';

Line 2907: Replacing all references of PA_TASKS by PA_STRUCT_TASK_WBS_V*/

2903: RAISE;
2904: END Check_Currency_Name_Or_Code;
2905:
2906: /* Changes for FP.M, Tracking Bug No - 3354518
2907: Replacing all references of PA_TASKS by PA_STRUCT_TASK_WBS_V*/
2908: /* Commenting code below for FP.M changes, Tracking Bug No - 3354518 */
2909: /*PROCEDURE check_task_name_or_id
2910: (p_project_id IN pa_tasks.project_id%TYPE,
2911: p_task_id IN pa_tasks.task_id%TYPE,

Line 2910: (p_project_id IN pa_tasks.project_id%TYPE,

2906: /* Changes for FP.M, Tracking Bug No - 3354518
2907: Replacing all references of PA_TASKS by PA_STRUCT_TASK_WBS_V*/
2908: /* Commenting code below for FP.M changes, Tracking Bug No - 3354518 */
2909: /*PROCEDURE check_task_name_or_id
2910: (p_project_id IN pa_tasks.project_id%TYPE,
2911: p_task_id IN pa_tasks.task_id%TYPE,
2912: p_task_name IN pa_tasks.task_name%TYPE,
2913: p_check_id_flag IN VARCHAR2,
2914: x_task_id OUT pa_tasks.task_id%TYPE,

Line 2911: p_task_id IN pa_tasks.task_id%TYPE,

2907: Replacing all references of PA_TASKS by PA_STRUCT_TASK_WBS_V*/
2908: /* Commenting code below for FP.M changes, Tracking Bug No - 3354518 */
2909: /*PROCEDURE check_task_name_or_id
2910: (p_project_id IN pa_tasks.project_id%TYPE,
2911: p_task_id IN pa_tasks.task_id%TYPE,
2912: p_task_name IN pa_tasks.task_name%TYPE,
2913: p_check_id_flag IN VARCHAR2,
2914: x_task_id OUT pa_tasks.task_id%TYPE,
2915: x_return_status OUT VARCHAR2,

Line 2912: p_task_name IN pa_tasks.task_name%TYPE,

2908: /* Commenting code below for FP.M changes, Tracking Bug No - 3354518 */
2909: /*PROCEDURE check_task_name_or_id
2910: (p_project_id IN pa_tasks.project_id%TYPE,
2911: p_task_id IN pa_tasks.task_id%TYPE,
2912: p_task_name IN pa_tasks.task_name%TYPE,
2913: p_check_id_flag IN VARCHAR2,
2914: x_task_id OUT pa_tasks.task_id%TYPE,
2915: x_return_status OUT VARCHAR2,
2916: x_msg_count OUT NUMBER,

Line 2914: x_task_id OUT pa_tasks.task_id%TYPE,

2910: (p_project_id IN pa_tasks.project_id%TYPE,
2911: p_task_id IN pa_tasks.task_id%TYPE,
2912: p_task_name IN pa_tasks.task_name%TYPE,
2913: p_check_id_flag IN VARCHAR2,
2914: x_task_id OUT pa_tasks.task_id%TYPE,
2915: x_return_status OUT VARCHAR2,
2916: x_msg_count OUT NUMBER,
2917: x_error_msg OUT VARCHAR2)*/
2918: /* Rewriting procedure declaration below to refer to pa_struct_task_wbs_v

Line 2919: instead of pa_tasks - as part of worplan structure model changes in FP.M */

2915: x_return_status OUT VARCHAR2,
2916: x_msg_count OUT NUMBER,
2917: x_error_msg OUT VARCHAR2)*/
2918: /* Rewriting procedure declaration below to refer to pa_struct_task_wbs_v
2919: instead of pa_tasks - as part of worplan structure model changes in FP.M */
2920: PROCEDURE check_task_name_or_id
2921: (p_project_id IN PA_STRUCT_TASK_WBS_V.project_id%TYPE,
2922: p_task_id IN PA_STRUCT_TASK_WBS_V.task_id%TYPE,
2923: p_task_name IN PA_STRUCT_TASK_WBS_V.task_name%TYPE,

Line 5423: , pa_tasks t

5419: from dual
5420: where exists
5421: (select 1
5422: from pa_budget_versions bv
5423: , pa_tasks t
5424: , pa_resource_assignments a
5425: where a.budget_version_id = bv.budget_version_id
5426: and a.task_id = t.task_id
5427: and a.resource_assignment_type = 'USER_ENTERED'

Line 5450: , pa_tasks t

5446: from dual
5447: where exists
5448: (select 1
5449: from pa_budget_versions bv
5450: , pa_tasks t
5451: , pa_resource_assignments a
5452: where a.budget_version_id = bv.budget_version_id
5453: and a.task_id = t.task_id
5454: and a.resource_assignment_type = 'USER_ENTERED'

Line 8952: ( /* p_task_id IN pa_tasks.task_id%TYPE Commenting out NOCOPY for to replace --File.Sql.39 bug 4440895

8948: referenced for any of the options(project/plan type/ plan version) in pa_fp_elements table.
8949: */
8950:
8951: PROCEDURE check_delete_task_ok
8952: ( /* p_task_id IN pa_tasks.task_id%TYPE Commenting out NOCOPY for to replace --File.Sql.39 bug 4440895
8953: pa_tasks by PA_STRUCT_TASK_WBS_V as part of FP.M, Tracking Bug No - 3354518 */
8954: p_task_id IN pa_struct_task_wbs_v.task_id%TYPE
8955: ,p_validation_mode IN VARCHAR2
8956: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 8953: pa_tasks by PA_STRUCT_TASK_WBS_V as part of FP.M, Tracking Bug No - 3354518 */

8949: */
8950:
8951: PROCEDURE check_delete_task_ok
8952: ( /* p_task_id IN pa_tasks.task_id%TYPE Commenting out NOCOPY for to replace --File.Sql.39 bug 4440895
8953: pa_tasks by PA_STRUCT_TASK_WBS_V as part of FP.M, Tracking Bug No - 3354518 */
8954: p_task_id IN pa_struct_task_wbs_v.task_id%TYPE
8955: ,p_validation_mode IN VARCHAR2
8956: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
8957: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 8976: Replacing all references of PA_TASKS by PA_STRUCT_TASK_WBS_V

8972:
8973: l_validation_success VARCHAR2(1) := 'Y'; /* Y when delete is allowed, N when delete is not allowed */
8974:
8975: /* Changes for FP.M, Tracking Bug No - 3354518
8976: Replacing all references of PA_TASKS by PA_STRUCT_TASK_WBS_V
8977: and of PA_FP_ELEMNTS by PA_RESOURCE_ASSIGNMENTS
8978: as PA_FP_ELEMENTS is being obsoleted*/
8979:
8980:

Line 8995: FROM PA_TASKS pt */ -- Commenting out code for FP.M, Tracking Bug No - 3354518

8991: FROM pa_fp_elements fe */
8992: /* Bug 2993894 ,pa_budget_versions bv */ -- Commenting out code for FP.M, Tracking Bug No - 3354518
8993: /* WHERE fe.task_id IN
8994: (SELECT pt.task_id
8995: FROM PA_TASKS pt */ -- Commenting out code for FP.M, Tracking Bug No - 3354518
8996: /* pa_tasks pt Commenting out for to replace pa_tasks by PA_STRUCT_TASK_WBS_V
8997: as part of FP.M, Tracking Bug No - 3354518 */
8998: /* CONNECT BY PRIOR pt.task_id = pt.parent_task_id
8999: START WITH pt.task_id = p_task_id)*/ -- Commenting out code for FP.M, Tracking Bug No - 3354518

Line 8996: /* pa_tasks pt Commenting out for to replace pa_tasks by PA_STRUCT_TASK_WBS_V

8992: /* Bug 2993894 ,pa_budget_versions bv */ -- Commenting out code for FP.M, Tracking Bug No - 3354518
8993: /* WHERE fe.task_id IN
8994: (SELECT pt.task_id
8995: FROM PA_TASKS pt */ -- Commenting out code for FP.M, Tracking Bug No - 3354518
8996: /* pa_tasks pt Commenting out for to replace pa_tasks by PA_STRUCT_TASK_WBS_V
8997: as part of FP.M, Tracking Bug No - 3354518 */
8998: /* CONNECT BY PRIOR pt.task_id = pt.parent_task_id
8999: START WITH pt.task_id = p_task_id)*/ -- Commenting out code for FP.M, Tracking Bug No - 3354518
9000: /* Bug 2993894 AND bv.budget_version_id = fe.fin_plan_version_id */

Line 9006: (SELECT pt.task_id /Changing refernece of pa_struct_task_wbs_v below to pa_tasks/

9002: SELECT 1
9003: FROM pa_resource_assignments r,
9004: pa_budget_versions bv
9005: WHERE r.task_id IN
9006: (SELECT pt.task_id /*Changing refernece of pa_struct_task_wbs_v below to pa_tasks*/
9007: FROM PA_TASKS pt /*Reverting changes for FPM, view pa_struct_task_wbs_v cannot be used in connect by clause*/
9008: CONNECT BY PRIOR pt.task_id = pt.parent_task_id
9009: START WITH pt.task_id = p_task_id)
9010: AND bv.budget_version_id = r.budget_version_id

Line 9007: FROM PA_TASKS pt /Reverting changes for FPM, view pa_struct_task_wbs_v cannot be used in connect by clause/

9003: FROM pa_resource_assignments r,
9004: pa_budget_versions bv
9005: WHERE r.task_id IN
9006: (SELECT pt.task_id /*Changing refernece of pa_struct_task_wbs_v below to pa_tasks*/
9007: FROM PA_TASKS pt /*Reverting changes for FPM, view pa_struct_task_wbs_v cannot be used in connect by clause*/
9008: CONNECT BY PRIOR pt.task_id = pt.parent_task_id
9009: START WITH pt.task_id = p_task_id)
9010: AND bv.budget_version_id = r.budget_version_id
9011: AND nvl(bv.wp_version_flag,'N') = 'N'); -- Added for FP.M, Tracking Bug No - 3354518

Line 9035: -- pa_tasks pt Commenting out for to replace pa_tasks by PA_STRUCT_TASK_WBS_V as part of FP.M, Tracking Bug No - 3354518

9031: pa_budget_versions bv
9032: WHERE fe.task_id IN
9033: (SELECT pt.task_id
9034: FROM PA_STRUCT_TASK_WBS_V pt
9035: -- pa_tasks pt Commenting out for to replace pa_tasks by PA_STRUCT_TASK_WBS_V as part of FP.M, Tracking Bug No - 3354518
9036: CONNECT BY PRIOR pt.task_id = pt.parent_task_id
9037: START WITH pt.task_id = p_task_id)
9038: -- AND bv.budget_version_id = fe.fin_plan_version_id
9039: -- Part of Changes for FP.M, Tracking Bug No - 3354518 , replace fin_plan_version_id by budget_version_id

Line 9050: -- pa_tasks pt Commenting out for to replace pa_tasks by PA_STRUCT_TASK_WBS_V as part of FP.M, Tracking Bug No - 3354518

9046: pa_budget_versions bv
9047: WHERE r.task_id IN
9048: (SELECT pt.task_id
9049: FROM PA_STRUCT_TASK_WBS_V pt
9050: -- pa_tasks pt Commenting out for to replace pa_tasks by PA_STRUCT_TASK_WBS_V as part of FP.M, Tracking Bug No - 3354518
9051: CONNECT BY PRIOR pt.task_id = pt.parent_task_id
9052: START WITH pt.task_id = p_task_id)
9053: AND bv.budget_version_id = r.budget_version_id
9054: AND nvl(bv.wp_version_flag,'N') = 'N' -- Added for FP.M, Tracking Bug No - 3354518

Line 9226: (p_task_id IN pa_tasks.task_id%TYPE

9222: RAISE;
9223: END check_delete_task_ok;
9224:
9225: PROCEDURE check_reparent_task_ok
9226: (p_task_id IN pa_tasks.task_id%TYPE
9227: ,p_old_parent_task_id IN pa_tasks.task_id%TYPE
9228: ,p_new_parent_task_id IN pa_tasks.task_id%TYPE
9229: ,p_validation_mode IN VARCHAR2
9230: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 9227: ,p_old_parent_task_id IN pa_tasks.task_id%TYPE

9223: END check_delete_task_ok;
9224:
9225: PROCEDURE check_reparent_task_ok
9226: (p_task_id IN pa_tasks.task_id%TYPE
9227: ,p_old_parent_task_id IN pa_tasks.task_id%TYPE
9228: ,p_new_parent_task_id IN pa_tasks.task_id%TYPE
9229: ,p_validation_mode IN VARCHAR2
9230: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
9231: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 9228: ,p_new_parent_task_id IN pa_tasks.task_id%TYPE

9224:
9225: PROCEDURE check_reparent_task_ok
9226: (p_task_id IN pa_tasks.task_id%TYPE
9227: ,p_old_parent_task_id IN pa_tasks.task_id%TYPE
9228: ,p_new_parent_task_id IN pa_tasks.task_id%TYPE
9229: ,p_validation_mode IN VARCHAR2
9230: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
9231: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
9232: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 9237: l_parent_top_task_id pa_tasks.top_task_id%TYPE;

9233: AS
9234:
9235: -- validation variables
9236: l_is_parent_lowest_task NUMBER(1);
9237: l_parent_top_task_id pa_tasks.top_task_id%TYPE;
9238: l_task_name pa_tasks.task_name%TYPE;
9239: l_old_parent_task_name pa_tasks.task_name%TYPE;
9240: l_new_parent_task_name pa_tasks.task_name%TYPE;
9241:

Line 9238: l_task_name pa_tasks.task_name%TYPE;

9234:
9235: -- validation variables
9236: l_is_parent_lowest_task NUMBER(1);
9237: l_parent_top_task_id pa_tasks.top_task_id%TYPE;
9238: l_task_name pa_tasks.task_name%TYPE;
9239: l_old_parent_task_name pa_tasks.task_name%TYPE;
9240: l_new_parent_task_name pa_tasks.task_name%TYPE;
9241:
9242: -- debugging variables

Line 9239: l_old_parent_task_name pa_tasks.task_name%TYPE;

9235: -- validation variables
9236: l_is_parent_lowest_task NUMBER(1);
9237: l_parent_top_task_id pa_tasks.top_task_id%TYPE;
9238: l_task_name pa_tasks.task_name%TYPE;
9239: l_old_parent_task_name pa_tasks.task_name%TYPE;
9240: l_new_parent_task_name pa_tasks.task_name%TYPE;
9241:
9242: -- debugging variables
9243: l_module_name VARCHAR2(100) := 'check_reparent_task_ok';

Line 9240: l_new_parent_task_name pa_tasks.task_name%TYPE;

9236: l_is_parent_lowest_task NUMBER(1);
9237: l_parent_top_task_id pa_tasks.top_task_id%TYPE;
9238: l_task_name pa_tasks.task_name%TYPE;
9239: l_old_parent_task_name pa_tasks.task_name%TYPE;
9240: l_new_parent_task_name pa_tasks.task_name%TYPE;
9241:
9242: -- debugging variables
9243: l_module_name VARCHAR2(100) := 'check_reparent_task_ok';
9244: l_return_status VARCHAR2(1);

Line 9251: cursor task_ra_csr (tid pa_tasks.task_id%TYPE) is

9247: l_msg_data VARCHAR2(2000);
9248: l_msg_index_out NUMBER;
9249: l_debug_mode VARCHAR2(1);
9250:
9251: cursor task_ra_csr (tid pa_tasks.task_id%TYPE) is
9252: select 1
9253: from pa_resource_assignments
9254: where task_id = tid;
9255: task_ra_rec task_ra_csr%ROWTYPE;

Line 9346: from pa_tasks

9342: x_return_status := FND_API.G_RET_STS_ERROR;
9343: BEGIN
9344: select task_name
9345: into l_task_name
9346: from pa_tasks
9347: where task_id = p_task_id;
9348: select task_name
9349: into l_old_parent_task_name
9350: from pa_tasks

Line 9350: from pa_tasks

9346: from pa_tasks
9347: where task_id = p_task_id;
9348: select task_name
9349: into l_old_parent_task_name
9350: from pa_tasks
9351: where task_id = p_old_parent_task_id;
9352: EXCEPTION
9353: when NO_DATA_FOUND then
9354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 9393: from pa_tasks

9389:
9390: -- VALIDATION: New parent task
9391: select top_task_id
9392: into l_parent_top_task_id
9393: from pa_tasks
9394: where task_id = p_new_parent_task_id;
9395: l_is_parent_lowest_task := pa_budget_utils2.check_task_lowest_in_budgets
9396: (x_task_id => p_new_parent_task_id,
9397: x_top_task_id => l_parent_top_task_id,

Line 9405: from pa_tasks

9401: x_return_status := FND_API.G_RET_STS_ERROR;
9402: BEGIN
9403: select task_name
9404: into l_task_name
9405: from pa_tasks
9406: where task_id = p_task_id;
9407: select task_name
9408: into l_new_parent_task_name
9409: from pa_tasks

Line 9409: from pa_tasks

9405: from pa_tasks
9406: where task_id = p_task_id;
9407: select task_name
9408: into l_new_parent_task_name
9409: from pa_tasks
9410: where task_id = p_new_parent_task_id;
9411: EXCEPTION
9412: when NO_DATA_FOUND then
9413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 9490: we change all references to pa_tasks to pa_struct_task_wbs_v

9486: This function is being called by PA_FP_ELEMENTS_PUB currently to verify,
9487: if PA_FP_ELEMENTS contains a entry for this task.
9488: This procedure is now obsoleted.
9489: However noticing that this procedure is re-usable,
9490: we change all references to pa_tasks to pa_struct_task_wbs_v
9491: and all references of pa_fp_elements to pa_resource_assignments*/
9492:
9493: FUNCTION check_task_in_fp_option
9494: (

Line 9495: /* p_task_id IN pa_tasks.task_id%TYPE */

9491: and all references of pa_fp_elements to pa_resource_assignments*/
9492:
9493: FUNCTION check_task_in_fp_option
9494: (
9495: /* p_task_id IN pa_tasks.task_id%TYPE */
9496: /* Changing reference of pa_tasks to pa_struct_task_wbs_v */
9497: p_task_id IN pa_struct_task_wbs_v.task_id%TYPE)
9498:
9499: RETURN VARCHAR2 AS

Line 9496: /* Changing reference of pa_tasks to pa_struct_task_wbs_v */

9492:
9493: FUNCTION check_task_in_fp_option
9494: (
9495: /* p_task_id IN pa_tasks.task_id%TYPE */
9496: /* Changing reference of pa_tasks to pa_struct_task_wbs_v */
9497: p_task_id IN pa_struct_task_wbs_v.task_id%TYPE)
9498:
9499: RETURN VARCHAR2 AS
9500:

Line 9591: , p_task_id IN pa_tasks.task_id%TYPE

9587:
9588: FUNCTION Get_Budgeted_Amount
9589: (
9590: p_project_id IN pa_projects_all.project_id%TYPE
9591: , p_task_id IN pa_tasks.task_id%TYPE
9592: , p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE
9593: , p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
9594: , p_amount_type IN VARCHAR2
9595: ) RETURN NUMBER

Line 10404: ,p_task_id IN pa_tasks.task_id%TYPE)

10400: /* To determine if a task is a planning element or not */
10401: -- Modified for Bug 3840993 --sagarwal
10402: FUNCTION IS_TASK_A_PLANNING_ELEMENT(
10403: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
10404: ,p_task_id IN pa_tasks.task_id%TYPE)
10405: RETURN VARCHAR2 IS
10406: l_exists VARCHAR2(1);
10407: l_structure_version_id pa_budget_versions.project_structure_version_id%TYPE;
10408:

Line 10539: AND ppev1.object_type = 'PA_TASKS';

10535: WHERE ppev2.object_type = 'PA_STRUCTURES'
10536: AND ppev2.project_id = p_project_id
10537: AND ppev2.proj_element_id = c_structure_id
10538: AND ppev1.parent_structure_version_id = ppev2.element_version_id
10539: AND ppev1.object_type = 'PA_TASKS';
10540: /*** Bug 3683382 modified the query for performance
10541: SELECT proj_element_id
10542: from pa_proj_elements
10543: where project_id = p_project_id

Line 10544: and object_type = 'PA_TASKS'

10540: /*** Bug 3683382 modified the query for performance
10541: SELECT proj_element_id
10542: from pa_proj_elements
10543: where project_id = p_project_id
10544: and object_type = 'PA_TASKS'
10545: and proj_element_id IN (
10546: select ppev1.proj_element_id
10547: from pa_proj_element_versions ppev1,
10548: pa_proj_element_versions ppev2

Line 12966: p_object_type => 'PA_TASKS',

12962: PA_PROGRESS_UTILS.REDEFAULT_BASE_PC
12963: (p_project_id => p_project_id,
12964: p_proj_element_id => p_proj_element_id,
12965: p_structure_type => 'FINANCIAL',
12966: p_object_type => 'PA_TASKS',
12967: p_as_of_date => trunc(SYSDATE),
12968: p_structure_version_id => g_fp_wa_struct_ver_id,
12969: p_structure_status => l_structure_status,
12970: p_calling_context => 'FINANCIAL_PLANNING',