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_TLD_PVT dependencies on OKL_TXD_AR_LN_DTLS_B

Line 433: FROM OKL_TXD_AR_LN_DTLS_B

429: l_dummy_var VARCHAR2(1) := '0';
430:
431: CURSOR l_tld_id_reverses_csr IS
432: SELECT '1'
433: FROM OKL_TXD_AR_LN_DTLS_B
434: WHERE id = p_tldv_rec.tld_id_reverses;
435:
436:
437: BEGIN

Line 468: SELECT OKL_TXD_AR_LN_DTLS_B_S.NEXTVAL

464: ---------------------------------------------------------------------------
465: -- start: cklee 03/13/07
466: FUNCTION get_seq_id RETURN NUMBER IS
467: cursor c_seq is
468: SELECT OKL_TXD_AR_LN_DTLS_B_S.NEXTVAL
469: FROM dual;
470: l_seq number;
471: BEGIN
472: -- RETURN(Okc_P_Util.raw_to_number(sys_guid()));

Line 512: FROM OKL_TXD_AR_LN_DTLS_B B

508: BEGIN
509: DELETE FROM OKL_TXD_AR_LN_DTLS_TL T
510: WHERE NOT EXISTS (
511: SELECT NULL
512: FROM OKL_TXD_AR_LN_DTLS_B B
513: WHERE B.ID = T.ID
514: AND T.LANGUAGE = USERENV('LANG')
515: );
516:

Line 574: -- FUNCTION get_rec for: OKL_TXD_AR_LN_DTLS_B

