90: NULL;
91: END api_copy;
92:
93: ---------------------------------------------------------------------------
94: -- FUNCTION get_rec for: OKL_SIF_RET_LEVELS_V
95: ---------------------------------------------------------------------------
96: FUNCTION get_rec (
97: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN
93: ---------------------------------------------------------------------------
94: -- FUNCTION get_rec for: OKL_SIF_RET_LEVELS_V
95: ---------------------------------------------------------------------------
96: FUNCTION get_rec (
97: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN
99: ) RETURN okl_sif_ret_levels_v_rec_type IS
100: CURSOR srlv_pk_csr (p_id IN NUMBER) IS
101: SELECT
95: ---------------------------------------------------------------------------
96: FUNCTION get_rec (
97: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN
99: ) RETURN okl_sif_ret_levels_v_rec_type IS
100: CURSOR srlv_pk_csr (p_id IN NUMBER) IS
101: SELECT
102: ID,
103: LEVEL_INDEX_NUMBER,
134: LAST_UPDATE_LOGIN,
135: RATE,
136: REAMORT_BALANCE,
137: REAMORT_DATE
138: FROM Okl_Sif_Ret_Levels_V
139: WHERE okl_sif_ret_levels_v.id = p_id;
140: l_srlv_pk srlv_pk_csr%ROWTYPE;
141: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type;
142: BEGIN
135: RATE,
136: REAMORT_BALANCE,
137: REAMORT_DATE
138: FROM Okl_Sif_Ret_Levels_V
139: WHERE okl_sif_ret_levels_v.id = p_id;
140: l_srlv_pk srlv_pk_csr%ROWTYPE;
141: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type;
142: BEGIN
143: x_no_data_found := TRUE;
137: REAMORT_DATE
138: FROM Okl_Sif_Ret_Levels_V
139: WHERE okl_sif_ret_levels_v.id = p_id;
140: l_srlv_pk srlv_pk_csr%ROWTYPE;
141: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type;
142: BEGIN
143: x_no_data_found := TRUE;
144: -- Get current database values
145: OPEN srlv_pk_csr (p_okl_sif_ret_levels_v_rec.id);
141: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type;
142: BEGIN
143: x_no_data_found := TRUE;
144: -- Get current database values
145: OPEN srlv_pk_csr (p_okl_sif_ret_levels_v_rec.id);
146: FETCH srlv_pk_csr INTO
147: l_okl_sif_ret_levels_v_rec.id,
148: l_okl_sif_ret_levels_v_rec.level_index_number,
149: l_okl_sif_ret_levels_v_rec.number_of_periods,
143: x_no_data_found := TRUE;
144: -- Get current database values
145: OPEN srlv_pk_csr (p_okl_sif_ret_levels_v_rec.id);
146: FETCH srlv_pk_csr INTO
147: l_okl_sif_ret_levels_v_rec.id,
148: l_okl_sif_ret_levels_v_rec.level_index_number,
149: l_okl_sif_ret_levels_v_rec.number_of_periods,
150: l_okl_sif_ret_levels_v_rec.sir_id,
151: l_okl_sif_ret_levels_v_rec.index_number,
144: -- Get current database values
145: OPEN srlv_pk_csr (p_okl_sif_ret_levels_v_rec.id);
146: FETCH srlv_pk_csr INTO
147: l_okl_sif_ret_levels_v_rec.id,
148: l_okl_sif_ret_levels_v_rec.level_index_number,
149: l_okl_sif_ret_levels_v_rec.number_of_periods,
150: l_okl_sif_ret_levels_v_rec.sir_id,
151: l_okl_sif_ret_levels_v_rec.index_number,
152: l_okl_sif_ret_levels_v_rec.level_type,
145: OPEN srlv_pk_csr (p_okl_sif_ret_levels_v_rec.id);
146: FETCH srlv_pk_csr INTO
147: l_okl_sif_ret_levels_v_rec.id,
148: l_okl_sif_ret_levels_v_rec.level_index_number,
149: l_okl_sif_ret_levels_v_rec.number_of_periods,
150: l_okl_sif_ret_levels_v_rec.sir_id,
151: l_okl_sif_ret_levels_v_rec.index_number,
152: l_okl_sif_ret_levels_v_rec.level_type,
153: l_okl_sif_ret_levels_v_rec.amount,
146: FETCH srlv_pk_csr INTO
147: l_okl_sif_ret_levels_v_rec.id,
148: l_okl_sif_ret_levels_v_rec.level_index_number,
149: l_okl_sif_ret_levels_v_rec.number_of_periods,
150: l_okl_sif_ret_levels_v_rec.sir_id,
151: l_okl_sif_ret_levels_v_rec.index_number,
152: l_okl_sif_ret_levels_v_rec.level_type,
153: l_okl_sif_ret_levels_v_rec.amount,
154: l_okl_sif_ret_levels_v_rec.advance_or_arrears,
147: l_okl_sif_ret_levels_v_rec.id,
148: l_okl_sif_ret_levels_v_rec.level_index_number,
149: l_okl_sif_ret_levels_v_rec.number_of_periods,
150: l_okl_sif_ret_levels_v_rec.sir_id,
151: l_okl_sif_ret_levels_v_rec.index_number,
152: l_okl_sif_ret_levels_v_rec.level_type,
153: l_okl_sif_ret_levels_v_rec.amount,
154: l_okl_sif_ret_levels_v_rec.advance_or_arrears,
155: l_okl_sif_ret_levels_v_rec.period,
148: l_okl_sif_ret_levels_v_rec.level_index_number,
149: l_okl_sif_ret_levels_v_rec.number_of_periods,
150: l_okl_sif_ret_levels_v_rec.sir_id,
151: l_okl_sif_ret_levels_v_rec.index_number,
152: l_okl_sif_ret_levels_v_rec.level_type,
153: l_okl_sif_ret_levels_v_rec.amount,
154: l_okl_sif_ret_levels_v_rec.advance_or_arrears,
155: l_okl_sif_ret_levels_v_rec.period,
156: l_okl_sif_ret_levels_v_rec.lock_level_step,
149: l_okl_sif_ret_levels_v_rec.number_of_periods,
150: l_okl_sif_ret_levels_v_rec.sir_id,
151: l_okl_sif_ret_levels_v_rec.index_number,
152: l_okl_sif_ret_levels_v_rec.level_type,
153: l_okl_sif_ret_levels_v_rec.amount,
154: l_okl_sif_ret_levels_v_rec.advance_or_arrears,
155: l_okl_sif_ret_levels_v_rec.period,
156: l_okl_sif_ret_levels_v_rec.lock_level_step,
157: l_okl_sif_ret_levels_v_rec.days_in_period,
150: l_okl_sif_ret_levels_v_rec.sir_id,
151: l_okl_sif_ret_levels_v_rec.index_number,
152: l_okl_sif_ret_levels_v_rec.level_type,
153: l_okl_sif_ret_levels_v_rec.amount,
154: l_okl_sif_ret_levels_v_rec.advance_or_arrears,
155: l_okl_sif_ret_levels_v_rec.period,
156: l_okl_sif_ret_levels_v_rec.lock_level_step,
157: l_okl_sif_ret_levels_v_rec.days_in_period,
158: l_okl_sif_ret_levels_v_rec.first_payment_date,
151: l_okl_sif_ret_levels_v_rec.index_number,
152: l_okl_sif_ret_levels_v_rec.level_type,
153: l_okl_sif_ret_levels_v_rec.amount,
154: l_okl_sif_ret_levels_v_rec.advance_or_arrears,
155: l_okl_sif_ret_levels_v_rec.period,
156: l_okl_sif_ret_levels_v_rec.lock_level_step,
157: l_okl_sif_ret_levels_v_rec.days_in_period,
158: l_okl_sif_ret_levels_v_rec.first_payment_date,
159: l_okl_sif_ret_levels_v_rec.object_version_number,
152: l_okl_sif_ret_levels_v_rec.level_type,
153: l_okl_sif_ret_levels_v_rec.amount,
154: l_okl_sif_ret_levels_v_rec.advance_or_arrears,
155: l_okl_sif_ret_levels_v_rec.period,
156: l_okl_sif_ret_levels_v_rec.lock_level_step,
157: l_okl_sif_ret_levels_v_rec.days_in_period,
158: l_okl_sif_ret_levels_v_rec.first_payment_date,
159: l_okl_sif_ret_levels_v_rec.object_version_number,
160: l_okl_sif_ret_levels_v_rec.stream_interface_attribute1,
153: l_okl_sif_ret_levels_v_rec.amount,
154: l_okl_sif_ret_levels_v_rec.advance_or_arrears,
155: l_okl_sif_ret_levels_v_rec.period,
156: l_okl_sif_ret_levels_v_rec.lock_level_step,
157: l_okl_sif_ret_levels_v_rec.days_in_period,
158: l_okl_sif_ret_levels_v_rec.first_payment_date,
159: l_okl_sif_ret_levels_v_rec.object_version_number,
160: l_okl_sif_ret_levels_v_rec.stream_interface_attribute1,
161: l_okl_sif_ret_levels_v_rec.stream_interface_attribute2,
154: l_okl_sif_ret_levels_v_rec.advance_or_arrears,
155: l_okl_sif_ret_levels_v_rec.period,
156: l_okl_sif_ret_levels_v_rec.lock_level_step,
157: l_okl_sif_ret_levels_v_rec.days_in_period,
158: l_okl_sif_ret_levels_v_rec.first_payment_date,
159: l_okl_sif_ret_levels_v_rec.object_version_number,
160: l_okl_sif_ret_levels_v_rec.stream_interface_attribute1,
161: l_okl_sif_ret_levels_v_rec.stream_interface_attribute2,
162: l_okl_sif_ret_levels_v_rec.stream_interface_attribute3,
155: l_okl_sif_ret_levels_v_rec.period,
156: l_okl_sif_ret_levels_v_rec.lock_level_step,
157: l_okl_sif_ret_levels_v_rec.days_in_period,
158: l_okl_sif_ret_levels_v_rec.first_payment_date,
159: l_okl_sif_ret_levels_v_rec.object_version_number,
160: l_okl_sif_ret_levels_v_rec.stream_interface_attribute1,
161: l_okl_sif_ret_levels_v_rec.stream_interface_attribute2,
162: l_okl_sif_ret_levels_v_rec.stream_interface_attribute3,
163: l_okl_sif_ret_levels_v_rec.stream_interface_attribute4,
156: l_okl_sif_ret_levels_v_rec.lock_level_step,
157: l_okl_sif_ret_levels_v_rec.days_in_period,
158: l_okl_sif_ret_levels_v_rec.first_payment_date,
159: l_okl_sif_ret_levels_v_rec.object_version_number,
160: l_okl_sif_ret_levels_v_rec.stream_interface_attribute1,
161: l_okl_sif_ret_levels_v_rec.stream_interface_attribute2,
162: l_okl_sif_ret_levels_v_rec.stream_interface_attribute3,
163: l_okl_sif_ret_levels_v_rec.stream_interface_attribute4,
164: l_okl_sif_ret_levels_v_rec.stream_interface_attribute5,
157: l_okl_sif_ret_levels_v_rec.days_in_period,
158: l_okl_sif_ret_levels_v_rec.first_payment_date,
159: l_okl_sif_ret_levels_v_rec.object_version_number,
160: l_okl_sif_ret_levels_v_rec.stream_interface_attribute1,
161: l_okl_sif_ret_levels_v_rec.stream_interface_attribute2,
162: l_okl_sif_ret_levels_v_rec.stream_interface_attribute3,
163: l_okl_sif_ret_levels_v_rec.stream_interface_attribute4,
164: l_okl_sif_ret_levels_v_rec.stream_interface_attribute5,
165: l_okl_sif_ret_levels_v_rec.stream_interface_attribute6,
158: l_okl_sif_ret_levels_v_rec.first_payment_date,
159: l_okl_sif_ret_levels_v_rec.object_version_number,
160: l_okl_sif_ret_levels_v_rec.stream_interface_attribute1,
161: l_okl_sif_ret_levels_v_rec.stream_interface_attribute2,
162: l_okl_sif_ret_levels_v_rec.stream_interface_attribute3,
163: l_okl_sif_ret_levels_v_rec.stream_interface_attribute4,
164: l_okl_sif_ret_levels_v_rec.stream_interface_attribute5,
165: l_okl_sif_ret_levels_v_rec.stream_interface_attribute6,
166: l_okl_sif_ret_levels_v_rec.stream_interface_attribute7,
159: l_okl_sif_ret_levels_v_rec.object_version_number,
160: l_okl_sif_ret_levels_v_rec.stream_interface_attribute1,
161: l_okl_sif_ret_levels_v_rec.stream_interface_attribute2,
162: l_okl_sif_ret_levels_v_rec.stream_interface_attribute3,
163: l_okl_sif_ret_levels_v_rec.stream_interface_attribute4,
164: l_okl_sif_ret_levels_v_rec.stream_interface_attribute5,
165: l_okl_sif_ret_levels_v_rec.stream_interface_attribute6,
166: l_okl_sif_ret_levels_v_rec.stream_interface_attribute7,
167: l_okl_sif_ret_levels_v_rec.stream_interface_attribute8,
160: l_okl_sif_ret_levels_v_rec.stream_interface_attribute1,
161: l_okl_sif_ret_levels_v_rec.stream_interface_attribute2,
162: l_okl_sif_ret_levels_v_rec.stream_interface_attribute3,
163: l_okl_sif_ret_levels_v_rec.stream_interface_attribute4,
164: l_okl_sif_ret_levels_v_rec.stream_interface_attribute5,
165: l_okl_sif_ret_levels_v_rec.stream_interface_attribute6,
166: l_okl_sif_ret_levels_v_rec.stream_interface_attribute7,
167: l_okl_sif_ret_levels_v_rec.stream_interface_attribute8,
168: l_okl_sif_ret_levels_v_rec.stream_interface_attribute9,
161: l_okl_sif_ret_levels_v_rec.stream_interface_attribute2,
162: l_okl_sif_ret_levels_v_rec.stream_interface_attribute3,
163: l_okl_sif_ret_levels_v_rec.stream_interface_attribute4,
164: l_okl_sif_ret_levels_v_rec.stream_interface_attribute5,
165: l_okl_sif_ret_levels_v_rec.stream_interface_attribute6,
166: l_okl_sif_ret_levels_v_rec.stream_interface_attribute7,
167: l_okl_sif_ret_levels_v_rec.stream_interface_attribute8,
168: l_okl_sif_ret_levels_v_rec.stream_interface_attribute9,
169: l_okl_sif_ret_levels_v_rec.stream_interface_attribute10,
162: l_okl_sif_ret_levels_v_rec.stream_interface_attribute3,
163: l_okl_sif_ret_levels_v_rec.stream_interface_attribute4,
164: l_okl_sif_ret_levels_v_rec.stream_interface_attribute5,
165: l_okl_sif_ret_levels_v_rec.stream_interface_attribute6,
166: l_okl_sif_ret_levels_v_rec.stream_interface_attribute7,
167: l_okl_sif_ret_levels_v_rec.stream_interface_attribute8,
168: l_okl_sif_ret_levels_v_rec.stream_interface_attribute9,
169: l_okl_sif_ret_levels_v_rec.stream_interface_attribute10,
170: l_okl_sif_ret_levels_v_rec.stream_interface_attribute11,
163: l_okl_sif_ret_levels_v_rec.stream_interface_attribute4,
164: l_okl_sif_ret_levels_v_rec.stream_interface_attribute5,
165: l_okl_sif_ret_levels_v_rec.stream_interface_attribute6,
166: l_okl_sif_ret_levels_v_rec.stream_interface_attribute7,
167: l_okl_sif_ret_levels_v_rec.stream_interface_attribute8,
168: l_okl_sif_ret_levels_v_rec.stream_interface_attribute9,
169: l_okl_sif_ret_levels_v_rec.stream_interface_attribute10,
170: l_okl_sif_ret_levels_v_rec.stream_interface_attribute11,
171: l_okl_sif_ret_levels_v_rec.stream_interface_attribute12,
164: l_okl_sif_ret_levels_v_rec.stream_interface_attribute5,
165: l_okl_sif_ret_levels_v_rec.stream_interface_attribute6,
166: l_okl_sif_ret_levels_v_rec.stream_interface_attribute7,
167: l_okl_sif_ret_levels_v_rec.stream_interface_attribute8,
168: l_okl_sif_ret_levels_v_rec.stream_interface_attribute9,
169: l_okl_sif_ret_levels_v_rec.stream_interface_attribute10,
170: l_okl_sif_ret_levels_v_rec.stream_interface_attribute11,
171: l_okl_sif_ret_levels_v_rec.stream_interface_attribute12,
172: l_okl_sif_ret_levels_v_rec.stream_interface_attribute13,
165: l_okl_sif_ret_levels_v_rec.stream_interface_attribute6,
166: l_okl_sif_ret_levels_v_rec.stream_interface_attribute7,
167: l_okl_sif_ret_levels_v_rec.stream_interface_attribute8,
168: l_okl_sif_ret_levels_v_rec.stream_interface_attribute9,
169: l_okl_sif_ret_levels_v_rec.stream_interface_attribute10,
170: l_okl_sif_ret_levels_v_rec.stream_interface_attribute11,
171: l_okl_sif_ret_levels_v_rec.stream_interface_attribute12,
172: l_okl_sif_ret_levels_v_rec.stream_interface_attribute13,
173: l_okl_sif_ret_levels_v_rec.stream_interface_attribute14,
166: l_okl_sif_ret_levels_v_rec.stream_interface_attribute7,
167: l_okl_sif_ret_levels_v_rec.stream_interface_attribute8,
168: l_okl_sif_ret_levels_v_rec.stream_interface_attribute9,
169: l_okl_sif_ret_levels_v_rec.stream_interface_attribute10,
170: l_okl_sif_ret_levels_v_rec.stream_interface_attribute11,
171: l_okl_sif_ret_levels_v_rec.stream_interface_attribute12,
172: l_okl_sif_ret_levels_v_rec.stream_interface_attribute13,
173: l_okl_sif_ret_levels_v_rec.stream_interface_attribute14,
174: l_okl_sif_ret_levels_v_rec.stream_interface_attribute15,
167: l_okl_sif_ret_levels_v_rec.stream_interface_attribute8,
168: l_okl_sif_ret_levels_v_rec.stream_interface_attribute9,
169: l_okl_sif_ret_levels_v_rec.stream_interface_attribute10,
170: l_okl_sif_ret_levels_v_rec.stream_interface_attribute11,
171: l_okl_sif_ret_levels_v_rec.stream_interface_attribute12,
172: l_okl_sif_ret_levels_v_rec.stream_interface_attribute13,
173: l_okl_sif_ret_levels_v_rec.stream_interface_attribute14,
174: l_okl_sif_ret_levels_v_rec.stream_interface_attribute15,
175: l_okl_sif_ret_levels_v_rec.creation_date,
168: l_okl_sif_ret_levels_v_rec.stream_interface_attribute9,
169: l_okl_sif_ret_levels_v_rec.stream_interface_attribute10,
170: l_okl_sif_ret_levels_v_rec.stream_interface_attribute11,
171: l_okl_sif_ret_levels_v_rec.stream_interface_attribute12,
172: l_okl_sif_ret_levels_v_rec.stream_interface_attribute13,
173: l_okl_sif_ret_levels_v_rec.stream_interface_attribute14,
174: l_okl_sif_ret_levels_v_rec.stream_interface_attribute15,
175: l_okl_sif_ret_levels_v_rec.creation_date,
176: l_okl_sif_ret_levels_v_rec.created_by,
169: l_okl_sif_ret_levels_v_rec.stream_interface_attribute10,
170: l_okl_sif_ret_levels_v_rec.stream_interface_attribute11,
171: l_okl_sif_ret_levels_v_rec.stream_interface_attribute12,
172: l_okl_sif_ret_levels_v_rec.stream_interface_attribute13,
173: l_okl_sif_ret_levels_v_rec.stream_interface_attribute14,
174: l_okl_sif_ret_levels_v_rec.stream_interface_attribute15,
175: l_okl_sif_ret_levels_v_rec.creation_date,
176: l_okl_sif_ret_levels_v_rec.created_by,
177: l_okl_sif_ret_levels_v_rec.last_update_date,
170: l_okl_sif_ret_levels_v_rec.stream_interface_attribute11,
171: l_okl_sif_ret_levels_v_rec.stream_interface_attribute12,
172: l_okl_sif_ret_levels_v_rec.stream_interface_attribute13,
173: l_okl_sif_ret_levels_v_rec.stream_interface_attribute14,
174: l_okl_sif_ret_levels_v_rec.stream_interface_attribute15,
175: l_okl_sif_ret_levels_v_rec.creation_date,
176: l_okl_sif_ret_levels_v_rec.created_by,
177: l_okl_sif_ret_levels_v_rec.last_update_date,
178: l_okl_sif_ret_levels_v_rec.last_updated_by,
171: l_okl_sif_ret_levels_v_rec.stream_interface_attribute12,
172: l_okl_sif_ret_levels_v_rec.stream_interface_attribute13,
173: l_okl_sif_ret_levels_v_rec.stream_interface_attribute14,
174: l_okl_sif_ret_levels_v_rec.stream_interface_attribute15,
175: l_okl_sif_ret_levels_v_rec.creation_date,
176: l_okl_sif_ret_levels_v_rec.created_by,
177: l_okl_sif_ret_levels_v_rec.last_update_date,
178: l_okl_sif_ret_levels_v_rec.last_updated_by,
179: l_okl_sif_ret_levels_v_rec.last_update_login,
172: l_okl_sif_ret_levels_v_rec.stream_interface_attribute13,
173: l_okl_sif_ret_levels_v_rec.stream_interface_attribute14,
174: l_okl_sif_ret_levels_v_rec.stream_interface_attribute15,
175: l_okl_sif_ret_levels_v_rec.creation_date,
176: l_okl_sif_ret_levels_v_rec.created_by,
177: l_okl_sif_ret_levels_v_rec.last_update_date,
178: l_okl_sif_ret_levels_v_rec.last_updated_by,
179: l_okl_sif_ret_levels_v_rec.last_update_login,
180: l_okl_sif_ret_levels_v_rec.rate,
173: l_okl_sif_ret_levels_v_rec.stream_interface_attribute14,
174: l_okl_sif_ret_levels_v_rec.stream_interface_attribute15,
175: l_okl_sif_ret_levels_v_rec.creation_date,
176: l_okl_sif_ret_levels_v_rec.created_by,
177: l_okl_sif_ret_levels_v_rec.last_update_date,
178: l_okl_sif_ret_levels_v_rec.last_updated_by,
179: l_okl_sif_ret_levels_v_rec.last_update_login,
180: l_okl_sif_ret_levels_v_rec.rate,
181: l_okl_sif_ret_levels_v_rec.reamort_balance,
174: l_okl_sif_ret_levels_v_rec.stream_interface_attribute15,
175: l_okl_sif_ret_levels_v_rec.creation_date,
176: l_okl_sif_ret_levels_v_rec.created_by,
177: l_okl_sif_ret_levels_v_rec.last_update_date,
178: l_okl_sif_ret_levels_v_rec.last_updated_by,
179: l_okl_sif_ret_levels_v_rec.last_update_login,
180: l_okl_sif_ret_levels_v_rec.rate,
181: l_okl_sif_ret_levels_v_rec.reamort_balance,
182: l_okl_sif_ret_levels_v_rec.reamort_date; -- racheruv 18.02.2013
175: l_okl_sif_ret_levels_v_rec.creation_date,
176: l_okl_sif_ret_levels_v_rec.created_by,
177: l_okl_sif_ret_levels_v_rec.last_update_date,
178: l_okl_sif_ret_levels_v_rec.last_updated_by,
179: l_okl_sif_ret_levels_v_rec.last_update_login,
180: l_okl_sif_ret_levels_v_rec.rate,
181: l_okl_sif_ret_levels_v_rec.reamort_balance,
182: l_okl_sif_ret_levels_v_rec.reamort_date; -- racheruv 18.02.2013
183: x_no_data_found := srlv_pk_csr%NOTFOUND;
176: l_okl_sif_ret_levels_v_rec.created_by,
177: l_okl_sif_ret_levels_v_rec.last_update_date,
178: l_okl_sif_ret_levels_v_rec.last_updated_by,
179: l_okl_sif_ret_levels_v_rec.last_update_login,
180: l_okl_sif_ret_levels_v_rec.rate,
181: l_okl_sif_ret_levels_v_rec.reamort_balance,
182: l_okl_sif_ret_levels_v_rec.reamort_date; -- racheruv 18.02.2013
183: x_no_data_found := srlv_pk_csr%NOTFOUND;
184: CLOSE srlv_pk_csr;
177: l_okl_sif_ret_levels_v_rec.last_update_date,
178: l_okl_sif_ret_levels_v_rec.last_updated_by,
179: l_okl_sif_ret_levels_v_rec.last_update_login,
180: l_okl_sif_ret_levels_v_rec.rate,
181: l_okl_sif_ret_levels_v_rec.reamort_balance,
182: l_okl_sif_ret_levels_v_rec.reamort_date; -- racheruv 18.02.2013
183: x_no_data_found := srlv_pk_csr%NOTFOUND;
184: CLOSE srlv_pk_csr;
185: RETURN(l_okl_sif_ret_levels_v_rec);
178: l_okl_sif_ret_levels_v_rec.last_updated_by,
179: l_okl_sif_ret_levels_v_rec.last_update_login,
180: l_okl_sif_ret_levels_v_rec.rate,
181: l_okl_sif_ret_levels_v_rec.reamort_balance,
182: l_okl_sif_ret_levels_v_rec.reamort_date; -- racheruv 18.02.2013
183: x_no_data_found := srlv_pk_csr%NOTFOUND;
184: CLOSE srlv_pk_csr;
185: RETURN(l_okl_sif_ret_levels_v_rec);
186: END get_rec;
181: l_okl_sif_ret_levels_v_rec.reamort_balance,
182: l_okl_sif_ret_levels_v_rec.reamort_date; -- racheruv 18.02.2013
183: x_no_data_found := srlv_pk_csr%NOTFOUND;
184: CLOSE srlv_pk_csr;
185: RETURN(l_okl_sif_ret_levels_v_rec);
186: END get_rec;
187:
188: ------------------------------------------------------------------
189: -- This version of get_rec sets error messages if no data found --
188: ------------------------------------------------------------------
189: -- This version of get_rec sets error messages if no data found --
190: ------------------------------------------------------------------
191: FUNCTION get_rec (
192: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
193: x_return_status OUT NOCOPY VARCHAR2
194: ) RETURN okl_sif_ret_levels_v_rec_type IS
195: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type;
196: l_row_notfound BOOLEAN := TRUE;
190: ------------------------------------------------------------------
191: FUNCTION get_rec (
192: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
193: x_return_status OUT NOCOPY VARCHAR2
194: ) RETURN okl_sif_ret_levels_v_rec_type IS
195: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type;
196: l_row_notfound BOOLEAN := TRUE;
197: BEGIN
198: x_return_status := OKC_API.G_RET_STS_SUCCESS;
191: FUNCTION get_rec (
192: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
193: x_return_status OUT NOCOPY VARCHAR2
194: ) RETURN okl_sif_ret_levels_v_rec_type IS
195: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type;
196: l_row_notfound BOOLEAN := TRUE;
197: BEGIN
198: x_return_status := OKC_API.G_RET_STS_SUCCESS;
199: l_okl_sif_ret_levels_v_rec := get_rec(p_okl_sif_ret_levels_v_rec, l_row_notfound);
195: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type;
196: l_row_notfound BOOLEAN := TRUE;
197: BEGIN
198: x_return_status := OKC_API.G_RET_STS_SUCCESS;
199: l_okl_sif_ret_levels_v_rec := get_rec(p_okl_sif_ret_levels_v_rec, l_row_notfound);
200: IF (l_row_notfound) THEN
201: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
202: x_return_status := OKC_API.G_RET_STS_ERROR;
203: END IF;
200: IF (l_row_notfound) THEN
201: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
202: x_return_status := OKC_API.G_RET_STS_ERROR;
203: END IF;
204: RETURN(l_okl_sif_ret_levels_v_rec);
205: END get_rec;
206: -----------------------------------------------------------
207: -- So we don't have to pass an "l_row_notfound" variable --
208: -----------------------------------------------------------
206: -----------------------------------------------------------
207: -- So we don't have to pass an "l_row_notfound" variable --
208: -----------------------------------------------------------
209: FUNCTION get_rec (
210: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
211: ) RETURN okl_sif_ret_levels_v_rec_type IS
212: l_row_not_found BOOLEAN := TRUE;
213: BEGIN
214: RETURN(get_rec(p_okl_sif_ret_levels_v_rec, l_row_not_found));
207: -- So we don't have to pass an "l_row_notfound" variable --
208: -----------------------------------------------------------
209: FUNCTION get_rec (
210: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
211: ) RETURN okl_sif_ret_levels_v_rec_type IS
212: l_row_not_found BOOLEAN := TRUE;
213: BEGIN
214: RETURN(get_rec(p_okl_sif_ret_levels_v_rec, l_row_not_found));
215: END get_rec;
210: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
211: ) RETURN okl_sif_ret_levels_v_rec_type IS
212: l_row_not_found BOOLEAN := TRUE;
213: BEGIN
214: RETURN(get_rec(p_okl_sif_ret_levels_v_rec, l_row_not_found));
215: END get_rec;
216: ---------------------------------------------------------------------------
217: -- FUNCTION get_rec for: OKL_SIF_RET_LEVELS
218: ---------------------------------------------------------------------------
336: BEGIN
337: RETURN(get_rec(p_srl_rec, l_row_not_found));
338: END get_rec;
339: ---------------------------------------------------------------------------
340: -- FUNCTION null_out_defaults for: OKL_SIF_RET_LEVELS_V
341: ---------------------------------------------------------------------------
342: FUNCTION null_out_defaults (
343: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
344: ) RETURN okl_sif_ret_levels_v_rec_type IS
339: ---------------------------------------------------------------------------
340: -- FUNCTION null_out_defaults for: OKL_SIF_RET_LEVELS_V
341: ---------------------------------------------------------------------------
342: FUNCTION null_out_defaults (
343: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
344: ) RETURN okl_sif_ret_levels_v_rec_type IS
345: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
346: BEGIN
347: IF (l_okl_sif_ret_levels_v_rec.id = OKC_API.G_MISS_NUM ) THEN
340: -- FUNCTION null_out_defaults for: OKL_SIF_RET_LEVELS_V
341: ---------------------------------------------------------------------------
342: FUNCTION null_out_defaults (
343: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
344: ) RETURN okl_sif_ret_levels_v_rec_type IS
345: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
346: BEGIN
347: IF (l_okl_sif_ret_levels_v_rec.id = OKC_API.G_MISS_NUM ) THEN
348: l_okl_sif_ret_levels_v_rec.id := NULL;
341: ---------------------------------------------------------------------------
342: FUNCTION null_out_defaults (
343: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
344: ) RETURN okl_sif_ret_levels_v_rec_type IS
345: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
346: BEGIN
347: IF (l_okl_sif_ret_levels_v_rec.id = OKC_API.G_MISS_NUM ) THEN
348: l_okl_sif_ret_levels_v_rec.id := NULL;
349: END IF;
343: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
344: ) RETURN okl_sif_ret_levels_v_rec_type IS
345: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
346: BEGIN
347: IF (l_okl_sif_ret_levels_v_rec.id = OKC_API.G_MISS_NUM ) THEN
348: l_okl_sif_ret_levels_v_rec.id := NULL;
349: END IF;
350: IF (l_okl_sif_ret_levels_v_rec.level_index_number = OKC_API.G_MISS_NUM ) THEN
351: l_okl_sif_ret_levels_v_rec.level_index_number := NULL;
344: ) RETURN okl_sif_ret_levels_v_rec_type IS
345: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
346: BEGIN
347: IF (l_okl_sif_ret_levels_v_rec.id = OKC_API.G_MISS_NUM ) THEN
348: l_okl_sif_ret_levels_v_rec.id := NULL;
349: END IF;
350: IF (l_okl_sif_ret_levels_v_rec.level_index_number = OKC_API.G_MISS_NUM ) THEN
351: l_okl_sif_ret_levels_v_rec.level_index_number := NULL;
352: END IF;
346: BEGIN
347: IF (l_okl_sif_ret_levels_v_rec.id = OKC_API.G_MISS_NUM ) THEN
348: l_okl_sif_ret_levels_v_rec.id := NULL;
349: END IF;
350: IF (l_okl_sif_ret_levels_v_rec.level_index_number = OKC_API.G_MISS_NUM ) THEN
351: l_okl_sif_ret_levels_v_rec.level_index_number := NULL;
352: END IF;
353: IF (l_okl_sif_ret_levels_v_rec.number_of_periods = OKC_API.G_MISS_NUM ) THEN
354: l_okl_sif_ret_levels_v_rec.number_of_periods := NULL;
347: IF (l_okl_sif_ret_levels_v_rec.id = OKC_API.G_MISS_NUM ) THEN
348: l_okl_sif_ret_levels_v_rec.id := NULL;
349: END IF;
350: IF (l_okl_sif_ret_levels_v_rec.level_index_number = OKC_API.G_MISS_NUM ) THEN
351: l_okl_sif_ret_levels_v_rec.level_index_number := NULL;
352: END IF;
353: IF (l_okl_sif_ret_levels_v_rec.number_of_periods = OKC_API.G_MISS_NUM ) THEN
354: l_okl_sif_ret_levels_v_rec.number_of_periods := NULL;
355: END IF;
349: END IF;
350: IF (l_okl_sif_ret_levels_v_rec.level_index_number = OKC_API.G_MISS_NUM ) THEN
351: l_okl_sif_ret_levels_v_rec.level_index_number := NULL;
352: END IF;
353: IF (l_okl_sif_ret_levels_v_rec.number_of_periods = OKC_API.G_MISS_NUM ) THEN
354: l_okl_sif_ret_levels_v_rec.number_of_periods := NULL;
355: END IF;
356: IF (l_okl_sif_ret_levels_v_rec.sir_id = OKC_API.G_MISS_NUM ) THEN
357: l_okl_sif_ret_levels_v_rec.sir_id := NULL;
350: IF (l_okl_sif_ret_levels_v_rec.level_index_number = OKC_API.G_MISS_NUM ) THEN
351: l_okl_sif_ret_levels_v_rec.level_index_number := NULL;
352: END IF;
353: IF (l_okl_sif_ret_levels_v_rec.number_of_periods = OKC_API.G_MISS_NUM ) THEN
354: l_okl_sif_ret_levels_v_rec.number_of_periods := NULL;
355: END IF;
356: IF (l_okl_sif_ret_levels_v_rec.sir_id = OKC_API.G_MISS_NUM ) THEN
357: l_okl_sif_ret_levels_v_rec.sir_id := NULL;
358: END IF;
352: END IF;
353: IF (l_okl_sif_ret_levels_v_rec.number_of_periods = OKC_API.G_MISS_NUM ) THEN
354: l_okl_sif_ret_levels_v_rec.number_of_periods := NULL;
355: END IF;
356: IF (l_okl_sif_ret_levels_v_rec.sir_id = OKC_API.G_MISS_NUM ) THEN
357: l_okl_sif_ret_levels_v_rec.sir_id := NULL;
358: END IF;
359: IF (l_okl_sif_ret_levels_v_rec.index_number = OKC_API.G_MISS_NUM ) THEN
360: l_okl_sif_ret_levels_v_rec.index_number := NULL;
353: IF (l_okl_sif_ret_levels_v_rec.number_of_periods = OKC_API.G_MISS_NUM ) THEN
354: l_okl_sif_ret_levels_v_rec.number_of_periods := NULL;
355: END IF;
356: IF (l_okl_sif_ret_levels_v_rec.sir_id = OKC_API.G_MISS_NUM ) THEN
357: l_okl_sif_ret_levels_v_rec.sir_id := NULL;
358: END IF;
359: IF (l_okl_sif_ret_levels_v_rec.index_number = OKC_API.G_MISS_NUM ) THEN
360: l_okl_sif_ret_levels_v_rec.index_number := NULL;
361: END IF;
355: END IF;
356: IF (l_okl_sif_ret_levels_v_rec.sir_id = OKC_API.G_MISS_NUM ) THEN
357: l_okl_sif_ret_levels_v_rec.sir_id := NULL;
358: END IF;
359: IF (l_okl_sif_ret_levels_v_rec.index_number = OKC_API.G_MISS_NUM ) THEN
360: l_okl_sif_ret_levels_v_rec.index_number := NULL;
361: END IF;
362: IF (l_okl_sif_ret_levels_v_rec.level_type = OKC_API.G_MISS_CHAR ) THEN
363: l_okl_sif_ret_levels_v_rec.level_type := NULL;
356: IF (l_okl_sif_ret_levels_v_rec.sir_id = OKC_API.G_MISS_NUM ) THEN
357: l_okl_sif_ret_levels_v_rec.sir_id := NULL;
358: END IF;
359: IF (l_okl_sif_ret_levels_v_rec.index_number = OKC_API.G_MISS_NUM ) THEN
360: l_okl_sif_ret_levels_v_rec.index_number := NULL;
361: END IF;
362: IF (l_okl_sif_ret_levels_v_rec.level_type = OKC_API.G_MISS_CHAR ) THEN
363: l_okl_sif_ret_levels_v_rec.level_type := NULL;
364: END IF;
358: END IF;
359: IF (l_okl_sif_ret_levels_v_rec.index_number = OKC_API.G_MISS_NUM ) THEN
360: l_okl_sif_ret_levels_v_rec.index_number := NULL;
361: END IF;
362: IF (l_okl_sif_ret_levels_v_rec.level_type = OKC_API.G_MISS_CHAR ) THEN
363: l_okl_sif_ret_levels_v_rec.level_type := NULL;
364: END IF;
365: IF (l_okl_sif_ret_levels_v_rec.amount = OKC_API.G_MISS_NUM ) THEN
366: l_okl_sif_ret_levels_v_rec.amount := NULL;
359: IF (l_okl_sif_ret_levels_v_rec.index_number = OKC_API.G_MISS_NUM ) THEN
360: l_okl_sif_ret_levels_v_rec.index_number := NULL;
361: END IF;
362: IF (l_okl_sif_ret_levels_v_rec.level_type = OKC_API.G_MISS_CHAR ) THEN
363: l_okl_sif_ret_levels_v_rec.level_type := NULL;
364: END IF;
365: IF (l_okl_sif_ret_levels_v_rec.amount = OKC_API.G_MISS_NUM ) THEN
366: l_okl_sif_ret_levels_v_rec.amount := NULL;
367: END IF;
361: END IF;
362: IF (l_okl_sif_ret_levels_v_rec.level_type = OKC_API.G_MISS_CHAR ) THEN
363: l_okl_sif_ret_levels_v_rec.level_type := NULL;
364: END IF;
365: IF (l_okl_sif_ret_levels_v_rec.amount = OKC_API.G_MISS_NUM ) THEN
366: l_okl_sif_ret_levels_v_rec.amount := NULL;
367: END IF;
368: IF (l_okl_sif_ret_levels_v_rec.advance_or_arrears = OKC_API.G_MISS_CHAR ) THEN
369: l_okl_sif_ret_levels_v_rec.advance_or_arrears := NULL;
362: IF (l_okl_sif_ret_levels_v_rec.level_type = OKC_API.G_MISS_CHAR ) THEN
363: l_okl_sif_ret_levels_v_rec.level_type := NULL;
364: END IF;
365: IF (l_okl_sif_ret_levels_v_rec.amount = OKC_API.G_MISS_NUM ) THEN
366: l_okl_sif_ret_levels_v_rec.amount := NULL;
367: END IF;
368: IF (l_okl_sif_ret_levels_v_rec.advance_or_arrears = OKC_API.G_MISS_CHAR ) THEN
369: l_okl_sif_ret_levels_v_rec.advance_or_arrears := NULL;
370: END IF;
364: END IF;
365: IF (l_okl_sif_ret_levels_v_rec.amount = OKC_API.G_MISS_NUM ) THEN
366: l_okl_sif_ret_levels_v_rec.amount := NULL;
367: END IF;
368: IF (l_okl_sif_ret_levels_v_rec.advance_or_arrears = OKC_API.G_MISS_CHAR ) THEN
369: l_okl_sif_ret_levels_v_rec.advance_or_arrears := NULL;
370: END IF;
371: IF (l_okl_sif_ret_levels_v_rec.period = OKC_API.G_MISS_CHAR ) THEN
372: l_okl_sif_ret_levels_v_rec.period := NULL;
365: IF (l_okl_sif_ret_levels_v_rec.amount = OKC_API.G_MISS_NUM ) THEN
366: l_okl_sif_ret_levels_v_rec.amount := NULL;
367: END IF;
368: IF (l_okl_sif_ret_levels_v_rec.advance_or_arrears = OKC_API.G_MISS_CHAR ) THEN
369: l_okl_sif_ret_levels_v_rec.advance_or_arrears := NULL;
370: END IF;
371: IF (l_okl_sif_ret_levels_v_rec.period = OKC_API.G_MISS_CHAR ) THEN
372: l_okl_sif_ret_levels_v_rec.period := NULL;
373: END IF;
367: END IF;
368: IF (l_okl_sif_ret_levels_v_rec.advance_or_arrears = OKC_API.G_MISS_CHAR ) THEN
369: l_okl_sif_ret_levels_v_rec.advance_or_arrears := NULL;
370: END IF;
371: IF (l_okl_sif_ret_levels_v_rec.period = OKC_API.G_MISS_CHAR ) THEN
372: l_okl_sif_ret_levels_v_rec.period := NULL;
373: END IF;
374: IF (l_okl_sif_ret_levels_v_rec.lock_level_step = OKC_API.G_MISS_CHAR ) THEN
375: l_okl_sif_ret_levels_v_rec.lock_level_step := NULL;
368: IF (l_okl_sif_ret_levels_v_rec.advance_or_arrears = OKC_API.G_MISS_CHAR ) THEN
369: l_okl_sif_ret_levels_v_rec.advance_or_arrears := NULL;
370: END IF;
371: IF (l_okl_sif_ret_levels_v_rec.period = OKC_API.G_MISS_CHAR ) THEN
372: l_okl_sif_ret_levels_v_rec.period := NULL;
373: END IF;
374: IF (l_okl_sif_ret_levels_v_rec.lock_level_step = OKC_API.G_MISS_CHAR ) THEN
375: l_okl_sif_ret_levels_v_rec.lock_level_step := NULL;
376: END IF;
370: END IF;
371: IF (l_okl_sif_ret_levels_v_rec.period = OKC_API.G_MISS_CHAR ) THEN
372: l_okl_sif_ret_levels_v_rec.period := NULL;
373: END IF;
374: IF (l_okl_sif_ret_levels_v_rec.lock_level_step = OKC_API.G_MISS_CHAR ) THEN
375: l_okl_sif_ret_levels_v_rec.lock_level_step := NULL;
376: END IF;
377: IF (l_okl_sif_ret_levels_v_rec.days_in_period = OKC_API.G_MISS_NUM ) THEN
378: l_okl_sif_ret_levels_v_rec.days_in_period := NULL;
371: IF (l_okl_sif_ret_levels_v_rec.period = OKC_API.G_MISS_CHAR ) THEN
372: l_okl_sif_ret_levels_v_rec.period := NULL;
373: END IF;
374: IF (l_okl_sif_ret_levels_v_rec.lock_level_step = OKC_API.G_MISS_CHAR ) THEN
375: l_okl_sif_ret_levels_v_rec.lock_level_step := NULL;
376: END IF;
377: IF (l_okl_sif_ret_levels_v_rec.days_in_period = OKC_API.G_MISS_NUM ) THEN
378: l_okl_sif_ret_levels_v_rec.days_in_period := NULL;
379: END IF;
373: END IF;
374: IF (l_okl_sif_ret_levels_v_rec.lock_level_step = OKC_API.G_MISS_CHAR ) THEN
375: l_okl_sif_ret_levels_v_rec.lock_level_step := NULL;
376: END IF;
377: IF (l_okl_sif_ret_levels_v_rec.days_in_period = OKC_API.G_MISS_NUM ) THEN
378: l_okl_sif_ret_levels_v_rec.days_in_period := NULL;
379: END IF;
380: IF (l_okl_sif_ret_levels_v_rec.first_payment_date = OKC_API.G_MISS_DATE ) THEN
381: l_okl_sif_ret_levels_v_rec.first_payment_date := NULL;
374: IF (l_okl_sif_ret_levels_v_rec.lock_level_step = OKC_API.G_MISS_CHAR ) THEN
375: l_okl_sif_ret_levels_v_rec.lock_level_step := NULL;
376: END IF;
377: IF (l_okl_sif_ret_levels_v_rec.days_in_period = OKC_API.G_MISS_NUM ) THEN
378: l_okl_sif_ret_levels_v_rec.days_in_period := NULL;
379: END IF;
380: IF (l_okl_sif_ret_levels_v_rec.first_payment_date = OKC_API.G_MISS_DATE ) THEN
381: l_okl_sif_ret_levels_v_rec.first_payment_date := NULL;
382: END IF;
376: END IF;
377: IF (l_okl_sif_ret_levels_v_rec.days_in_period = OKC_API.G_MISS_NUM ) THEN
378: l_okl_sif_ret_levels_v_rec.days_in_period := NULL;
379: END IF;
380: IF (l_okl_sif_ret_levels_v_rec.first_payment_date = OKC_API.G_MISS_DATE ) THEN
381: l_okl_sif_ret_levels_v_rec.first_payment_date := NULL;
382: END IF;
383: IF (l_okl_sif_ret_levels_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
384: l_okl_sif_ret_levels_v_rec.object_version_number := NULL;
377: IF (l_okl_sif_ret_levels_v_rec.days_in_period = OKC_API.G_MISS_NUM ) THEN
378: l_okl_sif_ret_levels_v_rec.days_in_period := NULL;
379: END IF;
380: IF (l_okl_sif_ret_levels_v_rec.first_payment_date = OKC_API.G_MISS_DATE ) THEN
381: l_okl_sif_ret_levels_v_rec.first_payment_date := NULL;
382: END IF;
383: IF (l_okl_sif_ret_levels_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
384: l_okl_sif_ret_levels_v_rec.object_version_number := NULL;
385: END IF;
379: END IF;
380: IF (l_okl_sif_ret_levels_v_rec.first_payment_date = OKC_API.G_MISS_DATE ) THEN
381: l_okl_sif_ret_levels_v_rec.first_payment_date := NULL;
382: END IF;
383: IF (l_okl_sif_ret_levels_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
384: l_okl_sif_ret_levels_v_rec.object_version_number := NULL;
385: END IF;
386: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute1 = OKC_API.G_MISS_CHAR ) THEN
387: l_okl_sif_ret_levels_v_rec.stream_interface_attribute1 := NULL;
380: IF (l_okl_sif_ret_levels_v_rec.first_payment_date = OKC_API.G_MISS_DATE ) THEN
381: l_okl_sif_ret_levels_v_rec.first_payment_date := NULL;
382: END IF;
383: IF (l_okl_sif_ret_levels_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
384: l_okl_sif_ret_levels_v_rec.object_version_number := NULL;
385: END IF;
386: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute1 = OKC_API.G_MISS_CHAR ) THEN
387: l_okl_sif_ret_levels_v_rec.stream_interface_attribute1 := NULL;
388: END IF;
382: END IF;
383: IF (l_okl_sif_ret_levels_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
384: l_okl_sif_ret_levels_v_rec.object_version_number := NULL;
385: END IF;
386: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute1 = OKC_API.G_MISS_CHAR ) THEN
387: l_okl_sif_ret_levels_v_rec.stream_interface_attribute1 := NULL;
388: END IF;
389: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute2 = OKC_API.G_MISS_CHAR ) THEN
390: l_okl_sif_ret_levels_v_rec.stream_interface_attribute2 := NULL;
383: IF (l_okl_sif_ret_levels_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
384: l_okl_sif_ret_levels_v_rec.object_version_number := NULL;
385: END IF;
386: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute1 = OKC_API.G_MISS_CHAR ) THEN
387: l_okl_sif_ret_levels_v_rec.stream_interface_attribute1 := NULL;
388: END IF;
389: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute2 = OKC_API.G_MISS_CHAR ) THEN
390: l_okl_sif_ret_levels_v_rec.stream_interface_attribute2 := NULL;
391: END IF;
385: END IF;
386: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute1 = OKC_API.G_MISS_CHAR ) THEN
387: l_okl_sif_ret_levels_v_rec.stream_interface_attribute1 := NULL;
388: END IF;
389: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute2 = OKC_API.G_MISS_CHAR ) THEN
390: l_okl_sif_ret_levels_v_rec.stream_interface_attribute2 := NULL;
391: END IF;
392: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute3 = OKC_API.G_MISS_CHAR ) THEN
393: l_okl_sif_ret_levels_v_rec.stream_interface_attribute3 := NULL;
386: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute1 = OKC_API.G_MISS_CHAR ) THEN
387: l_okl_sif_ret_levels_v_rec.stream_interface_attribute1 := NULL;
388: END IF;
389: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute2 = OKC_API.G_MISS_CHAR ) THEN
390: l_okl_sif_ret_levels_v_rec.stream_interface_attribute2 := NULL;
391: END IF;
392: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute3 = OKC_API.G_MISS_CHAR ) THEN
393: l_okl_sif_ret_levels_v_rec.stream_interface_attribute3 := NULL;
394: END IF;
388: END IF;
389: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute2 = OKC_API.G_MISS_CHAR ) THEN
390: l_okl_sif_ret_levels_v_rec.stream_interface_attribute2 := NULL;
391: END IF;
392: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute3 = OKC_API.G_MISS_CHAR ) THEN
393: l_okl_sif_ret_levels_v_rec.stream_interface_attribute3 := NULL;
394: END IF;
395: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute4 = OKC_API.G_MISS_CHAR ) THEN
396: l_okl_sif_ret_levels_v_rec.stream_interface_attribute4 := NULL;
389: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute2 = OKC_API.G_MISS_CHAR ) THEN
390: l_okl_sif_ret_levels_v_rec.stream_interface_attribute2 := NULL;
391: END IF;
392: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute3 = OKC_API.G_MISS_CHAR ) THEN
393: l_okl_sif_ret_levels_v_rec.stream_interface_attribute3 := NULL;
394: END IF;
395: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute4 = OKC_API.G_MISS_CHAR ) THEN
396: l_okl_sif_ret_levels_v_rec.stream_interface_attribute4 := NULL;
397: END IF;
391: END IF;
392: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute3 = OKC_API.G_MISS_CHAR ) THEN
393: l_okl_sif_ret_levels_v_rec.stream_interface_attribute3 := NULL;
394: END IF;
395: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute4 = OKC_API.G_MISS_CHAR ) THEN
396: l_okl_sif_ret_levels_v_rec.stream_interface_attribute4 := NULL;
397: END IF;
398: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute5 = OKC_API.G_MISS_CHAR ) THEN
399: l_okl_sif_ret_levels_v_rec.stream_interface_attribute5 := NULL;
392: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute3 = OKC_API.G_MISS_CHAR ) THEN
393: l_okl_sif_ret_levels_v_rec.stream_interface_attribute3 := NULL;
394: END IF;
395: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute4 = OKC_API.G_MISS_CHAR ) THEN
396: l_okl_sif_ret_levels_v_rec.stream_interface_attribute4 := NULL;
397: END IF;
398: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute5 = OKC_API.G_MISS_CHAR ) THEN
399: l_okl_sif_ret_levels_v_rec.stream_interface_attribute5 := NULL;
400: END IF;
394: END IF;
395: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute4 = OKC_API.G_MISS_CHAR ) THEN
396: l_okl_sif_ret_levels_v_rec.stream_interface_attribute4 := NULL;
397: END IF;
398: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute5 = OKC_API.G_MISS_CHAR ) THEN
399: l_okl_sif_ret_levels_v_rec.stream_interface_attribute5 := NULL;
400: END IF;
401: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute6 = OKC_API.G_MISS_CHAR ) THEN
402: l_okl_sif_ret_levels_v_rec.stream_interface_attribute6 := NULL;
395: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute4 = OKC_API.G_MISS_CHAR ) THEN
396: l_okl_sif_ret_levels_v_rec.stream_interface_attribute4 := NULL;
397: END IF;
398: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute5 = OKC_API.G_MISS_CHAR ) THEN
399: l_okl_sif_ret_levels_v_rec.stream_interface_attribute5 := NULL;
400: END IF;
401: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute6 = OKC_API.G_MISS_CHAR ) THEN
402: l_okl_sif_ret_levels_v_rec.stream_interface_attribute6 := NULL;
403: END IF;
397: END IF;
398: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute5 = OKC_API.G_MISS_CHAR ) THEN
399: l_okl_sif_ret_levels_v_rec.stream_interface_attribute5 := NULL;
400: END IF;
401: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute6 = OKC_API.G_MISS_CHAR ) THEN
402: l_okl_sif_ret_levels_v_rec.stream_interface_attribute6 := NULL;
403: END IF;
404: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute7 = OKC_API.G_MISS_CHAR ) THEN
405: l_okl_sif_ret_levels_v_rec.stream_interface_attribute7 := NULL;
398: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute5 = OKC_API.G_MISS_CHAR ) THEN
399: l_okl_sif_ret_levels_v_rec.stream_interface_attribute5 := NULL;
400: END IF;
401: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute6 = OKC_API.G_MISS_CHAR ) THEN
402: l_okl_sif_ret_levels_v_rec.stream_interface_attribute6 := NULL;
403: END IF;
404: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute7 = OKC_API.G_MISS_CHAR ) THEN
405: l_okl_sif_ret_levels_v_rec.stream_interface_attribute7 := NULL;
406: END IF;
400: END IF;
401: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute6 = OKC_API.G_MISS_CHAR ) THEN
402: l_okl_sif_ret_levels_v_rec.stream_interface_attribute6 := NULL;
403: END IF;
404: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute7 = OKC_API.G_MISS_CHAR ) THEN
405: l_okl_sif_ret_levels_v_rec.stream_interface_attribute7 := NULL;
406: END IF;
407: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute8 = OKC_API.G_MISS_CHAR ) THEN
408: l_okl_sif_ret_levels_v_rec.stream_interface_attribute8 := NULL;
401: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute6 = OKC_API.G_MISS_CHAR ) THEN
402: l_okl_sif_ret_levels_v_rec.stream_interface_attribute6 := NULL;
403: END IF;
404: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute7 = OKC_API.G_MISS_CHAR ) THEN
405: l_okl_sif_ret_levels_v_rec.stream_interface_attribute7 := NULL;
406: END IF;
407: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute8 = OKC_API.G_MISS_CHAR ) THEN
408: l_okl_sif_ret_levels_v_rec.stream_interface_attribute8 := NULL;
409: END IF;
403: END IF;
404: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute7 = OKC_API.G_MISS_CHAR ) THEN
405: l_okl_sif_ret_levels_v_rec.stream_interface_attribute7 := NULL;
406: END IF;
407: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute8 = OKC_API.G_MISS_CHAR ) THEN
408: l_okl_sif_ret_levels_v_rec.stream_interface_attribute8 := NULL;
409: END IF;
410: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute9 = OKC_API.G_MISS_CHAR ) THEN
411: l_okl_sif_ret_levels_v_rec.stream_interface_attribute9 := NULL;
404: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute7 = OKC_API.G_MISS_CHAR ) THEN
405: l_okl_sif_ret_levels_v_rec.stream_interface_attribute7 := NULL;
406: END IF;
407: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute8 = OKC_API.G_MISS_CHAR ) THEN
408: l_okl_sif_ret_levels_v_rec.stream_interface_attribute8 := NULL;
409: END IF;
410: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute9 = OKC_API.G_MISS_CHAR ) THEN
411: l_okl_sif_ret_levels_v_rec.stream_interface_attribute9 := NULL;
412: END IF;
406: END IF;
407: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute8 = OKC_API.G_MISS_CHAR ) THEN
408: l_okl_sif_ret_levels_v_rec.stream_interface_attribute8 := NULL;
409: END IF;
410: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute9 = OKC_API.G_MISS_CHAR ) THEN
411: l_okl_sif_ret_levels_v_rec.stream_interface_attribute9 := NULL;
412: END IF;
413: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute10 = OKC_API.G_MISS_CHAR ) THEN
414: l_okl_sif_ret_levels_v_rec.stream_interface_attribute10 := NULL;
407: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute8 = OKC_API.G_MISS_CHAR ) THEN
408: l_okl_sif_ret_levels_v_rec.stream_interface_attribute8 := NULL;
409: END IF;
410: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute9 = OKC_API.G_MISS_CHAR ) THEN
411: l_okl_sif_ret_levels_v_rec.stream_interface_attribute9 := NULL;
412: END IF;
413: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute10 = OKC_API.G_MISS_CHAR ) THEN
414: l_okl_sif_ret_levels_v_rec.stream_interface_attribute10 := NULL;
415: END IF;
409: END IF;
410: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute9 = OKC_API.G_MISS_CHAR ) THEN
411: l_okl_sif_ret_levels_v_rec.stream_interface_attribute9 := NULL;
412: END IF;
413: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute10 = OKC_API.G_MISS_CHAR ) THEN
414: l_okl_sif_ret_levels_v_rec.stream_interface_attribute10 := NULL;
415: END IF;
416: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute11 = OKC_API.G_MISS_CHAR ) THEN
417: l_okl_sif_ret_levels_v_rec.stream_interface_attribute11 := NULL;
410: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute9 = OKC_API.G_MISS_CHAR ) THEN
411: l_okl_sif_ret_levels_v_rec.stream_interface_attribute9 := NULL;
412: END IF;
413: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute10 = OKC_API.G_MISS_CHAR ) THEN
414: l_okl_sif_ret_levels_v_rec.stream_interface_attribute10 := NULL;
415: END IF;
416: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute11 = OKC_API.G_MISS_CHAR ) THEN
417: l_okl_sif_ret_levels_v_rec.stream_interface_attribute11 := NULL;
418: END IF;
412: END IF;
413: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute10 = OKC_API.G_MISS_CHAR ) THEN
414: l_okl_sif_ret_levels_v_rec.stream_interface_attribute10 := NULL;
415: END IF;
416: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute11 = OKC_API.G_MISS_CHAR ) THEN
417: l_okl_sif_ret_levels_v_rec.stream_interface_attribute11 := NULL;
418: END IF;
419: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute12 = OKC_API.G_MISS_CHAR ) THEN
420: l_okl_sif_ret_levels_v_rec.stream_interface_attribute12 := NULL;
413: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute10 = OKC_API.G_MISS_CHAR ) THEN
414: l_okl_sif_ret_levels_v_rec.stream_interface_attribute10 := NULL;
415: END IF;
416: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute11 = OKC_API.G_MISS_CHAR ) THEN
417: l_okl_sif_ret_levels_v_rec.stream_interface_attribute11 := NULL;
418: END IF;
419: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute12 = OKC_API.G_MISS_CHAR ) THEN
420: l_okl_sif_ret_levels_v_rec.stream_interface_attribute12 := NULL;
421: END IF;
415: END IF;
416: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute11 = OKC_API.G_MISS_CHAR ) THEN
417: l_okl_sif_ret_levels_v_rec.stream_interface_attribute11 := NULL;
418: END IF;
419: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute12 = OKC_API.G_MISS_CHAR ) THEN
420: l_okl_sif_ret_levels_v_rec.stream_interface_attribute12 := NULL;
421: END IF;
422: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute13 = OKC_API.G_MISS_CHAR ) THEN
423: l_okl_sif_ret_levels_v_rec.stream_interface_attribute13 := NULL;
416: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute11 = OKC_API.G_MISS_CHAR ) THEN
417: l_okl_sif_ret_levels_v_rec.stream_interface_attribute11 := NULL;
418: END IF;
419: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute12 = OKC_API.G_MISS_CHAR ) THEN
420: l_okl_sif_ret_levels_v_rec.stream_interface_attribute12 := NULL;
421: END IF;
422: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute13 = OKC_API.G_MISS_CHAR ) THEN
423: l_okl_sif_ret_levels_v_rec.stream_interface_attribute13 := NULL;
424: END IF;
418: END IF;
419: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute12 = OKC_API.G_MISS_CHAR ) THEN
420: l_okl_sif_ret_levels_v_rec.stream_interface_attribute12 := NULL;
421: END IF;
422: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute13 = OKC_API.G_MISS_CHAR ) THEN
423: l_okl_sif_ret_levels_v_rec.stream_interface_attribute13 := NULL;
424: END IF;
425: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute14 = OKC_API.G_MISS_CHAR ) THEN
426: l_okl_sif_ret_levels_v_rec.stream_interface_attribute14 := NULL;
419: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute12 = OKC_API.G_MISS_CHAR ) THEN
420: l_okl_sif_ret_levels_v_rec.stream_interface_attribute12 := NULL;
421: END IF;
422: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute13 = OKC_API.G_MISS_CHAR ) THEN
423: l_okl_sif_ret_levels_v_rec.stream_interface_attribute13 := NULL;
424: END IF;
425: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute14 = OKC_API.G_MISS_CHAR ) THEN
426: l_okl_sif_ret_levels_v_rec.stream_interface_attribute14 := NULL;
427: END IF;
421: END IF;
422: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute13 = OKC_API.G_MISS_CHAR ) THEN
423: l_okl_sif_ret_levels_v_rec.stream_interface_attribute13 := NULL;
424: END IF;
425: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute14 = OKC_API.G_MISS_CHAR ) THEN
426: l_okl_sif_ret_levels_v_rec.stream_interface_attribute14 := NULL;
427: END IF;
428: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute15 = OKC_API.G_MISS_CHAR ) THEN
429: l_okl_sif_ret_levels_v_rec.stream_interface_attribute15 := NULL;
422: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute13 = OKC_API.G_MISS_CHAR ) THEN
423: l_okl_sif_ret_levels_v_rec.stream_interface_attribute13 := NULL;
424: END IF;
425: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute14 = OKC_API.G_MISS_CHAR ) THEN
426: l_okl_sif_ret_levels_v_rec.stream_interface_attribute14 := NULL;
427: END IF;
428: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute15 = OKC_API.G_MISS_CHAR ) THEN
429: l_okl_sif_ret_levels_v_rec.stream_interface_attribute15 := NULL;
430: END IF;
424: END IF;
425: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute14 = OKC_API.G_MISS_CHAR ) THEN
426: l_okl_sif_ret_levels_v_rec.stream_interface_attribute14 := NULL;
427: END IF;
428: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute15 = OKC_API.G_MISS_CHAR ) THEN
429: l_okl_sif_ret_levels_v_rec.stream_interface_attribute15 := NULL;
430: END IF;
431: IF (l_okl_sif_ret_levels_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
432: l_okl_sif_ret_levels_v_rec.creation_date := NULL;
425: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute14 = OKC_API.G_MISS_CHAR ) THEN
426: l_okl_sif_ret_levels_v_rec.stream_interface_attribute14 := NULL;
427: END IF;
428: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute15 = OKC_API.G_MISS_CHAR ) THEN
429: l_okl_sif_ret_levels_v_rec.stream_interface_attribute15 := NULL;
430: END IF;
431: IF (l_okl_sif_ret_levels_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
432: l_okl_sif_ret_levels_v_rec.creation_date := NULL;
433: END IF;
427: END IF;
428: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute15 = OKC_API.G_MISS_CHAR ) THEN
429: l_okl_sif_ret_levels_v_rec.stream_interface_attribute15 := NULL;
430: END IF;
431: IF (l_okl_sif_ret_levels_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
432: l_okl_sif_ret_levels_v_rec.creation_date := NULL;
433: END IF;
434: IF (l_okl_sif_ret_levels_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
435: l_okl_sif_ret_levels_v_rec.created_by := NULL;
428: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute15 = OKC_API.G_MISS_CHAR ) THEN
429: l_okl_sif_ret_levels_v_rec.stream_interface_attribute15 := NULL;
430: END IF;
431: IF (l_okl_sif_ret_levels_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
432: l_okl_sif_ret_levels_v_rec.creation_date := NULL;
433: END IF;
434: IF (l_okl_sif_ret_levels_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
435: l_okl_sif_ret_levels_v_rec.created_by := NULL;
436: END IF;
430: END IF;
431: IF (l_okl_sif_ret_levels_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
432: l_okl_sif_ret_levels_v_rec.creation_date := NULL;
433: END IF;
434: IF (l_okl_sif_ret_levels_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
435: l_okl_sif_ret_levels_v_rec.created_by := NULL;
436: END IF;
437: IF (l_okl_sif_ret_levels_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
438: l_okl_sif_ret_levels_v_rec.last_update_date := NULL;
431: IF (l_okl_sif_ret_levels_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
432: l_okl_sif_ret_levels_v_rec.creation_date := NULL;
433: END IF;
434: IF (l_okl_sif_ret_levels_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
435: l_okl_sif_ret_levels_v_rec.created_by := NULL;
436: END IF;
437: IF (l_okl_sif_ret_levels_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
438: l_okl_sif_ret_levels_v_rec.last_update_date := NULL;
439: END IF;
433: END IF;
434: IF (l_okl_sif_ret_levels_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
435: l_okl_sif_ret_levels_v_rec.created_by := NULL;
436: END IF;
437: IF (l_okl_sif_ret_levels_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
438: l_okl_sif_ret_levels_v_rec.last_update_date := NULL;
439: END IF;
440: IF (l_okl_sif_ret_levels_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
441: l_okl_sif_ret_levels_v_rec.last_updated_by := NULL;
434: IF (l_okl_sif_ret_levels_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
435: l_okl_sif_ret_levels_v_rec.created_by := NULL;
436: END IF;
437: IF (l_okl_sif_ret_levels_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
438: l_okl_sif_ret_levels_v_rec.last_update_date := NULL;
439: END IF;
440: IF (l_okl_sif_ret_levels_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
441: l_okl_sif_ret_levels_v_rec.last_updated_by := NULL;
442: END IF;
436: END IF;
437: IF (l_okl_sif_ret_levels_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
438: l_okl_sif_ret_levels_v_rec.last_update_date := NULL;
439: END IF;
440: IF (l_okl_sif_ret_levels_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
441: l_okl_sif_ret_levels_v_rec.last_updated_by := NULL;
442: END IF;
443: IF (l_okl_sif_ret_levels_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
444: l_okl_sif_ret_levels_v_rec.last_update_login := NULL;
437: IF (l_okl_sif_ret_levels_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
438: l_okl_sif_ret_levels_v_rec.last_update_date := NULL;
439: END IF;
440: IF (l_okl_sif_ret_levels_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
441: l_okl_sif_ret_levels_v_rec.last_updated_by := NULL;
442: END IF;
443: IF (l_okl_sif_ret_levels_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
444: l_okl_sif_ret_levels_v_rec.last_update_login := NULL;
445: END IF;
439: END IF;
440: IF (l_okl_sif_ret_levels_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
441: l_okl_sif_ret_levels_v_rec.last_updated_by := NULL;
442: END IF;
443: IF (l_okl_sif_ret_levels_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
444: l_okl_sif_ret_levels_v_rec.last_update_login := NULL;
445: END IF;
446: --smahapat 10/12/03
447: IF (l_okl_sif_ret_levels_v_rec.rate = OKC_API.G_MISS_NUM ) THEN
440: IF (l_okl_sif_ret_levels_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
441: l_okl_sif_ret_levels_v_rec.last_updated_by := NULL;
442: END IF;
443: IF (l_okl_sif_ret_levels_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
444: l_okl_sif_ret_levels_v_rec.last_update_login := NULL;
445: END IF;
446: --smahapat 10/12/03
447: IF (l_okl_sif_ret_levels_v_rec.rate = OKC_API.G_MISS_NUM ) THEN
448: l_okl_sif_ret_levels_v_rec.rate := NULL;
443: IF (l_okl_sif_ret_levels_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
444: l_okl_sif_ret_levels_v_rec.last_update_login := NULL;
445: END IF;
446: --smahapat 10/12/03
447: IF (l_okl_sif_ret_levels_v_rec.rate = OKC_API.G_MISS_NUM ) THEN
448: l_okl_sif_ret_levels_v_rec.rate := NULL;
449: END IF;
450: -- racheruv 18.02.2013 .. next two columns
451: IF (l_okl_sif_ret_levels_v_rec.reamort_balance = OKC_API.G_MISS_NUM ) THEN
444: l_okl_sif_ret_levels_v_rec.last_update_login := NULL;
445: END IF;
446: --smahapat 10/12/03
447: IF (l_okl_sif_ret_levels_v_rec.rate = OKC_API.G_MISS_NUM ) THEN
448: l_okl_sif_ret_levels_v_rec.rate := NULL;
449: END IF;
450: -- racheruv 18.02.2013 .. next two columns
451: IF (l_okl_sif_ret_levels_v_rec.reamort_balance = OKC_API.G_MISS_NUM ) THEN
452: l_okl_sif_ret_levels_v_rec.reamort_balance := NULL;
447: IF (l_okl_sif_ret_levels_v_rec.rate = OKC_API.G_MISS_NUM ) THEN
448: l_okl_sif_ret_levels_v_rec.rate := NULL;
449: END IF;
450: -- racheruv 18.02.2013 .. next two columns
451: IF (l_okl_sif_ret_levels_v_rec.reamort_balance = OKC_API.G_MISS_NUM ) THEN
452: l_okl_sif_ret_levels_v_rec.reamort_balance := NULL;
453: END IF;
454: IF (l_okl_sif_ret_levels_v_rec.reamort_date = OKC_API.G_MISS_DATE ) THEN
455: l_okl_sif_ret_levels_v_rec.reamort_date := NULL;
448: l_okl_sif_ret_levels_v_rec.rate := NULL;
449: END IF;
450: -- racheruv 18.02.2013 .. next two columns
451: IF (l_okl_sif_ret_levels_v_rec.reamort_balance = OKC_API.G_MISS_NUM ) THEN
452: l_okl_sif_ret_levels_v_rec.reamort_balance := NULL;
453: END IF;
454: IF (l_okl_sif_ret_levels_v_rec.reamort_date = OKC_API.G_MISS_DATE ) THEN
455: l_okl_sif_ret_levels_v_rec.reamort_date := NULL;
456: END IF;
450: -- racheruv 18.02.2013 .. next two columns
451: IF (l_okl_sif_ret_levels_v_rec.reamort_balance = OKC_API.G_MISS_NUM ) THEN
452: l_okl_sif_ret_levels_v_rec.reamort_balance := NULL;
453: END IF;
454: IF (l_okl_sif_ret_levels_v_rec.reamort_date = OKC_API.G_MISS_DATE ) THEN
455: l_okl_sif_ret_levels_v_rec.reamort_date := NULL;
456: END IF;
457: RETURN(l_okl_sif_ret_levels_v_rec);
458: END null_out_defaults;
451: IF (l_okl_sif_ret_levels_v_rec.reamort_balance = OKC_API.G_MISS_NUM ) THEN
452: l_okl_sif_ret_levels_v_rec.reamort_balance := NULL;
453: END IF;
454: IF (l_okl_sif_ret_levels_v_rec.reamort_date = OKC_API.G_MISS_DATE ) THEN
455: l_okl_sif_ret_levels_v_rec.reamort_date := NULL;
456: END IF;
457: RETURN(l_okl_sif_ret_levels_v_rec);
458: END null_out_defaults;
459: ---------------------------------
453: END IF;
454: IF (l_okl_sif_ret_levels_v_rec.reamort_date = OKC_API.G_MISS_DATE ) THEN
455: l_okl_sif_ret_levels_v_rec.reamort_date := NULL;
456: END IF;
457: RETURN(l_okl_sif_ret_levels_v_rec);
458: END null_out_defaults;
459: ---------------------------------
460: -- Validate_Attributes for: ID --
461: ---------------------------------
591: ---------------------------------------------------------------------------
592: -- FUNCTION Validate_Attributes
593: ---------------------------------------------------------------------------
594: --------------------------------------------------
595: -- Validate_Attributes for:OKL_SIF_RET_LEVELS_V --
596: --------------------------------------------------
597: FUNCTION Validate_Attributes (
598: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
599: ) RETURN VARCHAR2 IS
594: --------------------------------------------------
595: -- Validate_Attributes for:OKL_SIF_RET_LEVELS_V --
596: --------------------------------------------------
597: FUNCTION Validate_Attributes (
598: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
599: ) RETURN VARCHAR2 IS
600: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
601: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
602: BEGIN
605: -----------------------------
606: -- ***
607: -- id
608: -- ***
609: validate_id(x_return_status, p_okl_sif_ret_levels_v_rec.id);
610: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
611: -- smahapat added 05/14
612: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
613: -- need to exit
622:
623: -- ***
624: -- sir_id
625: -- ***
626: validate_sir_id(x_return_status, p_okl_sif_ret_levels_v_rec.sir_id);
627: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
628: -- smahapat added 05/14
629: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
630: -- need to exit
639:
640: -- ***
641: -- index_number
642: -- ***
643: validate_index_number(x_return_status, p_okl_sif_ret_levels_v_rec.index_number);
644: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
645: -- smahapat added 05/14
646: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
647: -- need to exit
656:
657: -- ***
658: -- object_version_number
659: -- ***
660: validate_object_version_number(x_return_status, p_okl_sif_ret_levels_v_rec.object_version_number);
661: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
662: -- smahapat added 05/14
663: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
664: -- need to exit
688: ---------------------------------------------------------------------------
689: -- PROCEDURE Validate_Record
690: ---------------------------------------------------------------------------
691: ----------------------------------------------
692: -- Validate Record for:OKL_SIF_RET_LEVELS_V --
693: ----------------------------------------------
694: FUNCTION Validate_Record (
695: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
696: p_db_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
691: ----------------------------------------------
692: -- Validate Record for:OKL_SIF_RET_LEVELS_V --
693: ----------------------------------------------
694: FUNCTION Validate_Record (
695: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
696: p_db_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
697: ) RETURN VARCHAR2 IS
698: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
699: ------------------------------------
692: -- Validate Record for:OKL_SIF_RET_LEVELS_V --
693: ----------------------------------------------
694: FUNCTION Validate_Record (
695: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
696: p_db_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
697: ) RETURN VARCHAR2 IS
698: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
699: ------------------------------------
700: -- FUNCTION validate_foreign_keys --
699: ------------------------------------
700: -- FUNCTION validate_foreign_keys --
701: ------------------------------------
702: FUNCTION validate_foreign_keys (
703: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
704: p_db_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
705: ) RETURN VARCHAR2 IS
706: item_not_found_error EXCEPTION;
707: CURSOR okl_sifv_sirv_fk_csr (p_id IN NUMBER) IS
700: -- FUNCTION validate_foreign_keys --
701: ------------------------------------
702: FUNCTION validate_foreign_keys (
703: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
704: p_db_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
705: ) RETURN VARCHAR2 IS
706: item_not_found_error EXCEPTION;
707: CURSOR okl_sifv_sirv_fk_csr (p_id IN NUMBER) IS
708: SELECT 'x'
712:
713: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
714: l_row_notfound BOOLEAN := TRUE;
715: BEGIN
716: IF ((p_okl_sif_ret_levels_v_rec.SIR_ID IS NOT NULL)
717: AND
718: (p_okl_sif_ret_levels_v_rec.SIR_ID <> p_db_okl_sif_ret_levels_v_rec.SIR_ID))
719: THEN
720: OPEN okl_sifv_sirv_fk_csr (p_okl_sif_ret_levels_v_rec.SIR_ID);
714: l_row_notfound BOOLEAN := TRUE;
715: BEGIN
716: IF ((p_okl_sif_ret_levels_v_rec.SIR_ID IS NOT NULL)
717: AND
718: (p_okl_sif_ret_levels_v_rec.SIR_ID <> p_db_okl_sif_ret_levels_v_rec.SIR_ID))
719: THEN
720: OPEN okl_sifv_sirv_fk_csr (p_okl_sif_ret_levels_v_rec.SIR_ID);
721: FETCH okl_sifv_sirv_fk_csr INTO l_okl_sifv_sirv_fk;
722: l_row_notfound := okl_sifv_sirv_fk_csr%NOTFOUND;
716: IF ((p_okl_sif_ret_levels_v_rec.SIR_ID IS NOT NULL)
717: AND
718: (p_okl_sif_ret_levels_v_rec.SIR_ID <> p_db_okl_sif_ret_levels_v_rec.SIR_ID))
719: THEN
720: OPEN okl_sifv_sirv_fk_csr (p_okl_sif_ret_levels_v_rec.SIR_ID);
721: FETCH okl_sifv_sirv_fk_csr INTO l_okl_sifv_sirv_fk;
722: l_row_notfound := okl_sifv_sirv_fk_csr%NOTFOUND;
723: CLOSE okl_sifv_sirv_fk_csr;
724: IF (l_row_notfound) THEN
732: l_return_status := OKC_API.G_RET_STS_ERROR;
733: RETURN (l_return_status);
734: END validate_foreign_keys;
735: BEGIN
736: l_return_status := validate_foreign_keys(p_okl_sif_ret_levels_v_rec, p_db_okl_sif_ret_levels_v_rec);
737: RETURN (l_return_status);
738: END Validate_Record;
739: FUNCTION Validate_Record (
740: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
736: l_return_status := validate_foreign_keys(p_okl_sif_ret_levels_v_rec, p_db_okl_sif_ret_levels_v_rec);
737: RETURN (l_return_status);
738: END Validate_Record;
739: FUNCTION Validate_Record (
740: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
741: ) RETURN VARCHAR2 IS
742: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
743: l_db_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := get_rec(p_okl_sif_ret_levels_v_rec);
744: BEGIN
739: FUNCTION Validate_Record (
740: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
741: ) RETURN VARCHAR2 IS
742: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
743: l_db_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := get_rec(p_okl_sif_ret_levels_v_rec);
744: BEGIN
745: l_return_status := Validate_Record(p_okl_sif_ret_levels_v_rec => p_okl_sif_ret_levels_v_rec,
746: p_db_okl_sif_ret_levels_v_rec => l_db_okl_sif_ret_levels_v_rec);
747: RETURN (l_return_status);
741: ) RETURN VARCHAR2 IS
742: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
743: l_db_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := get_rec(p_okl_sif_ret_levels_v_rec);
744: BEGIN
745: l_return_status := Validate_Record(p_okl_sif_ret_levels_v_rec => p_okl_sif_ret_levels_v_rec,
746: p_db_okl_sif_ret_levels_v_rec => l_db_okl_sif_ret_levels_v_rec);
747: RETURN (l_return_status);
748: END Validate_Record;
749:
742: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
743: l_db_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := get_rec(p_okl_sif_ret_levels_v_rec);
744: BEGIN
745: l_return_status := Validate_Record(p_okl_sif_ret_levels_v_rec => p_okl_sif_ret_levels_v_rec,
746: p_db_okl_sif_ret_levels_v_rec => l_db_okl_sif_ret_levels_v_rec);
747: RETURN (l_return_status);
748: END Validate_Record;
749:
750: ---------------------------------------------------------------------------
750: ---------------------------------------------------------------------------
751: -- PROCEDURE Migrate
752: ---------------------------------------------------------------------------
753: PROCEDURE migrate (
754: p_from IN okl_sif_ret_levels_v_rec_type,
755: p_to IN OUT NOCOPY srl_rec_type
756: ) IS
757: BEGIN
758: p_to.id := p_from.id;
793: p_to.reamort_date := p_from.reamort_date; --racheruv 18.02.2013
794: END migrate;
795: PROCEDURE migrate (
796: p_from IN srl_rec_type,
797: p_to IN OUT NOCOPY okl_sif_ret_levels_v_rec_type
798: ) IS
799: BEGIN
800: p_to.id := p_from.id;
801: p_to.level_index_number := p_from.level_index_number;
837: ---------------------------------------------------------------------------
838: -- PROCEDURE validate_row
839: ---------------------------------------------------------------------------
840: -------------------------------------------
841: -- validate_row for:OKL_SIF_RET_LEVELS_V --
842: -------------------------------------------
843: PROCEDURE validate_row(
844: p_api_version IN NUMBER,
845: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
845: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
846: x_return_status OUT NOCOPY VARCHAR2,
847: x_msg_count OUT NOCOPY NUMBER,
848: x_msg_data OUT NOCOPY VARCHAR2,
849: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type) IS
850:
851: l_api_version CONSTANT NUMBER := 1;
852: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
853: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
850:
851: l_api_version CONSTANT NUMBER := 1;
852: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
853: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
854: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
855: l_srl_rec srl_rec_type;
856: l_srl_rec srl_rec_type;
857: BEGIN
858: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
867: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
868: RAISE OKC_API.G_EXCEPTION_ERROR;
869: END IF;
870: --- Validate all non-missing attributes (Item Level Validation)
871: l_return_status := Validate_Attributes(l_okl_sif_ret_levels_v_rec);
872: --- If any errors happen abort API
873: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
874: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
875: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
874: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
875: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
876: RAISE OKC_API.G_EXCEPTION_ERROR;
877: END IF;
878: l_return_status := Validate_Record(l_okl_sif_ret_levels_v_rec);
879: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
880: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
881: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
882: RAISE OKC_API.G_EXCEPTION_ERROR;
914: '_PVT'
915: );
916: END validate_row;
917: ------------------------------------------------------
918: -- PL/SQL TBL validate_row for:OKL_SIF_RET_LEVELS_V --
919: ------------------------------------------------------
920: PROCEDURE validate_row(
921: p_api_version IN NUMBER,
922: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
922: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
923: x_return_status OUT NOCOPY VARCHAR2,
924: x_msg_count OUT NOCOPY NUMBER,
925: x_msg_data OUT NOCOPY VARCHAR2,
926: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
927: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
928:
929: l_api_version CONSTANT NUMBER := 1;
930: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_validate_row';
931: i NUMBER := 0;
932: BEGIN
933: OKC_API.init_msg_list(p_init_msg_list);
934: -- Make sure PL/SQL table has records in it before passing
935: IF (p_okl_sif_ret_levels_v_tbl.COUNT > 0) THEN
936: i := p_okl_sif_ret_levels_v_tbl.FIRST;
937: LOOP
938: DECLARE
939: l_error_rec OKC_API.ERROR_REC_TYPE;
932: BEGIN
933: OKC_API.init_msg_list(p_init_msg_list);
934: -- Make sure PL/SQL table has records in it before passing
935: IF (p_okl_sif_ret_levels_v_tbl.COUNT > 0) THEN
936: i := p_okl_sif_ret_levels_v_tbl.FIRST;
937: LOOP
938: DECLARE
939: l_error_rec OKC_API.ERROR_REC_TYPE;
940: BEGIN
946: p_init_msg_list => OKC_API.G_FALSE,
947: x_return_status => l_error_rec.error_type,
948: x_msg_count => l_error_rec.msg_count,
949: x_msg_data => l_error_rec.msg_data,
950: p_okl_sif_ret_levels_v_rec => p_okl_sif_ret_levels_v_tbl(i));
951: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
952: l_error_rec.SQLCODE := SQLCODE;
953: load_error_tbl(l_error_rec, px_error_tbl);
954: ELSE
968: l_error_rec.error_type := 'OTHERS';
969: l_error_rec.SQLCODE := SQLCODE;
970: load_error_tbl(l_error_rec, px_error_tbl);
971: END;
972: EXIT WHEN (i = p_okl_sif_ret_levels_v_tbl.LAST);
973: i := p_okl_sif_ret_levels_v_tbl.NEXT(i);
974: END LOOP;
975: END IF;
976: -- Loop through the error_tbl to find the error with the highest severity
969: l_error_rec.SQLCODE := SQLCODE;
970: load_error_tbl(l_error_rec, px_error_tbl);
971: END;
972: EXIT WHEN (i = p_okl_sif_ret_levels_v_tbl.LAST);
973: i := p_okl_sif_ret_levels_v_tbl.NEXT(i);
974: END LOOP;
975: END IF;
976: -- Loop through the error_tbl to find the error with the highest severity
977: -- and return it.
1010: );
1011: END validate_row;
1012:
1013: ------------------------------------------------------
1014: -- PL/SQL TBL validate_row for:OKL_SIF_RET_LEVELS_V --
1015: ------------------------------------------------------
1016: PROCEDURE validate_row(
1017: p_api_version IN NUMBER,
1018: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1018: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1019: x_return_status OUT NOCOPY VARCHAR2,
1020: x_msg_count OUT NOCOPY NUMBER,
1021: x_msg_data OUT NOCOPY VARCHAR2,
1022: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type) IS
1023:
1024: l_api_version CONSTANT NUMBER := 1;
1025: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
1026: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1027: l_error_tbl OKC_API.ERROR_TBL_TYPE;
1028: BEGIN
1029: OKC_API.init_msg_list(p_init_msg_list);
1030: -- Make sure PL/SQL table has records in it before passing
1031: IF (p_okl_sif_ret_levels_v_tbl.COUNT > 0) THEN
1032: validate_row (
1033: p_api_version => p_api_version,
1034: p_init_msg_list => OKC_API.G_FALSE,
1035: x_return_status => x_return_status,
1034: p_init_msg_list => OKC_API.G_FALSE,
1035: x_return_status => x_return_status,
1036: x_msg_count => x_msg_count,
1037: x_msg_data => x_msg_data,
1038: p_okl_sif_ret_levels_v_tbl => p_okl_sif_ret_levels_v_tbl,
1039: px_error_tbl => l_error_tbl);
1040: END IF;
1041: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1042: EXCEPTION
1233: '_PVT'
1234: );
1235: END insert_row;
1236: ------------------------------------------
1237: -- insert_row for :OKL_SIF_RET_LEVELS_V --
1238: ------------------------------------------
1239: PROCEDURE insert_row(
1240: p_api_version IN NUMBER,
1241: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1241: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1242: x_return_status OUT NOCOPY VARCHAR2,
1243: x_msg_count OUT NOCOPY NUMBER,
1244: x_msg_data OUT NOCOPY VARCHAR2,
1245: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
1246: x_okl_sif_ret_levels_v_rec OUT NOCOPY okl_sif_ret_levels_v_rec_type) IS
1247:
1248: l_api_version CONSTANT NUMBER := 1;
1249: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1242: x_return_status OUT NOCOPY VARCHAR2,
1243: x_msg_count OUT NOCOPY NUMBER,
1244: x_msg_data OUT NOCOPY VARCHAR2,
1245: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
1246: x_okl_sif_ret_levels_v_rec OUT NOCOPY okl_sif_ret_levels_v_rec_type) IS
1247:
1248: l_api_version CONSTANT NUMBER := 1;
1249: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1250: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1247:
1248: l_api_version CONSTANT NUMBER := 1;
1249: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1250: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1251: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
1252: l_def_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type;
1253: l_srl_rec srl_rec_type;
1254: lx_srl_rec srl_rec_type;
1255: -------------------------------
1248: l_api_version CONSTANT NUMBER := 1;
1249: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1250: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1251: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
1252: l_def_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type;
1253: l_srl_rec srl_rec_type;
1254: lx_srl_rec srl_rec_type;
1255: -------------------------------
1256: -- FUNCTION fill_who_columns --
1255: -------------------------------
1256: -- FUNCTION fill_who_columns --
1257: -------------------------------
1258: FUNCTION fill_who_columns (
1259: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
1260: ) RETURN okl_sif_ret_levels_v_rec_type IS
1261: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
1262: BEGIN
1263: l_okl_sif_ret_levels_v_rec.CREATION_DATE := SYSDATE;
1256: -- FUNCTION fill_who_columns --
1257: -------------------------------
1258: FUNCTION fill_who_columns (
1259: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
1260: ) RETURN okl_sif_ret_levels_v_rec_type IS
1261: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
1262: BEGIN
1263: l_okl_sif_ret_levels_v_rec.CREATION_DATE := SYSDATE;
1264: l_okl_sif_ret_levels_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1257: -------------------------------
1258: FUNCTION fill_who_columns (
1259: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
1260: ) RETURN okl_sif_ret_levels_v_rec_type IS
1261: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
1262: BEGIN
1263: l_okl_sif_ret_levels_v_rec.CREATION_DATE := SYSDATE;
1264: l_okl_sif_ret_levels_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1265: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_DATE := l_okl_sif_ret_levels_v_rec.CREATION_DATE;
1259: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
1260: ) RETURN okl_sif_ret_levels_v_rec_type IS
1261: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
1262: BEGIN
1263: l_okl_sif_ret_levels_v_rec.CREATION_DATE := SYSDATE;
1264: l_okl_sif_ret_levels_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1265: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_DATE := l_okl_sif_ret_levels_v_rec.CREATION_DATE;
1266: l_okl_sif_ret_levels_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1267: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1260: ) RETURN okl_sif_ret_levels_v_rec_type IS
1261: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
1262: BEGIN
1263: l_okl_sif_ret_levels_v_rec.CREATION_DATE := SYSDATE;
1264: l_okl_sif_ret_levels_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1265: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_DATE := l_okl_sif_ret_levels_v_rec.CREATION_DATE;
1266: l_okl_sif_ret_levels_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1267: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1268: RETURN(l_okl_sif_ret_levels_v_rec);
1261: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
1262: BEGIN
1263: l_okl_sif_ret_levels_v_rec.CREATION_DATE := SYSDATE;
1264: l_okl_sif_ret_levels_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1265: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_DATE := l_okl_sif_ret_levels_v_rec.CREATION_DATE;
1266: l_okl_sif_ret_levels_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1267: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1268: RETURN(l_okl_sif_ret_levels_v_rec);
1269: END fill_who_columns;
1262: BEGIN
1263: l_okl_sif_ret_levels_v_rec.CREATION_DATE := SYSDATE;
1264: l_okl_sif_ret_levels_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1265: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_DATE := l_okl_sif_ret_levels_v_rec.CREATION_DATE;
1266: l_okl_sif_ret_levels_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1267: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1268: RETURN(l_okl_sif_ret_levels_v_rec);
1269: END fill_who_columns;
1270: ---------------------------------------------
1263: l_okl_sif_ret_levels_v_rec.CREATION_DATE := SYSDATE;
1264: l_okl_sif_ret_levels_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1265: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_DATE := l_okl_sif_ret_levels_v_rec.CREATION_DATE;
1266: l_okl_sif_ret_levels_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1267: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1268: RETURN(l_okl_sif_ret_levels_v_rec);
1269: END fill_who_columns;
1270: ---------------------------------------------
1271: -- Set_Attributes for:OKL_SIF_RET_LEVELS_V --
1264: l_okl_sif_ret_levels_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1265: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_DATE := l_okl_sif_ret_levels_v_rec.CREATION_DATE;
1266: l_okl_sif_ret_levels_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1267: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1268: RETURN(l_okl_sif_ret_levels_v_rec);
1269: END fill_who_columns;
1270: ---------------------------------------------
1271: -- Set_Attributes for:OKL_SIF_RET_LEVELS_V --
1272: ---------------------------------------------
1267: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1268: RETURN(l_okl_sif_ret_levels_v_rec);
1269: END fill_who_columns;
1270: ---------------------------------------------
1271: -- Set_Attributes for:OKL_SIF_RET_LEVELS_V --
1272: ---------------------------------------------
1273: FUNCTION Set_Attributes (
1274: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
1275: x_okl_sif_ret_levels_v_rec OUT NOCOPY okl_sif_ret_levels_v_rec_type
1270: ---------------------------------------------
1271: -- Set_Attributes for:OKL_SIF_RET_LEVELS_V --
1272: ---------------------------------------------
1273: FUNCTION Set_Attributes (
1274: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
1275: x_okl_sif_ret_levels_v_rec OUT NOCOPY okl_sif_ret_levels_v_rec_type
1276: ) RETURN VARCHAR2 IS
1277: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1278: BEGIN
1271: -- Set_Attributes for:OKL_SIF_RET_LEVELS_V --
1272: ---------------------------------------------
1273: FUNCTION Set_Attributes (
1274: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
1275: x_okl_sif_ret_levels_v_rec OUT NOCOPY okl_sif_ret_levels_v_rec_type
1276: ) RETURN VARCHAR2 IS
1277: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1278: BEGIN
1279: x_okl_sif_ret_levels_v_rec := p_okl_sif_ret_levels_v_rec;
1275: x_okl_sif_ret_levels_v_rec OUT NOCOPY okl_sif_ret_levels_v_rec_type
1276: ) RETURN VARCHAR2 IS
1277: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1278: BEGIN
1279: x_okl_sif_ret_levels_v_rec := p_okl_sif_ret_levels_v_rec;
1280: x_okl_sif_ret_levels_v_rec.OBJECT_VERSION_NUMBER := 1;
1281: RETURN(l_return_status);
1282: END Set_Attributes;
1283: BEGIN
1276: ) RETURN VARCHAR2 IS
1277: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1278: BEGIN
1279: x_okl_sif_ret_levels_v_rec := p_okl_sif_ret_levels_v_rec;
1280: x_okl_sif_ret_levels_v_rec.OBJECT_VERSION_NUMBER := 1;
1281: RETURN(l_return_status);
1282: END Set_Attributes;
1283: BEGIN
1284: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1292: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1293: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1294: RAISE OKC_API.G_EXCEPTION_ERROR;
1295: END IF;
1296: l_okl_sif_ret_levels_v_rec := null_out_defaults(p_okl_sif_ret_levels_v_rec);
1297: -- Set primary key value
1298: l_okl_sif_ret_levels_v_rec.ID := get_seq_id;
1299: -- Setting item attributes
1300: l_return_Status := Set_Attributes(
1294: RAISE OKC_API.G_EXCEPTION_ERROR;
1295: END IF;
1296: l_okl_sif_ret_levels_v_rec := null_out_defaults(p_okl_sif_ret_levels_v_rec);
1297: -- Set primary key value
1298: l_okl_sif_ret_levels_v_rec.ID := get_seq_id;
1299: -- Setting item attributes
1300: l_return_Status := Set_Attributes(
1301: l_okl_sif_ret_levels_v_rec, -- IN
1302: l_def_okl_sif_ret_levels_v_rec); -- OUT
1297: -- Set primary key value
1298: l_okl_sif_ret_levels_v_rec.ID := get_seq_id;
1299: -- Setting item attributes
1300: l_return_Status := Set_Attributes(
1301: l_okl_sif_ret_levels_v_rec, -- IN
1302: l_def_okl_sif_ret_levels_v_rec); -- OUT
1303: --- If any errors happen abort API
1304: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1305: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1298: l_okl_sif_ret_levels_v_rec.ID := get_seq_id;
1299: -- Setting item attributes
1300: l_return_Status := Set_Attributes(
1301: l_okl_sif_ret_levels_v_rec, -- IN
1302: l_def_okl_sif_ret_levels_v_rec); -- OUT
1303: --- If any errors happen abort API
1304: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1305: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1306: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1305: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1306: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1307: RAISE OKC_API.G_EXCEPTION_ERROR;
1308: END IF;
1309: l_def_okl_sif_ret_levels_v_rec := fill_who_columns(l_def_okl_sif_ret_levels_v_rec);
1310: --- Validate all non-missing attributes (Item Level Validation)
1311: l_return_status := Validate_Attributes(l_def_okl_sif_ret_levels_v_rec);
1312: --- If any errors happen abort API
1313: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1307: RAISE OKC_API.G_EXCEPTION_ERROR;
1308: END IF;
1309: l_def_okl_sif_ret_levels_v_rec := fill_who_columns(l_def_okl_sif_ret_levels_v_rec);
1310: --- Validate all non-missing attributes (Item Level Validation)
1311: l_return_status := Validate_Attributes(l_def_okl_sif_ret_levels_v_rec);
1312: --- If any errors happen abort API
1313: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1314: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1315: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1314: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1315: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1316: RAISE OKC_API.G_EXCEPTION_ERROR;
1317: END IF;
1318: l_return_status := Validate_Record(l_def_okl_sif_ret_levels_v_rec);
1319: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1320: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1321: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1322: RAISE OKC_API.G_EXCEPTION_ERROR;
1323: END IF;
1324: -----------------------------------------
1325: -- Move VIEW record to "Child" records --
1326: -----------------------------------------
1327: migrate(l_def_okl_sif_ret_levels_v_rec, l_srl_rec);
1328: -----------------------------------------------
1329: -- Call the INSERT_ROW for each child record --
1330: -----------------------------------------------
1331: insert_row(
1340: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1341: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1342: RAISE OKC_API.G_EXCEPTION_ERROR;
1343: END IF;
1344: migrate(lx_srl_rec, l_def_okl_sif_ret_levels_v_rec);
1345: -- Set OUT values
1346: x_okl_sif_ret_levels_v_rec := l_def_okl_sif_ret_levels_v_rec;
1347: x_return_status := l_return_status;
1348: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1342: RAISE OKC_API.G_EXCEPTION_ERROR;
1343: END IF;
1344: migrate(lx_srl_rec, l_def_okl_sif_ret_levels_v_rec);
1345: -- Set OUT values
1346: x_okl_sif_ret_levels_v_rec := l_def_okl_sif_ret_levels_v_rec;
1347: x_return_status := l_return_status;
1348: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1349: EXCEPTION
1350: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1378: '_PVT'
1379: );
1380: END insert_row;
1381: --------------------------------------------------------
1382: -- PL/SQL TBL insert_row for:OKL_SIF_RET_LEVELS_V_TBL --
1383: --------------------------------------------------------
1384: PROCEDURE insert_row(
1385: p_api_version IN NUMBER,
1386: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1386: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1387: x_return_status OUT NOCOPY VARCHAR2,
1388: x_msg_count OUT NOCOPY NUMBER,
1389: x_msg_data OUT NOCOPY VARCHAR2,
1390: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
1391: x_okl_sif_ret_levels_v_tbl OUT NOCOPY okl_sif_ret_levels_v_tbl_type,
1392: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
1393:
1394: l_api_version CONSTANT NUMBER := 1;
1387: x_return_status OUT NOCOPY VARCHAR2,
1388: x_msg_count OUT NOCOPY NUMBER,
1389: x_msg_data OUT NOCOPY VARCHAR2,
1390: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
1391: x_okl_sif_ret_levels_v_tbl OUT NOCOPY okl_sif_ret_levels_v_tbl_type,
1392: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
1393:
1394: l_api_version CONSTANT NUMBER := 1;
1395: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
1396: i NUMBER := 0;
1397: BEGIN
1398: OKC_API.init_msg_list(p_init_msg_list);
1399: -- Make sure PL/SQL table has records in it before passing
1400: IF (p_okl_sif_ret_levels_v_tbl.COUNT > 0) THEN
1401: i := p_okl_sif_ret_levels_v_tbl.FIRST;
1402: LOOP
1403: DECLARE
1404: l_error_rec OKC_API.ERROR_REC_TYPE;
1397: BEGIN
1398: OKC_API.init_msg_list(p_init_msg_list);
1399: -- Make sure PL/SQL table has records in it before passing
1400: IF (p_okl_sif_ret_levels_v_tbl.COUNT > 0) THEN
1401: i := p_okl_sif_ret_levels_v_tbl.FIRST;
1402: LOOP
1403: DECLARE
1404: l_error_rec OKC_API.ERROR_REC_TYPE;
1405: BEGIN
1411: p_init_msg_list => OKC_API.G_FALSE,
1412: x_return_status => l_error_rec.error_type,
1413: x_msg_count => l_error_rec.msg_count,
1414: x_msg_data => l_error_rec.msg_data,
1415: p_okl_sif_ret_levels_v_rec => p_okl_sif_ret_levels_v_tbl(i),
1416: x_okl_sif_ret_levels_v_rec => x_okl_sif_ret_levels_v_tbl(i));
1417: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
1418: l_error_rec.SQLCODE := SQLCODE;
1419: load_error_tbl(l_error_rec, px_error_tbl);
1412: x_return_status => l_error_rec.error_type,
1413: x_msg_count => l_error_rec.msg_count,
1414: x_msg_data => l_error_rec.msg_data,
1415: p_okl_sif_ret_levels_v_rec => p_okl_sif_ret_levels_v_tbl(i),
1416: x_okl_sif_ret_levels_v_rec => x_okl_sif_ret_levels_v_tbl(i));
1417: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
1418: l_error_rec.SQLCODE := SQLCODE;
1419: load_error_tbl(l_error_rec, px_error_tbl);
1420: ELSE
1434: l_error_rec.error_type := 'OTHERS';
1435: l_error_rec.SQLCODE := SQLCODE;
1436: load_error_tbl(l_error_rec, px_error_tbl);
1437: END;
1438: EXIT WHEN (i = p_okl_sif_ret_levels_v_tbl.LAST);
1439: i := p_okl_sif_ret_levels_v_tbl.NEXT(i);
1440: END LOOP;
1441: END IF;
1442: -- Loop through the error_tbl to find the error with the highest severity
1435: l_error_rec.SQLCODE := SQLCODE;
1436: load_error_tbl(l_error_rec, px_error_tbl);
1437: END;
1438: EXIT WHEN (i = p_okl_sif_ret_levels_v_tbl.LAST);
1439: i := p_okl_sif_ret_levels_v_tbl.NEXT(i);
1440: END LOOP;
1441: END IF;
1442: -- Loop through the error_tbl to find the error with the highest severity
1443: -- and return it.
1476: );
1477: END insert_row;
1478:
1479: --------------------------------------------------------
1480: -- PL/SQL TBL insert_row for:OKL_SIF_RET_LEVELS_V_TBL --
1481: --------------------------------------------------------
1482: PROCEDURE insert_row(
1483: p_api_version IN NUMBER,
1484: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1484: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1485: x_return_status OUT NOCOPY VARCHAR2,
1486: x_msg_count OUT NOCOPY NUMBER,
1487: x_msg_data OUT NOCOPY VARCHAR2,
1488: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
1489: x_okl_sif_ret_levels_v_tbl OUT NOCOPY okl_sif_ret_levels_v_tbl_type) IS
1490:
1491: l_api_version CONSTANT NUMBER := 1;
1492: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1485: x_return_status OUT NOCOPY VARCHAR2,
1486: x_msg_count OUT NOCOPY NUMBER,
1487: x_msg_data OUT NOCOPY VARCHAR2,
1488: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
1489: x_okl_sif_ret_levels_v_tbl OUT NOCOPY okl_sif_ret_levels_v_tbl_type) IS
1490:
1491: l_api_version CONSTANT NUMBER := 1;
1492: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1493: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1494: l_error_tbl OKC_API.ERROR_TBL_TYPE;
1495: BEGIN
1496: OKC_API.init_msg_list(p_init_msg_list);
1497: -- Make sure PL/SQL table has records in it before passing
1498: IF (p_okl_sif_ret_levels_v_tbl.COUNT > 0) THEN
1499: insert_row (
1500: p_api_version => p_api_version,
1501: p_init_msg_list => OKC_API.G_FALSE,
1502: x_return_status => x_return_status,
1501: p_init_msg_list => OKC_API.G_FALSE,
1502: x_return_status => x_return_status,
1503: x_msg_count => x_msg_count,
1504: x_msg_data => x_msg_data,
1505: p_okl_sif_ret_levels_v_tbl => p_okl_sif_ret_levels_v_tbl,
1506: x_okl_sif_ret_levels_v_tbl => x_okl_sif_ret_levels_v_tbl,
1507: px_error_tbl => l_error_tbl);
1508: END IF;
1509: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1502: x_return_status => x_return_status,
1503: x_msg_count => x_msg_count,
1504: x_msg_data => x_msg_data,
1505: p_okl_sif_ret_levels_v_tbl => p_okl_sif_ret_levels_v_tbl,
1506: x_okl_sif_ret_levels_v_tbl => x_okl_sif_ret_levels_v_tbl,
1507: px_error_tbl => l_error_tbl);
1508: END IF;
1509: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1510: EXCEPTION
1650: '_PVT'
1651: );
1652: END lock_row;
1653: ----------------------------------------
1654: -- lock_row for: OKL_SIF_RET_LEVELS_V --
1655: ----------------------------------------
1656: PROCEDURE lock_row(
1657: p_api_version IN NUMBER,
1658: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1658: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1659: x_return_status OUT NOCOPY VARCHAR2,
1660: x_msg_count OUT NOCOPY NUMBER,
1661: x_msg_data OUT NOCOPY VARCHAR2,
1662: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type) IS
1663:
1664: l_api_version CONSTANT NUMBER := 1;
1665: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1666: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1680: END IF;
1681: -----------------------------------------
1682: -- Move VIEW record to "Child" records --
1683: -----------------------------------------
1684: migrate(p_okl_sif_ret_levels_v_rec, l_srl_rec);
1685: ---------------------------------------------
1686: -- Call the LOCK_ROW for each child record --
1687: ---------------------------------------------
1688: lock_row(
1731: '_PVT'
1732: );
1733: END lock_row;
1734: ------------------------------------------------------
1735: -- PL/SQL TBL lock_row for:OKL_SIF_RET_LEVELS_V_TBL --
1736: ------------------------------------------------------
1737: PROCEDURE lock_row(
1738: p_api_version IN NUMBER,
1739: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1739: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1740: x_return_status OUT NOCOPY VARCHAR2,
1741: x_msg_count OUT NOCOPY NUMBER,
1742: x_msg_data OUT NOCOPY VARCHAR2,
1743: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
1744: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
1745:
1746: l_api_version CONSTANT NUMBER := 1;
1747: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_lock_row';
1748: i NUMBER := 0;
1749: BEGIN
1750: OKC_API.init_msg_list(p_init_msg_list);
1751: -- Make sure PL/SQL table has recrods in it before passing
1752: IF (p_okl_sif_ret_levels_v_tbl.COUNT > 0) THEN
1753: i := p_okl_sif_ret_levels_v_tbl.FIRST;
1754: LOOP
1755: DECLARE
1756: l_error_rec OKC_API.ERROR_REC_TYPE;
1749: BEGIN
1750: OKC_API.init_msg_list(p_init_msg_list);
1751: -- Make sure PL/SQL table has recrods in it before passing
1752: IF (p_okl_sif_ret_levels_v_tbl.COUNT > 0) THEN
1753: i := p_okl_sif_ret_levels_v_tbl.FIRST;
1754: LOOP
1755: DECLARE
1756: l_error_rec OKC_API.ERROR_REC_TYPE;
1757: BEGIN
1763: p_init_msg_list => OKC_API.G_FALSE,
1764: x_return_status => l_error_rec.error_type,
1765: x_msg_count => l_error_rec.msg_count,
1766: x_msg_data => l_error_rec.msg_data,
1767: p_okl_sif_ret_levels_v_rec => p_okl_sif_ret_levels_v_tbl(i));
1768: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
1769: l_error_rec.SQLCODE := SQLCODE;
1770: load_error_tbl(l_error_rec, px_error_tbl);
1771: ELSE
1785: l_error_rec.error_type := 'OTHERS';
1786: l_error_rec.SQLCODE := SQLCODE;
1787: load_error_tbl(l_error_rec, px_error_tbl);
1788: END;
1789: EXIT WHEN (i = p_okl_sif_ret_levels_v_tbl.LAST);
1790: i := p_okl_sif_ret_levels_v_tbl.NEXT(i);
1791: END LOOP;
1792: END IF;
1793: -- Loop through the error_tbl to find the error with the highest severity
1786: l_error_rec.SQLCODE := SQLCODE;
1787: load_error_tbl(l_error_rec, px_error_tbl);
1788: END;
1789: EXIT WHEN (i = p_okl_sif_ret_levels_v_tbl.LAST);
1790: i := p_okl_sif_ret_levels_v_tbl.NEXT(i);
1791: END LOOP;
1792: END IF;
1793: -- Loop through the error_tbl to find the error with the highest severity
1794: -- and return it.
1826: '_PVT'
1827: );
1828: END lock_row;
1829: ------------------------------------------------------
1830: -- PL/SQL TBL lock_row for:OKL_SIF_RET_LEVELS_V_TBL --
1831: ------------------------------------------------------
1832: PROCEDURE lock_row(
1833: p_api_version IN NUMBER,
1834: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1834: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1835: x_return_status OUT NOCOPY VARCHAR2,
1836: x_msg_count OUT NOCOPY NUMBER,
1837: x_msg_data OUT NOCOPY VARCHAR2,
1838: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type) IS
1839:
1840: l_api_version CONSTANT NUMBER := 1;
1841: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1842: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1843: l_error_tbl OKC_API.ERROR_TBL_TYPE;
1844: BEGIN
1845: OKC_API.init_msg_list(p_init_msg_list);
1846: -- Make sure PL/SQL table has recrods in it before passing
1847: IF (p_okl_sif_ret_levels_v_tbl.COUNT > 0) THEN
1848: lock_row(
1849: p_api_version => p_api_version,
1850: p_init_msg_list => OKC_API.G_FALSE,
1851: x_return_status => x_return_status,
1850: p_init_msg_list => OKC_API.G_FALSE,
1851: x_return_status => x_return_status,
1852: x_msg_count => x_msg_count,
1853: x_msg_data => x_msg_data,
1854: p_okl_sif_ret_levels_v_tbl => p_okl_sif_ret_levels_v_tbl,
1855: px_error_tbl => l_error_tbl);
1856: END IF;
1857: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1858: EXCEPTION
2182: '_PVT'
2183: );
2184: END update_row;
2185: -----------------------------------------
2186: -- update_row for:OKL_SIF_RET_LEVELS_V --
2187: -----------------------------------------
2188: PROCEDURE update_row(
2189: p_api_version IN NUMBER,
2190: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2190: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2191: x_return_status OUT NOCOPY VARCHAR2,
2192: x_msg_count OUT NOCOPY NUMBER,
2193: x_msg_data OUT NOCOPY VARCHAR2,
2194: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
2195: x_okl_sif_ret_levels_v_rec OUT NOCOPY okl_sif_ret_levels_v_rec_type) IS
2196:
2197: l_api_version CONSTANT NUMBER := 1;
2198: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2191: x_return_status OUT NOCOPY VARCHAR2,
2192: x_msg_count OUT NOCOPY NUMBER,
2193: x_msg_data OUT NOCOPY VARCHAR2,
2194: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
2195: x_okl_sif_ret_levels_v_rec OUT NOCOPY okl_sif_ret_levels_v_rec_type) IS
2196:
2197: l_api_version CONSTANT NUMBER := 1;
2198: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2199: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2196:
2197: l_api_version CONSTANT NUMBER := 1;
2198: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2199: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2200: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
2201: l_def_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type;
2202: l_db_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type;
2203: l_srl_rec srl_rec_type;
2204: lx_srl_rec srl_rec_type;
2197: l_api_version CONSTANT NUMBER := 1;
2198: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2199: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2200: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
2201: l_def_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type;
2202: l_db_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type;
2203: l_srl_rec srl_rec_type;
2204: lx_srl_rec srl_rec_type;
2205: -------------------------------
2198: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2199: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2200: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
2201: l_def_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type;
2202: l_db_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type;
2203: l_srl_rec srl_rec_type;
2204: lx_srl_rec srl_rec_type;
2205: -------------------------------
2206: -- FUNCTION fill_who_columns --
2205: -------------------------------
2206: -- FUNCTION fill_who_columns --
2207: -------------------------------
2208: FUNCTION fill_who_columns (
2209: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
2210: ) RETURN okl_sif_ret_levels_v_rec_type IS
2211: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
2212: BEGIN
2213: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_DATE := SYSDATE;
2206: -- FUNCTION fill_who_columns --
2207: -------------------------------
2208: FUNCTION fill_who_columns (
2209: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
2210: ) RETURN okl_sif_ret_levels_v_rec_type IS
2211: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
2212: BEGIN
2213: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_DATE := SYSDATE;
2214: l_okl_sif_ret_levels_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2207: -------------------------------
2208: FUNCTION fill_who_columns (
2209: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
2210: ) RETURN okl_sif_ret_levels_v_rec_type IS
2211: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
2212: BEGIN
2213: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_DATE := SYSDATE;
2214: l_okl_sif_ret_levels_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2215: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2209: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
2210: ) RETURN okl_sif_ret_levels_v_rec_type IS
2211: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
2212: BEGIN
2213: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_DATE := SYSDATE;
2214: l_okl_sif_ret_levels_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2215: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2216: RETURN(l_okl_sif_ret_levels_v_rec);
2217: END fill_who_columns;
2210: ) RETURN okl_sif_ret_levels_v_rec_type IS
2211: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
2212: BEGIN
2213: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_DATE := SYSDATE;
2214: l_okl_sif_ret_levels_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2215: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2216: RETURN(l_okl_sif_ret_levels_v_rec);
2217: END fill_who_columns;
2218: ----------------------------------
2211: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
2212: BEGIN
2213: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_DATE := SYSDATE;
2214: l_okl_sif_ret_levels_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2215: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2216: RETURN(l_okl_sif_ret_levels_v_rec);
2217: END fill_who_columns;
2218: ----------------------------------
2219: -- FUNCTION populate_new_record --
2212: BEGIN
2213: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_DATE := SYSDATE;
2214: l_okl_sif_ret_levels_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2215: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2216: RETURN(l_okl_sif_ret_levels_v_rec);
2217: END fill_who_columns;
2218: ----------------------------------
2219: -- FUNCTION populate_new_record --
2220: ----------------------------------
2218: ----------------------------------
2219: -- FUNCTION populate_new_record --
2220: ----------------------------------
2221: FUNCTION populate_new_record (
2222: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
2223: x_okl_sif_ret_levels_v_rec OUT NOCOPY okl_sif_ret_levels_v_rec_type
2224: ) RETURN VARCHAR2 IS
2225: l_row_notfound BOOLEAN := TRUE;
2226: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2219: -- FUNCTION populate_new_record --
2220: ----------------------------------
2221: FUNCTION populate_new_record (
2222: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
2223: x_okl_sif_ret_levels_v_rec OUT NOCOPY okl_sif_ret_levels_v_rec_type
2224: ) RETURN VARCHAR2 IS
2225: l_row_notfound BOOLEAN := TRUE;
2226: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2227: BEGIN
2224: ) RETURN VARCHAR2 IS
2225: l_row_notfound BOOLEAN := TRUE;
2226: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2227: BEGIN
2228: x_okl_sif_ret_levels_v_rec := p_okl_sif_ret_levels_v_rec;
2229: -- Get current database values
2230: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
2231: -- so it may be verified through LOCK_ROW.
2232: l_db_okl_sif_ret_levels_v_rec := get_rec(p_okl_sif_ret_levels_v_rec, l_return_status);
2228: x_okl_sif_ret_levels_v_rec := p_okl_sif_ret_levels_v_rec;
2229: -- Get current database values
2230: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
2231: -- so it may be verified through LOCK_ROW.
2232: l_db_okl_sif_ret_levels_v_rec := get_rec(p_okl_sif_ret_levels_v_rec, l_return_status);
2233: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2234: IF (x_okl_sif_ret_levels_v_rec.id = OKC_API.G_MISS_NUM)
2235: THEN
2236: x_okl_sif_ret_levels_v_rec.id := l_db_okl_sif_ret_levels_v_rec.id;
2230: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
2231: -- so it may be verified through LOCK_ROW.
2232: l_db_okl_sif_ret_levels_v_rec := get_rec(p_okl_sif_ret_levels_v_rec, l_return_status);
2233: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2234: IF (x_okl_sif_ret_levels_v_rec.id = OKC_API.G_MISS_NUM)
2235: THEN
2236: x_okl_sif_ret_levels_v_rec.id := l_db_okl_sif_ret_levels_v_rec.id;
2237: END IF;
2238: IF (x_okl_sif_ret_levels_v_rec.level_index_number = OKC_API.G_MISS_NUM)
2232: l_db_okl_sif_ret_levels_v_rec := get_rec(p_okl_sif_ret_levels_v_rec, l_return_status);
2233: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2234: IF (x_okl_sif_ret_levels_v_rec.id = OKC_API.G_MISS_NUM)
2235: THEN
2236: x_okl_sif_ret_levels_v_rec.id := l_db_okl_sif_ret_levels_v_rec.id;
2237: END IF;
2238: IF (x_okl_sif_ret_levels_v_rec.level_index_number = OKC_API.G_MISS_NUM)
2239: THEN
2240: x_okl_sif_ret_levels_v_rec.level_index_number := l_db_okl_sif_ret_levels_v_rec.level_index_number;
2234: IF (x_okl_sif_ret_levels_v_rec.id = OKC_API.G_MISS_NUM)
2235: THEN
2236: x_okl_sif_ret_levels_v_rec.id := l_db_okl_sif_ret_levels_v_rec.id;
2237: END IF;
2238: IF (x_okl_sif_ret_levels_v_rec.level_index_number = OKC_API.G_MISS_NUM)
2239: THEN
2240: x_okl_sif_ret_levels_v_rec.level_index_number := l_db_okl_sif_ret_levels_v_rec.level_index_number;
2241: END IF;
2242: IF (x_okl_sif_ret_levels_v_rec.number_of_periods = OKC_API.G_MISS_NUM)
2236: x_okl_sif_ret_levels_v_rec.id := l_db_okl_sif_ret_levels_v_rec.id;
2237: END IF;
2238: IF (x_okl_sif_ret_levels_v_rec.level_index_number = OKC_API.G_MISS_NUM)
2239: THEN
2240: x_okl_sif_ret_levels_v_rec.level_index_number := l_db_okl_sif_ret_levels_v_rec.level_index_number;
2241: END IF;
2242: IF (x_okl_sif_ret_levels_v_rec.number_of_periods = OKC_API.G_MISS_NUM)
2243: THEN
2244: x_okl_sif_ret_levels_v_rec.number_of_periods := l_db_okl_sif_ret_levels_v_rec.number_of_periods;
2238: IF (x_okl_sif_ret_levels_v_rec.level_index_number = OKC_API.G_MISS_NUM)
2239: THEN
2240: x_okl_sif_ret_levels_v_rec.level_index_number := l_db_okl_sif_ret_levels_v_rec.level_index_number;
2241: END IF;
2242: IF (x_okl_sif_ret_levels_v_rec.number_of_periods = OKC_API.G_MISS_NUM)
2243: THEN
2244: x_okl_sif_ret_levels_v_rec.number_of_periods := l_db_okl_sif_ret_levels_v_rec.number_of_periods;
2245: END IF;
2246: IF (x_okl_sif_ret_levels_v_rec.sir_id = OKC_API.G_MISS_NUM)
2240: x_okl_sif_ret_levels_v_rec.level_index_number := l_db_okl_sif_ret_levels_v_rec.level_index_number;
2241: END IF;
2242: IF (x_okl_sif_ret_levels_v_rec.number_of_periods = OKC_API.G_MISS_NUM)
2243: THEN
2244: x_okl_sif_ret_levels_v_rec.number_of_periods := l_db_okl_sif_ret_levels_v_rec.number_of_periods;
2245: END IF;
2246: IF (x_okl_sif_ret_levels_v_rec.sir_id = OKC_API.G_MISS_NUM)
2247: THEN
2248: x_okl_sif_ret_levels_v_rec.sir_id := l_db_okl_sif_ret_levels_v_rec.sir_id;
2242: IF (x_okl_sif_ret_levels_v_rec.number_of_periods = OKC_API.G_MISS_NUM)
2243: THEN
2244: x_okl_sif_ret_levels_v_rec.number_of_periods := l_db_okl_sif_ret_levels_v_rec.number_of_periods;
2245: END IF;
2246: IF (x_okl_sif_ret_levels_v_rec.sir_id = OKC_API.G_MISS_NUM)
2247: THEN
2248: x_okl_sif_ret_levels_v_rec.sir_id := l_db_okl_sif_ret_levels_v_rec.sir_id;
2249: END IF;
2250: IF (x_okl_sif_ret_levels_v_rec.index_number = OKC_API.G_MISS_NUM)
2244: x_okl_sif_ret_levels_v_rec.number_of_periods := l_db_okl_sif_ret_levels_v_rec.number_of_periods;
2245: END IF;
2246: IF (x_okl_sif_ret_levels_v_rec.sir_id = OKC_API.G_MISS_NUM)
2247: THEN
2248: x_okl_sif_ret_levels_v_rec.sir_id := l_db_okl_sif_ret_levels_v_rec.sir_id;
2249: END IF;
2250: IF (x_okl_sif_ret_levels_v_rec.index_number = OKC_API.G_MISS_NUM)
2251: THEN
2252: x_okl_sif_ret_levels_v_rec.index_number := l_db_okl_sif_ret_levels_v_rec.index_number;
2246: IF (x_okl_sif_ret_levels_v_rec.sir_id = OKC_API.G_MISS_NUM)
2247: THEN
2248: x_okl_sif_ret_levels_v_rec.sir_id := l_db_okl_sif_ret_levels_v_rec.sir_id;
2249: END IF;
2250: IF (x_okl_sif_ret_levels_v_rec.index_number = OKC_API.G_MISS_NUM)
2251: THEN
2252: x_okl_sif_ret_levels_v_rec.index_number := l_db_okl_sif_ret_levels_v_rec.index_number;
2253: END IF;
2254: IF (x_okl_sif_ret_levels_v_rec.level_type = OKC_API.G_MISS_CHAR)
2248: x_okl_sif_ret_levels_v_rec.sir_id := l_db_okl_sif_ret_levels_v_rec.sir_id;
2249: END IF;
2250: IF (x_okl_sif_ret_levels_v_rec.index_number = OKC_API.G_MISS_NUM)
2251: THEN
2252: x_okl_sif_ret_levels_v_rec.index_number := l_db_okl_sif_ret_levels_v_rec.index_number;
2253: END IF;
2254: IF (x_okl_sif_ret_levels_v_rec.level_type = OKC_API.G_MISS_CHAR)
2255: THEN
2256: x_okl_sif_ret_levels_v_rec.level_type := l_db_okl_sif_ret_levels_v_rec.level_type;
2250: IF (x_okl_sif_ret_levels_v_rec.index_number = OKC_API.G_MISS_NUM)
2251: THEN
2252: x_okl_sif_ret_levels_v_rec.index_number := l_db_okl_sif_ret_levels_v_rec.index_number;
2253: END IF;
2254: IF (x_okl_sif_ret_levels_v_rec.level_type = OKC_API.G_MISS_CHAR)
2255: THEN
2256: x_okl_sif_ret_levels_v_rec.level_type := l_db_okl_sif_ret_levels_v_rec.level_type;
2257: END IF;
2258: IF (x_okl_sif_ret_levels_v_rec.amount = OKC_API.G_MISS_NUM)
2252: x_okl_sif_ret_levels_v_rec.index_number := l_db_okl_sif_ret_levels_v_rec.index_number;
2253: END IF;
2254: IF (x_okl_sif_ret_levels_v_rec.level_type = OKC_API.G_MISS_CHAR)
2255: THEN
2256: x_okl_sif_ret_levels_v_rec.level_type := l_db_okl_sif_ret_levels_v_rec.level_type;
2257: END IF;
2258: IF (x_okl_sif_ret_levels_v_rec.amount = OKC_API.G_MISS_NUM)
2259: THEN
2260: x_okl_sif_ret_levels_v_rec.amount := l_db_okl_sif_ret_levels_v_rec.amount;
2254: IF (x_okl_sif_ret_levels_v_rec.level_type = OKC_API.G_MISS_CHAR)
2255: THEN
2256: x_okl_sif_ret_levels_v_rec.level_type := l_db_okl_sif_ret_levels_v_rec.level_type;
2257: END IF;
2258: IF (x_okl_sif_ret_levels_v_rec.amount = OKC_API.G_MISS_NUM)
2259: THEN
2260: x_okl_sif_ret_levels_v_rec.amount := l_db_okl_sif_ret_levels_v_rec.amount;
2261: END IF;
2262: IF (x_okl_sif_ret_levels_v_rec.advance_or_arrears = OKC_API.G_MISS_CHAR)
2256: x_okl_sif_ret_levels_v_rec.level_type := l_db_okl_sif_ret_levels_v_rec.level_type;
2257: END IF;
2258: IF (x_okl_sif_ret_levels_v_rec.amount = OKC_API.G_MISS_NUM)
2259: THEN
2260: x_okl_sif_ret_levels_v_rec.amount := l_db_okl_sif_ret_levels_v_rec.amount;
2261: END IF;
2262: IF (x_okl_sif_ret_levels_v_rec.advance_or_arrears = OKC_API.G_MISS_CHAR)
2263: THEN
2264: x_okl_sif_ret_levels_v_rec.advance_or_arrears := l_db_okl_sif_ret_levels_v_rec.advance_or_arrears;
2258: IF (x_okl_sif_ret_levels_v_rec.amount = OKC_API.G_MISS_NUM)
2259: THEN
2260: x_okl_sif_ret_levels_v_rec.amount := l_db_okl_sif_ret_levels_v_rec.amount;
2261: END IF;
2262: IF (x_okl_sif_ret_levels_v_rec.advance_or_arrears = OKC_API.G_MISS_CHAR)
2263: THEN
2264: x_okl_sif_ret_levels_v_rec.advance_or_arrears := l_db_okl_sif_ret_levels_v_rec.advance_or_arrears;
2265: END IF;
2266: IF (x_okl_sif_ret_levels_v_rec.period = OKC_API.G_MISS_CHAR)
2260: x_okl_sif_ret_levels_v_rec.amount := l_db_okl_sif_ret_levels_v_rec.amount;
2261: END IF;
2262: IF (x_okl_sif_ret_levels_v_rec.advance_or_arrears = OKC_API.G_MISS_CHAR)
2263: THEN
2264: x_okl_sif_ret_levels_v_rec.advance_or_arrears := l_db_okl_sif_ret_levels_v_rec.advance_or_arrears;
2265: END IF;
2266: IF (x_okl_sif_ret_levels_v_rec.period = OKC_API.G_MISS_CHAR)
2267: THEN
2268: x_okl_sif_ret_levels_v_rec.period := l_db_okl_sif_ret_levels_v_rec.period;
2262: IF (x_okl_sif_ret_levels_v_rec.advance_or_arrears = OKC_API.G_MISS_CHAR)
2263: THEN
2264: x_okl_sif_ret_levels_v_rec.advance_or_arrears := l_db_okl_sif_ret_levels_v_rec.advance_or_arrears;
2265: END IF;
2266: IF (x_okl_sif_ret_levels_v_rec.period = OKC_API.G_MISS_CHAR)
2267: THEN
2268: x_okl_sif_ret_levels_v_rec.period := l_db_okl_sif_ret_levels_v_rec.period;
2269: END IF;
2270: IF (x_okl_sif_ret_levels_v_rec.lock_level_step = OKC_API.G_MISS_CHAR)
2264: x_okl_sif_ret_levels_v_rec.advance_or_arrears := l_db_okl_sif_ret_levels_v_rec.advance_or_arrears;
2265: END IF;
2266: IF (x_okl_sif_ret_levels_v_rec.period = OKC_API.G_MISS_CHAR)
2267: THEN
2268: x_okl_sif_ret_levels_v_rec.period := l_db_okl_sif_ret_levels_v_rec.period;
2269: END IF;
2270: IF (x_okl_sif_ret_levels_v_rec.lock_level_step = OKC_API.G_MISS_CHAR)
2271: THEN
2272: x_okl_sif_ret_levels_v_rec.lock_level_step := l_db_okl_sif_ret_levels_v_rec.lock_level_step;
2266: IF (x_okl_sif_ret_levels_v_rec.period = OKC_API.G_MISS_CHAR)
2267: THEN
2268: x_okl_sif_ret_levels_v_rec.period := l_db_okl_sif_ret_levels_v_rec.period;
2269: END IF;
2270: IF (x_okl_sif_ret_levels_v_rec.lock_level_step = OKC_API.G_MISS_CHAR)
2271: THEN
2272: x_okl_sif_ret_levels_v_rec.lock_level_step := l_db_okl_sif_ret_levels_v_rec.lock_level_step;
2273: END IF;
2274: IF (x_okl_sif_ret_levels_v_rec.days_in_period = OKC_API.G_MISS_NUM)
2268: x_okl_sif_ret_levels_v_rec.period := l_db_okl_sif_ret_levels_v_rec.period;
2269: END IF;
2270: IF (x_okl_sif_ret_levels_v_rec.lock_level_step = OKC_API.G_MISS_CHAR)
2271: THEN
2272: x_okl_sif_ret_levels_v_rec.lock_level_step := l_db_okl_sif_ret_levels_v_rec.lock_level_step;
2273: END IF;
2274: IF (x_okl_sif_ret_levels_v_rec.days_in_period = OKC_API.G_MISS_NUM)
2275: THEN
2276: x_okl_sif_ret_levels_v_rec.days_in_period := l_db_okl_sif_ret_levels_v_rec.days_in_period;
2270: IF (x_okl_sif_ret_levels_v_rec.lock_level_step = OKC_API.G_MISS_CHAR)
2271: THEN
2272: x_okl_sif_ret_levels_v_rec.lock_level_step := l_db_okl_sif_ret_levels_v_rec.lock_level_step;
2273: END IF;
2274: IF (x_okl_sif_ret_levels_v_rec.days_in_period = OKC_API.G_MISS_NUM)
2275: THEN
2276: x_okl_sif_ret_levels_v_rec.days_in_period := l_db_okl_sif_ret_levels_v_rec.days_in_period;
2277: END IF;
2278: IF (x_okl_sif_ret_levels_v_rec.first_payment_date = OKC_API.G_MISS_DATE)
2272: x_okl_sif_ret_levels_v_rec.lock_level_step := l_db_okl_sif_ret_levels_v_rec.lock_level_step;
2273: END IF;
2274: IF (x_okl_sif_ret_levels_v_rec.days_in_period = OKC_API.G_MISS_NUM)
2275: THEN
2276: x_okl_sif_ret_levels_v_rec.days_in_period := l_db_okl_sif_ret_levels_v_rec.days_in_period;
2277: END IF;
2278: IF (x_okl_sif_ret_levels_v_rec.first_payment_date = OKC_API.G_MISS_DATE)
2279: THEN
2280: x_okl_sif_ret_levels_v_rec.first_payment_date := l_db_okl_sif_ret_levels_v_rec.first_payment_date;
2274: IF (x_okl_sif_ret_levels_v_rec.days_in_period = OKC_API.G_MISS_NUM)
2275: THEN
2276: x_okl_sif_ret_levels_v_rec.days_in_period := l_db_okl_sif_ret_levels_v_rec.days_in_period;
2277: END IF;
2278: IF (x_okl_sif_ret_levels_v_rec.first_payment_date = OKC_API.G_MISS_DATE)
2279: THEN
2280: x_okl_sif_ret_levels_v_rec.first_payment_date := l_db_okl_sif_ret_levels_v_rec.first_payment_date;
2281: END IF;
2282: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute1 = OKC_API.G_MISS_CHAR)
2276: x_okl_sif_ret_levels_v_rec.days_in_period := l_db_okl_sif_ret_levels_v_rec.days_in_period;
2277: END IF;
2278: IF (x_okl_sif_ret_levels_v_rec.first_payment_date = OKC_API.G_MISS_DATE)
2279: THEN
2280: x_okl_sif_ret_levels_v_rec.first_payment_date := l_db_okl_sif_ret_levels_v_rec.first_payment_date;
2281: END IF;
2282: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute1 = OKC_API.G_MISS_CHAR)
2283: THEN
2284: x_okl_sif_ret_levels_v_rec.stream_interface_attribute1 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute1;
2278: IF (x_okl_sif_ret_levels_v_rec.first_payment_date = OKC_API.G_MISS_DATE)
2279: THEN
2280: x_okl_sif_ret_levels_v_rec.first_payment_date := l_db_okl_sif_ret_levels_v_rec.first_payment_date;
2281: END IF;
2282: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute1 = OKC_API.G_MISS_CHAR)
2283: THEN
2284: x_okl_sif_ret_levels_v_rec.stream_interface_attribute1 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute1;
2285: END IF;
2286: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute2 = OKC_API.G_MISS_CHAR)
2280: x_okl_sif_ret_levels_v_rec.first_payment_date := l_db_okl_sif_ret_levels_v_rec.first_payment_date;
2281: END IF;
2282: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute1 = OKC_API.G_MISS_CHAR)
2283: THEN
2284: x_okl_sif_ret_levels_v_rec.stream_interface_attribute1 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute1;
2285: END IF;
2286: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute2 = OKC_API.G_MISS_CHAR)
2287: THEN
2288: x_okl_sif_ret_levels_v_rec.stream_interface_attribute2 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute2;
2282: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute1 = OKC_API.G_MISS_CHAR)
2283: THEN
2284: x_okl_sif_ret_levels_v_rec.stream_interface_attribute1 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute1;
2285: END IF;
2286: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute2 = OKC_API.G_MISS_CHAR)
2287: THEN
2288: x_okl_sif_ret_levels_v_rec.stream_interface_attribute2 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute2;
2289: END IF;
2290: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute3 = OKC_API.G_MISS_CHAR)
2284: x_okl_sif_ret_levels_v_rec.stream_interface_attribute1 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute1;
2285: END IF;
2286: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute2 = OKC_API.G_MISS_CHAR)
2287: THEN
2288: x_okl_sif_ret_levels_v_rec.stream_interface_attribute2 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute2;
2289: END IF;
2290: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute3 = OKC_API.G_MISS_CHAR)
2291: THEN
2292: x_okl_sif_ret_levels_v_rec.stream_interface_attribute3 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute3;
2286: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute2 = OKC_API.G_MISS_CHAR)
2287: THEN
2288: x_okl_sif_ret_levels_v_rec.stream_interface_attribute2 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute2;
2289: END IF;
2290: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute3 = OKC_API.G_MISS_CHAR)
2291: THEN
2292: x_okl_sif_ret_levels_v_rec.stream_interface_attribute3 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute3;
2293: END IF;
2294: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute4 = OKC_API.G_MISS_CHAR)
2288: x_okl_sif_ret_levels_v_rec.stream_interface_attribute2 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute2;
2289: END IF;
2290: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute3 = OKC_API.G_MISS_CHAR)
2291: THEN
2292: x_okl_sif_ret_levels_v_rec.stream_interface_attribute3 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute3;
2293: END IF;
2294: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute4 = OKC_API.G_MISS_CHAR)
2295: THEN
2296: x_okl_sif_ret_levels_v_rec.stream_interface_attribute4 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute4;
2290: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute3 = OKC_API.G_MISS_CHAR)
2291: THEN
2292: x_okl_sif_ret_levels_v_rec.stream_interface_attribute3 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute3;
2293: END IF;
2294: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute4 = OKC_API.G_MISS_CHAR)
2295: THEN
2296: x_okl_sif_ret_levels_v_rec.stream_interface_attribute4 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute4;
2297: END IF;
2298: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute5 = OKC_API.G_MISS_CHAR)
2292: x_okl_sif_ret_levels_v_rec.stream_interface_attribute3 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute3;
2293: END IF;
2294: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute4 = OKC_API.G_MISS_CHAR)
2295: THEN
2296: x_okl_sif_ret_levels_v_rec.stream_interface_attribute4 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute4;
2297: END IF;
2298: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute5 = OKC_API.G_MISS_CHAR)
2299: THEN
2300: x_okl_sif_ret_levels_v_rec.stream_interface_attribute5 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute5;
2294: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute4 = OKC_API.G_MISS_CHAR)
2295: THEN
2296: x_okl_sif_ret_levels_v_rec.stream_interface_attribute4 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute4;
2297: END IF;
2298: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute5 = OKC_API.G_MISS_CHAR)
2299: THEN
2300: x_okl_sif_ret_levels_v_rec.stream_interface_attribute5 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute5;
2301: END IF;
2302: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute6 = OKC_API.G_MISS_CHAR)
2296: x_okl_sif_ret_levels_v_rec.stream_interface_attribute4 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute4;
2297: END IF;
2298: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute5 = OKC_API.G_MISS_CHAR)
2299: THEN
2300: x_okl_sif_ret_levels_v_rec.stream_interface_attribute5 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute5;
2301: END IF;
2302: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute6 = OKC_API.G_MISS_CHAR)
2303: THEN
2304: x_okl_sif_ret_levels_v_rec.stream_interface_attribute6 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute6;
2298: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute5 = OKC_API.G_MISS_CHAR)
2299: THEN
2300: x_okl_sif_ret_levels_v_rec.stream_interface_attribute5 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute5;
2301: END IF;
2302: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute6 = OKC_API.G_MISS_CHAR)
2303: THEN
2304: x_okl_sif_ret_levels_v_rec.stream_interface_attribute6 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute6;
2305: END IF;
2306: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute7 = OKC_API.G_MISS_CHAR)
2300: x_okl_sif_ret_levels_v_rec.stream_interface_attribute5 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute5;
2301: END IF;
2302: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute6 = OKC_API.G_MISS_CHAR)
2303: THEN
2304: x_okl_sif_ret_levels_v_rec.stream_interface_attribute6 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute6;
2305: END IF;
2306: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute7 = OKC_API.G_MISS_CHAR)
2307: THEN
2308: x_okl_sif_ret_levels_v_rec.stream_interface_attribute7 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute7;
2302: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute6 = OKC_API.G_MISS_CHAR)
2303: THEN
2304: x_okl_sif_ret_levels_v_rec.stream_interface_attribute6 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute6;
2305: END IF;
2306: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute7 = OKC_API.G_MISS_CHAR)
2307: THEN
2308: x_okl_sif_ret_levels_v_rec.stream_interface_attribute7 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute7;
2309: END IF;
2310: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute8 = OKC_API.G_MISS_CHAR)
2304: x_okl_sif_ret_levels_v_rec.stream_interface_attribute6 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute6;
2305: END IF;
2306: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute7 = OKC_API.G_MISS_CHAR)
2307: THEN
2308: x_okl_sif_ret_levels_v_rec.stream_interface_attribute7 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute7;
2309: END IF;
2310: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute8 = OKC_API.G_MISS_CHAR)
2311: THEN
2312: x_okl_sif_ret_levels_v_rec.stream_interface_attribute8 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute8;
2306: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute7 = OKC_API.G_MISS_CHAR)
2307: THEN
2308: x_okl_sif_ret_levels_v_rec.stream_interface_attribute7 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute7;
2309: END IF;
2310: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute8 = OKC_API.G_MISS_CHAR)
2311: THEN
2312: x_okl_sif_ret_levels_v_rec.stream_interface_attribute8 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute8;
2313: END IF;
2314: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute9 = OKC_API.G_MISS_CHAR)
2308: x_okl_sif_ret_levels_v_rec.stream_interface_attribute7 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute7;
2309: END IF;
2310: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute8 = OKC_API.G_MISS_CHAR)
2311: THEN
2312: x_okl_sif_ret_levels_v_rec.stream_interface_attribute8 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute8;
2313: END IF;
2314: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute9 = OKC_API.G_MISS_CHAR)
2315: THEN
2316: x_okl_sif_ret_levels_v_rec.stream_interface_attribute9 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute9;
2310: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute8 = OKC_API.G_MISS_CHAR)
2311: THEN
2312: x_okl_sif_ret_levels_v_rec.stream_interface_attribute8 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute8;
2313: END IF;
2314: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute9 = OKC_API.G_MISS_CHAR)
2315: THEN
2316: x_okl_sif_ret_levels_v_rec.stream_interface_attribute9 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute9;
2317: END IF;
2318: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute10 = OKC_API.G_MISS_CHAR)
2312: x_okl_sif_ret_levels_v_rec.stream_interface_attribute8 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute8;
2313: END IF;
2314: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute9 = OKC_API.G_MISS_CHAR)
2315: THEN
2316: x_okl_sif_ret_levels_v_rec.stream_interface_attribute9 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute9;
2317: END IF;
2318: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute10 = OKC_API.G_MISS_CHAR)
2319: THEN
2320: x_okl_sif_ret_levels_v_rec.stream_interface_attribute10 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute10;
2314: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute9 = OKC_API.G_MISS_CHAR)
2315: THEN
2316: x_okl_sif_ret_levels_v_rec.stream_interface_attribute9 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute9;
2317: END IF;
2318: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute10 = OKC_API.G_MISS_CHAR)
2319: THEN
2320: x_okl_sif_ret_levels_v_rec.stream_interface_attribute10 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute10;
2321: END IF;
2322: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute11 = OKC_API.G_MISS_CHAR)
2316: x_okl_sif_ret_levels_v_rec.stream_interface_attribute9 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute9;
2317: END IF;
2318: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute10 = OKC_API.G_MISS_CHAR)
2319: THEN
2320: x_okl_sif_ret_levels_v_rec.stream_interface_attribute10 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute10;
2321: END IF;
2322: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute11 = OKC_API.G_MISS_CHAR)
2323: THEN
2324: x_okl_sif_ret_levels_v_rec.stream_interface_attribute11 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute11;
2318: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute10 = OKC_API.G_MISS_CHAR)
2319: THEN
2320: x_okl_sif_ret_levels_v_rec.stream_interface_attribute10 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute10;
2321: END IF;
2322: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute11 = OKC_API.G_MISS_CHAR)
2323: THEN
2324: x_okl_sif_ret_levels_v_rec.stream_interface_attribute11 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute11;
2325: END IF;
2326: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute12 = OKC_API.G_MISS_CHAR)
2320: x_okl_sif_ret_levels_v_rec.stream_interface_attribute10 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute10;
2321: END IF;
2322: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute11 = OKC_API.G_MISS_CHAR)
2323: THEN
2324: x_okl_sif_ret_levels_v_rec.stream_interface_attribute11 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute11;
2325: END IF;
2326: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute12 = OKC_API.G_MISS_CHAR)
2327: THEN
2328: x_okl_sif_ret_levels_v_rec.stream_interface_attribute12 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute12;
2322: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute11 = OKC_API.G_MISS_CHAR)
2323: THEN
2324: x_okl_sif_ret_levels_v_rec.stream_interface_attribute11 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute11;
2325: END IF;
2326: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute12 = OKC_API.G_MISS_CHAR)
2327: THEN
2328: x_okl_sif_ret_levels_v_rec.stream_interface_attribute12 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute12;
2329: END IF;
2330: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute13 = OKC_API.G_MISS_CHAR)
2324: x_okl_sif_ret_levels_v_rec.stream_interface_attribute11 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute11;
2325: END IF;
2326: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute12 = OKC_API.G_MISS_CHAR)
2327: THEN
2328: x_okl_sif_ret_levels_v_rec.stream_interface_attribute12 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute12;
2329: END IF;
2330: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute13 = OKC_API.G_MISS_CHAR)
2331: THEN
2332: x_okl_sif_ret_levels_v_rec.stream_interface_attribute13 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute13;
2326: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute12 = OKC_API.G_MISS_CHAR)
2327: THEN
2328: x_okl_sif_ret_levels_v_rec.stream_interface_attribute12 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute12;
2329: END IF;
2330: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute13 = OKC_API.G_MISS_CHAR)
2331: THEN
2332: x_okl_sif_ret_levels_v_rec.stream_interface_attribute13 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute13;
2333: END IF;
2334: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute14 = OKC_API.G_MISS_CHAR)
2328: x_okl_sif_ret_levels_v_rec.stream_interface_attribute12 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute12;
2329: END IF;
2330: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute13 = OKC_API.G_MISS_CHAR)
2331: THEN
2332: x_okl_sif_ret_levels_v_rec.stream_interface_attribute13 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute13;
2333: END IF;
2334: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute14 = OKC_API.G_MISS_CHAR)
2335: THEN
2336: x_okl_sif_ret_levels_v_rec.stream_interface_attribute14 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute14;
2330: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute13 = OKC_API.G_MISS_CHAR)
2331: THEN
2332: x_okl_sif_ret_levels_v_rec.stream_interface_attribute13 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute13;
2333: END IF;
2334: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute14 = OKC_API.G_MISS_CHAR)
2335: THEN
2336: x_okl_sif_ret_levels_v_rec.stream_interface_attribute14 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute14;
2337: END IF;
2338: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute15 = OKC_API.G_MISS_CHAR)
2332: x_okl_sif_ret_levels_v_rec.stream_interface_attribute13 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute13;
2333: END IF;
2334: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute14 = OKC_API.G_MISS_CHAR)
2335: THEN
2336: x_okl_sif_ret_levels_v_rec.stream_interface_attribute14 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute14;
2337: END IF;
2338: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute15 = OKC_API.G_MISS_CHAR)
2339: THEN
2340: x_okl_sif_ret_levels_v_rec.stream_interface_attribute15 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute15;
2334: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute14 = OKC_API.G_MISS_CHAR)
2335: THEN
2336: x_okl_sif_ret_levels_v_rec.stream_interface_attribute14 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute14;
2337: END IF;
2338: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute15 = OKC_API.G_MISS_CHAR)
2339: THEN
2340: x_okl_sif_ret_levels_v_rec.stream_interface_attribute15 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute15;
2341: END IF;
2342: IF (x_okl_sif_ret_levels_v_rec.creation_date = OKC_API.G_MISS_DATE)
2336: x_okl_sif_ret_levels_v_rec.stream_interface_attribute14 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute14;
2337: END IF;
2338: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute15 = OKC_API.G_MISS_CHAR)
2339: THEN
2340: x_okl_sif_ret_levels_v_rec.stream_interface_attribute15 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute15;
2341: END IF;
2342: IF (x_okl_sif_ret_levels_v_rec.creation_date = OKC_API.G_MISS_DATE)
2343: THEN
2344: x_okl_sif_ret_levels_v_rec.creation_date := l_db_okl_sif_ret_levels_v_rec.creation_date;
2338: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute15 = OKC_API.G_MISS_CHAR)
2339: THEN
2340: x_okl_sif_ret_levels_v_rec.stream_interface_attribute15 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute15;
2341: END IF;
2342: IF (x_okl_sif_ret_levels_v_rec.creation_date = OKC_API.G_MISS_DATE)
2343: THEN
2344: x_okl_sif_ret_levels_v_rec.creation_date := l_db_okl_sif_ret_levels_v_rec.creation_date;
2345: END IF;
2346: IF (x_okl_sif_ret_levels_v_rec.created_by = OKC_API.G_MISS_NUM)
2340: x_okl_sif_ret_levels_v_rec.stream_interface_attribute15 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute15;
2341: END IF;
2342: IF (x_okl_sif_ret_levels_v_rec.creation_date = OKC_API.G_MISS_DATE)
2343: THEN
2344: x_okl_sif_ret_levels_v_rec.creation_date := l_db_okl_sif_ret_levels_v_rec.creation_date;
2345: END IF;
2346: IF (x_okl_sif_ret_levels_v_rec.created_by = OKC_API.G_MISS_NUM)
2347: THEN
2348: x_okl_sif_ret_levels_v_rec.created_by := l_db_okl_sif_ret_levels_v_rec.created_by;
2342: IF (x_okl_sif_ret_levels_v_rec.creation_date = OKC_API.G_MISS_DATE)
2343: THEN
2344: x_okl_sif_ret_levels_v_rec.creation_date := l_db_okl_sif_ret_levels_v_rec.creation_date;
2345: END IF;
2346: IF (x_okl_sif_ret_levels_v_rec.created_by = OKC_API.G_MISS_NUM)
2347: THEN
2348: x_okl_sif_ret_levels_v_rec.created_by := l_db_okl_sif_ret_levels_v_rec.created_by;
2349: END IF;
2350: IF (x_okl_sif_ret_levels_v_rec.last_update_date = OKC_API.G_MISS_DATE)
2344: x_okl_sif_ret_levels_v_rec.creation_date := l_db_okl_sif_ret_levels_v_rec.creation_date;
2345: END IF;
2346: IF (x_okl_sif_ret_levels_v_rec.created_by = OKC_API.G_MISS_NUM)
2347: THEN
2348: x_okl_sif_ret_levels_v_rec.created_by := l_db_okl_sif_ret_levels_v_rec.created_by;
2349: END IF;
2350: IF (x_okl_sif_ret_levels_v_rec.last_update_date = OKC_API.G_MISS_DATE)
2351: THEN
2352: x_okl_sif_ret_levels_v_rec.last_update_date := l_db_okl_sif_ret_levels_v_rec.last_update_date;
2346: IF (x_okl_sif_ret_levels_v_rec.created_by = OKC_API.G_MISS_NUM)
2347: THEN
2348: x_okl_sif_ret_levels_v_rec.created_by := l_db_okl_sif_ret_levels_v_rec.created_by;
2349: END IF;
2350: IF (x_okl_sif_ret_levels_v_rec.last_update_date = OKC_API.G_MISS_DATE)
2351: THEN
2352: x_okl_sif_ret_levels_v_rec.last_update_date := l_db_okl_sif_ret_levels_v_rec.last_update_date;
2353: END IF;
2354: IF (x_okl_sif_ret_levels_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
2348: x_okl_sif_ret_levels_v_rec.created_by := l_db_okl_sif_ret_levels_v_rec.created_by;
2349: END IF;
2350: IF (x_okl_sif_ret_levels_v_rec.last_update_date = OKC_API.G_MISS_DATE)
2351: THEN
2352: x_okl_sif_ret_levels_v_rec.last_update_date := l_db_okl_sif_ret_levels_v_rec.last_update_date;
2353: END IF;
2354: IF (x_okl_sif_ret_levels_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
2355: THEN
2356: x_okl_sif_ret_levels_v_rec.last_updated_by := l_db_okl_sif_ret_levels_v_rec.last_updated_by;
2350: IF (x_okl_sif_ret_levels_v_rec.last_update_date = OKC_API.G_MISS_DATE)
2351: THEN
2352: x_okl_sif_ret_levels_v_rec.last_update_date := l_db_okl_sif_ret_levels_v_rec.last_update_date;
2353: END IF;
2354: IF (x_okl_sif_ret_levels_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
2355: THEN
2356: x_okl_sif_ret_levels_v_rec.last_updated_by := l_db_okl_sif_ret_levels_v_rec.last_updated_by;
2357: END IF;
2358: IF (x_okl_sif_ret_levels_v_rec.last_update_login = OKC_API.G_MISS_NUM)
2352: x_okl_sif_ret_levels_v_rec.last_update_date := l_db_okl_sif_ret_levels_v_rec.last_update_date;
2353: END IF;
2354: IF (x_okl_sif_ret_levels_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
2355: THEN
2356: x_okl_sif_ret_levels_v_rec.last_updated_by := l_db_okl_sif_ret_levels_v_rec.last_updated_by;
2357: END IF;
2358: IF (x_okl_sif_ret_levels_v_rec.last_update_login = OKC_API.G_MISS_NUM)
2359: THEN
2360: x_okl_sif_ret_levels_v_rec.last_update_login := l_db_okl_sif_ret_levels_v_rec.last_update_login;
2354: IF (x_okl_sif_ret_levels_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
2355: THEN
2356: x_okl_sif_ret_levels_v_rec.last_updated_by := l_db_okl_sif_ret_levels_v_rec.last_updated_by;
2357: END IF;
2358: IF (x_okl_sif_ret_levels_v_rec.last_update_login = OKC_API.G_MISS_NUM)
2359: THEN
2360: x_okl_sif_ret_levels_v_rec.last_update_login := l_db_okl_sif_ret_levels_v_rec.last_update_login;
2361: END IF;
2362: --smahapat 10/12/03
2356: x_okl_sif_ret_levels_v_rec.last_updated_by := l_db_okl_sif_ret_levels_v_rec.last_updated_by;
2357: END IF;
2358: IF (x_okl_sif_ret_levels_v_rec.last_update_login = OKC_API.G_MISS_NUM)
2359: THEN
2360: x_okl_sif_ret_levels_v_rec.last_update_login := l_db_okl_sif_ret_levels_v_rec.last_update_login;
2361: END IF;
2362: --smahapat 10/12/03
2363: IF (x_okl_sif_ret_levels_v_rec.rate = OKC_API.G_MISS_NUM)
2364: THEN
2359: THEN
2360: x_okl_sif_ret_levels_v_rec.last_update_login := l_db_okl_sif_ret_levels_v_rec.last_update_login;
2361: END IF;
2362: --smahapat 10/12/03
2363: IF (x_okl_sif_ret_levels_v_rec.rate = OKC_API.G_MISS_NUM)
2364: THEN
2365: x_okl_sif_ret_levels_v_rec.rate := l_db_okl_sif_ret_levels_v_rec.rate;
2366: END IF;
2367: --racheruv 18.02.2013
2361: END IF;
2362: --smahapat 10/12/03
2363: IF (x_okl_sif_ret_levels_v_rec.rate = OKC_API.G_MISS_NUM)
2364: THEN
2365: x_okl_sif_ret_levels_v_rec.rate := l_db_okl_sif_ret_levels_v_rec.rate;
2366: END IF;
2367: --racheruv 18.02.2013
2368: IF (x_okl_sif_ret_levels_v_rec.reamort_balance = OKC_API.G_MISS_NUM)
2369: THEN
2364: THEN
2365: x_okl_sif_ret_levels_v_rec.rate := l_db_okl_sif_ret_levels_v_rec.rate;
2366: END IF;
2367: --racheruv 18.02.2013
2368: IF (x_okl_sif_ret_levels_v_rec.reamort_balance = OKC_API.G_MISS_NUM)
2369: THEN
2370: x_okl_sif_ret_levels_v_rec.reamort_balance := l_db_okl_sif_ret_levels_v_rec.reamort_balance;
2371: END IF;
2372: --racheruv 18.02.2013
2366: END IF;
2367: --racheruv 18.02.2013
2368: IF (x_okl_sif_ret_levels_v_rec.reamort_balance = OKC_API.G_MISS_NUM)
2369: THEN
2370: x_okl_sif_ret_levels_v_rec.reamort_balance := l_db_okl_sif_ret_levels_v_rec.reamort_balance;
2371: END IF;
2372: --racheruv 18.02.2013
2373: IF (x_okl_sif_ret_levels_v_rec.reamort_date = OKC_API.G_MISS_DATE)
2374: THEN
2369: THEN
2370: x_okl_sif_ret_levels_v_rec.reamort_balance := l_db_okl_sif_ret_levels_v_rec.reamort_balance;
2371: END IF;
2372: --racheruv 18.02.2013
2373: IF (x_okl_sif_ret_levels_v_rec.reamort_date = OKC_API.G_MISS_DATE)
2374: THEN
2375: x_okl_sif_ret_levels_v_rec.reamort_date := l_db_okl_sif_ret_levels_v_rec.reamort_date;
2376: END IF;
2377: END IF;
2371: END IF;
2372: --racheruv 18.02.2013
2373: IF (x_okl_sif_ret_levels_v_rec.reamort_date = OKC_API.G_MISS_DATE)
2374: THEN
2375: x_okl_sif_ret_levels_v_rec.reamort_date := l_db_okl_sif_ret_levels_v_rec.reamort_date;
2376: END IF;
2377: END IF;
2378: RETURN(l_return_status);
2379: END populate_new_record;
2377: END IF;
2378: RETURN(l_return_status);
2379: END populate_new_record;
2380: ---------------------------------------------
2381: -- Set_Attributes for:OKL_SIF_RET_LEVELS_V --
2382: ---------------------------------------------
2383: FUNCTION Set_Attributes (
2384: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
2385: x_okl_sif_ret_levels_v_rec OUT NOCOPY okl_sif_ret_levels_v_rec_type
2380: ---------------------------------------------
2381: -- Set_Attributes for:OKL_SIF_RET_LEVELS_V --
2382: ---------------------------------------------
2383: FUNCTION Set_Attributes (
2384: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
2385: x_okl_sif_ret_levels_v_rec OUT NOCOPY okl_sif_ret_levels_v_rec_type
2386: ) RETURN VARCHAR2 IS
2387: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2388: BEGIN
2381: -- Set_Attributes for:OKL_SIF_RET_LEVELS_V --
2382: ---------------------------------------------
2383: FUNCTION Set_Attributes (
2384: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
2385: x_okl_sif_ret_levels_v_rec OUT NOCOPY okl_sif_ret_levels_v_rec_type
2386: ) RETURN VARCHAR2 IS
2387: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2388: BEGIN
2389: x_okl_sif_ret_levels_v_rec := p_okl_sif_ret_levels_v_rec;
2385: x_okl_sif_ret_levels_v_rec OUT NOCOPY okl_sif_ret_levels_v_rec_type
2386: ) RETURN VARCHAR2 IS
2387: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2388: BEGIN
2389: x_okl_sif_ret_levels_v_rec := p_okl_sif_ret_levels_v_rec;
2390: RETURN(l_return_status);
2391: END Set_Attributes;
2392: BEGIN
2393: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2403: RAISE OKC_API.G_EXCEPTION_ERROR;
2404: END IF;
2405: --- Setting item attributes
2406: l_return_status := Set_Attributes(
2407: p_okl_sif_ret_levels_v_rec, -- IN
2408: x_okl_sif_ret_levels_v_rec); -- OUT
2409: --- If any errors happen abort API
2410: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2411: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2404: END IF;
2405: --- Setting item attributes
2406: l_return_status := Set_Attributes(
2407: p_okl_sif_ret_levels_v_rec, -- IN
2408: x_okl_sif_ret_levels_v_rec); -- OUT
2409: --- If any errors happen abort API
2410: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2411: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2412: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2411: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2412: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2413: RAISE OKC_API.G_EXCEPTION_ERROR;
2414: END IF;
2415: l_return_status := populate_new_record(l_okl_sif_ret_levels_v_rec, l_def_okl_sif_ret_levels_v_rec);
2416: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2417: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2418: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2419: RAISE OKC_API.G_EXCEPTION_ERROR;
2417: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2418: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2419: RAISE OKC_API.G_EXCEPTION_ERROR;
2420: END IF;
2421: l_def_okl_sif_ret_levels_v_rec := fill_who_columns(l_def_okl_sif_ret_levels_v_rec);
2422: --- Validate all non-missing attributes (Item Level Validation)
2423: l_return_status := Validate_Attributes(l_def_okl_sif_ret_levels_v_rec);
2424: --- If any errors happen abort API
2425: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2419: RAISE OKC_API.G_EXCEPTION_ERROR;
2420: END IF;
2421: l_def_okl_sif_ret_levels_v_rec := fill_who_columns(l_def_okl_sif_ret_levels_v_rec);
2422: --- Validate all non-missing attributes (Item Level Validation)
2423: l_return_status := Validate_Attributes(l_def_okl_sif_ret_levels_v_rec);
2424: --- If any errors happen abort API
2425: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2426: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2427: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2426: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2427: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2428: RAISE OKC_API.G_EXCEPTION_ERROR;
2429: END IF;
2430: l_return_status := Validate_Record(l_def_okl_sif_ret_levels_v_rec, l_db_okl_sif_ret_levels_v_rec);
2431: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2432: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2433: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2434: RAISE OKC_API.G_EXCEPTION_ERROR;
2440: p_init_msg_list => p_init_msg_list,
2441: x_return_status => l_return_status,
2442: x_msg_count => x_msg_count,
2443: x_msg_data => x_msg_data,
2444: p_okl_sif_ret_levels_v_rec => p_okl_sif_ret_levels_v_rec);
2445: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2446: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2447: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2448: RAISE OKC_API.G_EXCEPTION_ERROR;
2450:
2451: -----------------------------------------
2452: -- Move VIEW record to "Child" records --
2453: -----------------------------------------
2454: migrate(l_def_okl_sif_ret_levels_v_rec, l_srl_rec);
2455: -----------------------------------------------
2456: -- Call the UPDATE_ROW for each child record --
2457: -----------------------------------------------
2458: update_row(
2467: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2468: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2469: RAISE OKC_API.G_EXCEPTION_ERROR;
2470: END IF;
2471: migrate(lx_srl_rec, l_def_okl_sif_ret_levels_v_rec);
2472: x_okl_sif_ret_levels_v_rec := l_def_okl_sif_ret_levels_v_rec;
2473: x_return_status := l_return_status;
2474: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2475: EXCEPTION
2468: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2469: RAISE OKC_API.G_EXCEPTION_ERROR;
2470: END IF;
2471: migrate(lx_srl_rec, l_def_okl_sif_ret_levels_v_rec);
2472: x_okl_sif_ret_levels_v_rec := l_def_okl_sif_ret_levels_v_rec;
2473: x_return_status := l_return_status;
2474: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2475: EXCEPTION
2476: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2504: '_PVT'
2505: );
2506: END update_row;
2507: --------------------------------------------------------
2508: -- PL/SQL TBL update_row for:okl_sif_ret_levels_v_tbl --
2509: --------------------------------------------------------
2510: PROCEDURE update_row(
2511: p_api_version IN NUMBER,
2512: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2512: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2513: x_return_status OUT NOCOPY VARCHAR2,
2514: x_msg_count OUT NOCOPY NUMBER,
2515: x_msg_data OUT NOCOPY VARCHAR2,
2516: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
2517: x_okl_sif_ret_levels_v_tbl OUT NOCOPY okl_sif_ret_levels_v_tbl_type,
2518: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
2519:
2520: l_api_version CONSTANT NUMBER := 1;
2513: x_return_status OUT NOCOPY VARCHAR2,
2514: x_msg_count OUT NOCOPY NUMBER,
2515: x_msg_data OUT NOCOPY VARCHAR2,
2516: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
2517: x_okl_sif_ret_levels_v_tbl OUT NOCOPY okl_sif_ret_levels_v_tbl_type,
2518: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
2519:
2520: l_api_version CONSTANT NUMBER := 1;
2521: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
2522: i NUMBER := 0;
2523: BEGIN
2524: OKC_API.init_msg_list(p_init_msg_list);
2525: -- Make sure PL/SQL table has records in it before passing
2526: IF (p_okl_sif_ret_levels_v_tbl.COUNT > 0) THEN
2527: i := p_okl_sif_ret_levels_v_tbl.FIRST;
2528: LOOP
2529: DECLARE
2530: l_error_rec OKC_API.ERROR_REC_TYPE;
2523: BEGIN
2524: OKC_API.init_msg_list(p_init_msg_list);
2525: -- Make sure PL/SQL table has records in it before passing
2526: IF (p_okl_sif_ret_levels_v_tbl.COUNT > 0) THEN
2527: i := p_okl_sif_ret_levels_v_tbl.FIRST;
2528: LOOP
2529: DECLARE
2530: l_error_rec OKC_API.ERROR_REC_TYPE;
2531: BEGIN
2537: p_init_msg_list => OKC_API.G_FALSE,
2538: x_return_status => l_error_rec.error_type,
2539: x_msg_count => l_error_rec.msg_count,
2540: x_msg_data => l_error_rec.msg_data,
2541: p_okl_sif_ret_levels_v_rec => p_okl_sif_ret_levels_v_tbl(i),
2542: x_okl_sif_ret_levels_v_rec => x_okl_sif_ret_levels_v_tbl(i));
2543: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
2544: l_error_rec.SQLCODE := SQLCODE;
2545: load_error_tbl(l_error_rec, px_error_tbl);
2538: x_return_status => l_error_rec.error_type,
2539: x_msg_count => l_error_rec.msg_count,
2540: x_msg_data => l_error_rec.msg_data,
2541: p_okl_sif_ret_levels_v_rec => p_okl_sif_ret_levels_v_tbl(i),
2542: x_okl_sif_ret_levels_v_rec => x_okl_sif_ret_levels_v_tbl(i));
2543: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
2544: l_error_rec.SQLCODE := SQLCODE;
2545: load_error_tbl(l_error_rec, px_error_tbl);
2546: ELSE
2560: l_error_rec.error_type := 'OTHERS';
2561: l_error_rec.SQLCODE := SQLCODE;
2562: load_error_tbl(l_error_rec, px_error_tbl);
2563: END;
2564: EXIT WHEN (i = p_okl_sif_ret_levels_v_tbl.LAST);
2565: i := p_okl_sif_ret_levels_v_tbl.NEXT(i);
2566: END LOOP;
2567: END IF;
2568: -- Loop through the error_tbl to find the error with the highest severity
2561: l_error_rec.SQLCODE := SQLCODE;
2562: load_error_tbl(l_error_rec, px_error_tbl);
2563: END;
2564: EXIT WHEN (i = p_okl_sif_ret_levels_v_tbl.LAST);
2565: i := p_okl_sif_ret_levels_v_tbl.NEXT(i);
2566: END LOOP;
2567: END IF;
2568: -- Loop through the error_tbl to find the error with the highest severity
2569: -- and return it.
2602: );
2603: END update_row;
2604:
2605: --------------------------------------------------------
2606: -- PL/SQL TBL update_row for:OKL_SIF_RET_LEVELS_V_TBL --
2607: --------------------------------------------------------
2608: PROCEDURE update_row(
2609: p_api_version IN NUMBER,
2610: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2610: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2611: x_return_status OUT NOCOPY VARCHAR2,
2612: x_msg_count OUT NOCOPY NUMBER,
2613: x_msg_data OUT NOCOPY VARCHAR2,
2614: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
2615: x_okl_sif_ret_levels_v_tbl OUT NOCOPY okl_sif_ret_levels_v_tbl_type) IS
2616:
2617: l_api_version CONSTANT NUMBER := 1;
2618: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2611: x_return_status OUT NOCOPY VARCHAR2,
2612: x_msg_count OUT NOCOPY NUMBER,
2613: x_msg_data OUT NOCOPY VARCHAR2,
2614: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
2615: x_okl_sif_ret_levels_v_tbl OUT NOCOPY okl_sif_ret_levels_v_tbl_type) IS
2616:
2617: l_api_version CONSTANT NUMBER := 1;
2618: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2619: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2620: l_error_tbl OKC_API.ERROR_TBL_TYPE;
2621: BEGIN
2622: OKC_API.init_msg_list(p_init_msg_list);
2623: -- Make sure PL/SQL table has records in it before passing
2624: IF (p_okl_sif_ret_levels_v_tbl.COUNT > 0) THEN
2625: update_row (
2626: p_api_version => p_api_version,
2627: p_init_msg_list => OKC_API.G_FALSE,
2628: x_return_status => x_return_status,
2627: p_init_msg_list => OKC_API.G_FALSE,
2628: x_return_status => x_return_status,
2629: x_msg_count => x_msg_count,
2630: x_msg_data => x_msg_data,
2631: p_okl_sif_ret_levels_v_tbl => p_okl_sif_ret_levels_v_tbl,
2632: x_okl_sif_ret_levels_v_tbl => x_okl_sif_ret_levels_v_tbl,
2633: px_error_tbl => l_error_tbl);
2634: END IF;
2635: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2628: x_return_status => x_return_status,
2629: x_msg_count => x_msg_count,
2630: x_msg_data => x_msg_data,
2631: p_okl_sif_ret_levels_v_tbl => p_okl_sif_ret_levels_v_tbl,
2632: x_okl_sif_ret_levels_v_tbl => x_okl_sif_ret_levels_v_tbl,
2633: px_error_tbl => l_error_tbl);
2634: END IF;
2635: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2636: EXCEPTION
2732: '_PVT'
2733: );
2734: END delete_row;
2735: -----------------------------------------
2736: -- delete_row for:OKL_SIF_RET_LEVELS_V --
2737: -----------------------------------------
2738: PROCEDURE delete_row(
2739: p_api_version IN NUMBER,
2740: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2740: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2741: x_return_status OUT NOCOPY VARCHAR2,
2742: x_msg_count OUT NOCOPY NUMBER,
2743: x_msg_data OUT NOCOPY VARCHAR2,
2744: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type) IS
2745:
2746: l_api_version CONSTANT NUMBER := 1;
2747: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2748: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2745:
2746: l_api_version CONSTANT NUMBER := 1;
2747: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2748: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2749: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
2750: l_srl_rec srl_rec_type;
2751: BEGIN
2752: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2753: G_PKG_NAME,
2763: END IF;
2764: -----------------------------------------
2765: -- Move VIEW record to "Child" records --
2766: -----------------------------------------
2767: migrate(l_okl_sif_ret_levels_v_rec, l_srl_rec);
2768: -----------------------------------------------
2769: -- Call the DELETE_ROW for each child record --
2770: -----------------------------------------------
2771: delete_row(
2814: '_PVT'
2815: );
2816: END delete_row;
2817: ----------------------------------------------------
2818: -- PL/SQL TBL delete_row for:OKL_SIF_RET_LEVELS_V --
2819: ----------------------------------------------------
2820: PROCEDURE delete_row(
2821: p_api_version IN NUMBER,
2822: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2822: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2823: x_return_status OUT NOCOPY VARCHAR2,
2824: x_msg_count OUT NOCOPY NUMBER,
2825: x_msg_data OUT NOCOPY VARCHAR2,
2826: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
2827: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
2828:
2829: l_api_version CONSTANT NUMBER := 1;
2830: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
2831: i NUMBER := 0;
2832: BEGIN
2833: OKC_API.init_msg_list(p_init_msg_list);
2834: -- Make sure PL/SQL table has records in it before passing
2835: IF (p_okl_sif_ret_levels_v_tbl.COUNT > 0) THEN
2836: i := p_okl_sif_ret_levels_v_tbl.FIRST;
2837: LOOP
2838: DECLARE
2839: l_error_rec OKC_API.ERROR_REC_TYPE;
2832: BEGIN
2833: OKC_API.init_msg_list(p_init_msg_list);
2834: -- Make sure PL/SQL table has records in it before passing
2835: IF (p_okl_sif_ret_levels_v_tbl.COUNT > 0) THEN
2836: i := p_okl_sif_ret_levels_v_tbl.FIRST;
2837: LOOP
2838: DECLARE
2839: l_error_rec OKC_API.ERROR_REC_TYPE;
2840: BEGIN
2846: p_init_msg_list => OKC_API.G_FALSE,
2847: x_return_status => l_error_rec.error_type,
2848: x_msg_count => l_error_rec.msg_count,
2849: x_msg_data => l_error_rec.msg_data,
2850: p_okl_sif_ret_levels_v_rec => p_okl_sif_ret_levels_v_tbl(i));
2851: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
2852: l_error_rec.SQLCODE := SQLCODE;
2853: load_error_tbl(l_error_rec, px_error_tbl);
2854: ELSE
2868: l_error_rec.error_type := 'OTHERS';
2869: l_error_rec.SQLCODE := SQLCODE;
2870: load_error_tbl(l_error_rec, px_error_tbl);
2871: END;
2872: EXIT WHEN (i = p_okl_sif_ret_levels_v_tbl.LAST);
2873: i := p_okl_sif_ret_levels_v_tbl.NEXT(i);
2874: END LOOP;
2875: END IF;
2876: -- Loop through the error_tbl to find the error with the highest severity
2869: l_error_rec.SQLCODE := SQLCODE;
2870: load_error_tbl(l_error_rec, px_error_tbl);
2871: END;
2872: EXIT WHEN (i = p_okl_sif_ret_levels_v_tbl.LAST);
2873: i := p_okl_sif_ret_levels_v_tbl.NEXT(i);
2874: END LOOP;
2875: END IF;
2876: -- Loop through the error_tbl to find the error with the highest severity
2877: -- and return it.
2910: );
2911: END delete_row;
2912:
2913: ----------------------------------------------------
2914: -- PL/SQL TBL delete_row for:OKL_SIF_RET_LEVELS_V --
2915: ----------------------------------------------------
2916: PROCEDURE delete_row(
2917: p_api_version IN NUMBER,
2918: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2918: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2919: x_return_status OUT NOCOPY VARCHAR2,
2920: x_msg_count OUT NOCOPY NUMBER,
2921: x_msg_data OUT NOCOPY VARCHAR2,
2922: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type) IS
2923:
2924: l_api_version CONSTANT NUMBER := 1;
2925: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2926: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2927: l_error_tbl OKC_API.ERROR_TBL_TYPE;
2928: BEGIN
2929: OKC_API.init_msg_list(p_init_msg_list);
2930: -- Make sure PL/SQL table has records in it before passing
2931: IF (p_okl_sif_ret_levels_v_tbl.COUNT > 0) THEN
2932: delete_row (
2933: p_api_version => p_api_version,
2934: p_init_msg_list => OKC_API.G_FALSE,
2935: x_return_status => x_return_status,
2934: p_init_msg_list => OKC_API.G_FALSE,
2935: x_return_status => x_return_status,
2936: x_msg_count => x_msg_count,
2937: x_msg_data => x_msg_data,
2938: p_okl_sif_ret_levels_v_tbl => p_okl_sif_ret_levels_v_tbl,
2939: px_error_tbl => l_error_tbl);
2940: END IF;
2941: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2942: EXCEPTION