APPS.JTF_DPF_LOGICAL_PAGES_PKG dependencies on JTF_DPF_LOGICAL_PAGES_TL

Line 62: insert into JTF_DPF_LOGICAL_PAGES_TL (

58: X_LAST_UPDATED_BY,
59: X_LAST_UPDATE_LOGIN
60: );
61:
62: insert into JTF_DPF_LOGICAL_PAGES_TL (
63: LOGICAL_PAGE_ID,
64: LOGICAL_PAGE_DESCRIPTION,
65: CREATED_BY,
66: LAST_UPDATE_DATE,

Line 84: from JTF_DPF_LOGICAL_PAGES_TL T

80: from FND_LANGUAGES L
81: where L.INSTALLED_FLAG in ('I', 'B')
82: and not exists
83: (select NULL
84: from JTF_DPF_LOGICAL_PAGES_TL T
85: where T.LOGICAL_PAGE_ID = X_LOGICAL_PAGE_ID
86: and T.LANGUAGE = L.LANGUAGE_CODE);
87:
88: open c;

Line 125: from JTF_DPF_LOGICAL_PAGES_TL

121:
122: cursor c1 is select
123: LOGICAL_PAGE_DESCRIPTION,
124: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
125: from JTF_DPF_LOGICAL_PAGES_TL
126: where LOGICAL_PAGE_ID = X_LOGICAL_PAGE_ID
127: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
128: for update of LOGICAL_PAGE_ID nowait;
129: begin

Line 202: update JTF_DPF_LOGICAL_PAGES_TL set

198: if (sql%notfound) then
199: raise no_data_found;
200: end if;
201:
202: update JTF_DPF_LOGICAL_PAGES_TL set
203: LOGICAL_PAGE_DESCRIPTION = X_LOGICAL_PAGE_DESCRIPTION,
204: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
205: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
206: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 220: delete from JTF_DPF_LOGICAL_PAGES_TL

216: procedure DELETE_ROW (
217: X_LOGICAL_PAGE_ID in NUMBER
218: ) is
219: begin
220: delete from JTF_DPF_LOGICAL_PAGES_TL
221: where LOGICAL_PAGE_ID = X_LOGICAL_PAGE_ID;
222:
223: if (sql%notfound) then
224: raise no_data_found;

Line 238: delete from JTF_DPF_LOGICAL_PAGES_TL T

234:
235: procedure ADD_LANGUAGE
236: is
237: begin
238: delete from JTF_DPF_LOGICAL_PAGES_TL T
239: where not exists
240: (select NULL
241: from JTF_DPF_LOGICAL_PAGES_B B
242: where B.LOGICAL_PAGE_ID = T.LOGICAL_PAGE_ID

Line 245: update JTF_DPF_LOGICAL_PAGES_TL T set (

241: from JTF_DPF_LOGICAL_PAGES_B B
242: where B.LOGICAL_PAGE_ID = T.LOGICAL_PAGE_ID
243: );
244:
245: update JTF_DPF_LOGICAL_PAGES_TL T set (
246: LOGICAL_PAGE_DESCRIPTION
247: ) = (select
248: B.LOGICAL_PAGE_DESCRIPTION
249: from JTF_DPF_LOGICAL_PAGES_TL B

Line 249: from JTF_DPF_LOGICAL_PAGES_TL B

245: update JTF_DPF_LOGICAL_PAGES_TL T set (
246: LOGICAL_PAGE_DESCRIPTION
247: ) = (select
248: B.LOGICAL_PAGE_DESCRIPTION
249: from JTF_DPF_LOGICAL_PAGES_TL B
250: where B.LOGICAL_PAGE_ID = T.LOGICAL_PAGE_ID
251: and B.LANGUAGE = T.SOURCE_LANG)
252: where (
253: T.LOGICAL_PAGE_ID,

Line 258: from JTF_DPF_LOGICAL_PAGES_TL SUBB, JTF_DPF_LOGICAL_PAGES_TL SUBT

254: T.LANGUAGE
255: ) in (select
256: SUBT.LOGICAL_PAGE_ID,
257: SUBT.LANGUAGE
258: from JTF_DPF_LOGICAL_PAGES_TL SUBB, JTF_DPF_LOGICAL_PAGES_TL SUBT
259: where SUBB.LOGICAL_PAGE_ID = SUBT.LOGICAL_PAGE_ID
260: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
261: and (SUBB.LOGICAL_PAGE_DESCRIPTION <> SUBT.LOGICAL_PAGE_DESCRIPTION
262: or (SUBB.LOGICAL_PAGE_DESCRIPTION is null and SUBT.LOGICAL_PAGE_DESCRIPTION is not null)

Line 266: insert into JTF_DPF_LOGICAL_PAGES_TL (

262: or (SUBB.LOGICAL_PAGE_DESCRIPTION is null and SUBT.LOGICAL_PAGE_DESCRIPTION is not null)
263: or (SUBB.LOGICAL_PAGE_DESCRIPTION is not null and SUBT.LOGICAL_PAGE_DESCRIPTION is null)
264: ));
265:
266: insert into JTF_DPF_LOGICAL_PAGES_TL (
267: LOGICAL_PAGE_ID,
268: LOGICAL_PAGE_DESCRIPTION,
269: CREATED_BY,
270: LAST_UPDATE_DATE,

Line 284: from JTF_DPF_LOGICAL_PAGES_TL B, FND_LANGUAGES L

280: B.LAST_UPDATED_BY,
281: B.LAST_UPDATE_LOGIN,
282: L.LANGUAGE_CODE,
283: B.SOURCE_LANG
284: from JTF_DPF_LOGICAL_PAGES_TL B, FND_LANGUAGES L
285: where L.INSTALLED_FLAG in ('I', 'B')
286: and B.LANGUAGE = userenv('LANG')
287: and not exists
288: (select NULL

Line 289: from JTF_DPF_LOGICAL_PAGES_TL T

285: where L.INSTALLED_FLAG in ('I', 'B')
286: and B.LANGUAGE = userenv('LANG')
287: and not exists
288: (select NULL
289: from JTF_DPF_LOGICAL_PAGES_TL T
290: where T.LOGICAL_PAGE_ID = B.LOGICAL_PAGE_ID
291: and T.LANGUAGE = L.LANGUAGE_CODE);
292: end ADD_LANGUAGE;
293:

Line 307: update jtf_dpf_logical_pages_tl set

303: l_user_id := 0;
304: if x_owner = 'SEED' then l_user_id := 1; end if;
305:
306: l_lid := find(x_logical_page_name, x_application_id);
307: update jtf_dpf_logical_pages_tl set
308: logical_page_description = x_logical_page_description,
309: last_updated_by = l_user_id,
310: last_update_date = sysdate,
311: last_update_login = 0,