DBA Data[Home] [Help]

APPS.INV_PICK_RELEASE_PUB dependencies on FND_API

Line 54: -- p_init_msg_list (optional, default FND_API.G_FALSE)

50: --
51: -- Input Parameters
52: -- p_api_version_number
53: -- API version number (current version is 1.0)
54: -- p_init_msg_list (optional, default FND_API.G_FALSE)
55: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
56: -- if set to FND_API.G_TRUE
57: -- initialize error message list
58: -- if set to FND_API.G_FALSE - not initialize error

Line 55: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.

51: -- Input Parameters
52: -- p_api_version_number
53: -- API version number (current version is 1.0)
54: -- p_init_msg_list (optional, default FND_API.G_FALSE)
55: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
56: -- if set to FND_API.G_TRUE
57: -- initialize error message list
58: -- if set to FND_API.G_FALSE - not initialize error
59: -- message list

Line 56: -- if set to FND_API.G_TRUE

52: -- p_api_version_number
53: -- API version number (current version is 1.0)
54: -- p_init_msg_list (optional, default FND_API.G_FALSE)
55: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
56: -- if set to FND_API.G_TRUE
57: -- initialize error message list
58: -- if set to FND_API.G_FALSE - not initialize error
59: -- message list
60: -- p_commit (optional, default FND_API.G_FALSE)

Line 58: -- if set to FND_API.G_FALSE - not initialize error

54: -- p_init_msg_list (optional, default FND_API.G_FALSE)
55: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
56: -- if set to FND_API.G_TRUE
57: -- initialize error message list
58: -- if set to FND_API.G_FALSE - not initialize error
59: -- message list
60: -- p_commit (optional, default FND_API.G_FALSE)
61: -- whether or not to commit the changes to database
62: --

Line 60: -- p_commit (optional, default FND_API.G_FALSE)

56: -- if set to FND_API.G_TRUE
57: -- initialize error message list
58: -- if set to FND_API.G_FALSE - not initialize error
59: -- message list
60: -- p_commit (optional, default FND_API.G_FALSE)
61: -- whether or not to commit the changes to database
62: --
63: -- p_mo_line_tbl
64: -- Table of Move Order Line records to pick release

Line 82: -- fnd_api.g_ret_sts_success;

78: --
79: -- Output Parameters
80: -- x_return_status
81: -- if the pick release process succeeds, the value is
82: -- fnd_api.g_ret_sts_success;
83: -- if there is an expected error, the value is
84: -- fnd_api.g_ret_sts_error;
85: -- if there is an unexpected error, the value is
86: -- fnd_api.g_ret_sts_unexp_error;

Line 84: -- fnd_api.g_ret_sts_error;

80: -- x_return_status
81: -- if the pick release process succeeds, the value is
82: -- fnd_api.g_ret_sts_success;
83: -- if there is an expected error, the value is
84: -- fnd_api.g_ret_sts_error;
85: -- if there is an unexpected error, the value is
86: -- fnd_api.g_ret_sts_unexp_error;
87: -- x_msg_count
88: -- if there is one or more errors, the number of error messages

Line 86: -- fnd_api.g_ret_sts_unexp_error;

82: -- fnd_api.g_ret_sts_success;
83: -- if there is an expected error, the value is
84: -- fnd_api.g_ret_sts_error;
85: -- if there is an unexpected error, the value is
86: -- fnd_api.g_ret_sts_unexp_error;
87: -- x_msg_count
88: -- if there is one or more errors, the number of error messages
89: -- in the buffer
90: -- x_msg_data

Line 92: -- (See fnd_api package for more details about the above output parameters)

88: -- if there is one or more errors, the number of error messages
89: -- in the buffer
90: -- x_msg_data
91: -- if there is one and only one error, the error message
92: -- (See fnd_api package for more details about the above output parameters)
93: -- x_pick_release_status
94: -- This output parameter is a table of records (of type
95: -- INV_Release_Status_Tbl_Type) which specifies the pick release status
96: -- for each move order line that is passed in.

Line 109: ,p_allow_partial_pick IN VARCHAR2 DEFAULT fnd_api.g_true

