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_ACTIONS_PVT dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 276: pa_debug.g_err_stage := 'Bulk inserting into PA_PROJ_ELEMENT_VERSIONS';

272: BULK COLLECT INTO l_proj_element_id_tbl ;
273:
274:
275: IF p_debug_mode = 'Y' THEN
276: pa_debug.g_err_stage := 'Bulk inserting into PA_PROJ_ELEMENT_VERSIONS';
277: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
278: END IF;
279:
280:

Line 287: INSERT INTO PA_PROJ_ELEMENT_VERSIONS(

283: -- From copy action API p_element_version_id_tbl will be passed
284: -- as null.Hence using nvl
285:
286: FORALL i in l_proj_element_id_tbl.FIRST..l_proj_element_id_tbl.LAST
287: INSERT INTO PA_PROJ_ELEMENT_VERSIONS(
288: element_version_id
289: ,proj_element_id
290: ,object_type
291: ,project_id

Line 303: nvl(p_element_version_id_tbl(i),pa_proj_element_versions_s.nextval)

299: ,source_object_type
300: )
301: VALUES
302: (
303: nvl(p_element_version_id_tbl(i),pa_proj_element_versions_s.nextval)
304: ,l_proj_element_id_tbl(i)
305: ,g_actions
306: ,nvl(p_project_id,-99)
307: ,SYSDATE

Line 734: -- Delete from PA_PROJ_ELEMENT_VERSIONS Table

730: FORALL i in l_proj_element_id_tbl.FIRST..l_proj_element_id_tbl.LAST
731: DELETE FROM pa_proj_elements
732: WHERE proj_element_id = l_proj_element_id_tbl(i) ;
733:
734: -- Delete from PA_PROJ_ELEMENT_VERSIONS Table
735: -- Bug 3614361 Including Returning Clause
736: FORALL i in l_proj_element_id_tbl.FIRST..l_proj_element_id_tbl.LAST
737: DELETE FROM pa_proj_element_versions
738: WHERE proj_element_id = l_proj_element_id_tbl(i)

Line 737: DELETE FROM pa_proj_element_versions

733:
734: -- Delete from PA_PROJ_ELEMENT_VERSIONS Table
735: -- Bug 3614361 Including Returning Clause
736: FORALL i in l_proj_element_id_tbl.FIRST..l_proj_element_id_tbl.LAST
737: DELETE FROM pa_proj_element_versions
738: WHERE proj_element_id = l_proj_element_id_tbl(i)
739: RETURNING element_version_id
740: BULK COLLECT INTO l_elem_version_id_tbl;
741:

Line 803: DELETE FROM PA_PROJ_ELEMENT_VERSIONS

799: pa_debug.write('DELETE_DLV_ACTIONS_IN_BULK: ' || g_module_name,pa_debug.g_err_stage,5);
800: END IF;
801:
802: FORALL i in p_element_version_id_tbl.FIRST..p_element_version_id_tbl.LAST
803: DELETE FROM PA_PROJ_ELEMENT_VERSIONS
804: WHERE element_version_id = p_element_version_id_tbl(i) ;
805:
806: END IF ;
807:

Line 872: ,p_action_ver_id IN pa_proj_element_versions.element_version_id%TYPE

868: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
869: ,p_debug_mode IN VARCHAR2 :='N'
870: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
871: ,p_action_id IN pa_proj_elements.proj_element_id%TYPE
872: ,p_action_ver_id IN pa_proj_element_versions.element_version_id%TYPE
873: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
874: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
875: ,p_function_code IN pa_proj_elements.function_code%TYPE
876: ,p_project_id IN pa_projects_all.project_id%TYPE

Line 874: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE

870: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
871: ,p_action_id IN pa_proj_elements.proj_element_id%TYPE
872: ,p_action_ver_id IN pa_proj_element_versions.element_version_id%TYPE
873: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
874: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
875: ,p_function_code IN pa_proj_elements.function_code%TYPE
876: ,p_project_id IN pa_projects_all.project_id%TYPE
877: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
878: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 1066: -- Delete from PA_PROJ_ELEMENT_VERSIONS Table

1062: -- Delete from PA_PROJ_ELEMENTS Table
1063: DELETE FROM pa_proj_elements
1064: WHERE proj_element_id = p_action_id ;
1065:
1066: -- Delete from PA_PROJ_ELEMENT_VERSIONS Table
1067: DELETE FROM pa_proj_element_versions
1068: WHERE element_version_id = p_action_ver_id ;
1069:
1070: -- Delete from PA_PROJ_ELEM_VER_SCHEDULE Table

Line 1067: DELETE FROM pa_proj_element_versions

1063: DELETE FROM pa_proj_elements
1064: WHERE proj_element_id = p_action_id ;
1065:
1066: -- Delete from PA_PROJ_ELEMENT_VERSIONS Table
1067: DELETE FROM pa_proj_element_versions
1068: WHERE element_version_id = p_action_ver_id ;
1069:
1070: -- Delete from PA_PROJ_ELEM_VER_SCHEDULE Table
1071: DELETE FROM pa_proj_elem_ver_schedule

Line 1137: ,p_action_ver_id IN pa_proj_element_versions.element_version_id%TYPE

1133: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
1134: ,p_debug_mode IN VARCHAR2 :='N'
1135: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1136: ,p_action_id IN pa_proj_elements.proj_element_id%TYPE
1137: ,p_action_ver_id IN pa_proj_element_versions.element_version_id%TYPE
1138: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
1139: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
1140: ,p_function_code IN pa_proj_elements.function_code%TYPE
1141: ,p_project_id IN pa_projects_all.project_id%TYPE

Line 1139: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE

1135: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1136: ,p_action_id IN pa_proj_elements.proj_element_id%TYPE
1137: ,p_action_ver_id IN pa_proj_element_versions.element_version_id%TYPE
1138: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
1139: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
1140: ,p_function_code IN pa_proj_elements.function_code%TYPE
1141: ,p_project_id IN pa_projects_all.project_id%TYPE
1142: ,x_action_del_allowed IN VARCHAR2
1143: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1299: ,p_task_ver_id IN pa_proj_element_versions.element_version_id%TYPE := null

1295: ,p_target_object_type IN pa_object_relationships.object_type_from%TYPE
1296: ,p_source_project_id IN pa_projects_all.project_id%TYPE
1297: ,p_target_project_id IN pa_projects_all.project_id%TYPE
1298: ,p_task_id IN pa_proj_elements.proj_element_id%TYPE := null
1299: ,p_task_ver_id IN pa_proj_element_versions.element_version_id%TYPE := null
1300: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
1301: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
1302: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
1303: ,p_calling_mode IN VARCHAR2 := NULL -- Added for bug# 3911050

Line 1342: ,pa_proj_element_versions_s.nextval -- Target Action Version Id -- Included for Bug # 3431156

1338: -- ,null --Commented for Bug # 3431156 --This corresponds to the target action version id
1339: -- ,null --Commented for Bug # 3431156 --This corresponds to target action projelementid
1340: ,ppe.proj_element_id --Source Action Proj Element Id -- Included for Bug # 3431156
1341: ,ppv.element_version_id --Source Action Version Id -- Included for Bug # 3431156
1342: ,pa_proj_element_versions_s.nextval -- Target Action Version Id -- Included for Bug # 3431156
1343: ,pa_tasks_s.nextval -- Target Action Proj Element Id -- Included for Bug # 3431156
1344: ,null -- record version number
1345: FROM pa_proj_elements ppe,
1346: pa_proj_element_versions ppv,

Line 1346: pa_proj_element_versions ppv,

1342: ,pa_proj_element_versions_s.nextval -- Target Action Version Id -- Included for Bug # 3431156
1343: ,pa_tasks_s.nextval -- Target Action Proj Element Id -- Included for Bug # 3431156
1344: ,null -- record version number
1345: FROM pa_proj_elements ppe,
1346: pa_proj_element_versions ppv,
1347: pa_proj_elem_ver_schedule psc,
1348: pa_object_relationships obj,
1349: pa_projects_all pa,
1350: pa_project_types_all ppt

Line 1419: FROM pa_proj_element_versions

1415: --Commented for Bug # 3431156
1416: /*CURSOR get_version_id
1417: IS
1418: SELECT element_version_id
1419: FROM pa_proj_element_versions
1420: WHERE proj_element_id = l_target_object_id
1421: AND object_type = 'PA_DELIVERABLES' ;*/
1422:
1423: --Bug # 3431156 Modified the cursor to fetch

Line 1428: FROM pa_proj_element_versions

1424: --either the source deliverable version id/target deliverable version id
1425: CURSOR get_version_id (l_dlv_id NUMBER)
1426: IS
1427: SELECT element_version_id
1428: FROM pa_proj_element_versions
1429: WHERE proj_element_id = l_dlv_id
1430: AND object_type = 'PA_DELIVERABLES' ;
1431:
1432: CURSOR get_project_mode