[Home] [Help]
PACKAGE: APPS.OKC_TERMS_TEMPLATES_PVT
Source
1 PACKAGE OKC_TERMS_TEMPLATES_PVT AS
2 /* $Header: OKCVTERMTMPLS.pls 120.1 2005/06/07 04:05:09 appldev $ */
3
4 ---------------------------------------------------------------------------
5 -- Record Types
6 ---------------------------------------------------------------------------
7
8 TYPE template_rec_type IS RECORD (
9 template_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_ID%TYPE,
10 template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE,
11 intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE,
12 status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE,
13 start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE,
14 end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE,
15 instruction_text OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE,
16 description OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE,
17 working_copy_flag OKC_TERMS_TEMPLATES_ALL.WORKING_COPY_FLAG%TYPE,
18 parent_template_id OKC_TERMS_TEMPLATES_ALL.PARENT_TEMPLATE_ID%TYPE,
19 print_Template_Id OKC_TERMS_TEMPLATES_ALL.print_Template_Id%TYPE,
20 global_flag OKC_TERMS_TEMPLATES_ALL.global_flag%TYPE,
21 contract_expert_enabled OKC_TERMS_TEMPLATES_ALL.contract_expert_enabled%TYPE,
22 tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.tmpl_numbering_scheme%TYPE,
23 xprt_clause_mandatory_flag OKC_TERMS_TEMPLATES_ALL.xprt_clause_mandatory_flag%TYPE,
24 xprt_scn_code OKC_TERMS_TEMPLATES_ALL.xprt_scn_code%TYPE,
25 template_model_id OKC_TERMS_TEMPLATES_ALL.template_model_id%TYPE,
26 approval_wf_key OKC_TERMS_TEMPLATES_ALL.approval_wf_key%TYPE,
27 cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.cz_export_wf_key%TYPE,
28 orig_system_reference_code OKC_TERMS_TEMPLATES_ALL.orig_system_reference_code%TYPE,
29 orig_system_reference_id1 OKC_TERMS_TEMPLATES_ALL.orig_system_reference_id1%TYPE,
30 orig_system_reference_id2 OKC_TERMS_TEMPLATES_ALL.orig_system_reference_id2%TYPE,
31 org_id OKC_TERMS_TEMPLATES_ALL.org_id%TYPE,
32 attribute_category OKC_TERMS_TEMPLATES_ALL.attribute_category%TYPE,
33 attribute1 OKC_TERMS_TEMPLATES_ALL.attribute1%TYPE,
34 attribute2 OKC_TERMS_TEMPLATES_ALL.attribute2%TYPE,
35 attribute3 OKC_TERMS_TEMPLATES_ALL.attribute3%TYPE,
36 attribute4 OKC_TERMS_TEMPLATES_ALL.attribute4%TYPE,
37 attribute5 OKC_TERMS_TEMPLATES_ALL.attribute5%TYPE,
38 attribute6 OKC_TERMS_TEMPLATES_ALL.attribute6%TYPE,
39 attribute7 OKC_TERMS_TEMPLATES_ALL.attribute7%TYPE,
40 attribute8 OKC_TERMS_TEMPLATES_ALL.attribute8%TYPE,
41 attribute9 OKC_TERMS_TEMPLATES_ALL.attribute9%TYPE,
42 attribute10 OKC_TERMS_TEMPLATES_ALL.attribute10%TYPE,
43 attribute11 OKC_TERMS_TEMPLATES_ALL.attribute11%TYPE,
44 attribute12 OKC_TERMS_TEMPLATES_ALL.attribute12%TYPE,
45 attribute13 OKC_TERMS_TEMPLATES_ALL.attribute13%TYPE,
46 attribute14 OKC_TERMS_TEMPLATES_ALL.attribute14%TYPE,
47 attribute15 OKC_TERMS_TEMPLATES_ALL.attribute15%TYPE,
48 translated_from_tmpl_id OKC_TERMS_TEMPLATES_ALL.translated_from_tmpl_id%TYPE,
49 language OKC_TERMS_TEMPLATES_ALL.language%TYPE);
50 ---------------------------------------------------------------------------
51 -- Procedures and Functions
52 ---------------------------------------------------------------------------
53
54 PROCEDURE insert_row(
55 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
56 x_return_status OUT NOCOPY VARCHAR2,
57
58 p_template_name IN VARCHAR2,
59 p_template_id IN NUMBER,
60 p_working_copy_flag IN VARCHAR2,
61 p_intent IN VARCHAR2,
62 p_status_code IN VARCHAR2,
63 p_start_date IN DATE,
64 p_end_date IN DATE,
65 p_global_flag IN VARCHAR2,
66 p_parent_template_id IN NUMBER,
67 p_print_template_id IN NUMBER,
68 p_contract_expert_enabled IN VARCHAR2,
69 p_xprt_clause_mandatory_flag IN VARCHAR2 := NULL, -- Added for 11.5.10+: Contract Expert Changes
70 p_xprt_scn_code IN VARCHAR2 := NULL, -- Added for 11.5.10: Contract Expert Changes
71 p_template_model_id IN NUMBER,
72 p_instruction_text IN VARCHAR2,
73 p_tmpl_numbering_scheme IN NUMBER,
74 p_description IN VARCHAR2,
75 p_approval_wf_key IN VARCHAR2 := NULL,
76 p_cz_export_wf_key IN VARCHAR2 := NULL,
77 p_orig_system_reference_code IN VARCHAR2 := NULL,
78 p_orig_system_reference_id1 IN NUMBER := NULL,
79 p_orig_system_reference_id2 IN NUMBER := NULL,
80 p_org_id IN NUMBER,
81
82 p_attribute_category IN VARCHAR2 := NULL,
83 p_attribute1 IN VARCHAR2 := NULL,
84 p_attribute2 IN VARCHAR2 := NULL,
85 p_attribute3 IN VARCHAR2 := NULL,
86 p_attribute4 IN VARCHAR2 := NULL,
87 p_attribute5 IN VARCHAR2 := NULL,
88 p_attribute6 IN VARCHAR2 := NULL,
89 p_attribute7 IN VARCHAR2 := NULL,
90 p_attribute8 IN VARCHAR2 := NULL,
91 p_attribute9 IN VARCHAR2 := NULL,
92 p_attribute10 IN VARCHAR2 := NULL,
93 p_attribute11 IN VARCHAR2 := NULL,
94 p_attribute12 IN VARCHAR2 := NULL,
95 p_attribute13 IN VARCHAR2 := NULL,
96 p_attribute14 IN VARCHAR2 := NULL,
97 p_attribute15 IN VARCHAR2 := NULL,
98 p_translated_from_tmpl_id IN NUMBER := NULL,
99 p_language IN VARCHAR2 := NULL,
100
101 x_template_id OUT NOCOPY NUMBER
102 );
103
104 PROCEDURE lock_row(
105 x_return_status OUT NOCOPY VARCHAR2,
106
107 p_template_id IN NUMBER,
108
109 p_object_version_number IN NUMBER
110 );
111
112 PROCEDURE update_row(
113 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
114 x_return_status OUT NOCOPY VARCHAR2,
115
116 p_template_name IN VARCHAR2,
117 p_template_id IN NUMBER,
118 p_working_copy_flag IN VARCHAR2,
119 p_intent IN VARCHAR2,
120 p_status_code IN VARCHAR2,
121 p_start_date IN DATE,
122 p_end_date IN DATE,
123 p_global_flag IN VARCHAR2,
124 p_parent_template_id IN NUMBER,
125 p_print_template_id IN NUMBER,
126 p_contract_expert_enabled IN VARCHAR2,
127 p_xprt_clause_mandatory_flag IN VARCHAR2 := NULL, -- Added for 11.5.10+ : Contract Expert Changes
128 p_xprt_scn_code IN VARCHAR2 := NULL, -- Added for 11.5.10: Contract Expert Changes
129 p_template_model_id IN NUMBER,
130 p_instruction_text IN VARCHAR2,
131 p_tmpl_numbering_scheme IN NUMBER,
132 p_description IN VARCHAR2,
133 p_approval_wf_key IN VARCHAR2 := NULL,
134 p_cz_export_wf_key IN VARCHAR2 := NULL,
135 p_orig_system_reference_code IN VARCHAR2 := NULL,
136 p_orig_system_reference_id1 IN NUMBER := NULL,
137 p_orig_system_reference_id2 IN NUMBER := NULL,
138 p_org_id IN NUMBER := NULL,
139
140 p_attribute_category IN VARCHAR2 := NULL,
141 p_attribute1 IN VARCHAR2 := NULL,
142 p_attribute2 IN VARCHAR2 := NULL,
143 p_attribute3 IN VARCHAR2 := NULL,
144 p_attribute4 IN VARCHAR2 := NULL,
145 p_attribute5 IN VARCHAR2 := NULL,
146 p_attribute6 IN VARCHAR2 := NULL,
147 p_attribute7 IN VARCHAR2 := NULL,
148 p_attribute8 IN VARCHAR2 := NULL,
149 p_attribute9 IN VARCHAR2 := NULL,
150 p_attribute10 IN VARCHAR2 := NULL,
151 p_attribute11 IN VARCHAR2 := NULL,
152 p_attribute12 IN VARCHAR2 := NULL,
153 p_attribute13 IN VARCHAR2 := NULL,
154 p_attribute14 IN VARCHAR2 := NULL,
155 p_attribute15 IN VARCHAR2 := NULL,
156 p_translated_from_tmpl_id IN NUMBER := NULL,
157 p_language IN VARCHAR2 := NULL,
158
159 p_object_version_number IN NUMBER
160 );
161
162 PROCEDURE delete_row(
163 x_return_status OUT NOCOPY VARCHAR2,
164
165 p_template_id IN NUMBER,
166
167 p_object_version_number IN NUMBER,
168 p_delete_parent_yn IN VARCHAR2 := 'N'
169 );
170
171 PROCEDURE validate_row(
172 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
173 x_return_status OUT NOCOPY VARCHAR2,
174
175 p_template_name IN VARCHAR2,
176 p_template_id IN NUMBER,
177 p_working_copy_flag IN VARCHAR2,
178 p_intent IN VARCHAR2,
179 p_status_code IN VARCHAR2,
180 p_start_date IN DATE,
181 p_end_date IN DATE,
182 p_global_flag IN VARCHAR2,
183 p_parent_template_id IN NUMBER,
184 p_print_template_id IN NUMBER,
185 p_contract_expert_enabled IN VARCHAR2,
186 p_xprt_clause_mandatory_flag IN VARCHAR2 := NULL, -- Added for 11.5.10+ : Contract Expert Changes
187 p_xprt_scn_code IN VARCHAR2 := NULL, -- Added for 11.5.10: Contract Expert Changes
188 p_template_model_id IN NUMBER,
189 p_instruction_text IN VARCHAR2,
190 p_tmpl_numbering_scheme IN NUMBER,
191 p_description IN VARCHAR2,
192 p_approval_wf_key IN VARCHAR2 := NULL,
193 p_cz_export_wf_key IN VARCHAR2 := NULL,
194 p_orig_system_reference_code IN VARCHAR2 := NULL,
195 p_orig_system_reference_id1 IN NUMBER := NULL,
196 p_orig_system_reference_id2 IN NUMBER := NULL,
197 p_org_id IN NUMBER,
198
199 p_attribute_category IN VARCHAR2 := NULL,
200 p_attribute1 IN VARCHAR2 := NULL,
201 p_attribute2 IN VARCHAR2 := NULL,
202 p_attribute3 IN VARCHAR2 := NULL,
203 p_attribute4 IN VARCHAR2 := NULL,
204 p_attribute5 IN VARCHAR2 := NULL,
205 p_attribute6 IN VARCHAR2 := NULL,
206 p_attribute7 IN VARCHAR2 := NULL,
207 p_attribute8 IN VARCHAR2 := NULL,
208 p_attribute9 IN VARCHAR2 := NULL,
209 p_attribute10 IN VARCHAR2 := NULL,
210 p_attribute11 IN VARCHAR2 := NULL,
211 p_attribute12 IN VARCHAR2 := NULL,
212 p_attribute13 IN VARCHAR2 := NULL,
213 p_attribute14 IN VARCHAR2 := NULL,
214 p_attribute15 IN VARCHAR2 := NULL,
215 p_translated_from_tmpl_id IN NUMBER := NULL,
216 p_language IN VARCHAR2 := NULL,
217
218 p_object_version_number IN NUMBER
219 );
220
221 FUNCTION get_rec (
222 p_template_id IN NUMBER,
223
224 x_template_name OUT NOCOPY VARCHAR2,
225 x_working_copy_flag OUT NOCOPY VARCHAR2,
226 x_intent OUT NOCOPY VARCHAR2,
227 x_status_code OUT NOCOPY VARCHAR2,
228 x_start_date OUT NOCOPY DATE,
229 x_end_date OUT NOCOPY DATE,
230 x_global_flag OUT NOCOPY VARCHAR2,
231 x_parent_template_id OUT NOCOPY NUMBER,
232 x_print_template_id OUT NOCOPY NUMBER,
233 x_contract_expert_enabled OUT NOCOPY VARCHAR2,
234 x_xprt_clause_mandatory_flag OUT NOCOPY VARCHAR2, -- Added for 11.5.10+ : Contract Expert Changes
235 x_xprt_scn_code OUT NOCOPY VARCHAR2, -- Added for 11.5.10: Contract Expert Changes
236 x_template_model_id OUT NOCOPY NUMBER,
237 x_instruction_text OUT NOCOPY VARCHAR2,
238 x_tmpl_numbering_scheme OUT NOCOPY NUMBER,
239 x_description OUT NOCOPY VARCHAR2,
240 x_approval_wf_key OUT NOCOPY VARCHAR2,
241 x_cz_export_wf_key OUT NOCOPY VARCHAR2,
242 x_orig_system_reference_code OUT NOCOPY VARCHAR2,
243 x_orig_system_reference_id1 OUT NOCOPY NUMBER,
244 x_orig_system_reference_id2 OUT NOCOPY NUMBER,
245 x_org_id OUT NOCOPY NUMBER,
246 x_attribute_category OUT NOCOPY VARCHAR2,
247 x_attribute1 OUT NOCOPY VARCHAR2,
248 x_attribute2 OUT NOCOPY VARCHAR2,
249 x_attribute3 OUT NOCOPY VARCHAR2,
250 x_attribute4 OUT NOCOPY VARCHAR2,
251 x_attribute5 OUT NOCOPY VARCHAR2,
252 x_attribute6 OUT NOCOPY VARCHAR2,
253 x_attribute7 OUT NOCOPY VARCHAR2,
254 x_attribute8 OUT NOCOPY VARCHAR2,
255 x_attribute9 OUT NOCOPY VARCHAR2,
256 x_attribute10 OUT NOCOPY VARCHAR2,
257 x_attribute11 OUT NOCOPY VARCHAR2,
258 x_attribute12 OUT NOCOPY VARCHAR2,
259 x_attribute13 OUT NOCOPY VARCHAR2,
260 x_attribute14 OUT NOCOPY VARCHAR2,
261 x_attribute15 OUT NOCOPY VARCHAR2,
262 x_object_version_number OUT NOCOPY NUMBER,
263 x_created_by OUT NOCOPY NUMBER,
264 x_creation_date OUT NOCOPY DATE,
265 x_last_updated_by OUT NOCOPY NUMBER,
266 x_last_update_login OUT NOCOPY NUMBER,
267 x_last_update_date OUT NOCOPY DATE,
268 x_translated_from_tmpl_id OUT NOCOPY NUMBER,
269 x_language OUT NOCOPY VARCHAR2
270
271 ) RETURN VARCHAR2;
272
273 PROCEDURE Update_Template_Id(
274 x_return_status OUT NOCOPY VARCHAR2,
275 p_old_template_id IN NUMBER,
276 p_new_template_id IN NUMBER
277 );
278
279 END OKC_TERMS_TEMPLATES_PVT;