DBA Data[Home] [Help]

APPS.PAY_IP_STARTUP_UTIL dependencies on HR_LEGISLATION

Line 299: --Returns TRUE if the HR_LEGISLATION_INSTALLATIONS do not have PAY or PER

295: l_reference number := 0;
296:
297: BEGIN
298: hr_utility.set_location('pay_ip_startup_util.check_to_install',10);
299: --Returns TRUE if the HR_LEGISLATION_INSTALLATIONS do not have PAY or PER
300: --for the given legislation and if no other patch is getting applied
301: --and reference data is available.
302:
303: IF pay_ip_utility.IS_release_122_plus THEN

Line 309: FROM hr_legislation_installations

305: END IF;
306:
307: SELECT count(application_short_name)
308: INTO l_Installed
309: FROM hr_legislation_installations
310: WHERE application_short_name IN('PAY','PER')
311: AND legislation_code = p_legislation_code;
312:
313: IF l_installed > 0 THEN

Line 322: FROM hr_legislation_installations

318: END IF;
319:
320: SELECT count(application_short_name)
321: INTO l_Installed
322: FROM hr_legislation_installations
323: WHERE action IS NOT NULL;
324:
325: IF l_installed > 0 THEN
326: g_logging := 'Y';

Line 1881: -- table as HR_LEGISLATION.INSTALL picks up the legislation_code from

1877: END update_shadow_tables;
1878:
1879: -- ---------------------------------------------------------------------
1880: -- A record for the choosen legislation rule is inserted in to History
1881: -- table as HR_LEGISLATION.INSTALL picks up the legislation_code from
1882: -- this history table
1883: -- ---------------------------------------------------------------------
1884: PROCEDURE insert_history_table
1885: (p_legislation_code IN VARCHAR2) IS

Line 1966: -- required legislation_code and currency, by HR_LEGISLATION.INSTALL

1962: END create_report_format_param;
1963:
1964: -- ---------------------------------------------------------------------
1965: -- The data from Shadow tables are moved in to the main tables with the
1966: -- required legislation_code and currency, by HR_LEGISLATION.INSTALL
1967: -- ---------------------------------------------------------------------
1968: PROCEDURE move_to_main_tables IS
1969:
1970: BEGIN

Line 1972: hr_legislation.install;

1968: PROCEDURE move_to_main_tables IS
1969:
1970: BEGIN
1971: hr_utility.set_location('pay_ip_startup_util.move_to_main_tables',10);
1972: hr_legislation.install;
1973:
1974: EXCEPTION
1975: WHEN OTHERS THEN
1976: RAISE_APPLICATION_ERROR(-20001, SQLERRM);

Line 3484: write_log('LOG','PAY_34016_IP_CALL_PROC','HR_LEGISLATION.INSTALL',NULL);

3480:
3481: -- Moving to Main Tables
3482: hr_utility.set_location('pay_ip_startup_util.setup',80);
3483: write_log('LOG',NULL,NULL,NULL);
3484: write_log('LOG','PAY_34016_IP_CALL_PROC','HR_LEGISLATION.INSTALL',NULL);
3485: BEGIN
3486: move_to_main_tables;
3487: EXCEPTION
3488: WHEN OTHERS THEN