APPS.FF_DATA_DICT dependencies on HR_S_FTYPE_CONTEXT_USAGES

Line 186: update /*+NO_INDEX*/ hr_s_ftype_context_usages

182:
183: update /*+NO_INDEX*/ hr_s_route_context_usages
184: set context_id = context_id - 50000000;
185:
186: update /*+NO_INDEX*/ hr_s_ftype_context_usages
187: set context_id = context_id - 50000000;
188:
189: update /*+NO_INDEX*/ hr_s_function_context_usages
190: set context_id = context_id - 50000000;

Line 260: update hr_s_ftype_context_usages

256: set key_value = to_char(l_new_surrogate_key)
257: where key_value = to_char(stu_rec.c_surrogate_key)
258: and key_name = 'CONTEXT_ID';
259:
260: update hr_s_ftype_context_usages
261: set context_id = l_new_surrogate_key
262: where context_id = stu_rec.c_surrogate_key;
263:
264: update hr_s_route_context_usages

Line 500: from hr_s_ftype_context_usages

496:
497: CURSOR ftcu (p_ftype_id number) -- Cursor for install context usages
498: IS
499: select *
500: from hr_s_ftype_context_usages
501: where formula_type_id = p_ftype_id;
502:
503: stu_rec stu%ROWTYPE; -- Record definition for cursor select
504:

Line 587: update hr_s_ftype_context_usages

583:
584: update hr_s_formulas_f
585: set formula_type_id = formula_type_id - 50000000;
586:
587: update hr_s_ftype_context_usages
588: set formula_type_id = formula_type_id - 50000000;
589:
590: update hr_s_qp_reports
591: set formula_type_id = formula_type_id - 50000000;

Line 667: update hr_s_ftype_context_usages

663: update hr_s_formulas_f
664: set formula_type_id = l_new_surrogate_key
665: where formula_type_id = stu_rec.c_surrogate_key;
666:
667: update hr_s_ftype_context_usages
668: set formula_type_id = l_new_surrogate_key
669: where formula_type_id = stu_rec.c_surrogate_key;
670:
671: update hr_s_qp_reports

Line 687: delete from hr_s_ftype_context_usages

683:
684: delete from hr_s_formula_types
685: where rowid = stu_rec.rowid;
686:
687: delete from hr_s_ftype_context_usages
688: where formula_type_id = l_new_surrogate_key;
689:
690: END remove;
691:

Line 724: from hr_s_ftype_context_usages hfcu

720: select 1
721: from dual
722: where exists
723: (select hfcu.context_id
724: from hr_s_ftype_context_usages hfcu
725: where hfcu.formula_type_id = l_new_surrogate_key
726: MINUS
727: select fcu.context_id
728: from ff_ftype_context_usages fcu

Line 792: from hr_s_ftype_context_usages

788: -- this first
789:
790: select count(*)
791: into l_number_of_ftcu
792: from hr_s_ftype_context_usages
793: where formula_type_id = l_new_surrogate_key;
794:
795: if l_number_of_ftcu <> 0 then
796: open c_fft3;