105: ,x_msg_data OUT NOCOPY VARCHAR2
106: ,p_mo_line_tbl IN INV_Move_Order_PUB.TROLIN_TBL_TYPE
107: ,p_auto_pick_confirm IN NUMBER := NULL
108: ,p_grouping_rule_id IN NUMBER := NULL
109: ,p_allow_partial_pick IN VARCHAR2 DEFAULT fnd_api.g_true
110: ,x_pick_release_status OUT NOCOPY INV_Release_Status_Tbl_Type
111: ,p_plan_tasks IN BOOLEAN := FALSE
112: ,p_skip_cartonization IN BOOLEAN := FALSE
113: ,p_mo_transact_date IN DATE := fnd_api.g_miss_date

Line 113: ,p_mo_transact_date IN DATE := fnd_api.g_miss_date

109: ,p_allow_partial_pick IN VARCHAR2 DEFAULT fnd_api.g_true
110: ,x_pick_release_status OUT NOCOPY INV_Release_Status_Tbl_Type
111: ,p_plan_tasks IN BOOLEAN := FALSE
112: ,p_skip_cartonization IN BOOLEAN := FALSE
113: ,p_mo_transact_date IN DATE := fnd_api.g_miss_date
114: );
115:
116:
117: -- Changes for R12 Planned Crossdocking project.

Line 156: ,p_allow_partial_pick IN VARCHAR2 DEFAULT fnd_api.g_true

152: ,x_msg_data OUT NOCOPY VARCHAR2
153: ,p_mo_line_tbl IN INV_Move_Order_PUB.TROLIN_TBL_TYPE
154: ,p_auto_pick_confirm IN NUMBER := NULL
155: ,p_grouping_rule_id IN NUMBER := NULL
156: ,p_allow_partial_pick IN VARCHAR2 DEFAULT fnd_api.g_true
157: ,x_pick_release_status OUT NOCOPY INV_Release_Status_Tbl_Type
158: ,p_plan_tasks IN BOOLEAN := FALSE
159: ,p_skip_cartonization IN BOOLEAN := FALSE
160: ,p_wsh_release_table IN OUT NOCOPY WSH_PR_CRITERIA.relRecTabTyp

Line 205: -- fnd_api.g_ret_sts_success;

201: --
202: -- Output Parameters
203: -- x_return_status
204: -- if the pick release process succeeds, the value is
205: -- fnd_api.g_ret_sts_success;
206: -- if there is an expected error, the value is
207: -- fnd_api.g_ret_sts_error;
208: -- if there is an unexpected error, the value is
209: -- fnd_api.g_ret_sts_unexp_error;

Line 207: -- fnd_api.g_ret_sts_error;

203: -- x_return_status
204: -- if the pick release process succeeds, the value is
205: -- fnd_api.g_ret_sts_success;
206: -- if there is an expected error, the value is
207: -- fnd_api.g_ret_sts_error;
208: -- if there is an unexpected error, the value is
209: -- fnd_api.g_ret_sts_unexp_error;
210: -- x_msg_count
211: -- if there is one or more errors, the number of error messages

Line 209: -- fnd_api.g_ret_sts_unexp_error;

205: -- fnd_api.g_ret_sts_success;
206: -- if there is an expected error, the value is
207: -- fnd_api.g_ret_sts_error;
208: -- if there is an unexpected error, the value is
209: -- fnd_api.g_ret_sts_unexp_error;
210: -- x_msg_count
211: -- if there is one or more errors, the number of error messages
212: -- in the buffer
213: -- x_msg_data

Line 215: -- (See fnd_api package for more details about the above output parameters)

