APPS.HR_FORM_CANVASES_PKG dependencies on HR_FORM_CANVASES_TL

Line 73: insert into HR_FORM_CANVASES_TL (

69: );
70: end if;
71: close c;
72:
73: insert into HR_FORM_CANVASES_TL (
74: FORM_CANVAS_ID,
75: USER_CANVAS_NAME,
76: DESCRIPTION,
77: LAST_UPDATE_DATE,

Line 99: from HR_FORM_CANVASES_TL T

95: from FND_LANGUAGES L
96: where L.INSTALLED_FLAG in ('I', 'B')
97: and not exists
98: (select NULL
99: from HR_FORM_CANVASES_TL T
100: where T.FORM_CANVAS_ID = X_FORM_CANVAS_ID
101: and T.LANGUAGE = L.LANGUAGE_CODE);
102:
103: open c;

Line 136: from HR_FORM_CANVASES_TL

132: cursor c1 is select
133: USER_CANVAS_NAME,
134: DESCRIPTION,
135: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
136: from HR_FORM_CANVASES_TL
137: where FORM_CANVAS_ID = X_FORM_CANVAS_ID
138: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
139: for update of FORM_CANVAS_ID nowait;
140: begin

Line 203: update HR_FORM_CANVASES_TL set

199: if (sql%notfound) then
200: raise no_data_found;
201: end if;
202:
203: update HR_FORM_CANVASES_TL set
204: USER_CANVAS_NAME = X_USER_CANVAS_NAME,
205: DESCRIPTION = X_DESCRIPTION,
206: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
207: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 222: delete from HR_FORM_CANVASES_TL

218: procedure DELETE_ROW (
219: X_FORM_CANVAS_ID in NUMBER
220: ) is
221: begin
222: delete from HR_FORM_CANVASES_TL
223: where FORM_CANVAS_ID = X_FORM_CANVAS_ID;
224:
225: if (sql%notfound) then
226: raise no_data_found;

Line 240: delete from HR_FORM_CANVASES_TL T

236:
237: procedure ADD_LANGUAGE
238: is
239: begin
240: delete from HR_FORM_CANVASES_TL T
241: where not exists
242: (select NULL
243: from HR_FORM_CANVASES_B B
244: where B.FORM_CANVAS_ID = T.FORM_CANVAS_ID

Line 247: update HR_FORM_CANVASES_TL T set (

243: from HR_FORM_CANVASES_B B
244: where B.FORM_CANVAS_ID = T.FORM_CANVAS_ID
245: );
246:
247: update HR_FORM_CANVASES_TL T set (
248: USER_CANVAS_NAME,
249: DESCRIPTION
250: ) = (select
251: B.USER_CANVAS_NAME,

Line 253: from HR_FORM_CANVASES_TL B

249: DESCRIPTION
250: ) = (select
251: B.USER_CANVAS_NAME,
252: B.DESCRIPTION
253: from HR_FORM_CANVASES_TL B
254: where B.FORM_CANVAS_ID = T.FORM_CANVAS_ID
255: and B.LANGUAGE = T.SOURCE_LANG)
256: where (
257: T.FORM_CANVAS_ID,

Line 262: from HR_FORM_CANVASES_TL SUBB, HR_FORM_CANVASES_TL SUBT

258: T.LANGUAGE
259: ) in (select
260: SUBT.FORM_CANVAS_ID,
261: SUBT.LANGUAGE
262: from HR_FORM_CANVASES_TL SUBB, HR_FORM_CANVASES_TL SUBT
263: where SUBB.FORM_CANVAS_ID = SUBT.FORM_CANVAS_ID
264: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
265: and (SUBB.USER_CANVAS_NAME <> SUBT.USER_CANVAS_NAME
266: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 271: insert into HR_FORM_CANVASES_TL (

267: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
268: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
269: ));
270:
271: insert into HR_FORM_CANVASES_TL (
272: FORM_CANVAS_ID,
273: USER_CANVAS_NAME,
274: DESCRIPTION,
275: LAST_UPDATE_DATE,

Line 293: from HR_FORM_CANVASES_TL B, FND_LANGUAGES L

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

Line 298: from HR_FORM_CANVASES_TL T

294: where L.INSTALLED_FLAG in ('I', 'B')
295: and B.LANGUAGE = userenv('LANG')
296: and not exists
297: (select NULL
298: from HR_FORM_CANVASES_TL T
299: where T.FORM_CANVAS_ID = B.FORM_CANVAS_ID
300: and T.LANGUAGE = L.LANGUAGE_CODE);
301: end ADD_LANGUAGE;
302:

Line 352: update HR_FORM_CANVASES_TL set

348: and hfw.application_id = x_application_id
349: and hfw.form_id = x_form_id
350: and hfw.window_name = x_window_name;
351:
352: update HR_FORM_CANVASES_TL set
353: DESCRIPTION = X_DESCRIPTION,
354: USER_CANVAS_NAME = X_USER_CANVAS_NAME,
355: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
356: LAST_UPDATED_BY = X_LAST_UPDATED_BY,