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 FND_API

Line 20: -- fnd_api.g_true or fnd_api.g_false (default).

16: -- Input Parameters
17: -- p_query_input
18: -- used to specify query criteria
19: -- p_lock_records
20: -- fnd_api.g_true or fnd_api.g_false (default).
21: -- Specify whether to lock matching records
22: -- p_sort_by_req_date
23: -- Specify whether to sort the return records by requirement date
24: -- see INVRSVGS.pls for details

Line 32: -- fnd_api.g_ret_sts_error.

28: --
29: -- Output Parameters
30: -- x_error_code
31: -- This error code is only meaningful if x_return_status equals
32: -- fnd_api.g_ret_sts_error.
33: -- see INVRSVGS.pls for error code definition
34: PROCEDURE query_reservation
35: (
36: p_api_version_number IN NUMBER

Line 37: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

33: -- see INVRSVGS.pls for error code definition
34: PROCEDURE query_reservation
35: (
36: p_api_version_number IN NUMBER
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

Line 42: , p_lock_records 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
46: , x_mtl_reservation_tbl_count OUT NOCOPY NUMBER

Line 53: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

49:
50: /**** {{ R12 Enhanced reservations code changes }}****/
51: PROCEDURE query_reservation (
52: p_api_version_number IN NUMBER
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

Line 58: , p_lock_records 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
62: , x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type

Line 75: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

71: -- INVCONV - add out parameter x_secondary_quantity_reserved
72: PROCEDURE create_reservation
73: (
74: p_api_version_number IN NUMBER
75: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
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

Line 85: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false

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
89: , x_quantity_reserved OUT NOCOPY NUMBER

Line 86: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false

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
89: , x_quantity_reserved OUT NOCOPY NUMBER
90: , x_secondary_quantity_reserved OUT NOCOPY NUMBER

Line 87: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true

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
89: , x_quantity_reserved OUT NOCOPY NUMBER
90: , x_secondary_quantity_reserved OUT NOCOPY NUMBER
91: , x_reservation_id OUT NOCOPY NUMBER

Line 104: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

100: -- INVCONV - Incorporate secondary_quantity_reserved as an OUT parameter
101: PROCEDURE update_reservation
102: (
103: p_api_version_number IN NUMBER
104: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
105: , x_return_status OUT NOCOPY VARCHAR2
106: , x_msg_count OUT NOCOPY NUMBER
107: , x_msg_data OUT NOCOPY VARCHAR2
108: , x_quantity_reserved OUT NOCOPY NUMBER

Line 114: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true

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

Line 115: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false

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

Line 116: , p_check_availability IN VARCHAR2 DEFAULT fnd_api.g_false

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
118: );
119:
120: --This procedure updates the reservation and will in turn call the

Line 125: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

121: -- overloaded update_reservation
122: PROCEDURE update_reservation
123: (
124: p_api_version_number IN NUMBER
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

Line 133: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true

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

Line 134: , p_check_availability IN VARCHAR2 DEFAULT fnd_api.g_false

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

Line 143: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

139: --
140: PROCEDURE delete_reservation
141: (
142: p_api_version_number IN NUMBER
143: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
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

Line 151: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true

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
155: PROCEDURE relieve_reservation

Line 158: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

154: -- INVCONV - Incorporate secondary quantities into signature
155: PROCEDURE relieve_reservation
156: (
157: p_api_version_number IN NUMBER
158: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
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

Line 166: , p_relieve_all IN VARCHAR2 DEFAULT fnd_api.g_true

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
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

Line 169: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true

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
173: , x_secondary_remain_quantity OUT NOCOPY NUMBER

Line 180: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

176:
177: PROCEDURE transfer_reservation
178: (
179: p_api_version_number IN NUMBER
180: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
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

Line 190: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true

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

Line 201: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

197: -- the to serial number table as an input
198: PROCEDURE transfer_reservation
199: (
200: p_api_version_number IN NUMBER
201: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
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

Line 212: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true

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: );
216: /*** End R12 ***/

Line 244: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

240:
241: PROCEDURE query_reservation_om_hdr_line
242: (
243: p_api_version_number IN NUMBER
244: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
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

Line 250: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false

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
254: IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no

Line 307: p_commit IN VARCHAR2 := FND_API.g_false,

303:
304: PROCEDURE UPD_RESERVATION_PUP ( x_return_status OUT NOCOPY VARCHAR2,
305: x_msg_count OUT NOCOPY NUMBER,
306: x_msg_data OUT NOCOPY VARCHAR2,
307: p_commit IN VARCHAR2 := FND_API.g_false,
308: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
309: p_organization_id IN NUMBER,
310: p_demand_source_header_id IN NUMBER,
311: p_demand_source_line_id IN NUMBER,

Line 308: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

304: PROCEDURE UPD_RESERVATION_PUP ( x_return_status OUT NOCOPY VARCHAR2,
305: x_msg_count OUT NOCOPY NUMBER,
306: x_msg_data OUT NOCOPY VARCHAR2,
307: p_commit IN VARCHAR2 := FND_API.g_false,
308: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
309: p_organization_id IN NUMBER,
310: p_demand_source_header_id IN NUMBER,
311: p_demand_source_line_id IN NUMBER,
312: p_from_subinventory_code IN VARCHAR2,

Line 321: p_validation_flag IN VARCHAR2 := fnd_api.g_false,

317: p_revision IN VARCHAR2,
318: p_lot_number IN VARCHAR2,
319: p_quantity IN NUMBER,
320: p_uom IN VARCHAR2,
321: p_validation_flag IN VARCHAR2 := fnd_api.g_false,
322: p_force_reservation_flag IN VARCHAR2 := fnd_api.g_false
323: );
324:
325: /*

Line 322: p_force_reservation_flag IN VARCHAR2 := fnd_api.g_false

318: p_lot_number IN VARCHAR2,
319: p_quantity IN NUMBER,
320: p_uom IN VARCHAR2,
321: p_validation_flag IN VARCHAR2 := fnd_api.g_false,
322: p_force_reservation_flag IN VARCHAR2 := fnd_api.g_false
323: );
324:
325: /*
326: ** ---------------------------------------------------------------------------

Line 374: , p_commit IN VARCHAR2 := fnd_api.g_false

370: PROCEDURE Upd_Reservation_PUP_New(
371: x_return_status OUT NOCOPY VARCHAR2
372: , x_msg_count OUT NOCOPY NUMBER
373: , x_msg_data OUT NOCOPY VARCHAR2
374: , p_commit IN VARCHAR2 := fnd_api.g_false
375: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
376: , p_organization_id IN NUMBER
377: , p_demand_source_header_id IN NUMBER
378: , p_demand_source_line_id IN NUMBER

Line 375: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false

371: x_return_status OUT NOCOPY VARCHAR2
372: , x_msg_count OUT NOCOPY NUMBER
373: , x_msg_data OUT NOCOPY VARCHAR2
374: , p_commit IN VARCHAR2 := fnd_api.g_false
375: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
376: , p_organization_id IN NUMBER
377: , p_demand_source_header_id IN NUMBER
378: , p_demand_source_line_id IN NUMBER
379: , p_from_subinventory_code IN VARCHAR2

Line 389: , p_validation_flag IN VARCHAR2 := fnd_api.g_false

385: , p_lot_number IN VARCHAR2
386: , p_quantity IN NUMBER
387: , p_uom IN VARCHAR2
388: , p_lpn_id IN NUMBER := NULL
389: , p_validation_flag IN VARCHAR2 := fnd_api.g_false
390: , p_force_reservation_flag IN VARCHAR2 := fnd_api.g_false
391: , p_requirement_date IN DATE DEFAULT NULL -- bug 2879208
392: , p_source_lpn_id IN NUMBER := NULL -- Bug 4016953/3871066
393: , p_demand_source_name IN VARCHAR2 DEFAULT NULL -- RTV Project

Line 390: , p_force_reservation_flag IN VARCHAR2 := fnd_api.g_false

386: , p_quantity IN NUMBER
387: , p_uom IN VARCHAR2
388: , p_lpn_id IN NUMBER := NULL
389: , p_validation_flag IN VARCHAR2 := fnd_api.g_false
390: , p_force_reservation_flag IN VARCHAR2 := fnd_api.g_false
391: , p_requirement_date IN DATE DEFAULT NULL -- bug 2879208
392: , p_source_lpn_id IN NUMBER := NULL -- Bug 4016953/3871066
393: , p_demand_source_name IN VARCHAR2 DEFAULT NULL -- RTV Project
394: );

Line 443: p_commit IN VARCHAR2 := FND_API.g_false,

439: Procedure TRANSFER_LPN_TRX_RESERVATION
440: ( x_return_status OUT NOCOPY VARCHAR2,
441: x_msg_count OUT NOCOPY NUMBER,
442: x_msg_data OUT NOCOPY VARCHAR2,
443: p_commit IN VARCHAR2 := FND_API.g_false,
444: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
445: p_transaction_temp_id IN NUMBER := 0,
446: p_organization_id IN NUMBER,
447: p_lpn_id IN NUMBER,

Line 444: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

440: ( x_return_status OUT NOCOPY VARCHAR2,
441: x_msg_count OUT NOCOPY NUMBER,
442: x_msg_data OUT NOCOPY VARCHAR2,
443: p_commit IN VARCHAR2 := FND_API.g_false,
444: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
445: p_transaction_temp_id IN NUMBER := 0,
446: p_organization_id IN NUMBER,
447: p_lpn_id IN NUMBER,
448: p_from_subinventory_code IN VARCHAR2,

Line 470: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

466: ,p_demand_source_line_id NUMBER
467: ,p_demand_source_header_id NUMBER
468: ,p_demand_source_name VARCHAR2);
469: PROCEDURE Do_check_for_commit( p_api_version_number IN NUMBER
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);

Line 487: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

483:
484: PROCEDURE get_wip_entity_type
485: (
486: p_api_version_number IN NUMBER
487: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
488: , x_return_status OUT NOCOPY VARCHAR2
489: , x_msg_count OUT NOCOPY NUMBER
490: , x_msg_data OUT NOCOPY VARCHAR2
491: , p_organization_id IN NUMBER DEFAULT NULL

Line 539: | Should be fnd_api.g_false or fnd_api.g_true |

535: | p_api_version_number |
536: | API version number |
537: | p_init_msg_lst |
538: | Whether initialize the error message list or not |
539: | Should be fnd_api.g_false or fnd_api.g_true |
540: | p_serial_number_tbl |
541: | table of serials to check whether the serials have been reserved or not |
542: | Output Parameters |
543: | x_return_status |

Line 558: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

554:
555: PROCEDURE is_serial_number_reserved
556: (
557: p_api_version_number IN 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

Line 579: | Should be fnd_api.g_false or fnd_api.g_true |

575: | p_api_version_number |
576: | API version number |
577: | p_init_msg_lst |
578: | Whether initialize the error message list or not |
579: | Should be fnd_api.g_false or fnd_api.g_true |
580: | p_serial_number_tbl |
581: | table of serials to check whether the serials have been reserved or not |
582: | Output Parameters |
583: | x_return_status |

Line 600: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

596:
597: PROCEDURE is_serial_reserved
598: (
599: p_api_version_number IN NUMBER
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

Line 611: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

607: );
608:
609: PROCEDURE Transfer_Reservation_SubXfer
610: ( p_api_version_number IN NUMBER DEFAULT 1.0
611: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
612: , x_return_status OUT NOCOPY VARCHAR2
613: , x_msg_count OUT NOCOPY NUMBER
614: , x_msg_data OUT NOCOPY VARCHAR2
615: , p_Inventory_Item_Id IN Number

Line 775: , p_init_msg_lst IN VARCHAR2 Default Fnd_API.G_False

771:
772: PROCEDURE get_ship_qty_tolerance
773: (
774: p_api_version_number IN NUMBER
775: , p_init_msg_lst IN VARCHAR2 Default Fnd_API.G_False
776: , x_return_status OUT NOCOPY VARCHAR2
777: , x_msg_count OUT NOCOPY NUMBER
778: , x_msg_data OUT NOCOPY VARCHAR2
779: , p_demand_type_id IN NUMBER