DBA Data[Home] [Help]

APPS.PA_ACTIONS_PUB dependencies on PA_OBJECT_RELATIONSHIPS

Line 72: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE

68: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
69: ,p_proj_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
70: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
71: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE := null
72: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE
73: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
74: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
75: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
76: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null

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

69: ,p_proj_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
70: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
71: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE := null
72: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE
73: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
74: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
75: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
76: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
77: ,p_pm_source_reference_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE() -- added 3435905

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

116: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
117: ,p_proj_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
118: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
119: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE := null
120: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null -- 3578694, added default value
121: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
122: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
123: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
124: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null

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

117: ,p_proj_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
118: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
119: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE := null
120: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null -- 3578694, added default value
121: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
122: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
123: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
124: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
125: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null

Line 141: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE

137: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
138: ,p_debug_mode IN VARCHAR2 :='N'
139: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
140: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
141: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE
142: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
143: ,p_proj_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
144: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
145: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 168: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE

164: ,p_due_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE()
165: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
166: ,p_proj_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
167: ,p_user_action_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
168: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE
169: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
170: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
171: ,p_action_owner_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
172: ,p_carrying_out_org_id IN NUMBER := null

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

165: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
166: ,p_proj_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
167: ,p_user_action_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
168: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE
169: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
170: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
171: ,p_action_owner_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
172: ,p_carrying_out_org_id IN NUMBER := null
173: ,p_action_reference_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()

Line 218: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE

214: ,p_proj_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
215: ,p_user_action_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
216: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
217: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE := null
218: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE
219: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
220: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
221: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
222: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null

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

215: ,p_user_action_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
216: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
217: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE := null
218: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE
219: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
220: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
221: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
222: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
223: ,p_pm_source_reference_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE() -- added 3435905

Line 261: ,p_source_object_id IN pa_object_relationships.object_id_from2%TYPE

257: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
258: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
259: ,p_debug_mode IN VARCHAR2 :='N'
260: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
261: ,p_source_object_id IN pa_object_relationships.object_id_from2%TYPE
262: ,p_source_object_type IN pa_object_relationships.object_type_from%TYPE
263: ,p_target_object_id IN pa_object_relationships.object_id_from2%TYPE
264: ,p_target_object_type IN pa_object_relationships.object_type_from%TYPE
265: ,p_source_project_id IN pa_projects_all.project_id%TYPE

Line 262: ,p_source_object_type IN pa_object_relationships.object_type_from%TYPE

258: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
259: ,p_debug_mode IN VARCHAR2 :='N'
260: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
261: ,p_source_object_id IN pa_object_relationships.object_id_from2%TYPE
262: ,p_source_object_type IN pa_object_relationships.object_type_from%TYPE
263: ,p_target_object_id IN pa_object_relationships.object_id_from2%TYPE
264: ,p_target_object_type IN pa_object_relationships.object_type_from%TYPE
265: ,p_source_project_id IN pa_projects_all.project_id%TYPE
266: ,p_target_project_id IN pa_projects_all.project_id%TYPE

Line 263: ,p_target_object_id IN pa_object_relationships.object_id_from2%TYPE

259: ,p_debug_mode IN VARCHAR2 :='N'
260: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
261: ,p_source_object_id IN pa_object_relationships.object_id_from2%TYPE
262: ,p_source_object_type IN pa_object_relationships.object_type_from%TYPE
263: ,p_target_object_id IN pa_object_relationships.object_id_from2%TYPE
264: ,p_target_object_type IN pa_object_relationships.object_type_from%TYPE
265: ,p_source_project_id IN pa_projects_all.project_id%TYPE
266: ,p_target_project_id IN pa_projects_all.project_id%TYPE
267: ,p_task_id IN pa_proj_elements.proj_element_id%TYPE := null

Line 264: ,p_target_object_type IN pa_object_relationships.object_type_from%TYPE

260: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
261: ,p_source_object_id IN pa_object_relationships.object_id_from2%TYPE
262: ,p_source_object_type IN pa_object_relationships.object_type_from%TYPE
263: ,p_target_object_id IN pa_object_relationships.object_id_from2%TYPE
264: ,p_target_object_type IN pa_object_relationships.object_type_from%TYPE
265: ,p_source_project_id IN pa_projects_all.project_id%TYPE
266: ,p_target_project_id IN pa_projects_all.project_id%TYPE
267: ,p_task_id IN pa_proj_elements.proj_element_id%TYPE := null
268: ,p_task_ver_id IN pa_proj_element_versions.element_version_id%TYPE := null