eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.AHL_MM_MTL_MGT_PVT dependencies on AHL_MM_MTL_MGT_PVT

Line 1: PACKAGE BODY AHL_MM_MTL_MGT_PVT AS

1: PACKAGE BODY AHL_MM_MTL_MGT_PVT AS
2: /* $Header: AHLVMMGB.pls 120.0.12020000.3 2013/01/03 09:30:28 sansatpa noship $*/
3: ------------------------------------
4: -- Common constants and variables --
5: ------------------------------------

Line 128: -- x_mtl_avl_schld_tbl : AHL_MM_MTL_MGT_PVT.Mtl_Avl_Schld_Rec

124: -- x_return_status OUT VARCHAR2 Required
125: --
126: -- Check_Material_Aval Parameters :
127: -- p_schedule_material_id_tbl : Table containing Schedule material requirement id of the demand.
128: -- x_mtl_avl_schld_tbl : AHL_MM_MTL_MGT_PVT.Mtl_Avl_Schld_Rec
129: --
130: PROCEDURE CHECK_AVAILABILITY(
131: P_API_VERSION IN NUMBER,
132: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

Line 137: X_MTL_AVL_SCHLD_TBL OUT NOCOPY AHL_MM_MTL_MGT_PVT.MTL_AVL_SCHLD_TBL,

133: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
134: P_MODULE_TYPE IN VARCHAR2 := NULL,
135: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
136: P_SCHEDULE_MATERIAL_ID_TBL IN NUMBER_TABLE_TYPE,
137: X_MTL_AVL_SCHLD_TBL OUT NOCOPY AHL_MM_MTL_MGT_PVT.MTL_AVL_SCHLD_TBL,
138: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
139: X_MSG_COUNT OUT NOCOPY NUMBER,
140: X_MSG_DATA OUT NOCOPY VARCHAR2)
141: IS

Line 276: X_MTL_AVL_SCHLD_TBL OUT NOCOPY AHL_MM_MTL_MGT_PVT.MTL_AVL_SCHLD_TBL,

272: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
273: P_MODULE_TYPE IN VARCHAR2 := NULL,
274: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
275: P_SCHEDULE_MATERIAL_ID_TBL IN NUMBER_TABLE_TYPE,
276: X_MTL_AVL_SCHLD_TBL OUT NOCOPY AHL_MM_MTL_MGT_PVT.MTL_AVL_SCHLD_TBL,
277: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
278: X_MSG_COUNT OUT NOCOPY NUMBER,
279: X_MSG_DATA OUT NOCOPY VARCHAR2 )
280: IS

Line 438: X_MTL_AVL_SCHLD_TBL OUT NOCOPY AHL_MM_MTL_MGT_PVT.MTL_AVL_SCHLD_TBL,

434: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
435: P_MODULE_TYPE IN VARCHAR2 := NULL,
436: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
437: P_VISIT_ID IN NUMBER,
438: X_MTL_AVL_SCHLD_TBL OUT NOCOPY AHL_MM_MTL_MGT_PVT.MTL_AVL_SCHLD_TBL,
439: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
440: X_MSG_COUNT OUT NOCOPY NUMBER,
441: X_MSG_DATA OUT NOCOPY VARCHAR2 )
442: IS

Line 1199: l_p_sch_mtl_id_tbl AHL_MM_MTL_MGT_PVT.number_table_type;

1195:
1196: -- Define local variables
1197: l_planning_window NUMBER;
1198: l_demand_rec get_demand_details%ROWTYPE;
1199: l_p_sch_mtl_id_tbl AHL_MM_MTL_MGT_PVT.number_table_type;
1200: l_wo_name_tbl varchar2_table_type;
1201: l_x_mtl_avl_schld_tbl AHL_MM_MTL_MGT_PVT.mtl_avl_schld_tbl;
1202: i NUMBER := 1;
1203: k NUMBER := 1;

Line 1201: l_x_mtl_avl_schld_tbl AHL_MM_MTL_MGT_PVT.mtl_avl_schld_tbl;

1197: l_planning_window NUMBER;
1198: l_demand_rec get_demand_details%ROWTYPE;
1199: l_p_sch_mtl_id_tbl AHL_MM_MTL_MGT_PVT.number_table_type;
1200: l_wo_name_tbl varchar2_table_type;
1201: l_x_mtl_avl_schld_tbl AHL_MM_MTL_MGT_PVT.mtl_avl_schld_tbl;
1202: i NUMBER := 1;
1203: k NUMBER := 1;
1204: l_bucket_size NUMBER := 1000;
1205:

