APPS.FF_DATA_DICT dependencies on FF_ROUTE_CONTEXT_USAGES

Line 3059: from ff_route_context_usages

3055: cursor c_ff_rcu_pop (c_route_id in number,
3056: c_sequence_no in number,
3057: c_context_id in number) is
3058: select distinct null
3059: from ff_route_context_usages
3060: where route_id = c_route_id
3061: and sequence_no = c_sequence_no
3062: and context_id = c_context_id;
3063: --

Line 3104: delete ff_route_context_usages

3100: --
3101: -- Changing or inserting route so delete live ctx usages
3102: -- for this route
3103: --
3104: delete ff_route_context_usages
3105: where route_id = stu_rec.c_surrogate_key;
3106: --
3107: -- Now install route ctx usages
3108: --

Line 3122: insert into ff_route_context_usages

3118: END IF;
3119: close c_ff_contexts_null;
3120: --
3121: BEGIN
3122: insert into ff_route_context_usages
3123: (route_id
3124: ,context_id
3125: ,sequence_no
3126: )

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

3130: ,context_usages.sequence_no
3131: );
3132: EXCEPTION WHEN OTHERS THEN
3133: hr_legislation.hrrunprc_trace_on;
3134: hr_utility.trace('ins ff_route_context_usages');
3135: hr_utility.trace('route_id ' ||
3136: to_char(context_usages.route_id));
3137: hr_utility.trace('route_name ' ||
3138: stu_rec.c_true_key);