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_BTC_PVT dependencies on OKL_TRX_CSH_BATCH_B

Line 107: -- FUNCTION get_rec for: OKL_TRX_CSH_BATCH_B

103:
104: END add_language;
105:
106: ---------------------------------------------------------------------------
107: -- FUNCTION get_rec for: OKL_TRX_CSH_BATCH_B
108: ---------------------------------------------------------------------------
109: FUNCTION get_rec (
110: p_btc_rec IN btc_rec_type,
111: x_no_data_found OUT NOCOPY BOOLEAN

Line 154: FROM Okl_Trx_Csh_Batch_B

150: CURRENCY_CONVERSION_TYPE,
151: CURRENCY_CONVERSION_RATE,
152: CURRENCY_CONVERSION_DATE,
153: REMIT_BANK_ID
154: FROM Okl_Trx_Csh_Batch_B
155: WHERE okl_trx_csh_batch_b.id = p_id;
156: l_btc_pk btc_pk_csr%ROWTYPE;
157: l_btc_rec btc_rec_type;
158: BEGIN

Line 155: WHERE okl_trx_csh_batch_b.id = p_id;

151: CURRENCY_CONVERSION_RATE,
152: CURRENCY_CONVERSION_DATE,
153: REMIT_BANK_ID
154: FROM Okl_Trx_Csh_Batch_B
155: WHERE okl_trx_csh_batch_b.id = p_id;
156: l_btc_pk btc_pk_csr%ROWTYPE;
157: l_btc_rec btc_rec_type;
158: BEGIN
159: x_no_data_found := TRUE;

Line 1335: -- insert_row for:OKL_TRX_CSH_BATCH_B --

1331: ---------------------------------------------------------------------------
1332: -- PROCEDURE insert_row
1333: ---------------------------------------------------------------------------
1334: ----------------------------------------
1335: -- insert_row for:OKL_TRX_CSH_BATCH_B --
1336: ----------------------------------------
1337: PROCEDURE insert_row(
1338: p_init_msg_list IN VARCHAR2,
1339: x_return_status OUT NOCOPY VARCHAR2,

Line 1351: -- Set_Attributes for:OKL_TRX_CSH_BATCH_B --

1347: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1348: l_btc_rec btc_rec_type := p_btc_rec;
1349: l_def_btc_rec btc_rec_type;
1350: --------------------------------------------
1351: -- Set_Attributes for:OKL_TRX_CSH_BATCH_B --
1352: --------------------------------------------
1353: FUNCTION Set_Attributes (
1354: p_btc_rec IN btc_rec_type,
1355: x_btc_rec OUT NOCOPY btc_rec_type

Line 1383: INSERT INTO OKL_TRX_CSH_BATCH_B(

1379: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1380: RAISE Okl_Api.G_EXCEPTION_ERROR;
1381: END IF;
1382:
1383: INSERT INTO OKL_TRX_CSH_BATCH_B(
1384: id,
1385: object_version_number,
1386: date_entered,
1387: date_gl_requested,

Line 1892: -- lock_row for:OKL_TRX_CSH_BATCH_B --

1888: ---------------------------------------------------------------------------
1889: -- PROCEDURE lock_row
1890: ---------------------------------------------------------------------------
1891: --------------------------------------
1892: -- lock_row for:OKL_TRX_CSH_BATCH_B --
1893: --------------------------------------
1894: PROCEDURE lock_row(
1895: p_init_msg_list IN VARCHAR2,
1896: x_return_status OUT NOCOPY VARCHAR2,

Line 1905: FROM OKL_TRX_CSH_BATCH_B

1901: E_Resource_Busy EXCEPTION;
1902: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1903: CURSOR lock_csr (p_btc_rec IN btc_rec_type) IS
1904: SELECT OBJECT_VERSION_NUMBER
1905: FROM OKL_TRX_CSH_BATCH_B
1906: WHERE ID = p_btc_rec.id
1907: AND OBJECT_VERSION_NUMBER = p_btc_rec.object_version_number
1908: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1909:

Line 1912: FROM OKL_TRX_CSH_BATCH_B

1908: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1909:
1910: CURSOR lchk_csr (p_btc_rec IN btc_rec_type) IS
1911: SELECT OBJECT_VERSION_NUMBER
1912: FROM OKL_TRX_CSH_BATCH_B
1913: WHERE ID = p_btc_rec.id;
1914: l_api_version CONSTANT NUMBER := 1;
1915: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1916: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 1917: l_object_version_number OKL_TRX_CSH_BATCH_B.OBJECT_VERSION_NUMBER%TYPE;

1913: WHERE ID = p_btc_rec.id;
1914: l_api_version CONSTANT NUMBER := 1;
1915: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1916: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1917: l_object_version_number OKL_TRX_CSH_BATCH_B.OBJECT_VERSION_NUMBER%TYPE;
1918: lc_object_version_number OKL_TRX_CSH_BATCH_B.OBJECT_VERSION_NUMBER%TYPE;
1919: l_row_notfound BOOLEAN := FALSE;
1920: lc_row_notfound BOOLEAN := FALSE;
1921: BEGIN

Line 1918: lc_object_version_number OKL_TRX_CSH_BATCH_B.OBJECT_VERSION_NUMBER%TYPE;

1914: l_api_version CONSTANT NUMBER := 1;
1915: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1916: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1917: l_object_version_number OKL_TRX_CSH_BATCH_B.OBJECT_VERSION_NUMBER%TYPE;
1918: lc_object_version_number OKL_TRX_CSH_BATCH_B.OBJECT_VERSION_NUMBER%TYPE;
1919: l_row_notfound BOOLEAN := FALSE;
1920: lc_row_notfound BOOLEAN := FALSE;
1921: BEGIN
1922: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

Line 2266: -- update_row for:OKL_TRX_CSH_BATCH_B --

2262: ---------------------------------------------------------------------------
2263: -- PROCEDURE update_row
2264: ---------------------------------------------------------------------------
2265: ----------------------------------------
2266: -- update_row for:OKL_TRX_CSH_BATCH_B --
2267: ----------------------------------------
2268: PROCEDURE update_row(
2269: p_init_msg_list IN VARCHAR2,
2270: x_return_status OUT NOCOPY VARCHAR2,

Line 2466: -- Set_Attributes for:OKL_TRX_CSH_BATCH_B --

2462:
2463: RETURN(l_return_status);
2464: END populate_new_record;
2465: --------------------------------------------
2466: -- Set_Attributes for:OKL_TRX_CSH_BATCH_B --
2467: --------------------------------------------
2468: FUNCTION Set_Attributes (
2469: p_btc_rec IN btc_rec_type,
2470: x_btc_rec OUT NOCOPY btc_rec_type

Line 2503: UPDATE OKL_TRX_CSH_BATCH_B

2499: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2500: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2501: RAISE Okl_Api.G_EXCEPTION_ERROR;
2502: END IF;
2503: UPDATE OKL_TRX_CSH_BATCH_B
2504: SET OBJECT_VERSION_NUMBER = l_def_btc_rec.object_version_number,
2505: DATE_ENTERED = l_def_btc_rec.date_entered,
2506: DATE_GL_REQUESTED = l_def_btc_rec.date_gl_requested,
2507: DATE_DEPOSIT = l_def_btc_rec.date_deposit,

Line 3201: -- delete_row for:OKL_TRX_CSH_BATCH_B --

3197: ---------------------------------------------------------------------------
3198: -- PROCEDURE delete_row
3199: ---------------------------------------------------------------------------
3200: ----------------------------------------
3201: -- delete_row for:OKL_TRX_CSH_BATCH_B --
3202: ----------------------------------------
3203: PROCEDURE delete_row(
3204: p_init_msg_list IN VARCHAR2,
3205: x_return_status OUT NOCOPY VARCHAR2,

Line 3225: DELETE FROM OKL_TRX_CSH_BATCH_B

3221: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3222: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3223: RAISE Okl_Api.G_EXCEPTION_ERROR;
3224: END IF;
3225: DELETE FROM OKL_TRX_CSH_BATCH_B
3226: WHERE ID = l_btc_rec.id;
3227:
3228: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3229: EXCEPTION