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;
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;
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);
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;
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:
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,
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:
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;
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;
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);
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;
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;