DBA Data[Home] [Help]

APPS.PAY_IP_STARTUP_UTIL dependencies on HR_S_HISTORY

Line 528: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_HISTORY',NULL);

524: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_VALID_DEPENDENT_TYPES',NULL);
525: DELETE hr_s_valid_dependent_types;
526: COMMIT;
527:
528: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_HISTORY',NULL);
529: DELETE hr_s_history;
530: COMMIT;
531:
532: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_STATE_RULES',NULL);

Line 529: DELETE hr_s_history;

525: DELETE hr_s_valid_dependent_types;
526: COMMIT;
527:
528: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_HISTORY',NULL);
529: DELETE hr_s_history;
530: COMMIT;
531:
532: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_STATE_RULES',NULL);
533: DELETE hr_s_state_rules;

Line 1506: INSERT INTO hr_s_history

1502: (p_legislation_code IN VARCHAR2) IS
1503:
1504: BEGIN
1505: hr_utility.set_location('pay_ip_startup_util.insert_history_table',10);
1506: INSERT INTO hr_s_history
1507: ( package_name
1508: ,date_of_export
1509: ,date_of_import
1510: ,status

Line 2237: -- Inserting in to HR_S_HISTORY table

2233: write_log('LOG',NULL,NULL,NULL);
2234: write_log('LOG','PAY_34014_IP_UPD_LEG_CURR',p_Legislation_Code,p_currency_code);
2235: update_shadow_tables(p_legislation_code, p_currency_code);
2236:
2237: -- Inserting in to HR_S_HISTORY table
2238:
2239: hr_utility.set_location('pay_ip_startup_util.setup',70);
2240: write_log('LOG',NULL,NULL,NULL);
2241: write_log('LOG','PAY_34011_IP_INS_DATA_IN_TABLE','record','HR_S_HISTORY');

Line 2241: write_log('LOG','PAY_34011_IP_INS_DATA_IN_TABLE','record','HR_S_HISTORY');

2237: -- Inserting in to HR_S_HISTORY table
2238:
2239: hr_utility.set_location('pay_ip_startup_util.setup',70);
2240: write_log('LOG',NULL,NULL,NULL);
2241: write_log('LOG','PAY_34011_IP_INS_DATA_IN_TABLE','record','HR_S_HISTORY');
2242: insert_history_table(p_legislation_code);
2243:
2244: -- Moving to Main Tables
2245: hr_utility.set_location('pay_ip_startup_util.setup',80);