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_PROJECTS_ALL

Line 102: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE := null

98: ,p_attribute15_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
99: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
100: ,p_proj_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
101: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
102: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE := null
103: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE
104: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
105: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
106: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null

Line 517: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE := null

513: ,p_attribute15_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
514: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
515: ,p_proj_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
516: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
517: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE := null
518: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null -- 3578694 added default value
519: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
520: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
521: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null

Line 876: ,p_project_id IN pa_projects_all.project_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
879: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
880: )

Line 1141: ,p_project_id IN pa_projects_all.project_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
1144: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1145: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1296: ,p_source_project_id IN pa_projects_all.project_id%TYPE

1292: ,p_source_object_id IN pa_object_relationships.object_id_from2%TYPE
1293: ,p_source_object_type IN pa_object_relationships.object_type_from%TYPE
1294: ,p_target_object_id IN pa_object_relationships.object_id_from2%TYPE
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

Line 1297: ,p_target_project_id IN pa_projects_all.project_id%TYPE

1293: ,p_source_object_type IN pa_object_relationships.object_type_from%TYPE
1294: ,p_target_object_id IN pa_object_relationships.object_id_from2%TYPE
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

Line 1311: l_proj_id pa_projects_all.project_id%TYPE;

1307: )
1308: IS
1309:
1310: --Bug 3614361
1311: l_proj_id pa_projects_all.project_id%TYPE;
1312:
1313: CURSOR get_source_actions IS
1314: SELECT ppe.name
1315: ,ppe.manager_person_id

Line 1349: pa_projects_all pa,

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
1351: WHERE obj.object_id_from2 = p_source_object_id
1352: AND obj.object_type_from = p_source_object_type
1353: AND obj.relationship_type = 'A'

Line 1435: FROM pa_projects_all

1431:
1432: CURSOR get_project_mode
1433: IS
1434: SELECT 'TEMPLATE'
1435: FROM pa_projects_all
1436: WHERE project_id = p_target_project_id
1437: AND template_flag = 'Y';
1438: BEGIN
1439: