DBA Data[Home] [Help]

APPS.CSP_TRANSACTIONS_PUB dependencies on INV_MOVE_ORDER_PUB

Line 139: l_trolin_tbl inv_move_order_pub.Trolin_Tbl_Type;

135: x_msg_count OUT NOCOPY number,
136: x_msg_data OUT NOCOPY varchar2) is
137:
138: l_header_id number;
139: l_trolin_tbl inv_move_order_pub.Trolin_Tbl_Type;
140: l_trolin_old_tbl inv_move_order_pub.trolin_tbl_type;
141: x_trolin_tbl inv_move_order_pub.trolin_tbl_type;
142:
143: cursor c_header_id is

Line 140: l_trolin_old_tbl inv_move_order_pub.trolin_tbl_type;

136: x_msg_data OUT NOCOPY varchar2) is
137:
138: l_header_id number;
139: l_trolin_tbl inv_move_order_pub.Trolin_Tbl_Type;
140: l_trolin_old_tbl inv_move_order_pub.trolin_tbl_type;
141: x_trolin_tbl inv_move_order_pub.trolin_tbl_type;
142:
143: cursor c_header_id is
144: select header_id

Line 141: x_trolin_tbl inv_move_order_pub.trolin_tbl_type;

137:
138: l_header_id number;
139: l_trolin_tbl inv_move_order_pub.Trolin_Tbl_Type;
140: l_trolin_old_tbl inv_move_order_pub.trolin_tbl_type;
141: x_trolin_tbl inv_move_order_pub.trolin_tbl_type;
142:
143: cursor c_header_id is
144: select header_id
145: from mtl_txn_request_lines

Line 158: inv_move_order_pub.process_move_order_line(

154: l_trolin_tbl(1).header_id := l_header_id;
155: l_trolin_tbl(1).line_id := p_line_id;
156: l_trolin_tbl(1).operation := inv_globals.g_opr_update;
157:
158: inv_move_order_pub.process_move_order_line(
159: p_api_version_number => 1.0
160: , x_return_status => x_return_status
161: , x_msg_count => x_msg_count
162: , x_msg_data => x_msg_data

Line 194: l_mohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;

190: ,x_return_status OUT NOCOPY VARCHAR2
191: ,x_msg_count OUT NOCOPY NUMBER
192: ,x_msg_data OUT NOCOPY VARCHAR2 ) IS
193:
194: l_mohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
195: l_mohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
196: l_header_id number;
197:
198: l_api_version_number CONSTANT NUMBER := 1.0;

Line 195: l_mohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;

191: ,x_msg_count OUT NOCOPY NUMBER
192: ,x_msg_data OUT NOCOPY VARCHAR2 ) IS
193:
194: l_mohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
195: l_mohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
196: l_header_id number;
197:
198: l_api_version_number CONSTANT NUMBER := 1.0;
199: l_api_name CONSTANT VARCHAR2(30) := 'Create_Move_Order_Header';

Line 274: INV_Move_Order_PUB.Create_Move_order_Header(

270: l_mohdr_rec.db_flag := FND_API.G_TRUE;
271: l_mohdr_rec.operation := INV_GLOBALS.G_OPR_CREATE;
272:
273: -- call public api to create a record for move order header in Oracle Inventory
274: INV_Move_Order_PUB.Create_Move_order_Header(
275: p_api_version_number => 1,
276: p_init_msg_list => p_init_msg_list,
277: p_return_values => FND_API.G_TRUE,
278: p_commit => l_commit,

Line 431: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;

427: ,x_return_status OUT NOCOPY VARCHAR2
428: ,x_msg_count OUT NOCOPY NUMBER
429: ,x_msg_data OUT NOCOPY VARCHAR2 ) IS
430:
431: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
432: l_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
433:
434: l_api_version_number CONSTANT NUMBER := 1.0;
435: l_api_name CONSTANT VARCHAR2(30) := 'Create_Move_Order_Line';

Line 432: l_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;

428: ,x_msg_count OUT NOCOPY NUMBER
429: ,x_msg_data OUT NOCOPY VARCHAR2 ) IS
430:
431: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
432: l_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
433:
434: l_api_version_number CONSTANT NUMBER := 1.0;
435: l_api_name CONSTANT VARCHAR2(30) := 'Create_Move_Order_Line';
436: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 536: INV_Move_Order_Pub.Create_Move_Order_Lines

532: l_trolin_tbl(l_order_count).uom_code := p_uom_code;
533: l_trolin_tbl(l_order_count).db_flag := FND_API.G_TRUE;
534: l_trolin_tbl(l_order_count).operation := INV_GLOBALS.G_OPR_CREATE;
535:
536: INV_Move_Order_Pub.Create_Move_Order_Lines
537: ( p_api_version_number => 1.0 ,
538: p_init_msg_list => p_init_msg_list,
539: p_commit => l_commit,
540: p_return_values => FND_API.G_TRUE,