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_POL_PVT dependencies on OKL_POOLS

Line 94: -- FUNCTION get_rec for: OKL_POOLS_V

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

Line 146: FROM OKL_POOLS

142: LAST_UPDATED_BY,
143: LAST_UPDATE_DATE,
144: LAST_UPDATE_LOGIN,
145: LEGAL_ENTITY_ID
146: FROM OKL_POOLS
147: WHERE OKL_POOLS.id = p_id;
148: l_okl_polv_pk okl_polv_pk_csr%ROWTYPE;
149: l_polv_rec polv_rec_type;
150: BEGIN

Line 147: WHERE OKL_POOLS.id = p_id;

143: LAST_UPDATE_DATE,
144: LAST_UPDATE_LOGIN,
145: LEGAL_ENTITY_ID
146: FROM OKL_POOLS
147: WHERE OKL_POOLS.id = p_id;
148: l_okl_polv_pk okl_polv_pk_csr%ROWTYPE;
149: l_polv_rec polv_rec_type;
150: BEGIN
151: x_no_data_found := TRUE;

Line 233: -- FUNCTION get_rec for: okl_pools

229: BEGIN
230: RETURN(get_rec(p_polv_rec, l_row_not_found));
231: END get_rec;
232: ---------------------------------------------------------------------------
233: -- FUNCTION get_rec for: okl_pools
234: ---------------------------------------------------------------------------
235: FUNCTION get_rec (
236: p_pol_rec IN pol_rec_type,
237: x_no_data_found OUT NOCOPY BOOLEAN

Line 239: CURSOR okl_pools_pk_csr (p_id IN NUMBER) IS

235: FUNCTION get_rec (
236: p_pol_rec IN pol_rec_type,
237: x_no_data_found OUT NOCOPY BOOLEAN
238: ) RETURN pol_rec_type IS
239: CURSOR okl_pools_pk_csr (p_id IN NUMBER) IS
240: SELECT
241: ID,
242: OBJECT_VERSION_NUMBER,
243: POT_ID,

Line 285: FROM okl_pools

281: LAST_UPDATED_BY,
282: LAST_UPDATE_DATE,
283: LAST_UPDATE_LOGIN,
284: LEGAL_ENTITY_ID
285: FROM okl_pools
286: WHERE okl_pools.id = p_id;
287: l_okl_pools_pk okl_pools_pk_csr%ROWTYPE;
288: l_pol_rec pol_rec_type;
289: BEGIN

Line 286: WHERE okl_pools.id = p_id;

282: LAST_UPDATE_DATE,
283: LAST_UPDATE_LOGIN,
284: LEGAL_ENTITY_ID
285: FROM okl_pools
286: WHERE okl_pools.id = p_id;
287: l_okl_pools_pk okl_pools_pk_csr%ROWTYPE;
288: l_pol_rec pol_rec_type;
289: BEGIN
290: x_no_data_found := TRUE;

Line 287: l_okl_pools_pk okl_pools_pk_csr%ROWTYPE;

283: LAST_UPDATE_LOGIN,
284: LEGAL_ENTITY_ID
285: FROM okl_pools
286: WHERE okl_pools.id = p_id;
287: l_okl_pools_pk okl_pools_pk_csr%ROWTYPE;
288: l_pol_rec pol_rec_type;
289: BEGIN
290: x_no_data_found := TRUE;
291: -- Get current database values

Line 292: OPEN okl_pools_pk_csr (p_pol_rec.id);

288: l_pol_rec pol_rec_type;
289: BEGIN
290: x_no_data_found := TRUE;
291: -- Get current database values
292: OPEN okl_pools_pk_csr (p_pol_rec.id);
293: FETCH okl_pools_pk_csr INTO
294: l_pol_rec.id,
295: l_pol_rec.object_version_number,
296: l_pol_rec.pot_id,

Line 293: FETCH okl_pools_pk_csr INTO

289: BEGIN
290: x_no_data_found := TRUE;
291: -- Get current database values
292: OPEN okl_pools_pk_csr (p_pol_rec.id);
293: FETCH okl_pools_pk_csr INTO
294: l_pol_rec.id,
295: l_pol_rec.object_version_number,
296: l_pol_rec.pot_id,
297: l_pol_rec.khr_id,

Line 338: x_no_data_found := okl_pools_pk_csr%NOTFOUND;

334: l_pol_rec.last_updated_by,
335: l_pol_rec.last_update_date,
336: l_pol_rec.last_update_login,
337: l_pol_rec.legal_entity_id;
338: x_no_data_found := okl_pools_pk_csr%NOTFOUND;
339: CLOSE okl_pools_pk_csr;
340: RETURN(l_pol_rec);
341: END get_rec;
342:

Line 339: CLOSE okl_pools_pk_csr;

335: l_pol_rec.last_update_date,
336: l_pol_rec.last_update_login,
337: l_pol_rec.legal_entity_id;
338: x_no_data_found := okl_pools_pk_csr%NOTFOUND;
339: CLOSE okl_pools_pk_csr;
340: RETURN(l_pol_rec);
341: END get_rec;
342:
343: ------------------------------------------------------------------

Line 373: -- FUNCTION null_out_defaults for: OKL_POOLS_V

369: RETURN(get_rec(p_pol_rec, l_row_not_found));
370: END get_rec;
371:
372: ---------------------------------------------------------------------------
373: -- FUNCTION null_out_defaults for: OKL_POOLS_V
374: -- mvasudev, hold this off for now
375: ---------------------------------------------------------------------------
376: FUNCTION null_out_defaults (
377: p_polv_rec IN polv_rec_type

Line 586: CURSOR okl_potv_pk_csr (p_id IN OKL_POOLS.pot_id%TYPE) IS

582: l_dummy VARCHAR2(1) := '?';
583: l_row_not_found BOOLEAN := FALSE;
584:
585: -- Cursor For OKL_POL_POT_FK;
586: CURSOR okl_potv_pk_csr (p_id IN OKL_POOLS.pot_id%TYPE) IS
587: SELECT '1'
588: FROM OKL_POOL_TYPES_V
589: WHERE OKL_POOL_TYPES_V.id = p_id;
590:

Line 633: CURSOR okl_khrv_pk_csr (p_id IN OKL_POOLS.khr_id%TYPE) IS

629: l_dummy VARCHAR2(1) := '?';
630: l_row_not_found BOOLEAN := FALSE;
631:
632: -- Cursor For OKL_POL_KHR_FK;
633: CURSOR okl_khrv_pk_csr (p_id IN OKL_POOLS.khr_id%TYPE) IS
634: SELECT '1'
635: FROM OKL_K_HEADERS_V
636: WHERE OKL_K_HEADERS_V.id = p_id;
637:

Line 714: CURSOR okl_fnd_curr_csr (p_code IN OKL_POOLS.currency_code%TYPE) IS

710: l_dummy VARCHAR2(1) := '?';
711: l_row_not_found BOOLEAN := FALSE;
712:
713: -- Cursor For OKL_CURRENCIES;
714: CURSOR okl_fnd_curr_csr (p_code IN OKL_POOLS.currency_code%TYPE) IS
715: SELECT '1'
716: FROM FND_CURRENCIES_VL
717: WHERE FND_CURRENCIES_VL.currency_code = p_code; -- Bug 6982517. Changed to use the parameter.
718:

Line 861: -- Validate_Attributes for:OKL_POOLS_V --

857: ---------------------------------------------------------------------------
858: -- FUNCTION Validate_Attributes
859: ---------------------------------------------------------------------------
860: ---------------------------------------------------
861: -- Validate_Attributes for:OKL_POOLS_V --
862: ---------------------------------------------------
863: FUNCTION Validate_Attributes (
864: p_polv_rec IN polv_rec_type
865: ) RETURN VARCHAR2 IS

Line 991: FROM OKL_POOLS

987:
988: -- Cursor for PIT Unique Key
989: CURSOR okl_pol_uk_csr(p_rec polv_rec_type) IS
990: SELECT '1'
991: FROM OKL_POOLS
992: WHERE pool_number = p_rec.pool_number
993: AND id <> NVL(p_rec.id,-9999);
994:
995: BEGIN

Line 1034: -- Validate Record for:OKL_POOLS_V --

1030: ---------------------------------------------------------------------------
1031: -- PROCEDURE Validate_Record
1032: ---------------------------------------------------------------------------
1033: -----------------------------------------
1034: -- Validate Record for:OKL_POOLS_V --
1035: -----------------------------------------
1036: FUNCTION Validate_Record (
1037: p_polv_rec IN polv_rec_type,
1038: p_db_polv_rec IN polv_rec_type

Line 1184: -- validate_row for:OKL_POOLS_V --

1180: ---------------------------------------------------------------------------
1181: -- PROCEDURE validate_row
1182: ---------------------------------------------------------------------------
1183: --------------------------------------------
1184: -- validate_row for:OKL_POOLS_V --
1185: --------------------------------------------
1186: PROCEDURE validate_row(
1187: p_api_version IN NUMBER,
1188: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1261: -- PL/SQL TBL validate_row for:OKL_POOLS_V --

1257: '_PVT'
1258: );
1259: END validate_row;
1260: -------------------------------------------------------
1261: -- PL/SQL TBL validate_row for:OKL_POOLS_V --
1262: -------------------------------------------------------
1263: PROCEDURE validate_row(
1264: p_api_version IN NUMBER,
1265: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1357: -- PL/SQL TBL validate_row for:OKL_POOLS_V --

1353: );
1354: END validate_row;
1355:
1356: -------------------------------------------------------
1357: -- PL/SQL TBL validate_row for:OKL_POOLS_V --
1358: -------------------------------------------------------
1359: PROCEDURE validate_row(
1360: p_api_version IN NUMBER,
1361: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1422: -- insert_row for:okl_pools --

1418: ---------------------------------------------------------------------------
1419: -- PROCEDURE insert_row
1420: ---------------------------------------------------------------------------
1421: ----------------------------------------
1422: -- insert_row for:okl_pools --
1423: ----------------------------------------
1424: PROCEDURE insert_row(
1425: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1426: x_return_status OUT NOCOPY VARCHAR2,

Line 1438: -- Set_Attributes for:okl_pools --

1434: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1435: l_pol_rec pol_rec_type := p_pol_rec;
1436: l_def_pol_rec pol_rec_type;
1437: --------------------------------------------
1438: -- Set_Attributes for:okl_pools --
1439: --------------------------------------------
1440: FUNCTION Set_Attributes (
1441: p_pol_rec IN pol_rec_type,
1442: x_pol_rec OUT NOCOPY pol_rec_type

Line 1469: INSERT INTO okl_pools(

1465: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1466: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1467: RAISE OKL_API.G_EXCEPTION_ERROR;
1468: END IF;
1469: INSERT INTO okl_pools(
1470: ID,
1471: OBJECT_VERSION_NUMBER,
1472: POT_ID,
1473: KHR_ID,

Line 1596: -- insert_row for :OKL_POOLS_V --

1592: '_PVT'
1593: );
1594: END insert_row;
1595: -------------------------------------------
1596: -- insert_row for :OKL_POOLS_V --
1597: -------------------------------------------
1598: PROCEDURE insert_row(
1599: p_api_version IN NUMBER,
1600: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1630: -- Set_Attributes for:OKL_POOLS_V --

1626: l_polv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1627: RETURN(l_polv_rec);
1628: END fill_who_columns;
1629: ----------------------------------------------
1630: -- Set_Attributes for:OKL_POOLS_V --
1631: ----------------------------------------------
1632: FUNCTION Set_Attributes (
1633: p_polv_rec IN polv_rec_type,
1634: x_polv_rec OUT NOCOPY polv_rec_type

Line 1918: -- lock_row for:okl_pools --

1914: ---------------------------------------------------------------------------
1915: -- PROCEDURE lock_row
1916: ---------------------------------------------------------------------------
1917: --------------------------------------
1918: -- lock_row for:okl_pools --
1919: --------------------------------------
1920: PROCEDURE lock_row(
1921: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1922: x_return_status OUT NOCOPY VARCHAR2,

Line 1931: FROM okl_pools

1927: E_Resource_Busy EXCEPTION;
1928: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1929: CURSOR lock_csr (p_pol_rec IN pol_rec_type) IS
1930: SELECT OBJECT_VERSION_NUMBER
1931: FROM okl_pools
1932: WHERE ID = p_pol_rec.id
1933: AND OBJECT_VERSION_NUMBER = p_pol_rec.object_version_number
1934: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1935:

Line 1938: FROM okl_pools

1934: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1935:
1936: CURSOR lchk_csr (p_pol_rec IN pol_rec_type) IS
1937: SELECT OBJECT_VERSION_NUMBER
1938: FROM okl_pools
1939: WHERE ID = p_pol_rec.id;
1940: l_api_version CONSTANT NUMBER := 1;
1941: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1942: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 1943: l_object_version_number okl_pools.OBJECT_VERSION_NUMBER%TYPE;

1939: WHERE ID = p_pol_rec.id;
1940: l_api_version CONSTANT NUMBER := 1;
1941: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1942: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1943: l_object_version_number okl_pools.OBJECT_VERSION_NUMBER%TYPE;
1944: lc_object_version_number okl_pools.OBJECT_VERSION_NUMBER%TYPE;
1945: l_row_notfound BOOLEAN := FALSE;
1946: lc_row_notfound BOOLEAN := FALSE;
1947: BEGIN

Line 1944: lc_object_version_number okl_pools.OBJECT_VERSION_NUMBER%TYPE;

1940: l_api_version CONSTANT NUMBER := 1;
1941: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1942: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1943: l_object_version_number okl_pools.OBJECT_VERSION_NUMBER%TYPE;
1944: lc_object_version_number okl_pools.OBJECT_VERSION_NUMBER%TYPE;
1945: l_row_notfound BOOLEAN := FALSE;
1946: lc_row_notfound BOOLEAN := FALSE;
1947: BEGIN
1948: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 2025: -- lock_row for: OKL_POOLS_V --

2021: '_PVT'
2022: );
2023: END lock_row;
2024: -----------------------------------------
2025: -- lock_row for: OKL_POOLS_V --
2026: -----------------------------------------
2027: PROCEDURE lock_row(
2028: p_api_version IN NUMBER,
2029: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2265: -- update_row for:okl_pools --

2261: ---------------------------------------------------------------------------
2262: -- PROCEDURE update_row
2263: ---------------------------------------------------------------------------
2264: ----------------------------------------
2265: -- update_row for:okl_pools --
2266: ----------------------------------------
2267: PROCEDURE update_row(
2268: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2269: x_return_status OUT NOCOPY VARCHAR2,

Line 2478: -- Set_Attributes for:okl_pools --

2474: END IF;
2475: RETURN(l_return_status);
2476: END populate_new_record;
2477: --------------------------------------------
2478: -- Set_Attributes for:okl_pools --
2479: --------------------------------------------
2480: FUNCTION Set_Attributes (
2481: p_pol_rec IN pol_rec_type,
2482: x_pol_rec OUT NOCOPY pol_rec_type

Line 2515: UPDATE okl_pools

2511: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2512: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2513: RAISE OKL_API.G_EXCEPTION_ERROR;
2514: END IF;
2515: UPDATE okl_pools
2516: SET OBJECT_VERSION_NUMBER = l_def_pol_rec.object_version_number,
2517: POT_ID = l_def_pol_rec.pot_id,
2518: KHR_ID = l_def_pol_rec.khr_id,
2519: POOL_NUMBER = l_def_pol_rec.pool_number,

Line 2597: -- update_row for:OKL_POOLS_V --

2593: '_PVT'
2594: );
2595: END update_row;
2596: ------------------------------------------
2597: -- update_row for:OKL_POOLS_V --
2598: ------------------------------------------
2599: PROCEDURE update_row(
2600: p_api_version IN NUMBER,
2601: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2821: -- Set_Attributes for:OKL_POOLS_V --

2817: END IF;
2818: RETURN(l_return_status);
2819: END populate_new_record;
2820: ----------------------------------------------
2821: -- Set_Attributes for:OKL_POOLS_V --
2822: ----------------------------------------------
2823: FUNCTION Set_Attributes (
2824: p_polv_rec IN polv_rec_type,
2825: x_polv_rec OUT NOCOPY polv_rec_type

Line 3117: -- delete_row for:okl_pools --

3113: ---------------------------------------------------------------------------
3114: -- PROCEDURE delete_row
3115: ---------------------------------------------------------------------------
3116: ----------------------------------------
3117: -- delete_row for:okl_pools --
3118: ----------------------------------------
3119: PROCEDURE delete_row(
3120: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
3121: x_return_status OUT NOCOPY VARCHAR2,

Line 3142: DELETE FROM okl_pools

3138: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3139: RAISE OKL_API.G_EXCEPTION_ERROR;
3140: END IF;
3141:
3142: DELETE FROM okl_pools
3143: WHERE ID = p_pol_rec.id;
3144:
3145: x_return_status := l_return_status;
3146: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 3180: -- delete_row for:OKL_POOLS_V --

3176: '_PVT'
3177: );
3178: END delete_row;
3179: ------------------------------------------
3180: -- delete_row for:OKL_POOLS_V --
3181: ------------------------------------------
3182: PROCEDURE delete_row(
3183: p_api_version IN NUMBER,
3184: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 3262: -- PL/SQL TBL delete_row for:OKL_POOLS_V --

3258: '_PVT'
3259: );
3260: END delete_row;
3261: -----------------------------------------------------
3262: -- PL/SQL TBL delete_row for:OKL_POOLS_V --
3263: -----------------------------------------------------
3264: PROCEDURE delete_row(
3265: p_api_version IN NUMBER,
3266: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 3358: -- PL/SQL TBL delete_row for:OKL_POOLS_V --

3354: );
3355: END delete_row;
3356:
3357: -----------------------------------------------------
3358: -- PL/SQL TBL delete_row for:OKL_POOLS_V --
3359: -----------------------------------------------------
3360: PROCEDURE delete_row(
3361: p_api_version IN NUMBER,
3362: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,