DBA Data[Home] [Help]

APPS.PA_ACTIONS_PVT dependencies on PA_PROJ_ELEMENTS

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

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

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

Line 46: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%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
46: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
47: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
48: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
49: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
50: ) ;

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

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

Line 92: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%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
94: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
95: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
96: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

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
94: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
95: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
96: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
97: );

Line 127: ,p_action_id IN pa_proj_elements.proj_element_id%TYPE

123: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
124: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
125: ,p_debug_mode IN VARCHAR2 :='N'
126: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
127: ,p_action_id IN pa_proj_elements.proj_element_id%TYPE
128: ,p_action_ver_id IN pa_proj_element_versions.element_version_id%TYPE
129: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
130: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
131: ,p_function_code IN pa_proj_elements.function_code%TYPE

Line 129: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE

125: ,p_debug_mode IN VARCHAR2 :='N'
126: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
127: ,p_action_id IN pa_proj_elements.proj_element_id%TYPE
128: ,p_action_ver_id IN pa_proj_element_versions.element_version_id%TYPE
129: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
130: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
131: ,p_function_code IN pa_proj_elements.function_code%TYPE
132: ,p_project_id IN pa_projects_all.project_id%TYPE
133: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 131: ,p_function_code IN pa_proj_elements.function_code%TYPE

127: ,p_action_id IN pa_proj_elements.proj_element_id%TYPE
128: ,p_action_ver_id IN pa_proj_element_versions.element_version_id%TYPE
129: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
130: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
131: ,p_function_code IN pa_proj_elements.function_code%TYPE
132: ,p_project_id IN pa_projects_all.project_id%TYPE
133: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
134: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
135: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

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
155: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
156: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
157: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null

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

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
155: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
156: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
157: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
158: ,p_calling_mode IN VARCHAR2 := NULL -- added for bug# 3911050
159: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

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
155: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
156: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
157: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
158: ,p_calling_mode IN VARCHAR2 := NULL -- added for bug# 3911050
159: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
160: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

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
155: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
156: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
157: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
158: ,p_calling_mode IN VARCHAR2 := NULL -- added for bug# 3911050
159: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
160: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
161: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 173: ,p_action_id IN pa_proj_elements.proj_element_id%TYPE

169: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
170: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
171: ,p_debug_mode IN VARCHAR2 :='N'
172: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
173: ,p_action_id IN pa_proj_elements.proj_element_id%TYPE
174: ,p_action_ver_id IN pa_proj_element_versions.element_version_id%TYPE
175: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
176: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
177: ,p_function_code IN pa_proj_elements.function_code%TYPE

Line 175: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE

171: ,p_debug_mode IN VARCHAR2 :='N'
172: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
173: ,p_action_id IN pa_proj_elements.proj_element_id%TYPE
174: ,p_action_ver_id IN pa_proj_element_versions.element_version_id%TYPE
175: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
176: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
177: ,p_function_code IN pa_proj_elements.function_code%TYPE
178: ,p_project_id IN pa_projects_all.project_id%TYPE
179: ,x_action_del_allowed IN VARCHAR2

Line 177: ,p_function_code IN pa_proj_elements.function_code%TYPE

173: ,p_action_id IN pa_proj_elements.proj_element_id%TYPE
174: ,p_action_ver_id IN pa_proj_element_versions.element_version_id%TYPE
175: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
176: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
177: ,p_function_code IN pa_proj_elements.function_code%TYPE
178: ,p_project_id IN pa_projects_all.project_id%TYPE
179: ,x_action_del_allowed IN VARCHAR2
180: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
181: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895