## 4. CRUD Operations / Called Services

### Pre-computed evidence from code analysis graph:

| CRUD | SC / CBS | SC Code | Entity / DB | Operation Description |
|------|----------|---------|-------------|----------------------|
| R | `JKKHakkoSODCC.callEKK0351B002SC` | EKK0351B002SC | KK_T_OP_SVCKEI (Option service contract table) | Calls option service contract list inquiry by service contract number |
| R | `JKKHakkoSODCC.callEKK0351A010SC` | EKK0351A010SC | KK_T_OP_SVCKEI_DETAIL (Option service contract detail table) | Calls option service contract agreement inquiry by option service contract number |
| R | `JKKHakkoSODCC.callEKK0341B008SC` | EKK0341B008SC | KK_T_KKTK_SVCKEI (Equipment-provided service contract table) | Calls equipment-provided service contract list inquiry by service contract number |
| R | `JKKHakkoSODCC.callEKK0361A010SC` | EKK0361A010SC | KK_T_OP_SVCKEI_ISP (Option service contract <ISP> table) | Calls option service contract <ISP> agreement inquiry |
| R | `JKKHakkoSODCC.callEKK0161A010SC` | EKK0161A010SC | KK_T_SVCKEI_UCWK (Service contract detail table) | Calls service contract detail agreement inquiry by service contract detail number |
| R | `JKKHakkoSODCC.callEKK0341B008_02SC` | EKK0341B008_02SC | KK_T_KKTK_SVCKEI (Equipment-provided service contract table) | Alternative equipment-provided service contract list inquiry (EG switch path) |
| R | `JKKHakkoSODCC.getEKK0251B001SC` | EKK0251B001SC | KK_T_SVCKEI_KAISEN (Service line detail table) | Calls service line detail list inquiry by service contract number |
| R | `JKKHakkoSODCC.callEKK0191A010SC` | EKK0191A010SC | KK_T_SVCKEI_UCWK_TEL (Telephone service contract detail table) | Calls telephone service contract detail agreement inquiry |
| R | `JKKHakkoSODCC.getEKK1041B001result` | EKK1041B001SC | KK_T_ODR_SET (Order settings table) | Retrieves order settings list result from param |
| R | `JKKHakkoSODCC.callEKK1041B001SC` | EKK1041B001SC | KK_T_ODR_SET (Order settings table) | Calls order settings list inquiry by order type code, service order code, service contract number |
| R | `JKKHakkoSODCC.callEKK0351B002SC` (Mobile) | EKK0351B002SC | KK_T_OP_SVCKEI | Calls option service contract list inquiry in mobile branch |
| C | `JKKHakkoSODCC.addSOD` | JKKHakkoSODCC | - | Generates and adds SOD records (FTTH cancellation, WiMAX cancellation, e-mobile cancellation, WiFi Spot, SIP cancellation, ENUM deletion, OLS, emergency notification) |
| C | `JKKHakkoSODCC.addTakinoSOD` | JKKHakkoSODCC | - | Generates SOD for multi-function router operations (setup, cancellation, deletion) |
| C | `JKKHakkoSODCC.addTokiSOD` | JKKHakkoSODCC | - | Generates SOD for number transfer (tokii) registration |
| R | `JKKHakkoSODCC.getSame_trn_no` | EKK1081C011 | KK_T_ODR_HAKKO_JOKEN (Order issuance condition table) | Retrieves unified transaction number (同一処理番号) for grouping related cancellations |
| R | `JKKHakkoSODCC.findMobileStartOrderAtKK1041` | EKK1041B001SC | KK_T_ODR_SET (Order settings table) | Checks if mobile start order has been processed for the service contract number |
| R | `JKKHakkoSODCC.findZ5OrderAtKK1041` | EKK1041B001SC | KK_T_ODR_SET | Counts Z5 orders for WiMAX cancellation check |
| R | `JKKHakkoSODCC.findZ1OrderHasBeenSentSvcKeiUcwk` | EKK1041B001SC | KK_T_ODR_SET | Checks if Z1 order (telephone order) has been sent for the service contract detail number |
| R | `JKKHakkoSODCC.findZ1OrderHasBeenSent` | EKK1041B001SC | KK_T_ODR_SET | Checks if Z1 order has been sent (legacy version without svc_kei_ucwk) |
| - | `JKKHakkoSODCC.countUpWiFiSpotSessions` | - | - | Counts up WiFi Spot sessions by SYSID and service contract detail number |
| - | `JKKHakkoSODCC.checkTakinoRT` | - | - | Checks multi-function router (Takino router) configuration status |
| - | `JKKHakkoSODCC.opSetOdrCtrl` | JKKHakkoSODCC | - | Option setup order control - builds and issues option SOD from mapped data |
| - | `JKKHakkoSODCC.chgSvcKeiJdg` | JKKHakkoSODCC | - | Judges whether service contract number has changed between previous and current processing |
| - | `JKKHakkoSODCC.isMansionPrvate` | JKKHakkoSODCC | - | Judges if the customer is a mansion private type (mansion-type FTTH) |
| - | `JKKHakkoSODCC.isEmobile` | JKKHakkoSODCC | - | Judges if the service is e-mobile (checks pcrs_cd against e-mobile course codes) |
| - | `JKKHakkoSODCC.isBlank` | JKKHakkoSODCC | - | Utility method to check if a string is null or empty |
| - | `JKKHakkoSODCC.isTajgsTelNo` | JKKHakkoSODCC | - | Judges if the telephone number belongs to the company (self telephone number check) |
| - | `JKKHakkoSODCC.isMonaiBmp` | JKKHakkoSODCC | - | Judges if number porting (numport) is available |
| - | `JKKHakkoSODCC.isRegalVaKiki` | JKKHakkoSODCC | - | Judges if the VA (Voice Access) home equipment model code matches |
| - | `JKKHakkoSODCC.callEKK1081B001SC` | EKK1081B001SC | KK_T_ODR_HAKKO_JOKEN (Order issuance condition table) | Calls order issuance condition list inquiry |
| - | `JKKHakkoSODCC.callEKK1081E010SC` | EKK1081E010SC | KK_T_ODR_HAKKO_JOKEN | Calls order issuance condition modification/delete processing |
| - | `JKKHakkoSODCC.judgeOdrHakkoJoken4WiFiSpot` | - | - | Judges order issuance condition for WiFi Spot |

**CRUD Classification Logic:**

- **C (Create)**: `addSOD()`, `addTakinoSOD()`, `addTokiSOD()` - All write new SOD records
- **R (Read)**: All `callEKK*SC()` methods - Service component calls that query data via message-based interfaces. These correspond to CBS (CBS = CBS component) calls reading from tables like KK_T_OP_SVCKEI, KK_T_SVCKEI_UCWK, KK_T_KKTK_SVCKEI, KK_T_ODR_SET, KK_T_ODR_HAKKO_JOKEN, KK_T_SVCKEI_KAISEN.
- **- (Utility/Helper)**: Methods like `opSetOdrCtrl()`, `chgSvcKeiJdg()`, `isBlank()`, `checkTakinoRT()` - Internal helper methods that coordinate logic without direct DB access