APPS.HR_FORM_CANVASES_PKG dependencies on HR_FORM_CANVASES_TL

Line 104: p_entity_name => 'HR_FORM_CANVASES_TL',

100:
101: BEGIN
102:
103: per_RIC_pkg.chk_integrity (
104: p_entity_name => 'HR_FORM_CANVASES_TL',
105: p_ref_entity => 'HR_FORM_CANVASES_B',
106: p_ref_column_name => 'FORM_CANVAS_ID',
107: p_ref_col_value_number => X_FORM_CANVAS_ID,
108: p_ref_col_value_varchar => NULL,

Line 118: insert into HR_FORM_CANVASES_TL (

114: --
115: -- Code Ends Here.
116: --
117:
118: insert into HR_FORM_CANVASES_TL (
119: FORM_CANVAS_ID,
120: USER_CANVAS_NAME,
121: DESCRIPTION,
122: LAST_UPDATE_DATE,

Line 144: from HR_FORM_CANVASES_TL T

140: from FND_LANGUAGES L
141: where L.INSTALLED_FLAG in ('I', 'B')
142: and not exists
143: (select NULL
144: from HR_FORM_CANVASES_TL T
145: where T.FORM_CANVAS_ID = X_FORM_CANVAS_ID
146: and T.LANGUAGE = L.LANGUAGE_CODE);
147:
148: open c;

Line 181: from HR_FORM_CANVASES_TL

177: cursor c1 is select
178: USER_CANVAS_NAME,
179: DESCRIPTION,
180: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
181: from HR_FORM_CANVASES_TL
182: where FORM_CANVAS_ID = X_FORM_CANVAS_ID
183: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
184: for update of FORM_CANVAS_ID nowait;
185: begin

Line 248: update HR_FORM_CANVASES_TL set

244: if (sql%notfound) then
245: raise no_data_found;
246: end if;
247:
248: update HR_FORM_CANVASES_TL set
249: USER_CANVAS_NAME = X_USER_CANVAS_NAME,
250: DESCRIPTION = X_DESCRIPTION,
251: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
252: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 267: delete from HR_FORM_CANVASES_TL

263: procedure DELETE_ROW (
264: X_FORM_CANVAS_ID in NUMBER
265: ) is
266: begin
267: delete from HR_FORM_CANVASES_TL
268: where FORM_CANVAS_ID = X_FORM_CANVAS_ID;
269:
270: if (sql%notfound) then
271: raise no_data_found;

Line 285: PER_RIC_PKG.ref_info_rec('HR_FORM_CANVASES_TL', PER_RIC_PKG.column_info_tbl(

281: p_entity_name => 'HR_FORM_CANVASES_B',
282: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
283: PER_RIC_PKG.ref_info_rec('HR_CANVAS_PROPERTIES', PER_RIC_PKG.column_info_tbl(
284: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
285: PER_RIC_PKG.ref_info_rec('HR_FORM_CANVASES_TL', PER_RIC_PKG.column_info_tbl(
286: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
287: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
288: PER_RIC_PKG.col_info_rec('FORM_CANVAS_ID',NULL,X_FORM_CANVAS_ID,NULL))),
289: PER_RIC_PKG.ref_info_rec('HR_FORM_TAB_PAGES_B', PER_RIC_PKG.column_info_tbl(

Line 316: delete from HR_FORM_CANVASES_TL T

312: procedure ADD_LANGUAGE
313: is
314: begin
315:
316: delete from HR_FORM_CANVASES_TL T
317: where not exists
318: (select NULL
319: from HR_FORM_CANVASES_B B
320: where B.FORM_CANVAS_ID = T.FORM_CANVAS_ID

Line 323: update HR_FORM_CANVASES_TL T set (

319: from HR_FORM_CANVASES_B B
320: where B.FORM_CANVAS_ID = T.FORM_CANVAS_ID
321: );
322:
323: update HR_FORM_CANVASES_TL T set (
324: USER_CANVAS_NAME,
325: DESCRIPTION
326: ) = (select
327: B.USER_CANVAS_NAME,

Line 329: from HR_FORM_CANVASES_TL B

325: DESCRIPTION
326: ) = (select
327: B.USER_CANVAS_NAME,
328: B.DESCRIPTION
329: from HR_FORM_CANVASES_TL B
330: where B.FORM_CANVAS_ID = T.FORM_CANVAS_ID
331: and B.LANGUAGE = T.SOURCE_LANG)
332: where (
333: T.FORM_CANVAS_ID,

Line 338: from HR_FORM_CANVASES_TL SUBB, HR_FORM_CANVASES_TL SUBT

334: T.LANGUAGE
335: ) in (select
336: SUBT.FORM_CANVAS_ID,
337: SUBT.LANGUAGE
338: from HR_FORM_CANVASES_TL SUBB, HR_FORM_CANVASES_TL SUBT
339: where SUBB.FORM_CANVAS_ID = SUBT.FORM_CANVAS_ID
340: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
341: and (SUBB.USER_CANVAS_NAME <> SUBT.USER_CANVAS_NAME
342: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 348: insert into HR_FORM_CANVASES_TL (

344: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
345: ));
346:
347:
348: insert into HR_FORM_CANVASES_TL (
349: FORM_CANVAS_ID,
350: USER_CANVAS_NAME,
351: DESCRIPTION,
352: LAST_UPDATE_DATE,

Line 370: from HR_FORM_CANVASES_TL B, FND_LANGUAGES L

366: B.CREATED_BY,
367: B.CREATION_DATE,
368: L.LANGUAGE_CODE,
369: B.SOURCE_LANG
370: from HR_FORM_CANVASES_TL B, FND_LANGUAGES L
371: where L.INSTALLED_FLAG in ('I', 'B')
372: and B.LANGUAGE = userenv('LANG')
373: and not exists
374: (select NULL

Line 375: from HR_FORM_CANVASES_TL T

371: where L.INSTALLED_FLAG in ('I', 'B')
372: and B.LANGUAGE = userenv('LANG')
373: and not exists
374: (select NULL
375: from HR_FORM_CANVASES_TL T
376: where T.FORM_CANVAS_ID = B.FORM_CANVAS_ID
377: and T.LANGUAGE = L.LANGUAGE_CODE);
378: end ADD_LANGUAGE;
379:

Line 429: update HR_FORM_CANVASES_TL set

425: and hfw.application_id = x_application_id
426: and hfw.form_id = x_form_id
427: and hfw.window_name = x_window_name;
428:
429: update HR_FORM_CANVASES_TL set
430: DESCRIPTION = X_DESCRIPTION,
431: USER_CANVAS_NAME = X_USER_CANVAS_NAME,
432: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
433: LAST_UPDATED_BY = X_LAST_UPDATED_BY,