APPS.HR_FORM_CANVASES_PKG dependencies on HR_FORM_CANVASES_B

Line 38: cursor C is select ROWID from HR_FORM_CANVASES_B

34: X_LAST_UPDATE_DATE in DATE,
35: X_LAST_UPDATED_BY in NUMBER,
36: X_LAST_UPDATE_LOGIN in NUMBER
37: ) is
38: cursor C is select ROWID from HR_FORM_CANVASES_B
39: where FORM_CANVAS_ID = X_FORM_CANVAS_ID
40: ;
41: begin
42: -- Added cursor check for Bug 5600334 to avoid unwanted inserts.

Line 56: p_entity_name => 'HR_FORM_CANVASES_B',

52:
53: BEGIN
54:
55: per_RIC_pkg.chk_integrity (
56: p_entity_name => 'HR_FORM_CANVASES_B',
57: p_ref_entity => 'HR_FORM_WINDOWS_B',
58: p_ref_column_name => 'FORM_WINDOW_ID',
59: p_ref_col_value_number => X_FORM_WINDOW_ID,
60: p_ref_col_value_varchar => NULL,

Line 70: insert into HR_FORM_CANVASES_B (

66: --
67: -- Code Ends Here.
68: --
69:
70: insert into HR_FORM_CANVASES_B (
71: OBJECT_VERSION_NUMBER,
72: FORM_WINDOW_ID,
73: CANVAS_TYPE,
74: FORM_CANVAS_ID,

Line 105: p_ref_entity => 'HR_FORM_CANVASES_B',

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,
109: p_ref_col_value_date => NULL,

Line 172: from HR_FORM_CANVASES_B

168: OBJECT_VERSION_NUMBER,
169: FORM_WINDOW_ID,
170: CANVAS_TYPE,
171: CANVAS_NAME
172: from HR_FORM_CANVASES_B
173: where FORM_CANVAS_ID = X_FORM_CANVAS_ID
174: for update of FORM_CANVAS_ID nowait;
175: recinfo c%rowtype;
176:

Line 234: update HR_FORM_CANVASES_B set

230: X_LAST_UPDATED_BY in NUMBER,
231: X_LAST_UPDATE_LOGIN in NUMBER
232: ) is
233: begin
234: update HR_FORM_CANVASES_B set
235: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
236: FORM_WINDOW_ID = X_FORM_WINDOW_ID,
237: CANVAS_TYPE = X_CANVAS_TYPE,
238: CANVAS_NAME = X_CANVAS_NAME,

Line 281: p_entity_name => 'HR_FORM_CANVASES_B',

277: --
278: BEGIN
279:
280: per_RIC_pkg.chk_integrity (
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(

Line 304: delete from HR_FORM_CANVASES_B

300: --
301: -- Code Ends Here.
302: --
303:
304: delete from HR_FORM_CANVASES_B
305: where FORM_CANVAS_ID = X_FORM_CANVAS_ID;
306:
307: if (sql%notfound) then
308: raise no_data_found;

Line 319: from HR_FORM_CANVASES_B B

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
321: );
322:
323: update HR_FORM_CANVASES_TL T set (

Line 422: from hr_form_canvases_b hfc

418: and application_id = x_application_id;
419:
420: select hfc.form_canvas_id,hfw.form_window_id
421: into x_form_canvas_id,x_form_window_id
422: from hr_form_canvases_b hfc
423: ,hr_form_windows_b hfw
424: where hfc.canvas_name = x_canvas_name
425: and hfw.application_id = x_application_id
426: and hfw.form_id = x_form_id

Line 492: from hr_form_canvases_b hfc

488:
489: begin
490: select hfc.form_canvas_id
491: into x_form_canvas_id
492: from hr_form_canvases_b hfc
493: where hfc.canvas_name = x_canvas_name
494: and hfc.form_window_id = x_form_window_id;
495: exception
496: when no_data_found then

Line 497: select hr_form_canvases_b_s.nextval

493: where hfc.canvas_name = x_canvas_name
494: and hfc.form_window_id = x_form_window_id;
495: exception
496: when no_data_found then
497: select hr_form_canvases_b_s.nextval
498: into x_form_canvas_id
499: from dual;
500: end;
501: