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