DBA Data[Home] [Help]

APPS.OKL_POPULATE_PRCENG_RST_PUB dependencies on OKC_API

Line 71: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,

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,

Line 72: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 73: p_effective_pre_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,

Line 74: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 75: p_index_number 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

Line 76: p_effective_after_tax_yield 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: );

Line 77: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

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

Line 78: p_nominal_after_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:

Line 79: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM

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

Line 87: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM);

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 (

Line 102: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,

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 (

Line 104: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM);

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,

Line 109: 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,

Line 110: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%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,

Line 111: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%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);

Line 112: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%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:

Line 113: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,

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:

Line 114: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,

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 (

Line 115: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%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,

Line 121: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,

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);

Line 123: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%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:

Line 124: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,

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

Line 125: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR);

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 (

Line 156: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,

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,

Line 157: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,

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,

Line 158: p_level_index_number 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,

Line 159: p_number_of_periods IN NUMBER := OKC_API.G_MISS_NUM,

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,

Line 160: p_level_type IN OKL_SIF_RET_LEVELS.LEVEL_TYPE%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,

Line 161: p_amount 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,

Line 162: p_advance_or_arrears IN OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 163: p_period IN OKL_SIF_RET_LEVELS.PERIOD%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 164: p_lock_level_step IN OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR,

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

Line 165: p_days_in_period IN NUMBER := OKC_API.G_MISS_NUM,

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

Line 167: p_rate IN NUMBER := OKC_API.G_MISS_NUM,

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