120: -- Parameters :
121: --
122: -- Standard IN Parameters :
123: -- p_api_version IN NUMBER Required
124: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
125: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
126: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
127: -- p_interface_flag IN VARCHAR2 Required
128: -- p_called_module IN VARCHAR2 Default Null.
121: --
122: -- Standard IN Parameters :
123: -- p_api_version IN NUMBER Required
124: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
125: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
126: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
127: -- p_interface_flag IN VARCHAR2 Required
128: -- p_called_module IN VARCHAR2 Default Null.
129: --
122: -- Standard IN Parameters :
123: -- p_api_version IN NUMBER Required
124: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
125: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
126: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
127: -- p_interface_flag IN VARCHAR2 Required
128: -- p_called_module IN VARCHAR2 Default Null.
129: --
130: -- Standard OUT Parameters :
142: -- End of Comments.
143:
144: PROCEDURE Create_Material_Reqst (
145: p_api_version IN NUMBER,
146: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
147: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
148: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
149: p_interface_flag IN VARCHAR2 ,
150: p_x_req_material_tbl IN OUT NOCOPY Req_Material_Tbl_Type,
143:
144: PROCEDURE Create_Material_Reqst (
145: p_api_version IN NUMBER,
146: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
147: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
148: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
149: p_interface_flag IN VARCHAR2 ,
150: p_x_req_material_tbl IN OUT NOCOPY Req_Material_Tbl_Type,
151: x_job_return_status OUT NOCOPY VARCHAR2,
144: PROCEDURE Create_Material_Reqst (
145: p_api_version IN NUMBER,
146: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
147: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
148: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
149: p_interface_flag IN VARCHAR2 ,
150: p_x_req_material_tbl IN OUT NOCOPY Req_Material_Tbl_Type,
151: x_job_return_status OUT NOCOPY VARCHAR2,
152: x_return_status OUT NOCOPY VARCHAR2,
164: -- Parameters :
165: --
166: -- Standard IN Parameters :
167: -- p_api_version IN NUMBER Required
168: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
169: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
170: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
171: -- Based on this flag, the API will set the default attributes.
172: -- p_module_type In VARCHAR2 Default NULL
165: --
166: -- Standard IN Parameters :
167: -- p_api_version IN NUMBER Required
168: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
169: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
170: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
171: -- Based on this flag, the API will set the default attributes.
172: -- p_module_type In VARCHAR2 Default NULL
173: -- This will be null.
166: -- Standard IN Parameters :
167: -- p_api_version IN NUMBER Required
168: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
169: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
170: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
171: -- Based on this flag, the API will set the default attributes.
172: -- p_module_type In VARCHAR2 Default NULL
173: -- This will be null.
174: -- Standard OUT Parameters :
182: --
183:
184: PROCEDURE Process_Material_Request (
185: p_api_version IN NUMBER,
186: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
187: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
188: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
189: p_module_type IN VARCHAR2 := NULL,
190: p_x_req_material_tbl IN OUT NOCOPY AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type,
183:
184: PROCEDURE Process_Material_Request (
185: p_api_version IN NUMBER,
186: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
187: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
188: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
189: p_module_type IN VARCHAR2 := NULL,
190: p_x_req_material_tbl IN OUT NOCOPY AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type,
191: x_return_status OUT NOCOPY VARCHAR2,
184: PROCEDURE Process_Material_Request (
185: p_api_version IN NUMBER,
186: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
187: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
188: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
189: p_module_type IN VARCHAR2 := NULL,
190: p_x_req_material_tbl IN OUT NOCOPY AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type,
191: x_return_status OUT NOCOPY VARCHAR2,
192: x_msg_count OUT NOCOPY NUMBER,
202: -- Parameters :
203: --
204: -- Standard IN Parameters :
205: -- p_api_version IN NUMBER Required
206: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
207: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
208: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
209: -- Based on this flag, the API will set the default attributes.
210: -- Standard OUT Parameters :
203: --
204: -- Standard IN Parameters :
205: -- p_api_version IN NUMBER Required
206: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
207: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
208: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
209: -- Based on this flag, the API will set the default attributes.
210: -- Standard OUT Parameters :
211: -- x_return_status OUT VARCHAR2 Required
204: -- Standard IN Parameters :
205: -- p_api_version IN NUMBER Required
206: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
207: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
208: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
209: -- Based on this flag, the API will set the default attributes.
210: -- Standard OUT Parameters :
211: -- x_return_status OUT VARCHAR2 Required
212: -- x_msg_count OUT NUMBER Required
219: --
220:
221: PROCEDURE Process_Wo_Op_Materials (
222: p_api_version IN NUMBER,
223: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
224: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
225: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
226: p_operation_flag IN VARCHAR2,
227: p_prd_wooperation_tbl IN AHL_PRD_OPERATIONS_PVT.Prd_Operation_Tbl,
220:
221: PROCEDURE Process_Wo_Op_Materials (
222: p_api_version IN NUMBER,
223: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
224: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
225: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
226: p_operation_flag IN VARCHAR2,
227: p_prd_wooperation_tbl IN AHL_PRD_OPERATIONS_PVT.Prd_Operation_Tbl,
228: x_req_material_tbl OUT NOCOPY Req_Material_Tbl_Type,
221: PROCEDURE Process_Wo_Op_Materials (
222: p_api_version IN NUMBER,
223: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
224: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
225: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
226: p_operation_flag IN VARCHAR2,
227: p_prd_wooperation_tbl IN AHL_PRD_OPERATIONS_PVT.Prd_Operation_Tbl,
228: x_req_material_tbl OUT NOCOPY Req_Material_Tbl_Type,
229: x_return_status OUT NOCOPY VARCHAR2,
379: -- Parameters :
380: --
381: -- Standard IN Parameters :
382: -- p_api_version IN NUMBER Required
383: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
384: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
385: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
386: -- Based on this flag, the API will set the default attributes.
387: -- Standard OUT Parameters :
380: --
381: -- Standard IN Parameters :
382: -- p_api_version IN NUMBER Required
383: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
384: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
385: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
386: -- Based on this flag, the API will set the default attributes.
387: -- Standard OUT Parameters :
388: -- x_return_status OUT VARCHAR2 Required
381: -- Standard IN Parameters :
382: -- p_api_version IN NUMBER Required
383: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
384: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
385: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
386: -- Based on this flag, the API will set the default attributes.
387: -- Standard OUT Parameters :
388: -- x_return_status OUT VARCHAR2 Required
389: -- x_msg_count OUT NUMBER Required