eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FF_DATA_DICT dependencies on FF_FORMULAS_F

Line 889: from ff_formulas_f a,

885:
886: delete ff_compiled_info_f f
887: where f.formula_id in (
888: select distinct a.formula_id
889: from ff_formulas_f a,
890: ff_fdi_usages_f b,
891: ff_contexts c
892: where a.formula_type_id = stu_rec.c_surrogate_key
893: and a.formula_id = b.formula_id

Line 901: from ff_formulas_f a,

897:
898: delete ff_fdi_usages_f f
899: where f.formula_id in (
900: select distinct a.formula_id
901: from ff_formulas_f a,
902: ff_fdi_usages_f b,
903: ff_contexts c
904: where a.formula_type_id = stu_rec.c_surrogate_key
905: and a.formula_id = b.formula_id

Line 1010: -- INSTALLATION PROCEDURE FOR : FF_FORMULAS_F

1006:
1007: END install_fft;
1008:
1009: --****************************************************************************
1010: -- INSTALLATION PROCEDURE FOR : FF_FORMULAS_F
1011: --****************************************************************************
1012:
1013: PROCEDURE install_formulas (p_phase IN NUMBER)
1014: ----------------------------------------------

Line 1075: -- FF_FORMULAS_F

1071: PROCEDURE crt_exc (exception_type IN varchar2)
1072: ----------------------------------------------
1073: IS
1074: -- Reports any exceptions during the delivery of startup data to
1075: -- FF_FORMULAS_F
1076: BEGIN
1077: -- When the installation procedures encounter an error that cannot
1078: -- be handled, an exception is raised and all work is rolled back
1079: -- to the last savepoint. The installation process then continues

Line 1085: hr_legislation.insert_hr_stu_exceptions('ff_formulas_f'

1081: -- not be raised more than once.
1082:
1083: rollback to new_formula_name;
1084:
1085: hr_legislation.insert_hr_stu_exceptions('ff_formulas_f'
1086: , r_distinct.c_surrogate_key
1087: , exception_type
1088: , r_distinct.c_true_key);
1089:

Line 1140: from ff_formulas_f a

1136:
1137:
1138: select distinct null
1139: into l_null_return
1140: from ff_formulas_f a
1141: where exists
1142: (select null
1143: from hr_s_formulas_f b
1144: where a.formula_id = b.formula_id

Line 1229: from ff_formulas_f

1225: BEGIN
1226:
1227: select distinct formula_id
1228: into l_new_formula_id
1229: from ff_formulas_f
1230: where formula_name = r_distinct.c_true_key
1231: and formula_type_id = r_distinct.formula_type_id
1232: and business_Group_id is null
1233: and ((legislation_code is NULL and r_distinct.legislation_code is NULL)

Line 1247: hr_utility.trace('sel ff_formulas_f TMR');

1243:
1244: WHEN TOO_MANY_ROWS THEN
1245:
1246: hr_legislation.hrrunprc_trace_on;
1247: hr_utility.trace('sel ff_formulas_f TMR');
1248: hr_utility.trace('formula_name ' ||
1249: r_distinct.c_true_key);
1250: hr_utility.trace('formula_type_id ' ||
1251: to_char(r_distinct.formula_type_id));

Line 1479: from ff_formulas_f a

1475:
1476:
1477: select distinct null
1478: into l_null_return
1479: from ff_formulas_f a
1480: where a.formula_name = r_distinct.c_true_key
1481: and a.formula_type_id = r_distinct.formula_type_id
1482: and a.business_group_id is not null
1483: and exists (select null from per_business_groups b

Line 1513: from ff_formulas_f

1509:
1510:
1511: select distinct null
1512: into l_null_return
1513: from ff_formulas_f
1514: where formula_name = r_distinct.c_true_key
1515: and formula_type_id = r_distinct.formula_type_id
1516: and legislation_code <> r_distinct.legislation_code
1517: and (legislation_code is null or

Line 1598: from ff_formulas_f

1594:
1595: BEGIN
1596: select null
1597: into l_dummy
1598: from ff_formulas_f
1599: where formula_id = form_id;
1600: EXCEPTION when others then
1601: return TRUE;
1602: END;

Line 1616: from ff_formulas_f

1612: and effective_start_date = r_all_rows.effective_start_date;
1613:
1614: select formula_text
1615: into vlive_formula_text
1616: from ff_formulas_f
1617: where formula_id = form_id
1618: and effective_start_date = r_all_rows.effective_start_date;
1619:
1620: -- First check if non stub formula diff from live

Line 1653: from ff_formulas_f

1649: MINUS
1650: select effective_start_date,
1651: effective_end_date,
1652: description
1653: from ff_formulas_f
1654: where formula_id = form_id
1655: and formula_type_id = r_distinct.formula_type_id
1656: )
1657: UNION

Line 1662: from ff_formulas_f

1658: (
1659: select effective_start_date,
1660: effective_end_date,
1661: description
1662: from ff_formulas_f
1663: where formula_id = form_id
1664: and formula_type_id = r_distinct.formula_type_id
1665: MINUS
1666: select effective_start_date,

Line 1756: delete from ff_formulas_f

1752:
1753: delete from ff_compiled_info_f
1754: where formula_id = r_distinct.c_surrogate_key;
1755:
1756: delete from ff_formulas_f
1757: where formula_id = r_distinct.c_surrogate_key;
1758:
1759: FOR each_row IN c_each_row(r_distinct.c_surrogate_key) LOOP
1760:

Line 1769: insert into ff_formulas_f

1765: RAISE row_in_error;
1766: END IF;
1767:
1768: BEGIN
1769: insert into ff_formulas_f
1770: (formula_id
1771: ,effective_start_date
1772: ,effective_end_date
1773: ,business_group_id

Line 1807: hr_utility.trace('ins ff_formulas_f');

1803: ,r_each_row.creation_date
1804: );
1805: EXCEPTION WHEN OTHERS THEN
1806: hr_legislation.hrrunprc_trace_on;
1807: hr_utility.trace('ins ff_formulas_f');
1808: hr_utility.trace('formula_name ' ||
1809: r_each_row.formula_name);
1810: hr_utility.trace('formula_id ' ||
1811: to_char(r_each_row.formula_id));

Line 4030: from ff_formulas_f

4026: -- Checking the installed account
4027:
4028: select distinct null
4029: into l_null_return
4030: from ff_formulas_f
4031: where formula_id = stu_rec.formula_id;
4032:
4033: return TRUE;
4034: