APPS.HR_TEMPLATE_ITEM_TAB_PAGES_PKG dependencies on HR_TEMPLATE_ITEM_TAB_PAGES

Line 1: package body HR_TEMPLATE_ITEM_TAB_PAGES_PKG as

1: package body HR_TEMPLATE_ITEM_TAB_PAGES_PKG as
2: /* $Header: hrtiplct.pkb 120.1 2011/04/28 10:52:38 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_ITEM_TAB_PAGES

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_ITEM_TAB_PAGES
36: where TEMPLATE_ITEM_TAB_PAGE_ID = X_TEMPLATE_ITEM_TAB_PAGE_ID
37: ;
38: begin
39:

Line 47: p_entity_name => 'HR_TEMPLATE_ITEM_TAB_PAGES',

43: --
44:
45: BEGIN
46: PER_RIC_PKG.chk_integrity (
47: p_entity_name => 'HR_TEMPLATE_ITEM_TAB_PAGES',
48: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
49: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEMS_B', PER_RIC_PKG.column_info_tbl(
50: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,X_TEMPLATE_ITEM_ID,NULL))),
51: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_TAB_PAGES_B', PER_RIC_PKG.column_info_tbl(

Line 61: insert into HR_TEMPLATE_ITEM_TAB_PAGES (

57: --
58: -- Code Ends Here.
59: --
60:
61: insert into HR_TEMPLATE_ITEM_TAB_PAGES (
62: LAST_UPDATE_LOGIN,
63: CREATED_BY,
64: CREATION_DATE,
65: LAST_UPDATE_DATE,

Line 102: from HR_TEMPLATE_ITEM_TAB_PAGES

98: cursor c1 is select
99: OBJECT_VERSION_NUMBER,
100: TEMPLATE_ITEM_ID,
101: TEMPLATE_TAB_PAGE_ID
102: from HR_TEMPLATE_ITEM_TAB_PAGES
103: where TEMPLATE_ITEM_TAB_PAGE_ID = X_TEMPLATE_ITEM_TAB_PAGE_ID
104: for update of TEMPLATE_ITEM_TAB_PAGE_ID nowait;
105: begin
106: for tlinfo in c1 loop

Line 130: update HR_TEMPLATE_ITEM_TAB_PAGES set

126: X_LAST_UPDATED_BY in NUMBER,
127: X_LAST_UPDATE_LOGIN in NUMBER
128: ) is
129: begin
130: update HR_TEMPLATE_ITEM_TAB_PAGES set
131: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
132: TEMPLATE_ITEM_ID = X_TEMPLATE_ITEM_ID,
133: TEMPLATE_TAB_PAGE_ID = X_TEMPLATE_TAB_PAGE_ID,
134: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 148: delete from HR_TEMPLATE_ITEM_TAB_PAGES

144: procedure DELETE_ROW (
145: X_TEMPLATE_ITEM_TAB_PAGE_ID in NUMBER
146: ) is
147: begin
148: delete from HR_TEMPLATE_ITEM_TAB_PAGES
149: where TEMPLATE_ITEM_TAB_PAGE_ID = X_TEMPLATE_ITEM_TAB_PAGE_ID;
150:
151: if (sql%notfound) then
152: raise no_data_found;

Line 272: from hr_template_item_tab_pages

268:
269: begin
270: select template_item_tab_page_id
271: into x_template_item_tab_page_id
272: from hr_template_item_tab_pages
273: where template_tab_page_id = x_template_tab_page_id
274: and template_item_id = x_template_item_id;
275: exception
276: when no_data_found then

Line 277: select hr_template_item_tab_pages_s.nextval

273: where template_tab_page_id = x_template_tab_page_id
274: and template_item_id = x_template_item_id;
275: exception
276: when no_data_found then
277: select hr_template_item_tab_pages_s.nextval
278: into x_template_item_tab_page_id
279: from dual;
280: end;
281:

Line 306: end HR_TEMPLATE_ITEM_TAB_PAGES_PKG;

302: X_LAST_UPDATED_BY,
303: X_LAST_UPDATE_LOGIN);
304: end;
305: end LOAD_ROW;
306: end HR_TEMPLATE_ITEM_TAB_PAGES_PKG;