Line 1270: AHL_MM_MTL_MGT_PVT.SCHEDULE_MATERIALS(p_api_version => 1.0

1266: IF (i = l_bucket_size) THEN
1267: --Call API to schedule material requirement for the same
1268: FND_FILE.put_line(FND_FILE.log, 'Calling schedule_material API for a set of ' || l_bucket_size || ' demands');
1269:
1270: AHL_MM_MTL_MGT_PVT.SCHEDULE_MATERIALS(p_api_version => 1.0
1271: , p_init_msg_list => FND_API.G_FALSE
1272: , p_commit => FND_API.G_FALSE
1273: , p_module_type => NULL
1274: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 1331: AHL_MM_MTL_MGT_PVT.SCHEDULE_MATERIALS(p_api_version => 1.0

1327:
1328: --Call API to schedule material requirement for the same
1329: FND_FILE.put_line(FND_FILE.log, 'Calling schedule_material API for last set of demands');
1330:
1331: AHL_MM_MTL_MGT_PVT.SCHEDULE_MATERIALS(p_api_version => 1.0
1332: , p_init_msg_list => FND_API.G_FALSE
1333: , p_commit => FND_API.G_FALSE
1334: , p_module_type => NULL
1335: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 1459: p_asm_id_tab IN AHL_MM_MTL_MGT_PVT.number_table_type,

1455: p_api_version IN NUMBER := 1.0,
1456: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1457: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1458: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1459: p_asm_id_tab IN AHL_MM_MTL_MGT_PVT.number_table_type,
1460: x_return_status OUT NOCOPY VARCHAR2,
1461: x_msg_count OUT NOCOPY NUMBER,
1462: x_msg_data OUT NOCOPY VARCHAR2
1463: )

Line 1745: L_API_NAME CONSTANT VARCHAR2(80) := 'AHL_MM_MTL_MGT_PVT.CREATE_INTERNAL_SALES_ORDER';

1741: X_RESERVATION_ID OUT NOCOPY NUMBER )
1742:
1743: IS
1744:
1745: L_API_NAME CONSTANT VARCHAR2(80) := 'AHL_MM_MTL_MGT_PVT.CREATE_INTERNAL_SALES_ORDER';
1746: L_FM_SERIAL_NUM_TBL OAF_VARCHAR2_TABLE_100 := OAF_VARCHAR2_TABLE_100();
1747: L_TO_SERIAL_NUM_TBL OAF_VARCHAR2_TABLE_100 := OAF_VARCHAR2_TABLE_100();
1748: L_QUANTITY_TBL OAF_NUMBER_TABLE := OAF_NUMBER_TABLE();
1749: L_SOURCE_ORG_TBL OAF_NUMBER_TABLE := OAF_NUMBER_TABLE();

Line 1996: l_api_name CONSTANT VARCHAR2(80) := 'AHL_MM_MTL_MGT_PVT.CREATE_INTERNAL_ORDER';

1992: x_dev_phase VARCHAR2(15);
1993: x_dev_status VARCHAR2(10);
1994: x_message VARCHAR2(2000);
1995: l_api_version CONSTANT NUMBER := 1.0;
1996: l_api_name CONSTANT VARCHAR2(80) := 'AHL_MM_MTL_MGT_PVT.CREATE_INTERNAL_ORDER';
1997: l_user_id NUMBER := fnd_global.user_id;
1998: l_person_id NUMBER;
1999: L_CURRENCY_CODE varchar2(15);
2000: L_PRODUCT_TXN_ID NUMBER := AHL_MM_PROD_TXN_ID_S.nextval;

Line 2694: l_api_name CONSTANT VARCHAR2(80) := 'AHL_MM_MTL_MGT_PVT.CREATE_RESERVATION_IR';

2690: L_MSG_COUNT NUMBER;
2691: L_MSG_INDEX_OUT NUMBER;
2692: L_MSG_DATA VARCHAR2(2000);
2693:
2694: l_api_name CONSTANT VARCHAR2(80) := 'AHL_MM_MTL_MGT_PVT.CREATE_RESERVATION_IR';
2695:
2696: BEGIN
2697:
2698: L_RSV_REC.DEMAND_SOURCE_LINE_DETAIL := P_SCHEDULED_MATERIAL_ID; --

Line 2797: L_API_NAME CONSTANT VARCHAR2(80) := 'AHL_MM_MTL_MGT_PVT.PICK_RELEASE';

2793: X_RETURN_STATUS OUT NOCOPY VARCHAR2 )
2794:
2795: IS
2796:
2797: L_API_NAME CONSTANT VARCHAR2(80) := 'AHL_MM_MTL_MGT_PVT.PICK_RELEASE';
2798: L_SOURCE_SUB_INV_TBL OAF_VARCHAR2_TABLE_100 := OAF_VARCHAR2_TABLE_100();
2799: L_SOURCE_LOCATOR_TBL OAF_NUMBER_TABLE := OAF_NUMBER_TABLE();
2800: L_FM_SERIAL_NUM_TBL OAF_VARCHAR2_TABLE_100 := OAF_VARCHAR2_TABLE_100();
2801: L_TO_SERIAL_NUM_TBL OAF_VARCHAR2_TABLE_100 := OAF_VARCHAR2_TABLE_100();

Line 2985: L_API_NAME varchar2(80) := 'AHL_MM_MTL_MGT_PVT.PICK_RELEASE_CONFIRM';

2981: X_MSG_DATA OUT NOCOPY VARCHAR2,
2982: X_RETURN_STATUS OUT NOCOPY VARCHAR2 )
2983: IS
2984: l_api_version CONSTANT NUMBER := 1.0;
2985: L_API_NAME varchar2(80) := 'AHL_MM_MTL_MGT_PVT.PICK_RELEASE_CONFIRM';
2986: L_PICKING_RULE_ID NUMBER DEFAULT NULL;
2987: l_batch_rec WSH_PICKING_BATCHES_PUB.batch_info_rec;
2988: l_order_type_id NUMBER;
2989: l_customer_id NUMBER;

