1 PACKAGE pay_ca_taxability_rules_pkg AUTHID CURRENT_USER as
2 /* $Header: paycaetw.pkh 120.1 2006/02/21 12:13:28 ssouresr noship $ */
3 --
4 --
5 /*
6 ******************************************************************
7 * *
8 * Copyright (C) 1993 Oracle Corporation. *
9 * All rights reserved. *
10 * *
11 * This material has been provided pursuant to an agreement *
12 * containing restrictions on its use. The material is also *
13 * protected by copyright law. No part of this material may *
14 * be copied or distributed, transmitted or transcribed, in *
15 * any form or by any means, electronic, mechanical, magnetic, *
16 * manual, or otherwise, or disclosed to third parties without *
17 * the express written permission of Oracle Corporation, *
18 * 500 Oracle Parkway, Redwood City, CA, 94065. *
19 * *
20 ******************************************************************
21
22
23 Name : pay_ca_taxability_rules_pkg
24
25 Description : This package holds building blocks used in maintenace
26 of Canadian taxability rules using PAY_TAXABILITY_RULES
27 table.
28
29 Uses : hr_utility
30
31 Change List
32 -----------
33 Date Name Vers Bug No Description
34 ---- ---- ---- ------ -----------
35 NOV-11-1993 RMAMGAIN 1.0 Created with following proc.
36 get_or_update
37 05-NOV-05 SSOURESR 115.1 Added tax type PPIP
38 */
39 --
40
41 PROCEDURE get_or_update(X_MODE VARCHAR2,
42 X_CONTEXT VARCHAR2,
43 X_JURISDICTION VARCHAR2,
44 X_TAX_CAT VARCHAR2,
45 X_classification_id NUMBER,
46 X_legislation_code VARCHAR2,
47 X_taxability_rules_date_id out nocopy NUMBER,
48 X_valid_date_from in out nocopy DATE,
49 X_valid_date_to in out nocopy DATE,
50 X_session_date DATE,
51 X_BOX1 IN OUT nocopy VARCHAR2,
52 X_BOX2 IN OUT nocopy VARCHAR2,
53 X_BOX3 IN OUT nocopy VARCHAR2,
54 X_BOX4 IN OUT nocopy VARCHAR2,
55 X_BOX5 IN OUT nocopy VARCHAR2,
56 X_BOX6 IN OUT nocopy VARCHAR2,
57 X_BOX7 IN OUT nocopy VARCHAR2,
58 X_BOX8 IN OUT nocopy VARCHAR2,
59 X_BOX9 IN OUT nocopy VARCHAR2,
60 X_BOX10 IN OUT nocopy VARCHAR2);
61 --
62 FUNCTION get_classification_id (p_classification_name VARCHAR2) RETURN NUMBER;
63 --
64 END pay_ca_taxability_rules_pkg;