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_TIL_PVT dependencies on OKL_TXL_AR_INV_LNS_B

Line 396: FROM OKL_TXL_AR_INV_LNS_B

392: l_dummy_var VARCHAR2(1) := '0';
393:
394: CURSOR l_til_id_reverses_csr IS
395: SELECT '1'
396: FROM OKL_TXL_AR_INV_LNS_B
397: WHERE id = p_tilv_rec.til_id_reverses;
398:
399:
400: BEGIN

Line 465: FROM OKL_TXL_AR_INV_LNS_B B

461: BEGIN
462: DELETE FROM OKL_TXL_AR_INV_LNS_TL T
463: WHERE NOT EXISTS (
464: SELECT NULL
465: FROM OKL_TXL_AR_INV_LNS_B B
466: WHERE B.ID = T.ID
467: AND T.LANGUAGE = USERENV('LANG')
468: );
469:

Line 527: -- FUNCTION get_rec for: OKL_TXL_AR_INV_LNS_B

523:
524: END add_language;
525:
526: ---------------------------------------------------------------------------
527: -- FUNCTION get_rec for: OKL_TXL_AR_INV_LNS_B
528: ---------------------------------------------------------------------------
529: FUNCTION get_rec (
530: p_til_rec IN til_rec_type,
531: x_no_data_found OUT NOCOPY BOOLEAN

Line 596: FROM Okl_Txl_Ar_Inv_Lns_B

592: TXS_TRX_LINE_ID
593: -- end: 30-Jan-07 cklee Billing R12 project |
594: ,TAX_LINE_ID --14-May-08 sechawla 6619311 : ADDED
595:
596: FROM Okl_Txl_Ar_Inv_Lns_B
597: WHERE okl_txl_ar_inv_lns_b.id = p_id;
598: l_til_pk til_pk_csr%ROWTYPE;
599: l_til_rec til_rec_type;
600: BEGIN

Line 597: WHERE okl_txl_ar_inv_lns_b.id = p_id;

593: -- end: 30-Jan-07 cklee Billing R12 project |
594: ,TAX_LINE_ID --14-May-08 sechawla 6619311 : ADDED
595:
596: FROM Okl_Txl_Ar_Inv_Lns_B
597: WHERE okl_txl_ar_inv_lns_b.id = p_id;
598: l_til_pk til_pk_csr%ROWTYPE;
599: l_til_rec til_rec_type;
600: BEGIN
601: x_no_data_found := TRUE;

Line 1600: -- insert_row for:OKL_TXL_AR_INV_LNS_B --

1596: ---------------------------------------------------------------------------
1597: -- PROCEDURE insert_row
1598: ---------------------------------------------------------------------------
1599: -----------------------------------------
1600: -- insert_row for:OKL_TXL_AR_INV_LNS_B --
1601: -----------------------------------------
1602: PROCEDURE insert_row(
1603: p_init_msg_list IN VARCHAR2,
1604: x_return_status OUT NOCOPY VARCHAR2,

Line 1616: -- Set_Attributes for:OKL_TXL_AR_INV_LNS_B --

1612: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1613: l_til_rec til_rec_type := p_til_rec;
1614: l_def_til_rec til_rec_type;
1615: ---------------------------------------------
1616: -- Set_Attributes for:OKL_TXL_AR_INV_LNS_B --
1617: ---------------------------------------------
1618: FUNCTION Set_Attributes (
1619: p_til_rec IN til_rec_type,
1620: x_til_rec OUT NOCOPY til_rec_type

Line 1647: INSERT INTO OKL_TXL_AR_INV_LNS_B(

1643: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1644: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1645: RAISE Okl_Api.G_EXCEPTION_ERROR;
1646: END IF;
1647: INSERT INTO OKL_TXL_AR_INV_LNS_B(
1648: id,
1649: inv_receiv_line_code,
1650: tai_id,
1651: kle_id,

Line 2230: -- lock_row for:OKL_TXL_AR_INV_LNS_B --

2226: ---------------------------------------------------------------------------
2227: -- PROCEDURE lock_row
2228: ---------------------------------------------------------------------------
2229: ---------------------------------------
2230: -- lock_row for:OKL_TXL_AR_INV_LNS_B --
2231: ---------------------------------------
2232: PROCEDURE lock_row(
2233: p_init_msg_list IN VARCHAR2,
2234: x_return_status OUT NOCOPY VARCHAR2,

Line 2243: FROM OKL_TXL_AR_INV_LNS_B

2239: E_Resource_Busy EXCEPTION;
2240: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2241: CURSOR lock_csr (p_til_rec IN til_rec_type) IS
2242: SELECT OBJECT_VERSION_NUMBER
2243: FROM OKL_TXL_AR_INV_LNS_B
2244: WHERE ID = p_til_rec.id
2245: AND OBJECT_VERSION_NUMBER = p_til_rec.object_version_number
2246: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2247:

Line 2250: FROM OKL_TXL_AR_INV_LNS_B

2246: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2247:
2248: CURSOR lchk_csr (p_til_rec IN til_rec_type) IS
2249: SELECT OBJECT_VERSION_NUMBER
2250: FROM OKL_TXL_AR_INV_LNS_B
2251: WHERE ID = p_til_rec.id;
2252: l_api_version CONSTANT NUMBER := 1;
2253: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2254: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 2255: l_object_version_number OKL_TXL_AR_INV_LNS_B.OBJECT_VERSION_NUMBER%TYPE;

2251: WHERE ID = p_til_rec.id;
2252: l_api_version CONSTANT NUMBER := 1;
2253: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2254: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2255: l_object_version_number OKL_TXL_AR_INV_LNS_B.OBJECT_VERSION_NUMBER%TYPE;
2256: lc_object_version_number OKL_TXL_AR_INV_LNS_B.OBJECT_VERSION_NUMBER%TYPE;
2257: l_row_notfound BOOLEAN := FALSE;
2258: lc_row_notfound BOOLEAN := FALSE;
2259: BEGIN

Line 2256: lc_object_version_number OKL_TXL_AR_INV_LNS_B.OBJECT_VERSION_NUMBER%TYPE;

2252: l_api_version CONSTANT NUMBER := 1;
2253: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2254: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2255: l_object_version_number OKL_TXL_AR_INV_LNS_B.OBJECT_VERSION_NUMBER%TYPE;
2256: lc_object_version_number OKL_TXL_AR_INV_LNS_B.OBJECT_VERSION_NUMBER%TYPE;
2257: l_row_notfound BOOLEAN := FALSE;
2258: lc_row_notfound BOOLEAN := FALSE;
2259: BEGIN
2260: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

Line 2639: -- update_row for:OKL_TXL_AR_INV_LNS_B --

2635: ---------------------------------------------------------------------------
2636: -- PROCEDURE update_row
2637: ---------------------------------------------------------------------------
2638: -----------------------------------------
2639: -- update_row for:OKL_TXL_AR_INV_LNS_B --
2640: -----------------------------------------
2641: PROCEDURE update_row(
2642: p_init_msg_list IN VARCHAR2,
2643: x_return_status OUT NOCOPY VARCHAR2,

Line 2904: -- Set_Attributes for:OKL_TXL_AR_INV_LNS_B --

2900:
2901: RETURN(l_return_status);
2902: END populate_new_record;
2903: ---------------------------------------------
2904: -- Set_Attributes for:OKL_TXL_AR_INV_LNS_B --
2905: ---------------------------------------------
2906: FUNCTION Set_Attributes (
2907: p_til_rec IN til_rec_type,
2908: x_til_rec OUT NOCOPY til_rec_type

Line 2948: UPDATE OKL_TXL_AR_INV_LNS_B

2944: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2945: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2946: RAISE Okl_Api.G_EXCEPTION_ERROR;
2947: END IF;
2948: UPDATE OKL_TXL_AR_INV_LNS_B
2949: SET INV_RECEIV_LINE_CODE = l_def_til_rec.inv_receiv_line_code,
2950: TAI_ID = l_def_til_rec.tai_id,
2951: KLE_ID = l_def_til_rec.kle_id,
2952: TPL_ID = l_def_til_rec.tpl_id,

Line 3788: -- delete_row for:OKL_TXL_AR_INV_LNS_B --

3784: ---------------------------------------------------------------------------
3785: -- PROCEDURE delete_row
3786: ---------------------------------------------------------------------------
3787: -----------------------------------------
3788: -- delete_row for:OKL_TXL_AR_INV_LNS_B --
3789: -----------------------------------------
3790: PROCEDURE delete_row(
3791: p_init_msg_list IN VARCHAR2,
3792: x_return_status OUT NOCOPY VARCHAR2,

Line 3812: DELETE FROM OKL_TXL_AR_INV_LNS_B

3808: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3809: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3810: RAISE Okl_Api.G_EXCEPTION_ERROR;
3811: END IF;
3812: DELETE FROM OKL_TXL_AR_INV_LNS_B
3813: WHERE ID = l_til_rec.id;
3814:
3815: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3816: EXCEPTION