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.OKS_BTN_PRINT_PREVIEW_PVT dependencies on FND_CURRENCIES

Line 413: CURSOR fnd_currencies_pk_csr (p_currency_code IN VARCHAR2) IS

409: p_btn_pr_rec IN btn_pr_rec_type,
410: p_db_btn_pr_rec IN btn_pr_rec_type
411: ) RETURN VARCHAR2 IS
412: item_not_found_error EXCEPTION;
413: CURSOR fnd_currencies_pk_csr (p_currency_code IN VARCHAR2) IS
414: SELECT 'x'
415: FROM Fnd_Currencies
416: WHERE fnd_currencies.currency_code = p_currency_code;
417: l_fnd_currencies_pk fnd_currencies_pk_csr%ROWTYPE;

Line 415: FROM Fnd_Currencies

411: ) RETURN VARCHAR2 IS
412: item_not_found_error EXCEPTION;
413: CURSOR fnd_currencies_pk_csr (p_currency_code IN VARCHAR2) IS
414: SELECT 'x'
415: FROM Fnd_Currencies
416: WHERE fnd_currencies.currency_code = p_currency_code;
417: l_fnd_currencies_pk fnd_currencies_pk_csr%ROWTYPE;
418:
419: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 416: WHERE fnd_currencies.currency_code = p_currency_code;

412: item_not_found_error EXCEPTION;
413: CURSOR fnd_currencies_pk_csr (p_currency_code IN VARCHAR2) IS
414: SELECT 'x'
415: FROM Fnd_Currencies
416: WHERE fnd_currencies.currency_code = p_currency_code;
417: l_fnd_currencies_pk fnd_currencies_pk_csr%ROWTYPE;
418:
419: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
420: l_row_notfound BOOLEAN := TRUE;

Line 417: l_fnd_currencies_pk fnd_currencies_pk_csr%ROWTYPE;

413: CURSOR fnd_currencies_pk_csr (p_currency_code IN VARCHAR2) IS
414: SELECT 'x'
415: FROM Fnd_Currencies
416: WHERE fnd_currencies.currency_code = p_currency_code;
417: l_fnd_currencies_pk fnd_currencies_pk_csr%ROWTYPE;
418:
419: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
420: l_row_notfound BOOLEAN := TRUE;
421: BEGIN

Line 426: OPEN fnd_currencies_pk_csr (p_btn_pr_rec.CURRENCY_CODE);

422: IF ((p_btn_pr_rec.CURRENCY_CODE IS NOT NULL)
423: AND
424: (p_btn_pr_rec.CURRENCY_CODE <> p_db_btn_pr_rec.CURRENCY_CODE))
425: THEN
426: OPEN fnd_currencies_pk_csr (p_btn_pr_rec.CURRENCY_CODE);
427: FETCH fnd_currencies_pk_csr INTO l_fnd_currencies_pk;
428: l_row_notfound := fnd_currencies_pk_csr%NOTFOUND;
429: CLOSE fnd_currencies_pk_csr;
430: IF (l_row_notfound) THEN

Line 427: FETCH fnd_currencies_pk_csr INTO l_fnd_currencies_pk;

423: AND
424: (p_btn_pr_rec.CURRENCY_CODE <> p_db_btn_pr_rec.CURRENCY_CODE))
425: THEN
426: OPEN fnd_currencies_pk_csr (p_btn_pr_rec.CURRENCY_CODE);
427: FETCH fnd_currencies_pk_csr INTO l_fnd_currencies_pk;
428: l_row_notfound := fnd_currencies_pk_csr%NOTFOUND;
429: CLOSE fnd_currencies_pk_csr;
430: IF (l_row_notfound) THEN
431: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CURRENCY_CODE');

Line 428: l_row_notfound := fnd_currencies_pk_csr%NOTFOUND;

424: (p_btn_pr_rec.CURRENCY_CODE <> p_db_btn_pr_rec.CURRENCY_CODE))
425: THEN
426: OPEN fnd_currencies_pk_csr (p_btn_pr_rec.CURRENCY_CODE);
427: FETCH fnd_currencies_pk_csr INTO l_fnd_currencies_pk;
428: l_row_notfound := fnd_currencies_pk_csr%NOTFOUND;
429: CLOSE fnd_currencies_pk_csr;
430: IF (l_row_notfound) THEN
431: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CURRENCY_CODE');
432: RAISE item_not_found_error;

Line 429: CLOSE fnd_currencies_pk_csr;

425: THEN
426: OPEN fnd_currencies_pk_csr (p_btn_pr_rec.CURRENCY_CODE);
427: FETCH fnd_currencies_pk_csr INTO l_fnd_currencies_pk;
428: l_row_notfound := fnd_currencies_pk_csr%NOTFOUND;
429: CLOSE fnd_currencies_pk_csr;
430: IF (l_row_notfound) THEN
431: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CURRENCY_CODE');
432: RAISE item_not_found_error;
433: END IF;