786: l_subinventory_code,
787: l_transfer_subinventory,
788: l_from_locator_id,
789: l_to_locator_id
790: FROM mtl_txn_request_lines
791: WHERE line_id = l_line_id;
792: END IF;
793:
794: IF l_transfer_organization_id IS NOT NULL THEN
1019: transfer_cost_group_id = Nvl(transfer_cost_group_id, l_transfer_cost_group_id)
1020: where transaction_temp_id = l_line_id;
1021: ELSIF p_input_type = G_INPUT_MOLINE THEN
1022: IF (l_debug = 1) THEN
1023: print_debug('update the mtl_txn_request_lines with cost group ' ||
1024: l_cost_group_id || ' and ' || l_transfer_cost_group_id);
1025: END IF;
1026: update mtl_txn_request_lines
1027: set from_cost_Group_id = l_cost_group_id,
1022: IF (l_debug = 1) THEN
1023: print_debug('update the mtl_txn_request_lines with cost group ' ||
1024: l_cost_group_id || ' and ' || l_transfer_cost_group_id);
1025: END IF;
1026: update mtl_txn_request_lines
1027: set from_cost_Group_id = l_cost_group_id,
1028: to_cost_group_id = Nvl(to_cost_group_id, l_transfer_cost_group_id)
1029: where line_id = l_line_id;
1030: end if;
1058: SET transfer_cost_group_id = NULL
1059: WHERE transaction_temp_id = l_line_id;
1060: ELSIF p_input_type = G_INPUT_MOLINE THEN
1061: IF (l_debug = 1) THEN
1062: print_debug('update the mtl_txn_request_lines with to cost group null');
1063: END IF;
1064: UPDATE mtl_txn_request_lines
1065: SET to_cost_group_id = null
1066: WHERE line_id = l_line_id;
1060: ELSIF p_input_type = G_INPUT_MOLINE THEN
1061: IF (l_debug = 1) THEN
1062: print_debug('update the mtl_txn_request_lines with to cost group null');
1063: END IF;
1064: UPDATE mtl_txn_request_lines
1065: SET to_cost_group_id = null
1066: WHERE line_id = l_line_id;
1067: END IF;
1068: ELSE
1100: SET cost_group_id = l_cost_group_id
1101: WHERE transaction_temp_id = l_line_id;
1102: ELSIF p_input_type = G_INPUT_MOLINE THEN
1103: IF (l_debug = 1) THEN
1104: print_debug('update the mtl_txn_request_lines with cost group ' ||
1105: l_cost_group_id || ' and ' || l_transfer_cost_group_id);
1106: END IF;
1107: UPDATE mtl_txn_request_lines
1108: SET from_cost_group_id = l_cost_group_id
1103: IF (l_debug = 1) THEN
1104: print_debug('update the mtl_txn_request_lines with cost group ' ||
1105: l_cost_group_id || ' and ' || l_transfer_cost_group_id);
1106: END IF;
1107: UPDATE mtl_txn_request_lines
1108: SET from_cost_group_id = l_cost_group_id
1109: WHERE line_id = l_line_id;
1110: END IF;
1111: END IF;-- for org transfer ,dest locator is project
1152: --transfer_cost_group_id = Nvl(transfer_cost_group_id, l_transfer_cost_group_id)
1153: WHERE transaction_temp_id = l_line_id;
1154: ELSIF p_input_type = G_INPUT_MOLINE THEN
1155: IF (l_debug = 1) THEN
1156: print_debug('update the mtl_txn_request_lines with cost group ' || l_cost_group_id);
1157: END IF;
1158: UPDATE mtl_txn_request_lines
1159: SET from_cost_group_id = l_cost_group_id
1160: --to_cost_group_id = Nvl(to_cost_group_id, l_transfer_cost_group_id)
1154: ELSIF p_input_type = G_INPUT_MOLINE THEN
1155: IF (l_debug = 1) THEN
1156: print_debug('update the mtl_txn_request_lines with cost group ' || l_cost_group_id);
1157: END IF;
1158: UPDATE mtl_txn_request_lines
1159: SET from_cost_group_id = l_cost_group_id
1160: --to_cost_group_id = Nvl(to_cost_group_id, l_transfer_cost_group_id)
1161: WHERE line_id = l_line_id;
1162: END IF;
1174: transfer_cost_group_id = Nvl(transfer_cost_group_id, l_transfer_cost_group_id)
1175: WHERE transaction_temp_id = l_line_id;
1176: ELSIF p_input_type = G_INPUT_MOLINE THEN
1177: IF (l_debug = 1) THEN
1178: print_debug('update the mtl_txn_request_lines with cost group ' ||
1179: l_cost_group_id || ' and ' || l_transfer_cost_group_id);
1180: END IF;
1181: UPDATE mtl_txn_request_lines
1182: SET from_cost_group_id = l_cost_group_id,
1177: IF (l_debug = 1) THEN
1178: print_debug('update the mtl_txn_request_lines with cost group ' ||
1179: l_cost_group_id || ' and ' || l_transfer_cost_group_id);
1180: END IF;
1181: UPDATE mtl_txn_request_lines
1182: SET from_cost_group_id = l_cost_group_id,
1183: to_cost_group_id = Nvl(to_cost_group_id, l_transfer_cost_group_id)
1184: WHERE line_id = l_line_id;
1185: END IF;
1234: WHERE transaction_temp_id = l_line_id;
1235:
1236: ELSIF p_input_type = G_INPUT_MOLINE THEN
1237: IF (l_debug = 1) THEN
1238: print_debug('update the mtl_txn_request_lines with from cost group null');
1239: print_debug('update the mtl_txn_request_lines with tfr cost group null');
1240: END IF;
1241:
1242: UPDATE mtl_txn_request_lines
1235:
1236: ELSIF p_input_type = G_INPUT_MOLINE THEN
1237: IF (l_debug = 1) THEN
1238: print_debug('update the mtl_txn_request_lines with from cost group null');
1239: print_debug('update the mtl_txn_request_lines with tfr cost group null');
1240: END IF;
1241:
1242: UPDATE mtl_txn_request_lines
1243: SET to_cost_group_id = NULL,
1238: print_debug('update the mtl_txn_request_lines with from cost group null');
1239: print_debug('update the mtl_txn_request_lines with tfr cost group null');
1240: END IF;
1241:
1242: UPDATE mtl_txn_request_lines
1243: SET to_cost_group_id = NULL,
1244: from_cost_group_id = null
1245: WHERE line_id = l_line_id;
1246: END IF;
1256: END IF;
1257:
1258: IF (p_input_type = g_input_moline) THEN -- Input type is MMTT
1259: IF (l_debug = 1) THEN
1260: print_debug('before calling wms_costgroupengine_pvt for mtl_txn_request_lines record');
1261: END IF;
1262: wms_costgroupengine_pvt.assign_cost_group
1263: (p_api_version => 1.0,
1264: p_init_msg_list => fnd_api.g_false,
1284: IF (l_debug = 1) THEN
1285: print_debug('Setting from cost group as null ');
1286: END IF;
1287:
1288: UPDATE mtl_txn_request_lines
1289: SET
1290: from_cost_group_id = null
1291: WHERE line_id = l_line_id;
1292:
1341: IF (l_debug = 1) THEN
1342: print_debug('Setting cost group as null ');
1343: END IF;
1344:
1345: UPDATE mtl_txn_request_lines
1346: SET
1347: from_cost_group_id = null
1348: WHERE line_id = l_line_id;
1349:
1376: SET transfer_cost_group_id = NULL
1377: WHERE transaction_temp_id = l_line_id;
1378: ELSIF p_input_type = G_INPUT_MOLINE THEN
1379: IF (l_debug = 1) THEN
1380: print_debug('update the mtl_txn_request_lines with transfer cost group null');
1381: END IF;
1382: UPDATE mtl_txn_request_lines
1383: SET to_cost_group_id = null
1384: WHERE line_id = l_line_id;
1378: ELSIF p_input_type = G_INPUT_MOLINE THEN
1379: IF (l_debug = 1) THEN
1380: print_debug('update the mtl_txn_request_lines with transfer cost group null');
1381: END IF;
1382: UPDATE mtl_txn_request_lines
1383: SET to_cost_group_id = null
1384: WHERE line_id = l_line_id;
1385: END IF;
1386: -- Added by cjandhya
1426: SET transfer_cost_group_id = l_transfer_cost_group_id
1427: WHERE transaction_temp_id = l_line_id;
1428: ELSIF p_input_type = G_INPUT_MOLINE THEN
1429: IF (l_debug = 1) THEN
1430: print_debug('update the mtl_txn_request_lines with cost group ' ||
1431: l_cost_group_id || ' and ' || l_transfer_cost_group_id);
1432: END IF;
1433: UPDATE mtl_txn_request_lines
1434: SET to_cost_group_id = l_transfer_cost_group_id
1429: IF (l_debug = 1) THEN
1430: print_debug('update the mtl_txn_request_lines with cost group ' ||
1431: l_cost_group_id || ' and ' || l_transfer_cost_group_id);
1432: END IF;
1433: UPDATE mtl_txn_request_lines
1434: SET to_cost_group_id = l_transfer_cost_group_id
1435: WHERE line_id = l_line_id;
1436: END IF;
1437: END IF;
1546: END IF;
1547: END IF;
1548: ELSIF (p_input_type = g_input_moline) THEN
1549: IF (l_debug = 1) THEN
1550: print_debug('before calling wms_costgroupengine_pvt for mtl_txn_request_lines record');
1551: END IF;
1552: wms_costgroupengine_pvt.assign_cost_group
1553: (
1554: p_api_version => 1.0,