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 54: p_task_id IN pa_tasks.task_id%TYPE Default Null,

50: */
51:
52: FUNCTION Plan_Amount_Exists_Task_Res
53: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE ,
54: p_task_id IN pa_tasks.task_id%TYPE Default Null,
55: p_resource_list_member_id IN pa_resource_list_members.RESOURCE_LIST_MEMBER_ID%TYPE Default Null
56: ) RETURN VARCHAR2;
57:
58:

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 294: (p_project_id IN pa_tasks.project_id%TYPE,

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,
296: p_task_name IN pa_tasks.task_name%TYPE,
297: p_check_id_flag IN VARCHAR2,
298: x_task_id OUT pa_tasks.task_id%TYPE,

Line 295: p_task_id IN pa_tasks.task_id%TYPE,

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,
296: p_task_name IN pa_tasks.task_name%TYPE,
297: p_check_id_flag IN VARCHAR2,
298: x_task_id OUT pa_tasks.task_id%TYPE,
299: x_return_status OUT VARCHAR2,

Line 296: p_task_name IN pa_tasks.task_name%TYPE,

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,
296: p_task_name IN pa_tasks.task_name%TYPE,
297: p_check_id_flag IN VARCHAR2,
298: x_task_id OUT pa_tasks.task_id%TYPE,
299: x_return_status OUT VARCHAR2,
300: x_msg_count OUT NUMBER,

Line 298: x_task_id OUT pa_tasks.task_id%TYPE,

294: (p_project_id IN pa_tasks.project_id%TYPE,
295: p_task_id IN pa_tasks.task_id%TYPE,
296: p_task_name IN pa_tasks.task_name%TYPE,
297: p_check_id_flag IN VARCHAR2,
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

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

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,
307: p_task_name IN PA_STRUCT_TASK_WBS_V.task_name%TYPE,

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

688: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
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

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 701: (p_task_id IN pa_tasks.task_id%TYPE

697: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
698: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
699:
700: PROCEDURE check_reparent_task_ok
701: (p_task_id IN pa_tasks.task_id%TYPE
702: ,p_old_parent_task_id IN pa_tasks.task_id%TYPE
703: ,p_new_parent_task_id IN pa_tasks.task_id%TYPE
704: ,p_validation_mode IN VARCHAR2 DEFAULT 'U'
705: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 702: ,p_old_parent_task_id IN pa_tasks.task_id%TYPE

698: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
699:
700: PROCEDURE check_reparent_task_ok
701: (p_task_id IN pa_tasks.task_id%TYPE
702: ,p_old_parent_task_id IN pa_tasks.task_id%TYPE
703: ,p_new_parent_task_id IN pa_tasks.task_id%TYPE
704: ,p_validation_mode IN VARCHAR2 DEFAULT 'U'
705: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
706: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 703: ,p_new_parent_task_id IN pa_tasks.task_id%TYPE

699:
700: PROCEDURE check_reparent_task_ok
701: (p_task_id IN pa_tasks.task_id%TYPE
702: ,p_old_parent_task_id IN pa_tasks.task_id%TYPE
703: ,p_new_parent_task_id IN pa_tasks.task_id%TYPE
704: ,p_validation_mode IN VARCHAR2 DEFAULT 'U'
705: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
706: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
707: ,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 716: (p_task_id IN pa_tasks.task_id%TYPE)

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*/
718: FUNCTION check_task_in_fp_option
719: (p_task_id IN pa_struct_task_wbs_v.task_id%TYPE)
720: RETURN VARCHAR2;

Line 759: , p_task_id IN pa_tasks.task_id%TYPE

755:
756: FUNCTION Get_Budgeted_Amount
757: (
758: p_project_id IN pa_projects_all.project_id%TYPE
759: , p_task_id IN pa_tasks.task_id%TYPE
760: , p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE
761: , p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
762: , p_amount_type IN VARCHAR2
763: )

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

813: /* To determine if a task is a planning element or not */
814: -- Modified for Bug 3840993 --sagarwal
815: FUNCTION IS_TASK_A_PLANNING_ELEMENT(
816: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
817: ,p_task_id IN pa_tasks.task_id%TYPE)
818: RETURN VARCHAR2;
819:
820: /* To determine if a task has resources attached to it as planning element */
821: FUNCTION IS_RESOURCE_ATTACHED_TO_TASK(