[Home] [Help]
491: , last_updated_by
492: , last_update_login
493: , created_by
494: , creation_date
495: from hr_s_formula_types;
496:
497: CURSOR ftcu (p_ftype_id number) -- Cursor for install context usages
498: IS
499: select *
535: select distinct null
536: from ff_formula_types a
537: where exists
538: (select null
539: from hr_s_formula_types b
540: where a.formula_type_id = b.formula_type_id
541: );
542: --
543: v_sequence_number number(9);
577: --
578: --conflict may exist
579: --update all formula_type_id's to remove conflict
580:
581: update hr_s_formula_types
582: set formula_type_id = formula_type_id - 50000000;
583:
584: update hr_s_formulas_f
585: set formula_type_id = formula_type_id - 50000000;
603: select min(formula_type_id) - (count(*) *3)
604: , max(formula_type_id) + (count(*) *3)
605: into v_min_delivered
606: , v_max_delivered
607: from hr_s_formula_types;
608:
609: select ff_formula_types_s.nextval
610: into v_sequence_number
611: from dual;
650: END;
651:
652: -- Update all child entities
653:
654: update hr_s_formula_types
655: set formula_type_id = l_new_surrogate_key
656: where formula_type_id = stu_rec.c_surrogate_key;
657:
658: update hr_s_application_ownerships
680: -- Remove a row from the startup/delivered tables
681:
682: BEGIN
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;
1402: -- Check first parent does not exist in the delivery tables
1403:
1404: select distinct null
1405: into l_NULL_RETURN
1406: from hr_s_formula_types
1407: where formula_type_id = r_each_row.formula_type_id;
1408:
1409:
1410: crt_exc('Parent formula type still exists in delivery tables');
4010: -- Checking the delivery account
4011:
4012: select distinct null
4013: into l_null_return
4014: from hr_s_formula_types
4015: where formula_type_id = stu_rec.formula_type_id;
4016:
4017: crt_exc('Parent formula type remains in delivery tables');
4018: