1 PACKAGE ZX_REG_REL_PUB AS
2 /* $Header: zxcregrelpubs.pls 120.1 2004/01/02 15:43:49 vramamur ship $ */
3
4 TYPE regime_rec is RECORD(
5 regime_code VARCHAR2(30),
6 regime_name VARCHAR2(80)
7 );
8 TYPE regime_rec_arr_type is table of regime_rec index by binary_integer;
9 TYPE regime_level_rec is RECORD(
10 regime_code VARCHAR2(30),
11 parent_regime_code VARCHAR2(30),
12 level NUMBER
13 );
14 TYPE regime_rec_level_arr_type is table of regime_level_rec index by binary_integer;
15
16 PROCEDURE insert_rel(
17 x_return_status OUT NOCOPY VARCHAR2,
18 p_child IN VARCHAR2,
19 p_parent IN VARCHAR2,
20 X_CREATED_BY in NUMBER,
21 X_CREATION_DATE in DATE,
22 X_LAST_UPDATED_BY in NUMBER,
23 X_LAST_UPDATE_DATE in DATE,
24 X_LAST_UPDATE_LOGIN in NUMBER,
25 X_REQUEST_ID in NUMBER,
26 X_PROGRAM_ID in NUMBER,
27 X_PROGRAM_LOGIN_ID in NUMBER,
28 X_PROGRAM_APPLICATION_ID in NUMBER
29 );
30
31 PROCEDURE update_rel(
32 x_return_status OUT NOCOPY VARCHAR2,
33 p_child IN VARCHAR2 ,
34 p_parent IN VARCHAR2 default null,
35 X_LAST_UPDATED_BY in NUMBER,
36 X_LAST_UPDATE_DATE in DATE,
37 X_LAST_UPDATE_LOGIN in NUMBER,
38 X_REQUEST_ID in NUMBER,
39 X_PROGRAM_ID in NUMBER,
40 X_PROGRAM_LOGIN_ID in NUMBER,
41 X_PROGRAM_APPLICATION_ID in NUMBER
42 );
43
44 PROCEDURE update_taxes(
45 x_return_status OUT NOCOPY VARCHAR2,
46 p_regime_code IN VARCHAR2 ,
47 p_old_rep_tax_auth_id IN NUMBER ,
48 p_old_coll_tax_auth_id IN NUMBER,
49 p_new_rep_tax_auth_id IN NUMBER ,
50 p_new_coll_tax_auth_id IN NUMBER
51 );
52
53 PROCEDURE get_regime_details(
54 x_return_status OUT NOCOPY VARCHAR2,
55 p_country_code IN VARCHAR2 default null,
56 p_tax_regime_code IN VARCHAR2 default null,
57 x_regime_rec OUT NOCOPY regime_rec_arr_type );
58
59 PROCEDURE get_regime_hierarchy(
60 x_return_status OUT NOCOPY VARCHAR2,
61 p_tax_regime_code IN VARCHAR2 default null,
62 x_regime_level_rec OUT NOCOPY regime_rec_level_arr_type
63 );
64
65 END ZX_REG_REL_PUB;