1 PACKAGE AST_ROUTING_PUB AUTHID CURRENT_USER AS
2 /* $Header: asttmrts.pls 115.10 2004/09/03 09:00:05 uadhikar ship $ */
3
4 TYPE resource_access_rec_type is RECORD
5 (
6 resource_id NUMBER,
7 access_level VARCHAR2(1)
8 );
9
10 TYPE resource_access_tbl_type is TABLE of resource_access_rec_type
11 index by BINARY_INTEGER;
12
13 G_NO_PARTY CONSTANT NUMBER := -1;
14 G_MULTIPLE_PARTY CONSTANT NUMBER := -2;
15
16 ------------------------------------------------------------------------------
17 -- Procedure : getResourcesForParty
18 -- Usage : Used for routing purposes by the UWQ / Telephony team
19 -- Description: This procedure takes party_id as input and returns
20 -- a table of resource_ids that have update access to
21 -- the party.
22 -- Parameters :
23 -- p_party_id IN NUMBER Required
24 -- p_resources OUT resource_access_tbl_type
25 --
26 ------------------------------------------------------------------------------
27
28 PROCEDURE getResourcesForParty (
29 p_party_id IN NUMBER,
30 p_resources OUT NOCOPY resource_access_tbl_type);
31
32 ------------------------------------------------------------------------------
33 -- Procedure : getResourcesForSourceCode
34 -- Usage : Used for routing purposes by the UWQ / Telephony team
35 -- Description: This procedure takes source_code as input and returns
36 -- a table of resource_ids that can work on the
37 -- campaign schedule associated with this source code
38 -- Parameters :
39 -- p_source_code IN VARCHAR2 Required
40 -- p_resources OUT resource_access_tbl_type
41 --
42 ------------------------------------------------------------------------------
43
44 PROCEDURE getResourcesForSourceCode (
45 p_source_code IN VARCHAR2,
46 p_resources OUT NOCOPY resource_access_tbl_type);
47
48 ------------------------------------------------------------------------------
49 -- Procedure : getPartyForObject
50 -- Usage : Used for routing purposes by the UWQ / Telephony team
51 -- Description: This procedure takes a type and value as input and
52 -- returns a party_id
53 -- Parameters :
54 -- p_object_type IN VARCHAR2 Required
55 -- p_object_value IN VARCHAR2 Required
56 -- p_party_id OUT NUMBER
57 --
58 ------------------------------------------------------------------------------
59
60 PROCEDURE getPartyForObject (
61 p_object_type IN VARCHAR2,
62 p_object_value IN VARCHAR2,
63 p_party_name OUT NOCOPY VARCHAR2,
64 p_party_id OUT NOCOPY NUMBER);
65
66 -- overloaded procedure for multiple IVR parameters scenarios
67 -- Added for future changes
68 PROCEDURE getPartyForObject (
69 p_object_type IN VARCHAR2,
70 p_object_value IN VARCHAR2,
71 p_object2_type IN OUT NOCOPY VARCHAR2,
72 p_object2_value IN OUT NOCOPY VARCHAR2,
73 p_party_name OUT NOCOPY VARCHAR2,
74 p_party_id OUT NOCOPY NUMBER);
75
76 END AST_ROUTING_PUB;