[Home] [Help]
PACKAGE: APPS.IEM_KB_RESULTS_PVT
Source
1 PACKAGE IEM_KB_RESULTS_PVT AUTHID CURRENT_USER as
2 /* $Header: iemvkbrs.pls 115.4 2002/12/03 22:39:52 sboorela shipped $ */
3
4 -- Start of Comments
5 -- API name : create_item
6 -- Type : Private
7 -- Function : This procedure create a record in the table IEM_KB_RESULTS
8 -- Pre-reqs : None.
9 -- Parameters :
10 -- IN
11 -- p_api_version_number IN NUMBER Required
12 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
13 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
14 -- p_db_link IN VARCHAR2,
15 -- p_db_username IN VARCHAR2,
16 -- p_db_password IN VARCHAR2,
17 -- p_db_server_id IN NUMBER,
18 -- p_is_admin IN VARCHAR2,
19 -- p_conn_desc IN VARCHAR2:=FND_API.G_MISS_CHAR,
20 --
21 -- OUT
22 -- x_return_status OUT VARCHAR2
23 -- x_msg_count OUT NUMBER
24 -- x_msg_data OUT VARCHAR2
25 --
26 -- Version : 1.0
27 -- Notes :
28 --
29 -- End of comments
30 -- **********************************************************
31
32 PROCEDURE create_item (p_api_version_number IN NUMBER,
33 p_init_msg_list IN VARCHAR2 ,
34 p_commit IN VARCHAR2 ,
35 p_message_id IN NUMBER,
36 p_classification_id IN NUMBER,
37 p_email_account_id IN NUMBER,
38 p_document_id IN VARCHAR2,
39 p_kb_repository_name IN VARCHAR2,
40 p_kb_category_name IN VARCHAR2,
41 p_document_title IN VARCHAR2,
42 p_doc_last_modified_date IN DATE,
43 p_score IN VARCHAR2,
44 p_url IN VARCHAR2,
45 p_kb_delete IN VARCHAR2,
46 p_CREATED_BY NUMBER,
47 p_CREATION_DATE DATE,
48 p_LAST_UPDATED_BY NUMBER,
49 p_LAST_UPDATE_DATE DATE,
50 p_LAST_UPDATE_LOGIN NUMBER,
51 p_ATTRIBUTE1 VARCHAR2,
52 p_ATTRIBUTE2 VARCHAR2,
53 p_ATTRIBUTE3 VARCHAR2,
54 p_ATTRIBUTE4 VARCHAR2,
55 p_ATTRIBUTE5 VARCHAR2,
56 p_ATTRIBUTE6 VARCHAR2,
57 p_ATTRIBUTE7 VARCHAR2,
58 p_ATTRIBUTE8 VARCHAR2,
59 p_ATTRIBUTE9 VARCHAR2,
60 p_ATTRIBUTE10 VARCHAR2,
61 p_ATTRIBUTE11 VARCHAR2,
62 p_ATTRIBUTE12 VARCHAR2,
63 p_ATTRIBUTE13 VARCHAR2,
64 p_ATTRIBUTE14 VARCHAR2,
65 p_ATTRIBUTE15 VARCHAR2,
66 x_return_status OUT NOCOPY VARCHAR2,
67 x_msg_count OUT NOCOPY NUMBER,
68 x_msg_data OUT NOCOPY VARCHAR2
69 );
70
71 -- Start of Comments
72 -- API name : delete_item
73 -- Type : Private
74 -- Function : This procedure delete all the recor for which delete flag
75 -- is set to 'Y'
76 -- Pre-reqs : None.
77 -- Parameters :
78 -- IN
79 -- p_api_version_number IN NUMBER Required
80 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
81 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
82 -- p_db_conn_id in number:=null,
83 -- p_db_username IN VARCHAR2 :=null,
84 -- p_db_server_id IN NUMBER:=null,
85
86 -- OUT
87 -- x_return_status OUT VARCHAR2
88 -- x_msg_count OUT NUMBER
89 -- x_msg_data OUT VARCHAR2
90 --
91 -- Version : 1.0
92 -- Notes :
93 --
94 -- End of comments
95 -- **********************************************************
96
97 PROCEDURE delete_item (p_api_version_number IN NUMBER,
98 p_init_msg_list IN VARCHAR2 ,
99 p_commit IN VARCHAR2 ,
100 x_return_status OUT NOCOPY VARCHAR2,
101 x_msg_count OUT NOCOPY NUMBER,
102 x_msg_data OUT NOCOPY VARCHAR2
103 );
104 -- Start of Comments
105 -- API name : update_item
106 -- Type : Private
107 -- Function : This procedure update only the delete flag to 'Y'
108 -- Pre-reqs : None.
109 -- Parameters :
110 -- IN
111 -- p_api_version_number IN NUMBER Required
112 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
113 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
114 -- p_db_conn_id IN NUMBER:=NULL,
115 -- p_db_link IN VARCHAR2:=NULL,
116 -- p_db_username IN VARCHAR2:=NULL,
117 -- p_db_password IN VARCHAR2:=NULL,
118 -- p_db_server_id IN NUMBER:=NULL,
119 -- p_is_admin IN VARCHAR2:=NULL,
120 -- p_conn_desc IN VARCHAR2:=NULL,
121 --
122 -- OUT
123 -- x_return_status OUT VARCHAR2
124 -- x_msg_count OUT NUMBER
125 -- x_msg_data OUT VARCHAR2
126 --
127 -- Version : 1.0
128 -- Notes :
129 --
130 -- End of comments
131 -- **********************************************************
132
133 PROCEDURE update_item (p_api_version_number IN NUMBER,
134 p_init_msg_list IN VARCHAR2 ,
135 p_commit IN VARCHAR2 ,
136 p_kb_result_id IN NUMBER,
137 p_kb_delete IN VARCHAR2,
138 p_CREATED_BY NUMBER,
139 p_CREATION_DATE DATE,
140 p_LAST_UPDATED_BY NUMBER,
141 p_LAST_UPDATE_DATE DATE,
142 p_LAST_UPDATE_LOGIN NUMBER,
143 p_ATTRIBUTE1 VARCHAR2,
144 p_ATTRIBUTE2 VARCHAR2,
145 p_ATTRIBUTE3 VARCHAR2,
146 p_ATTRIBUTE4 VARCHAR2,
147 p_ATTRIBUTE5 VARCHAR2,
148 p_ATTRIBUTE6 VARCHAR2,
149 p_ATTRIBUTE7 VARCHAR2,
150 p_ATTRIBUTE8 VARCHAR2,
151 p_ATTRIBUTE9 VARCHAR2,
152 p_ATTRIBUTE10 VARCHAR2,
153 p_ATTRIBUTE11 VARCHAR2,
154 p_ATTRIBUTE12 VARCHAR2,
155 p_ATTRIBUTE13 VARCHAR2,
156 p_ATTRIBUTE14 VARCHAR2,
157 p_ATTRIBUTE15 VARCHAR2,
158 x_return_status OUT NOCOPY VARCHAR2,
159 x_msg_count OUT NOCOPY NUMBER,
160 x_msg_data OUT NOCOPY VARCHAR2
161 );
162 END IEM_KB_RESULTS_PVT;