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 334: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;

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

Line 335: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;

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

Line 336: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;

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

Line 366: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail

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

Line 454: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;

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

Line 455: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;

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

Line 456: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;

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

Line 527: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail

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

Line 576: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;

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

Line 577: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;

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

Line 578: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;

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

Line 634: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail

630: l_in_rec := NULL;
631: l_in_rec.caller := 'WMS_REP';
632: l_in_rec.action_code := 'UPDATE';
633:
634: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail
635: (p_api_version_number => 1.0,
636: p_init_msg_list => fnd_api.g_false,
637: p_commit => fnd_api.g_false,
638: x_return_status => l_return_status,

Line 783: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;

779: l_expected_ship_date DATE;
780: l_repl_to_subinventory_code VARCHAR2(10);
781: l_repl_status VARCHAR2(1);
782:
783: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
784: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
785: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
786:
787: l_detail_id_tab WSH_UTIL_CORE.id_tab_type;

Line 784: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;

780: l_repl_to_subinventory_code VARCHAR2(10);
781: l_repl_status VARCHAR2(1);
782:
783: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
784: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
785: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
786:
787: l_detail_id_tab WSH_UTIL_CORE.id_tab_type;
788: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;

Line 785: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;

781: l_repl_status VARCHAR2(1);
782:
783: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
784: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
785: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
786:
787: l_detail_id_tab WSH_UTIL_CORE.id_tab_type;
788: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
789: l_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;

Line 1343: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail

1339: l_in_rec := NULL;
1340: l_in_rec.caller := 'WMS_REP';
1341: l_in_rec.action_code := 'UPDATE';
1342:
1343: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail
1344: (p_api_version_number => 1.0,
1345: p_init_msg_list => fnd_api.g_false,
1346: p_commit => fnd_api.g_false,
1347: x_return_status => l_return_status,

Line 3219: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;

3215: l_rsv_id NUMBER;
3216: l_error_code NUMBER;
3217: l_mo_uom_code VARCHAR2(3);
3218:
3219: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
3220: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
3221: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
3222:
3223: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;

Line 3220: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;

3216: l_error_code NUMBER;
3217: l_mo_uom_code VARCHAR2(3);
3218:
3219: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
3220: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
3221: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
3222:
3223: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;
3224: l_rsv_temp_rec_2 inv_reservation_global.mtl_reservation_rec_type;

Line 3221: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;

3217: l_mo_uom_code VARCHAR2(3);
3218:
3219: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
3220: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
3221: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
3222:
3223: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;
3224: l_rsv_temp_rec_2 inv_reservation_global.mtl_reservation_rec_type;
3225: l_line_num NUMBER ;

Line 4367: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;

4363:
4364: l_repl_level NUMBER;
4365: l_repl_type NUMBER;
4366:
4367: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
4368: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
4369: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
4370:
4371: -- For bulk upload in the WRD table

Line 4368: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;

4364: l_repl_level NUMBER;
4365: l_repl_type NUMBER;
4366:
4367: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
4368: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
4369: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
4370:
4371: -- For bulk upload in the WRD table
4372: l_organization_id_tab num_tab;

Line 4369: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;

4365: l_repl_type NUMBER;
4366:
4367: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
4368: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
4369: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
4370:
4371: -- For bulk upload in the WRD table
4372: l_organization_id_tab num_tab;
4373: l_mo_header_id_tab num_tab;

Line 4914: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;

4910: l_prev_sub_code VARCHAR2(10);
4911: l_qty_tree_demand_line_id NUMBER;
4912:
4913: l_rsv_id_tb num_tab;
4914: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
4915: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
4916: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
4917:
4918: l_serial_number inv_reservation_global.serial_number_tbl_type;

Line 4915: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;

4911: l_qty_tree_demand_line_id NUMBER;
4912:
4913: l_rsv_id_tb num_tab;
4914: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
4915: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
4916: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
4917:
4918: l_serial_number inv_reservation_global.serial_number_tbl_type;
4919: l_to_serial_number inv_reservation_global.serial_number_tbl_type;

Line 4916: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;

4912:
4913: l_rsv_id_tb num_tab;
4914: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
4915: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
4916: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
4917:
4918: l_serial_number inv_reservation_global.serial_number_tbl_type;
4919: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
4920: l_quantity_reserved NUMBER;

Line 6494: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;

6490:
6491: l_return_value BOOLEAN;
6492: l_atr_ORG NUMBER;
6493:
6494: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
6495: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
6496: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
6497:
6498: l_pr_sub VARCHAR2(10);

Line 6495: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;

6491: l_return_value BOOLEAN;
6492: l_atr_ORG NUMBER;
6493:
6494: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
6495: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
6496: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
6497:
6498: l_pr_sub VARCHAR2(10);
6499:

Line 6496: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;

6492: l_atr_ORG NUMBER;
6493:
6494: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
6495: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
6496: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
6497:
6498: l_pr_sub VARCHAR2(10);
6499:
6500: -- BULK OPERATION: Table to store results from the open demand for replenishment