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.FEM_COL_POPULATION_TMPLT_PKG dependencies on FEM_COL_POPULATION_TMPLT_TL

Line 84: insert into FEM_COL_POPULATION_TMPLT_TL (

80: X_LAST_UPDATED_BY,
81: X_LAST_UPDATE_LOGIN
82: );
83:
84: insert into FEM_COL_POPULATION_TMPLT_TL (
85: COL_POP_TEMPLT_OBJ_DEF_ID,
86: TARGET_TABLE_NAME,
87: TARGET_COLUMN_NAME,
88: SOURCE_TABLE_NAME,

Line 114: from FEM_COL_POPULATION_TMPLT_TL T

110: from FND_LANGUAGES L
111: where L.INSTALLED_FLAG in ('I', 'B')
112: and not exists
113: (select NULL
114: from FEM_COL_POPULATION_TMPLT_TL T
115: where T.COL_POP_TEMPLT_OBJ_DEF_ID = X_COL_POP_TEMPLT_OBJ_DEF_ID
116: and T.SOURCE_TABLE_NAME = X_SOURCE_TABLE_NAME
117: and T.TARGET_COLUMN_NAME = X_TARGET_COLUMN_NAME
118: and T.TARGET_TABLE_NAME = X_TARGET_TABLE_NAME

Line 176: from FEM_COL_POPULATION_TMPLT_TL

172:
173: cursor c1 is select
174: DESCRIPTION,
175: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
176: from FEM_COL_POPULATION_TMPLT_TL
177: where COL_POP_TEMPLT_OBJ_DEF_ID = X_COL_POP_TEMPLT_OBJ_DEF_ID
178: and SOURCE_TABLE_NAME = X_SOURCE_TABLE_NAME
179: and TARGET_COLUMN_NAME = X_TARGET_COLUMN_NAME
180: and TARGET_TABLE_NAME = X_TARGET_TABLE_NAME

Line 287: update FEM_COL_POPULATION_TMPLT_TL set

283: if (sql%notfound) then
284: raise no_data_found;
285: end if;
286:
287: update FEM_COL_POPULATION_TMPLT_TL set
288: DESCRIPTION = X_DESCRIPTION,
289: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
290: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
291: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 311: delete from FEM_COL_POPULATION_TMPLT_TL

307: X_TARGET_COLUMN_NAME in VARCHAR2,
308: X_TARGET_TABLE_NAME in VARCHAR2
309: ) is
310: begin
311: delete from FEM_COL_POPULATION_TMPLT_TL
312: where COL_POP_TEMPLT_OBJ_DEF_ID = X_COL_POP_TEMPLT_OBJ_DEF_ID
313: and SOURCE_TABLE_NAME = X_SOURCE_TABLE_NAME
314: and TARGET_COLUMN_NAME = X_TARGET_COLUMN_NAME
315: and TARGET_TABLE_NAME = X_TARGET_TABLE_NAME;

Line 335: delete from FEM_COL_POPULATION_TMPLT_TL T

331:
332: procedure ADD_LANGUAGE
333: is
334: begin
335: delete from FEM_COL_POPULATION_TMPLT_TL T
336: where not exists
337: (select NULL
338: from FEM_COL_POPULATION_TMPLT_B B
339: where B.COL_POP_TEMPLT_OBJ_DEF_ID = T.COL_POP_TEMPLT_OBJ_DEF_ID

Line 345: update FEM_COL_POPULATION_TMPLT_TL T set (

341: and B.TARGET_COLUMN_NAME = T.TARGET_COLUMN_NAME
342: and B.TARGET_TABLE_NAME = T.TARGET_TABLE_NAME
343: );
344:
345: update FEM_COL_POPULATION_TMPLT_TL T set (
346: DESCRIPTION
347: ) = (select
348: B.DESCRIPTION
349: from FEM_COL_POPULATION_TMPLT_TL B

Line 349: from FEM_COL_POPULATION_TMPLT_TL B

345: update FEM_COL_POPULATION_TMPLT_TL T set (
346: DESCRIPTION
347: ) = (select
348: B.DESCRIPTION
349: from FEM_COL_POPULATION_TMPLT_TL B
350: where B.COL_POP_TEMPLT_OBJ_DEF_ID = T.COL_POP_TEMPLT_OBJ_DEF_ID
351: and B.SOURCE_TABLE_NAME = T.SOURCE_TABLE_NAME
352: and B.TARGET_COLUMN_NAME = T.TARGET_COLUMN_NAME
353: and B.TARGET_TABLE_NAME = T.TARGET_TABLE_NAME

Line 367: from FEM_COL_POPULATION_TMPLT_TL SUBB, FEM_COL_POPULATION_TMPLT_TL SUBT

363: SUBT.SOURCE_TABLE_NAME,
364: SUBT.TARGET_COLUMN_NAME,
365: SUBT.TARGET_TABLE_NAME,
366: SUBT.LANGUAGE
367: from FEM_COL_POPULATION_TMPLT_TL SUBB, FEM_COL_POPULATION_TMPLT_TL SUBT
368: where SUBB.COL_POP_TEMPLT_OBJ_DEF_ID = SUBT.COL_POP_TEMPLT_OBJ_DEF_ID
369: and SUBB.SOURCE_TABLE_NAME = SUBT.SOURCE_TABLE_NAME
370: and SUBB.TARGET_COLUMN_NAME = SUBT.TARGET_COLUMN_NAME
371: and SUBB.TARGET_TABLE_NAME = SUBT.TARGET_TABLE_NAME

Line 378: insert into FEM_COL_POPULATION_TMPLT_TL (

374: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
375: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
376: ));
377:
378: insert into FEM_COL_POPULATION_TMPLT_TL (
379: COL_POP_TEMPLT_OBJ_DEF_ID,
380: TARGET_TABLE_NAME,
381: TARGET_COLUMN_NAME,
382: SOURCE_TABLE_NAME,

Line 404: from FEM_COL_POPULATION_TMPLT_TL B, FND_LANGUAGES L

400: B.LAST_UPDATE_LOGIN,
401: B.DESCRIPTION,
402: L.LANGUAGE_CODE,
403: B.SOURCE_LANG
404: from FEM_COL_POPULATION_TMPLT_TL B, FND_LANGUAGES L
405: where L.INSTALLED_FLAG in ('I', 'B')
406: and B.LANGUAGE = userenv('LANG')
407: and not exists
408: (select NULL

Line 409: from FEM_COL_POPULATION_TMPLT_TL T

405: where L.INSTALLED_FLAG in ('I', 'B')
406: and B.LANGUAGE = userenv('LANG')
407: and not exists
408: (select NULL
409: from FEM_COL_POPULATION_TMPLT_TL T
410: where T.COL_POP_TEMPLT_OBJ_DEF_ID = B.COL_POP_TEMPLT_OBJ_DEF_ID
411: and T.SOURCE_TABLE_NAME = B.SOURCE_TABLE_NAME
412: and T.TARGET_COLUMN_NAME = B.TARGET_COLUMN_NAME
413: and T.TARGET_TABLE_NAME = B.TARGET_TABLE_NAME