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,
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,
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,
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,
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
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: );
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
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:
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
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 (
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 (
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,
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,
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,
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);
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:
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:
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 (
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,
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);
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:
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
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 (
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,
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,
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,
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,
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,
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,
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,
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,
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: x_return_status OUT NOCOPY VARCHAR2
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: x_return_status OUT NOCOPY VARCHAR2
169: );
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: x_return_status OUT NOCOPY VARCHAR2
169: );
170:
171: --Added by RIRAWAT