[Home] [Help]
PACKAGE: APPS.OKC_TERMS_TEMPLATES_GRP
Source
1 PACKAGE OKC_TERMS_TEMPLATES_GRP AUTHID CURRENT_USER AS
2 /* $Header: OKCGTERMTMPLS.pls 120.2.12020000.2 2013/01/31 08:10:09 skavutha ship $ */
3
4 ---------------------------------------------------------------------------
5 -- Procedures and Functions
6 ---------------------------------------------------------------------------
7
8 PROCEDURE create_template(
9 p_api_version IN NUMBER,
10 p_init_msg_list IN VARCHAR2 ,
11 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
12 p_commit IN VARCHAR2 := FND_API.G_FALSE,
13
14 x_return_status OUT NOCOPY VARCHAR2,
15 x_msg_count OUT NOCOPY NUMBER,
16 x_msg_data OUT NOCOPY VARCHAR2,
17
18 p_template_name IN VARCHAR2,
19 p_template_id IN NUMBER := NULL,
20 p_working_copy_flag IN VARCHAR2,
21 p_intent IN VARCHAR2,
22 p_status_code IN VARCHAR2,
23 p_start_date IN DATE,
24 p_end_date IN DATE,
25 p_global_flag IN VARCHAR2,
26 p_parent_template_id IN NUMBER,
27 p_print_template_id IN NUMBER,
28 p_contract_expert_enabled IN VARCHAR2,
29 p_xprt_clause_mandatory_flag IN VARCHAR2 := NULL,
30 p_xprt_scn_code IN VARCHAR2 := NULL,
31 p_template_model_id IN NUMBER,
32 p_instruction_text IN VARCHAR2,
33 p_tmpl_numbering_scheme IN NUMBER,
34 p_description IN VARCHAR2,
35 p_approval_wf_key IN VARCHAR2 := NULL,
36 p_cz_export_wf_key IN VARCHAR2 := NULL,
37 p_orig_system_reference_code IN VARCHAR2 := NULL,
38 p_orig_system_reference_id1 IN NUMBER := NULL,
39 p_orig_system_reference_id2 IN NUMBER := NULL,
40 p_org_id IN NUMBER,
41 p_cls_enabled IN VARCHAR2 := 'N',
42
43 p_attribute_category IN VARCHAR2 := NULL,
44 p_attribute1 IN VARCHAR2 := NULL,
45 p_attribute2 IN VARCHAR2 := NULL,
46 p_attribute3 IN VARCHAR2 := NULL,
47 p_attribute4 IN VARCHAR2 := NULL,
48 p_attribute5 IN VARCHAR2 := NULL,
49 p_attribute6 IN VARCHAR2 := NULL,
50 p_attribute7 IN VARCHAR2 := NULL,
51 p_attribute8 IN VARCHAR2 := NULL,
52 p_attribute9 IN VARCHAR2 := NULL,
53 p_attribute10 IN VARCHAR2 := NULL,
54 p_attribute11 IN VARCHAR2 := NULL,
55 p_attribute12 IN VARCHAR2 := NULL,
56 p_attribute13 IN VARCHAR2 := NULL,
57 p_attribute14 IN VARCHAR2 := NULL,
58 p_attribute15 IN VARCHAR2 := NULL,
59
60 p_translated_from_tmpl_id IN NUMBER := NULL,
61 p_language IN VARCHAR2 := NULL,
62
63 x_template_id OUT NOCOPY NUMBER
64
65 );
66
67 PROCEDURE lock_row(
68 p_api_version IN NUMBER,
69 p_init_msg_list IN VARCHAR2 ,
70
71 x_return_status OUT NOCOPY VARCHAR2,
72 x_msg_count OUT NOCOPY NUMBER,
73 x_msg_data OUT NOCOPY VARCHAR2,
74
75 p_template_id IN NUMBER,
76
77 p_object_version_number IN NUMBER
78
79 );
80
81 PROCEDURE update_template(
82 p_api_version IN NUMBER,
83 p_init_msg_list IN VARCHAR2 ,
84 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
85 p_commit IN VARCHAR2 := FND_API.G_FALSE,
86
87 x_return_status OUT NOCOPY VARCHAR2,
88 x_msg_count OUT NOCOPY NUMBER,
89 x_msg_data OUT NOCOPY VARCHAR2,
90
91 p_template_name IN VARCHAR2,
92 p_template_id IN NUMBER,
93 p_working_copy_flag IN VARCHAR2,
94 p_intent IN VARCHAR2,
95 p_status_code IN VARCHAR2,
96 p_start_date IN DATE,
97 p_end_date IN DATE,
98 p_global_flag IN VARCHAR2,
99 p_parent_template_id IN NUMBER,
100 p_print_template_id IN NUMBER,
101 p_contract_expert_enabled IN VARCHAR2,
102 p_xprt_clause_mandatory_flag IN VARCHAR2 := NULL, -- Added for 11.5.10+: Contract Expert Changes
103 p_xprt_scn_code IN VARCHAR2 := NULL, -- Added for 11.5.10+: Contract Expert Changes
104 p_template_model_id IN NUMBER,
105 p_instruction_text IN VARCHAR2,
106 p_tmpl_numbering_scheme IN NUMBER,
107 p_description IN VARCHAR2,
108 p_approval_wf_key IN VARCHAR2 := NULL,
109 p_cz_export_wf_key IN VARCHAR2 := NULL,
110 p_orig_system_reference_code IN VARCHAR2 := NULL,
111 p_orig_system_reference_id1 IN NUMBER := NULL,
112 p_orig_system_reference_id2 IN NUMBER := NULL,
113 p_org_id IN NUMBER,
114 p_cls_enabled IN VARCHAR2 := 'N',
115
116 p_attribute_category IN VARCHAR2 := NULL,
117 p_attribute1 IN VARCHAR2 := NULL,
118 p_attribute2 IN VARCHAR2 := NULL,
119 p_attribute3 IN VARCHAR2 := NULL,
120 p_attribute4 IN VARCHAR2 := NULL,
121 p_attribute5 IN VARCHAR2 := NULL,
122 p_attribute6 IN VARCHAR2 := NULL,
123 p_attribute7 IN VARCHAR2 := NULL,
124 p_attribute8 IN VARCHAR2 := NULL,
125 p_attribute9 IN VARCHAR2 := NULL,
126 p_attribute10 IN VARCHAR2 := NULL,
127 p_attribute11 IN VARCHAR2 := NULL,
128 p_attribute12 IN VARCHAR2 := NULL,
129 p_attribute13 IN VARCHAR2 := NULL,
130 p_attribute14 IN VARCHAR2 := NULL,
131 p_attribute15 IN VARCHAR2 := NULL,
132
133 p_translated_from_tmpl_id IN NUMBER := NULL,
134 p_language IN VARCHAR2 := NULL,
135
136 p_object_version_number IN NUMBER
137 );
138
139 PROCEDURE delete_template(
140 p_api_version IN NUMBER,
141 p_init_msg_list IN VARCHAR2 ,
142 p_commit IN VARCHAR2 := FND_API.G_FALSE,
143
144 x_return_status OUT NOCOPY VARCHAR2,
145 x_msg_count OUT NOCOPY NUMBER,
146 x_msg_data OUT NOCOPY VARCHAR2,
147
148 p_template_id IN NUMBER,
149
150 p_object_version_number IN NUMBER
151 );
152
153 PROCEDURE validate_row(
154 p_api_version IN NUMBER,
155 p_init_msg_list IN VARCHAR2 ,
156 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
157
158 x_return_status OUT NOCOPY VARCHAR2,
159 x_msg_count OUT NOCOPY NUMBER,
160 x_msg_data OUT NOCOPY VARCHAR2,
161
162 p_template_name IN VARCHAR2,
163 p_template_id IN NUMBER,
164 p_working_copy_flag IN VARCHAR2,
165 p_intent IN VARCHAR2,
166 p_status_code IN VARCHAR2,
167 p_start_date IN DATE,
168 p_end_date IN DATE,
169 p_global_flag IN VARCHAR2,
170 p_parent_template_id IN NUMBER,
171 p_print_template_id IN NUMBER,
172 p_contract_expert_enabled IN VARCHAR2,
173 p_xprt_clause_mandatory_flag IN VARCHAR2 := NULL, -- Added for 11.5.10+: Contract Expert Changes
174 p_xprt_scn_code IN VARCHAR2 := NULL, -- Added for 11.5.10+: Contract Expert Changes
175 p_template_model_id IN NUMBER,
176 p_instruction_text IN VARCHAR2,
177 p_tmpl_numbering_scheme IN NUMBER,
178 p_description IN VARCHAR2,
179 p_approval_wf_key IN VARCHAR2 := NULL,
180 p_cz_export_wf_key IN VARCHAR2 := NULL,
181 p_orig_system_reference_code IN VARCHAR2 := NULL,
182 p_orig_system_reference_id1 IN NUMBER := NULL,
183 p_orig_system_reference_id2 IN NUMBER := NULL,
184 p_org_id IN NUMBER,
185
186 p_attribute_category IN VARCHAR2 := NULL,
190 p_attribute4 IN VARCHAR2 := NULL,
187 p_attribute1 IN VARCHAR2 := NULL,
188 p_attribute2 IN VARCHAR2 := NULL,
189 p_attribute3 IN VARCHAR2 := NULL,
191 p_attribute5 IN VARCHAR2 := NULL,
192 p_attribute6 IN VARCHAR2 := NULL,
193 p_attribute7 IN VARCHAR2 := NULL,
194 p_attribute8 IN VARCHAR2 := NULL,
195 p_attribute9 IN VARCHAR2 := NULL,
196 p_attribute10 IN VARCHAR2 := NULL,
197 p_attribute11 IN VARCHAR2 := NULL,
198 p_attribute12 IN VARCHAR2 := NULL,
199 p_attribute13 IN VARCHAR2 := NULL,
200 p_attribute14 IN VARCHAR2 := NULL,
201 p_attribute15 IN VARCHAR2 := NULL,
202
203 p_translated_from_tmpl_id IN NUMBER := NULL,
204 p_language IN VARCHAR2 := NULL,
205
206 p_object_version_number IN NUMBER
207 );
208
209 END OKC_TERMS_TEMPLATES_GRP;