APPS.PAY_IP_STARTUP_UTIL dependencies on HR_S_ROUTE_CONTEXT_USAGES

Line 368: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_ROUTE_CONTEXT_USAGES',NULL);

364: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_ROUTES',NULL);
365: DELETE hr_s_routes;
366: COMMIT;
367:
368: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_ROUTE_CONTEXT_USAGES',NULL);
369: DELETE hr_s_route_context_usages;
370: COMMIT;
371:
372: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_CONTEXTS',NULL);

Line 369: DELETE hr_s_route_context_usages;

365: DELETE hr_s_routes;
366: COMMIT;
367:
368: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_ROUTE_CONTEXT_USAGES',NULL);
369: DELETE hr_s_route_context_usages;
370: COMMIT;
371:
372: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_CONTEXTS',NULL);
373: DELETE hr_s_contexts;

Line 1070: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Route Context Usages', 'HR_S_ROUTE_CONTEXT_USAGES');

1066: WHERE EXISTS ( SELECT NULL
1067: FROM hr_s_routes b
1068: WHERE b.route_id = a.route_id));
1069: write_log('LOG',NULL,NULL,NULL);
1070: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Route Context Usages', 'HR_S_ROUTE_CONTEXT_USAGES');
1071: INSERT INTO hr_s_route_context_usages
1072: (SELECT
1073: route_id
1074: ,context_id

Line 1071: INSERT INTO hr_s_route_context_usages

1067: FROM hr_s_routes b
1068: WHERE b.route_id = a.route_id));
1069: write_log('LOG',NULL,NULL,NULL);
1070: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Route Context Usages', 'HR_S_ROUTE_CONTEXT_USAGES');
1071: INSERT INTO hr_s_route_context_usages
1072: (SELECT
1073: route_id
1074: ,context_id
1075: ,sequence_no