7: --------------------------------------------------------------------------
8:
9: PROCEDURE ADD_LANGUAGE IS
10: BEGIN
11: OKC_TIME_PVT.ADD_LANGUAGE;
12: END ADD_LANGUAGE;
13:
14: PROCEDURE DELETE_TIMEVALUES_N_TASKS(
15: p_api_version IN NUMBER,
19: x_msg_data OUT NOCOPY VARCHAR2,
20: p_chr_id IN NUMBER ,
21: p_tve_id IN NUMBER) IS
22: BEGIN
23: OKC_TIME_PVT.DELETE_TIMEVALUES_N_TASKS(
24: p_api_version,
25: p_init_msg_list,
26: x_return_status,
27: x_msg_count,
129: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
130: raise OKC_API.G_EXCEPTION_ERROR;
131: END IF;
132: l_talv_rec := migrate_talv(l_talv_rec, g_talv_rec);
133: OKC_TIME_PVT.CREATE_TPA_RELTV(
134: p_api_version,
135: p_init_msg_list,
136: x_return_status,
137: x_msg_count,
257: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
258: raise OKC_API.G_EXCEPTION_ERROR;
259: END IF;
260: l_talv_rec := migrate_talv(l_talv_rec, g_talv_rec);
261: OKC_TIME_PVT.UPDATE_TPA_RELTV(
262: p_api_version,
263: p_init_msg_list,
264: x_return_status,
265: x_msg_count,
383: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
384: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
385: raise OKC_API.G_EXCEPTION_ERROR;
386: END IF;
387: OKC_TIME_PVT.DELETE_TPA_RELTV(
388: p_api_version,
389: p_init_msg_list,
390: x_return_status,
391: x_msg_count,
485: x_msg_count OUT NOCOPY NUMBER,
486: x_msg_data OUT NOCOPY VARCHAR2,
487: p_talv_rec IN talv_rec_type) IS
488: BEGIN
489: OKC_TIME_PVT.LOCK_TPA_RELTV(
490: p_api_version,
491: p_init_msg_list,
492: x_return_status,
493: x_msg_count,
548: x_msg_count OUT NOCOPY NUMBER,
549: x_msg_data OUT NOCOPY VARCHAR2,
550: p_talv_rec IN talv_rec_type) IS
551: BEGIN
552: OKC_TIME_PVT.VALID_TPA_RELTV(
553: p_api_version,
554: p_init_msg_list,
555: x_return_status,
556: x_msg_count,
704: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
705: raise OKC_API.G_EXCEPTION_ERROR;
706: END IF;
707: l_talv_evt_rec := migrate_talv(l_talv_evt_rec, g_talv_evt_rec);
708: OKC_TIME_PVT.CREATE_TPA_RELTV(
709: p_api_version,
710: p_init_msg_list,
711: x_return_status,
712: x_msg_count,
832: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
833: raise OKC_API.G_EXCEPTION_ERROR;
834: END IF;
835: l_talv_evt_rec := migrate_talv(l_talv_evt_rec, g_talv_evt_rec);
836: OKC_TIME_PVT.UPDATE_TPA_RELTV(
837: p_api_version,
838: p_init_msg_list,
839: x_return_status,
840: x_msg_count,
958: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
959: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
960: raise OKC_API.G_EXCEPTION_ERROR;
961: END IF;
962: OKC_TIME_PVT.DELETE_TPA_RELTV(
963: p_api_version,
964: p_init_msg_list,
965: x_return_status,
966: x_msg_count,
1060: x_msg_count OUT NOCOPY NUMBER,
1061: x_msg_data OUT NOCOPY VARCHAR2,
1062: p_talv_evt_rec IN talv_evt_rec_type) IS
1063: BEGIN
1064: OKC_TIME_PVT.LOCK_TPA_RELTV(
1065: p_api_version,
1066: p_init_msg_list,
1067: x_return_status,
1068: x_msg_count,
1123: x_msg_count OUT NOCOPY NUMBER,
1124: x_msg_data OUT NOCOPY VARCHAR2,
1125: p_talv_evt_rec IN talv_evt_rec_type) IS
1126: BEGIN
1127: OKC_TIME_PVT.VALID_TPA_RELTV(
1128: p_api_version,
1129: p_init_msg_list,
1130: x_return_status,
1131: x_msg_count,
1279: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1280: raise OKC_API.G_EXCEPTION_ERROR;
1281: END IF;
1282: l_tavv_rec := migrate_tavv(l_tavv_rec, g_tavv_rec);
1283: OKC_TIME_PVT.CREATE_TPA_VALUE(
1284: p_api_version,
1285: p_init_msg_list,
1286: x_return_status,
1287: x_msg_count,
1407: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1408: raise OKC_API.G_EXCEPTION_ERROR;
1409: END IF;
1410: l_tavv_rec := migrate_tavv(l_tavv_rec, g_tavv_rec);
1411: OKC_TIME_PVT.UPDATE_TPA_VALUE(
1412: p_api_version,
1413: p_init_msg_list,
1414: x_return_status,
1415: x_msg_count,
1533: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1534: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1535: raise OKC_API.G_EXCEPTION_ERROR;
1536: END IF;
1537: OKC_TIME_PVT.DELETE_TPA_VALUE(
1538: p_api_version,
1539: p_init_msg_list,
1540: x_return_status,
1541: x_msg_count,
1635: x_msg_count OUT NOCOPY NUMBER,
1636: x_msg_data OUT NOCOPY VARCHAR2,
1637: p_tavv_rec IN tavv_rec_type) IS
1638: BEGIN
1639: OKC_TIME_PVT.LOCK_TPA_VALUE(
1640: p_api_version,
1641: p_init_msg_list,
1642: x_return_status,
1643: x_msg_count,
1698: x_msg_count OUT NOCOPY NUMBER,
1699: x_msg_data OUT NOCOPY VARCHAR2,
1700: p_tavv_rec IN tavv_rec_type) IS
1701: BEGIN
1702: OKC_TIME_PVT.VALID_TPA_VALUE(
1703: p_api_version,
1704: p_init_msg_list,
1705: x_return_status,
1706: x_msg_count,
1860: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1861: raise OKC_API.G_EXCEPTION_ERROR;
1862: END IF;
1863: l_tgdv_ext_rec := migrate_tgdv(l_tgdv_ext_rec, g_tgdv_ext_rec);
1864: OKC_TIME_PVT.CREATE_TPG_DELIMITED(
1865: p_api_version,
1866: p_init_msg_list,
1867: x_return_status,
1868: x_msg_count,
1988: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1989: raise OKC_API.G_EXCEPTION_ERROR;
1990: END IF;
1991: l_tgdv_ext_rec := migrate_tgdv(l_tgdv_ext_rec, g_tgdv_ext_rec);
1992: OKC_TIME_PVT.UPDATE_TPG_DELIMITED(
1993: p_api_version,
1994: p_init_msg_list,
1995: x_return_status,
1996: x_msg_count,
2114: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2115: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2116: raise OKC_API.G_EXCEPTION_ERROR;
2117: END IF;
2118: OKC_TIME_PVT.DELETE_TPG_DELIMITED(
2119: p_api_version,
2120: p_init_msg_list,
2121: x_return_status,
2122: x_msg_count,
2216: x_msg_count OUT NOCOPY NUMBER,
2217: x_msg_data OUT NOCOPY VARCHAR2,
2218: p_tgdv_ext_rec IN tgdv_ext_rec_type) IS
2219: BEGIN
2220: OKC_TIME_PVT.LOCK_TPG_DELIMITED(
2221: p_api_version,
2222: p_init_msg_list,
2223: x_return_status,
2224: x_msg_count,
2279: x_msg_count OUT NOCOPY NUMBER,
2280: x_msg_data OUT NOCOPY VARCHAR2,
2281: p_tgdv_ext_rec IN tgdv_ext_rec_type) IS
2282: BEGIN
2283: OKC_TIME_PVT.VALID_TPG_DELIMITED(
2284: p_api_version,
2285: p_init_msg_list,
2286: x_return_status,
2287: x_msg_count,
2433: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2434: raise OKC_API.G_EXCEPTION_ERROR;
2435: END IF;
2436: l_tgnv_rec := migrate_tgnv(l_tgnv_rec, g_tgnv_rec);
2437: OKC_TIME_PVT.CREATE_TPG_NAMED(
2438: p_api_version,
2439: p_init_msg_list,
2440: x_return_status,
2441: x_msg_count,
2561: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2562: raise OKC_API.G_EXCEPTION_ERROR;
2563: END IF;
2564: l_tgnv_rec := migrate_tgnv(l_tgnv_rec, g_tgnv_rec);
2565: OKC_TIME_PVT.UPDATE_TPG_NAMED(
2566: p_api_version,
2567: p_init_msg_list,
2568: x_return_status,
2569: x_msg_count,
2687: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2688: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2689: raise OKC_API.G_EXCEPTION_ERROR;
2690: END IF;
2691: OKC_TIME_PVT.DELETE_TPG_NAMED(
2692: p_api_version,
2693: p_init_msg_list,
2694: x_return_status,
2695: x_msg_count,
2789: x_msg_count OUT NOCOPY NUMBER,
2790: x_msg_data OUT NOCOPY VARCHAR2,
2791: p_tgnv_rec IN tgnv_rec_type) IS
2792: BEGIN
2793: OKC_TIME_PVT.LOCK_TPG_NAMED(
2794: p_api_version,
2795: p_init_msg_list,
2796: x_return_status,
2797: x_msg_count,
2852: x_msg_count OUT NOCOPY NUMBER,
2853: x_msg_data OUT NOCOPY VARCHAR2,
2854: p_tgnv_rec IN tgnv_rec_type) IS
2855: BEGIN
2856: OKC_TIME_PVT.VALID_TPG_NAMED(
2857: p_api_version,
2858: p_init_msg_list,
2859: x_return_status,
2860: x_msg_count,
3083: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3084: raise OKC_API.G_EXCEPTION_ERROR;
3085: END IF;
3086: l_isev_ext_rec := migrate_isev(l_isev_ext_rec, g_isev_ext_rec);
3087: OKC_TIME_PVT.CREATE_IA_STARTEND(
3088: p_api_version,
3089: p_init_msg_list,
3090: x_return_status,
3091: x_msg_count,
3211: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3212: raise OKC_API.G_EXCEPTION_ERROR;
3213: END IF;
3214: l_isev_ext_rec := migrate_isev(l_isev_ext_rec, g_isev_ext_rec);
3215: OKC_TIME_PVT.UPDATE_IA_STARTEND(
3216: p_api_version,
3217: p_init_msg_list,
3218: x_return_status,
3219: x_msg_count,
3337: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3338: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3339: raise OKC_API.G_EXCEPTION_ERROR;
3340: END IF;
3341: OKC_TIME_PVT.DELETE_IA_STARTEND(
3342: p_api_version,
3343: p_init_msg_list,
3344: x_return_status,
3345: x_msg_count,
3439: x_msg_count OUT NOCOPY NUMBER,
3440: x_msg_data OUT NOCOPY VARCHAR2,
3441: p_isev_ext_rec IN isev_ext_rec_type) IS
3442: BEGIN
3443: OKC_TIME_PVT.LOCK_IA_STARTEND(
3444: p_api_version,
3445: p_init_msg_list,
3446: x_return_status,
3447: x_msg_count,
3502: x_msg_count OUT NOCOPY NUMBER,
3503: x_msg_data OUT NOCOPY VARCHAR2,
3504: p_isev_ext_rec IN isev_ext_rec_type) IS
3505: BEGIN
3506: OKC_TIME_PVT.VALID_IA_STARTEND(
3507: p_api_version,
3508: p_init_msg_list,
3509: x_return_status,
3510: x_msg_count,
3587: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3588: raise OKC_API.G_EXCEPTION_ERROR;
3589: END IF;
3590: l_isev_rel_rec := migrate_isev(l_isev_rel_rec, g_isev_rel_rec);
3591: OKC_TIME_PVT.CREATE_IA_STARTEND(
3592: p_api_version,
3593: p_init_msg_list,
3594: x_return_status,
3595: x_msg_count,
3715: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3716: raise OKC_API.G_EXCEPTION_ERROR;
3717: END IF;
3718: l_isev_rel_rec := migrate_isev(l_isev_rel_rec, g_isev_rel_rec);
3719: OKC_TIME_PVT.UPDATE_IA_STARTEND(
3720: p_api_version,
3721: p_init_msg_list,
3722: x_return_status,
3723: x_msg_count,
3841: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3842: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3843: raise OKC_API.G_EXCEPTION_ERROR;
3844: END IF;
3845: OKC_TIME_PVT.DELETE_IA_STARTEND(
3846: p_api_version,
3847: p_init_msg_list,
3848: x_return_status,
3849: x_msg_count,
3943: x_msg_count OUT NOCOPY NUMBER,
3944: x_msg_data OUT NOCOPY VARCHAR2,
3945: p_isev_rel_rec IN isev_rel_rec_type) IS
3946: BEGIN
3947: OKC_TIME_PVT.LOCK_IA_STARTEND(
3948: p_api_version,
3949: p_init_msg_list,
3950: x_return_status,
3951: x_msg_count,
4006: x_msg_count OUT NOCOPY NUMBER,
4007: x_msg_data OUT NOCOPY VARCHAR2,
4008: p_isev_rel_rec IN isev_rel_rec_type) IS
4009: BEGIN
4010: OKC_TIME_PVT.VALID_IA_STARTEND(
4011: p_api_version,
4012: p_init_msg_list,
4013: x_return_status,
4014: x_msg_count,
4161: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4162: raise OKC_API.G_EXCEPTION_ERROR;
4163: END IF;
4164: l_igsv_ext_rec := migrate_igsv(l_igsv_ext_rec, g_igsv_ext_rec);
4165: OKC_TIME_PVT.CREATE_IG_STARTEND(
4166: p_api_version,
4167: p_init_msg_list,
4168: x_return_status,
4169: x_msg_count,
4289: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4290: raise OKC_API.G_EXCEPTION_ERROR;
4291: END IF;
4292: l_igsv_ext_rec := migrate_igsv(l_igsv_ext_rec, g_igsv_ext_rec);
4293: OKC_TIME_PVT.UPDATE_IG_STARTEND(
4294: p_api_version,
4295: p_init_msg_list,
4296: x_return_status,
4297: x_msg_count,
4415: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4416: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4417: raise OKC_API.G_EXCEPTION_ERROR;
4418: END IF;
4419: OKC_TIME_PVT.DELETE_IG_STARTEND(
4420: p_api_version,
4421: p_init_msg_list,
4422: x_return_status,
4423: x_msg_count,
4517: x_msg_count OUT NOCOPY NUMBER,
4518: x_msg_data OUT NOCOPY VARCHAR2,
4519: p_igsv_ext_rec IN igsv_ext_rec_type) IS
4520: BEGIN
4521: OKC_TIME_PVT.LOCK_IG_STARTEND(
4522: p_api_version,
4523: p_init_msg_list,
4524: x_return_status,
4525: x_msg_count,
4580: x_msg_count OUT NOCOPY NUMBER,
4581: x_msg_data OUT NOCOPY VARCHAR2,
4582: p_igsv_ext_rec IN igsv_ext_rec_type) IS
4583: BEGIN
4584: OKC_TIME_PVT.VALID_IG_STARTEND(
4585: p_api_version,
4586: p_init_msg_list,
4587: x_return_status,
4588: x_msg_count,
4739: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4740: raise OKC_API.G_EXCEPTION_ERROR;
4741: END IF;
4742: l_cylv_ext_rec := migrate_cylv(l_cylv_ext_rec, g_cylv_ext_rec);
4743: OKC_TIME_PVT.CREATE_CYCLE(
4744: p_api_version,
4745: p_init_msg_list,
4746: x_return_status,
4747: x_msg_count,
4867: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4868: raise OKC_API.G_EXCEPTION_ERROR;
4869: END IF;
4870: l_cylv_ext_rec := migrate_cylv(l_cylv_ext_rec, g_cylv_ext_rec);
4871: OKC_TIME_PVT.UPDATE_CYCLE(
4872: p_api_version,
4873: p_init_msg_list,
4874: x_return_status,
4875: x_msg_count,
4993: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4994: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4995: raise OKC_API.G_EXCEPTION_ERROR;
4996: END IF;
4997: OKC_TIME_PVT.DELETE_CYCLE(
4998: p_api_version,
4999: p_init_msg_list,
5000: x_return_status,
5001: x_msg_count,
5095: x_msg_count OUT NOCOPY NUMBER,
5096: x_msg_data OUT NOCOPY VARCHAR2,
5097: p_cylv_ext_rec IN cylv_ext_rec_type) IS
5098: BEGIN
5099: OKC_TIME_PVT.LOCK_CYCLE(
5100: p_api_version,
5101: p_init_msg_list,
5102: x_return_status,
5103: x_msg_count,
5158: x_msg_count OUT NOCOPY NUMBER,
5159: x_msg_data OUT NOCOPY VARCHAR2,
5160: p_cylv_ext_rec IN cylv_ext_rec_type) IS
5161: BEGIN
5162: OKC_TIME_PVT.VALID_CYCLE(
5163: p_api_version,
5164: p_init_msg_list,
5165: x_return_status,
5166: x_msg_count,
5294: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
5295: raise OKC_API.G_EXCEPTION_ERROR;
5296: END IF;
5297: l_spnv_rec := migrate_spnv(l_spnv_rec, g_spnv_rec);
5298: OKC_TIME_PVT.CREATE_SPAN(
5299: p_api_version,
5300: p_init_msg_list,
5301: x_return_status,
5302: x_msg_count,
5422: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
5423: raise OKC_API.G_EXCEPTION_ERROR;
5424: END IF;
5425: l_spnv_rec := migrate_spnv(l_spnv_rec, g_spnv_rec);
5426: OKC_TIME_PVT.UPDATE_SPAN(
5427: p_api_version,
5428: p_init_msg_list,
5429: x_return_status,
5430: x_msg_count,
5548: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5549: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
5550: raise OKC_API.G_EXCEPTION_ERROR;
5551: END IF;
5552: OKC_TIME_PVT.DELETE_SPAN(
5553: p_api_version,
5554: p_init_msg_list,
5555: x_return_status,
5556: x_msg_count,
5650: x_msg_count OUT NOCOPY NUMBER,
5651: x_msg_data OUT NOCOPY VARCHAR2,
5652: p_spnv_rec IN spnv_rec_type) IS
5653: BEGIN
5654: OKC_TIME_PVT.LOCK_SPAN(
5655: p_api_version,
5656: p_init_msg_list,
5657: x_return_status,
5658: x_msg_count,
5713: x_msg_count OUT NOCOPY NUMBER,
5714: x_msg_data OUT NOCOPY VARCHAR2,
5715: p_spnv_rec IN spnv_rec_type) IS
5716: BEGIN
5717: OKC_TIME_PVT.VALID_SPAN(
5718: p_api_version,
5719: p_init_msg_list,
5720: x_return_status,
5721: x_msg_count,
5865: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
5866: raise OKC_API.G_EXCEPTION_ERROR;
5867: END IF;
5868: l_tcuv_rec := migrate_tcuv(l_tcuv_rec, g_tcuv_rec);
5869: OKC_TIME_PVT.CREATE_TIME_CODE_UNITS(
5870: p_api_version,
5871: p_init_msg_list,
5872: x_return_status,
5873: x_msg_count,
5993: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
5994: raise OKC_API.G_EXCEPTION_ERROR;
5995: END IF;
5996: l_tcuv_rec := migrate_tcuv(l_tcuv_rec, g_tcuv_rec);
5997: OKC_TIME_PVT.UPDATE_TIME_CODE_UNITS(
5998: p_api_version,
5999: p_init_msg_list,
6000: x_return_status,
6001: x_msg_count,
6119: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6120: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6121: raise OKC_API.G_EXCEPTION_ERROR;
6122: END IF;
6123: OKC_TIME_PVT.DELETE_TIME_CODE_UNITS(
6124: p_api_version,
6125: p_init_msg_list,
6126: x_return_status,
6127: x_msg_count,
6221: x_msg_count OUT NOCOPY NUMBER,
6222: x_msg_data OUT NOCOPY VARCHAR2,
6223: p_tcuv_rec IN tcuv_rec_type) IS
6224: BEGIN
6225: OKC_TIME_PVT.LOCK_TIME_CODE_UNITS(
6226: p_api_version,
6227: p_init_msg_list,
6228: x_return_status,
6229: x_msg_count,
6284: x_msg_count OUT NOCOPY NUMBER,
6285: x_msg_data OUT NOCOPY VARCHAR2,
6286: p_tcuv_rec IN tcuv_rec_type) IS
6287: BEGIN
6288: OKC_TIME_PVT.VALID_TIME_CODE_UNITS(
6289: p_api_version,
6290: p_init_msg_list,
6291: x_return_status,
6292: x_msg_count,
6417: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6418: raise OKC_API.G_EXCEPTION_ERROR;
6419: END IF;
6420: l_rtvv_rec := migrate_rtvv(l_rtvv_rec, g_rtvv_rec);
6421: OKC_TIME_PVT.CREATE_RESOLVED_TIMEVALUES(
6422: p_api_version,
6423: p_init_msg_list,
6424: x_return_status,
6425: x_msg_count,
6545: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6546: raise OKC_API.G_EXCEPTION_ERROR;
6547: END IF;
6548: l_rtvv_rec := migrate_rtvv(l_rtvv_rec, g_rtvv_rec);
6549: OKC_TIME_PVT.UPDATE_RESOLVED_TIMEVALUES(
6550: p_api_version,
6551: p_init_msg_list,
6552: x_return_status,
6553: x_msg_count,
6671: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6672: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6673: raise OKC_API.G_EXCEPTION_ERROR;
6674: END IF;
6675: OKC_TIME_PVT.DELETE_RESOLVED_TIMEVALUES(
6676: p_api_version,
6677: p_init_msg_list,
6678: x_return_status,
6679: x_msg_count,
6773: x_msg_count OUT NOCOPY NUMBER,
6774: x_msg_data OUT NOCOPY VARCHAR2,
6775: p_rtvv_rec IN rtvv_rec_type) IS
6776: BEGIN
6777: OKC_TIME_PVT.LOCK_RESOLVED_TIMEVALUES(
6778: p_api_version,
6779: p_init_msg_list,
6780: x_return_status,
6781: x_msg_count,
6836: x_msg_count OUT NOCOPY NUMBER,
6837: x_msg_data OUT NOCOPY VARCHAR2,
6838: p_rtvv_rec IN rtvv_rec_type) IS
6839: BEGIN
6840: OKC_TIME_PVT.VALID_RESOLVED_TIMEVALUES(
6841: p_api_version,
6842: p_init_msg_list,
6843: x_return_status,
6844: x_msg_count,