DBA Data[Home] [Help]

APPS.CSP_TRANSACTIONS_PUB dependencies on INV_GLOBALS

Line 156: l_trolin_tbl(1).operation := inv_globals.g_opr_update;

152:
153: l_trolin_tbl(1).line_status := 9;
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

Line 261: l_mohdr_rec.header_status := INV_Globals.G_TO_STATUS_PREAPPROVED;

257: l_mohdr_rec.created_by := nvl(fnd_global.user_id,1);
258: l_mohdr_rec.creation_date := sysdate;
259: l_mohdr_rec.date_required := p_date_required;
260: l_mohdr_rec.from_subinventory_code:= p_from_subinventory_code;
261: l_mohdr_rec.header_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
262: l_mohdr_rec.last_updated_by := nvl(fnd_global.user_id,1);
263: l_mohdr_rec.last_update_date := sysdate;
264: l_mohdr_rec.last_update_login := nvl(fnd_global.login_id,-1);
265: l_mohdr_rec.organization_id := p_organization_id;

Line 268: l_mohdr_rec.transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;

264: l_mohdr_rec.last_update_login := nvl(fnd_global.login_id,-1);
265: l_mohdr_rec.organization_id := p_organization_id;
266: l_mohdr_rec.status_date := sysdate;
267: l_mohdr_rec.to_subinventory_code := p_to_subinventory_code;
268: l_mohdr_rec.transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;
269: l_mohdr_rec.move_order_type := INV_GLOBALS.G_MOVE_ORDER_REQUISITION;
270: l_mohdr_rec.db_flag := FND_API.G_TRUE;
271: l_mohdr_rec.operation := INV_GLOBALS.G_OPR_CREATE;
272:

Line 269: l_mohdr_rec.move_order_type := INV_GLOBALS.G_MOVE_ORDER_REQUISITION;

265: l_mohdr_rec.organization_id := p_organization_id;
266: l_mohdr_rec.status_date := sysdate;
267: l_mohdr_rec.to_subinventory_code := p_to_subinventory_code;
268: l_mohdr_rec.transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;
269: l_mohdr_rec.move_order_type := INV_GLOBALS.G_MOVE_ORDER_REQUISITION;
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

Line 271: l_mohdr_rec.operation := INV_GLOBALS.G_OPR_CREATE;

267: l_mohdr_rec.to_subinventory_code := p_to_subinventory_code;
268: l_mohdr_rec.transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;
269: l_mohdr_rec.move_order_type := INV_GLOBALS.G_MOVE_ORDER_REQUISITION;
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,

Line 523: l_trolin_tbl(l_order_count).line_status := INV_Globals.G_TO_STATUS_PREAPPROVED;

519: l_trolin_tbl(l_order_count).last_update_date := sysdate;
520: l_trolin_tbl(l_order_count).last_update_login := nvl(FND_GLOBAL.LOGIN_ID, -1);
521: l_trolin_tbl(l_order_count).line_id := nvl(px_line_id,FND_API.G_MISS_NUM);
522: l_trolin_tbl(l_order_count).line_number := l_line_num;
523: l_trolin_tbl(l_order_count).line_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
524: l_trolin_tbl(l_order_count).transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;
525: l_trolin_tbl(l_order_count).organization_id := p_organization_id;
526: l_trolin_tbl(l_order_count).to_organization_id := p_to_organization_id;
527: l_trolin_tbl(l_order_count).quantity := p_quantity;

Line 524: l_trolin_tbl(l_order_count).transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;

520: l_trolin_tbl(l_order_count).last_update_login := nvl(FND_GLOBAL.LOGIN_ID, -1);
521: l_trolin_tbl(l_order_count).line_id := nvl(px_line_id,FND_API.G_MISS_NUM);
522: l_trolin_tbl(l_order_count).line_number := l_line_num;
523: l_trolin_tbl(l_order_count).line_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
524: l_trolin_tbl(l_order_count).transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;
525: l_trolin_tbl(l_order_count).organization_id := p_organization_id;
526: l_trolin_tbl(l_order_count).to_organization_id := p_to_organization_id;
527: l_trolin_tbl(l_order_count).quantity := p_quantity;
528: l_trolin_tbl(l_order_count).quantity_delivered := p_quantity_delivered;

Line 534: l_trolin_tbl(l_order_count).operation := INV_GLOBALS.G_OPR_CREATE;

530: l_trolin_tbl(l_order_count).to_subinventory_code := p_to_subinventory_code;
531: l_trolin_tbl(l_order_count).to_locator_id := p_to_locator_id;
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,