DBA Data[Home] [Help]

APPS.PAY_IP_STARTUP_UTIL dependencies on HR_S_HISTORY

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

586: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_VALID_DEPENDENT_TYPES',NULL);
587: DELETE hr_s_valid_dependent_types;
588: COMMIT;
589:
590: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_HISTORY',NULL);
591: DELETE hr_s_history;
592: COMMIT;
593:
594: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_STATE_RULES',NULL);

Line 591: DELETE hr_s_history;

587: DELETE hr_s_valid_dependent_types;
588: COMMIT;
589:
590: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_HISTORY',NULL);
591: DELETE hr_s_history;
592: COMMIT;
593:
594: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_STATE_RULES',NULL);
595: DELETE hr_s_state_rules;

Line 1889: INSERT INTO hr_s_history

1885: (p_legislation_code IN VARCHAR2) IS
1886:
1887: BEGIN
1888: hr_utility.set_location('pay_ip_startup_util.insert_history_table',10);
1889: INSERT INTO hr_s_history
1890: ( package_name
1891: ,date_of_export
1892: ,date_of_import
1893: ,status

Line 3474: -- Inserting in to HR_S_HISTORY table

3470: write_log('LOG',NULL,NULL,NULL);
3471: write_log('LOG','PAY_34014_IP_UPD_LEG_CURR',p_Legislation_Code,p_currency_code);
3472: update_shadow_tables(p_legislation_code, p_currency_code);
3473:
3474: -- Inserting in to HR_S_HISTORY table
3475:
3476: hr_utility.set_location('pay_ip_startup_util.setup',70);
3477: write_log('LOG',NULL,NULL,NULL);
3478: write_log('LOG','PAY_34011_IP_INS_DATA_IN_TABLE','record','HR_S_HISTORY');

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

3474: -- Inserting in to HR_S_HISTORY table
3475:
3476: hr_utility.set_location('pay_ip_startup_util.setup',70);
3477: write_log('LOG',NULL,NULL,NULL);
3478: write_log('LOG','PAY_34011_IP_INS_DATA_IN_TABLE','record','HR_S_HISTORY');
3479: insert_history_table(p_legislation_code);
3480:
3481: -- Moving to Main Tables
3482: hr_utility.set_location('pay_ip_startup_util.setup',80);