DBA Data[Home] [Help]

APPS.OKC_TIME_PVT dependencies on OKC_TIME_PUB

Line 524: OKC_TIME_pub.create_tpg_named(

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;
524: OKC_TIME_pub.create_tpg_named(
525: p_api_version,
526: p_init_msg_list,
527: x_return_status,
528: x_msg_count,

Line 567: OKC_TIME_pub.update_tpg_named(

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,
569: p_init_msg_list,
570: x_return_status,
571: x_msg_count,

Line 606: OKC_TIME_pub.delete_tpg_named(

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,

Line 658: OKC_TIME_pub.valid_tpg_named(

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,
660: p_init_msg_list,
661: x_return_status,
662: x_msg_count,

Line 885: OKC_TIME_pub.create_ia_startend(

881: p_isev_ext_rec.description := 'Limited by of Generic';
882: p_isev_ext_rec.short_description := 'Limited by of Generic';
883: p_isev_ext_rec.comments := 'Generated by TGD';
884: p_isev_ext_rec.dnz_chr_id := p_tgdv_ext_rec.dnz_chr_id;
885: OKC_TIME_pub.create_ia_startend(
886: p_api_version,
887: p_init_msg_list,
888: x_return_status,
889: x_msg_count,

Line 959: OKC_TIME_pub.create_ia_startend(

955: p_isev_ext_rec.description := 'Limited by of Generic';
956: p_isev_ext_rec.short_description := 'Limited by of Generic';
957: p_isev_ext_rec.comments := 'Generated by TGD';
958: p_isev_ext_rec.dnz_chr_id := l_okc_tve.dnz_chr_id;
959: OKC_TIME_pub.create_ia_startend(
960: p_api_version,
961: p_init_msg_list,
962: x_return_status,
963: x_msg_count,

Line 977: OKC_TIME_pub.delete_ia_startend(

973: end if;
974: else
975: if p_tgdv_ext_rec.limited_start_date is null then
976: p_isev_ext_rec.id := l_okc_tve.tve_id_limited;
977: OKC_TIME_pub.delete_ia_startend(
978: p_api_version,
979: p_init_msg_list,
980: x_return_status,
981: x_msg_count,

Line 1002: OKC_TIME_pub.update_ia_startend(

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(
1003: p_api_version,
1004: p_init_msg_list,
1005: x_return_status,
1006: x_msg_count,

Line 1069: OKC_TIME_pub.delete_ia_startend(

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,
1072: x_return_status,
1073: x_msg_count,

Line 1427: OKC_TIME_PUB.create_tpa_value(

1423: p_tavv_rec.description := 'Start date of Absolute Interval';
1424: p_tavv_rec.short_description := 'Start of Abs Intrvl';
1425: p_tavv_rec.comments := 'Generated by ISE';
1426: p_tavv_rec.dnz_chr_id := p_isev_ext_rec.dnz_chr_id;
1427: OKC_TIME_PUB.create_tpa_value(
1428: p_api_version,
1429: p_init_msg_list,
1430: x_return_status,
1431: x_msg_count,

Line 1549: OKC_TIME_pub.update_tpa_value(

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,
1551: p_init_msg_list,
1552: x_return_status,
1553: x_msg_count,

Line 1607: OKC_TIME_pub.delete_tpa_value(

1603: p_tavv_rec.id := l_okc_tve.tve_id_started;
1604: else
1605: p_tavv_rec.id := p_isev_ext_rec.tve_id_started;
1606: end if;
1607: OKC_TIME_pub.delete_tpa_value(
1608: p_api_version,
1609: p_init_msg_list,
1610: x_return_status,
1611: x_msg_count,

Line 1709: OKC_TIME_pub.create_tpa_reltv(

1705: p_talv_rec.description := 'Start date of Relative Interval';
1706: p_talv_rec.short_description := 'Start of Rel Intrvl';
1707: p_talv_rec.comments := 'Generated by ISE';
1708: p_talv_rec.dnz_chr_id := p_isev_rel_rec.dnz_chr_id;
1709: OKC_TIME_pub.create_tpa_reltv(
1710: p_api_version,
1711: p_init_msg_list,
1712: x_return_status,
1713: x_msg_count,

Line 1812: OKC_TIME_pub.update_tpa_reltv(

1808: p_talv_rec.duration := -1 * x_isev_rel_rec.start_duration;
1809: end if;
1810: p_talv_rec.uom_code := x_isev_rel_rec.start_uom_code;
1811: p_talv_rec.operator := x_isev_rel_rec.start_operator;
1812: OKC_TIME_pub.update_tpa_reltv(
1813: p_api_version,
1814: p_init_msg_list,
1815: x_return_status,
1816: x_msg_count,

Line 1858: OKC_TIME_pub.delete_tpa_reltv(

1854: p_talv_rec.id := l_okc_tve.tve_id_started;
1855: else
1856: p_talv_rec.id := p_isev_rel_rec.tve_id_started;
1857: end if;
1858: OKC_TIME_pub.delete_tpa_reltv(
1859: p_api_version,
1860: p_init_msg_list,
1861: x_return_status,
1862: x_msg_count,

Line 2023: OKC_TIME_pub.create_tpg_delimited(

2019: p_tgdv_ext_rec.description := 'Start of Generic Interval Startend';
2020: p_tgdv_ext_rec.short_description := 'Start Generic Intrvl';
2021: p_tgdv_ext_rec.comments := 'Generated by IGS';
2022: p_tgdv_ext_rec.dnz_chr_id := p_igsv_ext_rec.dnz_chr_id;
2023: OKC_TIME_pub.create_tpg_delimited(
2024: p_api_version,
2025: p_init_msg_list,
2026: x_return_status,
2027: x_msg_count,

Line 2046: OKC_TIME_pub.create_tpg_delimited(

2042: p_tgdv_ext_rec.description := 'End of Generic Interval Startend';
2043: p_tgdv_ext_rec.short_description := 'End Generic Intrvl';
2044: p_tgdv_ext_rec.comments := 'Generated by IGS';
2045: p_tgdv_ext_rec.dnz_chr_id := p_igsv_ext_rec.dnz_chr_id;
2046: OKC_TIME_pub.create_tpg_delimited(
2047: p_api_version,
2048: p_init_msg_list,
2049: x_return_status,
2050: x_msg_count,

Line 2109: OKC_TIME_pub.update_tpg_delimited(

2105: p_tgdv_ext_rec.hour := p_igsv_ext_rec.start_hour;
2106: p_tgdv_ext_rec.minute := p_igsv_ext_rec.start_minute;
2107: p_tgdv_ext_rec.second := p_igsv_ext_rec.start_second;
2108: p_tgdv_ext_rec.nth := p_igsv_ext_rec.start_nth;
2109: OKC_TIME_pub.update_tpg_delimited(
2110: p_api_version,
2111: p_init_msg_list,
2112: x_return_status,
2113: x_msg_count,

Line 2128: OKC_TIME_pub.update_tpg_delimited(

2124: p_tgdv_ext_rec.hour := p_igsv_ext_rec.end_hour;
2125: p_tgdv_ext_rec.minute := p_igsv_ext_rec.end_minute;
2126: p_tgdv_ext_rec.second := p_igsv_ext_rec.end_second;
2127: p_tgdv_ext_rec.nth := p_igsv_ext_rec.end_nth;
2128: OKC_TIME_pub.update_tpg_delimited(
2129: p_api_version,
2130: p_init_msg_list,
2131: x_return_status,
2132: x_msg_count,

Line 2162: OKC_TIME_pub.delete_tpg_delimited(

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(
2163: p_api_version,
2164: p_init_msg_list,
2165: x_return_status,
2166: x_msg_count,

Line 2173: OKC_TIME_pub.delete_tpg_delimited(

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(
2174: p_api_version,
2175: p_init_msg_list,
2176: x_return_status,
2177: x_msg_count,

Line 2604: OKC_TIME_pub.create_ia_startend(

2600: p_isev_ext_rec.description := 'Limited by of Cycle';
2601: p_isev_ext_rec.short_description := 'Limited by of Cycle';
2602: p_isev_ext_rec.comments := 'Generated by cyl';
2603: p_isev_ext_rec.dnz_chr_id := p_cylv_ext_rec.dnz_chr_id;
2604: OKC_TIME_pub.create_ia_startend(
2605: p_api_version,
2606: p_init_msg_list,
2607: x_return_status,
2608: x_msg_count,

Line 2637: OKC_TIME_pub.create_span(

2633: p_spnv_rec.duration := x_cylv_ext_rec.duration;
2634: p_spnv_rec.active_yn := x_cylv_ext_rec.active_yn;
2635: p_spnv_rec.tve_id := x_cylv_ext_rec.id;
2636: p_spnv_rec.object_version_number := x_cylv_ext_rec.object_version_number;
2637: OKC_TIME_pub.create_span(
2638: p_api_version,
2639: p_init_msg_list,
2640: x_return_status,
2641: x_msg_count,

Line 2706: OKC_TIME_pub.create_ia_startend(

2702: p_isev_ext_rec.description := 'Limited by of Generic';
2703: p_isev_ext_rec.short_description := 'Limited by of Generic';
2704: p_isev_ext_rec.comments := 'Generated by cyl';
2705: p_isev_ext_rec.dnz_chr_id := l_okc_tve.dnz_chr_id;
2706: OKC_TIME_pub.create_ia_startend(
2707: p_api_version,
2708: p_init_msg_list,
2709: x_return_status,
2710: x_msg_count,

Line 2722: OKC_TIME_pub.delete_ia_startend(

2718: end if;
2719: else
2720: if p_cylv_ext_rec.limited_start_date is null then
2721: p_isev_ext_rec.id := l_okc_tve.tve_id_limited;
2722: OKC_TIME_pub.delete_ia_startend(
2723: p_api_version,
2724: p_init_msg_list,
2725: x_return_status,
2726: x_msg_count,

Line 2745: OKC_TIME_pub.update_ia_startend(

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(
2746: p_api_version,
2747: p_init_msg_list,
2748: x_return_status,
2749: x_msg_count,

Line 2778: OKC_TIME_pub.update_span(

2774: p_spnv_rec.uom_code := x_cylv_ext_rec.uom_code;
2775: p_spnv_rec.duration := x_cylv_ext_rec.duration;
2776: p_spnv_rec.active_yn := x_cylv_ext_rec.active_yn;
2777: p_spnv_rec.object_version_number := p_cylv_ext_rec.object_version_number;
2778: OKC_TIME_pub.update_span(
2779: p_api_version,
2780: p_init_msg_list,
2781: x_return_status,
2782: x_msg_count,

Line 2818: OKC_TIME_pub.delete_ia_startend(

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,

Line 2835: OKC_TIME_pub.delete_span(

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;
2835: OKC_TIME_pub.delete_span(
2836: p_api_version,
2837: p_init_msg_list,
2838: x_return_status,
2839: x_msg_count,

Line 2902: OKC_TIME_pub.valid_span(

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(
2903: p_api_version,
2904: p_init_msg_list,
2905: x_return_status,
2906: x_msg_count,