DBA Data[Home] [Help]

APPS.CSP_TRANSACTIONS_PUB dependencies on INV_MOVE_ORDER_PUB

Line 84: l_trolin_tbl inv_move_order_pub.Trolin_Tbl_Type;

80: x_msg_count OUT NOCOPY number,
81: x_msg_data OUT NOCOPY varchar2) is
82:
83: l_header_id number;
84: l_trolin_tbl inv_move_order_pub.Trolin_Tbl_Type;
85: l_trolin_old_tbl inv_move_order_pub.trolin_tbl_type;
86: x_trolin_tbl inv_move_order_pub.trolin_tbl_type;
87:
88: cursor c_header_id is

Line 85: l_trolin_old_tbl inv_move_order_pub.trolin_tbl_type;

81: x_msg_data OUT NOCOPY varchar2) is
82:
83: l_header_id number;
84: l_trolin_tbl inv_move_order_pub.Trolin_Tbl_Type;
85: l_trolin_old_tbl inv_move_order_pub.trolin_tbl_type;
86: x_trolin_tbl inv_move_order_pub.trolin_tbl_type;
87:
88: cursor c_header_id is
89: select header_id

Line 86: x_trolin_tbl inv_move_order_pub.trolin_tbl_type;

82:
83: l_header_id number;
84: l_trolin_tbl inv_move_order_pub.Trolin_Tbl_Type;
85: l_trolin_old_tbl inv_move_order_pub.trolin_tbl_type;
86: x_trolin_tbl inv_move_order_pub.trolin_tbl_type;
87:
88: cursor c_header_id is
89: select header_id
90: from mtl_txn_request_lines

Line 103: inv_move_order_pub.process_move_order_line(

99: l_trolin_tbl(1).header_id := l_header_id;
100: l_trolin_tbl(1).line_id := p_line_id;
101: l_trolin_tbl(1).operation := inv_globals.g_opr_update;
102:
103: inv_move_order_pub.process_move_order_line(
104: p_api_version_number => 1.0
105: , x_return_status => x_return_status
106: , x_msg_count => x_msg_count
107: , x_msg_data => x_msg_data

Line 139: l_mohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;

135: ,x_return_status OUT NOCOPY VARCHAR2
136: ,x_msg_count OUT NOCOPY NUMBER
137: ,x_msg_data OUT NOCOPY VARCHAR2 ) IS
138:
139: l_mohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
140: l_mohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
141: l_header_id number;
142:
143: l_api_version_number CONSTANT NUMBER := 1.0;

Line 140: l_mohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;

136: ,x_msg_count OUT NOCOPY NUMBER
137: ,x_msg_data OUT NOCOPY VARCHAR2 ) IS
138:
139: l_mohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
140: l_mohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
141: l_header_id number;
142:
143: l_api_version_number CONSTANT NUMBER := 1.0;
144: l_api_name CONSTANT VARCHAR2(30) := 'Create_Move_Order_Header';

Line 219: INV_Move_Order_PUB.Create_Move_order_Header(

215: l_mohdr_rec.db_flag := FND_API.G_TRUE;
216: l_mohdr_rec.operation := INV_GLOBALS.G_OPR_CREATE;
217:
218: -- call public api to create a record for move order header in Oracle Inventory
219: INV_Move_Order_PUB.Create_Move_order_Header(
220: p_api_version_number => 1,
221: p_init_msg_list => p_init_msg_list,
222: p_return_values => FND_API.G_TRUE,
223: p_commit => l_commit,

Line 376: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;

372: ,x_return_status OUT NOCOPY VARCHAR2
373: ,x_msg_count OUT NOCOPY NUMBER
374: ,x_msg_data OUT NOCOPY VARCHAR2 ) IS
375:
376: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
377: l_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
378:
379: l_api_version_number CONSTANT NUMBER := 1.0;
380: l_api_name CONSTANT VARCHAR2(30) := 'Create_Move_Order_Line';

Line 377: l_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;

373: ,x_msg_count OUT NOCOPY NUMBER
374: ,x_msg_data OUT NOCOPY VARCHAR2 ) IS
375:
376: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
377: l_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
378:
379: l_api_version_number CONSTANT NUMBER := 1.0;
380: l_api_name CONSTANT VARCHAR2(30) := 'Create_Move_Order_Line';
381: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 481: INV_Move_Order_Pub.Create_Move_Order_Lines

477: l_trolin_tbl(l_order_count).uom_code := p_uom_code;
478: l_trolin_tbl(l_order_count).db_flag := FND_API.G_TRUE;
479: l_trolin_tbl(l_order_count).operation := INV_GLOBALS.G_OPR_CREATE;
480:
481: INV_Move_Order_Pub.Create_Move_Order_Lines
482: ( p_api_version_number => 1.0 ,
483: p_init_msg_list => p_init_msg_list,
484: p_commit => l_commit,
485: p_return_values => FND_API.G_TRUE,