APPS.FF_DATA_DICT dependencies on FF_ROUTE_CONTEXT_USAGES

Line 3099: from ff_route_context_usages

3095: cursor c_ff_rcu_pop (c_route_id in number,
3096: c_sequence_no in number,
3097: c_context_id in number) is
3098: select distinct null
3099: from ff_route_context_usages
3100: where route_id = c_route_id
3101: and sequence_no = c_sequence_no
3102: and context_id = c_context_id;
3103: --

Line 3144: delete ff_route_context_usages

3140: --
3141: -- Changing or inserting route so delete live ctx usages
3142: -- for this route
3143: --
3144: delete ff_route_context_usages
3145: where route_id = stu_rec.c_surrogate_key;
3146: --
3147: -- Now install route ctx usages
3148: --

Line 3162: insert into ff_route_context_usages

3158: END IF;
3159: close c_ff_contexts_null;
3160: --
3161: BEGIN
3162: insert into ff_route_context_usages
3163: (route_id
3164: ,context_id
3165: ,sequence_no
3166: )

Line 3174: hr_utility.trace('ins ff_route_context_usages');

3170: ,context_usages.sequence_no
3171: );
3172: EXCEPTION WHEN OTHERS THEN
3173: hr_legislation.hrrunprc_trace_on;
3174: hr_utility.trace('ins ff_route_context_usages');
3175: hr_utility.trace('route_id ' ||
3176: to_char(context_usages.route_id));
3177: hr_utility.trace('route_name ' ||
3178: stu_rec.c_true_key);