DBA Data[Home] [Help]

APPS.AHL_MM_MTL_MGT_PVT dependencies on FND_API

Line 119: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

115: -- x_mtl_avl_schld_tbl : AHL_MM_MTL_MGT_PVT.Mtl_Avl_Schld_Rec
116: --
117: PROCEDURE CHECK_AVAILABILITY(
118: p_api_version IN NUMBER,
119: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
120: p_commit IN VARCHAR2 := FND_API.g_false,
121: p_module_type IN VARCHAR2 := NULL,
122: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
123: p_schedule_material_id_tbl IN number_table_type,

Line 120: p_commit IN VARCHAR2 := FND_API.g_false,

116: --
117: PROCEDURE CHECK_AVAILABILITY(
118: p_api_version IN NUMBER,
119: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
120: p_commit IN VARCHAR2 := FND_API.g_false,
121: p_module_type IN VARCHAR2 := NULL,
122: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
123: p_schedule_material_id_tbl IN number_table_type,
124: X_MTL_AVL_SCHLD_TBL OUT NOCOPY AHL_MM_MTL_MGT_PVT.MTL_AVL_SCHLD_TBL,

Line 122: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

118: p_api_version IN NUMBER,
119: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
120: p_commit IN VARCHAR2 := FND_API.g_false,
121: p_module_type IN VARCHAR2 := NULL,
122: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
123: p_schedule_material_id_tbl IN number_table_type,
124: X_MTL_AVL_SCHLD_TBL OUT NOCOPY AHL_MM_MTL_MGT_PVT.MTL_AVL_SCHLD_TBL,
125: x_return_status OUT NOCOPY VARCHAR2,
126: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 148: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

144: -- x_mtl_avl_schld_tbl : Table containing output against schedule material req id
145: --
146: PROCEDURE SCHEDULE_MATERIALS(
147: p_api_version IN NUMBER,
148: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
149: p_commit IN VARCHAR2 := FND_API.g_false,
150: P_MODULE_TYPE IN VARCHAR2 := NULL,
151: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
152: p_schedule_material_id_tbl IN number_table_type,

Line 149: p_commit IN VARCHAR2 := FND_API.g_false,

145: --
146: PROCEDURE SCHEDULE_MATERIALS(
147: p_api_version IN NUMBER,
148: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
149: p_commit IN VARCHAR2 := FND_API.g_false,
150: P_MODULE_TYPE IN VARCHAR2 := NULL,
151: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
152: p_schedule_material_id_tbl IN number_table_type,
153: X_MTL_AVL_SCHLD_TBL OUT NOCOPY AHL_MM_MTL_MGT_PVT.MTL_AVL_SCHLD_TBL,

Line 151: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

147: p_api_version IN NUMBER,
148: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
149: p_commit IN VARCHAR2 := FND_API.g_false,
150: P_MODULE_TYPE IN VARCHAR2 := NULL,
151: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
152: p_schedule_material_id_tbl IN number_table_type,
153: X_MTL_AVL_SCHLD_TBL OUT NOCOPY AHL_MM_MTL_MGT_PVT.MTL_AVL_SCHLD_TBL,
154: x_return_status OUT NOCOPY VARCHAR2,
155: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 170: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

166: -- Parameters :
167: --
168: -- Standard IN Parameters :
169: -- p_api_version IN NUMBER Required
170: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
171: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
172: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
173: -- Based on this flag, the API will set the default attributes.
174: -- p_module_type In VARCHAR2 Default NULL

Line 171: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

167: --
168: -- Standard IN Parameters :
169: -- p_api_version IN NUMBER Required
170: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
171: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
172: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
173: -- Based on this flag, the API will set the default attributes.
174: -- p_module_type In VARCHAR2 Default NULL
175: -- This will be null.

Line 172: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

168: -- Standard IN Parameters :
169: -- p_api_version IN NUMBER Required
170: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
171: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
172: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
173: -- Based on this flag, the API will set the default attributes.
174: -- p_module_type In VARCHAR2 Default NULL
175: -- This will be null.
176: -- Standard OUT Parameters :

Line 187: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

183: -- x_mtl_avl_schld_tbl OUT : Table containing output against schedule material req id
184: --
185: PROCEDURE SCHEDULE_VISIT_MATERIALS(
186: P_API_VERSION IN NUMBER,
187: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
188: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
189: P_MODULE_TYPE IN VARCHAR2 := NULL,
190: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
191: P_VISIT_ID IN NUMBER,

Line 188: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

184: --
185: PROCEDURE SCHEDULE_VISIT_MATERIALS(
186: P_API_VERSION IN NUMBER,
187: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
188: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
189: P_MODULE_TYPE IN VARCHAR2 := NULL,
190: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
191: P_VISIT_ID IN NUMBER,
192: X_MTL_AVL_SCHLD_TBL OUT NOCOPY AHL_MM_MTL_MGT_PVT.MTL_AVL_SCHLD_TBL,

Line 190: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

186: P_API_VERSION IN NUMBER,
187: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
188: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
189: P_MODULE_TYPE IN VARCHAR2 := NULL,
190: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
191: P_VISIT_ID IN NUMBER,
192: X_MTL_AVL_SCHLD_TBL OUT NOCOPY AHL_MM_MTL_MGT_PVT.MTL_AVL_SCHLD_TBL,
193: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
194: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 238: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

234: --
235:
236: PROCEDURE CREATE_MOVE_ORDER(
237: p_api_version IN NUMBER,
238: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
239: p_commit IN VARCHAR2 := FND_API.G_FALSE,
240: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
241:
242: p_scheduled_material_id IN NUMBER,

Line 239: p_commit IN VARCHAR2 := FND_API.G_FALSE,

235:
236: PROCEDURE CREATE_MOVE_ORDER(
237: p_api_version IN NUMBER,
238: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
239: p_commit IN VARCHAR2 := FND_API.G_FALSE,
240: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
241:
242: p_scheduled_material_id IN NUMBER,
243: p_supply_tbl_type IN Supply_Tbl_Type,

Line 240: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

236: PROCEDURE CREATE_MOVE_ORDER(
237: p_api_version IN NUMBER,
238: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
239: p_commit IN VARCHAR2 := FND_API.G_FALSE,
240: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
241:
242: p_scheduled_material_id IN NUMBER,
243: p_supply_tbl_type IN Supply_Tbl_Type,
244: x_mo_hdr_id OUT NOCOPY NUMBER,

Line 282: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

278: -- Usage : This procedure is called from variour places where AOG flag gets updated. It is used to
279: -- send workflow notifications upon updation of AOG flag.
280: -- IN Parameters :
281: -- p_api_version IN NUMBER Required
282: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
283: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
284: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
285: -- p_asm_id_tab IN NUMBER Required.
286: --

Line 283: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

279: -- send workflow notifications upon updation of AOG flag.
280: -- IN Parameters :
281: -- p_api_version IN NUMBER Required
282: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
283: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
284: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
285: -- p_asm_id_tab IN NUMBER Required.
286: --
287: -- OUT Parameters :

Line 284: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

280: -- IN Parameters :
281: -- p_api_version IN NUMBER Required
282: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
283: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
284: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
285: -- p_asm_id_tab IN NUMBER Required.
286: --
287: -- OUT Parameters :
288: -- x_return_status OUT VARCHAR2 Required

Line 295: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

291: --
292:
293: PROCEDURE Invoke_AOG_Upd_Notification(
294: p_api_version IN NUMBER := 1.0,
295: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
296: p_commit IN VARCHAR2 := FND_API.G_FALSE,
297: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
298: p_asm_id_tab IN AHL_MM_MTL_MGT_PVT.number_table_type,
299: x_return_status OUT NOCOPY VARCHAR2,

Line 296: p_commit IN VARCHAR2 := FND_API.G_FALSE,

292:
293: PROCEDURE Invoke_AOG_Upd_Notification(
294: p_api_version IN NUMBER := 1.0,
295: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
296: p_commit IN VARCHAR2 := FND_API.G_FALSE,
297: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
298: p_asm_id_tab IN AHL_MM_MTL_MGT_PVT.number_table_type,
299: x_return_status OUT NOCOPY VARCHAR2,
300: x_msg_count OUT NOCOPY NUMBER,

Line 297: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

293: PROCEDURE Invoke_AOG_Upd_Notification(
294: p_api_version IN NUMBER := 1.0,
295: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
296: p_commit IN VARCHAR2 := FND_API.G_FALSE,
297: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
298: p_asm_id_tab IN AHL_MM_MTL_MGT_PVT.number_table_type,
299: x_return_status OUT NOCOPY VARCHAR2,
300: x_msg_count OUT NOCOPY NUMBER,
301: x_msg_data OUT NOCOPY VARCHAR2

Line 318: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE

314: -- Pre-reqs :
315: --
316: -- Standard IN Parameters :
317: -- p_api_version NUMBER := 1.0
318: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
319: -- p_commit VARCHAR2 := FND_API.G_FALSE
320: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
321: -- p_default VARCHAR2 := FND_API.G_FALSE
322: -- p_module_type VARCHAR2 := NULL

Line 319: -- p_commit VARCHAR2 := FND_API.G_FALSE

315: --
316: -- Standard IN Parameters :
317: -- p_api_version NUMBER := 1.0
318: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
319: -- p_commit VARCHAR2 := FND_API.G_FALSE
320: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
321: -- p_default VARCHAR2 := FND_API.G_FALSE
322: -- p_module_type VARCHAR2 := NULL
323: --

Line 320: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL

316: -- Standard IN Parameters :
317: -- p_api_version NUMBER := 1.0
318: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
319: -- p_commit VARCHAR2 := FND_API.G_FALSE
320: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
321: -- p_default VARCHAR2 := FND_API.G_FALSE
322: -- p_module_type VARCHAR2 := NULL
323: --
324: -- Standard OUT Parameters :

Line 321: -- p_default VARCHAR2 := FND_API.G_FALSE

317: -- p_api_version NUMBER := 1.0
318: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
319: -- p_commit VARCHAR2 := FND_API.G_FALSE
320: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
321: -- p_default VARCHAR2 := FND_API.G_FALSE
322: -- p_module_type VARCHAR2 := NULL
323: --
324: -- Standard OUT Parameters :
325: -- p_x_return_status VARCHAR2 Required

Line 345: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

341: PROCEDURE Perform_Inter_Org_Transfer
342: (
343: -- Standard IN params
344: p_api_version IN NUMBER := 1.0,
345: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
346: p_commit IN VARCHAR2 := FND_API.G_FALSE,
347: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
348: p_default IN VARCHAR2 := FND_API.G_FALSE,
349: p_module_type IN VARCHAR2 := NULL,

Line 346: p_commit IN VARCHAR2 := FND_API.G_FALSE,

342: (
343: -- Standard IN params
344: p_api_version IN NUMBER := 1.0,
345: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
346: p_commit IN VARCHAR2 := FND_API.G_FALSE,
347: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
348: p_default IN VARCHAR2 := FND_API.G_FALSE,
349: p_module_type IN VARCHAR2 := NULL,
350: -- Standard OUT params

Line 347: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

343: -- Standard IN params
344: p_api_version IN NUMBER := 1.0,
345: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
346: p_commit IN VARCHAR2 := FND_API.G_FALSE,
347: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
348: p_default IN VARCHAR2 := FND_API.G_FALSE,
349: p_module_type IN VARCHAR2 := NULL,
350: -- Standard OUT params
351: x_return_status OUT NOCOPY VARCHAR2,

Line 348: p_default IN VARCHAR2 := FND_API.G_FALSE,

344: p_api_version IN NUMBER := 1.0,
345: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
346: p_commit IN VARCHAR2 := FND_API.G_FALSE,
347: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
348: p_default IN VARCHAR2 := FND_API.G_FALSE,
349: p_module_type IN VARCHAR2 := NULL,
350: -- Standard OUT params
351: x_return_status OUT NOCOPY VARCHAR2,
352: x_msg_count OUT NOCOPY NUMBER,

Line 375: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE

371: -- Pre-reqs :
372: --
373: -- Standard IN Parameters :
374: -- p_api_version NUMBER := 1.0
375: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
376: -- p_commit VARCHAR2 := FND_API.G_FALSE
377: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
378: -- p_default VARCHAR2 := FND_API.G_FALSE
379: -- p_module_type VARCHAR2 := NULL

Line 376: -- p_commit VARCHAR2 := FND_API.G_FALSE

372: --
373: -- Standard IN Parameters :
374: -- p_api_version NUMBER := 1.0
375: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
376: -- p_commit VARCHAR2 := FND_API.G_FALSE
377: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
378: -- p_default VARCHAR2 := FND_API.G_FALSE
379: -- p_module_type VARCHAR2 := NULL
380: --

Line 377: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL

373: -- Standard IN Parameters :
374: -- p_api_version NUMBER := 1.0
375: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
376: -- p_commit VARCHAR2 := FND_API.G_FALSE
377: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
378: -- p_default VARCHAR2 := FND_API.G_FALSE
379: -- p_module_type VARCHAR2 := NULL
380: --
381: -- Standard OUT Parameters :

Line 378: -- p_default VARCHAR2 := FND_API.G_FALSE

374: -- p_api_version NUMBER := 1.0
375: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
376: -- p_commit VARCHAR2 := FND_API.G_FALSE
377: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
378: -- p_default VARCHAR2 := FND_API.G_FALSE
379: -- p_module_type VARCHAR2 := NULL
380: --
381: -- Standard OUT Parameters :
382: -- x_return_status VARCHAR2 Required

Line 398: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

394: PROCEDURE Perform_Inter_Org_Transfer_Inv
395: (
396: -- Standard IN params
397: p_api_version IN NUMBER := 1.0,
398: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
399: p_commit IN VARCHAR2 := FND_API.G_FALSE,
400: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
401: p_default IN VARCHAR2 := FND_API.G_FALSE,
402: p_module_type IN VARCHAR2 := NULL,

Line 399: p_commit IN VARCHAR2 := FND_API.G_FALSE,

395: (
396: -- Standard IN params
397: p_api_version IN NUMBER := 1.0,
398: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
399: p_commit IN VARCHAR2 := FND_API.G_FALSE,
400: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
401: p_default IN VARCHAR2 := FND_API.G_FALSE,
402: p_module_type IN VARCHAR2 := NULL,
403: -- Standard OUT params

Line 400: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

396: -- Standard IN params
397: p_api_version IN NUMBER := 1.0,
398: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
399: p_commit IN VARCHAR2 := FND_API.G_FALSE,
400: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
401: p_default IN VARCHAR2 := FND_API.G_FALSE,
402: p_module_type IN VARCHAR2 := NULL,
403: -- Standard OUT params
404: x_return_status OUT NOCOPY VARCHAR2,

Line 401: p_default IN VARCHAR2 := FND_API.G_FALSE,

397: p_api_version IN NUMBER := 1.0,
398: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
399: p_commit IN VARCHAR2 := FND_API.G_FALSE,
400: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
401: p_default IN VARCHAR2 := FND_API.G_FALSE,
402: p_module_type IN VARCHAR2 := NULL,
403: -- Standard OUT params
404: x_return_status OUT NOCOPY VARCHAR2,
405: x_msg_count OUT NOCOPY NUMBER,

Line 416: G_RET_STS_SUCCESS VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

412: -- changes by sansatpa begins
413:
414: G_LEVEL_PROCEDURE NUMBER := FND_LOG.LEVEL_PROCEDURE;
415: G_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
416: G_RET_STS_SUCCESS VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
417: G_RET_STS_ERROR varchar2(1) := FND_API.G_RET_STS_ERROR;
418:
419:
420: ---------------------------------------------------------------------------------------------------------

Line 417: G_RET_STS_ERROR varchar2(1) := FND_API.G_RET_STS_ERROR;

413:
414: G_LEVEL_PROCEDURE NUMBER := FND_LOG.LEVEL_PROCEDURE;
415: G_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
416: G_RET_STS_SUCCESS VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
417: G_RET_STS_ERROR varchar2(1) := FND_API.G_RET_STS_ERROR;
418:
419:
420: ---------------------------------------------------------------------------------------------------------
421: -- SANSATPA:: Adding the following procedure for creating Internal Sales Orders

Line 435: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE

431: -- Pre-reqs :
432: --
433: -- Standard IN Parameters :
434: -- p_api_version NUMBER := 1.0
435: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
436: -- p_commit VARCHAR2 := FND_API.G_FALSE
437: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
438: --
439: -- Standard OUT Parameters :

Line 436: -- p_commit VARCHAR2 := FND_API.G_FALSE

432: --
433: -- Standard IN Parameters :
434: -- p_api_version NUMBER := 1.0
435: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
436: -- p_commit VARCHAR2 := FND_API.G_FALSE
437: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
438: --
439: -- Standard OUT Parameters :
440: -- x_return_status VARCHAR2 Required

Line 437: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL

433: -- Standard IN Parameters :
434: -- p_api_version NUMBER := 1.0
435: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
436: -- p_commit VARCHAR2 := FND_API.G_FALSE
437: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
438: --
439: -- Standard OUT Parameters :
440: -- x_return_status VARCHAR2 Required
441: -- x_msg_count NUMBER Required

Line 463: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

459: -- End of Comments --
460: PROCEDURE CREATE_INTERNAL_SALES_ORDER(
461: -- Standard IN params
462: P_API_VERSION IN NUMBER,
463: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
464: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
465: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
466: -- Standard OUT params
467: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 464: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

460: PROCEDURE CREATE_INTERNAL_SALES_ORDER(
461: -- Standard IN params
462: P_API_VERSION IN NUMBER,
463: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
464: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
465: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
466: -- Standard OUT params
467: X_MSG_COUNT OUT NOCOPY NUMBER,
468: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 465: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

461: -- Standard IN params
462: P_API_VERSION IN NUMBER,
463: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
464: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
465: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
466: -- Standard OUT params
467: X_MSG_COUNT OUT NOCOPY NUMBER,
468: X_MSG_DATA OUT NOCOPY VARCHAR2,
469: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 496: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

492: -- Invokes Invoke_AOG_Upd_Notification to send notification and AhlPrdWorkorderPvt.updateWoAogStatus
493: -- to update workorder status to AOG
494: -- IN Parameters :
495: -- p_api_version IN NUMBER Required
496: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
497: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
498: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
499: -- P_SCHEDULE_MATERIAL_ID_TBL IN Table of NUMBER containing ASM ID Required.
500: --

Line 497: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

493: -- to update workorder status to AOG
494: -- IN Parameters :
495: -- p_api_version IN NUMBER Required
496: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
497: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
498: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
499: -- P_SCHEDULE_MATERIAL_ID_TBL IN Table of NUMBER containing ASM ID Required.
500: --
501: -- OUT Parameters :

Line 498: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

494: -- IN Parameters :
495: -- p_api_version IN NUMBER Required
496: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
497: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
498: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
499: -- P_SCHEDULE_MATERIAL_ID_TBL IN Table of NUMBER containing ASM ID Required.
500: --
501: -- OUT Parameters :
502: -- x_return_status OUT VARCHAR2 Required

Line 509: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

505: --
506:
507: PROCEDURE AOG_UPD_NOTIFICATION(
508: P_API_VERSION IN NUMBER := 1.0,
509: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
510: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
511: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
512: P_SCHEDULE_MATERIAL_ID_TBL IN NUMBER_TABLE_TYPE,
513: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 510: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

506:
507: PROCEDURE AOG_UPD_NOTIFICATION(
508: P_API_VERSION IN NUMBER := 1.0,
509: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
510: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
511: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
512: P_SCHEDULE_MATERIAL_ID_TBL IN NUMBER_TABLE_TYPE,
513: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
514: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 511: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

507: PROCEDURE AOG_UPD_NOTIFICATION(
508: P_API_VERSION IN NUMBER := 1.0,
509: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
510: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
511: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
512: P_SCHEDULE_MATERIAL_ID_TBL IN NUMBER_TABLE_TYPE,
513: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
514: X_MSG_COUNT OUT NOCOPY NUMBER,
515: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 526: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

522: -- Type : Public
523: -- Usage : This procedure is called to update AOG flag
524: -- IN Parameters :
525: -- p_api_version IN NUMBER Required
526: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
527: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
528: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
529: -- P_AOG_TBL IN AOG_TBL_TYPE Required.
530: --

Line 527: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

523: -- Usage : This procedure is called to update AOG flag
524: -- IN Parameters :
525: -- p_api_version IN NUMBER Required
526: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
527: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
528: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
529: -- P_AOG_TBL IN AOG_TBL_TYPE Required.
530: --
531: -- OUT Parameters :

Line 528: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

524: -- IN Parameters :
525: -- p_api_version IN NUMBER Required
526: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
527: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
528: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
529: -- P_AOG_TBL IN AOG_TBL_TYPE Required.
530: --
531: -- OUT Parameters :
532: -- x_return_status OUT VARCHAR2 Required

Line 539: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

535: --
536:
537: PROCEDURE UPDATE_AOG(
538: P_API_VERSION IN NUMBER := 1.0,
539: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
540: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
541: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
542: P_AOG_TBL IN AOG_TBL_TYPE,
543: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 540: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

536:
537: PROCEDURE UPDATE_AOG(
538: P_API_VERSION IN NUMBER := 1.0,
539: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
540: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
541: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
542: P_AOG_TBL IN AOG_TBL_TYPE,
543: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
544: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 541: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

537: PROCEDURE UPDATE_AOG(
538: P_API_VERSION IN NUMBER := 1.0,
539: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
540: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
541: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
542: P_AOG_TBL IN AOG_TBL_TYPE,
543: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
544: X_MSG_COUNT OUT NOCOPY NUMBER,
545: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 550: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

546: );
547:
548: /*PROCEDURE PICK_RELEASE(
549: P_API_VERSION IN NUMBER,
550: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
551: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
552: P_ORDER_HEADER_ID IN NUMBER, -- the ISO header is
553: P_ORDER_LINE_ID IN NUMBER, -- the iso line id
554: P_FM_SERIAL_NUM_TBL IN OAF_VARCHAR2_TABLE_100,

Line 551: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

547:
548: /*PROCEDURE PICK_RELEASE(
549: P_API_VERSION IN NUMBER,
550: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
551: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
552: P_ORDER_HEADER_ID IN NUMBER, -- the ISO header is
553: P_ORDER_LINE_ID IN NUMBER, -- the iso line id
554: P_FM_SERIAL_NUM_TBL IN OAF_VARCHAR2_TABLE_100,
555: P_TO_SERIAL_NUM_TBL IN OAF_VARCHAR2_TABLE_100,

Line 583: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

579: --
580:
581: PROCEDURE FILTER_INSTANCES_MATCHING_BG(
582: p_api_version IN NUMBER,
583: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
584: p_commit IN VARCHAR2 := FND_API.G_FALSE,
585: p_module_type IN VARCHAR2,
586: p_demand_Record IN AHL_MM_MTL_MGT_PVT.BG_Demand_Rec,
587: x_return_status OUT NOCOPY VARCHAR2,

Line 584: p_commit IN VARCHAR2 := FND_API.G_FALSE,

580:
581: PROCEDURE FILTER_INSTANCES_MATCHING_BG(
582: p_api_version IN NUMBER,
583: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
584: p_commit IN VARCHAR2 := FND_API.G_FALSE,
585: p_module_type IN VARCHAR2,
586: p_demand_Record IN AHL_MM_MTL_MGT_PVT.BG_Demand_Rec,
587: x_return_status OUT NOCOPY VARCHAR2,
588: x_msg_count OUT NOCOPY NUMBER,

Line 609: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

605: -- X_Inv_Mtl_Avl_Tbl AHL_MM_MTL_MGT_PVT.Inv_Mtl_Avl_Tbl
606: --
607: PROCEDURE GET_AVAILABLE_QUANTITY(
608: P_API_VERSION IN NUMBER,
609: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
610: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
611: P_MODULE_TYPE IN VARCHAR2 := NULL,
612: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
613: P_ORG_ID NUMBER,

Line 610: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

606: --
607: PROCEDURE GET_AVAILABLE_QUANTITY(
608: P_API_VERSION IN NUMBER,
609: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
610: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
611: P_MODULE_TYPE IN VARCHAR2 := NULL,
612: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
613: P_ORG_ID NUMBER,
614: P_INV_ITEM_ID NUMBER,

Line 612: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

608: P_API_VERSION IN NUMBER,
609: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
610: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
611: P_MODULE_TYPE IN VARCHAR2 := NULL,
612: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
613: P_ORG_ID NUMBER,
614: P_INV_ITEM_ID NUMBER,
615: X_Inv_Mtl_Avl_Tbl OUT NOCOPY AHL_MM_MTL_MGT_PVT.Inv_Mtl_Avl_Tbl,
616: x_return_status OUT NOCOPY VARCHAR2,

Line 636: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

632: -- Parameters :
633: --
634: -- Standard IN Parameters :
635: -- p_api_version IN NUMBER Required
636: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
637: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
638: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
639: -- Based on this flag, the API will set the default attributes.
640: -- p_module_type In VARCHAR2 Default NULL

Line 637: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

633: --
634: -- Standard IN Parameters :
635: -- p_api_version IN NUMBER Required
636: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
637: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
638: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
639: -- Based on this flag, the API will set the default attributes.
640: -- p_module_type In VARCHAR2 Default NULL
641: -- This will be null.

Line 638: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

634: -- Standard IN Parameters :
635: -- p_api_version IN NUMBER Required
636: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
637: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
638: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
639: -- Based on this flag, the API will set the default attributes.
640: -- p_module_type In VARCHAR2 Default NULL
641: -- This will be null.
642: -- Standard OUT Parameters :

Line 653: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

649: -- x_mtl_avl_schld_tbl OUT : Table containing output against schedule material req id
650: --
651: PROCEDURE SCHED_ALL_VST_MTLS(
652: P_API_VERSION IN NUMBER,
653: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
654: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
655: P_MODULE_TYPE IN VARCHAR2 := NULL,
656: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
657: P_VISIT_IDS IN AHL_MM_MTL_MGT_PVT.visit_ids_Tbl,

Line 654: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

650: --
651: PROCEDURE SCHED_ALL_VST_MTLS(
652: P_API_VERSION IN NUMBER,
653: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
654: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
655: P_MODULE_TYPE IN VARCHAR2 := NULL,
656: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
657: P_VISIT_IDS IN AHL_MM_MTL_MGT_PVT.visit_ids_Tbl,
658: X_MTL_AVL_SCHLD_TBL OUT NOCOPY AHL_MM_MTL_MGT_PVT.MTL_AVL_SCHLD_TBL,

Line 656: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

652: P_API_VERSION IN NUMBER,
653: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
654: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
655: P_MODULE_TYPE IN VARCHAR2 := NULL,
656: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
657: P_VISIT_IDS IN AHL_MM_MTL_MGT_PVT.visit_ids_Tbl,
658: X_MTL_AVL_SCHLD_TBL OUT NOCOPY AHL_MM_MTL_MGT_PVT.MTL_AVL_SCHLD_TBL,
659: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
660: X_MSG_COUNT OUT NOCOPY NUMBER,