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_ASD_PVT dependencies on OKL_TXD_ASSETS_B

Line 786: FROM OKL_TXD_ASSETS_B B --fixed bug 3321017 by kmotepal

782: BEGIN
783: DELETE FROM OKL_TXD_ASSETS_TL T
784: WHERE NOT EXISTS (
785: SELECT NULL
786: FROM OKL_TXD_ASSETS_B B --fixed bug 3321017 by kmotepal
787: WHERE B.ID = T.ID
788: );
789:
790: UPDATE OKL_TXD_ASSETS_TL T SET (

Line 897: FROM Okl_Txd_Assets_b txd

893: CURRENCY_CONVERSION_TYPE,
894: CURRENCY_CONVERSION_RATE,
895: CURRENCY_CONVERSION_DATE
896: -- Multi-Currency changes
897: FROM Okl_Txd_Assets_b txd
898: WHERE txd.id = p_id;
899: l_asd_pk asd_pk_csr%ROWTYPE;
900: l_asd_rec asd_rec_type;
901: BEGIN

Line 1666: -- insert_row for:OKL_TXD_ASSETS_B --

1662: ---------------------------------------------------------------------------
1663: -- PROCEDURE insert_row
1664: ---------------------------------------------------------------------------
1665: -----------------------------------
1666: -- insert_row for:OKL_TXD_ASSETS_B --
1667: -----------------------------------
1668: PROCEDURE insert_row(
1669: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1670: x_return_status OUT NOCOPY VARCHAR2,

Line 1682: -- Set_Attributes for:OKL_TXD_ASSETS_B --

1678: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1679: l_asd_rec asd_rec_type := p_asd_rec;
1680: l_def_asd_rec asd_rec_type;
1681: ---------------------------------------
1682: -- Set_Attributes for:OKL_TXD_ASSETS_B --
1683: ---------------------------------------
1684: FUNCTION Set_Attributes (
1685: p_asd_rec IN asd_rec_type,
1686: x_asd_rec OUT NOCOPY asd_rec_type

Line 1713: INSERT INTO OKL_TXD_ASSETS_B(

1709: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1710: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1711: RAISE OKC_API.G_EXCEPTION_ERROR;
1712: END IF;
1713: INSERT INTO OKL_TXD_ASSETS_B(
1714: id,
1715: object_version_number,
1716: tal_id,
1717: target_kle_id,

Line 2232: -- lock_row for:OKL_TXD_ASSETS_B --

2228: ---------------------------------------------------------------------------
2229: -- PROCEDURE lock_row
2230: ---------------------------------------------------------------------------
2231: ---------------------------------
2232: -- lock_row for:OKL_TXD_ASSETS_B --
2233: ---------------------------------
2234: PROCEDURE lock_row(
2235: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2236: x_return_status OUT NOCOPY VARCHAR2,

Line 2245: FROM OKL_TXD_ASSETS_B

2241: E_Resource_Busy EXCEPTION;
2242: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2243: CURSOR lock_csr (p_asd_rec IN asd_rec_type) IS
2244: SELECT OBJECT_VERSION_NUMBER
2245: FROM OKL_TXD_ASSETS_B
2246: WHERE ID = p_asd_rec.id
2247: AND OBJECT_VERSION_NUMBER = p_asd_rec.object_version_number
2248: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2249:

Line 2252: FROM OKL_TXD_ASSETS_B

2248: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2249:
2250: CURSOR lchk_csr (p_asd_rec IN asd_rec_type) IS
2251: SELECT OBJECT_VERSION_NUMBER
2252: FROM OKL_TXD_ASSETS_B
2253: WHERE ID = p_asd_rec.id;
2254: l_api_version CONSTANT NUMBER := 1;
2255: l_api_name CONSTANT VARCHAR2(30) := 'ASSETS_lock_row';
2256: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2257: l_object_version_number OKL_TXD_ASSETS_B.OBJECT_VERSION_NUMBER%TYPE;

2253: WHERE ID = p_asd_rec.id;
2254: l_api_version CONSTANT NUMBER := 1;
2255: l_api_name CONSTANT VARCHAR2(30) := 'ASSETS_lock_row';
2256: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2257: l_object_version_number OKL_TXD_ASSETS_B.OBJECT_VERSION_NUMBER%TYPE;
2258: lc_object_version_number OKL_TXD_ASSETS_B.OBJECT_VERSION_NUMBER%TYPE;
2259: l_row_notfound BOOLEAN := FALSE;
2260: lc_row_notfound BOOLEAN := FALSE;
2261: BEGIN

Line 2258: lc_object_version_number OKL_TXD_ASSETS_B.OBJECT_VERSION_NUMBER%TYPE;

2254: l_api_version CONSTANT NUMBER := 1;
2255: l_api_name CONSTANT VARCHAR2(30) := 'ASSETS_lock_row';
2256: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2257: l_object_version_number OKL_TXD_ASSETS_B.OBJECT_VERSION_NUMBER%TYPE;
2258: lc_object_version_number OKL_TXD_ASSETS_B.OBJECT_VERSION_NUMBER%TYPE;
2259: l_row_notfound BOOLEAN := FALSE;
2260: lc_row_notfound BOOLEAN := FALSE;
2261: BEGIN
2262: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2585: -- update_row for:OKL_TXD_ASSETS_B --

2581: ---------------------------------------------------------------------------
2582: -- PROCEDURE update_row
2583: ---------------------------------------------------------------------------
2584: -----------------------------------
2585: -- update_row for:OKL_TXD_ASSETS_B --
2586: -----------------------------------
2587: PROCEDURE update_row(
2588: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2589: x_return_status OUT NOCOPY VARCHAR2,

Line 2787: -- Set_Attributes for:OKL_TXD_ASSETS_B --

2783: -- Multi Currency Change
2784: RETURN(l_return_status);
2785: END populate_new_record;
2786: ---------------------------------------
2787: -- Set_Attributes for:OKL_TXD_ASSETS_B --
2788: ---------------------------------------
2789: FUNCTION Set_Attributes (
2790: p_asd_rec IN asd_rec_type,
2791: x_asd_rec OUT NOCOPY asd_rec_type

Line 2824: UPDATE OKL_TXD_ASSETS_B

2820: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2821: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2822: RAISE OKC_API.G_EXCEPTION_ERROR;
2823: END IF;
2824: UPDATE OKL_TXD_ASSETS_B
2825: SET OBJECT_VERSION_NUMBER = l_def_asd_rec.object_version_number,
2826: TAL_ID = l_def_asd_rec.tal_id,
2827: TARGET_KLE_ID = l_def_asd_rec.target_kle_id,
2828: LINE_DETAIL_NUMBER = l_def_asd_rec.line_detail_number,

Line 3564: -- delete_row for:OKL_TXD_ASSETS_B --

3560: ---------------------------------------------------------------------------
3561: -- PROCEDURE delete_row
3562: ---------------------------------------------------------------------------
3563: -----------------------------------
3564: -- delete_row for:OKL_TXD_ASSETS_B --
3565: -----------------------------------
3566: PROCEDURE delete_row(
3567: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3568: x_return_status OUT NOCOPY VARCHAR2,

Line 3588: DELETE FROM OKL_TXD_ASSETS_B

3584: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3585: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3586: RAISE OKC_API.G_EXCEPTION_ERROR;
3587: END IF;
3588: DELETE FROM OKL_TXD_ASSETS_B
3589: WHERE ID = l_asd_rec.id;
3590:
3591: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3592: EXCEPTION