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_ART_PVT dependencies on OKL_ASSET_RETURNS_B

Line 1701: -- FUNCTION get_rec for: OKL_ASSET_RETURNS_B

1697:
1698: END add_language;
1699:
1700: ---------------------------------------------------------------------------
1701: -- FUNCTION get_rec for: OKL_ASSET_RETURNS_B
1702: ---------------------------------------------------------------------------
1703: -- Start of comments
1704: --
1705: -- Function Name : get_rec

Line 1706: -- Description : for: OKL_ASSET_RETURNS_B

1702: ---------------------------------------------------------------------------
1703: -- Start of comments
1704: --
1705: -- Function Name : get_rec
1706: -- Description : for: OKL_ASSET_RETURNS_B
1707: -- Business Rules :
1708: -- Parameters :
1709: -- Version : 1.0
1710: -- History : RABHUPAT 16-DEC-2002 2667636

Line 1717: CURSOR okl_asset_returns_b_pk_csr (p_id IN NUMBER) IS

1713: FUNCTION get_rec (
1714: p_art_rec IN art_rec_type,
1715: x_no_data_found OUT NOCOPY BOOLEAN
1716: ) RETURN art_rec_type IS
1717: CURSOR okl_asset_returns_b_pk_csr (p_id IN NUMBER) IS
1718: SELECT
1719: ID,
1720: KLE_ID,
1721: SECURITY_DEP_TRX_AP_ID,

Line 1785: FROM Okl_Asset_Returns_B

1781: -- Legal Entity Changes End
1782: -- DJANASWA Loan Repossession proj start
1783: ASSET_FMV_AMOUNT
1784: -- Loan Repossession proj end
1785: FROM Okl_Asset_Returns_B
1786: WHERE okl_asset_returns_b.id = p_id;
1787: l_okl_asset_returns_b_pk okl_asset_returns_b_pk_csr%ROWTYPE;
1788: l_art_rec art_rec_type;
1789: BEGIN

Line 1786: WHERE okl_asset_returns_b.id = p_id;

1782: -- DJANASWA Loan Repossession proj start
1783: ASSET_FMV_AMOUNT
1784: -- Loan Repossession proj end
1785: FROM Okl_Asset_Returns_B
1786: WHERE okl_asset_returns_b.id = p_id;
1787: l_okl_asset_returns_b_pk okl_asset_returns_b_pk_csr%ROWTYPE;
1788: l_art_rec art_rec_type;
1789: BEGIN
1790: x_no_data_found := TRUE;

Line 1787: l_okl_asset_returns_b_pk okl_asset_returns_b_pk_csr%ROWTYPE;

1783: ASSET_FMV_AMOUNT
1784: -- Loan Repossession proj end
1785: FROM Okl_Asset_Returns_B
1786: WHERE okl_asset_returns_b.id = p_id;
1787: l_okl_asset_returns_b_pk okl_asset_returns_b_pk_csr%ROWTYPE;
1788: l_art_rec art_rec_type;
1789: BEGIN
1790: x_no_data_found := TRUE;
1791: -- Get current database values

Line 1792: OPEN okl_asset_returns_b_pk_csr (p_art_rec.id);

1788: l_art_rec art_rec_type;
1789: BEGIN
1790: x_no_data_found := TRUE;
1791: -- Get current database values
1792: OPEN okl_asset_returns_b_pk_csr (p_art_rec.id);
1793: FETCH okl_asset_returns_b_pk_csr INTO
1794: l_art_rec.ID,
1795: l_art_rec.KLE_ID,
1796: l_art_rec.SECURITY_DEP_TRX_AP_ID,

Line 1793: FETCH okl_asset_returns_b_pk_csr INTO

1789: BEGIN
1790: x_no_data_found := TRUE;
1791: -- Get current database values
1792: OPEN okl_asset_returns_b_pk_csr (p_art_rec.id);
1793: FETCH okl_asset_returns_b_pk_csr INTO
1794: l_art_rec.ID,
1795: l_art_rec.KLE_ID,
1796: l_art_rec.SECURITY_DEP_TRX_AP_ID,
1797: l_art_rec.ISO_ID,

