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_IEH_PVT dependencies on IEX_EXCLUSION_HIST_TL

Line 100: DELETE FROM IEX_EXCLUSION_HIST_TL T

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

Line 107: UPDATE IEX_EXCLUSION_HIST_TL T SET(

103: FROM IEX_EXCLUSION_HIST_B B
104: WHERE B.EXCLUSION_HISTORY_ID =T.EXCLUSION_HISTORY_ID
105: );
106:
107: UPDATE IEX_EXCLUSION_HIST_TL T SET(
108: EXCLUSION_COMMENT,
109: CANCELLATION_COMMENT,
110: LANGUAGE) = (SELECT
111: B.EXCLUSION_COMMENT,

Line 114: FROM IEX_EXCLUSION_HIST_TL B

110: LANGUAGE) = (SELECT
111: B.EXCLUSION_COMMENT,
112: B.CANCELLATION_COMMENT,
113: B.LANGUAGE
114: FROM IEX_EXCLUSION_HIST_TL B
115: WHERE B.EXCLUSION_HISTORY_ID = T.EXCLUSION_HISTORY_ID)
116: WHERE ( T.EXCLUSION_HISTORY_ID)
117: IN (SELECT
118: SUBT.EXCLUSION_HISTORY_ID

Line 119: FROM IEX_EXCLUSION_HIST_TL SUBB, IEX_EXCLUSION_HIST_TL SUBT

115: WHERE B.EXCLUSION_HISTORY_ID = T.EXCLUSION_HISTORY_ID)
116: WHERE ( T.EXCLUSION_HISTORY_ID)
117: IN (SELECT
118: SUBT.EXCLUSION_HISTORY_ID
119: FROM IEX_EXCLUSION_HIST_TL SUBB, IEX_EXCLUSION_HIST_TL SUBT
120: WHERE SUBB.EXCLUSION_HISTORY_ID = SUBT.EXCLUSION_HISTORY_ID
121: AND (SUBB.EXCLUSION_COMMENT <> SUBT.EXCLUSION_COMMENT
122: OR SUBB.CANCELLATION_COMMENT <> SUBT.CANCELLATION_COMMENT
123: OR SUBB.LANGUAGE <> SUBT.LANGUAGE

Line 129: INSERT INTO IEX_EXCLUSION_HIST_TL (

125: OR (SUBB.CANCELLATION_COMMENT IS NULL AND SUBT.CANCELLATION_COMMENT IS NOT NULL)
126: OR (SUBB.LANGUAGE IS NOT NULL AND SUBT.LANGUAGE IS NULL)
127: ));
128:
129: INSERT INTO IEX_EXCLUSION_HIST_TL (
130: EXCLUSION_HISTORY_ID,
131: EXCLUSION_COMMENT,
132: CANCELLATION_COMMENT,
133: LANGUAGE,

Line 153: FROM IEX_EXCLUSION_HIST_TL B, FND_LANGUAGES L

149: B.CREATION_DATE,
150: B.LAST_UPDATED_BY,
151: B.LAST_UPDATE_DATE,
152: B.LAST_UPDATE_LOGIN
153: FROM IEX_EXCLUSION_HIST_TL B, FND_LANGUAGES L
154: WHERE L.INSTALLED_FLAG IN ('I', 'B')
155: AND B.LANGUAGE = USERENV('LANG')
156: AND NOT EXISTS (
157: SELECT NULL

Line 158: FROM IEX_EXCLUSION_HIST_TL T

154: WHERE L.INSTALLED_FLAG IN ('I', 'B')
155: AND B.LANGUAGE = USERENV('LANG')
156: AND NOT EXISTS (
157: SELECT NULL
158: FROM IEX_EXCLUSION_HIST_TL T
159: WHERE T.EXCLUSION_HISTORY_ID = B.EXCLUSION_HISTORY_ID
160: );
161: END add_language;
162:

Line 289: -- FUNCTION get_rec for: IEX_EXCLUSION_HIST_TL

285: BEGIN
286: RETURN(get_rec(p_iehv_rec, l_row_not_found));
287: END get_rec;
288: ---------------------------------------------------------------------------
289: -- FUNCTION get_rec for: IEX_EXCLUSION_HIST_TL
290: ---------------------------------------------------------------------------
291: FUNCTION get_rec (
292: p_ieht_rec IN ieht_rec_type,
293: x_no_data_found OUT NOCOPY BOOLEAN

Line 295: CURSOR iex_exclusion_hist_tl_pk_csr (p_exclusion_history_id IN NUMBER) IS

291: FUNCTION get_rec (
292: p_ieht_rec IN ieht_rec_type,
293: x_no_data_found OUT NOCOPY BOOLEAN
294: ) RETURN ieht_rec_type AS
295: CURSOR iex_exclusion_hist_tl_pk_csr (p_exclusion_history_id IN NUMBER) IS
296: SELECT
297: EXCLUSION_HISTORY_ID,
298: EXCLUSION_COMMENT,
299: CANCELLATION_COMMENT,

Line 308: FROM Iex_Exclusion_Hist_Tl

304: CREATION_DATE,
305: LAST_UPDATED_BY,
306: LAST_UPDATE_DATE,
307: LAST_UPDATE_LOGIN
308: FROM Iex_Exclusion_Hist_Tl
309: WHERE iex_exclusion_hist_tl.exclusion_history_id = p_exclusion_history_id;
310: l_iex_exclusion_hist_tl_pk iex_exclusion_hist_tl_pk_csr%ROWTYPE;
311: l_ieht_rec ieht_rec_type;
312: BEGIN

Line 309: WHERE iex_exclusion_hist_tl.exclusion_history_id = p_exclusion_history_id;

305: LAST_UPDATED_BY,
306: LAST_UPDATE_DATE,
307: LAST_UPDATE_LOGIN
308: FROM Iex_Exclusion_Hist_Tl
309: WHERE iex_exclusion_hist_tl.exclusion_history_id = p_exclusion_history_id;
310: l_iex_exclusion_hist_tl_pk iex_exclusion_hist_tl_pk_csr%ROWTYPE;
311: l_ieht_rec ieht_rec_type;
312: BEGIN
313: x_no_data_found := TRUE;

Line 310: l_iex_exclusion_hist_tl_pk iex_exclusion_hist_tl_pk_csr%ROWTYPE;

306: LAST_UPDATE_DATE,
307: LAST_UPDATE_LOGIN
308: FROM Iex_Exclusion_Hist_Tl
309: WHERE iex_exclusion_hist_tl.exclusion_history_id = p_exclusion_history_id;
310: l_iex_exclusion_hist_tl_pk iex_exclusion_hist_tl_pk_csr%ROWTYPE;
311: l_ieht_rec ieht_rec_type;
312: BEGIN
313: x_no_data_found := TRUE;
314: -- Get current database values

Line 315: OPEN iex_exclusion_hist_tl_pk_csr (p_ieht_rec.exclusion_history_id);

311: l_ieht_rec ieht_rec_type;
312: BEGIN
313: x_no_data_found := TRUE;
314: -- Get current database values
315: OPEN iex_exclusion_hist_tl_pk_csr (p_ieht_rec.exclusion_history_id);
316: FETCH iex_exclusion_hist_tl_pk_csr INTO
317: l_ieht_rec.exclusion_history_id,
318: l_ieht_rec.exclusion_comment,
319: l_ieht_rec.cancellation_comment,

Line 316: FETCH iex_exclusion_hist_tl_pk_csr INTO

312: BEGIN
313: x_no_data_found := TRUE;
314: -- Get current database values
315: OPEN iex_exclusion_hist_tl_pk_csr (p_ieht_rec.exclusion_history_id);
316: FETCH iex_exclusion_hist_tl_pk_csr INTO
317: l_ieht_rec.exclusion_history_id,
318: l_ieht_rec.exclusion_comment,
319: l_ieht_rec.cancellation_comment,
320: l_ieht_rec.language,

Line 328: x_no_data_found := iex_exclusion_hist_tl_pk_csr%NOTFOUND;

324: l_ieht_rec.creation_date,
325: l_ieht_rec.last_updated_by,
326: l_ieht_rec.last_update_date,
327: l_ieht_rec.last_update_login;
328: x_no_data_found := iex_exclusion_hist_tl_pk_csr%NOTFOUND;
329: CLOSE iex_exclusion_hist_tl_pk_csr;
330: RETURN(l_ieht_rec);
331: END get_rec;
332:

Line 329: CLOSE iex_exclusion_hist_tl_pk_csr;

325: l_ieht_rec.last_updated_by,
326: l_ieht_rec.last_update_date,
327: l_ieht_rec.last_update_login;
328: x_no_data_found := iex_exclusion_hist_tl_pk_csr%NOTFOUND;
329: CLOSE iex_exclusion_hist_tl_pk_csr;
330: RETURN(l_ieht_rec);
331: END get_rec;
332:
333: ------------------------------------------------------------------

Line 1511: -- insert_row for:IEX_EXCLUSION_HIST_TL --

1507: '_PVT'
1508: );
1509: END insert_row;
1510: ------------------------------------------
1511: -- insert_row for:IEX_EXCLUSION_HIST_TL --
1512: ------------------------------------------
1513: PROCEDURE insert_row(
1514: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1515: x_return_status OUT NOCOPY VARCHAR2,

Line 1531: -- Set_Attributes for:IEX_EXCLUSION_HIST_TL --

1527: SELECT *
1528: FROM FND_LANGUAGES
1529: WHERE INSTALLED_FLAG IN ('I', 'B');
1530: ----------------------------------------------
1531: -- Set_Attributes for:IEX_EXCLUSION_HIST_TL --
1532: ----------------------------------------------
1533: FUNCTION Set_Attributes (
1534: p_ieht_rec IN ieht_rec_type,
1535: x_ieht_rec OUT NOCOPY ieht_rec_type

Line 1566: INSERT INTO IEX_EXCLUSION_HIST_TL(

1562: RAISE OKC_API.G_EXCEPTION_ERROR;
1563: END IF;
1564: FOR l_lang_rec IN get_languages LOOP
1565: l_ieht_rec.language := l_lang_rec.language_code;
1566: INSERT INTO IEX_EXCLUSION_HIST_TL(
1567: exclusion_history_id,
1568: exclusion_comment,
1569: cancellation_comment,
1570: language,

Line 2063: -- lock_row for:IEX_EXCLUSION_HIST_TL --

2059: '_PVT'
2060: );
2061: END lock_row;
2062: ----------------------------------------
2063: -- lock_row for:IEX_EXCLUSION_HIST_TL --
2064: ----------------------------------------
2065: PROCEDURE lock_row(
2066: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2067: x_return_status OUT NOCOPY VARCHAR2,

Line 2076: FROM IEX_EXCLUSION_HIST_TL

2072: E_Resource_Busy EXCEPTION;
2073: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2074: CURSOR lock_csr (p_ieht_rec IN ieht_rec_type) IS
2075: SELECT *
2076: FROM IEX_EXCLUSION_HIST_TL
2077: WHERE EXCLUSION_HISTORY_ID = p_ieht_rec.exclusion_history_id
2078: FOR UPDATE NOWAIT;
2079:
2080: l_api_version CONSTANT NUMBER := 1;

Line 2674: -- update_row for:IEX_EXCLUSION_HIST_TL --

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

Line 2753: -- Set_Attributes for:IEX_EXCLUSION_HIST_TL --

2749: END IF;
2750: RETURN(l_return_status);
2751: END populate_new_record;
2752: ----------------------------------------------
2753: -- Set_Attributes for:IEX_EXCLUSION_HIST_TL --
2754: ----------------------------------------------
2755: FUNCTION Set_Attributes (
2756: p_ieht_rec IN ieht_rec_type,
2757: x_ieht_rec OUT NOCOPY ieht_rec_type

Line 2792: UPDATE IEX_EXCLUSION_HIST_TL

2788: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2789: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2790: RAISE OKC_API.G_EXCEPTION_ERROR;
2791: END IF;
2792: UPDATE IEX_EXCLUSION_HIST_TL
2793: SET EXCLUSION_COMMENT = l_def_ieht_rec.exclusion_comment,
2794: CANCELLATION_COMMENT = l_def_ieht_rec.cancellation_comment,
2795: CREATED_BY = l_def_ieht_rec.created_by,
2796: CREATION_DATE = l_def_ieht_rec.creation_date,

Line 2803: UPDATE IEX_EXCLUSION_HIST_TL

2799: LAST_UPDATE_LOGIN = l_def_ieht_rec.last_update_login
2800: WHERE EXCLUSION_HISTORY_ID = l_def_ieht_rec.exclusion_history_id
2801: AND SOURCE_LANG = USERENV('LANG');
2802:
2803: UPDATE IEX_EXCLUSION_HIST_TL
2804: SET SFWT_FLAG = 'Y'
2805: WHERE EXCLUSION_HISTORY_ID = l_def_ieht_rec.exclusion_history_id
2806: AND SOURCE_LANG <> USERENV('LANG');
2807:

Line 3412: -- delete_row for:IEX_EXCLUSION_HIST_TL --

3408: '_PVT'
3409: );
3410: END delete_row;
3411: ------------------------------------------
3412: -- delete_row for:IEX_EXCLUSION_HIST_TL --
3413: ------------------------------------------
3414: PROCEDURE delete_row(
3415: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3416: x_return_status OUT NOCOPY VARCHAR2,

Line 3437: DELETE FROM IEX_EXCLUSION_HIST_TL

3433: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3434: RAISE OKC_API.G_EXCEPTION_ERROR;
3435: END IF;
3436:
3437: DELETE FROM IEX_EXCLUSION_HIST_TL
3438: WHERE EXCLUSION_HISTORY_ID = p_ieht_rec.exclusion_history_id;
3439:
3440: x_return_status := l_return_status;
3441: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);