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