DBA Data[Home] [Help]

APPS.MTL_CCEOI_PROCESS_PVT dependencies on FND_API

Line 9: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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 ,

Line 10: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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 ,

Line 11: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

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 ,

Line 67: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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 ,

Line 68: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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 ,

Line 69: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

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 ,

Line 82: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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 ,

Line 83: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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 ,

Line 84: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

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 ,

Line 97: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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 ,

Line 98: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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 ,

Line 99: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

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 ,

Line 113: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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 ,

Line 114: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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 ,

Line 115: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

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 ,

Line 131: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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 ,

Line 132: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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 ,

Line 133: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

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 ,

Line 144: p_simulate IN VARCHAR2 DEFAULT FND_API.G_FALSE)

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

Line 152: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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 ,

Line 153: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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 ,

Line 154: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

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 ,

Line 179: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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 ,

Line 180: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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 ,

Line 181: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

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 ,

Line 196: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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 ,

Line 197: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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 ,

Line 198: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

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 ,

Line 203: p_simulate IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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

Line 219: p_simulate IN VARCHAR2 DEFAULT FND_API.G_FALSE ) return BOOLEAN;

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;

Line 233: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false

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

Line 234: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false

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

Line 235: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full

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