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_ICG_PVT dependencies on OKL_INS_CLASS_CATS

Line 190: p_token2_value => 'OKL_INS_CLASS_CATS',

186: p_msg_name => G_NO_PARENT_RECORD,
187: p_token1 => G_COL_NAME_TOKEN,
188: p_token1_value => 'IAY_ID',
189: p_token2 => g_child_table_token,
190: p_token2_value => 'OKL_INS_CLASS_CATS',
191: p_token3 => g_parent_table_token,
192: p_token3_value => 'OKX_ASST_CATGRS_V');
193:
194: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 259: p_token2_value => 'OKL_INS_CLASS_CATS',

255: p_msg_name => G_NO_PARENT_RECORD,
256: p_token1 => G_COL_NAME_TOKEN,
257: p_token1_value => 'IAC_CODE',
258: p_token2 => g_child_table_token,
259: p_token2_value => 'OKL_INS_CLASS_CATS',
260: p_token3 => g_parent_table_token,
261: p_token3_value => 'FND_LOOKUPS');
262:
263: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 368: -- Function : get_rec (OKL_INS_CLASS_CATS)

364:
365: END validate_icg_date_to;
366: */
367: -----------------------------------------------------------------------------
368: -- Function : get_rec (OKL_INS_CLASS_CATS)
369: -----------------------------------------------------------------------------
370:
371: FUNCTION get_rec (p_icg_rec IN icg_rec_type, x_no_data_found OUT NOCOPY BOOLEAN) RETURN icg_rec_type IS
372:

Line 373: CURSOR okl_ins_class_cats_pk_csr (p_id IN NUMBER) IS

369: -----------------------------------------------------------------------------
370:
371: FUNCTION get_rec (p_icg_rec IN icg_rec_type, x_no_data_found OUT NOCOPY BOOLEAN) RETURN icg_rec_type IS
372:
373: CURSOR okl_ins_class_cats_pk_csr (p_id IN NUMBER) IS
374: SELECT
375: ID,
376: IAC_CODE,
377: IAY_ID,

Line 386: FROM Okl_Ins_Class_Cats

382: CREATION_DATE,
383: LAST_UPDATED_BY,
384: LAST_UPDATE_DATE,
385: LAST_UPDATE_LOGIN
386: FROM Okl_Ins_Class_Cats
387: WHERE okl_ins_class_cats.id = p_id;
388:
389: l_okl_ins_class_cats_pk okl_ins_class_cats_pk_csr%ROWTYPE;
390: l_icg_rec icg_rec_type;

Line 387: WHERE okl_ins_class_cats.id = p_id;

383: LAST_UPDATED_BY,
384: LAST_UPDATE_DATE,
385: LAST_UPDATE_LOGIN
386: FROM Okl_Ins_Class_Cats
387: WHERE okl_ins_class_cats.id = p_id;
388:
389: l_okl_ins_class_cats_pk okl_ins_class_cats_pk_csr%ROWTYPE;
390: l_icg_rec icg_rec_type;
391:

Line 389: l_okl_ins_class_cats_pk okl_ins_class_cats_pk_csr%ROWTYPE;

385: LAST_UPDATE_LOGIN
386: FROM Okl_Ins_Class_Cats
387: WHERE okl_ins_class_cats.id = p_id;
388:
389: l_okl_ins_class_cats_pk okl_ins_class_cats_pk_csr%ROWTYPE;
390: l_icg_rec icg_rec_type;
391:
392: BEGIN
393:

Line 397: OPEN okl_ins_class_cats_pk_csr (p_icg_rec.id);

393:
394: x_no_data_found := TRUE;
395:
396: -- Get current database values
397: OPEN okl_ins_class_cats_pk_csr (p_icg_rec.id);
398: FETCH okl_ins_class_cats_pk_csr INTO
399: l_icg_rec.ID,
400: l_icg_rec.IAC_CODE,
401: l_icg_rec.IAY_ID,

Line 398: FETCH okl_ins_class_cats_pk_csr INTO

394: x_no_data_found := TRUE;
395:
396: -- Get current database values
397: OPEN okl_ins_class_cats_pk_csr (p_icg_rec.id);
398: FETCH okl_ins_class_cats_pk_csr INTO
399: l_icg_rec.ID,
400: l_icg_rec.IAC_CODE,
401: l_icg_rec.IAY_ID,
402: l_icg_rec.OBJECT_VERSION_NUMBER,

Line 411: x_no_data_found := okl_ins_class_cats_pk_csr%NOTFOUND;

407: l_icg_rec.LAST_UPDATED_BY,
408: l_icg_rec.LAST_UPDATE_DATE,
409: l_icg_rec.LAST_UPDATE_LOGIN;
410:
411: x_no_data_found := okl_ins_class_cats_pk_csr%NOTFOUND;
412: CLOSE okl_ins_class_cats_pk_csr;
413: RETURN(l_icg_rec);
414:
415: END get_rec;

Line 412: CLOSE okl_ins_class_cats_pk_csr;

408: l_icg_rec.LAST_UPDATE_DATE,
409: l_icg_rec.LAST_UPDATE_LOGIN;
410:
411: x_no_data_found := okl_ins_class_cats_pk_csr%NOTFOUND;
412: CLOSE okl_ins_class_cats_pk_csr;
413: RETURN(l_icg_rec);
414:
415: END get_rec;
416:

Line 426: -- Function : get_rec (OKL_INS_CLASS_CATS_V)

422: RETURN(get_rec(p_icg_rec, l_row_notfound));
423: END get_rec;
424:
425: -----------------------------------------------------------------------------
426: -- Function : get_rec (OKL_INS_CLASS_CATS_V)
427: -----------------------------------------------------------------------------
428:
429: FUNCTION get_rec (p_icgv_rec IN icgv_rec_type, x_no_data_found OUT NOCOPY BOOLEAN) RETURN icgv_rec_type IS
430:

Line 444: FROM okl_ins_class_cats_v

440: CREATION_DATE,
441: LAST_UPDATED_BY,
442: LAST_UPDATE_DATE,
443: LAST_UPDATE_LOGIN
444: FROM okl_ins_class_cats_v
445: WHERE okl_ins_class_cats_v.id = p_id;
446:
447: l_okl_icgv_pk okl_icgv_pk_csr%ROWTYPE;
448: l_icgv_rec icgv_rec_type;

Line 445: WHERE okl_ins_class_cats_v.id = p_id;

441: LAST_UPDATED_BY,
442: LAST_UPDATE_DATE,
443: LAST_UPDATE_LOGIN
444: FROM okl_ins_class_cats_v
445: WHERE okl_ins_class_cats_v.id = p_id;
446:
447: l_okl_icgv_pk okl_icgv_pk_csr%ROWTYPE;
448: l_icgv_rec icgv_rec_type;
449:

Line 524: -- Function Name : validate_attributes (for OKL_INS_CLASS_CATS_V)

520:
521: END null_out_defaults;
522:
523: -----------------------------------------------------------------------------
524: -- Function Name : validate_attributes (for OKL_INS_CLASS_CATS_V)
525: -- Description :
526: -- Business Rules :
527: -- Parameters : icgv_rec_type
528: -- Current Version : 1.1

Line 591: -- Function Name : validate_record (for OKL_INS_CLASS_CATS_V)

587:
588: END validate_attributes;
589:
590: -----------------------------------------------------------------------------
591: -- Function Name : validate_record (for OKL_INS_CLASS_CATS_V)
592: -- Description :
593: -- Business Rules :
594: -- Parameters : icgv_rec_type
595: -- Current Version : 1.1

Line 613: FROM okl_ins_class_cats

609: l_dummy VARCHAR(1) := '?';
610:
611: CURSOR c_active_rec IS
612: SELECT id, iay_id, date_from, date_to
613: FROM okl_ins_class_cats
614: WHERE id <> (p_icgv_rec.id)
615: AND (iay_id = p_icgv_rec.iay_id AND NVL(TRUNC(date_to) + 1, SYSDATE) >= SYSDATE);
616:
617: CURSOR c_asset_category_csr ( p_category_id NUMBER) IS

Line 683: -- Function : migrate (OKL_INS_CLASS_CATS_V)

679: END validate_record;
680:
681:
682: -----------------------------------------------------------------------------
683: -- Function : migrate (OKL_INS_CLASS_CATS_V)
684: -----------------------------------------------------------------------------
685:
686: PROCEDURE migrate (p_from IN icgv_rec_type, p_to IN OUT NOCOPY icg_rec_type) IS
687:

Line 705: -- Function : migrate (OKL_INS_CLASS_CATS)

701:
702: END migrate;
703:
704: -----------------------------------------------------------------------------
705: -- Function : migrate (OKL_INS_CLASS_CATS)
706: -----------------------------------------------------------------------------
707:
708: PROCEDURE migrate (p_from IN icg_rec_type, p_to IN OUT NOCOPY icgv_rec_type) IS
709:

Line 912: -- PROCEDURE insert_row (OKL_INS_CLASS_CATS)

908:
909: END validate_row;
910:
911: -----------------------------------------------------------------------------
912: -- PROCEDURE insert_row (OKL_INS_CLASS_CATS)
913: -----------------------------------------------------------------------------
914:
915: PROCEDURE insert_row(
916: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 930: -- Set_Attributes for:OKL_INS_CLASS_CATS --

926: l_icg_rec icg_rec_type := p_icg_rec;
927: l_def_icg_rec icg_rec_type;
928:
929: -------------------------------------------
930: -- Set_Attributes for:OKL_INS_CLASS_CATS --
931: -------------------------------------------
932: FUNCTION Set_Attributes (p_icg_rec IN icg_rec_type, x_icg_rec OUT NOCOPY icg_rec_type) RETURN VARCHAR2 IS
933: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
934: BEGIN

Line 963: INSERT INTO OKL_INS_CLASS_CATS(

959: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
960: RAISE OKC_API.G_EXCEPTION_ERROR;
961: END IF;
962:
963: INSERT INTO OKL_INS_CLASS_CATS(
964: id,
965: iac_code,
966: iay_id,
967: object_version_number,

Line 1030: -- PROCEDURE insert_row (OKL_INS_CLASS_CATS_V)

1026:
1027: END insert_row;
1028:
1029: -----------------------------------------------------------------------------
1030: -- PROCEDURE insert_row (OKL_INS_CLASS_CATS_V)
1031: -----------------------------------------------------------------------------
1032:
1033: PROCEDURE insert_row(
1034: p_api_version IN NUMBER,

Line 1067: -- Set_Attributes for:OKL_INS_CLASS_CATS_V --

1063: RETURN(l_icgv_rec);
1064:
1065: END fill_who_columns;
1066: ---------------------------------------------
1067: -- Set_Attributes for:OKL_INS_CLASS_CATS_V --
1068: ---------------------------------------------
1069: FUNCTION Set_Attributes (p_icgv_rec IN icgv_rec_type,
1070: x_icgv_rec OUT NOCOPY icgv_rec_type) RETURN VARCHAR2 IS
1071:

Line 1263: -- PROCEDURE lock_row (OKL_INS_CLASS_CATS)

1259: );
1260: END insert_row;
1261:
1262: -----------------------------------------------------------------------------
1263: -- PROCEDURE lock_row (OKL_INS_CLASS_CATS)
1264: -----------------------------------------------------------------------------
1265:
1266: PROCEDURE lock_row(
1267: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1277: FROM OKL_INS_CLASS_CATS

1273: E_Resource_Busy EXCEPTION;
1274: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1275: CURSOR lock_csr (p_icg_rec IN icg_rec_type) IS
1276: SELECT OBJECT_VERSION_NUMBER
1277: FROM OKL_INS_CLASS_CATS
1278: WHERE ID = p_icg_rec.id
1279: AND OBJECT_VERSION_NUMBER = p_icg_rec.object_version_number
1280: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1281:

Line 1284: FROM OKL_INS_CLASS_CATS

1280: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1281:
1282: CURSOR lchk_csr (p_icg_rec IN icg_rec_type) IS
1283: SELECT OBJECT_VERSION_NUMBER
1284: FROM OKL_INS_CLASS_CATS
1285: WHERE ID = p_icg_rec.id;
1286: l_api_version CONSTANT NUMBER := 1;
1287: l_api_name CONSTANT VARCHAR2(30) := 'CATS_lock_row';
1288: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1289: l_object_version_number OKL_INS_CLASS_CATS.OBJECT_VERSION_NUMBER%TYPE;

1285: WHERE ID = p_icg_rec.id;
1286: l_api_version CONSTANT NUMBER := 1;
1287: l_api_name CONSTANT VARCHAR2(30) := 'CATS_lock_row';
1288: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1289: l_object_version_number OKL_INS_CLASS_CATS.OBJECT_VERSION_NUMBER%TYPE;
1290: lc_object_version_number OKL_INS_CLASS_CATS.OBJECT_VERSION_NUMBER%TYPE;
1291: l_row_notfound BOOLEAN := FALSE;
1292: lc_row_notfound BOOLEAN := FALSE;
1293: BEGIN

Line 1290: lc_object_version_number OKL_INS_CLASS_CATS.OBJECT_VERSION_NUMBER%TYPE;

1286: l_api_version CONSTANT NUMBER := 1;
1287: l_api_name CONSTANT VARCHAR2(30) := 'CATS_lock_row';
1288: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1289: l_object_version_number OKL_INS_CLASS_CATS.OBJECT_VERSION_NUMBER%TYPE;
1290: lc_object_version_number OKL_INS_CLASS_CATS.OBJECT_VERSION_NUMBER%TYPE;
1291: l_row_notfound BOOLEAN := FALSE;
1292: lc_row_notfound BOOLEAN := FALSE;
1293: BEGIN
1294: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1370: -- lock_row for:OKL_INS_CLASS_CATS_V --

1366: '_PVT'
1367: );
1368: END lock_row;
1369: ---------------------------------------
1370: -- lock_row for:OKL_INS_CLASS_CATS_V --
1371: ---------------------------------------
1372: PROCEDURE lock_row(
1373: p_api_version IN NUMBER,
1374: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1515: -- PROCEDURE update_row (OKL_INS_CLASS_CATS)

1511: );
1512: END lock_row;
1513:
1514: -----------------------------------------------------------------------------
1515: -- PROCEDURE update_row (OKL_INS_CLASS_CATS)
1516: -----------------------------------------------------------------------------
1517:
1518: PROCEDURE update_row(
1519: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1596: -- Set_Attributes for:OKL_INS_CLASS_CATS --

1592: END IF;
1593: RETURN(l_return_status);
1594: END populate_new_record;
1595: -------------------------------------------
1596: -- Set_Attributes for:OKL_INS_CLASS_CATS --
1597: -------------------------------------------
1598: FUNCTION Set_Attributes (
1599: p_icg_rec IN icg_rec_type,
1600: x_icg_rec OUT NOCOPY icg_rec_type

Line 1633: UPDATE OKL_INS_CLASS_CATS

1629: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1630: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1631: RAISE OKC_API.G_EXCEPTION_ERROR;
1632: END IF;
1633: UPDATE OKL_INS_CLASS_CATS
1634: SET IAC_CODE = l_def_icg_rec.iac_code,
1635: IAY_ID = l_def_icg_rec.iay_id,
1636: OBJECT_VERSION_NUMBER = l_def_icg_rec.object_version_number,
1637: DATE_FROM = l_def_icg_rec.date_from,

Line 1682: -- PROCEDURE update_row (OKL_INS_CLASS_CATS_V)

1678: );
1679: END update_row;
1680:
1681: -----------------------------------------------------------------------------
1682: -- PROCEDURE update_row (OKL_INS_CLASS_CATS_V)
1683: -----------------------------------------------------------------------------
1684:
1685: PROCEDURE update_row(
1686: p_api_version IN NUMBER,

Line 1778: -- Set_Attributes for:OKL_INS_CLASS_CATS_V --

1774: END IF;
1775: RETURN(l_return_status);
1776: END populate_new_record;
1777: ---------------------------------------------
1778: -- Set_Attributes for:OKL_INS_CLASS_CATS_V --
1779: ---------------------------------------------
1780: FUNCTION Set_Attributes (
1781: p_icgv_rec IN icgv_rec_type,
1782: x_icgv_rec OUT NOCOPY icgv_rec_type

Line 1976: -- delete_row for:OKL_INS_CLASS_CATS --

1972: ---------------------------------------------------------------------------
1973: -- PROCEDURE delete_row
1974: ---------------------------------------------------------------------------
1975: ---------------------------------------
1976: -- delete_row for:OKL_INS_CLASS_CATS --
1977: ---------------------------------------
1978: PROCEDURE delete_row(
1979: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1980: x_return_status OUT NOCOPY VARCHAR2,

Line 2000: DELETE FROM OKL_INS_CLASS_CATS

1996: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1997: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1998: RAISE OKC_API.G_EXCEPTION_ERROR;
1999: END IF;
2000: DELETE FROM OKL_INS_CLASS_CATS
2001: WHERE ID = l_icg_rec.id;
2002:
2003: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2004: EXCEPTION

Line 2037: -- delete_row for:OKL_INS_CLASS_CATS_V --

2033: '_PVT'
2034: );
2035: END delete_row;
2036: -----------------------------------------
2037: -- delete_row for:OKL_INS_CLASS_CATS_V --
2038: -----------------------------------------
2039: PROCEDURE delete_row(
2040: p_api_version IN NUMBER,
2041: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,