APPS.JTF_DPF_PHYSICAL_PAGES_PKG dependencies on JTF_DPF_PHYSICAL_PAGES_TL

Line 60: insert into JTF_DPF_PHYSICAL_PAGES_TL (

56: X_LAST_UPDATED_BY,
57: X_LAST_UPDATE_LOGIN
58: );
59:
60: insert into JTF_DPF_PHYSICAL_PAGES_TL (
61: PHYSICAL_PAGE_ID,
62: PHYSICAL_PAGE_DESCRIPTION,
63: CREATED_BY,
64: LAST_UPDATE_DATE,

Line 82: from JTF_DPF_PHYSICAL_PAGES_TL T

78: from FND_LANGUAGES L
79: where L.INSTALLED_FLAG in ('I', 'B')
80: and not exists
81: (select NULL
82: from JTF_DPF_PHYSICAL_PAGES_TL T
83: where T.PHYSICAL_PAGE_ID = X_PHYSICAL_PAGE_ID
84: and T.LANGUAGE = L.LANGUAGE_CODE);
85:
86: open c;

Line 115: from JTF_DPF_PHYSICAL_PAGES_TL

111:
112: cursor c1 is select
113: PHYSICAL_PAGE_DESCRIPTION,
114: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
115: from JTF_DPF_PHYSICAL_PAGES_TL
116: where PHYSICAL_PAGE_ID = X_PHYSICAL_PAGE_ID
117: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
118: for update of PHYSICAL_PAGE_ID nowait;
119: begin

Line 177: update JTF_DPF_PHYSICAL_PAGES_TL set

173: if (sql%notfound) then
174: raise no_data_found;
175: end if;
176:
177: update JTF_DPF_PHYSICAL_PAGES_TL set
178: PHYSICAL_PAGE_DESCRIPTION = X_PHYSICAL_PAGE_DESCRIPTION,
179: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
180: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
181: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 195: delete from JTF_DPF_PHYSICAL_PAGES_TL

191: procedure DELETE_ROW (
192: X_PHYSICAL_PAGE_ID in NUMBER
193: ) is
194: begin
195: delete from JTF_DPF_PHYSICAL_PAGES_TL
196: where PHYSICAL_PAGE_ID = X_PHYSICAL_PAGE_ID;
197:
198: if (sql%notfound) then
199: raise no_data_found;

Line 213: delete from JTF_DPF_PHYSICAL_PAGES_TL T

209:
210: procedure ADD_LANGUAGE
211: is
212: begin
213: delete from JTF_DPF_PHYSICAL_PAGES_TL T
214: where not exists
215: (select NULL
216: from JTF_DPF_PHYSICAL_PAGES_B B
217: where B.PHYSICAL_PAGE_ID = T.PHYSICAL_PAGE_ID

Line 220: update JTF_DPF_PHYSICAL_PAGES_TL T set (

216: from JTF_DPF_PHYSICAL_PAGES_B B
217: where B.PHYSICAL_PAGE_ID = T.PHYSICAL_PAGE_ID
218: );
219:
220: update JTF_DPF_PHYSICAL_PAGES_TL T set (
221: PHYSICAL_PAGE_DESCRIPTION
222: ) = (select
223: B.PHYSICAL_PAGE_DESCRIPTION
224: from JTF_DPF_PHYSICAL_PAGES_TL B

Line 224: from JTF_DPF_PHYSICAL_PAGES_TL B

220: update JTF_DPF_PHYSICAL_PAGES_TL T set (
221: PHYSICAL_PAGE_DESCRIPTION
222: ) = (select
223: B.PHYSICAL_PAGE_DESCRIPTION
224: from JTF_DPF_PHYSICAL_PAGES_TL B
225: where B.PHYSICAL_PAGE_ID = T.PHYSICAL_PAGE_ID
226: and B.LANGUAGE = T.SOURCE_LANG)
227: where (
228: T.PHYSICAL_PAGE_ID,

Line 233: from JTF_DPF_PHYSICAL_PAGES_TL SUBB, JTF_DPF_PHYSICAL_PAGES_TL SUBT

229: T.LANGUAGE
230: ) in (select
231: SUBT.PHYSICAL_PAGE_ID,
232: SUBT.LANGUAGE
233: from JTF_DPF_PHYSICAL_PAGES_TL SUBB, JTF_DPF_PHYSICAL_PAGES_TL SUBT
234: where SUBB.PHYSICAL_PAGE_ID = SUBT.PHYSICAL_PAGE_ID
235: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
236: and (SUBB.PHYSICAL_PAGE_DESCRIPTION <> SUBT.PHYSICAL_PAGE_DESCRIPTION
237: or (SUBB.PHYSICAL_PAGE_DESCRIPTION is null and SUBT.PHYSICAL_PAGE_DESCRIPTION is not null)

Line 241: insert into JTF_DPF_PHYSICAL_PAGES_TL (

237: or (SUBB.PHYSICAL_PAGE_DESCRIPTION is null and SUBT.PHYSICAL_PAGE_DESCRIPTION is not null)
238: or (SUBB.PHYSICAL_PAGE_DESCRIPTION is not null and SUBT.PHYSICAL_PAGE_DESCRIPTION is null)
239: ));
240:
241: insert into JTF_DPF_PHYSICAL_PAGES_TL (
242: PHYSICAL_PAGE_ID,
243: PHYSICAL_PAGE_DESCRIPTION,
244: CREATED_BY,
245: LAST_UPDATE_DATE,

Line 259: from JTF_DPF_PHYSICAL_PAGES_TL B, FND_LANGUAGES L

255: B.LAST_UPDATED_BY,
256: B.LAST_UPDATE_LOGIN,
257: L.LANGUAGE_CODE,
258: B.SOURCE_LANG
259: from JTF_DPF_PHYSICAL_PAGES_TL B, FND_LANGUAGES L
260: where L.INSTALLED_FLAG in ('I', 'B')
261: and B.LANGUAGE = userenv('LANG')
262: and not exists
263: (select NULL

Line 264: from JTF_DPF_PHYSICAL_PAGES_TL T

260: where L.INSTALLED_FLAG in ('I', 'B')
261: and B.LANGUAGE = userenv('LANG')
262: and not exists
263: (select NULL
264: from JTF_DPF_PHYSICAL_PAGES_TL T
265: where T.PHYSICAL_PAGE_ID = B.PHYSICAL_PAGE_ID
266: and T.LANGUAGE = L.LANGUAGE_CODE);
267: end ADD_LANGUAGE;
268:

Line 303: update jtf_dpf_physical_pages_tl set

299: if x_owner = 'SEED' then l_user_id := 1; end if;
300: l_page_id := find_oldest_prefer_owned_by(x_page_name, x_application_id,
301: l_user_id);
302:
303: update jtf_dpf_physical_pages_tl set
304: physical_page_description = x_page_description,
305: last_updated_by = l_user_id,
306: last_update_date = sysdate,
307: last_update_login = 0,