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_KLE_PVT dependencies on OKL_K_LINES_V

Line 12: G_VIEW CONSTANT VARCHAR2(200) := 'OKL_K_LINES_V';

8:
9:
10: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
11: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
12: G_VIEW CONSTANT VARCHAR2(200) := 'OKL_K_LINES_V';
13:
14: G_EXCEPTION_HALT_VALIDATION exception;
15:
16:

Line 574: -- Validate_Attributes for: OKL_K_LINES_V --

570: ,p_token2_value => SQLERRM);
571: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
572: end validate_subsidy_id;
573: ---------------------------------------------
574: -- Validate_Attributes for: OKL_K_LINES_V --
575: ---------------------------------------------
576: FUNCTION Validate_Attributes (
577: p_klev_rec IN klev_rec_type
578: ) RETURN VARCHAR2 IS

Line 1438: -- FUNCTION get_rec for: OKL_K_LINES_V

1434: END get_rec;
1435:
1436:
1437: ---------------------------------------------------------------------------
1438: -- FUNCTION get_rec for: OKL_K_LINES_V
1439: ---------------------------------------------------------------------------
1440: FUNCTION get_rec (
1441: p_klev_rec IN klev_rec_type,
1442: x_no_data_found OUT NOCOPY BOOLEAN

Line 1444: CURSOR okl_k_lines_v_pk_csr (p_id IN NUMBER) IS

1440: FUNCTION get_rec (
1441: p_klev_rec IN klev_rec_type,
1442: x_no_data_found OUT NOCOPY BOOLEAN
1443: ) RETURN klev_rec_type IS
1444: CURSOR okl_k_lines_v_pk_csr (p_id IN NUMBER) IS
1445: SELECT
1446: ID,
1447: OBJECT_VERSION_NUMBER,
1448: KLE_ID,

Line 1593: FROM OKL_K_LINES_V

1589: --Bug# 16344245
1590: AMOUNT_BALANCE_LEGACY,
1591: DT_EFFECTIVE_BALANCE_LEGACY
1592:
1593: FROM OKL_K_LINES_V
1594: WHERE OKL_K_LINES_V.id = p_id;
1595: l_okl_k_lines_v_pk okl_k_lines_v_pk_csr%ROWTYPE;
1596: l_klev_rec klev_rec_type;
1597: BEGIN

Line 1594: WHERE OKL_K_LINES_V.id = p_id;

1590: AMOUNT_BALANCE_LEGACY,
1591: DT_EFFECTIVE_BALANCE_LEGACY
1592:
1593: FROM OKL_K_LINES_V
1594: WHERE OKL_K_LINES_V.id = p_id;
1595: l_okl_k_lines_v_pk okl_k_lines_v_pk_csr%ROWTYPE;
1596: l_klev_rec klev_rec_type;
1597: BEGIN
1598:

Line 1595: l_okl_k_lines_v_pk okl_k_lines_v_pk_csr%ROWTYPE;

1591: DT_EFFECTIVE_BALANCE_LEGACY
1592:
1593: FROM OKL_K_LINES_V
1594: WHERE OKL_K_LINES_V.id = p_id;
1595: l_okl_k_lines_v_pk okl_k_lines_v_pk_csr%ROWTYPE;
1596: l_klev_rec klev_rec_type;
1597: BEGIN
1598:
1599: x_no_data_found := TRUE;

Line 1601: OPEN okl_k_lines_v_pk_csr (p_klev_rec.id);

1597: BEGIN
1598:
1599: x_no_data_found := TRUE;
1600: -- Get current database values
1601: OPEN okl_k_lines_v_pk_csr (p_klev_rec.id);
1602: FETCH okl_k_lines_v_pk_csr INTO
1603: l_klev_rec.ID,
1604: l_klev_rec.OBJECT_VERSION_NUMBER,
1605: l_klev_rec.KLE_ID,

Line 1602: FETCH okl_k_lines_v_pk_csr INTO

1598:
1599: x_no_data_found := TRUE;
1600: -- Get current database values
1601: OPEN okl_k_lines_v_pk_csr (p_klev_rec.id);
1602: FETCH okl_k_lines_v_pk_csr INTO
1603: l_klev_rec.ID,
1604: l_klev_rec.OBJECT_VERSION_NUMBER,
1605: l_klev_rec.KLE_ID,
1606: l_klev_rec.STY_ID,

Line 1750: x_no_data_found := okl_k_lines_v_pk_csr%NOTFOUND;

1746: l_klev_rec.AMOUNT_BALANCE_LEGACY,
1747: l_klev_rec.DT_EFFECTIVE_BALANCE_LEGACY
1748:
1749: ;
1750: x_no_data_found := okl_k_lines_v_pk_csr%NOTFOUND;
1751: CLOSE okl_k_lines_v_pk_csr;
1752: RETURN(l_klev_rec);
1753: END get_rec;
1754:

Line 1751: CLOSE okl_k_lines_v_pk_csr;

1747: l_klev_rec.DT_EFFECTIVE_BALANCE_LEGACY
1748:
1749: ;
1750: x_no_data_found := okl_k_lines_v_pk_csr%NOTFOUND;
1751: CLOSE okl_k_lines_v_pk_csr;
1752: RETURN(l_klev_rec);
1753: END get_rec;
1754:
1755: FUNCTION get_rec (

Line 1765: -- FUNCTION null_out_defaults for: OKL_K_LINES_V --

1761: END get_rec;
1762:
1763:
1764: -----------------------------------------------------
1765: -- FUNCTION null_out_defaults for: OKL_K_LINES_V --
1766: -----------------------------------------------------
1767: FUNCTION null_out_defaults (
1768: p_klev_rec IN klev_rec_type
1769: ) RETURN klev_rec_type IS

Line 2302: -- Validate_Record for: OKL_K_LINES_V --

2298: ---------------------------------------------------------------------------
2299:
2300:
2301: -----------------------------------------
2302: -- Validate_Record for: OKL_K_LINES_V --
2303: -----------------------------------------
2304: FUNCTION Validate_Record (
2305: p_klev_rec IN klev_rec_type
2306: ) RETURN VARCHAR2 IS

Line 3074: -- validate_row for: OKL_K_LINES_V --

3070: -- PROCEDURE validate_row
3071: ---------------------------------------------------------------------------
3072:
3073: --------------------------------------
3074: -- validate_row for: OKL_K_LINES_V --
3075: --------------------------------------
3076:
3077: PROCEDURE validate_row(
3078:

Line 3162: -- PL/SQL TBL validate_row for: OKL_K_LINES_V --

3158: );
3159:
3160: END validate_row;
3161: ------------------------------------------
3162: -- PL/SQL TBL validate_row for: OKL_K_LINES_V --
3163: ------------------------------------------
3164:
3165: PROCEDURE validate_row(
3166:

Line 4024: -- insert_row for: OKL_K_LINES_V --

4020:
4021: END insert_row;
4022:
4023: ------------------------------------
4024: -- insert_row for: OKL_K_LINES_V --
4025: ------------------------------------
4026:
4027: PROCEDURE insert_row(
4028:

Line 4060: -- Set_Attributes for: OKL_K_LINES_V --

4056: l_klev_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
4057: RETURN(l_klev_rec);
4058: END fill_who_columns;
4059: ----------------------------------------
4060: -- Set_Attributes for: OKL_K_LINES_V --
4061: ----------------------------------------
4062: FUNCTION Set_Attributes (
4063: p_klev_rec IN klev_rec_type,
4064: x_klev_rec OUT NOCOPY klev_rec_type

Line 4189: -- PL/SQL TBL insert_row for: OKL_K_LINES_V --

4185:
4186: END insert_row;
4187:
4188: ----------------------------------------
4189: -- PL/SQL TBL insert_row for: OKL_K_LINES_V --
4190: ----------------------------------------
4191:
4192: PROCEDURE insert_row(
4193:

Line 4379: -- lock_row for: OKL_K_LINES_V --

4375:
4376: END lock_row;
4377:
4378: ----------------------------------
4379: -- lock_row for: OKL_K_LINES_V --
4380: ----------------------------------
4381:
4382: PROCEDURE lock_row(
4383:

Line 4468: -- PL/SQL TBL lock_row for: OKL_K_LINES_V --

4464: );
4465:
4466: END lock_row;
4467: --------------------------------------
4468: -- PL/SQL TBL lock_row for: OKL_K_LINES_V --
4469: --------------------------------------
4470:
4471: PROCEDURE lock_row(
4472:

Line 5365: -- update_row for: OKL_K_LINES_V --

5361:
5362: END update_row;
5363:
5364: ------------------------------------
5365: -- update_row for: OKL_K_LINES_V --
5366: ------------------------------------
5367:
5368: PROCEDURE update_row(
5369:

Line 5938: -- Set_Attributes for: OKL_K_LINES_V --

5934:
5935: RETURN(l_return_status);
5936: END populate_new_record;
5937: ----------------------------------------
5938: -- Set_Attributes for: OKL_K_LINES_V --
5939: ----------------------------------------
5940: FUNCTION Set_Attributes (
5941: p_klev_rec IN klev_rec_type,
5942: x_klev_rec OUT NOCOPY klev_rec_type

Line 6066: -- PL/SQL TBL update_row for: OKL_K_LINES_V --

6062: );
6063:
6064: END update_row;
6065: ----------------------------------------
6066: -- PL/SQL TBL update_row for: OKL_K_LINES_V --
6067: ----------------------------------------
6068:
6069: PROCEDURE update_row(
6070:

Line 6323: -- PL/SQL TBL delete_row for: OKL_K_LINES_V --

6319: );
6320:
6321: END delete_row;
6322: ----------------------------------------
6323: -- PL/SQL TBL delete_row for: OKL_K_LINES_V --
6324: ----------------------------------------
6325:
6326: PROCEDURE delete_row(
6327: