DBA Data[Home] [Help]

APPS.FF_DATA_DICT dependencies on FF_FTYPE_CONTEXT_USAGES

Line 728: from ff_ftype_context_usages fcu

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
729: where fcu.formula_type_id = l_new_surrogate_key);
730: --
731: BEGIN
732: -- This routine only operates in phase 1. Rows are present in the

Line 910: delete from ff_ftype_context_usages

906: and b.item_name = upper(c.context_name)
907: and c.context_id = usages.context_id
908: and b.usage = 'U');
909:
910: delete from ff_ftype_context_usages
911: where formula_type_id = stu_rec.c_surrogate_key
912: and context_id=usages.context_id;
913:
914: open c_fft5 (usages.context_id);

Line 921: insert into ff_ftype_context_usages

917: RAISE NO_DATA_FOUND;
918: END IF;
919: close c_fft5;
920:
921: insert into ff_ftype_context_usages
922: (formula_type_id
923: ,context_id)
924: values
925: (usages.formula_type_id

Line 941: hr_utility.trace('ins ff_ftype_context_usages');

937: return;
938:
939: WHEN OTHERS THEN
940: hr_legislation.hrrunprc_trace_on;
941: hr_utility.trace('ins ff_ftype_context_usages');
942: hr_utility.trace('formula_type_id ' ||
943: to_char(usages.formula_type_id));
944: hr_utility.trace('context_id ' ||
945: to_char(usages.context_id));