Line 4098: l_debug_module VARCHAR2(1000) := 'ahl.plsql.AHL_MM_MTL_MGT_PVT.Perform_Inter_Org_Transfer';

4094: )
4095: IS
4096:
4097: -- Logging Variable
4098: l_debug_module VARCHAR2(1000) := 'ahl.plsql.AHL_MM_MTL_MGT_PVT.Perform_Inter_Org_Transfer';
4099: l_msg_index_out NUMBER;
4100:
4101: -- Local Variables
4102: l_shipping_network_code MTL_SHIPPING_NETWORK_VIEW.intransit_type%TYPE;

Line 4430: l_debug_module VARCHAR2(1000) := 'ahl.plsql.AHL_MM_MTL_MGT_PVT.Perform_Inter_Org_Transfer_Inv';

4426: l_api_version CONSTANT NUMBER := 1.0;
4427: l_api_name CONSTANT VARCHAR2(30) := 'Perform_Inter_Org_Transfer_Inv';
4428:
4429: --Logging
4430: l_debug_module VARCHAR2(1000) := 'ahl.plsql.AHL_MM_MTL_MGT_PVT.Perform_Inter_Org_Transfer_Inv';
4431:
4432: --local variables
4433: l_error BOOLEAN;
4434: l_transaction_header_id NUMBER;

Line 4825: l_debug_module VARCHAR2(1000) := 'ahl.plsql.AHL_MM_MTL_MGT_PVT.Insert_Material';

4821: l_source_code VARCHAR2(240):= 'AHL';
4822: l_ship_id_present VARCHAR2(1);
4823:
4824: --Log
4825: l_debug_module VARCHAR2(1000) := 'ahl.plsql.AHL_MM_MTL_MGT_PVT.Insert_Material';
4826: BEGIN
4827: l_process_flag := '1';
4828: x_return_status := FND_API.G_RET_STS_SUCCESS;
4829: --log

Line 5144: l_debug_module VARCHAR2(1000) := 'ahl.plsql.AHL_MM_MTL_MGT_PVT.Validate_Record';

5140: x_return_status OUT NOCOPY VARCHAR2,
5141: x_msg_count OUT NOCOPY NUMBER,
5142: x_msg_data OUT NOCOPY VARCHAR2 )
5143: IS
5144: l_debug_module VARCHAR2(1000) := 'ahl.plsql.AHL_MM_MTL_MGT_PVT.Validate_Record';
5145: -- Cursor Declaration
5146: -- Item id validation and selecting item attributes in destination
5147: CURSOR ITEM_VALID_CUR_DEST (p_org_id NUMBER, p_item NUMBER)
5148: IS

