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.ECX_XREF_HDR_PKG dependencies on ECX_XREF_HDR

Line 1: package body ECX_XREF_HDR_PKG as

1: package body ECX_XREF_HDR_PKG as
2: /* $Header: ECXXRFHB.pls 120.2 2005/06/30 11:19:14 appldev ship $ */
3:
4: procedure TRANSLATE_ROW (
5: X_XREF_CATEGORY_CODE IN VARCHAR2,

Line 30: from ecx_xref_hdr

26:
27: begin
28: select xref_category_id
29: into l_hdr_id
30: from ecx_xref_hdr
31: where XREF_CATEGORY_CODE = x_xref_category_code;
32:
33: select LAST_UPDATED_BY, LAST_UPDATE_DATE
34: into l_db_luby, l_db_ludate

Line 35: from ECX_XREF_HDR_TL

31: where XREF_CATEGORY_CODE = x_xref_category_code;
32:
33: select LAST_UPDATED_BY, LAST_UPDATE_DATE
34: into l_db_luby, l_db_ludate
35: from ECX_XREF_HDR_TL
36: where XREF_CATEGORY_ID = l_hdr_id
37: and LANGUAGE = userenv('LANG');
38:
39: -- Update record, honoring customization mode.

Line 48: update ECX_XREF_HDR_TL set

44: if ((x_custom_mode = 'FORCE') or
45: ((l_luby = 0) and (l_db_luby = 1)) or
46: ((l_luby = l_db_luby) and (l_ludate > l_db_ludate)))
47: then
48: update ECX_XREF_HDR_TL set
49: DESCRIPTION = nvl(x_description, DESCRIPTION),
50: SOURCE_LANG = userenv('LANG'),
51: LAST_UPDATE_DATE = l_ludate,
52: LAST_UPDATED_BY = l_luby,

Line 94: from ECX_XREF_HDR_B

90:
91: begin
92: select XREF_CATEGORY_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE
93: into l_hdr_id, l_db_luby, l_db_ludate
94: from ECX_XREF_HDR_B
95: where XREF_CATEGORY_CODE = x_xref_category_code;
96:
97: -- Update record, honoring customization mode.
98: -- Record should be updated only if:

Line 147: cursor C is select ROWID from ECX_XREF_HDR_B

143: X_LAST_UPDATE_DATE in DATE,
144: X_LAST_UPDATED_BY in NUMBER,
145: X_LAST_UPDATE_LOGIN in NUMBER
146: ) is
147: cursor C is select ROWID from ECX_XREF_HDR_B
148: where XREF_CATEGORY_ID = X_XREF_CATEGORY_ID
149: ;
150: begin
151: insert into ECX_XREF_HDR_B (

Line 151: insert into ECX_XREF_HDR_B (

147: cursor C is select ROWID from ECX_XREF_HDR_B
148: where XREF_CATEGORY_ID = X_XREF_CATEGORY_ID
149: ;
150: begin
151: insert into ECX_XREF_HDR_B (
152: XREF_CATEGORY_ID,
153: XREF_CATEGORY_CODE,
154: CREATION_DATE,
155: CREATED_BY,

Line 169: insert into ECX_XREF_HDR_TL (

165: X_LAST_UPDATED_BY,
166: X_LAST_UPDATE_LOGIN
167: );
168:
169: insert into ECX_XREF_HDR_TL (
170: DESCRIPTION,
171: LAST_UPDATE_DATE,
172: LAST_UPDATED_BY,
173: CREATION_DATE,

Line 193: from ECX_XREF_HDR_TL T

189: from WF_LANGUAGES L
190: where L.INSTALLED_FLAG = 'Y'
191: and not exists
192: (select NULL
193: from ECX_XREF_HDR_TL T
194: where T.XREF_CATEGORY_ID = X_XREF_CATEGORY_ID
195: and T.LANGUAGE = L.CODE);
196:
197: open c;

Line 214: from ECX_XREF_HDR_B

210: X_DESCRIPTION in VARCHAR2
211: ) is
212: cursor c is select
213: XREF_CATEGORY_CODE
214: from ECX_XREF_HDR_B
215: where XREF_CATEGORY_ID = X_XREF_CATEGORY_ID
216: for update of XREF_CATEGORY_ID nowait;
217: recinfo c%rowtype;
218:

Line 222: from ECX_XREF_HDR_TL

218:
219: cursor c1 is select
220: DESCRIPTION,
221: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
222: from ECX_XREF_HDR_TL
223: where XREF_CATEGORY_ID = X_XREF_CATEGORY_ID
224: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
225: for update of XREF_CATEGORY_ID nowait;
226: begin

Line 267: update ECX_XREF_HDR_B set

263: X_LAST_UPDATED_BY in NUMBER,
264: X_LAST_UPDATE_LOGIN in NUMBER
265: ) is
266: begin
267: update ECX_XREF_HDR_B set
268: XREF_CATEGORY_CODE = X_XREF_CATEGORY_CODE,
269: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
270: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
271: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 278: update ECX_XREF_HDR_TL set

274: if (sql%notfound) then
275: raise no_data_found;
276: end if;
277:
278: update ECX_XREF_HDR_TL set
279: DESCRIPTION = X_DESCRIPTION,
280: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
281: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
282: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 296: delete from ECX_XREF_HDR_TL

292: procedure DELETE_ROW (
293: X_XREF_CATEGORY_ID in NUMBER
294: ) is
295: begin
296: delete from ECX_XREF_HDR_TL
297: where XREF_CATEGORY_ID = X_XREF_CATEGORY_ID;
298:
299: if (sql%notfound) then
300: raise no_data_found;

Line 303: delete from ECX_XREF_HDR_B

299: if (sql%notfound) then
300: raise no_data_found;
301: end if;
302:
303: delete from ECX_XREF_HDR_B
304: where XREF_CATEGORY_ID = X_XREF_CATEGORY_ID;
305:
306: if (sql%notfound) then
307: raise no_data_found;

Line 314: delete from ECX_XREF_HDR_TL T

310:
311: procedure ADD_LANGUAGE
312: is
313: begin
314: delete from ECX_XREF_HDR_TL T
315: where not exists
316: (select NULL
317: from ECX_XREF_HDR_B B
318: where B.XREF_CATEGORY_ID = T.XREF_CATEGORY_ID

Line 317: from ECX_XREF_HDR_B B

313: begin
314: delete from ECX_XREF_HDR_TL T
315: where not exists
316: (select NULL
317: from ECX_XREF_HDR_B B
318: where B.XREF_CATEGORY_ID = T.XREF_CATEGORY_ID
319: );
320:
321: update ECX_XREF_HDR_TL T set (

Line 321: update ECX_XREF_HDR_TL T set (

317: from ECX_XREF_HDR_B B
318: where B.XREF_CATEGORY_ID = T.XREF_CATEGORY_ID
319: );
320:
321: update ECX_XREF_HDR_TL T set (
322: DESCRIPTION
323: ) = (select
324: B.DESCRIPTION
325: from ECX_XREF_HDR_TL B

Line 325: from ECX_XREF_HDR_TL B

321: update ECX_XREF_HDR_TL T set (
322: DESCRIPTION
323: ) = (select
324: B.DESCRIPTION
325: from ECX_XREF_HDR_TL B
326: where B.XREF_CATEGORY_ID = T.XREF_CATEGORY_ID
327: and B.LANGUAGE = T.SOURCE_LANG)
328: where (
329: T.XREF_CATEGORY_ID,

Line 334: from ECX_XREF_HDR_TL SUBB, ECX_XREF_HDR_TL SUBT

330: T.LANGUAGE
331: ) in (select
332: SUBT.XREF_CATEGORY_ID,
333: SUBT.LANGUAGE
334: from ECX_XREF_HDR_TL SUBB, ECX_XREF_HDR_TL SUBT
335: where SUBB.XREF_CATEGORY_ID = SUBT.XREF_CATEGORY_ID
336: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
337: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
338: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 342: insert into ECX_XREF_HDR_TL (

338: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
339: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
340: ));
341:
342: insert into ECX_XREF_HDR_TL (
343: DESCRIPTION,
344: LAST_UPDATE_DATE,
345: LAST_UPDATED_BY,
346: CREATION_DATE,

Line 362: from ECX_XREF_HDR_TL B, WF_LANGUAGES L

358: B.LAST_UPDATE_LOGIN,
359: B.XREF_CATEGORY_ID,
360: L.CODE,
361: B.SOURCE_LANG
362: from ECX_XREF_HDR_TL B, WF_LANGUAGES L
363: where L.INSTALLED_FLAG = 'Y'
364: and B.LANGUAGE = userenv('LANG')
365: and not exists
366: (select NULL

Line 367: from ECX_XREF_HDR_TL T

363: where L.INSTALLED_FLAG = 'Y'
364: and B.LANGUAGE = userenv('LANG')
365: and not exists
366: (select NULL
367: from ECX_XREF_HDR_TL T
368: where T.XREF_CATEGORY_ID = B.XREF_CATEGORY_ID
369: and T.LANGUAGE = L.CODE);
370: end ADD_LANGUAGE;
371:

Line 372: end ECX_XREF_HDR_PKG;

368: where T.XREF_CATEGORY_ID = B.XREF_CATEGORY_ID
369: and T.LANGUAGE = L.CODE);
370: end ADD_LANGUAGE;
371:
372: end ECX_XREF_HDR_PKG;