[Home] [Help]
PACKAGE: APPS.OKL_POPULATE_PRCENG_RST_PUB
Source
1 PACKAGE OKL_POPULATE_PRCENG_RST_PUB AUTHID CURRENT_USER AS
2 /*$Header: OKLPPRSS.pls 120.1.12020000.2 2013/02/20 11:18:47 racheruv ship $*/
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL VARIABLES
6 ---------------------------------------------------------------------------
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_POPULATE_PR_ENG_RESULT_PUB';
8
9 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
10 G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
11 G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
12 G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
13 G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
14 G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
15
16 G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
17 G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
18 G_EXC_NAME_OTHERS CONSTANT VARCHAR2(6) := 'OTHERS';
19 G_API_TYPE CONSTANT VARCHAR(4) := '_PUB';
20 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
21 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
22 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
23
24
25 G_EXCEPTION_HALT_PROCESSING EXCEPTION;
26 G_EXCEPTION_ERROR EXCEPTION;
27 G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
28
29 --Added by KTHIRUVA for the Inbound Parser Changes
30 G_XMLG_RECEIVE_EVENT CONSTANT VARCHAR2(50) := 'oracle.apps.okl.inbound.lease.receive';
31
32 --Added by BKATRAGA
33 --Bug - Start of Changes
34 TYPE strm_rec_type IS RECORD (
35 strm_name OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE,
36 strm_desc VARCHAR2(150),
37 sre_date VARCHAR2(30),
38 amount NUMBER,
39 --Added by kthiruva for Streams Performance
40 --Bug 4346646 - Start of Changes
41 index_number NUMBER
42 --Bug 4346646 - End of Changes
43 );
44
45 TYPE strm_tbl_type IS TABLE OF strm_rec_type
46 INDEX BY BINARY_INTEGER;
47
48 TYPE strm_excp_rec_type IS RECORD (
49 error_code OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE,
50 error_message OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE,
51 tag_name OKL_SIF_RET_ERRORS.TAG_NAME%TYPE
52 );
53
54 TYPE strm_excp_tbl_type IS TABLE OF strm_excp_rec_type
55 INDEX BY BINARY_INTEGER;
56
57 SUBTYPE srsv_tbl_type IS okl_srs_pvt.srsv_tbl_type;
58 --Bug - End of Changes
59
60 SUBTYPE sirv_rec_type IS okl_sir_pvt.sirv_rec_type;
61 SUBTYPE srsv_rec_type IS okl_srs_pvt.srsv_rec_type;
62 SUBTYPE srmv_rec_type IS okl_srm_pvt.srmv_rec_type;
63 SUBTYPE sifv_rec_type IS okl_sif_pvt.sifv_rec_type;
64 SUBTYPE srlv_rec_type IS okl_srl_pvt.okl_sif_ret_levels_v_rec_type;
65 SUBTYPE LOG_MSG_TBL_TYPE IS Okl_Streams_Util.LOG_MSG_TBL;
66
67 -- mvasudev, 04/24/2002 added
68 PROCEDURE populate_sif_rets (
69 x_return_status OUT NOCOPY VARCHAR2,
70 x_id OUT NOCOPY NUMBER,
71 p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
72 p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
73 p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
74 p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
75 p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
76 p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
77 p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
78 p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
79 p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM
80 );
81 -- mvasudev, 04/24/2002 end
82
83 -- mvasudev, 04/24/2002 added
84 PROCEDURE update_sif_rets (
85 x_return_status OUT NOCOPY VARCHAR2,
86 p_id IN NUMBER,
87 p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM);
88 -- mvasudev, 04/24/2002 end
89
90 -- mvasudev, 04/24/2002 added
91 PROCEDURE update_sif_rets (
92 p_id IN NUMBER,
93 p_yield_name IN VARCHAR2,
94 p_amount IN NUMBER,
95 x_return_status OUT NOCOPY VARCHAR2);
96 -- mvasudev, 04/24/2002 end
97
98 --Modified by BKATRAGA
99 --Bug - Start of Changes
100 PROCEDURE populate_sif_ret_strms (
101 x_return_status OUT NOCOPY VARCHAR2,
102 p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
103 p_strm_tbl IN strm_tbl_type,
104 p_sir_id IN NUMBER := OKC_API.G_MISS_NUM);
105
106 PROCEDURE populate_sif_ret_errors (
107 x_return_status OUT NOCOPY VARCHAR2,
108 x_id OUT NOCOPY NUMBER,
109 p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
110 p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
111 p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
112 p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
113 p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
114 p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
115 p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR);
116
117
118 PROCEDURE populate_sif_ret_errors (
119 x_return_status OUT NOCOPY VARCHAR2,
120 x_id OUT NOCOPY NUMBER,
121 p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
122 p_strm_excp_tbl IN strm_excp_tbl_type,
123 p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
124 p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
125 p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR);
126 -- Bug -End Of Changes
127
128 -- mvasudev, 04/24/2002 added
129 PROCEDURE populate_insured_residual (
130 p_transaction_number IN NUMBER,
131 p_amount IN NUMBER,
132 p_sir_id IN NUMBER,
133 x_return_status OUT NOCOPY VARCHAR2);
134 -- mvasudev, 04/24/2002 end
135
136 -- mvasudev, 04/24/2002 added
137 PROCEDURE update_status (
138 p_transaction_number IN NUMBER,
139 p_sis_code IN VARCHAR2, -- outbound status
140 p_srt_code IN VARCHAR2, -- inbound status
141 p_log_file_name IN VARCHAR2,
142 x_return_status OUT NOCOPY VARCHAR2);
143 -- mvasudev, 04/24/2002 end
144
145 PROCEDURE check_status (
146 p_transaction_number IN NUMBER,
147 x_ok_to_proceed OUT NOCOPY VARCHAR2,
148 x_return_status OUT NOCOPY VARCHAR2);
149
150 PROCEDURE log_error_messages (
151 p_transaction_number IN NUMBER,
152 x_return_status OUT NOCOPY VARCHAR2
153 );
154
155 PROCEDURE populate_sif_ret_levels (
156 p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
157 p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
158 p_level_index_number IN NUMBER := OKC_API.G_MISS_NUM,
159 p_number_of_periods IN NUMBER := OKC_API.G_MISS_NUM,
160 p_level_type IN OKL_SIF_RET_LEVELS.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
161 p_amount IN NUMBER := OKC_API.G_MISS_NUM,
162 p_advance_or_arrears IN OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
163 p_period IN OKL_SIF_RET_LEVELS.PERIOD%TYPE := OKC_API.G_MISS_CHAR,
164 p_lock_level_step IN OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR,
165 p_days_in_period IN NUMBER := OKC_API.G_MISS_NUM,
166 p_first_payment_date IN VARCHAR2,
167 p_rate IN NUMBER := OKC_API.G_MISS_NUM,
168 p_reamort_balance IN NUMBER := OKC_API.G_MISS_NUM,
169 p_reamort_date IN VARCHAR2,
170 x_return_status OUT NOCOPY VARCHAR2
171 );
172
173 --Added by RIRAWAT
174 -- This procedure has been added to replace the call to the Inbound Workflow.
175 -- The method Okl_Process_Streams_Pvt.process_stream_results is now being called
176 -- directly instead of invoking it through the workflow.
177 PROCEDURE process( p_transaction_number IN NUMBER,
178 resultout OUT NOCOPY VARCHAR2);
179
180 FUNCTION correct_feb_date (p_date VARCHAR2)
181 RETURN VARCHAR2;
182
183 --Added by KTHIRUVA
184 -- This procedure has been added to raise a business event once the call to
185 -- Okl_Process_Streams_Pvt.process_stream_results completes
186 PROCEDURE raise_business_event(p_transaction_number IN NUMBER,
187 x_return_status OUT NOCOPY VARCHAR2);
188
189 END OKL_POPULATE_PRCENG_RST_PUB;