DBA Data[Home] [Help]

APPS.WMS_UT_PKG dependencies on INV_GLOBALS

Line 1160: l_transaction_type_id := INV_GLOBALS.G_TYPE_INTERNAL_ORDER_STGXFR;

1156: AND mso.segment1 = to_char(oh.order_number)
1157: AND ROWNUM < 2;
1158:
1159: IF l_source_doc_type = 10 THEN
1160: l_transaction_type_id := INV_GLOBALS.G_TYPE_INTERNAL_ORDER_STGXFR;
1161: ELSE
1162: l_transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_STGXFR;
1163: END IF;
1164: SELECT transaction_source_type_id

Line 1162: l_transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_STGXFR;

1158:
1159: IF l_source_doc_type = 10 THEN
1160: l_transaction_type_id := INV_GLOBALS.G_TYPE_INTERNAL_ORDER_STGXFR;
1161: ELSE
1162: l_transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_STGXFR;
1163: END IF;
1164: SELECT transaction_source_type_id
1165: INTO l_demand_source_type_id
1166: FROM mtl_transaction_types

Line 1271: l_trohdr_rec.move_order_type := INV_GLOBALS.G_MOVE_ORDER_REQUISITION;

1267: l_trohdr_rec.last_update_date := l_date;
1268: l_trohdr_rec.last_update_login := p_user_id;
1269: l_trohdr_rec.organization_id := p_org_id;
1270: --l_trohdr_rec.grouping_rule_id := NULL; --l_org_infopick_grouping_rule_id;
1271: l_trohdr_rec.move_order_type := INV_GLOBALS.G_MOVE_ORDER_REQUISITION;
1272: --l_trohdr_rec.transaction_type_id := NULL;
1273: l_trohdr_rec.operation := INV_GLOBALS.G_OPR_CREATE;
1274: l_trohdr_rec.header_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
1275: l_trohdr_rec.request_number := l_request_number;

Line 1273: l_trohdr_rec.operation := INV_GLOBALS.G_OPR_CREATE;

1269: l_trohdr_rec.organization_id := p_org_id;
1270: --l_trohdr_rec.grouping_rule_id := NULL; --l_org_infopick_grouping_rule_id;
1271: l_trohdr_rec.move_order_type := INV_GLOBALS.G_MOVE_ORDER_REQUISITION;
1272: --l_trohdr_rec.transaction_type_id := NULL;
1273: l_trohdr_rec.operation := INV_GLOBALS.G_OPR_CREATE;
1274: l_trohdr_rec.header_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
1275: l_trohdr_rec.request_number := l_request_number;
1276:
1277:

Line 1274: l_trohdr_rec.header_status := INV_Globals.G_TO_STATUS_PREAPPROVED;

1270: --l_trohdr_rec.grouping_rule_id := NULL; --l_org_infopick_grouping_rule_id;
1271: l_trohdr_rec.move_order_type := INV_GLOBALS.G_MOVE_ORDER_REQUISITION;
1272: --l_trohdr_rec.transaction_type_id := NULL;
1273: l_trohdr_rec.operation := INV_GLOBALS.G_OPR_CREATE;
1274: l_trohdr_rec.header_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
1275: l_trohdr_rec.request_number := l_request_number;
1276:
1277:
1278: Inv_Move_Order_Pub.Create_Move_Order_Header

Line 1321: l_trolin_tbl(l_ix).transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_MOVEORDER;

1317: -- source
1318: l_trolin_tbl(l_ix).txn_source_line_detail_id := NULL;
1319: l_trolin_tbl(l_ix).txn_source_line_id := NULL;
1320: l_trolin_tbl(l_ix).txn_source_id := l_mo_header_id;
1321: l_trolin_tbl(l_ix).transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_MOVEORDER;
1322: -- source
1323: l_trolin_tbl(l_ix).organization_id := p_org_id;
1324: l_trolin_tbl(l_ix).from_subinventory_code := NULL; --p_from_subinventory;
1325: l_trolin_tbl(l_ix).from_locator_id := NULL; --p_from_locator;

Line 1337: l_trolin_tbl(l_ix).line_status := INV_Globals.G_TO_STATUS_PREAPPROVED;

1333: l_trolin_tbl(l_ix).primary_quantity := l_request_quantity;
1334: l_trolin_tbl(l_ix).required_quantity := l_request_quantity;
1335: l_trolin_tbl(l_ix).uom_code := l_mo_orders(l_ix)(5);
1336: l_trolin_tbl(l_ix).grade_code := NULL;
1337: l_trolin_tbl(l_ix).line_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
1338: l_trolin_tbl(l_ix).unit_number := NULL;
1339:
1340: l_trolin_tbl(l_ix).transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;
1341:

Line 1340: l_trolin_tbl(l_ix).transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;

1336: l_trolin_tbl(l_ix).grade_code := NULL;
1337: l_trolin_tbl(l_ix).line_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
1338: l_trolin_tbl(l_ix).unit_number := NULL;
1339:
1340: l_trolin_tbl(l_ix).transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;
1341:
1342: IF l_ix = l_mo_orders.count THEN
1343: print_debug('Calling create move order lines - ' || l_trolin_tbl.count);
1344: Inv_Move_Order_Pub.Create_Move_Order_Lines

Line 1821: l_transaction_type_id := INV_GLOBALS.G_TYPE_INTERNAL_ORDER_STGXFR;

1817:
1818: l_dem_indx := g_demand_tbl.count + 1;
1819:
1820: IF sol_rec.source_doc_type_id = 10 THEN
1821: l_transaction_type_id := INV_GLOBALS.G_TYPE_INTERNAL_ORDER_STGXFR;
1822: ELSE
1823: l_transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_STGXFR;
1824: END IF;
1825: SELECT transaction_source_type_id

Line 1823: l_transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_STGXFR;

1819:
1820: IF sol_rec.source_doc_type_id = 10 THEN
1821: l_transaction_type_id := INV_GLOBALS.G_TYPE_INTERNAL_ORDER_STGXFR;
1822: ELSE
1823: l_transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_STGXFR;
1824: END IF;
1825: SELECT transaction_source_type_id
1826: INTO l_demand_source_type_id
1827: FROM mtl_transaction_types