DBA Data[Home] [Help]

APPS.PA_DELIVERABLE_PUB dependencies on PA_INTERFACE_UTILS_PUB

Line 62: , p_pm_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR /* Bug no. 3651113 */

58: , p_item_description IN VARCHAR2 := NULL
59: , p_unit_price IN NUMBER := NULL
60: , p_unit_number IN VARCHAR2 := NULL
61: , p_currency_code IN VARCHAR2 := NULL
62: , p_pm_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR /* Bug no. 3651113 */
63: , p_dlvr_item_id OUT NOCOPY PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE --File.Sql.39 bug 4440895
64: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
65: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
66: , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 126: , p_pm_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR /* Bug no. 3651113 */

122: , p_unit_price IN NUMBER := NULL
123: , p_unit_number IN VARCHAR2 := NULL
124: , p_currency_code IN VARCHAR2 := NULL
125: , p_dlvr_item_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
126: , p_pm_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR /* Bug no. 3651113 */
127: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
128: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
129: , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
130: );

Line 140: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

136: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
137: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
138: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
139: ,p_debug_mode IN VARCHAR2 :='N'
140: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
141: ,p_dlv_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
142: ,p_dlv_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
143: ,p_rec_ver_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
144: ,p_dlv_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()

Line 160: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

156: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
157: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
158: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
159: ,p_debug_mode IN VARCHAR2 :='N'
160: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
161: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE
162: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE
163: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
164: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE

Line 182: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

178: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
179: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
180: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
181: ,p_debug_mode IN VARCHAR2 :='N'
182: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
183: ,p_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
184: ,p_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
185: ,p_element_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
186: ,p_element_number_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()

Line 204: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

200: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
201: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
202: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
203: ,p_debug_mode IN VARCHAR2 :='N'
204: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
205: ,p_project_id IN pa_projects_all.project_id%TYPE
206: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
207: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
208: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 219: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

215: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
216: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
217: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
218: ,p_debug_mode IN VARCHAR2 :='N'
219: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
220: ,p_calling_context IN VARCHAR2 := 'PA_TASKS'
221: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE
222: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE
223: ,p_project_id IN pa_projects_all.project_id%TYPE

Line 238: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

234: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
235: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
236: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
237: ,p_debug_mode IN VARCHAR2 :='N'
238: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
239: ,p_project_id IN NUMBER
240: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
241: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
242: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 253: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

249: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
250: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
251: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
252: ,p_debug_mode IN VARCHAR2 :='N'
253: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
254: ,p_source_project_id IN NUMBER
255: ,p_target_project_id IN NUMBER
256: ,p_dlv_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
257: ,p_dlv_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()

Line 280: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

276: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
277: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
278: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
279: ,p_debug_mode IN VARCHAR2 :='N'
280: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
281: /* Bug #: 3305199 SMukka */
282: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
283: /*,p_src_task_versions_tab IN PA_PLSQL_DATATYPES.IdTabTyp */
284: /*,p_dest_task_versions_tab IN PA_PLSQL_DATATYPES.IdTabTyp */