DBA Data[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;