Line 1860: x_no_data_found := okl_asset_returns_b_pk_csr%NOTFOUND;

1856: -- Legal Entity Changes End
1857: -- DJANASWA Loan Repossession proj start
1858: l_art_rec.ASSET_FMV_AMOUNT;
1859: -- Loan Repossession proj end
1860: x_no_data_found := okl_asset_returns_b_pk_csr%NOTFOUND;
1861: CLOSE okl_asset_returns_b_pk_csr;
1862: RETURN(l_art_rec);
1863: END get_rec;
1864:

Line 1861: CLOSE okl_asset_returns_b_pk_csr;

1857: -- DJANASWA Loan Repossession proj start
1858: l_art_rec.ASSET_FMV_AMOUNT;
1859: -- Loan Repossession proj end
1860: x_no_data_found := okl_asset_returns_b_pk_csr%NOTFOUND;
1861: CLOSE okl_asset_returns_b_pk_csr;
1862: RETURN(l_art_rec);
1863: END get_rec;
1864:
1865: FUNCTION get_rec (

Line 2993: -- insert_row for:OKL_ASSET_RETURNS_B --

2989: ---------------------------------------------------------------------------
2990: -- PROCEDURE insert_row
2991: ---------------------------------------------------------------------------
2992: ----------------------------------------
2993: -- insert_row for:OKL_ASSET_RETURNS_B --
2994: ----------------------------------------
2995: -- Start of comments
2996: --
2997: -- Procedure Name : insert_row

Line 2998: -- Description : for OKL_ASSET_RETURNS_B

2994: ----------------------------------------
2995: -- Start of comments
2996: --
2997: -- Procedure Name : insert_row
2998: -- Description : for OKL_ASSET_RETURNS_B
2999: -- Business Rules :
3000: -- Parameters :
3001: -- Version : 1.0
3002: -- History : RABHUPAT 16-DEC-2002 2667636

Line 3019: -- Set_Attributes for:OKL_ASSET_RETURNS_B --

3015: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3016: l_art_rec art_rec_type := p_art_rec;
3017: l_def_art_rec art_rec_type;
3018: --------------------------------------------
3019: -- Set_Attributes for:OKL_ASSET_RETURNS_B --
3020: --------------------------------------------
3021: FUNCTION Set_Attributes (
3022: p_art_rec IN art_rec_type,
3023: x_art_rec OUT NOCOPY art_rec_type

Line 3050: INSERT INTO OKL_ASSET_RETURNS_B(

3046: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3047: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3048: RAISE OKC_API.G_EXCEPTION_ERROR;
3049: END IF;
3050: INSERT INTO OKL_ASSET_RETURNS_B(
3051: id,
3052: kle_id,
3053: security_dep_trx_ap_id,
3054: iso_id,

Line 3641: -- lock_row for:OKL_ASSET_RETURNS_B --

3637: ---------------------------------------------------------------------------
3638: -- PROCEDURE lock_row
3639: ---------------------------------------------------------------------------
3640: --------------------------------------
3641: -- lock_row for:OKL_ASSET_RETURNS_B --
3642: --------------------------------------
3643: PROCEDURE lock_row(
3644: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3645: x_return_status OUT NOCOPY VARCHAR2,

Line 3654: FROM OKL_ASSET_RETURNS_B

3650: E_Resource_Busy EXCEPTION;
3651: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3652: CURSOR lock_csr (p_art_rec IN art_rec_type) IS
3653: SELECT OBJECT_VERSION_NUMBER
3654: FROM OKL_ASSET_RETURNS_B
3655: WHERE ID = p_art_rec.id
3656: AND OBJECT_VERSION_NUMBER = p_art_rec.object_version_number
3657: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
3658:

Line 3661: FROM OKL_ASSET_RETURNS_B

3657: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
3658:
3659: CURSOR lchk_csr (p_art_rec IN art_rec_type) IS
3660: SELECT OBJECT_VERSION_NUMBER
3661: FROM OKL_ASSET_RETURNS_B
3662: WHERE ID = p_art_rec.id;
3663: l_api_version CONSTANT NUMBER := 1;
3664: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
3665: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3666: l_object_version_number OKL_ASSET_RETURNS_B.OBJECT_VERSION_NUMBER%TYPE;

3662: WHERE ID = p_art_rec.id;
3663: l_api_version CONSTANT NUMBER := 1;
3664: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
3665: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3666: l_object_version_number OKL_ASSET_RETURNS_B.OBJECT_VERSION_NUMBER%TYPE;
3667: lc_object_version_number OKL_ASSET_RETURNS_B.OBJECT_VERSION_NUMBER%TYPE;
3668: l_row_notfound BOOLEAN := FALSE;
3669: lc_row_notfound BOOLEAN := FALSE;
3670: BEGIN

Line 3667: lc_object_version_number OKL_ASSET_RETURNS_B.OBJECT_VERSION_NUMBER%TYPE;

3663: l_api_version CONSTANT NUMBER := 1;
3664: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
3665: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3666: l_object_version_number OKL_ASSET_RETURNS_B.OBJECT_VERSION_NUMBER%TYPE;
3667: lc_object_version_number OKL_ASSET_RETURNS_B.OBJECT_VERSION_NUMBER%TYPE;
3668: l_row_notfound BOOLEAN := FALSE;
3669: lc_row_notfound BOOLEAN := FALSE;
3670: BEGIN
3671: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 4010: -- update_row for:OKL_ASSET_RETURNS_B --

4006: ---------------------------------------------------------------------------
4007: -- PROCEDURE update_row
4008: ---------------------------------------------------------------------------
4009: ----------------------------------------
4010: -- update_row for:OKL_ASSET_RETURNS_B --
4011: ----------------------------------------
4012: -- Start of comments
4013: --
4014: -- Procedure Name : update_row

Line 4015: -- Description : for OKL_ASSET_RETURNS_B

4011: ----------------------------------------
4012: -- Start of comments
4013: --
4014: -- Procedure Name : update_row
4015: -- Description : for OKL_ASSET_RETURNS_B
4016: -- Business Rules :
4017: -- Parameters :
4018: -- Version : 1.0
4019: -- History : RABHUPAT 16-DEC-2002 2667636

Line 4305: -- Set_Attributes for:OKL_ASSET_RETURNS_B --

4301:
4302: RETURN(l_return_status);
4303: END populate_new_record;
4304: --------------------------------------------
4305: -- Set_Attributes for:OKL_ASSET_RETURNS_B --
4306: --------------------------------------------
4307: FUNCTION Set_Attributes (
4308: p_art_rec IN art_rec_type,
4309: x_art_rec OUT NOCOPY art_rec_type

Line 4342: UPDATE OKL_ASSET_RETURNS_B

4338: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4339: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4340: RAISE OKC_API.G_EXCEPTION_ERROR;
4341: END IF;
4342: UPDATE OKL_ASSET_RETURNS_B
4343: SET KLE_ID = l_def_art_rec.kle_id,
4344: SECURITY_DEP_TRX_AP_ID = l_def_art_rec.security_dep_trx_ap_id,
4345: ISO_ID = l_def_art_rec.iso_id,
4346: RNA_ID = l_def_art_rec.rna_id,

Line 5156: -- delete_row for:OKL_ASSET_RETURNS_B --

5152: ---------------------------------------------------------------------------
5153: -- PROCEDURE delete_row
5154: ---------------------------------------------------------------------------
5155: ----------------------------------------
5156: -- delete_row for:OKL_ASSET_RETURNS_B --
5157: ----------------------------------------
5158: PROCEDURE delete_row(
5159: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
5160: x_return_status OUT NOCOPY VARCHAR2,

Line 5180: DELETE FROM OKL_ASSET_RETURNS_B

5176: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5177: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5178: RAISE OKC_API.G_EXCEPTION_ERROR;
5179: END IF;
5180: DELETE FROM OKL_ASSET_RETURNS_B
5181: WHERE ID = l_art_rec.id;
5182:
5183: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
5184: EXCEPTION