DBA Data[Home] [Help]

APPS.WSH_PICK_LIST dependencies on INV_GLOBALS

Line 1279: g_trolin_tbl(l_count).line_status := INV_Globals.G_TO_STATUS_PREAPPROVED;

1275: g_trolin_tbl(l_count).secondary_quantity := TO_NUMBER(WSH_PR_CRITERIA.release_table(i).requested_quantity2);
1276: g_trolin_tbl(l_count).uom_code := WSH_PR_CRITERIA.release_table(i).requested_quantity_uom;
1277: g_trolin_tbl(l_count).secondary_uom := WSH_PR_CRITERIA.release_table(i).requested_quantity_UOM2;
1278: g_trolin_tbl(l_count).grade_code := WSH_PR_CRITERIA.release_table(i).preferred_grade;
1279: g_trolin_tbl(l_count).line_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
1280: g_trolin_tbl(l_count).unit_number := WSH_PR_CRITERIA.release_table(i).unit_number;
1281: -- Transaction type is different for internal orders
1282: IF (WSH_PR_CRITERIA.release_table(i).source_doc_type = 10) THEN
1283: g_trolin_tbl(l_count).transaction_type_id := INV_GLOBALS.G_TYPE_INTERNAL_ORDER_STGXFR;

Line 1283: g_trolin_tbl(l_count).transaction_type_id := INV_GLOBALS.G_TYPE_INTERNAL_ORDER_STGXFR;

1279: g_trolin_tbl(l_count).line_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
1280: g_trolin_tbl(l_count).unit_number := WSH_PR_CRITERIA.release_table(i).unit_number;
1281: -- Transaction type is different for internal orders
1282: IF (WSH_PR_CRITERIA.release_table(i).source_doc_type = 10) THEN
1283: g_trolin_tbl(l_count).transaction_type_id := INV_GLOBALS.G_TYPE_INTERNAL_ORDER_STGXFR;
1284: ELSE
1285: g_trolin_tbl(l_count).transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_STGXFR;
1286: END IF;
1287:

Line 1285: g_trolin_tbl(l_count).transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_STGXFR;

1281: -- Transaction type is different for internal orders
1282: IF (WSH_PR_CRITERIA.release_table(i).source_doc_type = 10) THEN
1283: g_trolin_tbl(l_count).transaction_type_id := INV_GLOBALS.G_TYPE_INTERNAL_ORDER_STGXFR;
1284: ELSE
1285: g_trolin_tbl(l_count).transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_STGXFR;
1286: END IF;
1287:
1288: -- No need to create move order line for backordered line
1289: IF (WSH_PR_CRITERIA.release_table(i).move_order_line_id IS NOT NULL) THEN

Line 1297: g_trolin_tbl(l_count).operation := INV_GLOBALS.G_OPR_UPDATE;

1293: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_TROLIN_UTIL.QUERY_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
1294: END IF;
1295: l_temp_trolin_rec := INV_Trolin_Util.Query_Row( p_line_id => g_trolin_tbl(l_count).line_id );
1296: g_trolin_tbl(l_count).quantity := l_temp_trolin_rec.quantity;
1297: g_trolin_tbl(l_count).operation := INV_GLOBALS.G_OPR_UPDATE;
1298: ELSE
1299: g_trolin_tbl(l_count).operation := INV_GLOBALS.G_OPR_CREATE;
1300: END IF;
1301: --}

Line 1299: g_trolin_tbl(l_count).operation := INV_GLOBALS.G_OPR_CREATE;

1295: l_temp_trolin_rec := INV_Trolin_Util.Query_Row( p_line_id => g_trolin_tbl(l_count).line_id );
1296: g_trolin_tbl(l_count).quantity := l_temp_trolin_rec.quantity;
1297: g_trolin_tbl(l_count).operation := INV_GLOBALS.G_OPR_UPDATE;
1298: ELSE
1299: g_trolin_tbl(l_count).operation := INV_GLOBALS.G_OPR_CREATE;
1300: END IF;
1301: --}
1302: END IF; -- released_status X
1303: --}

Line 3097: p_move_order_type => INV_GLOBALS.G_MOVE_ORDER_PICK_WAVE,

3093: INV_Pick_Wave_Pick_Confirm_PUB.Pick_Confirm
3094: (p_api_version_number => l_api_version_number,
3095: p_init_msg_list => FND_API.G_TRUE,
3096: p_commit => l_commit,
3097: p_move_order_type => INV_GLOBALS.G_MOVE_ORDER_PICK_WAVE,
3098: p_transaction_mode => 1,
3099: p_trolin_tbl => g_trolin_tbl,
3100: p_mold_tbl => l_mmtt_tbl,
3101: x_mmtt_tbl => l_mmtt_tbl,

Line 4481: l_trohdr_rec.move_order_type := INV_GLOBALS.G_MOVE_ORDER_PICK_WAVE;

4477: l_trohdr_rec.last_update_date := l_date;
4478: l_trohdr_rec.last_update_login := l_login_id;
4479: l_trohdr_rec.organization_id := l_organization_id;
4480: l_trohdr_rec.grouping_rule_id := l_org_info.pick_grouping_rule_id;
4481: l_trohdr_rec.move_order_type := INV_GLOBALS.G_MOVE_ORDER_PICK_WAVE;
4482: l_trohdr_rec.transaction_type_id := NULL;
4483: l_trohdr_rec.operation := INV_GLOBALS.G_OPR_CREATE;
4484: l_trohdr_rec.header_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
4485: l_trohdr_rec.request_number := l_batch_name;

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

4479: l_trohdr_rec.organization_id := l_organization_id;
4480: l_trohdr_rec.grouping_rule_id := l_org_info.pick_grouping_rule_id;
4481: l_trohdr_rec.move_order_type := INV_GLOBALS.G_MOVE_ORDER_PICK_WAVE;
4482: l_trohdr_rec.transaction_type_id := NULL;
4483: l_trohdr_rec.operation := INV_GLOBALS.G_OPR_CREATE;
4484: l_trohdr_rec.header_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
4485: l_trohdr_rec.request_number := l_batch_name;
4486:
4487: -- 90.7 Create Move Order Header

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

4480: l_trohdr_rec.grouping_rule_id := l_org_info.pick_grouping_rule_id;
4481: l_trohdr_rec.move_order_type := INV_GLOBALS.G_MOVE_ORDER_PICK_WAVE;
4482: l_trohdr_rec.transaction_type_id := NULL;
4483: l_trohdr_rec.operation := INV_GLOBALS.G_OPR_CREATE;
4484: l_trohdr_rec.header_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
4485: l_trohdr_rec.request_number := l_batch_name;
4486:
4487: -- 90.7 Create Move Order Header
4488: IF l_debug_on THEN

Line 5366: l_trohdr_rec.operation := INV_GLOBALS.G_OPR_DELETE;

5362: -- Clear move order header/line records
5363: l_trohdr_rec := l_empty_trohdr_rec;
5364: l_trohdr_val_rec := l_empty_trohdr_val_rec;
5365: l_trohdr_rec.header_id := crec.mo_header_id;
5366: l_trohdr_rec.operation := INV_GLOBALS.G_OPR_DELETE;
5367: l_trolin_tbl.delete;
5368: l_trolin_val_tbl.delete;
5369: IF l_debug_on THEN
5370: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_MOVE_ORDER_PUB.PROCESS_MOVE_ORDER'