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.FND_DOCUMENT_DATATYPES_PKG dependencies on FND_DOCUMENT_DATATYPES

Line 1: package body FND_DOCUMENT_DATATYPES_PKG as

1: package body FND_DOCUMENT_DATATYPES_PKG as
2: /* $Header: AFAKDTPB.pls 115.15 2004/05/27 21:07:41 blash ship $ */
3:
4:
5: procedure INSERT_ROW (

Line 19: cursor C is select ROWID from FND_DOCUMENT_DATATYPES

15: X_LAST_UPDATE_DATE in DATE,
16: X_LAST_UPDATED_BY in NUMBER,
17: X_LAST_UPDATE_LOGIN in NUMBER
18: )is
19: cursor C is select ROWID from FND_DOCUMENT_DATATYPES
20: where DATATYPE_ID = X_DATATYPE_ID
21: and LANGUAGE = X_LANGUAGE
22: and NAME = X_NAME
23: and LANGUAGE = userenv('LANG');

Line 25: insert into FND_DOCUMENT_DATATYPES (

21: and LANGUAGE = X_LANGUAGE
22: and NAME = X_NAME
23: and LANGUAGE = userenv('LANG');
24: begin
25: insert into FND_DOCUMENT_DATATYPES (
26: DATATYPE_ID,
27: NAME,
28: USER_NAME,
29: CREATION_DATE,

Line 55: from FND_DOCUMENT_DATATYPES T

51: from FND_LANGUAGES L
52: where L.INSTALLED_FLAG in ('I', 'B')
53: and not exists
54: (select NULL
55: from FND_DOCUMENT_DATATYPES T
56: where T.DATATYPE_ID = X_DATATYPE_ID
57: and T.LANGUAGE = X_LANGUAGE
58: and T.NAME = X_NAME
59: and T.LANGUAGE = L.LANGUAGE_CODE);

Line 83: from FND_DOCUMENT_DATATYPES

79: cursor c1 is select
80: START_DATE_ACTIVE,
81: END_DATE_ACTIVE,
82: USER_NAME
83: from FND_DOCUMENT_DATATYPES
84: where DATATYPE_ID = X_DATATYPE_ID
85: and LANGUAGE = X_LANGUAGE
86: and NAME = X_NAME
87: and LANGUAGE = userenv('LANG')

Line 126: update FND_DOCUMENT_DATATYPES set

122: X_LAST_UPDATED_BY in NUMBER,
123: X_LAST_UPDATE_LOGIN in NUMBER
124: ) is
125: begin
126: update FND_DOCUMENT_DATATYPES set
127: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
128: END_DATE_ACTIVE = X_END_DATE_ACTIVE,
129: USER_NAME = X_USER_NAME,
130: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 150: delete from FND_DOCUMENT_DATATYPES

146: X_LANGUAGE in VARCHAR2,
147: X_NAME in VARCHAR2
148: ) is
149: begin
150: delete from FND_DOCUMENT_DATATYPES
151: where DATATYPE_ID = X_DATATYPE_ID
152: and LANGUAGE = X_LANGUAGE
153: and NAME = X_NAME;
154:

Line 170: update FND_DOCUMENT_DATATYPES T set (

166: /* as a quick workaround to fix the time-consuming table handler issue */
167: /* Eventually we'll need to turn them into a separate fix_language procedure */
168: /*
169:
170: update FND_DOCUMENT_DATATYPES T set (
171: USER_NAME
172: ) = (select
173: B.USER_NAME
174: from FND_DOCUMENT_DATATYPES B

Line 174: from FND_DOCUMENT_DATATYPES B

170: update FND_DOCUMENT_DATATYPES T set (
171: USER_NAME
172: ) = (select
173: B.USER_NAME
174: from FND_DOCUMENT_DATATYPES B
175: where B.DATATYPE_ID = T.DATATYPE_ID
176: and B.NAME = T.NAME
177: and B.LANGUAGE = T.SOURCE_LANG)
178: where (

Line 186: from FND_DOCUMENT_DATATYPES SUBB, FND_DOCUMENT_DATATYPES SUBT

182: ) in (select
183: SUBT.DATATYPE_ID,
184: SUBT.NAME,
185: SUBT.LANGUAGE
186: from FND_DOCUMENT_DATATYPES SUBB, FND_DOCUMENT_DATATYPES SUBT
187: where SUBB.DATATYPE_ID = SUBT.DATATYPE_ID
188: and SUBB.NAME = SUBT.NAME
189: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
190: and (SUBB.USER_NAME <> SUBT.USER_NAME

Line 194: insert into FND_DOCUMENT_DATATYPES (

190: and (SUBB.USER_NAME <> SUBT.USER_NAME
191: ));
192: */
193:
194: insert into FND_DOCUMENT_DATATYPES (
195: DATATYPE_ID,
196: NAME,
197: USER_NAME,
198: CREATION_DATE,

Line 220: from FND_DOCUMENT_DATATYPES B, FND_LANGUAGES L

216: B.START_DATE_ACTIVE,
217: B.END_DATE_ACTIVE,
218: L.LANGUAGE_CODE,
219: B.SOURCE_LANG
220: from FND_DOCUMENT_DATATYPES B, FND_LANGUAGES L
221: where L.INSTALLED_FLAG in ('I', 'B')
222: and B.LANGUAGE = userenv('LANG')
223: and not exists
224: (select NULL

Line 225: from FND_DOCUMENT_DATATYPES T

221: where L.INSTALLED_FLAG in ('I', 'B')
222: and B.LANGUAGE = userenv('LANG')
223: and not exists
224: (select NULL
225: from FND_DOCUMENT_DATATYPES T
226: where T.DATATYPE_ID = B.DATATYPE_ID
227: and T.NAME = B.NAME
228: and T.LANGUAGE = L.LANGUAGE_CODE);
229: end ADD_LANGUAGE;

Line 238: update fnd_document_datatypes set

234: X_USER_NAME in VARCHAR2,
235: X_OWNER in VARCHAR2) IS
236: begin
237:
238: update fnd_document_datatypes set
239: user_name = nvl(X_USER_NAME,user_name),
240: last_update_date = sysdate,
241: last_updated_by = decode(X_OWNER, 'SEED', 1, 0),
242: last_update_login = 0,

Line 273: from fnd_document_datatypes

269: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
270:
271: select LAST_UPDATED_BY, LAST_UPDATE_DATE
272: into db_luby, db_ludate
273: from fnd_document_datatypes
274: where name = X_NAME
275: and datatype_id = to_number(X_DATATYPE_ID)
276: and LANGUAGE = userenv('LANG');
277:

Line 280: update fnd_document_datatypes set

276: and LANGUAGE = userenv('LANG');
277:
278: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
279: db_ludate, X_CUSTOM_MODE)) then
280: update fnd_document_datatypes set
281: user_name = nvl(X_USER_NAME,user_name),
282: last_update_date = f_ludate,
283: last_updated_by = f_luby,
284: last_update_login = 0,

Line 368: from fnd_document_datatypes

364: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
365:
366: select LAST_UPDATED_BY, LAST_UPDATE_DATE
367: into db_luby, db_ludate
368: from fnd_document_datatypes
369: where name = X_NAME
370: and language = userenv('LANG')
371: and datatype_id = to_number(X_DATATYPE_ID);
372:

Line 406: end FND_DOCUMENT_DATATYPES_PKG;

402: X_LAST_UPDATE_LOGIN => 0);
403:
404: end LOAD_ROW;
405:
406: end FND_DOCUMENT_DATATYPES_PKG;