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_PROJ_ELEMENTS

Line 75: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null

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
78: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
79: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 76: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%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
78: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
79: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
80: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 78: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%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
78: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
79: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
80: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
81: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
82: ) ;

Line 123: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null

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
126: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
127: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 124: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%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
126: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
127: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
128: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 125: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null

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
126: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
127: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
128: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
129: );

Line 174: ,p_deliverable_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%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()
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

Line 221: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null

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
224: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
225: ,p_insert_or_update IN VARCHAR2 := 'INSERT'

Line 222: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%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
224: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
225: ,p_insert_or_update IN VARCHAR2 := 'INSERT'
226: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 224: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%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
224: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
225: ,p_insert_or_update IN VARCHAR2 := 'INSERT'
226: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
227: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
228: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 240: ,p_action_id IN pa_proj_elements.proj_element_id%TYPE

236: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
237: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
238: ,p_debug_mode IN VARCHAR2 :='N'
239: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
240: ,p_action_id IN pa_proj_elements.proj_element_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

Line 242: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE

238: ,p_debug_mode IN VARCHAR2 :='N'
239: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
240: ,p_action_id IN pa_proj_elements.proj_element_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

Line 244: ,p_function_code IN pa_proj_elements.function_code%TYPE

240: ,p_action_id IN pa_proj_elements.proj_element_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

Line 267: ,p_task_id IN pa_proj_elements.proj_element_id%TYPE := null

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
271: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null

Line 269: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null

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
271: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
272: ,p_calling_mode IN VARCHAR2 := NULL -- Added for bug# 3911050
273: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 270: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null

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
271: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
272: ,p_calling_mode IN VARCHAR2 := NULL -- Added for bug# 3911050
273: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
274: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 271: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null

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
271: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
272: ,p_calling_mode IN VARCHAR2 := NULL -- Added for bug# 3911050
273: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
274: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
275: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 327: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null

323: ,p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
324: ,p_object_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
325: ,p_object_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
326: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
327: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
328: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
329: ,p_pm_source_reference_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
330: ,p_insert_or_update IN VARCHAR2 := 'UPDATE'
331: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 328: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null

324: ,p_object_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
325: ,p_object_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
326: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
327: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
328: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
329: ,p_pm_source_reference_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
330: ,p_insert_or_update IN VARCHAR2 := 'UPDATE'
331: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
332: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895