APPS.WMS_RE_CUSTOM_PUB dependencies on FND_API

Line 12: g_miss_num constant number := fnd_api.g_miss_num;

8: -- Notes :
9: -- Modified : 02/08/99 mzeckzer created
10:
11: -- Local copies of fnd globals to prevent pragma violations of api functions
12: g_miss_num constant number := fnd_api.g_miss_num;
13: g_miss_char constant varchar2(1) := fnd_api.g_miss_char;
14: g_miss_date constant date := fnd_api.g_miss_date;
15:
16: -- Start of comments

Line 13: g_miss_char constant varchar2(1) := fnd_api.g_miss_char;

9: -- Modified : 02/08/99 mzeckzer created
10:
11: -- Local copies of fnd globals to prevent pragma violations of api functions
12: g_miss_num constant number := fnd_api.g_miss_num;
13: g_miss_char constant varchar2(1) := fnd_api.g_miss_char;
14: g_miss_date constant date := fnd_api.g_miss_date;
15:
16: -- Start of comments
17: -- API name : GetTotalLocationCapacity

Line 14: g_miss_date constant date := fnd_api.g_miss_date;

10:
11: -- Local copies of fnd globals to prevent pragma violations of api functions
12: g_miss_num constant number := fnd_api.g_miss_num;
13: g_miss_char constant varchar2(1) := fnd_api.g_miss_char;
14: g_miss_date constant date := fnd_api.g_miss_date;
15:
16: -- Start of comments
17: -- API name : GetTotalLocationCapacity
18: -- Type : Public

Line 25: -- p_organization_id in number required default = fnd_api.g_miss_num

21: -- This function is made available to be used within put away
22: -- rule setup.
23: -- Pre-reqs : none
24: -- Parameters :
25: -- p_organization_id in number required default = fnd_api.g_miss_num
26: -- p_subinventory_code in varchar2 required default = fnd_api.g_miss_char
27: -- p_locator_id in number optional default = null
28: -- p_inventory_item_id in number required default = fnd_api.g_miss_num
29: -- p_transaction_uom in varchar2 required default = fnd_api.g_miss_char

Line 26: -- p_subinventory_code in varchar2 required default = fnd_api.g_miss_char

22: -- rule setup.
23: -- Pre-reqs : none
24: -- Parameters :
25: -- p_organization_id in number required default = fnd_api.g_miss_num
26: -- p_subinventory_code in varchar2 required default = fnd_api.g_miss_char
27: -- p_locator_id in number optional default = null
28: -- p_inventory_item_id in number required default = fnd_api.g_miss_num
29: -- p_transaction_uom in varchar2 required default = fnd_api.g_miss_char
30: -- return value out number

Line 28: -- p_inventory_item_id in number required default = fnd_api.g_miss_num

24: -- Parameters :
25: -- p_organization_id in number required default = fnd_api.g_miss_num
26: -- p_subinventory_code in varchar2 required default = fnd_api.g_miss_char
27: -- p_locator_id in number optional default = null
28: -- p_inventory_item_id in number required default = fnd_api.g_miss_num
29: -- p_transaction_uom in varchar2 required default = fnd_api.g_miss_char
30: -- return value out number
31: -- Version : not tracked
32: -- Notes : capacity should be returned as measured in txn UOM

Line 29: -- p_transaction_uom in varchar2 required default = fnd_api.g_miss_char

25: -- p_organization_id in number required default = fnd_api.g_miss_num
26: -- p_subinventory_code in varchar2 required default = fnd_api.g_miss_char
27: -- p_locator_id in number optional default = null
28: -- p_inventory_item_id in number required default = fnd_api.g_miss_num
29: -- p_transaction_uom in varchar2 required default = fnd_api.g_miss_char
30: -- return value out number
31: -- Version : not tracked
32: -- Notes : capacity should be returned as measured in txn UOM
33: -- End of comments

Line 53: -- p_organization_id in number required default = fnd_api.g_miss_num

49: -- This function is made available to be used within put away
50: -- rule setup.
51: -- Pre-reqs : none
52: -- Parameters :
53: -- p_organization_id in number required default = fnd_api.g_miss_num
54: -- p_subinventory_code in varchar2 required default = fnd_api.g_miss_char
55: -- p_locator_id in number optional default = null
56: -- p_inventory_item_id in number required default = fnd_api.g_miss_num
57: -- p_transaction_uom in varchar2 required default = fnd_api.g_miss_char

Line 54: -- p_subinventory_code in varchar2 required default = fnd_api.g_miss_char

