APPS.HR_TEMPLATE_CANVASES_B_PKG dependencies on HR_TEMPLATE_CANVASES_B

Line 1: package body HR_TEMPLATE_CANVASES_B_PKG as

1: package body HR_TEMPLATE_CANVASES_B_PKG as
2: /* $Header: hrtculct.pkb 120.1 2011/04/28 11:01:08 sidsaxen ship $ */
3: procedure OWNER_TO_WHO (
4: X_OWNER in VARCHAR2,
5: X_CREATION_DATE out nocopy DATE,

Line 35: cursor C is select ROWID from HR_TEMPLATE_CANVASES_B

31: X_LAST_UPDATE_DATE in DATE,
32: X_LAST_UPDATED_BY in NUMBER,
33: X_LAST_UPDATE_LOGIN in NUMBER
34: ) is
35: cursor C is select ROWID from HR_TEMPLATE_CANVASES_B
36: where TEMPLATE_CANVAS_ID = X_TEMPLATE_CANVAS_ID
37: ;
38: begin
39:

Line 47: p_entity_name => 'HR_TEMPLATE_CANVASES_B',

43: --
44:
45: BEGIN
46: PER_RIC_PKG.chk_integrity (
47: p_entity_name => 'HR_TEMPLATE_CANVASES_B',
48: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
49: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_WINDOWS_B', PER_RIC_PKG.column_info_tbl(
50: PER_RIC_PKG.col_info_rec('TEMPLATE_WINDOW_ID',NULL,X_TEMPLATE_WINDOW_ID,NULL))),
51: PER_RIC_PKG.ref_info_rec('HR_FORM_CANVASES_B', PER_RIC_PKG.column_info_tbl(

Line 60: insert into HR_TEMPLATE_CANVASES_B (

56: END;
57: --
58: -- Code Ends Here.
59: --
60: insert into HR_TEMPLATE_CANVASES_B (
61: TEMPLATE_CANVAS_ID,
62: OBJECT_VERSION_NUMBER,
63: TEMPLATE_WINDOW_ID,
64: FORM_CANVAS_ID,

Line 101: from HR_TEMPLATE_CANVASES_B

97: cursor c1 is select
98: OBJECT_VERSION_NUMBER,
99: TEMPLATE_WINDOW_ID,
100: FORM_CANVAS_ID
101: from HR_TEMPLATE_CANVASES_B
102: where TEMPLATE_CANVAS_ID = X_TEMPLATE_CANVAS_ID
103: for update of TEMPLATE_CANVAS_ID nowait;
104: begin
105: for tlinfo in c1 loop

Line 129: update HR_TEMPLATE_CANVASES_B set

125: X_LAST_UPDATED_BY in NUMBER,
126: X_LAST_UPDATE_LOGIN in NUMBER
127: ) is
128: begin
129: update HR_TEMPLATE_CANVASES_B set
130: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
131: TEMPLATE_WINDOW_ID = X_TEMPLATE_WINDOW_ID,
132: FORM_CANVAS_ID = X_FORM_CANVAS_ID,
133: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 155: p_entity_name => 'HR_TEMPLATE_CANVASES_B',

151: --
152:
153: BEGIN
154: PER_RIC_PKG.chk_integrity (
155: p_entity_name => 'HR_TEMPLATE_CANVASES_B',
156: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
157: PER_RIC_PKG.ref_info_rec('HR_CANVAS_PROPERTIES', PER_RIC_PKG.column_info_tbl(
158: PER_RIC_PKG.col_info_rec('TEMPLATE_CANVAS_ID',NULL,X_TEMPLATE_CANVAS_ID,NULL))),
159: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_TAB_PAGES_B', PER_RIC_PKG.column_info_tbl(

Line 169: delete from HR_TEMPLATE_CANVASES_B

165: --
166: -- Code Ends Here.
167: --
168:
169: delete from HR_TEMPLATE_CANVASES_B
170: where TEMPLATE_CANVAS_ID = X_TEMPLATE_CANVAS_ID;
171:
172: if (sql%notfound) then
173: raise no_data_found;

Line 253: from hr_template_canvases_b

249: begin
250:
251: select template_canvas_id
252: into x_template_canvas_id
253: from hr_template_canvases_b
254: where form_canvas_id = x_form_canvas_id
255: and template_window_id = x_template_window_id;
256:
257: exception

Line 259: select hr_template_canvases_b_s.nextval

255: and template_window_id = x_template_window_id;
256:
257: exception
258: when no_data_found then
259: select hr_template_canvases_b_s.nextval
260: into x_template_canvas_id
261: from dual;
262: end;
263:

Line 290: end HR_TEMPLATE_CANVASES_B_PKG;

286: X_LAST_UPDATE_LOGIN);
287: end;
288:
289: end LOAD_ROW;
290: end HR_TEMPLATE_CANVASES_B_PKG;