APPS.FRM_DOCUMENTS_PKG dependencies on FRM_DOCUMENTS_TL

Line 51: insert into FRM_DOCUMENTS_TL (

47: X_LAST_UPDATED_BY,
48: X_LAST_UPDATE_LOGIN
49: );
50:
51: insert into FRM_DOCUMENTS_TL (
52: DOCUMENT_ID,
53: USER_NAME,
54: CREATION_DATE,
55: CREATED_BY,

Line 75: from FRM_DOCUMENTS_TL T

71: from FND_LANGUAGES L
72: where L.INSTALLED_FLAG in ('I', 'B')
73: and not exists
74: (select NULL
75: from FRM_DOCUMENTS_TL T
76: where T.DOCUMENT_ID = X_DOCUMENT_ID
77: and T.LANGUAGE = L.LANGUAGE_CODE);
78:
79: open c;

Line 114: from FRM_DOCUMENTS_TL

110:
111: cursor c1 is select
112: USER_NAME,
113: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
114: from FRM_DOCUMENTS_TL
115: where DOCUMENT_ID = X_DOCUMENT_ID
116: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
117: for update of DOCUMENT_ID nowait;
118: begin

Line 187: update FRM_DOCUMENTS_TL set

183: if (sql%notfound) then
184: raise no_data_found;
185: end if;
186:
187: update FRM_DOCUMENTS_TL set
188: USER_NAME = X_USER_NAME,
189: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
190: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
191: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 205: delete from FRM_DOCUMENTS_TL

201: procedure DELETE_ROW (
202: X_DOCUMENT_ID in NUMBER
203: ) is
204: begin
205: delete from FRM_DOCUMENTS_TL
206: where DOCUMENT_ID = X_DOCUMENT_ID;
207:
208: if (sql%notfound) then
209: raise no_data_found;

Line 223: delete from FRM_DOCUMENTS_TL T

219:
220: procedure ADD_LANGUAGE
221: is
222: begin
223: delete from FRM_DOCUMENTS_TL T
224: where not exists
225: (select NULL
226: from FRM_DOCUMENTS_B B
227: where B.DOCUMENT_ID = T.DOCUMENT_ID

Line 230: update FRM_DOCUMENTS_TL T set (

226: from FRM_DOCUMENTS_B B
227: where B.DOCUMENT_ID = T.DOCUMENT_ID
228: );
229:
230: update FRM_DOCUMENTS_TL T set (
231: USER_NAME
232: ) = (select
233: B.USER_NAME
234: from FRM_DOCUMENTS_TL B

Line 234: from FRM_DOCUMENTS_TL B

230: update FRM_DOCUMENTS_TL T set (
231: USER_NAME
232: ) = (select
233: B.USER_NAME
234: from FRM_DOCUMENTS_TL B
235: where B.DOCUMENT_ID = T.DOCUMENT_ID
236: and B.LANGUAGE = T.SOURCE_LANG)
237: where (
238: T.DOCUMENT_ID,

Line 243: from FRM_DOCUMENTS_TL SUBB, FRM_DOCUMENTS_TL SUBT

239: T.LANGUAGE
240: ) in (select
241: SUBT.DOCUMENT_ID,
242: SUBT.LANGUAGE
243: from FRM_DOCUMENTS_TL SUBB, FRM_DOCUMENTS_TL SUBT
244: where SUBB.DOCUMENT_ID = SUBT.DOCUMENT_ID
245: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
246: and (SUBB.USER_NAME <> SUBT.USER_NAME
247: ));

Line 249: insert into FRM_DOCUMENTS_TL (

245: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
246: and (SUBB.USER_NAME <> SUBT.USER_NAME
247: ));
248:
249: insert into FRM_DOCUMENTS_TL (
250: DOCUMENT_ID,
251: USER_NAME,
252: CREATION_DATE,
253: CREATED_BY,

Line 269: from FRM_DOCUMENTS_TL B, FND_LANGUAGES L

265: B.LAST_UPDATE_LOGIN,
266: B.LAST_UPDATE_DATE,
267: L.LANGUAGE_CODE,
268: B.SOURCE_LANG
269: from FRM_DOCUMENTS_TL B, FND_LANGUAGES L
270: where L.INSTALLED_FLAG in ('I', 'B')
271: and B.LANGUAGE = userenv('LANG')
272: and not exists
273: (select NULL

Line 274: from FRM_DOCUMENTS_TL T

270: where L.INSTALLED_FLAG in ('I', 'B')
271: and B.LANGUAGE = userenv('LANG')
272: and not exists
273: (select NULL
274: from FRM_DOCUMENTS_TL T
275: where T.DOCUMENT_ID = B.DOCUMENT_ID
276: and T.LANGUAGE = L.LANGUAGE_CODE);
277: end ADD_LANGUAGE;
278:

Line 400: from FRM_DOCUMENTS_TL

396: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
397: begin
398: select LAST_UPDATED_BY, LAST_UPDATE_DATE
399: into db_luby, db_ludate
400: from FRM_DOCUMENTS_TL
401: where DOCUMENT_ID = x_document_id
402: and LANGUAGE = userenv('LANG');
403:
404: -- Test for customization and version

Line 408: update FRM_DOCUMENTS_TL

404: -- Test for customization and version
405: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
406: db_ludate, x_custom_mode)) then
407:
408: update FRM_DOCUMENTS_TL
409: set USER_NAME = x_user_name,
410: LAST_UPDATE_DATE = f_ludate,
411: LAST_UPDATED_BY = f_luby,
412: LAST_UPDATE_LOGIN = 0,