1 PACKAGE OKC_TERMS_COPY_GRP AUTHID CURRENT_USER AS
2 /* $Header: OKCGDCPS.pls 120.4.12020000.4 2013/04/12 14:11:53 serukull ship $ */
3
4 /*
5 --To be used when copying/transitioning a document
6
7 --p_keep_version should be passed as 'Y' in case of document transition.
8 --p_keep_version should be passed as 'N' in case of document copy where target
9 --document is expected to have same version of article as source document .
10 --p_copy_for_amendment and p_copy_deliverable should be passed as 'Y' when making amendment in sourcing.All other systems should pass p_copy_for_amendment as 'N'.
11 --p_copy_deliverable should be passed as 'Y' when deliverable also needs to be
12 --copied.
13 */
14
15 Procedure copy_doc (
16 p_api_version IN Number,
17 p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
18 p_commit IN Varchar2 default fnd_api.g_false,
19 p_source_doc_type IN Varchar2,
20 p_source_doc_id IN Number,
21 p_target_doc_type IN OUT NOCOPY Varchar2,
22 p_target_doc_id IN OUT NOCOPY Number,
23 p_keep_version IN Varchar2 default 'N',
24 p_article_effective_date IN Date,
25 p_initialize_status_yn IN Varchar2 default 'Y',
26 p_reset_Fixed_Date_yn IN Varchar2 default 'Y',
27 p_internal_party_id IN Number default Null,
28 p_internal_contact_id IN Number default Null,
29 p_target_contractual_doctype IN Varchar2 default NULL,
30 p_copy_del_attachments_yn IN Varchar2 default 'Y',
31 p_external_party_id IN Number default Null,
32 p_external_contact_id IN Number default Null,
33 p_copy_deliverables IN Varchar2 default 'Y',
34 p_document_number IN Varchar2 default Null,
35 p_copy_for_amendment IN Varchar2 default 'N',
36 p_copy_doc_attachments IN Varchar2 default 'N',
37 p_allow_duplicate_terms IN Varchar2 default 'N',
38 p_copy_attachments_by_ref IN Varchar2 default 'N',
39 x_return_status OUT NOCOPY Varchar2,
40 x_msg_data OUT NOCOPY Varchar2,
41 x_msg_count OUT NOCOPY Number,
42 p_external_party_site_id IN Number default Null,
43 p_copy_abstract_yn IN Varchar2 default 'N',
44 p_contract_admin_id IN NUMBER := NULL,
45 p_legal_contact_id IN NUMBER := NULL
46 -- Conc Mod Changes Start
47 ,p_retain_lock_terms_yn IN VARCHAR2 := 'N'
48 ,p_retain_lock_xprt_yn IN VARCHAR2 := 'N'
49 -- conc mod clean up and support for concurrent updates to deliverables.
50 -- For backward compatability
51 ,p_add_only_amend_deliverables IN VARCHAR2 := 'N'
52 -- conc mod clean up and support for concurrent updates to deliverables.
53 -- For backward compatability
54
55 ,P_RETAIN_LOCK_DELIVERABLES_YN IN VARCHAR2 := 'N'
56 ,p_rebuild_locks IN VARCHAR2 := 'N'
57 -- Conc Mod Changes End
58 );
59
60 /*
61 --To be used when copying a terms template to make a new template
62 */
63 Procedure copy_terms_template (
64 p_api_version IN Number,
65 p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
66 p_commit IN Varchar2 default FND_API.G_FALSE,
67 p_template_id IN Number,
68 p_tmpl_name IN Varchar2,
69 p_intent IN Varchar2,
70 p_start_date IN Date default sysdate,
71 p_end_date IN Date default Null,
72 p_instruction_text IN Varchar2 default Null,
73 p_description IN Varchar2 default Null,
74 p_print_Template_Id IN Number default Null,
75 p_global_flag IN Varchar2 default 'N',
76 p_contract_expert_enabled IN Varchar2 default 'N',
77 p_cls_enabled IN Varchar2 default 'N',
78 p_xprt_clause_mandatory_flag IN VARCHAR2 := NULL,
79 p_xprt_scn_code IN VARCHAR2 := NULL,
80 p_attribute_category IN Varchar2 default Null,
81 p_attribute1 IN Varchar2 default Null,
82 p_attribute2 IN Varchar2 default Null,
83 p_attribute3 IN Varchar2 default Null,
84 p_attribute4 IN Varchar2 default Null,
85 p_attribute5 IN Varchar2 default Null,
86 p_attribute6 IN Varchar2 default Null,
87 p_attribute7 IN Varchar2 default Null,
88 p_attribute8 IN Varchar2 default Null,
89 p_attribute9 IN Varchar2 default Null,
90 p_attribute10 IN Varchar2 default Null,
91 p_attribute11 IN Varchar2 default Null,
92 p_attribute12 IN Varchar2 default Null,
93 p_attribute13 IN Varchar2 default Null,
94 p_attribute14 IN Varchar2 default Null,
95 p_attribute15 IN Varchar2 default Null,
96 p_copy_deliverables IN Varchar2 default 'Y',
97 p_translated_from_tmpl_id IN Number default Null,
98 p_language IN Varchar2 default Null,
99 x_template_id OUT NOCOPY Number,
100 x_return_status OUT NOCOPY Varchar2,
101 x_msg_data OUT NOCOPY Varchar2,
102 x_msg_count OUT NOCOPY Number);
103
104 /*
105 --To be used when instantiating a term on a document.
106 */
107 Procedure copy_terms (
108 p_api_version IN Number,
109 p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
110 p_commit IN Varchar2 default fnd_api.g_false,
111 p_template_id IN Number,
112 p_target_doc_type IN Varchar2,
113 p_target_doc_id IN Number,
114 p_article_effective_date IN Date,
115 p_retain_deliverable IN Varchar2 default 'N',
116 p_target_contractual_doctype IN Varchar2 default NULL,
117 p_target_response_doctype IN Varchar2 default NULL,
118 p_internal_party_id IN Number default Null,
119 p_internal_contact_id IN Number default Null,
120 p_external_party_id IN Number default Null,
121 p_external_party_site_id IN Number default Null,
122 p_external_contact_id IN Number default Null,
123
124 p_validate_commit IN Varchar2 default FND_API.G_FALSE,
125 p_validation_string IN Varchar2,
126 p_document_number IN Varchar2 default Null,
127 x_return_status OUT NOCOPY Varchar2,
128 x_msg_data OUT NOCOPY Varchar2,
129 x_msg_count OUT NOCOPY Number,
130 p_retain_clauses IN Varchar2 default 'N', --kkolukul: Clm Changes
131 p_contract_admin_id IN NUMBER := NULL,
132 p_legal_contact_id IN NUMBER := NULL
133 );
134
135 /* To be used to create Revision of a Template */
136
137 Procedure create_template_revision (
138 p_api_version IN Number,
139 p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
140 p_commit IN Varchar2 default FND_API.G_FALSE,
141 p_template_id IN Number,
142 p_copy_deliverables IN Varchar2 default 'Y',
143 x_template_id OUT NOCOPY Number,
144 x_return_status OUT NOCOPY Varchar2,
145 x_msg_data OUT NOCOPY Varchar2,
146 x_msg_count OUT NOCOPY Number);
147 /*
148 -- To be used while copying a document from archive to make a new document.
149 -- This functionality is only supported in OM.
150 */
151
152 Procedure copy_archived_doc (
153 p_api_version IN Number,
154 p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
155 p_commit IN Varchar2 default fnd_api.g_false,
156 p_source_doc_type IN Varchar2,
157 p_source_doc_id IN Number,
158 p_source_version_number IN Number,
159 p_target_doc_type IN Varchar2,
160 p_target_doc_id IN Number,
161 p_document_number IN Varchar2 default Null,
162 p_allow_duplicate_terms IN Varchar2 default 'N',
163 x_return_status OUT NOCOPY Varchar2,
164 x_msg_data OUT NOCOPY Varchar2,
165 x_msg_count OUT NOCOPY Number
166 );
167
168
169 /*************************************************************
170 07-APR-2004 pnayani: bug#3524864 added copy_response_doc API |
171 This API is used for copying terms, deliverables and document attachments from
172 one response doc to another. Initially coded to support proxy bidding process in sourcing.
173 p_source_doc_type - source document type,
174 p_source_doc_id - source document id,
175 p_target_doc_type - target document type,
176 p_target_doc_id - target document id,
177 p_target_doc_number - target document number,
178 p_keep_version - passed as 'Y' in case of document transition.
179 - passed as 'N' in case of document copy where target
180 - doc is expected to have same version of article as source doc.
181 p_article_effective_date - article effective date,
182 p_copy_doc_attachments - flag indicates if doc attachments should be copied, valid values Y/N,
183 p_allow_duplicate_terms - flag with valid values Y/N,
184 p_copy_attachments_by_ref - flag indicates if document attachments should be
185 - physically copied or referenced, valid values Y/N,
186 *************************************************************/
187
188 Procedure copy_response_doc (
189 p_api_version IN Number,
190 p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
191 p_commit IN Varchar2 default fnd_api.g_false,
192 p_source_doc_type IN Varchar2,
193 p_source_doc_id IN Number,
194 p_target_doc_type IN OUT NOCOPY Varchar2,
195 p_target_doc_id IN OUT NOCOPY Number,
196 p_target_doc_number IN Varchar2 default Null,
197 p_keep_version IN Varchar2 default 'N',
198 p_article_effective_date IN Date,
199 p_copy_doc_attachments IN Varchar2 default 'N',
200 p_allow_duplicate_terms IN Varchar2 default 'N',
201 p_copy_attachments_by_ref IN Varchar2 default 'N',
202 x_return_status OUT NOCOPY Varchar2,
203 x_msg_data OUT NOCOPY Varchar2,
204 x_msg_count OUT NOCOPY Number
205 );
206
207
208 PROCEDURE process_mod_terms (
209 p_api_version IN Number,
210 p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
211 p_commit IN Varchar2 default fnd_api.g_false,
212
213 p_process IN VARCHAR2,
214
215 p_source_doc_type IN Varchar2,
216 p_source_doc_id IN Number,
217
218 p_target_doc_type IN OUT NOCOPY Varchar2,
219 p_target_doc_id IN OUT NOCOPY Number,
220 p_target_document_number IN Varchar2 default Null,
221
222
223 x_return_status OUT NOCOPY Varchar2,
224 x_msg_data OUT NOCOPY Varchar2,
225 x_msg_count OUT NOCOPY Number
226 );
227
228
229
230
231 END OKC_TERMS_COPY_GRP;