APPS.FRM_DIRECTORY_PKG dependencies on FRM_DIRECTORY_TL

Line 42: insert into FRM_DIRECTORY_TL (

38: X_LAST_UPDATED_BY,
39: X_LAST_UPDATE_LOGIN
40: );
41:
42: insert into FRM_DIRECTORY_TL (
43: DIRECTORY_ID,
44: USER_NAME,
45: CREATION_DATE,
46: CREATED_BY,

Line 66: from FRM_DIRECTORY_TL T

62: from FND_LANGUAGES L
63: where L.INSTALLED_FLAG in ('I', 'B')
64: and not exists
65: (select NULL
66: from FRM_DIRECTORY_TL T
67: where T.DIRECTORY_ID = X_DIRECTORY_ID
68: and T.LANGUAGE = L.LANGUAGE_CODE);
69:
70: open c;

Line 99: from FRM_DIRECTORY_TL

95:
96: cursor c1 is select
97: USER_NAME,
98: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
99: from FRM_DIRECTORY_TL
100: where DIRECTORY_ID = X_DIRECTORY_ID
101: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
102: for update of DIRECTORY_ID nowait;
103: begin

Line 161: update FRM_DIRECTORY_TL set

157: if (sql%notfound) then
158: raise no_data_found;
159: end if;
160:
161: update FRM_DIRECTORY_TL set
162: USER_NAME = X_USER_NAME,
163: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
164: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
165: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 179: delete from FRM_DIRECTORY_TL

175: procedure DELETE_ROW (
176: X_DIRECTORY_ID in NUMBER
177: ) is
178: begin
179: delete from FRM_DIRECTORY_TL
180: where DIRECTORY_ID = X_DIRECTORY_ID;
181:
182: if (sql%notfound) then
183: raise no_data_found;

Line 197: delete from FRM_DIRECTORY_TL T

193:
194: procedure ADD_LANGUAGE
195: is
196: begin
197: delete from FRM_DIRECTORY_TL T
198: where not exists
199: (select NULL
200: from FRM_DIRECTORY_B B
201: where B.DIRECTORY_ID = T.DIRECTORY_ID

Line 204: update FRM_DIRECTORY_TL T set (

200: from FRM_DIRECTORY_B B
201: where B.DIRECTORY_ID = T.DIRECTORY_ID
202: );
203:
204: update FRM_DIRECTORY_TL T set (
205: USER_NAME
206: ) = (select
207: B.USER_NAME
208: from FRM_DIRECTORY_TL B

Line 208: from FRM_DIRECTORY_TL B

204: update FRM_DIRECTORY_TL T set (
205: USER_NAME
206: ) = (select
207: B.USER_NAME
208: from FRM_DIRECTORY_TL B
209: where B.DIRECTORY_ID = T.DIRECTORY_ID
210: and B.LANGUAGE = T.SOURCE_LANG)
211: where (
212: T.DIRECTORY_ID,

Line 217: from FRM_DIRECTORY_TL SUBB, FRM_DIRECTORY_TL SUBT

213: T.LANGUAGE
214: ) in (select
215: SUBT.DIRECTORY_ID,
216: SUBT.LANGUAGE
217: from FRM_DIRECTORY_TL SUBB, FRM_DIRECTORY_TL SUBT
218: where SUBB.DIRECTORY_ID = SUBT.DIRECTORY_ID
219: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
220: and (SUBB.USER_NAME <> SUBT.USER_NAME
221: ));

Line 223: insert into FRM_DIRECTORY_TL (

219: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
220: and (SUBB.USER_NAME <> SUBT.USER_NAME
221: ));
222:
223: insert into FRM_DIRECTORY_TL (
224: DIRECTORY_ID,
225: USER_NAME,
226: CREATION_DATE,
227: CREATED_BY,

Line 243: from FRM_DIRECTORY_TL B, FND_LANGUAGES L

239: B.LAST_UPDATE_LOGIN,
240: B.LAST_UPDATE_DATE,
241: L.LANGUAGE_CODE,
242: B.SOURCE_LANG
243: from FRM_DIRECTORY_TL B, FND_LANGUAGES L
244: where L.INSTALLED_FLAG in ('I', 'B')
245: and B.LANGUAGE = userenv('LANG')
246: and not exists
247: (select NULL

Line 248: from FRM_DIRECTORY_TL T

244: where L.INSTALLED_FLAG in ('I', 'B')
245: and B.LANGUAGE = userenv('LANG')
246: and not exists
247: (select NULL
248: from FRM_DIRECTORY_TL T
249: where T.DIRECTORY_ID = B.DIRECTORY_ID
250: and T.LANGUAGE = L.LANGUAGE_CODE);
251: end ADD_LANGUAGE;
252:

Line 365: from FRM_DIRECTORY_TL

361: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
362: begin
363: select LAST_UPDATED_BY, LAST_UPDATE_DATE
364: into db_luby, db_ludate
365: from FRM_DIRECTORY_TL
366: where DIRECTORY_ID = x_directory_id
367: and LANGUAGE = userenv('LANG');
368:
369: -- Test for customization and version

Line 373: update FRM_DIRECTORY_TL

369: -- Test for customization and version
370: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
371: db_ludate, x_custom_mode)) then
372:
373: update FRM_DIRECTORY_TL
374: set USER_NAME = x_user_name,
375: LAST_UPDATE_DATE = f_ludate,
376: LAST_UPDATED_BY = f_luby,
377: LAST_UPDATE_LOGIN = 0,