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.OKL_IVE_PVT dependencies on OKL_INDEX_VALUES

Line 240: FROM OKL_INDEX_VALUES_V

236: CURSOR ive_csr(v_idx_id NUMBER,
237: v_datetime_valid DATE,
238: v_id NUMBER) IS
239: SELECT '1'
240: FROM OKL_INDEX_VALUES_V
241: WHERE IDX_ID = v_idx_id
242: AND DATETIME_VALID = v_datetime_valid
243: AND ID <> v_id;
244:

Line 311: -- FUNCTION get_rec for: OKL_INDEX_VALUES

307: null;
308: END api_copy;
309:
310: ---------------------------------------------------------------------------
311: -- FUNCTION get_rec for: OKL_INDEX_VALUES
312: ---------------------------------------------------------------------------
313: FUNCTION get_rec (
314: p_ive_rec IN ive_rec_type,
315: x_no_data_found OUT NOCOPY BOOLEAN

Line 317: CURSOR okl_index_values_pk_csr (p_id IN NUMBER) IS

313: FUNCTION get_rec (
314: p_ive_rec IN ive_rec_type,
315: x_no_data_found OUT NOCOPY BOOLEAN
316: ) RETURN ive_rec_type IS
317: CURSOR okl_index_values_pk_csr (p_id IN NUMBER) IS
318: SELECT
319: ID,
320: DATETIME_VALID,
321: IDX_ID,

Line 334: FROM Okl_Index_Values

330: CREATION_DATE,
331: LAST_UPDATED_BY,
332: LAST_UPDATE_DATE,
333: LAST_UPDATE_LOGIN
334: FROM Okl_Index_Values
335: WHERE okl_index_values.id = p_id;
336: l_okl_index_values_pk okl_index_values_pk_csr%ROWTYPE;
337: l_ive_rec ive_rec_type;
338: BEGIN

Line 335: WHERE okl_index_values.id = p_id;

331: LAST_UPDATED_BY,
332: LAST_UPDATE_DATE,
333: LAST_UPDATE_LOGIN
334: FROM Okl_Index_Values
335: WHERE okl_index_values.id = p_id;
336: l_okl_index_values_pk okl_index_values_pk_csr%ROWTYPE;
337: l_ive_rec ive_rec_type;
338: BEGIN
339: x_no_data_found := TRUE;

Line 336: l_okl_index_values_pk okl_index_values_pk_csr%ROWTYPE;

332: LAST_UPDATE_DATE,
333: LAST_UPDATE_LOGIN
334: FROM Okl_Index_Values
335: WHERE okl_index_values.id = p_id;
336: l_okl_index_values_pk okl_index_values_pk_csr%ROWTYPE;
337: l_ive_rec ive_rec_type;
338: BEGIN
339: x_no_data_found := TRUE;
340: -- Get current database values

Line 341: OPEN okl_index_values_pk_csr (p_ive_rec.id);

337: l_ive_rec ive_rec_type;
338: BEGIN
339: x_no_data_found := TRUE;
340: -- Get current database values
341: OPEN okl_index_values_pk_csr (p_ive_rec.id);
342: FETCH okl_index_values_pk_csr INTO
343: l_ive_rec.ID,
344: l_ive_rec.DATETIME_VALID,
345: l_ive_rec.IDX_ID,

Line 342: FETCH okl_index_values_pk_csr INTO

338: BEGIN
339: x_no_data_found := TRUE;
340: -- Get current database values
341: OPEN okl_index_values_pk_csr (p_ive_rec.id);
342: FETCH okl_index_values_pk_csr INTO
343: l_ive_rec.ID,
344: l_ive_rec.DATETIME_VALID,
345: l_ive_rec.IDX_ID,
346: l_ive_rec.VALUE,

Line 358: x_no_data_found := okl_index_values_pk_csr%NOTFOUND;

354: l_ive_rec.CREATION_DATE,
355: l_ive_rec.LAST_UPDATED_BY,
356: l_ive_rec.LAST_UPDATE_DATE,
357: l_ive_rec.LAST_UPDATE_LOGIN;
358: x_no_data_found := okl_index_values_pk_csr%NOTFOUND;
359: CLOSE okl_index_values_pk_csr;
360: RETURN(l_ive_rec);
361: END get_rec;
362:

Line 359: CLOSE okl_index_values_pk_csr;

355: l_ive_rec.LAST_UPDATED_BY,
356: l_ive_rec.LAST_UPDATE_DATE,
357: l_ive_rec.LAST_UPDATE_LOGIN;
358: x_no_data_found := okl_index_values_pk_csr%NOTFOUND;
359: CLOSE okl_index_values_pk_csr;
360: RETURN(l_ive_rec);
361: END get_rec;
362:
363: FUNCTION get_rec (

Line 371: -- FUNCTION get_rec for: OKL_INDEX_VALUES_V

367: BEGIN
368: RETURN(get_rec(p_ive_rec, l_row_notfound));
369: END get_rec;
370: ---------------------------------------------------------------------------
371: -- FUNCTION get_rec for: OKL_INDEX_VALUES_V
372: ---------------------------------------------------------------------------
373: FUNCTION get_rec (
374: p_ivev_rec IN ivev_rec_type,
375: x_no_data_found OUT NOCOPY BOOLEAN

Line 394: FROM Okl_Index_Values_V

390: CREATION_DATE,
391: LAST_UPDATED_BY,
392: LAST_UPDATE_DATE,
393: LAST_UPDATE_LOGIN
394: FROM Okl_Index_Values_V
395: WHERE okl_index_values_v.id = p_id;
396: l_okl_ivev_pk okl_ivev_pk_csr%ROWTYPE;
397: l_ivev_rec ivev_rec_type;
398: BEGIN

Line 395: WHERE okl_index_values_v.id = p_id;

391: LAST_UPDATED_BY,
392: LAST_UPDATE_DATE,
393: LAST_UPDATE_LOGIN
394: FROM Okl_Index_Values_V
395: WHERE okl_index_values_v.id = p_id;
396: l_okl_ivev_pk okl_ivev_pk_csr%ROWTYPE;
397: l_ivev_rec ivev_rec_type;
398: BEGIN
399: x_no_data_found := TRUE;

Line 432: -- FUNCTION null_out_defaults for: OKL_INDEX_VALUES_V --

428: RETURN(get_rec(p_ivev_rec, l_row_notfound));
429: END get_rec;
430:
431: --------------------------------------------------------
432: -- FUNCTION null_out_defaults for: OKL_INDEX_VALUES_V --
433: --------------------------------------------------------
434: FUNCTION null_out_defaults (
435: p_ivev_rec IN ivev_rec_type
436: ) RETURN ivev_rec_type IS

Line 487: -- Validate_Attributes for:OKL_INDEX_VALUES_V --

483: ---------------------------------------------------------------------------
484: -- PROCEDURE Validate_Attributes
485: ---------------------------------------------------------------------------
486: ------------------------------------------------
487: -- Validate_Attributes for:OKL_INDEX_VALUES_V --
488: ------------------------------------------------
489: FUNCTION Validate_Attributes (
490: p_ivev_rec IN ivev_rec_type
491: ) RETURN VARCHAR2 IS

Line 570: -- Validate_Record for:OKL_INDEX_VALUES_V --

566: ---------------------------------------------------------------------------
567: -- PROCEDURE Validate_Record
568: ---------------------------------------------------------------------------
569: --------------------------------------------
570: -- Validate_Record for:OKL_INDEX_VALUES_V --
571: --------------------------------------------
572: FUNCTION Validate_Record (
573: p_ivev_rec IN ivev_rec_type
574: ) RETURN VARCHAR2 IS

Line 636: -- validate_row for:OKL_INDEX_VALUES_V --

632: ---------------------------------------------------------------------------
633: -- PROCEDURE validate_row
634: ---------------------------------------------------------------------------
635: -----------------------------------------
636: -- validate_row for:OKL_INDEX_VALUES_V --
637: -----------------------------------------
638: PROCEDURE validate_row(
639: p_api_version IN NUMBER,
640: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 787: -- insert_row for:OKL_INDEX_VALUES --

783: ---------------------------------------------------------------------------
784: -- PROCEDURE insert_row
785: ---------------------------------------------------------------------------
786: -------------------------------------
787: -- insert_row for:OKL_INDEX_VALUES --
788: -------------------------------------
789: PROCEDURE insert_row(
790: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
791: x_return_status OUT NOCOPY VARCHAR2,

Line 803: -- Set_Attributes for:OKL_INDEX_VALUES --

799: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
800: l_ive_rec ive_rec_type := p_ive_rec;
801: l_def_ive_rec ive_rec_type;
802: -----------------------------------------
803: -- Set_Attributes for:OKL_INDEX_VALUES --
804: -----------------------------------------
805: FUNCTION Set_Attributes (
806: p_ive_rec IN ive_rec_type,
807: x_ive_rec OUT NOCOPY ive_rec_type

Line 835: INSERT INTO OKL_INDEX_VALUES(

831: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
832: RAISE OKC_API.G_EXCEPTION_ERROR;
833: END IF;
834:
835: INSERT INTO OKL_INDEX_VALUES(
836: id,
837: datetime_valid,
838: idx_id,
839: value,

Line 903: -- insert_row for:OKL_INDEX_VALUES_V --

899: '_PVT'
900: );
901: END insert_row;
902: ---------------------------------------
903: -- insert_row for:OKL_INDEX_VALUES_V --
904: ---------------------------------------
905: PROCEDURE insert_row(
906: p_api_version IN NUMBER,
907: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 937: -- Set_Attributes for:OKL_INDEX_VALUES_V --

933: l_ivev_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
934: RETURN(l_ivev_rec);
935: END fill_who_columns;
936: -------------------------------------------
937: -- Set_Attributes for:OKL_INDEX_VALUES_V --
938: -------------------------------------------
939: FUNCTION Set_Attributes (
940: p_ivev_rec IN ivev_rec_type,
941: x_ivev_rec OUT NOCOPY ivev_rec_type

Line 1135: -- lock_row for:OKL_INDEX_VALUES --

1131: ---------------------------------------------------------------------------
1132: -- PROCEDURE lock_row
1133: ---------------------------------------------------------------------------
1134: -----------------------------------
1135: -- lock_row for:OKL_INDEX_VALUES --
1136: -----------------------------------
1137: PROCEDURE lock_row(
1138: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1139: x_return_status OUT NOCOPY VARCHAR2,

Line 1148: FROM OKL_INDEX_VALUES

1144: E_Resource_Busy EXCEPTION;
1145: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1146: CURSOR lock_csr (p_ive_rec IN ive_rec_type) IS
1147: SELECT OBJECT_VERSION_NUMBER
1148: FROM OKL_INDEX_VALUES
1149: WHERE ID = p_ive_rec.id
1150: AND OBJECT_VERSION_NUMBER = p_ive_rec.object_version_number
1151: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1152:

Line 1155: FROM OKL_INDEX_VALUES

1151: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1152:
1153: CURSOR lchk_csr (p_ive_rec IN ive_rec_type) IS
1154: SELECT OBJECT_VERSION_NUMBER
1155: FROM OKL_INDEX_VALUES
1156: WHERE ID = p_ive_rec.id;
1157: l_api_version CONSTANT NUMBER := 1;
1158: l_api_name CONSTANT VARCHAR2(30) := 'VALUES_lock_row';
1159: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1160: l_object_version_number OKL_INDEX_VALUES.OBJECT_VERSION_NUMBER%TYPE;

1156: WHERE ID = p_ive_rec.id;
1157: l_api_version CONSTANT NUMBER := 1;
1158: l_api_name CONSTANT VARCHAR2(30) := 'VALUES_lock_row';
1159: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1160: l_object_version_number OKL_INDEX_VALUES.OBJECT_VERSION_NUMBER%TYPE;
1161: lc_object_version_number OKL_INDEX_VALUES.OBJECT_VERSION_NUMBER%TYPE;
1162: l_row_notfound BOOLEAN := FALSE;
1163: lc_row_notfound BOOLEAN := FALSE;
1164: BEGIN

Line 1161: lc_object_version_number OKL_INDEX_VALUES.OBJECT_VERSION_NUMBER%TYPE;

1157: l_api_version CONSTANT NUMBER := 1;
1158: l_api_name CONSTANT VARCHAR2(30) := 'VALUES_lock_row';
1159: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1160: l_object_version_number OKL_INDEX_VALUES.OBJECT_VERSION_NUMBER%TYPE;
1161: lc_object_version_number OKL_INDEX_VALUES.OBJECT_VERSION_NUMBER%TYPE;
1162: l_row_notfound BOOLEAN := FALSE;
1163: lc_row_notfound BOOLEAN := FALSE;
1164: BEGIN
1165: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1241: -- lock_row for:OKL_INDEX_VALUES_V --

1237: '_PVT'
1238: );
1239: END lock_row;
1240: -------------------------------------
1241: -- lock_row for:OKL_INDEX_VALUES_V --
1242: -------------------------------------
1243: PROCEDURE lock_row(
1244: p_api_version IN NUMBER,
1245: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1396: -- update_row for:OKL_INDEX_VALUES --

1392: ---------------------------------------------------------------------------
1393: -- PROCEDURE update_row
1394: ---------------------------------------------------------------------------
1395: -------------------------------------
1396: -- update_row for:OKL_INDEX_VALUES --
1397: -------------------------------------
1398: PROCEDURE update_row(
1399: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1400: x_return_status OUT NOCOPY VARCHAR2,

Line 1492: -- Set_Attributes for:OKL_INDEX_VALUES --

1488: END IF;
1489: RETURN(l_return_status);
1490: END populate_new_record;
1491: -----------------------------------------
1492: -- Set_Attributes for:OKL_INDEX_VALUES --
1493: -----------------------------------------
1494: FUNCTION Set_Attributes (
1495: p_ive_rec IN ive_rec_type,
1496: x_ive_rec OUT NOCOPY ive_rec_type

Line 1530: UPDATE OKL_INDEX_VALUES

1526: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1527: RAISE OKC_API.G_EXCEPTION_ERROR;
1528: END IF;
1529:
1530: UPDATE OKL_INDEX_VALUES
1531: SET DATETIME_VALID = l_def_ive_rec.datetime_valid,
1532: IDX_ID = l_def_ive_rec.idx_id,
1533: VALUE = l_def_ive_rec.value,
1534: OBJECT_VERSION_NUMBER = l_def_ive_rec.object_version_number,

Line 1582: -- update_row for:OKL_INDEX_VALUES_V --

1578: '_PVT'
1579: );
1580: END update_row;
1581: ---------------------------------------
1582: -- update_row for:OKL_INDEX_VALUES_V --
1583: ---------------------------------------
1584: PROCEDURE update_row(
1585: p_api_version IN NUMBER,
1586: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1693: -- Set_Attributes for:OKL_INDEX_VALUES_V --

1689: END IF;
1690: RETURN(l_return_status);
1691: END populate_new_record;
1692: -------------------------------------------
1693: -- Set_Attributes for:OKL_INDEX_VALUES_V --
1694: -------------------------------------------
1695: FUNCTION Set_Attributes (
1696: p_ivev_rec IN ivev_rec_type,
1697: x_ivev_rec OUT NOCOPY ivev_rec_type

Line 1895: -- delete_row for:OKL_INDEX_VALUES --

1891: ---------------------------------------------------------------------------
1892: -- PROCEDURE delete_row
1893: ---------------------------------------------------------------------------
1894: -------------------------------------
1895: -- delete_row for:OKL_INDEX_VALUES --
1896: -------------------------------------
1897: PROCEDURE delete_row(
1898: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1899: x_return_status OUT NOCOPY VARCHAR2,

Line 1919: DELETE FROM OKL_INDEX_VALUES

1915: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1916: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1917: RAISE OKC_API.G_EXCEPTION_ERROR;
1918: END IF;
1919: DELETE FROM OKL_INDEX_VALUES
1920: WHERE ID = l_ive_rec.id;
1921:
1922: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1923: EXCEPTION

Line 1956: -- delete_row for:OKL_INDEX_VALUES_V --

1952: '_PVT'
1953: );
1954: END delete_row;
1955: ---------------------------------------
1956: -- delete_row for:OKL_INDEX_VALUES_V --
1957: ---------------------------------------
1958: PROCEDURE delete_row(
1959: p_api_version IN NUMBER,
1960: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,