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,
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,
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,
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,
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
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: );
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
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:
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
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 (
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,
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);
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:
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
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 (
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,
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,
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,
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);
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
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:
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
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 (
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,
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,
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,
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,
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,
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,
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,
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,
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
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: );
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)