DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_UTILS dependencies on PA_STRUCT_TASK_WBS_V

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

287: ) ;
288:
289:
290: /* Changes for FP.M, Tracking Bug No - 3354518
291: Replacing all references of PA_TASKS by PA_STRUCT_TASK_WBS_V*/
292: /* Commenting code below for FP.M changes, Tracking Bug No - 3354518 */
293: /*PROCEDURE check_task_name_or_id
294: (p_project_id IN pa_tasks.project_id%TYPE,
295: p_task_id IN pa_tasks.task_id%TYPE,

Line 302: /* Rewriting procedure declaration below to refer to pa_struct_task_wbs_v

298: x_task_id OUT pa_tasks.task_id%TYPE,
299: x_return_status OUT VARCHAR2,
300: x_msg_count OUT NUMBER,
301: x_error_msg OUT VARCHAR2);*/
302: /* Rewriting procedure declaration below to refer to pa_struct_task_wbs_v
303: instead of pa_tasks - as part of worplan structure model changes in FP.M */
304: PROCEDURE check_task_name_or_id
305: (p_project_id IN PA_STRUCT_TASK_WBS_V.project_id%TYPE,
306: p_task_id IN PA_STRUCT_TASK_WBS_V.task_id%TYPE,

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

301: x_error_msg OUT VARCHAR2);*/
302: /* Rewriting procedure declaration below to refer to pa_struct_task_wbs_v
303: instead of pa_tasks - as part of worplan structure model changes in FP.M */
304: PROCEDURE check_task_name_or_id
305: (p_project_id IN PA_STRUCT_TASK_WBS_V.project_id%TYPE,
306: p_task_id IN PA_STRUCT_TASK_WBS_V.task_id%TYPE,
307: p_task_name IN PA_STRUCT_TASK_WBS_V.task_name%TYPE,
308: p_check_id_flag IN VARCHAR2,
309: x_task_id OUT NOCOPY PA_STRUCT_TASK_WBS_V.task_id%TYPE, --File.Sql.39 bug 4440895

Line 306: p_task_id IN PA_STRUCT_TASK_WBS_V.task_id%TYPE,

302: /* Rewriting procedure declaration below to refer to pa_struct_task_wbs_v
303: instead of pa_tasks - as part of worplan structure model changes in FP.M */
304: PROCEDURE check_task_name_or_id
305: (p_project_id IN PA_STRUCT_TASK_WBS_V.project_id%TYPE,
306: p_task_id IN PA_STRUCT_TASK_WBS_V.task_id%TYPE,
307: p_task_name IN PA_STRUCT_TASK_WBS_V.task_name%TYPE,
308: p_check_id_flag IN VARCHAR2,
309: x_task_id OUT NOCOPY PA_STRUCT_TASK_WBS_V.task_id%TYPE, --File.Sql.39 bug 4440895
310: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 307: p_task_name IN PA_STRUCT_TASK_WBS_V.task_name%TYPE,

303: instead of pa_tasks - as part of worplan structure model changes in FP.M */
304: PROCEDURE check_task_name_or_id
305: (p_project_id IN PA_STRUCT_TASK_WBS_V.project_id%TYPE,
306: p_task_id IN PA_STRUCT_TASK_WBS_V.task_id%TYPE,
307: p_task_name IN PA_STRUCT_TASK_WBS_V.task_name%TYPE,
308: p_check_id_flag IN VARCHAR2,
309: x_task_id OUT NOCOPY PA_STRUCT_TASK_WBS_V.task_id%TYPE, --File.Sql.39 bug 4440895
310: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
311: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

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

305: (p_project_id IN PA_STRUCT_TASK_WBS_V.project_id%TYPE,
306: p_task_id IN PA_STRUCT_TASK_WBS_V.task_id%TYPE,
307: p_task_name IN PA_STRUCT_TASK_WBS_V.task_name%TYPE,
308: p_check_id_flag IN VARCHAR2,
309: x_task_id OUT NOCOPY PA_STRUCT_TASK_WBS_V.task_id%TYPE, --File.Sql.39 bug 4440895
310: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
311: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
312: x_error_msg OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
313:

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

689: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
690:
691: PROCEDURE check_delete_task_ok
692: (/* p_task_id IN pa_tasks.task_id%TYPE Commenting out NOCOPY for to replace --File.Sql.39 bug 4440895
693: pa_tasks by PA_STRUCT_TASK_WBS_V as part of FP.M, Tracking Bug No - 3354518 */
694: p_task_id IN pa_struct_task_wbs_v.task_id%TYPE
695: ,p_validation_mode IN VARCHAR2 DEFAULT 'U'
696: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
697: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 694: p_task_id IN pa_struct_task_wbs_v.task_id%TYPE

690:
691: PROCEDURE check_delete_task_ok
692: (/* p_task_id IN pa_tasks.task_id%TYPE Commenting out NOCOPY for to replace --File.Sql.39 bug 4440895
693: pa_tasks by PA_STRUCT_TASK_WBS_V as part of FP.M, Tracking Bug No - 3354518 */
694: p_task_id IN pa_struct_task_wbs_v.task_id%TYPE
695: ,p_validation_mode IN VARCHAR2 DEFAULT 'U'
696: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
697: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
698: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 713: all references to pa_tasks to pa_struct_task_wbs_v and all references of

709: /* Part of changes for FP.M, Tracking Bug No - 3354518
710: This function is being called by PA_FP_ELEMENTS_PUB currently to verify,
711: if PA_FP_ELEMENTS contains a entry for this task. This procedure is now
712: obsoleted.However noticing that this procedure is re-usable, we change
713: all references to pa_tasks to pa_struct_task_wbs_v and all references of
714: pa_fp_elements to pa_resource_assignments */
715: /* FUNCTION check_task_in_fp_option
716: (p_task_id IN pa_tasks.task_id%TYPE)
717: RETURN VARCHAR2; Re-writing function declaration below*/

Line 719: (p_task_id IN pa_struct_task_wbs_v.task_id%TYPE)

715: /* FUNCTION check_task_in_fp_option
716: (p_task_id IN pa_tasks.task_id%TYPE)
717: RETURN VARCHAR2; Re-writing function declaration below*/
718: FUNCTION check_task_in_fp_option
719: (p_task_id IN pa_struct_task_wbs_v.task_id%TYPE)
720: RETURN VARCHAR2;
721:
722:
723: --Name: Get_Budgeted_Amount