[Home] [Help]
PACKAGE: APPS.OKL_COPY_CONTRACT_PVT
Source
1 Package okl_copy_contract_pvt as
2 /* $Header: OKLRCOPS.pls 120.3 2005/10/14 19:36:16 apaul noship $ */
3
4 subtype clev_rec_type is okl_okc_migration_pvt.clev_rec_type;
5 subtype clev_tbl_type is okl_okc_migration_pvt.clev_tbl_type;
6 subtype chrv_rec_type is okl_okc_migration_pvt.chrv_rec_type;
7 subtype chrv_tbl_type is okl_okc_migration_pvt.chrv_tbl_type;
8 subtype klev_rec_type is OKL_CONTRACT_PUB.klev_rec_type;
9 subtype khrv_rec_type is OKL_CONTRACT_PUB.khrv_rec_type;
10 subtype khrv_tbl_type is OKL_CONTRACT_PUB.khrv_tbl_type;
11 subtype klev_tbl_type is OKL_CONTRACT_PUB.klev_tbl_type;
12
13
14 ---------------------------------------------------------------------------
15 -- GLOBAL MESSAGE CONSTANTS
16 ---------------------------------------------------------------------------
17 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
18 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
19 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
20 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
21 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
22 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
23 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
24 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
25 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
26 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
27 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXP_ERROR';
28 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
29 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
30 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UPPERCASE_REQ';
31 ------------------------------------------------------------------------------------
32 -- GLOBAL EXCEPTION
33 ---------------------------------------------------------------------------
34 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
35 G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
36 G_API_VERSION CONSTANT NUMBER := 1.0;
37 G_SCOPE CONSTANT VARCHAR2(4) := '_PVT';
38
39 -- GLOBAL VARIABLES
40 ---------------------------------------------------------------------------
41 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_COPY_CONTRACT_PVT';
42 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
43 ---------------------------------------------------------------------------
44
45 TYPE api_components_rec IS RECORD(id NUMBER,
46 to_k NUMBER,
47 component_type VARCHAR2(30),
48 attribute1 VARCHAR2(100));
49 TYPE api_components_tbl IS TABLE OF api_components_rec
50 INDEX BY BINARY_INTEGER;
51
52 TYPE api_lines_rec IS RECORD(id NUMBER,
53 to_k NUMBER,
54 to_line NUMBER,
55 lse_id NUMBER,
56 line_exists_yn VARCHAR2(1));
57 TYPE api_lines_tbl IS TABLE OF api_lines_rec
58 INDEX BY BINARY_INTEGER;
59
60 FUNCTION is_copy_allowed(p_chr_id IN NUMBER,p_sts_code IN VARCHAR2 DEFAULT NULL) RETURN BOOLEAN;
61 FUNCTION is_subcontract_allowed(p_chr_id IN NUMBER,p_sts_code IN VARCHAR2) RETURN BOOLEAN;
62 FUNCTION update_target_contract(p_chr_id IN NUMBER) RETURN BOOLEAN;
63
64 PROCEDURE derive_line_style(p_old_lse_id IN NUMBER,
65 p_old_jtot_code IN VARCHAR2,
66 p_new_subclass IN VARCHAR2,
67 p_new_parent_lse IN NUMBER,
68 x_new_lse_count OUT NOCOPY NUMBER,
69 x_new_lse_ids OUT NOCOPY VARCHAR2);
70 PROCEDURE copy_components(
71 p_api_version IN NUMBER,
72 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
73 x_return_status OUT NOCOPY VARCHAR2,
74 x_msg_count OUT NOCOPY NUMBER,
75 x_msg_data OUT NOCOPY VARCHAR2,
76 p_from_chr_id IN NUMBER,
77 p_to_chr_id IN NUMBER,
78 p_contract_number IN VARCHAR2,
79 p_contract_number_modifier IN VARCHAR2,
80 p_to_template_yn IN VARCHAR2 DEFAULT 'N',
81 p_copy_reference IN VARCHAR2 DEFAULT 'COPY',
82 p_copy_line_party_yn IN VARCHAR2,
83 p_scs_code IN VARCHAR2,
84 p_intent IN VARCHAR2,
85 p_prospect IN VARCHAR2,
86 p_components_tbl IN api_components_tbl,
87 p_lines_tbl IN api_lines_tbl,
88 x_chr_id OUT NOCOPY NUMBER);
89
90 PROCEDURE copy_contract(
91 p_api_version IN NUMBER,
92 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
93 x_return_status OUT NOCOPY VARCHAR2,
94 x_msg_count OUT NOCOPY NUMBER,
95 x_msg_data OUT NOCOPY VARCHAR2,
96 p_commit IN VARCHAR2 DEFAULT 'F',
97 p_chr_id IN NUMBER,
98 p_contract_number IN VARCHAR2,
99 p_contract_number_modifier IN VARCHAR2,
100 p_to_template_yn IN VARCHAR2 DEFAULT 'N',
101 p_renew_ref_yn IN VARCHAR2,
102 p_copy_lines_yn IN VARCHAR2,
103 p_override_org IN VARCHAR2 DEFAULT 'N',
104 x_chr_id OUT NOCOPY NUMBER);
105
106 PROCEDURE copy_lease_contract(
107 p_api_version IN NUMBER,
108 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
109 x_return_status OUT NOCOPY VARCHAR2,
110 x_msg_count OUT NOCOPY NUMBER,
111 x_msg_data OUT NOCOPY VARCHAR2,
112 p_commit IN VARCHAR2 DEFAULT 'F',
113 p_chr_id IN NUMBER,
114 p_contract_number IN VARCHAR2,
115 p_contract_number_modifier IN VARCHAR2,
116 p_to_template_yn IN VARCHAR2 DEFAULT 'N',
117 p_renew_ref_yn IN VARCHAR2,
118 p_copy_lines_yn IN VARCHAR2,
119 p_override_org IN VARCHAR2 DEFAULT 'N',
120 p_trans_type IN VARCHAR2,
121 x_chr_id OUT NOCOPY NUMBER);
122
123 PROCEDURE copy_lease_contract_new(
124 p_api_version IN NUMBER,
125 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
126 x_return_status OUT NOCOPY VARCHAR2,
127 x_msg_count OUT NOCOPY NUMBER,
128 x_msg_data OUT NOCOPY VARCHAR2,
129 p_commit IN VARCHAR2 DEFAULT 'F',
130 p_chr_id IN NUMBER,
131 p_contract_number IN VARCHAR2,
132 p_contract_number_modifier IN VARCHAR2,
133 p_to_template_yn IN VARCHAR2 DEFAULT 'N',
134 p_renew_ref_yn IN VARCHAR2,
135 p_copy_lines_yn IN VARCHAR2,
136 p_override_org IN VARCHAR2 DEFAULT 'N',
137 p_trans_type IN VARCHAR2,
138 x_chr_id OUT NOCOPY NUMBER,
139 p_rbk_date IN DATE DEFAULT NULL);
140
141 Procedure copy_contract_lines(
142 p_api_version IN NUMBER,
143 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
144 x_return_status OUT NOCOPY VARCHAR2,
145 x_msg_count OUT NOCOPY NUMBER,
146 x_msg_data OUT NOCOPY VARCHAR2,
147 p_from_cle_id IN NUMBER,
148 p_to_cle_id IN NUMBER,
149 p_to_chr_id IN NUMBER,
150 p_to_template_yn IN VARCHAR2,
151 p_copy_reference IN VARCHAR2,
152 p_copy_line_party_yn IN VARCHAR2,
153 p_renew_ref_yn IN VARCHAR2,
154 x_cle_id OUT NOCOPY NUMBER);
155
156 PROCEDURE copy_rules(
157 p_api_version IN NUMBER,
158 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
159 x_return_status OUT NOCOPY VARCHAR2,
160 x_msg_count OUT NOCOPY NUMBER,
161 x_msg_data OUT NOCOPY VARCHAR2,
162 p_rgp_id IN NUMBER,
163 p_cle_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
164 p_chr_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
165 p_to_template_yn IN VARCHAR2,
166 x_rgp_id OUT NOCOPY NUMBER);
167
168 PROCEDURE copy_party_roles(
169 p_api_version IN NUMBER,
170 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
171 x_return_status OUT NOCOPY VARCHAR2,
172 x_msg_count OUT NOCOPY NUMBER,
173 x_msg_data OUT NOCOPY VARCHAR2,
174 p_cpl_id IN NUMBER,
175 p_cle_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
176 p_chr_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
177 P_rle_code IN VARCHAR2,
178 x_cpl_id OUT NOCOPY NUMBER);
179
180 PROCEDURE copy_articles(
181 p_api_version IN NUMBER,
182 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
183 x_return_status OUT NOCOPY VARCHAR2,
184 x_msg_count OUT NOCOPY NUMBER,
185 x_msg_data OUT NOCOPY VARCHAR2,
186 p_cat_id IN NUMBER,
187 p_cle_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
188 p_chr_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
189 p_sav_sav_release IN VARCHAR2 DEFAULT NULL,
190 x_cat_id OUT NOCOPY NUMBER);
191
192 PROCEDURE copy_latest_articles(
193 p_api_version IN NUMBER,
194 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
195 x_return_status OUT NOCOPY VARCHAR2,
196 x_msg_count OUT NOCOPY NUMBER,
197 x_msg_data OUT NOCOPY VARCHAR2,
198 p_cat_id IN NUMBER,
199 p_cle_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
200 p_chr_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
201 x_cat_id OUT NOCOPY NUMBER);
202
203 -- bug 3630858
204 PROCEDURE copy_product_options
205 (p_api_version IN NUMBER,
206 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
207 x_return_status OUT NOCOPY VARCHAR2,
208 x_msg_count OUT NOCOPY NUMBER,
209 x_msg_data OUT NOCOPY VARCHAR2,
210 p_new_khr_id IN NUMBER,
211 p_cspv_id IN NUMBER,
212 x_cspv_id OUT NOCOPY NUMBER
213 );
214
215 End okl_copy_contract_Pvt;