[Home] [Help]
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,
132: LAST_UPDATE_DATE,
133: LAST_UPDATED_BY,
134: LAST_UPDATE_LOGIN,
135: RATE --smahapat 10/12/03
136: FROM Okl_Sif_Ret_Levels_V
137: WHERE okl_sif_ret_levels_v.id = p_id;
138: l_srlv_pk srlv_pk_csr%ROWTYPE;
139: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type;
140: BEGIN
133: LAST_UPDATED_BY,
134: LAST_UPDATE_LOGIN,
135: RATE --smahapat 10/12/03
136: FROM Okl_Sif_Ret_Levels_V
137: WHERE okl_sif_ret_levels_v.id = p_id;
138: l_srlv_pk srlv_pk_csr%ROWTYPE;
139: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type;
140: BEGIN
141: x_no_data_found := TRUE;
135: RATE --smahapat 10/12/03
136: FROM Okl_Sif_Ret_Levels_V
137: WHERE okl_sif_ret_levels_v.id = p_id;
138: l_srlv_pk srlv_pk_csr%ROWTYPE;
139: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type;
140: BEGIN
141: x_no_data_found := TRUE;
142: -- Get current database values
143: OPEN srlv_pk_csr (p_okl_sif_ret_levels_v_rec.id);
139: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type;
140: BEGIN
141: x_no_data_found := TRUE;
142: -- Get current database values
143: OPEN srlv_pk_csr (p_okl_sif_ret_levels_v_rec.id);
144: FETCH srlv_pk_csr INTO
145: l_okl_sif_ret_levels_v_rec.id,
146: l_okl_sif_ret_levels_v_rec.level_index_number,
147: l_okl_sif_ret_levels_v_rec.number_of_periods,
141: x_no_data_found := TRUE;
142: -- Get current database values
143: OPEN srlv_pk_csr (p_okl_sif_ret_levels_v_rec.id);
144: FETCH srlv_pk_csr INTO
145: l_okl_sif_ret_levels_v_rec.id,
146: l_okl_sif_ret_levels_v_rec.level_index_number,
147: l_okl_sif_ret_levels_v_rec.number_of_periods,
148: l_okl_sif_ret_levels_v_rec.sir_id,
149: l_okl_sif_ret_levels_v_rec.index_number,
142: -- Get current database values
143: OPEN srlv_pk_csr (p_okl_sif_ret_levels_v_rec.id);
144: FETCH srlv_pk_csr INTO
145: l_okl_sif_ret_levels_v_rec.id,
146: l_okl_sif_ret_levels_v_rec.level_index_number,
147: l_okl_sif_ret_levels_v_rec.number_of_periods,
148: l_okl_sif_ret_levels_v_rec.sir_id,
149: l_okl_sif_ret_levels_v_rec.index_number,
150: l_okl_sif_ret_levels_v_rec.level_type,
143: OPEN srlv_pk_csr (p_okl_sif_ret_levels_v_rec.id);
144: FETCH srlv_pk_csr INTO
145: l_okl_sif_ret_levels_v_rec.id,
146: l_okl_sif_ret_levels_v_rec.level_index_number,
147: l_okl_sif_ret_levels_v_rec.number_of_periods,
148: l_okl_sif_ret_levels_v_rec.sir_id,
149: l_okl_sif_ret_levels_v_rec.index_number,
150: l_okl_sif_ret_levels_v_rec.level_type,
151: l_okl_sif_ret_levels_v_rec.amount,
144: FETCH srlv_pk_csr INTO
145: l_okl_sif_ret_levels_v_rec.id,
146: l_okl_sif_ret_levels_v_rec.level_index_number,
147: l_okl_sif_ret_levels_v_rec.number_of_periods,
148: l_okl_sif_ret_levels_v_rec.sir_id,
149: l_okl_sif_ret_levels_v_rec.index_number,
150: l_okl_sif_ret_levels_v_rec.level_type,
151: l_okl_sif_ret_levels_v_rec.amount,
152: l_okl_sif_ret_levels_v_rec.advance_or_arrears,
145: l_okl_sif_ret_levels_v_rec.id,
146: l_okl_sif_ret_levels_v_rec.level_index_number,
147: l_okl_sif_ret_levels_v_rec.number_of_periods,
148: l_okl_sif_ret_levels_v_rec.sir_id,
149: l_okl_sif_ret_levels_v_rec.index_number,
150: l_okl_sif_ret_levels_v_rec.level_type,
151: l_okl_sif_ret_levels_v_rec.amount,
152: l_okl_sif_ret_levels_v_rec.advance_or_arrears,
153: l_okl_sif_ret_levels_v_rec.period,
146: l_okl_sif_ret_levels_v_rec.level_index_number,
147: l_okl_sif_ret_levels_v_rec.number_of_periods,
148: l_okl_sif_ret_levels_v_rec.sir_id,
149: l_okl_sif_ret_levels_v_rec.index_number,
150: l_okl_sif_ret_levels_v_rec.level_type,
151: l_okl_sif_ret_levels_v_rec.amount,
152: l_okl_sif_ret_levels_v_rec.advance_or_arrears,
153: l_okl_sif_ret_levels_v_rec.period,
154: l_okl_sif_ret_levels_v_rec.lock_level_step,
147: l_okl_sif_ret_levels_v_rec.number_of_periods,
148: l_okl_sif_ret_levels_v_rec.sir_id,
149: l_okl_sif_ret_levels_v_rec.index_number,
150: l_okl_sif_ret_levels_v_rec.level_type,
151: l_okl_sif_ret_levels_v_rec.amount,
152: l_okl_sif_ret_levels_v_rec.advance_or_arrears,
153: l_okl_sif_ret_levels_v_rec.period,
154: l_okl_sif_ret_levels_v_rec.lock_level_step,
155: l_okl_sif_ret_levels_v_rec.days_in_period,
148: l_okl_sif_ret_levels_v_rec.sir_id,
149: l_okl_sif_ret_levels_v_rec.index_number,
150: l_okl_sif_ret_levels_v_rec.level_type,
151: l_okl_sif_ret_levels_v_rec.amount,
152: l_okl_sif_ret_levels_v_rec.advance_or_arrears,
153: l_okl_sif_ret_levels_v_rec.period,
154: l_okl_sif_ret_levels_v_rec.lock_level_step,
155: l_okl_sif_ret_levels_v_rec.days_in_period,
156: l_okl_sif_ret_levels_v_rec.first_payment_date,
149: l_okl_sif_ret_levels_v_rec.index_number,
150: l_okl_sif_ret_levels_v_rec.level_type,
151: l_okl_sif_ret_levels_v_rec.amount,
152: l_okl_sif_ret_levels_v_rec.advance_or_arrears,
153: l_okl_sif_ret_levels_v_rec.period,
154: l_okl_sif_ret_levels_v_rec.lock_level_step,
155: l_okl_sif_ret_levels_v_rec.days_in_period,
156: l_okl_sif_ret_levels_v_rec.first_payment_date,
157: l_okl_sif_ret_levels_v_rec.object_version_number,
150: l_okl_sif_ret_levels_v_rec.level_type,
151: l_okl_sif_ret_levels_v_rec.amount,
152: l_okl_sif_ret_levels_v_rec.advance_or_arrears,
153: l_okl_sif_ret_levels_v_rec.period,
154: l_okl_sif_ret_levels_v_rec.lock_level_step,
155: l_okl_sif_ret_levels_v_rec.days_in_period,
156: l_okl_sif_ret_levels_v_rec.first_payment_date,
157: l_okl_sif_ret_levels_v_rec.object_version_number,
158: l_okl_sif_ret_levels_v_rec.stream_interface_attribute1,
151: l_okl_sif_ret_levels_v_rec.amount,
152: l_okl_sif_ret_levels_v_rec.advance_or_arrears,
153: l_okl_sif_ret_levels_v_rec.period,
154: l_okl_sif_ret_levels_v_rec.lock_level_step,
155: l_okl_sif_ret_levels_v_rec.days_in_period,
156: l_okl_sif_ret_levels_v_rec.first_payment_date,
157: l_okl_sif_ret_levels_v_rec.object_version_number,
158: l_okl_sif_ret_levels_v_rec.stream_interface_attribute1,
159: l_okl_sif_ret_levels_v_rec.stream_interface_attribute2,
152: l_okl_sif_ret_levels_v_rec.advance_or_arrears,
153: l_okl_sif_ret_levels_v_rec.period,
154: l_okl_sif_ret_levels_v_rec.lock_level_step,
155: l_okl_sif_ret_levels_v_rec.days_in_period,
156: l_okl_sif_ret_levels_v_rec.first_payment_date,
157: l_okl_sif_ret_levels_v_rec.object_version_number,
158: l_okl_sif_ret_levels_v_rec.stream_interface_attribute1,
159: l_okl_sif_ret_levels_v_rec.stream_interface_attribute2,
160: l_okl_sif_ret_levels_v_rec.stream_interface_attribute3,
153: l_okl_sif_ret_levels_v_rec.period,
154: l_okl_sif_ret_levels_v_rec.lock_level_step,
155: l_okl_sif_ret_levels_v_rec.days_in_period,
156: l_okl_sif_ret_levels_v_rec.first_payment_date,
157: l_okl_sif_ret_levels_v_rec.object_version_number,
158: l_okl_sif_ret_levels_v_rec.stream_interface_attribute1,
159: l_okl_sif_ret_levels_v_rec.stream_interface_attribute2,
160: l_okl_sif_ret_levels_v_rec.stream_interface_attribute3,
161: l_okl_sif_ret_levels_v_rec.stream_interface_attribute4,
154: l_okl_sif_ret_levels_v_rec.lock_level_step,
155: l_okl_sif_ret_levels_v_rec.days_in_period,
156: l_okl_sif_ret_levels_v_rec.first_payment_date,
157: l_okl_sif_ret_levels_v_rec.object_version_number,
158: l_okl_sif_ret_levels_v_rec.stream_interface_attribute1,
159: l_okl_sif_ret_levels_v_rec.stream_interface_attribute2,
160: l_okl_sif_ret_levels_v_rec.stream_interface_attribute3,
161: l_okl_sif_ret_levels_v_rec.stream_interface_attribute4,
162: l_okl_sif_ret_levels_v_rec.stream_interface_attribute5,
155: l_okl_sif_ret_levels_v_rec.days_in_period,
156: l_okl_sif_ret_levels_v_rec.first_payment_date,
157: l_okl_sif_ret_levels_v_rec.object_version_number,
158: l_okl_sif_ret_levels_v_rec.stream_interface_attribute1,
159: l_okl_sif_ret_levels_v_rec.stream_interface_attribute2,
160: l_okl_sif_ret_levels_v_rec.stream_interface_attribute3,
161: l_okl_sif_ret_levels_v_rec.stream_interface_attribute4,
162: l_okl_sif_ret_levels_v_rec.stream_interface_attribute5,
163: l_okl_sif_ret_levels_v_rec.stream_interface_attribute6,
156: l_okl_sif_ret_levels_v_rec.first_payment_date,
157: l_okl_sif_ret_levels_v_rec.object_version_number,
158: l_okl_sif_ret_levels_v_rec.stream_interface_attribute1,
159: l_okl_sif_ret_levels_v_rec.stream_interface_attribute2,
160: l_okl_sif_ret_levels_v_rec.stream_interface_attribute3,
161: l_okl_sif_ret_levels_v_rec.stream_interface_attribute4,
162: l_okl_sif_ret_levels_v_rec.stream_interface_attribute5,
163: l_okl_sif_ret_levels_v_rec.stream_interface_attribute6,
164: l_okl_sif_ret_levels_v_rec.stream_interface_attribute7,
157: l_okl_sif_ret_levels_v_rec.object_version_number,
158: l_okl_sif_ret_levels_v_rec.stream_interface_attribute1,
159: l_okl_sif_ret_levels_v_rec.stream_interface_attribute2,
160: l_okl_sif_ret_levels_v_rec.stream_interface_attribute3,
161: l_okl_sif_ret_levels_v_rec.stream_interface_attribute4,
162: l_okl_sif_ret_levels_v_rec.stream_interface_attribute5,
163: l_okl_sif_ret_levels_v_rec.stream_interface_attribute6,
164: l_okl_sif_ret_levels_v_rec.stream_interface_attribute7,
165: l_okl_sif_ret_levels_v_rec.stream_interface_attribute8,
158: l_okl_sif_ret_levels_v_rec.stream_interface_attribute1,
159: l_okl_sif_ret_levels_v_rec.stream_interface_attribute2,
160: l_okl_sif_ret_levels_v_rec.stream_interface_attribute3,
161: l_okl_sif_ret_levels_v_rec.stream_interface_attribute4,
162: l_okl_sif_ret_levels_v_rec.stream_interface_attribute5,
163: l_okl_sif_ret_levels_v_rec.stream_interface_attribute6,
164: l_okl_sif_ret_levels_v_rec.stream_interface_attribute7,
165: l_okl_sif_ret_levels_v_rec.stream_interface_attribute8,
166: l_okl_sif_ret_levels_v_rec.stream_interface_attribute9,
159: l_okl_sif_ret_levels_v_rec.stream_interface_attribute2,
160: l_okl_sif_ret_levels_v_rec.stream_interface_attribute3,
161: l_okl_sif_ret_levels_v_rec.stream_interface_attribute4,
162: l_okl_sif_ret_levels_v_rec.stream_interface_attribute5,
163: l_okl_sif_ret_levels_v_rec.stream_interface_attribute6,
164: l_okl_sif_ret_levels_v_rec.stream_interface_attribute7,
165: l_okl_sif_ret_levels_v_rec.stream_interface_attribute8,
166: l_okl_sif_ret_levels_v_rec.stream_interface_attribute9,
167: l_okl_sif_ret_levels_v_rec.stream_interface_attribute10,
160: l_okl_sif_ret_levels_v_rec.stream_interface_attribute3,
161: l_okl_sif_ret_levels_v_rec.stream_interface_attribute4,
162: l_okl_sif_ret_levels_v_rec.stream_interface_attribute5,
163: l_okl_sif_ret_levels_v_rec.stream_interface_attribute6,
164: l_okl_sif_ret_levels_v_rec.stream_interface_attribute7,
165: l_okl_sif_ret_levels_v_rec.stream_interface_attribute8,
166: l_okl_sif_ret_levels_v_rec.stream_interface_attribute9,
167: l_okl_sif_ret_levels_v_rec.stream_interface_attribute10,
168: l_okl_sif_ret_levels_v_rec.stream_interface_attribute11,
161: l_okl_sif_ret_levels_v_rec.stream_interface_attribute4,
162: l_okl_sif_ret_levels_v_rec.stream_interface_attribute5,
163: l_okl_sif_ret_levels_v_rec.stream_interface_attribute6,
164: l_okl_sif_ret_levels_v_rec.stream_interface_attribute7,
165: l_okl_sif_ret_levels_v_rec.stream_interface_attribute8,
166: l_okl_sif_ret_levels_v_rec.stream_interface_attribute9,
167: l_okl_sif_ret_levels_v_rec.stream_interface_attribute10,
168: l_okl_sif_ret_levels_v_rec.stream_interface_attribute11,
169: l_okl_sif_ret_levels_v_rec.stream_interface_attribute12,
162: l_okl_sif_ret_levels_v_rec.stream_interface_attribute5,
163: l_okl_sif_ret_levels_v_rec.stream_interface_attribute6,
164: l_okl_sif_ret_levels_v_rec.stream_interface_attribute7,
165: l_okl_sif_ret_levels_v_rec.stream_interface_attribute8,
166: l_okl_sif_ret_levels_v_rec.stream_interface_attribute9,
167: l_okl_sif_ret_levels_v_rec.stream_interface_attribute10,
168: l_okl_sif_ret_levels_v_rec.stream_interface_attribute11,
169: l_okl_sif_ret_levels_v_rec.stream_interface_attribute12,
170: l_okl_sif_ret_levels_v_rec.stream_interface_attribute13,
163: l_okl_sif_ret_levels_v_rec.stream_interface_attribute6,
164: l_okl_sif_ret_levels_v_rec.stream_interface_attribute7,
165: l_okl_sif_ret_levels_v_rec.stream_interface_attribute8,
166: l_okl_sif_ret_levels_v_rec.stream_interface_attribute9,
167: l_okl_sif_ret_levels_v_rec.stream_interface_attribute10,
168: l_okl_sif_ret_levels_v_rec.stream_interface_attribute11,
169: l_okl_sif_ret_levels_v_rec.stream_interface_attribute12,
170: l_okl_sif_ret_levels_v_rec.stream_interface_attribute13,
171: l_okl_sif_ret_levels_v_rec.stream_interface_attribute14,
164: l_okl_sif_ret_levels_v_rec.stream_interface_attribute7,
165: l_okl_sif_ret_levels_v_rec.stream_interface_attribute8,
166: l_okl_sif_ret_levels_v_rec.stream_interface_attribute9,
167: l_okl_sif_ret_levels_v_rec.stream_interface_attribute10,
168: l_okl_sif_ret_levels_v_rec.stream_interface_attribute11,
169: l_okl_sif_ret_levels_v_rec.stream_interface_attribute12,
170: l_okl_sif_ret_levels_v_rec.stream_interface_attribute13,
171: l_okl_sif_ret_levels_v_rec.stream_interface_attribute14,
172: l_okl_sif_ret_levels_v_rec.stream_interface_attribute15,
165: l_okl_sif_ret_levels_v_rec.stream_interface_attribute8,
166: l_okl_sif_ret_levels_v_rec.stream_interface_attribute9,
167: l_okl_sif_ret_levels_v_rec.stream_interface_attribute10,
168: l_okl_sif_ret_levels_v_rec.stream_interface_attribute11,
169: l_okl_sif_ret_levels_v_rec.stream_interface_attribute12,
170: l_okl_sif_ret_levels_v_rec.stream_interface_attribute13,
171: l_okl_sif_ret_levels_v_rec.stream_interface_attribute14,
172: l_okl_sif_ret_levels_v_rec.stream_interface_attribute15,
173: l_okl_sif_ret_levels_v_rec.creation_date,
166: l_okl_sif_ret_levels_v_rec.stream_interface_attribute9,
167: l_okl_sif_ret_levels_v_rec.stream_interface_attribute10,
168: l_okl_sif_ret_levels_v_rec.stream_interface_attribute11,
169: l_okl_sif_ret_levels_v_rec.stream_interface_attribute12,
170: l_okl_sif_ret_levels_v_rec.stream_interface_attribute13,
171: l_okl_sif_ret_levels_v_rec.stream_interface_attribute14,
172: l_okl_sif_ret_levels_v_rec.stream_interface_attribute15,
173: l_okl_sif_ret_levels_v_rec.creation_date,
174: l_okl_sif_ret_levels_v_rec.created_by,
167: l_okl_sif_ret_levels_v_rec.stream_interface_attribute10,
168: l_okl_sif_ret_levels_v_rec.stream_interface_attribute11,
169: l_okl_sif_ret_levels_v_rec.stream_interface_attribute12,
170: l_okl_sif_ret_levels_v_rec.stream_interface_attribute13,
171: l_okl_sif_ret_levels_v_rec.stream_interface_attribute14,
172: l_okl_sif_ret_levels_v_rec.stream_interface_attribute15,
173: l_okl_sif_ret_levels_v_rec.creation_date,
174: l_okl_sif_ret_levels_v_rec.created_by,
175: l_okl_sif_ret_levels_v_rec.last_update_date,
168: l_okl_sif_ret_levels_v_rec.stream_interface_attribute11,
169: l_okl_sif_ret_levels_v_rec.stream_interface_attribute12,
170: l_okl_sif_ret_levels_v_rec.stream_interface_attribute13,
171: l_okl_sif_ret_levels_v_rec.stream_interface_attribute14,
172: l_okl_sif_ret_levels_v_rec.stream_interface_attribute15,
173: l_okl_sif_ret_levels_v_rec.creation_date,
174: l_okl_sif_ret_levels_v_rec.created_by,
175: l_okl_sif_ret_levels_v_rec.last_update_date,
176: l_okl_sif_ret_levels_v_rec.last_updated_by,
169: l_okl_sif_ret_levels_v_rec.stream_interface_attribute12,
170: l_okl_sif_ret_levels_v_rec.stream_interface_attribute13,
171: l_okl_sif_ret_levels_v_rec.stream_interface_attribute14,
172: l_okl_sif_ret_levels_v_rec.stream_interface_attribute15,
173: l_okl_sif_ret_levels_v_rec.creation_date,
174: l_okl_sif_ret_levels_v_rec.created_by,
175: l_okl_sif_ret_levels_v_rec.last_update_date,
176: l_okl_sif_ret_levels_v_rec.last_updated_by,
177: l_okl_sif_ret_levels_v_rec.last_update_login,
170: l_okl_sif_ret_levels_v_rec.stream_interface_attribute13,
171: l_okl_sif_ret_levels_v_rec.stream_interface_attribute14,
172: l_okl_sif_ret_levels_v_rec.stream_interface_attribute15,
173: l_okl_sif_ret_levels_v_rec.creation_date,
174: l_okl_sif_ret_levels_v_rec.created_by,
175: l_okl_sif_ret_levels_v_rec.last_update_date,
176: l_okl_sif_ret_levels_v_rec.last_updated_by,
177: l_okl_sif_ret_levels_v_rec.last_update_login,
178: l_okl_sif_ret_levels_v_rec.rate; --smahapat 10/12/03
171: l_okl_sif_ret_levels_v_rec.stream_interface_attribute14,
172: l_okl_sif_ret_levels_v_rec.stream_interface_attribute15,
173: l_okl_sif_ret_levels_v_rec.creation_date,
174: l_okl_sif_ret_levels_v_rec.created_by,
175: l_okl_sif_ret_levels_v_rec.last_update_date,
176: l_okl_sif_ret_levels_v_rec.last_updated_by,
177: l_okl_sif_ret_levels_v_rec.last_update_login,
178: l_okl_sif_ret_levels_v_rec.rate; --smahapat 10/12/03
179: x_no_data_found := srlv_pk_csr%NOTFOUND;
172: l_okl_sif_ret_levels_v_rec.stream_interface_attribute15,
173: l_okl_sif_ret_levels_v_rec.creation_date,
174: l_okl_sif_ret_levels_v_rec.created_by,
175: l_okl_sif_ret_levels_v_rec.last_update_date,
176: l_okl_sif_ret_levels_v_rec.last_updated_by,
177: l_okl_sif_ret_levels_v_rec.last_update_login,
178: l_okl_sif_ret_levels_v_rec.rate; --smahapat 10/12/03
179: x_no_data_found := srlv_pk_csr%NOTFOUND;
180: CLOSE srlv_pk_csr;
173: l_okl_sif_ret_levels_v_rec.creation_date,
174: l_okl_sif_ret_levels_v_rec.created_by,
175: l_okl_sif_ret_levels_v_rec.last_update_date,
176: l_okl_sif_ret_levels_v_rec.last_updated_by,
177: l_okl_sif_ret_levels_v_rec.last_update_login,
178: l_okl_sif_ret_levels_v_rec.rate; --smahapat 10/12/03
179: x_no_data_found := srlv_pk_csr%NOTFOUND;
180: CLOSE srlv_pk_csr;
181: RETURN(l_okl_sif_ret_levels_v_rec);
174: l_okl_sif_ret_levels_v_rec.created_by,
175: l_okl_sif_ret_levels_v_rec.last_update_date,
176: l_okl_sif_ret_levels_v_rec.last_updated_by,
177: l_okl_sif_ret_levels_v_rec.last_update_login,
178: l_okl_sif_ret_levels_v_rec.rate; --smahapat 10/12/03
179: x_no_data_found := srlv_pk_csr%NOTFOUND;
180: CLOSE srlv_pk_csr;
181: RETURN(l_okl_sif_ret_levels_v_rec);
182: END get_rec;
177: l_okl_sif_ret_levels_v_rec.last_update_login,
178: l_okl_sif_ret_levels_v_rec.rate; --smahapat 10/12/03
179: x_no_data_found := srlv_pk_csr%NOTFOUND;
180: CLOSE srlv_pk_csr;
181: RETURN(l_okl_sif_ret_levels_v_rec);
182: END get_rec;
183:
184: ------------------------------------------------------------------
185: -- This version of get_rec sets error messages if no data found --
184: ------------------------------------------------------------------
185: -- This version of get_rec sets error messages if no data found --
186: ------------------------------------------------------------------
187: FUNCTION get_rec (
188: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
189: x_return_status OUT NOCOPY VARCHAR2
190: ) RETURN okl_sif_ret_levels_v_rec_type IS
191: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type;
192: l_row_notfound BOOLEAN := TRUE;
186: ------------------------------------------------------------------
187: FUNCTION get_rec (
188: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
189: x_return_status OUT NOCOPY VARCHAR2
190: ) RETURN okl_sif_ret_levels_v_rec_type IS
191: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type;
192: l_row_notfound BOOLEAN := TRUE;
193: BEGIN
194: x_return_status := OKC_API.G_RET_STS_SUCCESS;
187: FUNCTION get_rec (
188: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
189: x_return_status OUT NOCOPY VARCHAR2
190: ) RETURN okl_sif_ret_levels_v_rec_type IS
191: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type;
192: l_row_notfound BOOLEAN := TRUE;
193: BEGIN
194: x_return_status := OKC_API.G_RET_STS_SUCCESS;
195: l_okl_sif_ret_levels_v_rec := get_rec(p_okl_sif_ret_levels_v_rec, l_row_notfound);
191: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type;
192: l_row_notfound BOOLEAN := TRUE;
193: BEGIN
194: x_return_status := OKC_API.G_RET_STS_SUCCESS;
195: l_okl_sif_ret_levels_v_rec := get_rec(p_okl_sif_ret_levels_v_rec, l_row_notfound);
196: IF (l_row_notfound) THEN
197: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
198: x_return_status := OKC_API.G_RET_STS_ERROR;
199: END IF;
196: IF (l_row_notfound) THEN
197: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
198: x_return_status := OKC_API.G_RET_STS_ERROR;
199: END IF;
200: RETURN(l_okl_sif_ret_levels_v_rec);
201: END get_rec;
202: -----------------------------------------------------------
203: -- So we don't have to pass an "l_row_notfound" variable --
204: -----------------------------------------------------------
202: -----------------------------------------------------------
203: -- So we don't have to pass an "l_row_notfound" variable --
204: -----------------------------------------------------------
205: FUNCTION get_rec (
206: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
207: ) RETURN okl_sif_ret_levels_v_rec_type IS
208: l_row_not_found BOOLEAN := TRUE;
209: BEGIN
210: RETURN(get_rec(p_okl_sif_ret_levels_v_rec, l_row_not_found));
203: -- So we don't have to pass an "l_row_notfound" variable --
204: -----------------------------------------------------------
205: FUNCTION get_rec (
206: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
207: ) RETURN okl_sif_ret_levels_v_rec_type IS
208: l_row_not_found BOOLEAN := TRUE;
209: BEGIN
210: RETURN(get_rec(p_okl_sif_ret_levels_v_rec, l_row_not_found));
211: END get_rec;
206: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
207: ) RETURN okl_sif_ret_levels_v_rec_type IS
208: l_row_not_found BOOLEAN := TRUE;
209: BEGIN
210: RETURN(get_rec(p_okl_sif_ret_levels_v_rec, l_row_not_found));
211: END get_rec;
212: ---------------------------------------------------------------------------
213: -- FUNCTION get_rec for: OKL_SIF_RET_LEVELS
214: ---------------------------------------------------------------------------
328: BEGIN
329: RETURN(get_rec(p_srl_rec, l_row_not_found));
330: END get_rec;
331: ---------------------------------------------------------------------------
332: -- FUNCTION null_out_defaults for: OKL_SIF_RET_LEVELS_V
333: ---------------------------------------------------------------------------
334: FUNCTION null_out_defaults (
335: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
336: ) RETURN okl_sif_ret_levels_v_rec_type IS
331: ---------------------------------------------------------------------------
332: -- FUNCTION null_out_defaults for: OKL_SIF_RET_LEVELS_V
333: ---------------------------------------------------------------------------
334: FUNCTION null_out_defaults (
335: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
336: ) RETURN okl_sif_ret_levels_v_rec_type IS
337: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
338: BEGIN
339: IF (l_okl_sif_ret_levels_v_rec.id = OKC_API.G_MISS_NUM ) THEN
332: -- FUNCTION null_out_defaults for: OKL_SIF_RET_LEVELS_V
333: ---------------------------------------------------------------------------
334: FUNCTION null_out_defaults (
335: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
336: ) RETURN okl_sif_ret_levels_v_rec_type IS
337: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
338: BEGIN
339: IF (l_okl_sif_ret_levels_v_rec.id = OKC_API.G_MISS_NUM ) THEN
340: l_okl_sif_ret_levels_v_rec.id := NULL;
333: ---------------------------------------------------------------------------
334: FUNCTION null_out_defaults (
335: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
336: ) RETURN okl_sif_ret_levels_v_rec_type IS
337: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
338: BEGIN
339: IF (l_okl_sif_ret_levels_v_rec.id = OKC_API.G_MISS_NUM ) THEN
340: l_okl_sif_ret_levels_v_rec.id := NULL;
341: END IF;
335: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
336: ) RETURN okl_sif_ret_levels_v_rec_type IS
337: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
338: BEGIN
339: IF (l_okl_sif_ret_levels_v_rec.id = OKC_API.G_MISS_NUM ) THEN
340: l_okl_sif_ret_levels_v_rec.id := NULL;
341: END IF;
342: IF (l_okl_sif_ret_levels_v_rec.level_index_number = OKC_API.G_MISS_NUM ) THEN
343: l_okl_sif_ret_levels_v_rec.level_index_number := NULL;
336: ) RETURN okl_sif_ret_levels_v_rec_type IS
337: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
338: BEGIN
339: IF (l_okl_sif_ret_levels_v_rec.id = OKC_API.G_MISS_NUM ) THEN
340: l_okl_sif_ret_levels_v_rec.id := NULL;
341: END IF;
342: IF (l_okl_sif_ret_levels_v_rec.level_index_number = OKC_API.G_MISS_NUM ) THEN
343: l_okl_sif_ret_levels_v_rec.level_index_number := NULL;
344: END IF;
338: BEGIN
339: IF (l_okl_sif_ret_levels_v_rec.id = OKC_API.G_MISS_NUM ) THEN
340: l_okl_sif_ret_levels_v_rec.id := NULL;
341: END IF;
342: IF (l_okl_sif_ret_levels_v_rec.level_index_number = OKC_API.G_MISS_NUM ) THEN
343: l_okl_sif_ret_levels_v_rec.level_index_number := NULL;
344: END IF;
345: IF (l_okl_sif_ret_levels_v_rec.number_of_periods = OKC_API.G_MISS_NUM ) THEN
346: l_okl_sif_ret_levels_v_rec.number_of_periods := NULL;
339: IF (l_okl_sif_ret_levels_v_rec.id = OKC_API.G_MISS_NUM ) THEN
340: l_okl_sif_ret_levels_v_rec.id := NULL;
341: END IF;
342: IF (l_okl_sif_ret_levels_v_rec.level_index_number = OKC_API.G_MISS_NUM ) THEN
343: l_okl_sif_ret_levels_v_rec.level_index_number := NULL;
344: END IF;
345: IF (l_okl_sif_ret_levels_v_rec.number_of_periods = OKC_API.G_MISS_NUM ) THEN
346: l_okl_sif_ret_levels_v_rec.number_of_periods := NULL;
347: END IF;
341: END IF;
342: IF (l_okl_sif_ret_levels_v_rec.level_index_number = OKC_API.G_MISS_NUM ) THEN
343: l_okl_sif_ret_levels_v_rec.level_index_number := NULL;
344: END IF;
345: IF (l_okl_sif_ret_levels_v_rec.number_of_periods = OKC_API.G_MISS_NUM ) THEN
346: l_okl_sif_ret_levels_v_rec.number_of_periods := NULL;
347: END IF;
348: IF (l_okl_sif_ret_levels_v_rec.sir_id = OKC_API.G_MISS_NUM ) THEN
349: l_okl_sif_ret_levels_v_rec.sir_id := NULL;
342: IF (l_okl_sif_ret_levels_v_rec.level_index_number = OKC_API.G_MISS_NUM ) THEN
343: l_okl_sif_ret_levels_v_rec.level_index_number := NULL;
344: END IF;
345: IF (l_okl_sif_ret_levels_v_rec.number_of_periods = OKC_API.G_MISS_NUM ) THEN
346: l_okl_sif_ret_levels_v_rec.number_of_periods := NULL;
347: END IF;
348: IF (l_okl_sif_ret_levels_v_rec.sir_id = OKC_API.G_MISS_NUM ) THEN
349: l_okl_sif_ret_levels_v_rec.sir_id := NULL;
350: END IF;
344: END IF;
345: IF (l_okl_sif_ret_levels_v_rec.number_of_periods = OKC_API.G_MISS_NUM ) THEN
346: l_okl_sif_ret_levels_v_rec.number_of_periods := NULL;
347: END IF;
348: IF (l_okl_sif_ret_levels_v_rec.sir_id = OKC_API.G_MISS_NUM ) THEN
349: l_okl_sif_ret_levels_v_rec.sir_id := NULL;
350: END IF;
351: IF (l_okl_sif_ret_levels_v_rec.index_number = OKC_API.G_MISS_NUM ) THEN
352: l_okl_sif_ret_levels_v_rec.index_number := NULL;
345: IF (l_okl_sif_ret_levels_v_rec.number_of_periods = OKC_API.G_MISS_NUM ) THEN
346: l_okl_sif_ret_levels_v_rec.number_of_periods := NULL;
347: END IF;
348: IF (l_okl_sif_ret_levels_v_rec.sir_id = OKC_API.G_MISS_NUM ) THEN
349: l_okl_sif_ret_levels_v_rec.sir_id := NULL;
350: END IF;
351: IF (l_okl_sif_ret_levels_v_rec.index_number = OKC_API.G_MISS_NUM ) THEN
352: l_okl_sif_ret_levels_v_rec.index_number := NULL;
353: END IF;
347: END IF;
348: IF (l_okl_sif_ret_levels_v_rec.sir_id = OKC_API.G_MISS_NUM ) THEN
349: l_okl_sif_ret_levels_v_rec.sir_id := NULL;
350: END IF;
351: IF (l_okl_sif_ret_levels_v_rec.index_number = OKC_API.G_MISS_NUM ) THEN
352: l_okl_sif_ret_levels_v_rec.index_number := NULL;
353: END IF;
354: IF (l_okl_sif_ret_levels_v_rec.level_type = OKC_API.G_MISS_CHAR ) THEN
355: l_okl_sif_ret_levels_v_rec.level_type := NULL;
348: IF (l_okl_sif_ret_levels_v_rec.sir_id = OKC_API.G_MISS_NUM ) THEN
349: l_okl_sif_ret_levels_v_rec.sir_id := NULL;
350: END IF;
351: IF (l_okl_sif_ret_levels_v_rec.index_number = OKC_API.G_MISS_NUM ) THEN
352: l_okl_sif_ret_levels_v_rec.index_number := NULL;
353: END IF;
354: IF (l_okl_sif_ret_levels_v_rec.level_type = OKC_API.G_MISS_CHAR ) THEN
355: l_okl_sif_ret_levels_v_rec.level_type := NULL;
356: END IF;
350: END IF;
351: IF (l_okl_sif_ret_levels_v_rec.index_number = OKC_API.G_MISS_NUM ) THEN
352: l_okl_sif_ret_levels_v_rec.index_number := NULL;
353: END IF;
354: IF (l_okl_sif_ret_levels_v_rec.level_type = OKC_API.G_MISS_CHAR ) THEN
355: l_okl_sif_ret_levels_v_rec.level_type := NULL;
356: END IF;
357: IF (l_okl_sif_ret_levels_v_rec.amount = OKC_API.G_MISS_NUM ) THEN
358: l_okl_sif_ret_levels_v_rec.amount := NULL;
351: IF (l_okl_sif_ret_levels_v_rec.index_number = OKC_API.G_MISS_NUM ) THEN
352: l_okl_sif_ret_levels_v_rec.index_number := NULL;
353: END IF;
354: IF (l_okl_sif_ret_levels_v_rec.level_type = OKC_API.G_MISS_CHAR ) THEN
355: l_okl_sif_ret_levels_v_rec.level_type := NULL;
356: END IF;
357: IF (l_okl_sif_ret_levels_v_rec.amount = OKC_API.G_MISS_NUM ) THEN
358: l_okl_sif_ret_levels_v_rec.amount := NULL;
359: END IF;
353: END IF;
354: IF (l_okl_sif_ret_levels_v_rec.level_type = OKC_API.G_MISS_CHAR ) THEN
355: l_okl_sif_ret_levels_v_rec.level_type := NULL;
356: END IF;
357: IF (l_okl_sif_ret_levels_v_rec.amount = OKC_API.G_MISS_NUM ) THEN
358: l_okl_sif_ret_levels_v_rec.amount := NULL;
359: END IF;
360: IF (l_okl_sif_ret_levels_v_rec.advance_or_arrears = OKC_API.G_MISS_CHAR ) THEN
361: l_okl_sif_ret_levels_v_rec.advance_or_arrears := NULL;
354: IF (l_okl_sif_ret_levels_v_rec.level_type = OKC_API.G_MISS_CHAR ) THEN
355: l_okl_sif_ret_levels_v_rec.level_type := NULL;
356: END IF;
357: IF (l_okl_sif_ret_levels_v_rec.amount = OKC_API.G_MISS_NUM ) THEN
358: l_okl_sif_ret_levels_v_rec.amount := NULL;
359: END IF;
360: IF (l_okl_sif_ret_levels_v_rec.advance_or_arrears = OKC_API.G_MISS_CHAR ) THEN
361: l_okl_sif_ret_levels_v_rec.advance_or_arrears := NULL;
362: END IF;
356: END IF;
357: IF (l_okl_sif_ret_levels_v_rec.amount = OKC_API.G_MISS_NUM ) THEN
358: l_okl_sif_ret_levels_v_rec.amount := NULL;
359: END IF;
360: IF (l_okl_sif_ret_levels_v_rec.advance_or_arrears = OKC_API.G_MISS_CHAR ) THEN
361: l_okl_sif_ret_levels_v_rec.advance_or_arrears := NULL;
362: END IF;
363: IF (l_okl_sif_ret_levels_v_rec.period = OKC_API.G_MISS_CHAR ) THEN
364: l_okl_sif_ret_levels_v_rec.period := NULL;
357: IF (l_okl_sif_ret_levels_v_rec.amount = OKC_API.G_MISS_NUM ) THEN
358: l_okl_sif_ret_levels_v_rec.amount := NULL;
359: END IF;
360: IF (l_okl_sif_ret_levels_v_rec.advance_or_arrears = OKC_API.G_MISS_CHAR ) THEN
361: l_okl_sif_ret_levels_v_rec.advance_or_arrears := NULL;
362: END IF;
363: IF (l_okl_sif_ret_levels_v_rec.period = OKC_API.G_MISS_CHAR ) THEN
364: l_okl_sif_ret_levels_v_rec.period := NULL;
365: END IF;
359: END IF;
360: IF (l_okl_sif_ret_levels_v_rec.advance_or_arrears = OKC_API.G_MISS_CHAR ) THEN
361: l_okl_sif_ret_levels_v_rec.advance_or_arrears := NULL;
362: END IF;
363: IF (l_okl_sif_ret_levels_v_rec.period = OKC_API.G_MISS_CHAR ) THEN
364: l_okl_sif_ret_levels_v_rec.period := NULL;
365: END IF;
366: IF (l_okl_sif_ret_levels_v_rec.lock_level_step = OKC_API.G_MISS_CHAR ) THEN
367: l_okl_sif_ret_levels_v_rec.lock_level_step := NULL;
360: IF (l_okl_sif_ret_levels_v_rec.advance_or_arrears = OKC_API.G_MISS_CHAR ) THEN
361: l_okl_sif_ret_levels_v_rec.advance_or_arrears := NULL;
362: END IF;
363: IF (l_okl_sif_ret_levels_v_rec.period = OKC_API.G_MISS_CHAR ) THEN
364: l_okl_sif_ret_levels_v_rec.period := NULL;
365: END IF;
366: IF (l_okl_sif_ret_levels_v_rec.lock_level_step = OKC_API.G_MISS_CHAR ) THEN
367: l_okl_sif_ret_levels_v_rec.lock_level_step := NULL;
368: END IF;
362: END IF;
363: IF (l_okl_sif_ret_levels_v_rec.period = OKC_API.G_MISS_CHAR ) THEN
364: l_okl_sif_ret_levels_v_rec.period := NULL;
365: END IF;
366: IF (l_okl_sif_ret_levels_v_rec.lock_level_step = OKC_API.G_MISS_CHAR ) THEN
367: l_okl_sif_ret_levels_v_rec.lock_level_step := NULL;
368: END IF;
369: IF (l_okl_sif_ret_levels_v_rec.days_in_period = OKC_API.G_MISS_NUM ) THEN
370: l_okl_sif_ret_levels_v_rec.days_in_period := NULL;
363: IF (l_okl_sif_ret_levels_v_rec.period = OKC_API.G_MISS_CHAR ) THEN
364: l_okl_sif_ret_levels_v_rec.period := NULL;
365: END IF;
366: IF (l_okl_sif_ret_levels_v_rec.lock_level_step = OKC_API.G_MISS_CHAR ) THEN
367: l_okl_sif_ret_levels_v_rec.lock_level_step := NULL;
368: END IF;
369: IF (l_okl_sif_ret_levels_v_rec.days_in_period = OKC_API.G_MISS_NUM ) THEN
370: l_okl_sif_ret_levels_v_rec.days_in_period := NULL;
371: END IF;
365: END IF;
366: IF (l_okl_sif_ret_levels_v_rec.lock_level_step = OKC_API.G_MISS_CHAR ) THEN
367: l_okl_sif_ret_levels_v_rec.lock_level_step := NULL;
368: END IF;
369: IF (l_okl_sif_ret_levels_v_rec.days_in_period = OKC_API.G_MISS_NUM ) THEN
370: l_okl_sif_ret_levels_v_rec.days_in_period := NULL;
371: END IF;
372: IF (l_okl_sif_ret_levels_v_rec.first_payment_date = OKC_API.G_MISS_DATE ) THEN
373: l_okl_sif_ret_levels_v_rec.first_payment_date := NULL;
366: IF (l_okl_sif_ret_levels_v_rec.lock_level_step = OKC_API.G_MISS_CHAR ) THEN
367: l_okl_sif_ret_levels_v_rec.lock_level_step := NULL;
368: END IF;
369: IF (l_okl_sif_ret_levels_v_rec.days_in_period = OKC_API.G_MISS_NUM ) THEN
370: l_okl_sif_ret_levels_v_rec.days_in_period := NULL;
371: END IF;
372: IF (l_okl_sif_ret_levels_v_rec.first_payment_date = OKC_API.G_MISS_DATE ) THEN
373: l_okl_sif_ret_levels_v_rec.first_payment_date := NULL;
374: END IF;
368: END IF;
369: IF (l_okl_sif_ret_levels_v_rec.days_in_period = OKC_API.G_MISS_NUM ) THEN
370: l_okl_sif_ret_levels_v_rec.days_in_period := NULL;
371: END IF;
372: IF (l_okl_sif_ret_levels_v_rec.first_payment_date = OKC_API.G_MISS_DATE ) THEN
373: l_okl_sif_ret_levels_v_rec.first_payment_date := NULL;
374: END IF;
375: IF (l_okl_sif_ret_levels_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
376: l_okl_sif_ret_levels_v_rec.object_version_number := NULL;
369: IF (l_okl_sif_ret_levels_v_rec.days_in_period = OKC_API.G_MISS_NUM ) THEN
370: l_okl_sif_ret_levels_v_rec.days_in_period := NULL;
371: END IF;
372: IF (l_okl_sif_ret_levels_v_rec.first_payment_date = OKC_API.G_MISS_DATE ) THEN
373: l_okl_sif_ret_levels_v_rec.first_payment_date := NULL;
374: END IF;
375: IF (l_okl_sif_ret_levels_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
376: l_okl_sif_ret_levels_v_rec.object_version_number := NULL;
377: END IF;
371: END IF;
372: IF (l_okl_sif_ret_levels_v_rec.first_payment_date = OKC_API.G_MISS_DATE ) THEN
373: l_okl_sif_ret_levels_v_rec.first_payment_date := NULL;
374: END IF;
375: IF (l_okl_sif_ret_levels_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
376: l_okl_sif_ret_levels_v_rec.object_version_number := NULL;
377: END IF;
378: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute1 = OKC_API.G_MISS_CHAR ) THEN
379: l_okl_sif_ret_levels_v_rec.stream_interface_attribute1 := NULL;
372: IF (l_okl_sif_ret_levels_v_rec.first_payment_date = OKC_API.G_MISS_DATE ) THEN
373: l_okl_sif_ret_levels_v_rec.first_payment_date := NULL;
374: END IF;
375: IF (l_okl_sif_ret_levels_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
376: l_okl_sif_ret_levels_v_rec.object_version_number := NULL;
377: END IF;
378: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute1 = OKC_API.G_MISS_CHAR ) THEN
379: l_okl_sif_ret_levels_v_rec.stream_interface_attribute1 := NULL;
380: END IF;
374: END IF;
375: IF (l_okl_sif_ret_levels_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
376: l_okl_sif_ret_levels_v_rec.object_version_number := NULL;
377: END IF;
378: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute1 = OKC_API.G_MISS_CHAR ) THEN
379: l_okl_sif_ret_levels_v_rec.stream_interface_attribute1 := NULL;
380: END IF;
381: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute2 = OKC_API.G_MISS_CHAR ) THEN
382: l_okl_sif_ret_levels_v_rec.stream_interface_attribute2 := NULL;
375: IF (l_okl_sif_ret_levels_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
376: l_okl_sif_ret_levels_v_rec.object_version_number := NULL;
377: END IF;
378: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute1 = OKC_API.G_MISS_CHAR ) THEN
379: l_okl_sif_ret_levels_v_rec.stream_interface_attribute1 := NULL;
380: END IF;
381: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute2 = OKC_API.G_MISS_CHAR ) THEN
382: l_okl_sif_ret_levels_v_rec.stream_interface_attribute2 := NULL;
383: END IF;
377: END IF;
378: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute1 = OKC_API.G_MISS_CHAR ) THEN
379: l_okl_sif_ret_levels_v_rec.stream_interface_attribute1 := NULL;
380: END IF;
381: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute2 = OKC_API.G_MISS_CHAR ) THEN
382: l_okl_sif_ret_levels_v_rec.stream_interface_attribute2 := NULL;
383: END IF;
384: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute3 = OKC_API.G_MISS_CHAR ) THEN
385: l_okl_sif_ret_levels_v_rec.stream_interface_attribute3 := NULL;
378: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute1 = OKC_API.G_MISS_CHAR ) THEN
379: l_okl_sif_ret_levels_v_rec.stream_interface_attribute1 := NULL;
380: END IF;
381: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute2 = OKC_API.G_MISS_CHAR ) THEN
382: l_okl_sif_ret_levels_v_rec.stream_interface_attribute2 := NULL;
383: END IF;
384: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute3 = OKC_API.G_MISS_CHAR ) THEN
385: l_okl_sif_ret_levels_v_rec.stream_interface_attribute3 := NULL;
386: END IF;
380: END IF;
381: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute2 = OKC_API.G_MISS_CHAR ) THEN
382: l_okl_sif_ret_levels_v_rec.stream_interface_attribute2 := NULL;
383: END IF;
384: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute3 = OKC_API.G_MISS_CHAR ) THEN
385: l_okl_sif_ret_levels_v_rec.stream_interface_attribute3 := NULL;
386: END IF;
387: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute4 = OKC_API.G_MISS_CHAR ) THEN
388: l_okl_sif_ret_levels_v_rec.stream_interface_attribute4 := NULL;
381: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute2 = OKC_API.G_MISS_CHAR ) THEN
382: l_okl_sif_ret_levels_v_rec.stream_interface_attribute2 := NULL;
383: END IF;
384: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute3 = OKC_API.G_MISS_CHAR ) THEN
385: l_okl_sif_ret_levels_v_rec.stream_interface_attribute3 := NULL;
386: END IF;
387: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute4 = OKC_API.G_MISS_CHAR ) THEN
388: l_okl_sif_ret_levels_v_rec.stream_interface_attribute4 := NULL;
389: END IF;
383: END IF;
384: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute3 = OKC_API.G_MISS_CHAR ) THEN
385: l_okl_sif_ret_levels_v_rec.stream_interface_attribute3 := NULL;
386: END IF;
387: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute4 = OKC_API.G_MISS_CHAR ) THEN
388: l_okl_sif_ret_levels_v_rec.stream_interface_attribute4 := NULL;
389: END IF;
390: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute5 = OKC_API.G_MISS_CHAR ) THEN
391: l_okl_sif_ret_levels_v_rec.stream_interface_attribute5 := NULL;
384: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute3 = OKC_API.G_MISS_CHAR ) THEN
385: l_okl_sif_ret_levels_v_rec.stream_interface_attribute3 := NULL;
386: END IF;
387: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute4 = OKC_API.G_MISS_CHAR ) THEN
388: l_okl_sif_ret_levels_v_rec.stream_interface_attribute4 := NULL;
389: END IF;
390: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute5 = OKC_API.G_MISS_CHAR ) THEN
391: l_okl_sif_ret_levels_v_rec.stream_interface_attribute5 := NULL;
392: END IF;
386: END IF;
387: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute4 = OKC_API.G_MISS_CHAR ) THEN
388: l_okl_sif_ret_levels_v_rec.stream_interface_attribute4 := NULL;
389: END IF;
390: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute5 = OKC_API.G_MISS_CHAR ) THEN
391: l_okl_sif_ret_levels_v_rec.stream_interface_attribute5 := NULL;
392: END IF;
393: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute6 = OKC_API.G_MISS_CHAR ) THEN
394: l_okl_sif_ret_levels_v_rec.stream_interface_attribute6 := NULL;
387: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute4 = OKC_API.G_MISS_CHAR ) THEN
388: l_okl_sif_ret_levels_v_rec.stream_interface_attribute4 := NULL;
389: END IF;
390: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute5 = OKC_API.G_MISS_CHAR ) THEN
391: l_okl_sif_ret_levels_v_rec.stream_interface_attribute5 := NULL;
392: END IF;
393: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute6 = OKC_API.G_MISS_CHAR ) THEN
394: l_okl_sif_ret_levels_v_rec.stream_interface_attribute6 := NULL;
395: END IF;
389: END IF;
390: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute5 = OKC_API.G_MISS_CHAR ) THEN
391: l_okl_sif_ret_levels_v_rec.stream_interface_attribute5 := NULL;
392: END IF;
393: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute6 = OKC_API.G_MISS_CHAR ) THEN
394: l_okl_sif_ret_levels_v_rec.stream_interface_attribute6 := NULL;
395: END IF;
396: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute7 = OKC_API.G_MISS_CHAR ) THEN
397: l_okl_sif_ret_levels_v_rec.stream_interface_attribute7 := NULL;
390: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute5 = OKC_API.G_MISS_CHAR ) THEN
391: l_okl_sif_ret_levels_v_rec.stream_interface_attribute5 := NULL;
392: END IF;
393: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute6 = OKC_API.G_MISS_CHAR ) THEN
394: l_okl_sif_ret_levels_v_rec.stream_interface_attribute6 := NULL;
395: END IF;
396: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute7 = OKC_API.G_MISS_CHAR ) THEN
397: l_okl_sif_ret_levels_v_rec.stream_interface_attribute7 := NULL;
398: END IF;
392: END IF;
393: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute6 = OKC_API.G_MISS_CHAR ) THEN
394: l_okl_sif_ret_levels_v_rec.stream_interface_attribute6 := NULL;
395: END IF;
396: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute7 = OKC_API.G_MISS_CHAR ) THEN
397: l_okl_sif_ret_levels_v_rec.stream_interface_attribute7 := NULL;
398: END IF;
399: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute8 = OKC_API.G_MISS_CHAR ) THEN
400: l_okl_sif_ret_levels_v_rec.stream_interface_attribute8 := NULL;
393: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute6 = OKC_API.G_MISS_CHAR ) THEN
394: l_okl_sif_ret_levels_v_rec.stream_interface_attribute6 := NULL;
395: END IF;
396: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute7 = OKC_API.G_MISS_CHAR ) THEN
397: l_okl_sif_ret_levels_v_rec.stream_interface_attribute7 := NULL;
398: END IF;
399: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute8 = OKC_API.G_MISS_CHAR ) THEN
400: l_okl_sif_ret_levels_v_rec.stream_interface_attribute8 := NULL;
401: END IF;
395: END IF;
396: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute7 = OKC_API.G_MISS_CHAR ) THEN
397: l_okl_sif_ret_levels_v_rec.stream_interface_attribute7 := NULL;
398: END IF;
399: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute8 = OKC_API.G_MISS_CHAR ) THEN
400: l_okl_sif_ret_levels_v_rec.stream_interface_attribute8 := NULL;
401: END IF;
402: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute9 = OKC_API.G_MISS_CHAR ) THEN
403: l_okl_sif_ret_levels_v_rec.stream_interface_attribute9 := NULL;
396: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute7 = OKC_API.G_MISS_CHAR ) THEN
397: l_okl_sif_ret_levels_v_rec.stream_interface_attribute7 := NULL;
398: END IF;
399: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute8 = OKC_API.G_MISS_CHAR ) THEN
400: l_okl_sif_ret_levels_v_rec.stream_interface_attribute8 := NULL;
401: END IF;
402: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute9 = OKC_API.G_MISS_CHAR ) THEN
403: l_okl_sif_ret_levels_v_rec.stream_interface_attribute9 := NULL;
404: END IF;
398: END IF;
399: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute8 = OKC_API.G_MISS_CHAR ) THEN
400: l_okl_sif_ret_levels_v_rec.stream_interface_attribute8 := NULL;
401: END IF;
402: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute9 = OKC_API.G_MISS_CHAR ) THEN
403: l_okl_sif_ret_levels_v_rec.stream_interface_attribute9 := NULL;
404: END IF;
405: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute10 = OKC_API.G_MISS_CHAR ) THEN
406: l_okl_sif_ret_levels_v_rec.stream_interface_attribute10 := NULL;
399: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute8 = OKC_API.G_MISS_CHAR ) THEN
400: l_okl_sif_ret_levels_v_rec.stream_interface_attribute8 := NULL;
401: END IF;
402: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute9 = OKC_API.G_MISS_CHAR ) THEN
403: l_okl_sif_ret_levels_v_rec.stream_interface_attribute9 := NULL;
404: END IF;
405: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute10 = OKC_API.G_MISS_CHAR ) THEN
406: l_okl_sif_ret_levels_v_rec.stream_interface_attribute10 := NULL;
407: END IF;
401: END IF;
402: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute9 = OKC_API.G_MISS_CHAR ) THEN
403: l_okl_sif_ret_levels_v_rec.stream_interface_attribute9 := NULL;
404: END IF;
405: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute10 = OKC_API.G_MISS_CHAR ) THEN
406: l_okl_sif_ret_levels_v_rec.stream_interface_attribute10 := NULL;
407: END IF;
408: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute11 = OKC_API.G_MISS_CHAR ) THEN
409: l_okl_sif_ret_levels_v_rec.stream_interface_attribute11 := NULL;
402: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute9 = OKC_API.G_MISS_CHAR ) THEN
403: l_okl_sif_ret_levels_v_rec.stream_interface_attribute9 := NULL;
404: END IF;
405: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute10 = OKC_API.G_MISS_CHAR ) THEN
406: l_okl_sif_ret_levels_v_rec.stream_interface_attribute10 := NULL;
407: END IF;
408: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute11 = OKC_API.G_MISS_CHAR ) THEN
409: l_okl_sif_ret_levels_v_rec.stream_interface_attribute11 := NULL;
410: END IF;
404: END IF;
405: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute10 = OKC_API.G_MISS_CHAR ) THEN
406: l_okl_sif_ret_levels_v_rec.stream_interface_attribute10 := NULL;
407: END IF;
408: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute11 = OKC_API.G_MISS_CHAR ) THEN
409: l_okl_sif_ret_levels_v_rec.stream_interface_attribute11 := NULL;
410: END IF;
411: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute12 = OKC_API.G_MISS_CHAR ) THEN
412: l_okl_sif_ret_levels_v_rec.stream_interface_attribute12 := NULL;
405: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute10 = OKC_API.G_MISS_CHAR ) THEN
406: l_okl_sif_ret_levels_v_rec.stream_interface_attribute10 := NULL;
407: END IF;
408: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute11 = OKC_API.G_MISS_CHAR ) THEN
409: l_okl_sif_ret_levels_v_rec.stream_interface_attribute11 := NULL;
410: END IF;
411: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute12 = OKC_API.G_MISS_CHAR ) THEN
412: l_okl_sif_ret_levels_v_rec.stream_interface_attribute12 := NULL;
413: END IF;
407: END IF;
408: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute11 = OKC_API.G_MISS_CHAR ) THEN
409: l_okl_sif_ret_levels_v_rec.stream_interface_attribute11 := NULL;
410: END IF;
411: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute12 = OKC_API.G_MISS_CHAR ) THEN
412: l_okl_sif_ret_levels_v_rec.stream_interface_attribute12 := NULL;
413: END IF;
414: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute13 = OKC_API.G_MISS_CHAR ) THEN
415: l_okl_sif_ret_levels_v_rec.stream_interface_attribute13 := NULL;
408: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute11 = OKC_API.G_MISS_CHAR ) THEN
409: l_okl_sif_ret_levels_v_rec.stream_interface_attribute11 := NULL;
410: END IF;
411: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute12 = OKC_API.G_MISS_CHAR ) THEN
412: l_okl_sif_ret_levels_v_rec.stream_interface_attribute12 := NULL;
413: END IF;
414: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute13 = OKC_API.G_MISS_CHAR ) THEN
415: l_okl_sif_ret_levels_v_rec.stream_interface_attribute13 := NULL;
416: END IF;
410: END IF;
411: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute12 = OKC_API.G_MISS_CHAR ) THEN
412: l_okl_sif_ret_levels_v_rec.stream_interface_attribute12 := NULL;
413: END IF;
414: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute13 = OKC_API.G_MISS_CHAR ) THEN
415: l_okl_sif_ret_levels_v_rec.stream_interface_attribute13 := NULL;
416: END IF;
417: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute14 = OKC_API.G_MISS_CHAR ) THEN
418: l_okl_sif_ret_levels_v_rec.stream_interface_attribute14 := NULL;
411: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute12 = OKC_API.G_MISS_CHAR ) THEN
412: l_okl_sif_ret_levels_v_rec.stream_interface_attribute12 := NULL;
413: END IF;
414: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute13 = OKC_API.G_MISS_CHAR ) THEN
415: l_okl_sif_ret_levels_v_rec.stream_interface_attribute13 := NULL;
416: END IF;
417: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute14 = OKC_API.G_MISS_CHAR ) THEN
418: l_okl_sif_ret_levels_v_rec.stream_interface_attribute14 := NULL;
419: END IF;
413: END IF;
414: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute13 = OKC_API.G_MISS_CHAR ) THEN
415: l_okl_sif_ret_levels_v_rec.stream_interface_attribute13 := NULL;
416: END IF;
417: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute14 = OKC_API.G_MISS_CHAR ) THEN
418: l_okl_sif_ret_levels_v_rec.stream_interface_attribute14 := NULL;
419: END IF;
420: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute15 = OKC_API.G_MISS_CHAR ) THEN
421: l_okl_sif_ret_levels_v_rec.stream_interface_attribute15 := NULL;
414: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute13 = OKC_API.G_MISS_CHAR ) THEN
415: l_okl_sif_ret_levels_v_rec.stream_interface_attribute13 := NULL;
416: END IF;
417: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute14 = OKC_API.G_MISS_CHAR ) THEN
418: l_okl_sif_ret_levels_v_rec.stream_interface_attribute14 := NULL;
419: END IF;
420: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute15 = OKC_API.G_MISS_CHAR ) THEN
421: l_okl_sif_ret_levels_v_rec.stream_interface_attribute15 := NULL;
422: END IF;
416: END IF;
417: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute14 = OKC_API.G_MISS_CHAR ) THEN
418: l_okl_sif_ret_levels_v_rec.stream_interface_attribute14 := NULL;
419: END IF;
420: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute15 = OKC_API.G_MISS_CHAR ) THEN
421: l_okl_sif_ret_levels_v_rec.stream_interface_attribute15 := NULL;
422: END IF;
423: IF (l_okl_sif_ret_levels_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
424: l_okl_sif_ret_levels_v_rec.creation_date := NULL;
417: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute14 = OKC_API.G_MISS_CHAR ) THEN
418: l_okl_sif_ret_levels_v_rec.stream_interface_attribute14 := NULL;
419: END IF;
420: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute15 = OKC_API.G_MISS_CHAR ) THEN
421: l_okl_sif_ret_levels_v_rec.stream_interface_attribute15 := NULL;
422: END IF;
423: IF (l_okl_sif_ret_levels_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
424: l_okl_sif_ret_levels_v_rec.creation_date := NULL;
425: END IF;
419: END IF;
420: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute15 = OKC_API.G_MISS_CHAR ) THEN
421: l_okl_sif_ret_levels_v_rec.stream_interface_attribute15 := NULL;
422: END IF;
423: IF (l_okl_sif_ret_levels_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
424: l_okl_sif_ret_levels_v_rec.creation_date := NULL;
425: END IF;
426: IF (l_okl_sif_ret_levels_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
427: l_okl_sif_ret_levels_v_rec.created_by := NULL;
420: IF (l_okl_sif_ret_levels_v_rec.stream_interface_attribute15 = OKC_API.G_MISS_CHAR ) THEN
421: l_okl_sif_ret_levels_v_rec.stream_interface_attribute15 := NULL;
422: END IF;
423: IF (l_okl_sif_ret_levels_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
424: l_okl_sif_ret_levels_v_rec.creation_date := NULL;
425: END IF;
426: IF (l_okl_sif_ret_levels_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
427: l_okl_sif_ret_levels_v_rec.created_by := NULL;
428: END IF;
422: END IF;
423: IF (l_okl_sif_ret_levels_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
424: l_okl_sif_ret_levels_v_rec.creation_date := NULL;
425: END IF;
426: IF (l_okl_sif_ret_levels_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
427: l_okl_sif_ret_levels_v_rec.created_by := NULL;
428: END IF;
429: IF (l_okl_sif_ret_levels_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
430: l_okl_sif_ret_levels_v_rec.last_update_date := NULL;
423: IF (l_okl_sif_ret_levels_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
424: l_okl_sif_ret_levels_v_rec.creation_date := NULL;
425: END IF;
426: IF (l_okl_sif_ret_levels_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
427: l_okl_sif_ret_levels_v_rec.created_by := NULL;
428: END IF;
429: IF (l_okl_sif_ret_levels_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
430: l_okl_sif_ret_levels_v_rec.last_update_date := NULL;
431: END IF;
425: END IF;
426: IF (l_okl_sif_ret_levels_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
427: l_okl_sif_ret_levels_v_rec.created_by := NULL;
428: END IF;
429: IF (l_okl_sif_ret_levels_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
430: l_okl_sif_ret_levels_v_rec.last_update_date := NULL;
431: END IF;
432: IF (l_okl_sif_ret_levels_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
433: l_okl_sif_ret_levels_v_rec.last_updated_by := NULL;
426: IF (l_okl_sif_ret_levels_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
427: l_okl_sif_ret_levels_v_rec.created_by := NULL;
428: END IF;
429: IF (l_okl_sif_ret_levels_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
430: l_okl_sif_ret_levels_v_rec.last_update_date := NULL;
431: END IF;
432: IF (l_okl_sif_ret_levels_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
433: l_okl_sif_ret_levels_v_rec.last_updated_by := NULL;
434: END IF;
428: END IF;
429: IF (l_okl_sif_ret_levels_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
430: l_okl_sif_ret_levels_v_rec.last_update_date := NULL;
431: END IF;
432: IF (l_okl_sif_ret_levels_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
433: l_okl_sif_ret_levels_v_rec.last_updated_by := NULL;
434: END IF;
435: IF (l_okl_sif_ret_levels_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
436: l_okl_sif_ret_levels_v_rec.last_update_login := NULL;
429: IF (l_okl_sif_ret_levels_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
430: l_okl_sif_ret_levels_v_rec.last_update_date := NULL;
431: END IF;
432: IF (l_okl_sif_ret_levels_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
433: l_okl_sif_ret_levels_v_rec.last_updated_by := NULL;
434: END IF;
435: IF (l_okl_sif_ret_levels_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
436: l_okl_sif_ret_levels_v_rec.last_update_login := NULL;
437: END IF;
431: END IF;
432: IF (l_okl_sif_ret_levels_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
433: l_okl_sif_ret_levels_v_rec.last_updated_by := NULL;
434: END IF;
435: IF (l_okl_sif_ret_levels_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
436: l_okl_sif_ret_levels_v_rec.last_update_login := NULL;
437: END IF;
438: --smahapat 10/12/03
439: IF (l_okl_sif_ret_levels_v_rec.rate = OKC_API.G_MISS_NUM ) THEN
432: IF (l_okl_sif_ret_levels_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
433: l_okl_sif_ret_levels_v_rec.last_updated_by := NULL;
434: END IF;
435: IF (l_okl_sif_ret_levels_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
436: l_okl_sif_ret_levels_v_rec.last_update_login := NULL;
437: END IF;
438: --smahapat 10/12/03
439: IF (l_okl_sif_ret_levels_v_rec.rate = OKC_API.G_MISS_NUM ) THEN
440: l_okl_sif_ret_levels_v_rec.rate := NULL;
435: IF (l_okl_sif_ret_levels_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
436: l_okl_sif_ret_levels_v_rec.last_update_login := NULL;
437: END IF;
438: --smahapat 10/12/03
439: IF (l_okl_sif_ret_levels_v_rec.rate = OKC_API.G_MISS_NUM ) THEN
440: l_okl_sif_ret_levels_v_rec.rate := NULL;
441: END IF;
442: RETURN(l_okl_sif_ret_levels_v_rec);
443: END null_out_defaults;
436: l_okl_sif_ret_levels_v_rec.last_update_login := NULL;
437: END IF;
438: --smahapat 10/12/03
439: IF (l_okl_sif_ret_levels_v_rec.rate = OKC_API.G_MISS_NUM ) THEN
440: l_okl_sif_ret_levels_v_rec.rate := NULL;
441: END IF;
442: RETURN(l_okl_sif_ret_levels_v_rec);
443: END null_out_defaults;
444: ---------------------------------
438: --smahapat 10/12/03
439: IF (l_okl_sif_ret_levels_v_rec.rate = OKC_API.G_MISS_NUM ) THEN
440: l_okl_sif_ret_levels_v_rec.rate := NULL;
441: END IF;
442: RETURN(l_okl_sif_ret_levels_v_rec);
443: END null_out_defaults;
444: ---------------------------------
445: -- Validate_Attributes for: ID --
446: ---------------------------------
576: ---------------------------------------------------------------------------
577: -- FUNCTION Validate_Attributes
578: ---------------------------------------------------------------------------
579: --------------------------------------------------
580: -- Validate_Attributes for:OKL_SIF_RET_LEVELS_V --
581: --------------------------------------------------
582: FUNCTION Validate_Attributes (
583: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
584: ) RETURN VARCHAR2 IS
579: --------------------------------------------------
580: -- Validate_Attributes for:OKL_SIF_RET_LEVELS_V --
581: --------------------------------------------------
582: FUNCTION Validate_Attributes (
583: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
584: ) RETURN VARCHAR2 IS
585: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
586: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
587: BEGIN
590: -----------------------------
591: -- ***
592: -- id
593: -- ***
594: validate_id(x_return_status, p_okl_sif_ret_levels_v_rec.id);
595: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
596: -- smahapat added 05/14
597: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
598: -- need to exit
607:
608: -- ***
609: -- sir_id
610: -- ***
611: validate_sir_id(x_return_status, p_okl_sif_ret_levels_v_rec.sir_id);
612: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
613: -- smahapat added 05/14
614: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
615: -- need to exit
624:
625: -- ***
626: -- index_number
627: -- ***
628: validate_index_number(x_return_status, p_okl_sif_ret_levels_v_rec.index_number);
629: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
630: -- smahapat added 05/14
631: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
632: -- need to exit
641:
642: -- ***
643: -- object_version_number
644: -- ***
645: validate_object_version_number(x_return_status, p_okl_sif_ret_levels_v_rec.object_version_number);
646: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
647: -- smahapat added 05/14
648: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
649: -- need to exit
673: ---------------------------------------------------------------------------
674: -- PROCEDURE Validate_Record
675: ---------------------------------------------------------------------------
676: ----------------------------------------------
677: -- Validate Record for:OKL_SIF_RET_LEVELS_V --
678: ----------------------------------------------
679: FUNCTION Validate_Record (
680: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
681: p_db_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
676: ----------------------------------------------
677: -- Validate Record for:OKL_SIF_RET_LEVELS_V --
678: ----------------------------------------------
679: FUNCTION Validate_Record (
680: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
681: p_db_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
682: ) RETURN VARCHAR2 IS
683: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
684: ------------------------------------
677: -- Validate Record for:OKL_SIF_RET_LEVELS_V --
678: ----------------------------------------------
679: FUNCTION Validate_Record (
680: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
681: p_db_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
682: ) RETURN VARCHAR2 IS
683: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
684: ------------------------------------
685: -- FUNCTION validate_foreign_keys --
684: ------------------------------------
685: -- FUNCTION validate_foreign_keys --
686: ------------------------------------
687: FUNCTION validate_foreign_keys (
688: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
689: p_db_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
690: ) RETURN VARCHAR2 IS
691: item_not_found_error EXCEPTION;
692: CURSOR okl_sifv_sirv_fk_csr (p_id IN NUMBER) IS
685: -- FUNCTION validate_foreign_keys --
686: ------------------------------------
687: FUNCTION validate_foreign_keys (
688: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
689: p_db_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
690: ) RETURN VARCHAR2 IS
691: item_not_found_error EXCEPTION;
692: CURSOR okl_sifv_sirv_fk_csr (p_id IN NUMBER) IS
693: SELECT 'x'
697:
698: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
699: l_row_notfound BOOLEAN := TRUE;
700: BEGIN
701: IF ((p_okl_sif_ret_levels_v_rec.SIR_ID IS NOT NULL)
702: AND
703: (p_okl_sif_ret_levels_v_rec.SIR_ID <> p_db_okl_sif_ret_levels_v_rec.SIR_ID))
704: THEN
705: OPEN okl_sifv_sirv_fk_csr (p_okl_sif_ret_levels_v_rec.SIR_ID);
699: l_row_notfound BOOLEAN := TRUE;
700: BEGIN
701: IF ((p_okl_sif_ret_levels_v_rec.SIR_ID IS NOT NULL)
702: AND
703: (p_okl_sif_ret_levels_v_rec.SIR_ID <> p_db_okl_sif_ret_levels_v_rec.SIR_ID))
704: THEN
705: OPEN okl_sifv_sirv_fk_csr (p_okl_sif_ret_levels_v_rec.SIR_ID);
706: FETCH okl_sifv_sirv_fk_csr INTO l_okl_sifv_sirv_fk;
707: l_row_notfound := okl_sifv_sirv_fk_csr%NOTFOUND;
701: IF ((p_okl_sif_ret_levels_v_rec.SIR_ID IS NOT NULL)
702: AND
703: (p_okl_sif_ret_levels_v_rec.SIR_ID <> p_db_okl_sif_ret_levels_v_rec.SIR_ID))
704: THEN
705: OPEN okl_sifv_sirv_fk_csr (p_okl_sif_ret_levels_v_rec.SIR_ID);
706: FETCH okl_sifv_sirv_fk_csr INTO l_okl_sifv_sirv_fk;
707: l_row_notfound := okl_sifv_sirv_fk_csr%NOTFOUND;
708: CLOSE okl_sifv_sirv_fk_csr;
709: IF (l_row_notfound) THEN
717: l_return_status := OKC_API.G_RET_STS_ERROR;
718: RETURN (l_return_status);
719: END validate_foreign_keys;
720: BEGIN
721: l_return_status := validate_foreign_keys(p_okl_sif_ret_levels_v_rec, p_db_okl_sif_ret_levels_v_rec);
722: RETURN (l_return_status);
723: END Validate_Record;
724: FUNCTION Validate_Record (
725: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
721: l_return_status := validate_foreign_keys(p_okl_sif_ret_levels_v_rec, p_db_okl_sif_ret_levels_v_rec);
722: RETURN (l_return_status);
723: END Validate_Record;
724: FUNCTION Validate_Record (
725: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
726: ) RETURN VARCHAR2 IS
727: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
728: l_db_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := get_rec(p_okl_sif_ret_levels_v_rec);
729: BEGIN
724: FUNCTION Validate_Record (
725: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
726: ) RETURN VARCHAR2 IS
727: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
728: l_db_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := get_rec(p_okl_sif_ret_levels_v_rec);
729: BEGIN
730: l_return_status := Validate_Record(p_okl_sif_ret_levels_v_rec => p_okl_sif_ret_levels_v_rec,
731: p_db_okl_sif_ret_levels_v_rec => l_db_okl_sif_ret_levels_v_rec);
732: RETURN (l_return_status);
726: ) RETURN VARCHAR2 IS
727: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
728: l_db_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := get_rec(p_okl_sif_ret_levels_v_rec);
729: BEGIN
730: l_return_status := Validate_Record(p_okl_sif_ret_levels_v_rec => p_okl_sif_ret_levels_v_rec,
731: p_db_okl_sif_ret_levels_v_rec => l_db_okl_sif_ret_levels_v_rec);
732: RETURN (l_return_status);
733: END Validate_Record;
734:
727: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
728: l_db_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := get_rec(p_okl_sif_ret_levels_v_rec);
729: BEGIN
730: l_return_status := Validate_Record(p_okl_sif_ret_levels_v_rec => p_okl_sif_ret_levels_v_rec,
731: p_db_okl_sif_ret_levels_v_rec => l_db_okl_sif_ret_levels_v_rec);
732: RETURN (l_return_status);
733: END Validate_Record;
734:
735: ---------------------------------------------------------------------------
735: ---------------------------------------------------------------------------
736: -- PROCEDURE Migrate
737: ---------------------------------------------------------------------------
738: PROCEDURE migrate (
739: p_from IN okl_sif_ret_levels_v_rec_type,
740: p_to IN OUT NOCOPY srl_rec_type
741: ) IS
742: BEGIN
743: p_to.id := p_from.id;
776: p_to.rate := p_from.rate; --smahapat 10/12/03
777: END migrate;
778: PROCEDURE migrate (
779: p_from IN srl_rec_type,
780: p_to IN OUT NOCOPY okl_sif_ret_levels_v_rec_type
781: ) IS
782: BEGIN
783: p_to.id := p_from.id;
784: p_to.level_index_number := p_from.level_index_number;
818: ---------------------------------------------------------------------------
819: -- PROCEDURE validate_row
820: ---------------------------------------------------------------------------
821: -------------------------------------------
822: -- validate_row for:OKL_SIF_RET_LEVELS_V --
823: -------------------------------------------
824: PROCEDURE validate_row(
825: p_api_version IN NUMBER,
826: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
826: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
827: x_return_status OUT NOCOPY VARCHAR2,
828: x_msg_count OUT NOCOPY NUMBER,
829: x_msg_data OUT NOCOPY VARCHAR2,
830: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type) IS
831:
832: l_api_version CONSTANT NUMBER := 1;
833: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
834: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
831:
832: l_api_version CONSTANT NUMBER := 1;
833: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
834: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
835: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
836: l_srl_rec srl_rec_type;
837: l_srl_rec srl_rec_type;
838: BEGIN
839: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
848: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
849: RAISE OKC_API.G_EXCEPTION_ERROR;
850: END IF;
851: --- Validate all non-missing attributes (Item Level Validation)
852: l_return_status := Validate_Attributes(l_okl_sif_ret_levels_v_rec);
853: --- If any errors happen abort API
854: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
855: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
856: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
855: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
856: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
857: RAISE OKC_API.G_EXCEPTION_ERROR;
858: END IF;
859: l_return_status := Validate_Record(l_okl_sif_ret_levels_v_rec);
860: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
861: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
862: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
863: RAISE OKC_API.G_EXCEPTION_ERROR;
895: '_PVT'
896: );
897: END validate_row;
898: ------------------------------------------------------
899: -- PL/SQL TBL validate_row for:OKL_SIF_RET_LEVELS_V --
900: ------------------------------------------------------
901: PROCEDURE validate_row(
902: p_api_version IN NUMBER,
903: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
903: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
904: x_return_status OUT NOCOPY VARCHAR2,
905: x_msg_count OUT NOCOPY NUMBER,
906: x_msg_data OUT NOCOPY VARCHAR2,
907: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
908: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
909:
910: l_api_version CONSTANT NUMBER := 1;
911: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_validate_row';
912: i NUMBER := 0;
913: BEGIN
914: OKC_API.init_msg_list(p_init_msg_list);
915: -- Make sure PL/SQL table has records in it before passing
916: IF (p_okl_sif_ret_levels_v_tbl.COUNT > 0) THEN
917: i := p_okl_sif_ret_levels_v_tbl.FIRST;
918: LOOP
919: DECLARE
920: l_error_rec OKC_API.ERROR_REC_TYPE;
913: BEGIN
914: OKC_API.init_msg_list(p_init_msg_list);
915: -- Make sure PL/SQL table has records in it before passing
916: IF (p_okl_sif_ret_levels_v_tbl.COUNT > 0) THEN
917: i := p_okl_sif_ret_levels_v_tbl.FIRST;
918: LOOP
919: DECLARE
920: l_error_rec OKC_API.ERROR_REC_TYPE;
921: BEGIN
927: p_init_msg_list => OKC_API.G_FALSE,
928: x_return_status => l_error_rec.error_type,
929: x_msg_count => l_error_rec.msg_count,
930: x_msg_data => l_error_rec.msg_data,
931: p_okl_sif_ret_levels_v_rec => p_okl_sif_ret_levels_v_tbl(i));
932: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
933: l_error_rec.SQLCODE := SQLCODE;
934: load_error_tbl(l_error_rec, px_error_tbl);
935: ELSE
949: l_error_rec.error_type := 'OTHERS';
950: l_error_rec.SQLCODE := SQLCODE;
951: load_error_tbl(l_error_rec, px_error_tbl);
952: END;
953: EXIT WHEN (i = p_okl_sif_ret_levels_v_tbl.LAST);
954: i := p_okl_sif_ret_levels_v_tbl.NEXT(i);
955: END LOOP;
956: END IF;
957: -- Loop through the error_tbl to find the error with the highest severity
950: l_error_rec.SQLCODE := SQLCODE;
951: load_error_tbl(l_error_rec, px_error_tbl);
952: END;
953: EXIT WHEN (i = p_okl_sif_ret_levels_v_tbl.LAST);
954: i := p_okl_sif_ret_levels_v_tbl.NEXT(i);
955: END LOOP;
956: END IF;
957: -- Loop through the error_tbl to find the error with the highest severity
958: -- and return it.
991: );
992: END validate_row;
993:
994: ------------------------------------------------------
995: -- PL/SQL TBL validate_row for:OKL_SIF_RET_LEVELS_V --
996: ------------------------------------------------------
997: PROCEDURE validate_row(
998: p_api_version IN NUMBER,
999: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
999: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1000: x_return_status OUT NOCOPY VARCHAR2,
1001: x_msg_count OUT NOCOPY NUMBER,
1002: x_msg_data OUT NOCOPY VARCHAR2,
1003: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type) IS
1004:
1005: l_api_version CONSTANT NUMBER := 1;
1006: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
1007: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1008: l_error_tbl OKC_API.ERROR_TBL_TYPE;
1009: BEGIN
1010: OKC_API.init_msg_list(p_init_msg_list);
1011: -- Make sure PL/SQL table has records in it before passing
1012: IF (p_okl_sif_ret_levels_v_tbl.COUNT > 0) THEN
1013: validate_row (
1014: p_api_version => p_api_version,
1015: p_init_msg_list => OKC_API.G_FALSE,
1016: x_return_status => x_return_status,
1015: p_init_msg_list => OKC_API.G_FALSE,
1016: x_return_status => x_return_status,
1017: x_msg_count => x_msg_count,
1018: x_msg_data => x_msg_data,
1019: p_okl_sif_ret_levels_v_tbl => p_okl_sif_ret_levels_v_tbl,
1020: px_error_tbl => l_error_tbl);
1021: END IF;
1022: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1023: EXCEPTION
1210: '_PVT'
1211: );
1212: END insert_row;
1213: ------------------------------------------
1214: -- insert_row for :OKL_SIF_RET_LEVELS_V --
1215: ------------------------------------------
1216: PROCEDURE insert_row(
1217: p_api_version IN NUMBER,
1218: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1218: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1219: x_return_status OUT NOCOPY VARCHAR2,
1220: x_msg_count OUT NOCOPY NUMBER,
1221: x_msg_data OUT NOCOPY VARCHAR2,
1222: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
1223: x_okl_sif_ret_levels_v_rec OUT NOCOPY okl_sif_ret_levels_v_rec_type) IS
1224:
1225: l_api_version CONSTANT NUMBER := 1;
1226: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1219: x_return_status OUT NOCOPY VARCHAR2,
1220: x_msg_count OUT NOCOPY NUMBER,
1221: x_msg_data OUT NOCOPY VARCHAR2,
1222: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
1223: x_okl_sif_ret_levels_v_rec OUT NOCOPY okl_sif_ret_levels_v_rec_type) IS
1224:
1225: l_api_version CONSTANT NUMBER := 1;
1226: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1227: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1224:
1225: l_api_version CONSTANT NUMBER := 1;
1226: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1227: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1228: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
1229: l_def_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type;
1230: l_srl_rec srl_rec_type;
1231: lx_srl_rec srl_rec_type;
1232: -------------------------------
1225: l_api_version CONSTANT NUMBER := 1;
1226: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1227: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1228: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
1229: l_def_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type;
1230: l_srl_rec srl_rec_type;
1231: lx_srl_rec srl_rec_type;
1232: -------------------------------
1233: -- FUNCTION fill_who_columns --
1232: -------------------------------
1233: -- FUNCTION fill_who_columns --
1234: -------------------------------
1235: FUNCTION fill_who_columns (
1236: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
1237: ) RETURN okl_sif_ret_levels_v_rec_type IS
1238: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
1239: BEGIN
1240: l_okl_sif_ret_levels_v_rec.CREATION_DATE := SYSDATE;
1233: -- FUNCTION fill_who_columns --
1234: -------------------------------
1235: FUNCTION fill_who_columns (
1236: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
1237: ) RETURN okl_sif_ret_levels_v_rec_type IS
1238: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
1239: BEGIN
1240: l_okl_sif_ret_levels_v_rec.CREATION_DATE := SYSDATE;
1241: l_okl_sif_ret_levels_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1234: -------------------------------
1235: FUNCTION fill_who_columns (
1236: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
1237: ) RETURN okl_sif_ret_levels_v_rec_type IS
1238: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
1239: BEGIN
1240: l_okl_sif_ret_levels_v_rec.CREATION_DATE := SYSDATE;
1241: l_okl_sif_ret_levels_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1242: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_DATE := l_okl_sif_ret_levels_v_rec.CREATION_DATE;
1236: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
1237: ) RETURN okl_sif_ret_levels_v_rec_type IS
1238: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
1239: BEGIN
1240: l_okl_sif_ret_levels_v_rec.CREATION_DATE := SYSDATE;
1241: l_okl_sif_ret_levels_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1242: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_DATE := l_okl_sif_ret_levels_v_rec.CREATION_DATE;
1243: l_okl_sif_ret_levels_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1244: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1237: ) RETURN okl_sif_ret_levels_v_rec_type IS
1238: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
1239: BEGIN
1240: l_okl_sif_ret_levels_v_rec.CREATION_DATE := SYSDATE;
1241: l_okl_sif_ret_levels_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1242: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_DATE := l_okl_sif_ret_levels_v_rec.CREATION_DATE;
1243: l_okl_sif_ret_levels_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1244: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1245: RETURN(l_okl_sif_ret_levels_v_rec);
1238: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
1239: BEGIN
1240: l_okl_sif_ret_levels_v_rec.CREATION_DATE := SYSDATE;
1241: l_okl_sif_ret_levels_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1242: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_DATE := l_okl_sif_ret_levels_v_rec.CREATION_DATE;
1243: l_okl_sif_ret_levels_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1244: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1245: RETURN(l_okl_sif_ret_levels_v_rec);
1246: END fill_who_columns;
1239: BEGIN
1240: l_okl_sif_ret_levels_v_rec.CREATION_DATE := SYSDATE;
1241: l_okl_sif_ret_levels_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1242: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_DATE := l_okl_sif_ret_levels_v_rec.CREATION_DATE;
1243: l_okl_sif_ret_levels_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1244: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1245: RETURN(l_okl_sif_ret_levels_v_rec);
1246: END fill_who_columns;
1247: ---------------------------------------------
1240: l_okl_sif_ret_levels_v_rec.CREATION_DATE := SYSDATE;
1241: l_okl_sif_ret_levels_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1242: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_DATE := l_okl_sif_ret_levels_v_rec.CREATION_DATE;
1243: l_okl_sif_ret_levels_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1244: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1245: RETURN(l_okl_sif_ret_levels_v_rec);
1246: END fill_who_columns;
1247: ---------------------------------------------
1248: -- Set_Attributes for:OKL_SIF_RET_LEVELS_V --
1241: l_okl_sif_ret_levels_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1242: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_DATE := l_okl_sif_ret_levels_v_rec.CREATION_DATE;
1243: l_okl_sif_ret_levels_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1244: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1245: RETURN(l_okl_sif_ret_levels_v_rec);
1246: END fill_who_columns;
1247: ---------------------------------------------
1248: -- Set_Attributes for:OKL_SIF_RET_LEVELS_V --
1249: ---------------------------------------------
1244: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1245: RETURN(l_okl_sif_ret_levels_v_rec);
1246: END fill_who_columns;
1247: ---------------------------------------------
1248: -- Set_Attributes for:OKL_SIF_RET_LEVELS_V --
1249: ---------------------------------------------
1250: FUNCTION Set_Attributes (
1251: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
1252: x_okl_sif_ret_levels_v_rec OUT NOCOPY okl_sif_ret_levels_v_rec_type
1247: ---------------------------------------------
1248: -- Set_Attributes for:OKL_SIF_RET_LEVELS_V --
1249: ---------------------------------------------
1250: FUNCTION Set_Attributes (
1251: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
1252: x_okl_sif_ret_levels_v_rec OUT NOCOPY okl_sif_ret_levels_v_rec_type
1253: ) RETURN VARCHAR2 IS
1254: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1255: BEGIN
1248: -- Set_Attributes for:OKL_SIF_RET_LEVELS_V --
1249: ---------------------------------------------
1250: FUNCTION Set_Attributes (
1251: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
1252: x_okl_sif_ret_levels_v_rec OUT NOCOPY okl_sif_ret_levels_v_rec_type
1253: ) RETURN VARCHAR2 IS
1254: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1255: BEGIN
1256: x_okl_sif_ret_levels_v_rec := p_okl_sif_ret_levels_v_rec;
1252: x_okl_sif_ret_levels_v_rec OUT NOCOPY okl_sif_ret_levels_v_rec_type
1253: ) RETURN VARCHAR2 IS
1254: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1255: BEGIN
1256: x_okl_sif_ret_levels_v_rec := p_okl_sif_ret_levels_v_rec;
1257: x_okl_sif_ret_levels_v_rec.OBJECT_VERSION_NUMBER := 1;
1258: RETURN(l_return_status);
1259: END Set_Attributes;
1260: BEGIN
1253: ) RETURN VARCHAR2 IS
1254: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1255: BEGIN
1256: x_okl_sif_ret_levels_v_rec := p_okl_sif_ret_levels_v_rec;
1257: x_okl_sif_ret_levels_v_rec.OBJECT_VERSION_NUMBER := 1;
1258: RETURN(l_return_status);
1259: END Set_Attributes;
1260: BEGIN
1261: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1269: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1270: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1271: RAISE OKC_API.G_EXCEPTION_ERROR;
1272: END IF;
1273: l_okl_sif_ret_levels_v_rec := null_out_defaults(p_okl_sif_ret_levels_v_rec);
1274: -- Set primary key value
1275: l_okl_sif_ret_levels_v_rec.ID := get_seq_id;
1276: -- Setting item attributes
1277: l_return_Status := Set_Attributes(
1271: RAISE OKC_API.G_EXCEPTION_ERROR;
1272: END IF;
1273: l_okl_sif_ret_levels_v_rec := null_out_defaults(p_okl_sif_ret_levels_v_rec);
1274: -- Set primary key value
1275: l_okl_sif_ret_levels_v_rec.ID := get_seq_id;
1276: -- Setting item attributes
1277: l_return_Status := Set_Attributes(
1278: l_okl_sif_ret_levels_v_rec, -- IN
1279: l_def_okl_sif_ret_levels_v_rec); -- OUT
1274: -- Set primary key value
1275: l_okl_sif_ret_levels_v_rec.ID := get_seq_id;
1276: -- Setting item attributes
1277: l_return_Status := Set_Attributes(
1278: l_okl_sif_ret_levels_v_rec, -- IN
1279: l_def_okl_sif_ret_levels_v_rec); -- OUT
1280: --- If any errors happen abort API
1281: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1282: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1275: l_okl_sif_ret_levels_v_rec.ID := get_seq_id;
1276: -- Setting item attributes
1277: l_return_Status := Set_Attributes(
1278: l_okl_sif_ret_levels_v_rec, -- IN
1279: l_def_okl_sif_ret_levels_v_rec); -- OUT
1280: --- If any errors happen abort API
1281: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1282: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1283: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1282: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1283: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1284: RAISE OKC_API.G_EXCEPTION_ERROR;
1285: END IF;
1286: l_def_okl_sif_ret_levels_v_rec := fill_who_columns(l_def_okl_sif_ret_levels_v_rec);
1287: --- Validate all non-missing attributes (Item Level Validation)
1288: l_return_status := Validate_Attributes(l_def_okl_sif_ret_levels_v_rec);
1289: --- If any errors happen abort API
1290: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1284: RAISE OKC_API.G_EXCEPTION_ERROR;
1285: END IF;
1286: l_def_okl_sif_ret_levels_v_rec := fill_who_columns(l_def_okl_sif_ret_levels_v_rec);
1287: --- Validate all non-missing attributes (Item Level Validation)
1288: l_return_status := Validate_Attributes(l_def_okl_sif_ret_levels_v_rec);
1289: --- If any errors happen abort API
1290: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1291: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1292: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1291: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1292: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1293: RAISE OKC_API.G_EXCEPTION_ERROR;
1294: END IF;
1295: l_return_status := Validate_Record(l_def_okl_sif_ret_levels_v_rec);
1296: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1297: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1298: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1299: RAISE OKC_API.G_EXCEPTION_ERROR;
1300: END IF;
1301: -----------------------------------------
1302: -- Move VIEW record to "Child" records --
1303: -----------------------------------------
1304: migrate(l_def_okl_sif_ret_levels_v_rec, l_srl_rec);
1305: -----------------------------------------------
1306: -- Call the INSERT_ROW for each child record --
1307: -----------------------------------------------
1308: insert_row(
1317: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1318: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1319: RAISE OKC_API.G_EXCEPTION_ERROR;
1320: END IF;
1321: migrate(lx_srl_rec, l_def_okl_sif_ret_levels_v_rec);
1322: -- Set OUT values
1323: x_okl_sif_ret_levels_v_rec := l_def_okl_sif_ret_levels_v_rec;
1324: x_return_status := l_return_status;
1325: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1319: RAISE OKC_API.G_EXCEPTION_ERROR;
1320: END IF;
1321: migrate(lx_srl_rec, l_def_okl_sif_ret_levels_v_rec);
1322: -- Set OUT values
1323: x_okl_sif_ret_levels_v_rec := l_def_okl_sif_ret_levels_v_rec;
1324: x_return_status := l_return_status;
1325: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1326: EXCEPTION
1327: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1355: '_PVT'
1356: );
1357: END insert_row;
1358: --------------------------------------------------------
1359: -- PL/SQL TBL insert_row for:OKL_SIF_RET_LEVELS_V_TBL --
1360: --------------------------------------------------------
1361: PROCEDURE insert_row(
1362: p_api_version IN NUMBER,
1363: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1363: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1364: x_return_status OUT NOCOPY VARCHAR2,
1365: x_msg_count OUT NOCOPY NUMBER,
1366: x_msg_data OUT NOCOPY VARCHAR2,
1367: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
1368: x_okl_sif_ret_levels_v_tbl OUT NOCOPY okl_sif_ret_levels_v_tbl_type,
1369: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
1370:
1371: l_api_version CONSTANT NUMBER := 1;
1364: x_return_status OUT NOCOPY VARCHAR2,
1365: x_msg_count OUT NOCOPY NUMBER,
1366: x_msg_data OUT NOCOPY VARCHAR2,
1367: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
1368: x_okl_sif_ret_levels_v_tbl OUT NOCOPY okl_sif_ret_levels_v_tbl_type,
1369: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
1370:
1371: l_api_version CONSTANT NUMBER := 1;
1372: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
1373: i NUMBER := 0;
1374: BEGIN
1375: OKC_API.init_msg_list(p_init_msg_list);
1376: -- Make sure PL/SQL table has records in it before passing
1377: IF (p_okl_sif_ret_levels_v_tbl.COUNT > 0) THEN
1378: i := p_okl_sif_ret_levels_v_tbl.FIRST;
1379: LOOP
1380: DECLARE
1381: l_error_rec OKC_API.ERROR_REC_TYPE;
1374: BEGIN
1375: OKC_API.init_msg_list(p_init_msg_list);
1376: -- Make sure PL/SQL table has records in it before passing
1377: IF (p_okl_sif_ret_levels_v_tbl.COUNT > 0) THEN
1378: i := p_okl_sif_ret_levels_v_tbl.FIRST;
1379: LOOP
1380: DECLARE
1381: l_error_rec OKC_API.ERROR_REC_TYPE;
1382: BEGIN
1388: p_init_msg_list => OKC_API.G_FALSE,
1389: x_return_status => l_error_rec.error_type,
1390: x_msg_count => l_error_rec.msg_count,
1391: x_msg_data => l_error_rec.msg_data,
1392: p_okl_sif_ret_levels_v_rec => p_okl_sif_ret_levels_v_tbl(i),
1393: x_okl_sif_ret_levels_v_rec => x_okl_sif_ret_levels_v_tbl(i));
1394: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
1395: l_error_rec.SQLCODE := SQLCODE;
1396: load_error_tbl(l_error_rec, px_error_tbl);
1389: x_return_status => l_error_rec.error_type,
1390: x_msg_count => l_error_rec.msg_count,
1391: x_msg_data => l_error_rec.msg_data,
1392: p_okl_sif_ret_levels_v_rec => p_okl_sif_ret_levels_v_tbl(i),
1393: x_okl_sif_ret_levels_v_rec => x_okl_sif_ret_levels_v_tbl(i));
1394: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
1395: l_error_rec.SQLCODE := SQLCODE;
1396: load_error_tbl(l_error_rec, px_error_tbl);
1397: ELSE
1411: l_error_rec.error_type := 'OTHERS';
1412: l_error_rec.SQLCODE := SQLCODE;
1413: load_error_tbl(l_error_rec, px_error_tbl);
1414: END;
1415: EXIT WHEN (i = p_okl_sif_ret_levels_v_tbl.LAST);
1416: i := p_okl_sif_ret_levels_v_tbl.NEXT(i);
1417: END LOOP;
1418: END IF;
1419: -- Loop through the error_tbl to find the error with the highest severity
1412: l_error_rec.SQLCODE := SQLCODE;
1413: load_error_tbl(l_error_rec, px_error_tbl);
1414: END;
1415: EXIT WHEN (i = p_okl_sif_ret_levels_v_tbl.LAST);
1416: i := p_okl_sif_ret_levels_v_tbl.NEXT(i);
1417: END LOOP;
1418: END IF;
1419: -- Loop through the error_tbl to find the error with the highest severity
1420: -- and return it.
1453: );
1454: END insert_row;
1455:
1456: --------------------------------------------------------
1457: -- PL/SQL TBL insert_row for:OKL_SIF_RET_LEVELS_V_TBL --
1458: --------------------------------------------------------
1459: PROCEDURE insert_row(
1460: p_api_version IN NUMBER,
1461: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1461: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1462: x_return_status OUT NOCOPY VARCHAR2,
1463: x_msg_count OUT NOCOPY NUMBER,
1464: x_msg_data OUT NOCOPY VARCHAR2,
1465: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
1466: x_okl_sif_ret_levels_v_tbl OUT NOCOPY okl_sif_ret_levels_v_tbl_type) IS
1467:
1468: l_api_version CONSTANT NUMBER := 1;
1469: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1462: x_return_status OUT NOCOPY VARCHAR2,
1463: x_msg_count OUT NOCOPY NUMBER,
1464: x_msg_data OUT NOCOPY VARCHAR2,
1465: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
1466: x_okl_sif_ret_levels_v_tbl OUT NOCOPY okl_sif_ret_levels_v_tbl_type) IS
1467:
1468: l_api_version CONSTANT NUMBER := 1;
1469: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1470: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1471: l_error_tbl OKC_API.ERROR_TBL_TYPE;
1472: BEGIN
1473: OKC_API.init_msg_list(p_init_msg_list);
1474: -- Make sure PL/SQL table has records in it before passing
1475: IF (p_okl_sif_ret_levels_v_tbl.COUNT > 0) THEN
1476: insert_row (
1477: p_api_version => p_api_version,
1478: p_init_msg_list => OKC_API.G_FALSE,
1479: x_return_status => x_return_status,
1478: p_init_msg_list => OKC_API.G_FALSE,
1479: x_return_status => x_return_status,
1480: x_msg_count => x_msg_count,
1481: x_msg_data => x_msg_data,
1482: p_okl_sif_ret_levels_v_tbl => p_okl_sif_ret_levels_v_tbl,
1483: x_okl_sif_ret_levels_v_tbl => x_okl_sif_ret_levels_v_tbl,
1484: px_error_tbl => l_error_tbl);
1485: END IF;
1486: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1479: x_return_status => x_return_status,
1480: x_msg_count => x_msg_count,
1481: x_msg_data => x_msg_data,
1482: p_okl_sif_ret_levels_v_tbl => p_okl_sif_ret_levels_v_tbl,
1483: x_okl_sif_ret_levels_v_tbl => x_okl_sif_ret_levels_v_tbl,
1484: px_error_tbl => l_error_tbl);
1485: END IF;
1486: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1487: EXCEPTION
1627: '_PVT'
1628: );
1629: END lock_row;
1630: ----------------------------------------
1631: -- lock_row for: OKL_SIF_RET_LEVELS_V --
1632: ----------------------------------------
1633: PROCEDURE lock_row(
1634: p_api_version IN NUMBER,
1635: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1635: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1636: x_return_status OUT NOCOPY VARCHAR2,
1637: x_msg_count OUT NOCOPY NUMBER,
1638: x_msg_data OUT NOCOPY VARCHAR2,
1639: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type) IS
1640:
1641: l_api_version CONSTANT NUMBER := 1;
1642: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1643: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1657: END IF;
1658: -----------------------------------------
1659: -- Move VIEW record to "Child" records --
1660: -----------------------------------------
1661: migrate(p_okl_sif_ret_levels_v_rec, l_srl_rec);
1662: ---------------------------------------------
1663: -- Call the LOCK_ROW for each child record --
1664: ---------------------------------------------
1665: lock_row(
1708: '_PVT'
1709: );
1710: END lock_row;
1711: ------------------------------------------------------
1712: -- PL/SQL TBL lock_row for:OKL_SIF_RET_LEVELS_V_TBL --
1713: ------------------------------------------------------
1714: PROCEDURE lock_row(
1715: p_api_version IN NUMBER,
1716: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1716: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1717: x_return_status OUT NOCOPY VARCHAR2,
1718: x_msg_count OUT NOCOPY NUMBER,
1719: x_msg_data OUT NOCOPY VARCHAR2,
1720: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
1721: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
1722:
1723: l_api_version CONSTANT NUMBER := 1;
1724: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_lock_row';
1725: i NUMBER := 0;
1726: BEGIN
1727: OKC_API.init_msg_list(p_init_msg_list);
1728: -- Make sure PL/SQL table has recrods in it before passing
1729: IF (p_okl_sif_ret_levels_v_tbl.COUNT > 0) THEN
1730: i := p_okl_sif_ret_levels_v_tbl.FIRST;
1731: LOOP
1732: DECLARE
1733: l_error_rec OKC_API.ERROR_REC_TYPE;
1726: BEGIN
1727: OKC_API.init_msg_list(p_init_msg_list);
1728: -- Make sure PL/SQL table has recrods in it before passing
1729: IF (p_okl_sif_ret_levels_v_tbl.COUNT > 0) THEN
1730: i := p_okl_sif_ret_levels_v_tbl.FIRST;
1731: LOOP
1732: DECLARE
1733: l_error_rec OKC_API.ERROR_REC_TYPE;
1734: BEGIN
1740: p_init_msg_list => OKC_API.G_FALSE,
1741: x_return_status => l_error_rec.error_type,
1742: x_msg_count => l_error_rec.msg_count,
1743: x_msg_data => l_error_rec.msg_data,
1744: p_okl_sif_ret_levels_v_rec => p_okl_sif_ret_levels_v_tbl(i));
1745: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
1746: l_error_rec.SQLCODE := SQLCODE;
1747: load_error_tbl(l_error_rec, px_error_tbl);
1748: ELSE
1762: l_error_rec.error_type := 'OTHERS';
1763: l_error_rec.SQLCODE := SQLCODE;
1764: load_error_tbl(l_error_rec, px_error_tbl);
1765: END;
1766: EXIT WHEN (i = p_okl_sif_ret_levels_v_tbl.LAST);
1767: i := p_okl_sif_ret_levels_v_tbl.NEXT(i);
1768: END LOOP;
1769: END IF;
1770: -- Loop through the error_tbl to find the error with the highest severity
1763: l_error_rec.SQLCODE := SQLCODE;
1764: load_error_tbl(l_error_rec, px_error_tbl);
1765: END;
1766: EXIT WHEN (i = p_okl_sif_ret_levels_v_tbl.LAST);
1767: i := p_okl_sif_ret_levels_v_tbl.NEXT(i);
1768: END LOOP;
1769: END IF;
1770: -- Loop through the error_tbl to find the error with the highest severity
1771: -- and return it.
1803: '_PVT'
1804: );
1805: END lock_row;
1806: ------------------------------------------------------
1807: -- PL/SQL TBL lock_row for:OKL_SIF_RET_LEVELS_V_TBL --
1808: ------------------------------------------------------
1809: PROCEDURE lock_row(
1810: p_api_version IN NUMBER,
1811: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1811: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1812: x_return_status OUT NOCOPY VARCHAR2,
1813: x_msg_count OUT NOCOPY NUMBER,
1814: x_msg_data OUT NOCOPY VARCHAR2,
1815: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type) IS
1816:
1817: l_api_version CONSTANT NUMBER := 1;
1818: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1819: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1820: l_error_tbl OKC_API.ERROR_TBL_TYPE;
1821: BEGIN
1822: OKC_API.init_msg_list(p_init_msg_list);
1823: -- Make sure PL/SQL table has recrods in it before passing
1824: IF (p_okl_sif_ret_levels_v_tbl.COUNT > 0) THEN
1825: lock_row(
1826: p_api_version => p_api_version,
1827: p_init_msg_list => OKC_API.G_FALSE,
1828: x_return_status => x_return_status,
1827: p_init_msg_list => OKC_API.G_FALSE,
1828: x_return_status => x_return_status,
1829: x_msg_count => x_msg_count,
1830: x_msg_data => x_msg_data,
1831: p_okl_sif_ret_levels_v_tbl => p_okl_sif_ret_levels_v_tbl,
1832: px_error_tbl => l_error_tbl);
1833: END IF;
1834: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1835: EXCEPTION
2149: '_PVT'
2150: );
2151: END update_row;
2152: -----------------------------------------
2153: -- update_row for:OKL_SIF_RET_LEVELS_V --
2154: -----------------------------------------
2155: PROCEDURE update_row(
2156: p_api_version IN NUMBER,
2157: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2157: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2158: x_return_status OUT NOCOPY VARCHAR2,
2159: x_msg_count OUT NOCOPY NUMBER,
2160: x_msg_data OUT NOCOPY VARCHAR2,
2161: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
2162: x_okl_sif_ret_levels_v_rec OUT NOCOPY okl_sif_ret_levels_v_rec_type) IS
2163:
2164: l_api_version CONSTANT NUMBER := 1;
2165: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2158: x_return_status OUT NOCOPY VARCHAR2,
2159: x_msg_count OUT NOCOPY NUMBER,
2160: x_msg_data OUT NOCOPY VARCHAR2,
2161: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
2162: x_okl_sif_ret_levels_v_rec OUT NOCOPY okl_sif_ret_levels_v_rec_type) IS
2163:
2164: l_api_version CONSTANT NUMBER := 1;
2165: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2166: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2163:
2164: l_api_version CONSTANT NUMBER := 1;
2165: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2166: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2167: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
2168: l_def_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type;
2169: l_db_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type;
2170: l_srl_rec srl_rec_type;
2171: lx_srl_rec srl_rec_type;
2164: l_api_version CONSTANT NUMBER := 1;
2165: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2166: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2167: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
2168: l_def_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type;
2169: l_db_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type;
2170: l_srl_rec srl_rec_type;
2171: lx_srl_rec srl_rec_type;
2172: -------------------------------
2165: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2166: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2167: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
2168: l_def_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type;
2169: l_db_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type;
2170: l_srl_rec srl_rec_type;
2171: lx_srl_rec srl_rec_type;
2172: -------------------------------
2173: -- FUNCTION fill_who_columns --
2172: -------------------------------
2173: -- FUNCTION fill_who_columns --
2174: -------------------------------
2175: FUNCTION fill_who_columns (
2176: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
2177: ) RETURN okl_sif_ret_levels_v_rec_type IS
2178: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
2179: BEGIN
2180: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_DATE := SYSDATE;
2173: -- FUNCTION fill_who_columns --
2174: -------------------------------
2175: FUNCTION fill_who_columns (
2176: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
2177: ) RETURN okl_sif_ret_levels_v_rec_type IS
2178: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
2179: BEGIN
2180: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_DATE := SYSDATE;
2181: l_okl_sif_ret_levels_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2174: -------------------------------
2175: FUNCTION fill_who_columns (
2176: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
2177: ) RETURN okl_sif_ret_levels_v_rec_type IS
2178: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
2179: BEGIN
2180: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_DATE := SYSDATE;
2181: l_okl_sif_ret_levels_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2182: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2176: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type
2177: ) RETURN okl_sif_ret_levels_v_rec_type IS
2178: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
2179: BEGIN
2180: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_DATE := SYSDATE;
2181: l_okl_sif_ret_levels_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2182: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2183: RETURN(l_okl_sif_ret_levels_v_rec);
2184: END fill_who_columns;
2177: ) RETURN okl_sif_ret_levels_v_rec_type IS
2178: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
2179: BEGIN
2180: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_DATE := SYSDATE;
2181: l_okl_sif_ret_levels_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2182: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2183: RETURN(l_okl_sif_ret_levels_v_rec);
2184: END fill_who_columns;
2185: ----------------------------------
2178: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
2179: BEGIN
2180: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_DATE := SYSDATE;
2181: l_okl_sif_ret_levels_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2182: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2183: RETURN(l_okl_sif_ret_levels_v_rec);
2184: END fill_who_columns;
2185: ----------------------------------
2186: -- FUNCTION populate_new_record --
2179: BEGIN
2180: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_DATE := SYSDATE;
2181: l_okl_sif_ret_levels_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2182: l_okl_sif_ret_levels_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2183: RETURN(l_okl_sif_ret_levels_v_rec);
2184: END fill_who_columns;
2185: ----------------------------------
2186: -- FUNCTION populate_new_record --
2187: ----------------------------------
2185: ----------------------------------
2186: -- FUNCTION populate_new_record --
2187: ----------------------------------
2188: FUNCTION populate_new_record (
2189: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
2190: x_okl_sif_ret_levels_v_rec OUT NOCOPY okl_sif_ret_levels_v_rec_type
2191: ) RETURN VARCHAR2 IS
2192: l_row_notfound BOOLEAN := TRUE;
2193: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2186: -- FUNCTION populate_new_record --
2187: ----------------------------------
2188: FUNCTION populate_new_record (
2189: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
2190: x_okl_sif_ret_levels_v_rec OUT NOCOPY okl_sif_ret_levels_v_rec_type
2191: ) RETURN VARCHAR2 IS
2192: l_row_notfound BOOLEAN := TRUE;
2193: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2194: BEGIN
2191: ) RETURN VARCHAR2 IS
2192: l_row_notfound BOOLEAN := TRUE;
2193: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2194: BEGIN
2195: x_okl_sif_ret_levels_v_rec := p_okl_sif_ret_levels_v_rec;
2196: -- Get current database values
2197: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
2198: -- so it may be verified through LOCK_ROW.
2199: l_db_okl_sif_ret_levels_v_rec := get_rec(p_okl_sif_ret_levels_v_rec, l_return_status);
2195: x_okl_sif_ret_levels_v_rec := p_okl_sif_ret_levels_v_rec;
2196: -- Get current database values
2197: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
2198: -- so it may be verified through LOCK_ROW.
2199: l_db_okl_sif_ret_levels_v_rec := get_rec(p_okl_sif_ret_levels_v_rec, l_return_status);
2200: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2201: IF (x_okl_sif_ret_levels_v_rec.id = OKC_API.G_MISS_NUM)
2202: THEN
2203: x_okl_sif_ret_levels_v_rec.id := l_db_okl_sif_ret_levels_v_rec.id;
2197: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
2198: -- so it may be verified through LOCK_ROW.
2199: l_db_okl_sif_ret_levels_v_rec := get_rec(p_okl_sif_ret_levels_v_rec, l_return_status);
2200: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2201: IF (x_okl_sif_ret_levels_v_rec.id = OKC_API.G_MISS_NUM)
2202: THEN
2203: x_okl_sif_ret_levels_v_rec.id := l_db_okl_sif_ret_levels_v_rec.id;
2204: END IF;
2205: IF (x_okl_sif_ret_levels_v_rec.level_index_number = OKC_API.G_MISS_NUM)
2199: l_db_okl_sif_ret_levels_v_rec := get_rec(p_okl_sif_ret_levels_v_rec, l_return_status);
2200: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2201: IF (x_okl_sif_ret_levels_v_rec.id = OKC_API.G_MISS_NUM)
2202: THEN
2203: x_okl_sif_ret_levels_v_rec.id := l_db_okl_sif_ret_levels_v_rec.id;
2204: END IF;
2205: IF (x_okl_sif_ret_levels_v_rec.level_index_number = OKC_API.G_MISS_NUM)
2206: THEN
2207: x_okl_sif_ret_levels_v_rec.level_index_number := l_db_okl_sif_ret_levels_v_rec.level_index_number;
2201: IF (x_okl_sif_ret_levels_v_rec.id = OKC_API.G_MISS_NUM)
2202: THEN
2203: x_okl_sif_ret_levels_v_rec.id := l_db_okl_sif_ret_levels_v_rec.id;
2204: END IF;
2205: IF (x_okl_sif_ret_levels_v_rec.level_index_number = OKC_API.G_MISS_NUM)
2206: THEN
2207: x_okl_sif_ret_levels_v_rec.level_index_number := l_db_okl_sif_ret_levels_v_rec.level_index_number;
2208: END IF;
2209: IF (x_okl_sif_ret_levels_v_rec.number_of_periods = OKC_API.G_MISS_NUM)
2203: x_okl_sif_ret_levels_v_rec.id := l_db_okl_sif_ret_levels_v_rec.id;
2204: END IF;
2205: IF (x_okl_sif_ret_levels_v_rec.level_index_number = OKC_API.G_MISS_NUM)
2206: THEN
2207: x_okl_sif_ret_levels_v_rec.level_index_number := l_db_okl_sif_ret_levels_v_rec.level_index_number;
2208: END IF;
2209: IF (x_okl_sif_ret_levels_v_rec.number_of_periods = OKC_API.G_MISS_NUM)
2210: THEN
2211: x_okl_sif_ret_levels_v_rec.number_of_periods := l_db_okl_sif_ret_levels_v_rec.number_of_periods;
2205: IF (x_okl_sif_ret_levels_v_rec.level_index_number = OKC_API.G_MISS_NUM)
2206: THEN
2207: x_okl_sif_ret_levels_v_rec.level_index_number := l_db_okl_sif_ret_levels_v_rec.level_index_number;
2208: END IF;
2209: IF (x_okl_sif_ret_levels_v_rec.number_of_periods = OKC_API.G_MISS_NUM)
2210: THEN
2211: x_okl_sif_ret_levels_v_rec.number_of_periods := l_db_okl_sif_ret_levels_v_rec.number_of_periods;
2212: END IF;
2213: IF (x_okl_sif_ret_levels_v_rec.sir_id = OKC_API.G_MISS_NUM)
2207: x_okl_sif_ret_levels_v_rec.level_index_number := l_db_okl_sif_ret_levels_v_rec.level_index_number;
2208: END IF;
2209: IF (x_okl_sif_ret_levels_v_rec.number_of_periods = OKC_API.G_MISS_NUM)
2210: THEN
2211: x_okl_sif_ret_levels_v_rec.number_of_periods := l_db_okl_sif_ret_levels_v_rec.number_of_periods;
2212: END IF;
2213: IF (x_okl_sif_ret_levels_v_rec.sir_id = OKC_API.G_MISS_NUM)
2214: THEN
2215: x_okl_sif_ret_levels_v_rec.sir_id := l_db_okl_sif_ret_levels_v_rec.sir_id;
2209: IF (x_okl_sif_ret_levels_v_rec.number_of_periods = OKC_API.G_MISS_NUM)
2210: THEN
2211: x_okl_sif_ret_levels_v_rec.number_of_periods := l_db_okl_sif_ret_levels_v_rec.number_of_periods;
2212: END IF;
2213: IF (x_okl_sif_ret_levels_v_rec.sir_id = OKC_API.G_MISS_NUM)
2214: THEN
2215: x_okl_sif_ret_levels_v_rec.sir_id := l_db_okl_sif_ret_levels_v_rec.sir_id;
2216: END IF;
2217: IF (x_okl_sif_ret_levels_v_rec.index_number = OKC_API.G_MISS_NUM)
2211: x_okl_sif_ret_levels_v_rec.number_of_periods := l_db_okl_sif_ret_levels_v_rec.number_of_periods;
2212: END IF;
2213: IF (x_okl_sif_ret_levels_v_rec.sir_id = OKC_API.G_MISS_NUM)
2214: THEN
2215: x_okl_sif_ret_levels_v_rec.sir_id := l_db_okl_sif_ret_levels_v_rec.sir_id;
2216: END IF;
2217: IF (x_okl_sif_ret_levels_v_rec.index_number = OKC_API.G_MISS_NUM)
2218: THEN
2219: x_okl_sif_ret_levels_v_rec.index_number := l_db_okl_sif_ret_levels_v_rec.index_number;
2213: IF (x_okl_sif_ret_levels_v_rec.sir_id = OKC_API.G_MISS_NUM)
2214: THEN
2215: x_okl_sif_ret_levels_v_rec.sir_id := l_db_okl_sif_ret_levels_v_rec.sir_id;
2216: END IF;
2217: IF (x_okl_sif_ret_levels_v_rec.index_number = OKC_API.G_MISS_NUM)
2218: THEN
2219: x_okl_sif_ret_levels_v_rec.index_number := l_db_okl_sif_ret_levels_v_rec.index_number;
2220: END IF;
2221: IF (x_okl_sif_ret_levels_v_rec.level_type = OKC_API.G_MISS_CHAR)
2215: x_okl_sif_ret_levels_v_rec.sir_id := l_db_okl_sif_ret_levels_v_rec.sir_id;
2216: END IF;
2217: IF (x_okl_sif_ret_levels_v_rec.index_number = OKC_API.G_MISS_NUM)
2218: THEN
2219: x_okl_sif_ret_levels_v_rec.index_number := l_db_okl_sif_ret_levels_v_rec.index_number;
2220: END IF;
2221: IF (x_okl_sif_ret_levels_v_rec.level_type = OKC_API.G_MISS_CHAR)
2222: THEN
2223: x_okl_sif_ret_levels_v_rec.level_type := l_db_okl_sif_ret_levels_v_rec.level_type;
2217: IF (x_okl_sif_ret_levels_v_rec.index_number = OKC_API.G_MISS_NUM)
2218: THEN
2219: x_okl_sif_ret_levels_v_rec.index_number := l_db_okl_sif_ret_levels_v_rec.index_number;
2220: END IF;
2221: IF (x_okl_sif_ret_levels_v_rec.level_type = OKC_API.G_MISS_CHAR)
2222: THEN
2223: x_okl_sif_ret_levels_v_rec.level_type := l_db_okl_sif_ret_levels_v_rec.level_type;
2224: END IF;
2225: IF (x_okl_sif_ret_levels_v_rec.amount = OKC_API.G_MISS_NUM)
2219: x_okl_sif_ret_levels_v_rec.index_number := l_db_okl_sif_ret_levels_v_rec.index_number;
2220: END IF;
2221: IF (x_okl_sif_ret_levels_v_rec.level_type = OKC_API.G_MISS_CHAR)
2222: THEN
2223: x_okl_sif_ret_levels_v_rec.level_type := l_db_okl_sif_ret_levels_v_rec.level_type;
2224: END IF;
2225: IF (x_okl_sif_ret_levels_v_rec.amount = OKC_API.G_MISS_NUM)
2226: THEN
2227: x_okl_sif_ret_levels_v_rec.amount := l_db_okl_sif_ret_levels_v_rec.amount;
2221: IF (x_okl_sif_ret_levels_v_rec.level_type = OKC_API.G_MISS_CHAR)
2222: THEN
2223: x_okl_sif_ret_levels_v_rec.level_type := l_db_okl_sif_ret_levels_v_rec.level_type;
2224: END IF;
2225: IF (x_okl_sif_ret_levels_v_rec.amount = OKC_API.G_MISS_NUM)
2226: THEN
2227: x_okl_sif_ret_levels_v_rec.amount := l_db_okl_sif_ret_levels_v_rec.amount;
2228: END IF;
2229: IF (x_okl_sif_ret_levels_v_rec.advance_or_arrears = OKC_API.G_MISS_CHAR)
2223: x_okl_sif_ret_levels_v_rec.level_type := l_db_okl_sif_ret_levels_v_rec.level_type;
2224: END IF;
2225: IF (x_okl_sif_ret_levels_v_rec.amount = OKC_API.G_MISS_NUM)
2226: THEN
2227: x_okl_sif_ret_levels_v_rec.amount := l_db_okl_sif_ret_levels_v_rec.amount;
2228: END IF;
2229: IF (x_okl_sif_ret_levels_v_rec.advance_or_arrears = OKC_API.G_MISS_CHAR)
2230: THEN
2231: x_okl_sif_ret_levels_v_rec.advance_or_arrears := l_db_okl_sif_ret_levels_v_rec.advance_or_arrears;
2225: IF (x_okl_sif_ret_levels_v_rec.amount = OKC_API.G_MISS_NUM)
2226: THEN
2227: x_okl_sif_ret_levels_v_rec.amount := l_db_okl_sif_ret_levels_v_rec.amount;
2228: END IF;
2229: IF (x_okl_sif_ret_levels_v_rec.advance_or_arrears = OKC_API.G_MISS_CHAR)
2230: THEN
2231: x_okl_sif_ret_levels_v_rec.advance_or_arrears := l_db_okl_sif_ret_levels_v_rec.advance_or_arrears;
2232: END IF;
2233: IF (x_okl_sif_ret_levels_v_rec.period = OKC_API.G_MISS_CHAR)
2227: x_okl_sif_ret_levels_v_rec.amount := l_db_okl_sif_ret_levels_v_rec.amount;
2228: END IF;
2229: IF (x_okl_sif_ret_levels_v_rec.advance_or_arrears = OKC_API.G_MISS_CHAR)
2230: THEN
2231: x_okl_sif_ret_levels_v_rec.advance_or_arrears := l_db_okl_sif_ret_levels_v_rec.advance_or_arrears;
2232: END IF;
2233: IF (x_okl_sif_ret_levels_v_rec.period = OKC_API.G_MISS_CHAR)
2234: THEN
2235: x_okl_sif_ret_levels_v_rec.period := l_db_okl_sif_ret_levels_v_rec.period;
2229: IF (x_okl_sif_ret_levels_v_rec.advance_or_arrears = OKC_API.G_MISS_CHAR)
2230: THEN
2231: x_okl_sif_ret_levels_v_rec.advance_or_arrears := l_db_okl_sif_ret_levels_v_rec.advance_or_arrears;
2232: END IF;
2233: IF (x_okl_sif_ret_levels_v_rec.period = OKC_API.G_MISS_CHAR)
2234: THEN
2235: x_okl_sif_ret_levels_v_rec.period := l_db_okl_sif_ret_levels_v_rec.period;
2236: END IF;
2237: IF (x_okl_sif_ret_levels_v_rec.lock_level_step = OKC_API.G_MISS_CHAR)
2231: x_okl_sif_ret_levels_v_rec.advance_or_arrears := l_db_okl_sif_ret_levels_v_rec.advance_or_arrears;
2232: END IF;
2233: IF (x_okl_sif_ret_levels_v_rec.period = OKC_API.G_MISS_CHAR)
2234: THEN
2235: x_okl_sif_ret_levels_v_rec.period := l_db_okl_sif_ret_levels_v_rec.period;
2236: END IF;
2237: IF (x_okl_sif_ret_levels_v_rec.lock_level_step = OKC_API.G_MISS_CHAR)
2238: THEN
2239: x_okl_sif_ret_levels_v_rec.lock_level_step := l_db_okl_sif_ret_levels_v_rec.lock_level_step;
2233: IF (x_okl_sif_ret_levels_v_rec.period = OKC_API.G_MISS_CHAR)
2234: THEN
2235: x_okl_sif_ret_levels_v_rec.period := l_db_okl_sif_ret_levels_v_rec.period;
2236: END IF;
2237: IF (x_okl_sif_ret_levels_v_rec.lock_level_step = OKC_API.G_MISS_CHAR)
2238: THEN
2239: x_okl_sif_ret_levels_v_rec.lock_level_step := l_db_okl_sif_ret_levels_v_rec.lock_level_step;
2240: END IF;
2241: IF (x_okl_sif_ret_levels_v_rec.days_in_period = OKC_API.G_MISS_NUM)
2235: x_okl_sif_ret_levels_v_rec.period := l_db_okl_sif_ret_levels_v_rec.period;
2236: END IF;
2237: IF (x_okl_sif_ret_levels_v_rec.lock_level_step = OKC_API.G_MISS_CHAR)
2238: THEN
2239: x_okl_sif_ret_levels_v_rec.lock_level_step := l_db_okl_sif_ret_levels_v_rec.lock_level_step;
2240: END IF;
2241: IF (x_okl_sif_ret_levels_v_rec.days_in_period = OKC_API.G_MISS_NUM)
2242: THEN
2243: x_okl_sif_ret_levels_v_rec.days_in_period := l_db_okl_sif_ret_levels_v_rec.days_in_period;
2237: IF (x_okl_sif_ret_levels_v_rec.lock_level_step = OKC_API.G_MISS_CHAR)
2238: THEN
2239: x_okl_sif_ret_levels_v_rec.lock_level_step := l_db_okl_sif_ret_levels_v_rec.lock_level_step;
2240: END IF;
2241: IF (x_okl_sif_ret_levels_v_rec.days_in_period = OKC_API.G_MISS_NUM)
2242: THEN
2243: x_okl_sif_ret_levels_v_rec.days_in_period := l_db_okl_sif_ret_levels_v_rec.days_in_period;
2244: END IF;
2245: IF (x_okl_sif_ret_levels_v_rec.first_payment_date = OKC_API.G_MISS_DATE)
2239: x_okl_sif_ret_levels_v_rec.lock_level_step := l_db_okl_sif_ret_levels_v_rec.lock_level_step;
2240: END IF;
2241: IF (x_okl_sif_ret_levels_v_rec.days_in_period = OKC_API.G_MISS_NUM)
2242: THEN
2243: x_okl_sif_ret_levels_v_rec.days_in_period := l_db_okl_sif_ret_levels_v_rec.days_in_period;
2244: END IF;
2245: IF (x_okl_sif_ret_levels_v_rec.first_payment_date = OKC_API.G_MISS_DATE)
2246: THEN
2247: x_okl_sif_ret_levels_v_rec.first_payment_date := l_db_okl_sif_ret_levels_v_rec.first_payment_date;
2241: IF (x_okl_sif_ret_levels_v_rec.days_in_period = OKC_API.G_MISS_NUM)
2242: THEN
2243: x_okl_sif_ret_levels_v_rec.days_in_period := l_db_okl_sif_ret_levels_v_rec.days_in_period;
2244: END IF;
2245: IF (x_okl_sif_ret_levels_v_rec.first_payment_date = OKC_API.G_MISS_DATE)
2246: THEN
2247: x_okl_sif_ret_levels_v_rec.first_payment_date := l_db_okl_sif_ret_levels_v_rec.first_payment_date;
2248: END IF;
2249: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute1 = OKC_API.G_MISS_CHAR)
2243: x_okl_sif_ret_levels_v_rec.days_in_period := l_db_okl_sif_ret_levels_v_rec.days_in_period;
2244: END IF;
2245: IF (x_okl_sif_ret_levels_v_rec.first_payment_date = OKC_API.G_MISS_DATE)
2246: THEN
2247: x_okl_sif_ret_levels_v_rec.first_payment_date := l_db_okl_sif_ret_levels_v_rec.first_payment_date;
2248: END IF;
2249: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute1 = OKC_API.G_MISS_CHAR)
2250: THEN
2251: x_okl_sif_ret_levels_v_rec.stream_interface_attribute1 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute1;
2245: IF (x_okl_sif_ret_levels_v_rec.first_payment_date = OKC_API.G_MISS_DATE)
2246: THEN
2247: x_okl_sif_ret_levels_v_rec.first_payment_date := l_db_okl_sif_ret_levels_v_rec.first_payment_date;
2248: END IF;
2249: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute1 = OKC_API.G_MISS_CHAR)
2250: THEN
2251: x_okl_sif_ret_levels_v_rec.stream_interface_attribute1 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute1;
2252: END IF;
2253: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute2 = OKC_API.G_MISS_CHAR)
2247: x_okl_sif_ret_levels_v_rec.first_payment_date := l_db_okl_sif_ret_levels_v_rec.first_payment_date;
2248: END IF;
2249: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute1 = OKC_API.G_MISS_CHAR)
2250: THEN
2251: x_okl_sif_ret_levels_v_rec.stream_interface_attribute1 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute1;
2252: END IF;
2253: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute2 = OKC_API.G_MISS_CHAR)
2254: THEN
2255: x_okl_sif_ret_levels_v_rec.stream_interface_attribute2 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute2;
2249: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute1 = OKC_API.G_MISS_CHAR)
2250: THEN
2251: x_okl_sif_ret_levels_v_rec.stream_interface_attribute1 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute1;
2252: END IF;
2253: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute2 = OKC_API.G_MISS_CHAR)
2254: THEN
2255: x_okl_sif_ret_levels_v_rec.stream_interface_attribute2 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute2;
2256: END IF;
2257: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute3 = OKC_API.G_MISS_CHAR)
2251: x_okl_sif_ret_levels_v_rec.stream_interface_attribute1 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute1;
2252: END IF;
2253: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute2 = OKC_API.G_MISS_CHAR)
2254: THEN
2255: x_okl_sif_ret_levels_v_rec.stream_interface_attribute2 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute2;
2256: END IF;
2257: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute3 = OKC_API.G_MISS_CHAR)
2258: THEN
2259: x_okl_sif_ret_levels_v_rec.stream_interface_attribute3 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute3;
2253: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute2 = OKC_API.G_MISS_CHAR)
2254: THEN
2255: x_okl_sif_ret_levels_v_rec.stream_interface_attribute2 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute2;
2256: END IF;
2257: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute3 = OKC_API.G_MISS_CHAR)
2258: THEN
2259: x_okl_sif_ret_levels_v_rec.stream_interface_attribute3 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute3;
2260: END IF;
2261: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute4 = OKC_API.G_MISS_CHAR)
2255: x_okl_sif_ret_levels_v_rec.stream_interface_attribute2 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute2;
2256: END IF;
2257: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute3 = OKC_API.G_MISS_CHAR)
2258: THEN
2259: x_okl_sif_ret_levels_v_rec.stream_interface_attribute3 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute3;
2260: END IF;
2261: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute4 = OKC_API.G_MISS_CHAR)
2262: THEN
2263: x_okl_sif_ret_levels_v_rec.stream_interface_attribute4 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute4;
2257: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute3 = OKC_API.G_MISS_CHAR)
2258: THEN
2259: x_okl_sif_ret_levels_v_rec.stream_interface_attribute3 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute3;
2260: END IF;
2261: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute4 = OKC_API.G_MISS_CHAR)
2262: THEN
2263: x_okl_sif_ret_levels_v_rec.stream_interface_attribute4 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute4;
2264: END IF;
2265: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute5 = OKC_API.G_MISS_CHAR)
2259: x_okl_sif_ret_levels_v_rec.stream_interface_attribute3 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute3;
2260: END IF;
2261: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute4 = OKC_API.G_MISS_CHAR)
2262: THEN
2263: x_okl_sif_ret_levels_v_rec.stream_interface_attribute4 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute4;
2264: END IF;
2265: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute5 = OKC_API.G_MISS_CHAR)
2266: THEN
2267: x_okl_sif_ret_levels_v_rec.stream_interface_attribute5 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute5;
2261: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute4 = OKC_API.G_MISS_CHAR)
2262: THEN
2263: x_okl_sif_ret_levels_v_rec.stream_interface_attribute4 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute4;
2264: END IF;
2265: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute5 = OKC_API.G_MISS_CHAR)
2266: THEN
2267: x_okl_sif_ret_levels_v_rec.stream_interface_attribute5 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute5;
2268: END IF;
2269: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute6 = OKC_API.G_MISS_CHAR)
2263: x_okl_sif_ret_levels_v_rec.stream_interface_attribute4 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute4;
2264: END IF;
2265: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute5 = OKC_API.G_MISS_CHAR)
2266: THEN
2267: x_okl_sif_ret_levels_v_rec.stream_interface_attribute5 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute5;
2268: END IF;
2269: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute6 = OKC_API.G_MISS_CHAR)
2270: THEN
2271: x_okl_sif_ret_levels_v_rec.stream_interface_attribute6 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute6;
2265: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute5 = OKC_API.G_MISS_CHAR)
2266: THEN
2267: x_okl_sif_ret_levels_v_rec.stream_interface_attribute5 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute5;
2268: END IF;
2269: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute6 = OKC_API.G_MISS_CHAR)
2270: THEN
2271: x_okl_sif_ret_levels_v_rec.stream_interface_attribute6 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute6;
2272: END IF;
2273: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute7 = OKC_API.G_MISS_CHAR)
2267: x_okl_sif_ret_levels_v_rec.stream_interface_attribute5 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute5;
2268: END IF;
2269: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute6 = OKC_API.G_MISS_CHAR)
2270: THEN
2271: x_okl_sif_ret_levels_v_rec.stream_interface_attribute6 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute6;
2272: END IF;
2273: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute7 = OKC_API.G_MISS_CHAR)
2274: THEN
2275: x_okl_sif_ret_levels_v_rec.stream_interface_attribute7 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute7;
2269: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute6 = OKC_API.G_MISS_CHAR)
2270: THEN
2271: x_okl_sif_ret_levels_v_rec.stream_interface_attribute6 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute6;
2272: END IF;
2273: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute7 = OKC_API.G_MISS_CHAR)
2274: THEN
2275: x_okl_sif_ret_levels_v_rec.stream_interface_attribute7 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute7;
2276: END IF;
2277: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute8 = OKC_API.G_MISS_CHAR)
2271: x_okl_sif_ret_levels_v_rec.stream_interface_attribute6 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute6;
2272: END IF;
2273: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute7 = OKC_API.G_MISS_CHAR)
2274: THEN
2275: x_okl_sif_ret_levels_v_rec.stream_interface_attribute7 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute7;
2276: END IF;
2277: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute8 = OKC_API.G_MISS_CHAR)
2278: THEN
2279: x_okl_sif_ret_levels_v_rec.stream_interface_attribute8 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute8;
2273: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute7 = OKC_API.G_MISS_CHAR)
2274: THEN
2275: x_okl_sif_ret_levels_v_rec.stream_interface_attribute7 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute7;
2276: END IF;
2277: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute8 = OKC_API.G_MISS_CHAR)
2278: THEN
2279: x_okl_sif_ret_levels_v_rec.stream_interface_attribute8 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute8;
2280: END IF;
2281: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute9 = OKC_API.G_MISS_CHAR)
2275: x_okl_sif_ret_levels_v_rec.stream_interface_attribute7 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute7;
2276: END IF;
2277: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute8 = OKC_API.G_MISS_CHAR)
2278: THEN
2279: x_okl_sif_ret_levels_v_rec.stream_interface_attribute8 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute8;
2280: END IF;
2281: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute9 = OKC_API.G_MISS_CHAR)
2282: THEN
2283: x_okl_sif_ret_levels_v_rec.stream_interface_attribute9 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute9;
2277: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute8 = OKC_API.G_MISS_CHAR)
2278: THEN
2279: x_okl_sif_ret_levels_v_rec.stream_interface_attribute8 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute8;
2280: END IF;
2281: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute9 = OKC_API.G_MISS_CHAR)
2282: THEN
2283: x_okl_sif_ret_levels_v_rec.stream_interface_attribute9 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute9;
2284: END IF;
2285: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute10 = OKC_API.G_MISS_CHAR)
2279: x_okl_sif_ret_levels_v_rec.stream_interface_attribute8 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute8;
2280: END IF;
2281: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute9 = OKC_API.G_MISS_CHAR)
2282: THEN
2283: x_okl_sif_ret_levels_v_rec.stream_interface_attribute9 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute9;
2284: END IF;
2285: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute10 = OKC_API.G_MISS_CHAR)
2286: THEN
2287: x_okl_sif_ret_levels_v_rec.stream_interface_attribute10 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute10;
2281: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute9 = OKC_API.G_MISS_CHAR)
2282: THEN
2283: x_okl_sif_ret_levels_v_rec.stream_interface_attribute9 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute9;
2284: END IF;
2285: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute10 = OKC_API.G_MISS_CHAR)
2286: THEN
2287: x_okl_sif_ret_levels_v_rec.stream_interface_attribute10 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute10;
2288: END IF;
2289: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute11 = OKC_API.G_MISS_CHAR)
2283: x_okl_sif_ret_levels_v_rec.stream_interface_attribute9 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute9;
2284: END IF;
2285: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute10 = OKC_API.G_MISS_CHAR)
2286: THEN
2287: x_okl_sif_ret_levels_v_rec.stream_interface_attribute10 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute10;
2288: END IF;
2289: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute11 = OKC_API.G_MISS_CHAR)
2290: THEN
2291: x_okl_sif_ret_levels_v_rec.stream_interface_attribute11 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute11;
2285: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute10 = OKC_API.G_MISS_CHAR)
2286: THEN
2287: x_okl_sif_ret_levels_v_rec.stream_interface_attribute10 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute10;
2288: END IF;
2289: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute11 = OKC_API.G_MISS_CHAR)
2290: THEN
2291: x_okl_sif_ret_levels_v_rec.stream_interface_attribute11 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute11;
2292: END IF;
2293: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute12 = OKC_API.G_MISS_CHAR)
2287: x_okl_sif_ret_levels_v_rec.stream_interface_attribute10 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute10;
2288: END IF;
2289: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute11 = OKC_API.G_MISS_CHAR)
2290: THEN
2291: x_okl_sif_ret_levels_v_rec.stream_interface_attribute11 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute11;
2292: END IF;
2293: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute12 = OKC_API.G_MISS_CHAR)
2294: THEN
2295: x_okl_sif_ret_levels_v_rec.stream_interface_attribute12 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute12;
2289: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute11 = OKC_API.G_MISS_CHAR)
2290: THEN
2291: x_okl_sif_ret_levels_v_rec.stream_interface_attribute11 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute11;
2292: END IF;
2293: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute12 = OKC_API.G_MISS_CHAR)
2294: THEN
2295: x_okl_sif_ret_levels_v_rec.stream_interface_attribute12 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute12;
2296: END IF;
2297: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute13 = OKC_API.G_MISS_CHAR)
2291: x_okl_sif_ret_levels_v_rec.stream_interface_attribute11 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute11;
2292: END IF;
2293: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute12 = OKC_API.G_MISS_CHAR)
2294: THEN
2295: x_okl_sif_ret_levels_v_rec.stream_interface_attribute12 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute12;
2296: END IF;
2297: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute13 = OKC_API.G_MISS_CHAR)
2298: THEN
2299: x_okl_sif_ret_levels_v_rec.stream_interface_attribute13 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute13;
2293: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute12 = OKC_API.G_MISS_CHAR)
2294: THEN
2295: x_okl_sif_ret_levels_v_rec.stream_interface_attribute12 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute12;
2296: END IF;
2297: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute13 = OKC_API.G_MISS_CHAR)
2298: THEN
2299: x_okl_sif_ret_levels_v_rec.stream_interface_attribute13 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute13;
2300: END IF;
2301: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute14 = OKC_API.G_MISS_CHAR)
2295: x_okl_sif_ret_levels_v_rec.stream_interface_attribute12 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute12;
2296: END IF;
2297: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute13 = OKC_API.G_MISS_CHAR)
2298: THEN
2299: x_okl_sif_ret_levels_v_rec.stream_interface_attribute13 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute13;
2300: END IF;
2301: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute14 = OKC_API.G_MISS_CHAR)
2302: THEN
2303: x_okl_sif_ret_levels_v_rec.stream_interface_attribute14 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute14;
2297: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute13 = OKC_API.G_MISS_CHAR)
2298: THEN
2299: x_okl_sif_ret_levels_v_rec.stream_interface_attribute13 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute13;
2300: END IF;
2301: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute14 = OKC_API.G_MISS_CHAR)
2302: THEN
2303: x_okl_sif_ret_levels_v_rec.stream_interface_attribute14 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute14;
2304: END IF;
2305: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute15 = OKC_API.G_MISS_CHAR)
2299: x_okl_sif_ret_levels_v_rec.stream_interface_attribute13 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute13;
2300: END IF;
2301: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute14 = OKC_API.G_MISS_CHAR)
2302: THEN
2303: x_okl_sif_ret_levels_v_rec.stream_interface_attribute14 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute14;
2304: END IF;
2305: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute15 = OKC_API.G_MISS_CHAR)
2306: THEN
2307: x_okl_sif_ret_levels_v_rec.stream_interface_attribute15 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute15;
2301: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute14 = OKC_API.G_MISS_CHAR)
2302: THEN
2303: x_okl_sif_ret_levels_v_rec.stream_interface_attribute14 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute14;
2304: END IF;
2305: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute15 = OKC_API.G_MISS_CHAR)
2306: THEN
2307: x_okl_sif_ret_levels_v_rec.stream_interface_attribute15 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute15;
2308: END IF;
2309: IF (x_okl_sif_ret_levels_v_rec.creation_date = OKC_API.G_MISS_DATE)
2303: x_okl_sif_ret_levels_v_rec.stream_interface_attribute14 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute14;
2304: END IF;
2305: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute15 = OKC_API.G_MISS_CHAR)
2306: THEN
2307: x_okl_sif_ret_levels_v_rec.stream_interface_attribute15 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute15;
2308: END IF;
2309: IF (x_okl_sif_ret_levels_v_rec.creation_date = OKC_API.G_MISS_DATE)
2310: THEN
2311: x_okl_sif_ret_levels_v_rec.creation_date := l_db_okl_sif_ret_levels_v_rec.creation_date;
2305: IF (x_okl_sif_ret_levels_v_rec.stream_interface_attribute15 = OKC_API.G_MISS_CHAR)
2306: THEN
2307: x_okl_sif_ret_levels_v_rec.stream_interface_attribute15 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute15;
2308: END IF;
2309: IF (x_okl_sif_ret_levels_v_rec.creation_date = OKC_API.G_MISS_DATE)
2310: THEN
2311: x_okl_sif_ret_levels_v_rec.creation_date := l_db_okl_sif_ret_levels_v_rec.creation_date;
2312: END IF;
2313: IF (x_okl_sif_ret_levels_v_rec.created_by = OKC_API.G_MISS_NUM)
2307: x_okl_sif_ret_levels_v_rec.stream_interface_attribute15 := l_db_okl_sif_ret_levels_v_rec.stream_interface_attribute15;
2308: END IF;
2309: IF (x_okl_sif_ret_levels_v_rec.creation_date = OKC_API.G_MISS_DATE)
2310: THEN
2311: x_okl_sif_ret_levels_v_rec.creation_date := l_db_okl_sif_ret_levels_v_rec.creation_date;
2312: END IF;
2313: IF (x_okl_sif_ret_levels_v_rec.created_by = OKC_API.G_MISS_NUM)
2314: THEN
2315: x_okl_sif_ret_levels_v_rec.created_by := l_db_okl_sif_ret_levels_v_rec.created_by;
2309: IF (x_okl_sif_ret_levels_v_rec.creation_date = OKC_API.G_MISS_DATE)
2310: THEN
2311: x_okl_sif_ret_levels_v_rec.creation_date := l_db_okl_sif_ret_levels_v_rec.creation_date;
2312: END IF;
2313: IF (x_okl_sif_ret_levels_v_rec.created_by = OKC_API.G_MISS_NUM)
2314: THEN
2315: x_okl_sif_ret_levels_v_rec.created_by := l_db_okl_sif_ret_levels_v_rec.created_by;
2316: END IF;
2317: IF (x_okl_sif_ret_levels_v_rec.last_update_date = OKC_API.G_MISS_DATE)
2311: x_okl_sif_ret_levels_v_rec.creation_date := l_db_okl_sif_ret_levels_v_rec.creation_date;
2312: END IF;
2313: IF (x_okl_sif_ret_levels_v_rec.created_by = OKC_API.G_MISS_NUM)
2314: THEN
2315: x_okl_sif_ret_levels_v_rec.created_by := l_db_okl_sif_ret_levels_v_rec.created_by;
2316: END IF;
2317: IF (x_okl_sif_ret_levels_v_rec.last_update_date = OKC_API.G_MISS_DATE)
2318: THEN
2319: x_okl_sif_ret_levels_v_rec.last_update_date := l_db_okl_sif_ret_levels_v_rec.last_update_date;
2313: IF (x_okl_sif_ret_levels_v_rec.created_by = OKC_API.G_MISS_NUM)
2314: THEN
2315: x_okl_sif_ret_levels_v_rec.created_by := l_db_okl_sif_ret_levels_v_rec.created_by;
2316: END IF;
2317: IF (x_okl_sif_ret_levels_v_rec.last_update_date = OKC_API.G_MISS_DATE)
2318: THEN
2319: x_okl_sif_ret_levels_v_rec.last_update_date := l_db_okl_sif_ret_levels_v_rec.last_update_date;
2320: END IF;
2321: IF (x_okl_sif_ret_levels_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
2315: x_okl_sif_ret_levels_v_rec.created_by := l_db_okl_sif_ret_levels_v_rec.created_by;
2316: END IF;
2317: IF (x_okl_sif_ret_levels_v_rec.last_update_date = OKC_API.G_MISS_DATE)
2318: THEN
2319: x_okl_sif_ret_levels_v_rec.last_update_date := l_db_okl_sif_ret_levels_v_rec.last_update_date;
2320: END IF;
2321: IF (x_okl_sif_ret_levels_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
2322: THEN
2323: x_okl_sif_ret_levels_v_rec.last_updated_by := l_db_okl_sif_ret_levels_v_rec.last_updated_by;
2317: IF (x_okl_sif_ret_levels_v_rec.last_update_date = OKC_API.G_MISS_DATE)
2318: THEN
2319: x_okl_sif_ret_levels_v_rec.last_update_date := l_db_okl_sif_ret_levels_v_rec.last_update_date;
2320: END IF;
2321: IF (x_okl_sif_ret_levels_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
2322: THEN
2323: x_okl_sif_ret_levels_v_rec.last_updated_by := l_db_okl_sif_ret_levels_v_rec.last_updated_by;
2324: END IF;
2325: IF (x_okl_sif_ret_levels_v_rec.last_update_login = OKC_API.G_MISS_NUM)
2319: x_okl_sif_ret_levels_v_rec.last_update_date := l_db_okl_sif_ret_levels_v_rec.last_update_date;
2320: END IF;
2321: IF (x_okl_sif_ret_levels_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
2322: THEN
2323: x_okl_sif_ret_levels_v_rec.last_updated_by := l_db_okl_sif_ret_levels_v_rec.last_updated_by;
2324: END IF;
2325: IF (x_okl_sif_ret_levels_v_rec.last_update_login = OKC_API.G_MISS_NUM)
2326: THEN
2327: x_okl_sif_ret_levels_v_rec.last_update_login := l_db_okl_sif_ret_levels_v_rec.last_update_login;
2321: IF (x_okl_sif_ret_levels_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
2322: THEN
2323: x_okl_sif_ret_levels_v_rec.last_updated_by := l_db_okl_sif_ret_levels_v_rec.last_updated_by;
2324: END IF;
2325: IF (x_okl_sif_ret_levels_v_rec.last_update_login = OKC_API.G_MISS_NUM)
2326: THEN
2327: x_okl_sif_ret_levels_v_rec.last_update_login := l_db_okl_sif_ret_levels_v_rec.last_update_login;
2328: END IF;
2329: --smahapat 10/12/03
2323: x_okl_sif_ret_levels_v_rec.last_updated_by := l_db_okl_sif_ret_levels_v_rec.last_updated_by;
2324: END IF;
2325: IF (x_okl_sif_ret_levels_v_rec.last_update_login = OKC_API.G_MISS_NUM)
2326: THEN
2327: x_okl_sif_ret_levels_v_rec.last_update_login := l_db_okl_sif_ret_levels_v_rec.last_update_login;
2328: END IF;
2329: --smahapat 10/12/03
2330: IF (x_okl_sif_ret_levels_v_rec.rate = OKC_API.G_MISS_NUM)
2331: THEN
2326: THEN
2327: x_okl_sif_ret_levels_v_rec.last_update_login := l_db_okl_sif_ret_levels_v_rec.last_update_login;
2328: END IF;
2329: --smahapat 10/12/03
2330: IF (x_okl_sif_ret_levels_v_rec.rate = OKC_API.G_MISS_NUM)
2331: THEN
2332: x_okl_sif_ret_levels_v_rec.rate := l_db_okl_sif_ret_levels_v_rec.rate;
2333: END IF;
2334: END IF;
2328: END IF;
2329: --smahapat 10/12/03
2330: IF (x_okl_sif_ret_levels_v_rec.rate = OKC_API.G_MISS_NUM)
2331: THEN
2332: x_okl_sif_ret_levels_v_rec.rate := l_db_okl_sif_ret_levels_v_rec.rate;
2333: END IF;
2334: END IF;
2335: RETURN(l_return_status);
2336: END populate_new_record;
2334: END IF;
2335: RETURN(l_return_status);
2336: END populate_new_record;
2337: ---------------------------------------------
2338: -- Set_Attributes for:OKL_SIF_RET_LEVELS_V --
2339: ---------------------------------------------
2340: FUNCTION Set_Attributes (
2341: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
2342: x_okl_sif_ret_levels_v_rec OUT NOCOPY okl_sif_ret_levels_v_rec_type
2337: ---------------------------------------------
2338: -- Set_Attributes for:OKL_SIF_RET_LEVELS_V --
2339: ---------------------------------------------
2340: FUNCTION Set_Attributes (
2341: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
2342: x_okl_sif_ret_levels_v_rec OUT NOCOPY okl_sif_ret_levels_v_rec_type
2343: ) RETURN VARCHAR2 IS
2344: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2345: BEGIN
2338: -- Set_Attributes for:OKL_SIF_RET_LEVELS_V --
2339: ---------------------------------------------
2340: FUNCTION Set_Attributes (
2341: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
2342: x_okl_sif_ret_levels_v_rec OUT NOCOPY okl_sif_ret_levels_v_rec_type
2343: ) RETURN VARCHAR2 IS
2344: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2345: BEGIN
2346: x_okl_sif_ret_levels_v_rec := p_okl_sif_ret_levels_v_rec;
2342: x_okl_sif_ret_levels_v_rec OUT NOCOPY okl_sif_ret_levels_v_rec_type
2343: ) RETURN VARCHAR2 IS
2344: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2345: BEGIN
2346: x_okl_sif_ret_levels_v_rec := p_okl_sif_ret_levels_v_rec;
2347: RETURN(l_return_status);
2348: END Set_Attributes;
2349: BEGIN
2350: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2360: RAISE OKC_API.G_EXCEPTION_ERROR;
2361: END IF;
2362: --- Setting item attributes
2363: l_return_status := Set_Attributes(
2364: p_okl_sif_ret_levels_v_rec, -- IN
2365: x_okl_sif_ret_levels_v_rec); -- OUT
2366: --- If any errors happen abort API
2367: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2368: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2361: END IF;
2362: --- Setting item attributes
2363: l_return_status := Set_Attributes(
2364: p_okl_sif_ret_levels_v_rec, -- IN
2365: x_okl_sif_ret_levels_v_rec); -- OUT
2366: --- If any errors happen abort API
2367: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2368: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2369: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2368: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2369: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2370: RAISE OKC_API.G_EXCEPTION_ERROR;
2371: END IF;
2372: l_return_status := populate_new_record(l_okl_sif_ret_levels_v_rec, l_def_okl_sif_ret_levels_v_rec);
2373: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2374: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2375: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2376: RAISE OKC_API.G_EXCEPTION_ERROR;
2374: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2375: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2376: RAISE OKC_API.G_EXCEPTION_ERROR;
2377: END IF;
2378: l_def_okl_sif_ret_levels_v_rec := fill_who_columns(l_def_okl_sif_ret_levels_v_rec);
2379: --- Validate all non-missing attributes (Item Level Validation)
2380: l_return_status := Validate_Attributes(l_def_okl_sif_ret_levels_v_rec);
2381: --- If any errors happen abort API
2382: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2376: RAISE OKC_API.G_EXCEPTION_ERROR;
2377: END IF;
2378: l_def_okl_sif_ret_levels_v_rec := fill_who_columns(l_def_okl_sif_ret_levels_v_rec);
2379: --- Validate all non-missing attributes (Item Level Validation)
2380: l_return_status := Validate_Attributes(l_def_okl_sif_ret_levels_v_rec);
2381: --- If any errors happen abort API
2382: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2383: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2384: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2383: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2384: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2385: RAISE OKC_API.G_EXCEPTION_ERROR;
2386: END IF;
2387: l_return_status := Validate_Record(l_def_okl_sif_ret_levels_v_rec, l_db_okl_sif_ret_levels_v_rec);
2388: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2389: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2390: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2391: RAISE OKC_API.G_EXCEPTION_ERROR;
2397: p_init_msg_list => p_init_msg_list,
2398: x_return_status => l_return_status,
2399: x_msg_count => x_msg_count,
2400: x_msg_data => x_msg_data,
2401: p_okl_sif_ret_levels_v_rec => p_okl_sif_ret_levels_v_rec);
2402: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2403: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2404: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2405: RAISE OKC_API.G_EXCEPTION_ERROR;
2407:
2408: -----------------------------------------
2409: -- Move VIEW record to "Child" records --
2410: -----------------------------------------
2411: migrate(l_def_okl_sif_ret_levels_v_rec, l_srl_rec);
2412: -----------------------------------------------
2413: -- Call the UPDATE_ROW for each child record --
2414: -----------------------------------------------
2415: update_row(
2424: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2425: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2426: RAISE OKC_API.G_EXCEPTION_ERROR;
2427: END IF;
2428: migrate(lx_srl_rec, l_def_okl_sif_ret_levels_v_rec);
2429: x_okl_sif_ret_levels_v_rec := l_def_okl_sif_ret_levels_v_rec;
2430: x_return_status := l_return_status;
2431: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2432: EXCEPTION
2425: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2426: RAISE OKC_API.G_EXCEPTION_ERROR;
2427: END IF;
2428: migrate(lx_srl_rec, l_def_okl_sif_ret_levels_v_rec);
2429: x_okl_sif_ret_levels_v_rec := l_def_okl_sif_ret_levels_v_rec;
2430: x_return_status := l_return_status;
2431: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2432: EXCEPTION
2433: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2461: '_PVT'
2462: );
2463: END update_row;
2464: --------------------------------------------------------
2465: -- PL/SQL TBL update_row for:okl_sif_ret_levels_v_tbl --
2466: --------------------------------------------------------
2467: PROCEDURE update_row(
2468: p_api_version IN NUMBER,
2469: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2469: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2470: x_return_status OUT NOCOPY VARCHAR2,
2471: x_msg_count OUT NOCOPY NUMBER,
2472: x_msg_data OUT NOCOPY VARCHAR2,
2473: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
2474: x_okl_sif_ret_levels_v_tbl OUT NOCOPY okl_sif_ret_levels_v_tbl_type,
2475: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
2476:
2477: l_api_version CONSTANT NUMBER := 1;
2470: x_return_status OUT NOCOPY VARCHAR2,
2471: x_msg_count OUT NOCOPY NUMBER,
2472: x_msg_data OUT NOCOPY VARCHAR2,
2473: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
2474: x_okl_sif_ret_levels_v_tbl OUT NOCOPY okl_sif_ret_levels_v_tbl_type,
2475: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
2476:
2477: l_api_version CONSTANT NUMBER := 1;
2478: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
2479: i NUMBER := 0;
2480: BEGIN
2481: OKC_API.init_msg_list(p_init_msg_list);
2482: -- Make sure PL/SQL table has records in it before passing
2483: IF (p_okl_sif_ret_levels_v_tbl.COUNT > 0) THEN
2484: i := p_okl_sif_ret_levels_v_tbl.FIRST;
2485: LOOP
2486: DECLARE
2487: l_error_rec OKC_API.ERROR_REC_TYPE;
2480: BEGIN
2481: OKC_API.init_msg_list(p_init_msg_list);
2482: -- Make sure PL/SQL table has records in it before passing
2483: IF (p_okl_sif_ret_levels_v_tbl.COUNT > 0) THEN
2484: i := p_okl_sif_ret_levels_v_tbl.FIRST;
2485: LOOP
2486: DECLARE
2487: l_error_rec OKC_API.ERROR_REC_TYPE;
2488: BEGIN
2494: p_init_msg_list => OKC_API.G_FALSE,
2495: x_return_status => l_error_rec.error_type,
2496: x_msg_count => l_error_rec.msg_count,
2497: x_msg_data => l_error_rec.msg_data,
2498: p_okl_sif_ret_levels_v_rec => p_okl_sif_ret_levels_v_tbl(i),
2499: x_okl_sif_ret_levels_v_rec => x_okl_sif_ret_levels_v_tbl(i));
2500: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
2501: l_error_rec.SQLCODE := SQLCODE;
2502: load_error_tbl(l_error_rec, px_error_tbl);
2495: x_return_status => l_error_rec.error_type,
2496: x_msg_count => l_error_rec.msg_count,
2497: x_msg_data => l_error_rec.msg_data,
2498: p_okl_sif_ret_levels_v_rec => p_okl_sif_ret_levels_v_tbl(i),
2499: x_okl_sif_ret_levels_v_rec => x_okl_sif_ret_levels_v_tbl(i));
2500: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
2501: l_error_rec.SQLCODE := SQLCODE;
2502: load_error_tbl(l_error_rec, px_error_tbl);
2503: ELSE
2517: l_error_rec.error_type := 'OTHERS';
2518: l_error_rec.SQLCODE := SQLCODE;
2519: load_error_tbl(l_error_rec, px_error_tbl);
2520: END;
2521: EXIT WHEN (i = p_okl_sif_ret_levels_v_tbl.LAST);
2522: i := p_okl_sif_ret_levels_v_tbl.NEXT(i);
2523: END LOOP;
2524: END IF;
2525: -- Loop through the error_tbl to find the error with the highest severity
2518: l_error_rec.SQLCODE := SQLCODE;
2519: load_error_tbl(l_error_rec, px_error_tbl);
2520: END;
2521: EXIT WHEN (i = p_okl_sif_ret_levels_v_tbl.LAST);
2522: i := p_okl_sif_ret_levels_v_tbl.NEXT(i);
2523: END LOOP;
2524: END IF;
2525: -- Loop through the error_tbl to find the error with the highest severity
2526: -- and return it.
2559: );
2560: END update_row;
2561:
2562: --------------------------------------------------------
2563: -- PL/SQL TBL update_row for:OKL_SIF_RET_LEVELS_V_TBL --
2564: --------------------------------------------------------
2565: PROCEDURE update_row(
2566: p_api_version IN NUMBER,
2567: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2567: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2568: x_return_status OUT NOCOPY VARCHAR2,
2569: x_msg_count OUT NOCOPY NUMBER,
2570: x_msg_data OUT NOCOPY VARCHAR2,
2571: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
2572: x_okl_sif_ret_levels_v_tbl OUT NOCOPY okl_sif_ret_levels_v_tbl_type) IS
2573:
2574: l_api_version CONSTANT NUMBER := 1;
2575: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2568: x_return_status OUT NOCOPY VARCHAR2,
2569: x_msg_count OUT NOCOPY NUMBER,
2570: x_msg_data OUT NOCOPY VARCHAR2,
2571: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
2572: x_okl_sif_ret_levels_v_tbl OUT NOCOPY okl_sif_ret_levels_v_tbl_type) IS
2573:
2574: l_api_version CONSTANT NUMBER := 1;
2575: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2576: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2577: l_error_tbl OKC_API.ERROR_TBL_TYPE;
2578: BEGIN
2579: OKC_API.init_msg_list(p_init_msg_list);
2580: -- Make sure PL/SQL table has records in it before passing
2581: IF (p_okl_sif_ret_levels_v_tbl.COUNT > 0) THEN
2582: update_row (
2583: p_api_version => p_api_version,
2584: p_init_msg_list => OKC_API.G_FALSE,
2585: x_return_status => x_return_status,
2584: p_init_msg_list => OKC_API.G_FALSE,
2585: x_return_status => x_return_status,
2586: x_msg_count => x_msg_count,
2587: x_msg_data => x_msg_data,
2588: p_okl_sif_ret_levels_v_tbl => p_okl_sif_ret_levels_v_tbl,
2589: x_okl_sif_ret_levels_v_tbl => x_okl_sif_ret_levels_v_tbl,
2590: px_error_tbl => l_error_tbl);
2591: END IF;
2592: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2585: x_return_status => x_return_status,
2586: x_msg_count => x_msg_count,
2587: x_msg_data => x_msg_data,
2588: p_okl_sif_ret_levels_v_tbl => p_okl_sif_ret_levels_v_tbl,
2589: x_okl_sif_ret_levels_v_tbl => x_okl_sif_ret_levels_v_tbl,
2590: px_error_tbl => l_error_tbl);
2591: END IF;
2592: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2593: EXCEPTION
2689: '_PVT'
2690: );
2691: END delete_row;
2692: -----------------------------------------
2693: -- delete_row for:OKL_SIF_RET_LEVELS_V --
2694: -----------------------------------------
2695: PROCEDURE delete_row(
2696: p_api_version IN NUMBER,
2697: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2697: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2698: x_return_status OUT NOCOPY VARCHAR2,
2699: x_msg_count OUT NOCOPY NUMBER,
2700: x_msg_data OUT NOCOPY VARCHAR2,
2701: p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type) IS
2702:
2703: l_api_version CONSTANT NUMBER := 1;
2704: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2705: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2702:
2703: l_api_version CONSTANT NUMBER := 1;
2704: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2705: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2706: l_okl_sif_ret_levels_v_rec okl_sif_ret_levels_v_rec_type := p_okl_sif_ret_levels_v_rec;
2707: l_srl_rec srl_rec_type;
2708: BEGIN
2709: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2710: G_PKG_NAME,
2720: END IF;
2721: -----------------------------------------
2722: -- Move VIEW record to "Child" records --
2723: -----------------------------------------
2724: migrate(l_okl_sif_ret_levels_v_rec, l_srl_rec);
2725: -----------------------------------------------
2726: -- Call the DELETE_ROW for each child record --
2727: -----------------------------------------------
2728: delete_row(
2771: '_PVT'
2772: );
2773: END delete_row;
2774: ----------------------------------------------------
2775: -- PL/SQL TBL delete_row for:OKL_SIF_RET_LEVELS_V --
2776: ----------------------------------------------------
2777: PROCEDURE delete_row(
2778: p_api_version IN NUMBER,
2779: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2779: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2780: x_return_status OUT NOCOPY VARCHAR2,
2781: x_msg_count OUT NOCOPY NUMBER,
2782: x_msg_data OUT NOCOPY VARCHAR2,
2783: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
2784: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
2785:
2786: l_api_version CONSTANT NUMBER := 1;
2787: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
2788: i NUMBER := 0;
2789: BEGIN
2790: OKC_API.init_msg_list(p_init_msg_list);
2791: -- Make sure PL/SQL table has records in it before passing
2792: IF (p_okl_sif_ret_levels_v_tbl.COUNT > 0) THEN
2793: i := p_okl_sif_ret_levels_v_tbl.FIRST;
2794: LOOP
2795: DECLARE
2796: l_error_rec OKC_API.ERROR_REC_TYPE;
2789: BEGIN
2790: OKC_API.init_msg_list(p_init_msg_list);
2791: -- Make sure PL/SQL table has records in it before passing
2792: IF (p_okl_sif_ret_levels_v_tbl.COUNT > 0) THEN
2793: i := p_okl_sif_ret_levels_v_tbl.FIRST;
2794: LOOP
2795: DECLARE
2796: l_error_rec OKC_API.ERROR_REC_TYPE;
2797: BEGIN
2803: p_init_msg_list => OKC_API.G_FALSE,
2804: x_return_status => l_error_rec.error_type,
2805: x_msg_count => l_error_rec.msg_count,
2806: x_msg_data => l_error_rec.msg_data,
2807: p_okl_sif_ret_levels_v_rec => p_okl_sif_ret_levels_v_tbl(i));
2808: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
2809: l_error_rec.SQLCODE := SQLCODE;
2810: load_error_tbl(l_error_rec, px_error_tbl);
2811: ELSE
2825: l_error_rec.error_type := 'OTHERS';
2826: l_error_rec.SQLCODE := SQLCODE;
2827: load_error_tbl(l_error_rec, px_error_tbl);
2828: END;
2829: EXIT WHEN (i = p_okl_sif_ret_levels_v_tbl.LAST);
2830: i := p_okl_sif_ret_levels_v_tbl.NEXT(i);
2831: END LOOP;
2832: END IF;
2833: -- Loop through the error_tbl to find the error with the highest severity
2826: l_error_rec.SQLCODE := SQLCODE;
2827: load_error_tbl(l_error_rec, px_error_tbl);
2828: END;
2829: EXIT WHEN (i = p_okl_sif_ret_levels_v_tbl.LAST);
2830: i := p_okl_sif_ret_levels_v_tbl.NEXT(i);
2831: END LOOP;
2832: END IF;
2833: -- Loop through the error_tbl to find the error with the highest severity
2834: -- and return it.
2867: );
2868: END delete_row;
2869:
2870: ----------------------------------------------------
2871: -- PL/SQL TBL delete_row for:OKL_SIF_RET_LEVELS_V --
2872: ----------------------------------------------------
2873: PROCEDURE delete_row(
2874: p_api_version IN NUMBER,
2875: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2875: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2876: x_return_status OUT NOCOPY VARCHAR2,
2877: x_msg_count OUT NOCOPY NUMBER,
2878: x_msg_data OUT NOCOPY VARCHAR2,
2879: p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type) IS
2880:
2881: l_api_version CONSTANT NUMBER := 1;
2882: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2883: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2884: l_error_tbl OKC_API.ERROR_TBL_TYPE;
2885: BEGIN
2886: OKC_API.init_msg_list(p_init_msg_list);
2887: -- Make sure PL/SQL table has records in it before passing
2888: IF (p_okl_sif_ret_levels_v_tbl.COUNT > 0) THEN
2889: delete_row (
2890: p_api_version => p_api_version,
2891: p_init_msg_list => OKC_API.G_FALSE,
2892: x_return_status => x_return_status,
2891: p_init_msg_list => OKC_API.G_FALSE,
2892: x_return_status => x_return_status,
2893: x_msg_count => x_msg_count,
2894: x_msg_data => x_msg_data,
2895: p_okl_sif_ret_levels_v_tbl => p_okl_sif_ret_levels_v_tbl,
2896: px_error_tbl => l_error_tbl);
2897: END IF;
2898: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2899: EXCEPTION