570:
571: END add_language;
572:
573: ---------------------------------------------------------------------------
574: -- FUNCTION get_rec for: OKL_TXD_AR_LN_DTLS_B
575: ---------------------------------------------------------------------------
576: FUNCTION get_rec (
577: p_tld_rec IN tld_rec_type,
578: x_no_data_found OUT NOCOPY BOOLEAN

Line 580: CURSOR okl_txd_ar_ln_dtls_b_pk_csr (p_id IN NUMBER) IS

576: FUNCTION get_rec (
577: p_tld_rec IN tld_rec_type,
578: x_no_data_found OUT NOCOPY BOOLEAN
579: ) RETURN tld_rec_type IS
580: CURSOR okl_txd_ar_ln_dtls_b_pk_csr (p_id IN NUMBER) IS
581: SELECT
582: ID,
583: BCH_ID,
584: BCL_ID,

Line 651: FROM Okl_Txd_Ar_Ln_Dtls_B

647: CREATION_DATE,
648: LAST_UPDATED_BY,
649: LAST_UPDATE_DATE,
650: LAST_UPDATE_LOGIN
651: FROM Okl_Txd_Ar_Ln_Dtls_B
652: WHERE okl_txd_ar_ln_dtls_b.id = p_id;
653: l_okl_txd_ar_ln_dtls_b_pk okl_txd_ar_ln_dtls_b_pk_csr%ROWTYPE;
654: l_tld_rec tld_rec_type;
655: BEGIN

Line 652: WHERE okl_txd_ar_ln_dtls_b.id = p_id;

648: LAST_UPDATED_BY,
649: LAST_UPDATE_DATE,
650: LAST_UPDATE_LOGIN
651: FROM Okl_Txd_Ar_Ln_Dtls_B
652: WHERE okl_txd_ar_ln_dtls_b.id = p_id;
653: l_okl_txd_ar_ln_dtls_b_pk okl_txd_ar_ln_dtls_b_pk_csr%ROWTYPE;
654: l_tld_rec tld_rec_type;
655: BEGIN
656: x_no_data_found := TRUE;

Line 653: l_okl_txd_ar_ln_dtls_b_pk okl_txd_ar_ln_dtls_b_pk_csr%ROWTYPE;

649: LAST_UPDATE_DATE,
650: LAST_UPDATE_LOGIN
651: FROM Okl_Txd_Ar_Ln_Dtls_B
652: WHERE okl_txd_ar_ln_dtls_b.id = p_id;
653: l_okl_txd_ar_ln_dtls_b_pk okl_txd_ar_ln_dtls_b_pk_csr%ROWTYPE;
654: l_tld_rec tld_rec_type;
655: BEGIN
656: x_no_data_found := TRUE;
657: -- Get current database values

Line 658: OPEN okl_txd_ar_ln_dtls_b_pk_csr (p_tld_rec.id);

654: l_tld_rec tld_rec_type;
655: BEGIN
656: x_no_data_found := TRUE;
657: -- Get current database values
658: OPEN okl_txd_ar_ln_dtls_b_pk_csr (p_tld_rec.id);
659: FETCH okl_txd_ar_ln_dtls_b_pk_csr INTO
660: l_tld_rec.ID,
661: l_tld_rec.BCH_ID,
662: l_tld_rec.BCL_ID,

Line 659: FETCH okl_txd_ar_ln_dtls_b_pk_csr INTO

655: BEGIN
656: x_no_data_found := TRUE;
657: -- Get current database values
658: OPEN okl_txd_ar_ln_dtls_b_pk_csr (p_tld_rec.id);
659: FETCH okl_txd_ar_ln_dtls_b_pk_csr INTO
660: l_tld_rec.ID,
661: l_tld_rec.BCH_ID,
662: l_tld_rec.BCL_ID,
663: l_tld_rec.BSL_ID,

Line 729: x_no_data_found := okl_txd_ar_ln_dtls_b_pk_csr%NOTFOUND;

725: l_tld_rec.CREATION_DATE,
726: l_tld_rec.LAST_UPDATED_BY,
727: l_tld_rec.LAST_UPDATE_DATE,
728: l_tld_rec.LAST_UPDATE_LOGIN;
729: x_no_data_found := okl_txd_ar_ln_dtls_b_pk_csr%NOTFOUND;
730: CLOSE okl_txd_ar_ln_dtls_b_pk_csr;
731: RETURN(l_tld_rec);
732: END get_rec;
733:

Line 730: CLOSE okl_txd_ar_ln_dtls_b_pk_csr;

726: l_tld_rec.LAST_UPDATED_BY,
727: l_tld_rec.LAST_UPDATE_DATE,
728: l_tld_rec.LAST_UPDATE_LOGIN;
729: x_no_data_found := okl_txd_ar_ln_dtls_b_pk_csr%NOTFOUND;
730: CLOSE okl_txd_ar_ln_dtls_b_pk_csr;
731: RETURN(l_tld_rec);
732: END get_rec;
733:
734: FUNCTION get_rec (

Line 1730: -- insert_row for:OKL_TXD_AR_LN_DTLS_B --

1726: ---------------------------------------------------------------------------
1727: -- PROCEDURE insert_row
1728: ---------------------------------------------------------------------------
1729: -----------------------------------------
1730: -- insert_row for:OKL_TXD_AR_LN_DTLS_B --
1731: -----------------------------------------
1732: PROCEDURE insert_row(
1733: p_init_msg_list IN VARCHAR2,
1734: x_return_status OUT NOCOPY VARCHAR2,

Line 1746: -- Set_Attributes for:OKL_TXD_AR_LN_DTLS_B --

1742: l_return_status VARCHAR2(1) := Okl_api.G_RET_STS_SUCCESS;
1743: l_tld_rec tld_rec_type := p_tld_rec;
1744: l_def_tld_rec tld_rec_type;
1745: ---------------------------------------------
1746: -- Set_Attributes for:OKL_TXD_AR_LN_DTLS_B --
1747: ---------------------------------------------
1748: FUNCTION Set_Attributes (
1749: p_tld_rec IN tld_rec_type,
1750: x_tld_rec OUT NOCOPY tld_rec_type

Line 1777: INSERT INTO OKL_TXD_AR_LN_DTLS_B(

1773: RAISE Okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
1774: ELSIF (l_return_status = Okl_api.G_RET_STS_ERROR) THEN
1775: RAISE Okl_api.G_EXCEPTION_ERROR;
1776: END IF;
1777: INSERT INTO OKL_TXD_AR_LN_DTLS_B(
1778: id,
1779: bch_id,
1780: bcl_id,
1781: bsl_id,

Line 2333: -- lock_row for:OKL_TXD_AR_LN_DTLS_B --

2329: ---------------------------------------------------------------------------
2330: -- PROCEDURE lock_row
2331: ---------------------------------------------------------------------------
2332: ---------------------------------------
2333: -- lock_row for:OKL_TXD_AR_LN_DTLS_B --
2334: ---------------------------------------
2335: PROCEDURE lock_row(
2336: p_init_msg_list IN VARCHAR2,
2337: x_return_status OUT NOCOPY VARCHAR2,

Line 2346: FROM OKL_TXD_AR_LN_DTLS_B

2342: E_Resource_Busy EXCEPTION;
2343: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2344: CURSOR lock_csr (p_tld_rec IN tld_rec_type) IS
2345: SELECT OBJECT_VERSION_NUMBER
2346: FROM OKL_TXD_AR_LN_DTLS_B
2347: WHERE ID = p_tld_rec.id
2348: AND OBJECT_VERSION_NUMBER = p_tld_rec.object_version_number
2349: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2350:

Line 2353: FROM OKL_TXD_AR_LN_DTLS_B

2349: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2350:
2351: CURSOR lchk_csr (p_tld_rec IN tld_rec_type) IS
2352: SELECT OBJECT_VERSION_NUMBER
2353: FROM OKL_TXD_AR_LN_DTLS_B
2354: WHERE ID = p_tld_rec.id;
2355: l_api_version CONSTANT NUMBER := 1;
2356: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2357: l_return_status VARCHAR2(1) := Okl_api.G_RET_STS_SUCCESS;

Line 2358: l_object_version_number OKL_TXD_AR_LN_DTLS_B.OBJECT_VERSION_NUMBER%TYPE;

2354: WHERE ID = p_tld_rec.id;
2355: l_api_version CONSTANT NUMBER := 1;
2356: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2357: l_return_status VARCHAR2(1) := Okl_api.G_RET_STS_SUCCESS;
2358: l_object_version_number OKL_TXD_AR_LN_DTLS_B.OBJECT_VERSION_NUMBER%TYPE;
2359: lc_object_version_number OKL_TXD_AR_LN_DTLS_B.OBJECT_VERSION_NUMBER%TYPE;
2360: l_row_notfound BOOLEAN := FALSE;
2361: lc_row_notfound BOOLEAN := FALSE;
2362: BEGIN

Line 2359: lc_object_version_number OKL_TXD_AR_LN_DTLS_B.OBJECT_VERSION_NUMBER%TYPE;

2355: l_api_version CONSTANT NUMBER := 1;
2356: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2357: l_return_status VARCHAR2(1) := Okl_api.G_RET_STS_SUCCESS;
2358: l_object_version_number OKL_TXD_AR_LN_DTLS_B.OBJECT_VERSION_NUMBER%TYPE;
2359: lc_object_version_number OKL_TXD_AR_LN_DTLS_B.OBJECT_VERSION_NUMBER%TYPE;
2360: l_row_notfound BOOLEAN := FALSE;
2361: lc_row_notfound BOOLEAN := FALSE;
2362: BEGIN
2363: l_return_status := Okl_api.START_ACTIVITY(l_api_name,

Line 2702: -- update_row for:OKL_TXD_AR_LN_DTLS_B --

2698: ---------------------------------------------------------------------------
2699: -- PROCEDURE update_row
2700: ---------------------------------------------------------------------------
2701: -----------------------------------------
2702: -- update_row for:OKL_TXD_AR_LN_DTLS_B --
2703: -----------------------------------------
2704: PROCEDURE update_row(
2705: p_init_msg_list IN VARCHAR2,
2706: x_return_status OUT NOCOPY VARCHAR2,

Line 3002: -- Set_Attributes for:OKL_TXD_AR_LN_DTLS_B --

2998: END IF;
2999: RETURN(l_return_status);
3000: END populate_new_record;
3001: ---------------------------------------------
3002: -- Set_Attributes for:OKL_TXD_AR_LN_DTLS_B --
3003: ---------------------------------------------
3004: FUNCTION Set_Attributes (
3005: p_tld_rec IN tld_rec_type,
3006: x_tld_rec OUT NOCOPY tld_rec_type

Line 3039: UPDATE OKL_TXD_AR_LN_DTLS_B

3035: RAISE Okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
3036: ELSIF (l_return_status = Okl_api.G_RET_STS_ERROR) THEN
3037: RAISE Okl_api.G_EXCEPTION_ERROR;
3038: END IF;
3039: UPDATE OKL_TXD_AR_LN_DTLS_B
3040: SET BCH_ID = l_def_tld_rec.bch_id,
3041: BCL_ID = l_def_tld_rec.bcl_id,
3042: BSL_ID = l_def_tld_rec.bsl_id,
3043: BGH_ID = l_def_tld_rec.bgh_id,

Line 3882: -- delete_row for:OKL_TXD_AR_LN_DTLS_B --

3878: ---------------------------------------------------------------------------
3879: -- PROCEDURE delete_row
3880: ---------------------------------------------------------------------------
3881: -----------------------------------------
3882: -- delete_row for:OKL_TXD_AR_LN_DTLS_B --
3883: -----------------------------------------
3884: PROCEDURE delete_row(
3885: p_init_msg_list IN VARCHAR2,
3886: x_return_status OUT NOCOPY VARCHAR2,

Line 3906: DELETE FROM OKL_TXD_AR_LN_DTLS_B

3902: RAISE Okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
3903: ELSIF (l_return_status = Okl_api.G_RET_STS_ERROR) THEN
3904: RAISE Okl_api.G_EXCEPTION_ERROR;
3905: END IF;
3906: DELETE FROM OKL_TXD_AR_LN_DTLS_B
3907: WHERE ID = l_tld_rec.id;
3908:
3909: Okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
3910: EXCEPTION