APPS.PAY_IP_STARTUP_UTIL dependencies on HR_S_ROUTES

Line 148: ,hr_s_routes fr

144:
145: CURSOR get_routes_csr IS
146: SELECT distinct fr.route_id, route_name
147: FROM hr_s_application_ownerships ao
148: ,hr_s_routes fr
149: ,hr_s_balance_dimensions pbd
150: ,fnd_product_installations b
151: ,fnd_application c
152: WHERE pbd.legislation_code ='ZZ'

Line 220: --write_log ('OUTPUT','PAY_34011_IP_INS_DATA_IN_TABLE', 'Routes', 'HR_S_ROUTES');

216:
217: -- write output file for Balance Dimensions to be Installed.
218:
219: write_log('OUTPUT',NULL,NULL,NULL);
220: --write_log ('OUTPUT','PAY_34011_IP_INS_DATA_IN_TABLE', 'Routes', 'HR_S_ROUTES');
221:
222: FOR rec IN get_routes_csr LOOP
223: write_log ('OUTPUT','PAY_34012_IP_INS_DATA', 'Route', rec.route_name);
224: END LOOP;

Line 416: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_ROUTES',NULL);

412: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_FORMULAS_F',NULL);
413: DELETE hr_s_formulas_f;
414: COMMIT;
415:
416: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_ROUTES',NULL);
417: DELETE hr_s_routes;
418: COMMIT;
419:
420: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_ROUTE_CONTEXT_USAGES',NULL);

Line 417: DELETE hr_s_routes;

413: DELETE hr_s_formulas_f;
414: COMMIT;
415:
416: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_ROUTES',NULL);
417: DELETE hr_s_routes;
418: COMMIT;
419:
420: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_ROUTE_CONTEXT_USAGES',NULL);
421: DELETE hr_s_route_context_usages;

Line 1139: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Routes', 'HR_S_ROUTES');

1135:
1136: --Routes
1137:
1138: write_log('LOG',NULL,NULL,NULL);
1139: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Routes', 'HR_S_ROUTES');
1140: FOR rec IN get_routes_csr LOOP
1141: write_log ('LOG','PAY_34012_IP_INS_DATA', 'Route', rec.route_name);
1142:
1143: INSERT INTO hr_s_routes

Line 1143: INSERT INTO hr_s_routes

1139: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Routes', 'HR_S_ROUTES');
1140: FOR rec IN get_routes_csr LOOP
1141: write_log ('LOG','PAY_34012_IP_INS_DATA', 'Route', rec.route_name);
1142:
1143: INSERT INTO hr_s_routes
1144: ( route_id
1145: ,route_name
1146: ,user_defined_flag
1147: ,description

Line 1268: FROM hr_s_routes b

1264: ,parameter_name
1265: ,sequence_no
1266: FROM ff_route_parameters a
1267: WHERE EXISTS ( SELECT NULL
1268: FROM hr_s_routes b
1269: WHERE b.route_id = a.route_id));
1270: write_log('LOG',NULL,NULL,NULL);
1271: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Route Context Usages', 'HR_S_ROUTE_CONTEXT_USAGES');
1272: INSERT INTO hr_s_route_context_usages

Line 1279: FROM hr_s_routes b

1275: ,context_id
1276: ,sequence_no
1277: FROM ff_route_context_usages a
1278: WHERE EXISTS ( SELECT NULL
1279: FROM hr_s_routes b
1280: WHERE b.route_id = a.route_id));
1281:
1282: hr_utility.set_location('pay_ip_startup_util.move_to_shadow_tables ',70);
1283: