DBA Data[Home] [Help]

APPS.WSH_PICK_LIST dependencies on INV_GLOBALS

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

1336: g_trolin_tbl(l_count).secondary_quantity := TO_NUMBER(WSH_PR_CRITERIA.release_table(i).requested_quantity2);
1337: g_trolin_tbl(l_count).uom_code := WSH_PR_CRITERIA.release_table(i).requested_quantity_uom;
1338: g_trolin_tbl(l_count).secondary_uom := WSH_PR_CRITERIA.release_table(i).requested_quantity_UOM2;
1339: g_trolin_tbl(l_count).grade_code := WSH_PR_CRITERIA.release_table(i).preferred_grade;
1340: g_trolin_tbl(l_count).line_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
1341: g_trolin_tbl(l_count).unit_number := WSH_PR_CRITERIA.release_table(i).unit_number;
1342: -- Transaction type is different for internal orders
1343: IF (WSH_PR_CRITERIA.release_table(i).source_doc_type = 10) THEN
1344: g_trolin_tbl(l_count).transaction_type_id := INV_GLOBALS.G_TYPE_INTERNAL_ORDER_STGXFR;

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

1340: g_trolin_tbl(l_count).line_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
1341: g_trolin_tbl(l_count).unit_number := WSH_PR_CRITERIA.release_table(i).unit_number;
1342: -- Transaction type is different for internal orders
1343: IF (WSH_PR_CRITERIA.release_table(i).source_doc_type = 10) THEN
1344: g_trolin_tbl(l_count).transaction_type_id := INV_GLOBALS.G_TYPE_INTERNAL_ORDER_STGXFR;
1345: ELSE
1346: g_trolin_tbl(l_count).transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_STGXFR;
1347: END IF;
1348:

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

1342: -- Transaction type is different for internal orders
1343: IF (WSH_PR_CRITERIA.release_table(i).source_doc_type = 10) THEN
1344: g_trolin_tbl(l_count).transaction_type_id := INV_GLOBALS.G_TYPE_INTERNAL_ORDER_STGXFR;
1345: ELSE
1346: g_trolin_tbl(l_count).transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_STGXFR;
1347: END IF;
1348:
1349: -- No need to create move order line for backordered line
1350: IF (WSH_PR_CRITERIA.release_table(i).move_order_line_id IS NOT NULL) THEN

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

1354: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_TROLIN_UTIL.QUERY_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
1355: END IF;
1356: l_temp_trolin_rec := INV_Trolin_Util.Query_Row( p_line_id => g_trolin_tbl(l_count).line_id );
1357: g_trolin_tbl(l_count).quantity := l_temp_trolin_rec.quantity;
1358: g_trolin_tbl(l_count).operation := INV_GLOBALS.G_OPR_UPDATE;
1359: ELSE
1360: g_trolin_tbl(l_count).operation := INV_GLOBALS.G_OPR_CREATE;
1361: END IF;
1362: --}

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

1356: l_temp_trolin_rec := INV_Trolin_Util.Query_Row( p_line_id => g_trolin_tbl(l_count).line_id );
1357: g_trolin_tbl(l_count).quantity := l_temp_trolin_rec.quantity;
1358: g_trolin_tbl(l_count).operation := INV_GLOBALS.G_OPR_UPDATE;
1359: ELSE
1360: g_trolin_tbl(l_count).operation := INV_GLOBALS.G_OPR_CREATE;
1361: END IF;
1362: --}
1363: END IF; -- released_status X
1364: --}

Line 3171: p_move_order_type => INV_GLOBALS.G_MOVE_ORDER_PICK_WAVE,

3167: INV_Pick_Wave_Pick_Confirm_PUB.Pick_Confirm
3168: (p_api_version_number => l_api_version_number,
3169: p_init_msg_list => FND_API.G_TRUE,
3170: p_commit => l_commit,
3171: p_move_order_type => INV_GLOBALS.G_MOVE_ORDER_PICK_WAVE,
3172: p_transaction_mode => 1,
3173: p_trolin_tbl => g_trolin_tbl,
3174: p_mold_tbl => l_mmtt_tbl,
3175: x_mmtt_tbl => l_mmtt_tbl,

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

4572: l_trohdr_rec.last_update_date := l_date;
4573: l_trohdr_rec.last_update_login := l_login_id;
4574: l_trohdr_rec.organization_id := l_organization_id;
4575: l_trohdr_rec.grouping_rule_id := l_org_info.pick_grouping_rule_id;
4576: l_trohdr_rec.move_order_type := INV_GLOBALS.G_MOVE_ORDER_PICK_WAVE;
4577: l_trohdr_rec.transaction_type_id := NULL;
4578: l_trohdr_rec.operation := INV_GLOBALS.G_OPR_CREATE;
4579: l_trohdr_rec.header_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
4580: l_trohdr_rec.request_number := l_batch_name;

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

4574: l_trohdr_rec.organization_id := l_organization_id;
4575: l_trohdr_rec.grouping_rule_id := l_org_info.pick_grouping_rule_id;
4576: l_trohdr_rec.move_order_type := INV_GLOBALS.G_MOVE_ORDER_PICK_WAVE;
4577: l_trohdr_rec.transaction_type_id := NULL;
4578: l_trohdr_rec.operation := INV_GLOBALS.G_OPR_CREATE;
4579: l_trohdr_rec.header_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
4580: l_trohdr_rec.request_number := l_batch_name;
4581:
4582: -- 90.7 Create Move Order Header

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

4575: l_trohdr_rec.grouping_rule_id := l_org_info.pick_grouping_rule_id;
4576: l_trohdr_rec.move_order_type := INV_GLOBALS.G_MOVE_ORDER_PICK_WAVE;
4577: l_trohdr_rec.transaction_type_id := NULL;
4578: l_trohdr_rec.operation := INV_GLOBALS.G_OPR_CREATE;
4579: l_trohdr_rec.header_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
4580: l_trohdr_rec.request_number := l_batch_name;
4581:
4582: -- 90.7 Create Move Order Header
4583: IF l_debug_on THEN

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

5496: -- Clear move order header/line records
5497: l_trohdr_rec := l_empty_trohdr_rec;
5498: l_trohdr_val_rec := l_empty_trohdr_val_rec;
5499: l_trohdr_rec.header_id := crec.mo_header_id;
5500: l_trohdr_rec.operation := INV_GLOBALS.G_OPR_DELETE;
5501: l_trolin_tbl.delete;
5502: l_trolin_val_tbl.delete;
5503: IF l_debug_on THEN
5504: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_MOVE_ORDER_PUB.PROCESS_MOVE_ORDER'