211: -- if there is one or more errors, the number of error messages
212: -- in the buffer
213: -- x_msg_data
214: -- if there is one and only one error, the error message
215: -- (See fnd_api package for more details about the above output parameters)
216: --
217: -- HW INVCONV added p_missing_quantity2
218: PROCEDURE Reserve_Unconfirmed_Quantity
219: (

Line 221: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false

217: -- HW INVCONV added p_missing_quantity2
218: PROCEDURE Reserve_Unconfirmed_Quantity
219: (
220: p_api_version IN NUMBER
221: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
222: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
223: ,x_return_status OUT NOCOPY VARCHAR2
224: ,x_msg_count OUT NOCOPY NUMBER
225: ,x_msg_data OUT NOCOPY VARCHAR2

Line 222: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_false

218: PROCEDURE Reserve_Unconfirmed_Quantity
219: (
220: p_api_version IN NUMBER
221: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
222: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
223: ,x_return_status OUT NOCOPY VARCHAR2
224: ,x_msg_count OUT NOCOPY NUMBER
225: ,x_msg_data OUT NOCOPY VARCHAR2
226: ,p_missing_quantity IN NUMBER

Line 227: ,p_missing_quantity2 IN NUMBER DEFAULT fnd_api.g_miss_num

223: ,x_return_status OUT NOCOPY VARCHAR2
224: ,x_msg_count OUT NOCOPY NUMBER
225: ,x_msg_data OUT NOCOPY VARCHAR2
226: ,p_missing_quantity IN NUMBER
227: ,p_missing_quantity2 IN NUMBER DEFAULT fnd_api.g_miss_num
228: ,p_reservation_id IN NUMBER DEFAULT fnd_api.g_miss_num
229: ,p_demand_source_header_id IN NUMBER DEFAULT fnd_api.g_miss_num
230: ,p_demand_source_line_id IN NUMBER DEFAULT fnd_api.g_miss_num
231: ,p_organization_id IN NUMBER DEFAULT fnd_api.g_miss_num

Line 228: ,p_reservation_id IN NUMBER DEFAULT fnd_api.g_miss_num

224: ,x_msg_count OUT NOCOPY NUMBER
225: ,x_msg_data OUT NOCOPY VARCHAR2
226: ,p_missing_quantity IN NUMBER
227: ,p_missing_quantity2 IN NUMBER DEFAULT fnd_api.g_miss_num
228: ,p_reservation_id IN NUMBER DEFAULT fnd_api.g_miss_num
229: ,p_demand_source_header_id IN NUMBER DEFAULT fnd_api.g_miss_num
230: ,p_demand_source_line_id IN NUMBER DEFAULT fnd_api.g_miss_num
231: ,p_organization_id IN NUMBER DEFAULT fnd_api.g_miss_num
232: ,p_inventory_item_id IN NUMBER DEFAULT fnd_api.g_miss_num

Line 229: ,p_demand_source_header_id IN NUMBER DEFAULT fnd_api.g_miss_num

225: ,x_msg_data OUT NOCOPY VARCHAR2
226: ,p_missing_quantity IN NUMBER
227: ,p_missing_quantity2 IN NUMBER DEFAULT fnd_api.g_miss_num
228: ,p_reservation_id IN NUMBER DEFAULT fnd_api.g_miss_num
229: ,p_demand_source_header_id IN NUMBER DEFAULT fnd_api.g_miss_num
230: ,p_demand_source_line_id IN NUMBER DEFAULT fnd_api.g_miss_num
231: ,p_organization_id IN NUMBER DEFAULT fnd_api.g_miss_num
232: ,p_inventory_item_id IN NUMBER DEFAULT fnd_api.g_miss_num
233: ,p_subinventory_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char

Line 230: ,p_demand_source_line_id IN NUMBER DEFAULT fnd_api.g_miss_num

226: ,p_missing_quantity IN NUMBER
227: ,p_missing_quantity2 IN NUMBER DEFAULT fnd_api.g_miss_num
228: ,p_reservation_id IN NUMBER DEFAULT fnd_api.g_miss_num
229: ,p_demand_source_header_id IN NUMBER DEFAULT fnd_api.g_miss_num
230: ,p_demand_source_line_id IN NUMBER DEFAULT fnd_api.g_miss_num
231: ,p_organization_id IN NUMBER DEFAULT fnd_api.g_miss_num
232: ,p_inventory_item_id IN NUMBER DEFAULT fnd_api.g_miss_num
233: ,p_subinventory_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
234: ,p_locator_id IN NUMBER DEFAULT fnd_api.g_miss_num

Line 231: ,p_organization_id IN NUMBER DEFAULT fnd_api.g_miss_num

227: ,p_missing_quantity2 IN NUMBER DEFAULT fnd_api.g_miss_num
228: ,p_reservation_id IN NUMBER DEFAULT fnd_api.g_miss_num
229: ,p_demand_source_header_id IN NUMBER DEFAULT fnd_api.g_miss_num
230: ,p_demand_source_line_id IN NUMBER DEFAULT fnd_api.g_miss_num
231: ,p_organization_id IN NUMBER DEFAULT fnd_api.g_miss_num
232: ,p_inventory_item_id IN NUMBER DEFAULT fnd_api.g_miss_num
233: ,p_subinventory_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
234: ,p_locator_id IN NUMBER DEFAULT fnd_api.g_miss_num
235: ,p_revision IN VARCHAR2 DEFAULT fnd_api.g_miss_char

Line 232: ,p_inventory_item_id IN NUMBER DEFAULT fnd_api.g_miss_num

228: ,p_reservation_id IN NUMBER DEFAULT fnd_api.g_miss_num
229: ,p_demand_source_header_id IN NUMBER DEFAULT fnd_api.g_miss_num
230: ,p_demand_source_line_id IN NUMBER DEFAULT fnd_api.g_miss_num
231: ,p_organization_id IN NUMBER DEFAULT fnd_api.g_miss_num
232: ,p_inventory_item_id IN NUMBER DEFAULT fnd_api.g_miss_num
233: ,p_subinventory_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
234: ,p_locator_id IN NUMBER DEFAULT fnd_api.g_miss_num
235: ,p_revision IN VARCHAR2 DEFAULT fnd_api.g_miss_char
236: ,p_lot_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char

Line 233: ,p_subinventory_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char

229: ,p_demand_source_header_id IN NUMBER DEFAULT fnd_api.g_miss_num
230: ,p_demand_source_line_id IN NUMBER DEFAULT fnd_api.g_miss_num
231: ,p_organization_id IN NUMBER DEFAULT fnd_api.g_miss_num
232: ,p_inventory_item_id IN NUMBER DEFAULT fnd_api.g_miss_num
233: ,p_subinventory_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
234: ,p_locator_id IN NUMBER DEFAULT fnd_api.g_miss_num
235: ,p_revision IN VARCHAR2 DEFAULT fnd_api.g_miss_char
236: ,p_lot_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
237: );

Line 234: ,p_locator_id IN NUMBER DEFAULT fnd_api.g_miss_num

230: ,p_demand_source_line_id IN NUMBER DEFAULT fnd_api.g_miss_num
231: ,p_organization_id IN NUMBER DEFAULT fnd_api.g_miss_num
232: ,p_inventory_item_id IN NUMBER DEFAULT fnd_api.g_miss_num
233: ,p_subinventory_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
234: ,p_locator_id IN NUMBER DEFAULT fnd_api.g_miss_num
235: ,p_revision IN VARCHAR2 DEFAULT fnd_api.g_miss_char
236: ,p_lot_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
237: );
238:

Line 235: ,p_revision IN VARCHAR2 DEFAULT fnd_api.g_miss_char

231: ,p_organization_id IN NUMBER DEFAULT fnd_api.g_miss_num
232: ,p_inventory_item_id IN NUMBER DEFAULT fnd_api.g_miss_num
233: ,p_subinventory_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
234: ,p_locator_id IN NUMBER DEFAULT fnd_api.g_miss_num
235: ,p_revision IN VARCHAR2 DEFAULT fnd_api.g_miss_char
236: ,p_lot_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
237: );
238:
239: PROCEDURE assign_pick_slip_number(

Line 236: ,p_lot_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char

232: ,p_inventory_item_id IN NUMBER DEFAULT fnd_api.g_miss_num
233: ,p_subinventory_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
234: ,p_locator_id IN NUMBER DEFAULT fnd_api.g_miss_num
235: ,p_revision IN VARCHAR2 DEFAULT fnd_api.g_miss_char
236: ,p_lot_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
237: );
238:
239: PROCEDURE assign_pick_slip_number(
240: x_return_status OUT NOCOPY VARCHAR2,

Line 261: ,p_allow_partial_pick IN VARCHAR2 DEFAULT fnd_api.g_true

257: ,p_out_bound IN VARCHAR2
258: ,p_org_id IN NUMBER
259: ,p_move_order_header_id IN NUMBER
260: ,p_grouping_rule_id IN NUMBER := NULL
261: ,p_allow_partial_pick IN VARCHAR2 DEFAULT fnd_api.g_true
262: );
263:
264: /* Bug 7504490 - Added the procedure Reserve_Unconfqty_lpn. This procedure transfers the reservation
265: of the remaining quantity (task qty-picked qty) to cycle count reservation and ensures that the

Line 271: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false

267:
268: PROCEDURE Reserve_Unconfqty_lpn
269: (
270: p_api_version IN NUMBER
271: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
272: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
273: ,x_return_status OUT NOCOPY VARCHAR2
274: ,x_msg_count OUT NOCOPY NUMBER
275: ,x_msg_data OUT NOCOPY VARCHAR2

Line 272: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_false

268: PROCEDURE Reserve_Unconfqty_lpn
269: (
270: p_api_version IN NUMBER
271: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
272: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
273: ,x_return_status OUT NOCOPY VARCHAR2
274: ,x_msg_count OUT NOCOPY NUMBER
275: ,x_msg_data OUT NOCOPY VARCHAR2
276: ,x_new_rsv_id OUT NOCOPY NUMBER -- bug 8301348

Line 279: ,p_reservation_id IN NUMBER DEFAULT fnd_api.g_miss_num

275: ,x_msg_data OUT NOCOPY VARCHAR2
276: ,x_new_rsv_id OUT NOCOPY NUMBER -- bug 8301348
277: ,p_missing_quantity IN NUMBER
278: ,p_secondary_missing_quantity IN NUMBER DEFAULT NULL /*9251210*/
279: ,p_reservation_id IN NUMBER DEFAULT fnd_api.g_miss_num
280: ,p_demand_source_header_id IN NUMBER DEFAULT fnd_api.g_miss_num
281: ,p_demand_source_line_id IN NUMBER DEFAULT fnd_api.g_miss_num
282: ,p_organization_id IN NUMBER DEFAULT fnd_api.g_miss_num
283: ,p_inventory_item_id IN NUMBER DEFAULT fnd_api.g_miss_num

