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_TL

Line 104: DELETE FROM OKL_TXL_EXTENSION_TL T

100: -- PROCEDURE add_language
101: ---------------------------------------------------------------------------
102: PROCEDURE add_language IS
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

Line 111: UPDATE OKL_TXL_EXTENSION_TL T SET(

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(
112: INVENTORY_ITEM_NAME,
113: INVENTORY_ORG_NAME) = (SELECT
114: B.INVENTORY_ITEM_NAME,
115: B.INVENTORY_ORG_NAME

Line 116: FROM OKL_TXL_EXTENSION_TL B

112: INVENTORY_ITEM_NAME,
113: INVENTORY_ORG_NAME) = (SELECT
114: B.INVENTORY_ITEM_NAME,
115: B.INVENTORY_ORG_NAME
116: FROM OKL_TXL_EXTENSION_TL B
117: WHERE B.LINE_EXTENSION_ID = T.LINE_EXTENSION_ID
118: AND B.LANGUAGE = T.SOURCE_LANG)
119: WHERE ( T.LINE_EXTENSION_ID,
120: T.LANGUAGE)

Line 124: FROM OKL_TXL_EXTENSION_TL SUBB, OKL_TXL_EXTENSION_TL SUBT

120: T.LANGUAGE)
121: IN (SELECT
122: SUBT.LINE_EXTENSION_ID,
123: SUBT.LANGUAGE
124: FROM OKL_TXL_EXTENSION_TL SUBB, OKL_TXL_EXTENSION_TL SUBT
125: WHERE SUBB.LINE_EXTENSION_ID = SUBT.LINE_EXTENSION_ID
126: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
127: AND (SUBB.INVENTORY_ITEM_NAME <> SUBT.INVENTORY_ITEM_NAME
128: OR SUBB.INVENTORY_ORG_NAME <> SUBT.INVENTORY_ORG_NAME

Line 133: INSERT INTO OKL_TXL_EXTENSION_TL (

129: OR (SUBB.INVENTORY_ITEM_NAME IS NULL AND SUBT.INVENTORY_ITEM_NAME IS NOT NULL)
130: OR (SUBB.INVENTORY_ORG_NAME IS NULL AND SUBT.INVENTORY_ORG_NAME IS NOT NULL)
131: ));
132:
133: INSERT INTO OKL_TXL_EXTENSION_TL (
134: LINE_EXTENSION_ID,
135: LANGUAGE,
136: SOURCE_LANG,
137: SFWT_FLAG,

Line 157: FROM OKL_TXL_EXTENSION_TL B, FND_LANGUAGES L

153: B.CREATION_DATE,
154: B.LAST_UPDATED_BY,
155: B.LAST_UPDATE_DATE,
156: B.LAST_UPDATE_LOGIN
157: FROM OKL_TXL_EXTENSION_TL B, FND_LANGUAGES L
158: WHERE L.INSTALLED_FLAG IN ('I', 'B')
159: AND B.LANGUAGE = USERENV('LANG')
160: AND NOT EXISTS (
161: SELECT NULL

Line 162: FROM OKL_TXL_EXTENSION_TL T

158: WHERE L.INSTALLED_FLAG IN ('I', 'B')
159: AND B.LANGUAGE = USERENV('LANG')
160: AND NOT EXISTS (
161: SELECT NULL
162: FROM OKL_TXL_EXTENSION_TL T
163: WHERE T.LINE_EXTENSION_ID = B.LINE_EXTENSION_ID
164: AND T.LANGUAGE = L.LANGUAGE_CODE
165: );
166: END add_language;

Line 298: -- FUNCTION get_rec for: OKL_TXL_EXTENSION_TL

294: BEGIN
295: RETURN(get_rec(p_telv_rec, l_row_not_found));
296: END get_rec;
297: ---------------------------------------------------------------------------
298: -- FUNCTION get_rec for: OKL_TXL_EXTENSION_TL
299: ---------------------------------------------------------------------------
300: FUNCTION get_rec (
301: p_tell_rec IN tell_rec_type,
302: x_no_data_found OUT NOCOPY BOOLEAN

Line 304: CURSOR okl_txl_extension_tl_pk_csr (p_line_extension_id IN NUMBER,

300: FUNCTION get_rec (
301: p_tell_rec IN tell_rec_type,
302: x_no_data_found OUT NOCOPY BOOLEAN
303: ) RETURN tell_rec_type IS
304: CURSOR okl_txl_extension_tl_pk_csr (p_line_extension_id IN NUMBER,
305: p_language IN VARCHAR2) IS
306: SELECT
307: LINE_EXTENSION_ID,
308: LANGUAGE,

Line 318: FROM Okl_Txl_Extension_Tl

314: CREATION_DATE,
315: LAST_UPDATED_BY,
316: LAST_UPDATE_DATE,
317: LAST_UPDATE_LOGIN
318: FROM Okl_Txl_Extension_Tl
319: WHERE okl_txl_extension_tl.line_extension_id = p_line_extension_id
320: AND okl_txl_extension_tl.language = p_language;
321: l_okl_txl_extension_tl_pk okl_txl_extension_tl_pk_csr%ROWTYPE;
322: l_tell_rec tell_rec_type;

Line 319: WHERE okl_txl_extension_tl.line_extension_id = p_line_extension_id

315: LAST_UPDATED_BY,
316: LAST_UPDATE_DATE,
317: LAST_UPDATE_LOGIN
318: FROM Okl_Txl_Extension_Tl
319: WHERE okl_txl_extension_tl.line_extension_id = p_line_extension_id
320: AND okl_txl_extension_tl.language = p_language;
321: l_okl_txl_extension_tl_pk okl_txl_extension_tl_pk_csr%ROWTYPE;
322: l_tell_rec tell_rec_type;
323: BEGIN

Line 320: AND okl_txl_extension_tl.language = p_language;

316: LAST_UPDATE_DATE,
317: LAST_UPDATE_LOGIN
318: FROM Okl_Txl_Extension_Tl
319: WHERE okl_txl_extension_tl.line_extension_id = p_line_extension_id
320: AND okl_txl_extension_tl.language = p_language;
321: l_okl_txl_extension_tl_pk okl_txl_extension_tl_pk_csr%ROWTYPE;
322: l_tell_rec tell_rec_type;
323: BEGIN
324: x_no_data_found := TRUE;

Line 321: l_okl_txl_extension_tl_pk okl_txl_extension_tl_pk_csr%ROWTYPE;

317: LAST_UPDATE_LOGIN
318: FROM Okl_Txl_Extension_Tl
319: WHERE okl_txl_extension_tl.line_extension_id = p_line_extension_id
320: AND okl_txl_extension_tl.language = p_language;
321: l_okl_txl_extension_tl_pk okl_txl_extension_tl_pk_csr%ROWTYPE;
322: l_tell_rec tell_rec_type;
323: BEGIN
324: x_no_data_found := TRUE;
325: -- Get current database values

Line 326: OPEN okl_txl_extension_tl_pk_csr (p_tell_rec.line_extension_id,

322: l_tell_rec tell_rec_type;
323: BEGIN
324: x_no_data_found := TRUE;
325: -- Get current database values
326: OPEN okl_txl_extension_tl_pk_csr (p_tell_rec.line_extension_id,
327: p_tell_rec.language);
328: FETCH okl_txl_extension_tl_pk_csr INTO
329: l_tell_rec.line_extension_id,
330: l_tell_rec.language,

Line 328: FETCH okl_txl_extension_tl_pk_csr INTO

324: x_no_data_found := TRUE;
325: -- Get current database values
326: OPEN okl_txl_extension_tl_pk_csr (p_tell_rec.line_extension_id,
327: p_tell_rec.language);
328: FETCH okl_txl_extension_tl_pk_csr INTO
329: l_tell_rec.line_extension_id,
330: l_tell_rec.language,
331: l_tell_rec.source_lang,
332: l_tell_rec.sfwt_flag,

Line 340: x_no_data_found := okl_txl_extension_tl_pk_csr%NOTFOUND;

336: l_tell_rec.creation_date,
337: l_tell_rec.last_updated_by,
338: l_tell_rec.last_update_date,
339: l_tell_rec.last_update_login;
340: x_no_data_found := okl_txl_extension_tl_pk_csr%NOTFOUND;
341: CLOSE okl_txl_extension_tl_pk_csr;
342: RETURN(l_tell_rec);
343: END get_rec;
344:

Line 341: CLOSE okl_txl_extension_tl_pk_csr;

337: l_tell_rec.last_updated_by,
338: l_tell_rec.last_update_date,
339: l_tell_rec.last_update_login;
340: x_no_data_found := okl_txl_extension_tl_pk_csr%NOTFOUND;
341: CLOSE okl_txl_extension_tl_pk_csr;
342: RETURN(l_tell_rec);
343: END get_rec;
344:
345: ------------------------------------------------------------------

Line 1473: -- insert_row for:OKL_TXL_EXTENSION_TL --

1469: '_PVT'
1470: );
1471: END insert_row;
1472: -----------------------------------------
1473: -- insert_row for:OKL_TXL_EXTENSION_TL --
1474: -----------------------------------------
1475: PROCEDURE insert_row(
1476: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1477: x_return_status OUT NOCOPY VARCHAR2,

Line 1493: -- Set_Attributes for:OKL_TXL_EXTENSION_TL --

1489: SELECT *
1490: FROM FND_LANGUAGES
1491: WHERE INSTALLED_FLAG IN ('I', 'B');*/
1492: ---------------------------------------------
1493: -- Set_Attributes for:OKL_TXL_EXTENSION_TL --
1494: ---------------------------------------------
1495: FUNCTION Set_Attributes (
1496: p_tell_rec IN tell_rec_type,
1497: x_tell_rec OUT NOCOPY tell_rec_type

Line 1529: INSERT INTO OKL_TXL_EXTENSION_TL(

1525: RAISE OKL_API.G_EXCEPTION_ERROR;
1526: END IF;
1527: /*FOR l_lang_rec IN get_languages LOOP
1528: l_tell_rec.language := l_lang_rec.language_code;*/
1529: INSERT INTO OKL_TXL_EXTENSION_TL(
1530: line_extension_id,
1531: language,
1532: source_lang,
1533: sfwt_flag,

Line 1960: INSERT INTO OKL_TXL_EXTENSION_TL

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
1961: VALUES l_tell_tbl_in(j);
1962:
1963: -- Return the Inserted table of records
1964: x_telv_tbl := l_telv_tbl_in;

Line 2113: -- lock_row for:OKL_TXL_EXTENSION_TL --

2109: '_PVT'
2110: );
2111: END lock_row;
2112: ---------------------------------------
2113: -- lock_row for:OKL_TXL_EXTENSION_TL --
2114: ---------------------------------------
2115: PROCEDURE lock_row(
2116: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2117: x_return_status OUT NOCOPY VARCHAR2,

Line 2126: FROM OKL_TXL_EXTENSION_TL

2122: E_Resource_Busy EXCEPTION;
2123: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2124: CURSOR lock_csr (p_tell_rec IN tell_rec_type) IS
2125: SELECT *
2126: FROM OKL_TXL_EXTENSION_TL
2127: WHERE LINE_EXTENSION_ID = p_tell_rec.line_extension_id
2128: FOR UPDATE NOWAIT;
2129:
2130: l_api_version CONSTANT NUMBER := 1;

Line 2700: -- update_row for:OKL_TXL_EXTENSION_TL --

2696: '_PVT'
2697: );
2698: END update_row;
2699: -----------------------------------------
2700: -- update_row for:OKL_TXL_EXTENSION_TL --
2701: -----------------------------------------
2702: PROCEDURE update_row(
2703: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2704: x_return_status OUT NOCOPY VARCHAR2,

Line 2768: -- Set_Attributes for:OKL_TXL_EXTENSION_TL --

2764: END IF;
2765: RETURN(l_return_status);
2766: END populate_new_record;
2767: ---------------------------------------------
2768: -- Set_Attributes for:OKL_TXL_EXTENSION_TL --
2769: ---------------------------------------------
2770: FUNCTION Set_Attributes (
2771: p_tell_rec IN tell_rec_type,
2772: x_tell_rec OUT NOCOPY tell_rec_type

Line 2807: UPDATE OKL_TXL_EXTENSION_TL

2803: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2804: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2805: RAISE OKL_API.G_EXCEPTION_ERROR;
2806: END IF;
2807: UPDATE OKL_TXL_EXTENSION_TL
2808: SET INVENTORY_ITEM_NAME = l_def_tell_rec.inventory_item_name,
2809: INVENTORY_ORG_NAME = l_def_tell_rec.inventory_org_name,
2810: CREATED_BY = l_def_tell_rec.created_by,
2811: CREATION_DATE = l_def_tell_rec.creation_date,

Line 2818: UPDATE OKL_TXL_EXTENSION_TL

2814: LAST_UPDATE_LOGIN = l_def_tell_rec.last_update_login
2815: WHERE LINE_EXTENSION_ID = l_def_tell_rec.line_extension_id
2816: AND SOURCE_LANG = USERENV('LANG');
2817:
2818: UPDATE OKL_TXL_EXTENSION_TL
2819: SET SFWT_FLAG = 'Y'
2820: WHERE LINE_EXTENSION_ID = l_def_tell_rec.line_extension_id
2821: AND SOURCE_LANG <> USERENV('LANG');
2822:

Line 3392: -- delete_row for:OKL_TXL_EXTENSION_TL --

3388: '_PVT'
3389: );
3390: END delete_row;
3391: -----------------------------------------
3392: -- delete_row for:OKL_TXL_EXTENSION_TL --
3393: -----------------------------------------
3394: PROCEDURE delete_row(
3395: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
3396: x_return_status OUT NOCOPY VARCHAR2,

Line 3417: DELETE FROM OKL_TXL_EXTENSION_TL

3413: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3414: RAISE OKL_API.G_EXCEPTION_ERROR;
3415: END IF;
3416:
3417: DELETE FROM OKL_TXL_EXTENSION_TL
3418: WHERE LINE_EXTENSION_ID = p_tell_rec.line_extension_id;
3419:
3420: x_return_status := l_return_status;
3421: 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,