1 PACKAGE HZ_ADAPTER_PUB AUTHID CURRENT_USER AS
2 /*$Header: ARHADPUS.pls 120.3 2004/05/17 06:51:32 dmmehta noship $*/
3
4 TYPE adapter_rec_type IS RECORD (
5 adapter_id NUMBER
6 ,adapter_content_source VARCHAR2(30)
7 ,adapter_meaning VARCHAR2(80)
8 ,adapter_description VARCHAR2(240) DEFAULT NULL
9 ,message_format_code VARCHAR2(30)
10 ,synchronous_flag VARCHAR2(1) DEFAULT 'Y'
11 ,invoke_method_code VARCHAR2(30)
12 ,host_address VARCHAR2(240)
13 ,enabled_flag VARCHAR2(1) DEFAULT 'Y'
14 ,maximum_batch_size NUMBER
15 ,default_batch_size NUMBER
16 ,default_replace_status_level VARCHAR2(30)
17 ,username VARCHAR2(100)
18 ,encrypted_password VARCHAR2(100) );
19
20 TYPE adapter_terr_rec_type IS RECORD (
21 adapter_id NUMBER
22 ,territory_code VARCHAR2(30)
23 ,enabled_flag VARCHAR2(1) DEFAULT 'Y'
24 ,default_flag VARCHAR2(1) );
25
26 -- This procedure create a record in location adapter by passing location adapter record type
27 PROCEDURE create_adapter (
28 p_adapter_rec IN adapter_rec_type
29 ,x_adapter_id OUT NOCOPY NUMBER
30 ,x_return_status OUT NOCOPY VARCHAR2
31 ,x_msg_count OUT NOCOPY NUMBER
32 ,x_msg_data OUT NOCOPY VARCHAR2 );
33
34 -- This procedure create a record in location adapter territory by passing
35 -- location adapter territory record type
36 PROCEDURE create_adapter_terr (
37 p_adapter_terr_rec IN adapter_terr_rec_type
38 ,x_return_status OUT NOCOPY VARCHAR2
39 ,x_msg_count OUT NOCOPY NUMBER
40 ,x_msg_data OUT NOCOPY VARCHAR2 );
41
42 -- This procedure update a record in location adapater
43 PROCEDURE update_adapter (
44 p_adapter_rec IN adapter_rec_type
45 ,px_object_version_number IN OUT NOCOPY NUMBER
46 ,x_return_status OUT NOCOPY VARCHAR2
47 ,x_msg_count OUT NOCOPY NUMBER
48 ,x_msg_data OUT NOCOPY VARCHAR2 );
49
50 -- This procedure update a record in location adapter territory
51 PROCEDURE update_adapter_terr (
52 p_adapter_terr_rec IN adapter_terr_rec_type
53 ,px_object_version_number IN OUT NOCOPY NUMBER
54 ,x_return_status OUT NOCOPY VARCHAR2
55 ,x_msg_count OUT NOCOPY NUMBER
56 ,x_msg_data OUT NOCOPY VARCHAR2 );
57
58 PROCEDURE validate_adapter(
59 p_create_update_flag IN VARCHAR2,
60 p_adapter_rec IN adapter_rec_type,
61 x_return_status IN OUT NOCOPY VARCHAR2 );
62
63 PROCEDURE validate_adapter_terr(
64 p_create_update_flag IN VARCHAR2,
65 p_adapter_terr_rec IN adapter_terr_rec_type,
66 x_return_status IN OUT NOCOPY VARCHAR2 );
67
68 END HZ_ADAPTER_PUB;