Line 280: ,p_demand_source_header_id IN NUMBER DEFAULT fnd_api.g_miss_num

276: ,x_new_rsv_id OUT NOCOPY NUMBER -- bug 8301348
277: ,p_missing_quantity IN NUMBER
278: ,p_secondary_missing_quantity IN NUMBER DEFAULT NULL /*9251210*/
279: ,p_reservation_id IN NUMBER DEFAULT fnd_api.g_miss_num
280: ,p_demand_source_header_id IN NUMBER DEFAULT fnd_api.g_miss_num
281: ,p_demand_source_line_id IN NUMBER DEFAULT fnd_api.g_miss_num
282: ,p_organization_id IN NUMBER DEFAULT fnd_api.g_miss_num
283: ,p_inventory_item_id IN NUMBER DEFAULT fnd_api.g_miss_num
284: ,p_subinventory_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char

Line 281: ,p_demand_source_line_id IN NUMBER DEFAULT fnd_api.g_miss_num

277: ,p_missing_quantity IN NUMBER
278: ,p_secondary_missing_quantity IN NUMBER DEFAULT NULL /*9251210*/
279: ,p_reservation_id IN NUMBER DEFAULT fnd_api.g_miss_num
280: ,p_demand_source_header_id IN NUMBER DEFAULT fnd_api.g_miss_num
281: ,p_demand_source_line_id IN NUMBER DEFAULT fnd_api.g_miss_num
282: ,p_organization_id IN NUMBER DEFAULT fnd_api.g_miss_num
283: ,p_inventory_item_id IN NUMBER DEFAULT fnd_api.g_miss_num
284: ,p_subinventory_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
285: ,p_locator_id IN NUMBER DEFAULT fnd_api.g_miss_num

