DBA Data[Home] [Help]

PACKAGE: APPS.IEM_TAGPROCESS_PUB

Source


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;