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_PICK_RELEASE_PUB dependencies on FND_API

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

45: --
46: -- Input Parameters
47: -- p_api_version_number
48: -- API version number (current version is 1.0)
49: -- p_init_msg_list (optional, default FND_API.G_FALSE)
50: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
51: -- if set to FND_API.G_TRUE
52: -- initialize error message list
53: -- if set to FND_API.G_FALSE - not initialize error

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

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

Line 51: -- if set to FND_API.G_TRUE

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

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

49: -- p_init_msg_list (optional, default FND_API.G_FALSE)
50: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
51: -- if set to FND_API.G_TRUE
52: -- initialize error message list
53: -- if set to FND_API.G_FALSE - not initialize error
54: -- message list
55: -- p_commit (optional, default FND_API.G_FALSE)
56: -- whether or not to commit the changes to database
57: --

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

51: -- if set to FND_API.G_TRUE
52: -- initialize error message list
53: -- if set to FND_API.G_FALSE - not initialize error
54: -- message list
55: -- p_commit (optional, default FND_API.G_FALSE)
56: -- whether or not to commit the changes to database
57: --
58: -- p_mo_line_tbl
59: -- Table of Move Order Line records to pick release

Line 77: -- fnd_api.g_ret_sts_success;

73: --
74: -- Output Parameters
75: -- x_return_status
76: -- if the pick release process succeeds, the value is
77: -- fnd_api.g_ret_sts_success;
78: -- if there is an expected error, the value is
79: -- fnd_api.g_ret_sts_error;
80: -- if there is an unexpected error, the value is
81: -- fnd_api.g_ret_sts_unexp_error;

Line 79: -- fnd_api.g_ret_sts_error;

75: -- x_return_status
76: -- if the pick release process succeeds, the value is
77: -- fnd_api.g_ret_sts_success;
78: -- if there is an expected error, the value is
79: -- fnd_api.g_ret_sts_error;
80: -- if there is an unexpected error, the value is
81: -- fnd_api.g_ret_sts_unexp_error;
82: -- x_msg_count
83: -- if there is one or more errors, the number of error messages

Line 81: -- fnd_api.g_ret_sts_unexp_error;

77: -- fnd_api.g_ret_sts_success;
78: -- if there is an expected error, the value is
79: -- fnd_api.g_ret_sts_error;
80: -- if there is an unexpected error, the value is
81: -- fnd_api.g_ret_sts_unexp_error;
82: -- x_msg_count
83: -- if there is one or more errors, the number of error messages
84: -- in the buffer
85: -- x_msg_data

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

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

Line 104: ,p_allow_partial_pick IN VARCHAR2 DEFAULT fnd_api.g_true

100: ,x_msg_data OUT NOCOPY VARCHAR2
101: ,p_mo_line_tbl IN INV_Move_Order_PUB.TROLIN_TBL_TYPE
102: ,p_auto_pick_confirm IN NUMBER := NULL
103: ,p_grouping_rule_id IN NUMBER := NULL
104: ,p_allow_partial_pick IN VARCHAR2 DEFAULT fnd_api.g_true
105: ,x_pick_release_status OUT NOCOPY INV_Release_Status_Tbl_Type
106: ,p_plan_tasks IN BOOLEAN := FALSE
107: ,p_skip_cartonization IN BOOLEAN := FALSE
108: ,p_mo_transact_date IN DATE := fnd_api.g_miss_date

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

104: ,p_allow_partial_pick IN VARCHAR2 DEFAULT fnd_api.g_true
105: ,x_pick_release_status OUT NOCOPY INV_Release_Status_Tbl_Type
106: ,p_plan_tasks IN BOOLEAN := FALSE
107: ,p_skip_cartonization IN BOOLEAN := FALSE
108: ,p_mo_transact_date IN DATE := fnd_api.g_miss_date
109: );
110:
111:
112: -- Changes for R12 Planned Crossdocking project.

Line 151: ,p_allow_partial_pick IN VARCHAR2 DEFAULT fnd_api.g_true

147: ,x_msg_data OUT NOCOPY VARCHAR2
148: ,p_mo_line_tbl IN INV_Move_Order_PUB.TROLIN_TBL_TYPE
149: ,p_auto_pick_confirm IN NUMBER := NULL
150: ,p_grouping_rule_id IN NUMBER := NULL
151: ,p_allow_partial_pick IN VARCHAR2 DEFAULT fnd_api.g_true
152: ,x_pick_release_status OUT NOCOPY INV_Release_Status_Tbl_Type
153: ,p_plan_tasks IN BOOLEAN := FALSE
154: ,p_skip_cartonization IN BOOLEAN := FALSE
155: ,p_wsh_release_table IN OUT NOCOPY WSH_PR_CRITERIA.relRecTabTyp

Line 200: -- fnd_api.g_ret_sts_success;

