APPS.PAY_IP_STARTUP_UTIL dependencies on HR_LEGISLATION

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

289: l_reference number := 0;
290:
291: BEGIN
292: hr_utility.set_location('pay_ip_startup_util.check_to_install',10);
293: --Returns TRUE if the HR_LEGISLATION_INSTALLATIONS do not have PAY or PER
294: --for the given legislation and if no other patch is getting applied
295: --and reference data is available.
296:
297: SELECT count(*)

Line 299: FROM hr_legislation_installations

295: --and reference data is available.
296:
297: SELECT count(*)
298: INTO l_Installed
299: FROM hr_legislation_installations
300: WHERE application_short_name IN('PAY','PER')
301: AND legislation_code = p_legislation_code;
302:
303: IF l_installed > 0 THEN

Line 312: FROM hr_legislation_installations

308: END IF;
309:
310: SELECT count(*)
311: INTO l_Installed
312: FROM hr_legislation_installations
313: WHERE action IS NOT NULL;
314:
315: IF l_installed > 0 THEN
316: g_logging := 'Y';

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

1494: END update_shadow_tables;
1495:
1496: -- ---------------------------------------------------------------------
1497: -- A record for the choosen legislation rule is inserted in to History
1498: -- table as HR_LEGISLATION.INSTALL picks up the legislation_code from
1499: -- this history table
1500: -- ---------------------------------------------------------------------
1501: PROCEDURE insert_history_table
1502: (p_legislation_code IN VARCHAR2) IS

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

1519: END insert_history_table ;
1520:
1521: -- ---------------------------------------------------------------------
1522: -- The data from Shadow tables are moved in to the main tables with the
1523: -- required legislation_code and currency, by HR_LEGISLATION.INSTALL
1524: -- ---------------------------------------------------------------------
1525: PROCEDURE move_to_main_tables IS
1526:
1527: BEGIN

Line 1529: hr_legislation.install;

1525: PROCEDURE move_to_main_tables IS
1526:
1527: BEGIN
1528: hr_utility.set_location('pay_ip_startup_util.move_to_main_tables',10);
1529: hr_legislation.install;
1530:
1531: EXCEPTION
1532: WHEN OTHERS THEN
1533: RAISE_APPLICATION_ERROR(-20001, SQLERRM);

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

2243:
2244: -- Moving to Main Tables
2245: hr_utility.set_location('pay_ip_startup_util.setup',80);
2246: write_log('LOG',NULL,NULL,NULL);
2247: write_log('LOG','PAY_34016_IP_CALL_PROC','HR_LEGISLATION.INSTALL',NULL);
2248: BEGIN
2249: move_to_main_tables;
2250: EXCEPTION
2251: WHEN OTHERS THEN