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.IEX_IEA_PVT dependencies on IEX_EXT_AGNCY_TL

Line 100: DELETE FROM IEX_EXT_AGNCY_TL T

96: -- PROCEDURE add_language
97: ---------------------------------------------------------------------------
98: PROCEDURE add_language AS
99: BEGIN
100: DELETE FROM IEX_EXT_AGNCY_TL T
101: WHERE NOT EXISTS (
102: SELECT NULL
103: FROM IEX_EXT_AGNCY_B B
104: WHERE B.EXTERNAL_AGENCY_ID =T.EXTERNAL_AGENCY_ID

Line 107: UPDATE IEX_EXT_AGNCY_TL T SET(

103: FROM IEX_EXT_AGNCY_B B
104: WHERE B.EXTERNAL_AGENCY_ID =T.EXTERNAL_AGENCY_ID
105: );
106:
107: UPDATE IEX_EXT_AGNCY_TL T SET(
108: DESCRIPTION) = (SELECT
109: B.DESCRIPTION
110: FROM IEX_EXT_AGNCY_TL B
111: WHERE B.EXTERNAL_AGENCY_ID = T.EXTERNAL_AGENCY_ID

Line 110: FROM IEX_EXT_AGNCY_TL B

106:
107: UPDATE IEX_EXT_AGNCY_TL T SET(
108: DESCRIPTION) = (SELECT
109: B.DESCRIPTION
110: FROM IEX_EXT_AGNCY_TL B
111: WHERE B.EXTERNAL_AGENCY_ID = T.EXTERNAL_AGENCY_ID
112: AND B.LANGUAGE = T.SOURCE_LANG)
113: WHERE ( T.EXTERNAL_AGENCY_ID,
114: T.LANGUAGE)

Line 118: FROM IEX_EXT_AGNCY_TL SUBB, IEX_EXT_AGNCY_TL SUBT

114: T.LANGUAGE)
115: IN (SELECT
116: SUBT.EXTERNAL_AGENCY_ID,
117: SUBT.LANGUAGE
118: FROM IEX_EXT_AGNCY_TL SUBB, IEX_EXT_AGNCY_TL SUBT
119: WHERE SUBB.EXTERNAL_AGENCY_ID = SUBT.EXTERNAL_AGENCY_ID
120: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
121: AND (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
122: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)

Line 125: INSERT INTO IEX_EXT_AGNCY_TL (

121: AND (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
122: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
123: ));
124:
125: INSERT INTO IEX_EXT_AGNCY_TL (
126: EXTERNAL_AGENCY_ID,
127: DESCRIPTION,
128: LANGUAGE,
129: SOURCE_LANG,

Line 147: FROM IEX_EXT_AGNCY_TL B, FND_LANGUAGES L

143: B.CREATION_DATE,
144: B.LAST_UPDATED_BY,
145: B.LAST_UPDATE_DATE,
146: B.LAST_UPDATE_LOGIN
147: FROM IEX_EXT_AGNCY_TL B, FND_LANGUAGES L
148: WHERE L.INSTALLED_FLAG IN ('I', 'B')
149: AND B.LANGUAGE = USERENV('LANG')
150: AND NOT EXISTS (
151: SELECT NULL

Line 152: FROM IEX_EXT_AGNCY_TL T

148: WHERE L.INSTALLED_FLAG IN ('I', 'B')
149: AND B.LANGUAGE = USERENV('LANG')
150: AND NOT EXISTS (
151: SELECT NULL
152: FROM IEX_EXT_AGNCY_TL T
153: WHERE T.EXTERNAL_AGENCY_ID = B.EXTERNAL_AGENCY_ID
154: AND T.LANGUAGE = L.LANGUAGE_CODE
155: );
156: END add_language;

Line 389: -- FUNCTION get_rec for: IEX_EXT_AGNCY_TL

385: BEGIN
386: RETURN(get_rec(p_iea_rec, l_row_not_found));
387: END get_rec;
388: ---------------------------------------------------------------------------
389: -- FUNCTION get_rec for: IEX_EXT_AGNCY_TL
390: ---------------------------------------------------------------------------
391: FUNCTION get_rec (
392: p_ieat_rec IN ieat_rec_type,
393: x_no_data_found OUT NOCOPY BOOLEAN

Line 395: CURSOR iex_ext_agncy_tl_pk_csr (p_external_agency_id IN NUMBER,

391: FUNCTION get_rec (
392: p_ieat_rec IN ieat_rec_type,
393: x_no_data_found OUT NOCOPY BOOLEAN
394: ) RETURN ieat_rec_type AS
395: CURSOR iex_ext_agncy_tl_pk_csr (p_external_agency_id IN NUMBER,
396: p_language IN VARCHAR2) IS
397: SELECT
398: EXTERNAL_AGENCY_ID,
399: DESCRIPTION,

Line 408: FROM Iex_Ext_Agncy_Tl

404: CREATION_DATE,
405: LAST_UPDATED_BY,
406: LAST_UPDATE_DATE,
407: LAST_UPDATE_LOGIN
408: FROM Iex_Ext_Agncy_Tl
409: WHERE iex_ext_agncy_tl.external_agency_id = p_external_agency_id
410: AND iex_ext_agncy_tl.language = p_language;
411: l_iex_ext_agncy_tl_pk iex_ext_agncy_tl_pk_csr%ROWTYPE;
412: l_ieat_rec ieat_rec_type;

Line 409: WHERE iex_ext_agncy_tl.external_agency_id = p_external_agency_id

405: LAST_UPDATED_BY,
406: LAST_UPDATE_DATE,
407: LAST_UPDATE_LOGIN
408: FROM Iex_Ext_Agncy_Tl
409: WHERE iex_ext_agncy_tl.external_agency_id = p_external_agency_id
410: AND iex_ext_agncy_tl.language = p_language;
411: l_iex_ext_agncy_tl_pk iex_ext_agncy_tl_pk_csr%ROWTYPE;
412: l_ieat_rec ieat_rec_type;
413: BEGIN

Line 410: AND iex_ext_agncy_tl.language = p_language;

406: LAST_UPDATE_DATE,
407: LAST_UPDATE_LOGIN
408: FROM Iex_Ext_Agncy_Tl
409: WHERE iex_ext_agncy_tl.external_agency_id = p_external_agency_id
410: AND iex_ext_agncy_tl.language = p_language;
411: l_iex_ext_agncy_tl_pk iex_ext_agncy_tl_pk_csr%ROWTYPE;
412: l_ieat_rec ieat_rec_type;
413: BEGIN
414: x_no_data_found := TRUE;

Line 411: l_iex_ext_agncy_tl_pk iex_ext_agncy_tl_pk_csr%ROWTYPE;

407: LAST_UPDATE_LOGIN
408: FROM Iex_Ext_Agncy_Tl
409: WHERE iex_ext_agncy_tl.external_agency_id = p_external_agency_id
410: AND iex_ext_agncy_tl.language = p_language;
411: l_iex_ext_agncy_tl_pk iex_ext_agncy_tl_pk_csr%ROWTYPE;
412: l_ieat_rec ieat_rec_type;
413: BEGIN
414: x_no_data_found := TRUE;
415: -- Get current database values

Line 416: OPEN iex_ext_agncy_tl_pk_csr (p_ieat_rec.external_agency_id,

412: l_ieat_rec ieat_rec_type;
413: BEGIN
414: x_no_data_found := TRUE;
415: -- Get current database values
416: OPEN iex_ext_agncy_tl_pk_csr (p_ieat_rec.external_agency_id,
417: p_ieat_rec.language);
418: FETCH iex_ext_agncy_tl_pk_csr INTO
419: l_ieat_rec.external_agency_id,
420: l_ieat_rec.description,

Line 418: FETCH iex_ext_agncy_tl_pk_csr INTO

414: x_no_data_found := TRUE;
415: -- Get current database values
416: OPEN iex_ext_agncy_tl_pk_csr (p_ieat_rec.external_agency_id,
417: p_ieat_rec.language);
418: FETCH iex_ext_agncy_tl_pk_csr INTO
419: l_ieat_rec.external_agency_id,
420: l_ieat_rec.description,
421: l_ieat_rec.language,
422: l_ieat_rec.source_lang,

Line 429: x_no_data_found := iex_ext_agncy_tl_pk_csr%NOTFOUND;

425: l_ieat_rec.creation_date,
426: l_ieat_rec.last_updated_by,
427: l_ieat_rec.last_update_date,
428: l_ieat_rec.last_update_login;
429: x_no_data_found := iex_ext_agncy_tl_pk_csr%NOTFOUND;
430: CLOSE iex_ext_agncy_tl_pk_csr;
431: RETURN(l_ieat_rec);
432: END get_rec;
433:

Line 430: CLOSE iex_ext_agncy_tl_pk_csr;

426: l_ieat_rec.last_updated_by,
427: l_ieat_rec.last_update_date,
428: l_ieat_rec.last_update_login;
429: x_no_data_found := iex_ext_agncy_tl_pk_csr%NOTFOUND;
430: CLOSE iex_ext_agncy_tl_pk_csr;
431: RETURN(l_ieat_rec);
432: END get_rec;
433:
434: ------------------------------------------------------------------

Line 1525: -- insert_row for:IEX_EXT_AGNCY_TL --

1521: '_PVT'
1522: );
1523: END insert_row;
1524: -------------------------------------
1525: -- insert_row for:IEX_EXT_AGNCY_TL --
1526: -------------------------------------
1527: PROCEDURE insert_row(
1528: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1529: x_return_status OUT NOCOPY VARCHAR2,

Line 1545: -- Set_Attributes for:IEX_EXT_AGNCY_TL --

1541: SELECT *
1542: FROM FND_LANGUAGES
1543: WHERE INSTALLED_FLAG IN ('I', 'B');
1544: -----------------------------------------
1545: -- Set_Attributes for:IEX_EXT_AGNCY_TL --
1546: -----------------------------------------
1547: FUNCTION Set_Attributes (
1548: p_ieat_rec IN ieat_rec_type,
1549: x_ieat_rec OUT NOCOPY ieat_rec_type

Line 1580: INSERT INTO IEX_EXT_AGNCY_TL(

1576: RAISE OKC_API.G_EXCEPTION_ERROR;
1577: END IF;
1578: FOR l_lang_rec IN get_languages LOOP
1579: l_ieat_rec.language := l_lang_rec.language_code;
1580: INSERT INTO IEX_EXT_AGNCY_TL(
1581: external_agency_id,
1582: description,
1583: language,
1584: source_lang,

Line 2075: -- lock_row for:IEX_EXT_AGNCY_TL --

2071: '_PVT'
2072: );
2073: END lock_row;
2074: -----------------------------------
2075: -- lock_row for:IEX_EXT_AGNCY_TL --
2076: -----------------------------------
2077: PROCEDURE lock_row(
2078: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2079: x_return_status OUT NOCOPY VARCHAR2,

Line 2088: FROM IEX_EXT_AGNCY_TL

2084: E_Resource_Busy EXCEPTION;
2085: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2086: CURSOR lock_csr (p_ieat_rec IN ieat_rec_type) IS
2087: SELECT *
2088: FROM IEX_EXT_AGNCY_TL
2089: WHERE EXTERNAL_AGENCY_ID = p_ieat_rec.external_agency_id
2090: FOR UPDATE NOWAIT;
2091:
2092: l_api_version CONSTANT NUMBER := 1;

Line 2676: -- update_row for:IEX_EXT_AGNCY_TL --

2672: '_PVT'
2673: );
2674: END update_row;
2675: -------------------------------------
2676: -- update_row for:IEX_EXT_AGNCY_TL --
2677: -------------------------------------
2678: PROCEDURE update_row(
2679: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2680: x_return_status OUT NOCOPY VARCHAR2,

Line 2751: -- Set_Attributes for:IEX_EXT_AGNCY_TL --

2747: END IF;
2748: RETURN(l_return_status);
2749: END populate_new_record;
2750: -----------------------------------------
2751: -- Set_Attributes for:IEX_EXT_AGNCY_TL --
2752: -----------------------------------------
2753: FUNCTION Set_Attributes (
2754: p_ieat_rec IN ieat_rec_type,
2755: x_ieat_rec OUT NOCOPY ieat_rec_type

Line 2790: UPDATE IEX_EXT_AGNCY_TL

2786: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2787: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2788: RAISE OKC_API.G_EXCEPTION_ERROR;
2789: END IF;
2790: UPDATE IEX_EXT_AGNCY_TL
2791: SET DESCRIPTION = l_def_ieat_rec.description,
2792: CREATED_BY = l_def_ieat_rec.created_by,
2793: CREATION_DATE = l_def_ieat_rec.creation_date,
2794: LAST_UPDATED_BY = l_def_ieat_rec.last_updated_by,

Line 2800: UPDATE IEX_EXT_AGNCY_TL

2796: LAST_UPDATE_LOGIN = l_def_ieat_rec.last_update_login
2797: WHERE EXTERNAL_AGENCY_ID = l_def_ieat_rec.external_agency_id
2798: AND SOURCE_LANG = USERENV('LANG');
2799:
2800: UPDATE IEX_EXT_AGNCY_TL
2801: SET SFWT_FLAG = 'Y'
2802: WHERE EXTERNAL_AGENCY_ID = l_def_ieat_rec.external_agency_id
2803: AND SOURCE_LANG <> USERENV('LANG');
2804:

Line 3397: -- delete_row for:IEX_EXT_AGNCY_TL --

3393: '_PVT'
3394: );
3395: END delete_row;
3396: -------------------------------------
3397: -- delete_row for:IEX_EXT_AGNCY_TL --
3398: -------------------------------------
3399: PROCEDURE delete_row(
3400: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3401: x_return_status OUT NOCOPY VARCHAR2,

Line 3422: DELETE FROM IEX_EXT_AGNCY_TL

3418: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3419: RAISE OKC_API.G_EXCEPTION_ERROR;
3420: END IF;
3421:
3422: DELETE FROM IEX_EXT_AGNCY_TL
3423: WHERE EXTERNAL_AGENCY_ID = p_ieat_rec.external_agency_id;
3424:
3425: x_return_status := l_return_status;
3426: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);