1 PACKAGE IEM_ENCRYPT_TAGS_PVT AUTHID CURRENT_USER AS
2 /* $Header: iemvencs.pls 120.0 2005/06/02 13:37:51 appldev noship $ */
3 --
4 --
5 -- Purpose: Mantain Encrypted Tags
6 --
7 -- MODIFICATION HISTORY
8 -- Person Date Comments
9 -- Liang Xia 02/25/2002 Created
10 -- Liang Xia 10/24/2002 Added reset_tag API
11 -- Liang Xia 12/05/2002 Fixed GSCC warning: NOCOPY, no G_MISS...
12 -- Liang Xia 07/22/2004 Added duplicate_tags for reuse tag
13 -- --------- ------ ------------------------------------------
14 TYPE email_tag_type IS RECORD (
15 email_tag_key varchar2(256),
16 email_tag_value varchar2(256));
17
18 TYPE email_tag_tbl IS TABLE OF email_tag_type
19 INDEX BY BINARY_INTEGER;
20
21 -- Start of Comments
22 -- API name : create_item
23 -- Type : Private
24 -- Function : This procedure creates record in the table IEM_ENCRYPTED_TAGS table
25 -- Pre-reqs : None.
26 -- Parameters :
27 PROCEDURE create_item (
28 p_api_version_number IN NUMBER,
29 p_init_msg_list IN VARCHAR2 := null,
30 p_commit IN VARCHAR2 := null,
31 p_agent_id IN number,
32 p_interaction_id IN number,
33 p_email_tag_tbl IN email_tag_tbl,
34 x_encripted_id OUT NOCOPY number,
35 x_token OUT NOCOPY VARCHAR2,
36 x_return_status OUT NOCOPY VARCHAR2,
37 x_msg_count OUT NOCOPY NUMBER,
38 x_msg_data OUT NOCOPY VARCHAR2
39 ) ;
40
41 -- Start of Comments
42 -- API name : delete_item_by_msg_id
43 -- Type : Private
44 -- Function : This procedure delete record in the table IEM_ENCRYPTED_TAGS table by msg_id
45 -- Pre-reqs : None.
46 -- Parameters :
47 PROCEDURE delete_item_by_msg_id
48 (p_api_version_number IN NUMBER,
49 P_init_msg_list IN VARCHAR2 := null,
50 p_commit IN VARCHAR2 := null,
51 p_message_id IN NUMBER,
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_msg_count OUT NOCOPY NUMBER,
54 x_msg_data OUT NOCOPY VARCHAR2);
55
56 -- Start of Comments
57 -- API name : update_item_on_mess_id
58 -- Type : Private
59 -- Function : This procedure update record in the table IEM_ENCRYPTED_TAGS table by enrypted_id
60 -- Pre-reqs : None.
61 -- Parameters :
62 PROCEDURE update_item_on_mess_id (
63 p_api_version_number IN NUMBER,
64 p_init_msg_list IN VARCHAR2 := null,
65 p_commit IN VARCHAR2 := null,
66 p_encrypted_id IN NUMBER,
67 p_message_id IN NUMBER,
68 x_return_status OUT NOCOPY VARCHAR2,
69 x_msg_count OUT NOCOPY NUMBER,
70 x_msg_data OUT NOCOPY VARCHAR2
71 );
72
73
74 -- Start of Comments
75 -- API name : create_encrypted_tag_dtls
76 -- Type : Private
77 -- Function : This procedure creates record in the table IEM_ENCRYPTED_TAG_DTLS table
78 -- Pre-reqs : None.
79 -- Parameters :
80 PROCEDURE create_encrypted_tag_dtls (
81 p_api_version_number IN NUMBER,
82 p_init_msg_list IN VARCHAR2 := null,
83 p_commit IN VARCHAR2 := null,
84 p_key IN VARCHAR2,
85 p_val IN VARCHAR2,
86 x_return_status OUT NOCOPY VARCHAR2,
87 x_msg_count OUT NOCOPY NUMBER,
88 x_msg_data OUT NOCOPY VARCHAR2
89 );
90
91 -- Start of Comments
92 -- API name : reset_tag
93 -- Type : Private
94 -- Function : This procedure set message id to NULL in IEM_ENCRYPTED_TAGS table
95 -- for p_message_id. Reset_tag makes the tag re-usable, in case of
96 -- the need of re-process the email.
97 -- Pre-reqs : None.
98 -- Parameters : p_message_id The message_id that need to reset.
99 -- Version : This is shipped in MP-Q ( 115.9 )
100 PROCEDURE reset_tag
101 (p_api_version_number IN NUMBER,
102 P_init_msg_list IN VARCHAR2 := null,
103 p_commit IN VARCHAR2 := null,
104 p_message_id IN NUMBER,
105 x_return_status OUT NOCOPY VARCHAR2,
106 x_msg_count OUT NOCOPY NUMBER,
107 x_msg_data OUT NOCOPY VARCHAR2);
108
109 -- Start of Comments
110 -- API name : duplicate_tags
111 -- Type : Private
112 -- Function : This procedure duplicate record for encypted and stamp with msg_id
113 -- Pre-reqs : None.
114 -- Parameters :
115 PROCEDURE duplicate_tags
116 (p_api_version_number IN NUMBER,
117 P_init_msg_list IN VARCHAR2 := null,
118 p_commit IN VARCHAR2 := null,
119 p_encrypted_id IN NUMBER,
120 p_message_id IN NUMBER,
121 x_return_status OUT NOCOPY VARCHAR2,
122 x_msg_count OUT NOCOPY NUMBER,
123 x_msg_data OUT NOCOPY VARCHAR2);
124
125 END IEM_ENCRYPT_TAGS_PVT;