[Home] [Help]
PACKAGE: APPS.OKL_ST_CODE_CONVERSIONS
Source
1 PACKAGE Okl_St_Code_Conversions AUTHID CURRENT_USER AS
2 /* $Header: OKLRSCCS.pls 120.7.12010000.2 2009/01/19 12:56:52 rgooty ship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL VARIABLES
6 ---------------------------------------------------------------------------
7 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
8 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
9 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
10 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
11 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_ST_CODE_CONVERSIONS';
12
13
14 G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
15 G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
16 G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
17 G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
18 G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
19
20 G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
21 G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
22 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
23 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
24 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
25
26 G_EXCEPTION_HALT_PROCESSING EXCEPTION;
27 G_EXCEPTION_ERROR EXCEPTION;
28 G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
29
30 G_DEFAULT_DATE_FORMAT CONSTANT VARCHAR2(10) := 'YYYY-MM-DD';
31 G_EXPENSE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_EXPENSE;
32 G_INCOME CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_INCOME;
33 G_ADVANCE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ADVANCE;
34 G_ARREARS CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_ARREARS;
35 G_FND_YES CONSTANT VARCHAR2(1) := Okl_Create_Streams_Pvt.G_FND_YES;
36 G_FND_NO CONSTANT VARCHAR2(1) := Okl_Create_Streams_Pvt.G_FND_NO;
37 G_CSM_TRUE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_CSM_TRUE;
38 G_CSM_FALSE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_CSM_FALSE;
39
40 G_LOCK_AMOUNT CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_LOCK_AMOUNT;
41 G_LOCK_RATE CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_LOCK_RATE;
42 G_LOCK_BOTH CONSTANT VARCHAR2(10) :=Okl_Create_Streams_Pvt. G_LOCK_BOTH;
43 G_MODE_LESSOR CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_LESSOR;
44 G_MODE_LENDER CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_LENDER;
45 G_MODE_BOTH CONSTANT VARCHAR2(10) := Okl_Create_Streams_Pvt.G_MODE_BOTH;
46 G_SFE_LEVEL_PAYMENT CONSTANT VARCHAR2(7) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_PAYMENT;
47 G_SFE_LEVEL_INTEREST CONSTANT VARCHAR2(8) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_INTEREST;
48 G_SFE_LEVEL_PRINCIPAL CONSTANT VARCHAR2(9) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_PRINCIPAL;
49 G_SFE_LEVEL_FUNDING CONSTANT VARCHAR2(7) := Okl_Create_Streams_Pvt.G_SFE_LEVEL_FUNDING;
50 --Added by kthiruva on 12-Sep-2005 for Variable Rate Project
51 --Bug -Start of Changes
52 G_BALANCE_RATE CONSTANT VARCHAR2(20) := Okl_Create_Streams_Pvt.G_BALANCE_RATE;
53 G_BALANCE_PAYMENT CONSTANT VARCHAR2(20) := Okl_Create_Streams_Pvt.G_BALANCE_PAYMENT;
54 G_BALANCE_TERM CONSTANT VARCHAR2(20) := Okl_Create_Streams_Pvt.G_BALANCE_TERM;
55 G_BALANCE_FUNDING CONSTANT VARCHAR2(20) := Okl_Create_Streams_Pvt.G_BALANCE_FUNDING;
56 --Bug - End of Changes
57
58
59 ---------------------------------------------------------------------------
60 -- PRCODURE CONVERT_DATE
61 ---------------------------------------------------------------------------
62 PROCEDURE CONVERT_DATE(p_date IN DATE,
63 p_date_format IN VARCHAR2,
64 x_char_date OUT NOCOPY VARCHAR2);
65
66 PROCEDURE TRANSLATE_COUNTRY(p_country IN VARCHAR2,
67 x_country OUT NOCOPY VARCHAR2);
68
69 PROCEDURE TRANSLATE_IRS_TAX_TREATMENT(p_irs_tax_treatment IN VARCHAR2,
70 x_irs_tax_treatment OUT NOCOPY VARCHAR2);
71
72 PROCEDURE TRANSLATE_FASB_TREATMENT(p_fasb_treatment IN VARCHAR2,
73 p_rvi_yn IN VARCHAR2,
74 x_fasb_treatment OUT NOCOPY VARCHAR2);
75
76 --Added by dkagrawa on 6-Oct-2005 .Introducing overloaded method
77 --Bug 4654549 - Start of Changes
78 PROCEDURE TRANSLATE_FASB_TREATMENT(p_fasb_treatment IN VARCHAR2,
79 x_fasb_treatment OUT NOCOPY VARCHAR2);
80 --Bug 4654549 - End of Changes
81
82 PROCEDURE TRANSLATE_PURCHASE_OPTION(p_purchase_option IN VARCHAR2,
83 x_purchase_option OUT NOCOPY VARCHAR2);
84
85 PROCEDURE TRANSLATE_DEPRECIATION_METHOD(p_depreciation_method IN VARCHAR2,
86 x_depreciation_method OUT NOCOPY VARCHAR2,
87 p_term IN NUMBER,
88 x_term OUT NOCOPY VARCHAR2,
89 p_salvage IN NUMBER,
90 x_salvage OUT NOCOPY NUMBER,
91 p_adr_convention IN VARCHAR2,
92 x_adr_convention OUT NOCOPY VARCHAR2);
93
94 PROCEDURE TRANSLATE_DEPRE_ADRCONVENTION(p_depreciation_adrconvention IN VARCHAR2,
95 x_depreciation_adrconvention OUT NOCOPY VARCHAR2);
96
97 PROCEDURE TRANSLATE_YN(p_yn IN VARCHAR2,
98 x_yn OUT NOCOPY VARCHAR2);
99
100 PROCEDURE TRANSLATE_PERIODICITY(p_periodicity IN VARCHAR2,
101 x_periodicity OUT NOCOPY VARCHAR2);
102
103 PROCEDURE TRANSLATE_STRUCTURE(p_structure IN VARCHAR2,
104 x_structure OUT NOCOPY VARCHAR2);
105
106 PROCEDURE TRANSLATE_STREAM_TYPE(p_stream_type_name IN VARCHAR2,
107 p_sfe_type IN VARCHAR2,
108 x_stream_type_name OUT NOCOPY VARCHAR2,
109 x_stream_type_desc OUT NOCOPY VARCHAR2);
110
111 PROCEDURE TRANSLATE_STREAM_TYPE(p_stream_type_name IN VARCHAR2,
112 p_sfe_type IN VARCHAR2,
113 p_sil_type IN VARCHAR2,
114 x_stream_type_name OUT NOCOPY VARCHAR2,
115 x_stream_type_desc OUT NOCOPY VARCHAR2);
116
117 PROCEDURE TRANSLATE_ADVANCE_ARREARS(p_advance_arrears IN VARCHAR2,
118 x_advance_arrears OUT NOCOPY VARCHAR2);
119
120
121 PROCEDURE TRANSLATE_INCOME_EXPENSE(p_income_expense IN VARCHAR2,
122 x_income_expense OUT NOCOPY VARCHAR2);
123
124 PROCEDURE TRANSLATE_PERCENTAGE(p_percentage IN NUMBER,
125 x_ratio OUT NOCOPY VARCHAR2);
126
127 PROCEDURE REVERSE_TRANSLATE_STREAM_TYPE(p_stream_type_name IN VARCHAR2,
128 p_stream_type_desc IN VARCHAR2,
129 x_stream_type_name OUT NOCOPY VARCHAR2);
130
131 PROCEDURE TRANSLATE_LOCK_LEVEL_STEP(p_lock_level_step IN VARCHAR2,
132 x_lock_amount OUT NOCOPY VARCHAR2,
133 x_lock_rate OUT NOCOPY VARCHAR2);
134
135 PROCEDURE TRANSLATE_MODE(p_mode IN VARCHAR2,
136 x_mode OUT NOCOPY VARCHAR2);
137
138 PROCEDURE TRANSLATE_FEE_LEVEL_TYPE(p_fee_level_type IN VARCHAR2,
139 x_fee_level_type OUT NOCOPY VARCHAR2);
140
141 PROCEDURE REVERSE_TRANSLATE_YN(p_yn IN VARCHAR2,
142 x_yn OUT NOCOPY VARCHAR2);
143
144 PROCEDURE REVERSE_TRANSLATE_PERIODICITY(p_periodicity IN VARCHAR2,
145 x_periodicity OUT NOCOPY VARCHAR2);
146
147 PROCEDURE TRANSLATE_NEPA(p_nominal_yn IN VARCHAR2,
148 p_pre_tax_yn IN VARCHAR2,
149 x_nepa OUT NOCOPY VARCHAR2);
150
151 PROCEDURE TRANSLATE_LOCK_LEVEL_LNSTEP(p_level_type IN VARCHAR2,
152 p_lock_level_step IN VARCHAR2,
153 x_lock_amount OUT NOCOPY VARCHAR2,
154 x_lock_rate OUT NOCOPY VARCHAR2);
155
156 PROCEDURE TRANSLATE_SIY_TYPE(p_siy_type IN VARCHAR2,
157 x_siy_type OUT NOCOPY VARCHAR2);
158
159 PROCEDURE TRANSLATE_GUARANTEE_TYPE(p_guarantee_type IN VARCHAR2,
160 x_guarantee_type OUT NOCOPY VARCHAR2);
161
162 PROCEDURE TRANSLATE_STATISTIC_INDEX(p_target_type IN VARCHAR2,
163 p_statistic_index IN VARCHAR2,
164 x_statistic_index OUT NOCOPY VARCHAR2);
165
166 --new procedure added to determine mode.
167
168 PROCEDURE GET_MODE(p_transaction_number IN NUMBER,
169 x_mode OUT NOCOPY VARCHAR2);
170
171
172 --New Procedure Added to FundingAndRate.
173
174 PROCEDURE SET_FUNDINGANDRATE (p_transaction_number In NUMBER,
175 p_fee_index In NUMBER,
176 x_FundingAndRate out NOCOPY VARCHAR2);
177
178 --Added by kthiruva on 12-Sep-2005 for Variable Rate Project
179 --Bug 4615187 -Start of Changes
180 PROCEDURE GET_BALANCE_METHOD(p_transaction_number IN NUMBER,
181 x_balance_method OUT NOCOPY VARCHAR2);
182
183 PROCEDURE CONVERT_DATE_RESTRUCT(p_date IN DATE,
184 p_date_format IN VARCHAR2,
185 p_type IN VARCHAR2,
186 p_periodicity IN VARCHAR2,
187 x_char_date OUT NOCOPY VARCHAR2);
188 --Bug 4615187 - End of Changes
189
190 -- gboomina BUG#4036384 procedure to set the description for fee with purpose
191 --code as RVI
192 PROCEDURE SET_RVI_FEE_DESCRIPTION(p_kle_id IN NUMBER,
193 p_description IN VARCHAR2,
194 x_description OUT NOCOPY VARCHAR2);
195 --Added by kthiruva on 11-Nov-2005 for the VR Build
196 --Bug 4726209 - Start of Changes
197 PROCEDURE REVERSE_TRANSLATE_ADV_OR_ARR (p_yn IN VARCHAR2,
198 x_yn OUT NOCOPY VARCHAR2);
199 --Bug 4726209 - End of Changes
200
201 --Added by kthiruva on 19-Apr-2006 to determine if a Paydown has been made on a contract
202 --Bug 5161075 - Start of Changes
203 PROCEDURE IS_PPD_AVAILABLE(p_trx_number IN NUMBER,
204 x_yn OUT NOCOPY VARCHAR2);
205 --Bug 5161075 - End of Changes
206
207 --Added by rbanerje on 03-Oct-2008 to return the decimal separator in the number format
208 --Bug 6085025 - Start of Changes
209 PROCEDURE get_decimal_separator( x_seperator OUT NOCOPY VARCHAR2 );
210 --Bug 6085025 - End of Changes
211
212 END Okl_St_Code_Conversions;