Line 282: ,p_organization_id IN NUMBER DEFAULT fnd_api.g_miss_num

278: ,p_secondary_missing_quantity IN NUMBER DEFAULT NULL /*9251210*/
279: ,p_reservation_id IN NUMBER DEFAULT fnd_api.g_miss_num
280: ,p_demand_source_header_id IN NUMBER DEFAULT fnd_api.g_miss_num
281: ,p_demand_source_line_id IN NUMBER DEFAULT fnd_api.g_miss_num
282: ,p_organization_id IN NUMBER DEFAULT fnd_api.g_miss_num
283: ,p_inventory_item_id IN NUMBER DEFAULT fnd_api.g_miss_num
284: ,p_subinventory_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
285: ,p_locator_id IN NUMBER DEFAULT fnd_api.g_miss_num
286: ,p_revision IN VARCHAR2 DEFAULT fnd_api.g_miss_char

Line 283: ,p_inventory_item_id IN NUMBER DEFAULT fnd_api.g_miss_num

279: ,p_reservation_id IN NUMBER DEFAULT fnd_api.g_miss_num
280: ,p_demand_source_header_id IN NUMBER DEFAULT fnd_api.g_miss_num
281: ,p_demand_source_line_id IN NUMBER DEFAULT fnd_api.g_miss_num
282: ,p_organization_id IN NUMBER DEFAULT fnd_api.g_miss_num
283: ,p_inventory_item_id IN NUMBER DEFAULT fnd_api.g_miss_num
284: ,p_subinventory_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
285: ,p_locator_id IN NUMBER DEFAULT fnd_api.g_miss_num
286: ,p_revision IN VARCHAR2 DEFAULT fnd_api.g_miss_char
287: ,p_lot_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char

