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 115.3 2002/12/11 10:01:23 raranjan noship $ */
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: insert into HR_TEMPLATE_ITEM_TAB_PAGES (

Line 39: insert into HR_TEMPLATE_ITEM_TAB_PAGES (

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: insert into HR_TEMPLATE_ITEM_TAB_PAGES (
40: LAST_UPDATE_LOGIN,
41: CREATED_BY,
42: CREATION_DATE,
43: LAST_UPDATE_DATE,

Line 80: from HR_TEMPLATE_ITEM_TAB_PAGES

76: cursor c1 is select
77: OBJECT_VERSION_NUMBER,
78: TEMPLATE_ITEM_ID,
79: TEMPLATE_TAB_PAGE_ID
80: from HR_TEMPLATE_ITEM_TAB_PAGES
81: where TEMPLATE_ITEM_TAB_PAGE_ID = X_TEMPLATE_ITEM_TAB_PAGE_ID
82: for update of TEMPLATE_ITEM_TAB_PAGE_ID nowait;
83: begin
84: for tlinfo in c1 loop

Line 108: update HR_TEMPLATE_ITEM_TAB_PAGES set

104: X_LAST_UPDATED_BY in NUMBER,
105: X_LAST_UPDATE_LOGIN in NUMBER
106: ) is
107: begin
108: update HR_TEMPLATE_ITEM_TAB_PAGES set
109: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
110: TEMPLATE_ITEM_ID = X_TEMPLATE_ITEM_ID,
111: TEMPLATE_TAB_PAGE_ID = X_TEMPLATE_TAB_PAGE_ID,
112: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 126: delete from HR_TEMPLATE_ITEM_TAB_PAGES

122: procedure DELETE_ROW (
123: X_TEMPLATE_ITEM_TAB_PAGE_ID in NUMBER
124: ) is
125: begin
126: delete from HR_TEMPLATE_ITEM_TAB_PAGES
127: where TEMPLATE_ITEM_TAB_PAGE_ID = X_TEMPLATE_ITEM_TAB_PAGE_ID;
128:
129: if (sql%notfound) then
130: raise no_data_found;

Line 250: from hr_template_item_tab_pages

246:
247: begin
248: select template_item_tab_page_id
249: into x_template_item_tab_page_id
250: from hr_template_item_tab_pages
251: where template_tab_page_id = x_template_tab_page_id
252: and template_item_id = x_template_item_id;
253: exception
254: when no_data_found then

Line 255: select hr_template_item_tab_pages_s.nextval

251: where template_tab_page_id = x_template_tab_page_id
252: and template_item_id = x_template_item_id;
253: exception
254: when no_data_found then
255: select hr_template_item_tab_pages_s.nextval
256: into x_template_item_tab_page_id
257: from dual;
258: end;
259:

Line 284: end HR_TEMPLATE_ITEM_TAB_PAGES_PKG;

280: X_LAST_UPDATED_BY,
281: X_LAST_UPDATE_LOGIN);
282: end;
283: end LOAD_ROW;
284: end HR_TEMPLATE_ITEM_TAB_PAGES_PKG;