1 PACKAGE OKC_TERMS_SECTIONS_PVT AS
2 /* $Header: OKCVSCNS.pls 120.0 2005/05/25 18:15:48 appldev 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 p_id IN NUMBER,
12 p_section_sequence IN NUMBER,
13 p_label IN VARCHAR2,
14 p_scn_id IN NUMBER,
15 p_heading IN VARCHAR2,
16 p_description IN VARCHAR2,
17 p_document_type IN VARCHAR2,
18 p_document_id IN NUMBER,
19 p_scn_code IN VARCHAR2,
20 p_amendment_description IN VARCHAR2,
21 p_amendment_operation_code IN VARCHAR2,
22 p_orig_system_reference_code IN VARCHAR2,
23 p_orig_system_reference_id1 IN NUMBER,
24 p_orig_system_reference_id2 IN NUMBER,
25 p_print_yn IN VARCHAR2 := 'N',
26 p_attribute_category IN VARCHAR2 := NULL,
27 p_attribute1 IN VARCHAR2 := NULL,
28 p_attribute2 IN VARCHAR2 := NULL,
29 p_attribute3 IN VARCHAR2 := NULL,
30 p_attribute4 IN VARCHAR2 := NULL,
31 p_attribute5 IN VARCHAR2 := NULL,
32 p_attribute6 IN VARCHAR2 := NULL,
33 p_attribute7 IN VARCHAR2 := NULL,
34 p_attribute8 IN VARCHAR2 := NULL,
35 p_attribute9 IN VARCHAR2 := NULL,
36 p_attribute10 IN VARCHAR2 := NULL,
37 p_attribute11 IN VARCHAR2 := NULL,
38 p_attribute12 IN VARCHAR2 := NULL,
39 p_attribute13 IN VARCHAR2 := NULL,
40 p_attribute14 IN VARCHAR2 := NULL,
41 p_attribute15 IN VARCHAR2 := NULL,
42 p_summary_amend_operation_code IN VARCHAR2 := NULL,
43
44 x_id OUT NOCOPY NUMBER
45 );
46
47 PROCEDURE lock_row(
48 x_return_status OUT NOCOPY VARCHAR2,
49
50 p_id IN NUMBER,
51
52 p_object_version_number IN NUMBER
53 );
54
55 PROCEDURE update_row(
56 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
57 x_return_status OUT NOCOPY VARCHAR2,
58 p_id IN NUMBER,
59 p_section_sequence IN NUMBER := NULL,
60 p_label IN VARCHAR2 := NULL,
61 p_scn_id IN NUMBER := NULL,
62 p_heading IN VARCHAR2 := NULL,
63 p_description IN VARCHAR2 := NULL,
64 p_document_type IN VARCHAR2 := NULL,
65 p_document_id IN NUMBER := NULL,
66 p_scn_code IN VARCHAR2 := NULL,
67 p_amendment_description IN VARCHAR2 := NULL,
68 p_amendment_operation_code IN VARCHAR2 := NULL,
69 p_orig_system_reference_code IN VARCHAR2 := NULL,
70 p_orig_system_reference_id1 IN NUMBER := NULL,
71 p_orig_system_reference_id2 IN NUMBER := NULL,
72 p_print_yn IN VARCHAR2 := 'N',
73 p_attribute_category IN VARCHAR2 := NULL,
74 p_attribute1 IN VARCHAR2 := NULL,
75 p_attribute2 IN VARCHAR2 := NULL,
76 p_attribute3 IN VARCHAR2 := NULL,
77 p_attribute4 IN VARCHAR2 := NULL,
78 p_attribute5 IN VARCHAR2 := NULL,
79 p_attribute6 IN VARCHAR2 := NULL,
80 p_attribute7 IN VARCHAR2 := NULL,
81 p_attribute8 IN VARCHAR2 := NULL,
82 p_attribute9 IN VARCHAR2 := NULL,
83 p_attribute10 IN VARCHAR2 := NULL,
84 p_attribute11 IN VARCHAR2 := NULL,
85 p_attribute12 IN VARCHAR2 := NULL,
86 p_attribute13 IN VARCHAR2 := NULL,
87 p_attribute14 IN VARCHAR2 := NULL,
88 p_attribute15 IN VARCHAR2 := NULL,
89 p_summary_amend_operation_code IN VARCHAR2 := NULL,
90 p_last_amended_by IN NUMBER := NULL,
91 p_last_amendment_date IN DATE := NULL,
92 p_object_version_number IN NUMBER
93 );
94
95 PROCEDURE delete_row(
96 x_return_status OUT NOCOPY VARCHAR2,
97 p_id IN NUMBER,
98 p_object_version_number IN NUMBER
99 );
100
101 PROCEDURE delete_set(
102 x_return_status OUT NOCOPY VARCHAR2,
103 p_doc_type IN VARCHAR2,
104 p_doc_id IN NUMBER
105 );
106
107 PROCEDURE validate_row(
108 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
109 x_return_status OUT NOCOPY VARCHAR2,
110 p_id IN NUMBER,
111 p_section_sequence IN NUMBER,
112 p_label IN VARCHAR2,
113 p_scn_id IN NUMBER,
114 p_heading IN VARCHAR2,
115 p_description IN VARCHAR2,
116 p_document_type IN VARCHAR2,
117 p_document_id IN NUMBER,
118 p_scn_code IN VARCHAR2,
119 p_amendment_description IN VARCHAR2,
120 p_amendment_operation_code IN VARCHAR2,
121 p_orig_system_reference_code IN VARCHAR2,
122 p_orig_system_reference_id1 IN NUMBER,
123 p_orig_system_reference_id2 IN NUMBER,
124 p_print_yn IN VARCHAR2 :='N',
125 p_attribute_category IN VARCHAR2 := NULL,
126 p_attribute1 IN VARCHAR2 := NULL,
127 p_attribute2 IN VARCHAR2 := NULL,
128 p_attribute3 IN VARCHAR2 := NULL,
129 p_attribute4 IN VARCHAR2 := NULL,
130 p_attribute5 IN VARCHAR2 := NULL,
131 p_attribute6 IN VARCHAR2 := NULL,
132 p_attribute7 IN VARCHAR2 := NULL,
133 p_attribute8 IN VARCHAR2 := NULL,
134 p_attribute9 IN VARCHAR2 := NULL,
135 p_attribute10 IN VARCHAR2 := NULL,
136 p_attribute11 IN VARCHAR2 := NULL,
137 p_attribute12 IN VARCHAR2 := NULL,
138 p_attribute13 IN VARCHAR2 := NULL,
139 p_attribute14 IN VARCHAR2 := NULL,
140 p_attribute15 IN VARCHAR2 := NULL,
141 p_summary_amend_operation_code IN VARCHAR2 := NULL,
142 p_object_version_number IN NUMBER
143 );
144
145 FUNCTION get_rec (
146 p_id IN NUMBER,
147 x_section_sequence OUT NOCOPY NUMBER,
148 x_label OUT NOCOPY VARCHAR2,
149 x_scn_id OUT NOCOPY NUMBER,
150 x_heading OUT NOCOPY VARCHAR2,
151 x_description OUT NOCOPY VARCHAR2,
152 x_document_type OUT NOCOPY VARCHAR2,
153 x_document_id OUT NOCOPY NUMBER,
154 x_scn_code OUT NOCOPY VARCHAR2,
155 x_amendment_description OUT NOCOPY VARCHAR2,
156 x_amendment_operation_code OUT NOCOPY VARCHAR2,
157 x_orig_system_reference_code OUT NOCOPY VARCHAR2,
158 x_orig_system_reference_id1 OUT NOCOPY NUMBER,
159 x_orig_system_reference_id2 OUT NOCOPY NUMBER,
160 x_print_yn OUT NOCOPY VARCHAR2,
161 x_attribute_category OUT NOCOPY VARCHAR2,
162 x_attribute1 OUT NOCOPY VARCHAR2,
163 x_attribute2 OUT NOCOPY VARCHAR2,
164 x_attribute3 OUT NOCOPY VARCHAR2,
165 x_attribute4 OUT NOCOPY VARCHAR2,
166 x_attribute5 OUT NOCOPY VARCHAR2,
167 x_attribute6 OUT NOCOPY VARCHAR2,
168 x_attribute7 OUT NOCOPY VARCHAR2,
169 x_attribute8 OUT NOCOPY VARCHAR2,
170 x_attribute9 OUT NOCOPY VARCHAR2,
171 x_attribute10 OUT NOCOPY VARCHAR2,
172 x_attribute11 OUT NOCOPY VARCHAR2,
173 x_attribute12 OUT NOCOPY VARCHAR2,
174 x_attribute13 OUT NOCOPY VARCHAR2,
175 x_attribute14 OUT NOCOPY VARCHAR2,
176 x_attribute15 OUT NOCOPY VARCHAR2,
177 x_summary_amend_operation_code OUT NOCOPY VARCHAR2,
178 x_object_version_number OUT NOCOPY NUMBER,
179 x_created_by OUT NOCOPY NUMBER,
180 x_creation_date OUT NOCOPY DATE,
181 x_last_updated_by OUT NOCOPY NUMBER,
182 x_last_update_login OUT NOCOPY NUMBER,
183 x_last_update_date OUT NOCOPY DATE,
184 x_last_amended_by OUT NOCOPY NUMBER,
185 x_last_amendment_date OUT NOCOPY DATE
186
187 ) RETURN VARCHAR2;
188
189
190 --This Function is called from Versioning API OKC_VERSION_PVT
191 FUNCTION Create_Version(
192 p_doc_type IN VARCHAR2,
193 p_doc_id IN NUMBER,
194 p_major_version IN NUMBER
195 ) RETURN VARCHAR2;
196
197 --This Function is called from Versioning API OKC_VERSION_PVT
198 FUNCTION Restore_Version(
199 p_doc_type IN VARCHAR2,
200 p_doc_id IN NUMBER,
201 p_major_version NUMBER
202 ) RETURN VARCHAR2;
203
204 --This Function is called from Versioning API OKC_VERSION_PVT
205 -- to delete sections for specified version of document
206
207 FUNCTION Delete_Version(
208 p_doc_type IN VARCHAR2,
209 p_doc_id IN NUMBER,
210 p_major_version IN NUMBER
211 ) RETURN VARCHAR2;
212
213 END OKC_TERMS_SECTIONS_PVT;