[Home] [Help]
PACKAGE: APPS.OKL_POPULATE_PRCENG_RESULT_PUB
Source
1 PACKAGE OKL_POPULATE_PRCENG_RESULT_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPPERS.pls 115.11 2003/10/25 22:58:23 smahapat noship $ */
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 SUBTYPE sirv_rec_type IS okl_sir_pvt.sirv_rec_type;
30 SUBTYPE srsv_rec_type IS okl_srs_pvt.srsv_rec_type;
31 SUBTYPE srmv_rec_type IS okl_srm_pvt.srmv_rec_type;
32 SUBTYPE sifv_rec_type IS okl_sif_pvt.sifv_rec_type;
33 SUBTYPE srlv_rec_type IS okl_srl_pvt.okl_sif_ret_levels_v_rec_type;
34 SUBTYPE LOG_MSG_TBL_TYPE IS Okl_Streams_Util.LOG_MSG_TBL;
35
36 -- mvasudev, 04/24/2002 added
37 PROCEDURE populate_sif_rets (
38 x_return_status OUT NOCOPY VARCHAR2,
39 x_id OUT NOCOPY NUMBER,
40 p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
41 p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
42 p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
43 p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
44 p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
45 p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
46 p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
47 p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
48 p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM
49 );
50 -- mvasudev, 04/24/2002 end
51
52 -- mvasudev, 04/24/2002 added
53 PROCEDURE update_sif_rets (
54 x_return_status OUT NOCOPY VARCHAR2,
55 p_id IN NUMBER,
56 p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM);
57 -- mvasudev, 04/24/2002 end
58
59 -- mvasudev, 04/24/2002 added
60 PROCEDURE update_sif_rets (
61 p_id IN NUMBER,
62 p_yield_name IN VARCHAR2,
63 p_amount IN NUMBER,
64 x_return_status OUT NOCOPY VARCHAR2);
65 -- mvasudev, 04/24/2002 end
66
67 PROCEDURE populate_sif_ret_strms (
68 x_return_status OUT NOCOPY VARCHAR2,
69 p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
70 p_description IN VARCHAR2 := OKC_API.G_MISS_CHAR,
71 p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
72 p_sre_date IN VARCHAR2 := OKC_API.G_MISS_CHAR,
73 p_amount IN NUMBER := OKC_API.G_MISS_NUM,
74 p_sir_id IN NUMBER := OKC_API.G_MISS_NUM);
75
76 -- mvasudev, 04/24/2002 added
77 PROCEDURE populate_sif_ret_errors (
78 x_return_status OUT NOCOPY VARCHAR2,
79 x_id OUT NOCOPY NUMBER,
80 p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
81 p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
82 p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
83 p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
84 p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
85 p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
86 p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR);
87 -- mvasudev, 04/24/2002 end
88
89 -- mvasudev, 04/24/2002 added
90 PROCEDURE populate_insured_residual (
91 p_transaction_number IN NUMBER,
92 p_amount IN NUMBER,
93 p_sir_id IN NUMBER,
94 x_return_status OUT NOCOPY VARCHAR2);
95 -- mvasudev, 04/24/2002 end
96
97 -- mvasudev, 04/24/2002 added
98 PROCEDURE update_status (
99 p_transaction_number IN NUMBER,
100 p_sis_code IN VARCHAR2, -- outbound status
101 p_srt_code IN VARCHAR2, -- inbound status
102 p_log_file_name IN VARCHAR2,
103 x_return_status OUT NOCOPY VARCHAR2);
104 -- mvasudev, 04/24/2002 end
105
106 PROCEDURE check_status (
107 p_transaction_number IN NUMBER,
108 x_ok_to_proceed OUT NOCOPY VARCHAR2,
109 x_return_status OUT NOCOPY VARCHAR2);
110
111 PROCEDURE log_error_messages (
112 p_transaction_number IN NUMBER,
113 x_return_status OUT NOCOPY VARCHAR2
114 );
115
116 PROCEDURE populate_sif_ret_levels (
117 p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
118 p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
119 p_level_index_number IN NUMBER := OKC_API.G_MISS_NUM,
120 p_number_of_periods IN NUMBER := OKC_API.G_MISS_NUM,
121 p_level_type IN OKL_SIF_RET_LEVELS.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
122 p_amount IN NUMBER := OKC_API.G_MISS_NUM,
123 p_advance_or_arrears IN OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
124 p_period IN OKL_SIF_RET_LEVELS.PERIOD%TYPE := OKC_API.G_MISS_CHAR,
125 p_lock_level_step IN OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR,
126 p_days_in_period IN NUMBER := OKC_API.G_MISS_NUM,
127 p_first_payment_date IN VARCHAR2,
128 p_rate IN NUMBER := OKC_API.G_MISS_NUM,
129 x_return_status OUT NOCOPY VARCHAR2
130 );
131
132 FUNCTION correct_feb_date (p_date VARCHAR2)
133 RETURN VARCHAR2;
134
135 END OKL_POPULATE_PRCENG_RESULT_PUB;