1 PACKAGE OKC_REVIEW_UPLD_TERMS_PVT AS
2 /* $Header: OKCVRUTS.pls 120.4 2006/04/12 18:01 vnanjang noship $ */
3
4 ---------------------------------------------------------------------------
5 -- Procedures and Functions
6 ---------------------------------------------------------------------------
7
8 PROCEDURE insert_row(
9 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10 x_return_status OUT NOCOPY VARCHAR2,
11
12 p_REVIEW_UPLD_TERMS_id IN NUMBER,
13 p_document_id IN NUMBER,
14 p_document_type IN VARCHAR2,
15 p_object_id IN NUMBER,
16 p_object_type IN VARCHAR2,
17 p_object_title IN CLOB,
18 p_object_text IN CLOB,
19 p_parent_object_type IN VARCHAR2,
20 p_parent_id IN NUMBER,
21 p_article_id IN NUMBER,
22 p_article_version_id IN NUMBER,
23 p_label IN VARCHAR2,
24 p_display_seq IN NUMBER,
25 p_action IN VARCHAR2,
26 p_error_message_count IN NUMBER,
27 p_warning_message_count IN NUMBER,
28 p_new_parent_id IN NUMBER,
29 p_upload_level IN NUMBER,
30
31 x_REVIEW_UPLD_TERMS_id OUT NOCOPY NUMBER
32 );
33
34 PROCEDURE lock_row(
35 x_return_status OUT NOCOPY VARCHAR2,
36
37 p_REVIEW_UPLD_TERMS_id IN NUMBER,
38
39 p_object_version_number IN NUMBER
40 );
41
42 PROCEDURE update_row(
43 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
44 x_return_status OUT NOCOPY VARCHAR2,
45
46 p_REVIEW_UPLD_TERMS_id IN NUMBER,
47
48 p_document_id IN NUMBER := NULL,
49 p_document_type IN VARCHAR2 := NULL,
50 p_object_id IN NUMBER := NULL,
51 p_object_type IN VARCHAR2 := NULL,
52 p_object_title IN CLOB := NULL,
53 p_object_text IN CLOB := NULL,
54 p_parent_object_type IN VARCHAR2 := NULL,
55 p_parent_id IN NUMBER := NULL,
56 p_article_id IN NUMBER := NULL,
57 p_article_version_id IN NUMBER := NULL,
58 p_label IN VARCHAR2 := NULL,
59 p_display_seq IN NUMBER := NULL,
60 p_action IN VARCHAR2 := NULL,
61 p_error_message_count IN NUMBER := NULL,
62 p_warning_message_count IN NUMBER := NULL,
63 p_new_parent_id IN NUMBER := NULL,
64 p_upload_level IN NUMBER := NULL,
65 p_object_version_number IN NUMBER
66 );
67
68 PROCEDURE delete_row(
69 x_return_status OUT NOCOPY VARCHAR2,
70
71 p_REVIEW_UPLD_TERMS_id IN NUMBER,
72
73 p_object_version_number IN NUMBER
74 );
75
76 PROCEDURE validate_row(
77 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
78 x_return_status OUT NOCOPY VARCHAR2,
79
80 p_REVIEW_UPLD_TERMS_id IN NUMBER,
81 p_document_id IN NUMBER,
82 p_document_type IN VARCHAR2,
83 p_object_id IN NUMBER,
84 p_object_type IN VARCHAR2,
85 p_object_title IN CLOB,
86 p_object_text IN CLOB,
87 p_parent_object_type IN VARCHAR2,
88 p_parent_id IN NUMBER,
89 p_article_id IN NUMBER,
90 p_article_version_id IN NUMBER,
91 p_label IN VARCHAR2,
92 p_display_seq IN NUMBER,
93 p_action IN VARCHAR2,
94 p_error_message_count IN NUMBER,
95 p_warning_message_count IN NUMBER,
96 p_new_parent_id IN NUMBER,
97 p_upload_level IN NUMBER,
98
99 p_object_version_number IN NUMBER
100 );
101
102 FUNCTION get_rec (
103 p_REVIEW_UPLD_TERMS_id IN NUMBER,
104
105 x_document_id OUT NOCOPY NUMBER,
106 x_document_type OUT NOCOPY VARCHAR2,
107 x_object_id OUT NOCOPY NUMBER,
108 x_object_type OUT NOCOPY VARCHAR2,
109 x_object_title OUT NOCOPY CLOB,
110 x_object_text OUT NOCOPY CLOB,
111 x_parent_object_type OUT NOCOPY VARCHAR2,
112 x_parent_id OUT NOCOPY NUMBER,
113 x_article_id OUT NOCOPY NUMBER,
114 x_article_version_id OUT NOCOPY NUMBER,
115 x_label OUT NOCOPY VARCHAR2,
116 x_display_seq OUT NOCOPY NUMBER,
117 x_action OUT NOCOPY VARCHAR2,
118 x_error_message_count OUT NOCOPY NUMBER,
119 x_warning_message_count OUT NOCOPY NUMBER,
120 x_object_version_number OUT NOCOPY NUMBER,
121 x_new_parent_id OUT NOCOPY NUMBER,
122 x_upload_level OUT NOCOPY NUMBER,
123 x_created_by OUT NOCOPY NUMBER,
124 x_creation_date OUT NOCOPY DATE,
125 x_last_updated_by OUT NOCOPY NUMBER,
126 x_last_update_login OUT NOCOPY NUMBER,
127 x_last_update_date OUT NOCOPY DATE
128
129 ) RETURN VARCHAR2;
130
131
132 PROCEDURE Accept_Changes (
133 p_api_version IN NUMBER,
134 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
135 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
136 p_commit IN VARCHAR2 := FND_API.G_FALSE,
137 p_mode IN VARCHAR2 := 'NORMAL', --other value 'AMEND',
138
139 p_document_type IN VARCHAR2,
140 p_document_id IN NUMBER,
141 p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,
142 p_validation_string IN VARCHAR2 := NULL,
143
144 x_return_status OUT NOCOPY VARCHAR2,
145 x_msg_data OUT NOCOPY VARCHAR2,
146 x_msg_count OUT NOCOPY NUMBER
147 );
148
149 PROCEDURE Reject_Changes (
150 p_api_version IN NUMBER,
151 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
152 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
153 p_commit IN VARCHAR2 := FND_API.G_FALSE,
154
155 p_document_type IN VARCHAR2,
156 p_document_id IN NUMBER,
157
158 x_return_status OUT NOCOPY VARCHAR2,
159 x_msg_data OUT NOCOPY VARCHAR2,
160 x_msg_count OUT NOCOPY NUMBER
161 );
162
163 PROCEDURE Delete_uploaded_terms (
164 p_api_version IN NUMBER,
165 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
166 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
167 p_commit IN VARCHAR2 := FND_API.G_FALSE,
168
169 p_document_type IN VARCHAR2,
170 p_document_id IN NUMBER,
171
172 x_return_status OUT NOCOPY VARCHAR2,
173 x_msg_data OUT NOCOPY VARCHAR2,
174 x_msg_count OUT NOCOPY NUMBER
175 );
176
177 PROCEDURE Sync_Review_Tables (
178 p_api_version IN NUMBER,
179 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
180 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
181 p_commit IN VARCHAR2 := FND_API.G_FALSE,
182 p_validation_string IN VARCHAR2 := NULL,
183 p_document_type IN VARCHAR2,
184 p_document_id IN NUMBER,
185
186 x_return_status OUT NOCOPY VARCHAR2,
187 x_msg_data OUT NOCOPY VARCHAR2,
188 x_msg_count OUT NOCOPY NUMBER
189 );
190
191 /*
192 -- PROCEDURE Create_Unassigned_Section
193 -- creating un-assigned sections in a document
194 */
195 PROCEDURE Create_Unassigned_Section (
196 p_api_version IN NUMBER,
197 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
198 p_commit IN VARCHAR2 := FND_API.G_FALSE,
199
200 x_return_status OUT NOCOPY VARCHAR2,
201 x_msg_data OUT NOCOPY VARCHAR2,
202 x_msg_count OUT NOCOPY NUMBER,
203
204 p_document_type IN VARCHAR2,
205 p_document_id IN NUMBER,
206 p_new_parent_id IN NUMBER,
207 x_scn_id OUT NOCOPY NUMBER );
208
209
210 END OKC_REVIEW_UPLD_TERMS_PVT;