DBA Data[Home] [Help]

APPS.WMS_CATCH_WEIGHT_PVT dependencies on WSH_INTERFACE_EXT_GRP

Line 581: l_shipping_attr WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;

577: l_api_version CONSTANT NUMBER := 1.0;
578: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
579: l_progress VARCHAR2(10) := '0';
580:
581: l_shipping_attr WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
582: l_shipping_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
583: l_shipping_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
584:
585: l_msg_details VARCHAR2(3000);

Line 582: l_shipping_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;

578: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
579: l_progress VARCHAR2(10) := '0';
580:
581: l_shipping_attr WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
582: l_shipping_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
583: l_shipping_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
584:
585: l_msg_details VARCHAR2(3000);
586: l_pricing_ind VARCHAR2(30);

Line 583: l_shipping_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;

579: l_progress VARCHAR2(10) := '0';
580:
581: l_shipping_attr WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
582: l_shipping_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
583: l_shipping_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
584:
585: l_msg_details VARCHAR2(3000);
586: l_pricing_ind VARCHAR2(30);
587: l_tolerance NUMBER;

Line 725: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail (

721:
722: l_shipping_in_rec.caller := 'WMS';
723: l_shipping_in_rec.action_code := 'UPDATE';
724:
725: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail (
726: p_api_version_number => 1.0
727: , p_init_msg_list => fnd_api.g_false
728: , p_commit => fnd_api.g_false
729: , x_return_status => x_return_status

Line 817: l_shipping_attr WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;

813: AND wdd.inventory_item_id = p_inventory_item_id
814: AND NVL(wdd.revision, '@') = NVL(p_revision, '@')
815: AND NVL(wdd.lot_number, '@') = NVL(p_lot_number, '@');
816:
817: l_shipping_attr WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
818: l_shipping_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
819: l_shipping_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
820: l_msg_details VARCHAR2(3000);
821: l_attr_counter NUMBER := 1;

Line 818: l_shipping_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;

814: AND NVL(wdd.revision, '@') = NVL(p_revision, '@')
815: AND NVL(wdd.lot_number, '@') = NVL(p_lot_number, '@');
816:
817: l_shipping_attr WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
818: l_shipping_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
819: l_shipping_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
820: l_msg_details VARCHAR2(3000);
821: l_attr_counter NUMBER := 1;
822: l_del_det_id NUMBER;

Line 819: l_shipping_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;

815: AND NVL(wdd.lot_number, '@') = NVL(p_lot_number, '@');
816:
817: l_shipping_attr WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
818: l_shipping_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
819: l_shipping_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
820: l_msg_details VARCHAR2(3000);
821: l_attr_counter NUMBER := 1;
822: l_del_det_id NUMBER;
823: l_line_quantity NUMBER;

Line 923: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail (

919: IF (l_debug = 1) THEN
920: print_debug('Calling Create_Update_Delivery_Detail count='||l_shipping_attr.count, 9);
921: END IF;
922:
923: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail (
924: p_api_version_number => 1.0
925: , p_init_msg_list => fnd_api.g_false
926: , p_commit => fnd_api.g_false
927: , x_return_status => x_return_status

Line 1578: l_shipping_attr WSH_INTERFACE_EXT_GRP.delivery_details_attr_tbl_type;

1574: l_api_return_status VARCHAR2(1);
1575: l_wdd_qty_incr NUMBER;
1576: l_wdd_qty_decr NUMBER;
1577:
1578: l_shipping_attr WSH_INTERFACE_EXT_GRP.delivery_details_attr_tbl_type;
1579: l_shipping_in_rec WSH_INTERFACE_EXT_GRP.detailinrectype;
1580: l_shipping_out_rec WSH_INTERFACE_EXT_GRP.detailoutrectype;
1581: l_wdd_index NUMBER;
1582: l_msg_details VARCHAR2(3000);

Line 1579: l_shipping_in_rec WSH_INTERFACE_EXT_GRP.detailinrectype;

1575: l_wdd_qty_incr NUMBER;
1576: l_wdd_qty_decr NUMBER;
1577:
1578: l_shipping_attr WSH_INTERFACE_EXT_GRP.delivery_details_attr_tbl_type;
1579: l_shipping_in_rec WSH_INTERFACE_EXT_GRP.detailinrectype;
1580: l_shipping_out_rec WSH_INTERFACE_EXT_GRP.detailoutrectype;
1581: l_wdd_index NUMBER;
1582: l_msg_details VARCHAR2(3000);
1583:

Line 1580: l_shipping_out_rec WSH_INTERFACE_EXT_GRP.detailoutrectype;

1576: l_wdd_qty_decr NUMBER;
1577:
1578: l_shipping_attr WSH_INTERFACE_EXT_GRP.delivery_details_attr_tbl_type;
1579: l_shipping_in_rec WSH_INTERFACE_EXT_GRP.detailinrectype;
1580: l_shipping_out_rec WSH_INTERFACE_EXT_GRP.detailoutrectype;
1581: l_wdd_index NUMBER;
1582: l_msg_details VARCHAR2(3000);
1583:
1584: l_subinv_code VARCHAR2(10);

Line 2227: WSH_INTERFACE_EXT_GRP.create_update_delivery_detail(

2223: IF (l_debug = 1) THEN
2224: print_debug('Calling create_update_delivery_detail count='||l_shipping_attr.count,4);
2225: END IF;
2226:
2227: WSH_INTERFACE_EXT_GRP.create_update_delivery_detail(
2228: p_api_version_number => 1.0
2229: , p_init_msg_list => fnd_api.g_false
2230: , p_commit => fnd_api.g_false
2231: , x_return_status => x_return_status