104: P_Login_Id,
105: P_user_id,
106: SYSDATE);
107: IF SQL%NOTFOUND then
108: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
109: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.insert');
110: hr_utility.set_message_token('STEP','1');
111: hr_utility.raise_error;
112: end if;
105: P_user_id,
106: SYSDATE);
107: IF SQL%NOTFOUND then
108: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
109: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.insert');
110: hr_utility.set_message_token('STEP','1');
111: hr_utility.raise_error;
112: end if;
113: --
106: SYSDATE);
107: IF SQL%NOTFOUND then
108: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
109: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.insert');
110: hr_utility.set_message_token('STEP','1');
111: hr_utility.raise_error;
112: end if;
113: --
114: END insert_rules;
107: IF SQL%NOTFOUND then
108: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
109: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.insert');
110: hr_utility.set_message_token('STEP','1');
111: hr_utility.raise_error;
112: end if;
113: --
114: END insert_rules;
115: --
129: and taxability_rules_date_id = P_taxability_rules_date_id
130: and legislation_code = P_legislation_code;
131:
132: IF SQL%NOTFOUND then
133: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
134: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.delete');
135: hr_utility.set_message_token('STEP','1');
136: hr_utility.raise_error;
137: end if;
130: and legislation_code = P_legislation_code;
131:
132: IF SQL%NOTFOUND then
133: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
134: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.delete');
135: hr_utility.set_message_token('STEP','1');
136: hr_utility.raise_error;
137: end if;
138: --
131:
132: IF SQL%NOTFOUND then
133: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
134: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.delete');
135: hr_utility.set_message_token('STEP','1');
136: hr_utility.raise_error;
137: end if;
138: --
139: END delete_rules;
132: IF SQL%NOTFOUND then
133: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
134: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.delete');
135: hr_utility.set_message_token('STEP','1');
136: hr_utility.raise_error;
137: end if;
138: --
139: END delete_rules;
140: --