[Home] [Help]
PACKAGE: APPS.OKS_SETUP_UTIL_PUB
Source
1 PACKAGE OKS_SETUP_UTIL_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKSSETUS.pls 120.9 2005/12/19 07:06:44 npalepu noship $ */
3
4
5 SUBTYPE War_tbl IS OKS_EXTWAR_UTIL_PVT.War_tbl;
6
7 -- GLOBAL VARIABLES
8 ----------------------------------------------------------------------------
9 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_SETUP_UTIL_PUB';
10 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
11 G_OKS_APP_NAME CONSTANT VARCHAR2(3) := 'OKS';
12 G_WAR_TBL war_tbl;
13 G_PTR NUMBER := 1;
14
15 G_GCD_PERIOD_START oks_k_defaults.period_start%TYPE;
16 G_GCD_PERIOD_TYPE oks_k_defaults.period_type%TYPE;
17 G_GCD_PRICE_UOM oks_k_defaults.price_uom%TYPE;
18 ----------------------------------------------------------------------------
19
20 -- GLOBAL_MESSAGE_CONSTANTS
21 ---------------------------------------------------------------------------
22 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
23 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
24 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
25 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
26 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
27 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
28 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
29 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
30 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
31 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
32 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
33 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
34 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
35 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UPPERCASE_REQUIRED';
36 ---------------------------------------------------------------------------
37
38 -- GLOBAL EXCEPTION
39 ---------------------------------------------------------------------------
40 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
41 ---------------------------------------------------------------------------
42 G_BULK_FETCH_LIMIT CONSTANT NUMBER := 1000;
43
44 TYPE contact_dtl_rec IS RECORD
45 (
46 contact_id NUMBER,
47 contact_first_name VARCHAR2(2000),
48 contact_name VARCHAR2(2000),
49 party_id NUMBER,
50 party_name VARCHAR2(2000),
51 email_point_id NUMBER,
52 email VARCHAR2(2000),
53 phone_point_id NUMBER,
54 phone VARCHAR2(2000),
55 fax_point_id NUMBER,
56 fax VARCHAR2(2000),
57 quote_site_id NUMBER,
58 quote_address VARCHAR2(2000),
59 quote_city VARCHAR2(2000),
60 quote_country VARCHAR2(2000)
61
62 );
63
64 Procedure Update_Hdr_Amount
65 (
66 p_api_version IN Number,
67 p_init_msg_list IN Varchar2,
68 p_chr_id IN Number,
69 x_return_status OUT NOCOPY Varchar2,
70 x_msg_count OUT NOCOPY Number,
71 x_msg_data OUT NOCOPY Varchar2
72 ) ;
73
74
75 Procedure copy_subscr_inst(
76 p_new_chr_id IN NUMBER,
77 p_cle_id IN NUMBER,
78 p_intent IN VARCHAR2 DEFAULT NULL,
79 x_return_status OUT NOCOPY VARCHAR2
80 );
81
82 Procedure Okscopy
83 ( p_chr_id NUMBER,
84 p_cle_id Number,
85 x_return_status out NOCOPY Varchar2,
86 p_upd_line_flag Varchar2 default null,
87 p_bill_profile_flag IN Varchar2 default null);
88
89 PROCEDURE Update_Line_Numbers
90 (
91 p_chr_id IN NUMBER,
92 p_cle_id IN NUMBER,
93 x_return_status OUT NOCOPY VARCHAR2
94 );
95
96 PROCEDURE Update_Line_Numbers
97 (
98 p_chr_id IN NUMBER,
99 p_update_top_line IN BOOLEAN DEFAULT FALSE,
100 x_return_status OUT NOCOPY VARCHAR2
101 );
102
103
104 PROCEDURE Get_QTO_Details
105 (
106 p_api_version IN Number,
107 p_init_msg_list IN Varchar2,
108 P_commit IN Varchar2,
109 p_chr_id IN Number,
110 p_type IN Varchar2,
111 x_contact_dtl_rec OUT NOCOPY contact_dtl_rec,
112 x_return_status OUT NOCOPY Varchar2,
113 x_msg_count OUT NOCOPY Number,
114 x_msg_data OUT NOCOPY Varchar2
115 );
116
117 PROCEDURE Create_Qto_Rule(p_api_version IN NUMBER,
118 p_init_msg_list IN VARCHAR2,
119 p_chr_id IN NUMBER,
120 p_contact_id IN NUMBER,
121 x_return_status OUT NOCOPY VARCHAR2,
122 x_msg_count OUT NOCOPY NUMBER,
123 x_msg_data OUT NOCOPY VARCHAR2);
124
125 Procedure copy_revenue_distb
126 (p_cle_id IN NUMBER,
127 p_new_cle_id IN NUMBER,
128 p_new_chr_id IN NUMBER,
129 x_return_status OUT NOCOPY VARCHAR2);
130
131 Procedure copy_hdr_sales_credits
132 (p_chr_id IN NUMBER,
133 p_new_chr_id IN NUMBER,
134 x_return_status OUT NOCOPY VARCHAR2);
135
136 Procedure copy_line_sales_credits
137 (p_cle_id IN NUMBER,
138 p_new_cle_id IN NUMBER,
139 p_new_chr_id IN NUMBER,
140 x_return_status OUT NOCOPY VARCHAR2);
141
142
143 Procedure copy_hdr_attr
144 (p_chr_id IN NUMBER,
145 p_new_chr_id IN NUMBER,
146 p_duration_match IN VARCHAR2,
147 p_renew_ref_YN IN VARCHAR2 DEFAULT 'N',
148 x_return_status OUT NOCOPY VARCHAR2);
149
150 Procedure copy_lines_attr
151 (p_cle_id IN NUMBER,
152 p_new_cle_id IN NUMBER,
153 p_new_chr_id IN NUMBER,
154 p_do_copy IN BOOLEAN Default true,
155 x_return_status OUT NOCOPY VARCHAR2);
156
157 PROCEDURE get_strlvls
158 (p_chr_id IN NUMBER,
159 p_cle_id IN NUMBER,
160 p_billsch_type IN VARCHAR2,
161 x_strlvl_tbl OUT NOCOPY OKS_BILL_SCH.StreamLvl_tbl,
162 x_return_status OUT NOCOPY VARCHAR2
163 );
164 PROCEDURE sub_copy
165 (p_chr_id IN NUMBER,
166 p_cle_id IN NUMBER,
167 p_start_date IN DATE,
168 p_upd_line_flag IN Varchar2,
169 p_billing_schedule_type IN VARCHAR2,
170 p_duration_match IN Varchar2,
171 p_bill_profile_flag IN Varchar2,
172 p_do_copy IN BOOLEAN Default true,
173 x_return_status OUT NOCOPY VARCHAR2);
174
175 FUNCTION Resp_Org_id RETURN NUMBER;
176
177 PROCEDURE Delete_Contract(
178 p_api_version IN NUMBER,
179 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
180 p_chr_id IN NUMBER,
181 x_return_status OUT NOCOPY VARCHAR2,
182 x_msg_count OUT NOCOPY NUMBER,
183 x_msg_data OUT NOCOPY VARCHAR2);
184
185
186 PROCEDURE Delete_Contract_Line(
187 p_api_version IN NUMBER,
188 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
189 p_line_id IN NUMBER,
190 x_return_status OUT NOCOPY VARCHAR2,
191 x_msg_count OUT NOCOPY NUMBER,
192 x_msg_data OUT NOCOPY VARCHAR2);
193
194 -- Line Cancellation --
195 -- New procedure added to find if a contract thats going to be deleted
196 -- has lines or covered levels that has been renewed on another contract
197 PROCEDURE Delete_Transfer_Contract(
198 p_api_version IN NUMBER,
199 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
200 p_chr_id IN NUMBER,
201 p_cle_id IN NUMBER DEFAULT NULL,
202 p_intent IN VARCHAR2, -- new --
203 x_contract_number OUT NOCOPY VARCHAR2,
204 x_return_status OUT NOCOPY VARCHAR2,
205 x_msg_count OUT NOCOPY NUMBER,
206 x_msg_data OUT NOCOPY VARCHAR2);
207
208 -- Line cancellation --
209
210 /*
211 New procedure to delete toplines an sublines for OKS. This builds on
212 OKS_SETUP_UTIL_PUB.Delete_Contract_Line and adds stuff that authoring does and some other
213 stuff that nobody seems to be doing
214
215 Parameters
216 p_line_id : id of the top line/subline from OKC_K_LINES_B table
217 */
218 PROCEDURE DELETE_TOP_SUB_LINE
219 (
220 p_api_version IN NUMBER,
221 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
222 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
223 p_line_id IN NUMBER,
224 x_return_status OUT NOCOPY VARCHAR2,
225 x_msg_count OUT NOCOPY NUMBER,
226 x_msg_data OUT NOCOPY VARCHAR2
227 );
228
229 --Npalepu added on 30-nov-2005 for bug # 4768227.
230 --New Function Get_Annualized_Factor is added to calculate the Annualized_Factor provided start_date,end_date and lse_id.
231 FUNCTION Get_Annualized_Factor(p_start_date IN DATE,
232 p_end_date IN DATE,
233 p_lse_id IN NUMBER)
234 RETURN NUMBER;
235 --end bug # 4768227
236
237 --npalepu added on 15-dec-2005 for bug # 4886786
238 PROCEDURE Update_Annualized_Factor_BMGR(X_errbuf out NOCOPY varchar2,
239 X_retcode out NOCOPY varchar2,
240 P_batch_size in number,
241 P_Num_Workers in number);
242
243 PROCEDURE Update_Annualized_Factor_HMGR(X_errbuf out NOCOPY varchar2,
244 X_retcode out NOCOPY varchar2,
245 P_batch_size in number,
246 P_Num_Workers in number);
247
248 PROCEDURE Update_Annualized_Factor_BWKR(X_errbuf out NOCOPY varchar2,
249 X_retcode out NOCOPY varchar2,
250 P_batch_size in number,
251 P_Worker_Id in number,
252 P_Num_Workers in number);
253
254 PROCEDURE Update_Annualized_Factor_HWKR(X_errbuf out NOCOPY varchar2,
255 X_retcode out NOCOPY varchar2,
256 P_batch_size in number,
257 P_Worker_Id in number,
258 P_Num_Workers in number);
259 --end npalepu
260
261 END OKS_SETUP_UTIL_PUB;