DBA Data[Home] [Help]

APPS.INV_MOVE_ORDER_PUB dependencies on INV_MOVE_ORDER_PUB

Line 1: PACKAGE BODY INV_Move_Order_PUB AS

1: PACKAGE BODY INV_Move_Order_PUB AS
2: /* $Header: INVPTROB.pls 120.5.12010000.2 2008/10/20 13:21:25 mporecha ship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_Move_Order_PUB';

2: /* $Header: INVPTROB.pls 120.5.12010000.2 2008/10/20 13:21:25 mporecha ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_Move_Order_PUB';
7:
8: g_inventory_item_id NUMBER := NULL;
9: g_primary_uom_code VARCHAR2(3) := NULL;
10: g_restrict_subinventories_code NUMBER;

Line 888: ,'INV_Move_Order_PUB.Create_Move_Order_Lines');

884: l_item_loc_ctrl := INV_CACHE.item_rec.location_control_code;
885: EXCEPTION
886: WHEN OTHERS THEN
887: print_debug('Exception retrieving item locator control from cache ' || sqlerrm
888: ,'INV_Move_Order_PUB.Create_Move_Order_Lines');
889: l_item_loc_ctrl := 0;
890: END;
891: IF l_item_loc_ctrl IS NULL OR l_item_loc_ctrl = 0 THEN
892: OPEN get_item_loc_ctrl (x_trolin_tbl(l_index).organization_id

Line 1559: l_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;

1555: IS
1556: l_api_version_number CONSTANT NUMBER := 1.0;
1557: l_api_name CONSTANT VARCHAR2(30):= 'Get_Move_Order';
1558: l_header_id NUMBER := p_header_id;
1559: l_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
1560: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
1561: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1562: BEGIN
1563:

Line 1560: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;

1556: l_api_version_number CONSTANT NUMBER := 1.0;
1557: l_api_name CONSTANT VARCHAR2(30):= 'Get_Move_Order';
1558: l_header_id NUMBER := p_header_id;
1559: l_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
1560: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
1561: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1562: BEGIN
1563:
1564: -- Standard call to check for call compatibility

Line 1955: , p_carton_grouping_tbl IN inv_move_order_pub.num_tbl_type

1951: );
1952: END Process_Move_Order_Line;
1953:
1954: PROCEDURE stamp_cart_id ( p_validation_level IN NUMBER
1955: , p_carton_grouping_tbl IN inv_move_order_pub.num_tbl_type
1956: , p_move_order_line_tbl IN inv_move_order_pub.num_tbl_type
1957: ) IS
1958: BEGIN
1959: FORALL i in 1..p_move_order_line_tbl.count

Line 1956: , p_move_order_line_tbl IN inv_move_order_pub.num_tbl_type

1952: END Process_Move_Order_Line;
1953:
1954: PROCEDURE stamp_cart_id ( p_validation_level IN NUMBER
1955: , p_carton_grouping_tbl IN inv_move_order_pub.num_tbl_type
1956: , p_move_order_line_tbl IN inv_move_order_pub.num_tbl_type
1957: ) IS
1958: BEGIN
1959: FORALL i in 1..p_move_order_line_tbl.count
1960: UPDATE mtl_txn_request_lines SET

Line 1966: END INV_Move_Order_PUB;

1962: WHERE line_id = p_move_order_line_tbl(i);
1963: END stamp_cart_id;
1964:
1965:
1966: END INV_Move_Order_PUB;