1 PACKAGE IEM_TAG_KEY_PVT AUTHID CURRENT_USER AS
2 /* $Header: iemvtags.pls 120.0 2005/06/02 14:00:41 appldev noship $ */
3 --
4 --
5 -- Purpose: Mantain email tag related operations
6 --
7 -- MODIFICATION HISTORY
8 -- Person Date Comments
9 -- Liang Xia 3/20/2002 Created
10 -- Liang Xia 5/14/2002 added more validation on Key ID
11 -- Liang Xia 12/05/2002 Fixed plsql GSCC warning: NOCOPY, No G_MISS..
12 -- Liang Xia 12/04/2004 changed to iem_mstemail_accounts for 115.11 schema compliance
13 -- --------- ------ ------------------------------------------
14 TYPE key_tbl_type IS table of VARCHAR(100) INDEX BY BINARY_INTEGER;
15
16 -- Start of Comments
17 -- API name : create_item_tag
18 -- Type : Private
19 -- Function : This procedure creates record in the table IEM_TAG_KEYS table
20 -- Pre-reqs : None.
21 -- Parameters :
22 PROCEDURE create_item_tag (
23 p_api_version_number IN NUMBER,
24 p_init_msg_list IN VARCHAR2 := null,
25 p_commit IN VARCHAR2 := null,
26 p_key_id IN VARCHAR2,
27 p_key_name IN VARCHAR2,
28 p_type_type_code IN VARCHAR2,
29 p_value IN VARCHAR2,
30 x_return_status OUT NOCOPY VARCHAR2,
31 x_msg_count OUT NOCOPY NUMBER,
32 x_msg_data OUT NOCOPY VARCHAR2
33 ) ;
34
35 -- Start of Comments
36 -- API name : create_item_account_tags
37 -- Type : Private
38 -- Function : This procedure creates record in the table IEM_ACCT_TAG_KEYS table
39 -- Pre-reqs : None.
40 -- Parameters :
41 PROCEDURE create_item_account_tags (
42 p_api_version_number IN NUMBER,
43 p_init_msg_list IN VARCHAR2 := null,
44 p_commit IN VARCHAR2 := null,
45 p_email_account_id IN NUMBER,
46 p_tag_key_id IN NUMBER,
47 x_return_status OUT NOCOPY VARCHAR2,
48 x_msg_count OUT NOCOPY NUMBER,
49 x_msg_data OUT NOCOPY VARCHAR2
50 );
51
52 -- Start of Comments
53 -- API name : delete_item_batch
54 -- Type : Private
55 -- Function : This procedure delete batch of records in the table IEM_TAG_KEYS table
56 -- Pre-reqs : None.
57 -- Parameters :
58 PROCEDURE delete_item_batch
59 (p_api_version_number IN NUMBER,
60 P_init_msg_list IN VARCHAR2 := null,
61 p_commit IN VARCHAR2 := null,
62 p_tagKey_ids_tbl IN jtf_varchar2_Table_100,
63 x_return_status OUT NOCOPY VARCHAR2,
64 x_msg_count OUT NOCOPY NUMBER,
65 x_msg_data OUT NOCOPY VARCHAR2);
66
67 -- Start of Comments
68 -- API name : update_item_tag_key
69 -- Type : Private
70 -- Function : This procedure update records in the table IEM_TAG_KEYS table
71 -- Pre-reqs : None.
72 -- Parameters :
73 PROCEDURE update_item_tag_key (
74 p_api_version_number IN NUMBER,
75 p_init_msg_list IN VARCHAR2 := null,
76 p_commit IN VARCHAR2 := null,
77 p_tag_key_id IN NUMBER,
78 p_key_id IN VARCHAR2:= null,
79 p_key_name IN VARCHAR2:= null,
80 p_type_type_code IN VARCHAR2:= null,
81 p_value IN VARCHAR2:= null,
82 x_return_status OUT NOCOPY VARCHAR2,
83 x_msg_count OUT NOCOPY NUMBER,
84 x_msg_data OUT NOCOPY VARCHAR2
85 );
86
87 -- Start of Comments
88 -- API name : update_acct_tag_wrap
89 -- Type : Private
90 -- Function : This procedure update records in the table IEM_ACCT_TAG_KEYS table
91 -- Pre-reqs : None.
92 -- Parameters :
93 PROCEDURE update_acct_tag_wrap (p_api_version_number IN NUMBER,
94 p_init_msg_list IN VARCHAR2 := null,
95 p_commit IN VARCHAR2 := null,
96 p_account_id IN NUMBER,
97 p_in_key_id IN VARCHAR2:= null,
98 p_out_key_id IN VARCHAR2 := null,
99 x_return_status OUT NOCOPY VARCHAR2,
100 x_msg_count OUT NOCOPY NUMBER,
101 x_msg_data OUT NOCOPY VARCHAR2 );
102
103 -- Start of Comments
104 -- API name : delete_acct_tag_on_acct_ID
105 -- Type : Private
106 -- Function : This procedure delete records in the table IEM_ACCT_TAG_KEYS table based on email_account_id
107 -- Pre-reqs : None.
108 -- Parameters :
109 PROCEDURE delete_acct_tag_on_acct_ID
110 (p_api_version_number IN NUMBER,
111 P_init_msg_list IN VARCHAR2 := null,
112 p_commit IN VARCHAR2 := null,
113 p_email_acct_id IN iem_mstemail_accounts.email_account_id%type,
114 x_return_status OUT NOCOPY VARCHAR2,
115 x_msg_count OUT NOCOPY NUMBER,
116 x_msg_data OUT NOCOPY VARCHAR2);
117
118 FUNCTION varChar_to_table ( inString IN VARCHAR2 )
119 return key_tbl_type;
120
121 END IEM_TAG_KEY_PVT;