Line 284: ,p_subinventory_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char

280: ,p_demand_source_header_id IN NUMBER DEFAULT fnd_api.g_miss_num
281: ,p_demand_source_line_id IN NUMBER DEFAULT fnd_api.g_miss_num
282: ,p_organization_id IN NUMBER DEFAULT fnd_api.g_miss_num
283: ,p_inventory_item_id IN NUMBER DEFAULT fnd_api.g_miss_num
284: ,p_subinventory_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
285: ,p_locator_id IN NUMBER DEFAULT fnd_api.g_miss_num
286: ,p_revision IN VARCHAR2 DEFAULT fnd_api.g_miss_char
287: ,p_lot_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
288: ,p_lpn_id IN NUMBER DEFAULT fnd_api.g_miss_num

Line 285: ,p_locator_id IN NUMBER DEFAULT fnd_api.g_miss_num

281: ,p_demand_source_line_id IN NUMBER DEFAULT fnd_api.g_miss_num
282: ,p_organization_id IN NUMBER DEFAULT fnd_api.g_miss_num
283: ,p_inventory_item_id IN NUMBER DEFAULT fnd_api.g_miss_num
284: ,p_subinventory_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
285: ,p_locator_id IN NUMBER DEFAULT fnd_api.g_miss_num
286: ,p_revision IN VARCHAR2 DEFAULT fnd_api.g_miss_char
287: ,p_lot_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
288: ,p_lpn_id IN NUMBER DEFAULT fnd_api.g_miss_num
289: );

Line 286: ,p_revision IN VARCHAR2 DEFAULT fnd_api.g_miss_char

282: ,p_organization_id IN NUMBER DEFAULT fnd_api.g_miss_num
283: ,p_inventory_item_id IN NUMBER DEFAULT fnd_api.g_miss_num
284: ,p_subinventory_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
285: ,p_locator_id IN NUMBER DEFAULT fnd_api.g_miss_num
286: ,p_revision IN VARCHAR2 DEFAULT fnd_api.g_miss_char
287: ,p_lot_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
288: ,p_lpn_id IN NUMBER DEFAULT fnd_api.g_miss_num
289: );
290:

Line 287: ,p_lot_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char

283: ,p_inventory_item_id IN NUMBER DEFAULT fnd_api.g_miss_num
284: ,p_subinventory_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
285: ,p_locator_id IN NUMBER DEFAULT fnd_api.g_miss_num
286: ,p_revision IN VARCHAR2 DEFAULT fnd_api.g_miss_char
287: ,p_lot_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
288: ,p_lpn_id IN NUMBER DEFAULT fnd_api.g_miss_num
289: );
290:
291:

Line 288: ,p_lpn_id IN NUMBER DEFAULT fnd_api.g_miss_num

284: ,p_subinventory_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
285: ,p_locator_id IN NUMBER DEFAULT fnd_api.g_miss_num
286: ,p_revision IN VARCHAR2 DEFAULT fnd_api.g_miss_char
287: ,p_lot_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
288: ,p_lpn_id IN NUMBER DEFAULT fnd_api.g_miss_num
289: );
290:
291:
292: