APPS.HR_FORM_DATA_GROUP_ITEMS_PKG dependencies on HR_FORM_DATA_GROUP_ITEMS

Line 1: package body HR_FORM_DATA_GROUP_ITEMS_PKG as

1: package body HR_FORM_DATA_GROUP_ITEMS_PKG as
2: /* $Header: hrfgilct.pkb 115.2 2002/12/10 10:58:29 hjonnala 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_FORM_DATA_GROUP_ITEMS

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_FORM_DATA_GROUP_ITEMS
36: where FORM_DATA_GROUP_ITEM_ID = X_FORM_DATA_GROUP_ITEM_ID
37: ;
38: begin
39: insert into HR_FORM_DATA_GROUP_ITEMS (

Line 39: insert into HR_FORM_DATA_GROUP_ITEMS (

35: cursor C is select ROWID from HR_FORM_DATA_GROUP_ITEMS
36: where FORM_DATA_GROUP_ITEM_ID = X_FORM_DATA_GROUP_ITEM_ID
37: ;
38: begin
39: insert into HR_FORM_DATA_GROUP_ITEMS (
40: FORM_DATA_GROUP_ID,
41: FORM_ITEM_ID,
42: LAST_UPDATE_DATE,
43: LAST_UPDATED_BY,

Line 80: from HR_FORM_DATA_GROUP_ITEMS

76: cursor c1 is select
77: FORM_DATA_GROUP_ID,
78: FORM_ITEM_ID,
79: OBJECT_VERSION_NUMBER
80: from HR_FORM_DATA_GROUP_ITEMS
81: where FORM_DATA_GROUP_ITEM_ID = X_FORM_DATA_GROUP_ITEM_ID
82: for update of FORM_DATA_GROUP_ITEM_ID nowait;
83: begin
84: for tlinfo in c1 loop

Line 108: update HR_FORM_DATA_GROUP_ITEMS set

104: X_LAST_UPDATED_BY in NUMBER,
105: X_LAST_UPDATE_LOGIN in NUMBER
106: ) is
107: begin
108: update HR_FORM_DATA_GROUP_ITEMS set
109: FORM_DATA_GROUP_ID = X_FORM_DATA_GROUP_ID,
110: FORM_ITEM_ID = X_FORM_ITEM_ID,
111: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
112: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 126: delete from HR_FORM_DATA_GROUP_ITEMS

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

Line 194: from hr_form_data_group_items fgi

190:
191: begin
192: select fgi.form_data_group_item_id
193: into x_form_data_group_item_id
194: from hr_form_data_group_items fgi
195: where fgi.form_data_group_id = x_form_data_group_id
196: and fgi.form_item_id = x_form_item_id;
197: exception
198: when no_data_found then

Line 199: select hr_form_data_group_items_s.nextval

195: where fgi.form_data_group_id = x_form_data_group_id
196: and fgi.form_item_id = x_form_item_id;
197: exception
198: when no_data_found then
199: select hr_form_data_group_items_s.nextval
200: into x_form_data_group_item_id
201: from dual;
202: end;
203:

Line 230: end HR_FORM_DATA_GROUP_ITEMS_PKG;

226: X_LAST_UPDATED_BY,
227: X_LAST_UPDATE_LOGIN);
228: end;
229: end LOAD_ROW;
230: end HR_FORM_DATA_GROUP_ITEMS_PKG;