1 PACKAGE XLE_REGISTRATIONS_VAL_PVT AUTHID CURRENT_USER AS
2 /* $Header: xleregvs.pls 120.2 2011/05/20 09:12:55 srsampat ship $ */
3
4 /*-----------------------------------------------------------
5 This procedure is called from the Creae LE page, Create
6 Registration for LE page and from Create Registration for
7 Establishment page.
8
9 This procedure validates the Registration Number as per the
10 validation rules known for a few of the countries.
11 viz - Argentina, Brazil, Colombia, Chile, Spain,
12 Italy, Portugal
13 ------------------------------------------------------------*/
14 PROCEDURE Validate_Reg_Number(
15 p_jurisdiction_id IN NUMBER,
16 p_registration_id IN NUMBER,
17 p_registration_number IN VARCHAR2,
18 p_entity_type IN VARCHAR2,
19 p_init_msg_list IN VARCHAR2,
20 x_return_status IN OUT NOCOPY VARCHAR2,
21 x_msg_count IN OUT NOCOPY NUMBER ,
22 x_msg_data IN OUT NOCOPY VARCHAR2);
23
24 -- Perform Spanish registration number validation
25 -- as per algorithm
26 PROCEDURE do_es_regnum_validations(
27 p_legislative_cat_code IN VARCHAR2,
28 p_required_flag IN VARCHAR2,
29 p_registration_code IN VARCHAR2,
30 p_registration_number IN VARCHAR2,
31 x_return_status IN OUT NOCOPY VARCHAR2 ,
32 x_msg_data IN OUT NOCOPY VARCHAR2 ,
33 x_msg_count IN OUT NOCOPY NUMBER );
34
35
36 -- Perform Portugeese registration number validation
37 -- as per algorithm
38 PROCEDURE do_pt_regnum_validations(
39 p_legislative_cat_code IN VARCHAR2,
40 p_required_flag IN VARCHAR2,
41 p_registration_code IN VARCHAR2,
42 p_registration_number IN VARCHAR2,
43 x_return_status IN OUT NOCOPY VARCHAR2 ,
44 x_msg_data IN OUT NOCOPY VARCHAR2 ,
45 x_msg_count IN OUT NOCOPY NUMBER );
46
47 -- Perform validation for 11 digit Italian registration
48 -- number.
49 procedure PO_VALIDATE_VAT_IT(
50 VAT_VALUE IN VARCHAR2,
51 Xi_UNIQUE_FLAG IN VARCHAR2,
52 RET_VAR OUT NOCOPY VARCHAR2,
53 RET_MESSAGE OUT NOCOPY VARCHAR2);
54
55
56 -- Perform Italian registration number validation
57 -- as per algorithm
58 PROCEDURE do_it_regnum_validations(
59 p_legislative_cat_code IN VARCHAR2,
60 p_required_flag IN VARCHAR2,
61 p_registration_code IN VARCHAR2,
62 p_registration_number IN VARCHAR2,
63 x_return_status IN OUT NOCOPY VARCHAR2 ,
64 x_msg_data IN OUT NOCOPY VARCHAR2 ,
65 x_msg_count IN OUT NOCOPY NUMBER );
66
67 -- Perform Argentine registration number validation
68 -- as per algorithm
69 PROCEDURE do_ar_regnum_validations(
70 p_legislative_cat_code IN VARCHAR2,
71 p_required_flag IN VARCHAR2,
72 p_registration_code IN VARCHAR2,
73 p_registration_number IN VARCHAR2,
74 x_return_status IN OUT NOCOPY VARCHAR2 ,
75 x_msg_data IN OUT NOCOPY VARCHAR2 ,
76 x_msg_count IN OUT NOCOPY NUMBER );
77
78 -- Perform Chilean registration number validation
79 -- as per algorithm
80 PROCEDURE do_cl_regnum_validations(
81 p_legislative_cat_code IN VARCHAR2,
82 p_required_flag IN VARCHAR2,
83 p_registration_code IN VARCHAR2,
84 p_registration_number IN VARCHAR2,
85 x_return_status IN OUT NOCOPY VARCHAR2 ,
86 x_msg_data IN OUT NOCOPY VARCHAR2 ,
87 x_msg_count IN OUT NOCOPY NUMBER );
88
89
90 -- Perform Colombian registration number validation
91 -- as per algorithm
92 PROCEDURE do_co_regnum_validations(
93 p_legislative_cat_code IN VARCHAR2,
94 p_required_flag IN VARCHAR2,
95 p_registration_code IN VARCHAR2,
96 p_registration_number IN VARCHAR2,
97 x_return_status IN OUT NOCOPY VARCHAR2 ,
98 x_msg_data IN OUT NOCOPY VARCHAR2 ,
99 x_msg_count IN OUT NOCOPY NUMBER );
100
101 -- Perform Brazilian registration number validation
102 -- as per algorithm
103 PROCEDURE do_br_regnum_validations(
104 p_legislative_cat_code IN VARCHAR2,
105 p_required_flag IN VARCHAR2,
106 p_registration_code IN VARCHAR2,
107 p_registration_number IN VARCHAR2,
108 x_return_status IN OUT NOCOPY VARCHAR2 ,
109 x_msg_data IN OUT NOCOPY VARCHAR2 ,
110 x_msg_count IN OUT NOCOPY NUMBER );
111
112 END XLE_REGISTRATIONS_VAL_PVT;
113
114