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_PUB dependencies on PA_OBJECT_RELATIONSHIPS

Line 114: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE

110: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
111: ,p_proj_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
112: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
113: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE := null
114: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE
115: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
116: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
117: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
118: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null

Line 115: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null

111: ,p_proj_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
112: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
113: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE := null
114: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE
115: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
116: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
117: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
118: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
119: ,p_pm_source_reference_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE() -- added 3435905

Line 127: l_rel_subtype PA_OBJECT_RELATIONSHIPS.RELATIONSHIP_SUBTYPE%TYPE ;

123: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
124: )
125: IS
126: l_proj_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
127: l_rel_subtype PA_OBJECT_RELATIONSHIPS.RELATIONSHIP_SUBTYPE%TYPE ;
128: l_debug_mode VARCHAR2(10);
129: l_msg_count NUMBER ;
130: l_data VARCHAR2(2000);
131: l_msg_data VARCHAR2(2000);

Line 362: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null -- 3578694 passing default null

358: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
359: ,p_proj_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
360: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
361: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE := null
362: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null -- 3578694 passing default null
363: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
364: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
365: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
366: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null

Line 363: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null

359: ,p_proj_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
360: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
361: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE := null
362: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null -- 3578694 passing default null
363: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
364: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
365: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
366: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
367: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null

Line 550: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE

546: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
547: ,p_debug_mode IN VARCHAR2 :='N'
548: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
549: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
550: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE
551: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
552: ,p_proj_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
553: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
554: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 758: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE

754: ,p_proj_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
755: ,p_user_action_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
756: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
757: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE := null
758: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE
759: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
760: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
761: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
762: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null

Line 759: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null

755: ,p_user_action_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
756: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
757: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE := null
758: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE
759: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
760: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
761: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
762: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
763: ,p_pm_source_reference_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE() -- added 3435905

Line 1447: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE

1443: ,p_due_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE()
1444: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
1445: ,p_proj_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
1446: ,p_user_action_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
1447: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE
1448: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
1449: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
1450: ,p_action_owner_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
1451: ,p_carrying_out_org_id IN NUMBER := null

Line 1448: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null

1444: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
1445: ,p_proj_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
1446: ,p_user_action_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
1447: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE
1448: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
1449: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
1450: ,p_action_owner_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
1451: ,p_carrying_out_org_id IN NUMBER := null
1452: ,p_action_reference_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()

Line 1528: PA_OBJECT_RELATIONSHIPS OBJ

1524: SELECT PPE.NAME ,
1525: PPE.FUNCTION_CODE,
1526: PPE.PROJ_ELEMENT_ID
1527: FROM PA_PROJ_ELEMENTS PPE ,
1528: PA_OBJECT_RELATIONSHIPS OBJ
1529: WHERE PPE.PROJECT_ID = p_project_id
1530: AND OBJ.OBJECT_ID_FROM2= p_object_id
1531: AND PPE.PROJ_ELEMENT_ID = OBJ.OBJECT_ID_TO2
1532: AND OBJ.OBJECT_TYPE_FROM = 'PA_DELIVERABLES'

Line 2607: ,p_source_object_id IN pa_object_relationships.object_id_from2%TYPE

2603: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2604: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
2605: ,p_debug_mode IN VARCHAR2 :='N'
2606: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2607: ,p_source_object_id IN pa_object_relationships.object_id_from2%TYPE
2608: ,p_source_object_type IN pa_object_relationships.object_type_from%TYPE
2609: ,p_target_object_id IN pa_object_relationships.object_id_from2%TYPE
2610: ,p_target_object_type IN pa_object_relationships.object_type_from%TYPE
2611: ,p_source_project_id IN pa_projects_all.project_id%TYPE

Line 2608: ,p_source_object_type IN pa_object_relationships.object_type_from%TYPE

2604: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
2605: ,p_debug_mode IN VARCHAR2 :='N'
2606: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2607: ,p_source_object_id IN pa_object_relationships.object_id_from2%TYPE
2608: ,p_source_object_type IN pa_object_relationships.object_type_from%TYPE
2609: ,p_target_object_id IN pa_object_relationships.object_id_from2%TYPE
2610: ,p_target_object_type IN pa_object_relationships.object_type_from%TYPE
2611: ,p_source_project_id IN pa_projects_all.project_id%TYPE
2612: ,p_target_project_id IN pa_projects_all.project_id%TYPE

Line 2609: ,p_target_object_id IN pa_object_relationships.object_id_from2%TYPE

2605: ,p_debug_mode IN VARCHAR2 :='N'
2606: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2607: ,p_source_object_id IN pa_object_relationships.object_id_from2%TYPE
2608: ,p_source_object_type IN pa_object_relationships.object_type_from%TYPE
2609: ,p_target_object_id IN pa_object_relationships.object_id_from2%TYPE
2610: ,p_target_object_type IN pa_object_relationships.object_type_from%TYPE
2611: ,p_source_project_id IN pa_projects_all.project_id%TYPE
2612: ,p_target_project_id IN pa_projects_all.project_id%TYPE
2613: ,p_task_id IN pa_proj_elements.proj_element_id%TYPE := null

Line 2610: ,p_target_object_type IN pa_object_relationships.object_type_from%TYPE

2606: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2607: ,p_source_object_id IN pa_object_relationships.object_id_from2%TYPE
2608: ,p_source_object_type IN pa_object_relationships.object_type_from%TYPE
2609: ,p_target_object_id IN pa_object_relationships.object_id_from2%TYPE
2610: ,p_target_object_type IN pa_object_relationships.object_type_from%TYPE
2611: ,p_source_project_id IN pa_projects_all.project_id%TYPE
2612: ,p_target_project_id IN pa_projects_all.project_id%TYPE
2613: ,p_task_id IN pa_proj_elements.proj_element_id%TYPE := null
2614: ,p_task_ver_id IN pa_proj_element_versions.element_version_id%TYPE := null