1 PACKAGE IEM_TAGPROCESS_PUB AUTHID CURRENT_USER AS
2 /* $Header: iemptags.pls 120.0 2005/06/02 14:06:50 appldev noship $ */
3
4 --
5 --
6 -- Purpose: Maintain Tag Process
7 --
8 -- MODIFICATION HISTORY
9 -- Person Date Comments
10 -- Liang Xia 3/24/2002 Created
11 -- Liang Xia 11/18/2002 Modified getEncryptId() to return null
12 -- for Acknowledgement account.
13 -- Liang Xia 12/6/2002 Fixed GSCC warning: NOCOPY, no G_MISS...
14 -- Liang Xia 11/26/2004 115.11 schema compliance change.
15 -- --------- ------ -----------------------------------------
16
17 -- Enter procedure, function bodies as shown below
18
19 /*GLOBAL VARIABLES AVAILABLE TO THE PUBLIC FOR CALLING
20 ===================================================*/
21
22 G_PKG_NAME varchar2(255) :='IEM_TAGPROCESS_PUB';
23
24 TYPE keyVals_rec_type is RECORD (
25 key iem_route_rules.key_type_code%type,
26 value iem_route_rules.value%type,
27 datatype varchar2(1));
28
29 --Table of Key-Values
30 TYPE keyVals_tbl_type is TABLE OF keyVals_rec_type INDEX BY BINARY_INTEGER;
31
32 -- Start of Comments
33 -- API name : getEncryptId
34 -- Type : Public for eMail Center internal use
35 -- Function : This procedure returns encrypted_id,which used in out bound email for tagging process
36 --
37 -- Pre-reqs : None.
38 -- Parameters :
39 PROCEDURE getEncryptId(
40 P_Api_Version_Number IN NUMBER,
41 P_Init_Msg_List IN VARCHAR2 := null,
42 P_Commit IN VARCHAR2 := null,
43 p_email_account_id IN iem_mstemail_accounts.email_account_id%type,
44 p_agent_id IN NUMBER,
45 p_interaction_id IN NUMBER,
46 p_biz_keyVal_tab IN keyVals_tbl_type,
47 x_encrypted_id OUT NOCOPY VARCHAR2,
48 x_msg_count OUT NOCOPY NUMBER,
49 x_return_status OUT NOCOPY VARCHAR2,
50 x_msg_data OUT NOCOPY VARCHAR2);
51
52 -- Start of Comments
53 -- API name : IEM_STAMP_ENCRYPTED_TAG
54 -- Type : private
55 -- Function : This procedure stamp message_id on the encrypted tag
56 --
57 -- Pre-reqs : None.
58 -- Parameters :
59 PROCEDURE IEM_STAMP_ENCRYPTED_TAG(
60 P_Api_Version_Number IN NUMBER,
61 P_Init_Msg_List IN VARCHAR2 := null,
62 P_Commit IN VARCHAR2 := null,
63 p_encrypted_id IN NUMBER,
64 p_message_id IN NUMBER,
65 x_msg_count OUT NOCOPY NUMBER,
66 x_return_status OUT NOCOPY VARCHAR2,
67 x_msg_data OUT NOCOPY VARCHAR2);
68
69 -- Start of Comments
70 -- API name : getTagValues
71 -- Type : Public for eMail Center internal use
72 -- Function : This procedure returns tags in key-val format for a given encrypted_id.
73 -- Necessary security checking is performed before return key-val.
74 -- Pre-reqs : None.
75 -- Parameters :
76 PROCEDURE getTagValues(
77 P_Api_Version_Number IN NUMBER,
78 P_Init_Msg_List IN VARCHAR2 := null,
79 P_Commit IN VARCHAR2 := null,
80 p_encrypted_id IN VARCHAR2,
81 p_message_id IN NUMBER,
82 x_key_value OUT NOCOPY keyVals_tbl_type,
83 x_msg_count OUT NOCOPY NUMBER,
84 x_return_status OUT NOCOPY VARCHAR2,
85 x_msg_data OUT NOCOPY VARCHAR2);
86
87 -- Start of Comments
88 -- API name : getTagValues_on_MsgId
89 -- Type : Public for eMail Center internal use
90 -- Function : This procedure returns tags in key-val format for a given message_id if the message_id was stamped.
91 -- Pre-reqs : None.
92 -- Parameters :
93 PROCEDURE getTagValues_on_MsgId(
94 P_Api_Version_Number IN NUMBER,
95 P_Init_Msg_List IN VARCHAR2 := null,
96 P_Commit IN VARCHAR2 := null,
97 p_message_id IN NUMBER,
98 x_key_value OUT NOCOPY keyVals_tbl_type,
99 x_encrypted_id OUT NOCOPY VARCHAR2,
100 x_msg_count OUT NOCOPY NUMBER,
101 x_return_status OUT NOCOPY VARCHAR2,
102 x_msg_data OUT NOCOPY VARCHAR2);
103
104 -- Start of Comments
105 -- API name : isValidAgent
106 -- Type : Public for eMail Center internal use
107 -- Function : This function valids a eMail Center Agent. Used in auto-route email to the agent who sent the message.
108 -- Validation based on: 1. Agent account association. 2. Assigned 'ICENTER' role. 3.Assigned a group.
109 -- Pre-reqs : None.
110 -- Parameters :
111 function isValidAgent( p_agent_id number, p_email_acct_id number)
112 return boolean;
113
114 END;