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.INV_RESERVATION_PVT dependencies on INV_RESERVATION_GLOBAL

Line 7: (p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

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

Line 8: , x_rsv_rec OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type);

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

Line 41: , p_query_input IN inv_reservation_global.mtl_reservation_rec_type

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

Line 43: , p_sort_by_req_date IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort

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

Line 44: , p_cancel_order_mode IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no

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: );

Line 45: , x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type

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:

Line 57: , p_query_input IN inv_reservation_global.mtl_reservation_rec_type

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

Line 59: , p_sort_by_req_date IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort

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

Line 60: , p_cancel_order_mode IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no

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

Line 61: , p_serial_number_table IN 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

Line 62: , x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_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
66: , x_error_code OUT NOCOPY NUMBER

Line 64: , x_serial_number_table OUT NOCOPY inv_reservation_global.rsv_serial_number_table

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:

Line 80: IN inv_reservation_global.mtl_reservation_rec_type

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

Line 82: IN 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

Line 84: OUT NOCOPY inv_reservation_global.serial_number_tbl_type

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

Line 110: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

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

Line 111: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

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

Line 112: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type

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

Line 113: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type

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

Line 129: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

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

Line 130: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

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

Line 131: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type

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

Line 132: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type

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: );

Line 148: IN inv_reservation_global.mtl_reservation_rec_type

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: );

Line 150: IN inv_reservation_global.serial_number_tbl_type

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

Line 163: IN inv_reservation_global.mtl_reservation_rec_type

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

Line 168: IN inv_reservation_global.serial_number_tbl_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
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

Line 185: IN inv_reservation_global.mtl_reservation_rec_type

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

Line 187: IN inv_reservation_global.mtl_reservation_rec_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

Line 189: IN inv_reservation_global.serial_number_tbl_type

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: );

Line 206: IN inv_reservation_global.mtl_reservation_rec_type

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

Line 208: IN inv_reservation_global.mtl_reservation_rec_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

Line 210: IN inv_reservation_global.serial_number_tbl_type

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

Line 211: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_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
215: );

Line 249: IN inv_reservation_global.mtl_reservation_rec_type

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

Line 252: IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort

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

Line 254: IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no

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

Line 256: OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type

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:

Line 473: ,x_failed_rsv_temp_tbl OUT NOCOPY inv_reservation_global.mtl_failed_rsv_tbl_type);

469: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
470: , x_return_status OUT NOCOPY VARCHAR2
471: , x_msg_count OUT NOCOPY NUMBER
472: , x_msg_data OUT NOCOPY VARCHAR2
473: ,x_failed_rsv_temp_tbl OUT NOCOPY inv_reservation_global.mtl_failed_rsv_tbl_type);
474:
475: PROCEDURE print_rsv_rec(p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type);
476:
477:

Line 475: PROCEDURE print_rsv_rec(p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type);

471: , x_msg_count OUT NOCOPY NUMBER
472: , x_msg_data OUT NOCOPY VARCHAR2
473: ,x_failed_rsv_temp_tbl OUT NOCOPY inv_reservation_global.mtl_failed_rsv_tbl_type);
474:
475: PROCEDURE print_rsv_rec(p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type);
476:
477:
478: PROCEDURE convert_quantity(x_return_status OUT NOCOPY VARCHAR2, px_rsv_rec IN OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type);
479:

Line 478: PROCEDURE convert_quantity(x_return_status OUT NOCOPY VARCHAR2, px_rsv_rec IN OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type);

474:
475: PROCEDURE print_rsv_rec(p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type);
476:
477:
478: PROCEDURE convert_quantity(x_return_status OUT NOCOPY VARCHAR2, px_rsv_rec IN OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type);
479:
480: /**** {{ R12 Enhanced reservations code changes }}****/
481: /* This API will take a set of parameters and return the wip entity type and the job type as output. */
482:

Line 492: , p_source_type_id IN NUMBER DEFAULT INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_WIP

488: , x_msg_count OUT NOCOPY NUMBER
489: , x_msg_data OUT NOCOPY VARCHAR2
490: , p_organization_id IN NUMBER DEFAULT NULL
491: , p_item_id IN NUMBER DEFAULT NULL
492: , p_source_type_id IN NUMBER DEFAULT INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_WIP
493: , p_source_header_id IN NUMBER
494: , p_source_line_id IN NUMBER
495: , p_source_line_detail IN NUMBER
496: , x_wip_entity_type OUT NOCOPY NUMBER

Line 561: , p_serial_number_tbl IN inv_reservation_global.serial_number_tbl_type

557: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
558: , x_return_status OUT NOCOPY VARCHAR2
559: , x_msg_count OUT NOCOPY NUMBER
560: , x_msg_data OUT NOCOPY VARCHAR2
561: , p_serial_number_tbl IN inv_reservation_global.serial_number_tbl_type
562: , x_serial_number_tbl OUT NOCOPY inv_reservation_global.rsv_serial_number_table
563: );
564:
565: /*=================================================================================*

Line 562: , x_serial_number_tbl OUT NOCOPY inv_reservation_global.rsv_serial_number_table

558: , x_return_status OUT NOCOPY VARCHAR2
559: , x_msg_count OUT NOCOPY NUMBER
560: , x_msg_data OUT NOCOPY VARCHAR2
561: , p_serial_number_tbl IN inv_reservation_global.serial_number_tbl_type
562: , x_serial_number_tbl OUT NOCOPY inv_reservation_global.rsv_serial_number_table
563: );
564:
565: /*=================================================================================*
566: | Procedure |

Line 603: , p_serial_number_tbl IN inv_reservation_global.serial_number_tbl_type

599: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
600: , x_return_status OUT NOCOPY VARCHAR2
601: , x_msg_count OUT NOCOPY NUMBER
602: , x_msg_data OUT NOCOPY VARCHAR2
603: , p_serial_number_tbl IN inv_reservation_global.serial_number_tbl_type
604: , x_serial_number_tbl OUT NOCOPY inv_reservation_global.rsv_serial_number_table
605: , x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
606: );
607:

Line 604: , x_serial_number_tbl OUT NOCOPY inv_reservation_global.rsv_serial_number_table

600: , x_return_status OUT NOCOPY VARCHAR2
601: , x_msg_count OUT NOCOPY NUMBER
602: , x_msg_data OUT NOCOPY VARCHAR2
603: , p_serial_number_tbl IN inv_reservation_global.serial_number_tbl_type
604: , x_serial_number_tbl OUT NOCOPY inv_reservation_global.rsv_serial_number_table
605: , x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
606: );
607:
608: PROCEDURE Transfer_Reservation_SubXfer

Line 605: , x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type

601: , x_msg_count OUT NOCOPY NUMBER
602: , x_msg_data OUT NOCOPY VARCHAR2
603: , p_serial_number_tbl IN inv_reservation_global.serial_number_tbl_type
604: , x_serial_number_tbl OUT NOCOPY inv_reservation_global.rsv_serial_number_table
605: , x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
606: );
607:
608: PROCEDURE Transfer_Reservation_SubXfer
609: ( p_api_version_number IN NUMBER DEFAULT 1.0