APPS.HR_TEMPLATE_TAB_PAGES_PKG dependencies on HR_TEMPLATE_TAB_PAGES_B

Line 35: cursor C is select ROWID from HR_TEMPLATE_TAB_PAGES_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_TAB_PAGES_B
36: where TEMPLATE_TAB_PAGE_ID = X_TEMPLATE_TAB_PAGE_ID
37: ;
38: begin
39:

Line 47: p_entity_name => 'HR_TEMPLATE_TAB_PAGES_B',

43: --
44:
45: BEGIN
46: PER_RIC_PKG.chk_integrity (
47: p_entity_name => 'HR_TEMPLATE_TAB_PAGES_B',
48: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
49: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_CANVASES_B', PER_RIC_PKG.column_info_tbl(
50: PER_RIC_PKG.col_info_rec('TEMPLATE_CANVAS_ID',NULL,X_TEMPLATE_CANVAS_ID,NULL))),
51: PER_RIC_PKG.ref_info_rec('HR_FORM_TAB_PAGES_B', PER_RIC_PKG.column_info_tbl(

Line 61: insert into HR_TEMPLATE_TAB_PAGES_B (

57: --
58: -- Code Ends Here.
59: --
60:
61: insert into HR_TEMPLATE_TAB_PAGES_B (
62: TEMPLATE_TAB_PAGE_ID,
63: OBJECT_VERSION_NUMBER,
64: TEMPLATE_CANVAS_ID,
65: FORM_TAB_PAGE_ID,

Line 102: from HR_TEMPLATE_TAB_PAGES_B

98: cursor c1 is select
99: OBJECT_VERSION_NUMBER,
100: TEMPLATE_CANVAS_ID,
101: FORM_TAB_PAGE_ID
102: from HR_TEMPLATE_TAB_PAGES_B
103: where TEMPLATE_TAB_PAGE_ID = X_TEMPLATE_TAB_PAGE_ID
104: for update of TEMPLATE_TAB_PAGE_ID nowait;
105: begin
106: for tlinfo in c1 loop

Line 130: update HR_TEMPLATE_TAB_PAGES_B set

126: X_LAST_UPDATED_BY in NUMBER,
127: X_LAST_UPDATE_LOGIN in NUMBER
128: ) is
129: begin
130: update HR_TEMPLATE_TAB_PAGES_B set
131: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
132: TEMPLATE_CANVAS_ID = X_TEMPLATE_CANVAS_ID,
133: FORM_TAB_PAGE_ID = X_FORM_TAB_PAGE_ID,
134: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 156: p_entity_name => 'HR_TEMPLATE_TAB_PAGES_B',

152: --
153:
154: BEGIN
155: PER_RIC_PKG.chk_integrity (
156: p_entity_name => 'HR_TEMPLATE_TAB_PAGES_B',
157: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
158: PER_RIC_PKG.ref_info_rec('HR_TAB_PAGE_PROPERTIES_B', PER_RIC_PKG.column_info_tbl(
159: PER_RIC_PKG.col_info_rec('TEMPLATE_TAB_PAGE_ID',NULL,X_TEMPLATE_TAB_PAGE_ID,NULL))),
160: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXT_PAGES', PER_RIC_PKG.column_info_tbl(

Line 171: delete from HR_TEMPLATE_TAB_PAGES_B

167: END;
168: --
169: -- Code Ends Here.
170: --
171: delete from HR_TEMPLATE_TAB_PAGES_B
172: where TEMPLATE_TAB_PAGE_ID = X_TEMPLATE_TAB_PAGE_ID;
173:
174: if (sql%notfound) then
175: raise no_data_found;

Line 270: from hr_template_tab_pages_b

266:
267: begin
268: select template_tab_page_id
269: into x_template_tab_page_id
270: from hr_template_tab_pages_b
271: where template_canvas_id = x_template_canvas_id
272: and form_tab_page_id = x_form_tab_page_id;
273: exception
274: when no_data_found then

Line 275: select hr_template_tab_pages_b_s.nextval

271: where template_canvas_id = x_template_canvas_id
272: and form_tab_page_id = x_form_tab_page_id;
273: exception
274: when no_data_found then
275: select hr_template_tab_pages_b_s.nextval
276: into x_template_tab_page_id
277: from dual;
278: end;
279: