APPS.FF_DATA_DICT dependencies on HR_S_CONTEXTS

Line 110: from hr_s_contexts;

106: , rowid
107: , context_level
108: , data_type
109: , context_id c_surrogate_key
110: from hr_s_contexts;
111:
112:
113: stu_rec stu%ROWTYPE; -- Record for above SELECT
114:

Line 173: from hr_s_contexts b

169: into l_null_return
170: from ff_contexts a
171: where exists
172: (select null
173: from hr_s_contexts b
174: where a.context_id = b.context_id
175: );
176:
177: --conflict may exist

Line 180: update /*+NO_INDEX*/ hr_s_contexts

176:
177: --conflict may exist
178: --update all context_id's to remove conflict
179:
180: update /*+NO_INDEX*/ hr_s_contexts
181: set context_id = context_id - 50000000;
182:
183: update /*+NO_INDEX*/ hr_s_route_context_usages
184: set context_id = context_id - 50000000;

Line 206: from hr_s_contexts;

202: select min(context_id) - (count(*) *3)
203: , max(context_id) + (count(*) *3)
204: into v_min_delivered
205: , v_max_delivered
206: from hr_s_contexts;
207:
208: select ff_contexts_s.nextval
209: into v_sequence_number
210: from dual;

Line 251: update hr_s_contexts

247: END;
248:
249: -- Update all child entities
250:
251: update hr_s_contexts
252: set context_id = l_new_surrogate_key
253: where context_id = stu_rec.c_surrogate_key;
254:
255: update hr_s_application_ownerships

Line 281: delete from hr_s_contexts

277: -- Remove a row from the startup/delivered tables
278:
279: BEGIN
280:
281: delete from hr_s_contexts
282: where rowid = stu_rec.rowid;
283:
284:
285: IF p_phase = 2 THEN