5: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data x_errorcode OUT
6: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
7: PROCEDURE Calculate_Adjustment(
8: p_api_version IN NUMBER ,
9: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
10: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
11: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
12: x_return_status OUT NOCOPY VARCHAR2 ,
13: x_msg_count OUT NOCOPY NUMBER ,
6: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
7: PROCEDURE Calculate_Adjustment(
8: p_api_version IN NUMBER ,
9: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
10: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
11: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
12: x_return_status OUT NOCOPY VARCHAR2 ,
13: x_msg_count OUT NOCOPY NUMBER ,
14: x_msg_data OUT NOCOPY VARCHAR2 ,
7: PROCEDURE Calculate_Adjustment(
8: p_api_version IN NUMBER ,
9: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
10: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
11: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
12: x_return_status OUT NOCOPY VARCHAR2 ,
13: x_msg_count OUT NOCOPY NUMBER ,
14: x_msg_data OUT NOCOPY VARCHAR2 ,
15: x_errorcode OUT NOCOPY NUMBER ,
63: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data OUT
64: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
65: PROCEDURE Set_CCExport(
66: p_api_version IN NUMBER ,
67: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
68: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
69: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
70: x_return_status OUT NOCOPY VARCHAR2 ,
71: x_msg_count OUT NOCOPY NUMBER ,
64: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
65: PROCEDURE Set_CCExport(
66: p_api_version IN NUMBER ,
67: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
68: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
69: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
70: x_return_status OUT NOCOPY VARCHAR2 ,
71: x_msg_count OUT NOCOPY NUMBER ,
72: x_msg_data OUT NOCOPY VARCHAR2 ,
65: PROCEDURE Set_CCExport(
66: p_api_version IN NUMBER ,
67: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
68: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
69: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
70: x_return_status OUT NOCOPY VARCHAR2 ,
71: x_msg_count OUT NOCOPY NUMBER ,
72: x_msg_data OUT NOCOPY VARCHAR2 ,
73: p_cycle_count_entry_id IN NUMBER ,
78: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data OUT
79: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
80: PROCEDURE Set_CCEOIFlags(
81: p_api_version IN NUMBER ,
82: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
83: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
84: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
85: x_return_status OUT NOCOPY VARCHAR2 ,
86: x_msg_count OUT NOCOPY NUMBER ,
79: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
80: PROCEDURE Set_CCEOIFlags(
81: p_api_version IN NUMBER ,
82: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
83: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
84: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
85: x_return_status OUT NOCOPY VARCHAR2 ,
86: x_msg_count OUT NOCOPY NUMBER ,
87: x_msg_data OUT NOCOPY VARCHAR2 ,
80: PROCEDURE Set_CCEOIFlags(
81: p_api_version IN NUMBER ,
82: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
83: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
84: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
85: x_return_status OUT NOCOPY VARCHAR2 ,
86: x_msg_count OUT NOCOPY NUMBER ,
87: x_msg_data OUT NOCOPY VARCHAR2 ,
88: p_cc_entry_interface_id IN NUMBER ,
93: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data ,x_errorcode OUT
94: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
95: PROCEDURE Validate_CHeader(
96: p_api_version IN NUMBER ,
97: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
98: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
99: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
100: x_return_status OUT NOCOPY VARCHAR2 ,
101: x_msg_count OUT NOCOPY NUMBER ,
94: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
95: PROCEDURE Validate_CHeader(
96: p_api_version IN NUMBER ,
97: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
98: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
99: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
100: x_return_status OUT NOCOPY VARCHAR2 ,
101: x_msg_count OUT NOCOPY NUMBER ,
102: x_msg_data OUT NOCOPY VARCHAR2 ,
95: PROCEDURE Validate_CHeader(
96: p_api_version IN NUMBER ,
97: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
98: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
99: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
100: x_return_status OUT NOCOPY VARCHAR2 ,
101: x_msg_count OUT NOCOPY NUMBER ,
102: x_msg_data OUT NOCOPY VARCHAR2 ,
103: x_errorcode OUT NOCOPY NUMBER ,
109: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data ,x_errorcode OUT
110: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
111: PROCEDURE Validate_CountListSeq(
112: p_api_version IN NUMBER ,
113: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
114: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
115: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
116: x_return_status OUT NOCOPY VARCHAR2 ,
117: x_msg_count OUT NOCOPY NUMBER ,
110: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
111: PROCEDURE Validate_CountListSeq(
112: p_api_version IN NUMBER ,
113: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
114: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
115: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
116: x_return_status OUT NOCOPY VARCHAR2 ,
117: x_msg_count OUT NOCOPY NUMBER ,
118: x_msg_data OUT NOCOPY VARCHAR2 ,
111: PROCEDURE Validate_CountListSeq(
112: p_api_version IN NUMBER ,
113: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
114: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
115: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
116: x_return_status OUT NOCOPY VARCHAR2 ,
117: x_msg_count OUT NOCOPY NUMBER ,
118: x_msg_data OUT NOCOPY VARCHAR2 ,
119: x_errorcode OUT NOCOPY NUMBER ,
127: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data ,x_errorcode OUT
128: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
129: PROCEDURE Validate_ItemSKU(
130: p_api_version IN NUMBER ,
131: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
132: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
133: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
134: x_return_status OUT NOCOPY VARCHAR2 ,
135: x_msg_count OUT NOCOPY NUMBER ,
128: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
129: PROCEDURE Validate_ItemSKU(
130: p_api_version IN NUMBER ,
131: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
132: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
133: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
134: x_return_status OUT NOCOPY VARCHAR2 ,
135: x_msg_count OUT NOCOPY NUMBER ,
136: x_msg_data OUT NOCOPY VARCHAR2 ,
129: PROCEDURE Validate_ItemSKU(
130: p_api_version IN NUMBER ,
131: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
132: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
133: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
134: x_return_status OUT NOCOPY VARCHAR2 ,
135: x_msg_count OUT NOCOPY NUMBER ,
136: x_msg_data OUT NOCOPY VARCHAR2 ,
137: x_errorcode OUT NOCOPY NUMBER ,
140: p_sku_rec IN MTL_CCEOI_VAR_PVT.Inv_SKU_Rec_Type ,
141: p_subinventory IN VARCHAR2 ,
142: p_locator_rec IN MTL_CCEOI_VAR_PVT.INV_LOCATOR_REC_TYPE ,
143: p_organization_id IN number,
144: p_simulate IN VARCHAR2 DEFAULT FND_API.G_FALSE)
145: ;
146: --
147: -- Validate the UOM and quantity information
148: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data ,x_errorcode OUT
148: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data ,x_errorcode OUT
149: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
150: PROCEDURE Validate_UOMQuantity(
151: p_api_version IN NUMBER ,
152: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
153: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
154: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
155: x_return_status OUT NOCOPY VARCHAR2 ,
156: x_msg_count OUT NOCOPY NUMBER ,
149: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
150: PROCEDURE Validate_UOMQuantity(
151: p_api_version IN NUMBER ,
152: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
153: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
154: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
155: x_return_status OUT NOCOPY VARCHAR2 ,
156: x_msg_count OUT NOCOPY NUMBER ,
157: x_msg_data OUT NOCOPY VARCHAR2 ,
150: PROCEDURE Validate_UOMQuantity(
151: p_api_version IN NUMBER ,
152: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
153: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
154: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
155: x_return_status OUT NOCOPY VARCHAR2 ,
156: x_msg_count OUT NOCOPY NUMBER ,
157: x_msg_data OUT NOCOPY VARCHAR2 ,
158: x_errorcode OUT NOCOPY NUMBER ,
175: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data ,x_errorcode OUT
176: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
177: PROCEDURE Validate_CDate_Counter(
178: p_api_version IN NUMBER ,
179: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
180: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
181: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
182: x_return_status OUT NOCOPY VARCHAR2 ,
183: x_msg_count OUT NOCOPY NUMBER ,
176: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
177: PROCEDURE Validate_CDate_Counter(
178: p_api_version IN NUMBER ,
179: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
180: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
181: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
182: x_return_status OUT NOCOPY VARCHAR2 ,
183: x_msg_count OUT NOCOPY NUMBER ,
184: x_msg_data OUT NOCOPY VARCHAR2 ,
177: PROCEDURE Validate_CDate_Counter(
178: p_api_version IN NUMBER ,
179: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
180: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
181: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
182: x_return_status OUT NOCOPY VARCHAR2 ,
183: x_msg_count OUT NOCOPY NUMBER ,
184: x_msg_data OUT NOCOPY VARCHAR2 ,
185: x_errorcode OUT NOCOPY NUMBER ,
192: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data ,x_errorcode OUT
193: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
194: PROCEDURE Process_Data(
195: p_api_version IN NUMBER ,
196: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
197: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
198: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
199: x_return_status OUT NOCOPY VARCHAR2 ,
200: x_msg_count OUT NOCOPY NUMBER ,
193: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
194: PROCEDURE Process_Data(
195: p_api_version IN NUMBER ,
196: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
197: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
198: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
199: x_return_status OUT NOCOPY VARCHAR2 ,
200: x_msg_count OUT NOCOPY NUMBER ,
201: x_msg_data OUT NOCOPY VARCHAR2 ,
194: PROCEDURE Process_Data(
195: p_api_version IN NUMBER ,
196: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
197: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
198: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
199: x_return_status OUT NOCOPY VARCHAR2 ,
200: x_msg_count OUT NOCOPY NUMBER ,
201: x_msg_data OUT NOCOPY VARCHAR2 ,
202: x_errorcode OUT NOCOPY NUMBER ,
199: x_return_status OUT NOCOPY VARCHAR2 ,
200: x_msg_count OUT NOCOPY NUMBER ,
201: x_msg_data OUT NOCOPY VARCHAR2 ,
202: x_errorcode OUT NOCOPY NUMBER ,
203: p_simulate IN VARCHAR2 DEFAULT FND_API.G_FALSE,
204: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )
205: ;
206: --
207: -- updates CC entry record information
215: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE ,
216: x_return_status OUT NOCOPY VARCHAR2 );
217: --
218: FUNCTION check_serial_location(P_issue_receipt IN VARCHAR2,
219: p_simulate IN VARCHAR2 DEFAULT FND_API.G_FALSE ) return BOOLEAN;
220:
221: -- resets all global variables to null to prevent their accidental reuse
222: -- on next call of the public api in the same session
223: PROCEDURE Reset_Global_Vars;
229:
230: -- BEGIN INVCONV
231: PROCEDURE validate_secondaryuomqty (
232: p_api_version IN NUMBER
233: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
234: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
235: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
236: , x_return_status OUT NOCOPY VARCHAR2
237: , x_msg_count OUT NOCOPY NUMBER
230: -- BEGIN INVCONV
231: PROCEDURE validate_secondaryuomqty (
232: p_api_version IN NUMBER
233: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
234: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
235: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
236: , x_return_status OUT NOCOPY VARCHAR2
237: , x_msg_count OUT NOCOPY NUMBER
238: , x_msg_data OUT NOCOPY VARCHAR2
231: PROCEDURE validate_secondaryuomqty (
232: p_api_version IN NUMBER
233: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
234: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
235: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
236: , x_return_status OUT NOCOPY VARCHAR2
237: , x_msg_count OUT NOCOPY NUMBER
238: , x_msg_data OUT NOCOPY VARCHAR2
239: , x_errorcode OUT NOCOPY NUMBER