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_ACN_PVT dependencies on OKL_ASSET_CNDTN_LNS_B

Line 1329: -- FUNCTION get_rec for: OKL_ASSET_CNDTN_LNS_B

1325:
1326: END add_language;
1327:
1328: ---------------------------------------------------------------------------
1329: -- FUNCTION get_rec for: OKL_ASSET_CNDTN_LNS_B
1330: ---------------------------------------------------------------------------
1331: -- Start of comments
1332: --
1333: -- Function Name : get_rec

Line 1334: -- Description : for: OKL_ASSET_CNDTN_LNS_B

1330: ---------------------------------------------------------------------------
1331: -- Start of comments
1332: --
1333: -- Function Name : get_rec
1334: -- Description : for: OKL_ASSET_CNDTN_LNS_B
1335: -- Business Rules :
1336: -- Parameters :
1337: -- Version : 1.0
1338: -- History : RABHUPAT 13-DEC-2002 2667636

Line 1346: CURSOR okl_asset_cndtn_lns_b_pk_csr (p_id IN NUMBER) IS

1342: FUNCTION get_rec (
1343: p_acn_rec IN acn_rec_type,
1344: x_no_data_found OUT NOCOPY BOOLEAN
1345: ) RETURN acn_rec_type IS
1346: CURSOR okl_asset_cndtn_lns_b_pk_csr (p_id IN NUMBER) IS
1347: SELECT
1348: ID,
1349: SEQUENCE_NUMBER,
1350: ACD_ID,

Line 1398: FROM Okl_Asset_Cndtn_Lns_B

1394: CURRENCY_CONVERSION_TYPE,
1395: CURRENCY_CONVERSION_RATE,
1396: CURRENCY_CONVERSION_DATE
1397: -- RABHUPAT - 2667636 - End
1398: FROM Okl_Asset_Cndtn_Lns_B
1399: WHERE okl_asset_cndtn_lns_b.id = p_id;
1400: l_okl_asset_cndtn_lns_b_pk okl_asset_cndtn_lns_b_pk_csr%ROWTYPE;
1401: l_acn_rec acn_rec_type;
1402: BEGIN

Line 1399: WHERE okl_asset_cndtn_lns_b.id = p_id;

1395: CURRENCY_CONVERSION_RATE,
1396: CURRENCY_CONVERSION_DATE
1397: -- RABHUPAT - 2667636 - End
1398: FROM Okl_Asset_Cndtn_Lns_B
1399: WHERE okl_asset_cndtn_lns_b.id = p_id;
1400: l_okl_asset_cndtn_lns_b_pk okl_asset_cndtn_lns_b_pk_csr%ROWTYPE;
1401: l_acn_rec acn_rec_type;
1402: BEGIN
1403: x_no_data_found := TRUE;

Line 1400: l_okl_asset_cndtn_lns_b_pk okl_asset_cndtn_lns_b_pk_csr%ROWTYPE;

1396: CURRENCY_CONVERSION_DATE
1397: -- RABHUPAT - 2667636 - End
1398: FROM Okl_Asset_Cndtn_Lns_B
1399: WHERE okl_asset_cndtn_lns_b.id = p_id;
1400: l_okl_asset_cndtn_lns_b_pk okl_asset_cndtn_lns_b_pk_csr%ROWTYPE;
1401: l_acn_rec acn_rec_type;
1402: BEGIN
1403: x_no_data_found := TRUE;
1404: -- Get current database values

Line 1405: OPEN okl_asset_cndtn_lns_b_pk_csr (p_acn_rec.id);

1401: l_acn_rec acn_rec_type;
1402: BEGIN
1403: x_no_data_found := TRUE;
1404: -- Get current database values
1405: OPEN okl_asset_cndtn_lns_b_pk_csr (p_acn_rec.id);
1406: FETCH okl_asset_cndtn_lns_b_pk_csr INTO
1407: l_acn_rec.ID,
1408: l_acn_rec.SEQUENCE_NUMBER,
1409: l_acn_rec.ACD_ID,

Line 1406: FETCH okl_asset_cndtn_lns_b_pk_csr INTO

1402: BEGIN
1403: x_no_data_found := TRUE;
1404: -- Get current database values
1405: OPEN okl_asset_cndtn_lns_b_pk_csr (p_acn_rec.id);
1406: FETCH okl_asset_cndtn_lns_b_pk_csr INTO
1407: l_acn_rec.ID,
1408: l_acn_rec.SEQUENCE_NUMBER,
1409: l_acn_rec.ACD_ID,
1410: l_acn_rec.CTP_CODE,

