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_PROJECTS_ALL

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

67: ,p_attribute15_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_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

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

115: ,p_attribute15_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
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

Line 176: ,p_project_id IN pa_projects_all.project_id%TYPE --Included by avaithia for Bug 3512346

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()
174: ,p_deliverable_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE := null
175: ,p_insert_or_update IN VARCHAR2 := 'INSERT'
176: ,p_project_id IN pa_projects_all.project_id%TYPE --Included by avaithia for Bug 3512346
177: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
178: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
179: ,x_msg_data OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
180:

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

213: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_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

Line 245: ,p_project_id IN pa_projects_all.project_id%TYPE

241: ,p_action_ver_id IN pa_proj_element_versions.element_version_id%TYPE
242: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
243: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
244: ,p_function_code IN pa_proj_elements.function_code%TYPE
245: ,p_project_id IN pa_projects_all.project_id%TYPE
246: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
247: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
248: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
249: ) ;

Line 265: ,p_source_project_id IN pa_projects_all.project_id%TYPE

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
269: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null

Line 266: ,p_target_project_id IN pa_projects_all.project_id%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
269: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
270: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null

Line 283: ,p_project_number_from IN pa_projects_all.segment1%TYPE :=NULL

279: (
280: errbuf OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
281: ,retcode OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
282: ,p_function IN pa_lookups.lookup_code%TYPE
283: ,p_project_number_from IN pa_projects_all.segment1%TYPE :=NULL
284: ,p_project_number_to IN pa_projects_all.segment1%TYPE :=NULL
285: );
286:
287: -- 3578694 added

Line 284: ,p_project_number_to IN pa_projects_all.segment1%TYPE :=NULL

280: errbuf OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
281: ,retcode OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
282: ,p_function IN pa_lookups.lookup_code%TYPE
283: ,p_project_number_from IN pa_projects_all.segment1%TYPE :=NULL
284: ,p_project_number_to IN pa_projects_all.segment1%TYPE :=NULL
285: );
286:
287: -- 3578694 added
288: PROCEDURE UPD_DLV_ACTIONS_IN_BULK_TM

Line 346: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE

342: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
343: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
344: ,p_debug_mode IN VARCHAR2 :='N'
345: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
346: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE
347: ,p_project_number IN PA_PROJECTS_ALL.SEGMENT1%TYPE -- 3671408 added IN parameter
348: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
349: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
350: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 347: ,p_project_number IN PA_PROJECTS_ALL.SEGMENT1%TYPE -- 3671408 added IN parameter

343: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
344: ,p_debug_mode IN VARCHAR2 :='N'
345: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
346: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE
347: ,p_project_number IN PA_PROJECTS_ALL.SEGMENT1%TYPE -- 3671408 added IN parameter
348: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
349: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
350: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
351: );

Line 355: p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE

351: );
352:
353: PROCEDURE RUN_ACTION_CONC_FRM_WRP
354: (
355: p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE
356: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
357: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
358: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
359: );