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.

[Home] [Help]

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 2905: Replacing all references of PA_TASKS by PA_STRUCT_TASK_WBS_V*/

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

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

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

Line 2909: p_task_id IN pa_tasks.task_id%TYPE,

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

Line 2910: p_task_name IN pa_tasks.task_name%TYPE,

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

Line 2912: x_task_id OUT pa_tasks.task_id%TYPE,

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

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

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

Line 5421: , pa_tasks t

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

Line 5448: , pa_tasks t

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

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

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

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

8943: */
8944:
8945: PROCEDURE check_delete_task_ok
8946: ( /* p_task_id IN pa_tasks.task_id%TYPE Commenting out NOCOPY for to replace --File.Sql.39 bug 4440895
8947: pa_tasks by PA_STRUCT_TASK_WBS_V as part of FP.M, Tracking Bug No - 3354518 */
8948: p_task_id IN pa_struct_task_wbs_v.task_id%TYPE
8949: ,p_validation_mode IN VARCHAR2
8950: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
8951: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 8970: Replacing all references of PA_TASKS by PA_STRUCT_TASK_WBS_V

8966:
8967: l_validation_success VARCHAR2(1) := 'Y'; /* Y when delete is allowed, N when delete is not allowed */
8968:
8969: /* Changes for FP.M, Tracking Bug No - 3354518
8970: Replacing all references of PA_TASKS by PA_STRUCT_TASK_WBS_V
8971: and of PA_FP_ELEMNTS by PA_RESOURCE_ASSIGNMENTS
8972: as PA_FP_ELEMENTS is being obsoleted*/
8973:
8974:

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

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

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

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

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

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

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

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

Line 9029: -- 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

9025: pa_budget_versions bv
9026: WHERE fe.task_id IN
9027: (SELECT pt.task_id
9028: FROM PA_STRUCT_TASK_WBS_V pt
9029: -- 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
9030: CONNECT BY PRIOR pt.task_id = pt.parent_task_id
9031: START WITH pt.task_id = p_task_id)
9032: -- AND bv.budget_version_id = fe.fin_plan_version_id
9033: -- Part of Changes for FP.M, Tracking Bug No - 3354518 , replace fin_plan_version_id by budget_version_id

Line 9044: -- 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

9040: pa_budget_versions bv
9041: WHERE r.task_id IN
9042: (SELECT pt.task_id
9043: FROM PA_STRUCT_TASK_WBS_V pt
9044: -- 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
9045: CONNECT BY PRIOR pt.task_id = pt.parent_task_id
9046: START WITH pt.task_id = p_task_id)
9047: AND bv.budget_version_id = r.budget_version_id
9048: AND nvl(bv.wp_version_flag,'N') = 'N' -- Added for FP.M, Tracking Bug No - 3354518

Line 9220: (p_task_id IN pa_tasks.task_id%TYPE

9216: RAISE;
9217: END check_delete_task_ok;
9218:
9219: PROCEDURE check_reparent_task_ok
9220: (p_task_id IN pa_tasks.task_id%TYPE
9221: ,p_old_parent_task_id IN pa_tasks.task_id%TYPE
9222: ,p_new_parent_task_id IN pa_tasks.task_id%TYPE
9223: ,p_validation_mode IN VARCHAR2
9224: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 9221: ,p_old_parent_task_id IN pa_tasks.task_id%TYPE

9217: END check_delete_task_ok;
9218:
9219: PROCEDURE check_reparent_task_ok
9220: (p_task_id IN pa_tasks.task_id%TYPE
9221: ,p_old_parent_task_id IN pa_tasks.task_id%TYPE
9222: ,p_new_parent_task_id IN pa_tasks.task_id%TYPE
9223: ,p_validation_mode IN VARCHAR2
9224: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
9225: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 9222: ,p_new_parent_task_id IN pa_tasks.task_id%TYPE

9218:
9219: PROCEDURE check_reparent_task_ok
9220: (p_task_id IN pa_tasks.task_id%TYPE
9221: ,p_old_parent_task_id IN pa_tasks.task_id%TYPE
9222: ,p_new_parent_task_id IN pa_tasks.task_id%TYPE
9223: ,p_validation_mode IN VARCHAR2
9224: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
9225: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
9226: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 9231: l_parent_top_task_id pa_tasks.top_task_id%TYPE;

9227: AS
9228:
9229: -- validation variables
9230: l_is_parent_lowest_task NUMBER(1);
9231: l_parent_top_task_id pa_tasks.top_task_id%TYPE;
9232: l_task_name pa_tasks.task_name%TYPE;
9233: l_old_parent_task_name pa_tasks.task_name%TYPE;
9234: l_new_parent_task_name pa_tasks.task_name%TYPE;
9235:

Line 9232: l_task_name pa_tasks.task_name%TYPE;

9228:
9229: -- validation variables
9230: l_is_parent_lowest_task NUMBER(1);
9231: l_parent_top_task_id pa_tasks.top_task_id%TYPE;
9232: l_task_name pa_tasks.task_name%TYPE;
9233: l_old_parent_task_name pa_tasks.task_name%TYPE;
9234: l_new_parent_task_name pa_tasks.task_name%TYPE;
9235:
9236: -- debugging variables

Line 9233: l_old_parent_task_name pa_tasks.task_name%TYPE;

9229: -- validation variables
9230: l_is_parent_lowest_task NUMBER(1);
9231: l_parent_top_task_id pa_tasks.top_task_id%TYPE;
9232: l_task_name pa_tasks.task_name%TYPE;
9233: l_old_parent_task_name pa_tasks.task_name%TYPE;
9234: l_new_parent_task_name pa_tasks.task_name%TYPE;
9235:
9236: -- debugging variables
9237: l_module_name VARCHAR2(100) := 'check_reparent_task_ok';

Line 9234: l_new_parent_task_name pa_tasks.task_name%TYPE;

9230: l_is_parent_lowest_task NUMBER(1);
9231: l_parent_top_task_id pa_tasks.top_task_id%TYPE;
9232: l_task_name pa_tasks.task_name%TYPE;
9233: l_old_parent_task_name pa_tasks.task_name%TYPE;
9234: l_new_parent_task_name pa_tasks.task_name%TYPE;
9235:
9236: -- debugging variables
9237: l_module_name VARCHAR2(100) := 'check_reparent_task_ok';
9238: l_return_status VARCHAR2(1);

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

9241: l_msg_data VARCHAR2(2000);
9242: l_msg_index_out NUMBER;
9243: l_debug_mode VARCHAR2(1);
9244:
9245: cursor task_ra_csr (tid pa_tasks.task_id%TYPE) is
9246: select 1
9247: from pa_resource_assignments
9248: where task_id = tid;
9249: task_ra_rec task_ra_csr%ROWTYPE;

Line 9340: from pa_tasks

9336: x_return_status := FND_API.G_RET_STS_ERROR;
9337: BEGIN
9338: select task_name
9339: into l_task_name
9340: from pa_tasks
9341: where task_id = p_task_id;
9342: select task_name
9343: into l_old_parent_task_name
9344: from pa_tasks

Line 9344: from pa_tasks

9340: from pa_tasks
9341: where task_id = p_task_id;
9342: select task_name
9343: into l_old_parent_task_name
9344: from pa_tasks
9345: where task_id = p_old_parent_task_id;
9346: EXCEPTION
9347: when NO_DATA_FOUND then
9348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 9387: from pa_tasks

9383:
9384: -- VALIDATION: New parent task
9385: select top_task_id
9386: into l_parent_top_task_id
9387: from pa_tasks
9388: where task_id = p_new_parent_task_id;
9389: l_is_parent_lowest_task := pa_budget_utils2.check_task_lowest_in_budgets
9390: (x_task_id => p_new_parent_task_id,
9391: x_top_task_id => l_parent_top_task_id,

Line 9399: from pa_tasks

9395: x_return_status := FND_API.G_RET_STS_ERROR;
9396: BEGIN
9397: select task_name
9398: into l_task_name
9399: from pa_tasks
9400: where task_id = p_task_id;
9401: select task_name
9402: into l_new_parent_task_name
9403: from pa_tasks

Line 9403: from pa_tasks

9399: from pa_tasks
9400: where task_id = p_task_id;
9401: select task_name
9402: into l_new_parent_task_name
9403: from pa_tasks
9404: where task_id = p_new_parent_task_id;
9405: EXCEPTION
9406: when NO_DATA_FOUND then
9407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 9484: we change all references to pa_tasks to pa_struct_task_wbs_v

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

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

9485: and all references of pa_fp_elements to pa_resource_assignments*/
9486:
9487: FUNCTION check_task_in_fp_option
9488: (
9489: /* p_task_id IN pa_tasks.task_id%TYPE */
9490: /* Changing reference of pa_tasks to pa_struct_task_wbs_v */
9491: p_task_id IN pa_struct_task_wbs_v.task_id%TYPE)
9492:
9493: RETURN VARCHAR2 AS

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

9486:
9487: FUNCTION check_task_in_fp_option
9488: (
9489: /* p_task_id IN pa_tasks.task_id%TYPE */
9490: /* Changing reference of pa_tasks to pa_struct_task_wbs_v */
9491: p_task_id IN pa_struct_task_wbs_v.task_id%TYPE)
9492:
9493: RETURN VARCHAR2 AS
9494:

Line 9585: , p_task_id IN pa_tasks.task_id%TYPE

9581:
9582: FUNCTION Get_Budgeted_Amount
9583: (
9584: p_project_id IN pa_projects_all.project_id%TYPE
9585: , p_task_id IN pa_tasks.task_id%TYPE
9586: , p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE
9587: , p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
9588: , p_amount_type IN VARCHAR2
9589: ) RETURN NUMBER

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

10394: /* To determine if a task is a planning element or not */
10395: -- Modified for Bug 3840993 --sagarwal
10396: FUNCTION IS_TASK_A_PLANNING_ELEMENT(
10397: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
10398: ,p_task_id IN pa_tasks.task_id%TYPE)
10399: RETURN VARCHAR2 IS
10400: l_exists VARCHAR2(1);
10401: l_structure_version_id pa_budget_versions.project_structure_version_id%TYPE;
10402:

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

10529: WHERE ppev2.object_type = 'PA_STRUCTURES'
10530: AND ppev2.project_id = p_project_id
10531: AND ppev2.proj_element_id = c_structure_id
10532: AND ppev1.parent_structure_version_id = ppev2.element_version_id
10533: AND ppev1.object_type = 'PA_TASKS';
10534: /*** Bug 3683382 modified the query for performance
10535: SELECT proj_element_id
10536: from pa_proj_elements
10537: where project_id = p_project_id

Line 10538: and object_type = 'PA_TASKS'

10534: /*** Bug 3683382 modified the query for performance
10535: SELECT proj_element_id
10536: from pa_proj_elements
10537: where project_id = p_project_id
10538: and object_type = 'PA_TASKS'
10539: and proj_element_id IN (
10540: select ppev1.proj_element_id
10541: from pa_proj_element_versions ppev1,
10542: pa_proj_element_versions ppev2

Line 12960: p_object_type => 'PA_TASKS',

12956: PA_PROGRESS_UTILS.REDEFAULT_BASE_PC
12957: (p_project_id => p_project_id,
12958: p_proj_element_id => p_proj_element_id,
12959: p_structure_type => 'FINANCIAL',
12960: p_object_type => 'PA_TASKS',
12961: p_as_of_date => trunc(SYSDATE),
12962: p_structure_version_id => g_fp_wa_struct_ver_id,
12963: p_structure_status => l_structure_status,
12964: p_calling_context => 'FINANCIAL_PLANNING',