Line 1457: x_no_data_found := okl_asset_cndtn_lns_b_pk_csr%NOTFOUND;

1453: l_acn_rec.CURRENCY_CONVERSION_TYPE,
1454: l_acn_rec.CURRENCY_CONVERSION_RATE,
1455: l_acn_rec.CURRENCY_CONVERSION_DATE;
1456: -- RABHUPAT - 2667636 - End
1457: x_no_data_found := okl_asset_cndtn_lns_b_pk_csr%NOTFOUND;
1458: CLOSE okl_asset_cndtn_lns_b_pk_csr;
1459: RETURN(l_acn_rec);
1460: END get_rec;
1461:

Line 1458: CLOSE okl_asset_cndtn_lns_b_pk_csr;

1454: l_acn_rec.CURRENCY_CONVERSION_RATE,
1455: l_acn_rec.CURRENCY_CONVERSION_DATE;
1456: -- RABHUPAT - 2667636 - End
1457: x_no_data_found := okl_asset_cndtn_lns_b_pk_csr%NOTFOUND;
1458: CLOSE okl_asset_cndtn_lns_b_pk_csr;
1459: RETURN(l_acn_rec);
1460: END get_rec;
1461:
1462: FUNCTION get_rec (

Line 2446: -- insert_row for:OKL_ASSET_CNDTN_LNS_B --

2442: ---------------------------------------------------------------------------
2443: -- PROCEDURE insert_row
2444: ---------------------------------------------------------------------------
2445: ------------------------------------------
2446: -- insert_row for:OKL_ASSET_CNDTN_LNS_B --
2447: ------------------------------------------
2448: -- Start of comments
2449: --
2450: -- Procedure Name : insert_row

Line 2451: -- Description : for OKL_ASSET_CNDTN_LNS_B

2447: ------------------------------------------
2448: -- Start of comments
2449: --
2450: -- Procedure Name : insert_row
2451: -- Description : for OKL_ASSET_CNDTN_LNS_B
2452: -- Business Rules :
2453: -- Parameters :
2454: -- Version : 1.0
2455: -- History : RABHUPAT 13-DEC-2002 2667636

Line 2472: -- Set_Attributes for:OKL_ASSET_CNDTN_LNS_B --

2468: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2469: l_acn_rec acn_rec_type := p_acn_rec;
2470: l_def_acn_rec acn_rec_type;
2471: ----------------------------------------------
2472: -- Set_Attributes for:OKL_ASSET_CNDTN_LNS_B --
2473: ----------------------------------------------
2474: FUNCTION Set_Attributes (
2475: p_acn_rec IN acn_rec_type,
2476: x_acn_rec OUT NOCOPY acn_rec_type

Line 2503: INSERT INTO OKL_ASSET_CNDTN_LNS_B(

2499: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2500: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2501: RAISE OKC_API.G_EXCEPTION_ERROR;
2502: END IF;
2503: INSERT INTO OKL_ASSET_CNDTN_LNS_B(
2504: id,
2505: sequence_number,
2506: acd_id,
2507: ctp_code,

Line 3054: -- lock_row for:OKL_ASSET_CNDTN_LNS_B --

3050: ---------------------------------------------------------------------------
3051: -- PROCEDURE lock_row
3052: ---------------------------------------------------------------------------
3053: ----------------------------------------
3054: -- lock_row for:OKL_ASSET_CNDTN_LNS_B --
3055: ----------------------------------------
3056: PROCEDURE lock_row(
3057: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3058: x_return_status OUT NOCOPY VARCHAR2,

Line 3067: FROM OKL_ASSET_CNDTN_LNS_B

3063: E_Resource_Busy EXCEPTION;
3064: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3065: CURSOR lock_csr (p_acn_rec IN acn_rec_type) IS
3066: SELECT OBJECT_VERSION_NUMBER
3067: FROM OKL_ASSET_CNDTN_LNS_B
3068: WHERE ID = p_acn_rec.id
3069: AND OBJECT_VERSION_NUMBER = p_acn_rec.object_version_number
3070: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
3071:

Line 3074: FROM OKL_ASSET_CNDTN_LNS_B

3070: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
3071:
3072: CURSOR lchk_csr (p_acn_rec IN acn_rec_type) IS
3073: SELECT OBJECT_VERSION_NUMBER
3074: FROM OKL_ASSET_CNDTN_LNS_B
3075: WHERE ID = p_acn_rec.id;
3076: l_api_version CONSTANT NUMBER := 1;
3077: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
3078: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3079: l_object_version_number OKL_ASSET_CNDTN_LNS_B.OBJECT_VERSION_NUMBER%TYPE;

3075: WHERE ID = p_acn_rec.id;
3076: l_api_version CONSTANT NUMBER := 1;
3077: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
3078: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3079: l_object_version_number OKL_ASSET_CNDTN_LNS_B.OBJECT_VERSION_NUMBER%TYPE;
3080: lc_object_version_number OKL_ASSET_CNDTN_LNS_B.OBJECT_VERSION_NUMBER%TYPE;
3081: l_row_notfound BOOLEAN := FALSE;
3082: lc_row_notfound BOOLEAN := FALSE;
3083: BEGIN

Line 3080: lc_object_version_number OKL_ASSET_CNDTN_LNS_B.OBJECT_VERSION_NUMBER%TYPE;

3076: l_api_version CONSTANT NUMBER := 1;
3077: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
3078: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3079: l_object_version_number OKL_ASSET_CNDTN_LNS_B.OBJECT_VERSION_NUMBER%TYPE;
3080: lc_object_version_number OKL_ASSET_CNDTN_LNS_B.OBJECT_VERSION_NUMBER%TYPE;
3081: l_row_notfound BOOLEAN := FALSE;
3082: lc_row_notfound BOOLEAN := FALSE;
3083: BEGIN
3084: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3424: -- update_row for:OKL_ASSET_CNDTN_LNS_B --

3420: ---------------------------------------------------------------------------
3421: -- PROCEDURE update_row
3422: ---------------------------------------------------------------------------
3423: ------------------------------------------
3424: -- update_row for:OKL_ASSET_CNDTN_LNS_B --
3425: ------------------------------------------
3426: -- Start of comments
3427: --
3428: -- Procedure Name : update_row

Line 3429: -- Description : for OKL_ASSET_CNDTN_LNS_B

3425: ------------------------------------------
3426: -- Start of comments
3427: --
3428: -- Procedure Name : update_row
3429: -- Description : for OKL_ASSET_CNDTN_LNS_B
3430: -- Business Rules :
3431: -- Parameters :
3432: -- Version : 1.0
3433: -- History : RABHUPAT 13-DEC-2002 2667636

Line 3664: -- Set_Attributes for:OKL_ASSET_CNDTN_LNS_B --

3660: -- RABHUPAT - 2667636 - End
3661: RETURN(l_return_status);
3662: END populate_new_record;
3663: ----------------------------------------------
3664: -- Set_Attributes for:OKL_ASSET_CNDTN_LNS_B --
3665: ----------------------------------------------
3666: FUNCTION Set_Attributes (
3667: p_acn_rec IN acn_rec_type,
3668: x_acn_rec OUT NOCOPY acn_rec_type

Line 3701: UPDATE OKL_ASSET_CNDTN_LNS_B

3697: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3698: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3699: RAISE OKC_API.G_EXCEPTION_ERROR;
3700: END IF;
3701: UPDATE OKL_ASSET_CNDTN_LNS_B
3702: SET SEQUENCE_NUMBER = l_def_acn_rec.sequence_number,
3703: ACD_ID = l_def_acn_rec.acd_id,
3704: CTP_CODE = l_def_acn_rec.ctp_code,
3705: CDN_CODE = l_def_acn_rec.cdn_code,

Line 4466: -- delete_row for:OKL_ASSET_CNDTN_LNS_B --

4462: ---------------------------------------------------------------------------
4463: -- PROCEDURE delete_row
4464: ---------------------------------------------------------------------------
4465: ------------------------------------------
4466: -- delete_row for:OKL_ASSET_CNDTN_LNS_B --
4467: ------------------------------------------
4468: PROCEDURE delete_row(
4469: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4470: x_return_status OUT NOCOPY VARCHAR2,

Line 4490: DELETE FROM OKL_ASSET_CNDTN_LNS_B

4486: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4487: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4488: RAISE OKC_API.G_EXCEPTION_ERROR;
4489: END IF;
4490: DELETE FROM OKL_ASSET_CNDTN_LNS_B
4491: WHERE ID = l_acn_rec.id;
4492:
4493: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
4494: EXCEPTION