APPS.OKC_CTI_PVT dependencies on OKC_COVER_TIMES_V

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 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 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 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 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 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 ,