APPS.HR_FORM_ITEMS_PKG dependencies on HR_FORM_ITEMS_TL

Line 87: insert into HR_FORM_ITEMS_TL (

83: X_LAST_UPDATED_BY,
84: X_LAST_UPDATE_LOGIN
85: );
86:
87: insert into HR_FORM_ITEMS_TL (
88: LAST_UPDATE_LOGIN,
89: CREATED_BY,
90: CREATION_DATE,
91: LAST_UPDATE_DATE,

Line 113: from HR_FORM_ITEMS_TL T

109: from FND_LANGUAGES L
110: where L.INSTALLED_FLAG in ('I', 'B')
111: and not exists
112: (select NULL
113: from HR_FORM_ITEMS_TL T
114: where T.FORM_ITEM_ID = X_FORM_ITEM_ID
115: and T.LANGUAGE = L.LANGUAGE_CODE);
116:
117: open c;

Line 164: from HR_FORM_ITEMS_TL

160: cursor c1 is select
161: USER_ITEM_NAME,
162: DESCRIPTION,
163: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
164: from HR_FORM_ITEMS_TL
165: where FORM_ITEM_ID = X_FORM_ITEM_ID
166: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
167: for update of FORM_ITEM_ID nowait;
168: begin

Line 257: update HR_FORM_ITEMS_TL set

253: if (sql%notfound) then
254: raise no_data_found;
255: end if;
256:
257: update HR_FORM_ITEMS_TL set
258: USER_ITEM_NAME = X_USER_ITEM_NAME,
259: DESCRIPTION = X_DESCRIPTION,
260: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
261: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 276: delete from HR_FORM_ITEMS_TL

272: procedure DELETE_ROW (
273: X_FORM_ITEM_ID in NUMBER
274: ) is
275: begin
276: delete from HR_FORM_ITEMS_TL
277: where FORM_ITEM_ID = X_FORM_ITEM_ID;
278:
279: if (sql%notfound) then
280: raise no_data_found;

Line 294: delete from HR_FORM_ITEMS_TL T

290:
291: procedure ADD_LANGUAGE
292: is
293: begin
294: delete from HR_FORM_ITEMS_TL T
295: where not exists
296: (select NULL
297: from HR_FORM_ITEMS_B B
298: where B.FORM_ITEM_ID = T.FORM_ITEM_ID

Line 301: update HR_FORM_ITEMS_TL T set (

297: from HR_FORM_ITEMS_B B
298: where B.FORM_ITEM_ID = T.FORM_ITEM_ID
299: );
300:
301: update HR_FORM_ITEMS_TL T set (
302: USER_ITEM_NAME,
303: DESCRIPTION
304: ) = (select
305: B.USER_ITEM_NAME,

Line 307: from HR_FORM_ITEMS_TL B

303: DESCRIPTION
304: ) = (select
305: B.USER_ITEM_NAME,
306: B.DESCRIPTION
307: from HR_FORM_ITEMS_TL B
308: where B.FORM_ITEM_ID = T.FORM_ITEM_ID
309: and B.LANGUAGE = T.SOURCE_LANG)
310: where (
311: T.FORM_ITEM_ID,

Line 316: from HR_FORM_ITEMS_TL SUBB, HR_FORM_ITEMS_TL SUBT

312: T.LANGUAGE
313: ) in (select
314: SUBT.FORM_ITEM_ID,
315: SUBT.LANGUAGE
316: from HR_FORM_ITEMS_TL SUBB, HR_FORM_ITEMS_TL SUBT
317: where SUBB.FORM_ITEM_ID = SUBT.FORM_ITEM_ID
318: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
319: and (SUBB.USER_ITEM_NAME <> SUBT.USER_ITEM_NAME
320: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 325: insert into HR_FORM_ITEMS_TL (

321: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
322: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
323: ));
324:
325: insert into HR_FORM_ITEMS_TL (
326: LAST_UPDATE_LOGIN,
327: CREATED_BY,
328: CREATION_DATE,
329: LAST_UPDATE_DATE,

Line 347: from HR_FORM_ITEMS_TL B, FND_LANGUAGES L

343: B.USER_ITEM_NAME,
344: B.DESCRIPTION,
345: L.LANGUAGE_CODE,
346: B.SOURCE_LANG
347: from HR_FORM_ITEMS_TL B, FND_LANGUAGES L
348: where L.INSTALLED_FLAG in ('I', 'B')
349: and B.LANGUAGE = userenv('LANG')
350: and not exists
351: (select NULL

Line 352: from HR_FORM_ITEMS_TL T

348: where L.INSTALLED_FLAG in ('I', 'B')
349: and B.LANGUAGE = userenv('LANG')
350: and not exists
351: (select NULL
352: from HR_FORM_ITEMS_TL T
353: where T.FORM_ITEM_ID = B.FORM_ITEM_ID
354: and T.LANGUAGE = L.LANGUAGE_CODE);
355: end ADD_LANGUAGE;
356: procedure TRANSLATE_ROW (

Line 408: update HR_FORM_ITEMS_TL set

404: and form_id = x_form_id
405: and ( radio_button_name = x_radio_button_name
406: or (radio_button_name is null and x_radio_button_name is null) );
407:
408: update HR_FORM_ITEMS_TL set
409: DESCRIPTION = X_DESCRIPTION,
410: USER_ITEM_NAME = X_USER_ITEM_NAME,
411: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
412: LAST_UPDATED_BY = X_LAST_UPDATED_BY,