Line 5495: -- p_demand_Record IN AHL_MM_MTL_MGT_PVT.BG_Demand_Rec

5491: -- build goal requirements.
5492: --
5493: -- IN Parameters :
5494: -- P_MODULE_TYPE IN VARCHAR2 -- Can be 'INVENTORY', 'ER', 'WO2WO', 'CNB'
5495: -- p_demand_Record IN AHL_MM_MTL_MGT_PVT.BG_Demand_Rec
5496: --
5497: PROCEDURE FILTER_INSTANCES_MATCHING_BG(
5498: p_api_version IN NUMBER,
5499: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

Line 5502: p_demand_Record IN AHL_MM_MTL_MGT_PVT.BG_Demand_Rec,

5498: p_api_version IN NUMBER,
5499: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
5500: p_commit IN VARCHAR2 := FND_API.G_FALSE,
5501: p_module_type IN VARCHAR2,
5502: p_demand_Record IN AHL_MM_MTL_MGT_PVT.BG_Demand_Rec,
5503: x_return_status OUT NOCOPY VARCHAR2,
5504: x_msg_count OUT NOCOPY NUMBER,
5505: x_msg_data OUT NOCOPY VARCHAR2
5506: )

Line 6265: -- X_Inv_Mtl_Avl_Tbl AHL_MM_MTL_MGT_PVT.Inv_Mtl_Avl_Tbl

6261: -- P_INVENTORY_ITEM_ID IN NUMBER
6262: -- P_ORG_ID IN NUMBER
6263: --
6264: -- Return:
6265: -- X_Inv_Mtl_Avl_Tbl AHL_MM_MTL_MGT_PVT.Inv_Mtl_Avl_Tbl
6266: --
6267: PROCEDURE GET_AVAILABLE_QUANTITY(
6268: P_API_VERSION IN NUMBER,
6269: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

Line 6275: X_Inv_Mtl_Avl_Tbl OUT NOCOPY AHL_MM_MTL_MGT_PVT.Inv_Mtl_Avl_Tbl,

6271: P_MODULE_TYPE IN VARCHAR2 := NULL,
6272: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
6273: P_ORG_ID NUMBER,
6274: P_INV_ITEM_ID NUMBER,
6275: X_Inv_Mtl_Avl_Tbl OUT NOCOPY AHL_MM_MTL_MGT_PVT.Inv_Mtl_Avl_Tbl,
6276: x_return_status OUT NOCOPY VARCHAR2,
6277: X_MSG_COUNT OUT NOCOPY NUMBER,
6278: x_msg_data OUT NOCOPY VARCHAR2)
6279: IS

Line 6427: P_VISIT_IDS AHL_MM_MTL_MGT_PVT.visit_ids_Tbl,

6423: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
6424: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
6425: P_MODULE_TYPE IN VARCHAR2 := NULL,
6426: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
6427: P_VISIT_IDS AHL_MM_MTL_MGT_PVT.visit_ids_Tbl,
6428: X_MTL_AVL_SCHLD_TBL OUT NOCOPY AHL_MM_MTL_MGT_PVT.MTL_AVL_SCHLD_TBL,
6429: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
6430: X_MSG_COUNT OUT NOCOPY NUMBER,
6431: X_MSG_DATA OUT NOCOPY VARCHAR2 )

Line 6428: X_MTL_AVL_SCHLD_TBL OUT NOCOPY AHL_MM_MTL_MGT_PVT.MTL_AVL_SCHLD_TBL,

6424: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
6425: P_MODULE_TYPE IN VARCHAR2 := NULL,
6426: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
6427: P_VISIT_IDS AHL_MM_MTL_MGT_PVT.visit_ids_Tbl,
6428: X_MTL_AVL_SCHLD_TBL OUT NOCOPY AHL_MM_MTL_MGT_PVT.MTL_AVL_SCHLD_TBL,
6429: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
6430: X_MSG_COUNT OUT NOCOPY NUMBER,
6431: X_MSG_DATA OUT NOCOPY VARCHAR2 )
6432: IS

Line 6508: END AHL_MM_MTL_MGT_PVT;

6504: END SCHED_ALL_VST_MTLS;
6505: -- Kasridha: Changes for Marshalling Phase II Ends
6506:
6507:
6508: END AHL_MM_MTL_MGT_PVT;