23: Description : This package holds building blocks used in maintenace
24: of US taxability rule using PAY_TAXABILITY_RULES
25: table.
26:
27: Uses : hr_utility
28:
29: Change List
30: -----------
31: Date Name Vers Bug No Description
200: SYSDATE, P_user_id, P_Login_Id,
201: P_user_id, SYSDATE);
202:
203: IF SQL%NOTFOUND then
204: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
205: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.insert');
206: hr_utility.set_message_token('STEP','1');
207: hr_utility.raise_error;
208: end if;
201: P_user_id, SYSDATE);
202:
203: IF SQL%NOTFOUND then
204: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
205: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.insert');
206: hr_utility.set_message_token('STEP','1');
207: hr_utility.raise_error;
208: end if;
209: end if;
202:
203: IF SQL%NOTFOUND then
204: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
205: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.insert');
206: hr_utility.set_message_token('STEP','1');
207: hr_utility.raise_error;
208: end if;
209: end if;
210:
203: IF SQL%NOTFOUND then
204: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
205: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.insert');
206: hr_utility.set_message_token('STEP','1');
207: hr_utility.raise_error;
208: end if;
209: end if;
210:
211: RETURN ret;
235: and classification_id = p_classification_id
236: and taxability_rules_date_id = P_taxability_rules_date_id;
237:
238: IF SQL%NOTFOUND then
239: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
240: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.delete');
241: hr_utility.set_message_token('STEP','1');
242: hr_utility.raise_error;
243: end if;
236: and taxability_rules_date_id = P_taxability_rules_date_id;
237:
238: IF SQL%NOTFOUND then
239: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
240: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.delete');
241: hr_utility.set_message_token('STEP','1');
242: hr_utility.raise_error;
243: end if;
244: --
237:
238: IF SQL%NOTFOUND then
239: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
240: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.delete');
241: hr_utility.set_message_token('STEP','1');
242: hr_utility.raise_error;
243: end if;
244: --
245: RETURN ret;
238: IF SQL%NOTFOUND then
239: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
240: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.delete');
241: hr_utility.set_message_token('STEP','1');
242: hr_utility.raise_error;
243: end if;
244: --
245: RETURN ret;
246: --
581: p_tax_category => X_tax_cat,
582: p_tax_type => 'WC',
583: p_classification_id => X_classification_id ))
584: THEN
585: hr_utility.set_message(801, 'HR_50000_WC_ONLY_INC_ONE_OT');
586: hr_utility.raise_error;
587: END IF;
588: --
589: P_i := insert_rules(X_jurisdiction,'WC',X_tax_cat, X_classification_id, p_taxability_rules_date_id);
582: p_tax_type => 'WC',
583: p_classification_id => X_classification_id ))
584: THEN
585: hr_utility.set_message(801, 'HR_50000_WC_ONLY_INC_ONE_OT');
586: hr_utility.raise_error;
587: END IF;
588: --
589: P_i := insert_rules(X_jurisdiction,'WC',X_tax_cat, X_classification_id, p_taxability_rules_date_id);
590: end if;
791: ld_effective_date date;
792:
793:
794: Begin
795: hr_utility.trace('tax_type :'||p_tax_type);
796: hr_utility.trace('tax_category :'||p_tax_category);
797: hr_utility.trace('p_legislation_code :'||p_legislation_code);
798: hr_utility.trace('p_taxability_rules_date_id :'||to_char(p_taxability_rules_date_id));
799: hr_utility.trace('p_classification_id :'||to_char(p_classification_id));
792:
793:
794: Begin
795: hr_utility.trace('tax_type :'||p_tax_type);
796: hr_utility.trace('tax_category :'||p_tax_category);
797: hr_utility.trace('p_legislation_code :'||p_legislation_code);
798: hr_utility.trace('p_taxability_rules_date_id :'||to_char(p_taxability_rules_date_id));
799: hr_utility.trace('p_classification_id :'||to_char(p_classification_id));
800:
793:
794: Begin
795: hr_utility.trace('tax_type :'||p_tax_type);
796: hr_utility.trace('tax_category :'||p_tax_category);
797: hr_utility.trace('p_legislation_code :'||p_legislation_code);
798: hr_utility.trace('p_taxability_rules_date_id :'||to_char(p_taxability_rules_date_id));
799: hr_utility.trace('p_classification_id :'||to_char(p_classification_id));
800:
801:
794: Begin
795: hr_utility.trace('tax_type :'||p_tax_type);
796: hr_utility.trace('tax_category :'||p_tax_category);
797: hr_utility.trace('p_legislation_code :'||p_legislation_code);
798: hr_utility.trace('p_taxability_rules_date_id :'||to_char(p_taxability_rules_date_id));
799: hr_utility.trace('p_classification_id :'||to_char(p_classification_id));
800:
801:
802: if p_legislation_code = 'US' then
795: hr_utility.trace('tax_type :'||p_tax_type);
796: hr_utility.trace('tax_category :'||p_tax_category);
797: hr_utility.trace('p_legislation_code :'||p_legislation_code);
798: hr_utility.trace('p_taxability_rules_date_id :'||to_char(p_taxability_rules_date_id));
799: hr_utility.trace('p_classification_id :'||to_char(p_classification_id));
800:
801:
802: if p_legislation_code = 'US' then
803:
814: fetch c_session into ld_effective_date ;
815: if c_session%notfound then ld_effective_date := trunc(sysdate,'Y') ;
816: end if;
817: close c_session ;
818: hr_utility.trace('ld_effective_date :'||to_char(ld_effective_date));
819:
820: open c_chk_element_taxcat(p_classification_id,
821: p_tax_category,
822: ld_effective_date);
834: loop
835: fetch c_get_balance_type into ln_balance_type_id
836: ,lv_balance_name;
837: exit when c_get_balance_type%notfound;
838: hr_utility.trace('balance_type_id :'||to_char(ln_balance_type_id));
839: hr_utility.trace('balance_name :'||lv_balance_name);
840:
841:
842:
835: fetch c_get_balance_type into ln_balance_type_id
836: ,lv_balance_name;
837: exit when c_get_balance_type%notfound;
838: hr_utility.trace('balance_type_id :'||to_char(ln_balance_type_id));
839: hr_utility.trace('balance_name :'||lv_balance_name);
840:
841:
842:
843: /* for each of balance fetched call the core
862:
863: end if; /* p_legislation_code = 'US' */
864: END;
865: --begin
866: --hr_utility.trace_on (null, 'XTR');
867:
868: END pay_us_taxability_rules_pkg;