1 PACKAGE okl_vp_sync_cr_pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLRCRSS.pls 120.4 2005/10/11 10:40:47 sjalasut noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL VARIABLES
6 ---------------------------------------------------------------------------
7 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_VP_SYNC_CR_PVT';
8 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
9 G_API_TYPE CONSTANT VARCHAR2(30) := '_PVT';
10
11 -------------------------------------------------------------------------------
12 -- PROCEDURE sync_agr_header
13 -------------------------------------------------------------------------------
14 -- Start of comments
15 --
16 -- Procedure Name : sync_agr_header
17 -- Description : synchronizes the change request header with original
18 -- agreement header. only end date can be extended, comments and
19 -- short description can also be synced between change req and
20 -- original agreement
21 -- Parameters : IN p_orig_chr_id original agreement chr_id
22 -- IN p_creq_chr_id agreement id associated with the change request
23 -- Version : 1.0
24 -- History : May 18, 05 sjalasut created
25 -- End of comments
26 PROCEDURE sync_agr_header(p_api_version IN NUMBER
27 ,p_init_msg_list IN VARCHAR2
28 ,x_return_status OUT NOCOPY VARCHAR2
29 ,x_msg_count OUT NOCOPY NUMBER
30 ,x_msg_data OUT NOCOPY VARCHAR2
31 ,p_orig_chr_id IN okc_k_headers_b.id%TYPE
32 ,p_creq_chr_id IN okc_k_headers_b.id%TYPE
33 );
34
35 -------------------------------------------------------------------------------
36 -- PROCEDURE sync_non_primary_parties
37 -------------------------------------------------------------------------------
38 -- Start of comments
39 --
40 -- Procedure Name : sync_non_primary_parties
41 -- Description : handles synchronizing non primary parties between the change request
42 -- and original agreement id
43 -- non primary parties are all parties except OKX_VENDOR and OKX_LESSEE
44 -- Parameters : IN p_orig_chr_id original agreement chr_id
45 -- IN p_creq_chr_id agreement id associated with the change request
46 -- Version : 1.0
47 -- History : May 18, 05 sjalasut created
48 -- End of comments
49 PROCEDURE sync_non_primary_parties(p_api_version IN NUMBER
50 ,p_init_msg_list IN VARCHAR2
51 ,x_return_status OUT NOCOPY VARCHAR2
52 ,x_msg_count OUT NOCOPY NUMBER
53 ,x_msg_data OUT NOCOPY VARCHAR2
54 ,p_orig_chr_id IN okc_k_headers_b.id%TYPE
55 ,p_creq_chr_id IN okc_k_headers_b.id%TYPE
56 );
57
58 -------------------------------------------------------------------------------
59 -- PROCEDURE sync_party_contacts
60 -------------------------------------------------------------------------------
61 -- Start of comments
62 --
63 -- Procedure Name : sync_party_contacts
64 -- Description : handles synchrnonization of party contacts, this includes both
65 -- primary and non primary party contacts
66 -- Parameters : IN p_orig_chr_id original agreement chr_id
67 -- IN p_creq_chr_id agreement id associated with the change request
68 -- Version : 1.0
69 -- History : May 18, 05 sjalasut created
70 -- End of comments
71 PROCEDURE sync_party_contacts(p_api_version IN NUMBER
72 ,p_init_msg_list IN VARCHAR2
73 ,x_return_status OUT NOCOPY VARCHAR2
74 ,x_msg_count OUT NOCOPY NUMBER
75 ,x_msg_data OUT NOCOPY VARCHAR2
76 ,p_orig_chr_id IN okc_k_headers_b.id%TYPE
77 ,p_creq_chr_id IN okc_k_headers_b.id%TYPE
78 );
79
80 -------------------------------------------------------------------------------
81 -- PROCEDURE sync_article_changes
82 -------------------------------------------------------------------------------
83 -- Start of comments
84 --
85 -- Procedure Name : sync_article_changes
86 -- Description : handles synchrnonization of standard and non standard articles
87 -- between the change request and the original agreement
88 -- this api deletes all articles on the original agreement and then
89 -- creates all articles from the change request
90 -- Parameters : IN p_orig_chr_id original agreement chr_id
91 -- IN p_creq_chr_id agreement id associated with the change request
92 -- Version : 1.0
93 -- History : May 18, 05 sjalasut created
94 -- End of comments
95 PROCEDURE sync_article_changes(p_api_version IN NUMBER
96 ,p_init_msg_list IN VARCHAR2
97 ,x_return_status OUT NOCOPY VARCHAR2
98 ,x_msg_count OUT NOCOPY NUMBER
99 ,x_msg_data OUT NOCOPY VARCHAR2
100 ,p_orig_chr_id IN okc_k_headers_b.id%TYPE
101 ,p_creq_chr_id IN okc_k_headers_b.id%TYPE
102 );
103
104
105 -------------------------------------------------------------------------------
106 -- PROCEDURE sync_vendor_billing
107 -------------------------------------------------------------------------------
108 -- Start of comments
109 --
110 -- Procedure Name : sync_vendor_billing
111 -- Description : handles synchrnonization of Vendor Billing Information
112 -- between the change request and the original agreement
113 -- Parameters : IN p_orig_chr_id original agreement chr_id
114 -- IN p_creq_chr_id agreement id associated with the change request
115 -- Version : 1.0
116 -- History : Aug 22, 05 sjalasut created
117 -- End of comments
118 PROCEDURE sync_vendor_billing(p_api_version IN NUMBER
119 ,p_init_msg_list IN VARCHAR2
120 ,x_return_status OUT NOCOPY VARCHAR2
121 ,x_msg_count OUT NOCOPY NUMBER
122 ,x_msg_data OUT NOCOPY VARCHAR2
123 ,p_orig_chr_id IN okc_k_headers_b.id%TYPE
124 ,p_creq_chr_id IN okc_k_headers_b.id%TYPE
125 );
126
127 -------------------------------------------------------------------------------
128 -- PROCEDURE sync_associations
129 -------------------------------------------------------------------------------
130 -- Start of comments
131 --
132 -- Procedure Name : sync_associations
133 -- Description : handles synchronization of associations for change request type of
134 -- ASSOCIATION for a program agreement
135 -- in case of ASSOCIATION, new templates are added to the original agreement
136 -- end dates are synched up on the existing records, and any records deleted
137 -- from change request are also deleted from the original agreement
138 -- Parameters : IN p_orig_chr_id original agreement chr_id
139 -- IN p_creq_chr_id agreement id associated with the change request
140 -- Version : 1.0
141 -- History : May 18, 05 sjalasut created
142 -- End of comments
143 PROCEDURE sync_associations(p_api_version IN NUMBER
144 ,p_init_msg_list IN VARCHAR2
145 ,x_return_status OUT NOCOPY VARCHAR2
146 ,x_msg_count OUT NOCOPY NUMBER
147 ,x_msg_data OUT NOCOPY VARCHAR2
148 ,p_orig_chr_id IN okc_k_headers_b.id%TYPE
149 ,p_creq_chr_id IN okc_k_headers_b.id%TYPE
150 ,p_change_request_id IN okl_vp_change_requests.id%TYPE
151 );
152
153 -------------------------------------------------------------------------------
154 -- PROCEDURE sync_agr_associations
155 -------------------------------------------------------------------------------
156 -- Start of comments
157 --
158 -- Procedure Name : sync_associations
159 -- Description : handles synchronization of associations for change request type of
160 -- AGREEMENT for a program agreement
161 -- in case of AGREEMENT, new templates are added to the original agreement
162 -- end dates are synched up on the existing records, and any records deleted
163 -- from change request are also deleted from the original agreement
164 -- Parameters : IN p_orig_chr_id original agreement chr_id
165 -- IN p_creq_chr_id agreement id associated with the change request
166 -- Version : 1.0
167 -- History : May 18, 05 sjalasut created
168 -- End of comments
169 PROCEDURE sync_agr_associations(p_api_version IN NUMBER
170 ,p_init_msg_list IN VARCHAR2
171 ,x_return_status OUT NOCOPY VARCHAR2
172 ,x_msg_count OUT NOCOPY NUMBER
173 ,x_msg_data OUT NOCOPY VARCHAR2
174 ,p_orig_chr_id IN okc_k_headers_b.id%TYPE
175 ,p_creq_chr_id IN okc_k_headers_b.id%TYPE
176 ,p_change_request_id IN okl_vp_change_requests.id%TYPE
177 );
178
179 -------------------------------------------------------------------------------
180 -- PROCEDURE sync_elig_criteria
181 -------------------------------------------------------------------------------
182 -- Start of comments
183 --
184 -- Procedure Name : sync_elig_criteria
185 -- Description : handles synchronization of eligiility criteria
186 -- the eligibility criteria on the original agreement is deleted
187 -- and re-created from the change request.
188 -- Parameters : IN p_orig_chr_id original agreement chr_id
189 -- IN p_creq_chr_id agreement id associated with the change request
190 -- Version : 1.0
191 -- History : May 18, 05 sjalasut created
192 -- End of comments
193 PROCEDURE sync_elig_criteria(p_api_version IN NUMBER
194 ,p_init_msg_list IN VARCHAR2
195 ,x_return_status OUT NOCOPY VARCHAR2
196 ,x_msg_count OUT NOCOPY NUMBER
197 ,x_msg_data OUT NOCOPY VARCHAR2
198 ,p_orig_chr_id IN okc_k_headers_b.id%TYPE
199 ,p_creq_chr_id IN okc_k_headers_b.id%TYPE
200 );
201
202 -------------------------------------------------------------------------------
203 -- PROCEDURE sync_change_request
204 -------------------------------------------------------------------------------
205 -- Start of comments
206 --
207 -- Procedure Name : sync_change_request
208 -- Description : handles creation of change request header for Operating Agreement and Program Agreement
209 -- main synchornization api that calls the following apis in the following order
210 -- a. sync_agr_header
211 -- b. sync_non_primary_parties
212 -- c. sync_party_contacts
213 -- d. sync_article_changes
214 -- e. sync_associations
215 -- f. sync_elig_criteria
216 -- g. sync_terms (for a AGREEMENT type of change request)
217 -- Parameters : IN p_orig_chr_id original agreement chr_id
218 -- IN p_creq_chr_id agreement id associated with the change request
219 -- Version : 1.0
220 -- History : May 18, 05 sjalasut created
221 -- End of comments
222 PROCEDURE sync_change_request(p_api_version IN NUMBER
223 ,p_init_msg_list IN VARCHAR2
224 ,x_return_status OUT NOCOPY VARCHAR2
225 ,x_msg_count OUT NOCOPY NUMBER
226 ,x_msg_data OUT NOCOPY VARCHAR2
227 ,p_change_request_id IN okl_vp_change_requests.id%TYPE);
228
229 -------------------------------------------------------------------------------
230 -- PROCEDURE sync_terms
231 -------------------------------------------------------------------------------
232 -- Start of comments
233 --
234 -- Procedure Name : sync_terms
235 -- Description : handles synchronization of terms and conditions on the change request agreement
236 -- associated with an AGREEMENT type of change request, onto the originating
237 -- vendor agreement
238 -- Parameters : IN p_orig_chr_id original agreement chr_id
239 -- IN p_creq_chr_id agreement id associated with the change request
240 -- Version : 1.0
241 -- History : Sep 21, 05 sjalasut created
242 -- End of comments
243 PROCEDURE sync_terms(p_api_version IN NUMBER
244 ,p_init_msg_list IN VARCHAR2
245 ,x_return_status OUT NOCOPY VARCHAR2
246 ,x_msg_count OUT NOCOPY NUMBER
247 ,x_msg_data OUT NOCOPY VARCHAR2
248 ,p_orig_chr_id IN okc_k_headers_b.id%TYPE
249 ,p_creq_chr_id IN okc_k_headers_b.id%TYPE
250 );
251
252 -------------------------------------------------------------------------------
253 -- PROCEDURE sync_vendor_disb_setup
254 -------------------------------------------------------------------------------
255 -- Start of comments
256 --
257 -- Procedure Name : sync_vendor_disb_setup
258 -- Description : handles synchronization of program agreement vendor disbursement setup
259 -- Parameters : IN p_orig_chr_id original agreement chr_id
260 -- IN p_creq_chr_id agreement id associated with the change request
261 -- Version : 1.0
262 -- History : Sep 21, 05 sjalasut created
263 -- End of comments
264 PROCEDURE sync_vendor_disb_setup(p_api_version IN NUMBER
265 ,p_init_msg_list IN VARCHAR2
266 ,x_return_status OUT NOCOPY VARCHAR2
267 ,x_msg_count OUT NOCOPY NUMBER
268 ,x_msg_data OUT NOCOPY VARCHAR2
269 ,p_orig_chr_id IN okc_k_headers_b.id%TYPE
270 ,p_creq_chr_id IN okc_k_headers_b.id%TYPE
271 );
272
273 END okl_vp_sync_cr_pvt;