1 PACKAGE JG_TAXID_VAL_PKG AUTHID CURRENT_USER AS
2 /* $Header: jgzzgtis.pls 120.2 2002/11/12 23:30:14 thwon ship $ */
3
4 FUNCTION check_numeric(p_taxpayer_id IN VARCHAR2) RETURN VARCHAR2;
5
6 FUNCTION check_length(p_country_code IN VARCHAR2,
7 p_num_digits IN NUMBER,
8 p_taxpayer_id IN VARCHAR2) RETURN VARCHAR2;
9
10 FUNCTION check_primary_bank_branch(p_bank_branch_id IN NUMBER,
11 p_bank_name IN VARCHAR2,
12 p_bank_branch_name IN VARCHAR2) RETURN VARCHAR2;
13
14 FUNCTION check_detail_bank_branch(p_bank_branch_id IN NUMBER) RETURN VARCHAR2;
15
16 FUNCTION check_uniqueness(p_country_code IN VARCHAR2,
17 p_taxpayer_id IN VARCHAR2,
18 p_record_id IN NUMBER,
19 p_calling_program IN VARCHAR2,
20 p_orig_system_ref IN VARCHAR2,
21 p_entity_name IN VARCHAR2,
22 p_request_id IN NUMBER) RETURN VARCHAR2;
23
24 FUNCTION check_unique_tax_reg_num(p_country_code IN VARCHAR2,
25 p_tax_reg_num IN VARCHAR2,
26 p_record_id IN NUMBER,
27 p_calling_program IN VARCHAR2,
28 p_orig_system_ref IN VARCHAR2,
29 p_entity_name IN VARCHAR2,
30 p_request_id IN NUMBER) RETURN VARCHAR2;
31
32 PROCEDURE check_cross_module(p_country_code IN VARCHAR2,
33 p_entity_name IN VARCHAR2,
34 p_taxpayer_id IN VARCHAR2,
35 p_origin IN VARCHAR2,
36 p_taxid_type IN VARCHAR2,
37 p_calling_program IN VARCHAR2,
38 p_return_ar OUT NOCOPY VARCHAR2,
39 p_return_ap OUT NOCOPY VARCHAR2,
40 p_return_hr OUT NOCOPY VARCHAR2,
41 p_return_bk OUT NOCOPY VARCHAR2);
42
43 FUNCTION check_algorithm(p_taxpayer_id IN VARCHAR2,
44 p_country IN VARCHAR2,
45 p_global_attribute12 IN VARCHAR2) RETURN VARCHAR2;
46
47
48 END JG_TAXID_VAL_PKG;