DBA Data[Home] [Help]

APPS.INV_MO_ADMIN_PUB dependencies on INV_MOVE_ORDER_PUB

Line 31: l_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;

27:
28: l_api_version CONSTANT NUMBER := 1.0;
29: l_api_name CONSTANT VARCHAR2(30):= 'Cancel_Order';
30: l_return_status Varchar2(1) := FND_API.G_RET_STS_SUCCESS;
31: l_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
32: l_trolin_rec INV_Move_Order_PUB.Trolin_Rec_Type;
33: l_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
34: l_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
35: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;

Line 32: l_trolin_rec INV_Move_Order_PUB.Trolin_Rec_Type;

28: l_api_version CONSTANT NUMBER := 1.0;
29: l_api_name CONSTANT VARCHAR2(30):= 'Cancel_Order';
30: l_return_status Varchar2(1) := FND_API.G_RET_STS_SUCCESS;
31: l_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
32: l_trolin_rec INV_Move_Order_PUB.Trolin_Rec_Type;
33: l_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
34: l_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
35: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
36: l_msg_count Number;

Line 33: l_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;

29: l_api_name CONSTANT VARCHAR2(30):= 'Cancel_Order';
30: l_return_status Varchar2(1) := FND_API.G_RET_STS_SUCCESS;
31: l_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
32: l_trolin_rec INV_Move_Order_PUB.Trolin_Rec_Type;
33: l_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
34: l_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
35: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
36: l_msg_count Number;
37: l_msg_data Varchar2(100);

Line 34: l_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;

30: l_return_status Varchar2(1) := FND_API.G_RET_STS_SUCCESS;
31: l_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
32: l_trolin_rec INV_Move_Order_PUB.Trolin_Rec_Type;
33: l_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
34: l_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
35: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
36: l_msg_count Number;
37: l_msg_data Varchar2(100);
38: l_header_id Number := p_header_Id;

Line 35: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;

31: l_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
32: l_trolin_rec INV_Move_Order_PUB.Trolin_Rec_Type;
33: l_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
34: l_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
35: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
36: l_msg_count Number;
37: l_msg_data Varchar2(100);
38: l_header_id Number := p_header_Id;
39:

Line 56: INV_Move_Order_Pub.Get_Move_Order(

52: FND_MSG_PUB.initialize;
53: End If;
54:
55: -- API Body
56: INV_Move_Order_Pub.Get_Move_Order(
57: p_api_version_number => 1.0,
58: p_init_msg_list => FND_API.G_TRUE,
59: x_return_status => l_return_status,
60: x_msg_count => l_msg_count,

Line 171: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;

167: l_header_id Number := p_header_id;
168: l_hdr_status Number;
169: l_request_number Varchar2(25) := NULL;
170: l_return_status Varchar2(1) := FND_API.G_RET_STS_SUCCESS;
171: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
172: l_line_status NUMBER := 0;
173:
174: BEGIN
175:

Line 432: l_old_trolin_tbl INV_Move_Order_PUB.Trolin_tbl_Type;

428: l_Line_Id Number := p_line_Id;
429: l_line_status Number;
430: l_request_number Varchar2(25) := NULL;
431: l_return_status Varchar2(1) := FND_API.G_RET_STS_SUCCESS;
432: l_old_trolin_tbl INV_Move_Order_PUB.Trolin_tbl_Type;
433: l_new_trolin_tbl INV_Move_Order_PUB.Trolin_tbl_Type;
434: l_x_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
435: l_x_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
436: l_old_trolin_rec INV_Move_Order_PUB.Trolin_rec_Type;

Line 433: l_new_trolin_tbl INV_Move_Order_PUB.Trolin_tbl_Type;

429: l_line_status Number;
430: l_request_number Varchar2(25) := NULL;
431: l_return_status Varchar2(1) := FND_API.G_RET_STS_SUCCESS;
432: l_old_trolin_tbl INV_Move_Order_PUB.Trolin_tbl_Type;
433: l_new_trolin_tbl INV_Move_Order_PUB.Trolin_tbl_Type;
434: l_x_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
435: l_x_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
436: l_old_trolin_rec INV_Move_Order_PUB.Trolin_rec_Type;
437: l_msg_count Number;

Line 434: l_x_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;

430: l_request_number Varchar2(25) := NULL;
431: l_return_status Varchar2(1) := FND_API.G_RET_STS_SUCCESS;
432: l_old_trolin_tbl INV_Move_Order_PUB.Trolin_tbl_Type;
433: l_new_trolin_tbl INV_Move_Order_PUB.Trolin_tbl_Type;
434: l_x_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
435: l_x_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
436: l_old_trolin_rec INV_Move_Order_PUB.Trolin_rec_Type;
437: l_msg_count Number;
438: l_msg_data Varchar2(100);

Line 435: l_x_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;

431: l_return_status Varchar2(1) := FND_API.G_RET_STS_SUCCESS;
432: l_old_trolin_tbl INV_Move_Order_PUB.Trolin_tbl_Type;
433: l_new_trolin_tbl INV_Move_Order_PUB.Trolin_tbl_Type;
434: l_x_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
435: l_x_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
436: l_old_trolin_rec INV_Move_Order_PUB.Trolin_rec_Type;
437: l_msg_count Number;
438: l_msg_data Varchar2(100);
439: l_qty_del Number;

Line 436: l_old_trolin_rec INV_Move_Order_PUB.Trolin_rec_Type;

432: l_old_trolin_tbl INV_Move_Order_PUB.Trolin_tbl_Type;
433: l_new_trolin_tbl INV_Move_Order_PUB.Trolin_tbl_Type;
434: l_x_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
435: l_x_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
436: l_old_trolin_rec INV_Move_Order_PUB.Trolin_rec_Type;
437: l_msg_count Number;
438: l_msg_data Varchar2(100);
439: l_qty_del Number;
440: l_mo_type Number;