DBA Data[Home] [Help]

APPS.PA_ACTIONS_PVT dependencies on PA_OBJECT_RELATIONSHIPS

Line 40: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE

36: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
37: ,p_proj_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
38: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
39: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE := null
40: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE
41: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
42: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
43: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
44: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null

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

37: ,p_proj_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
38: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
39: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE := null
40: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE
41: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
42: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
43: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
44: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
45: ,p_pm_source_reference_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE() -- added 3435905

Line 88: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null -- 3578694 added default value

84: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
85: ,p_proj_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
86: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
87: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE := null
88: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null -- 3578694 added default value
89: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
90: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
91: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
92: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null

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

85: ,p_proj_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
86: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
87: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE := null
88: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null -- 3578694 added default value
89: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
90: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
91: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
92: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
93: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null

Line 109: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE

105: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
106: ,p_debug_mode IN VARCHAR2 :='N'
107: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
108: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
109: ,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: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 147: ,p_source_object_id IN pa_object_relationships.object_id_from2%TYPE

143: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
144: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
145: ,p_debug_mode IN VARCHAR2 :='N'
146: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
147: ,p_source_object_id IN pa_object_relationships.object_id_from2%TYPE
148: ,p_source_object_type IN pa_object_relationships.object_type_from%TYPE
149: ,p_target_object_id IN pa_object_relationships.object_id_from2%TYPE
150: ,p_target_object_type IN pa_object_relationships.object_type_from%TYPE
151: ,p_source_project_id IN pa_projects_all.project_id%TYPE

Line 148: ,p_source_object_type IN pa_object_relationships.object_type_from%TYPE

144: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
145: ,p_debug_mode IN VARCHAR2 :='N'
146: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
147: ,p_source_object_id IN pa_object_relationships.object_id_from2%TYPE
148: ,p_source_object_type IN pa_object_relationships.object_type_from%TYPE
149: ,p_target_object_id IN pa_object_relationships.object_id_from2%TYPE
150: ,p_target_object_type IN pa_object_relationships.object_type_from%TYPE
151: ,p_source_project_id IN pa_projects_all.project_id%TYPE
152: ,p_target_project_id IN pa_projects_all.project_id%TYPE

Line 149: ,p_target_object_id IN pa_object_relationships.object_id_from2%TYPE

145: ,p_debug_mode IN VARCHAR2 :='N'
146: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
147: ,p_source_object_id IN pa_object_relationships.object_id_from2%TYPE
148: ,p_source_object_type IN pa_object_relationships.object_type_from%TYPE
149: ,p_target_object_id IN pa_object_relationships.object_id_from2%TYPE
150: ,p_target_object_type IN pa_object_relationships.object_type_from%TYPE
151: ,p_source_project_id IN pa_projects_all.project_id%TYPE
152: ,p_target_project_id IN pa_projects_all.project_id%TYPE
153: ,p_task_id IN pa_proj_elements.proj_element_id%TYPE := null

Line 150: ,p_target_object_type IN pa_object_relationships.object_type_from%TYPE

146: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
147: ,p_source_object_id IN pa_object_relationships.object_id_from2%TYPE
148: ,p_source_object_type IN pa_object_relationships.object_type_from%TYPE
149: ,p_target_object_id IN pa_object_relationships.object_id_from2%TYPE
150: ,p_target_object_type IN pa_object_relationships.object_type_from%TYPE
151: ,p_source_project_id IN pa_projects_all.project_id%TYPE
152: ,p_target_project_id IN pa_projects_all.project_id%TYPE
153: ,p_task_id IN pa_proj_elements.proj_element_id%TYPE := null
154: ,p_task_ver_id IN pa_proj_element_versions.element_version_id%TYPE := null