DBA Data[Home] [Help]

APPS.PA_DELIVERABLE_PUB dependencies on PA_NUM_TBL_TYPE

Line 141: ,p_dlv_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()

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

Line 142: ,p_dlv_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()

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()
145: ,p_dlv_number_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
146: ,p_project_id IN pa_projects_all.project_id%TYPE

Line 143: ,p_rec_ver_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()

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()
145: ,p_dlv_number_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
146: ,p_project_id IN pa_projects_all.project_id%TYPE
147: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 183: ,p_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()

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()
187: ,p_task_or_dlv_elt_id IN NUMBER

Line 184: ,p_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()

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()
187: ,p_task_or_dlv_elt_id IN NUMBER
188: ,p_task_or_dlv_ver_id IN NUMBER

Line 256: ,p_dlv_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()

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()
258: ,p_item_details_flag IN VARCHAR2 := 'N'
259: ,p_dlv_actions_flag IN VARCHAR2 := 'N'
260: ,p_dlv_attachments_flag IN VARCHAR2 := 'N'

Line 257: ,p_dlv_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()

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()
258: ,p_item_details_flag IN VARCHAR2 := 'N'
259: ,p_dlv_actions_flag IN VARCHAR2 := 'N'
260: ,p_dlv_attachments_flag IN VARCHAR2 := 'N'
261: ,p_association_flag IN VARCHAR2 := 'N'

Line 282: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */

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 */
285: ,p_src_task_versions_tab IN SYSTEM.pa_num_tbl_type
286: ,p_dest_task_versions_tab IN SYSTEM.pa_num_tbl_type

Line 285: ,p_src_task_versions_tab IN SYSTEM.pa_num_tbl_type

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 */
285: ,p_src_task_versions_tab IN SYSTEM.pa_num_tbl_type
286: ,p_dest_task_versions_tab IN SYSTEM.pa_num_tbl_type
287: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
288: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
289: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 286: ,p_dest_task_versions_tab IN SYSTEM.pa_num_tbl_type

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 */
285: ,p_src_task_versions_tab IN SYSTEM.pa_num_tbl_type
286: ,p_dest_task_versions_tab IN SYSTEM.pa_num_tbl_type
287: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
288: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
289: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
290: ) ;