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 176: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;

172: --Bug 9118049, Request_number column in MTRH is defined to accept 30 characters.
173: --Stretching the variable from 25 char to 30 chars.
174: l_request_number MTL_TXN_REQUEST_HEADERS.request_number%type := NULL;
175: l_return_status Varchar2(1) := FND_API.G_RET_STS_SUCCESS;
176: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
177: l_line_status NUMBER := 0;
178:
179: BEGIN
180:

Line 442: l_old_trolin_tbl INV_Move_Order_PUB.Trolin_tbl_Type;

438: l_Line_Id Number := p_line_Id;
439: l_line_status Number;
440: l_request_number Varchar2(25) := NULL;
441: l_return_status Varchar2(1) := FND_API.G_RET_STS_SUCCESS;
442: l_old_trolin_tbl INV_Move_Order_PUB.Trolin_tbl_Type;
443: l_new_trolin_tbl INV_Move_Order_PUB.Trolin_tbl_Type;
444: l_x_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
445: l_x_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
446: l_old_trolin_rec INV_Move_Order_PUB.Trolin_rec_Type;

Line 443: l_new_trolin_tbl INV_Move_Order_PUB.Trolin_tbl_Type;

439: l_line_status Number;
440: l_request_number Varchar2(25) := NULL;
441: l_return_status Varchar2(1) := FND_API.G_RET_STS_SUCCESS;
442: l_old_trolin_tbl INV_Move_Order_PUB.Trolin_tbl_Type;
443: l_new_trolin_tbl INV_Move_Order_PUB.Trolin_tbl_Type;
444: l_x_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
445: l_x_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
446: l_old_trolin_rec INV_Move_Order_PUB.Trolin_rec_Type;
447: l_msg_count Number;

Line 444: l_x_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;

440: l_request_number Varchar2(25) := NULL;
441: l_return_status Varchar2(1) := FND_API.G_RET_STS_SUCCESS;
442: l_old_trolin_tbl INV_Move_Order_PUB.Trolin_tbl_Type;
443: l_new_trolin_tbl INV_Move_Order_PUB.Trolin_tbl_Type;
444: l_x_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
445: l_x_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
446: l_old_trolin_rec INV_Move_Order_PUB.Trolin_rec_Type;
447: l_msg_count Number;
448: l_msg_data Varchar2(100);

Line 445: l_x_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;

441: l_return_status Varchar2(1) := FND_API.G_RET_STS_SUCCESS;
442: l_old_trolin_tbl INV_Move_Order_PUB.Trolin_tbl_Type;
443: l_new_trolin_tbl INV_Move_Order_PUB.Trolin_tbl_Type;
444: l_x_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
445: l_x_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
446: l_old_trolin_rec INV_Move_Order_PUB.Trolin_rec_Type;
447: l_msg_count Number;
448: l_msg_data Varchar2(100);
449: l_qty_del Number;

Line 446: l_old_trolin_rec INV_Move_Order_PUB.Trolin_rec_Type;

442: l_old_trolin_tbl INV_Move_Order_PUB.Trolin_tbl_Type;
443: l_new_trolin_tbl INV_Move_Order_PUB.Trolin_tbl_Type;
444: l_x_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
445: l_x_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
446: l_old_trolin_rec INV_Move_Order_PUB.Trolin_rec_Type;
447: l_msg_count Number;
448: l_msg_data Varchar2(100);
449: l_qty_del Number;
450: l_mo_type Number;