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_STRUCT_TASK_WBS_V

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 2916: /* Rewriting procedure declaration below to refer to pa_struct_task_wbs_v

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
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,

Line 2919: (p_project_id IN PA_STRUCT_TASK_WBS_V.project_id%TYPE,

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,
2922: p_check_id_flag IN VARCHAR2,
2923: x_task_id OUT NOCOPY PA_STRUCT_TASK_WBS_V.task_id%TYPE, --File.Sql.39 bug 4440895

Line 2920: p_task_id IN PA_STRUCT_TASK_WBS_V.task_id%TYPE,

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,
2922: p_check_id_flag IN VARCHAR2,
2923: x_task_id OUT NOCOPY PA_STRUCT_TASK_WBS_V.task_id%TYPE, --File.Sql.39 bug 4440895
2924: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 2921: p_task_name IN PA_STRUCT_TASK_WBS_V.task_name%TYPE,

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,
2922: p_check_id_flag IN VARCHAR2,
2923: x_task_id OUT NOCOPY PA_STRUCT_TASK_WBS_V.task_id%TYPE, --File.Sql.39 bug 4440895
2924: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2925: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 2923: x_task_id OUT NOCOPY PA_STRUCT_TASK_WBS_V.task_id%TYPE, --File.Sql.39 bug 4440895

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,
2922: p_check_id_flag IN VARCHAR2,
2923: x_task_id OUT NOCOPY PA_STRUCT_TASK_WBS_V.task_id%TYPE, --File.Sql.39 bug 4440895
2924: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2925: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2926: x_error_msg OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
2927: is

Line 2938: from PA_STRUCT_TASK_WBS_V -- Changes for FP.M, Tracking Bug No - 3354518

2934: if p_check_id_flag = 'Y' then
2935: -- validate the id that was passed in
2936: select task_id
2937: into x_task_id
2938: from PA_STRUCT_TASK_WBS_V -- Changes for FP.M, Tracking Bug No - 3354518
2939: where task_id = p_task_id;
2940: elsif p_check_id_flag = 'N' then
2941: -- just return the p_task_id, since we're not validating
2942: x_task_id := p_task_id;

Line 2949: from PA_STRUCT_TASK_WBS_V -- Changes for FP.M, Tracking Bug No - 3354518

2945: if p_task_name is not null then
2946: -- p_task_id = null, so we need to find the id
2947: select task_id
2948: into x_task_id
2949: from PA_STRUCT_TASK_WBS_V -- Changes for FP.M, Tracking Bug No - 3354518
2950: where project_id = p_project_id and
2951: task_name = p_task_name;
2952: else
2953: x_task_id := null;

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 8948: p_task_id IN pa_struct_task_wbs_v.task_id%TYPE

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
8952: ,x_msg_data OUT NOCOPY VARCHAR2) --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 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 9028: FROM PA_STRUCT_TASK_WBS_V pt

9024: pa_resource_assignments fe,
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

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 9043: FROM PA_STRUCT_TASK_WBS_V pt

9039: FROM pa_resource_assignments r,
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

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 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 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 9491: p_task_id IN pa_struct_task_wbs_v.task_id%TYPE)

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:
9495: l_exists VARCHAR2(1) := 'N';