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

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

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

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

Line 2922: p_task_id IN PA_STRUCT_TASK_WBS_V.task_id%TYPE,

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

Line 2923: p_task_name IN PA_STRUCT_TASK_WBS_V.task_name%TYPE,

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

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

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

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

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

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

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

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

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

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

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

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

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

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