APPS.HR_FORM_TAB_PAGES_PKG dependencies on HR_FORM_TAB_PAGES_TL

Line 69: insert into HR_FORM_TAB_PAGES_TL (

65: X_LAST_UPDATED_BY,
66: X_LAST_UPDATE_LOGIN
67: );
68:
69: insert into HR_FORM_TAB_PAGES_TL (
70: USER_TAB_PAGE_NAME,
71: DESCRIPTION,
72: LAST_UPDATE_DATE,
73: LAST_UPDATED_BY,

Line 95: from HR_FORM_TAB_PAGES_TL T

91: from FND_LANGUAGES L
92: where L.INSTALLED_FLAG in ('I', 'B')
93: and not exists
94: (select NULL
95: from HR_FORM_TAB_PAGES_TL T
96: where T.FORM_TAB_PAGE_ID = X_FORM_TAB_PAGE_ID
97: and T.LANGUAGE = L.LANGUAGE_CODE);
98:
99: open c;

Line 134: from HR_FORM_TAB_PAGES_TL

130: cursor c1 is select
131: USER_TAB_PAGE_NAME,
132: DESCRIPTION,
133: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
134: from HR_FORM_TAB_PAGES_TL
135: where FORM_TAB_PAGE_ID = X_FORM_TAB_PAGE_ID
136: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
137: for update of FORM_TAB_PAGE_ID nowait;
138: begin

Line 205: update HR_FORM_TAB_PAGES_TL set

201: if (sql%notfound) then
202: raise no_data_found;
203: end if;
204:
205: update HR_FORM_TAB_PAGES_TL set
206: USER_TAB_PAGE_NAME = X_USER_TAB_PAGE_NAME,
207: DESCRIPTION = X_DESCRIPTION,
208: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
209: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 224: delete from HR_FORM_TAB_PAGES_TL

220: procedure DELETE_ROW (
221: X_FORM_TAB_PAGE_ID in NUMBER
222: ) is
223: begin
224: delete from HR_FORM_TAB_PAGES_TL
225: where FORM_TAB_PAGE_ID = X_FORM_TAB_PAGE_ID;
226:
227: if (sql%notfound) then
228: raise no_data_found;

Line 242: delete from HR_FORM_TAB_PAGES_TL T

238:
239: procedure ADD_LANGUAGE
240: is
241: begin
242: delete from HR_FORM_TAB_PAGES_TL T
243: where not exists
244: (select NULL
245: from HR_FORM_TAB_PAGES_B B
246: where B.FORM_TAB_PAGE_ID = T.FORM_TAB_PAGE_ID

Line 249: update HR_FORM_TAB_PAGES_TL T set (

245: from HR_FORM_TAB_PAGES_B B
246: where B.FORM_TAB_PAGE_ID = T.FORM_TAB_PAGE_ID
247: );
248:
249: update HR_FORM_TAB_PAGES_TL T set (
250: USER_TAB_PAGE_NAME,
251: DESCRIPTION
252: ) = (select
253: B.USER_TAB_PAGE_NAME,

Line 255: from HR_FORM_TAB_PAGES_TL B

251: DESCRIPTION
252: ) = (select
253: B.USER_TAB_PAGE_NAME,
254: B.DESCRIPTION
255: from HR_FORM_TAB_PAGES_TL B
256: where B.FORM_TAB_PAGE_ID = T.FORM_TAB_PAGE_ID
257: and B.LANGUAGE = T.SOURCE_LANG)
258: where (
259: T.FORM_TAB_PAGE_ID,

Line 264: from HR_FORM_TAB_PAGES_TL SUBB, HR_FORM_TAB_PAGES_TL SUBT

260: T.LANGUAGE
261: ) in (select
262: SUBT.FORM_TAB_PAGE_ID,
263: SUBT.LANGUAGE
264: from HR_FORM_TAB_PAGES_TL SUBB, HR_FORM_TAB_PAGES_TL SUBT
265: where SUBB.FORM_TAB_PAGE_ID = SUBT.FORM_TAB_PAGE_ID
266: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
267: and (SUBB.USER_TAB_PAGE_NAME <> SUBT.USER_TAB_PAGE_NAME
268: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 273: insert into HR_FORM_TAB_PAGES_TL (

269: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
270: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
271: ));
272:
273: insert into HR_FORM_TAB_PAGES_TL (
274: USER_TAB_PAGE_NAME,
275: DESCRIPTION,
276: LAST_UPDATE_DATE,
277: LAST_UPDATED_BY,

Line 295: from HR_FORM_TAB_PAGES_TL B, FND_LANGUAGES L

291: B.CREATION_DATE,
292: B.FORM_TAB_PAGE_ID,
293: L.LANGUAGE_CODE,
294: B.SOURCE_LANG
295: from HR_FORM_TAB_PAGES_TL B, FND_LANGUAGES L
296: where L.INSTALLED_FLAG in ('I', 'B')
297: and B.LANGUAGE = userenv('LANG')
298: and not exists
299: (select NULL

Line 300: from HR_FORM_TAB_PAGES_TL T

296: where L.INSTALLED_FLAG in ('I', 'B')
297: and B.LANGUAGE = userenv('LANG')
298: and not exists
299: (select NULL
300: from HR_FORM_TAB_PAGES_TL T
301: where T.FORM_TAB_PAGE_ID = B.FORM_TAB_PAGE_ID
302: and T.LANGUAGE = L.LANGUAGE_CODE);
303: end ADD_LANGUAGE;
304: procedure TRANSLATE_ROW (

Line 359: update HR_FORM_TAB_PAGES_TL set

355: and hfc.form_canvas_id = ftp.form_canvas_id
356: and ftp.tab_page_name = x_tab_page_name
357: and hfw.window_name = x_window_name;
358:
359: update HR_FORM_TAB_PAGES_TL set
360: DESCRIPTION = X_DESCRIPTION,
361: USER_TAB_PAGE_NAME = X_USER_TAB_PAGE_NAME,
362: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
363: LAST_UPDATED_BY = X_LAST_UPDATED_BY,