26: Description : This package holds building blocks used in maintenace
27: of Canadian taxability rules using PAY_TAXABILITY_RULES
28: table.
29:
30: Uses : hr_utility
31:
32: Change List
33: -----------
34: Date Name Vers Bug No Description
155: P_Login_Id,
156: P_user_id,
157: SYSDATE);
158: IF SQL%NOTFOUND then
159: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
160: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.insert');
161: hr_utility.set_message_token('STEP','1');
162: hr_utility.raise_error;
163: end if;
156: P_user_id,
157: SYSDATE);
158: IF SQL%NOTFOUND then
159: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
160: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.insert');
161: hr_utility.set_message_token('STEP','1');
162: hr_utility.raise_error;
163: end if;
164: --
157: SYSDATE);
158: IF SQL%NOTFOUND then
159: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
160: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.insert');
161: hr_utility.set_message_token('STEP','1');
162: hr_utility.raise_error;
163: end if;
164: --
165: END insert_rules;
158: IF SQL%NOTFOUND then
159: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
160: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.insert');
161: hr_utility.set_message_token('STEP','1');
162: hr_utility.raise_error;
163: end if;
164: --
165: END insert_rules;
166: --
178: and tax_category = P_category
179: and classification_id = p_classification_id
180: and taxability_rules_date_id = P_taxability_rules_date_id;
181: IF SQL%NOTFOUND then
182: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
183: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.delete');
184: hr_utility.set_message_token('STEP','1');
185: hr_utility.raise_error;
186: end if;
179: and classification_id = p_classification_id
180: and taxability_rules_date_id = P_taxability_rules_date_id;
181: IF SQL%NOTFOUND then
182: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
183: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.delete');
184: hr_utility.set_message_token('STEP','1');
185: hr_utility.raise_error;
186: end if;
187: --
180: and taxability_rules_date_id = P_taxability_rules_date_id;
181: IF SQL%NOTFOUND then
182: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
183: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.delete');
184: hr_utility.set_message_token('STEP','1');
185: hr_utility.raise_error;
186: end if;
187: --
188: --
181: IF SQL%NOTFOUND then
182: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
183: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.delete');
184: hr_utility.set_message_token('STEP','1');
185: hr_utility.raise_error;
186: end if;
187: --
188: --
189: END delete_rules;