[Home] [Help]
927: pay_tab(3) := 'PAY_US_STATE_TAX_INFO_F';
928: pay_tab(4) := 'PAY_US_FEDERAL_TAX_INFO_F';
929: pay_tab(5) := 'PAY_US_GARN_EXEMPTION_RULES_F';
930: pay_tab(6) := 'PAY_US_GARN_FEE_RULES_F';
931: pay_tab(7) := 'PAY_US_GARN_LIMIT_RULES_F';
932: pay_tab(8) := 'HR_REPORT_LOOKUPS';
933:
934: select count(*)
935: into l_patch_count
1153:
1154:
1155: for glr_rec in glr loop
1156: savepoint new_primary_key;
1157: insert into PAY_US_GARN_LIMIT_RULES_F
1158: (
1159: LIMIT_RULE_ID,
1160: EFFECTIVE_START_DATE,
1161: EFFECTIVE_END_DATE,
1171: CREATION_DATE) values
1172: (
1173: glr_rec.LIMIT_RULE_ID,
1174: /* Since we have already deleted all rows from
1175: pay_us_garn_limit_rules_f, there cannot be any conflict of ids. It is
1176: therefore safe to use the ids from the hr_s table. This will help in
1177: maintainig the correct ids for date-tracked rows. After inserting
1178: all the rows we will set the sequence to start at a value higher than the
1179: max value of the id in pay_us_garn_limit_rules_f.
1175: pay_us_garn_limit_rules_f, there cannot be any conflict of ids. It is
1176: therefore safe to use the ids from the hr_s table. This will help in
1177: maintainig the correct ids for date-tracked rows. After inserting
1178: all the rows we will set the sequence to start at a value higher than the
1179: max value of the id in pay_us_garn_limit_rules_f.
1180: PAY_US_GARN_LIMIT_RULES_S.nextval, -- cahnges for nextval */
1181: glr_rec.EFFECTIVE_START_DATE,
1182: glr_rec.EFFECTIVE_END_DATE,
1183: glr_rec.GARN_CATEGORY,
1195: end loop;
1196:
1197: select max(limit_rule_id)
1198: into l_max_val
1199: from pay_us_garn_limit_rules_f;
1200:
1201: l_next_val := 0;
1202:
1203: /* consume sequence till there is no conflict */