1 PACKAGE IEM_ROUTE_PUB AUTHID CURRENT_USER AS
2 /* $Header: iemprous.pls 120.1 2006/03/23 02:08:40 pkesani noship $ */
3
4 /*GLOBAL VARIABLES AVAILABLE TO THE PUBLIC FOR CALLING
5 ===================================================*/
6
7 --The record type for passing in Key-Value pairs
8 TYPE keyVals_rec_type is RECORD (
9 -- key iem_route_rules.key_type_code%type,
10 -- value iem_route_rules.value%type,
11 key VARCHAR2(30),
12 value VARCHAR2(2000),
13 datatype varchar2(1));
14
15 --Table of Key-Values
16 TYPE keyVals_tbl_type is TABLE OF keyVals_rec_type INDEX BY BINARY_INTEGER;
17
18
19 --Main Public method
20 PROCEDURE route(
21 p_api_version_number IN Number,
22 p_init_msg_list IN VARCHAR2 := NULL,
23 p_commit IN VARCHAR2 := NULL,
24 p_keyVals_tbl IN keyVals_tbl_type,
25 p_accountId IN Number,
26 x_groupId OUT NOCOPY Number,
27 x_return_status OUT NOCOPY VARCHAR2,
28 x_msg_count OUT NOCOPY NUMBER,
29 x_msg_data OUT NOCOPY VARCHAR2);
30
31 function get_key_value ( p_keyVals_tbl IN keyVals_tbl_type,
32 p_key_name IN VARCHAR2 )
33 return VARCHAR2;
34
35 END IEM_ROUTE_PUB;