217: p_isev_ext_rec OKC_TIME_PVT.isev_extended_rec_type;
218: p_igsv_ext_rec OKC_TIME_PVT.igsv_extended_rec_type;
219: l_api_name CONSTANT VARCHAR2(30) := 'delete_timevalues_n_tasks';
220: BEGIN
221: x_return_status := OKC_API.G_RET_STS_SUCCESS;
222: if p_chr_id <> 0 Then
223: if OKC_TIME_RES_PUB.Check_Res_Time_N_Tasks(p_tve_id, sysdate) Then
224: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
225: p_msg_name => 'OKC_RTV_EXISTS');
220: BEGIN
221: x_return_status := OKC_API.G_RET_STS_SUCCESS;
222: if p_chr_id <> 0 Then
223: if OKC_TIME_RES_PUB.Check_Res_Time_N_Tasks(p_tve_id, sysdate) Then
224: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
225: p_msg_name => 'OKC_RTV_EXISTS');
226: x_return_status := OKC_API.G_RET_STS_ERROR;
227: return;
228: end if;
222: if p_chr_id <> 0 Then
223: if OKC_TIME_RES_PUB.Check_Res_Time_N_Tasks(p_tve_id, sysdate) Then
224: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
225: p_msg_name => 'OKC_RTV_EXISTS');
226: x_return_status := OKC_API.G_RET_STS_ERROR;
227: return;
228: end if;
229: end if;
230: open tve_csr(p_tve_id);
231: fetch tve_csr into l_tve_rec;
232: l_not_found := tve_csr%NOTFOUND;
233: close tve_csr;
234: if l_not_found THEN
235: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TVE_ID');
236: raise item_not_found_error;
237: end if;
238: if l_tve_rec.tve_type = 'TAL' Then
239: p_talv_evt_rec.id := p_tve_id;
305: x_msg_count,
306: x_msg_data,
307: p_igsv_ext_rec);
308: end if;
309: if x_return_status = OKC_API.G_RET_STS_SUCCESS Then
310: OKC_TIME_RES_PUB.Delete_Res_Time_N_Tasks(
311: p_tve_id,
312: sysdate,
313: p_api_version,
316: end if;
317:
318: EXCEPTION
319: WHEN item_not_found_error THEN
320: x_return_status := OKC_API.G_RET_STS_ERROR;
321: WHEN OTHERS THEN
322: x_return_status := OKC_API.HANDLE_EXCEPTIONS
323: (l_api_name,
324: G_PKG_NAME,
318: EXCEPTION
319: WHEN item_not_found_error THEN
320: x_return_status := OKC_API.G_RET_STS_ERROR;
321: WHEN OTHERS THEN
322: x_return_status := OKC_API.HANDLE_EXCEPTIONS
323: (l_api_name,
324: G_PKG_NAME,
325: 'OTHERS',
326: x_msg_count,
515: x_talv_rec talv_rec_type;
516: p_tgnv_rec tgnv_rec_type;
517: x_tgnv_rec tgnv_rec_type;
518: BEGIN
519: x_return_status := OKC_API.G_RET_STS_SUCCESS;
520: x_talv_evt_rec := p_talv_evt_rec;
521: p_tgnv_rec.cnh_id := p_talv_evt_rec.cnh_id;
522: p_tgnv_rec.comments := 'Generated by TAL';
523: p_tgnv_rec.dnz_chr_id := p_talv_evt_rec.dnz_chr_id;
528: x_msg_count,
529: x_msg_data,
530: p_tgnv_rec,
531: x_tgnv_rec);
532: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
533: return;
534: end if;
535: x_talv_evt_rec.tve_id_offset := x_tgnv_rec.id;
536: x_talv_evt_rec.cnh_id := x_tgnv_rec.cnh_id;
542: x_msg_count,
543: x_msg_data,
544: p_talv_rec,
545: x_talv_rec);
546: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
547: return;
548: end if;
549: migrate(x_talv_rec,x_talv_evt_rec);
550: END CREATE_TPA_RELTV;
560: x_talv_rec talv_rec_type;
561: p_tgnv_rec tgnv_rec_type;
562: x_tgnv_rec tgnv_rec_type;
563: BEGIN
564: x_return_status := OKC_API.G_RET_STS_SUCCESS;
565: p_tgnv_rec.cnh_id := p_talv_evt_rec.cnh_id;
566: p_tgnv_rec.id := p_talv_evt_rec.tve_id_offset;
567: OKC_TIME_pub.update_tpg_named(
568: p_api_version,
571: x_msg_count,
572: x_msg_data,
573: p_tgnv_rec,
574: x_tgnv_rec);
575: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
576: return;
577: end if;
578: x_talv_evt_rec := p_talv_evt_rec;
579: migrate(p_talv_evt_rec,p_talv_rec);
584: x_msg_count,
585: x_msg_data,
586: p_talv_rec,
587: x_talv_rec);
588: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
589: return;
590: end if;
591: migrate(x_talv_rec,x_talv_evt_rec);
592: END UPDATE_TPA_RELTV;
600: p_talv_rec talv_rec_type;
601: x_talv_rec talv_rec_type;
602: p_tgnv_rec tgnv_rec_type;
603: BEGIN
604: x_return_status := OKC_API.G_RET_STS_SUCCESS;
605: p_tgnv_rec.id := p_talv_evt_rec.tve_id_offset;
606: OKC_TIME_pub.delete_tpg_named(
607: p_api_version,
608: p_init_msg_list,
609: x_return_status,
610: x_msg_count,
611: x_msg_data,
612: p_tgnv_rec);
613: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
614: return;
615: end if;
616: migrate(p_talv_evt_rec,p_talv_rec);
617: okc_tal_pvt.delete_row(
630: x_msg_data OUT NOCOPY VARCHAR2,
631: p_talv_evt_rec IN talv_event_rec_type) IS
632: p_talv_rec talv_rec_type;
633: BEGIN
634: x_return_status := OKC_API.G_RET_STS_SUCCESS;
635: migrate(p_talv_evt_rec,p_talv_rec);
636: okc_tal_pvt.lock_row(
637: p_api_version,
638: p_init_msg_list,
651: p_talv_evt_rec IN talv_event_rec_type) IS
652: p_talv_rec talv_rec_type;
653: p_tgnv_rec tgnv_rec_type;
654: BEGIN
655: x_return_status := OKC_API.G_RET_STS_SUCCESS;
656: p_tgnv_rec.id := p_talv_evt_rec.tve_id_offset;
657: p_tgnv_rec.cnh_id := p_talv_evt_rec.cnh_id;
658: OKC_TIME_pub.valid_tpg_named(
659: p_api_version,
661: x_return_status,
662: x_msg_count,
663: x_msg_data,
664: p_tgnv_rec);
665: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
666: return;
667: end if;
668: migrate(p_talv_evt_rec,p_talv_rec);
669: okc_tal_pvt.validate_row(
869: x_tgdv_rec tgdv_rec_type;
870: p_isev_ext_rec isev_extended_rec_type;
871: x_isev_ext_rec isev_extended_rec_type;
872: BEGIN
873: x_return_status := OKC_API.G_RET_STS_SUCCESS;
874: x_tgdv_ext_rec := p_tgdv_ext_rec;
875: if p_tgdv_ext_rec.limited_start_date <> OKC_API.G_MISS_DATE and
876: p_tgdv_ext_rec.limited_start_date is not null and
877: p_tgdv_ext_rec.limited_end_date <> OKC_API.G_MISS_DATE and
871: x_isev_ext_rec isev_extended_rec_type;
872: BEGIN
873: x_return_status := OKC_API.G_RET_STS_SUCCESS;
874: x_tgdv_ext_rec := p_tgdv_ext_rec;
875: if p_tgdv_ext_rec.limited_start_date <> OKC_API.G_MISS_DATE and
876: p_tgdv_ext_rec.limited_start_date is not null and
877: p_tgdv_ext_rec.limited_end_date <> OKC_API.G_MISS_DATE and
878: p_tgdv_ext_rec.limited_end_date is not null then
879: p_isev_ext_rec.start_date := p_tgdv_ext_rec.limited_start_date;
873: x_return_status := OKC_API.G_RET_STS_SUCCESS;
874: x_tgdv_ext_rec := p_tgdv_ext_rec;
875: if p_tgdv_ext_rec.limited_start_date <> OKC_API.G_MISS_DATE and
876: p_tgdv_ext_rec.limited_start_date is not null and
877: p_tgdv_ext_rec.limited_end_date <> OKC_API.G_MISS_DATE and
878: p_tgdv_ext_rec.limited_end_date is not null then
879: p_isev_ext_rec.start_date := p_tgdv_ext_rec.limited_start_date;
880: p_isev_ext_rec.end_date := p_tgdv_ext_rec.limited_end_date;
881: p_isev_ext_rec.description := 'Limited by of Generic';
889: x_msg_count,
890: x_msg_data,
891: p_isev_ext_rec,
892: x_isev_ext_rec);
893: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
894: return;
895: end if;
896: x_tgdv_ext_rec.tve_id_limited := x_isev_ext_rec.id;
897: x_tgdv_ext_rec.limited_start_date := x_isev_ext_rec.start_date;
905: x_msg_count,
906: x_msg_data,
907: p_tgdv_rec,
908: x_tgdv_rec);
909: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
910: return;
911: end if;
912: migrate(x_tgdv_rec,x_tgdv_ext_rec);
913: END CREATE_TPG_DELIMITED;
937: WHERE id = p_id;
938: l_okc_limited okc_limited_csr%ROWTYPE;
939: l_okc_tve okc_tve_csr%ROWTYPE;
940: BEGIN
941: x_return_status := OKC_API.G_RET_STS_SUCCESS;
942: x_tgdv_ext_rec := p_tgdv_ext_rec;
943: OPEN okc_tve_csr(x_tgdv_ext_rec.id);
944: FETCH okc_tve_csr INTO l_okc_tve;
945: l_row_notfound := okc_tve_csr%NOTFOUND;
943: OPEN okc_tve_csr(x_tgdv_ext_rec.id);
944: FETCH okc_tve_csr INTO l_okc_tve;
945: l_row_notfound := okc_tve_csr%NOTFOUND;
946: CLOSE okc_tve_csr;
947: if (l_okc_tve.tve_id_limited = OKC_API.G_MISS_NUM or
948: l_okc_tve.tve_id_limited is NULL) then
949: if p_tgdv_ext_rec.limited_start_date <> OKC_API.G_MISS_DATE and
950: p_tgdv_ext_rec.limited_start_date is not null and
951: p_tgdv_ext_rec.limited_end_date <> OKC_API.G_MISS_DATE and
945: l_row_notfound := okc_tve_csr%NOTFOUND;
946: CLOSE okc_tve_csr;
947: if (l_okc_tve.tve_id_limited = OKC_API.G_MISS_NUM or
948: l_okc_tve.tve_id_limited is NULL) then
949: if p_tgdv_ext_rec.limited_start_date <> OKC_API.G_MISS_DATE and
950: p_tgdv_ext_rec.limited_start_date is not null and
951: p_tgdv_ext_rec.limited_end_date <> OKC_API.G_MISS_DATE and
952: p_tgdv_ext_rec.limited_end_date is not null then
953: p_isev_ext_rec.start_date := p_tgdv_ext_rec.limited_start_date;
947: if (l_okc_tve.tve_id_limited = OKC_API.G_MISS_NUM or
948: l_okc_tve.tve_id_limited is NULL) then
949: if p_tgdv_ext_rec.limited_start_date <> OKC_API.G_MISS_DATE and
950: p_tgdv_ext_rec.limited_start_date is not null and
951: p_tgdv_ext_rec.limited_end_date <> OKC_API.G_MISS_DATE and
952: p_tgdv_ext_rec.limited_end_date is not null then
953: p_isev_ext_rec.start_date := p_tgdv_ext_rec.limited_start_date;
954: p_isev_ext_rec.end_date := p_tgdv_ext_rec.limited_end_date;
955: p_isev_ext_rec.description := 'Limited by of Generic';
963: x_msg_count,
964: x_msg_data,
965: p_isev_ext_rec,
966: x_isev_ext_rec);
967: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
968: return;
969: end if;
970: x_tgdv_ext_rec.tve_id_limited := x_isev_ext_rec.id;
971: x_tgdv_ext_rec.limited_start_date := x_isev_ext_rec.start_date;
980: x_return_status,
981: x_msg_count,
982: x_msg_data,
983: p_isev_ext_rec);
984: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
985: return;
986: end if;
987: x_tgdv_ext_rec.tve_id_limited := NULL;
988: x_tgdv_ext_rec.limited_start_date := NULL;
992: FETCH okc_limited_csr INTO l_okc_limited;
993: l_row_notfound := okc_limited_csr%NOTFOUND;
994: CLOSE okc_limited_csr;
995: if (((l_okc_limited.start_date <> p_tgdv_ext_rec.limited_start_date) and
996: (p_tgdv_ext_rec.limited_start_date <> OKC_API.G_MISS_DATE)) or
997: ((l_okc_limited.end_date <> p_tgdv_ext_rec.limited_end_date) and
998: (p_tgdv_ext_rec.limited_end_date <> OKC_API.G_MISS_DATE))) then
999: p_isev_ext_rec.start_date := p_tgdv_ext_rec.limited_start_date;
1000: p_isev_ext_rec.end_date := p_tgdv_ext_rec.limited_end_date;
994: CLOSE okc_limited_csr;
995: if (((l_okc_limited.start_date <> p_tgdv_ext_rec.limited_start_date) and
996: (p_tgdv_ext_rec.limited_start_date <> OKC_API.G_MISS_DATE)) or
997: ((l_okc_limited.end_date <> p_tgdv_ext_rec.limited_end_date) and
998: (p_tgdv_ext_rec.limited_end_date <> OKC_API.G_MISS_DATE))) then
999: p_isev_ext_rec.start_date := p_tgdv_ext_rec.limited_start_date;
1000: p_isev_ext_rec.end_date := p_tgdv_ext_rec.limited_end_date;
1001: p_isev_ext_rec.id := l_okc_tve.tve_id_limited;
1002: OKC_TIME_pub.update_ia_startend(
1006: x_msg_count,
1007: x_msg_data,
1008: p_isev_ext_rec,
1009: x_isev_ext_rec);
1010: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
1011: return;
1012: end if;
1013: x_tgdv_ext_rec.tve_id_limited := x_isev_ext_rec.id;
1014: x_tgdv_ext_rec.limited_start_date := x_isev_ext_rec.start_date;
1024: x_msg_count,
1025: x_msg_data,
1026: p_tgdv_rec,
1027: x_tgdv_rec);
1028: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
1029: return;
1030: end if;
1031: migrate(x_tgdv_rec,x_tgdv_ext_rec);
1032: EXCEPTION
1030: end if;
1031: migrate(x_tgdv_rec,x_tgdv_ext_rec);
1032: EXCEPTION
1033: WHEN OTHERS THEN
1034: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1035: (l_api_name,
1036: G_PKG_NAME,
1037: 'OTHERS',
1038: x_msg_count,
1057: WHERE id = p_id
1058: AND tve_type = 'TGD';
1059: l_okc_limited okc_limited_csr%ROWTYPE;
1060: BEGIN
1061: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1062: OPEN okc_limited_csr(p_tgdv_ext_rec.id);
1063: FETCH okc_limited_csr INTO l_okc_limited;
1064: l_row_notfound := okc_limited_csr%NOTFOUND;
1065: CLOSE okc_limited_csr;
1063: FETCH okc_limited_csr INTO l_okc_limited;
1064: l_row_notfound := okc_limited_csr%NOTFOUND;
1065: CLOSE okc_limited_csr;
1066: if l_okc_limited.tve_id_limited is not null and
1067: l_okc_limited.tve_id_limited <> OKC_API.G_MISS_NUM then
1068: p_isev_ext_rec.id := l_okc_limited.tve_id_limited;
1069: OKC_TIME_pub.delete_ia_startend(
1070: p_api_version,
1071: p_init_msg_list,
1073: x_msg_count,
1074: x_msg_data,
1075: p_isev_ext_rec);
1076: end if;
1077: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
1078: return;
1079: end if;
1080: migrate(p_tgdv_ext_rec,p_tgdv_rec);
1081: okc_tgd_pvt.delete_row(
1113: x_msg_data OUT NOCOPY VARCHAR2,
1114: p_tgdv_ext_rec IN tgdv_extended_rec_type) IS
1115: p_tgdv_rec tgdv_rec_type;
1116: BEGIN
1117: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1118: migrate(p_tgdv_ext_rec,p_tgdv_rec);
1119: okc_tgd_pvt.validate_row(
1120: p_api_version,
1121: p_init_msg_list,
1407: x_tavv_rec tavv_rec_type;
1408: p_isev_rec isev_rec_type;
1409: x_isev_rec isev_rec_type;
1410: BEGIN
1411: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1412: if (p_isev_ext_rec.start_date > p_isev_ext_rec.end_date) and
1413: (p_isev_ext_rec.end_date is NOT NULL and p_isev_ext_rec.end_date <> OKC_API.G_MISS_DATE) then
1414: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1415: p_msg_name => G_DATE_ERROR,
1409: x_isev_rec isev_rec_type;
1410: BEGIN
1411: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1412: if (p_isev_ext_rec.start_date > p_isev_ext_rec.end_date) and
1413: (p_isev_ext_rec.end_date is NOT NULL and p_isev_ext_rec.end_date <> OKC_API.G_MISS_DATE) then
1414: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1415: p_msg_name => G_DATE_ERROR,
1416: p_token1 => G_COL_NAME_TOKEN,
1417: p_token1_value => 'START_DATE');
1410: BEGIN
1411: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1412: if (p_isev_ext_rec.start_date > p_isev_ext_rec.end_date) and
1413: (p_isev_ext_rec.end_date is NOT NULL and p_isev_ext_rec.end_date <> OKC_API.G_MISS_DATE) then
1414: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1415: p_msg_name => G_DATE_ERROR,
1416: p_token1 => G_COL_NAME_TOKEN,
1417: p_token1_value => 'START_DATE');
1418: x_return_status := OKC_API.G_RET_STS_ERROR;
1414: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1415: p_msg_name => G_DATE_ERROR,
1416: p_token1 => G_COL_NAME_TOKEN,
1417: p_token1_value => 'START_DATE');
1418: x_return_status := OKC_API.G_RET_STS_ERROR;
1419: return;
1420: end if;
1421: x_isev_ext_rec := p_isev_ext_rec;
1422: p_tavv_rec.datetime := p_isev_ext_rec.start_date;
1431: x_msg_count,
1432: x_msg_data,
1433: p_tavv_rec,
1434: x_tavv_rec);
1435: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
1436: return;
1437: end if;
1438: x_isev_ext_rec.tve_id_started := x_tavv_rec.id;
1439: if p_isev_ext_rec.duration is null or
1436: return;
1437: end if;
1438: x_isev_ext_rec.tve_id_started := x_tavv_rec.id;
1439: if p_isev_ext_rec.duration is null or
1440: p_isev_ext_rec.duration = OKC_API.G_MISS_NUM then
1441: if p_isev_ext_rec.end_date is NOT NULL and
1442: p_isev_ext_rec.end_date <> OKC_API.G_MISS_DATE then
1443: okc_time_util_pub.get_duration(p_isev_ext_rec.start_date, p_isev_ext_rec.end_date,x_isev_ext_rec.duration,
1444: x_isev_ext_rec.uom_code,x_return_status);
1438: x_isev_ext_rec.tve_id_started := x_tavv_rec.id;
1439: if p_isev_ext_rec.duration is null or
1440: p_isev_ext_rec.duration = OKC_API.G_MISS_NUM then
1441: if p_isev_ext_rec.end_date is NOT NULL and
1442: p_isev_ext_rec.end_date <> OKC_API.G_MISS_DATE then
1443: okc_time_util_pub.get_duration(p_isev_ext_rec.start_date, p_isev_ext_rec.end_date,x_isev_ext_rec.duration,
1444: x_isev_ext_rec.uom_code,x_return_status);
1445: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
1446: return;
1441: if p_isev_ext_rec.end_date is NOT NULL and
1442: p_isev_ext_rec.end_date <> OKC_API.G_MISS_DATE then
1443: okc_time_util_pub.get_duration(p_isev_ext_rec.start_date, p_isev_ext_rec.end_date,x_isev_ext_rec.duration,
1444: x_isev_ext_rec.uom_code,x_return_status);
1445: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
1446: return;
1447: end if;
1448: else
1449: x_isev_ext_rec.duration := NULL;
1458: x_msg_count,
1459: x_msg_data,
1460: p_isev_rec,
1461: x_isev_rec);
1462: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
1463: return;
1464: end if;
1465: migrate(x_isev_rec,x_isev_ext_rec);
1466: END CREATE_IA_STARTEND;
1485: FROM okc_time_ia_startend_val_v
1486: WHERE id = p_id ;
1487: l_okc_tve okc_tve_csr%ROWTYPE;
1488: BEGIN
1489: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1490: if (p_isev_ext_rec.start_date > p_isev_ext_rec.end_date) and
1491: (p_isev_ext_rec.end_date is NOT NULL and p_isev_ext_rec.end_date <> OKC_API.G_MISS_DATE) then
1492: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1493: p_msg_name => G_DATE_ERROR,
1487: l_okc_tve okc_tve_csr%ROWTYPE;
1488: BEGIN
1489: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1490: if (p_isev_ext_rec.start_date > p_isev_ext_rec.end_date) and
1491: (p_isev_ext_rec.end_date is NOT NULL and p_isev_ext_rec.end_date <> OKC_API.G_MISS_DATE) then
1492: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1493: p_msg_name => G_DATE_ERROR,
1494: p_token1 => G_COL_NAME_TOKEN,
1495: p_token1_value => 'START_DATE');
1488: BEGIN
1489: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1490: if (p_isev_ext_rec.start_date > p_isev_ext_rec.end_date) and
1491: (p_isev_ext_rec.end_date is NOT NULL and p_isev_ext_rec.end_date <> OKC_API.G_MISS_DATE) then
1492: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1493: p_msg_name => G_DATE_ERROR,
1494: p_token1 => G_COL_NAME_TOKEN,
1495: p_token1_value => 'START_DATE');
1496: x_return_status := OKC_API.G_RET_STS_ERROR;
1492: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1493: p_msg_name => G_DATE_ERROR,
1494: p_token1 => G_COL_NAME_TOKEN,
1495: p_token1_value => 'START_DATE');
1496: x_return_status := OKC_API.G_RET_STS_ERROR;
1497: return;
1498: end if;
1499: if p_isev_ext_rec.start_date is NULL then
1500: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1496: x_return_status := OKC_API.G_RET_STS_ERROR;
1497: return;
1498: end if;
1499: if p_isev_ext_rec.start_date is NULL then
1500: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1501: p_msg_name => G_DATE_ERROR,
1502: p_token1 => G_COL_NAME_TOKEN,
1503: p_token1_value => 'START_DATE');
1504: x_return_status := OKC_API.G_RET_STS_ERROR;
1500: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1501: p_msg_name => G_DATE_ERROR,
1502: p_token1 => G_COL_NAME_TOKEN,
1503: p_token1_value => 'START_DATE');
1504: x_return_status := OKC_API.G_RET_STS_ERROR;
1505: return;
1506: end if;
1507: x_isev_ext_rec := p_isev_ext_rec;
1508: IF (p_isev_ext_rec.start_date = OKC_API.G_MISS_DATE) then
1504: x_return_status := OKC_API.G_RET_STS_ERROR;
1505: return;
1506: end if;
1507: x_isev_ext_rec := p_isev_ext_rec;
1508: IF (p_isev_ext_rec.start_date = OKC_API.G_MISS_DATE) then
1509: OPEN okc_tve_csr(p_isev_ext_rec.id);
1510: FETCH okc_tve_csr INTO l_okc_tve;
1511: l_row_notfound := okc_tve_csr%NOTFOUND;
1512: CLOSE okc_tve_csr;
1510: FETCH okc_tve_csr INTO l_okc_tve;
1511: l_row_notfound := okc_tve_csr%NOTFOUND;
1512: CLOSE okc_tve_csr;
1513: IF (l_row_notfound) THEN
1514: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TVE_ID_STARTED');
1515: RAISE item_not_found_error;
1516: END IF;
1517: x_isev_ext_rec.start_date := l_okc_tve.start_date;
1518: END IF;
1516: END IF;
1517: x_isev_ext_rec.start_date := l_okc_tve.start_date;
1518: END IF;
1519: if p_isev_ext_rec.duration is null or
1520: p_isev_ext_rec.duration = OKC_API.G_MISS_NUM then
1521: if p_isev_ext_rec.end_date is NOT NULL and
1522: p_isev_ext_rec.end_date <> OKC_API.G_MISS_DATE then
1523: okc_time_util_pub.get_duration(x_isev_ext_rec.start_date, p_isev_ext_rec.end_date,x_isev_ext_rec.duration,
1524: x_isev_ext_rec.uom_code,x_return_status);
1518: END IF;
1519: if p_isev_ext_rec.duration is null or
1520: p_isev_ext_rec.duration = OKC_API.G_MISS_NUM then
1521: if p_isev_ext_rec.end_date is NOT NULL and
1522: p_isev_ext_rec.end_date <> OKC_API.G_MISS_DATE then
1523: okc_time_util_pub.get_duration(x_isev_ext_rec.start_date, p_isev_ext_rec.end_date,x_isev_ext_rec.duration,
1524: x_isev_ext_rec.uom_code,x_return_status);
1525: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
1526: return;
1521: if p_isev_ext_rec.end_date is NOT NULL and
1522: p_isev_ext_rec.end_date <> OKC_API.G_MISS_DATE then
1523: okc_time_util_pub.get_duration(x_isev_ext_rec.start_date, p_isev_ext_rec.end_date,x_isev_ext_rec.duration,
1524: x_isev_ext_rec.uom_code,x_return_status);
1525: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
1526: return;
1527: end if;
1528: elsif p_isev_ext_rec.end_date is NULL then
1529: x_isev_ext_rec.duration := NULL;
1538: x_msg_count,
1539: x_msg_data,
1540: p_isev_rec,
1541: x_isev_rec);
1542: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
1543: return;
1544: end if;
1545: migrate(x_isev_rec,x_isev_ext_rec);
1546: if (p_isev_ext_rec.start_date <> OKC_API.G_MISS_DATE) then
1542: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
1543: return;
1544: end if;
1545: migrate(x_isev_rec,x_isev_ext_rec);
1546: if (p_isev_ext_rec.start_date <> OKC_API.G_MISS_DATE) then
1547: p_tavv_rec.id := x_isev_rec.tve_id_started;
1548: p_tavv_rec.datetime := p_isev_ext_rec.start_date;
1549: OKC_TIME_pub.update_tpa_value(
1550: p_api_version,
1556: x_tavv_rec);
1557: end if;
1558: EXCEPTION
1559: WHEN item_not_found_error THEN
1560: x_return_status := OKC_API.G_RET_STS_ERROR;
1561: WHEN OTHERS THEN
1562: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1563: (l_api_name,
1564: G_PKG_NAME,
1558: EXCEPTION
1559: WHEN item_not_found_error THEN
1560: x_return_status := OKC_API.G_RET_STS_ERROR;
1561: WHEN OTHERS THEN
1562: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1563: (l_api_name,
1564: G_PKG_NAME,
1565: 'OTHERS',
1566: x_msg_count,
1588: l_api_name CONSTANT VARCHAR2(30) := 'delete_ia_startend';
1589: l_row_notfound BOOLEAN := TRUE;
1590: item_not_found_error EXCEPTION;
1591: BEGIN
1592: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1593: if p_isev_ext_rec.tve_id_started is NULL or
1594: p_isev_ext_rec.tve_id_started = OKC_API.G_MISS_NUM then
1595: OPEN okc_tve_csr(p_isev_ext_rec.id);
1596: FETCH okc_tve_csr INTO l_okc_tve;
1590: item_not_found_error EXCEPTION;
1591: BEGIN
1592: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1593: if p_isev_ext_rec.tve_id_started is NULL or
1594: p_isev_ext_rec.tve_id_started = OKC_API.G_MISS_NUM then
1595: OPEN okc_tve_csr(p_isev_ext_rec.id);
1596: FETCH okc_tve_csr INTO l_okc_tve;
1597: l_row_notfound := okc_tve_csr%NOTFOUND;
1598: CLOSE okc_tve_csr;
1596: FETCH okc_tve_csr INTO l_okc_tve;
1597: l_row_notfound := okc_tve_csr%NOTFOUND;
1598: CLOSE okc_tve_csr;
1599: IF (l_row_notfound) THEN
1600: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TVE_ID_STARTED');
1601: RAISE item_not_found_error;
1602: END IF;
1603: p_tavv_rec.id := l_okc_tve.tve_id_started;
1604: else
1610: x_return_status,
1611: x_msg_count,
1612: x_msg_data,
1613: p_tavv_rec);
1614: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
1615: return;
1616: end if;
1617: migrate(p_isev_ext_rec,p_isev_rec);
1618: okc_ise_pvt.delete_row(
1623: x_msg_data,
1624: p_isev_rec);
1625: EXCEPTION
1626: WHEN item_not_found_error THEN
1627: x_return_status := OKC_API.G_RET_STS_ERROR;
1628: WHEN OTHERS THEN
1629: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1630: (l_api_name,
1631: G_PKG_NAME,
1625: EXCEPTION
1626: WHEN item_not_found_error THEN
1627: x_return_status := OKC_API.G_RET_STS_ERROR;
1628: WHEN OTHERS THEN
1629: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1630: (l_api_name,
1631: G_PKG_NAME,
1632: 'OTHERS',
1633: x_msg_count,
1662: x_msg_data OUT NOCOPY VARCHAR2,
1663: p_isev_ext_rec IN isev_extended_rec_type) IS
1664: p_isev_rec isev_rec_type;
1665: BEGIN
1666: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1667: migrate(p_isev_ext_rec,p_isev_rec);
1668: okc_ise_pvt.validate_row(
1669: p_api_version,
1670: p_init_msg_list,
1689: l_api_name CONSTANT VARCHAR2(30) := 'create_ia_startend';
1690: l_row_notfound BOOLEAN := TRUE;
1691: item_not_found_error EXCEPTION;
1692: BEGIN
1693: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1694: x_isev_rel_rec := p_isev_rel_rec;
1695: p_talv_rec.tve_id_offset := p_isev_rel_rec.start_tve_id_offset;
1696: if p_isev_rel_rec.start_duration >= 0 then
1697: p_talv_rec.before_after := 'A';
1713: x_msg_count,
1714: x_msg_data,
1715: p_talv_rec,
1716: x_talv_rec);
1717: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
1718: return;
1719: end if;
1720: p_date := OKC_TIME_UTIL_PUB.get_enddate(p_isev_rel_rec.start_parent_date,
1721: p_isev_rel_rec.start_uom_code,
1723: if p_date is NULL THEN
1724: return;
1725: end if;
1726: if p_isev_rel_rec.end_date is NOT NULL and
1727: p_isev_rel_rec.end_date <> OKC_API.G_MISS_DATE then
1728: okc_time_util_pub.get_duration(p_date, p_isev_rel_rec.end_date,x_isev_rel_rec.duration,
1729: x_isev_rel_rec.uom_code,x_return_status);
1730: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
1731: return;
1726: if p_isev_rel_rec.end_date is NOT NULL and
1727: p_isev_rel_rec.end_date <> OKC_API.G_MISS_DATE then
1728: okc_time_util_pub.get_duration(p_date, p_isev_rel_rec.end_date,x_isev_rel_rec.duration,
1729: x_isev_rel_rec.uom_code,x_return_status);
1730: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
1731: return;
1732: end if;
1733: else
1734: x_isev_rel_rec.duration := NULL;
1743: x_msg_count,
1744: x_msg_data,
1745: p_isev_rec,
1746: x_isev_rec);
1747: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
1748: return;
1749: end if;
1750: migrate(x_isev_rec,x_isev_rel_rec);
1751: END CREATE_IA_STARTEND;
1765: l_row_notfound BOOLEAN := TRUE;
1766: l_api_name CONSTANT VARCHAR2(30) := 'update_ia_startend';
1767: p_date date;
1768: BEGIN
1769: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1770: x_isev_rel_rec := p_isev_rel_rec;
1771: p_date := OKC_TIME_UTIL_PUB.get_enddate(p_isev_rel_rec.start_parent_date,
1772: p_isev_rel_rec.start_uom_code,
1773: p_isev_rel_rec.start_duration);
1774: if p_date is NULL THEN
1775: return;
1776: end if;
1777: if p_isev_rel_rec.end_date is NOT NULL and
1778: p_isev_rel_rec.end_date <> OKC_API.G_MISS_DATE then
1779: okc_time_util_pub.get_duration(p_date, p_isev_rel_rec.end_date,x_isev_rel_rec.duration,
1780: x_isev_rel_rec.uom_code,x_return_status);
1781: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
1782: return;
1777: if p_isev_rel_rec.end_date is NOT NULL and
1778: p_isev_rel_rec.end_date <> OKC_API.G_MISS_DATE then
1779: okc_time_util_pub.get_duration(p_date, p_isev_rel_rec.end_date,x_isev_rel_rec.duration,
1780: x_isev_rel_rec.uom_code,x_return_status);
1781: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
1782: return;
1783: end if;
1784: elsif p_isev_rel_rec.end_date is NULL then
1785: x_isev_rel_rec.duration := NULL;
1793: x_msg_count,
1794: x_msg_data,
1795: p_isev_rec,
1796: x_isev_rec);
1797: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
1798: return;
1799: end if;
1800: migrate(x_isev_rec,x_isev_rel_rec);
1801: p_talv_rec.id := x_isev_rel_rec.tve_id_started;
1839: l_api_name CONSTANT VARCHAR2(30) := 'delete_ia_startend';
1840: l_row_notfound BOOLEAN := TRUE;
1841: item_not_found_error EXCEPTION;
1842: BEGIN
1843: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1844: if p_isev_rel_rec.tve_id_started is NULL or
1845: p_isev_rel_rec.tve_id_started = OKC_API.G_MISS_NUM then
1846: OPEN okc_tve_csr(p_isev_rel_rec.id);
1847: FETCH okc_tve_csr INTO l_okc_tve;
1841: item_not_found_error EXCEPTION;
1842: BEGIN
1843: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1844: if p_isev_rel_rec.tve_id_started is NULL or
1845: p_isev_rel_rec.tve_id_started = OKC_API.G_MISS_NUM then
1846: OPEN okc_tve_csr(p_isev_rel_rec.id);
1847: FETCH okc_tve_csr INTO l_okc_tve;
1848: l_row_notfound := okc_tve_csr%NOTFOUND;
1849: CLOSE okc_tve_csr;
1847: FETCH okc_tve_csr INTO l_okc_tve;
1848: l_row_notfound := okc_tve_csr%NOTFOUND;
1849: CLOSE okc_tve_csr;
1850: IF (l_row_notfound) THEN
1851: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TVE_ID_STARTED');
1852: RAISE item_not_found_error;
1853: END IF;
1854: p_talv_rec.id := l_okc_tve.tve_id_started;
1855: else
1861: x_return_status,
1862: x_msg_count,
1863: x_msg_data,
1864: p_talv_rec);
1865: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
1866: return;
1867: end if;
1868: migrate(p_isev_rel_rec,p_isev_rec);
1869: okc_ise_pvt.delete_row(
1901: x_msg_data OUT NOCOPY VARCHAR2,
1902: p_isev_rel_rec IN isev_reltv_rec_type) IS
1903: p_isev_rec isev_rec_type;
1904: BEGIN
1905: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1906: migrate(p_isev_rel_rec,p_isev_rec);
1907: okc_ise_pvt.validate_row(
1908: p_api_version,
1909: p_init_msg_list,
2006: x_tgdv_ext_rec tgdv_extended_rec_type;
2007: p_igsv_rec igsv_rec_type;
2008: x_igsv_rec igsv_rec_type;
2009: BEGIN
2010: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2011: x_igsv_ext_rec := p_igsv_ext_rec;
2012: p_tgdv_ext_rec.month := p_igsv_ext_rec.start_month;
2013: p_tgdv_ext_rec.day := p_igsv_ext_rec.start_day;
2014: p_tgdv_ext_rec.day_of_week := p_igsv_ext_rec.start_day_of_week;
2027: x_msg_count,
2028: x_msg_data,
2029: p_tgdv_ext_rec,
2030: x_tgdv_ext_rec);
2031: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
2032: return;
2033: end if;
2034: x_igsv_ext_rec.tve_id_started := x_tgdv_ext_rec.id;
2035: p_tgdv_ext_rec.month := p_igsv_ext_rec.end_month;
2050: x_msg_count,
2051: x_msg_data,
2052: p_tgdv_ext_rec,
2053: x_tgdv_ext_rec);
2054: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
2055: return;
2056: end if;
2057: x_igsv_ext_rec.tve_id_ended := x_tgdv_ext_rec.id;
2058: migrate(x_igsv_ext_rec,p_igsv_rec);
2063: x_msg_count,
2064: x_msg_data,
2065: p_igsv_rec,
2066: x_igsv_rec);
2067: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
2068: return;
2069: end if;
2070: migrate(x_igsv_rec,x_igsv_ext_rec);
2071: END CREATE_IG_STARTEND;
2082: x_tgdv_ext_rec tgdv_extended_rec_type;
2083: p_igsv_rec igsv_rec_type;
2084: x_igsv_rec igsv_rec_type;
2085: BEGIN
2086: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2087: x_igsv_ext_rec := p_igsv_ext_rec;
2088: migrate(p_igsv_ext_rec,p_igsv_rec);
2089: okc_igs_pvt.update_row(
2090: p_api_version,
2093: x_msg_count,
2094: x_msg_data,
2095: p_igsv_rec,
2096: x_igsv_rec);
2097: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
2098: return;
2099: end if;
2100: migrate(x_igsv_rec,x_igsv_ext_rec);
2101: p_tgdv_ext_rec.id := x_igsv_ext_rec.tve_id_started;
2113: x_msg_count,
2114: x_msg_data,
2115: p_tgdv_ext_rec,
2116: x_tgdv_ext_rec);
2117: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
2118: return;
2119: end if;
2120: p_tgdv_ext_rec.id := x_igsv_ext_rec.tve_id_ended;
2121: p_tgdv_ext_rec.month := p_igsv_ext_rec.end_month;
2145: x_igsv_rec igsv_rec_type;
2146: p_tgdv_ext_rec tgdv_extended_rec_type;
2147: x_tgdv_ext_rec tgdv_extended_rec_type;
2148: BEGIN
2149: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2150: migrate(p_igsv_ext_rec,p_igsv_rec);
2151: okc_igs_pvt.delete_row(
2152: p_api_version,
2153: p_init_msg_list,
2154: x_return_status,
2155: x_msg_count,
2156: x_msg_data,
2157: p_igsv_rec);
2158: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
2159: return;
2160: end if;
2161: p_tgdv_ext_rec.id := p_igsv_rec.tve_id_started;
2162: OKC_TIME_pub.delete_tpg_delimited(
2165: x_return_status,
2166: x_msg_count,
2167: x_msg_data,
2168: p_tgdv_ext_rec);
2169: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
2170: return;
2171: end if;
2172: p_tgdv_ext_rec.id := p_igsv_rec.tve_id_ended;
2173: OKC_TIME_pub.delete_tpg_delimited(
2176: x_return_status,
2177: x_msg_count,
2178: x_msg_data,
2179: p_tgdv_ext_rec);
2180: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
2181: return;
2182: end if;
2183: END DELETE_IG_STARTEND;
2184: PROCEDURE LOCK_IG_STARTEND(
2208: x_msg_data OUT NOCOPY VARCHAR2,
2209: p_igsv_ext_rec IN igsv_extended_rec_type) IS
2210: p_igsv_rec igsv_rec_type;
2211: BEGIN
2212: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2213: migrate(p_igsv_ext_rec,p_igsv_rec);
2214: okc_igs_pvt.validate_row(
2215: p_api_version,
2216: p_init_msg_list,
2588: x_spnv_rec spnv_rec_type;
2589: p_isev_ext_rec isev_extended_rec_type;
2590: x_isev_ext_rec isev_extended_rec_type;
2591: BEGIN
2592: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2593: x_cylv_ext_rec := p_cylv_ext_rec;
2594: if p_cylv_ext_rec.limited_start_date <> OKC_API.G_MISS_DATE and
2595: p_cylv_ext_rec.limited_start_date is not null and
2596: p_cylv_ext_rec.limited_end_date <> OKC_API.G_MISS_DATE and
2590: x_isev_ext_rec isev_extended_rec_type;
2591: BEGIN
2592: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2593: x_cylv_ext_rec := p_cylv_ext_rec;
2594: if p_cylv_ext_rec.limited_start_date <> OKC_API.G_MISS_DATE and
2595: p_cylv_ext_rec.limited_start_date is not null and
2596: p_cylv_ext_rec.limited_end_date <> OKC_API.G_MISS_DATE and
2597: p_cylv_ext_rec.limited_end_date is not null then
2598: p_isev_ext_rec.start_date := p_cylv_ext_rec.limited_start_date;
2592: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2593: x_cylv_ext_rec := p_cylv_ext_rec;
2594: if p_cylv_ext_rec.limited_start_date <> OKC_API.G_MISS_DATE and
2595: p_cylv_ext_rec.limited_start_date is not null and
2596: p_cylv_ext_rec.limited_end_date <> OKC_API.G_MISS_DATE and
2597: p_cylv_ext_rec.limited_end_date is not null then
2598: p_isev_ext_rec.start_date := p_cylv_ext_rec.limited_start_date;
2599: p_isev_ext_rec.end_date := p_cylv_ext_rec.limited_end_date;
2600: p_isev_ext_rec.description := 'Limited by of Cycle';
2608: x_msg_count,
2609: x_msg_data,
2610: p_isev_ext_rec,
2611: x_isev_ext_rec);
2612: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
2613: return;
2614: end if;
2615: x_cylv_ext_rec.tve_id_limited := x_isev_ext_rec.id;
2616: x_cylv_ext_rec.limited_start_date := x_isev_ext_rec.start_date;
2624: x_msg_count,
2625: x_msg_data,
2626: p_cylv_rec,
2627: x_cylv_rec);
2628: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
2629: return;
2630: end if;
2631: migrate(x_cylv_rec,x_cylv_ext_rec);
2632: p_spnv_rec.uom_code := x_cylv_ext_rec.uom_code;
2641: x_msg_count,
2642: x_msg_data,
2643: p_spnv_rec,
2644: x_spnv_rec);
2645: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
2646: return;
2647: end if;
2648: x_cylv_ext_rec.uom_code := x_spnv_rec.uom_code;
2649: x_cylv_ext_rec.duration := x_spnv_rec.duration;
2684: WHERE id = p_id;
2685: l_okc_limited okc_limited_csr%ROWTYPE;
2686: l_okc_tve okc_tve_csr%ROWTYPE;
2687: BEGIN
2688: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2689: x_cylv_ext_rec := p_cylv_ext_rec;
2690: OPEN okc_tve_csr(x_cylv_ext_rec.id);
2691: FETCH okc_tve_csr INTO l_okc_tve;
2692: l_row_notfound := okc_tve_csr%NOTFOUND;
2690: OPEN okc_tve_csr(x_cylv_ext_rec.id);
2691: FETCH okc_tve_csr INTO l_okc_tve;
2692: l_row_notfound := okc_tve_csr%NOTFOUND;
2693: CLOSE okc_tve_csr;
2694: if (l_okc_tve.tve_id_limited = OKC_API.G_MISS_NUM or
2695: l_okc_tve.tve_id_limited is NULL) then
2696: if p_cylv_ext_rec.limited_start_date <> OKC_API.G_MISS_DATE and
2697: p_cylv_ext_rec.limited_start_date is not null and
2698: p_cylv_ext_rec.limited_end_date <> OKC_API.G_MISS_DATE and
2692: l_row_notfound := okc_tve_csr%NOTFOUND;
2693: CLOSE okc_tve_csr;
2694: if (l_okc_tve.tve_id_limited = OKC_API.G_MISS_NUM or
2695: l_okc_tve.tve_id_limited is NULL) then
2696: if p_cylv_ext_rec.limited_start_date <> OKC_API.G_MISS_DATE and
2697: p_cylv_ext_rec.limited_start_date is not null and
2698: p_cylv_ext_rec.limited_end_date <> OKC_API.G_MISS_DATE and
2699: p_cylv_ext_rec.limited_end_date is not null then
2700: p_isev_ext_rec.start_date := p_cylv_ext_rec.limited_start_date;
2694: if (l_okc_tve.tve_id_limited = OKC_API.G_MISS_NUM or
2695: l_okc_tve.tve_id_limited is NULL) then
2696: if p_cylv_ext_rec.limited_start_date <> OKC_API.G_MISS_DATE and
2697: p_cylv_ext_rec.limited_start_date is not null and
2698: p_cylv_ext_rec.limited_end_date <> OKC_API.G_MISS_DATE and
2699: p_cylv_ext_rec.limited_end_date is not null then
2700: p_isev_ext_rec.start_date := p_cylv_ext_rec.limited_start_date;
2701: p_isev_ext_rec.end_date := p_cylv_ext_rec.limited_end_date;
2702: p_isev_ext_rec.description := 'Limited by of Generic';
2710: x_msg_count,
2711: x_msg_data,
2712: p_isev_ext_rec,
2713: x_isev_ext_rec);
2714: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
2715: return;
2716: end if;
2717: x_cylv_ext_rec.tve_id_limited := x_isev_ext_rec.id;
2718: end if;
2725: x_return_status,
2726: x_msg_count,
2727: x_msg_data,
2728: p_isev_ext_rec);
2729: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
2730: return;
2731: end if;
2732: x_cylv_ext_rec.tve_id_limited := NULL;
2733: else
2735: FETCH okc_limited_csr INTO l_okc_limited;
2736: l_row_notfound := okc_limited_csr%NOTFOUND;
2737: CLOSE okc_limited_csr;
2738: if (((l_okc_limited.start_date <> p_cylv_ext_rec.limited_start_date) and
2739: (p_cylv_ext_rec.limited_start_date <> OKC_API.G_MISS_DATE)) or
2740: ((l_okc_limited.end_date <> p_cylv_ext_rec.limited_end_date) and
2741: (p_cylv_ext_rec.limited_end_date <> OKC_API.G_MISS_DATE))) then
2742: p_isev_ext_rec.start_date := p_cylv_ext_rec.limited_start_date;
2743: p_isev_ext_rec.end_date := p_cylv_ext_rec.limited_end_date;
2737: CLOSE okc_limited_csr;
2738: if (((l_okc_limited.start_date <> p_cylv_ext_rec.limited_start_date) and
2739: (p_cylv_ext_rec.limited_start_date <> OKC_API.G_MISS_DATE)) or
2740: ((l_okc_limited.end_date <> p_cylv_ext_rec.limited_end_date) and
2741: (p_cylv_ext_rec.limited_end_date <> OKC_API.G_MISS_DATE))) then
2742: p_isev_ext_rec.start_date := p_cylv_ext_rec.limited_start_date;
2743: p_isev_ext_rec.end_date := p_cylv_ext_rec.limited_end_date;
2744: p_isev_ext_rec.id := l_okc_tve.tve_id_limited;
2745: OKC_TIME_pub.update_ia_startend(
2749: x_msg_count,
2750: x_msg_data,
2751: p_isev_ext_rec,
2752: x_isev_ext_rec);
2753: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
2754: return;
2755: end if;
2756: end if;
2757: end if;
2764: x_msg_count,
2765: x_msg_data,
2766: p_cylv_rec,
2767: x_cylv_rec);
2768: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
2769: return;
2770: end if;
2771: migrate(x_cylv_rec,x_cylv_ext_rec);
2772: p_spnv_rec.tve_id := x_cylv_ext_rec.id;
2806: WHERE id = p_id
2807: AND tve_type = 'CYL';
2808: l_okc_limited okc_limited_csr%ROWTYPE;
2809: BEGIN
2810: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2811: OPEN okc_limited_csr(p_cylv_ext_rec.id);
2812: FETCH okc_limited_csr INTO l_okc_limited;
2813: l_row_notfound := okc_limited_csr%NOTFOUND;
2814: CLOSE okc_limited_csr;
2812: FETCH okc_limited_csr INTO l_okc_limited;
2813: l_row_notfound := okc_limited_csr%NOTFOUND;
2814: CLOSE okc_limited_csr;
2815: if l_okc_limited.tve_id_limited is not null and
2816: l_okc_limited.tve_id_limited <> OKC_API.G_MISS_NUM then
2817: p_isev_ext_rec.id := l_okc_limited.tve_id_limited;
2818: OKC_TIME_pub.delete_ia_startend(
2819: p_api_version,
2820: p_init_msg_list,
2821: x_return_status,
2822: x_msg_count,
2823: x_msg_data,
2824: p_isev_ext_rec);
2825: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
2826: return;
2827: end if;
2828: end if;
2829: if p_cylv_rec.spn_id is not null and
2826: return;
2827: end if;
2828: end if;
2829: if p_cylv_rec.spn_id is not null and
2830: p_cylv_rec.spn_id <> OKC_API.G_MISS_NUM Then
2831: p_spnv_rec.id := p_cylv_rec.spn_id;
2832: else
2833: p_spnv_rec.id := l_okc_limited.spn_id;
2834: end if;
2838: x_return_status,
2839: x_msg_count,
2840: x_msg_data,
2841: p_spnv_rec);
2842: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
2843: return;
2844: end if;
2845: migrate(p_cylv_ext_rec,p_cylv_rec);
2846: okc_cyl_pvt.delete_row(
2849: x_return_status,
2850: x_msg_count,
2851: x_msg_data,
2852: p_cylv_rec);
2853: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
2854: return;
2855: end if;
2856: END DELETE_CYCLE;
2857:
2864: p_cylv_ext_rec IN cylv_extended_rec_type) IS
2865: p_cylv_rec cylv_rec_type;
2866: p_spnv_rec spnv_rec_type;
2867: BEGIN
2868: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2869: migrate(p_cylv_ext_rec,p_cylv_rec);
2870: okc_cyl_pvt.lock_row(
2871: p_api_version,
2872: p_init_msg_list,
2885: p_cylv_ext_rec IN cylv_extended_rec_type) IS
2886: p_cylv_rec cylv_rec_type;
2887: p_spnv_rec spnv_rec_type;
2888: BEGIN
2889: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2890: migrate(p_cylv_ext_rec,p_cylv_rec);
2891: okc_cyl_pvt.validate_row(
2892: p_api_version,
2893: p_init_msg_list,
2894: x_return_status,
2895: x_msg_count,
2896: x_msg_data,
2897: p_cylv_rec);
2898: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
2899: return;
2900: end if;
2901: p_spnv_rec.id := p_cylv_rec.spn_id;
2902: OKC_TIME_pub.valid_span(
3193: short_description,
3194: comments
3195: )
3196: VALUES (
3197: DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
3198: DECODE(in_spn_id(i),OKC_API.G_MISS_NUM,NULL,in_spn_id(i)),
3199: DECODE(in_tve_id_offset(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_offset(i)),
3200: DECODE(in_tve_id_generated_by(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_generated_by(i)),
3201: DECODE(in_tve_id_started(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_started(i)),
3194: comments
3195: )
3196: VALUES (
3197: DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
3198: DECODE(in_spn_id(i),OKC_API.G_MISS_NUM,NULL,in_spn_id(i)),
3199: DECODE(in_tve_id_offset(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_offset(i)),
3200: DECODE(in_tve_id_generated_by(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_generated_by(i)),
3201: DECODE(in_tve_id_started(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_started(i)),
3202: DECODE(in_tve_id_ended(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_ended(i)),
3195: )
3196: VALUES (
3197: DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
3198: DECODE(in_spn_id(i),OKC_API.G_MISS_NUM,NULL,in_spn_id(i)),
3199: DECODE(in_tve_id_offset(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_offset(i)),
3200: DECODE(in_tve_id_generated_by(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_generated_by(i)),
3201: DECODE(in_tve_id_started(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_started(i)),
3202: DECODE(in_tve_id_ended(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_ended(i)),
3203: DECODE(in_tve_id_limited(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_limited(i)),
3196: VALUES (
3197: DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
3198: DECODE(in_spn_id(i),OKC_API.G_MISS_NUM,NULL,in_spn_id(i)),
3199: DECODE(in_tve_id_offset(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_offset(i)),
3200: DECODE(in_tve_id_generated_by(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_generated_by(i)),
3201: DECODE(in_tve_id_started(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_started(i)),
3202: DECODE(in_tve_id_ended(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_ended(i)),
3203: DECODE(in_tve_id_limited(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_limited(i)),
3204: DECODE(in_cnh_id(i),OKC_API.G_MISS_NUM,NULL,in_cnh_id(i)),
3197: DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
3198: DECODE(in_spn_id(i),OKC_API.G_MISS_NUM,NULL,in_spn_id(i)),
3199: DECODE(in_tve_id_offset(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_offset(i)),
3200: DECODE(in_tve_id_generated_by(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_generated_by(i)),
3201: DECODE(in_tve_id_started(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_started(i)),
3202: DECODE(in_tve_id_ended(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_ended(i)),
3203: DECODE(in_tve_id_limited(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_limited(i)),
3204: DECODE(in_cnh_id(i),OKC_API.G_MISS_NUM,NULL,in_cnh_id(i)),
3205: DECODE(in_dnz_chr_id(i),OKC_API.G_MISS_NUM,NULL,in_dnz_chr_id(i)),
3198: DECODE(in_spn_id(i),OKC_API.G_MISS_NUM,NULL,in_spn_id(i)),
3199: DECODE(in_tve_id_offset(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_offset(i)),
3200: DECODE(in_tve_id_generated_by(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_generated_by(i)),
3201: DECODE(in_tve_id_started(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_started(i)),
3202: DECODE(in_tve_id_ended(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_ended(i)),
3203: DECODE(in_tve_id_limited(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_limited(i)),
3204: DECODE(in_cnh_id(i),OKC_API.G_MISS_NUM,NULL,in_cnh_id(i)),
3205: DECODE(in_dnz_chr_id(i),OKC_API.G_MISS_NUM,NULL,in_dnz_chr_id(i)),
3206: DECODE(in_tve_type(i),OKC_API.G_MISS_CHAR,NULL,in_tve_type(i)),
3199: DECODE(in_tve_id_offset(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_offset(i)),
3200: DECODE(in_tve_id_generated_by(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_generated_by(i)),
3201: DECODE(in_tve_id_started(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_started(i)),
3202: DECODE(in_tve_id_ended(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_ended(i)),
3203: DECODE(in_tve_id_limited(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_limited(i)),
3204: DECODE(in_cnh_id(i),OKC_API.G_MISS_NUM,NULL,in_cnh_id(i)),
3205: DECODE(in_dnz_chr_id(i),OKC_API.G_MISS_NUM,NULL,in_dnz_chr_id(i)),
3206: DECODE(in_tve_type(i),OKC_API.G_MISS_CHAR,NULL,in_tve_type(i)),
3207: DECODE(in_tze_id(i),OKC_API.G_MISS_NUM,NULL,in_tze_id(i)),
3200: DECODE(in_tve_id_generated_by(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_generated_by(i)),
3201: DECODE(in_tve_id_started(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_started(i)),
3202: DECODE(in_tve_id_ended(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_ended(i)),
3203: DECODE(in_tve_id_limited(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_limited(i)),
3204: DECODE(in_cnh_id(i),OKC_API.G_MISS_NUM,NULL,in_cnh_id(i)),
3205: DECODE(in_dnz_chr_id(i),OKC_API.G_MISS_NUM,NULL,in_dnz_chr_id(i)),
3206: DECODE(in_tve_type(i),OKC_API.G_MISS_CHAR,NULL,in_tve_type(i)),
3207: DECODE(in_tze_id(i),OKC_API.G_MISS_NUM,NULL,in_tze_id(i)),
3208: DECODE(in_object_version_number(i),OKC_API.G_MISS_NUM,NULL,in_object_version_number(i)),
3201: DECODE(in_tve_id_started(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_started(i)),
3202: DECODE(in_tve_id_ended(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_ended(i)),
3203: DECODE(in_tve_id_limited(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_limited(i)),
3204: DECODE(in_cnh_id(i),OKC_API.G_MISS_NUM,NULL,in_cnh_id(i)),
3205: DECODE(in_dnz_chr_id(i),OKC_API.G_MISS_NUM,NULL,in_dnz_chr_id(i)),
3206: DECODE(in_tve_type(i),OKC_API.G_MISS_CHAR,NULL,in_tve_type(i)),
3207: DECODE(in_tze_id(i),OKC_API.G_MISS_NUM,NULL,in_tze_id(i)),
3208: DECODE(in_object_version_number(i),OKC_API.G_MISS_NUM,NULL,in_object_version_number(i)),
3209: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3202: DECODE(in_tve_id_ended(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_ended(i)),
3203: DECODE(in_tve_id_limited(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_limited(i)),
3204: DECODE(in_cnh_id(i),OKC_API.G_MISS_NUM,NULL,in_cnh_id(i)),
3205: DECODE(in_dnz_chr_id(i),OKC_API.G_MISS_NUM,NULL,in_dnz_chr_id(i)),
3206: DECODE(in_tve_type(i),OKC_API.G_MISS_CHAR,NULL,in_tve_type(i)),
3207: DECODE(in_tze_id(i),OKC_API.G_MISS_NUM,NULL,in_tze_id(i)),
3208: DECODE(in_object_version_number(i),OKC_API.G_MISS_NUM,NULL,in_object_version_number(i)),
3209: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3210: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3203: DECODE(in_tve_id_limited(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_limited(i)),
3204: DECODE(in_cnh_id(i),OKC_API.G_MISS_NUM,NULL,in_cnh_id(i)),
3205: DECODE(in_dnz_chr_id(i),OKC_API.G_MISS_NUM,NULL,in_dnz_chr_id(i)),
3206: DECODE(in_tve_type(i),OKC_API.G_MISS_CHAR,NULL,in_tve_type(i)),
3207: DECODE(in_tze_id(i),OKC_API.G_MISS_NUM,NULL,in_tze_id(i)),
3208: DECODE(in_object_version_number(i),OKC_API.G_MISS_NUM,NULL,in_object_version_number(i)),
3209: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3210: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3211: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3204: DECODE(in_cnh_id(i),OKC_API.G_MISS_NUM,NULL,in_cnh_id(i)),
3205: DECODE(in_dnz_chr_id(i),OKC_API.G_MISS_NUM,NULL,in_dnz_chr_id(i)),
3206: DECODE(in_tve_type(i),OKC_API.G_MISS_CHAR,NULL,in_tve_type(i)),
3207: DECODE(in_tze_id(i),OKC_API.G_MISS_NUM,NULL,in_tze_id(i)),
3208: DECODE(in_object_version_number(i),OKC_API.G_MISS_NUM,NULL,in_object_version_number(i)),
3209: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3210: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3211: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3212: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3205: DECODE(in_dnz_chr_id(i),OKC_API.G_MISS_NUM,NULL,in_dnz_chr_id(i)),
3206: DECODE(in_tve_type(i),OKC_API.G_MISS_CHAR,NULL,in_tve_type(i)),
3207: DECODE(in_tze_id(i),OKC_API.G_MISS_NUM,NULL,in_tze_id(i)),
3208: DECODE(in_object_version_number(i),OKC_API.G_MISS_NUM,NULL,in_object_version_number(i)),
3209: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3210: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3211: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3212: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3213: DECODE(in_uom_code(i),OKC_API.G_MISS_CHAR,NULL,in_uom_code(i)),
3206: DECODE(in_tve_type(i),OKC_API.G_MISS_CHAR,NULL,in_tve_type(i)),
3207: DECODE(in_tze_id(i),OKC_API.G_MISS_NUM,NULL,in_tze_id(i)),
3208: DECODE(in_object_version_number(i),OKC_API.G_MISS_NUM,NULL,in_object_version_number(i)),
3209: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3210: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3211: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3212: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3213: DECODE(in_uom_code(i),OKC_API.G_MISS_CHAR,NULL,in_uom_code(i)),
3214: DECODE(in_duration(i),OKC_API.G_MISS_NUM,NULL,in_duration(i)),
3207: DECODE(in_tze_id(i),OKC_API.G_MISS_NUM,NULL,in_tze_id(i)),
3208: DECODE(in_object_version_number(i),OKC_API.G_MISS_NUM,NULL,in_object_version_number(i)),
3209: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3210: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3211: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3212: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3213: DECODE(in_uom_code(i),OKC_API.G_MISS_CHAR,NULL,in_uom_code(i)),
3214: DECODE(in_duration(i),OKC_API.G_MISS_NUM,NULL,in_duration(i)),
3215: DECODE(in_operator(i),OKC_API.G_MISS_CHAR,NULL,in_operator(i)),
3208: DECODE(in_object_version_number(i),OKC_API.G_MISS_NUM,NULL,in_object_version_number(i)),
3209: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3210: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3211: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3212: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3213: DECODE(in_uom_code(i),OKC_API.G_MISS_CHAR,NULL,in_uom_code(i)),
3214: DECODE(in_duration(i),OKC_API.G_MISS_NUM,NULL,in_duration(i)),
3215: DECODE(in_operator(i),OKC_API.G_MISS_CHAR,NULL,in_operator(i)),
3216: DECODE(in_before_after(i),OKC_API.G_MISS_CHAR,NULL,in_before_after(i)),
3209: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3210: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3211: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3212: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3213: DECODE(in_uom_code(i),OKC_API.G_MISS_CHAR,NULL,in_uom_code(i)),
3214: DECODE(in_duration(i),OKC_API.G_MISS_NUM,NULL,in_duration(i)),
3215: DECODE(in_operator(i),OKC_API.G_MISS_CHAR,NULL,in_operator(i)),
3216: DECODE(in_before_after(i),OKC_API.G_MISS_CHAR,NULL,in_before_after(i)),
3217: DECODE(in_datetime(i),OKC_API.G_MISS_DATE,NULL,in_datetime(i)),
3210: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3211: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3212: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3213: DECODE(in_uom_code(i),OKC_API.G_MISS_CHAR,NULL,in_uom_code(i)),
3214: DECODE(in_duration(i),OKC_API.G_MISS_NUM,NULL,in_duration(i)),
3215: DECODE(in_operator(i),OKC_API.G_MISS_CHAR,NULL,in_operator(i)),
3216: DECODE(in_before_after(i),OKC_API.G_MISS_CHAR,NULL,in_before_after(i)),
3217: DECODE(in_datetime(i),OKC_API.G_MISS_DATE,NULL,in_datetime(i)),
3218: DECODE(in_month(i),OKC_API.G_MISS_NUM,NULL,in_month(i)),
3211: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3212: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3213: DECODE(in_uom_code(i),OKC_API.G_MISS_CHAR,NULL,in_uom_code(i)),
3214: DECODE(in_duration(i),OKC_API.G_MISS_NUM,NULL,in_duration(i)),
3215: DECODE(in_operator(i),OKC_API.G_MISS_CHAR,NULL,in_operator(i)),
3216: DECODE(in_before_after(i),OKC_API.G_MISS_CHAR,NULL,in_before_after(i)),
3217: DECODE(in_datetime(i),OKC_API.G_MISS_DATE,NULL,in_datetime(i)),
3218: DECODE(in_month(i),OKC_API.G_MISS_NUM,NULL,in_month(i)),
3219: DECODE(in_day(i),OKC_API.G_MISS_NUM,NULL,in_day(i)),
3212: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3213: DECODE(in_uom_code(i),OKC_API.G_MISS_CHAR,NULL,in_uom_code(i)),
3214: DECODE(in_duration(i),OKC_API.G_MISS_NUM,NULL,in_duration(i)),
3215: DECODE(in_operator(i),OKC_API.G_MISS_CHAR,NULL,in_operator(i)),
3216: DECODE(in_before_after(i),OKC_API.G_MISS_CHAR,NULL,in_before_after(i)),
3217: DECODE(in_datetime(i),OKC_API.G_MISS_DATE,NULL,in_datetime(i)),
3218: DECODE(in_month(i),OKC_API.G_MISS_NUM,NULL,in_month(i)),
3219: DECODE(in_day(i),OKC_API.G_MISS_NUM,NULL,in_day(i)),
3220: DECODE(in_hour(i),OKC_API.G_MISS_NUM,NULL,in_hour(i)),
3213: DECODE(in_uom_code(i),OKC_API.G_MISS_CHAR,NULL,in_uom_code(i)),
3214: DECODE(in_duration(i),OKC_API.G_MISS_NUM,NULL,in_duration(i)),
3215: DECODE(in_operator(i),OKC_API.G_MISS_CHAR,NULL,in_operator(i)),
3216: DECODE(in_before_after(i),OKC_API.G_MISS_CHAR,NULL,in_before_after(i)),
3217: DECODE(in_datetime(i),OKC_API.G_MISS_DATE,NULL,in_datetime(i)),
3218: DECODE(in_month(i),OKC_API.G_MISS_NUM,NULL,in_month(i)),
3219: DECODE(in_day(i),OKC_API.G_MISS_NUM,NULL,in_day(i)),
3220: DECODE(in_hour(i),OKC_API.G_MISS_NUM,NULL,in_hour(i)),
3221: DECODE(in_minute(i),OKC_API.G_MISS_NUM,NULL,in_minute(i)),
3214: DECODE(in_duration(i),OKC_API.G_MISS_NUM,NULL,in_duration(i)),
3215: DECODE(in_operator(i),OKC_API.G_MISS_CHAR,NULL,in_operator(i)),
3216: DECODE(in_before_after(i),OKC_API.G_MISS_CHAR,NULL,in_before_after(i)),
3217: DECODE(in_datetime(i),OKC_API.G_MISS_DATE,NULL,in_datetime(i)),
3218: DECODE(in_month(i),OKC_API.G_MISS_NUM,NULL,in_month(i)),
3219: DECODE(in_day(i),OKC_API.G_MISS_NUM,NULL,in_day(i)),
3220: DECODE(in_hour(i),OKC_API.G_MISS_NUM,NULL,in_hour(i)),
3221: DECODE(in_minute(i),OKC_API.G_MISS_NUM,NULL,in_minute(i)),
3222: DECODE(in_second(i),OKC_API.G_MISS_NUM,NULL,in_second(i)),
3215: DECODE(in_operator(i),OKC_API.G_MISS_CHAR,NULL,in_operator(i)),
3216: DECODE(in_before_after(i),OKC_API.G_MISS_CHAR,NULL,in_before_after(i)),
3217: DECODE(in_datetime(i),OKC_API.G_MISS_DATE,NULL,in_datetime(i)),
3218: DECODE(in_month(i),OKC_API.G_MISS_NUM,NULL,in_month(i)),
3219: DECODE(in_day(i),OKC_API.G_MISS_NUM,NULL,in_day(i)),
3220: DECODE(in_hour(i),OKC_API.G_MISS_NUM,NULL,in_hour(i)),
3221: DECODE(in_minute(i),OKC_API.G_MISS_NUM,NULL,in_minute(i)),
3222: DECODE(in_second(i),OKC_API.G_MISS_NUM,NULL,in_second(i)),
3223: DECODE(in_interval_yn(i),OKC_API.G_MISS_CHAR,NULL,in_interval_yn(i)),
3216: DECODE(in_before_after(i),OKC_API.G_MISS_CHAR,NULL,in_before_after(i)),
3217: DECODE(in_datetime(i),OKC_API.G_MISS_DATE,NULL,in_datetime(i)),
3218: DECODE(in_month(i),OKC_API.G_MISS_NUM,NULL,in_month(i)),
3219: DECODE(in_day(i),OKC_API.G_MISS_NUM,NULL,in_day(i)),
3220: DECODE(in_hour(i),OKC_API.G_MISS_NUM,NULL,in_hour(i)),
3221: DECODE(in_minute(i),OKC_API.G_MISS_NUM,NULL,in_minute(i)),
3222: DECODE(in_second(i),OKC_API.G_MISS_NUM,NULL,in_second(i)),
3223: DECODE(in_interval_yn(i),OKC_API.G_MISS_CHAR,NULL,in_interval_yn(i)),
3224: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i)),
3217: DECODE(in_datetime(i),OKC_API.G_MISS_DATE,NULL,in_datetime(i)),
3218: DECODE(in_month(i),OKC_API.G_MISS_NUM,NULL,in_month(i)),
3219: DECODE(in_day(i),OKC_API.G_MISS_NUM,NULL,in_day(i)),
3220: DECODE(in_hour(i),OKC_API.G_MISS_NUM,NULL,in_hour(i)),
3221: DECODE(in_minute(i),OKC_API.G_MISS_NUM,NULL,in_minute(i)),
3222: DECODE(in_second(i),OKC_API.G_MISS_NUM,NULL,in_second(i)),
3223: DECODE(in_interval_yn(i),OKC_API.G_MISS_CHAR,NULL,in_interval_yn(i)),
3224: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i)),
3225: DECODE(in_nth(i),OKC_API.G_MISS_NUM,NULL,in_nth(i)),
3218: DECODE(in_month(i),OKC_API.G_MISS_NUM,NULL,in_month(i)),
3219: DECODE(in_day(i),OKC_API.G_MISS_NUM,NULL,in_day(i)),
3220: DECODE(in_hour(i),OKC_API.G_MISS_NUM,NULL,in_hour(i)),
3221: DECODE(in_minute(i),OKC_API.G_MISS_NUM,NULL,in_minute(i)),
3222: DECODE(in_second(i),OKC_API.G_MISS_NUM,NULL,in_second(i)),
3223: DECODE(in_interval_yn(i),OKC_API.G_MISS_CHAR,NULL,in_interval_yn(i)),
3224: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i)),
3225: DECODE(in_nth(i),OKC_API.G_MISS_NUM,NULL,in_nth(i)),
3226: DECODE(in_day_of_week(i),OKC_API.G_MISS_CHAR,NULL,in_day_of_week(i)),
3219: DECODE(in_day(i),OKC_API.G_MISS_NUM,NULL,in_day(i)),
3220: DECODE(in_hour(i),OKC_API.G_MISS_NUM,NULL,in_hour(i)),
3221: DECODE(in_minute(i),OKC_API.G_MISS_NUM,NULL,in_minute(i)),
3222: DECODE(in_second(i),OKC_API.G_MISS_NUM,NULL,in_second(i)),
3223: DECODE(in_interval_yn(i),OKC_API.G_MISS_CHAR,NULL,in_interval_yn(i)),
3224: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i)),
3225: DECODE(in_nth(i),OKC_API.G_MISS_NUM,NULL,in_nth(i)),
3226: DECODE(in_day_of_week(i),OKC_API.G_MISS_CHAR,NULL,in_day_of_week(i)),
3227: DECODE(in_attribute_category(i),OKC_API.G_MISS_CHAR,NULL,in_attribute_category(i)),
3220: DECODE(in_hour(i),OKC_API.G_MISS_NUM,NULL,in_hour(i)),
3221: DECODE(in_minute(i),OKC_API.G_MISS_NUM,NULL,in_minute(i)),
3222: DECODE(in_second(i),OKC_API.G_MISS_NUM,NULL,in_second(i)),
3223: DECODE(in_interval_yn(i),OKC_API.G_MISS_CHAR,NULL,in_interval_yn(i)),
3224: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i)),
3225: DECODE(in_nth(i),OKC_API.G_MISS_NUM,NULL,in_nth(i)),
3226: DECODE(in_day_of_week(i),OKC_API.G_MISS_CHAR,NULL,in_day_of_week(i)),
3227: DECODE(in_attribute_category(i),OKC_API.G_MISS_CHAR,NULL,in_attribute_category(i)),
3228: DECODE(in_attribute1(i),OKC_API.G_MISS_CHAR,NULL,in_attribute1(i)),
3221: DECODE(in_minute(i),OKC_API.G_MISS_NUM,NULL,in_minute(i)),
3222: DECODE(in_second(i),OKC_API.G_MISS_NUM,NULL,in_second(i)),
3223: DECODE(in_interval_yn(i),OKC_API.G_MISS_CHAR,NULL,in_interval_yn(i)),
3224: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i)),
3225: DECODE(in_nth(i),OKC_API.G_MISS_NUM,NULL,in_nth(i)),
3226: DECODE(in_day_of_week(i),OKC_API.G_MISS_CHAR,NULL,in_day_of_week(i)),
3227: DECODE(in_attribute_category(i),OKC_API.G_MISS_CHAR,NULL,in_attribute_category(i)),
3228: DECODE(in_attribute1(i),OKC_API.G_MISS_CHAR,NULL,in_attribute1(i)),
3229: DECODE(in_attribute2(i),OKC_API.G_MISS_CHAR,NULL,in_attribute2(i)),
3222: DECODE(in_second(i),OKC_API.G_MISS_NUM,NULL,in_second(i)),
3223: DECODE(in_interval_yn(i),OKC_API.G_MISS_CHAR,NULL,in_interval_yn(i)),
3224: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i)),
3225: DECODE(in_nth(i),OKC_API.G_MISS_NUM,NULL,in_nth(i)),
3226: DECODE(in_day_of_week(i),OKC_API.G_MISS_CHAR,NULL,in_day_of_week(i)),
3227: DECODE(in_attribute_category(i),OKC_API.G_MISS_CHAR,NULL,in_attribute_category(i)),
3228: DECODE(in_attribute1(i),OKC_API.G_MISS_CHAR,NULL,in_attribute1(i)),
3229: DECODE(in_attribute2(i),OKC_API.G_MISS_CHAR,NULL,in_attribute2(i)),
3230: DECODE(in_attribute3(i),OKC_API.G_MISS_CHAR,NULL,in_attribute3(i)),
3223: DECODE(in_interval_yn(i),OKC_API.G_MISS_CHAR,NULL,in_interval_yn(i)),
3224: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i)),
3225: DECODE(in_nth(i),OKC_API.G_MISS_NUM,NULL,in_nth(i)),
3226: DECODE(in_day_of_week(i),OKC_API.G_MISS_CHAR,NULL,in_day_of_week(i)),
3227: DECODE(in_attribute_category(i),OKC_API.G_MISS_CHAR,NULL,in_attribute_category(i)),
3228: DECODE(in_attribute1(i),OKC_API.G_MISS_CHAR,NULL,in_attribute1(i)),
3229: DECODE(in_attribute2(i),OKC_API.G_MISS_CHAR,NULL,in_attribute2(i)),
3230: DECODE(in_attribute3(i),OKC_API.G_MISS_CHAR,NULL,in_attribute3(i)),
3231: DECODE(in_attribute4(i),OKC_API.G_MISS_CHAR,NULL,in_attribute4(i)),
3224: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i)),
3225: DECODE(in_nth(i),OKC_API.G_MISS_NUM,NULL,in_nth(i)),
3226: DECODE(in_day_of_week(i),OKC_API.G_MISS_CHAR,NULL,in_day_of_week(i)),
3227: DECODE(in_attribute_category(i),OKC_API.G_MISS_CHAR,NULL,in_attribute_category(i)),
3228: DECODE(in_attribute1(i),OKC_API.G_MISS_CHAR,NULL,in_attribute1(i)),
3229: DECODE(in_attribute2(i),OKC_API.G_MISS_CHAR,NULL,in_attribute2(i)),
3230: DECODE(in_attribute3(i),OKC_API.G_MISS_CHAR,NULL,in_attribute3(i)),
3231: DECODE(in_attribute4(i),OKC_API.G_MISS_CHAR,NULL,in_attribute4(i)),
3232: DECODE(in_attribute5(i),OKC_API.G_MISS_CHAR,NULL,in_attribute5(i)),
3225: DECODE(in_nth(i),OKC_API.G_MISS_NUM,NULL,in_nth(i)),
3226: DECODE(in_day_of_week(i),OKC_API.G_MISS_CHAR,NULL,in_day_of_week(i)),
3227: DECODE(in_attribute_category(i),OKC_API.G_MISS_CHAR,NULL,in_attribute_category(i)),
3228: DECODE(in_attribute1(i),OKC_API.G_MISS_CHAR,NULL,in_attribute1(i)),
3229: DECODE(in_attribute2(i),OKC_API.G_MISS_CHAR,NULL,in_attribute2(i)),
3230: DECODE(in_attribute3(i),OKC_API.G_MISS_CHAR,NULL,in_attribute3(i)),
3231: DECODE(in_attribute4(i),OKC_API.G_MISS_CHAR,NULL,in_attribute4(i)),
3232: DECODE(in_attribute5(i),OKC_API.G_MISS_CHAR,NULL,in_attribute5(i)),
3233: DECODE(in_attribute6(i),OKC_API.G_MISS_CHAR,NULL,in_attribute6(i)),
3226: DECODE(in_day_of_week(i),OKC_API.G_MISS_CHAR,NULL,in_day_of_week(i)),
3227: DECODE(in_attribute_category(i),OKC_API.G_MISS_CHAR,NULL,in_attribute_category(i)),
3228: DECODE(in_attribute1(i),OKC_API.G_MISS_CHAR,NULL,in_attribute1(i)),
3229: DECODE(in_attribute2(i),OKC_API.G_MISS_CHAR,NULL,in_attribute2(i)),
3230: DECODE(in_attribute3(i),OKC_API.G_MISS_CHAR,NULL,in_attribute3(i)),
3231: DECODE(in_attribute4(i),OKC_API.G_MISS_CHAR,NULL,in_attribute4(i)),
3232: DECODE(in_attribute5(i),OKC_API.G_MISS_CHAR,NULL,in_attribute5(i)),
3233: DECODE(in_attribute6(i),OKC_API.G_MISS_CHAR,NULL,in_attribute6(i)),
3234: DECODE(in_attribute7(i),OKC_API.G_MISS_CHAR,NULL,in_attribute7(i)),
3227: DECODE(in_attribute_category(i),OKC_API.G_MISS_CHAR,NULL,in_attribute_category(i)),
3228: DECODE(in_attribute1(i),OKC_API.G_MISS_CHAR,NULL,in_attribute1(i)),
3229: DECODE(in_attribute2(i),OKC_API.G_MISS_CHAR,NULL,in_attribute2(i)),
3230: DECODE(in_attribute3(i),OKC_API.G_MISS_CHAR,NULL,in_attribute3(i)),
3231: DECODE(in_attribute4(i),OKC_API.G_MISS_CHAR,NULL,in_attribute4(i)),
3232: DECODE(in_attribute5(i),OKC_API.G_MISS_CHAR,NULL,in_attribute5(i)),
3233: DECODE(in_attribute6(i),OKC_API.G_MISS_CHAR,NULL,in_attribute6(i)),
3234: DECODE(in_attribute7(i),OKC_API.G_MISS_CHAR,NULL,in_attribute7(i)),
3235: DECODE(in_attribute8(i),OKC_API.G_MISS_CHAR,NULL,in_attribute8(i)),
3228: DECODE(in_attribute1(i),OKC_API.G_MISS_CHAR,NULL,in_attribute1(i)),
3229: DECODE(in_attribute2(i),OKC_API.G_MISS_CHAR,NULL,in_attribute2(i)),
3230: DECODE(in_attribute3(i),OKC_API.G_MISS_CHAR,NULL,in_attribute3(i)),
3231: DECODE(in_attribute4(i),OKC_API.G_MISS_CHAR,NULL,in_attribute4(i)),
3232: DECODE(in_attribute5(i),OKC_API.G_MISS_CHAR,NULL,in_attribute5(i)),
3233: DECODE(in_attribute6(i),OKC_API.G_MISS_CHAR,NULL,in_attribute6(i)),
3234: DECODE(in_attribute7(i),OKC_API.G_MISS_CHAR,NULL,in_attribute7(i)),
3235: DECODE(in_attribute8(i),OKC_API.G_MISS_CHAR,NULL,in_attribute8(i)),
3236: DECODE(in_attribute9(i),OKC_API.G_MISS_CHAR,NULL,in_attribute9(i)),
3229: DECODE(in_attribute2(i),OKC_API.G_MISS_CHAR,NULL,in_attribute2(i)),
3230: DECODE(in_attribute3(i),OKC_API.G_MISS_CHAR,NULL,in_attribute3(i)),
3231: DECODE(in_attribute4(i),OKC_API.G_MISS_CHAR,NULL,in_attribute4(i)),
3232: DECODE(in_attribute5(i),OKC_API.G_MISS_CHAR,NULL,in_attribute5(i)),
3233: DECODE(in_attribute6(i),OKC_API.G_MISS_CHAR,NULL,in_attribute6(i)),
3234: DECODE(in_attribute7(i),OKC_API.G_MISS_CHAR,NULL,in_attribute7(i)),
3235: DECODE(in_attribute8(i),OKC_API.G_MISS_CHAR,NULL,in_attribute8(i)),
3236: DECODE(in_attribute9(i),OKC_API.G_MISS_CHAR,NULL,in_attribute9(i)),
3237: DECODE(in_attribute10(i),OKC_API.G_MISS_CHAR,NULL,in_attribute10(i)),
3230: DECODE(in_attribute3(i),OKC_API.G_MISS_CHAR,NULL,in_attribute3(i)),
3231: DECODE(in_attribute4(i),OKC_API.G_MISS_CHAR,NULL,in_attribute4(i)),
3232: DECODE(in_attribute5(i),OKC_API.G_MISS_CHAR,NULL,in_attribute5(i)),
3233: DECODE(in_attribute6(i),OKC_API.G_MISS_CHAR,NULL,in_attribute6(i)),
3234: DECODE(in_attribute7(i),OKC_API.G_MISS_CHAR,NULL,in_attribute7(i)),
3235: DECODE(in_attribute8(i),OKC_API.G_MISS_CHAR,NULL,in_attribute8(i)),
3236: DECODE(in_attribute9(i),OKC_API.G_MISS_CHAR,NULL,in_attribute9(i)),
3237: DECODE(in_attribute10(i),OKC_API.G_MISS_CHAR,NULL,in_attribute10(i)),
3238: DECODE(in_attribute11(i),OKC_API.G_MISS_CHAR,NULL,in_attribute11(i)),
3231: DECODE(in_attribute4(i),OKC_API.G_MISS_CHAR,NULL,in_attribute4(i)),
3232: DECODE(in_attribute5(i),OKC_API.G_MISS_CHAR,NULL,in_attribute5(i)),
3233: DECODE(in_attribute6(i),OKC_API.G_MISS_CHAR,NULL,in_attribute6(i)),
3234: DECODE(in_attribute7(i),OKC_API.G_MISS_CHAR,NULL,in_attribute7(i)),
3235: DECODE(in_attribute8(i),OKC_API.G_MISS_CHAR,NULL,in_attribute8(i)),
3236: DECODE(in_attribute9(i),OKC_API.G_MISS_CHAR,NULL,in_attribute9(i)),
3237: DECODE(in_attribute10(i),OKC_API.G_MISS_CHAR,NULL,in_attribute10(i)),
3238: DECODE(in_attribute11(i),OKC_API.G_MISS_CHAR,NULL,in_attribute11(i)),
3239: DECODE(in_attribute12(i),OKC_API.G_MISS_CHAR,NULL,in_attribute12(i)),
3232: DECODE(in_attribute5(i),OKC_API.G_MISS_CHAR,NULL,in_attribute5(i)),
3233: DECODE(in_attribute6(i),OKC_API.G_MISS_CHAR,NULL,in_attribute6(i)),
3234: DECODE(in_attribute7(i),OKC_API.G_MISS_CHAR,NULL,in_attribute7(i)),
3235: DECODE(in_attribute8(i),OKC_API.G_MISS_CHAR,NULL,in_attribute8(i)),
3236: DECODE(in_attribute9(i),OKC_API.G_MISS_CHAR,NULL,in_attribute9(i)),
3237: DECODE(in_attribute10(i),OKC_API.G_MISS_CHAR,NULL,in_attribute10(i)),
3238: DECODE(in_attribute11(i),OKC_API.G_MISS_CHAR,NULL,in_attribute11(i)),
3239: DECODE(in_attribute12(i),OKC_API.G_MISS_CHAR,NULL,in_attribute12(i)),
3240: DECODE(in_attribute13(i),OKC_API.G_MISS_CHAR,NULL,in_attribute13(i)),
3233: DECODE(in_attribute6(i),OKC_API.G_MISS_CHAR,NULL,in_attribute6(i)),
3234: DECODE(in_attribute7(i),OKC_API.G_MISS_CHAR,NULL,in_attribute7(i)),
3235: DECODE(in_attribute8(i),OKC_API.G_MISS_CHAR,NULL,in_attribute8(i)),
3236: DECODE(in_attribute9(i),OKC_API.G_MISS_CHAR,NULL,in_attribute9(i)),
3237: DECODE(in_attribute10(i),OKC_API.G_MISS_CHAR,NULL,in_attribute10(i)),
3238: DECODE(in_attribute11(i),OKC_API.G_MISS_CHAR,NULL,in_attribute11(i)),
3239: DECODE(in_attribute12(i),OKC_API.G_MISS_CHAR,NULL,in_attribute12(i)),
3240: DECODE(in_attribute13(i),OKC_API.G_MISS_CHAR,NULL,in_attribute13(i)),
3241: DECODE(in_attribute14(i),OKC_API.G_MISS_CHAR,NULL,in_attribute14(i)),
3234: DECODE(in_attribute7(i),OKC_API.G_MISS_CHAR,NULL,in_attribute7(i)),
3235: DECODE(in_attribute8(i),OKC_API.G_MISS_CHAR,NULL,in_attribute8(i)),
3236: DECODE(in_attribute9(i),OKC_API.G_MISS_CHAR,NULL,in_attribute9(i)),
3237: DECODE(in_attribute10(i),OKC_API.G_MISS_CHAR,NULL,in_attribute10(i)),
3238: DECODE(in_attribute11(i),OKC_API.G_MISS_CHAR,NULL,in_attribute11(i)),
3239: DECODE(in_attribute12(i),OKC_API.G_MISS_CHAR,NULL,in_attribute12(i)),
3240: DECODE(in_attribute13(i),OKC_API.G_MISS_CHAR,NULL,in_attribute13(i)),
3241: DECODE(in_attribute14(i),OKC_API.G_MISS_CHAR,NULL,in_attribute14(i)),
3242: DECODE(in_attribute15(i),OKC_API.G_MISS_CHAR,NULL,in_attribute15(i)),
3235: DECODE(in_attribute8(i),OKC_API.G_MISS_CHAR,NULL,in_attribute8(i)),
3236: DECODE(in_attribute9(i),OKC_API.G_MISS_CHAR,NULL,in_attribute9(i)),
3237: DECODE(in_attribute10(i),OKC_API.G_MISS_CHAR,NULL,in_attribute10(i)),
3238: DECODE(in_attribute11(i),OKC_API.G_MISS_CHAR,NULL,in_attribute11(i)),
3239: DECODE(in_attribute12(i),OKC_API.G_MISS_CHAR,NULL,in_attribute12(i)),
3240: DECODE(in_attribute13(i),OKC_API.G_MISS_CHAR,NULL,in_attribute13(i)),
3241: DECODE(in_attribute14(i),OKC_API.G_MISS_CHAR,NULL,in_attribute14(i)),
3242: DECODE(in_attribute15(i),OKC_API.G_MISS_CHAR,NULL,in_attribute15(i)),
3243: --Bug 3122962
3236: DECODE(in_attribute9(i),OKC_API.G_MISS_CHAR,NULL,in_attribute9(i)),
3237: DECODE(in_attribute10(i),OKC_API.G_MISS_CHAR,NULL,in_attribute10(i)),
3238: DECODE(in_attribute11(i),OKC_API.G_MISS_CHAR,NULL,in_attribute11(i)),
3239: DECODE(in_attribute12(i),OKC_API.G_MISS_CHAR,NULL,in_attribute12(i)),
3240: DECODE(in_attribute13(i),OKC_API.G_MISS_CHAR,NULL,in_attribute13(i)),
3241: DECODE(in_attribute14(i),OKC_API.G_MISS_CHAR,NULL,in_attribute14(i)),
3242: DECODE(in_attribute15(i),OKC_API.G_MISS_CHAR,NULL,in_attribute15(i)),
3243: --Bug 3122962
3244: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3237: DECODE(in_attribute10(i),OKC_API.G_MISS_CHAR,NULL,in_attribute10(i)),
3238: DECODE(in_attribute11(i),OKC_API.G_MISS_CHAR,NULL,in_attribute11(i)),
3239: DECODE(in_attribute12(i),OKC_API.G_MISS_CHAR,NULL,in_attribute12(i)),
3240: DECODE(in_attribute13(i),OKC_API.G_MISS_CHAR,NULL,in_attribute13(i)),
3241: DECODE(in_attribute14(i),OKC_API.G_MISS_CHAR,NULL,in_attribute14(i)),
3242: DECODE(in_attribute15(i),OKC_API.G_MISS_CHAR,NULL,in_attribute15(i)),
3243: --Bug 3122962
3244: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3245: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
3238: DECODE(in_attribute11(i),OKC_API.G_MISS_CHAR,NULL,in_attribute11(i)),
3239: DECODE(in_attribute12(i),OKC_API.G_MISS_CHAR,NULL,in_attribute12(i)),
3240: DECODE(in_attribute13(i),OKC_API.G_MISS_CHAR,NULL,in_attribute13(i)),
3241: DECODE(in_attribute14(i),OKC_API.G_MISS_CHAR,NULL,in_attribute14(i)),
3242: DECODE(in_attribute15(i),OKC_API.G_MISS_CHAR,NULL,in_attribute15(i)),
3243: --Bug 3122962
3244: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3245: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
3246: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
3240: DECODE(in_attribute13(i),OKC_API.G_MISS_CHAR,NULL,in_attribute13(i)),
3241: DECODE(in_attribute14(i),OKC_API.G_MISS_CHAR,NULL,in_attribute14(i)),
3242: DECODE(in_attribute15(i),OKC_API.G_MISS_CHAR,NULL,in_attribute15(i)),
3243: --Bug 3122962
3244: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3245: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
3246: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
3247: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i))
3248: );
3241: DECODE(in_attribute14(i),OKC_API.G_MISS_CHAR,NULL,in_attribute14(i)),
3242: DECODE(in_attribute15(i),OKC_API.G_MISS_CHAR,NULL,in_attribute15(i)),
3243: --Bug 3122962
3244: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3245: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
3246: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
3247: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i))
3248: );
3249:
3242: DECODE(in_attribute15(i),OKC_API.G_MISS_CHAR,NULL,in_attribute15(i)),
3243: --Bug 3122962
3244: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3245: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
3246: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
3247: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i))
3248: );
3249:
3250: --Bug 3122962
3243: --Bug 3122962
3244: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3245: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
3246: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
3247: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i))
3248: );
3249:
3250: --Bug 3122962
3251: /*
3266: last_update_date,
3267: last_update_login
3268: )
3269: VALUES (
3270: DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
3271: OKC_UTIL.g_language_code(lang_i),
3272: l_source_lang,
3273: DECODE(in_sfwt_flag(i),OKC_API.G_MISS_CHAR,NULL,in_sfwt_flag(i)),
3274: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
3269: VALUES (
3270: DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
3271: OKC_UTIL.g_language_code(lang_i),
3272: l_source_lang,
3273: DECODE(in_sfwt_flag(i),OKC_API.G_MISS_CHAR,NULL,in_sfwt_flag(i)),
3274: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
3275: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
3276: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i)),
3277: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3270: DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
3271: OKC_UTIL.g_language_code(lang_i),
3272: l_source_lang,
3273: DECODE(in_sfwt_flag(i),OKC_API.G_MISS_CHAR,NULL,in_sfwt_flag(i)),
3274: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
3275: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
3276: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i)),
3277: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3278: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3271: OKC_UTIL.g_language_code(lang_i),
3272: l_source_lang,
3273: DECODE(in_sfwt_flag(i),OKC_API.G_MISS_CHAR,NULL,in_sfwt_flag(i)),
3274: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
3275: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
3276: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i)),
3277: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3278: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3279: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3272: l_source_lang,
3273: DECODE(in_sfwt_flag(i),OKC_API.G_MISS_CHAR,NULL,in_sfwt_flag(i)),
3274: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
3275: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
3276: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i)),
3277: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3278: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3279: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3280: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3273: DECODE(in_sfwt_flag(i),OKC_API.G_MISS_CHAR,NULL,in_sfwt_flag(i)),
3274: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
3275: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
3276: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i)),
3277: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3278: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3279: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3280: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3281: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3274: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
3275: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
3276: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i)),
3277: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3278: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3279: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3280: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3281: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3282: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i))
3275: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
3276: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i)),
3277: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3278: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3279: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3280: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3281: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3282: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i))
3283: );
3276: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i)),
3277: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3278: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3279: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3280: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3281: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3282: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i))
3283: );
3284: END LOOP;
3277: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3278: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3279: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3280: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3281: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3282: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i))
3283: );
3284: END LOOP;
3285: */
3278: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3279: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3280: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3281: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3282: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i))
3283: );
3284: END LOOP;
3285: */
3286: EXCEPTION
3459: short_description,
3460: comments
3461: )
3462: VALUES (
3463: DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
3464: DECODE(in_spn_id(i),OKC_API.G_MISS_NUM,NULL,in_spn_id(i)),
3465: DECODE(in_tve_id_offset(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_offset(i)),
3466: DECODE(in_tve_id_generated_by(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_generated_by(i)),
3467: DECODE(in_tve_id_started(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_started(i)),
3460: comments
3461: )
3462: VALUES (
3463: DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
3464: DECODE(in_spn_id(i),OKC_API.G_MISS_NUM,NULL,in_spn_id(i)),
3465: DECODE(in_tve_id_offset(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_offset(i)),
3466: DECODE(in_tve_id_generated_by(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_generated_by(i)),
3467: DECODE(in_tve_id_started(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_started(i)),
3468: DECODE(in_tve_id_ended(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_ended(i)),
3461: )
3462: VALUES (
3463: DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
3464: DECODE(in_spn_id(i),OKC_API.G_MISS_NUM,NULL,in_spn_id(i)),
3465: DECODE(in_tve_id_offset(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_offset(i)),
3466: DECODE(in_tve_id_generated_by(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_generated_by(i)),
3467: DECODE(in_tve_id_started(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_started(i)),
3468: DECODE(in_tve_id_ended(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_ended(i)),
3469: DECODE(in_tve_id_limited(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_limited(i)),
3462: VALUES (
3463: DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
3464: DECODE(in_spn_id(i),OKC_API.G_MISS_NUM,NULL,in_spn_id(i)),
3465: DECODE(in_tve_id_offset(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_offset(i)),
3466: DECODE(in_tve_id_generated_by(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_generated_by(i)),
3467: DECODE(in_tve_id_started(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_started(i)),
3468: DECODE(in_tve_id_ended(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_ended(i)),
3469: DECODE(in_tve_id_limited(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_limited(i)),
3470: DECODE(in_cnh_id(i),OKC_API.G_MISS_NUM,NULL,in_cnh_id(i)),
3463: DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
3464: DECODE(in_spn_id(i),OKC_API.G_MISS_NUM,NULL,in_spn_id(i)),
3465: DECODE(in_tve_id_offset(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_offset(i)),
3466: DECODE(in_tve_id_generated_by(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_generated_by(i)),
3467: DECODE(in_tve_id_started(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_started(i)),
3468: DECODE(in_tve_id_ended(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_ended(i)),
3469: DECODE(in_tve_id_limited(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_limited(i)),
3470: DECODE(in_cnh_id(i),OKC_API.G_MISS_NUM,NULL,in_cnh_id(i)),
3471: DECODE(in_dnz_chr_id(i),OKC_API.G_MISS_NUM,NULL,in_dnz_chr_id(i)),
3464: DECODE(in_spn_id(i),OKC_API.G_MISS_NUM,NULL,in_spn_id(i)),
3465: DECODE(in_tve_id_offset(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_offset(i)),
3466: DECODE(in_tve_id_generated_by(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_generated_by(i)),
3467: DECODE(in_tve_id_started(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_started(i)),
3468: DECODE(in_tve_id_ended(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_ended(i)),
3469: DECODE(in_tve_id_limited(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_limited(i)),
3470: DECODE(in_cnh_id(i),OKC_API.G_MISS_NUM,NULL,in_cnh_id(i)),
3471: DECODE(in_dnz_chr_id(i),OKC_API.G_MISS_NUM,NULL,in_dnz_chr_id(i)),
3472: DECODE(in_tve_type(i),OKC_API.G_MISS_CHAR,NULL,in_tve_type(i)),
3465: DECODE(in_tve_id_offset(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_offset(i)),
3466: DECODE(in_tve_id_generated_by(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_generated_by(i)),
3467: DECODE(in_tve_id_started(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_started(i)),
3468: DECODE(in_tve_id_ended(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_ended(i)),
3469: DECODE(in_tve_id_limited(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_limited(i)),
3470: DECODE(in_cnh_id(i),OKC_API.G_MISS_NUM,NULL,in_cnh_id(i)),
3471: DECODE(in_dnz_chr_id(i),OKC_API.G_MISS_NUM,NULL,in_dnz_chr_id(i)),
3472: DECODE(in_tve_type(i),OKC_API.G_MISS_CHAR,NULL,in_tve_type(i)),
3473: DECODE(in_tze_id(i),OKC_API.G_MISS_NUM,NULL,in_tze_id(i)),
3466: DECODE(in_tve_id_generated_by(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_generated_by(i)),
3467: DECODE(in_tve_id_started(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_started(i)),
3468: DECODE(in_tve_id_ended(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_ended(i)),
3469: DECODE(in_tve_id_limited(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_limited(i)),
3470: DECODE(in_cnh_id(i),OKC_API.G_MISS_NUM,NULL,in_cnh_id(i)),
3471: DECODE(in_dnz_chr_id(i),OKC_API.G_MISS_NUM,NULL,in_dnz_chr_id(i)),
3472: DECODE(in_tve_type(i),OKC_API.G_MISS_CHAR,NULL,in_tve_type(i)),
3473: DECODE(in_tze_id(i),OKC_API.G_MISS_NUM,NULL,in_tze_id(i)),
3474: DECODE(in_object_version_number(i),OKC_API.G_MISS_NUM,NULL,in_object_version_number(i)),
3467: DECODE(in_tve_id_started(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_started(i)),
3468: DECODE(in_tve_id_ended(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_ended(i)),
3469: DECODE(in_tve_id_limited(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_limited(i)),
3470: DECODE(in_cnh_id(i),OKC_API.G_MISS_NUM,NULL,in_cnh_id(i)),
3471: DECODE(in_dnz_chr_id(i),OKC_API.G_MISS_NUM,NULL,in_dnz_chr_id(i)),
3472: DECODE(in_tve_type(i),OKC_API.G_MISS_CHAR,NULL,in_tve_type(i)),
3473: DECODE(in_tze_id(i),OKC_API.G_MISS_NUM,NULL,in_tze_id(i)),
3474: DECODE(in_object_version_number(i),OKC_API.G_MISS_NUM,NULL,in_object_version_number(i)),
3475: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3468: DECODE(in_tve_id_ended(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_ended(i)),
3469: DECODE(in_tve_id_limited(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_limited(i)),
3470: DECODE(in_cnh_id(i),OKC_API.G_MISS_NUM,NULL,in_cnh_id(i)),
3471: DECODE(in_dnz_chr_id(i),OKC_API.G_MISS_NUM,NULL,in_dnz_chr_id(i)),
3472: DECODE(in_tve_type(i),OKC_API.G_MISS_CHAR,NULL,in_tve_type(i)),
3473: DECODE(in_tze_id(i),OKC_API.G_MISS_NUM,NULL,in_tze_id(i)),
3474: DECODE(in_object_version_number(i),OKC_API.G_MISS_NUM,NULL,in_object_version_number(i)),
3475: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3476: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3469: DECODE(in_tve_id_limited(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_limited(i)),
3470: DECODE(in_cnh_id(i),OKC_API.G_MISS_NUM,NULL,in_cnh_id(i)),
3471: DECODE(in_dnz_chr_id(i),OKC_API.G_MISS_NUM,NULL,in_dnz_chr_id(i)),
3472: DECODE(in_tve_type(i),OKC_API.G_MISS_CHAR,NULL,in_tve_type(i)),
3473: DECODE(in_tze_id(i),OKC_API.G_MISS_NUM,NULL,in_tze_id(i)),
3474: DECODE(in_object_version_number(i),OKC_API.G_MISS_NUM,NULL,in_object_version_number(i)),
3475: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3476: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3477: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3470: DECODE(in_cnh_id(i),OKC_API.G_MISS_NUM,NULL,in_cnh_id(i)),
3471: DECODE(in_dnz_chr_id(i),OKC_API.G_MISS_NUM,NULL,in_dnz_chr_id(i)),
3472: DECODE(in_tve_type(i),OKC_API.G_MISS_CHAR,NULL,in_tve_type(i)),
3473: DECODE(in_tze_id(i),OKC_API.G_MISS_NUM,NULL,in_tze_id(i)),
3474: DECODE(in_object_version_number(i),OKC_API.G_MISS_NUM,NULL,in_object_version_number(i)),
3475: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3476: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3477: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3478: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3471: DECODE(in_dnz_chr_id(i),OKC_API.G_MISS_NUM,NULL,in_dnz_chr_id(i)),
3472: DECODE(in_tve_type(i),OKC_API.G_MISS_CHAR,NULL,in_tve_type(i)),
3473: DECODE(in_tze_id(i),OKC_API.G_MISS_NUM,NULL,in_tze_id(i)),
3474: DECODE(in_object_version_number(i),OKC_API.G_MISS_NUM,NULL,in_object_version_number(i)),
3475: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3476: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3477: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3478: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3479: DECODE(in_uom_code(i),OKC_API.G_MISS_CHAR,NULL,in_uom_code(i)),
3472: DECODE(in_tve_type(i),OKC_API.G_MISS_CHAR,NULL,in_tve_type(i)),
3473: DECODE(in_tze_id(i),OKC_API.G_MISS_NUM,NULL,in_tze_id(i)),
3474: DECODE(in_object_version_number(i),OKC_API.G_MISS_NUM,NULL,in_object_version_number(i)),
3475: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3476: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3477: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3478: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3479: DECODE(in_uom_code(i),OKC_API.G_MISS_CHAR,NULL,in_uom_code(i)),
3480: DECODE(in_duration(i),OKC_API.G_MISS_NUM,NULL,in_duration(i)),
3473: DECODE(in_tze_id(i),OKC_API.G_MISS_NUM,NULL,in_tze_id(i)),
3474: DECODE(in_object_version_number(i),OKC_API.G_MISS_NUM,NULL,in_object_version_number(i)),
3475: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3476: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3477: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3478: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3479: DECODE(in_uom_code(i),OKC_API.G_MISS_CHAR,NULL,in_uom_code(i)),
3480: DECODE(in_duration(i),OKC_API.G_MISS_NUM,NULL,in_duration(i)),
3481: DECODE(in_operator(i),OKC_API.G_MISS_CHAR,NULL,in_operator(i)),
3474: DECODE(in_object_version_number(i),OKC_API.G_MISS_NUM,NULL,in_object_version_number(i)),
3475: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3476: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3477: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3478: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3479: DECODE(in_uom_code(i),OKC_API.G_MISS_CHAR,NULL,in_uom_code(i)),
3480: DECODE(in_duration(i),OKC_API.G_MISS_NUM,NULL,in_duration(i)),
3481: DECODE(in_operator(i),OKC_API.G_MISS_CHAR,NULL,in_operator(i)),
3482: DECODE(in_before_after(i),OKC_API.G_MISS_CHAR,NULL,in_before_after(i)),
3475: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3476: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3477: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3478: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3479: DECODE(in_uom_code(i),OKC_API.G_MISS_CHAR,NULL,in_uom_code(i)),
3480: DECODE(in_duration(i),OKC_API.G_MISS_NUM,NULL,in_duration(i)),
3481: DECODE(in_operator(i),OKC_API.G_MISS_CHAR,NULL,in_operator(i)),
3482: DECODE(in_before_after(i),OKC_API.G_MISS_CHAR,NULL,in_before_after(i)),
3483: DECODE(in_datetime(i),OKC_API.G_MISS_DATE,NULL,in_datetime(i)),
3476: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3477: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3478: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3479: DECODE(in_uom_code(i),OKC_API.G_MISS_CHAR,NULL,in_uom_code(i)),
3480: DECODE(in_duration(i),OKC_API.G_MISS_NUM,NULL,in_duration(i)),
3481: DECODE(in_operator(i),OKC_API.G_MISS_CHAR,NULL,in_operator(i)),
3482: DECODE(in_before_after(i),OKC_API.G_MISS_CHAR,NULL,in_before_after(i)),
3483: DECODE(in_datetime(i),OKC_API.G_MISS_DATE,NULL,in_datetime(i)),
3484: DECODE(in_month(i),OKC_API.G_MISS_NUM,NULL,in_month(i)),
3477: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3478: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3479: DECODE(in_uom_code(i),OKC_API.G_MISS_CHAR,NULL,in_uom_code(i)),
3480: DECODE(in_duration(i),OKC_API.G_MISS_NUM,NULL,in_duration(i)),
3481: DECODE(in_operator(i),OKC_API.G_MISS_CHAR,NULL,in_operator(i)),
3482: DECODE(in_before_after(i),OKC_API.G_MISS_CHAR,NULL,in_before_after(i)),
3483: DECODE(in_datetime(i),OKC_API.G_MISS_DATE,NULL,in_datetime(i)),
3484: DECODE(in_month(i),OKC_API.G_MISS_NUM,NULL,in_month(i)),
3485: DECODE(in_day(i),OKC_API.G_MISS_NUM,NULL,in_day(i)),
3478: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3479: DECODE(in_uom_code(i),OKC_API.G_MISS_CHAR,NULL,in_uom_code(i)),
3480: DECODE(in_duration(i),OKC_API.G_MISS_NUM,NULL,in_duration(i)),
3481: DECODE(in_operator(i),OKC_API.G_MISS_CHAR,NULL,in_operator(i)),
3482: DECODE(in_before_after(i),OKC_API.G_MISS_CHAR,NULL,in_before_after(i)),
3483: DECODE(in_datetime(i),OKC_API.G_MISS_DATE,NULL,in_datetime(i)),
3484: DECODE(in_month(i),OKC_API.G_MISS_NUM,NULL,in_month(i)),
3485: DECODE(in_day(i),OKC_API.G_MISS_NUM,NULL,in_day(i)),
3486: DECODE(in_hour(i),OKC_API.G_MISS_NUM,NULL,in_hour(i)),
3479: DECODE(in_uom_code(i),OKC_API.G_MISS_CHAR,NULL,in_uom_code(i)),
3480: DECODE(in_duration(i),OKC_API.G_MISS_NUM,NULL,in_duration(i)),
3481: DECODE(in_operator(i),OKC_API.G_MISS_CHAR,NULL,in_operator(i)),
3482: DECODE(in_before_after(i),OKC_API.G_MISS_CHAR,NULL,in_before_after(i)),
3483: DECODE(in_datetime(i),OKC_API.G_MISS_DATE,NULL,in_datetime(i)),
3484: DECODE(in_month(i),OKC_API.G_MISS_NUM,NULL,in_month(i)),
3485: DECODE(in_day(i),OKC_API.G_MISS_NUM,NULL,in_day(i)),
3486: DECODE(in_hour(i),OKC_API.G_MISS_NUM,NULL,in_hour(i)),
3487: DECODE(in_minute(i),OKC_API.G_MISS_NUM,NULL,in_minute(i)),
3480: DECODE(in_duration(i),OKC_API.G_MISS_NUM,NULL,in_duration(i)),
3481: DECODE(in_operator(i),OKC_API.G_MISS_CHAR,NULL,in_operator(i)),
3482: DECODE(in_before_after(i),OKC_API.G_MISS_CHAR,NULL,in_before_after(i)),
3483: DECODE(in_datetime(i),OKC_API.G_MISS_DATE,NULL,in_datetime(i)),
3484: DECODE(in_month(i),OKC_API.G_MISS_NUM,NULL,in_month(i)),
3485: DECODE(in_day(i),OKC_API.G_MISS_NUM,NULL,in_day(i)),
3486: DECODE(in_hour(i),OKC_API.G_MISS_NUM,NULL,in_hour(i)),
3487: DECODE(in_minute(i),OKC_API.G_MISS_NUM,NULL,in_minute(i)),
3488: DECODE(in_second(i),OKC_API.G_MISS_NUM,NULL,in_second(i)),
3481: DECODE(in_operator(i),OKC_API.G_MISS_CHAR,NULL,in_operator(i)),
3482: DECODE(in_before_after(i),OKC_API.G_MISS_CHAR,NULL,in_before_after(i)),
3483: DECODE(in_datetime(i),OKC_API.G_MISS_DATE,NULL,in_datetime(i)),
3484: DECODE(in_month(i),OKC_API.G_MISS_NUM,NULL,in_month(i)),
3485: DECODE(in_day(i),OKC_API.G_MISS_NUM,NULL,in_day(i)),
3486: DECODE(in_hour(i),OKC_API.G_MISS_NUM,NULL,in_hour(i)),
3487: DECODE(in_minute(i),OKC_API.G_MISS_NUM,NULL,in_minute(i)),
3488: DECODE(in_second(i),OKC_API.G_MISS_NUM,NULL,in_second(i)),
3489: DECODE(in_interval_yn(i),OKC_API.G_MISS_CHAR,NULL,in_interval_yn(i)),
3482: DECODE(in_before_after(i),OKC_API.G_MISS_CHAR,NULL,in_before_after(i)),
3483: DECODE(in_datetime(i),OKC_API.G_MISS_DATE,NULL,in_datetime(i)),
3484: DECODE(in_month(i),OKC_API.G_MISS_NUM,NULL,in_month(i)),
3485: DECODE(in_day(i),OKC_API.G_MISS_NUM,NULL,in_day(i)),
3486: DECODE(in_hour(i),OKC_API.G_MISS_NUM,NULL,in_hour(i)),
3487: DECODE(in_minute(i),OKC_API.G_MISS_NUM,NULL,in_minute(i)),
3488: DECODE(in_second(i),OKC_API.G_MISS_NUM,NULL,in_second(i)),
3489: DECODE(in_interval_yn(i),OKC_API.G_MISS_CHAR,NULL,in_interval_yn(i)),
3490: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i)),
3483: DECODE(in_datetime(i),OKC_API.G_MISS_DATE,NULL,in_datetime(i)),
3484: DECODE(in_month(i),OKC_API.G_MISS_NUM,NULL,in_month(i)),
3485: DECODE(in_day(i),OKC_API.G_MISS_NUM,NULL,in_day(i)),
3486: DECODE(in_hour(i),OKC_API.G_MISS_NUM,NULL,in_hour(i)),
3487: DECODE(in_minute(i),OKC_API.G_MISS_NUM,NULL,in_minute(i)),
3488: DECODE(in_second(i),OKC_API.G_MISS_NUM,NULL,in_second(i)),
3489: DECODE(in_interval_yn(i),OKC_API.G_MISS_CHAR,NULL,in_interval_yn(i)),
3490: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i)),
3491: DECODE(in_nth(i),OKC_API.G_MISS_NUM,NULL,in_nth(i)),
3484: DECODE(in_month(i),OKC_API.G_MISS_NUM,NULL,in_month(i)),
3485: DECODE(in_day(i),OKC_API.G_MISS_NUM,NULL,in_day(i)),
3486: DECODE(in_hour(i),OKC_API.G_MISS_NUM,NULL,in_hour(i)),
3487: DECODE(in_minute(i),OKC_API.G_MISS_NUM,NULL,in_minute(i)),
3488: DECODE(in_second(i),OKC_API.G_MISS_NUM,NULL,in_second(i)),
3489: DECODE(in_interval_yn(i),OKC_API.G_MISS_CHAR,NULL,in_interval_yn(i)),
3490: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i)),
3491: DECODE(in_nth(i),OKC_API.G_MISS_NUM,NULL,in_nth(i)),
3492: DECODE(in_day_of_week(i),OKC_API.G_MISS_CHAR,NULL,in_day_of_week(i)),
3485: DECODE(in_day(i),OKC_API.G_MISS_NUM,NULL,in_day(i)),
3486: DECODE(in_hour(i),OKC_API.G_MISS_NUM,NULL,in_hour(i)),
3487: DECODE(in_minute(i),OKC_API.G_MISS_NUM,NULL,in_minute(i)),
3488: DECODE(in_second(i),OKC_API.G_MISS_NUM,NULL,in_second(i)),
3489: DECODE(in_interval_yn(i),OKC_API.G_MISS_CHAR,NULL,in_interval_yn(i)),
3490: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i)),
3491: DECODE(in_nth(i),OKC_API.G_MISS_NUM,NULL,in_nth(i)),
3492: DECODE(in_day_of_week(i),OKC_API.G_MISS_CHAR,NULL,in_day_of_week(i)),
3493: DECODE(in_attribute_category(i),OKC_API.G_MISS_CHAR,NULL,in_attribute_category(i)),
3486: DECODE(in_hour(i),OKC_API.G_MISS_NUM,NULL,in_hour(i)),
3487: DECODE(in_minute(i),OKC_API.G_MISS_NUM,NULL,in_minute(i)),
3488: DECODE(in_second(i),OKC_API.G_MISS_NUM,NULL,in_second(i)),
3489: DECODE(in_interval_yn(i),OKC_API.G_MISS_CHAR,NULL,in_interval_yn(i)),
3490: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i)),
3491: DECODE(in_nth(i),OKC_API.G_MISS_NUM,NULL,in_nth(i)),
3492: DECODE(in_day_of_week(i),OKC_API.G_MISS_CHAR,NULL,in_day_of_week(i)),
3493: DECODE(in_attribute_category(i),OKC_API.G_MISS_CHAR,NULL,in_attribute_category(i)),
3494: DECODE(in_attribute1(i),OKC_API.G_MISS_CHAR,NULL,in_attribute1(i)),
3487: DECODE(in_minute(i),OKC_API.G_MISS_NUM,NULL,in_minute(i)),
3488: DECODE(in_second(i),OKC_API.G_MISS_NUM,NULL,in_second(i)),
3489: DECODE(in_interval_yn(i),OKC_API.G_MISS_CHAR,NULL,in_interval_yn(i)),
3490: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i)),
3491: DECODE(in_nth(i),OKC_API.G_MISS_NUM,NULL,in_nth(i)),
3492: DECODE(in_day_of_week(i),OKC_API.G_MISS_CHAR,NULL,in_day_of_week(i)),
3493: DECODE(in_attribute_category(i),OKC_API.G_MISS_CHAR,NULL,in_attribute_category(i)),
3494: DECODE(in_attribute1(i),OKC_API.G_MISS_CHAR,NULL,in_attribute1(i)),
3495: DECODE(in_attribute2(i),OKC_API.G_MISS_CHAR,NULL,in_attribute2(i)),
3488: DECODE(in_second(i),OKC_API.G_MISS_NUM,NULL,in_second(i)),
3489: DECODE(in_interval_yn(i),OKC_API.G_MISS_CHAR,NULL,in_interval_yn(i)),
3490: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i)),
3491: DECODE(in_nth(i),OKC_API.G_MISS_NUM,NULL,in_nth(i)),
3492: DECODE(in_day_of_week(i),OKC_API.G_MISS_CHAR,NULL,in_day_of_week(i)),
3493: DECODE(in_attribute_category(i),OKC_API.G_MISS_CHAR,NULL,in_attribute_category(i)),
3494: DECODE(in_attribute1(i),OKC_API.G_MISS_CHAR,NULL,in_attribute1(i)),
3495: DECODE(in_attribute2(i),OKC_API.G_MISS_CHAR,NULL,in_attribute2(i)),
3496: DECODE(in_attribute3(i),OKC_API.G_MISS_CHAR,NULL,in_attribute3(i)),
3489: DECODE(in_interval_yn(i),OKC_API.G_MISS_CHAR,NULL,in_interval_yn(i)),
3490: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i)),
3491: DECODE(in_nth(i),OKC_API.G_MISS_NUM,NULL,in_nth(i)),
3492: DECODE(in_day_of_week(i),OKC_API.G_MISS_CHAR,NULL,in_day_of_week(i)),
3493: DECODE(in_attribute_category(i),OKC_API.G_MISS_CHAR,NULL,in_attribute_category(i)),
3494: DECODE(in_attribute1(i),OKC_API.G_MISS_CHAR,NULL,in_attribute1(i)),
3495: DECODE(in_attribute2(i),OKC_API.G_MISS_CHAR,NULL,in_attribute2(i)),
3496: DECODE(in_attribute3(i),OKC_API.G_MISS_CHAR,NULL,in_attribute3(i)),
3497: DECODE(in_attribute4(i),OKC_API.G_MISS_CHAR,NULL,in_attribute4(i)),
3490: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i)),
3491: DECODE(in_nth(i),OKC_API.G_MISS_NUM,NULL,in_nth(i)),
3492: DECODE(in_day_of_week(i),OKC_API.G_MISS_CHAR,NULL,in_day_of_week(i)),
3493: DECODE(in_attribute_category(i),OKC_API.G_MISS_CHAR,NULL,in_attribute_category(i)),
3494: DECODE(in_attribute1(i),OKC_API.G_MISS_CHAR,NULL,in_attribute1(i)),
3495: DECODE(in_attribute2(i),OKC_API.G_MISS_CHAR,NULL,in_attribute2(i)),
3496: DECODE(in_attribute3(i),OKC_API.G_MISS_CHAR,NULL,in_attribute3(i)),
3497: DECODE(in_attribute4(i),OKC_API.G_MISS_CHAR,NULL,in_attribute4(i)),
3498: DECODE(in_attribute5(i),OKC_API.G_MISS_CHAR,NULL,in_attribute5(i)),
3491: DECODE(in_nth(i),OKC_API.G_MISS_NUM,NULL,in_nth(i)),
3492: DECODE(in_day_of_week(i),OKC_API.G_MISS_CHAR,NULL,in_day_of_week(i)),
3493: DECODE(in_attribute_category(i),OKC_API.G_MISS_CHAR,NULL,in_attribute_category(i)),
3494: DECODE(in_attribute1(i),OKC_API.G_MISS_CHAR,NULL,in_attribute1(i)),
3495: DECODE(in_attribute2(i),OKC_API.G_MISS_CHAR,NULL,in_attribute2(i)),
3496: DECODE(in_attribute3(i),OKC_API.G_MISS_CHAR,NULL,in_attribute3(i)),
3497: DECODE(in_attribute4(i),OKC_API.G_MISS_CHAR,NULL,in_attribute4(i)),
3498: DECODE(in_attribute5(i),OKC_API.G_MISS_CHAR,NULL,in_attribute5(i)),
3499: DECODE(in_attribute6(i),OKC_API.G_MISS_CHAR,NULL,in_attribute6(i)),
3492: DECODE(in_day_of_week(i),OKC_API.G_MISS_CHAR,NULL,in_day_of_week(i)),
3493: DECODE(in_attribute_category(i),OKC_API.G_MISS_CHAR,NULL,in_attribute_category(i)),
3494: DECODE(in_attribute1(i),OKC_API.G_MISS_CHAR,NULL,in_attribute1(i)),
3495: DECODE(in_attribute2(i),OKC_API.G_MISS_CHAR,NULL,in_attribute2(i)),
3496: DECODE(in_attribute3(i),OKC_API.G_MISS_CHAR,NULL,in_attribute3(i)),
3497: DECODE(in_attribute4(i),OKC_API.G_MISS_CHAR,NULL,in_attribute4(i)),
3498: DECODE(in_attribute5(i),OKC_API.G_MISS_CHAR,NULL,in_attribute5(i)),
3499: DECODE(in_attribute6(i),OKC_API.G_MISS_CHAR,NULL,in_attribute6(i)),
3500: DECODE(in_attribute7(i),OKC_API.G_MISS_CHAR,NULL,in_attribute7(i)),
3493: DECODE(in_attribute_category(i),OKC_API.G_MISS_CHAR,NULL,in_attribute_category(i)),
3494: DECODE(in_attribute1(i),OKC_API.G_MISS_CHAR,NULL,in_attribute1(i)),
3495: DECODE(in_attribute2(i),OKC_API.G_MISS_CHAR,NULL,in_attribute2(i)),
3496: DECODE(in_attribute3(i),OKC_API.G_MISS_CHAR,NULL,in_attribute3(i)),
3497: DECODE(in_attribute4(i),OKC_API.G_MISS_CHAR,NULL,in_attribute4(i)),
3498: DECODE(in_attribute5(i),OKC_API.G_MISS_CHAR,NULL,in_attribute5(i)),
3499: DECODE(in_attribute6(i),OKC_API.G_MISS_CHAR,NULL,in_attribute6(i)),
3500: DECODE(in_attribute7(i),OKC_API.G_MISS_CHAR,NULL,in_attribute7(i)),
3501: DECODE(in_attribute8(i),OKC_API.G_MISS_CHAR,NULL,in_attribute8(i)),
3494: DECODE(in_attribute1(i),OKC_API.G_MISS_CHAR,NULL,in_attribute1(i)),
3495: DECODE(in_attribute2(i),OKC_API.G_MISS_CHAR,NULL,in_attribute2(i)),
3496: DECODE(in_attribute3(i),OKC_API.G_MISS_CHAR,NULL,in_attribute3(i)),
3497: DECODE(in_attribute4(i),OKC_API.G_MISS_CHAR,NULL,in_attribute4(i)),
3498: DECODE(in_attribute5(i),OKC_API.G_MISS_CHAR,NULL,in_attribute5(i)),
3499: DECODE(in_attribute6(i),OKC_API.G_MISS_CHAR,NULL,in_attribute6(i)),
3500: DECODE(in_attribute7(i),OKC_API.G_MISS_CHAR,NULL,in_attribute7(i)),
3501: DECODE(in_attribute8(i),OKC_API.G_MISS_CHAR,NULL,in_attribute8(i)),
3502: DECODE(in_attribute9(i),OKC_API.G_MISS_CHAR,NULL,in_attribute9(i)),
3495: DECODE(in_attribute2(i),OKC_API.G_MISS_CHAR,NULL,in_attribute2(i)),
3496: DECODE(in_attribute3(i),OKC_API.G_MISS_CHAR,NULL,in_attribute3(i)),
3497: DECODE(in_attribute4(i),OKC_API.G_MISS_CHAR,NULL,in_attribute4(i)),
3498: DECODE(in_attribute5(i),OKC_API.G_MISS_CHAR,NULL,in_attribute5(i)),
3499: DECODE(in_attribute6(i),OKC_API.G_MISS_CHAR,NULL,in_attribute6(i)),
3500: DECODE(in_attribute7(i),OKC_API.G_MISS_CHAR,NULL,in_attribute7(i)),
3501: DECODE(in_attribute8(i),OKC_API.G_MISS_CHAR,NULL,in_attribute8(i)),
3502: DECODE(in_attribute9(i),OKC_API.G_MISS_CHAR,NULL,in_attribute9(i)),
3503: DECODE(in_attribute10(i),OKC_API.G_MISS_CHAR,NULL,in_attribute10(i)),
3496: DECODE(in_attribute3(i),OKC_API.G_MISS_CHAR,NULL,in_attribute3(i)),
3497: DECODE(in_attribute4(i),OKC_API.G_MISS_CHAR,NULL,in_attribute4(i)),
3498: DECODE(in_attribute5(i),OKC_API.G_MISS_CHAR,NULL,in_attribute5(i)),
3499: DECODE(in_attribute6(i),OKC_API.G_MISS_CHAR,NULL,in_attribute6(i)),
3500: DECODE(in_attribute7(i),OKC_API.G_MISS_CHAR,NULL,in_attribute7(i)),
3501: DECODE(in_attribute8(i),OKC_API.G_MISS_CHAR,NULL,in_attribute8(i)),
3502: DECODE(in_attribute9(i),OKC_API.G_MISS_CHAR,NULL,in_attribute9(i)),
3503: DECODE(in_attribute10(i),OKC_API.G_MISS_CHAR,NULL,in_attribute10(i)),
3504: DECODE(in_attribute11(i),OKC_API.G_MISS_CHAR,NULL,in_attribute11(i)),
3497: DECODE(in_attribute4(i),OKC_API.G_MISS_CHAR,NULL,in_attribute4(i)),
3498: DECODE(in_attribute5(i),OKC_API.G_MISS_CHAR,NULL,in_attribute5(i)),
3499: DECODE(in_attribute6(i),OKC_API.G_MISS_CHAR,NULL,in_attribute6(i)),
3500: DECODE(in_attribute7(i),OKC_API.G_MISS_CHAR,NULL,in_attribute7(i)),
3501: DECODE(in_attribute8(i),OKC_API.G_MISS_CHAR,NULL,in_attribute8(i)),
3502: DECODE(in_attribute9(i),OKC_API.G_MISS_CHAR,NULL,in_attribute9(i)),
3503: DECODE(in_attribute10(i),OKC_API.G_MISS_CHAR,NULL,in_attribute10(i)),
3504: DECODE(in_attribute11(i),OKC_API.G_MISS_CHAR,NULL,in_attribute11(i)),
3505: DECODE(in_attribute12(i),OKC_API.G_MISS_CHAR,NULL,in_attribute12(i)),
3498: DECODE(in_attribute5(i),OKC_API.G_MISS_CHAR,NULL,in_attribute5(i)),
3499: DECODE(in_attribute6(i),OKC_API.G_MISS_CHAR,NULL,in_attribute6(i)),
3500: DECODE(in_attribute7(i),OKC_API.G_MISS_CHAR,NULL,in_attribute7(i)),
3501: DECODE(in_attribute8(i),OKC_API.G_MISS_CHAR,NULL,in_attribute8(i)),
3502: DECODE(in_attribute9(i),OKC_API.G_MISS_CHAR,NULL,in_attribute9(i)),
3503: DECODE(in_attribute10(i),OKC_API.G_MISS_CHAR,NULL,in_attribute10(i)),
3504: DECODE(in_attribute11(i),OKC_API.G_MISS_CHAR,NULL,in_attribute11(i)),
3505: DECODE(in_attribute12(i),OKC_API.G_MISS_CHAR,NULL,in_attribute12(i)),
3506: DECODE(in_attribute13(i),OKC_API.G_MISS_CHAR,NULL,in_attribute13(i)),
3499: DECODE(in_attribute6(i),OKC_API.G_MISS_CHAR,NULL,in_attribute6(i)),
3500: DECODE(in_attribute7(i),OKC_API.G_MISS_CHAR,NULL,in_attribute7(i)),
3501: DECODE(in_attribute8(i),OKC_API.G_MISS_CHAR,NULL,in_attribute8(i)),
3502: DECODE(in_attribute9(i),OKC_API.G_MISS_CHAR,NULL,in_attribute9(i)),
3503: DECODE(in_attribute10(i),OKC_API.G_MISS_CHAR,NULL,in_attribute10(i)),
3504: DECODE(in_attribute11(i),OKC_API.G_MISS_CHAR,NULL,in_attribute11(i)),
3505: DECODE(in_attribute12(i),OKC_API.G_MISS_CHAR,NULL,in_attribute12(i)),
3506: DECODE(in_attribute13(i),OKC_API.G_MISS_CHAR,NULL,in_attribute13(i)),
3507: DECODE(in_attribute14(i),OKC_API.G_MISS_CHAR,NULL,in_attribute14(i)),
3500: DECODE(in_attribute7(i),OKC_API.G_MISS_CHAR,NULL,in_attribute7(i)),
3501: DECODE(in_attribute8(i),OKC_API.G_MISS_CHAR,NULL,in_attribute8(i)),
3502: DECODE(in_attribute9(i),OKC_API.G_MISS_CHAR,NULL,in_attribute9(i)),
3503: DECODE(in_attribute10(i),OKC_API.G_MISS_CHAR,NULL,in_attribute10(i)),
3504: DECODE(in_attribute11(i),OKC_API.G_MISS_CHAR,NULL,in_attribute11(i)),
3505: DECODE(in_attribute12(i),OKC_API.G_MISS_CHAR,NULL,in_attribute12(i)),
3506: DECODE(in_attribute13(i),OKC_API.G_MISS_CHAR,NULL,in_attribute13(i)),
3507: DECODE(in_attribute14(i),OKC_API.G_MISS_CHAR,NULL,in_attribute14(i)),
3508: DECODE(in_attribute15(i),OKC_API.G_MISS_CHAR,NULL,in_attribute15(i)),
3501: DECODE(in_attribute8(i),OKC_API.G_MISS_CHAR,NULL,in_attribute8(i)),
3502: DECODE(in_attribute9(i),OKC_API.G_MISS_CHAR,NULL,in_attribute9(i)),
3503: DECODE(in_attribute10(i),OKC_API.G_MISS_CHAR,NULL,in_attribute10(i)),
3504: DECODE(in_attribute11(i),OKC_API.G_MISS_CHAR,NULL,in_attribute11(i)),
3505: DECODE(in_attribute12(i),OKC_API.G_MISS_CHAR,NULL,in_attribute12(i)),
3506: DECODE(in_attribute13(i),OKC_API.G_MISS_CHAR,NULL,in_attribute13(i)),
3507: DECODE(in_attribute14(i),OKC_API.G_MISS_CHAR,NULL,in_attribute14(i)),
3508: DECODE(in_attribute15(i),OKC_API.G_MISS_CHAR,NULL,in_attribute15(i)),
3509: --Bug 3122962
3502: DECODE(in_attribute9(i),OKC_API.G_MISS_CHAR,NULL,in_attribute9(i)),
3503: DECODE(in_attribute10(i),OKC_API.G_MISS_CHAR,NULL,in_attribute10(i)),
3504: DECODE(in_attribute11(i),OKC_API.G_MISS_CHAR,NULL,in_attribute11(i)),
3505: DECODE(in_attribute12(i),OKC_API.G_MISS_CHAR,NULL,in_attribute12(i)),
3506: DECODE(in_attribute13(i),OKC_API.G_MISS_CHAR,NULL,in_attribute13(i)),
3507: DECODE(in_attribute14(i),OKC_API.G_MISS_CHAR,NULL,in_attribute14(i)),
3508: DECODE(in_attribute15(i),OKC_API.G_MISS_CHAR,NULL,in_attribute15(i)),
3509: --Bug 3122962
3510: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3503: DECODE(in_attribute10(i),OKC_API.G_MISS_CHAR,NULL,in_attribute10(i)),
3504: DECODE(in_attribute11(i),OKC_API.G_MISS_CHAR,NULL,in_attribute11(i)),
3505: DECODE(in_attribute12(i),OKC_API.G_MISS_CHAR,NULL,in_attribute12(i)),
3506: DECODE(in_attribute13(i),OKC_API.G_MISS_CHAR,NULL,in_attribute13(i)),
3507: DECODE(in_attribute14(i),OKC_API.G_MISS_CHAR,NULL,in_attribute14(i)),
3508: DECODE(in_attribute15(i),OKC_API.G_MISS_CHAR,NULL,in_attribute15(i)),
3509: --Bug 3122962
3510: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3511: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
3504: DECODE(in_attribute11(i),OKC_API.G_MISS_CHAR,NULL,in_attribute11(i)),
3505: DECODE(in_attribute12(i),OKC_API.G_MISS_CHAR,NULL,in_attribute12(i)),
3506: DECODE(in_attribute13(i),OKC_API.G_MISS_CHAR,NULL,in_attribute13(i)),
3507: DECODE(in_attribute14(i),OKC_API.G_MISS_CHAR,NULL,in_attribute14(i)),
3508: DECODE(in_attribute15(i),OKC_API.G_MISS_CHAR,NULL,in_attribute15(i)),
3509: --Bug 3122962
3510: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3511: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
3512: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
3506: DECODE(in_attribute13(i),OKC_API.G_MISS_CHAR,NULL,in_attribute13(i)),
3507: DECODE(in_attribute14(i),OKC_API.G_MISS_CHAR,NULL,in_attribute14(i)),
3508: DECODE(in_attribute15(i),OKC_API.G_MISS_CHAR,NULL,in_attribute15(i)),
3509: --Bug 3122962
3510: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3511: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
3512: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
3513: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i))
3514: );
3507: DECODE(in_attribute14(i),OKC_API.G_MISS_CHAR,NULL,in_attribute14(i)),
3508: DECODE(in_attribute15(i),OKC_API.G_MISS_CHAR,NULL,in_attribute15(i)),
3509: --Bug 3122962
3510: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3511: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
3512: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
3513: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i))
3514: );
3515: --Bug 3122962
3508: DECODE(in_attribute15(i),OKC_API.G_MISS_CHAR,NULL,in_attribute15(i)),
3509: --Bug 3122962
3510: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3511: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
3512: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
3513: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i))
3514: );
3515: --Bug 3122962
3516: /*
3509: --Bug 3122962
3510: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3511: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
3512: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
3513: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i))
3514: );
3515: --Bug 3122962
3516: /*
3517: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST LOOP
3531: last_update_date,
3532: last_update_login
3533: )
3534: VALUES (
3535: DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
3536: OKC_UTIL.g_language_code(lang_i),
3537: l_source_lang,
3538: DECODE(in_sfwt_flag(i),OKC_API.G_MISS_CHAR,NULL,in_sfwt_flag(i)),
3539: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
3534: VALUES (
3535: DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
3536: OKC_UTIL.g_language_code(lang_i),
3537: l_source_lang,
3538: DECODE(in_sfwt_flag(i),OKC_API.G_MISS_CHAR,NULL,in_sfwt_flag(i)),
3539: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
3540: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
3541: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i)),
3542: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3535: DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
3536: OKC_UTIL.g_language_code(lang_i),
3537: l_source_lang,
3538: DECODE(in_sfwt_flag(i),OKC_API.G_MISS_CHAR,NULL,in_sfwt_flag(i)),
3539: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
3540: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
3541: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i)),
3542: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3543: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3536: OKC_UTIL.g_language_code(lang_i),
3537: l_source_lang,
3538: DECODE(in_sfwt_flag(i),OKC_API.G_MISS_CHAR,NULL,in_sfwt_flag(i)),
3539: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
3540: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
3541: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i)),
3542: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3543: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3544: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3537: l_source_lang,
3538: DECODE(in_sfwt_flag(i),OKC_API.G_MISS_CHAR,NULL,in_sfwt_flag(i)),
3539: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
3540: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
3541: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i)),
3542: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3543: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3544: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3545: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3538: DECODE(in_sfwt_flag(i),OKC_API.G_MISS_CHAR,NULL,in_sfwt_flag(i)),
3539: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
3540: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
3541: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i)),
3542: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3543: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3544: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3545: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3546: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3539: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
3540: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
3541: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i)),
3542: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3543: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3544: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3545: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3546: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3547: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i))
3540: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
3541: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i)),
3542: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3543: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3544: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3545: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3546: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3547: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i))
3548: );
3541: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i)),
3542: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3543: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3544: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3545: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3546: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3547: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i))
3548: );
3549: END LOOP;
3542: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3543: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3544: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3545: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3546: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3547: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i))
3548: );
3549: END LOOP;
3550: */
3543: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3544: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3545: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3546: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3547: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i))
3548: );
3549: END LOOP;
3550: */
3551: EXCEPTION
3610: l_tve_id_started NUMBER;
3611: l_tve_id_ended NUMBER;
3612: i NUMBER := p_isev_ext_tbl.FIRST;
3613: j NUMBER := 0;
3614: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3615: BEGIN
3616: while i is NOT NULL
3617: LOOP
3618: /* FOR ISE STARTED */
3686: in_description (j) := p_isev_ext_tbl(i).description;
3687: in_short_description (j) := p_isev_ext_tbl(i).short_description;
3688: in_comments (j) := p_isev_ext_tbl(i).comments;
3689: if p_isev_ext_tbl(i).duration is null or
3690: p_isev_ext_tbl(i).duration = OKC_API.G_MISS_NUM then
3691: if p_isev_ext_tbl(i).end_date is NOT NULL and
3692: p_isev_ext_tbl(i).end_date <> OKC_API.G_MISS_DATE then
3693: okc_time_util_pub.get_duration(p_isev_ext_tbl(i).start_date, p_isev_ext_tbl(i).end_date,in_duration(j),
3694: in_uom_code(j),x_return_status);
3688: in_comments (j) := p_isev_ext_tbl(i).comments;
3689: if p_isev_ext_tbl(i).duration is null or
3690: p_isev_ext_tbl(i).duration = OKC_API.G_MISS_NUM then
3691: if p_isev_ext_tbl(i).end_date is NOT NULL and
3692: p_isev_ext_tbl(i).end_date <> OKC_API.G_MISS_DATE then
3693: okc_time_util_pub.get_duration(p_isev_ext_tbl(i).start_date, p_isev_ext_tbl(i).end_date,in_duration(j),
3694: in_uom_code(j),x_return_status);
3695: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
3696: return;
3691: if p_isev_ext_tbl(i).end_date is NOT NULL and
3692: p_isev_ext_tbl(i).end_date <> OKC_API.G_MISS_DATE then
3693: okc_time_util_pub.get_duration(p_isev_ext_tbl(i).start_date, p_isev_ext_tbl(i).end_date,in_duration(j),
3694: in_uom_code(j),x_return_status);
3695: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
3696: return;
3697: end if;
3698: else
3699: in_duration(j) := NULL;
3796: short_description,
3797: comments
3798: )
3799: VALUES (
3800: DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
3801: DECODE(in_spn_id(i),OKC_API.G_MISS_NUM,NULL,in_spn_id(i)),
3802: DECODE(in_tve_id_offset(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_offset(i)),
3803: DECODE(in_tve_id_generated_by(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_generated_by(i)),
3804: DECODE(in_tve_id_started(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_started(i)),
3797: comments
3798: )
3799: VALUES (
3800: DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
3801: DECODE(in_spn_id(i),OKC_API.G_MISS_NUM,NULL,in_spn_id(i)),
3802: DECODE(in_tve_id_offset(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_offset(i)),
3803: DECODE(in_tve_id_generated_by(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_generated_by(i)),
3804: DECODE(in_tve_id_started(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_started(i)),
3805: DECODE(in_tve_id_ended(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_ended(i)),
3798: )
3799: VALUES (
3800: DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
3801: DECODE(in_spn_id(i),OKC_API.G_MISS_NUM,NULL,in_spn_id(i)),
3802: DECODE(in_tve_id_offset(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_offset(i)),
3803: DECODE(in_tve_id_generated_by(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_generated_by(i)),
3804: DECODE(in_tve_id_started(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_started(i)),
3805: DECODE(in_tve_id_ended(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_ended(i)),
3806: DECODE(in_tve_id_limited(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_limited(i)),
3799: VALUES (
3800: DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
3801: DECODE(in_spn_id(i),OKC_API.G_MISS_NUM,NULL,in_spn_id(i)),
3802: DECODE(in_tve_id_offset(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_offset(i)),
3803: DECODE(in_tve_id_generated_by(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_generated_by(i)),
3804: DECODE(in_tve_id_started(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_started(i)),
3805: DECODE(in_tve_id_ended(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_ended(i)),
3806: DECODE(in_tve_id_limited(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_limited(i)),
3807: DECODE(in_cnh_id(i),OKC_API.G_MISS_NUM,NULL,in_cnh_id(i)),
3800: DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
3801: DECODE(in_spn_id(i),OKC_API.G_MISS_NUM,NULL,in_spn_id(i)),
3802: DECODE(in_tve_id_offset(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_offset(i)),
3803: DECODE(in_tve_id_generated_by(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_generated_by(i)),
3804: DECODE(in_tve_id_started(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_started(i)),
3805: DECODE(in_tve_id_ended(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_ended(i)),
3806: DECODE(in_tve_id_limited(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_limited(i)),
3807: DECODE(in_cnh_id(i),OKC_API.G_MISS_NUM,NULL,in_cnh_id(i)),
3808: DECODE(in_dnz_chr_id(i),OKC_API.G_MISS_NUM,NULL,in_dnz_chr_id(i)),
3801: DECODE(in_spn_id(i),OKC_API.G_MISS_NUM,NULL,in_spn_id(i)),
3802: DECODE(in_tve_id_offset(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_offset(i)),
3803: DECODE(in_tve_id_generated_by(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_generated_by(i)),
3804: DECODE(in_tve_id_started(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_started(i)),
3805: DECODE(in_tve_id_ended(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_ended(i)),
3806: DECODE(in_tve_id_limited(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_limited(i)),
3807: DECODE(in_cnh_id(i),OKC_API.G_MISS_NUM,NULL,in_cnh_id(i)),
3808: DECODE(in_dnz_chr_id(i),OKC_API.G_MISS_NUM,NULL,in_dnz_chr_id(i)),
3809: DECODE(in_tve_type(i),OKC_API.G_MISS_CHAR,NULL,in_tve_type(i)),
3802: DECODE(in_tve_id_offset(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_offset(i)),
3803: DECODE(in_tve_id_generated_by(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_generated_by(i)),
3804: DECODE(in_tve_id_started(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_started(i)),
3805: DECODE(in_tve_id_ended(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_ended(i)),
3806: DECODE(in_tve_id_limited(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_limited(i)),
3807: DECODE(in_cnh_id(i),OKC_API.G_MISS_NUM,NULL,in_cnh_id(i)),
3808: DECODE(in_dnz_chr_id(i),OKC_API.G_MISS_NUM,NULL,in_dnz_chr_id(i)),
3809: DECODE(in_tve_type(i),OKC_API.G_MISS_CHAR,NULL,in_tve_type(i)),
3810: DECODE(in_tze_id(i),OKC_API.G_MISS_NUM,NULL,in_tze_id(i)),
3803: DECODE(in_tve_id_generated_by(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_generated_by(i)),
3804: DECODE(in_tve_id_started(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_started(i)),
3805: DECODE(in_tve_id_ended(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_ended(i)),
3806: DECODE(in_tve_id_limited(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_limited(i)),
3807: DECODE(in_cnh_id(i),OKC_API.G_MISS_NUM,NULL,in_cnh_id(i)),
3808: DECODE(in_dnz_chr_id(i),OKC_API.G_MISS_NUM,NULL,in_dnz_chr_id(i)),
3809: DECODE(in_tve_type(i),OKC_API.G_MISS_CHAR,NULL,in_tve_type(i)),
3810: DECODE(in_tze_id(i),OKC_API.G_MISS_NUM,NULL,in_tze_id(i)),
3811: DECODE(in_object_version_number(i),OKC_API.G_MISS_NUM,NULL,in_object_version_number(i)),
3804: DECODE(in_tve_id_started(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_started(i)),
3805: DECODE(in_tve_id_ended(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_ended(i)),
3806: DECODE(in_tve_id_limited(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_limited(i)),
3807: DECODE(in_cnh_id(i),OKC_API.G_MISS_NUM,NULL,in_cnh_id(i)),
3808: DECODE(in_dnz_chr_id(i),OKC_API.G_MISS_NUM,NULL,in_dnz_chr_id(i)),
3809: DECODE(in_tve_type(i),OKC_API.G_MISS_CHAR,NULL,in_tve_type(i)),
3810: DECODE(in_tze_id(i),OKC_API.G_MISS_NUM,NULL,in_tze_id(i)),
3811: DECODE(in_object_version_number(i),OKC_API.G_MISS_NUM,NULL,in_object_version_number(i)),
3812: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3805: DECODE(in_tve_id_ended(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_ended(i)),
3806: DECODE(in_tve_id_limited(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_limited(i)),
3807: DECODE(in_cnh_id(i),OKC_API.G_MISS_NUM,NULL,in_cnh_id(i)),
3808: DECODE(in_dnz_chr_id(i),OKC_API.G_MISS_NUM,NULL,in_dnz_chr_id(i)),
3809: DECODE(in_tve_type(i),OKC_API.G_MISS_CHAR,NULL,in_tve_type(i)),
3810: DECODE(in_tze_id(i),OKC_API.G_MISS_NUM,NULL,in_tze_id(i)),
3811: DECODE(in_object_version_number(i),OKC_API.G_MISS_NUM,NULL,in_object_version_number(i)),
3812: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3813: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3806: DECODE(in_tve_id_limited(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_limited(i)),
3807: DECODE(in_cnh_id(i),OKC_API.G_MISS_NUM,NULL,in_cnh_id(i)),
3808: DECODE(in_dnz_chr_id(i),OKC_API.G_MISS_NUM,NULL,in_dnz_chr_id(i)),
3809: DECODE(in_tve_type(i),OKC_API.G_MISS_CHAR,NULL,in_tve_type(i)),
3810: DECODE(in_tze_id(i),OKC_API.G_MISS_NUM,NULL,in_tze_id(i)),
3811: DECODE(in_object_version_number(i),OKC_API.G_MISS_NUM,NULL,in_object_version_number(i)),
3812: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3813: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3814: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3807: DECODE(in_cnh_id(i),OKC_API.G_MISS_NUM,NULL,in_cnh_id(i)),
3808: DECODE(in_dnz_chr_id(i),OKC_API.G_MISS_NUM,NULL,in_dnz_chr_id(i)),
3809: DECODE(in_tve_type(i),OKC_API.G_MISS_CHAR,NULL,in_tve_type(i)),
3810: DECODE(in_tze_id(i),OKC_API.G_MISS_NUM,NULL,in_tze_id(i)),
3811: DECODE(in_object_version_number(i),OKC_API.G_MISS_NUM,NULL,in_object_version_number(i)),
3812: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3813: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3814: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3815: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3808: DECODE(in_dnz_chr_id(i),OKC_API.G_MISS_NUM,NULL,in_dnz_chr_id(i)),
3809: DECODE(in_tve_type(i),OKC_API.G_MISS_CHAR,NULL,in_tve_type(i)),
3810: DECODE(in_tze_id(i),OKC_API.G_MISS_NUM,NULL,in_tze_id(i)),
3811: DECODE(in_object_version_number(i),OKC_API.G_MISS_NUM,NULL,in_object_version_number(i)),
3812: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3813: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3814: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3815: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3816: DECODE(in_uom_code(i),OKC_API.G_MISS_CHAR,NULL,in_uom_code(i)),
3809: DECODE(in_tve_type(i),OKC_API.G_MISS_CHAR,NULL,in_tve_type(i)),
3810: DECODE(in_tze_id(i),OKC_API.G_MISS_NUM,NULL,in_tze_id(i)),
3811: DECODE(in_object_version_number(i),OKC_API.G_MISS_NUM,NULL,in_object_version_number(i)),
3812: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3813: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3814: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3815: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3816: DECODE(in_uom_code(i),OKC_API.G_MISS_CHAR,NULL,in_uom_code(i)),
3817: DECODE(in_duration(i),OKC_API.G_MISS_NUM,NULL,in_duration(i)),
3810: DECODE(in_tze_id(i),OKC_API.G_MISS_NUM,NULL,in_tze_id(i)),
3811: DECODE(in_object_version_number(i),OKC_API.G_MISS_NUM,NULL,in_object_version_number(i)),
3812: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3813: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3814: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3815: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3816: DECODE(in_uom_code(i),OKC_API.G_MISS_CHAR,NULL,in_uom_code(i)),
3817: DECODE(in_duration(i),OKC_API.G_MISS_NUM,NULL,in_duration(i)),
3818: DECODE(in_operator(i),OKC_API.G_MISS_CHAR,NULL,in_operator(i)),
3811: DECODE(in_object_version_number(i),OKC_API.G_MISS_NUM,NULL,in_object_version_number(i)),
3812: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3813: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3814: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3815: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3816: DECODE(in_uom_code(i),OKC_API.G_MISS_CHAR,NULL,in_uom_code(i)),
3817: DECODE(in_duration(i),OKC_API.G_MISS_NUM,NULL,in_duration(i)),
3818: DECODE(in_operator(i),OKC_API.G_MISS_CHAR,NULL,in_operator(i)),
3819: DECODE(in_before_after(i),OKC_API.G_MISS_CHAR,NULL,in_before_after(i)),
3812: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3813: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3814: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3815: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3816: DECODE(in_uom_code(i),OKC_API.G_MISS_CHAR,NULL,in_uom_code(i)),
3817: DECODE(in_duration(i),OKC_API.G_MISS_NUM,NULL,in_duration(i)),
3818: DECODE(in_operator(i),OKC_API.G_MISS_CHAR,NULL,in_operator(i)),
3819: DECODE(in_before_after(i),OKC_API.G_MISS_CHAR,NULL,in_before_after(i)),
3820: DECODE(in_datetime(i),OKC_API.G_MISS_DATE,NULL,in_datetime(i)),
3813: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3814: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3815: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3816: DECODE(in_uom_code(i),OKC_API.G_MISS_CHAR,NULL,in_uom_code(i)),
3817: DECODE(in_duration(i),OKC_API.G_MISS_NUM,NULL,in_duration(i)),
3818: DECODE(in_operator(i),OKC_API.G_MISS_CHAR,NULL,in_operator(i)),
3819: DECODE(in_before_after(i),OKC_API.G_MISS_CHAR,NULL,in_before_after(i)),
3820: DECODE(in_datetime(i),OKC_API.G_MISS_DATE,NULL,in_datetime(i)),
3821: DECODE(in_month(i),OKC_API.G_MISS_NUM,NULL,in_month(i)),
3814: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3815: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3816: DECODE(in_uom_code(i),OKC_API.G_MISS_CHAR,NULL,in_uom_code(i)),
3817: DECODE(in_duration(i),OKC_API.G_MISS_NUM,NULL,in_duration(i)),
3818: DECODE(in_operator(i),OKC_API.G_MISS_CHAR,NULL,in_operator(i)),
3819: DECODE(in_before_after(i),OKC_API.G_MISS_CHAR,NULL,in_before_after(i)),
3820: DECODE(in_datetime(i),OKC_API.G_MISS_DATE,NULL,in_datetime(i)),
3821: DECODE(in_month(i),OKC_API.G_MISS_NUM,NULL,in_month(i)),
3822: DECODE(in_day(i),OKC_API.G_MISS_NUM,NULL,in_day(i)),
3815: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3816: DECODE(in_uom_code(i),OKC_API.G_MISS_CHAR,NULL,in_uom_code(i)),
3817: DECODE(in_duration(i),OKC_API.G_MISS_NUM,NULL,in_duration(i)),
3818: DECODE(in_operator(i),OKC_API.G_MISS_CHAR,NULL,in_operator(i)),
3819: DECODE(in_before_after(i),OKC_API.G_MISS_CHAR,NULL,in_before_after(i)),
3820: DECODE(in_datetime(i),OKC_API.G_MISS_DATE,NULL,in_datetime(i)),
3821: DECODE(in_month(i),OKC_API.G_MISS_NUM,NULL,in_month(i)),
3822: DECODE(in_day(i),OKC_API.G_MISS_NUM,NULL,in_day(i)),
3823: DECODE(in_hour(i),OKC_API.G_MISS_NUM,NULL,in_hour(i)),
3816: DECODE(in_uom_code(i),OKC_API.G_MISS_CHAR,NULL,in_uom_code(i)),
3817: DECODE(in_duration(i),OKC_API.G_MISS_NUM,NULL,in_duration(i)),
3818: DECODE(in_operator(i),OKC_API.G_MISS_CHAR,NULL,in_operator(i)),
3819: DECODE(in_before_after(i),OKC_API.G_MISS_CHAR,NULL,in_before_after(i)),
3820: DECODE(in_datetime(i),OKC_API.G_MISS_DATE,NULL,in_datetime(i)),
3821: DECODE(in_month(i),OKC_API.G_MISS_NUM,NULL,in_month(i)),
3822: DECODE(in_day(i),OKC_API.G_MISS_NUM,NULL,in_day(i)),
3823: DECODE(in_hour(i),OKC_API.G_MISS_NUM,NULL,in_hour(i)),
3824: DECODE(in_minute(i),OKC_API.G_MISS_NUM,NULL,in_minute(i)),
3817: DECODE(in_duration(i),OKC_API.G_MISS_NUM,NULL,in_duration(i)),
3818: DECODE(in_operator(i),OKC_API.G_MISS_CHAR,NULL,in_operator(i)),
3819: DECODE(in_before_after(i),OKC_API.G_MISS_CHAR,NULL,in_before_after(i)),
3820: DECODE(in_datetime(i),OKC_API.G_MISS_DATE,NULL,in_datetime(i)),
3821: DECODE(in_month(i),OKC_API.G_MISS_NUM,NULL,in_month(i)),
3822: DECODE(in_day(i),OKC_API.G_MISS_NUM,NULL,in_day(i)),
3823: DECODE(in_hour(i),OKC_API.G_MISS_NUM,NULL,in_hour(i)),
3824: DECODE(in_minute(i),OKC_API.G_MISS_NUM,NULL,in_minute(i)),
3825: DECODE(in_second(i),OKC_API.G_MISS_NUM,NULL,in_second(i)),
3818: DECODE(in_operator(i),OKC_API.G_MISS_CHAR,NULL,in_operator(i)),
3819: DECODE(in_before_after(i),OKC_API.G_MISS_CHAR,NULL,in_before_after(i)),
3820: DECODE(in_datetime(i),OKC_API.G_MISS_DATE,NULL,in_datetime(i)),
3821: DECODE(in_month(i),OKC_API.G_MISS_NUM,NULL,in_month(i)),
3822: DECODE(in_day(i),OKC_API.G_MISS_NUM,NULL,in_day(i)),
3823: DECODE(in_hour(i),OKC_API.G_MISS_NUM,NULL,in_hour(i)),
3824: DECODE(in_minute(i),OKC_API.G_MISS_NUM,NULL,in_minute(i)),
3825: DECODE(in_second(i),OKC_API.G_MISS_NUM,NULL,in_second(i)),
3826: DECODE(in_interval_yn(i),OKC_API.G_MISS_CHAR,NULL,in_interval_yn(i)),
3819: DECODE(in_before_after(i),OKC_API.G_MISS_CHAR,NULL,in_before_after(i)),
3820: DECODE(in_datetime(i),OKC_API.G_MISS_DATE,NULL,in_datetime(i)),
3821: DECODE(in_month(i),OKC_API.G_MISS_NUM,NULL,in_month(i)),
3822: DECODE(in_day(i),OKC_API.G_MISS_NUM,NULL,in_day(i)),
3823: DECODE(in_hour(i),OKC_API.G_MISS_NUM,NULL,in_hour(i)),
3824: DECODE(in_minute(i),OKC_API.G_MISS_NUM,NULL,in_minute(i)),
3825: DECODE(in_second(i),OKC_API.G_MISS_NUM,NULL,in_second(i)),
3826: DECODE(in_interval_yn(i),OKC_API.G_MISS_CHAR,NULL,in_interval_yn(i)),
3827: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i)),
3820: DECODE(in_datetime(i),OKC_API.G_MISS_DATE,NULL,in_datetime(i)),
3821: DECODE(in_month(i),OKC_API.G_MISS_NUM,NULL,in_month(i)),
3822: DECODE(in_day(i),OKC_API.G_MISS_NUM,NULL,in_day(i)),
3823: DECODE(in_hour(i),OKC_API.G_MISS_NUM,NULL,in_hour(i)),
3824: DECODE(in_minute(i),OKC_API.G_MISS_NUM,NULL,in_minute(i)),
3825: DECODE(in_second(i),OKC_API.G_MISS_NUM,NULL,in_second(i)),
3826: DECODE(in_interval_yn(i),OKC_API.G_MISS_CHAR,NULL,in_interval_yn(i)),
3827: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i)),
3828: DECODE(in_nth(i),OKC_API.G_MISS_NUM,NULL,in_nth(i)),
3821: DECODE(in_month(i),OKC_API.G_MISS_NUM,NULL,in_month(i)),
3822: DECODE(in_day(i),OKC_API.G_MISS_NUM,NULL,in_day(i)),
3823: DECODE(in_hour(i),OKC_API.G_MISS_NUM,NULL,in_hour(i)),
3824: DECODE(in_minute(i),OKC_API.G_MISS_NUM,NULL,in_minute(i)),
3825: DECODE(in_second(i),OKC_API.G_MISS_NUM,NULL,in_second(i)),
3826: DECODE(in_interval_yn(i),OKC_API.G_MISS_CHAR,NULL,in_interval_yn(i)),
3827: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i)),
3828: DECODE(in_nth(i),OKC_API.G_MISS_NUM,NULL,in_nth(i)),
3829: DECODE(in_day_of_week(i),OKC_API.G_MISS_CHAR,NULL,in_day_of_week(i)),
3822: DECODE(in_day(i),OKC_API.G_MISS_NUM,NULL,in_day(i)),
3823: DECODE(in_hour(i),OKC_API.G_MISS_NUM,NULL,in_hour(i)),
3824: DECODE(in_minute(i),OKC_API.G_MISS_NUM,NULL,in_minute(i)),
3825: DECODE(in_second(i),OKC_API.G_MISS_NUM,NULL,in_second(i)),
3826: DECODE(in_interval_yn(i),OKC_API.G_MISS_CHAR,NULL,in_interval_yn(i)),
3827: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i)),
3828: DECODE(in_nth(i),OKC_API.G_MISS_NUM,NULL,in_nth(i)),
3829: DECODE(in_day_of_week(i),OKC_API.G_MISS_CHAR,NULL,in_day_of_week(i)),
3830: DECODE(in_attribute_category(i),OKC_API.G_MISS_CHAR,NULL,in_attribute_category(i)),
3823: DECODE(in_hour(i),OKC_API.G_MISS_NUM,NULL,in_hour(i)),
3824: DECODE(in_minute(i),OKC_API.G_MISS_NUM,NULL,in_minute(i)),
3825: DECODE(in_second(i),OKC_API.G_MISS_NUM,NULL,in_second(i)),
3826: DECODE(in_interval_yn(i),OKC_API.G_MISS_CHAR,NULL,in_interval_yn(i)),
3827: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i)),
3828: DECODE(in_nth(i),OKC_API.G_MISS_NUM,NULL,in_nth(i)),
3829: DECODE(in_day_of_week(i),OKC_API.G_MISS_CHAR,NULL,in_day_of_week(i)),
3830: DECODE(in_attribute_category(i),OKC_API.G_MISS_CHAR,NULL,in_attribute_category(i)),
3831: DECODE(in_attribute1(i),OKC_API.G_MISS_CHAR,NULL,in_attribute1(i)),
3824: DECODE(in_minute(i),OKC_API.G_MISS_NUM,NULL,in_minute(i)),
3825: DECODE(in_second(i),OKC_API.G_MISS_NUM,NULL,in_second(i)),
3826: DECODE(in_interval_yn(i),OKC_API.G_MISS_CHAR,NULL,in_interval_yn(i)),
3827: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i)),
3828: DECODE(in_nth(i),OKC_API.G_MISS_NUM,NULL,in_nth(i)),
3829: DECODE(in_day_of_week(i),OKC_API.G_MISS_CHAR,NULL,in_day_of_week(i)),
3830: DECODE(in_attribute_category(i),OKC_API.G_MISS_CHAR,NULL,in_attribute_category(i)),
3831: DECODE(in_attribute1(i),OKC_API.G_MISS_CHAR,NULL,in_attribute1(i)),
3832: DECODE(in_attribute2(i),OKC_API.G_MISS_CHAR,NULL,in_attribute2(i)),
3825: DECODE(in_second(i),OKC_API.G_MISS_NUM,NULL,in_second(i)),
3826: DECODE(in_interval_yn(i),OKC_API.G_MISS_CHAR,NULL,in_interval_yn(i)),
3827: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i)),
3828: DECODE(in_nth(i),OKC_API.G_MISS_NUM,NULL,in_nth(i)),
3829: DECODE(in_day_of_week(i),OKC_API.G_MISS_CHAR,NULL,in_day_of_week(i)),
3830: DECODE(in_attribute_category(i),OKC_API.G_MISS_CHAR,NULL,in_attribute_category(i)),
3831: DECODE(in_attribute1(i),OKC_API.G_MISS_CHAR,NULL,in_attribute1(i)),
3832: DECODE(in_attribute2(i),OKC_API.G_MISS_CHAR,NULL,in_attribute2(i)),
3833: DECODE(in_attribute3(i),OKC_API.G_MISS_CHAR,NULL,in_attribute3(i)),
3826: DECODE(in_interval_yn(i),OKC_API.G_MISS_CHAR,NULL,in_interval_yn(i)),
3827: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i)),
3828: DECODE(in_nth(i),OKC_API.G_MISS_NUM,NULL,in_nth(i)),
3829: DECODE(in_day_of_week(i),OKC_API.G_MISS_CHAR,NULL,in_day_of_week(i)),
3830: DECODE(in_attribute_category(i),OKC_API.G_MISS_CHAR,NULL,in_attribute_category(i)),
3831: DECODE(in_attribute1(i),OKC_API.G_MISS_CHAR,NULL,in_attribute1(i)),
3832: DECODE(in_attribute2(i),OKC_API.G_MISS_CHAR,NULL,in_attribute2(i)),
3833: DECODE(in_attribute3(i),OKC_API.G_MISS_CHAR,NULL,in_attribute3(i)),
3834: DECODE(in_attribute4(i),OKC_API.G_MISS_CHAR,NULL,in_attribute4(i)),
3827: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i)),
3828: DECODE(in_nth(i),OKC_API.G_MISS_NUM,NULL,in_nth(i)),
3829: DECODE(in_day_of_week(i),OKC_API.G_MISS_CHAR,NULL,in_day_of_week(i)),
3830: DECODE(in_attribute_category(i),OKC_API.G_MISS_CHAR,NULL,in_attribute_category(i)),
3831: DECODE(in_attribute1(i),OKC_API.G_MISS_CHAR,NULL,in_attribute1(i)),
3832: DECODE(in_attribute2(i),OKC_API.G_MISS_CHAR,NULL,in_attribute2(i)),
3833: DECODE(in_attribute3(i),OKC_API.G_MISS_CHAR,NULL,in_attribute3(i)),
3834: DECODE(in_attribute4(i),OKC_API.G_MISS_CHAR,NULL,in_attribute4(i)),
3835: DECODE(in_attribute5(i),OKC_API.G_MISS_CHAR,NULL,in_attribute5(i)),
3828: DECODE(in_nth(i),OKC_API.G_MISS_NUM,NULL,in_nth(i)),
3829: DECODE(in_day_of_week(i),OKC_API.G_MISS_CHAR,NULL,in_day_of_week(i)),
3830: DECODE(in_attribute_category(i),OKC_API.G_MISS_CHAR,NULL,in_attribute_category(i)),
3831: DECODE(in_attribute1(i),OKC_API.G_MISS_CHAR,NULL,in_attribute1(i)),
3832: DECODE(in_attribute2(i),OKC_API.G_MISS_CHAR,NULL,in_attribute2(i)),
3833: DECODE(in_attribute3(i),OKC_API.G_MISS_CHAR,NULL,in_attribute3(i)),
3834: DECODE(in_attribute4(i),OKC_API.G_MISS_CHAR,NULL,in_attribute4(i)),
3835: DECODE(in_attribute5(i),OKC_API.G_MISS_CHAR,NULL,in_attribute5(i)),
3836: DECODE(in_attribute6(i),OKC_API.G_MISS_CHAR,NULL,in_attribute6(i)),
3829: DECODE(in_day_of_week(i),OKC_API.G_MISS_CHAR,NULL,in_day_of_week(i)),
3830: DECODE(in_attribute_category(i),OKC_API.G_MISS_CHAR,NULL,in_attribute_category(i)),
3831: DECODE(in_attribute1(i),OKC_API.G_MISS_CHAR,NULL,in_attribute1(i)),
3832: DECODE(in_attribute2(i),OKC_API.G_MISS_CHAR,NULL,in_attribute2(i)),
3833: DECODE(in_attribute3(i),OKC_API.G_MISS_CHAR,NULL,in_attribute3(i)),
3834: DECODE(in_attribute4(i),OKC_API.G_MISS_CHAR,NULL,in_attribute4(i)),
3835: DECODE(in_attribute5(i),OKC_API.G_MISS_CHAR,NULL,in_attribute5(i)),
3836: DECODE(in_attribute6(i),OKC_API.G_MISS_CHAR,NULL,in_attribute6(i)),
3837: DECODE(in_attribute7(i),OKC_API.G_MISS_CHAR,NULL,in_attribute7(i)),
3830: DECODE(in_attribute_category(i),OKC_API.G_MISS_CHAR,NULL,in_attribute_category(i)),
3831: DECODE(in_attribute1(i),OKC_API.G_MISS_CHAR,NULL,in_attribute1(i)),
3832: DECODE(in_attribute2(i),OKC_API.G_MISS_CHAR,NULL,in_attribute2(i)),
3833: DECODE(in_attribute3(i),OKC_API.G_MISS_CHAR,NULL,in_attribute3(i)),
3834: DECODE(in_attribute4(i),OKC_API.G_MISS_CHAR,NULL,in_attribute4(i)),
3835: DECODE(in_attribute5(i),OKC_API.G_MISS_CHAR,NULL,in_attribute5(i)),
3836: DECODE(in_attribute6(i),OKC_API.G_MISS_CHAR,NULL,in_attribute6(i)),
3837: DECODE(in_attribute7(i),OKC_API.G_MISS_CHAR,NULL,in_attribute7(i)),
3838: DECODE(in_attribute8(i),OKC_API.G_MISS_CHAR,NULL,in_attribute8(i)),
3831: DECODE(in_attribute1(i),OKC_API.G_MISS_CHAR,NULL,in_attribute1(i)),
3832: DECODE(in_attribute2(i),OKC_API.G_MISS_CHAR,NULL,in_attribute2(i)),
3833: DECODE(in_attribute3(i),OKC_API.G_MISS_CHAR,NULL,in_attribute3(i)),
3834: DECODE(in_attribute4(i),OKC_API.G_MISS_CHAR,NULL,in_attribute4(i)),
3835: DECODE(in_attribute5(i),OKC_API.G_MISS_CHAR,NULL,in_attribute5(i)),
3836: DECODE(in_attribute6(i),OKC_API.G_MISS_CHAR,NULL,in_attribute6(i)),
3837: DECODE(in_attribute7(i),OKC_API.G_MISS_CHAR,NULL,in_attribute7(i)),
3838: DECODE(in_attribute8(i),OKC_API.G_MISS_CHAR,NULL,in_attribute8(i)),
3839: DECODE(in_attribute9(i),OKC_API.G_MISS_CHAR,NULL,in_attribute9(i)),
3832: DECODE(in_attribute2(i),OKC_API.G_MISS_CHAR,NULL,in_attribute2(i)),
3833: DECODE(in_attribute3(i),OKC_API.G_MISS_CHAR,NULL,in_attribute3(i)),
3834: DECODE(in_attribute4(i),OKC_API.G_MISS_CHAR,NULL,in_attribute4(i)),
3835: DECODE(in_attribute5(i),OKC_API.G_MISS_CHAR,NULL,in_attribute5(i)),
3836: DECODE(in_attribute6(i),OKC_API.G_MISS_CHAR,NULL,in_attribute6(i)),
3837: DECODE(in_attribute7(i),OKC_API.G_MISS_CHAR,NULL,in_attribute7(i)),
3838: DECODE(in_attribute8(i),OKC_API.G_MISS_CHAR,NULL,in_attribute8(i)),
3839: DECODE(in_attribute9(i),OKC_API.G_MISS_CHAR,NULL,in_attribute9(i)),
3840: DECODE(in_attribute10(i),OKC_API.G_MISS_CHAR,NULL,in_attribute10(i)),
3833: DECODE(in_attribute3(i),OKC_API.G_MISS_CHAR,NULL,in_attribute3(i)),
3834: DECODE(in_attribute4(i),OKC_API.G_MISS_CHAR,NULL,in_attribute4(i)),
3835: DECODE(in_attribute5(i),OKC_API.G_MISS_CHAR,NULL,in_attribute5(i)),
3836: DECODE(in_attribute6(i),OKC_API.G_MISS_CHAR,NULL,in_attribute6(i)),
3837: DECODE(in_attribute7(i),OKC_API.G_MISS_CHAR,NULL,in_attribute7(i)),
3838: DECODE(in_attribute8(i),OKC_API.G_MISS_CHAR,NULL,in_attribute8(i)),
3839: DECODE(in_attribute9(i),OKC_API.G_MISS_CHAR,NULL,in_attribute9(i)),
3840: DECODE(in_attribute10(i),OKC_API.G_MISS_CHAR,NULL,in_attribute10(i)),
3841: DECODE(in_attribute11(i),OKC_API.G_MISS_CHAR,NULL,in_attribute11(i)),
3834: DECODE(in_attribute4(i),OKC_API.G_MISS_CHAR,NULL,in_attribute4(i)),
3835: DECODE(in_attribute5(i),OKC_API.G_MISS_CHAR,NULL,in_attribute5(i)),
3836: DECODE(in_attribute6(i),OKC_API.G_MISS_CHAR,NULL,in_attribute6(i)),
3837: DECODE(in_attribute7(i),OKC_API.G_MISS_CHAR,NULL,in_attribute7(i)),
3838: DECODE(in_attribute8(i),OKC_API.G_MISS_CHAR,NULL,in_attribute8(i)),
3839: DECODE(in_attribute9(i),OKC_API.G_MISS_CHAR,NULL,in_attribute9(i)),
3840: DECODE(in_attribute10(i),OKC_API.G_MISS_CHAR,NULL,in_attribute10(i)),
3841: DECODE(in_attribute11(i),OKC_API.G_MISS_CHAR,NULL,in_attribute11(i)),
3842: DECODE(in_attribute12(i),OKC_API.G_MISS_CHAR,NULL,in_attribute12(i)),
3835: DECODE(in_attribute5(i),OKC_API.G_MISS_CHAR,NULL,in_attribute5(i)),
3836: DECODE(in_attribute6(i),OKC_API.G_MISS_CHAR,NULL,in_attribute6(i)),
3837: DECODE(in_attribute7(i),OKC_API.G_MISS_CHAR,NULL,in_attribute7(i)),
3838: DECODE(in_attribute8(i),OKC_API.G_MISS_CHAR,NULL,in_attribute8(i)),
3839: DECODE(in_attribute9(i),OKC_API.G_MISS_CHAR,NULL,in_attribute9(i)),
3840: DECODE(in_attribute10(i),OKC_API.G_MISS_CHAR,NULL,in_attribute10(i)),
3841: DECODE(in_attribute11(i),OKC_API.G_MISS_CHAR,NULL,in_attribute11(i)),
3842: DECODE(in_attribute12(i),OKC_API.G_MISS_CHAR,NULL,in_attribute12(i)),
3843: DECODE(in_attribute13(i),OKC_API.G_MISS_CHAR,NULL,in_attribute13(i)),
3836: DECODE(in_attribute6(i),OKC_API.G_MISS_CHAR,NULL,in_attribute6(i)),
3837: DECODE(in_attribute7(i),OKC_API.G_MISS_CHAR,NULL,in_attribute7(i)),
3838: DECODE(in_attribute8(i),OKC_API.G_MISS_CHAR,NULL,in_attribute8(i)),
3839: DECODE(in_attribute9(i),OKC_API.G_MISS_CHAR,NULL,in_attribute9(i)),
3840: DECODE(in_attribute10(i),OKC_API.G_MISS_CHAR,NULL,in_attribute10(i)),
3841: DECODE(in_attribute11(i),OKC_API.G_MISS_CHAR,NULL,in_attribute11(i)),
3842: DECODE(in_attribute12(i),OKC_API.G_MISS_CHAR,NULL,in_attribute12(i)),
3843: DECODE(in_attribute13(i),OKC_API.G_MISS_CHAR,NULL,in_attribute13(i)),
3844: DECODE(in_attribute14(i),OKC_API.G_MISS_CHAR,NULL,in_attribute14(i)),
3837: DECODE(in_attribute7(i),OKC_API.G_MISS_CHAR,NULL,in_attribute7(i)),
3838: DECODE(in_attribute8(i),OKC_API.G_MISS_CHAR,NULL,in_attribute8(i)),
3839: DECODE(in_attribute9(i),OKC_API.G_MISS_CHAR,NULL,in_attribute9(i)),
3840: DECODE(in_attribute10(i),OKC_API.G_MISS_CHAR,NULL,in_attribute10(i)),
3841: DECODE(in_attribute11(i),OKC_API.G_MISS_CHAR,NULL,in_attribute11(i)),
3842: DECODE(in_attribute12(i),OKC_API.G_MISS_CHAR,NULL,in_attribute12(i)),
3843: DECODE(in_attribute13(i),OKC_API.G_MISS_CHAR,NULL,in_attribute13(i)),
3844: DECODE(in_attribute14(i),OKC_API.G_MISS_CHAR,NULL,in_attribute14(i)),
3845: DECODE(in_attribute15(i),OKC_API.G_MISS_CHAR,NULL,in_attribute15(i)),
3838: DECODE(in_attribute8(i),OKC_API.G_MISS_CHAR,NULL,in_attribute8(i)),
3839: DECODE(in_attribute9(i),OKC_API.G_MISS_CHAR,NULL,in_attribute9(i)),
3840: DECODE(in_attribute10(i),OKC_API.G_MISS_CHAR,NULL,in_attribute10(i)),
3841: DECODE(in_attribute11(i),OKC_API.G_MISS_CHAR,NULL,in_attribute11(i)),
3842: DECODE(in_attribute12(i),OKC_API.G_MISS_CHAR,NULL,in_attribute12(i)),
3843: DECODE(in_attribute13(i),OKC_API.G_MISS_CHAR,NULL,in_attribute13(i)),
3844: DECODE(in_attribute14(i),OKC_API.G_MISS_CHAR,NULL,in_attribute14(i)),
3845: DECODE(in_attribute15(i),OKC_API.G_MISS_CHAR,NULL,in_attribute15(i)),
3846: --Bug 3122962
3839: DECODE(in_attribute9(i),OKC_API.G_MISS_CHAR,NULL,in_attribute9(i)),
3840: DECODE(in_attribute10(i),OKC_API.G_MISS_CHAR,NULL,in_attribute10(i)),
3841: DECODE(in_attribute11(i),OKC_API.G_MISS_CHAR,NULL,in_attribute11(i)),
3842: DECODE(in_attribute12(i),OKC_API.G_MISS_CHAR,NULL,in_attribute12(i)),
3843: DECODE(in_attribute13(i),OKC_API.G_MISS_CHAR,NULL,in_attribute13(i)),
3844: DECODE(in_attribute14(i),OKC_API.G_MISS_CHAR,NULL,in_attribute14(i)),
3845: DECODE(in_attribute15(i),OKC_API.G_MISS_CHAR,NULL,in_attribute15(i)),
3846: --Bug 3122962
3847: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3840: DECODE(in_attribute10(i),OKC_API.G_MISS_CHAR,NULL,in_attribute10(i)),
3841: DECODE(in_attribute11(i),OKC_API.G_MISS_CHAR,NULL,in_attribute11(i)),
3842: DECODE(in_attribute12(i),OKC_API.G_MISS_CHAR,NULL,in_attribute12(i)),
3843: DECODE(in_attribute13(i),OKC_API.G_MISS_CHAR,NULL,in_attribute13(i)),
3844: DECODE(in_attribute14(i),OKC_API.G_MISS_CHAR,NULL,in_attribute14(i)),
3845: DECODE(in_attribute15(i),OKC_API.G_MISS_CHAR,NULL,in_attribute15(i)),
3846: --Bug 3122962
3847: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3848: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
3841: DECODE(in_attribute11(i),OKC_API.G_MISS_CHAR,NULL,in_attribute11(i)),
3842: DECODE(in_attribute12(i),OKC_API.G_MISS_CHAR,NULL,in_attribute12(i)),
3843: DECODE(in_attribute13(i),OKC_API.G_MISS_CHAR,NULL,in_attribute13(i)),
3844: DECODE(in_attribute14(i),OKC_API.G_MISS_CHAR,NULL,in_attribute14(i)),
3845: DECODE(in_attribute15(i),OKC_API.G_MISS_CHAR,NULL,in_attribute15(i)),
3846: --Bug 3122962
3847: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3848: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
3849: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
3843: DECODE(in_attribute13(i),OKC_API.G_MISS_CHAR,NULL,in_attribute13(i)),
3844: DECODE(in_attribute14(i),OKC_API.G_MISS_CHAR,NULL,in_attribute14(i)),
3845: DECODE(in_attribute15(i),OKC_API.G_MISS_CHAR,NULL,in_attribute15(i)),
3846: --Bug 3122962
3847: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3848: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
3849: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
3850: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i))
3851: );
3844: DECODE(in_attribute14(i),OKC_API.G_MISS_CHAR,NULL,in_attribute14(i)),
3845: DECODE(in_attribute15(i),OKC_API.G_MISS_CHAR,NULL,in_attribute15(i)),
3846: --Bug 3122962
3847: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3848: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
3849: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
3850: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i))
3851: );
3852: --Bug 3122962
3845: DECODE(in_attribute15(i),OKC_API.G_MISS_CHAR,NULL,in_attribute15(i)),
3846: --Bug 3122962
3847: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3848: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
3849: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
3850: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i))
3851: );
3852: --Bug 3122962
3853: /*
3846: --Bug 3122962
3847: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3848: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
3849: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
3850: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i))
3851: );
3852: --Bug 3122962
3853: /*
3854: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST LOOP
3868: last_update_date,
3869: last_update_login
3870: )
3871: VALUES (
3872: DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
3873: OKC_UTIL.g_language_code(lang_i),
3874: l_source_lang,
3875: DECODE(in_sfwt_flag(i),OKC_API.G_MISS_CHAR,NULL,in_sfwt_flag(i)),
3876: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
3871: VALUES (
3872: DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
3873: OKC_UTIL.g_language_code(lang_i),
3874: l_source_lang,
3875: DECODE(in_sfwt_flag(i),OKC_API.G_MISS_CHAR,NULL,in_sfwt_flag(i)),
3876: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
3877: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
3878: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i)),
3879: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3872: DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
3873: OKC_UTIL.g_language_code(lang_i),
3874: l_source_lang,
3875: DECODE(in_sfwt_flag(i),OKC_API.G_MISS_CHAR,NULL,in_sfwt_flag(i)),
3876: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
3877: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
3878: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i)),
3879: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3880: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3873: OKC_UTIL.g_language_code(lang_i),
3874: l_source_lang,
3875: DECODE(in_sfwt_flag(i),OKC_API.G_MISS_CHAR,NULL,in_sfwt_flag(i)),
3876: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
3877: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
3878: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i)),
3879: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3880: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3881: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3874: l_source_lang,
3875: DECODE(in_sfwt_flag(i),OKC_API.G_MISS_CHAR,NULL,in_sfwt_flag(i)),
3876: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
3877: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
3878: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i)),
3879: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3880: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3881: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3882: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3875: DECODE(in_sfwt_flag(i),OKC_API.G_MISS_CHAR,NULL,in_sfwt_flag(i)),
3876: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
3877: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
3878: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i)),
3879: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3880: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3881: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3882: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3883: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3876: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
3877: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
3878: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i)),
3879: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3880: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3881: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3882: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3883: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3884: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i))
3877: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
3878: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i)),
3879: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3880: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3881: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3882: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3883: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3884: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i))
3885: );
3878: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i)),
3879: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3880: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3881: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3882: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3883: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3884: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i))
3885: );
3886: END LOOP;
3879: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
3880: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3881: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3882: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3883: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3884: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i))
3885: );
3886: END LOOP;
3887: */
3880: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
3881: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
3882: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
3883: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
3884: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i))
3885: );
3886: END LOOP;
3887: */
3888: EXCEPTION
3948: l_tve_id_ended NUMBER;
3949: i NUMBER := p_isev_rel_tbl.FIRST;
3950: j NUMBER := 0;
3951: l_date DATE := NULL;
3952: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3953: BEGIN
3954: while i is NOT NULL
3955: LOOP
3956: /* FOR TPA RELATIVE */
4034: if l_date is NULL THEN
4035: return;
4036: end if;
4037: if p_isev_rel_tbl(i).end_date is NOT NULL and
4038: p_isev_rel_tbl(i).end_date <> OKC_API.G_MISS_DATE then
4039: okc_time_util_pub.get_duration(l_date, p_isev_rel_tbl(i).end_date,in_duration(j),
4040: in_uom_code(j),x_return_status);
4041: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
4042: return;
4037: if p_isev_rel_tbl(i).end_date is NOT NULL and
4038: p_isev_rel_tbl(i).end_date <> OKC_API.G_MISS_DATE then
4039: okc_time_util_pub.get_duration(l_date, p_isev_rel_tbl(i).end_date,in_duration(j),
4040: in_uom_code(j),x_return_status);
4041: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
4042: return;
4043: end if;
4044: else
4045: in_duration(j) := NULL;
4138: short_description,
4139: comments
4140: )
4141: VALUES (
4142: DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
4143: DECODE(in_spn_id(i),OKC_API.G_MISS_NUM,NULL,in_spn_id(i)),
4144: DECODE(in_tve_id_offset(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_offset(i)),
4145: DECODE(in_tve_id_generated_by(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_generated_by(i)),
4146: DECODE(in_tve_id_started(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_started(i)),
4139: comments
4140: )
4141: VALUES (
4142: DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
4143: DECODE(in_spn_id(i),OKC_API.G_MISS_NUM,NULL,in_spn_id(i)),
4144: DECODE(in_tve_id_offset(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_offset(i)),
4145: DECODE(in_tve_id_generated_by(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_generated_by(i)),
4146: DECODE(in_tve_id_started(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_started(i)),
4147: DECODE(in_tve_id_ended(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_ended(i)),
4140: )
4141: VALUES (
4142: DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
4143: DECODE(in_spn_id(i),OKC_API.G_MISS_NUM,NULL,in_spn_id(i)),
4144: DECODE(in_tve_id_offset(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_offset(i)),
4145: DECODE(in_tve_id_generated_by(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_generated_by(i)),
4146: DECODE(in_tve_id_started(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_started(i)),
4147: DECODE(in_tve_id_ended(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_ended(i)),
4148: DECODE(in_tve_id_limited(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_limited(i)),
4141: VALUES (
4142: DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
4143: DECODE(in_spn_id(i),OKC_API.G_MISS_NUM,NULL,in_spn_id(i)),
4144: DECODE(in_tve_id_offset(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_offset(i)),
4145: DECODE(in_tve_id_generated_by(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_generated_by(i)),
4146: DECODE(in_tve_id_started(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_started(i)),
4147: DECODE(in_tve_id_ended(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_ended(i)),
4148: DECODE(in_tve_id_limited(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_limited(i)),
4149: DECODE(in_cnh_id(i),OKC_API.G_MISS_NUM,NULL,in_cnh_id(i)),
4142: DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
4143: DECODE(in_spn_id(i),OKC_API.G_MISS_NUM,NULL,in_spn_id(i)),
4144: DECODE(in_tve_id_offset(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_offset(i)),
4145: DECODE(in_tve_id_generated_by(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_generated_by(i)),
4146: DECODE(in_tve_id_started(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_started(i)),
4147: DECODE(in_tve_id_ended(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_ended(i)),
4148: DECODE(in_tve_id_limited(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_limited(i)),
4149: DECODE(in_cnh_id(i),OKC_API.G_MISS_NUM,NULL,in_cnh_id(i)),
4150: DECODE(in_dnz_chr_id(i),OKC_API.G_MISS_NUM,NULL,in_dnz_chr_id(i)),
4143: DECODE(in_spn_id(i),OKC_API.G_MISS_NUM,NULL,in_spn_id(i)),
4144: DECODE(in_tve_id_offset(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_offset(i)),
4145: DECODE(in_tve_id_generated_by(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_generated_by(i)),
4146: DECODE(in_tve_id_started(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_started(i)),
4147: DECODE(in_tve_id_ended(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_ended(i)),
4148: DECODE(in_tve_id_limited(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_limited(i)),
4149: DECODE(in_cnh_id(i),OKC_API.G_MISS_NUM,NULL,in_cnh_id(i)),
4150: DECODE(in_dnz_chr_id(i),OKC_API.G_MISS_NUM,NULL,in_dnz_chr_id(i)),
4151: DECODE(in_tve_type(i),OKC_API.G_MISS_CHAR,NULL,in_tve_type(i)),
4144: DECODE(in_tve_id_offset(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_offset(i)),
4145: DECODE(in_tve_id_generated_by(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_generated_by(i)),
4146: DECODE(in_tve_id_started(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_started(i)),
4147: DECODE(in_tve_id_ended(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_ended(i)),
4148: DECODE(in_tve_id_limited(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_limited(i)),
4149: DECODE(in_cnh_id(i),OKC_API.G_MISS_NUM,NULL,in_cnh_id(i)),
4150: DECODE(in_dnz_chr_id(i),OKC_API.G_MISS_NUM,NULL,in_dnz_chr_id(i)),
4151: DECODE(in_tve_type(i),OKC_API.G_MISS_CHAR,NULL,in_tve_type(i)),
4152: DECODE(in_tze_id(i),OKC_API.G_MISS_NUM,NULL,in_tze_id(i)),
4145: DECODE(in_tve_id_generated_by(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_generated_by(i)),
4146: DECODE(in_tve_id_started(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_started(i)),
4147: DECODE(in_tve_id_ended(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_ended(i)),
4148: DECODE(in_tve_id_limited(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_limited(i)),
4149: DECODE(in_cnh_id(i),OKC_API.G_MISS_NUM,NULL,in_cnh_id(i)),
4150: DECODE(in_dnz_chr_id(i),OKC_API.G_MISS_NUM,NULL,in_dnz_chr_id(i)),
4151: DECODE(in_tve_type(i),OKC_API.G_MISS_CHAR,NULL,in_tve_type(i)),
4152: DECODE(in_tze_id(i),OKC_API.G_MISS_NUM,NULL,in_tze_id(i)),
4153: DECODE(in_object_version_number(i),OKC_API.G_MISS_NUM,NULL,in_object_version_number(i)),
4146: DECODE(in_tve_id_started(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_started(i)),
4147: DECODE(in_tve_id_ended(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_ended(i)),
4148: DECODE(in_tve_id_limited(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_limited(i)),
4149: DECODE(in_cnh_id(i),OKC_API.G_MISS_NUM,NULL,in_cnh_id(i)),
4150: DECODE(in_dnz_chr_id(i),OKC_API.G_MISS_NUM,NULL,in_dnz_chr_id(i)),
4151: DECODE(in_tve_type(i),OKC_API.G_MISS_CHAR,NULL,in_tve_type(i)),
4152: DECODE(in_tze_id(i),OKC_API.G_MISS_NUM,NULL,in_tze_id(i)),
4153: DECODE(in_object_version_number(i),OKC_API.G_MISS_NUM,NULL,in_object_version_number(i)),
4154: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
4147: DECODE(in_tve_id_ended(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_ended(i)),
4148: DECODE(in_tve_id_limited(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_limited(i)),
4149: DECODE(in_cnh_id(i),OKC_API.G_MISS_NUM,NULL,in_cnh_id(i)),
4150: DECODE(in_dnz_chr_id(i),OKC_API.G_MISS_NUM,NULL,in_dnz_chr_id(i)),
4151: DECODE(in_tve_type(i),OKC_API.G_MISS_CHAR,NULL,in_tve_type(i)),
4152: DECODE(in_tze_id(i),OKC_API.G_MISS_NUM,NULL,in_tze_id(i)),
4153: DECODE(in_object_version_number(i),OKC_API.G_MISS_NUM,NULL,in_object_version_number(i)),
4154: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
4155: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
4148: DECODE(in_tve_id_limited(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_limited(i)),
4149: DECODE(in_cnh_id(i),OKC_API.G_MISS_NUM,NULL,in_cnh_id(i)),
4150: DECODE(in_dnz_chr_id(i),OKC_API.G_MISS_NUM,NULL,in_dnz_chr_id(i)),
4151: DECODE(in_tve_type(i),OKC_API.G_MISS_CHAR,NULL,in_tve_type(i)),
4152: DECODE(in_tze_id(i),OKC_API.G_MISS_NUM,NULL,in_tze_id(i)),
4153: DECODE(in_object_version_number(i),OKC_API.G_MISS_NUM,NULL,in_object_version_number(i)),
4154: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
4155: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
4156: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
4149: DECODE(in_cnh_id(i),OKC_API.G_MISS_NUM,NULL,in_cnh_id(i)),
4150: DECODE(in_dnz_chr_id(i),OKC_API.G_MISS_NUM,NULL,in_dnz_chr_id(i)),
4151: DECODE(in_tve_type(i),OKC_API.G_MISS_CHAR,NULL,in_tve_type(i)),
4152: DECODE(in_tze_id(i),OKC_API.G_MISS_NUM,NULL,in_tze_id(i)),
4153: DECODE(in_object_version_number(i),OKC_API.G_MISS_NUM,NULL,in_object_version_number(i)),
4154: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
4155: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
4156: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
4157: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
4150: DECODE(in_dnz_chr_id(i),OKC_API.G_MISS_NUM,NULL,in_dnz_chr_id(i)),
4151: DECODE(in_tve_type(i),OKC_API.G_MISS_CHAR,NULL,in_tve_type(i)),
4152: DECODE(in_tze_id(i),OKC_API.G_MISS_NUM,NULL,in_tze_id(i)),
4153: DECODE(in_object_version_number(i),OKC_API.G_MISS_NUM,NULL,in_object_version_number(i)),
4154: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
4155: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
4156: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
4157: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
4158: DECODE(in_uom_code(i),OKC_API.G_MISS_CHAR,NULL,in_uom_code(i)),
4151: DECODE(in_tve_type(i),OKC_API.G_MISS_CHAR,NULL,in_tve_type(i)),
4152: DECODE(in_tze_id(i),OKC_API.G_MISS_NUM,NULL,in_tze_id(i)),
4153: DECODE(in_object_version_number(i),OKC_API.G_MISS_NUM,NULL,in_object_version_number(i)),
4154: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
4155: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
4156: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
4157: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
4158: DECODE(in_uom_code(i),OKC_API.G_MISS_CHAR,NULL,in_uom_code(i)),
4159: DECODE(in_duration(i),OKC_API.G_MISS_NUM,NULL,in_duration(i)),
4152: DECODE(in_tze_id(i),OKC_API.G_MISS_NUM,NULL,in_tze_id(i)),
4153: DECODE(in_object_version_number(i),OKC_API.G_MISS_NUM,NULL,in_object_version_number(i)),
4154: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
4155: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
4156: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
4157: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
4158: DECODE(in_uom_code(i),OKC_API.G_MISS_CHAR,NULL,in_uom_code(i)),
4159: DECODE(in_duration(i),OKC_API.G_MISS_NUM,NULL,in_duration(i)),
4160: DECODE(in_operator(i),OKC_API.G_MISS_CHAR,NULL,in_operator(i)),
4153: DECODE(in_object_version_number(i),OKC_API.G_MISS_NUM,NULL,in_object_version_number(i)),
4154: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
4155: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
4156: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
4157: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
4158: DECODE(in_uom_code(i),OKC_API.G_MISS_CHAR,NULL,in_uom_code(i)),
4159: DECODE(in_duration(i),OKC_API.G_MISS_NUM,NULL,in_duration(i)),
4160: DECODE(in_operator(i),OKC_API.G_MISS_CHAR,NULL,in_operator(i)),
4161: DECODE(in_before_after(i),OKC_API.G_MISS_CHAR,NULL,in_before_after(i)),
4154: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
4155: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
4156: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
4157: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
4158: DECODE(in_uom_code(i),OKC_API.G_MISS_CHAR,NULL,in_uom_code(i)),
4159: DECODE(in_duration(i),OKC_API.G_MISS_NUM,NULL,in_duration(i)),
4160: DECODE(in_operator(i),OKC_API.G_MISS_CHAR,NULL,in_operator(i)),
4161: DECODE(in_before_after(i),OKC_API.G_MISS_CHAR,NULL,in_before_after(i)),
4162: DECODE(in_datetime(i),OKC_API.G_MISS_DATE,NULL,in_datetime(i)),
4155: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
4156: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
4157: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
4158: DECODE(in_uom_code(i),OKC_API.G_MISS_CHAR,NULL,in_uom_code(i)),
4159: DECODE(in_duration(i),OKC_API.G_MISS_NUM,NULL,in_duration(i)),
4160: DECODE(in_operator(i),OKC_API.G_MISS_CHAR,NULL,in_operator(i)),
4161: DECODE(in_before_after(i),OKC_API.G_MISS_CHAR,NULL,in_before_after(i)),
4162: DECODE(in_datetime(i),OKC_API.G_MISS_DATE,NULL,in_datetime(i)),
4163: DECODE(in_month(i),OKC_API.G_MISS_NUM,NULL,in_month(i)),
4156: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
4157: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
4158: DECODE(in_uom_code(i),OKC_API.G_MISS_CHAR,NULL,in_uom_code(i)),
4159: DECODE(in_duration(i),OKC_API.G_MISS_NUM,NULL,in_duration(i)),
4160: DECODE(in_operator(i),OKC_API.G_MISS_CHAR,NULL,in_operator(i)),
4161: DECODE(in_before_after(i),OKC_API.G_MISS_CHAR,NULL,in_before_after(i)),
4162: DECODE(in_datetime(i),OKC_API.G_MISS_DATE,NULL,in_datetime(i)),
4163: DECODE(in_month(i),OKC_API.G_MISS_NUM,NULL,in_month(i)),
4164: DECODE(in_day(i),OKC_API.G_MISS_NUM,NULL,in_day(i)),
4157: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
4158: DECODE(in_uom_code(i),OKC_API.G_MISS_CHAR,NULL,in_uom_code(i)),
4159: DECODE(in_duration(i),OKC_API.G_MISS_NUM,NULL,in_duration(i)),
4160: DECODE(in_operator(i),OKC_API.G_MISS_CHAR,NULL,in_operator(i)),
4161: DECODE(in_before_after(i),OKC_API.G_MISS_CHAR,NULL,in_before_after(i)),
4162: DECODE(in_datetime(i),OKC_API.G_MISS_DATE,NULL,in_datetime(i)),
4163: DECODE(in_month(i),OKC_API.G_MISS_NUM,NULL,in_month(i)),
4164: DECODE(in_day(i),OKC_API.G_MISS_NUM,NULL,in_day(i)),
4165: DECODE(in_hour(i),OKC_API.G_MISS_NUM,NULL,in_hour(i)),
4158: DECODE(in_uom_code(i),OKC_API.G_MISS_CHAR,NULL,in_uom_code(i)),
4159: DECODE(in_duration(i),OKC_API.G_MISS_NUM,NULL,in_duration(i)),
4160: DECODE(in_operator(i),OKC_API.G_MISS_CHAR,NULL,in_operator(i)),
4161: DECODE(in_before_after(i),OKC_API.G_MISS_CHAR,NULL,in_before_after(i)),
4162: DECODE(in_datetime(i),OKC_API.G_MISS_DATE,NULL,in_datetime(i)),
4163: DECODE(in_month(i),OKC_API.G_MISS_NUM,NULL,in_month(i)),
4164: DECODE(in_day(i),OKC_API.G_MISS_NUM,NULL,in_day(i)),
4165: DECODE(in_hour(i),OKC_API.G_MISS_NUM,NULL,in_hour(i)),
4166: DECODE(in_minute(i),OKC_API.G_MISS_NUM,NULL,in_minute(i)),
4159: DECODE(in_duration(i),OKC_API.G_MISS_NUM,NULL,in_duration(i)),
4160: DECODE(in_operator(i),OKC_API.G_MISS_CHAR,NULL,in_operator(i)),
4161: DECODE(in_before_after(i),OKC_API.G_MISS_CHAR,NULL,in_before_after(i)),
4162: DECODE(in_datetime(i),OKC_API.G_MISS_DATE,NULL,in_datetime(i)),
4163: DECODE(in_month(i),OKC_API.G_MISS_NUM,NULL,in_month(i)),
4164: DECODE(in_day(i),OKC_API.G_MISS_NUM,NULL,in_day(i)),
4165: DECODE(in_hour(i),OKC_API.G_MISS_NUM,NULL,in_hour(i)),
4166: DECODE(in_minute(i),OKC_API.G_MISS_NUM,NULL,in_minute(i)),
4167: DECODE(in_second(i),OKC_API.G_MISS_NUM,NULL,in_second(i)),
4160: DECODE(in_operator(i),OKC_API.G_MISS_CHAR,NULL,in_operator(i)),
4161: DECODE(in_before_after(i),OKC_API.G_MISS_CHAR,NULL,in_before_after(i)),
4162: DECODE(in_datetime(i),OKC_API.G_MISS_DATE,NULL,in_datetime(i)),
4163: DECODE(in_month(i),OKC_API.G_MISS_NUM,NULL,in_month(i)),
4164: DECODE(in_day(i),OKC_API.G_MISS_NUM,NULL,in_day(i)),
4165: DECODE(in_hour(i),OKC_API.G_MISS_NUM,NULL,in_hour(i)),
4166: DECODE(in_minute(i),OKC_API.G_MISS_NUM,NULL,in_minute(i)),
4167: DECODE(in_second(i),OKC_API.G_MISS_NUM,NULL,in_second(i)),
4168: DECODE(in_interval_yn(i),OKC_API.G_MISS_CHAR,NULL,in_interval_yn(i)),
4161: DECODE(in_before_after(i),OKC_API.G_MISS_CHAR,NULL,in_before_after(i)),
4162: DECODE(in_datetime(i),OKC_API.G_MISS_DATE,NULL,in_datetime(i)),
4163: DECODE(in_month(i),OKC_API.G_MISS_NUM,NULL,in_month(i)),
4164: DECODE(in_day(i),OKC_API.G_MISS_NUM,NULL,in_day(i)),
4165: DECODE(in_hour(i),OKC_API.G_MISS_NUM,NULL,in_hour(i)),
4166: DECODE(in_minute(i),OKC_API.G_MISS_NUM,NULL,in_minute(i)),
4167: DECODE(in_second(i),OKC_API.G_MISS_NUM,NULL,in_second(i)),
4168: DECODE(in_interval_yn(i),OKC_API.G_MISS_CHAR,NULL,in_interval_yn(i)),
4169: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i)),
4162: DECODE(in_datetime(i),OKC_API.G_MISS_DATE,NULL,in_datetime(i)),
4163: DECODE(in_month(i),OKC_API.G_MISS_NUM,NULL,in_month(i)),
4164: DECODE(in_day(i),OKC_API.G_MISS_NUM,NULL,in_day(i)),
4165: DECODE(in_hour(i),OKC_API.G_MISS_NUM,NULL,in_hour(i)),
4166: DECODE(in_minute(i),OKC_API.G_MISS_NUM,NULL,in_minute(i)),
4167: DECODE(in_second(i),OKC_API.G_MISS_NUM,NULL,in_second(i)),
4168: DECODE(in_interval_yn(i),OKC_API.G_MISS_CHAR,NULL,in_interval_yn(i)),
4169: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i)),
4170: DECODE(in_nth(i),OKC_API.G_MISS_NUM,NULL,in_nth(i)),
4163: DECODE(in_month(i),OKC_API.G_MISS_NUM,NULL,in_month(i)),
4164: DECODE(in_day(i),OKC_API.G_MISS_NUM,NULL,in_day(i)),
4165: DECODE(in_hour(i),OKC_API.G_MISS_NUM,NULL,in_hour(i)),
4166: DECODE(in_minute(i),OKC_API.G_MISS_NUM,NULL,in_minute(i)),
4167: DECODE(in_second(i),OKC_API.G_MISS_NUM,NULL,in_second(i)),
4168: DECODE(in_interval_yn(i),OKC_API.G_MISS_CHAR,NULL,in_interval_yn(i)),
4169: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i)),
4170: DECODE(in_nth(i),OKC_API.G_MISS_NUM,NULL,in_nth(i)),
4171: DECODE(in_day_of_week(i),OKC_API.G_MISS_CHAR,NULL,in_day_of_week(i)),
4164: DECODE(in_day(i),OKC_API.G_MISS_NUM,NULL,in_day(i)),
4165: DECODE(in_hour(i),OKC_API.G_MISS_NUM,NULL,in_hour(i)),
4166: DECODE(in_minute(i),OKC_API.G_MISS_NUM,NULL,in_minute(i)),
4167: DECODE(in_second(i),OKC_API.G_MISS_NUM,NULL,in_second(i)),
4168: DECODE(in_interval_yn(i),OKC_API.G_MISS_CHAR,NULL,in_interval_yn(i)),
4169: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i)),
4170: DECODE(in_nth(i),OKC_API.G_MISS_NUM,NULL,in_nth(i)),
4171: DECODE(in_day_of_week(i),OKC_API.G_MISS_CHAR,NULL,in_day_of_week(i)),
4172: DECODE(in_attribute_category(i),OKC_API.G_MISS_CHAR,NULL,in_attribute_category(i)),
4165: DECODE(in_hour(i),OKC_API.G_MISS_NUM,NULL,in_hour(i)),
4166: DECODE(in_minute(i),OKC_API.G_MISS_NUM,NULL,in_minute(i)),
4167: DECODE(in_second(i),OKC_API.G_MISS_NUM,NULL,in_second(i)),
4168: DECODE(in_interval_yn(i),OKC_API.G_MISS_CHAR,NULL,in_interval_yn(i)),
4169: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i)),
4170: DECODE(in_nth(i),OKC_API.G_MISS_NUM,NULL,in_nth(i)),
4171: DECODE(in_day_of_week(i),OKC_API.G_MISS_CHAR,NULL,in_day_of_week(i)),
4172: DECODE(in_attribute_category(i),OKC_API.G_MISS_CHAR,NULL,in_attribute_category(i)),
4173: DECODE(in_attribute1(i),OKC_API.G_MISS_CHAR,NULL,in_attribute1(i)),
4166: DECODE(in_minute(i),OKC_API.G_MISS_NUM,NULL,in_minute(i)),
4167: DECODE(in_second(i),OKC_API.G_MISS_NUM,NULL,in_second(i)),
4168: DECODE(in_interval_yn(i),OKC_API.G_MISS_CHAR,NULL,in_interval_yn(i)),
4169: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i)),
4170: DECODE(in_nth(i),OKC_API.G_MISS_NUM,NULL,in_nth(i)),
4171: DECODE(in_day_of_week(i),OKC_API.G_MISS_CHAR,NULL,in_day_of_week(i)),
4172: DECODE(in_attribute_category(i),OKC_API.G_MISS_CHAR,NULL,in_attribute_category(i)),
4173: DECODE(in_attribute1(i),OKC_API.G_MISS_CHAR,NULL,in_attribute1(i)),
4174: DECODE(in_attribute2(i),OKC_API.G_MISS_CHAR,NULL,in_attribute2(i)),
4167: DECODE(in_second(i),OKC_API.G_MISS_NUM,NULL,in_second(i)),
4168: DECODE(in_interval_yn(i),OKC_API.G_MISS_CHAR,NULL,in_interval_yn(i)),
4169: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i)),
4170: DECODE(in_nth(i),OKC_API.G_MISS_NUM,NULL,in_nth(i)),
4171: DECODE(in_day_of_week(i),OKC_API.G_MISS_CHAR,NULL,in_day_of_week(i)),
4172: DECODE(in_attribute_category(i),OKC_API.G_MISS_CHAR,NULL,in_attribute_category(i)),
4173: DECODE(in_attribute1(i),OKC_API.G_MISS_CHAR,NULL,in_attribute1(i)),
4174: DECODE(in_attribute2(i),OKC_API.G_MISS_CHAR,NULL,in_attribute2(i)),
4175: DECODE(in_attribute3(i),OKC_API.G_MISS_CHAR,NULL,in_attribute3(i)),
4168: DECODE(in_interval_yn(i),OKC_API.G_MISS_CHAR,NULL,in_interval_yn(i)),
4169: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i)),
4170: DECODE(in_nth(i),OKC_API.G_MISS_NUM,NULL,in_nth(i)),
4171: DECODE(in_day_of_week(i),OKC_API.G_MISS_CHAR,NULL,in_day_of_week(i)),
4172: DECODE(in_attribute_category(i),OKC_API.G_MISS_CHAR,NULL,in_attribute_category(i)),
4173: DECODE(in_attribute1(i),OKC_API.G_MISS_CHAR,NULL,in_attribute1(i)),
4174: DECODE(in_attribute2(i),OKC_API.G_MISS_CHAR,NULL,in_attribute2(i)),
4175: DECODE(in_attribute3(i),OKC_API.G_MISS_CHAR,NULL,in_attribute3(i)),
4176: DECODE(in_attribute4(i),OKC_API.G_MISS_CHAR,NULL,in_attribute4(i)),
4169: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i)),
4170: DECODE(in_nth(i),OKC_API.G_MISS_NUM,NULL,in_nth(i)),
4171: DECODE(in_day_of_week(i),OKC_API.G_MISS_CHAR,NULL,in_day_of_week(i)),
4172: DECODE(in_attribute_category(i),OKC_API.G_MISS_CHAR,NULL,in_attribute_category(i)),
4173: DECODE(in_attribute1(i),OKC_API.G_MISS_CHAR,NULL,in_attribute1(i)),
4174: DECODE(in_attribute2(i),OKC_API.G_MISS_CHAR,NULL,in_attribute2(i)),
4175: DECODE(in_attribute3(i),OKC_API.G_MISS_CHAR,NULL,in_attribute3(i)),
4176: DECODE(in_attribute4(i),OKC_API.G_MISS_CHAR,NULL,in_attribute4(i)),
4177: DECODE(in_attribute5(i),OKC_API.G_MISS_CHAR,NULL,in_attribute5(i)),
4170: DECODE(in_nth(i),OKC_API.G_MISS_NUM,NULL,in_nth(i)),
4171: DECODE(in_day_of_week(i),OKC_API.G_MISS_CHAR,NULL,in_day_of_week(i)),
4172: DECODE(in_attribute_category(i),OKC_API.G_MISS_CHAR,NULL,in_attribute_category(i)),
4173: DECODE(in_attribute1(i),OKC_API.G_MISS_CHAR,NULL,in_attribute1(i)),
4174: DECODE(in_attribute2(i),OKC_API.G_MISS_CHAR,NULL,in_attribute2(i)),
4175: DECODE(in_attribute3(i),OKC_API.G_MISS_CHAR,NULL,in_attribute3(i)),
4176: DECODE(in_attribute4(i),OKC_API.G_MISS_CHAR,NULL,in_attribute4(i)),
4177: DECODE(in_attribute5(i),OKC_API.G_MISS_CHAR,NULL,in_attribute5(i)),
4178: DECODE(in_attribute6(i),OKC_API.G_MISS_CHAR,NULL,in_attribute6(i)),
4171: DECODE(in_day_of_week(i),OKC_API.G_MISS_CHAR,NULL,in_day_of_week(i)),
4172: DECODE(in_attribute_category(i),OKC_API.G_MISS_CHAR,NULL,in_attribute_category(i)),
4173: DECODE(in_attribute1(i),OKC_API.G_MISS_CHAR,NULL,in_attribute1(i)),
4174: DECODE(in_attribute2(i),OKC_API.G_MISS_CHAR,NULL,in_attribute2(i)),
4175: DECODE(in_attribute3(i),OKC_API.G_MISS_CHAR,NULL,in_attribute3(i)),
4176: DECODE(in_attribute4(i),OKC_API.G_MISS_CHAR,NULL,in_attribute4(i)),
4177: DECODE(in_attribute5(i),OKC_API.G_MISS_CHAR,NULL,in_attribute5(i)),
4178: DECODE(in_attribute6(i),OKC_API.G_MISS_CHAR,NULL,in_attribute6(i)),
4179: DECODE(in_attribute7(i),OKC_API.G_MISS_CHAR,NULL,in_attribute7(i)),
4172: DECODE(in_attribute_category(i),OKC_API.G_MISS_CHAR,NULL,in_attribute_category(i)),
4173: DECODE(in_attribute1(i),OKC_API.G_MISS_CHAR,NULL,in_attribute1(i)),
4174: DECODE(in_attribute2(i),OKC_API.G_MISS_CHAR,NULL,in_attribute2(i)),
4175: DECODE(in_attribute3(i),OKC_API.G_MISS_CHAR,NULL,in_attribute3(i)),
4176: DECODE(in_attribute4(i),OKC_API.G_MISS_CHAR,NULL,in_attribute4(i)),
4177: DECODE(in_attribute5(i),OKC_API.G_MISS_CHAR,NULL,in_attribute5(i)),
4178: DECODE(in_attribute6(i),OKC_API.G_MISS_CHAR,NULL,in_attribute6(i)),
4179: DECODE(in_attribute7(i),OKC_API.G_MISS_CHAR,NULL,in_attribute7(i)),
4180: DECODE(in_attribute8(i),OKC_API.G_MISS_CHAR,NULL,in_attribute8(i)),
4173: DECODE(in_attribute1(i),OKC_API.G_MISS_CHAR,NULL,in_attribute1(i)),
4174: DECODE(in_attribute2(i),OKC_API.G_MISS_CHAR,NULL,in_attribute2(i)),
4175: DECODE(in_attribute3(i),OKC_API.G_MISS_CHAR,NULL,in_attribute3(i)),
4176: DECODE(in_attribute4(i),OKC_API.G_MISS_CHAR,NULL,in_attribute4(i)),
4177: DECODE(in_attribute5(i),OKC_API.G_MISS_CHAR,NULL,in_attribute5(i)),
4178: DECODE(in_attribute6(i),OKC_API.G_MISS_CHAR,NULL,in_attribute6(i)),
4179: DECODE(in_attribute7(i),OKC_API.G_MISS_CHAR,NULL,in_attribute7(i)),
4180: DECODE(in_attribute8(i),OKC_API.G_MISS_CHAR,NULL,in_attribute8(i)),
4181: DECODE(in_attribute9(i),OKC_API.G_MISS_CHAR,NULL,in_attribute9(i)),
4174: DECODE(in_attribute2(i),OKC_API.G_MISS_CHAR,NULL,in_attribute2(i)),
4175: DECODE(in_attribute3(i),OKC_API.G_MISS_CHAR,NULL,in_attribute3(i)),
4176: DECODE(in_attribute4(i),OKC_API.G_MISS_CHAR,NULL,in_attribute4(i)),
4177: DECODE(in_attribute5(i),OKC_API.G_MISS_CHAR,NULL,in_attribute5(i)),
4178: DECODE(in_attribute6(i),OKC_API.G_MISS_CHAR,NULL,in_attribute6(i)),
4179: DECODE(in_attribute7(i),OKC_API.G_MISS_CHAR,NULL,in_attribute7(i)),
4180: DECODE(in_attribute8(i),OKC_API.G_MISS_CHAR,NULL,in_attribute8(i)),
4181: DECODE(in_attribute9(i),OKC_API.G_MISS_CHAR,NULL,in_attribute9(i)),
4182: DECODE(in_attribute10(i),OKC_API.G_MISS_CHAR,NULL,in_attribute10(i)),
4175: DECODE(in_attribute3(i),OKC_API.G_MISS_CHAR,NULL,in_attribute3(i)),
4176: DECODE(in_attribute4(i),OKC_API.G_MISS_CHAR,NULL,in_attribute4(i)),
4177: DECODE(in_attribute5(i),OKC_API.G_MISS_CHAR,NULL,in_attribute5(i)),
4178: DECODE(in_attribute6(i),OKC_API.G_MISS_CHAR,NULL,in_attribute6(i)),
4179: DECODE(in_attribute7(i),OKC_API.G_MISS_CHAR,NULL,in_attribute7(i)),
4180: DECODE(in_attribute8(i),OKC_API.G_MISS_CHAR,NULL,in_attribute8(i)),
4181: DECODE(in_attribute9(i),OKC_API.G_MISS_CHAR,NULL,in_attribute9(i)),
4182: DECODE(in_attribute10(i),OKC_API.G_MISS_CHAR,NULL,in_attribute10(i)),
4183: DECODE(in_attribute11(i),OKC_API.G_MISS_CHAR,NULL,in_attribute11(i)),
4176: DECODE(in_attribute4(i),OKC_API.G_MISS_CHAR,NULL,in_attribute4(i)),
4177: DECODE(in_attribute5(i),OKC_API.G_MISS_CHAR,NULL,in_attribute5(i)),
4178: DECODE(in_attribute6(i),OKC_API.G_MISS_CHAR,NULL,in_attribute6(i)),
4179: DECODE(in_attribute7(i),OKC_API.G_MISS_CHAR,NULL,in_attribute7(i)),
4180: DECODE(in_attribute8(i),OKC_API.G_MISS_CHAR,NULL,in_attribute8(i)),
4181: DECODE(in_attribute9(i),OKC_API.G_MISS_CHAR,NULL,in_attribute9(i)),
4182: DECODE(in_attribute10(i),OKC_API.G_MISS_CHAR,NULL,in_attribute10(i)),
4183: DECODE(in_attribute11(i),OKC_API.G_MISS_CHAR,NULL,in_attribute11(i)),
4184: DECODE(in_attribute12(i),OKC_API.G_MISS_CHAR,NULL,in_attribute12(i)),
4177: DECODE(in_attribute5(i),OKC_API.G_MISS_CHAR,NULL,in_attribute5(i)),
4178: DECODE(in_attribute6(i),OKC_API.G_MISS_CHAR,NULL,in_attribute6(i)),
4179: DECODE(in_attribute7(i),OKC_API.G_MISS_CHAR,NULL,in_attribute7(i)),
4180: DECODE(in_attribute8(i),OKC_API.G_MISS_CHAR,NULL,in_attribute8(i)),
4181: DECODE(in_attribute9(i),OKC_API.G_MISS_CHAR,NULL,in_attribute9(i)),
4182: DECODE(in_attribute10(i),OKC_API.G_MISS_CHAR,NULL,in_attribute10(i)),
4183: DECODE(in_attribute11(i),OKC_API.G_MISS_CHAR,NULL,in_attribute11(i)),
4184: DECODE(in_attribute12(i),OKC_API.G_MISS_CHAR,NULL,in_attribute12(i)),
4185: DECODE(in_attribute13(i),OKC_API.G_MISS_CHAR,NULL,in_attribute13(i)),
4178: DECODE(in_attribute6(i),OKC_API.G_MISS_CHAR,NULL,in_attribute6(i)),
4179: DECODE(in_attribute7(i),OKC_API.G_MISS_CHAR,NULL,in_attribute7(i)),
4180: DECODE(in_attribute8(i),OKC_API.G_MISS_CHAR,NULL,in_attribute8(i)),
4181: DECODE(in_attribute9(i),OKC_API.G_MISS_CHAR,NULL,in_attribute9(i)),
4182: DECODE(in_attribute10(i),OKC_API.G_MISS_CHAR,NULL,in_attribute10(i)),
4183: DECODE(in_attribute11(i),OKC_API.G_MISS_CHAR,NULL,in_attribute11(i)),
4184: DECODE(in_attribute12(i),OKC_API.G_MISS_CHAR,NULL,in_attribute12(i)),
4185: DECODE(in_attribute13(i),OKC_API.G_MISS_CHAR,NULL,in_attribute13(i)),
4186: DECODE(in_attribute14(i),OKC_API.G_MISS_CHAR,NULL,in_attribute14(i)),
4179: DECODE(in_attribute7(i),OKC_API.G_MISS_CHAR,NULL,in_attribute7(i)),
4180: DECODE(in_attribute8(i),OKC_API.G_MISS_CHAR,NULL,in_attribute8(i)),
4181: DECODE(in_attribute9(i),OKC_API.G_MISS_CHAR,NULL,in_attribute9(i)),
4182: DECODE(in_attribute10(i),OKC_API.G_MISS_CHAR,NULL,in_attribute10(i)),
4183: DECODE(in_attribute11(i),OKC_API.G_MISS_CHAR,NULL,in_attribute11(i)),
4184: DECODE(in_attribute12(i),OKC_API.G_MISS_CHAR,NULL,in_attribute12(i)),
4185: DECODE(in_attribute13(i),OKC_API.G_MISS_CHAR,NULL,in_attribute13(i)),
4186: DECODE(in_attribute14(i),OKC_API.G_MISS_CHAR,NULL,in_attribute14(i)),
4187: DECODE(in_attribute15(i),OKC_API.G_MISS_CHAR,NULL,in_attribute15(i)),
4180: DECODE(in_attribute8(i),OKC_API.G_MISS_CHAR,NULL,in_attribute8(i)),
4181: DECODE(in_attribute9(i),OKC_API.G_MISS_CHAR,NULL,in_attribute9(i)),
4182: DECODE(in_attribute10(i),OKC_API.G_MISS_CHAR,NULL,in_attribute10(i)),
4183: DECODE(in_attribute11(i),OKC_API.G_MISS_CHAR,NULL,in_attribute11(i)),
4184: DECODE(in_attribute12(i),OKC_API.G_MISS_CHAR,NULL,in_attribute12(i)),
4185: DECODE(in_attribute13(i),OKC_API.G_MISS_CHAR,NULL,in_attribute13(i)),
4186: DECODE(in_attribute14(i),OKC_API.G_MISS_CHAR,NULL,in_attribute14(i)),
4187: DECODE(in_attribute15(i),OKC_API.G_MISS_CHAR,NULL,in_attribute15(i)),
4188: --Bug 3122962
4181: DECODE(in_attribute9(i),OKC_API.G_MISS_CHAR,NULL,in_attribute9(i)),
4182: DECODE(in_attribute10(i),OKC_API.G_MISS_CHAR,NULL,in_attribute10(i)),
4183: DECODE(in_attribute11(i),OKC_API.G_MISS_CHAR,NULL,in_attribute11(i)),
4184: DECODE(in_attribute12(i),OKC_API.G_MISS_CHAR,NULL,in_attribute12(i)),
4185: DECODE(in_attribute13(i),OKC_API.G_MISS_CHAR,NULL,in_attribute13(i)),
4186: DECODE(in_attribute14(i),OKC_API.G_MISS_CHAR,NULL,in_attribute14(i)),
4187: DECODE(in_attribute15(i),OKC_API.G_MISS_CHAR,NULL,in_attribute15(i)),
4188: --Bug 3122962
4189: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
4182: DECODE(in_attribute10(i),OKC_API.G_MISS_CHAR,NULL,in_attribute10(i)),
4183: DECODE(in_attribute11(i),OKC_API.G_MISS_CHAR,NULL,in_attribute11(i)),
4184: DECODE(in_attribute12(i),OKC_API.G_MISS_CHAR,NULL,in_attribute12(i)),
4185: DECODE(in_attribute13(i),OKC_API.G_MISS_CHAR,NULL,in_attribute13(i)),
4186: DECODE(in_attribute14(i),OKC_API.G_MISS_CHAR,NULL,in_attribute14(i)),
4187: DECODE(in_attribute15(i),OKC_API.G_MISS_CHAR,NULL,in_attribute15(i)),
4188: --Bug 3122962
4189: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
4190: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
4183: DECODE(in_attribute11(i),OKC_API.G_MISS_CHAR,NULL,in_attribute11(i)),
4184: DECODE(in_attribute12(i),OKC_API.G_MISS_CHAR,NULL,in_attribute12(i)),
4185: DECODE(in_attribute13(i),OKC_API.G_MISS_CHAR,NULL,in_attribute13(i)),
4186: DECODE(in_attribute14(i),OKC_API.G_MISS_CHAR,NULL,in_attribute14(i)),
4187: DECODE(in_attribute15(i),OKC_API.G_MISS_CHAR,NULL,in_attribute15(i)),
4188: --Bug 3122962
4189: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
4190: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
4191: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
4185: DECODE(in_attribute13(i),OKC_API.G_MISS_CHAR,NULL,in_attribute13(i)),
4186: DECODE(in_attribute14(i),OKC_API.G_MISS_CHAR,NULL,in_attribute14(i)),
4187: DECODE(in_attribute15(i),OKC_API.G_MISS_CHAR,NULL,in_attribute15(i)),
4188: --Bug 3122962
4189: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
4190: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
4191: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
4192: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i))
4193: );
4186: DECODE(in_attribute14(i),OKC_API.G_MISS_CHAR,NULL,in_attribute14(i)),
4187: DECODE(in_attribute15(i),OKC_API.G_MISS_CHAR,NULL,in_attribute15(i)),
4188: --Bug 3122962
4189: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
4190: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
4191: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
4192: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i))
4193: );
4194: --Bug 3122962
4187: DECODE(in_attribute15(i),OKC_API.G_MISS_CHAR,NULL,in_attribute15(i)),
4188: --Bug 3122962
4189: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
4190: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
4191: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
4192: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i))
4193: );
4194: --Bug 3122962
4195: /*
4188: --Bug 3122962
4189: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
4190: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
4191: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
4192: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i))
4193: );
4194: --Bug 3122962
4195: /*
4196: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST LOOP
4210: last_update_date,
4211: last_update_login
4212: )
4213: VALUES (
4214: DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
4215: OKC_UTIL.g_language_code(lang_i),
4216: l_source_lang,
4217: DECODE(in_sfwt_flag(i),OKC_API.G_MISS_CHAR,NULL,in_sfwt_flag(i)),
4218: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
4213: VALUES (
4214: DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
4215: OKC_UTIL.g_language_code(lang_i),
4216: l_source_lang,
4217: DECODE(in_sfwt_flag(i),OKC_API.G_MISS_CHAR,NULL,in_sfwt_flag(i)),
4218: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
4219: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
4220: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i)),
4221: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
4214: DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
4215: OKC_UTIL.g_language_code(lang_i),
4216: l_source_lang,
4217: DECODE(in_sfwt_flag(i),OKC_API.G_MISS_CHAR,NULL,in_sfwt_flag(i)),
4218: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
4219: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
4220: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i)),
4221: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
4222: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
4215: OKC_UTIL.g_language_code(lang_i),
4216: l_source_lang,
4217: DECODE(in_sfwt_flag(i),OKC_API.G_MISS_CHAR,NULL,in_sfwt_flag(i)),
4218: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
4219: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
4220: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i)),
4221: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
4222: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
4223: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
4216: l_source_lang,
4217: DECODE(in_sfwt_flag(i),OKC_API.G_MISS_CHAR,NULL,in_sfwt_flag(i)),
4218: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
4219: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
4220: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i)),
4221: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
4222: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
4223: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
4224: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
4217: DECODE(in_sfwt_flag(i),OKC_API.G_MISS_CHAR,NULL,in_sfwt_flag(i)),
4218: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
4219: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
4220: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i)),
4221: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
4222: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
4223: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
4224: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
4225: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
4218: DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
4219: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
4220: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i)),
4221: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
4222: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
4223: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
4224: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
4225: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
4226: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i))
4219: DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
4220: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i)),
4221: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
4222: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
4223: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
4224: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
4225: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
4226: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i))
4227: );
4220: DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i)),
4221: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
4222: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
4223: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
4224: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
4225: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
4226: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i))
4227: );
4228: END LOOP;
4221: DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
4222: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
4223: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
4224: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
4225: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
4226: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i))
4227: );
4228: END LOOP;
4229: */
4222: DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
4223: DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
4224: DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
4225: DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
4226: DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i))
4227: );
4228: END LOOP;
4229: */
4230: EXCEPTION