[Home] [Help]
128:
129: CURSOR get_balance_dimensions_csr IS
130: SELECT distinct balance_dimension_id, dimension_name
131: FROM hr_s_application_ownerships ao
132: ,hr_s_balance_dimensions pbd
133: ,fnd_product_installations b
134: ,fnd_application c
135: WHERE pbd.legislation_code ='ZZ'
136: AND ao.key_name = 'BALANCE_DIMENSION_ID'
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'
153: AND ao.key_name = 'ROUTE_ID'
207:
208: -- write output file for Balance Dimensions to be Installed.
209:
210: write_log('OUTPUT',NULL,NULL,NULL);
211: --write_log ('OUTPUT','PAY_34011_IP_INS_DATA_IN_TABLE', 'Balance Dimensions', 'HR_S_BALANCE_DIMENSIONS');
212:
213: FOR rec IN get_balance_dimensions_csr LOOP
214: write_log ('OUTPUT','PAY_34012_IP_INS_DATA', 'Balance Dimension', rec.dimension_name);
215: END LOOP;
502: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_BALANCE_FEEDS_F',NULL);
503: DELETE hr_s_balance_feeds_f;
504: COMMIT;
505:
506: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_BALANCE_DIMENSIONS',NULL);
507: DELETE hr_s_balance_dimensions;
508: COMMIT;
509:
510: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_DIMENSION_ROUTES',NULL);
503: DELETE hr_s_balance_feeds_f;
504: COMMIT;
505:
506: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_BALANCE_DIMENSIONS',NULL);
507: DELETE hr_s_balance_dimensions;
508: COMMIT;
509:
510: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_DIMENSION_ROUTES',NULL);
511: DELETE hr_s_dimension_routes;
1080:
1081: --Balance Dimensions
1082:
1083: write_log('LOG',NULL,NULL,NULL);
1084: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Balance Dimensions', 'HR_S_BALANCE_DIMENSIONS');
1085: FOR rec IN get_balance_dimensions_csr LOOP
1086: write_log ('LOG','PAY_34012_IP_INS_DATA', 'Balance Dimension', rec.dimension_name);
1087:
1088: INSERT INTO hr_s_balance_dimensions
1084: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Balance Dimensions', 'HR_S_BALANCE_DIMENSIONS');
1085: FOR rec IN get_balance_dimensions_csr LOOP
1086: write_log ('LOG','PAY_34012_IP_INS_DATA', 'Balance Dimension', rec.dimension_name);
1087:
1088: INSERT INTO hr_s_balance_dimensions
1089: ( balance_dimension_id
1090: ,business_group_id
1091: ,legislation_code
1092: ,route_id
1223: UPDATE hr_s_dimension_routes
1224: SET run_dimension_id =
1225: (
1226: SELECT balance_dimension_id
1227: FROM hr_s_balance_dimensions
1228: WHERE legislation_code = 'ZZ'
1229: AND database_item_suffix = '_ASG_RUN'
1230: );
1231:
1231:
1232: DELETE FROM hr_s_application_ownerships
1233: WHERE key_name = 'BALANCE_DIMENSION_ID'
1234: AND TO_NUMBER(key_value) IN (SELECT balance_dimension_id
1235: FROM hr_s_balance_dimensions
1236: WHERE legislation_code = 'ZZ'
1237: AND INSTR(database_item_suffix,'_TU_') > 0);
1238:
1239: /* Set the SRB flag only when run balance patch is applied*/
1241: /* With tax unit not installed update
1242: the SAVE_RUN_BALANCE_ENABLED flag
1243: of _ASG_RUN dimension to 'Y'
1244: */
1245: UPDATE hr_s_balance_dimensions
1246: SET save_run_balance_enabled = 'Y'
1247: WHERE legislation_code = 'ZZ'
1248: AND database_item_suffix = '_ASG_RUN';
1249: END IF;
1830:
1831:
1832: --Updating Balance Dimensions Table
1833:
1834: write_log('LOG','PAY_34015_IP_UPD_TABLE','HR_S_BALANCE_DIMENSIONS',NULL);
1835: UPDATE hr_s_balance_dimensions
1836: SET legislation_code = p_legislation_code
1837: WHERE legislation_code = 'ZZ';
1838:
1831:
1832: --Updating Balance Dimensions Table
1833:
1834: write_log('LOG','PAY_34015_IP_UPD_TABLE','HR_S_BALANCE_DIMENSIONS',NULL);
1835: UPDATE hr_s_balance_dimensions
1836: SET legislation_code = p_legislation_code
1837: WHERE legislation_code = 'ZZ';
1838:
1839: --Updating Legislation Rules Table