[Home] [Help]
PACKAGE: APPS.OKS_IB_UTIL_PVT
Source
1 Package OKS_IB_UTIL_PVT As
2 /* $Header: OKSRIBUS.pls 120.17.12000000.1 2007/01/16 22:10:55 appldev ship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL MESSAGE CONSTANTS
6 ---------------------------------------------------------------------------
7 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
8 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
9 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
10 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
11 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
12 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
13 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
14 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
15 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UPPERCASE_REQUIRED';
16
17 ------------------------------------------------------------------------------------
18 -- GLOBAL EXCEPTION
19 ---------------------------------------------------------------------------
20 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
21
22 -- GLOBAL VARIABLES
23 ---------------------------------------------------------------------------
24 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_IB_UTIL_PVT';
25 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKS';
26 G_FND_LOG_OPTION CONSTANT VARCHAR2(30) := NVL(Fnd_Profile.Value('OKS_DEBUG'),'N');
27 ---------------------------------------------------------------------------
28 g_num_days_week CONSTANT NUMBER := 7;
29 g_quaterly CONSTANT NUMBER := 3;
30 g_halfyearly CONSTANT NUMBER := 6;
31 g_yearly CONSTANT NUMBER := 12;
32 g_service_line_style CONSTANT NUMBER := 1;
33 g_coverage_level_style CONSTANT NUMBER := 2;
34 g_usage_line_style CONSTANT NUMBER := 3;
35 g_installed_item_style CONSTANT NUMBER := 4;
36 g_regular CONSTANT NUMBER := 1;
37 g_nonregular CONSTANT NUMBER := 2;
38 g_stat_reg_inv_to_ar CONSTANT NUMBER := 1;
39 g_stat_ter_cr_inv_to_ar CONSTANT NUMBER := 2;
40 g_billaction_tr CONSTANT VARCHAR2 (9) := 'TR';
41 g_billaction_ri CONSTANT VARCHAR2 (9) := 'RI';
42 v_billsch_type CONSTANT VARCHAR2( 10 ) := 'T';
43
44
45
46 -- Billing rec
47 TYPE billing_rec_type IS RECORD (
48 start_date DATE
49 ,end_date DATE
50 ,inv_rule_id NUMBER
51 ,schedule_type VARCHAR2(1)
52 ,billing_type VARCHAR2(10)
53 ,freq_period VARCHAR2(10)
54 ,invoice_offset NUMBER
55 ,interface_offset NUMBER
56 ,amount NUMBER
57 ,currency_code VARCHAR2(10));
58
59
60 FUNCTION check_partial_flag (p_id IN NUMBER, p_flag IN VARCHAR2)
61 RETURN VARCHAR2;
62
63 FUNCTION get_terminate_amount (
64 p_line_id IN NUMBER,
65 p_termination_date IN DATE
66
67 )
68 RETURN NUMBER;
69
70 FUNCTION get_billed_amount (
71 p_line_id IN NUMBER
72 )
73 RETURN NUMBER;
74
75 FUNCTION get_transferred_amount (
76 p_line_id IN NUMBER,
77 p_transfer_date IN DATE
78 ) return Number;
79
80 Procedure CheckMultipleOU(P_Batch_ID Number, p_new_account_id Number, x_party_id Out NOCOPY Number, x_org_id Out NOCOPY Number);
81
82 FUNCTION checkaccount (p_batch_id NUMBER, p_new_account_id NUMBER)
83 RETURN Varchar2;
84 Procedure Get_prod_name(P_line_id Number, x_prod_name Out NoCopy Varchar2, X_system_name Out NoCopy Varchar2) ;
85
86
87 Procedure GetBillToShipTo(P_New_account_id Number,
88 P_BillTo_account_Id Number default Null,
89 P_BillTo_Address_Id Number default Null,
90 P_ShipTo_account_Id Number default Null,
91 P_ShipTo_Address_Id Number default Null,
92 P_Operating_unit Number default Null,
93 X_BillTo_account_Number Out NOCOPY VARCHAR2,
94 X_BillTo_account_Id Out NOCOPY Number,
95 X_BillTo_Party Out NOCOPY Varchar2,
96 X_BillTo_PartyId Out NOCOPY Number,
97 X_BillTo_Address_Id Out NOCOPY Number,
98 X_BillTo_Address Out NOCOPY Varchar2,
99 X_ShipTo_account_Number Out NOCOPY VARCHAR2,
100 X_ShipTo_account_Id Out NOCOPY Number,
101 X_ShipTo_Party Out NOCOPY Varchar2,
102 X_ShipTo_PartyId Out NOCOPY Number,
103 X_ShipTo_Address_Id Out NOCOPY Number,
104 X_ShipTo_Address Out NOCOPY Varchar2,
105 X_Contract_status_Code Out NOCOPY Varchar2,
106 X_Contract_status Out NOCOPY Varchar2,
107 X_Party_ID OUT NOCOPY Number,
108 X_Credit_option OUT NOCOPY Varchar2,
109 P_Transaction_date Date default sysdate
110
111
112 ) ;
113
114 PROCEDURE populate_globaltemp (
115 p_batch_id NUMBER,
116 p_batch_type VARCHAR2,
117 p_transaction_date Date default sysdate,
118 P_new_account_id Number Default null
119 );
120 Function Coverage_term_full_amount
121 (P_line_id Number
122 ,P_transfer_option Varchar2
123 , p_new_account_id Number
124 , p_transfer_date Date
125 , p_instance_id Number
126 , p_line_end_date Date
127 ) return varchar2;
128
129 Function Coverage_transfer_amount
130 (P_line_id Number,
131 P_transfer_option Varchar2
132 , p_new_account_id Number
133 , p_transfer_date Date
134 , p_instance_id Number) return number ;
135 --Pragma Restrict_References (Coverage_transfer_amount, WNDS);
136
137 Function Get_actual_creditamount(p_line_id Number, P_batch_id Number, P_line_type Varchar2) return Number ;
138 Function Get_actual_transferamount(p_line_id Number, P_batch_id Number, P_line_type Varchar2) return Number ;
139
140 Function Get_actual_billedamount(p_line_id Number, P_batch_id Number, P_line_type Varchar2) return Number ;
141
142
143 Function Coverage_terminate_amount
144 (P_line_id Number,
145 P_transfer_option Varchar2
146 , p_new_account_id Number
147 , p_transfer_date Date
148 , p_instance_id Number) return number ;
149
150 FUNCTION get_invoice_text (
151 p_product_item IN NUMBER,
152 p_start_date IN DATE,
153 p_end_date IN DATE
154 )RETURN VARCHAR2 ;
155
156 Function get_full_terminate_amount
157 (P_line_id IN Number,
158 P_transaction_date IN Date
159 , p_line_end_date Date
160
161 ) return Number;
162
163
164 Procedure Check_termcancel_lines
165 (
166 p_line_id Number -- TOp line id or Header Id
167 , p_line_type Varchar2 -- 'TL' or 'SL'
168 , P_txn_type Varchar2 --'T' for termination, 'C' for cancel
169 , X_date OUT NOCOPY Date
170 ) ;
171
172 Function get_BillContact_name(P_Contract_Id Number) return Varchar2;
173 Function get_salesrep_name(P_Contract_Id Number) return Varchar2;
174 Function Credit_option return Varchar2;
175
176
177
178
179 FUNCTION party_contact_info(
180 p_object1_code IN VARCHAR2,
181 p_object1_id1 IN VARCHAR2,
182 p_object1_id2 IN VARCHAR2,
183 p_org_id IN NUMBER,
184 p_info_req IN VARCHAR2 --possible values are 'NAME ,PHONE, EMAIL'
185 )
186 RETURN VARCHAR2;
187
188
189 FUNCTION get_credit_option (
190 p_Party_id IN NUMBER,
191 p_org_id IN NUMBER ,
192 P_transaction_date IN Date
193 )
194 RETURN VARCHAR2;
195
196 FUNCTION get_credit_amount_trm (
197 p_line_id IN NUMBER,
198 p_termination_date IN DATE DEFAULT NULL )
199 RETURN NUMBER ;
200
201
202 Function get_credit_amount_trf(
203 P_line_id IN Number,
204 p_new_account_id IN Number,
205 p_transfer_date IN Date)
206 RETURN NUMBER;
207
208
209 Function Check_renewed_Sublines
210 (
211 p_line_id Number
212
213 ) return Date;
214
215
216 Function Check_renewed_lines
217 (
218 p_line_id Number
219
220 ) return Date;
221
222
223 Function Check_Termination_date
224 (
225 p_line_id Number -- TOp line id or Header Id
226 , P_Line_type Varchar2 --'T' for TopLine, 'H' for Header
227 ) Return Date ;
228
229
230 Function Get_date_terminated
231 ( P_sts_code varchar2,
232 P_Transaction_date Date,
233 P_Start_date Date,
234 P_End_date Date)
235 Return Date ;
236 Procedure get_srv_name(P_line_id Number, x_service_name Out NoCopy Varchar2, x_service_description Out NoCopy varchar2);
237 Function Get_address(P_site_use_id Number) return varchar2 ;
238
239 FUNCTION get_covlvl_name
240 (
241 p_jtot_code VARCHAR2,
242 p_object1_id1 VARCHAR2,
243 p_object1_id2 VARCHAR2
244 )
245 RETURN VARCHAR2;
246
247 End OKS_IB_UTIL_PVT;
248
249
250