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.

APPS.WMS_REPLENISHMENT_PVT dependencies on WSH_INTERFACE_EXT_GRP

Line 331: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;

327: IS
328:
329: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
330:
331: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
332: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
333: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
334:
335: l_msg_count NUMBER;

Line 332: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;

328:
329: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
330:
331: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
332: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
333: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
334:
335: l_msg_count NUMBER;
336: l_msg_data VARCHAR2(1000);

Line 333: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;

329: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
330:
331: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
332: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
333: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
334:
335: l_msg_count NUMBER;
336: l_msg_data VARCHAR2(1000);
337: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 364: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail

360: l_detail_info_tab(1).replenishment_status := p_repl_status ;
361: l_in_rec.caller := 'WMS_REP';
362: l_in_rec.action_code := 'UPDATE';
363:
364: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail
365: (p_api_version_number => 1.0,
366: p_init_msg_list => fnd_api.g_false,
367: p_commit => fnd_api.g_false,
368: x_return_status => l_return_status,

Line 455: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;

451:
452: l_deliv_detail_id_tab num_tab;
453:
454: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
455: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
456: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
457: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
458: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
459:

Line 456: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;

452: l_deliv_detail_id_tab num_tab;
453:
454: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
455: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
456: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
457: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
458: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
459:
460: l_msg_count NUMBER;

Line 457: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;

453:
454: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
455: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
456: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
457: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
458: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
459:
460: l_msg_count NUMBER;
461: l_msg_data VARCHAR2(1000);

Line 530: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail

526: l_in_rec := NULL;
527: l_in_rec.caller := 'WMS_REP';
528: l_in_rec.action_code := 'UPDATE';
529:
530: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail
531: (p_api_version_number => 1.0,
532: p_init_msg_list => fnd_api.g_false,
533: p_commit => fnd_api.g_false,
534: x_return_status => l_return_status,

Line 579: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;

575: IS
576:
577: l_deliv_detail_id_tab num_tab;
578: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
579: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
580: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
581: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
582:
583: l_item_id NUMBER;

Line 580: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;

576:
577: l_deliv_detail_id_tab num_tab;
578: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
579: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
580: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
581: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
582:
583: l_item_id NUMBER;
584: l_org_id NUMBER;

Line 581: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;

577: l_deliv_detail_id_tab num_tab;
578: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
579: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
580: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
581: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
582:
583: l_item_id NUMBER;
584: l_org_id NUMBER;
585:

Line 639: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail

635: l_in_rec := NULL;
636: l_in_rec.caller := 'WMS_REP';
637: l_in_rec.action_code := 'UPDATE';
638:
639: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail
640: (p_api_version_number => 1.0,
641: p_init_msg_list => fnd_api.g_false,
642: p_commit => fnd_api.g_false,
643: x_return_status => l_return_status,

Line 789: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;

785: l_expected_ship_date DATE;
786: l_repl_to_subinventory_code VARCHAR2(10);
787: l_repl_status VARCHAR2(1);
788:
789: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
790: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
791:
792: l_detail_id_tab WSH_UTIL_CORE.id_tab_type;
793: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;

Line 790: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;

786: l_repl_to_subinventory_code VARCHAR2(10);
787: l_repl_status VARCHAR2(1);
788:
789: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
790: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
791:
792: l_detail_id_tab WSH_UTIL_CORE.id_tab_type;
793: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
794: l_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;

Line 1398: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail

1394: l_in_rec := NULL;
1395: l_in_rec.caller := 'WMS_REP';
1396: l_in_rec.action_code := 'UPDATE';
1397:
1398: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail
1399: (p_api_version_number => 1.0,
1400: p_init_msg_list => fnd_api.g_false,
1401: p_commit => fnd_api.g_false,
1402: x_return_status => l_return_status,

Line 3307: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;

3303: l_rsv_id NUMBER;
3304: l_error_code NUMBER;
3305: l_mo_uom_code VARCHAR2(3);
3306:
3307: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
3308: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
3309: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
3310:
3311: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;

Line 3308: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;

3304: l_error_code NUMBER;
3305: l_mo_uom_code VARCHAR2(3);
3306:
3307: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
3308: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
3309: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
3310:
3311: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;
3312: l_rsv_temp_rec_2 inv_reservation_global.mtl_reservation_rec_type;

Line 3309: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;

3305: l_mo_uom_code VARCHAR2(3);
3306:
3307: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
3308: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
3309: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
3310:
3311: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;
3312: l_rsv_temp_rec_2 inv_reservation_global.mtl_reservation_rec_type;
3313: l_line_num NUMBER ;

Line 4508: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;

4504:
4505: l_repl_level NUMBER;
4506: l_repl_type NUMBER;
4507:
4508: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
4509: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
4510: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
4511:
4512: -- For bulk upload in the WRD table

Line 4509: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;

4505: l_repl_level NUMBER;
4506: l_repl_type NUMBER;
4507:
4508: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
4509: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
4510: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
4511:
4512: -- For bulk upload in the WRD table
4513: l_organization_id_tab num_tab;

Line 4510: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;

4506: l_repl_type NUMBER;
4507:
4508: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
4509: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
4510: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
4511:
4512: -- For bulk upload in the WRD table
4513: l_organization_id_tab num_tab;
4514: l_mo_header_id_tab num_tab;

Line 5080: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;

5076: l_prev_sub_code VARCHAR2(10);
5077: l_qty_tree_demand_line_id NUMBER;
5078:
5079: l_rsv_id_tb num_tab;
5080: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
5081: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
5082: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
5083:
5084: l_serial_number inv_reservation_global.serial_number_tbl_type;

Line 5081: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;

5077: l_qty_tree_demand_line_id NUMBER;
5078:
5079: l_rsv_id_tb num_tab;
5080: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
5081: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
5082: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
5083:
5084: l_serial_number inv_reservation_global.serial_number_tbl_type;
5085: l_to_serial_number inv_reservation_global.serial_number_tbl_type;

Line 5082: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;

5078:
5079: l_rsv_id_tb num_tab;
5080: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
5081: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
5082: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
5083:
5084: l_serial_number inv_reservation_global.serial_number_tbl_type;
5085: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
5086: l_quantity_reserved NUMBER;

Line 6666: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;

6662:
6663: l_return_value BOOLEAN;
6664: l_atr_ORG NUMBER;
6665:
6666: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
6667: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
6668: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
6669:
6670: l_pr_sub VARCHAR2(10);

Line 6667: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;

6663: l_return_value BOOLEAN;
6664: l_atr_ORG NUMBER;
6665:
6666: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
6667: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
6668: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
6669:
6670: l_pr_sub VARCHAR2(10);
6671:

Line 6668: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;

6664: l_atr_ORG NUMBER;
6665:
6666: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
6667: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
6668: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
6669:
6670: l_pr_sub VARCHAR2(10);
6671:
6672: -- BULK OPERATION: Table to store results from the open demand for replenishment