196: --
197: -- Output Parameters
198: -- x_return_status
199: -- if the pick release process succeeds, the value is
200: -- fnd_api.g_ret_sts_success;
201: -- if there is an expected error, the value is
202: -- fnd_api.g_ret_sts_error;
203: -- if there is an unexpected error, the value is
204: -- fnd_api.g_ret_sts_unexp_error;

Line 202: -- fnd_api.g_ret_sts_error;

198: -- x_return_status
199: -- if the pick release process succeeds, the value is
200: -- fnd_api.g_ret_sts_success;
201: -- if there is an expected error, the value is
202: -- fnd_api.g_ret_sts_error;
203: -- if there is an unexpected error, the value is
204: -- fnd_api.g_ret_sts_unexp_error;
205: -- x_msg_count
206: -- if there is one or more errors, the number of error messages

Line 204: -- fnd_api.g_ret_sts_unexp_error;

200: -- fnd_api.g_ret_sts_success;
201: -- if there is an expected error, the value is
202: -- fnd_api.g_ret_sts_error;
203: -- if there is an unexpected error, the value is
204: -- fnd_api.g_ret_sts_unexp_error;
205: -- x_msg_count
206: -- if there is one or more errors, the number of error messages
207: -- in the buffer
208: -- x_msg_data

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

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

Line 216: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false

212: -- HW INVCONV added p_missing_quantity2
213: PROCEDURE Reserve_Unconfirmed_Quantity
214: (
215: p_api_version IN NUMBER
216: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
217: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
218: ,x_return_status OUT NOCOPY VARCHAR2
219: ,x_msg_count OUT NOCOPY NUMBER
220: ,x_msg_data OUT NOCOPY VARCHAR2

Line 217: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_false

213: PROCEDURE Reserve_Unconfirmed_Quantity
214: (
215: p_api_version IN NUMBER
216: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
217: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
218: ,x_return_status OUT NOCOPY VARCHAR2
219: ,x_msg_count OUT NOCOPY NUMBER
220: ,x_msg_data OUT NOCOPY VARCHAR2
221: ,p_missing_quantity IN NUMBER

Line 222: ,p_missing_quantity2 IN NUMBER DEFAULT fnd_api.g_miss_num

218: ,x_return_status OUT NOCOPY VARCHAR2
219: ,x_msg_count OUT NOCOPY NUMBER
220: ,x_msg_data OUT NOCOPY VARCHAR2
221: ,p_missing_quantity IN NUMBER
222: ,p_missing_quantity2 IN NUMBER DEFAULT fnd_api.g_miss_num
223: ,p_reservation_id IN NUMBER DEFAULT fnd_api.g_miss_num
224: ,p_demand_source_header_id IN NUMBER DEFAULT fnd_api.g_miss_num
225: ,p_demand_source_line_id IN NUMBER DEFAULT fnd_api.g_miss_num
226: ,p_organization_id IN NUMBER DEFAULT fnd_api.g_miss_num

Line 223: ,p_reservation_id IN NUMBER DEFAULT fnd_api.g_miss_num

219: ,x_msg_count OUT NOCOPY NUMBER
220: ,x_msg_data OUT NOCOPY VARCHAR2
221: ,p_missing_quantity IN NUMBER
222: ,p_missing_quantity2 IN NUMBER DEFAULT fnd_api.g_miss_num
223: ,p_reservation_id IN NUMBER DEFAULT fnd_api.g_miss_num
224: ,p_demand_source_header_id IN NUMBER DEFAULT fnd_api.g_miss_num
225: ,p_demand_source_line_id IN NUMBER DEFAULT fnd_api.g_miss_num
226: ,p_organization_id IN NUMBER DEFAULT fnd_api.g_miss_num
227: ,p_inventory_item_id IN NUMBER DEFAULT fnd_api.g_miss_num

Line 224: ,p_demand_source_header_id IN NUMBER DEFAULT fnd_api.g_miss_num

220: ,x_msg_data OUT NOCOPY VARCHAR2
221: ,p_missing_quantity IN NUMBER
222: ,p_missing_quantity2 IN NUMBER DEFAULT fnd_api.g_miss_num
223: ,p_reservation_id IN NUMBER DEFAULT fnd_api.g_miss_num
224: ,p_demand_source_header_id IN NUMBER DEFAULT fnd_api.g_miss_num
225: ,p_demand_source_line_id IN NUMBER DEFAULT fnd_api.g_miss_num
226: ,p_organization_id IN NUMBER DEFAULT fnd_api.g_miss_num
227: ,p_inventory_item_id IN NUMBER DEFAULT fnd_api.g_miss_num
228: ,p_subinventory_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char

Line 225: ,p_demand_source_line_id IN NUMBER DEFAULT fnd_api.g_miss_num

221: ,p_missing_quantity IN NUMBER
222: ,p_missing_quantity2 IN NUMBER DEFAULT fnd_api.g_miss_num
223: ,p_reservation_id IN NUMBER DEFAULT fnd_api.g_miss_num
224: ,p_demand_source_header_id IN NUMBER DEFAULT fnd_api.g_miss_num
225: ,p_demand_source_line_id IN NUMBER DEFAULT fnd_api.g_miss_num
226: ,p_organization_id IN NUMBER DEFAULT fnd_api.g_miss_num
227: ,p_inventory_item_id IN NUMBER DEFAULT fnd_api.g_miss_num
228: ,p_subinventory_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
229: ,p_locator_id IN NUMBER DEFAULT fnd_api.g_miss_num

Line 226: ,p_organization_id IN NUMBER DEFAULT fnd_api.g_miss_num

222: ,p_missing_quantity2 IN NUMBER DEFAULT fnd_api.g_miss_num
223: ,p_reservation_id IN NUMBER DEFAULT fnd_api.g_miss_num
224: ,p_demand_source_header_id IN NUMBER DEFAULT fnd_api.g_miss_num
225: ,p_demand_source_line_id IN NUMBER DEFAULT fnd_api.g_miss_num
226: ,p_organization_id IN NUMBER DEFAULT fnd_api.g_miss_num
227: ,p_inventory_item_id IN NUMBER DEFAULT fnd_api.g_miss_num
228: ,p_subinventory_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
229: ,p_locator_id IN NUMBER DEFAULT fnd_api.g_miss_num
230: ,p_revision IN VARCHAR2 DEFAULT fnd_api.g_miss_char

Line 227: ,p_inventory_item_id IN NUMBER DEFAULT fnd_api.g_miss_num

223: ,p_reservation_id IN NUMBER DEFAULT fnd_api.g_miss_num
224: ,p_demand_source_header_id IN NUMBER DEFAULT fnd_api.g_miss_num
225: ,p_demand_source_line_id IN NUMBER DEFAULT fnd_api.g_miss_num
226: ,p_organization_id IN NUMBER DEFAULT fnd_api.g_miss_num
227: ,p_inventory_item_id IN NUMBER DEFAULT fnd_api.g_miss_num
228: ,p_subinventory_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
229: ,p_locator_id IN NUMBER DEFAULT fnd_api.g_miss_num
230: ,p_revision IN VARCHAR2 DEFAULT fnd_api.g_miss_char
231: ,p_lot_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char

Line 228: ,p_subinventory_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char

224: ,p_demand_source_header_id IN NUMBER DEFAULT fnd_api.g_miss_num
225: ,p_demand_source_line_id IN NUMBER DEFAULT fnd_api.g_miss_num
226: ,p_organization_id IN NUMBER DEFAULT fnd_api.g_miss_num
227: ,p_inventory_item_id IN NUMBER DEFAULT fnd_api.g_miss_num
228: ,p_subinventory_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
229: ,p_locator_id IN NUMBER DEFAULT fnd_api.g_miss_num
230: ,p_revision IN VARCHAR2 DEFAULT fnd_api.g_miss_char
231: ,p_lot_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
232: );

Line 229: ,p_locator_id IN NUMBER DEFAULT fnd_api.g_miss_num

225: ,p_demand_source_line_id IN NUMBER DEFAULT fnd_api.g_miss_num
226: ,p_organization_id IN NUMBER DEFAULT fnd_api.g_miss_num
227: ,p_inventory_item_id IN NUMBER DEFAULT fnd_api.g_miss_num
228: ,p_subinventory_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
229: ,p_locator_id IN NUMBER DEFAULT fnd_api.g_miss_num
230: ,p_revision IN VARCHAR2 DEFAULT fnd_api.g_miss_char
231: ,p_lot_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
232: );
233:

