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_TEL_PVT dependencies on OKL_TXL_EXTENSION_B

Line 66: CURSOR c_pk_csr IS SELECT okl_txl_extension_b_s.NEXTVAL FROM DUAL;

62: -- FUNCTION get_seq_id
63: ---------------------------------------------------------------------------
64: FUNCTION get_seq_id RETURN NUMBER IS
65: l_pk_value NUMBER;
66: CURSOR c_pk_csr IS SELECT okl_txl_extension_b_s.NEXTVAL FROM DUAL;
67: BEGIN
68: /* Fetch the pk value from the sequence */
69: OPEN c_pk_csr;
70: FETCH c_pk_csr INTO l_pk_value;

Line 107: FROM OKL_TXL_EXTENSION_B B

103: BEGIN
104: DELETE FROM OKL_TXL_EXTENSION_TL T
105: WHERE NOT EXISTS (
106: SELECT NULL
107: FROM OKL_TXL_EXTENSION_B B
108: WHERE B.LINE_EXTENSION_ID =T.LINE_EXTENSION_ID
109: );
110:
111: UPDATE OKL_TXL_EXTENSION_TL T SET(

Line 375: -- FUNCTION get_rec for: OKL_TXL_EXTENSION_B

371: BEGIN
372: RETURN(get_rec(p_tell_rec, l_row_not_found));
373: END get_rec;
374: ---------------------------------------------------------------------------
375: -- FUNCTION get_rec for: OKL_TXL_EXTENSION_B
376: ---------------------------------------------------------------------------
377: FUNCTION get_rec (
378: p_tel_rec IN tel_rec_type,
379: x_no_data_found OUT NOCOPY BOOLEAN

Line 381: CURSOR okl_txl_extension_b_pk_csr (p_line_extension_id IN NUMBER) IS

377: FUNCTION get_rec (
378: p_tel_rec IN tel_rec_type,
379: x_no_data_found OUT NOCOPY BOOLEAN
380: ) RETURN tel_rec_type IS
381: CURSOR okl_txl_extension_b_pk_csr (p_line_extension_id IN NUMBER) IS
382: SELECT
383: LINE_EXTENSION_ID,
384: SOURCE_ID,
385: SOURCE_TABLE,

Line 419: FROM Okl_Txl_Extension_B

415: SUBSIDY_VENDOR_ID,
416: -- added by zrehman Bug#6707320 for Party Merge impact on Accounting sources tables start
417: ASSET_VENDOR_ID
418: -- added by zrehman Bug#6707320 for Party Merge impact on Accounting sources tables end
419: FROM Okl_Txl_Extension_B
420: WHERE okl_txl_extension_b.line_extension_id = p_line_extension_id;
421: l_okl_txl_extension_b_pk okl_txl_extension_b_pk_csr%ROWTYPE;
422: l_tel_rec tel_rec_type;
423: BEGIN

Line 420: WHERE okl_txl_extension_b.line_extension_id = p_line_extension_id;

416: -- added by zrehman Bug#6707320 for Party Merge impact on Accounting sources tables start
417: ASSET_VENDOR_ID
418: -- added by zrehman Bug#6707320 for Party Merge impact on Accounting sources tables end
419: FROM Okl_Txl_Extension_B
420: WHERE okl_txl_extension_b.line_extension_id = p_line_extension_id;
421: l_okl_txl_extension_b_pk okl_txl_extension_b_pk_csr%ROWTYPE;
422: l_tel_rec tel_rec_type;
423: BEGIN
424: x_no_data_found := TRUE;

Line 421: l_okl_txl_extension_b_pk okl_txl_extension_b_pk_csr%ROWTYPE;

417: ASSET_VENDOR_ID
418: -- added by zrehman Bug#6707320 for Party Merge impact on Accounting sources tables end
419: FROM Okl_Txl_Extension_B
420: WHERE okl_txl_extension_b.line_extension_id = p_line_extension_id;
421: l_okl_txl_extension_b_pk okl_txl_extension_b_pk_csr%ROWTYPE;
422: l_tel_rec tel_rec_type;
423: BEGIN
424: x_no_data_found := TRUE;
425: -- Get current database values

Line 426: OPEN okl_txl_extension_b_pk_csr (p_tel_rec.line_extension_id);

422: l_tel_rec tel_rec_type;
423: BEGIN
424: x_no_data_found := TRUE;
425: -- Get current database values
426: OPEN okl_txl_extension_b_pk_csr (p_tel_rec.line_extension_id);
427: FETCH okl_txl_extension_b_pk_csr INTO
428: l_tel_rec.line_extension_id,
429: l_tel_rec.source_id,
430: l_tel_rec.source_table,

Line 427: FETCH okl_txl_extension_b_pk_csr INTO

423: BEGIN
424: x_no_data_found := TRUE;
425: -- Get current database values
426: OPEN okl_txl_extension_b_pk_csr (p_tel_rec.line_extension_id);
427: FETCH okl_txl_extension_b_pk_csr INTO
428: l_tel_rec.line_extension_id,
429: l_tel_rec.source_id,
430: l_tel_rec.source_table,
431: l_tel_rec.object_version_number,

Line 464: x_no_data_found := okl_txl_extension_b_pk_csr%NOTFOUND;

460: l_tel_rec.subsidy_vendor_id ,
461: -- added by zrehman Bug#6707320 for Party Merge impact on Accounting sources tables start
462: l_tel_rec.asset_vendor_id;
463: -- added by zrehman Bug#6707320 for Party Merge impact on Accounting sources tables end;
464: x_no_data_found := okl_txl_extension_b_pk_csr%NOTFOUND;
465: CLOSE okl_txl_extension_b_pk_csr;
466: RETURN(l_tel_rec);
467: END get_rec;
468:

Line 465: CLOSE okl_txl_extension_b_pk_csr;

461: -- added by zrehman Bug#6707320 for Party Merge impact on Accounting sources tables start
462: l_tel_rec.asset_vendor_id;
463: -- added by zrehman Bug#6707320 for Party Merge impact on Accounting sources tables end;
464: x_no_data_found := okl_txl_extension_b_pk_csr%NOTFOUND;
465: CLOSE okl_txl_extension_b_pk_csr;
466: RETURN(l_tel_rec);
467: END get_rec;
468:
469: ------------------------------------------------------------------

Line 1319: -- insert_row for:OKL_TXL_EXTENSION_B --

1315: ---------------------------------------------------------------------------
1316: -- PROCEDURE insert_row
1317: ---------------------------------------------------------------------------
1318: ----------------------------------------
1319: -- insert_row for:OKL_TXL_EXTENSION_B --
1320: ----------------------------------------
1321: PROCEDURE insert_row(
1322: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1323: x_return_status OUT NOCOPY VARCHAR2,

Line 1335: -- Set_Attributes for:OKL_TXL_EXTENSION_B --

1331: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1332: l_tel_rec tel_rec_type := p_tel_rec;
1333: l_def_tel_rec tel_rec_type;
1334: --------------------------------------------
1335: -- Set_Attributes for:OKL_TXL_EXTENSION_B --
1336: --------------------------------------------
1337: FUNCTION Set_Attributes (
1338: p_tel_rec IN tel_rec_type,
1339: x_tel_rec OUT NOCOPY tel_rec_type

Line 1366: INSERT INTO OKL_TXL_EXTENSION_B(

1362: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1363: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1364: RAISE OKL_API.G_EXCEPTION_ERROR;
1365: END IF;
1366: INSERT INTO OKL_TXL_EXTENSION_B(
1367: line_extension_id,
1368: source_id,
1369: source_table,
1370: object_version_number,

Line 1591: -- insert_row for :OKL_TXL_EXTENSION_B --

1587: '_PVT'
1588: );
1589: END insert_row;
1590: -----------------------------------------
1591: -- insert_row for :OKL_TXL_EXTENSION_B --
1592: -----------------------------------------
1593: PROCEDURE insert_row(
1594: p_api_version IN NUMBER,
1595: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1627: -- Set_Attributes for:OKL_TXL_EXTENSION_B --

1623: l_telv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1624: RETURN(l_telv_rec);
1625: END fill_who_columns;
1626: --------------------------------------------
1627: -- Set_Attributes for:OKL_TXL_EXTENSION_B --
1628: --------------------------------------------
1629: FUNCTION Set_Attributes (
1630: p_telv_rec IN telv_rec_type,
1631: x_telv_rec OUT NOCOPY telv_rec_type

Line 1956: INSERT INTO OKL_TXL_EXTENSION_B

1952: END IF;
1953:
1954: -- Implementing the Bulk Insert Feature
1955: FORALL j in l_tel_tbl_in.FIRST .. l_tel_tbl_in.LAST
1956: INSERT INTO OKL_TXL_EXTENSION_B
1957: VALUES l_tel_tbl_in(j);
1958:
1959: FORALL j in l_tell_tbl_in.FIRST .. l_tell_tbl_in.LAST
1960: INSERT INTO OKL_TXL_EXTENSION_TL

Line 2006: -- lock_row for:OKL_TXL_EXTENSION_B --

2002: ---------------------------------------------------------------------------
2003: -- PROCEDURE lock_row
2004: ---------------------------------------------------------------------------
2005: --------------------------------------
2006: -- lock_row for:OKL_TXL_EXTENSION_B --
2007: --------------------------------------
2008: PROCEDURE lock_row(
2009: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2010: x_return_status OUT NOCOPY VARCHAR2,

Line 2019: FROM OKL_TXL_EXTENSION_B

2015: E_Resource_Busy EXCEPTION;
2016: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2017: CURSOR lock_csr (p_tel_rec IN tel_rec_type) IS
2018: SELECT OBJECT_VERSION_NUMBER
2019: FROM OKL_TXL_EXTENSION_B
2020: WHERE LINE_EXTENSION_ID = p_tel_rec.line_extension_id
2021: AND OBJECT_VERSION_NUMBER = p_tel_rec.object_version_number
2022: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2023:

Line 2026: FROM OKL_TXL_EXTENSION_B

2022: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2023:
2024: CURSOR lchk_csr (p_tel_rec IN tel_rec_type) IS
2025: SELECT OBJECT_VERSION_NUMBER
2026: FROM OKL_TXL_EXTENSION_B
2027: WHERE LINE_EXTENSION_ID = p_tel_rec.line_extension_id;
2028: l_api_version CONSTANT NUMBER := 1;
2029: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2030: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 2031: l_object_version_number OKL_TXL_EXTENSION_B.OBJECT_VERSION_NUMBER%TYPE;

2027: WHERE LINE_EXTENSION_ID = p_tel_rec.line_extension_id;
2028: l_api_version CONSTANT NUMBER := 1;
2029: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2030: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2031: l_object_version_number OKL_TXL_EXTENSION_B.OBJECT_VERSION_NUMBER%TYPE;
2032: lc_object_version_number OKL_TXL_EXTENSION_B.OBJECT_VERSION_NUMBER%TYPE;
2033: l_row_notfound BOOLEAN := FALSE;
2034: lc_row_notfound BOOLEAN := FALSE;
2035: BEGIN

Line 2032: lc_object_version_number OKL_TXL_EXTENSION_B.OBJECT_VERSION_NUMBER%TYPE;

2028: l_api_version CONSTANT NUMBER := 1;
2029: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2030: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2031: l_object_version_number OKL_TXL_EXTENSION_B.OBJECT_VERSION_NUMBER%TYPE;
2032: lc_object_version_number OKL_TXL_EXTENSION_B.OBJECT_VERSION_NUMBER%TYPE;
2033: l_row_notfound BOOLEAN := FALSE;
2034: lc_row_notfound BOOLEAN := FALSE;
2035: BEGIN
2036: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 2453: -- update_row for:OKL_TXL_EXTENSION_B --

2449: ---------------------------------------------------------------------------
2450: -- PROCEDURE update_row
2451: ---------------------------------------------------------------------------
2452: ----------------------------------------
2453: -- update_row for:OKL_TXL_EXTENSION_B --
2454: ----------------------------------------
2455: PROCEDURE update_row(
2456: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2457: x_return_status OUT NOCOPY VARCHAR2,

Line 2590: -- Set_Attributes for:OKL_TXL_EXTENSION_B --

2586: END IF;
2587: RETURN(l_return_status);
2588: END populate_new_record;
2589: --------------------------------------------
2590: -- Set_Attributes for:OKL_TXL_EXTENSION_B --
2591: --------------------------------------------
2592: FUNCTION Set_Attributes (
2593: p_tel_rec IN tel_rec_type,
2594: x_tel_rec OUT NOCOPY tel_rec_type

Line 2628: UPDATE OKL_TXL_EXTENSION_B

2624: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2625: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2626: RAISE OKL_API.G_EXCEPTION_ERROR;
2627: END IF;
2628: UPDATE OKL_TXL_EXTENSION_B
2629: SET SOURCE_ID = l_def_tel_rec.source_id,
2630: SOURCE_TABLE = l_def_tel_rec.source_table,
2631: OBJECT_VERSION_NUMBER = l_def_tel_rec.object_version_number,
2632: CONTRACT_LINE_NUMBER = l_def_tel_rec.contract_line_number,

Line 3329: -- delete_row for:OKL_TXL_EXTENSION_B --

3325: ---------------------------------------------------------------------------
3326: -- PROCEDURE delete_row
3327: ---------------------------------------------------------------------------
3328: ----------------------------------------
3329: -- delete_row for:OKL_TXL_EXTENSION_B --
3330: ----------------------------------------
3331: PROCEDURE delete_row(
3332: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
3333: x_return_status OUT NOCOPY VARCHAR2,

Line 3354: DELETE FROM OKL_TXL_EXTENSION_B

3350: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3351: RAISE OKL_API.G_EXCEPTION_ERROR;
3352: END IF;
3353:
3354: DELETE FROM OKL_TXL_EXTENSION_B
3355: WHERE LINE_EXTENSION_ID = p_tel_rec.line_extension_id;
3356:
3357: x_return_status := l_return_status;
3358: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 3713: -- insert_row for:OKL_TXL_EXTENSION_B/OKL_TXL_EXTENSION_TL ----------------

3709: -- PROCEDURE insert_row
3710: ---------------------------------------------------------------------------
3711: -- Added : PRASJAIN : Bug# 6268782
3712: ---------------------------------------------------------------------------
3713: -- insert_row for:OKL_TXL_EXTENSION_B/OKL_TXL_EXTENSION_TL ----------------
3714: ---------------------------------------------------------------------------
3715:
3716: PROCEDURE insert_row(
3717: p_api_version IN NUMBER,