[Home] [Help]
PACKAGE: APPS.OKC_COPY_CONTRACT_PUB
Source
1 Package OKC_COPY_CONTRACT_PUB AUTHID CURRENT_USER AS
2 /*$Header: OKCPCPYS.pls 120.3 2008/01/18 13:27:00 vgujarat ship $*/
3
4 SUBTYPE chrv_rec_type IS OKC_COPY_CONTRACT_PVT.chrv_rec_type;
5 SUBTYPE chrv_tbl_type IS OKC_COPY_CONTRACT_PVT.chrv_tbl_type;
6 SUBTYPE clev_rec_type IS OKC_COPY_CONTRACT_PVT.clev_rec_type;
7 SUBTYPE clev_tbl_type IS OKC_COPY_CONTRACT_PVT.clev_tbl_type;
8 SUBTYPE cacv_rec_type IS OKC_COPY_CONTRACT_PVT.cacv_rec_type;
9 SUBTYPE cacv_tbl_type IS OKC_COPY_CONTRACT_PVT.cacv_tbl_type;
10 SUBTYPE cpsv_rec_type IS OKC_COPY_CONTRACT_PVT.cpsv_rec_type;
11 SUBTYPE cpsv_tbl_type IS OKC_COPY_CONTRACT_PVT.cpsv_tbl_type;
12 SUBTYPE rulv_rec_type IS OKC_COPY_CONTRACT_PVT.rulv_rec_type;
13 SUBTYPE rulv_tbl_type IS OKC_COPY_CONTRACT_PVT.rulv_tbl_type;
14 SUBTYPE rgpv_rec_type IS OKC_COPY_CONTRACT_PVT.rgpv_rec_type;
15 SUBTYPE rgpv_tbl_type IS OKC_COPY_CONTRACT_PVT.rgpv_tbl_type;
16 SUBTYPE catv_rec_type IS OKC_COPY_CONTRACT_PVT.catv_rec_type;
17 SUBTYPE catv_tbl_type IS OKC_COPY_CONTRACT_PVT.catv_tbl_type;
18 SUBTYPE cnhv_rec_type IS OKC_COPY_CONTRACT_PVT.cnhv_rec_type;
19 SUBTYPE cnhv_tbl_type IS OKC_COPY_CONTRACT_PVT.cnhv_tbl_type;
20 SUBTYPE cnlv_rec_type IS OKC_COPY_CONTRACT_PVT.cnlv_rec_type;
21 SUBTYPE cnlv_tbl_type IS OKC_COPY_CONTRACT_PVT.cnlv_tbl_type;
22 SUBTYPE cimv_rec_type IS OKC_COPY_CONTRACT_PVT.cimv_rec_type;
23 SUBTYPE cimv_tbl_type IS OKC_COPY_CONTRACT_PVT.cimv_tbl_type;
24 SUBTYPE cplv_rec_type IS OKC_COPY_CONTRACT_PVT.cplv_rec_type;
25 SUBTYPE cplv_tbl_type IS OKC_COPY_CONTRACT_PVT.cplv_tbl_type;
26 SUBTYPE cgcv_rec_type IS OKC_COPY_CONTRACT_PVT.cgcv_rec_type;
27 SUBTYPE cgcv_tbl_type IS OKC_CONTRACT_GROUP_PUB.cgcv_tbl_type;
28
29
30 ---------------------------------------------------------------------------
31 -- GLOBAL MESSAGE CONSTANTS
32 ---------------------------------------------------------------------------
33 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
34 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
35 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
36 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
37 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
38 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
39 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
40 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
41 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
42 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
43 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
44 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
45 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
46 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UPPERCASE_REQ';
47
48 ------------------------------------------------------------------------------------
49 -- GLOBAL EXCEPTION
50 ---------------------------------------------------------------------------
51 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
52
53 -- GLOBAL VARIABLES
54 ---------------------------------------------------------------------------
55 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_COPY_CONTRACT_PUB';
56 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
57 ---------------------------------------------------------------------------
58
59
60 SUBTYPE api_components_tbl IS OKC_COPY_CONTRACT_PVT.api_components_tbl;
61 SUBTYPE api_lines_tbl IS OKC_COPY_CONTRACT_PVT.api_lines_tbl;
62
63
64 FUNCTION update_target_contract(p_chr_id IN NUMBER) RETURN BOOLEAN;
65 FUNCTION is_copy_allowed(p_chr_id IN NUMBER,p_sts_code IN VARCHAR2 DEFAULT NULL) RETURN BOOLEAN;
66 FUNCTION is_subcontract_allowed(p_chr_id IN NUMBER,p_sts_code IN VARCHAR2) RETURN BOOLEAN;
67
68 PROCEDURE derive_line_style(p_old_lse_id IN NUMBER,
69 p_old_jtot_code IN VARCHAR2,
70 p_new_subclass IN VARCHAR2,
71 p_new_parent_lse IN NUMBER,
72 x_new_lse_count OUT NOCOPY NUMBER,
73 x_new_lse_ids OUT NOCOPY VARCHAR2);
74
75 PROCEDURE copy_components(
76 p_api_version IN NUMBER,
77 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
78 x_return_status OUT NOCOPY VARCHAR2,
79 x_msg_count OUT NOCOPY NUMBER,
80 x_msg_data OUT NOCOPY VARCHAR2,
81 p_from_chr_id IN NUMBER,
82 p_to_chr_id IN NUMBER,
83 p_contract_number IN VARCHAR2,
84 p_contract_number_modifier IN VARCHAR2,
85 p_to_template_yn IN VARCHAR2 DEFAULT 'N',
86 p_copy_reference IN VARCHAR2 DEFAULT 'COPY',
87 p_copy_line_party_yn IN VARCHAR2,
88 p_scs_code IN VARCHAR2,
89 p_intent IN VARCHAR2,
90 p_prospect IN VARCHAR2,
91 p_components_tbl IN api_components_tbl,
92 p_lines_tbl IN api_lines_tbl,
93 x_chr_id OUT NOCOPY NUMBER,
94 p_concurrent_request IN VARCHAR2 DEFAULT 'N',
95 p_include_cancelled_lines IN VARCHAR2 DEFAULT 'Y',
96 p_include_terminated_lines IN VARCHAR2 DEFAULT 'Y');
97 -- Bug 2950549 - Added 1 more parameter p_concurrent_request in the
98 -- above procedure.
99
100 PROCEDURE copy_contract(
101 p_api_version IN NUMBER,
102 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
103 x_return_status OUT NOCOPY VARCHAR2,
104 x_msg_count OUT NOCOPY NUMBER,
105 x_msg_data OUT NOCOPY VARCHAR2,
106 p_commit IN VARCHAR2 DEFAULT 'F',
107 p_chr_id IN NUMBER,
108 p_contract_number IN VARCHAR2,
109 p_contract_number_modifier IN VARCHAR2,
110 p_to_template_yn IN VARCHAR2 DEFAULT 'N',
111 p_renew_ref_yn IN VARCHAR2 DEFAULT 'N',
112 p_copy_from_history_yn IN VARCHAR2 DEFAULT 'N',
113 p_from_version_number IN NUMBER DEFAULT NULL,
114 p_copy_latest_articles IN VARCHAR2 DEFAULT 'Y',
115 p_calling_mode IN VARCHAR2 DEFAULT 'OKC',
116 x_chr_id OUT NOCOPY NUMBER);
117
118 PROCEDURE copy_contract(
119 p_api_version IN NUMBER,
120 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
121 x_return_status OUT NOCOPY VARCHAR2,
122 x_msg_count OUT NOCOPY NUMBER,
123 x_msg_data OUT NOCOPY VARCHAR2,
124 p_commit IN VARCHAR2 DEFAULT 'F',
125 p_chr_id IN NUMBER,
126 p_contract_number IN VARCHAR2,
127 p_contract_number_modifier IN VARCHAR2,
128 p_to_template_yn IN VARCHAR2 DEFAULT 'N',
129 p_renew_ref_yn IN VARCHAR2 DEFAULT 'N',
130 p_copy_lines_yn IN VARCHAR2,
131 p_override_org IN VARCHAR2 DEFAULT 'N',
132 p_copy_from_history_yn IN VARCHAR2 DEFAULT 'N',
133 p_from_version_number IN NUMBER DEFAULT NULL,
134 p_copy_latest_articles IN VARCHAR2 DEFAULT 'Y',
135 p_calling_mode IN VARCHAR2 DEFAULT 'OKC',
136 x_chr_id OUT NOCOPY NUMBER);
137
138
139 -- LLC Added additional flag parameter to the call to not allow
140 -- change of status of sublines of the topline during update service
141
142 PROCEDURE copy_contract_lines(
143 p_api_version IN NUMBER,
144 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
145 x_return_status OUT NOCOPY VARCHAR2,
146 x_msg_count OUT NOCOPY NUMBER,
147 x_msg_data OUT NOCOPY VARCHAR2,
148 p_from_cle_id IN NUMBER,
149 p_to_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
150 p_to_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
151 p_to_template_yn IN VARCHAR2 DEFAULT 'N',
152 p_copy_reference IN VARCHAR2 DEFAULT 'COPY',
153 p_copy_line_party_yn IN VARCHAR2 DEFAULT 'Y',
154 p_renew_ref_yn IN VARCHAR2 DEFAULT 'N',
155 x_cle_id OUT NOCOPY NUMBER,
156 p_change_status IN VARCHAR2 DEFAULT 'Y');
157
158 PROCEDURE copy_rules(
159 p_api_version IN NUMBER,
160 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
161 x_return_status OUT NOCOPY VARCHAR2,
162 x_msg_count OUT NOCOPY NUMBER,
163 x_msg_data OUT NOCOPY VARCHAR2,
164 p_rgp_id IN NUMBER,
165 p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
166 p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
167 p_to_template_yn IN VARCHAR2,
168 x_rgp_id OUT NOCOPY NUMBER);
169
170 PROCEDURE copy_party_roles(
171 p_api_version IN NUMBER,
172 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
173 x_return_status OUT NOCOPY VARCHAR2,
174 x_msg_count OUT NOCOPY NUMBER,
175 x_msg_data OUT NOCOPY VARCHAR2,
176 p_cpl_id IN NUMBER,
177 p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
178 p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
179 P_rle_code IN VARCHAR2,
180 x_cpl_id OUT NOCOPY NUMBER);
181
182 PROCEDURE copy_articles(
183 p_api_version IN NUMBER,
184 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
185 x_return_status OUT NOCOPY VARCHAR2,
186 x_msg_count OUT NOCOPY NUMBER,
187 x_msg_data OUT NOCOPY VARCHAR2,
188 p_cat_id IN NUMBER,
189 p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
190 p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
191 p_sav_sav_release IN VARCHAR2 DEFAULT NULL,
192 x_cat_id OUT NOCOPY NUMBER);
193
194 PROCEDURE copy_latest_articles(
195 p_api_version IN NUMBER,
196 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
197 x_return_status OUT NOCOPY VARCHAR2,
198 x_msg_count OUT NOCOPY NUMBER,
199 x_msg_data OUT NOCOPY VARCHAR2,
200 p_cat_id IN NUMBER,
201 p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
202 p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
203 x_cat_id OUT NOCOPY NUMBER);
204
205 -- Bug 2950549 - Added this procedure
206 PROCEDURE copy_concurrent(errbuf out NOCOPY VARCHAR2,
207 retcode out NOCOPY NUMBER,
208 p_id in NUMBER,
209 p_from_chr_id IN NUMBER,
210 p_to_chr_id IN NUMBER,
211 p_contract_number IN VARCHAR2,
212 p_contract_number_modifier IN VARCHAR2,
213 p_to_template_yn IN VARCHAR2,
214 p_copy_reference IN VARCHAR2,
215 p_copy_line_party_yn IN VARCHAR2,
216 p_scs_code IN VARCHAR2,
217 p_intent IN VARCHAR2,
218 p_prospect IN VARCHAR2,
219 p_copy_entire_k_yn IN VARCHAR2,/* hkamdar R12 copy project*/ p_include_cancelled_lines IN VARCHAR2,
220 p_include_terminated_lines IN VARCHAR2);
221 -- Bug 2950549 End of the procedure
222
223 -- IKON ER 3819893
224 PROCEDURE UPDATE_TEMPLATE_CONTRACT (p_api_version IN NUMBER,
225 p_init_msg_list IN VARCHAR2,
226 p_chr_id IN NUMBER,
227 p_start_date IN DATE,
228 p_end_date IN DATE,
229 x_msg_count OUT NOCOPY NUMBER,
230 x_msg_data OUT NOCOPY VARCHAR2,
231 x_return_status OUT NOCOPY VARCHAR2) ;
232
233 END OKC_COPY_CONTRACT_PUB;