Line 230: ,p_revision IN VARCHAR2 DEFAULT fnd_api.g_miss_char

226: ,p_organization_id IN NUMBER DEFAULT fnd_api.g_miss_num
227: ,p_inventory_item_id IN NUMBER DEFAULT fnd_api.g_miss_num
228: ,p_subinventory_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
229: ,p_locator_id IN NUMBER DEFAULT fnd_api.g_miss_num
230: ,p_revision IN VARCHAR2 DEFAULT fnd_api.g_miss_char
231: ,p_lot_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
232: );
233:
234: PROCEDURE assign_pick_slip_number(

Line 231: ,p_lot_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char

227: ,p_inventory_item_id IN NUMBER DEFAULT fnd_api.g_miss_num
228: ,p_subinventory_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
229: ,p_locator_id IN NUMBER DEFAULT fnd_api.g_miss_num
230: ,p_revision IN VARCHAR2 DEFAULT fnd_api.g_miss_char
231: ,p_lot_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
232: );
233:
234: PROCEDURE assign_pick_slip_number(
235: x_return_status OUT NOCOPY VARCHAR2,

Line 256: ,p_allow_partial_pick IN VARCHAR2 DEFAULT fnd_api.g_true

252: ,p_out_bound IN VARCHAR2
253: ,p_org_id IN NUMBER
254: ,p_move_order_header_id IN NUMBER
255: ,p_grouping_rule_id IN NUMBER := NULL
256: ,p_allow_partial_pick IN VARCHAR2 DEFAULT fnd_api.g_true
257: );
258:
259:
260: END INV_Pick_Release_PUB;