APPS.FF_DATA_DICT dependencies on FF_FORMULA_TYPES

Line 469: -- INSTALLATION PROCEDURE FOR : FF_FORMULA_TYPES_S

465:
466: END install_ffc;
467:
468: --****************************************************************************
469: -- INSTALLATION PROCEDURE FOR : FF_FORMULA_TYPES_S
470: --****************************************************************************
471:
472: PROCEDURE install_fft (p_phase IN number)
473: -----------------------------------------

Line 510: -- FF_FORMULA_TYPES_S

506: PROCEDURE crt_exc (exception_type IN varchar2)
507: ----------------------------------------------
508: IS
509: -- Reports any exceptions during the delivery of startup data to
510: -- FF_FORMULA_TYPES_S
511:
512: BEGIN
513:
514: -- When the installation procedures encounter an error that cannot

Line 523: hr_legislation.insert_hr_stu_exceptions('ff_formula_types'

519:
520:
521: rollback to new_formula_type_name;
522:
523: hr_legislation.insert_hr_stu_exceptions('ff_formula_types'
524: , stu_rec.c_surrogate_key
525: , exception_type
526: , stu_rec.c_true_key);
527:

Line 536: from ff_formula_types a

532: -----------------------------
533: IS
534: CURSOR c_fft1 IS
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

Line 609: select ff_formula_types_s.nextval

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;
612:
613: IF v_sequence_number

Line 616: hr_legislation.munge_sequence('FF_FORMULA_TYPES_S',

612:
613: IF v_sequence_number
614: BETWEEN v_min_delivered AND v_max_delivered THEN
615:
616: hr_legislation.munge_sequence('FF_FORMULA_TYPES_S',
617: v_sequence_number,
618: v_max_delivered);
619:
620: END IF;

Line 636: from ff_formula_types

632: BEGIN
633:
634: select distinct formula_type_id
635: into l_new_surrogate_key
636: from ff_formula_types
637: where formula_type_name = stu_rec.c_true_key;
638:
639: EXCEPTION WHEN NO_DATA_FOUND THEN
640:

Line 641: select ff_formula_types_s.nextval

637: where formula_type_name = stu_rec.c_true_key;
638:
639: EXCEPTION WHEN NO_DATA_FOUND THEN
640:
641: select ff_formula_types_s.nextval
642: into l_new_surrogate_key
643: from dual;
644:
645: WHEN TOO_MANY_ROWS THEN

Line 825: update ff_formula_types

821: --
822:
823: BEGIN
824:
825: update ff_formula_types
826: set type_description = stu_rec.type_description
827: , last_update_date = stu_rec.last_update_date
828: , last_updated_by = stu_rec.last_updated_by
829: , last_update_login = stu_rec.last_update_login

Line 839: insert into ff_formula_types

835:
836: -- This formula type does not exist
837:
838: BEGIN
839: insert into ff_formula_types
840: (formula_type_name
841: ,formula_type_id
842: ,type_description
843: ,last_update_date

Line 861: hr_utility.trace('ins ff_formula_types');

857: ,stu_rec.creation_date
858: );
859: EXCEPTION WHEN OTHERS THEN
860: hr_legislation.hrrunprc_trace_on;
861: hr_utility.trace('ins ff_formula_types');
862: hr_utility.trace('formula_type_id ' ||
863: to_char(stu_rec.c_surrogate_key));
864: hr_utility.trace('formula_type_name ' ||
865: stu_rec.c_true_key);

Line 1429: from ff_formula_types

1425:
1426:
1427: select null
1428: into l_null_return
1429: from ff_formula_types
1430: where formula_type_id = r_each_row.formula_type_id;
1431:
1432: EXCEPTION WHEN NO_DATA_FOUND THEN
1433:

Line 4036: from ff_formula_types

4032: -- Checking the installed account
4033:
4034: select null
4035: into l_null_return
4036: from ff_formula_types
4037: where formula_type_id = stu_rec.formula_type_id;
4038:
4039: -- Drop down to second parent check
4040:

Line 4932: install_fft(p_phase); --install ff_Formula_types

4928: hr_legislation.hrrunprc_trace_on;
4929: hr_utility.trace('start install_fft: ' || to_char(p_phase));
4930: hr_legislation.hrrunprc_trace_off;
4931:
4932: install_fft(p_phase); --install ff_Formula_types
4933:
4934: hr_legislation.hrrunprc_trace_on;
4935: hr_utility.trace('start install_formulas: ' || to_char(p_phase));
4936: hr_legislation.hrrunprc_trace_off;