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_POX_PVT dependencies on OKL_POOL_TRANSACTIONS

Line 104: -- FUNCTION get_rec for: OKL_POOL_TRANSACTIONS_V

100: RETURN(l_newvalue);
101: END get_trans_num;
102:
103: ---------------------------------------------------------------------------
104: -- FUNCTION get_rec for: OKL_POOL_TRANSACTIONS_V
105: ---------------------------------------------------------------------------
106: FUNCTION get_rec (
107: p_poxv_rec IN poxv_rec_type,
108: x_no_data_found OUT NOCOPY BOOLEAN

Line 152: FROM OKL_POOL_TRANSACTIONS_V

148: LAST_UPDATE_DATE,
149: LAST_UPDATE_LOGIN,
150: LEGAL_ENTITY_ID,
151: TRANSACTION_STATUS
152: FROM OKL_POOL_TRANSACTIONS_V
153: WHERE OKL_POOL_TRANSACTIONS_V.id = p_id;
154: l_okl_poxv_pk okl_poxv_pk_csr%ROWTYPE;
155: l_poxv_rec poxv_rec_type;
156: BEGIN

Line 153: WHERE OKL_POOL_TRANSACTIONS_V.id = p_id;

149: LAST_UPDATE_LOGIN,
150: LEGAL_ENTITY_ID,
151: TRANSACTION_STATUS
152: FROM OKL_POOL_TRANSACTIONS_V
153: WHERE OKL_POOL_TRANSACTIONS_V.id = p_id;
154: l_okl_poxv_pk okl_poxv_pk_csr%ROWTYPE;
155: l_poxv_rec poxv_rec_type;
156: BEGIN
157: x_no_data_found := TRUE;

Line 235: -- FUNCTION get_rec for: okl_pool_transactions

231: BEGIN
232: RETURN(get_rec(p_poxv_rec, l_row_not_found));
233: END get_rec;
234: ---------------------------------------------------------------------------
235: -- FUNCTION get_rec for: okl_pool_transactions
236: ---------------------------------------------------------------------------
237: FUNCTION get_rec (
238: p_pox_rec IN pox_rec_type,
239: x_no_data_found OUT NOCOPY BOOLEAN

Line 241: CURSOR okl_pool_transactions_pk_csr (p_id IN NUMBER) IS

237: FUNCTION get_rec (
238: p_pox_rec IN pox_rec_type,
239: x_no_data_found OUT NOCOPY BOOLEAN
240: ) RETURN pox_rec_type IS
241: CURSOR okl_pool_transactions_pk_csr (p_id IN NUMBER) IS
242: SELECT
243: ID,
244: OBJECT_VERSION_NUMBER,
245: POL_ID,

Line 283: FROM okl_pool_transactions

279: LAST_UPDATE_DATE,
280: LAST_UPDATE_LOGIN,
281: LEGAL_ENTITY_ID,
282: TRANSACTION_STATUS
283: FROM okl_pool_transactions
284: WHERE okl_pool_transactions.id = p_id;
285: l_okl_pool_transactions_pk okl_pool_transactions_pk_csr%ROWTYPE;
286: l_pox_rec pox_rec_type;
287: BEGIN

Line 284: WHERE okl_pool_transactions.id = p_id;

280: LAST_UPDATE_LOGIN,
281: LEGAL_ENTITY_ID,
282: TRANSACTION_STATUS
283: FROM okl_pool_transactions
284: WHERE okl_pool_transactions.id = p_id;
285: l_okl_pool_transactions_pk okl_pool_transactions_pk_csr%ROWTYPE;
286: l_pox_rec pox_rec_type;
287: BEGIN
288: x_no_data_found := TRUE;

Line 285: l_okl_pool_transactions_pk okl_pool_transactions_pk_csr%ROWTYPE;

281: LEGAL_ENTITY_ID,
282: TRANSACTION_STATUS
283: FROM okl_pool_transactions
284: WHERE okl_pool_transactions.id = p_id;
285: l_okl_pool_transactions_pk okl_pool_transactions_pk_csr%ROWTYPE;
286: l_pox_rec pox_rec_type;
287: BEGIN
288: x_no_data_found := TRUE;
289: -- Get current database values

Line 290: OPEN okl_pool_transactions_pk_csr (p_pox_rec.id);

286: l_pox_rec pox_rec_type;
287: BEGIN
288: x_no_data_found := TRUE;
289: -- Get current database values
290: OPEN okl_pool_transactions_pk_csr (p_pox_rec.id);
291: FETCH okl_pool_transactions_pk_csr INTO
292: l_pox_rec.id,
293: l_pox_rec.object_version_number,
294: l_pox_rec.pol_id,

Line 291: FETCH okl_pool_transactions_pk_csr INTO

287: BEGIN
288: x_no_data_found := TRUE;
289: -- Get current database values
290: OPEN okl_pool_transactions_pk_csr (p_pox_rec.id);
291: FETCH okl_pool_transactions_pk_csr INTO
292: l_pox_rec.id,
293: l_pox_rec.object_version_number,
294: l_pox_rec.pol_id,
295: l_pox_rec.transaction_number,

Line 332: x_no_data_found := okl_pool_transactions_pk_csr%NOTFOUND;

328: l_pox_rec.last_update_date,
329: l_pox_rec.last_update_login,
330: l_pox_rec.legal_entity_id,
331: l_pox_rec.transaction_status;
332: x_no_data_found := okl_pool_transactions_pk_csr%NOTFOUND;
333: CLOSE okl_pool_transactions_pk_csr;
334: RETURN(l_pox_rec);
335: END get_rec;
336:

Line 333: CLOSE okl_pool_transactions_pk_csr;

329: l_pox_rec.last_update_login,
330: l_pox_rec.legal_entity_id,
331: l_pox_rec.transaction_status;
332: x_no_data_found := okl_pool_transactions_pk_csr%NOTFOUND;
333: CLOSE okl_pool_transactions_pk_csr;
334: RETURN(l_pox_rec);
335: END get_rec;
336:
337: ------------------------------------------------------------------

Line 367: -- FUNCTION null_out_defaults for: OKL_POOL_TRANSACTIONS_V

363: RETURN(get_rec(p_pox_rec, l_row_not_found));
364: END get_rec;
365:
366: ---------------------------------------------------------------------------
367: -- FUNCTION null_out_defaults for: OKL_POOL_TRANSACTIONS_V
368: -- mvasudev, hold this off for now
369: ---------------------------------------------------------------------------
370: FUNCTION null_out_defaults (
371: p_poxv_rec IN poxv_rec_type

Line 569: CURSOR okl_polv_pk_csr (p_id IN OKL_POOL_TRANSACTIONS_V.pol_id%TYPE) IS

565: l_dummy VARCHAR2(1) := '?';
566: l_row_not_found BOOLEAN := FALSE;
567:
568: -- Cursor For OKL_POL_POX_FK;
569: CURSOR okl_polv_pk_csr (p_id IN OKL_POOL_TRANSACTIONS_V.pol_id%TYPE) IS
570: SELECT '1'
571: FROM OKL_POOLS
572: WHERE OKL_POOLS.id = p_id;
573:

Line 868: FROM OKL_POOL_TRANSACTIONS_V

864:
865: -- Cursor for Pox Unique Key
866: CURSOR okl_pox_uk_csr(p_poxv_rec IN poxv_rec_type) IS
867: SELECT '1'
868: FROM OKL_POOL_TRANSACTIONS_V
869: WHERE transaction_number = p_poxv_rec.transaction_number
870: AND id <> NVL(p_poxv_rec.id,-9999);
871:
872: BEGIN

Line 912: -- Validate_Attributes for:OKL_POOL_TRANSACTIONS_V --

908: ---------------------------------------------------------------------------
909: -- FUNCTION Validate_Attributes
910: ---------------------------------------------------------------------------
911: ---------------------------------------------------
912: -- Validate_Attributes for:OKL_POOL_TRANSACTIONS_V --
913: ---------------------------------------------------
914: FUNCTION Validate_Attributes (
915: p_poxv_rec IN poxv_rec_type
916: ) RETURN VARCHAR2 IS

Line 1013: -- Validate Record for:OKL_POOL_TRANSACTIONS_V --

1009: ---------------------------------------------------------------------------
1010: -- PROCEDURE Validate_Record
1011: ---------------------------------------------------------------------------
1012: -----------------------------------------
1013: -- Validate Record for:OKL_POOL_TRANSACTIONS_V --
1014: -----------------------------------------
1015: FUNCTION Validate_Record (
1016: p_poxv_rec IN poxv_rec_type,
1017: p_db_poxv_rec IN poxv_rec_type

Line 1155: -- validate_row for:OKL_POOL_TRANSACTIONS_V --

1151: ---------------------------------------------------------------------------
1152: -- PROCEDURE validate_row
1153: ---------------------------------------------------------------------------
1154: --------------------------------------------
1155: -- validate_row for:OKL_POOL_TRANSACTIONS_V --
1156: --------------------------------------------
1157: PROCEDURE validate_row(
1158: p_api_version IN NUMBER,
1159: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1232: -- PL/SQL TBL validate_row for:OKL_POOL_TRANSACTIONS_V --

1228: '_PVT'
1229: );
1230: END validate_row;
1231: -------------------------------------------------------
1232: -- PL/SQL TBL validate_row for:OKL_POOL_TRANSACTIONS_V --
1233: -------------------------------------------------------
1234: PROCEDURE validate_row(
1235: p_api_version IN NUMBER,
1236: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1328: -- PL/SQL TBL validate_row for:OKL_POOL_TRANSACTIONS_V --

1324: );
1325: END validate_row;
1326:
1327: -------------------------------------------------------
1328: -- PL/SQL TBL validate_row for:OKL_POOL_TRANSACTIONS_V --
1329: -------------------------------------------------------
1330: PROCEDURE validate_row(
1331: p_api_version IN NUMBER,
1332: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1393: -- insert_row for:okl_pool_transactions --

1389: ---------------------------------------------------------------------------
1390: -- PROCEDURE insert_row
1391: ---------------------------------------------------------------------------
1392: ----------------------------------------
1393: -- insert_row for:okl_pool_transactions --
1394: ----------------------------------------
1395: PROCEDURE insert_row(
1396: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1397: x_return_status OUT NOCOPY VARCHAR2,

Line 1409: -- Set_Attributes for:okl_pool_transactions --

1405: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1406: l_pox_rec pox_rec_type := p_pox_rec;
1407: l_def_pox_rec pox_rec_type;
1408: --------------------------------------------
1409: -- Set_Attributes for:okl_pool_transactions --
1410: --------------------------------------------
1411: FUNCTION Set_Attributes (
1412: p_pox_rec IN pox_rec_type,
1413: x_pox_rec OUT NOCOPY pox_rec_type

Line 1440: INSERT INTO okl_pool_transactions(

1436: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1437: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1438: RAISE OKL_API.G_EXCEPTION_ERROR;
1439: END IF;
1440: INSERT INTO okl_pool_transactions(
1441: ID,
1442: OBJECT_VERSION_NUMBER,
1443: POL_ID,
1444: TRANSACTION_NUMBER,

Line 1559: -- insert_row for :OKL_POOL_TRANSACTIONS_V --

1555: '_PVT'
1556: );
1557: END insert_row;
1558: -------------------------------------------
1559: -- insert_row for :OKL_POOL_TRANSACTIONS_V --
1560: -------------------------------------------
1561: PROCEDURE insert_row(
1562: p_api_version IN NUMBER,
1563: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1593: -- Set_Attributes for:OKL_POOL_TRANSACTIONS_V --

1589: l_poxv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1590: RETURN(l_poxv_rec);
1591: END fill_who_columns;
1592: ----------------------------------------------
1593: -- Set_Attributes for:OKL_POOL_TRANSACTIONS_V --
1594: ----------------------------------------------
1595: FUNCTION Set_Attributes (
1596: p_poxv_rec IN poxv_rec_type,
1597: x_poxv_rec OUT NOCOPY poxv_rec_type

Line 1881: -- lock_row for:okl_pool_transactions --

1877: ---------------------------------------------------------------------------
1878: -- PROCEDURE lock_row
1879: ---------------------------------------------------------------------------
1880: --------------------------------------
1881: -- lock_row for:okl_pool_transactions --
1882: --------------------------------------
1883: PROCEDURE lock_row(
1884: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1885: x_return_status OUT NOCOPY VARCHAR2,

Line 1894: FROM okl_pool_transactions

1890: E_Resource_Busy EXCEPTION;
1891: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1892: CURSOR lock_csr (p_pox_rec IN pox_rec_type) IS
1893: SELECT OBJECT_VERSION_NUMBER
1894: FROM okl_pool_transactions
1895: WHERE ID = p_pox_rec.id
1896: AND OBJECT_VERSION_NUMBER = p_pox_rec.object_version_number
1897: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1898:

Line 1901: FROM okl_pool_transactions

1897: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1898:
1899: CURSOR lchk_csr (p_pox_rec IN pox_rec_type) IS
1900: SELECT OBJECT_VERSION_NUMBER
1901: FROM okl_pool_transactions
1902: WHERE ID = p_pox_rec.id;
1903: l_api_version CONSTANT NUMBER := 1;
1904: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1905: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 1906: l_object_version_number okl_pool_transactions.OBJECT_VERSION_NUMBER%TYPE;

1902: WHERE ID = p_pox_rec.id;
1903: l_api_version CONSTANT NUMBER := 1;
1904: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1905: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1906: l_object_version_number okl_pool_transactions.OBJECT_VERSION_NUMBER%TYPE;
1907: lc_object_version_number okl_pool_transactions.OBJECT_VERSION_NUMBER%TYPE;
1908: l_row_notfound BOOLEAN := FALSE;
1909: lc_row_notfound BOOLEAN := FALSE;
1910: BEGIN

Line 1907: lc_object_version_number okl_pool_transactions.OBJECT_VERSION_NUMBER%TYPE;

1903: l_api_version CONSTANT NUMBER := 1;
1904: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1905: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1906: l_object_version_number okl_pool_transactions.OBJECT_VERSION_NUMBER%TYPE;
1907: lc_object_version_number okl_pool_transactions.OBJECT_VERSION_NUMBER%TYPE;
1908: l_row_notfound BOOLEAN := FALSE;
1909: lc_row_notfound BOOLEAN := FALSE;
1910: BEGIN
1911: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 1988: -- lock_row for: OKL_POOL_TRANSACTIONS_V --

1984: '_PVT'
1985: );
1986: END lock_row;
1987: -----------------------------------------
1988: -- lock_row for: OKL_POOL_TRANSACTIONS_V --
1989: -----------------------------------------
1990: PROCEDURE lock_row(
1991: p_api_version IN NUMBER,
1992: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2228: -- update_row for:okl_pool_transactions --

2224: ---------------------------------------------------------------------------
2225: -- PROCEDURE update_row
2226: ---------------------------------------------------------------------------
2227: ----------------------------------------
2228: -- update_row for:okl_pool_transactions --
2229: ----------------------------------------
2230: PROCEDURE update_row(
2231: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2232: x_return_status OUT NOCOPY VARCHAR2,

Line 2424: -- Set_Attributes for:okl_pool_transactions --

2420: END IF;
2421: RETURN(l_return_status);
2422: END populate_new_record;
2423: --------------------------------------------
2424: -- Set_Attributes for:okl_pool_transactions --
2425: --------------------------------------------
2426: FUNCTION Set_Attributes (
2427: p_pox_rec IN pox_rec_type,
2428: x_pox_rec OUT NOCOPY pox_rec_type

Line 2462: UPDATE okl_pool_transactions

2458: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2459: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2460: RAISE OKL_API.G_EXCEPTION_ERROR;
2461: END IF;
2462: UPDATE okl_pool_transactions
2463: SET OBJECT_VERSION_NUMBER = l_def_pox_rec.object_version_number,
2464: POL_ID = l_def_pox_rec.pol_id,
2465: transaction_number = l_def_pox_rec.transaction_number,
2466: transaction_date = l_def_pox_rec.transaction_date,

Line 2540: -- update_row for:OKL_POOL_TRANSACTIONS_V --

2536: '_PVT'
2537: );
2538: END update_row;
2539: ------------------------------------------
2540: -- update_row for:OKL_POOL_TRANSACTIONS_V --
2541: ------------------------------------------
2542: PROCEDURE update_row(
2543: p_api_version IN NUMBER,
2544: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2752: -- Set_Attributes for:OKL_POOL_TRANSACTIONS_V --

2748: END IF;
2749: RETURN(l_return_status);
2750: END populate_new_record;
2751: ----------------------------------------------
2752: -- Set_Attributes for:OKL_POOL_TRANSACTIONS_V --
2753: ----------------------------------------------
2754: FUNCTION Set_Attributes (
2755: p_poxv_rec IN poxv_rec_type,
2756: x_poxv_rec OUT NOCOPY poxv_rec_type

Line 3047: -- delete_row for:okl_pool_transactions --

3043: ---------------------------------------------------------------------------
3044: -- PROCEDURE delete_row
3045: ---------------------------------------------------------------------------
3046: ----------------------------------------
3047: -- delete_row for:okl_pool_transactions --
3048: ----------------------------------------
3049: PROCEDURE delete_row(
3050: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
3051: x_return_status OUT NOCOPY VARCHAR2,

Line 3072: DELETE FROM okl_pool_transactions

3068: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3069: RAISE OKL_API.G_EXCEPTION_ERROR;
3070: END IF;
3071:
3072: DELETE FROM okl_pool_transactions
3073: WHERE ID = p_pox_rec.id;
3074:
3075: x_return_status := l_return_status;
3076: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 3110: -- delete_row for:OKL_POOL_TRANSACTIONS_V --

3106: '_PVT'
3107: );
3108: END delete_row;
3109: ------------------------------------------
3110: -- delete_row for:OKL_POOL_TRANSACTIONS_V --
3111: ------------------------------------------
3112: PROCEDURE delete_row(
3113: p_api_version IN NUMBER,
3114: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 3192: -- PL/SQL TBL delete_row for:OKL_POOL_TRANSACTIONS_V --

3188: '_PVT'
3189: );
3190: END delete_row;
3191: -----------------------------------------------------
3192: -- PL/SQL TBL delete_row for:OKL_POOL_TRANSACTIONS_V --
3193: -----------------------------------------------------
3194: PROCEDURE delete_row(
3195: p_api_version IN NUMBER,
3196: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 3288: -- PL/SQL TBL delete_row for:OKL_POOL_TRANSACTIONS_V --

3284: );
3285: END delete_row;
3286:
3287: -----------------------------------------------------
3288: -- PL/SQL TBL delete_row for:OKL_POOL_TRANSACTIONS_V --
3289: -----------------------------------------------------
3290: PROCEDURE delete_row(
3291: p_api_version IN NUMBER,
3292: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,