50: -- rule setup.
51: -- Pre-reqs : none
52: -- Parameters :
53: -- p_organization_id in number required default = fnd_api.g_miss_num
54: -- p_subinventory_code in varchar2 required default = fnd_api.g_miss_char
55: -- p_locator_id in number optional default = null
56: -- p_inventory_item_id in number required default = fnd_api.g_miss_num
57: -- p_transaction_uom in varchar2 required default = fnd_api.g_miss_char
58: -- return value out number

Line 56: -- p_inventory_item_id in number required default = fnd_api.g_miss_num

52: -- Parameters :
53: -- p_organization_id in number required default = fnd_api.g_miss_num
54: -- p_subinventory_code in varchar2 required default = fnd_api.g_miss_char
55: -- p_locator_id in number optional default = null
56: -- p_inventory_item_id in number required default = fnd_api.g_miss_num
57: -- p_transaction_uom in varchar2 required default = fnd_api.g_miss_char
58: -- return value out number
59: -- Version : not tracked
60: -- Notes : capacity should be returned as measured in txn UOM

Line 57: -- p_transaction_uom in varchar2 required default = fnd_api.g_miss_char

53: -- p_organization_id in number required default = fnd_api.g_miss_num
54: -- p_subinventory_code in varchar2 required default = fnd_api.g_miss_char
55: -- p_locator_id in number optional default = null
56: -- p_inventory_item_id in number required default = fnd_api.g_miss_num
57: -- p_transaction_uom in varchar2 required default = fnd_api.g_miss_char
58: -- return value out number
59: -- Version : not tracked
60: -- Notes : capacity should be returned as measured in txn UOM
61: -- End of comments

Line 81: -- p_organization_id in number required default = fnd_api.g_miss_num

77: -- This function is made available to be used within put away
78: -- rule setup.
79: -- Pre-reqs : none
80: -- Parameters :
81: -- p_organization_id in number required default = fnd_api.g_miss_num
82: -- p_subinventory_code in varchar2 required default = fnd_api.g_miss_char
83: -- p_locator_id in number optional default = null
84: -- p_inventory_item_id in number required default = fnd_api.g_miss_num
85: -- p_transaction_quantity in number required default = fnd_api.g_miss_num

Line 82: -- p_subinventory_code in varchar2 required default = fnd_api.g_miss_char

78: -- rule setup.
79: -- Pre-reqs : none
80: -- Parameters :
81: -- p_organization_id in number required default = fnd_api.g_miss_num
82: -- p_subinventory_code in varchar2 required default = fnd_api.g_miss_char
83: -- p_locator_id in number optional default = null
84: -- p_inventory_item_id in number required default = fnd_api.g_miss_num
85: -- p_transaction_quantity in number required default = fnd_api.g_miss_num
86: -- p_transaction_uom in varchar2 required default = fnd_api.g_miss_char

Line 84: -- p_inventory_item_id in number required default = fnd_api.g_miss_num

80: -- Parameters :
81: -- p_organization_id in number required default = fnd_api.g_miss_num
82: -- p_subinventory_code in varchar2 required default = fnd_api.g_miss_char
83: -- p_locator_id in number optional default = null
84: -- p_inventory_item_id in number required default = fnd_api.g_miss_num
85: -- p_transaction_quantity in number required default = fnd_api.g_miss_num
86: -- p_transaction_uom in varchar2 required default = fnd_api.g_miss_char
87: -- return value out number
88: -- Version : not tracked

Line 85: -- p_transaction_quantity in number required default = fnd_api.g_miss_num

81: -- p_organization_id in number required default = fnd_api.g_miss_num
82: -- p_subinventory_code in varchar2 required default = fnd_api.g_miss_char
83: -- p_locator_id in number optional default = null
84: -- p_inventory_item_id in number required default = fnd_api.g_miss_num
85: -- p_transaction_quantity in number required default = fnd_api.g_miss_num
86: -- p_transaction_uom in varchar2 required default = fnd_api.g_miss_char
87: -- return value out number
88: -- Version : not tracked
89: -- Notes : capacity must be returned as measured in txn UOM

Line 86: -- p_transaction_uom in varchar2 required default = fnd_api.g_miss_char

82: -- p_subinventory_code in varchar2 required default = fnd_api.g_miss_char
83: -- p_locator_id in number optional default = null
84: -- p_inventory_item_id in number required default = fnd_api.g_miss_num
85: -- p_transaction_quantity in number required default = fnd_api.g_miss_num
86: -- p_transaction_uom in varchar2 required default = fnd_api.g_miss_char
87: -- return value out number
88: -- Version : not tracked
89: -- Notes : capacity must be returned as measured in txn UOM
90: -- End of comments

Line 111: -- p_organization_id in number required default = fnd_api.g_miss_num

107: -- This function is made available to be used within put away
108: -- rule setup.
109: -- Pre-reqs : none
110: -- Parameters :
111: -- p_organization_id in number required default = fnd_api.g_miss_num
112: -- p_subinventory_code in varchar2 required default = fnd_api.g_miss_char
113: -- p_locator_id in number optional default = null
114: -- p_inventory_item_id in number required default = fnd_api.g_miss_num
115: -- p_transaction_quantity in number required default = fnd_api.g_miss_num

Line 112: -- p_subinventory_code in varchar2 required default = fnd_api.g_miss_char

108: -- rule setup.
109: -- Pre-reqs : none
110: -- Parameters :
111: -- p_organization_id in number required default = fnd_api.g_miss_num
112: -- p_subinventory_code in varchar2 required default = fnd_api.g_miss_char
113: -- p_locator_id in number optional default = null
114: -- p_inventory_item_id in number required default = fnd_api.g_miss_num
115: -- p_transaction_quantity in number required default = fnd_api.g_miss_num
116: -- p_transaction_uom in varchar2 required default = fnd_api.g_miss_char

Line 114: -- p_inventory_item_id in number required default = fnd_api.g_miss_num

110: -- Parameters :
111: -- p_organization_id in number required default = fnd_api.g_miss_num
112: -- p_subinventory_code in varchar2 required default = fnd_api.g_miss_char
113: -- p_locator_id in number optional default = null
114: -- p_inventory_item_id in number required default = fnd_api.g_miss_num
115: -- p_transaction_quantity in number required default = fnd_api.g_miss_num
116: -- p_transaction_uom in varchar2 required default = fnd_api.g_miss_char
117: -- return value out number
118: -- Version : not tracked

Line 115: -- p_transaction_quantity in number required default = fnd_api.g_miss_num

111: -- p_organization_id in number required default = fnd_api.g_miss_num
112: -- p_subinventory_code in varchar2 required default = fnd_api.g_miss_char
113: -- p_locator_id in number optional default = null
114: -- p_inventory_item_id in number required default = fnd_api.g_miss_num
115: -- p_transaction_quantity in number required default = fnd_api.g_miss_num
116: -- p_transaction_uom in varchar2 required default = fnd_api.g_miss_char
117: -- return value out number
118: -- Version : not tracked
119: -- Notes : capacity should be returned as measured in txn UOM

Line 116: -- p_transaction_uom in varchar2 required default = fnd_api.g_miss_char

112: -- p_subinventory_code in varchar2 required default = fnd_api.g_miss_char
113: -- p_locator_id in number optional default = null
114: -- p_inventory_item_id in number required default = fnd_api.g_miss_num
115: -- p_transaction_quantity in number required default = fnd_api.g_miss_num
116: -- p_transaction_uom in varchar2 required default = fnd_api.g_miss_char
117: -- return value out number
118: -- Version : not tracked
119: -- Notes : capacity should be returned as measured in txn UOM
120: -- End of comments

Line 146: -- p_init_msg_list in varchar2 optional default = fnd_api.g_false

142: -- identified by parameters p_transaction_temp_id and
143: -- p_type_code ( already validated by calling procedure )
144: -- set up strategy assignment in WMS_STRATEGY_ASSIGNMENTS
145: -- Parameters :
146: -- p_init_msg_list in varchar2 optional default = fnd_api.g_false
147: -- x_return_status out varchar2(1)
148: -- x_msg_count out number
149: -- x_msg_data out varchar2(2000)
150: -- p_transaction_temp_id in number required default = fnd_api.g_miss_num

Line 150: -- p_transaction_temp_id in number required default = fnd_api.g_miss_num

146: -- p_init_msg_list in varchar2 optional default = fnd_api.g_false
147: -- x_return_status out varchar2(1)
148: -- x_msg_count out number
149: -- x_msg_data out varchar2(2000)
150: -- p_transaction_temp_id in number required default = fnd_api.g_miss_num
151: -- p_type_code in number required default = fnd_api.g_miss_num
152: -- x_strategy_id out number
153: -- Version : not tracked
154: -- Notes : type code of returned strategy has to match type code

Line 151: -- p_type_code in number required default = fnd_api.g_miss_num

147: -- x_return_status out varchar2(1)
148: -- x_msg_count out number
149: -- x_msg_data out varchar2(2000)
150: -- p_transaction_temp_id in number required default = fnd_api.g_miss_num
151: -- p_type_code in number required default = fnd_api.g_miss_num
152: -- x_strategy_id out number
153: -- Version : not tracked
154: -- Notes : type code of returned strategy has to match type code
155: -- parameter

Line 159: p_init_msg_list in varchar2 := fnd_api.g_false

155: -- parameter
156: -- End of comments
157:
158: procedure SearchForStrategy (
159: p_init_msg_list in varchar2 := fnd_api.g_false
160: ,x_return_status out NOCOPY varchar2
161: ,x_msg_count out NOCOPY number
162: ,x_msg_data out NOCOPY varchar2
163: ,p_transaction_temp_id in number := fnd_api.g_miss_num

Line 163: ,p_transaction_temp_id in number := fnd_api.g_miss_num

159: p_init_msg_list in varchar2 := fnd_api.g_false
160: ,x_return_status out NOCOPY varchar2
161: ,x_msg_count out NOCOPY number
162: ,x_msg_data out NOCOPY varchar2
163: ,p_transaction_temp_id in number := fnd_api.g_miss_num
164: ,p_type_code in number := fnd_api.g_miss_num
165: ,x_strategy_id out NOCOPY number
166: );
167:

Line 164: ,p_type_code in number := fnd_api.g_miss_num

160: ,x_return_status out NOCOPY varchar2
161: ,x_msg_count out NOCOPY number
162: ,x_msg_data out NOCOPY varchar2
163: ,p_transaction_temp_id in number := fnd_api.g_miss_num
164: ,p_type_code in number := fnd_api.g_miss_num
165: ,x_strategy_id out NOCOPY number
166: );
167:
168: /**

Line 180: p_init_msg_list in varchar2 optional default = fnd_api.g_false

176: identified by parameters p_transaction_temp_id and
177: p_type_code ( already validated by calling procedure )
178: set up strategy assignment in WMS_STRATEGY_ASSIGNMENTS
179: Parameters :
180: p_init_msg_list in varchar2 optional default = fnd_api.g_false
181: x_return_status out varchar2(1)
182: x_msg_count out number
183: x_msg_data out varchar2(2000)
184: p_transaction_temp_id in number required default = fnd_api.g_miss_num

Line 184: p_transaction_temp_id in number required default = fnd_api.g_miss_num

180: p_init_msg_list in varchar2 optional default = fnd_api.g_false
181: x_return_status out varchar2(1)
182: x_msg_count out number
183: x_msg_data out varchar2(2000)
184: p_transaction_temp_id in number required default = fnd_api.g_miss_num
185: p_type_code in number required default = fnd_api.g_miss_num
186: x_return_type out varchar2 'V' for Value , 'R' for Rule , 'S' for strategy
187: ,x_return_type_id out number
188: Notes : type code of returned strategy has to match type code

Line 185: p_type_code in number required default = fnd_api.g_miss_num

181: x_return_status out varchar2(1)
182: x_msg_count out number
183: x_msg_data out varchar2(2000)
184: p_transaction_temp_id in number required default = fnd_api.g_miss_num
185: p_type_code in number required default = fnd_api.g_miss_num
186: x_return_type out varchar2 'V' for Value , 'R' for Rule , 'S' for strategy
187: ,x_return_type_id out number
188: Notes : type code of returned strategy has to match type code
189: parameter

Line 192: p_init_msg_list in varchar2 := fnd_api.g_false

188: Notes : type code of returned strategy has to match type code
189: parameter
190: */
191: procedure SearchForStrategy (
192: p_init_msg_list in varchar2 := fnd_api.g_false
193: ,x_return_status out NOCOPY varchar2
194: ,x_msg_count out NOCOPY number
195: ,x_msg_data out NOCOPY varchar2
196: ,p_transaction_temp_id in number := fnd_api.g_miss_num

Line 196: ,p_transaction_temp_id in number := fnd_api.g_miss_num

192: p_init_msg_list in varchar2 := fnd_api.g_false
193: ,x_return_status out NOCOPY varchar2
194: ,x_msg_count out NOCOPY number
195: ,x_msg_data out NOCOPY varchar2
196: ,p_transaction_temp_id in number := fnd_api.g_miss_num
197: ,p_type_code in number := fnd_api.g_miss_num
198: ,x_return_type out NOCOPY varchar2 -- 'V' for Value , 'R' for Rule , 'S' for strategy
199: ,x_return_type_id out NOCOPY number
200: );

Line 197: ,p_type_code in number := fnd_api.g_miss_num

193: ,x_return_status out NOCOPY varchar2
194: ,x_msg_count out NOCOPY number
195: ,x_msg_data out NOCOPY varchar2
196: ,p_transaction_temp_id in number := fnd_api.g_miss_num
197: ,p_type_code in number := fnd_api.g_miss_num
198: ,x_return_type out NOCOPY varchar2 -- 'V' for Value , 'R' for Rule , 'S' for strategy
199: ,x_return_type_id out NOCOPY number
200: );
201: