eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_CTI_PVT dependencies on OKC_COVER_TIMES

Line 13: G_VIEW CONSTANT VARCHAR2(200) := 'OKC_COVER_TIMES_V';

9: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKC_NO_PARENT_RECORD';
10: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
11: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
12: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
13: G_VIEW CONSTANT VARCHAR2(200) := 'OKC_COVER_TIMES_V';
14: G_EXCEPTION_HALT_VALIDATION exception;
15: g_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
16:
17: -- Start of comments

Line 363: -- FUNCTION get_rec for: OKC_COVER_TIMES

359: null;
360: END api_copy;
361:
362: ---------------------------------------------------------------------------
363: -- FUNCTION get_rec for: OKC_COVER_TIMES
364: ---------------------------------------------------------------------------
365: FUNCTION get_rec (
366: p_cti_rec IN cti_rec_type,
367: x_no_data_found OUT NOCOPY BOOLEAN

Line 381: FROM Okc_Cover_Times

377: CREATION_DATE,
378: LAST_UPDATED_BY,
379: LAST_UPDATE_DATE,
380: LAST_UPDATE_LOGIN
381: FROM Okc_Cover_Times
382: WHERE okc_cover_times.rul_id = p_rul_id
383: AND okc_cover_times.tve_id = p_tve_id;
384: l_cti_pk cti_pk_csr%ROWTYPE;
385: l_cti_rec cti_rec_type;

Line 382: WHERE okc_cover_times.rul_id = p_rul_id

378: LAST_UPDATED_BY,
379: LAST_UPDATE_DATE,
380: LAST_UPDATE_LOGIN
381: FROM Okc_Cover_Times
382: WHERE okc_cover_times.rul_id = p_rul_id
383: AND okc_cover_times.tve_id = p_tve_id;
384: l_cti_pk cti_pk_csr%ROWTYPE;
385: l_cti_rec cti_rec_type;
386: BEGIN

Line 383: AND okc_cover_times.tve_id = p_tve_id;

379: LAST_UPDATE_DATE,
380: LAST_UPDATE_LOGIN
381: FROM Okc_Cover_Times
382: WHERE okc_cover_times.rul_id = p_rul_id
383: AND okc_cover_times.tve_id = p_tve_id;
384: l_cti_pk cti_pk_csr%ROWTYPE;
385: l_cti_rec cti_rec_type;
386: BEGIN
387: x_no_data_found := TRUE;

Line 414: -- FUNCTION get_rec for: OKC_COVER_TIMES_V

410: BEGIN
411: RETURN(get_rec(p_cti_rec, l_row_notfound));
412: END get_rec;
413: ---------------------------------------------------------------------------
414: -- FUNCTION get_rec for: OKC_COVER_TIMES_V
415: ---------------------------------------------------------------------------
416: FUNCTION get_rec (
417: p_ctiv_rec IN ctiv_rec_type,
418: x_no_data_found OUT NOCOPY BOOLEAN

Line 432: FROM Okc_Cover_Times_V

428: CREATION_DATE,
429: LAST_UPDATED_BY,
430: LAST_UPDATE_DATE,
431: LAST_UPDATE_LOGIN
432: FROM Okc_Cover_Times_V
433: WHERE okc_cover_times_v.rul_id = p_rul_id
434: AND okc_cover_times_v.tve_id = p_tve_id;
435: l_okc_ctiv_pk okc_ctiv_pk_csr%ROWTYPE;
436: l_ctiv_rec ctiv_rec_type;

Line 433: WHERE okc_cover_times_v.rul_id = p_rul_id

429: LAST_UPDATED_BY,
430: LAST_UPDATE_DATE,
431: LAST_UPDATE_LOGIN
432: FROM Okc_Cover_Times_V
433: WHERE okc_cover_times_v.rul_id = p_rul_id
434: AND okc_cover_times_v.tve_id = p_tve_id;
435: l_okc_ctiv_pk okc_ctiv_pk_csr%ROWTYPE;
436: l_ctiv_rec ctiv_rec_type;
437: BEGIN

Line 434: AND okc_cover_times_v.tve_id = p_tve_id;

430: LAST_UPDATE_DATE,
431: LAST_UPDATE_LOGIN
432: FROM Okc_Cover_Times_V
433: WHERE okc_cover_times_v.rul_id = p_rul_id
434: AND okc_cover_times_v.tve_id = p_tve_id;
435: l_okc_ctiv_pk okc_ctiv_pk_csr%ROWTYPE;
436: l_ctiv_rec ctiv_rec_type;
437: BEGIN
438: x_no_data_found := TRUE;

Line 466: -- FUNCTION null_out_defaults for: OKC_COVER_TIMES_V --

462: RETURN(get_rec(p_ctiv_rec, l_row_notfound));
463: END get_rec;
464:
465: -------------------------------------------------------
466: -- FUNCTION null_out_defaults for: OKC_COVER_TIMES_V --
467: -------------------------------------------------------
468: FUNCTION null_out_defaults (
469: p_ctiv_rec IN ctiv_rec_type
470: ) RETURN ctiv_rec_type IS

Line 506: -- Validate_Attributes for:OKC_COVER_TIMES_V --

502: ---------------------------------------------------------------------------
503: -- PROCEDURE Validate_Attributes
504: ---------------------------------------------------------------------------
505: -----------------------------------------------
506: -- Validate_Attributes for:OKC_COVER_TIMES_V --
507: -----------------------------------------------
508: /* commenting out nocopy generated code in favor of hand-coded procedure
509: FUNCTION Validate_Attributes (
510: p_ctiv_rec IN ctiv_rec_type

Line 542: -- Validate_Record for:OKC_COVER_TIMES_V --

538: ---------------------------------------------------------------------------
539: -- PROCEDURE Validate_Record
540: ---------------------------------------------------------------------------
541: -------------------------------------------
542: -- Validate_Record for:OKC_COVER_TIMES_V --
543: -------------------------------------------
544: FUNCTION Validate_Record (
545: p_ctiv_rec IN ctiv_rec_type
546: ) RETURN VARCHAR2 IS

Line 590: -- validate_row for:OKC_COVER_TIMES_V --

586: ---------------------------------------------------------------------------
587: -- PROCEDURE validate_row
588: ---------------------------------------------------------------------------
589: ----------------------------------------
590: -- validate_row for:OKC_COVER_TIMES_V --
591: ----------------------------------------
592: PROCEDURE validate_row(
593: p_api_version IN NUMBER,
594: p_init_msg_list IN VARCHAR2 ,

Line 734: -- insert_row for:OKC_COVER_TIMES --

730: ---------------------------------------------------------------------------
731: -- PROCEDURE insert_row
732: ---------------------------------------------------------------------------
733: ------------------------------------
734: -- insert_row for:OKC_COVER_TIMES --
735: ------------------------------------
736: PROCEDURE insert_row(
737: p_init_msg_list IN VARCHAR2 ,
738: x_return_status OUT NOCOPY VARCHAR2,

Line 750: -- Set_Attributes for:OKC_COVER_TIMES --

746: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
747: l_cti_rec cti_rec_type := p_cti_rec;
748: l_def_cti_rec cti_rec_type;
749: ----------------------------------------
750: -- Set_Attributes for:OKC_COVER_TIMES --
751: ----------------------------------------
752: FUNCTION Set_Attributes (
753: p_cti_rec IN cti_rec_type,
754: x_cti_rec OUT NOCOPY cti_rec_type

Line 781: INSERT INTO OKC_COVER_TIMES(

777: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
778: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
779: RAISE OKC_API.G_EXCEPTION_ERROR;
780: END IF;
781: INSERT INTO OKC_COVER_TIMES(
782: rul_id,
783: tve_id,
784: dnz_chr_id,
785: object_version_number,

Line 837: -- insert_row for:OKC_COVER_TIMES_V --

833: '_PVT'
834: );
835: END insert_row;
836: --------------------------------------
837: -- insert_row for:OKC_COVER_TIMES_V --
838: --------------------------------------
839: PROCEDURE insert_row(
840: p_api_version IN NUMBER,
841: p_init_msg_list IN VARCHAR2 ,

Line 871: -- Set_Attributes for:OKC_COVER_TIMES_V --

867: l_ctiv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
868: RETURN(l_ctiv_rec);
869: END fill_who_columns;
870: ------------------------------------------
871: -- Set_Attributes for:OKC_COVER_TIMES_V --
872: ------------------------------------------
873: FUNCTION Set_Attributes (
874: p_ctiv_rec IN ctiv_rec_type,
875: x_ctiv_rec OUT NOCOPY ctiv_rec_type

Line 1049: -- lock_row for:OKC_COVER_TIMES --

1045: ---------------------------------------------------------------------------
1046: -- PROCEDURE lock_row
1047: ---------------------------------------------------------------------------
1048: ----------------------------------
1049: -- lock_row for:OKC_COVER_TIMES --
1050: ----------------------------------
1051: PROCEDURE lock_row(
1052: p_init_msg_list IN VARCHAR2 ,
1053: x_return_status OUT NOCOPY VARCHAR2,

Line 1062: FROM OKC_COVER_TIMES

1058: E_Resource_Busy EXCEPTION;
1059: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1060: CURSOR lock_csr (p_cti_rec IN cti_rec_type) IS
1061: SELECT OBJECT_VERSION_NUMBER
1062: FROM OKC_COVER_TIMES
1063: WHERE RUL_ID = p_cti_rec.rul_id
1064: AND TVE_ID = p_cti_rec.tve_id
1065: AND OBJECT_VERSION_NUMBER = p_cti_rec.object_version_number
1066: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line 1070: FROM OKC_COVER_TIMES

1066: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1067:
1068: CURSOR lchk_csr (p_cti_rec IN cti_rec_type) IS
1069: SELECT OBJECT_VERSION_NUMBER
1070: FROM OKC_COVER_TIMES
1071: WHERE RUL_ID = p_cti_rec.rul_id
1072: AND TVE_ID = p_cti_rec.tve_id;
1073: l_api_version CONSTANT NUMBER := 1;
1074: l_api_name CONSTANT VARCHAR2(30) := 'TIMES_lock_row';

Line 1076: l_object_version_number OKC_COVER_TIMES.OBJECT_VERSION_NUMBER%TYPE;

1072: AND TVE_ID = p_cti_rec.tve_id;
1073: l_api_version CONSTANT NUMBER := 1;
1074: l_api_name CONSTANT VARCHAR2(30) := 'TIMES_lock_row';
1075: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1076: l_object_version_number OKC_COVER_TIMES.OBJECT_VERSION_NUMBER%TYPE;
1077: lc_object_version_number OKC_COVER_TIMES.OBJECT_VERSION_NUMBER%TYPE;
1078: l_row_notfound BOOLEAN := FALSE;
1079: lc_row_notfound BOOLEAN := FALSE;
1080: BEGIN

Line 1077: lc_object_version_number OKC_COVER_TIMES.OBJECT_VERSION_NUMBER%TYPE;

1073: l_api_version CONSTANT NUMBER := 1;
1074: l_api_name CONSTANT VARCHAR2(30) := 'TIMES_lock_row';
1075: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1076: l_object_version_number OKC_COVER_TIMES.OBJECT_VERSION_NUMBER%TYPE;
1077: lc_object_version_number OKC_COVER_TIMES.OBJECT_VERSION_NUMBER%TYPE;
1078: l_row_notfound BOOLEAN := FALSE;
1079: lc_row_notfound BOOLEAN := FALSE;
1080: BEGIN
1081: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1157: -- lock_row for:OKC_COVER_TIMES_V --

1153: '_PVT'
1154: );
1155: END lock_row;
1156: ------------------------------------
1157: -- lock_row for:OKC_COVER_TIMES_V --
1158: ------------------------------------
1159: PROCEDURE lock_row(
1160: p_api_version IN NUMBER,
1161: p_init_msg_list IN VARCHAR2 ,

Line 1305: -- update_row for:OKC_COVER_TIMES --

1301: ---------------------------------------------------------------------------
1302: -- PROCEDURE update_row
1303: ---------------------------------------------------------------------------
1304: ------------------------------------
1305: -- update_row for:OKC_COVER_TIMES --
1306: ------------------------------------
1307: PROCEDURE update_row(
1308: p_init_msg_list IN VARCHAR2 ,
1309: x_return_status OUT NOCOPY VARCHAR2,

Line 1377: -- Set_Attributes for:OKC_COVER_TIMES --

1373: END IF;
1374: RETURN(l_return_status);
1375: END populate_new_record;
1376: ----------------------------------------
1377: -- Set_Attributes for:OKC_COVER_TIMES --
1378: ----------------------------------------
1379: FUNCTION Set_Attributes (
1380: p_cti_rec IN cti_rec_type,
1381: x_cti_rec OUT NOCOPY cti_rec_type

Line 1414: UPDATE OKC_COVER_TIMES

1410: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1411: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1412: RAISE OKC_API.G_EXCEPTION_ERROR;
1413: END IF;
1414: UPDATE OKC_COVER_TIMES
1415: SET DNZ_CHR_ID = l_def_cti_rec.dnz_chr_id,
1416: OBJECT_VERSION_NUMBER = l_def_cti_rec.object_version_number,
1417: CREATED_BY = l_def_cti_rec.created_by,
1418: CREATION_DATE = l_def_cti_rec.creation_date,

Line 1460: -- update_row for:OKC_COVER_TIMES_V --

1456: '_PVT'
1457: );
1458: END update_row;
1459: --------------------------------------
1460: -- update_row for:OKC_COVER_TIMES_V --
1461: --------------------------------------
1462: PROCEDURE update_row(
1463: p_api_version IN NUMBER,
1464: p_init_msg_list IN VARCHAR2 ,

Line 1547: -- Set_Attributes for:OKC_COVER_TIMES_V --

1543: END IF;
1544: RETURN(l_return_status);
1545: END populate_new_record;
1546: ------------------------------------------
1547: -- Set_Attributes for:OKC_COVER_TIMES_V --
1548: ------------------------------------------
1549: FUNCTION Set_Attributes (
1550: p_ctiv_rec IN ctiv_rec_type,
1551: x_ctiv_rec OUT NOCOPY ctiv_rec_type

Line 1730: -- delete_row for:OKC_COVER_TIMES --

1726: ---------------------------------------------------------------------------
1727: -- PROCEDURE delete_row
1728: ---------------------------------------------------------------------------
1729: ------------------------------------
1730: -- delete_row for:OKC_COVER_TIMES --
1731: ------------------------------------
1732: PROCEDURE delete_row(
1733: p_init_msg_list IN VARCHAR2 ,
1734: x_return_status OUT NOCOPY VARCHAR2,

Line 1775: DELETE FROM OKC_COVER_TIMES

1771: END IF;
1772:
1773:
1774: -- delete cover times
1775: DELETE FROM OKC_COVER_TIMES
1776: WHERE RUL_ID = l_cti_rec.rul_id AND TVE_ID = l_cti_rec.tve_id;
1777:
1778: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1779: EXCEPTION

Line 1812: -- delete_row for:OKC_COVER_TIMES_V --

1808: '_PVT'
1809: );
1810: END delete_row;
1811: --------------------------------------
1812: -- delete_row for:OKC_COVER_TIMES_V --
1813: --------------------------------------
1814: PROCEDURE delete_row(
1815: p_api_version IN NUMBER,
1816: p_init_msg_list IN VARCHAR2 ,

Line 1958: -- Procedure for mass insert in OKC_COVER_TIMES _B and TL tables

1954: );
1955: END delete_row;
1956:
1957: ---------------------------------------------------------------
1958: -- Procedure for mass insert in OKC_COVER_TIMES _B and TL tables
1959: ---------------------------------------------------------------
1960: PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2,p_ctiv_tbl ctiv_tbl_type) IS
1961: l_tabsize NUMBER := p_ctiv_tbl.COUNT;
1962: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;

Line 1997: INTO OKC_COVER_TIMES

1993: END LOOP;
1994:
1995: FORALL i in 1..l_tabsize
1996: INSERT
1997: INTO OKC_COVER_TIMES
1998: (
1999: rul_id,
2000: tve_id,
2001: dnz_chr_id,

Line 2051: INSERT INTO okc_cover_times_h

2047:
2048: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
2049:
2050: BEGIN
2051: INSERT INTO okc_cover_times_h
2052: (
2053: major_version,
2054: rul_id,
2055: tve_id,

Line 2075: FROM okc_cover_times

2071: creation_date,
2072: last_updated_by,
2073: last_update_date,
2074: last_update_login
2075: FROM okc_cover_times
2076: WHERE dnz_chr_id = p_chr_id;
2077:
2078: RETURN l_return_status;
2079: EXCEPTION

Line 2107: INSERT INTO okc_cover_times

2103:
2104: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
2105:
2106: BEGIN
2107: INSERT INTO okc_cover_times
2108: (
2109: rul_id,
2110: tve_id,
2111: dnz_chr_id,

Line 2129: FROM okc_cover_times_h

2125: creation_date,
2126: last_updated_by,
2127: last_update_date,
2128: last_update_login
2129: FROM okc_cover_times_h
2130: WHERE dnz_chr_id = p_chr_id
2131: AND major_version = p_major_version;
2132:
2133: RETURN l_return_status;