APPS.HR_TEMPLATE_ITEMS_PKG dependencies on HR_TEMPLATE_ITEMS_B

Line 35: cursor C is select ROWID from HR_TEMPLATE_ITEMS_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_ITEMS_B
36: where TEMPLATE_ITEM_ID = X_TEMPLATE_ITEM_ID
37: ;
38: begin
39: insert into HR_TEMPLATE_ITEMS_B (

Line 39: insert into HR_TEMPLATE_ITEMS_B (

35: cursor C is select ROWID from HR_TEMPLATE_ITEMS_B
36: where TEMPLATE_ITEM_ID = X_TEMPLATE_ITEM_ID
37: ;
38: begin
39: insert into HR_TEMPLATE_ITEMS_B (
40: LAST_UPDATED_BY,
41: FORM_ITEM_ID,
42: LAST_UPDATE_DATE,
43: TEMPLATE_ITEM_ID,

Line 79: from HR_TEMPLATE_ITEMS_B

75: cursor c1 is select
76: FORM_ITEM_ID,
77: OBJECT_VERSION_NUMBER,
78: FORM_TEMPLATE_ID
79: from HR_TEMPLATE_ITEMS_B
80: where TEMPLATE_ITEM_ID = X_TEMPLATE_ITEM_ID
81: for update of TEMPLATE_ITEM_ID nowait;
82: begin
83: for tlinfo in c1 loop

Line 107: update HR_TEMPLATE_ITEMS_B set

103: X_LAST_UPDATED_BY in NUMBER,
104: X_LAST_UPDATE_LOGIN in NUMBER
105: ) is
106: begin
107: update HR_TEMPLATE_ITEMS_B set
108: FORM_ITEM_ID = X_FORM_ITEM_ID,
109: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
110: FORM_TEMPLATE_ID = X_FORM_TEMPLATE_ID,
111: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 125: delete from HR_TEMPLATE_ITEMS_B

121: procedure DELETE_ROW (
122: X_TEMPLATE_ITEM_ID in NUMBER
123: ) is
124: begin
125: delete from HR_TEMPLATE_ITEMS_B
126: where TEMPLATE_ITEM_ID = X_TEMPLATE_ITEM_ID;
127:
128: if (sql%notfound) then
129: raise no_data_found;

Line 197: from hr_template_items_b

193:
194: begin
195: select template_item_id
196: into x_template_item_id
197: from hr_template_items_b
198: where form_template_id = x_form_template_id
199: and form_item_id = x_form_item_id;
200: exception
201: when no_data_found then

Line 202: select hr_template_items_b_s.nextval

198: where form_template_id = x_form_template_id
199: and form_item_id = x_form_item_id;
200: exception
201: when no_data_found then
202: select hr_template_items_b_s.nextval
203: into x_template_item_id
204: from dual;
205: end;
206: