DBA Data[Home] [Help]

APPS.OKC_TIME_PUB dependencies on OKC_TIME_PVT

Line 11: OKC_TIME_PVT.ADD_LANGUAGE;

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,

Line 23: OKC_TIME_PVT.DELETE_TIMEVALUES_N_TASKS(

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,

Line 133: OKC_TIME_PVT.CREATE_TPA_RELTV(

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,

Line 261: OKC_TIME_PVT.UPDATE_TPA_RELTV(

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,

Line 387: OKC_TIME_PVT.DELETE_TPA_RELTV(

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,

Line 489: OKC_TIME_PVT.LOCK_TPA_RELTV(

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,

Line 552: OKC_TIME_PVT.VALID_TPA_RELTV(

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,

Line 708: OKC_TIME_PVT.CREATE_TPA_RELTV(

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,

Line 836: OKC_TIME_PVT.UPDATE_TPA_RELTV(

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,

Line 962: OKC_TIME_PVT.DELETE_TPA_RELTV(

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,

Line 1064: OKC_TIME_PVT.LOCK_TPA_RELTV(

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,

Line 1127: OKC_TIME_PVT.VALID_TPA_RELTV(

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,

Line 1283: OKC_TIME_PVT.CREATE_TPA_VALUE(

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,

Line 1411: OKC_TIME_PVT.UPDATE_TPA_VALUE(

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,

Line 1537: OKC_TIME_PVT.DELETE_TPA_VALUE(

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,

Line 1639: OKC_TIME_PVT.LOCK_TPA_VALUE(

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,

Line 1702: OKC_TIME_PVT.VALID_TPA_VALUE(

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,

Line 1864: OKC_TIME_PVT.CREATE_TPG_DELIMITED(

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,

Line 1992: OKC_TIME_PVT.UPDATE_TPG_DELIMITED(

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,

Line 2118: OKC_TIME_PVT.DELETE_TPG_DELIMITED(

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,

Line 2220: OKC_TIME_PVT.LOCK_TPG_DELIMITED(

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,

Line 2283: OKC_TIME_PVT.VALID_TPG_DELIMITED(

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,

Line 2437: OKC_TIME_PVT.CREATE_TPG_NAMED(

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,

Line 2565: OKC_TIME_PVT.UPDATE_TPG_NAMED(

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,

Line 2691: OKC_TIME_PVT.DELETE_TPG_NAMED(

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,

Line 2793: OKC_TIME_PVT.LOCK_TPG_NAMED(

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,

Line 2856: OKC_TIME_PVT.VALID_TPG_NAMED(

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,

Line 3087: OKC_TIME_PVT.CREATE_IA_STARTEND(

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,

Line 3215: OKC_TIME_PVT.UPDATE_IA_STARTEND(

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,

Line 3341: OKC_TIME_PVT.DELETE_IA_STARTEND(

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,

Line 3443: OKC_TIME_PVT.LOCK_IA_STARTEND(

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,

Line 3506: OKC_TIME_PVT.VALID_IA_STARTEND(

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,

Line 3591: OKC_TIME_PVT.CREATE_IA_STARTEND(

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,

Line 3719: OKC_TIME_PVT.UPDATE_IA_STARTEND(

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,

Line 3845: OKC_TIME_PVT.DELETE_IA_STARTEND(

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,

Line 3947: OKC_TIME_PVT.LOCK_IA_STARTEND(

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,

Line 4010: OKC_TIME_PVT.VALID_IA_STARTEND(

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,

Line 4165: OKC_TIME_PVT.CREATE_IG_STARTEND(

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,

Line 4293: OKC_TIME_PVT.UPDATE_IG_STARTEND(

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,

Line 4419: OKC_TIME_PVT.DELETE_IG_STARTEND(

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,

Line 4521: OKC_TIME_PVT.LOCK_IG_STARTEND(

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,

Line 4584: OKC_TIME_PVT.VALID_IG_STARTEND(

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,

Line 4743: OKC_TIME_PVT.CREATE_CYCLE(

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,

Line 4871: OKC_TIME_PVT.UPDATE_CYCLE(

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,

Line 4997: OKC_TIME_PVT.DELETE_CYCLE(

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,

Line 5099: OKC_TIME_PVT.LOCK_CYCLE(

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,

Line 5162: OKC_TIME_PVT.VALID_CYCLE(

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,

Line 5298: OKC_TIME_PVT.CREATE_SPAN(

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,

Line 5426: OKC_TIME_PVT.UPDATE_SPAN(

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,

Line 5552: OKC_TIME_PVT.DELETE_SPAN(

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,

Line 5654: OKC_TIME_PVT.LOCK_SPAN(

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,

Line 5717: OKC_TIME_PVT.VALID_SPAN(

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,

Line 5869: OKC_TIME_PVT.CREATE_TIME_CODE_UNITS(

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,

Line 5997: OKC_TIME_PVT.UPDATE_TIME_CODE_UNITS(

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,

Line 6123: OKC_TIME_PVT.DELETE_TIME_CODE_UNITS(

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,

Line 6225: OKC_TIME_PVT.LOCK_TIME_CODE_UNITS(

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,

Line 6288: OKC_TIME_PVT.VALID_TIME_CODE_UNITS(

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,

Line 6421: OKC_TIME_PVT.CREATE_RESOLVED_TIMEVALUES(

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,

Line 6549: OKC_TIME_PVT.UPDATE_RESOLVED_TIMEVALUES(

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,

Line 6675: OKC_TIME_PVT.DELETE_RESOLVED_TIMEVALUES(

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,

Line 6777: OKC_TIME_PVT.LOCK_RESOLVED_TIMEVALUES(

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,

Line 6840: OKC_TIME_PVT.VALID_RESOLVED_TIMEVALUES(

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,