APPS.HR_TEMPLATE_ITEM_CONTEXTS_PKG dependencies on HR_TEMPLATE_ITEM_CONTEXTS_B

Line 36: cursor C is select ROWID from HR_TEMPLATE_ITEM_CONTEXTS_B

32: X_LAST_UPDATE_DATE in DATE,
33: X_LAST_UPDATED_BY in NUMBER,
34: X_LAST_UPDATE_LOGIN in NUMBER
35: ) is
36: cursor C is select ROWID from HR_TEMPLATE_ITEM_CONTEXTS_B
37: where TEMPLATE_ITEM_CONTEXT_ID = X_TEMPLATE_ITEM_CONTEXT_ID
38: ;
39: begin
40: insert into HR_TEMPLATE_ITEM_CONTEXTS_B (

Line 40: insert into HR_TEMPLATE_ITEM_CONTEXTS_B (

36: cursor C is select ROWID from HR_TEMPLATE_ITEM_CONTEXTS_B
37: where TEMPLATE_ITEM_CONTEXT_ID = X_TEMPLATE_ITEM_CONTEXT_ID
38: ;
39: begin
40: insert into HR_TEMPLATE_ITEM_CONTEXTS_B (
41: TEMPLATE_ITEM_CONTEXT_ID,
42: OBJECT_VERSION_NUMBER,
43: TEMPLATE_ITEM_ID,
44: CONTEXT_TYPE,

Line 85: from HR_TEMPLATE_ITEM_CONTEXTS_B

81: OBJECT_VERSION_NUMBER,
82: TEMPLATE_ITEM_ID,
83: CONTEXT_TYPE,
84: ITEM_CONTEXT_ID
85: from HR_TEMPLATE_ITEM_CONTEXTS_B
86: where TEMPLATE_ITEM_CONTEXT_ID = X_TEMPLATE_ITEM_CONTEXT_ID
87: for update of TEMPLATE_ITEM_CONTEXT_ID nowait;
88: begin
89: for tlinfo in c1 loop

Line 115: update HR_TEMPLATE_ITEM_CONTEXTS_B set

111: X_LAST_UPDATED_BY in NUMBER,
112: X_LAST_UPDATE_LOGIN in NUMBER
113: ) is
114: begin
115: update HR_TEMPLATE_ITEM_CONTEXTS_B set
116: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
117: TEMPLATE_ITEM_ID = X_TEMPLATE_ITEM_ID,
118: CONTEXT_TYPE = X_CONTEXT_TYPE,
119: ITEM_CONTEXT_ID = X_ITEM_CONTEXT_ID,

Line 134: delete from HR_TEMPLATE_ITEM_CONTEXTS_B

130: procedure DELETE_ROW (
131: X_TEMPLATE_ITEM_CONTEXT_ID in NUMBER
132: ) is
133: begin
134: delete from HR_TEMPLATE_ITEM_CONTEXTS_B
135: where TEMPLATE_ITEM_CONTEXT_ID = X_TEMPLATE_ITEM_CONTEXT_ID;
136:
137: if (sql%notfound) then
138: raise no_data_found;

Line 282: from hr_template_item_contexts_b ticb

278:
279: begin
280: select template_item_context_id
281: into x_template_item_context_id
282: from hr_template_item_contexts_b ticb
283: where ticb.template_item_id = x_template_item_id
284: and ticb.item_context_id = x_item_context_id;
285: exception
286: when no_data_found then

Line 287: select hr_template_item_contexts_b_s.nextval

283: where ticb.template_item_id = x_template_item_id
284: and ticb.item_context_id = x_item_context_id;
285: exception
286: when no_data_found then
287: select hr_template_item_contexts_b_s.nextval
288: into x_template_item_context_id
289: from dual;
290: end;
291: