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 526: -- Validate_Attributes for: OKL_K_LINES_V --

522: ,p_token2_value => SQLERRM);
523: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
524: end validate_subsidy_id;
525: ---------------------------------------------
526: -- Validate_Attributes for: OKL_K_LINES_V --
527: ---------------------------------------------
528: FUNCTION Validate_Attributes (
529: p_klev_rec IN klev_rec_type
530: ) RETURN VARCHAR2 IS

Line 1355: -- FUNCTION get_rec for: OKL_K_LINES_V

1351: END get_rec;
1352:
1353:
1354: ---------------------------------------------------------------------------
1355: -- FUNCTION get_rec for: OKL_K_LINES_V
1356: ---------------------------------------------------------------------------
1357: FUNCTION get_rec (
1358: p_klev_rec IN klev_rec_type,
1359: x_no_data_found OUT NOCOPY BOOLEAN

Line 1361: CURSOR okl_k_lines_v_pk_csr (p_id IN NUMBER) IS

1357: FUNCTION get_rec (
1358: p_klev_rec IN klev_rec_type,
1359: x_no_data_found OUT NOCOPY BOOLEAN
1360: ) RETURN klev_rec_type IS
1361: CURSOR okl_k_lines_v_pk_csr (p_id IN NUMBER) IS
1362: SELECT
1363: ID,
1364: OBJECT_VERSION_NUMBER,
1365: KLE_ID,

Line 1504: FROM OKL_K_LINES_V

1500: --Bug# 4631549
1501: EXPECTED_ASSET_COST
1502:
1503:
1504: FROM OKL_K_LINES_V
1505: WHERE OKL_K_LINES_V.id = p_id;
1506: l_okl_k_lines_v_pk okl_k_lines_v_pk_csr%ROWTYPE;
1507: l_klev_rec klev_rec_type;
1508: BEGIN

Line 1505: WHERE OKL_K_LINES_V.id = p_id;

1501: EXPECTED_ASSET_COST
1502:
1503:
1504: FROM OKL_K_LINES_V
1505: WHERE OKL_K_LINES_V.id = p_id;
1506: l_okl_k_lines_v_pk okl_k_lines_v_pk_csr%ROWTYPE;
1507: l_klev_rec klev_rec_type;
1508: BEGIN
1509:

Line 1506: l_okl_k_lines_v_pk okl_k_lines_v_pk_csr%ROWTYPE;

1502:
1503:
1504: FROM OKL_K_LINES_V
1505: WHERE OKL_K_LINES_V.id = p_id;
1506: l_okl_k_lines_v_pk okl_k_lines_v_pk_csr%ROWTYPE;
1507: l_klev_rec klev_rec_type;
1508: BEGIN
1509:
1510: x_no_data_found := TRUE;

Line 1512: OPEN okl_k_lines_v_pk_csr (p_klev_rec.id);

1508: BEGIN
1509:
1510: x_no_data_found := TRUE;
1511: -- Get current database values
1512: OPEN okl_k_lines_v_pk_csr (p_klev_rec.id);
1513: FETCH okl_k_lines_v_pk_csr INTO
1514: l_klev_rec.ID,
1515: l_klev_rec.OBJECT_VERSION_NUMBER,
1516: l_klev_rec.KLE_ID,

Line 1513: FETCH okl_k_lines_v_pk_csr INTO

1509:
1510: x_no_data_found := TRUE;
1511: -- Get current database values
1512: OPEN okl_k_lines_v_pk_csr (p_klev_rec.id);
1513: FETCH okl_k_lines_v_pk_csr INTO
1514: l_klev_rec.ID,
1515: l_klev_rec.OBJECT_VERSION_NUMBER,
1516: l_klev_rec.KLE_ID,
1517: l_klev_rec.STY_ID,

Line 1654: x_no_data_found := okl_k_lines_v_pk_csr%NOTFOUND;

1650: l_klev_rec.TERMINATION_VALUE,
1651: --Bug# 4631549
1652: l_klev_rec.EXPECTED_ASSET_COST
1653: ;
1654: x_no_data_found := okl_k_lines_v_pk_csr%NOTFOUND;
1655: CLOSE okl_k_lines_v_pk_csr;
1656: RETURN(l_klev_rec);
1657: END get_rec;
1658:

Line 1655: CLOSE okl_k_lines_v_pk_csr;

1651: --Bug# 4631549
1652: l_klev_rec.EXPECTED_ASSET_COST
1653: ;
1654: x_no_data_found := okl_k_lines_v_pk_csr%NOTFOUND;
1655: CLOSE okl_k_lines_v_pk_csr;
1656: RETURN(l_klev_rec);
1657: END get_rec;
1658:
1659: FUNCTION get_rec (

Line 1669: -- FUNCTION null_out_defaults for: OKL_K_LINES_V --

1665: END get_rec;
1666:
1667:
1668: -----------------------------------------------------
1669: -- FUNCTION null_out_defaults for: OKL_K_LINES_V --
1670: -----------------------------------------------------
1671: FUNCTION null_out_defaults (
1672: p_klev_rec IN klev_rec_type
1673: ) RETURN klev_rec_type IS

Line 2187: -- Validate_Record for: OKL_K_LINES_V --

2183: ---------------------------------------------------------------------------
2184:
2185:
2186: -----------------------------------------
2187: -- Validate_Record for: OKL_K_LINES_V --
2188: -----------------------------------------
2189: FUNCTION Validate_Record (
2190: p_klev_rec IN klev_rec_type
2191: ) RETURN VARCHAR2 IS

Line 2941: -- validate_row for: OKL_K_LINES_V --

2937: -- PROCEDURE validate_row
2938: ---------------------------------------------------------------------------
2939:
2940: --------------------------------------
2941: -- validate_row for: OKL_K_LINES_V --
2942: --------------------------------------
2943:
2944: PROCEDURE validate_row(
2945:

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

3025: );
3026:
3027: END validate_row;
3028: ------------------------------------------
3029: -- PL/SQL TBL validate_row for: OKL_K_LINES_V --
3030: ------------------------------------------
3031:
3032: PROCEDURE validate_row(
3033:

Line 3860: -- insert_row for: OKL_K_LINES_V --

3856:
3857: END insert_row;
3858:
3859: ------------------------------------
3860: -- insert_row for: OKL_K_LINES_V --
3861: ------------------------------------
3862:
3863: PROCEDURE insert_row(
3864:

Line 3896: -- Set_Attributes for: OKL_K_LINES_V --

3892: l_klev_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
3893: RETURN(l_klev_rec);
3894: END fill_who_columns;
3895: ----------------------------------------
3896: -- Set_Attributes for: OKL_K_LINES_V --
3897: ----------------------------------------
3898: FUNCTION Set_Attributes (
3899: p_klev_rec IN klev_rec_type,
3900: x_klev_rec OUT NOCOPY klev_rec_type

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

4021:
4022: END insert_row;
4023:
4024: ----------------------------------------
4025: -- PL/SQL TBL insert_row for: OKL_K_LINES_V --
4026: ----------------------------------------
4027:
4028: PROCEDURE insert_row(
4029:

Line 4215: -- lock_row for: OKL_K_LINES_V --

4211:
4212: END lock_row;
4213:
4214: ----------------------------------
4215: -- lock_row for: OKL_K_LINES_V --
4216: ----------------------------------
4217:
4218: PROCEDURE lock_row(
4219:

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

4300: );
4301:
4302: END lock_row;
4303: --------------------------------------
4304: -- PL/SQL TBL lock_row for: OKL_K_LINES_V --
4305: --------------------------------------
4306:
4307: PROCEDURE lock_row(
4308:

Line 5168: -- update_row for: OKL_K_LINES_V --

5164:
5165: END update_row;
5166:
5167: ------------------------------------
5168: -- update_row for: OKL_K_LINES_V --
5169: ------------------------------------
5170:
5171: PROCEDURE update_row(
5172:

Line 5722: -- Set_Attributes for: OKL_K_LINES_V --

5718:
5719: RETURN(l_return_status);
5720: END populate_new_record;
5721: ----------------------------------------
5722: -- Set_Attributes for: OKL_K_LINES_V --
5723: ----------------------------------------
5724: FUNCTION Set_Attributes (
5725: p_klev_rec IN klev_rec_type,
5726: x_klev_rec OUT NOCOPY klev_rec_type

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

5846: );
5847:
5848: END update_row;
5849: ----------------------------------------
5850: -- PL/SQL TBL update_row for: OKL_K_LINES_V --
5851: ----------------------------------------
5852:
5853: PROCEDURE update_row(
5854:

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

6103: );
6104:
6105: END delete_row;
6106: ----------------------------------------
6107: -- PL/SQL TBL delete_row for: OKL_K_LINES_V --
6108: ----------------------------------------
6109:
6110: PROCEDURE delete_row(
6111: