3:
4: /**** {{ R12 Enhanced reservations code changes }}****/
5: --Procedure convert_missing_to_null
6: PROCEDURE convert_missing_to_null
7: (p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
8: , x_rsv_rec OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type);
9: /*** End R12 ***/
10:
11: -- Procedure
4: /**** {{ R12 Enhanced reservations code changes }}****/
5: --Procedure convert_missing_to_null
6: PROCEDURE convert_missing_to_null
7: (p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
8: , x_rsv_rec OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type);
9: /*** End R12 ***/
10:
11: -- Procedure
12: -- query_reservation
37: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
38: , x_return_status OUT NOCOPY VARCHAR2
39: , x_msg_count OUT NOCOPY NUMBER
40: , x_msg_data OUT NOCOPY VARCHAR2
41: , p_query_input IN inv_reservation_global.mtl_reservation_rec_type
42: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false
43: , p_sort_by_req_date IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort
44: , p_cancel_order_mode IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no
45: , x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
39: , x_msg_count OUT NOCOPY NUMBER
40: , x_msg_data OUT NOCOPY VARCHAR2
41: , p_query_input IN inv_reservation_global.mtl_reservation_rec_type
42: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false
43: , p_sort_by_req_date IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort
44: , p_cancel_order_mode IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no
45: , x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
46: , x_mtl_reservation_tbl_count OUT NOCOPY NUMBER
47: , x_error_code OUT NOCOPY NUMBER
40: , x_msg_data OUT NOCOPY VARCHAR2
41: , p_query_input IN inv_reservation_global.mtl_reservation_rec_type
42: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false
43: , p_sort_by_req_date IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort
44: , p_cancel_order_mode IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no
45: , x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
46: , x_mtl_reservation_tbl_count OUT NOCOPY NUMBER
47: , x_error_code OUT NOCOPY NUMBER
48: );
41: , p_query_input IN inv_reservation_global.mtl_reservation_rec_type
42: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false
43: , p_sort_by_req_date IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort
44: , p_cancel_order_mode IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no
45: , x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
46: , x_mtl_reservation_tbl_count OUT NOCOPY NUMBER
47: , x_error_code OUT NOCOPY NUMBER
48: );
49:
53: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
54: , x_return_status OUT NOCOPY VARCHAR2
55: , x_msg_count OUT NOCOPY NUMBER
56: , x_msg_data OUT NOCOPY VARCHAR2
57: , p_query_input IN inv_reservation_global.mtl_reservation_rec_type
58: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false
59: , p_sort_by_req_date IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort
60: , p_cancel_order_mode IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no
61: , p_serial_number_table IN inv_reservation_global.rsv_serial_number_table
55: , x_msg_count OUT NOCOPY NUMBER
56: , x_msg_data OUT NOCOPY VARCHAR2
57: , p_query_input IN inv_reservation_global.mtl_reservation_rec_type
58: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false
59: , p_sort_by_req_date IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort
60: , p_cancel_order_mode IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no
61: , p_serial_number_table IN inv_reservation_global.rsv_serial_number_table
62: , x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
63: , x_mtl_reservation_tbl_count OUT NOCOPY NUMBER
56: , x_msg_data OUT NOCOPY VARCHAR2
57: , p_query_input IN inv_reservation_global.mtl_reservation_rec_type
58: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false
59: , p_sort_by_req_date IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort
60: , p_cancel_order_mode IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no
61: , p_serial_number_table IN inv_reservation_global.rsv_serial_number_table
62: , x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
63: , x_mtl_reservation_tbl_count OUT NOCOPY NUMBER
64: , x_serial_number_table OUT NOCOPY inv_reservation_global.rsv_serial_number_table
57: , p_query_input IN inv_reservation_global.mtl_reservation_rec_type
58: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false
59: , p_sort_by_req_date IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort
60: , p_cancel_order_mode IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no
61: , p_serial_number_table IN inv_reservation_global.rsv_serial_number_table
62: , x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
63: , x_mtl_reservation_tbl_count OUT NOCOPY NUMBER
64: , x_serial_number_table OUT NOCOPY inv_reservation_global.rsv_serial_number_table
65: , x_serial_number_table_count OUT NOCOPY NUMBER
58: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false
59: , p_sort_by_req_date IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort
60: , p_cancel_order_mode IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no
61: , p_serial_number_table IN inv_reservation_global.rsv_serial_number_table
62: , x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
63: , x_mtl_reservation_tbl_count OUT NOCOPY NUMBER
64: , x_serial_number_table OUT NOCOPY inv_reservation_global.rsv_serial_number_table
65: , x_serial_number_table_count OUT NOCOPY NUMBER
66: , x_error_code OUT NOCOPY NUMBER
60: , p_cancel_order_mode IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no
61: , p_serial_number_table IN inv_reservation_global.rsv_serial_number_table
62: , x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
63: , x_mtl_reservation_tbl_count OUT NOCOPY NUMBER
64: , x_serial_number_table OUT NOCOPY inv_reservation_global.rsv_serial_number_table
65: , x_serial_number_table_count OUT NOCOPY NUMBER
66: , x_error_code OUT NOCOPY NUMBER
67: );
68:
76: , x_return_status OUT NOCOPY VARCHAR2
77: , x_msg_count OUT NOCOPY NUMBER
78: , x_msg_data OUT NOCOPY VARCHAR2
79: , p_rsv_rec
80: IN inv_reservation_global.mtl_reservation_rec_type
81: , p_serial_number
82: IN inv_reservation_global.serial_number_tbl_type
83: , x_serial_number
84: OUT NOCOPY inv_reservation_global.serial_number_tbl_type
78: , x_msg_data OUT NOCOPY VARCHAR2
79: , p_rsv_rec
80: IN inv_reservation_global.mtl_reservation_rec_type
81: , p_serial_number
82: IN inv_reservation_global.serial_number_tbl_type
83: , x_serial_number
84: OUT NOCOPY inv_reservation_global.serial_number_tbl_type
85: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
86: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
80: IN inv_reservation_global.mtl_reservation_rec_type
81: , p_serial_number
82: IN inv_reservation_global.serial_number_tbl_type
83: , x_serial_number
84: OUT NOCOPY inv_reservation_global.serial_number_tbl_type
85: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
86: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
87: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
88: , p_over_reservation_flag IN NUMBER DEFAULT 0
106: , x_msg_count OUT NOCOPY NUMBER
107: , x_msg_data OUT NOCOPY VARCHAR2
108: , x_quantity_reserved OUT NOCOPY NUMBER
109: , x_secondary_quantity_reserved OUT NOCOPY NUMBER
110: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
111: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
112: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
113: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
114: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
107: , x_msg_data OUT NOCOPY VARCHAR2
108: , x_quantity_reserved OUT NOCOPY NUMBER
109: , x_secondary_quantity_reserved OUT NOCOPY NUMBER
110: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
111: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
112: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
113: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
114: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
115: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
108: , x_quantity_reserved OUT NOCOPY NUMBER
109: , x_secondary_quantity_reserved OUT NOCOPY NUMBER
110: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
111: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
112: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
113: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
114: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
115: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
116: , p_check_availability IN VARCHAR2 DEFAULT fnd_api.g_false
109: , x_secondary_quantity_reserved OUT NOCOPY NUMBER
110: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
111: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
112: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
113: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
114: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
115: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
116: , p_check_availability IN VARCHAR2 DEFAULT fnd_api.g_false
117: , p_over_reservation_flag IN NUMBER DEFAULT 0
125: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
126: , x_return_status OUT NOCOPY VARCHAR2
127: , x_msg_count OUT NOCOPY NUMBER
128: , x_msg_data OUT NOCOPY VARCHAR2
129: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
130: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
131: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
132: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
133: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
126: , x_return_status OUT NOCOPY VARCHAR2
127: , x_msg_count OUT NOCOPY NUMBER
128: , x_msg_data OUT NOCOPY VARCHAR2
129: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
130: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
131: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
132: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
133: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
134: , p_check_availability IN VARCHAR2 DEFAULT fnd_api.g_false
127: , x_msg_count OUT NOCOPY NUMBER
128: , x_msg_data OUT NOCOPY VARCHAR2
129: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
130: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
131: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
132: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
133: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
134: , p_check_availability IN VARCHAR2 DEFAULT fnd_api.g_false
135: , p_over_reservation_flag IN NUMBER DEFAULT 0
128: , x_msg_data OUT NOCOPY VARCHAR2
129: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
130: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
131: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
132: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
133: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
134: , p_check_availability IN VARCHAR2 DEFAULT fnd_api.g_false
135: , p_over_reservation_flag IN NUMBER DEFAULT 0
136: );
144: , x_return_status OUT NOCOPY VARCHAR2
145: , x_msg_count OUT NOCOPY NUMBER
146: , x_msg_data OUT NOCOPY VARCHAR2
147: , p_rsv_rec
148: IN inv_reservation_global.mtl_reservation_rec_type
149: , p_original_serial_number
150: IN inv_reservation_global.serial_number_tbl_type
151: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
152: );
146: , x_msg_data OUT NOCOPY VARCHAR2
147: , p_rsv_rec
148: IN inv_reservation_global.mtl_reservation_rec_type
149: , p_original_serial_number
150: IN inv_reservation_global.serial_number_tbl_type
151: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
152: );
153: --
154: -- INVCONV - Incorporate secondary quantities into signature
159: , x_return_status OUT NOCOPY VARCHAR2
160: , x_msg_count OUT NOCOPY NUMBER
161: , x_msg_data OUT NOCOPY VARCHAR2
162: , p_rsv_rec
163: IN inv_reservation_global.mtl_reservation_rec_type
164: , p_primary_relieved_quantity IN NUMBER
165: , p_secondary_relieved_quantity IN NUMBER
166: , p_relieve_all IN VARCHAR2 DEFAULT fnd_api.g_true
167: , p_original_serial_number
164: , p_primary_relieved_quantity IN NUMBER
165: , p_secondary_relieved_quantity IN NUMBER
166: , p_relieve_all IN VARCHAR2 DEFAULT fnd_api.g_true
167: , p_original_serial_number
168: IN inv_reservation_global.serial_number_tbl_type
169: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
170: , x_primary_relieved_quantity OUT NOCOPY NUMBER
171: , x_secondary_relieved_quantity OUT NOCOPY NUMBER
172: , x_primary_remain_quantity OUT NOCOPY NUMBER
181: , x_return_status OUT NOCOPY VARCHAR2
182: , x_msg_count OUT NOCOPY NUMBER
183: , x_msg_data OUT NOCOPY VARCHAR2
184: , p_original_rsv_rec
185: IN inv_reservation_global.mtl_reservation_rec_type
186: , p_to_rsv_rec
187: IN inv_reservation_global.mtl_reservation_rec_type
188: , p_original_serial_number
189: IN inv_reservation_global.serial_number_tbl_type
183: , x_msg_data OUT NOCOPY VARCHAR2
184: , p_original_rsv_rec
185: IN inv_reservation_global.mtl_reservation_rec_type
186: , p_to_rsv_rec
187: IN inv_reservation_global.mtl_reservation_rec_type
188: , p_original_serial_number
189: IN inv_reservation_global.serial_number_tbl_type
190: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
191: , p_over_reservation_flag IN NUMBER DEFAULT 0
185: IN inv_reservation_global.mtl_reservation_rec_type
186: , p_to_rsv_rec
187: IN inv_reservation_global.mtl_reservation_rec_type
188: , p_original_serial_number
189: IN inv_reservation_global.serial_number_tbl_type
190: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
191: , p_over_reservation_flag IN NUMBER DEFAULT 0
192: , x_reservation_id OUT NOCOPY NUMBER
193: );
202: , x_return_status OUT NOCOPY VARCHAR2
203: , x_msg_count OUT NOCOPY NUMBER
204: , x_msg_data OUT NOCOPY VARCHAR2
205: , p_original_rsv_rec
206: IN inv_reservation_global.mtl_reservation_rec_type
207: , p_to_rsv_rec
208: IN inv_reservation_global.mtl_reservation_rec_type
209: , p_original_serial_number
210: IN inv_reservation_global.serial_number_tbl_type
204: , x_msg_data OUT NOCOPY VARCHAR2
205: , p_original_rsv_rec
206: IN inv_reservation_global.mtl_reservation_rec_type
207: , p_to_rsv_rec
208: IN inv_reservation_global.mtl_reservation_rec_type
209: , p_original_serial_number
210: IN inv_reservation_global.serial_number_tbl_type
211: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
212: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
206: IN inv_reservation_global.mtl_reservation_rec_type
207: , p_to_rsv_rec
208: IN inv_reservation_global.mtl_reservation_rec_type
209: , p_original_serial_number
210: IN inv_reservation_global.serial_number_tbl_type
211: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
212: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
213: , p_over_reservation_flag IN NUMBER DEFAULT 0
214: , x_reservation_id OUT NOCOPY NUMBER
207: , p_to_rsv_rec
208: IN inv_reservation_global.mtl_reservation_rec_type
209: , p_original_serial_number
210: IN inv_reservation_global.serial_number_tbl_type
211: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
212: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
213: , p_over_reservation_flag IN NUMBER DEFAULT 0
214: , x_reservation_id OUT NOCOPY NUMBER
215: );
245: , x_return_status OUT NOCOPY VARCHAR2
246: , x_msg_count OUT NOCOPY NUMBER
247: , x_msg_data OUT NOCOPY VARCHAR2
248: , p_query_input
249: IN inv_reservation_global.mtl_reservation_rec_type
250: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false
251: , p_sort_by_req_date
252: IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort
253: , p_cancel_order_mode
248: , p_query_input
249: IN inv_reservation_global.mtl_reservation_rec_type
250: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false
251: , p_sort_by_req_date
252: IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort
253: , p_cancel_order_mode
254: IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no
255: , x_mtl_reservation_tbl
256: OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
250: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false
251: , p_sort_by_req_date
252: IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort
253: , p_cancel_order_mode
254: IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no
255: , x_mtl_reservation_tbl
256: OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
257: , x_mtl_reservation_tbl_count OUT NOCOPY NUMBER
258: , x_error_code OUT NOCOPY NUMBER
252: IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort
253: , p_cancel_order_mode
254: IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no
255: , x_mtl_reservation_tbl
256: OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
257: , x_mtl_reservation_tbl_count OUT NOCOPY NUMBER
258: , x_error_code OUT NOCOPY NUMBER
259: );
260:
470: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
471: , x_return_status OUT NOCOPY VARCHAR2
472: , x_msg_count OUT NOCOPY NUMBER
473: , x_msg_data OUT NOCOPY VARCHAR2
474: ,x_failed_rsv_temp_tbl OUT NOCOPY inv_reservation_global.mtl_failed_rsv_tbl_type);
475:
476: PROCEDURE print_rsv_rec(p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type);
477:
478:
472: , x_msg_count OUT NOCOPY NUMBER
473: , x_msg_data OUT NOCOPY VARCHAR2
474: ,x_failed_rsv_temp_tbl OUT NOCOPY inv_reservation_global.mtl_failed_rsv_tbl_type);
475:
476: PROCEDURE print_rsv_rec(p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type);
477:
478:
479: PROCEDURE convert_quantity(x_return_status OUT NOCOPY VARCHAR2, px_rsv_rec IN OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type);
480:
475:
476: PROCEDURE print_rsv_rec(p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type);
477:
478:
479: PROCEDURE convert_quantity(x_return_status OUT NOCOPY VARCHAR2, px_rsv_rec IN OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type);
480:
481: /**** {{ R12 Enhanced reservations code changes }}****/
482: /* This API will take a set of parameters and return the wip entity type and the job type as output. */
483:
489: , x_msg_count OUT NOCOPY NUMBER
490: , x_msg_data OUT NOCOPY VARCHAR2
491: , p_organization_id IN NUMBER DEFAULT NULL
492: , p_item_id IN NUMBER DEFAULT NULL
493: , p_source_type_id IN NUMBER DEFAULT INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_WIP
494: , p_source_header_id IN NUMBER
495: , p_source_line_id IN NUMBER
496: , p_source_line_detail IN NUMBER
497: , x_wip_entity_type OUT NOCOPY NUMBER
558: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
559: , x_return_status OUT NOCOPY VARCHAR2
560: , x_msg_count OUT NOCOPY NUMBER
561: , x_msg_data OUT NOCOPY VARCHAR2
562: , p_serial_number_tbl IN inv_reservation_global.serial_number_tbl_type
563: , x_serial_number_tbl OUT NOCOPY inv_reservation_global.rsv_serial_number_table
564: );
565:
566: /*=================================================================================*
559: , x_return_status OUT NOCOPY VARCHAR2
560: , x_msg_count OUT NOCOPY NUMBER
561: , x_msg_data OUT NOCOPY VARCHAR2
562: , p_serial_number_tbl IN inv_reservation_global.serial_number_tbl_type
563: , x_serial_number_tbl OUT NOCOPY inv_reservation_global.rsv_serial_number_table
564: );
565:
566: /*=================================================================================*
567: | Procedure |
600: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
601: , x_return_status OUT NOCOPY VARCHAR2
602: , x_msg_count OUT NOCOPY NUMBER
603: , x_msg_data OUT NOCOPY VARCHAR2
604: , p_serial_number_tbl IN inv_reservation_global.serial_number_tbl_type
605: , x_serial_number_tbl OUT NOCOPY inv_reservation_global.rsv_serial_number_table
606: , x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
607: );
608:
601: , x_return_status OUT NOCOPY VARCHAR2
602: , x_msg_count OUT NOCOPY NUMBER
603: , x_msg_data OUT NOCOPY VARCHAR2
604: , p_serial_number_tbl IN inv_reservation_global.serial_number_tbl_type
605: , x_serial_number_tbl OUT NOCOPY inv_reservation_global.rsv_serial_number_table
606: , x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
607: );
608:
609: PROCEDURE Transfer_Reservation_SubXfer
602: , x_msg_count OUT NOCOPY NUMBER
603: , x_msg_data OUT NOCOPY VARCHAR2
604: , p_serial_number_tbl IN inv_reservation_global.serial_number_tbl_type
605: , x_serial_number_tbl OUT NOCOPY inv_reservation_global.rsv_serial_number_table
606: , x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
607: );
608:
609: PROCEDURE Transfer_Reservation_SubXfer
610: ( p_api_version_number IN NUMBER DEFAULT 1.0