DBA Data[Home] [Help]

APPS.PA_PROJ_STRUCTURE_PVT dependencies on PA_PROJECT_STRUCTURE_UTILS

Line 121: PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_FIN_STRUC_VER_ID(ppev.project_id);

117: AND ppe.proj_element_id = ppev.proj_element_id
118: AND pt.task_id = ppe.proj_element_id
119: -- Added for bug 4999937
120: AND ppev.parent_structure_version_id =
121: PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_FIN_STRUC_VER_ID(ppev.project_id);
122: --
123: l_src_task_det_rec get_src_task_det%ROWTYPE;
124: l_dest_proj_name VARCHAR2(50);
125: l_src_task_id NUMBER;

Line 389: PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_FIN_STRUC_VER_ID(ppev.project_id); -- Added for Bug 5687144

385: AND ppe.project_id = ppev.project_id
386: AND ppe.proj_element_id = ppev.proj_element_id
387: AND pt.task_id = ppe.proj_element_id
388: AND ppev.parent_structure_version_id =
389: PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_FIN_STRUC_VER_ID(ppev.project_id); -- Added for Bug 5687144
390: --
391: --This is cursor is used when source task id and dest project id are passed to this api.
392: --This cursor returns subproject association relationships ids for the
393: --given source task id and destination project id.

Line 651: l_dest_fin_str_ver_id:=PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_FIN_STRUC_VER_ID(p_project_id);

647: -- CLOSE get_all_projects_for_task;
648: CLOSE get_all_sub_proj_ass_det;
649: ELSIF (p_project_id IS NOT NULL) AND (p_task_id IS NULL) THEN
650: --
651: l_dest_fin_str_ver_id:=PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_FIN_STRUC_VER_ID(p_project_id);
652: IF l_dest_fin_str_ver_id IS NULL THEN
653: --get only version for fin
654: PA_PROJECT_STRUCTURE_UTILS.Get_Financial_Version(p_project_id,l_dest_fin_str_ver_id);
655: END IF;

Line 654: PA_PROJECT_STRUCTURE_UTILS.Get_Financial_Version(p_project_id,l_dest_fin_str_ver_id);

650: --
651: l_dest_fin_str_ver_id:=PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_FIN_STRUC_VER_ID(p_project_id);
652: IF l_dest_fin_str_ver_id IS NULL THEN
653: --get only version for fin
654: PA_PROJECT_STRUCTURE_UTILS.Get_Financial_Version(p_project_id,l_dest_fin_str_ver_id);
655: END IF;
656: --
657: /* If project_id is not null, then delete all relationships that the project is associated with */
658: