DBA Data[Home] [Help]

APPS.OKC_RIL_PVT dependencies on OKC_REACT_INTERVALS_V

Line 13: G_VIEW CONSTANT VARCHAR2(200) := 'OKC_REACT_INTERVALS_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_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

Line 569: -- FUNCTION get_rec for: OKC_REACT_INTERVALS_V

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

Line 589: FROM Okc_React_Intervals_V

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;

Line 590: WHERE okc_react_intervals_v.tve_id = p_tve_id

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

Line 591: AND okc_react_intervals_v.rul_id = p_rul_id;

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;

Line 625: -- FUNCTION null_out_defaults for: OKC_REACT_INTERVALS_V --

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

Line 671: -- Validate_Attributes for:OKC_REACT_INTERVALS_V --

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

Line 717: -- Validate_Record for:OKC_REACT_INTERVALS_V --

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

Line 769: -- validate_row for:OKC_REACT_INTERVALS_V --

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,

Line 1020: -- insert_row for:OKC_REACT_INTERVALS_V --

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,

Line 1054: -- Set_Attributes for:OKC_REACT_INTERVALS_V --

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

Line 1340: -- lock_row for:OKC_REACT_INTERVALS_V --

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,

Line 1653: -- update_row for:OKC_REACT_INTERVALS_V --

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,

Line 1748: -- Set_Attributes for:OKC_REACT_INTERVALS_V --

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

Line 2012: -- delete_row for:OKC_REACT_INTERVALS_V --

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,