1 PACKAGE OKC_TERMS_COPY_GRP AS
2 /* $Header: OKCGDCPS.pls 120.2 2005/08/23 15:25:55 vnanjang noship $ */
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 );
47
48 /*
49 --To be used when copying a terms template to make a new template
50 */
51 Procedure copy_terms_template (
52 p_api_version IN Number,
53 p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
54 p_commit IN Varchar2 default FND_API.G_FALSE,
55 p_template_id IN Number,
56 p_tmpl_name IN Varchar2,
57 p_intent IN Varchar2,
58 p_start_date IN Date default sysdate,
59 p_end_date IN Date default Null,
60 p_instruction_text IN Varchar2 default Null,
61 p_description IN Varchar2 default Null,
62 p_print_Template_Id IN Number default Null,
63 p_global_flag IN Varchar2 default 'N',
64 p_contract_expert_enabled IN Varchar2 default 'N',
65 p_xprt_clause_mandatory_flag IN VARCHAR2 := NULL,
66 p_xprt_scn_code IN VARCHAR2 := NULL,
67 p_attribute_category IN Varchar2 default Null,
68 p_attribute1 IN Varchar2 default Null,
69 p_attribute2 IN Varchar2 default Null,
70 p_attribute3 IN Varchar2 default Null,
71 p_attribute4 IN Varchar2 default Null,
72 p_attribute5 IN Varchar2 default Null,
73 p_attribute6 IN Varchar2 default Null,
74 p_attribute7 IN Varchar2 default Null,
75 p_attribute8 IN Varchar2 default Null,
76 p_attribute9 IN Varchar2 default Null,
77 p_attribute10 IN Varchar2 default Null,
78 p_attribute11 IN Varchar2 default Null,
79 p_attribute12 IN Varchar2 default Null,
80 p_attribute13 IN Varchar2 default Null,
81 p_attribute14 IN Varchar2 default Null,
82 p_attribute15 IN Varchar2 default Null,
83 p_copy_deliverables IN Varchar2 default 'Y',
84 p_translated_from_tmpl_id IN Number default Null,
85 p_language IN Varchar2 default Null,
86 x_template_id OUT NOCOPY Number,
87 x_return_status OUT NOCOPY Varchar2,
88 x_msg_data OUT NOCOPY Varchar2,
89 x_msg_count OUT NOCOPY Number);
90
91 /*
92 --To be used when instantiating a term on a document.
93 */
94 Procedure copy_terms (
95 p_api_version IN Number,
96 p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
97 p_commit IN Varchar2 default fnd_api.g_false,
98 p_template_id IN Number,
99 p_target_doc_type IN Varchar2,
100 p_target_doc_id IN Number,
101 p_article_effective_date IN Date,
102 p_retain_deliverable IN Varchar2 default 'N',
103 p_target_contractual_doctype IN Varchar2 default NULL,
104 p_target_response_doctype IN Varchar2 default NULL,
105 p_internal_party_id IN Number default Null,
106 p_internal_contact_id IN Number default Null,
107 p_external_party_id IN Number default Null,
108 p_external_party_site_id IN Number default Null,
109 p_external_contact_id IN Number default Null,
110
111 p_validate_commit IN Varchar2 default FND_API.G_FALSE,
112 p_validation_string IN Varchar2,
113 p_document_number IN Varchar2 default Null,
114 x_return_status OUT NOCOPY Varchar2,
115 x_msg_data OUT NOCOPY Varchar2,
116 x_msg_count OUT NOCOPY Number,
117 p_contract_admin_id IN NUMBER := NULL,
118 p_legal_contact_id IN NUMBER := NULL
119 );
120
121 /* To be used to create Revision of a Template */
122
123 Procedure create_template_revision (
124 p_api_version IN Number,
125 p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
126 p_commit IN Varchar2 default FND_API.G_FALSE,
127 p_template_id IN Number,
128 p_copy_deliverables IN Varchar2 default 'Y',
129 x_template_id OUT NOCOPY Number,
130 x_return_status OUT NOCOPY Varchar2,
131 x_msg_data OUT NOCOPY Varchar2,
132 x_msg_count OUT NOCOPY Number);
133 /*
134 -- To be used while copying a document from archive to make a new document.
135 -- This functionality is only supported in OM.
136 */
137
138 Procedure copy_archived_doc (
139 p_api_version IN Number,
140 p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
141 p_commit IN Varchar2 default fnd_api.g_false,
142 p_source_doc_type IN Varchar2,
143 p_source_doc_id IN Number,
144 p_source_version_number IN Number,
145 p_target_doc_type IN Varchar2,
146 p_target_doc_id IN Number,
147 p_document_number IN Varchar2 default Null,
148 p_allow_duplicate_terms IN Varchar2 default 'N',
149 x_return_status OUT NOCOPY Varchar2,
150 x_msg_data OUT NOCOPY Varchar2,
151 x_msg_count OUT NOCOPY Number
152 );
153
154
155 /*************************************************************
156 07-APR-2004 pnayani: bug#3524864 added copy_response_doc API |
157 This API is used for copying terms, deliverables and document attachments from
158 one response doc to another. Initially coded to support proxy bidding process in sourcing.
159 p_source_doc_type - source document type,
160 p_source_doc_id - source document id,
161 p_target_doc_type - target document type,
162 p_target_doc_id - target document id,
163 p_target_doc_number - target document number,
164 p_keep_version - passed as 'Y' in case of document transition.
165 - passed as 'N' in case of document copy where target
166 - doc is expected to have same version of article as source doc.
167 p_article_effective_date - article effective date,
168 p_copy_doc_attachments - flag indicates if doc attachments should be copied, valid values Y/N,
169 p_allow_duplicate_terms - flag with valid values Y/N,
170 p_copy_attachments_by_ref - flag indicates if document attachments should be
171 - physically copied or referenced, valid values Y/N,
172 *************************************************************/
173
174 Procedure copy_response_doc (
175 p_api_version IN Number,
176 p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
177 p_commit IN Varchar2 default fnd_api.g_false,
178 p_source_doc_type IN Varchar2,
179 p_source_doc_id IN Number,
180 p_target_doc_type IN OUT NOCOPY Varchar2,
181 p_target_doc_id IN OUT NOCOPY Number,
182 p_target_doc_number IN Varchar2 default Null,
183 p_keep_version IN Varchar2 default 'N',
184 p_article_effective_date IN Date,
185 p_copy_doc_attachments IN Varchar2 default 'N',
186 p_allow_duplicate_terms IN Varchar2 default 'N',
187 p_copy_attachments_by_ref IN Varchar2 default 'N',
188 x_return_status OUT NOCOPY Varchar2,
189 x_msg_data OUT NOCOPY Varchar2,
190 x_msg_count OUT NOCOPY Number
191 );
192
193
194
195 END OKC_TERMS_COPY_GRP;