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_POT_PVT dependencies on OKL_POOL_TYPES

Line 94: -- FUNCTION get_rec for: OKL_POOL_TYPES_V

90: NULL;
91: END api_copy;
92:
93: ---------------------------------------------------------------------------
94: -- FUNCTION get_rec for: OKL_POOL_TYPES_V
95: ---------------------------------------------------------------------------
96: FUNCTION get_rec (
97: p_potv_rec IN potv_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN

Line 130: FROM OKL_POOL_TYPES_V

126: CREATION_DATE,
127: LAST_UPDATED_BY,
128: LAST_UPDATE_DATE,
129: LAST_UPDATE_LOGIN
130: FROM OKL_POOL_TYPES_V
131: WHERE OKL_POOL_TYPES_V.id = p_id;
132: l_okl_potv_pk okl_potv_pk_csr%ROWTYPE;
133: l_potv_rec potv_rec_type;
134: BEGIN

Line 131: WHERE OKL_POOL_TYPES_V.id = p_id;

127: LAST_UPDATED_BY,
128: LAST_UPDATE_DATE,
129: LAST_UPDATE_LOGIN
130: FROM OKL_POOL_TYPES_V
131: WHERE OKL_POOL_TYPES_V.id = p_id;
132: l_okl_potv_pk okl_potv_pk_csr%ROWTYPE;
133: l_potv_rec potv_rec_type;
134: BEGIN
135: x_no_data_found := TRUE;

Line 201: -- FUNCTION get_rec for: okl_pool_types

197: BEGIN
198: RETURN(get_rec(p_potv_rec, l_row_not_found));
199: END get_rec;
200: ---------------------------------------------------------------------------
201: -- FUNCTION get_rec for: okl_pool_types
202: ---------------------------------------------------------------------------
203: FUNCTION get_rec (
204: p_pot_rec IN pot_rec_type,
205: x_no_data_found OUT NOCOPY BOOLEAN

Line 207: CURSOR okl_pool_types_pk_csr (p_id IN NUMBER) IS

203: FUNCTION get_rec (
204: p_pot_rec IN pot_rec_type,
205: x_no_data_found OUT NOCOPY BOOLEAN
206: ) RETURN pot_rec_type IS
207: CURSOR okl_pool_types_pk_csr (p_id IN NUMBER) IS
208: SELECT
209: ID,
210: OBJECT_VERSION_NUMBER,
211: CODE,

Line 237: FROM okl_pool_types

233: CREATION_DATE,
234: LAST_UPDATED_BY,
235: LAST_UPDATE_DATE,
236: LAST_UPDATE_LOGIN
237: FROM okl_pool_types
238: WHERE okl_pool_types.id = p_id;
239: l_okl_pool_types_pk okl_pool_types_pk_csr%ROWTYPE;
240: l_pot_rec pot_rec_type;
241: BEGIN

Line 238: WHERE okl_pool_types.id = p_id;

234: LAST_UPDATED_BY,
235: LAST_UPDATE_DATE,
236: LAST_UPDATE_LOGIN
237: FROM okl_pool_types
238: WHERE okl_pool_types.id = p_id;
239: l_okl_pool_types_pk okl_pool_types_pk_csr%ROWTYPE;
240: l_pot_rec pot_rec_type;
241: BEGIN
242: x_no_data_found := TRUE;

Line 239: l_okl_pool_types_pk okl_pool_types_pk_csr%ROWTYPE;

235: LAST_UPDATE_DATE,
236: LAST_UPDATE_LOGIN
237: FROM okl_pool_types
238: WHERE okl_pool_types.id = p_id;
239: l_okl_pool_types_pk okl_pool_types_pk_csr%ROWTYPE;
240: l_pot_rec pot_rec_type;
241: BEGIN
242: x_no_data_found := TRUE;
243: -- Get current database values

Line 244: OPEN okl_pool_types_pk_csr (p_pot_rec.id);

240: l_pot_rec pot_rec_type;
241: BEGIN
242: x_no_data_found := TRUE;
243: -- Get current database values
244: OPEN okl_pool_types_pk_csr (p_pot_rec.id);
245: FETCH okl_pool_types_pk_csr INTO
246: l_pot_rec.id,
247: l_pot_rec.object_version_number,
248: l_pot_rec.code,

Line 245: FETCH okl_pool_types_pk_csr INTO

241: BEGIN
242: x_no_data_found := TRUE;
243: -- Get current database values
244: OPEN okl_pool_types_pk_csr (p_pot_rec.id);
245: FETCH okl_pool_types_pk_csr INTO
246: l_pot_rec.id,
247: l_pot_rec.object_version_number,
248: l_pot_rec.code,
249: l_pot_rec.description,

Line 274: x_no_data_found := okl_pool_types_pk_csr%NOTFOUND;

270: l_pot_rec.creation_date,
271: l_pot_rec.last_updated_by,
272: l_pot_rec.last_update_date,
273: l_pot_rec.last_update_login;
274: x_no_data_found := okl_pool_types_pk_csr%NOTFOUND;
275: CLOSE okl_pool_types_pk_csr;
276: RETURN(l_pot_rec);
277: END get_rec;
278:

Line 275: CLOSE okl_pool_types_pk_csr;

271: l_pot_rec.last_updated_by,
272: l_pot_rec.last_update_date,
273: l_pot_rec.last_update_login;
274: x_no_data_found := okl_pool_types_pk_csr%NOTFOUND;
275: CLOSE okl_pool_types_pk_csr;
276: RETURN(l_pot_rec);
277: END get_rec;
278:
279: ------------------------------------------------------------------

Line 309: -- FUNCTION null_out_defaults for: OKL_POOL_TYPES_V

305: RETURN(get_rec(p_pot_rec, l_row_not_found));
306: END get_rec;
307:
308: ---------------------------------------------------------------------------
309: -- FUNCTION null_out_defaults for: OKL_POOL_TYPES_V
310: -- mvasudev, hold this off for now
311: ---------------------------------------------------------------------------
312: FUNCTION null_out_defaults (
313: p_potv_rec IN potv_rec_type

Line 493: -- Validate_Attributes for:OKL_POOL_TYPES_V --

489: ---------------------------------------------------------------------------
490: -- FUNCTION Validate_Attributes
491: ---------------------------------------------------------------------------
492: ---------------------------------------------------
493: -- Validate_Attributes for:OKL_POOL_TYPES_V --
494: ---------------------------------------------------
495: FUNCTION Validate_Attributes (
496: p_potv_rec IN potv_rec_type
497: ) RETURN VARCHAR2 IS

Line 549: -- Validate Record for:OKL_POOL_TYPES_V --

545: ---------------------------------------------------------------------------
546: -- PROCEDURE Validate_Record
547: ---------------------------------------------------------------------------
548: -----------------------------------------
549: -- Validate Record for:OKL_POOL_TYPES_V --
550: -----------------------------------------
551: FUNCTION Validate_Record (
552: p_potv_rec IN potv_rec_type,
553: p_db_potv_rec IN potv_rec_type

Line 664: -- validate_row for:OKL_POOL_TYPES_V --

660: ---------------------------------------------------------------------------
661: -- PROCEDURE validate_row
662: ---------------------------------------------------------------------------
663: --------------------------------------------
664: -- validate_row for:OKL_POOL_TYPES_V --
665: --------------------------------------------
666: PROCEDURE validate_row(
667: p_api_version IN NUMBER,
668: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 741: -- PL/SQL TBL validate_row for:OKL_POOL_TYPES_V --

737: '_PVT'
738: );
739: END validate_row;
740: -------------------------------------------------------
741: -- PL/SQL TBL validate_row for:OKL_POOL_TYPES_V --
742: -------------------------------------------------------
743: PROCEDURE validate_row(
744: p_api_version IN NUMBER,
745: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 837: -- PL/SQL TBL validate_row for:OKL_POOL_TYPES_V --

833: );
834: END validate_row;
835:
836: -------------------------------------------------------
837: -- PL/SQL TBL validate_row for:OKL_POOL_TYPES_V --
838: -------------------------------------------------------
839: PROCEDURE validate_row(
840: p_api_version IN NUMBER,
841: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 902: -- insert_row for:okl_pool_types --

898: ---------------------------------------------------------------------------
899: -- PROCEDURE insert_row
900: ---------------------------------------------------------------------------
901: ----------------------------------------
902: -- insert_row for:okl_pool_types --
903: ----------------------------------------
904: PROCEDURE insert_row(
905: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
906: x_return_status OUT NOCOPY VARCHAR2,

Line 918: -- Set_Attributes for:okl_pool_types --

914: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
915: l_pot_rec pot_rec_type := p_pot_rec;
916: l_def_pot_rec pot_rec_type;
917: --------------------------------------------
918: -- Set_Attributes for:okl_pool_types --
919: --------------------------------------------
920: FUNCTION Set_Attributes (
921: p_pot_rec IN pot_rec_type,
922: x_pot_rec OUT NOCOPY pot_rec_type

Line 949: INSERT INTO okl_pool_types(

945: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
946: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
947: RAISE OKC_API.G_EXCEPTION_ERROR;
948: END IF;
949: INSERT INTO okl_pool_types(
950: ID,
951: OBJECT_VERSION_NUMBER,
952: CODE,
953: DESCRIPTION,

Line 1044: -- insert_row for :OKL_POOL_TYPES_V --

1040: '_PVT'
1041: );
1042: END insert_row;
1043: -------------------------------------------
1044: -- insert_row for :OKL_POOL_TYPES_V --
1045: -------------------------------------------
1046: PROCEDURE insert_row(
1047: p_api_version IN NUMBER,
1048: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1078: -- Set_Attributes for:OKL_POOL_TYPES_V --

1074: l_potv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1075: RETURN(l_potv_rec);
1076: END fill_who_columns;
1077: ----------------------------------------------
1078: -- Set_Attributes for:OKL_POOL_TYPES_V --
1079: ----------------------------------------------
1080: FUNCTION Set_Attributes (
1081: p_potv_rec IN potv_rec_type,
1082: x_potv_rec OUT NOCOPY potv_rec_type

Line 1354: -- lock_row for:okl_pool_types --

1350: ---------------------------------------------------------------------------
1351: -- PROCEDURE lock_row
1352: ---------------------------------------------------------------------------
1353: --------------------------------------
1354: -- lock_row for:okl_pool_types --
1355: --------------------------------------
1356: PROCEDURE lock_row(
1357: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1358: x_return_status OUT NOCOPY VARCHAR2,

Line 1367: FROM okl_pool_types

1363: E_Resource_Busy EXCEPTION;
1364: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1365: CURSOR lock_csr (p_pot_rec IN pot_rec_type) IS
1366: SELECT OBJECT_VERSION_NUMBER
1367: FROM okl_pool_types
1368: WHERE ID = p_pot_rec.id
1369: AND OBJECT_VERSION_NUMBER = p_pot_rec.object_version_number
1370: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1371:

Line 1374: FROM okl_pool_types

1370: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1371:
1372: CURSOR lchk_csr (p_pot_rec IN pot_rec_type) IS
1373: SELECT OBJECT_VERSION_NUMBER
1374: FROM okl_pool_types
1375: WHERE ID = p_pot_rec.id;
1376: l_api_version CONSTANT NUMBER := 1;
1377: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1378: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1379: l_object_version_number okl_pool_types.OBJECT_VERSION_NUMBER%TYPE;

1375: WHERE ID = p_pot_rec.id;
1376: l_api_version CONSTANT NUMBER := 1;
1377: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1378: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1379: l_object_version_number okl_pool_types.OBJECT_VERSION_NUMBER%TYPE;
1380: lc_object_version_number okl_pool_types.OBJECT_VERSION_NUMBER%TYPE;
1381: l_row_notfound BOOLEAN := FALSE;
1382: lc_row_notfound BOOLEAN := FALSE;
1383: BEGIN

Line 1380: lc_object_version_number okl_pool_types.OBJECT_VERSION_NUMBER%TYPE;

1376: l_api_version CONSTANT NUMBER := 1;
1377: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1378: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1379: l_object_version_number okl_pool_types.OBJECT_VERSION_NUMBER%TYPE;
1380: lc_object_version_number okl_pool_types.OBJECT_VERSION_NUMBER%TYPE;
1381: l_row_notfound BOOLEAN := FALSE;
1382: lc_row_notfound BOOLEAN := FALSE;
1383: BEGIN
1384: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1461: -- lock_row for: OKL_POOL_TYPES_V --

1457: '_PVT'
1458: );
1459: END lock_row;
1460: -----------------------------------------
1461: -- lock_row for: OKL_POOL_TYPES_V --
1462: -----------------------------------------
1463: PROCEDURE lock_row(
1464: p_api_version IN NUMBER,
1465: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1701: -- update_row for:okl_pool_types --

1697: ---------------------------------------------------------------------------
1698: -- PROCEDURE update_row
1699: ---------------------------------------------------------------------------
1700: ----------------------------------------
1701: -- update_row for:okl_pool_types --
1702: ----------------------------------------
1703: PROCEDURE update_row(
1704: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1705: x_return_status OUT NOCOPY VARCHAR2,

Line 1849: -- Set_Attributes for:okl_pool_types --

1845: END IF;
1846: RETURN(l_return_status);
1847: END populate_new_record;
1848: --------------------------------------------
1849: -- Set_Attributes for:okl_pool_types --
1850: --------------------------------------------
1851: FUNCTION Set_Attributes (
1852: p_pot_rec IN pot_rec_type,
1853: x_pot_rec OUT NOCOPY pot_rec_type

Line 1887: UPDATE okl_pool_types

1883: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1884: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1885: RAISE OKC_API.G_EXCEPTION_ERROR;
1886: END IF;
1887: UPDATE okl_pool_types
1888: SET OBJECT_VERSION_NUMBER = l_def_pot_rec.object_version_number,
1889: CODE = l_def_pot_rec.code,
1890: DESCRIPTION = l_def_pot_rec.description,
1891: SHORT_DESCRIPTION = l_def_pot_rec.short_description,

Line 1953: -- update_row for:OKL_POOL_TYPES_V --

1949: '_PVT'
1950: );
1951: END update_row;
1952: ------------------------------------------
1953: -- update_row for:OKL_POOL_TYPES_V --
1954: ------------------------------------------
1955: PROCEDURE update_row(
1956: p_api_version IN NUMBER,
1957: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2117: -- Set_Attributes for:OKL_POOL_TYPES_V --

2113: END IF;
2114: RETURN(l_return_status);
2115: END populate_new_record;
2116: ----------------------------------------------
2117: -- Set_Attributes for:OKL_POOL_TYPES_V --
2118: ----------------------------------------------
2119: FUNCTION Set_Attributes (
2120: p_potv_rec IN potv_rec_type,
2121: x_potv_rec OUT NOCOPY potv_rec_type

Line 2412: -- delete_row for:okl_pool_types --

2408: ---------------------------------------------------------------------------
2409: -- PROCEDURE delete_row
2410: ---------------------------------------------------------------------------
2411: ----------------------------------------
2412: -- delete_row for:okl_pool_types --
2413: ----------------------------------------
2414: PROCEDURE delete_row(
2415: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2416: x_return_status OUT NOCOPY VARCHAR2,

Line 2437: DELETE FROM okl_pool_types

2433: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2434: RAISE OKC_API.G_EXCEPTION_ERROR;
2435: END IF;
2436:
2437: DELETE FROM okl_pool_types
2438: WHERE ID = p_pot_rec.id;
2439:
2440: x_return_status := l_return_status;
2441: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2475: -- delete_row for:OKL_POOL_TYPES_V --

2471: '_PVT'
2472: );
2473: END delete_row;
2474: ------------------------------------------
2475: -- delete_row for:OKL_POOL_TYPES_V --
2476: ------------------------------------------
2477: PROCEDURE delete_row(
2478: p_api_version IN NUMBER,
2479: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2557: -- PL/SQL TBL delete_row for:OKL_POOL_TYPES_V --

2553: '_PVT'
2554: );
2555: END delete_row;
2556: -----------------------------------------------------
2557: -- PL/SQL TBL delete_row for:OKL_POOL_TYPES_V --
2558: -----------------------------------------------------
2559: PROCEDURE delete_row(
2560: p_api_version IN NUMBER,
2561: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2653: -- PL/SQL TBL delete_row for:OKL_POOL_TYPES_V --

2649: );
2650: END delete_row;
2651:
2652: -----------------------------------------------------
2653: -- PL/SQL TBL delete_row for:OKL_POOL_TYPES_V --
2654: -----------------------------------------------------
2655: PROCEDURE delete_row(
2656: p_api_version IN NUMBER,
2657: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,