116: P_Login_Id,
117: P_user_id,
118: SYSDATE);
119: IF SQL%NOTFOUND then
120: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
121: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.insert');
122: hr_utility.set_message_token('STEP','1');
123: hr_utility.raise_error;
124: end if;
117: P_user_id,
118: SYSDATE);
119: IF SQL%NOTFOUND then
120: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
121: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.insert');
122: hr_utility.set_message_token('STEP','1');
123: hr_utility.raise_error;
124: end if;
125: end if;
118: SYSDATE);
119: IF SQL%NOTFOUND then
120: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
121: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.insert');
122: hr_utility.set_message_token('STEP','1');
123: hr_utility.raise_error;
124: end if;
125: end if;
126: --
119: IF SQL%NOTFOUND then
120: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
121: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.insert');
122: hr_utility.set_message_token('STEP','1');
123: hr_utility.raise_error;
124: end if;
125: end if;
126: --
127: RETURN ret;
145: and classification_id = p_classification_id
146: and taxability_rules_date_id = P_taxability_rules_date_id;
147:
148: IF SQL%NOTFOUND then
149: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
150: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.delete');
151: hr_utility.set_message_token('STEP','1');
152: hr_utility.raise_error;
153: end if;
146: and taxability_rules_date_id = P_taxability_rules_date_id;
147:
148: IF SQL%NOTFOUND then
149: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
150: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.delete');
151: hr_utility.set_message_token('STEP','1');
152: hr_utility.raise_error;
153: end if;
154: --
147:
148: IF SQL%NOTFOUND then
149: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
150: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.delete');
151: hr_utility.set_message_token('STEP','1');
152: hr_utility.raise_error;
153: end if;
154: --
155: RETURN ret;
148: IF SQL%NOTFOUND then
149: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
150: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.delete');
151: hr_utility.set_message_token('STEP','1');
152: hr_utility.raise_error;
153: end if;
154: --
155: RETURN ret;
156: --