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_REACT_INTERVALS_V';
14: G_EXCEPTION_HALT_VALIDATION exception;
15: g_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
16:
17: -- Start of comments
565: BEGIN
566: RETURN(get_rec(p_ril_rec, l_row_notfound));
567: END get_rec;
568: ---------------------------------------------------------------------------
569: -- FUNCTION get_rec for: OKC_REACT_INTERVALS_V
570: ---------------------------------------------------------------------------
571: FUNCTION get_rec (
572: p_rilv_rec IN rilv_rec_type,
573: x_no_data_found OUT NOCOPY BOOLEAN
585: CREATION_DATE,
586: LAST_UPDATED_BY,
587: LAST_UPDATE_DATE,
588: LAST_UPDATE_LOGIN
589: FROM Okc_React_Intervals_V
590: WHERE okc_react_intervals_v.tve_id = p_tve_id
591: AND okc_react_intervals_v.rul_id = p_rul_id;
592: l_okc_rilv_pk okc_rilv_pk_csr%ROWTYPE;
593: l_rilv_rec rilv_rec_type;
586: LAST_UPDATED_BY,
587: LAST_UPDATE_DATE,
588: LAST_UPDATE_LOGIN
589: FROM Okc_React_Intervals_V
590: WHERE okc_react_intervals_v.tve_id = p_tve_id
591: AND okc_react_intervals_v.rul_id = p_rul_id;
592: l_okc_rilv_pk okc_rilv_pk_csr%ROWTYPE;
593: l_rilv_rec rilv_rec_type;
594: BEGIN
587: LAST_UPDATE_DATE,
588: LAST_UPDATE_LOGIN
589: FROM Okc_React_Intervals_V
590: WHERE okc_react_intervals_v.tve_id = p_tve_id
591: AND okc_react_intervals_v.rul_id = p_rul_id;
592: l_okc_rilv_pk okc_rilv_pk_csr%ROWTYPE;
593: l_rilv_rec rilv_rec_type;
594: BEGIN
595: x_no_data_found := TRUE;
621: RETURN(get_rec(p_rilv_rec, l_row_notfound));
622: END get_rec;
623:
624: -----------------------------------------------------------
625: -- FUNCTION null_out_defaults for: OKC_REACT_INTERVALS_V --
626: -----------------------------------------------------------
627: FUNCTION null_out_defaults (
628: p_rilv_rec IN rilv_rec_type
629: ) RETURN rilv_rec_type IS
667: ---------------------------------------------------------------------------
668: -- PROCEDURE Validate_Attributes
669: ---------------------------------------------------------------------------
670: ---------------------------------------------------
671: -- Validate_Attributes for:OKC_REACT_INTERVALS_V --
672: ---------------------------------------------------
673: /* commenting out nocopy generated code in favor of hand-coded procedure
674: FUNCTION Validate_Attributes (
675: p_rilv_rec IN rilv_rec_type
713: ---------------------------------------------------------------------------
714: -- PROCEDURE Validate_Record
715: ---------------------------------------------------------------------------
716: -----------------------------------------------
717: -- Validate_Record for:OKC_REACT_INTERVALS_V --
718: -----------------------------------------------
719: FUNCTION Validate_Record (
720: p_rilv_rec IN rilv_rec_type
721: ) RETURN VARCHAR2 IS
765: ---------------------------------------------------------------------------
766: -- PROCEDURE validate_row
767: ---------------------------------------------------------------------------
768: --------------------------------------------
769: -- validate_row for:OKC_REACT_INTERVALS_V --
770: --------------------------------------------
771: PROCEDURE validate_row(
772: p_api_version IN NUMBER,
773: p_init_msg_list IN VARCHAR2,
1016: '_PVT'
1017: );
1018: END insert_row;
1019: ------------------------------------------
1020: -- insert_row for:OKC_REACT_INTERVALS_V --
1021: ------------------------------------------
1022: PROCEDURE insert_row(
1023: p_api_version IN NUMBER,
1024: p_init_msg_list IN VARCHAR2,
1050: l_rilv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1051: RETURN(l_rilv_rec);
1052: END fill_who_columns;
1053: ----------------------------------------------
1054: -- Set_Attributes for:OKC_REACT_INTERVALS_V --
1055: ----------------------------------------------
1056: FUNCTION Set_Attributes (
1057: p_rilv_rec IN rilv_rec_type,
1058: x_rilv_rec OUT NOCOPY rilv_rec_type
1336: '_PVT'
1337: );
1338: END lock_row;
1339: ----------------------------------------
1340: -- lock_row for:OKC_REACT_INTERVALS_V --
1341: ----------------------------------------
1342: PROCEDURE lock_row(
1343: p_api_version IN NUMBER,
1344: p_init_msg_list IN VARCHAR2,
1649: '_PVT'
1650: );
1651: END update_row;
1652: ------------------------------------------
1653: -- update_row for:OKC_REACT_INTERVALS_V --
1654: ------------------------------------------
1655: PROCEDURE update_row(
1656: p_api_version IN NUMBER,
1657: p_init_msg_list IN VARCHAR2,
1744: END IF;
1745: RETURN(l_return_status);
1746: END populate_new_record;
1747: ----------------------------------------------
1748: -- Set_Attributes for:OKC_REACT_INTERVALS_V --
1749: ----------------------------------------------
1750: FUNCTION Set_Attributes (
1751: p_rilv_rec IN rilv_rec_type,
1752: x_rilv_rec OUT NOCOPY rilv_rec_type
2008: '_PVT'
2009: );
2010: END delete_row;
2011: ------------------------------------------
2012: -- delete_row for:OKC_REACT_INTERVALS_V --
2013: ------------------------------------------
2014: PROCEDURE delete_row(
2015: p_api_version IN NUMBER,
2016: p_init_msg_list IN VARCHAR2,