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_RIL_PVT dependencies on OKC_REACT_INTERVALS

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 514: -- FUNCTION get_rec for: OKC_REACT_INTERVALS

510: null;
511: END api_copy;
512:
513: ---------------------------------------------------------------------------
514: -- FUNCTION get_rec for: OKC_REACT_INTERVALS
515: ---------------------------------------------------------------------------
516: FUNCTION get_rec (
517: p_ril_rec IN ril_rec_type,
518: x_no_data_found OUT NOCOPY BOOLEAN

Line 534: FROM Okc_React_Intervals

530: CREATION_DATE,
531: LAST_UPDATED_BY,
532: LAST_UPDATE_DATE,
533: LAST_UPDATE_LOGIN
534: FROM Okc_React_Intervals
535: WHERE okc_react_intervals.tve_id = p_tve_id
536: AND okc_react_intervals.rul_id = p_rul_id;
537: l_ril_pk ril_pk_csr%ROWTYPE;
538: l_ril_rec ril_rec_type;

Line 535: WHERE okc_react_intervals.tve_id = p_tve_id

531: LAST_UPDATED_BY,
532: LAST_UPDATE_DATE,
533: LAST_UPDATE_LOGIN
534: FROM Okc_React_Intervals
535: WHERE okc_react_intervals.tve_id = p_tve_id
536: AND okc_react_intervals.rul_id = p_rul_id;
537: l_ril_pk ril_pk_csr%ROWTYPE;
538: l_ril_rec ril_rec_type;
539: BEGIN

Line 536: AND okc_react_intervals.rul_id = p_rul_id;

532: LAST_UPDATE_DATE,
533: LAST_UPDATE_LOGIN
534: FROM Okc_React_Intervals
535: WHERE okc_react_intervals.tve_id = p_tve_id
536: AND okc_react_intervals.rul_id = p_rul_id;
537: l_ril_pk ril_pk_csr%ROWTYPE;
538: l_ril_rec ril_rec_type;
539: BEGIN
540: x_no_data_found := TRUE;

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 913: -- insert_row for:OKC_REACT_INTERVALS --

909: ---------------------------------------------------------------------------
910: -- PROCEDURE insert_row
911: ---------------------------------------------------------------------------
912: ----------------------------------------
913: -- insert_row for:OKC_REACT_INTERVALS --
914: ----------------------------------------
915: PROCEDURE insert_row(
916: p_init_msg_list IN VARCHAR2,
917: x_return_status OUT NOCOPY VARCHAR2,

Line 929: -- Set_Attributes for:OKC_REACT_INTERVALS --

925: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
926: l_ril_rec ril_rec_type := p_ril_rec;
927: l_def_ril_rec ril_rec_type;
928: --------------------------------------------
929: -- Set_Attributes for:OKC_REACT_INTERVALS --
930: --------------------------------------------
931: FUNCTION Set_Attributes (
932: p_ril_rec IN ril_rec_type,
933: x_ril_rec OUT NOCOPY ril_rec_type

Line 960: INSERT INTO OKC_REACT_INTERVALS(

956: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
957: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
958: RAISE OKC_API.G_EXCEPTION_ERROR;
959: END IF;
960: INSERT INTO OKC_REACT_INTERVALS(
961: tve_id,
962: rul_id,
963: dnz_chr_id,
964: uom_code,

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 1232: -- lock_row for:OKC_REACT_INTERVALS --

1228: ---------------------------------------------------------------------------
1229: -- PROCEDURE lock_row
1230: ---------------------------------------------------------------------------
1231: --------------------------------------
1232: -- lock_row for:OKC_REACT_INTERVALS --
1233: --------------------------------------
1234: PROCEDURE lock_row(
1235: p_init_msg_list IN VARCHAR2,
1236: x_return_status OUT NOCOPY VARCHAR2,

Line 1245: FROM OKC_REACT_INTERVALS

1241: E_Resource_Busy EXCEPTION;
1242: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1243: CURSOR lock_csr (p_ril_rec IN ril_rec_type) IS
1244: SELECT OBJECT_VERSION_NUMBER
1245: FROM OKC_REACT_INTERVALS
1246: WHERE TVE_ID = p_ril_rec.tve_id
1247: AND RUL_ID = p_ril_rec.rul_id
1248: AND OBJECT_VERSION_NUMBER = p_ril_rec.object_version_number
1249: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line 1253: FROM OKC_REACT_INTERVALS

1249: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1250:
1251: CURSOR lchk_csr (p_ril_rec IN ril_rec_type) IS
1252: SELECT OBJECT_VERSION_NUMBER
1253: FROM OKC_REACT_INTERVALS
1254: WHERE TVE_ID = p_ril_rec.tve_id
1255: AND RUL_ID = p_ril_rec.rul_id;
1256: l_api_version CONSTANT NUMBER := 1;
1257: l_api_name CONSTANT VARCHAR2(30) := 'INTERVALS_lock_row';

Line 1259: l_object_version_number OKC_REACT_INTERVALS.OBJECT_VERSION_NUMBER%TYPE;

1255: AND RUL_ID = p_ril_rec.rul_id;
1256: l_api_version CONSTANT NUMBER := 1;
1257: l_api_name CONSTANT VARCHAR2(30) := 'INTERVALS_lock_row';
1258: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1259: l_object_version_number OKC_REACT_INTERVALS.OBJECT_VERSION_NUMBER%TYPE;
1260: lc_object_version_number OKC_REACT_INTERVALS.OBJECT_VERSION_NUMBER%TYPE;
1261: l_row_notfound BOOLEAN := FALSE;
1262: lc_row_notfound BOOLEAN := FALSE;
1263: BEGIN

Line 1260: lc_object_version_number OKC_REACT_INTERVALS.OBJECT_VERSION_NUMBER%TYPE;

1256: l_api_version CONSTANT NUMBER := 1;
1257: l_api_name CONSTANT VARCHAR2(30) := 'INTERVALS_lock_row';
1258: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1259: l_object_version_number OKC_REACT_INTERVALS.OBJECT_VERSION_NUMBER%TYPE;
1260: lc_object_version_number OKC_REACT_INTERVALS.OBJECT_VERSION_NUMBER%TYPE;
1261: l_row_notfound BOOLEAN := FALSE;
1262: lc_row_notfound BOOLEAN := FALSE;
1263: BEGIN
1264: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

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 1488: -- update_row for:OKC_REACT_INTERVALS --

1484: ---------------------------------------------------------------------------
1485: -- PROCEDURE update_row
1486: ---------------------------------------------------------------------------
1487: ----------------------------------------
1488: -- update_row for:OKC_REACT_INTERVALS --
1489: ----------------------------------------
1490: PROCEDURE update_row(
1491: p_init_msg_list IN VARCHAR2,
1492: x_return_status OUT NOCOPY VARCHAR2,

Line 1568: -- Set_Attributes for:OKC_REACT_INTERVALS --

1564: END IF;
1565: RETURN(l_return_status);
1566: END populate_new_record;
1567: --------------------------------------------
1568: -- Set_Attributes for:OKC_REACT_INTERVALS --
1569: --------------------------------------------
1570: FUNCTION Set_Attributes (
1571: p_ril_rec IN ril_rec_type,
1572: x_ril_rec OUT NOCOPY ril_rec_type

Line 1605: UPDATE OKC_REACT_INTERVALS

1601: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1602: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1603: RAISE OKC_API.G_EXCEPTION_ERROR;
1604: END IF;
1605: UPDATE OKC_REACT_INTERVALS
1606: SET DNZ_CHR_ID = l_def_ril_rec.dnz_chr_id,
1607: uom_code = l_def_ril_rec.uom_code,
1608: DURATION = l_def_ril_rec.duration,
1609: OBJECT_VERSION_NUMBER = l_def_ril_rec.object_version_number,

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 1931: -- delete_row for:OKC_REACT_INTERVALS --

1927: ---------------------------------------------------------------------------
1928: -- PROCEDURE delete_row
1929: ---------------------------------------------------------------------------
1930: ----------------------------------------
1931: -- delete_row for:OKC_REACT_INTERVALS --
1932: ----------------------------------------
1933: PROCEDURE delete_row(
1934: p_init_msg_list IN VARCHAR2,
1935: x_return_status OUT NOCOPY VARCHAR2,

Line 1975: DELETE FROM OKC_REACT_INTERVALS

1971: END IF;
1972:
1973:
1974: -- delete reaction times
1975: DELETE FROM OKC_REACT_INTERVALS
1976: WHERE TVE_ID = l_ril_rec.tve_id AND RUL_ID = l_ril_rec.rul_id;
1977:
1978: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1979: EXCEPTION

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,

Line 2158: -- Procedure for mass insert in OKC_REACT_INTERVALS _B and TL tables

2154: );
2155: END delete_row;
2156:
2157: ---------------------------------------------------------------
2158: -- Procedure for mass insert in OKC_REACT_INTERVALS _B and TL tables
2159: ---------------------------------------------------------------
2160: PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2,p_rilv_tbl rilv_tbl_type) IS
2161: l_tabsize NUMBER := p_rilv_tbl.COUNT;
2162: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;

Line 2199: INTO OKC_REACT_INTERVALS

2195: END LOOP;
2196:
2197: FORALL i in 1..l_tabsize
2198: INSERT
2199: INTO OKC_REACT_INTERVALS
2200: (
2201: tve_id,
2202: rul_id,
2203: dnz_chr_id,

Line 2258: INSERT INTO okc_react_intervals_h

2254:
2255: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
2256:
2257: BEGIN
2258: INSERT INTO okc_react_intervals_h
2259: (
2260: major_version,
2261: tve_id,
2262: rul_id,

Line 2286: FROM okc_react_intervals

2282: creation_date,
2283: last_updated_by,
2284: last_update_date,
2285: last_update_login
2286: FROM okc_react_intervals
2287: WHERE dnz_chr_id = p_chr_id;
2288:
2289: RETURN l_return_status;
2290: EXCEPTION

Line 2318: INSERT INTO okc_react_intervals

2314:
2315: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
2316:
2317: BEGIN
2318: INSERT INTO okc_react_intervals
2319: (
2320: tve_id,
2321: rul_id,
2322: dnz_chr_id,

Line 2344: FROM okc_react_intervals_h

2340: creation_date,
2341: last_updated_by,
2342: last_update_date,
2343: last_update_login
2344: FROM okc_react_intervals_h
2345: WHERE dnz_chr_id = p_chr_id
2346: AND major_version = p_major_version;
2347:
2348: RETURN l_return_status;