DBA Data[Home] [Help]

APPS.GMI_MOVE_ORDER_LINES_PUB dependencies on GMI_MOVE_ORDER_GLOBAL

Line 50: , p_mo_LINE_tbl IN GMI_Move_Order_GLOBAL.mo_line_tbl

46: p_api_version_number IN NUMBER
47: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
48: , p_validation_flag IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
49: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
50: , p_mo_LINE_tbl IN GMI_Move_Order_GLOBAL.mo_line_tbl
51: , x_mo_LINE_tbl OUT NOCOPY GMI_Move_Order_GLOBAL.mo_line_tbl
52: , x_return_status OUT NOCOPY VARCHAR2
53: , x_msg_count OUT NOCOPY NUMBER
54: , x_msg_data OUT NOCOPY VARCHAR2

Line 51: , x_mo_LINE_tbl OUT NOCOPY GMI_Move_Order_GLOBAL.mo_line_tbl

47: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
48: , p_validation_flag IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
49: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
50: , p_mo_LINE_tbl IN GMI_Move_Order_GLOBAL.mo_line_tbl
51: , x_mo_LINE_tbl OUT NOCOPY GMI_Move_Order_GLOBAL.mo_line_tbl
52: , x_return_status OUT NOCOPY VARCHAR2
53: , x_msg_count OUT NOCOPY NUMBER
54: , x_msg_data OUT NOCOPY VARCHAR2
55: )

Line 62: l_mo_line_rec GMI_MOVE_ORDER_GLOBAL.mo_line_rec;

58: l_api_version_number CONSTANT NUMBER := 1.0;
59: l_msg_count NUMBER :=0;
60: l_msg_data VARCHAR2(2000);
61: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
62: l_mo_line_rec GMI_MOVE_ORDER_GLOBAL.mo_line_rec;
63: l_mo_line_tbl GMI_MOVE_ORDER_GLOBAL.mo_line_tbl;
64:
65: CURSOR get_sales_order (V_line_id NUMBER) IS
66: select h.order_number

Line 63: l_mo_line_tbl GMI_MOVE_ORDER_GLOBAL.mo_line_tbl;

59: l_msg_count NUMBER :=0;
60: l_msg_data VARCHAR2(2000);
61: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
62: l_mo_line_rec GMI_MOVE_ORDER_GLOBAL.mo_line_rec;
63: l_mo_line_tbl GMI_MOVE_ORDER_GLOBAL.mo_line_tbl;
64:
65: CURSOR get_sales_order (V_line_id NUMBER) IS
66: select h.order_number
67: from oe_order_headers_all h