97: null;
98: END api_copy;
99:
100: ---------------------------------------------------------------------------
101: -- FUNCTION get_rec for: OKL_TAX_LINES_V
102: ---------------------------------------------------------------------------
103: FUNCTION get_rec (
104: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type,
105: x_no_data_found OUT NOCOPY BOOLEAN
100: ---------------------------------------------------------------------------
101: -- FUNCTION get_rec for: OKL_TAX_LINES_V
102: ---------------------------------------------------------------------------
103: FUNCTION get_rec (
104: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type,
105: x_no_data_found OUT NOCOPY BOOLEAN
106: ) RETURN OKL_TAX_LINES_rec_type IS
107: CURSOR okl_taxv_pk_csr (p_id IN NUMBER) IS
108: SELECT
102: ---------------------------------------------------------------------------
103: FUNCTION get_rec (
104: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type,
105: x_no_data_found OUT NOCOPY BOOLEAN
106: ) RETURN OKL_TAX_LINES_rec_type IS
107: CURSOR okl_taxv_pk_csr (p_id IN NUMBER) IS
108: SELECT
109: ID,
110: KHR_ID,
155: CREATION_DATE,
156: LAST_UPDATED_BY,
157: LAST_UPDATE_DATE,
158: LAST_UPDATE_LOGIN
159: FROM OKL_TAX_LINES
160: WHERE OKL_TAX_LINES.id = p_id;
161: l_okl_taxv_pk okl_taxv_pk_csr%ROWTYPE;
162: l_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type;
163: BEGIN
156: LAST_UPDATED_BY,
157: LAST_UPDATE_DATE,
158: LAST_UPDATE_LOGIN
159: FROM OKL_TAX_LINES
160: WHERE OKL_TAX_LINES.id = p_id;
161: l_okl_taxv_pk okl_taxv_pk_csr%ROWTYPE;
162: l_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type;
163: BEGIN
164: x_no_data_found := TRUE;
158: LAST_UPDATE_LOGIN
159: FROM OKL_TAX_LINES
160: WHERE OKL_TAX_LINES.id = p_id;
161: l_okl_taxv_pk okl_taxv_pk_csr%ROWTYPE;
162: l_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type;
163: BEGIN
164: x_no_data_found := TRUE;
165: -- Get current database values
166: OPEN okl_taxv_pk_csr (p_OKL_TAX_LINES_rec.id);
162: l_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type;
163: BEGIN
164: x_no_data_found := TRUE;
165: -- Get current database values
166: OPEN okl_taxv_pk_csr (p_OKL_TAX_LINES_rec.id);
167: FETCH okl_taxv_pk_csr INTO
168: l_OKL_TAX_LINES_rec.id,
169: l_OKL_TAX_LINES_rec.khr_id,
170: l_OKL_TAX_LINES_rec.kle_id,
164: x_no_data_found := TRUE;
165: -- Get current database values
166: OPEN okl_taxv_pk_csr (p_OKL_TAX_LINES_rec.id);
167: FETCH okl_taxv_pk_csr INTO
168: l_OKL_TAX_LINES_rec.id,
169: l_OKL_TAX_LINES_rec.khr_id,
170: l_OKL_TAX_LINES_rec.kle_id,
171: l_OKL_TAX_LINES_rec.asset_id,
172: l_OKL_TAX_LINES_rec.asset_number,
165: -- Get current database values
166: OPEN okl_taxv_pk_csr (p_OKL_TAX_LINES_rec.id);
167: FETCH okl_taxv_pk_csr INTO
168: l_OKL_TAX_LINES_rec.id,
169: l_OKL_TAX_LINES_rec.khr_id,
170: l_OKL_TAX_LINES_rec.kle_id,
171: l_OKL_TAX_LINES_rec.asset_id,
172: l_OKL_TAX_LINES_rec.asset_number,
173: l_OKL_TAX_LINES_rec.tax_line_type,
166: OPEN okl_taxv_pk_csr (p_OKL_TAX_LINES_rec.id);
167: FETCH okl_taxv_pk_csr INTO
168: l_OKL_TAX_LINES_rec.id,
169: l_OKL_TAX_LINES_rec.khr_id,
170: l_OKL_TAX_LINES_rec.kle_id,
171: l_OKL_TAX_LINES_rec.asset_id,
172: l_OKL_TAX_LINES_rec.asset_number,
173: l_OKL_TAX_LINES_rec.tax_line_type,
174: l_OKL_TAX_LINES_rec.sel_id,
167: FETCH okl_taxv_pk_csr INTO
168: l_OKL_TAX_LINES_rec.id,
169: l_OKL_TAX_LINES_rec.khr_id,
170: l_OKL_TAX_LINES_rec.kle_id,
171: l_OKL_TAX_LINES_rec.asset_id,
172: l_OKL_TAX_LINES_rec.asset_number,
173: l_OKL_TAX_LINES_rec.tax_line_type,
174: l_OKL_TAX_LINES_rec.sel_id,
175: l_OKL_TAX_LINES_rec.tax_due_date,
168: l_OKL_TAX_LINES_rec.id,
169: l_OKL_TAX_LINES_rec.khr_id,
170: l_OKL_TAX_LINES_rec.kle_id,
171: l_OKL_TAX_LINES_rec.asset_id,
172: l_OKL_TAX_LINES_rec.asset_number,
173: l_OKL_TAX_LINES_rec.tax_line_type,
174: l_OKL_TAX_LINES_rec.sel_id,
175: l_OKL_TAX_LINES_rec.tax_due_date,
176: l_OKL_TAX_LINES_rec.tax_type,
169: l_OKL_TAX_LINES_rec.khr_id,
170: l_OKL_TAX_LINES_rec.kle_id,
171: l_OKL_TAX_LINES_rec.asset_id,
172: l_OKL_TAX_LINES_rec.asset_number,
173: l_OKL_TAX_LINES_rec.tax_line_type,
174: l_OKL_TAX_LINES_rec.sel_id,
175: l_OKL_TAX_LINES_rec.tax_due_date,
176: l_OKL_TAX_LINES_rec.tax_type,
177: l_OKL_TAX_LINES_rec.tax_rate_code_id,
170: l_OKL_TAX_LINES_rec.kle_id,
171: l_OKL_TAX_LINES_rec.asset_id,
172: l_OKL_TAX_LINES_rec.asset_number,
173: l_OKL_TAX_LINES_rec.tax_line_type,
174: l_OKL_TAX_LINES_rec.sel_id,
175: l_OKL_TAX_LINES_rec.tax_due_date,
176: l_OKL_TAX_LINES_rec.tax_type,
177: l_OKL_TAX_LINES_rec.tax_rate_code_id,
178: l_OKL_TAX_LINES_rec.tax_rate_code,
171: l_OKL_TAX_LINES_rec.asset_id,
172: l_OKL_TAX_LINES_rec.asset_number,
173: l_OKL_TAX_LINES_rec.tax_line_type,
174: l_OKL_TAX_LINES_rec.sel_id,
175: l_OKL_TAX_LINES_rec.tax_due_date,
176: l_OKL_TAX_LINES_rec.tax_type,
177: l_OKL_TAX_LINES_rec.tax_rate_code_id,
178: l_OKL_TAX_LINES_rec.tax_rate_code,
179: l_OKL_TAX_LINES_rec.taxable_amount,
172: l_OKL_TAX_LINES_rec.asset_number,
173: l_OKL_TAX_LINES_rec.tax_line_type,
174: l_OKL_TAX_LINES_rec.sel_id,
175: l_OKL_TAX_LINES_rec.tax_due_date,
176: l_OKL_TAX_LINES_rec.tax_type,
177: l_OKL_TAX_LINES_rec.tax_rate_code_id,
178: l_OKL_TAX_LINES_rec.tax_rate_code,
179: l_OKL_TAX_LINES_rec.taxable_amount,
180: l_OKL_TAX_LINES_rec.tax_exemption_id,
173: l_OKL_TAX_LINES_rec.tax_line_type,
174: l_OKL_TAX_LINES_rec.sel_id,
175: l_OKL_TAX_LINES_rec.tax_due_date,
176: l_OKL_TAX_LINES_rec.tax_type,
177: l_OKL_TAX_LINES_rec.tax_rate_code_id,
178: l_OKL_TAX_LINES_rec.tax_rate_code,
179: l_OKL_TAX_LINES_rec.taxable_amount,
180: l_OKL_TAX_LINES_rec.tax_exemption_id,
181: l_OKL_TAX_LINES_rec.manually_entered_flag,
174: l_OKL_TAX_LINES_rec.sel_id,
175: l_OKL_TAX_LINES_rec.tax_due_date,
176: l_OKL_TAX_LINES_rec.tax_type,
177: l_OKL_TAX_LINES_rec.tax_rate_code_id,
178: l_OKL_TAX_LINES_rec.tax_rate_code,
179: l_OKL_TAX_LINES_rec.taxable_amount,
180: l_OKL_TAX_LINES_rec.tax_exemption_id,
181: l_OKL_TAX_LINES_rec.manually_entered_flag,
182: l_OKL_TAX_LINES_rec.overridden_flag,
175: l_OKL_TAX_LINES_rec.tax_due_date,
176: l_OKL_TAX_LINES_rec.tax_type,
177: l_OKL_TAX_LINES_rec.tax_rate_code_id,
178: l_OKL_TAX_LINES_rec.tax_rate_code,
179: l_OKL_TAX_LINES_rec.taxable_amount,
180: l_OKL_TAX_LINES_rec.tax_exemption_id,
181: l_OKL_TAX_LINES_rec.manually_entered_flag,
182: l_OKL_TAX_LINES_rec.overridden_flag,
183: l_OKL_TAX_LINES_rec.calculated_tax_amount,
176: l_OKL_TAX_LINES_rec.tax_type,
177: l_OKL_TAX_LINES_rec.tax_rate_code_id,
178: l_OKL_TAX_LINES_rec.tax_rate_code,
179: l_OKL_TAX_LINES_rec.taxable_amount,
180: l_OKL_TAX_LINES_rec.tax_exemption_id,
181: l_OKL_TAX_LINES_rec.manually_entered_flag,
182: l_OKL_TAX_LINES_rec.overridden_flag,
183: l_OKL_TAX_LINES_rec.calculated_tax_amount,
184: l_OKL_TAX_LINES_rec.tax_rate,
177: l_OKL_TAX_LINES_rec.tax_rate_code_id,
178: l_OKL_TAX_LINES_rec.tax_rate_code,
179: l_OKL_TAX_LINES_rec.taxable_amount,
180: l_OKL_TAX_LINES_rec.tax_exemption_id,
181: l_OKL_TAX_LINES_rec.manually_entered_flag,
182: l_OKL_TAX_LINES_rec.overridden_flag,
183: l_OKL_TAX_LINES_rec.calculated_tax_amount,
184: l_OKL_TAX_LINES_rec.tax_rate,
185: l_OKL_TAX_LINES_rec.tax_amount,
178: l_OKL_TAX_LINES_rec.tax_rate_code,
179: l_OKL_TAX_LINES_rec.taxable_amount,
180: l_OKL_TAX_LINES_rec.tax_exemption_id,
181: l_OKL_TAX_LINES_rec.manually_entered_flag,
182: l_OKL_TAX_LINES_rec.overridden_flag,
183: l_OKL_TAX_LINES_rec.calculated_tax_amount,
184: l_OKL_TAX_LINES_rec.tax_rate,
185: l_OKL_TAX_LINES_rec.tax_amount,
186: l_OKL_TAX_LINES_rec.sales_tax_id,
179: l_OKL_TAX_LINES_rec.taxable_amount,
180: l_OKL_TAX_LINES_rec.tax_exemption_id,
181: l_OKL_TAX_LINES_rec.manually_entered_flag,
182: l_OKL_TAX_LINES_rec.overridden_flag,
183: l_OKL_TAX_LINES_rec.calculated_tax_amount,
184: l_OKL_TAX_LINES_rec.tax_rate,
185: l_OKL_TAX_LINES_rec.tax_amount,
186: l_OKL_TAX_LINES_rec.sales_tax_id,
187: l_OKL_TAX_LINES_rec.source_trx_id,
180: l_OKL_TAX_LINES_rec.tax_exemption_id,
181: l_OKL_TAX_LINES_rec.manually_entered_flag,
182: l_OKL_TAX_LINES_rec.overridden_flag,
183: l_OKL_TAX_LINES_rec.calculated_tax_amount,
184: l_OKL_TAX_LINES_rec.tax_rate,
185: l_OKL_TAX_LINES_rec.tax_amount,
186: l_OKL_TAX_LINES_rec.sales_tax_id,
187: l_OKL_TAX_LINES_rec.source_trx_id,
188: l_OKL_TAX_LINES_rec.org_id,
181: l_OKL_TAX_LINES_rec.manually_entered_flag,
182: l_OKL_TAX_LINES_rec.overridden_flag,
183: l_OKL_TAX_LINES_rec.calculated_tax_amount,
184: l_OKL_TAX_LINES_rec.tax_rate,
185: l_OKL_TAX_LINES_rec.tax_amount,
186: l_OKL_TAX_LINES_rec.sales_tax_id,
187: l_OKL_TAX_LINES_rec.source_trx_id,
188: l_OKL_TAX_LINES_rec.org_id,
189: l_OKL_TAX_LINES_rec.history_yn,
182: l_OKL_TAX_LINES_rec.overridden_flag,
183: l_OKL_TAX_LINES_rec.calculated_tax_amount,
184: l_OKL_TAX_LINES_rec.tax_rate,
185: l_OKL_TAX_LINES_rec.tax_amount,
186: l_OKL_TAX_LINES_rec.sales_tax_id,
187: l_OKL_TAX_LINES_rec.source_trx_id,
188: l_OKL_TAX_LINES_rec.org_id,
189: l_OKL_TAX_LINES_rec.history_yn,
190: l_OKL_TAX_LINES_rec.actual_yn,
183: l_OKL_TAX_LINES_rec.calculated_tax_amount,
184: l_OKL_TAX_LINES_rec.tax_rate,
185: l_OKL_TAX_LINES_rec.tax_amount,
186: l_OKL_TAX_LINES_rec.sales_tax_id,
187: l_OKL_TAX_LINES_rec.source_trx_id,
188: l_OKL_TAX_LINES_rec.org_id,
189: l_OKL_TAX_LINES_rec.history_yn,
190: l_OKL_TAX_LINES_rec.actual_yn,
191: l_OKL_TAX_LINES_rec.source_name,
184: l_OKL_TAX_LINES_rec.tax_rate,
185: l_OKL_TAX_LINES_rec.tax_amount,
186: l_OKL_TAX_LINES_rec.sales_tax_id,
187: l_OKL_TAX_LINES_rec.source_trx_id,
188: l_OKL_TAX_LINES_rec.org_id,
189: l_OKL_TAX_LINES_rec.history_yn,
190: l_OKL_TAX_LINES_rec.actual_yn,
191: l_OKL_TAX_LINES_rec.source_name,
192: l_OKL_TAX_LINES_rec.trq_id,
185: l_OKL_TAX_LINES_rec.tax_amount,
186: l_OKL_TAX_LINES_rec.sales_tax_id,
187: l_OKL_TAX_LINES_rec.source_trx_id,
188: l_OKL_TAX_LINES_rec.org_id,
189: l_OKL_TAX_LINES_rec.history_yn,
190: l_OKL_TAX_LINES_rec.actual_yn,
191: l_OKL_TAX_LINES_rec.source_name,
192: l_OKL_TAX_LINES_rec.trq_id,
193: l_OKL_TAX_LINES_rec.program_id,
186: l_OKL_TAX_LINES_rec.sales_tax_id,
187: l_OKL_TAX_LINES_rec.source_trx_id,
188: l_OKL_TAX_LINES_rec.org_id,
189: l_OKL_TAX_LINES_rec.history_yn,
190: l_OKL_TAX_LINES_rec.actual_yn,
191: l_OKL_TAX_LINES_rec.source_name,
192: l_OKL_TAX_LINES_rec.trq_id,
193: l_OKL_TAX_LINES_rec.program_id,
194: l_OKL_TAX_LINES_rec.request_id,
187: l_OKL_TAX_LINES_rec.source_trx_id,
188: l_OKL_TAX_LINES_rec.org_id,
189: l_OKL_TAX_LINES_rec.history_yn,
190: l_OKL_TAX_LINES_rec.actual_yn,
191: l_OKL_TAX_LINES_rec.source_name,
192: l_OKL_TAX_LINES_rec.trq_id,
193: l_OKL_TAX_LINES_rec.program_id,
194: l_OKL_TAX_LINES_rec.request_id,
195: l_OKL_TAX_LINES_rec.program_application_id,
188: l_OKL_TAX_LINES_rec.org_id,
189: l_OKL_TAX_LINES_rec.history_yn,
190: l_OKL_TAX_LINES_rec.actual_yn,
191: l_OKL_TAX_LINES_rec.source_name,
192: l_OKL_TAX_LINES_rec.trq_id,
193: l_OKL_TAX_LINES_rec.program_id,
194: l_OKL_TAX_LINES_rec.request_id,
195: l_OKL_TAX_LINES_rec.program_application_id,
196: l_OKL_TAX_LINES_rec.program_update_date,
189: l_OKL_TAX_LINES_rec.history_yn,
190: l_OKL_TAX_LINES_rec.actual_yn,
191: l_OKL_TAX_LINES_rec.source_name,
192: l_OKL_TAX_LINES_rec.trq_id,
193: l_OKL_TAX_LINES_rec.program_id,
194: l_OKL_TAX_LINES_rec.request_id,
195: l_OKL_TAX_LINES_rec.program_application_id,
196: l_OKL_TAX_LINES_rec.program_update_date,
197: l_OKL_TAX_LINES_rec.attribute_category,
190: l_OKL_TAX_LINES_rec.actual_yn,
191: l_OKL_TAX_LINES_rec.source_name,
192: l_OKL_TAX_LINES_rec.trq_id,
193: l_OKL_TAX_LINES_rec.program_id,
194: l_OKL_TAX_LINES_rec.request_id,
195: l_OKL_TAX_LINES_rec.program_application_id,
196: l_OKL_TAX_LINES_rec.program_update_date,
197: l_OKL_TAX_LINES_rec.attribute_category,
198: l_OKL_TAX_LINES_rec.attribute1,
191: l_OKL_TAX_LINES_rec.source_name,
192: l_OKL_TAX_LINES_rec.trq_id,
193: l_OKL_TAX_LINES_rec.program_id,
194: l_OKL_TAX_LINES_rec.request_id,
195: l_OKL_TAX_LINES_rec.program_application_id,
196: l_OKL_TAX_LINES_rec.program_update_date,
197: l_OKL_TAX_LINES_rec.attribute_category,
198: l_OKL_TAX_LINES_rec.attribute1,
199: l_OKL_TAX_LINES_rec.attribute2,
192: l_OKL_TAX_LINES_rec.trq_id,
193: l_OKL_TAX_LINES_rec.program_id,
194: l_OKL_TAX_LINES_rec.request_id,
195: l_OKL_TAX_LINES_rec.program_application_id,
196: l_OKL_TAX_LINES_rec.program_update_date,
197: l_OKL_TAX_LINES_rec.attribute_category,
198: l_OKL_TAX_LINES_rec.attribute1,
199: l_OKL_TAX_LINES_rec.attribute2,
200: l_OKL_TAX_LINES_rec.attribute3,
193: l_OKL_TAX_LINES_rec.program_id,
194: l_OKL_TAX_LINES_rec.request_id,
195: l_OKL_TAX_LINES_rec.program_application_id,
196: l_OKL_TAX_LINES_rec.program_update_date,
197: l_OKL_TAX_LINES_rec.attribute_category,
198: l_OKL_TAX_LINES_rec.attribute1,
199: l_OKL_TAX_LINES_rec.attribute2,
200: l_OKL_TAX_LINES_rec.attribute3,
201: l_OKL_TAX_LINES_rec.attribute4,
194: l_OKL_TAX_LINES_rec.request_id,
195: l_OKL_TAX_LINES_rec.program_application_id,
196: l_OKL_TAX_LINES_rec.program_update_date,
197: l_OKL_TAX_LINES_rec.attribute_category,
198: l_OKL_TAX_LINES_rec.attribute1,
199: l_OKL_TAX_LINES_rec.attribute2,
200: l_OKL_TAX_LINES_rec.attribute3,
201: l_OKL_TAX_LINES_rec.attribute4,
202: l_OKL_TAX_LINES_rec.attribute5,
195: l_OKL_TAX_LINES_rec.program_application_id,
196: l_OKL_TAX_LINES_rec.program_update_date,
197: l_OKL_TAX_LINES_rec.attribute_category,
198: l_OKL_TAX_LINES_rec.attribute1,
199: l_OKL_TAX_LINES_rec.attribute2,
200: l_OKL_TAX_LINES_rec.attribute3,
201: l_OKL_TAX_LINES_rec.attribute4,
202: l_OKL_TAX_LINES_rec.attribute5,
203: l_OKL_TAX_LINES_rec.attribute6,
196: l_OKL_TAX_LINES_rec.program_update_date,
197: l_OKL_TAX_LINES_rec.attribute_category,
198: l_OKL_TAX_LINES_rec.attribute1,
199: l_OKL_TAX_LINES_rec.attribute2,
200: l_OKL_TAX_LINES_rec.attribute3,
201: l_OKL_TAX_LINES_rec.attribute4,
202: l_OKL_TAX_LINES_rec.attribute5,
203: l_OKL_TAX_LINES_rec.attribute6,
204: l_OKL_TAX_LINES_rec.attribute7,
197: l_OKL_TAX_LINES_rec.attribute_category,
198: l_OKL_TAX_LINES_rec.attribute1,
199: l_OKL_TAX_LINES_rec.attribute2,
200: l_OKL_TAX_LINES_rec.attribute3,
201: l_OKL_TAX_LINES_rec.attribute4,
202: l_OKL_TAX_LINES_rec.attribute5,
203: l_OKL_TAX_LINES_rec.attribute6,
204: l_OKL_TAX_LINES_rec.attribute7,
205: l_OKL_TAX_LINES_rec.attribute8,
198: l_OKL_TAX_LINES_rec.attribute1,
199: l_OKL_TAX_LINES_rec.attribute2,
200: l_OKL_TAX_LINES_rec.attribute3,
201: l_OKL_TAX_LINES_rec.attribute4,
202: l_OKL_TAX_LINES_rec.attribute5,
203: l_OKL_TAX_LINES_rec.attribute6,
204: l_OKL_TAX_LINES_rec.attribute7,
205: l_OKL_TAX_LINES_rec.attribute8,
206: l_OKL_TAX_LINES_rec.attribute9,
199: l_OKL_TAX_LINES_rec.attribute2,
200: l_OKL_TAX_LINES_rec.attribute3,
201: l_OKL_TAX_LINES_rec.attribute4,
202: l_OKL_TAX_LINES_rec.attribute5,
203: l_OKL_TAX_LINES_rec.attribute6,
204: l_OKL_TAX_LINES_rec.attribute7,
205: l_OKL_TAX_LINES_rec.attribute8,
206: l_OKL_TAX_LINES_rec.attribute9,
207: l_OKL_TAX_LINES_rec.attribute10,
200: l_OKL_TAX_LINES_rec.attribute3,
201: l_OKL_TAX_LINES_rec.attribute4,
202: l_OKL_TAX_LINES_rec.attribute5,
203: l_OKL_TAX_LINES_rec.attribute6,
204: l_OKL_TAX_LINES_rec.attribute7,
205: l_OKL_TAX_LINES_rec.attribute8,
206: l_OKL_TAX_LINES_rec.attribute9,
207: l_OKL_TAX_LINES_rec.attribute10,
208: l_OKL_TAX_LINES_rec.attribute11,
201: l_OKL_TAX_LINES_rec.attribute4,
202: l_OKL_TAX_LINES_rec.attribute5,
203: l_OKL_TAX_LINES_rec.attribute6,
204: l_OKL_TAX_LINES_rec.attribute7,
205: l_OKL_TAX_LINES_rec.attribute8,
206: l_OKL_TAX_LINES_rec.attribute9,
207: l_OKL_TAX_LINES_rec.attribute10,
208: l_OKL_TAX_LINES_rec.attribute11,
209: l_OKL_TAX_LINES_rec.attribute12,
202: l_OKL_TAX_LINES_rec.attribute5,
203: l_OKL_TAX_LINES_rec.attribute6,
204: l_OKL_TAX_LINES_rec.attribute7,
205: l_OKL_TAX_LINES_rec.attribute8,
206: l_OKL_TAX_LINES_rec.attribute9,
207: l_OKL_TAX_LINES_rec.attribute10,
208: l_OKL_TAX_LINES_rec.attribute11,
209: l_OKL_TAX_LINES_rec.attribute12,
210: l_OKL_TAX_LINES_rec.attribute13,
203: l_OKL_TAX_LINES_rec.attribute6,
204: l_OKL_TAX_LINES_rec.attribute7,
205: l_OKL_TAX_LINES_rec.attribute8,
206: l_OKL_TAX_LINES_rec.attribute9,
207: l_OKL_TAX_LINES_rec.attribute10,
208: l_OKL_TAX_LINES_rec.attribute11,
209: l_OKL_TAX_LINES_rec.attribute12,
210: l_OKL_TAX_LINES_rec.attribute13,
211: l_OKL_TAX_LINES_rec.attribute14,
204: l_OKL_TAX_LINES_rec.attribute7,
205: l_OKL_TAX_LINES_rec.attribute8,
206: l_OKL_TAX_LINES_rec.attribute9,
207: l_OKL_TAX_LINES_rec.attribute10,
208: l_OKL_TAX_LINES_rec.attribute11,
209: l_OKL_TAX_LINES_rec.attribute12,
210: l_OKL_TAX_LINES_rec.attribute13,
211: l_OKL_TAX_LINES_rec.attribute14,
212: l_OKL_TAX_LINES_rec.attribute15,
205: l_OKL_TAX_LINES_rec.attribute8,
206: l_OKL_TAX_LINES_rec.attribute9,
207: l_OKL_TAX_LINES_rec.attribute10,
208: l_OKL_TAX_LINES_rec.attribute11,
209: l_OKL_TAX_LINES_rec.attribute12,
210: l_OKL_TAX_LINES_rec.attribute13,
211: l_OKL_TAX_LINES_rec.attribute14,
212: l_OKL_TAX_LINES_rec.attribute15,
213: l_OKL_TAX_LINES_rec.created_by,
206: l_OKL_TAX_LINES_rec.attribute9,
207: l_OKL_TAX_LINES_rec.attribute10,
208: l_OKL_TAX_LINES_rec.attribute11,
209: l_OKL_TAX_LINES_rec.attribute12,
210: l_OKL_TAX_LINES_rec.attribute13,
211: l_OKL_TAX_LINES_rec.attribute14,
212: l_OKL_TAX_LINES_rec.attribute15,
213: l_OKL_TAX_LINES_rec.created_by,
214: l_OKL_TAX_LINES_rec.creation_date,
207: l_OKL_TAX_LINES_rec.attribute10,
208: l_OKL_TAX_LINES_rec.attribute11,
209: l_OKL_TAX_LINES_rec.attribute12,
210: l_OKL_TAX_LINES_rec.attribute13,
211: l_OKL_TAX_LINES_rec.attribute14,
212: l_OKL_TAX_LINES_rec.attribute15,
213: l_OKL_TAX_LINES_rec.created_by,
214: l_OKL_TAX_LINES_rec.creation_date,
215: l_OKL_TAX_LINES_rec.last_updated_by,
208: l_OKL_TAX_LINES_rec.attribute11,
209: l_OKL_TAX_LINES_rec.attribute12,
210: l_OKL_TAX_LINES_rec.attribute13,
211: l_OKL_TAX_LINES_rec.attribute14,
212: l_OKL_TAX_LINES_rec.attribute15,
213: l_OKL_TAX_LINES_rec.created_by,
214: l_OKL_TAX_LINES_rec.creation_date,
215: l_OKL_TAX_LINES_rec.last_updated_by,
216: l_OKL_TAX_LINES_rec.last_update_date,
209: l_OKL_TAX_LINES_rec.attribute12,
210: l_OKL_TAX_LINES_rec.attribute13,
211: l_OKL_TAX_LINES_rec.attribute14,
212: l_OKL_TAX_LINES_rec.attribute15,
213: l_OKL_TAX_LINES_rec.created_by,
214: l_OKL_TAX_LINES_rec.creation_date,
215: l_OKL_TAX_LINES_rec.last_updated_by,
216: l_OKL_TAX_LINES_rec.last_update_date,
217: l_OKL_TAX_LINES_rec.last_update_login;
210: l_OKL_TAX_LINES_rec.attribute13,
211: l_OKL_TAX_LINES_rec.attribute14,
212: l_OKL_TAX_LINES_rec.attribute15,
213: l_OKL_TAX_LINES_rec.created_by,
214: l_OKL_TAX_LINES_rec.creation_date,
215: l_OKL_TAX_LINES_rec.last_updated_by,
216: l_OKL_TAX_LINES_rec.last_update_date,
217: l_OKL_TAX_LINES_rec.last_update_login;
218: x_no_data_found := okl_taxv_pk_csr%NOTFOUND;
211: l_OKL_TAX_LINES_rec.attribute14,
212: l_OKL_TAX_LINES_rec.attribute15,
213: l_OKL_TAX_LINES_rec.created_by,
214: l_OKL_TAX_LINES_rec.creation_date,
215: l_OKL_TAX_LINES_rec.last_updated_by,
216: l_OKL_TAX_LINES_rec.last_update_date,
217: l_OKL_TAX_LINES_rec.last_update_login;
218: x_no_data_found := okl_taxv_pk_csr%NOTFOUND;
219: CLOSE okl_taxv_pk_csr;
212: l_OKL_TAX_LINES_rec.attribute15,
213: l_OKL_TAX_LINES_rec.created_by,
214: l_OKL_TAX_LINES_rec.creation_date,
215: l_OKL_TAX_LINES_rec.last_updated_by,
216: l_OKL_TAX_LINES_rec.last_update_date,
217: l_OKL_TAX_LINES_rec.last_update_login;
218: x_no_data_found := okl_taxv_pk_csr%NOTFOUND;
219: CLOSE okl_taxv_pk_csr;
220: RETURN(l_OKL_TAX_LINES_rec);
213: l_OKL_TAX_LINES_rec.created_by,
214: l_OKL_TAX_LINES_rec.creation_date,
215: l_OKL_TAX_LINES_rec.last_updated_by,
216: l_OKL_TAX_LINES_rec.last_update_date,
217: l_OKL_TAX_LINES_rec.last_update_login;
218: x_no_data_found := okl_taxv_pk_csr%NOTFOUND;
219: CLOSE okl_taxv_pk_csr;
220: RETURN(l_OKL_TAX_LINES_rec);
221: END get_rec;
216: l_OKL_TAX_LINES_rec.last_update_date,
217: l_OKL_TAX_LINES_rec.last_update_login;
218: x_no_data_found := okl_taxv_pk_csr%NOTFOUND;
219: CLOSE okl_taxv_pk_csr;
220: RETURN(l_OKL_TAX_LINES_rec);
221: END get_rec;
222:
223: ------------------------------------------------------------------
224: -- This version of get_rec sets error messages if no data found --
223: ------------------------------------------------------------------
224: -- This version of get_rec sets error messages if no data found --
225: ------------------------------------------------------------------
226: FUNCTION get_rec (
227: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type,
228: x_return_status OUT NOCOPY VARCHAR2
229: ) RETURN OKL_TAX_LINES_rec_type IS
230: l_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type;
231: l_row_notfound BOOLEAN := TRUE;
225: ------------------------------------------------------------------
226: FUNCTION get_rec (
227: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type,
228: x_return_status OUT NOCOPY VARCHAR2
229: ) RETURN OKL_TAX_LINES_rec_type IS
230: l_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type;
231: l_row_notfound BOOLEAN := TRUE;
232: BEGIN
233: x_return_status := OKC_API.G_RET_STS_SUCCESS;
226: FUNCTION get_rec (
227: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type,
228: x_return_status OUT NOCOPY VARCHAR2
229: ) RETURN OKL_TAX_LINES_rec_type IS
230: l_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type;
231: l_row_notfound BOOLEAN := TRUE;
232: BEGIN
233: x_return_status := OKC_API.G_RET_STS_SUCCESS;
234: l_OKL_TAX_LINES_rec := get_rec(p_OKL_TAX_LINES_rec, l_row_notfound);
230: l_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type;
231: l_row_notfound BOOLEAN := TRUE;
232: BEGIN
233: x_return_status := OKC_API.G_RET_STS_SUCCESS;
234: l_OKL_TAX_LINES_rec := get_rec(p_OKL_TAX_LINES_rec, l_row_notfound);
235: IF (l_row_notfound) THEN
236: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
237: x_return_status := OKC_API.G_RET_STS_ERROR;
238: END IF;
235: IF (l_row_notfound) THEN
236: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
237: x_return_status := OKC_API.G_RET_STS_ERROR;
238: END IF;
239: RETURN(l_OKL_TAX_LINES_rec);
240: END get_rec;
241: -----------------------------------------------------------
242: -- So we don't have to pass an "l_row_notfound" variable --
243: -----------------------------------------------------------
241: -----------------------------------------------------------
242: -- So we don't have to pass an "l_row_notfound" variable --
243: -----------------------------------------------------------
244: FUNCTION get_rec (
245: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type
246: ) RETURN OKL_TAX_LINES_rec_type IS
247: l_row_not_found BOOLEAN := TRUE;
248: BEGIN
249: RETURN(get_rec(p_OKL_TAX_LINES_rec, l_row_not_found));
242: -- So we don't have to pass an "l_row_notfound" variable --
243: -----------------------------------------------------------
244: FUNCTION get_rec (
245: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type
246: ) RETURN OKL_TAX_LINES_rec_type IS
247: l_row_not_found BOOLEAN := TRUE;
248: BEGIN
249: RETURN(get_rec(p_OKL_TAX_LINES_rec, l_row_not_found));
250: END get_rec;
245: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type
246: ) RETURN OKL_TAX_LINES_rec_type IS
247: l_row_not_found BOOLEAN := TRUE;
248: BEGIN
249: RETURN(get_rec(p_OKL_TAX_LINES_rec, l_row_not_found));
250: END get_rec;
251: ---------------------------------------------------------------------------
252: -- FUNCTION get_rec for: OKL_TAX_LINES
253: ---------------------------------------------------------------------------
248: BEGIN
249: RETURN(get_rec(p_OKL_TAX_LINES_rec, l_row_not_found));
250: END get_rec;
251: ---------------------------------------------------------------------------
252: -- FUNCTION get_rec for: OKL_TAX_LINES
253: ---------------------------------------------------------------------------
254: FUNCTION get_rec (
255: p_tax_rec IN tax_rec_type,
256: x_no_data_found OUT NOCOPY BOOLEAN
306: CREATION_DATE,
307: LAST_UPDATED_BY,
308: LAST_UPDATE_DATE,
309: LAST_UPDATE_LOGIN
310: FROM Okl_Tax_Lines
311: WHERE okl_tax_lines.id = p_id;
312: l_okl_tax_pk okl_tax_pk_csr%ROWTYPE;
313: l_tax_rec tax_rec_type;
314: BEGIN
307: LAST_UPDATED_BY,
308: LAST_UPDATE_DATE,
309: LAST_UPDATE_LOGIN
310: FROM Okl_Tax_Lines
311: WHERE okl_tax_lines.id = p_id;
312: l_okl_tax_pk okl_tax_pk_csr%ROWTYPE;
313: l_tax_rec tax_rec_type;
314: BEGIN
315: x_no_data_found := TRUE;
399: BEGIN
400: RETURN(get_rec(p_tax_rec, l_row_not_found));
401: END get_rec;
402: ---------------------------------------------------------------------------
403: -- FUNCTION null_out_defaults for: OKL_TAX_LINES_V
404: ---------------------------------------------------------------------------
405: FUNCTION null_out_defaults (
406: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type
407: ) RETURN OKL_TAX_LINES_rec_type IS
402: ---------------------------------------------------------------------------
403: -- FUNCTION null_out_defaults for: OKL_TAX_LINES_V
404: ---------------------------------------------------------------------------
405: FUNCTION null_out_defaults (
406: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type
407: ) RETURN OKL_TAX_LINES_rec_type IS
408: l_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type := p_OKL_TAX_LINES_rec;
409: BEGIN
410: IF (l_OKL_TAX_LINES_rec.id = OKC_API.G_MISS_NUM ) THEN
403: -- FUNCTION null_out_defaults for: OKL_TAX_LINES_V
404: ---------------------------------------------------------------------------
405: FUNCTION null_out_defaults (
406: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type
407: ) RETURN OKL_TAX_LINES_rec_type IS
408: l_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type := p_OKL_TAX_LINES_rec;
409: BEGIN
410: IF (l_OKL_TAX_LINES_rec.id = OKC_API.G_MISS_NUM ) THEN
411: l_OKL_TAX_LINES_rec.id := NULL;
404: ---------------------------------------------------------------------------
405: FUNCTION null_out_defaults (
406: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type
407: ) RETURN OKL_TAX_LINES_rec_type IS
408: l_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type := p_OKL_TAX_LINES_rec;
409: BEGIN
410: IF (l_OKL_TAX_LINES_rec.id = OKC_API.G_MISS_NUM ) THEN
411: l_OKL_TAX_LINES_rec.id := NULL;
412: END IF;
406: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type
407: ) RETURN OKL_TAX_LINES_rec_type IS
408: l_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type := p_OKL_TAX_LINES_rec;
409: BEGIN
410: IF (l_OKL_TAX_LINES_rec.id = OKC_API.G_MISS_NUM ) THEN
411: l_OKL_TAX_LINES_rec.id := NULL;
412: END IF;
413: IF (l_OKL_TAX_LINES_rec.khr_id = OKC_API.G_MISS_NUM ) THEN
414: l_OKL_TAX_LINES_rec.khr_id := NULL;
407: ) RETURN OKL_TAX_LINES_rec_type IS
408: l_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type := p_OKL_TAX_LINES_rec;
409: BEGIN
410: IF (l_OKL_TAX_LINES_rec.id = OKC_API.G_MISS_NUM ) THEN
411: l_OKL_TAX_LINES_rec.id := NULL;
412: END IF;
413: IF (l_OKL_TAX_LINES_rec.khr_id = OKC_API.G_MISS_NUM ) THEN
414: l_OKL_TAX_LINES_rec.khr_id := NULL;
415: END IF;
409: BEGIN
410: IF (l_OKL_TAX_LINES_rec.id = OKC_API.G_MISS_NUM ) THEN
411: l_OKL_TAX_LINES_rec.id := NULL;
412: END IF;
413: IF (l_OKL_TAX_LINES_rec.khr_id = OKC_API.G_MISS_NUM ) THEN
414: l_OKL_TAX_LINES_rec.khr_id := NULL;
415: END IF;
416: IF (l_OKL_TAX_LINES_rec.kle_id = OKC_API.G_MISS_NUM ) THEN
417: l_OKL_TAX_LINES_rec.kle_id := NULL;
410: IF (l_OKL_TAX_LINES_rec.id = OKC_API.G_MISS_NUM ) THEN
411: l_OKL_TAX_LINES_rec.id := NULL;
412: END IF;
413: IF (l_OKL_TAX_LINES_rec.khr_id = OKC_API.G_MISS_NUM ) THEN
414: l_OKL_TAX_LINES_rec.khr_id := NULL;
415: END IF;
416: IF (l_OKL_TAX_LINES_rec.kle_id = OKC_API.G_MISS_NUM ) THEN
417: l_OKL_TAX_LINES_rec.kle_id := NULL;
418: END IF;
412: END IF;
413: IF (l_OKL_TAX_LINES_rec.khr_id = OKC_API.G_MISS_NUM ) THEN
414: l_OKL_TAX_LINES_rec.khr_id := NULL;
415: END IF;
416: IF (l_OKL_TAX_LINES_rec.kle_id = OKC_API.G_MISS_NUM ) THEN
417: l_OKL_TAX_LINES_rec.kle_id := NULL;
418: END IF;
419: IF (l_OKL_TAX_LINES_rec.asset_id = OKC_API.G_MISS_NUM ) THEN
420: l_OKL_TAX_LINES_rec.asset_id := NULL;
413: IF (l_OKL_TAX_LINES_rec.khr_id = OKC_API.G_MISS_NUM ) THEN
414: l_OKL_TAX_LINES_rec.khr_id := NULL;
415: END IF;
416: IF (l_OKL_TAX_LINES_rec.kle_id = OKC_API.G_MISS_NUM ) THEN
417: l_OKL_TAX_LINES_rec.kle_id := NULL;
418: END IF;
419: IF (l_OKL_TAX_LINES_rec.asset_id = OKC_API.G_MISS_NUM ) THEN
420: l_OKL_TAX_LINES_rec.asset_id := NULL;
421: END IF;
415: END IF;
416: IF (l_OKL_TAX_LINES_rec.kle_id = OKC_API.G_MISS_NUM ) THEN
417: l_OKL_TAX_LINES_rec.kle_id := NULL;
418: END IF;
419: IF (l_OKL_TAX_LINES_rec.asset_id = OKC_API.G_MISS_NUM ) THEN
420: l_OKL_TAX_LINES_rec.asset_id := NULL;
421: END IF;
422: IF (l_OKL_TAX_LINES_rec.asset_number = OKC_API.G_MISS_CHAR ) THEN
423: l_OKL_TAX_LINES_rec.asset_number := NULL;
416: IF (l_OKL_TAX_LINES_rec.kle_id = OKC_API.G_MISS_NUM ) THEN
417: l_OKL_TAX_LINES_rec.kle_id := NULL;
418: END IF;
419: IF (l_OKL_TAX_LINES_rec.asset_id = OKC_API.G_MISS_NUM ) THEN
420: l_OKL_TAX_LINES_rec.asset_id := NULL;
421: END IF;
422: IF (l_OKL_TAX_LINES_rec.asset_number = OKC_API.G_MISS_CHAR ) THEN
423: l_OKL_TAX_LINES_rec.asset_number := NULL;
424: END IF;
418: END IF;
419: IF (l_OKL_TAX_LINES_rec.asset_id = OKC_API.G_MISS_NUM ) THEN
420: l_OKL_TAX_LINES_rec.asset_id := NULL;
421: END IF;
422: IF (l_OKL_TAX_LINES_rec.asset_number = OKC_API.G_MISS_CHAR ) THEN
423: l_OKL_TAX_LINES_rec.asset_number := NULL;
424: END IF;
425: IF (l_OKL_TAX_LINES_rec.tax_line_type = OKC_API.G_MISS_CHAR ) THEN
426: l_OKL_TAX_LINES_rec.tax_line_type := NULL;
419: IF (l_OKL_TAX_LINES_rec.asset_id = OKC_API.G_MISS_NUM ) THEN
420: l_OKL_TAX_LINES_rec.asset_id := NULL;
421: END IF;
422: IF (l_OKL_TAX_LINES_rec.asset_number = OKC_API.G_MISS_CHAR ) THEN
423: l_OKL_TAX_LINES_rec.asset_number := NULL;
424: END IF;
425: IF (l_OKL_TAX_LINES_rec.tax_line_type = OKC_API.G_MISS_CHAR ) THEN
426: l_OKL_TAX_LINES_rec.tax_line_type := NULL;
427: END IF;
421: END IF;
422: IF (l_OKL_TAX_LINES_rec.asset_number = OKC_API.G_MISS_CHAR ) THEN
423: l_OKL_TAX_LINES_rec.asset_number := NULL;
424: END IF;
425: IF (l_OKL_TAX_LINES_rec.tax_line_type = OKC_API.G_MISS_CHAR ) THEN
426: l_OKL_TAX_LINES_rec.tax_line_type := NULL;
427: END IF;
428: IF (l_OKL_TAX_LINES_rec.sel_id = OKC_API.G_MISS_NUM ) THEN
429: l_OKL_TAX_LINES_rec.sel_id := NULL;
422: IF (l_OKL_TAX_LINES_rec.asset_number = OKC_API.G_MISS_CHAR ) THEN
423: l_OKL_TAX_LINES_rec.asset_number := NULL;
424: END IF;
425: IF (l_OKL_TAX_LINES_rec.tax_line_type = OKC_API.G_MISS_CHAR ) THEN
426: l_OKL_TAX_LINES_rec.tax_line_type := NULL;
427: END IF;
428: IF (l_OKL_TAX_LINES_rec.sel_id = OKC_API.G_MISS_NUM ) THEN
429: l_OKL_TAX_LINES_rec.sel_id := NULL;
430: END IF;
424: END IF;
425: IF (l_OKL_TAX_LINES_rec.tax_line_type = OKC_API.G_MISS_CHAR ) THEN
426: l_OKL_TAX_LINES_rec.tax_line_type := NULL;
427: END IF;
428: IF (l_OKL_TAX_LINES_rec.sel_id = OKC_API.G_MISS_NUM ) THEN
429: l_OKL_TAX_LINES_rec.sel_id := NULL;
430: END IF;
431: IF (l_OKL_TAX_LINES_rec.tax_due_date = OKC_API.G_MISS_DATE ) THEN
432: l_OKL_TAX_LINES_rec.tax_due_date := NULL;
425: IF (l_OKL_TAX_LINES_rec.tax_line_type = OKC_API.G_MISS_CHAR ) THEN
426: l_OKL_TAX_LINES_rec.tax_line_type := NULL;
427: END IF;
428: IF (l_OKL_TAX_LINES_rec.sel_id = OKC_API.G_MISS_NUM ) THEN
429: l_OKL_TAX_LINES_rec.sel_id := NULL;
430: END IF;
431: IF (l_OKL_TAX_LINES_rec.tax_due_date = OKC_API.G_MISS_DATE ) THEN
432: l_OKL_TAX_LINES_rec.tax_due_date := NULL;
433: END IF;
427: END IF;
428: IF (l_OKL_TAX_LINES_rec.sel_id = OKC_API.G_MISS_NUM ) THEN
429: l_OKL_TAX_LINES_rec.sel_id := NULL;
430: END IF;
431: IF (l_OKL_TAX_LINES_rec.tax_due_date = OKC_API.G_MISS_DATE ) THEN
432: l_OKL_TAX_LINES_rec.tax_due_date := NULL;
433: END IF;
434: IF (l_OKL_TAX_LINES_rec.tax_type = OKC_API.G_MISS_NUM ) THEN
435: l_OKL_TAX_LINES_rec.tax_type := NULL;
428: IF (l_OKL_TAX_LINES_rec.sel_id = OKC_API.G_MISS_NUM ) THEN
429: l_OKL_TAX_LINES_rec.sel_id := NULL;
430: END IF;
431: IF (l_OKL_TAX_LINES_rec.tax_due_date = OKC_API.G_MISS_DATE ) THEN
432: l_OKL_TAX_LINES_rec.tax_due_date := NULL;
433: END IF;
434: IF (l_OKL_TAX_LINES_rec.tax_type = OKC_API.G_MISS_NUM ) THEN
435: l_OKL_TAX_LINES_rec.tax_type := NULL;
436: END IF;
430: END IF;
431: IF (l_OKL_TAX_LINES_rec.tax_due_date = OKC_API.G_MISS_DATE ) THEN
432: l_OKL_TAX_LINES_rec.tax_due_date := NULL;
433: END IF;
434: IF (l_OKL_TAX_LINES_rec.tax_type = OKC_API.G_MISS_NUM ) THEN
435: l_OKL_TAX_LINES_rec.tax_type := NULL;
436: END IF;
437: IF (l_OKL_TAX_LINES_rec.tax_rate_code_id = OKC_API.G_MISS_NUM ) THEN
438: l_OKL_TAX_LINES_rec.tax_rate_code_id := NULL;
431: IF (l_OKL_TAX_LINES_rec.tax_due_date = OKC_API.G_MISS_DATE ) THEN
432: l_OKL_TAX_LINES_rec.tax_due_date := NULL;
433: END IF;
434: IF (l_OKL_TAX_LINES_rec.tax_type = OKC_API.G_MISS_NUM ) THEN
435: l_OKL_TAX_LINES_rec.tax_type := NULL;
436: END IF;
437: IF (l_OKL_TAX_LINES_rec.tax_rate_code_id = OKC_API.G_MISS_NUM ) THEN
438: l_OKL_TAX_LINES_rec.tax_rate_code_id := NULL;
439: END IF;
433: END IF;
434: IF (l_OKL_TAX_LINES_rec.tax_type = OKC_API.G_MISS_NUM ) THEN
435: l_OKL_TAX_LINES_rec.tax_type := NULL;
436: END IF;
437: IF (l_OKL_TAX_LINES_rec.tax_rate_code_id = OKC_API.G_MISS_NUM ) THEN
438: l_OKL_TAX_LINES_rec.tax_rate_code_id := NULL;
439: END IF;
440: IF (l_OKL_TAX_LINES_rec.tax_rate_code = OKC_API.G_MISS_CHAR ) THEN
441: l_OKL_TAX_LINES_rec.tax_rate_code := NULL;
434: IF (l_OKL_TAX_LINES_rec.tax_type = OKC_API.G_MISS_NUM ) THEN
435: l_OKL_TAX_LINES_rec.tax_type := NULL;
436: END IF;
437: IF (l_OKL_TAX_LINES_rec.tax_rate_code_id = OKC_API.G_MISS_NUM ) THEN
438: l_OKL_TAX_LINES_rec.tax_rate_code_id := NULL;
439: END IF;
440: IF (l_OKL_TAX_LINES_rec.tax_rate_code = OKC_API.G_MISS_CHAR ) THEN
441: l_OKL_TAX_LINES_rec.tax_rate_code := NULL;
442: END IF;
436: END IF;
437: IF (l_OKL_TAX_LINES_rec.tax_rate_code_id = OKC_API.G_MISS_NUM ) THEN
438: l_OKL_TAX_LINES_rec.tax_rate_code_id := NULL;
439: END IF;
440: IF (l_OKL_TAX_LINES_rec.tax_rate_code = OKC_API.G_MISS_CHAR ) THEN
441: l_OKL_TAX_LINES_rec.tax_rate_code := NULL;
442: END IF;
443: IF (l_OKL_TAX_LINES_rec.taxable_amount = OKC_API.G_MISS_NUM ) THEN
444: l_OKL_TAX_LINES_rec.taxable_amount := NULL;
437: IF (l_OKL_TAX_LINES_rec.tax_rate_code_id = OKC_API.G_MISS_NUM ) THEN
438: l_OKL_TAX_LINES_rec.tax_rate_code_id := NULL;
439: END IF;
440: IF (l_OKL_TAX_LINES_rec.tax_rate_code = OKC_API.G_MISS_CHAR ) THEN
441: l_OKL_TAX_LINES_rec.tax_rate_code := NULL;
442: END IF;
443: IF (l_OKL_TAX_LINES_rec.taxable_amount = OKC_API.G_MISS_NUM ) THEN
444: l_OKL_TAX_LINES_rec.taxable_amount := NULL;
445: END IF;
439: END IF;
440: IF (l_OKL_TAX_LINES_rec.tax_rate_code = OKC_API.G_MISS_CHAR ) THEN
441: l_OKL_TAX_LINES_rec.tax_rate_code := NULL;
442: END IF;
443: IF (l_OKL_TAX_LINES_rec.taxable_amount = OKC_API.G_MISS_NUM ) THEN
444: l_OKL_TAX_LINES_rec.taxable_amount := NULL;
445: END IF;
446: IF (l_OKL_TAX_LINES_rec.tax_exemption_id = OKC_API.G_MISS_NUM ) THEN
447: l_OKL_TAX_LINES_rec.tax_exemption_id := NULL;
440: IF (l_OKL_TAX_LINES_rec.tax_rate_code = OKC_API.G_MISS_CHAR ) THEN
441: l_OKL_TAX_LINES_rec.tax_rate_code := NULL;
442: END IF;
443: IF (l_OKL_TAX_LINES_rec.taxable_amount = OKC_API.G_MISS_NUM ) THEN
444: l_OKL_TAX_LINES_rec.taxable_amount := NULL;
445: END IF;
446: IF (l_OKL_TAX_LINES_rec.tax_exemption_id = OKC_API.G_MISS_NUM ) THEN
447: l_OKL_TAX_LINES_rec.tax_exemption_id := NULL;
448: END IF;
442: END IF;
443: IF (l_OKL_TAX_LINES_rec.taxable_amount = OKC_API.G_MISS_NUM ) THEN
444: l_OKL_TAX_LINES_rec.taxable_amount := NULL;
445: END IF;
446: IF (l_OKL_TAX_LINES_rec.tax_exemption_id = OKC_API.G_MISS_NUM ) THEN
447: l_OKL_TAX_LINES_rec.tax_exemption_id := NULL;
448: END IF;
449: IF (l_OKL_TAX_LINES_rec.manually_entered_flag = OKC_API.G_MISS_CHAR ) THEN
450: l_OKL_TAX_LINES_rec.manually_entered_flag := NULL;
443: IF (l_OKL_TAX_LINES_rec.taxable_amount = OKC_API.G_MISS_NUM ) THEN
444: l_OKL_TAX_LINES_rec.taxable_amount := NULL;
445: END IF;
446: IF (l_OKL_TAX_LINES_rec.tax_exemption_id = OKC_API.G_MISS_NUM ) THEN
447: l_OKL_TAX_LINES_rec.tax_exemption_id := NULL;
448: END IF;
449: IF (l_OKL_TAX_LINES_rec.manually_entered_flag = OKC_API.G_MISS_CHAR ) THEN
450: l_OKL_TAX_LINES_rec.manually_entered_flag := NULL;
451: END IF;
445: END IF;
446: IF (l_OKL_TAX_LINES_rec.tax_exemption_id = OKC_API.G_MISS_NUM ) THEN
447: l_OKL_TAX_LINES_rec.tax_exemption_id := NULL;
448: END IF;
449: IF (l_OKL_TAX_LINES_rec.manually_entered_flag = OKC_API.G_MISS_CHAR ) THEN
450: l_OKL_TAX_LINES_rec.manually_entered_flag := NULL;
451: END IF;
452: IF (l_OKL_TAX_LINES_rec.overridden_flag = OKC_API.G_MISS_CHAR ) THEN
453: l_OKL_TAX_LINES_rec.overridden_flag := NULL;
446: IF (l_OKL_TAX_LINES_rec.tax_exemption_id = OKC_API.G_MISS_NUM ) THEN
447: l_OKL_TAX_LINES_rec.tax_exemption_id := NULL;
448: END IF;
449: IF (l_OKL_TAX_LINES_rec.manually_entered_flag = OKC_API.G_MISS_CHAR ) THEN
450: l_OKL_TAX_LINES_rec.manually_entered_flag := NULL;
451: END IF;
452: IF (l_OKL_TAX_LINES_rec.overridden_flag = OKC_API.G_MISS_CHAR ) THEN
453: l_OKL_TAX_LINES_rec.overridden_flag := NULL;
454: END IF;
448: END IF;
449: IF (l_OKL_TAX_LINES_rec.manually_entered_flag = OKC_API.G_MISS_CHAR ) THEN
450: l_OKL_TAX_LINES_rec.manually_entered_flag := NULL;
451: END IF;
452: IF (l_OKL_TAX_LINES_rec.overridden_flag = OKC_API.G_MISS_CHAR ) THEN
453: l_OKL_TAX_LINES_rec.overridden_flag := NULL;
454: END IF;
455: IF (l_OKL_TAX_LINES_rec.calculated_tax_amount = OKC_API.G_MISS_NUM ) THEN
456: l_OKL_TAX_LINES_rec.calculated_tax_amount := NULL;
449: IF (l_OKL_TAX_LINES_rec.manually_entered_flag = OKC_API.G_MISS_CHAR ) THEN
450: l_OKL_TAX_LINES_rec.manually_entered_flag := NULL;
451: END IF;
452: IF (l_OKL_TAX_LINES_rec.overridden_flag = OKC_API.G_MISS_CHAR ) THEN
453: l_OKL_TAX_LINES_rec.overridden_flag := NULL;
454: END IF;
455: IF (l_OKL_TAX_LINES_rec.calculated_tax_amount = OKC_API.G_MISS_NUM ) THEN
456: l_OKL_TAX_LINES_rec.calculated_tax_amount := NULL;
457: END IF;
451: END IF;
452: IF (l_OKL_TAX_LINES_rec.overridden_flag = OKC_API.G_MISS_CHAR ) THEN
453: l_OKL_TAX_LINES_rec.overridden_flag := NULL;
454: END IF;
455: IF (l_OKL_TAX_LINES_rec.calculated_tax_amount = OKC_API.G_MISS_NUM ) THEN
456: l_OKL_TAX_LINES_rec.calculated_tax_amount := NULL;
457: END IF;
458: IF (l_OKL_TAX_LINES_rec.tax_rate = OKC_API.G_MISS_NUM ) THEN
459: l_OKL_TAX_LINES_rec.tax_rate := NULL;
452: IF (l_OKL_TAX_LINES_rec.overridden_flag = OKC_API.G_MISS_CHAR ) THEN
453: l_OKL_TAX_LINES_rec.overridden_flag := NULL;
454: END IF;
455: IF (l_OKL_TAX_LINES_rec.calculated_tax_amount = OKC_API.G_MISS_NUM ) THEN
456: l_OKL_TAX_LINES_rec.calculated_tax_amount := NULL;
457: END IF;
458: IF (l_OKL_TAX_LINES_rec.tax_rate = OKC_API.G_MISS_NUM ) THEN
459: l_OKL_TAX_LINES_rec.tax_rate := NULL;
460: END IF;
454: END IF;
455: IF (l_OKL_TAX_LINES_rec.calculated_tax_amount = OKC_API.G_MISS_NUM ) THEN
456: l_OKL_TAX_LINES_rec.calculated_tax_amount := NULL;
457: END IF;
458: IF (l_OKL_TAX_LINES_rec.tax_rate = OKC_API.G_MISS_NUM ) THEN
459: l_OKL_TAX_LINES_rec.tax_rate := NULL;
460: END IF;
461: IF (l_OKL_TAX_LINES_rec.tax_amount = OKC_API.G_MISS_NUM ) THEN
462: l_OKL_TAX_LINES_rec.tax_amount := NULL;
455: IF (l_OKL_TAX_LINES_rec.calculated_tax_amount = OKC_API.G_MISS_NUM ) THEN
456: l_OKL_TAX_LINES_rec.calculated_tax_amount := NULL;
457: END IF;
458: IF (l_OKL_TAX_LINES_rec.tax_rate = OKC_API.G_MISS_NUM ) THEN
459: l_OKL_TAX_LINES_rec.tax_rate := NULL;
460: END IF;
461: IF (l_OKL_TAX_LINES_rec.tax_amount = OKC_API.G_MISS_NUM ) THEN
462: l_OKL_TAX_LINES_rec.tax_amount := NULL;
463: END IF;
457: END IF;
458: IF (l_OKL_TAX_LINES_rec.tax_rate = OKC_API.G_MISS_NUM ) THEN
459: l_OKL_TAX_LINES_rec.tax_rate := NULL;
460: END IF;
461: IF (l_OKL_TAX_LINES_rec.tax_amount = OKC_API.G_MISS_NUM ) THEN
462: l_OKL_TAX_LINES_rec.tax_amount := NULL;
463: END IF;
464: IF (l_OKL_TAX_LINES_rec.sales_tax_id = OKC_API.G_MISS_NUM ) THEN
465: l_OKL_TAX_LINES_rec.sales_tax_id := NULL;
458: IF (l_OKL_TAX_LINES_rec.tax_rate = OKC_API.G_MISS_NUM ) THEN
459: l_OKL_TAX_LINES_rec.tax_rate := NULL;
460: END IF;
461: IF (l_OKL_TAX_LINES_rec.tax_amount = OKC_API.G_MISS_NUM ) THEN
462: l_OKL_TAX_LINES_rec.tax_amount := NULL;
463: END IF;
464: IF (l_OKL_TAX_LINES_rec.sales_tax_id = OKC_API.G_MISS_NUM ) THEN
465: l_OKL_TAX_LINES_rec.sales_tax_id := NULL;
466: END IF;
460: END IF;
461: IF (l_OKL_TAX_LINES_rec.tax_amount = OKC_API.G_MISS_NUM ) THEN
462: l_OKL_TAX_LINES_rec.tax_amount := NULL;
463: END IF;
464: IF (l_OKL_TAX_LINES_rec.sales_tax_id = OKC_API.G_MISS_NUM ) THEN
465: l_OKL_TAX_LINES_rec.sales_tax_id := NULL;
466: END IF;
467: IF (l_OKL_TAX_LINES_rec.source_trx_id = OKC_API.G_MISS_NUM ) THEN
468: l_OKL_TAX_LINES_rec.source_trx_id := NULL;
461: IF (l_OKL_TAX_LINES_rec.tax_amount = OKC_API.G_MISS_NUM ) THEN
462: l_OKL_TAX_LINES_rec.tax_amount := NULL;
463: END IF;
464: IF (l_OKL_TAX_LINES_rec.sales_tax_id = OKC_API.G_MISS_NUM ) THEN
465: l_OKL_TAX_LINES_rec.sales_tax_id := NULL;
466: END IF;
467: IF (l_OKL_TAX_LINES_rec.source_trx_id = OKC_API.G_MISS_NUM ) THEN
468: l_OKL_TAX_LINES_rec.source_trx_id := NULL;
469: END IF;
463: END IF;
464: IF (l_OKL_TAX_LINES_rec.sales_tax_id = OKC_API.G_MISS_NUM ) THEN
465: l_OKL_TAX_LINES_rec.sales_tax_id := NULL;
466: END IF;
467: IF (l_OKL_TAX_LINES_rec.source_trx_id = OKC_API.G_MISS_NUM ) THEN
468: l_OKL_TAX_LINES_rec.source_trx_id := NULL;
469: END IF;
470: IF (l_OKL_TAX_LINES_rec.org_id = OKC_API.G_MISS_NUM ) THEN
471: l_OKL_TAX_LINES_rec.org_id := NULL;
464: IF (l_OKL_TAX_LINES_rec.sales_tax_id = OKC_API.G_MISS_NUM ) THEN
465: l_OKL_TAX_LINES_rec.sales_tax_id := NULL;
466: END IF;
467: IF (l_OKL_TAX_LINES_rec.source_trx_id = OKC_API.G_MISS_NUM ) THEN
468: l_OKL_TAX_LINES_rec.source_trx_id := NULL;
469: END IF;
470: IF (l_OKL_TAX_LINES_rec.org_id = OKC_API.G_MISS_NUM ) THEN
471: l_OKL_TAX_LINES_rec.org_id := NULL;
472: END IF;
466: END IF;
467: IF (l_OKL_TAX_LINES_rec.source_trx_id = OKC_API.G_MISS_NUM ) THEN
468: l_OKL_TAX_LINES_rec.source_trx_id := NULL;
469: END IF;
470: IF (l_OKL_TAX_LINES_rec.org_id = OKC_API.G_MISS_NUM ) THEN
471: l_OKL_TAX_LINES_rec.org_id := NULL;
472: END IF;
473: IF (l_OKL_TAX_LINES_rec.history_yn = OKC_API.G_MISS_CHAR ) THEN
474: l_OKL_TAX_LINES_rec.history_yn := NULL;
467: IF (l_OKL_TAX_LINES_rec.source_trx_id = OKC_API.G_MISS_NUM ) THEN
468: l_OKL_TAX_LINES_rec.source_trx_id := NULL;
469: END IF;
470: IF (l_OKL_TAX_LINES_rec.org_id = OKC_API.G_MISS_NUM ) THEN
471: l_OKL_TAX_LINES_rec.org_id := NULL;
472: END IF;
473: IF (l_OKL_TAX_LINES_rec.history_yn = OKC_API.G_MISS_CHAR ) THEN
474: l_OKL_TAX_LINES_rec.history_yn := NULL;
475: END IF;
469: END IF;
470: IF (l_OKL_TAX_LINES_rec.org_id = OKC_API.G_MISS_NUM ) THEN
471: l_OKL_TAX_LINES_rec.org_id := NULL;
472: END IF;
473: IF (l_OKL_TAX_LINES_rec.history_yn = OKC_API.G_MISS_CHAR ) THEN
474: l_OKL_TAX_LINES_rec.history_yn := NULL;
475: END IF;
476: IF (l_OKL_TAX_LINES_rec.actual_yn = OKC_API.G_MISS_CHAR ) THEN
477: l_OKL_TAX_LINES_rec.actual_yn := NULL;
470: IF (l_OKL_TAX_LINES_rec.org_id = OKC_API.G_MISS_NUM ) THEN
471: l_OKL_TAX_LINES_rec.org_id := NULL;
472: END IF;
473: IF (l_OKL_TAX_LINES_rec.history_yn = OKC_API.G_MISS_CHAR ) THEN
474: l_OKL_TAX_LINES_rec.history_yn := NULL;
475: END IF;
476: IF (l_OKL_TAX_LINES_rec.actual_yn = OKC_API.G_MISS_CHAR ) THEN
477: l_OKL_TAX_LINES_rec.actual_yn := NULL;
478: END IF;
472: END IF;
473: IF (l_OKL_TAX_LINES_rec.history_yn = OKC_API.G_MISS_CHAR ) THEN
474: l_OKL_TAX_LINES_rec.history_yn := NULL;
475: END IF;
476: IF (l_OKL_TAX_LINES_rec.actual_yn = OKC_API.G_MISS_CHAR ) THEN
477: l_OKL_TAX_LINES_rec.actual_yn := NULL;
478: END IF;
479: IF (l_OKL_TAX_LINES_rec.source_name = OKC_API.G_MISS_CHAR ) THEN
480: l_OKL_TAX_LINES_rec.source_name := NULL;
473: IF (l_OKL_TAX_LINES_rec.history_yn = OKC_API.G_MISS_CHAR ) THEN
474: l_OKL_TAX_LINES_rec.history_yn := NULL;
475: END IF;
476: IF (l_OKL_TAX_LINES_rec.actual_yn = OKC_API.G_MISS_CHAR ) THEN
477: l_OKL_TAX_LINES_rec.actual_yn := NULL;
478: END IF;
479: IF (l_OKL_TAX_LINES_rec.source_name = OKC_API.G_MISS_CHAR ) THEN
480: l_OKL_TAX_LINES_rec.source_name := NULL;
481: END IF;
475: END IF;
476: IF (l_OKL_TAX_LINES_rec.actual_yn = OKC_API.G_MISS_CHAR ) THEN
477: l_OKL_TAX_LINES_rec.actual_yn := NULL;
478: END IF;
479: IF (l_OKL_TAX_LINES_rec.source_name = OKC_API.G_MISS_CHAR ) THEN
480: l_OKL_TAX_LINES_rec.source_name := NULL;
481: END IF;
482: IF (l_OKL_TAX_LINES_rec.trq_id = OKC_API.G_MISS_NUM ) THEN
483: l_OKL_TAX_LINES_rec.trq_id := NULL;
476: IF (l_OKL_TAX_LINES_rec.actual_yn = OKC_API.G_MISS_CHAR ) THEN
477: l_OKL_TAX_LINES_rec.actual_yn := NULL;
478: END IF;
479: IF (l_OKL_TAX_LINES_rec.source_name = OKC_API.G_MISS_CHAR ) THEN
480: l_OKL_TAX_LINES_rec.source_name := NULL;
481: END IF;
482: IF (l_OKL_TAX_LINES_rec.trq_id = OKC_API.G_MISS_NUM ) THEN
483: l_OKL_TAX_LINES_rec.trq_id := NULL;
484: END IF;
478: END IF;
479: IF (l_OKL_TAX_LINES_rec.source_name = OKC_API.G_MISS_CHAR ) THEN
480: l_OKL_TAX_LINES_rec.source_name := NULL;
481: END IF;
482: IF (l_OKL_TAX_LINES_rec.trq_id = OKC_API.G_MISS_NUM ) THEN
483: l_OKL_TAX_LINES_rec.trq_id := NULL;
484: END IF;
485: IF (l_OKL_TAX_LINES_rec.program_id = OKC_API.G_MISS_NUM ) THEN
486: l_OKL_TAX_LINES_rec.program_id := NULL;
479: IF (l_OKL_TAX_LINES_rec.source_name = OKC_API.G_MISS_CHAR ) THEN
480: l_OKL_TAX_LINES_rec.source_name := NULL;
481: END IF;
482: IF (l_OKL_TAX_LINES_rec.trq_id = OKC_API.G_MISS_NUM ) THEN
483: l_OKL_TAX_LINES_rec.trq_id := NULL;
484: END IF;
485: IF (l_OKL_TAX_LINES_rec.program_id = OKC_API.G_MISS_NUM ) THEN
486: l_OKL_TAX_LINES_rec.program_id := NULL;
487: END IF;
481: END IF;
482: IF (l_OKL_TAX_LINES_rec.trq_id = OKC_API.G_MISS_NUM ) THEN
483: l_OKL_TAX_LINES_rec.trq_id := NULL;
484: END IF;
485: IF (l_OKL_TAX_LINES_rec.program_id = OKC_API.G_MISS_NUM ) THEN
486: l_OKL_TAX_LINES_rec.program_id := NULL;
487: END IF;
488: IF (l_OKL_TAX_LINES_rec.request_id = OKC_API.G_MISS_NUM ) THEN
489: l_OKL_TAX_LINES_rec.request_id := NULL;
482: IF (l_OKL_TAX_LINES_rec.trq_id = OKC_API.G_MISS_NUM ) THEN
483: l_OKL_TAX_LINES_rec.trq_id := NULL;
484: END IF;
485: IF (l_OKL_TAX_LINES_rec.program_id = OKC_API.G_MISS_NUM ) THEN
486: l_OKL_TAX_LINES_rec.program_id := NULL;
487: END IF;
488: IF (l_OKL_TAX_LINES_rec.request_id = OKC_API.G_MISS_NUM ) THEN
489: l_OKL_TAX_LINES_rec.request_id := NULL;
490: END IF;
484: END IF;
485: IF (l_OKL_TAX_LINES_rec.program_id = OKC_API.G_MISS_NUM ) THEN
486: l_OKL_TAX_LINES_rec.program_id := NULL;
487: END IF;
488: IF (l_OKL_TAX_LINES_rec.request_id = OKC_API.G_MISS_NUM ) THEN
489: l_OKL_TAX_LINES_rec.request_id := NULL;
490: END IF;
491: IF (l_OKL_TAX_LINES_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
492: l_OKL_TAX_LINES_rec.program_application_id := NULL;
485: IF (l_OKL_TAX_LINES_rec.program_id = OKC_API.G_MISS_NUM ) THEN
486: l_OKL_TAX_LINES_rec.program_id := NULL;
487: END IF;
488: IF (l_OKL_TAX_LINES_rec.request_id = OKC_API.G_MISS_NUM ) THEN
489: l_OKL_TAX_LINES_rec.request_id := NULL;
490: END IF;
491: IF (l_OKL_TAX_LINES_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
492: l_OKL_TAX_LINES_rec.program_application_id := NULL;
493: END IF;
487: END IF;
488: IF (l_OKL_TAX_LINES_rec.request_id = OKC_API.G_MISS_NUM ) THEN
489: l_OKL_TAX_LINES_rec.request_id := NULL;
490: END IF;
491: IF (l_OKL_TAX_LINES_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
492: l_OKL_TAX_LINES_rec.program_application_id := NULL;
493: END IF;
494: IF (l_OKL_TAX_LINES_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
495: l_OKL_TAX_LINES_rec.program_update_date := NULL;
488: IF (l_OKL_TAX_LINES_rec.request_id = OKC_API.G_MISS_NUM ) THEN
489: l_OKL_TAX_LINES_rec.request_id := NULL;
490: END IF;
491: IF (l_OKL_TAX_LINES_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
492: l_OKL_TAX_LINES_rec.program_application_id := NULL;
493: END IF;
494: IF (l_OKL_TAX_LINES_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
495: l_OKL_TAX_LINES_rec.program_update_date := NULL;
496: END IF;
490: END IF;
491: IF (l_OKL_TAX_LINES_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
492: l_OKL_TAX_LINES_rec.program_application_id := NULL;
493: END IF;
494: IF (l_OKL_TAX_LINES_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
495: l_OKL_TAX_LINES_rec.program_update_date := NULL;
496: END IF;
497: IF (l_OKL_TAX_LINES_rec.attribute_category = OKC_API.G_MISS_CHAR ) THEN
498: l_OKL_TAX_LINES_rec.attribute_category := NULL;
491: IF (l_OKL_TAX_LINES_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
492: l_OKL_TAX_LINES_rec.program_application_id := NULL;
493: END IF;
494: IF (l_OKL_TAX_LINES_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
495: l_OKL_TAX_LINES_rec.program_update_date := NULL;
496: END IF;
497: IF (l_OKL_TAX_LINES_rec.attribute_category = OKC_API.G_MISS_CHAR ) THEN
498: l_OKL_TAX_LINES_rec.attribute_category := NULL;
499: END IF;
493: END IF;
494: IF (l_OKL_TAX_LINES_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
495: l_OKL_TAX_LINES_rec.program_update_date := NULL;
496: END IF;
497: IF (l_OKL_TAX_LINES_rec.attribute_category = OKC_API.G_MISS_CHAR ) THEN
498: l_OKL_TAX_LINES_rec.attribute_category := NULL;
499: END IF;
500: IF (l_OKL_TAX_LINES_rec.attribute1 = OKC_API.G_MISS_CHAR ) THEN
501: l_OKL_TAX_LINES_rec.attribute1 := NULL;
494: IF (l_OKL_TAX_LINES_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
495: l_OKL_TAX_LINES_rec.program_update_date := NULL;
496: END IF;
497: IF (l_OKL_TAX_LINES_rec.attribute_category = OKC_API.G_MISS_CHAR ) THEN
498: l_OKL_TAX_LINES_rec.attribute_category := NULL;
499: END IF;
500: IF (l_OKL_TAX_LINES_rec.attribute1 = OKC_API.G_MISS_CHAR ) THEN
501: l_OKL_TAX_LINES_rec.attribute1 := NULL;
502: END IF;
496: END IF;
497: IF (l_OKL_TAX_LINES_rec.attribute_category = OKC_API.G_MISS_CHAR ) THEN
498: l_OKL_TAX_LINES_rec.attribute_category := NULL;
499: END IF;
500: IF (l_OKL_TAX_LINES_rec.attribute1 = OKC_API.G_MISS_CHAR ) THEN
501: l_OKL_TAX_LINES_rec.attribute1 := NULL;
502: END IF;
503: IF (l_OKL_TAX_LINES_rec.attribute2 = OKC_API.G_MISS_CHAR ) THEN
504: l_OKL_TAX_LINES_rec.attribute2 := NULL;
497: IF (l_OKL_TAX_LINES_rec.attribute_category = OKC_API.G_MISS_CHAR ) THEN
498: l_OKL_TAX_LINES_rec.attribute_category := NULL;
499: END IF;
500: IF (l_OKL_TAX_LINES_rec.attribute1 = OKC_API.G_MISS_CHAR ) THEN
501: l_OKL_TAX_LINES_rec.attribute1 := NULL;
502: END IF;
503: IF (l_OKL_TAX_LINES_rec.attribute2 = OKC_API.G_MISS_CHAR ) THEN
504: l_OKL_TAX_LINES_rec.attribute2 := NULL;
505: END IF;
499: END IF;
500: IF (l_OKL_TAX_LINES_rec.attribute1 = OKC_API.G_MISS_CHAR ) THEN
501: l_OKL_TAX_LINES_rec.attribute1 := NULL;
502: END IF;
503: IF (l_OKL_TAX_LINES_rec.attribute2 = OKC_API.G_MISS_CHAR ) THEN
504: l_OKL_TAX_LINES_rec.attribute2 := NULL;
505: END IF;
506: IF (l_OKL_TAX_LINES_rec.attribute3 = OKC_API.G_MISS_CHAR ) THEN
507: l_OKL_TAX_LINES_rec.attribute3 := NULL;
500: IF (l_OKL_TAX_LINES_rec.attribute1 = OKC_API.G_MISS_CHAR ) THEN
501: l_OKL_TAX_LINES_rec.attribute1 := NULL;
502: END IF;
503: IF (l_OKL_TAX_LINES_rec.attribute2 = OKC_API.G_MISS_CHAR ) THEN
504: l_OKL_TAX_LINES_rec.attribute2 := NULL;
505: END IF;
506: IF (l_OKL_TAX_LINES_rec.attribute3 = OKC_API.G_MISS_CHAR ) THEN
507: l_OKL_TAX_LINES_rec.attribute3 := NULL;
508: END IF;
502: END IF;
503: IF (l_OKL_TAX_LINES_rec.attribute2 = OKC_API.G_MISS_CHAR ) THEN
504: l_OKL_TAX_LINES_rec.attribute2 := NULL;
505: END IF;
506: IF (l_OKL_TAX_LINES_rec.attribute3 = OKC_API.G_MISS_CHAR ) THEN
507: l_OKL_TAX_LINES_rec.attribute3 := NULL;
508: END IF;
509: IF (l_OKL_TAX_LINES_rec.attribute4 = OKC_API.G_MISS_CHAR ) THEN
510: l_OKL_TAX_LINES_rec.attribute4 := NULL;
503: IF (l_OKL_TAX_LINES_rec.attribute2 = OKC_API.G_MISS_CHAR ) THEN
504: l_OKL_TAX_LINES_rec.attribute2 := NULL;
505: END IF;
506: IF (l_OKL_TAX_LINES_rec.attribute3 = OKC_API.G_MISS_CHAR ) THEN
507: l_OKL_TAX_LINES_rec.attribute3 := NULL;
508: END IF;
509: IF (l_OKL_TAX_LINES_rec.attribute4 = OKC_API.G_MISS_CHAR ) THEN
510: l_OKL_TAX_LINES_rec.attribute4 := NULL;
511: END IF;
505: END IF;
506: IF (l_OKL_TAX_LINES_rec.attribute3 = OKC_API.G_MISS_CHAR ) THEN
507: l_OKL_TAX_LINES_rec.attribute3 := NULL;
508: END IF;
509: IF (l_OKL_TAX_LINES_rec.attribute4 = OKC_API.G_MISS_CHAR ) THEN
510: l_OKL_TAX_LINES_rec.attribute4 := NULL;
511: END IF;
512: IF (l_OKL_TAX_LINES_rec.attribute5 = OKC_API.G_MISS_CHAR ) THEN
513: l_OKL_TAX_LINES_rec.attribute5 := NULL;
506: IF (l_OKL_TAX_LINES_rec.attribute3 = OKC_API.G_MISS_CHAR ) THEN
507: l_OKL_TAX_LINES_rec.attribute3 := NULL;
508: END IF;
509: IF (l_OKL_TAX_LINES_rec.attribute4 = OKC_API.G_MISS_CHAR ) THEN
510: l_OKL_TAX_LINES_rec.attribute4 := NULL;
511: END IF;
512: IF (l_OKL_TAX_LINES_rec.attribute5 = OKC_API.G_MISS_CHAR ) THEN
513: l_OKL_TAX_LINES_rec.attribute5 := NULL;
514: END IF;
508: END IF;
509: IF (l_OKL_TAX_LINES_rec.attribute4 = OKC_API.G_MISS_CHAR ) THEN
510: l_OKL_TAX_LINES_rec.attribute4 := NULL;
511: END IF;
512: IF (l_OKL_TAX_LINES_rec.attribute5 = OKC_API.G_MISS_CHAR ) THEN
513: l_OKL_TAX_LINES_rec.attribute5 := NULL;
514: END IF;
515: IF (l_OKL_TAX_LINES_rec.attribute6 = OKC_API.G_MISS_CHAR ) THEN
516: l_OKL_TAX_LINES_rec.attribute6 := NULL;
509: IF (l_OKL_TAX_LINES_rec.attribute4 = OKC_API.G_MISS_CHAR ) THEN
510: l_OKL_TAX_LINES_rec.attribute4 := NULL;
511: END IF;
512: IF (l_OKL_TAX_LINES_rec.attribute5 = OKC_API.G_MISS_CHAR ) THEN
513: l_OKL_TAX_LINES_rec.attribute5 := NULL;
514: END IF;
515: IF (l_OKL_TAX_LINES_rec.attribute6 = OKC_API.G_MISS_CHAR ) THEN
516: l_OKL_TAX_LINES_rec.attribute6 := NULL;
517: END IF;
511: END IF;
512: IF (l_OKL_TAX_LINES_rec.attribute5 = OKC_API.G_MISS_CHAR ) THEN
513: l_OKL_TAX_LINES_rec.attribute5 := NULL;
514: END IF;
515: IF (l_OKL_TAX_LINES_rec.attribute6 = OKC_API.G_MISS_CHAR ) THEN
516: l_OKL_TAX_LINES_rec.attribute6 := NULL;
517: END IF;
518: IF (l_OKL_TAX_LINES_rec.attribute7 = OKC_API.G_MISS_CHAR ) THEN
519: l_OKL_TAX_LINES_rec.attribute7 := NULL;
512: IF (l_OKL_TAX_LINES_rec.attribute5 = OKC_API.G_MISS_CHAR ) THEN
513: l_OKL_TAX_LINES_rec.attribute5 := NULL;
514: END IF;
515: IF (l_OKL_TAX_LINES_rec.attribute6 = OKC_API.G_MISS_CHAR ) THEN
516: l_OKL_TAX_LINES_rec.attribute6 := NULL;
517: END IF;
518: IF (l_OKL_TAX_LINES_rec.attribute7 = OKC_API.G_MISS_CHAR ) THEN
519: l_OKL_TAX_LINES_rec.attribute7 := NULL;
520: END IF;
514: END IF;
515: IF (l_OKL_TAX_LINES_rec.attribute6 = OKC_API.G_MISS_CHAR ) THEN
516: l_OKL_TAX_LINES_rec.attribute6 := NULL;
517: END IF;
518: IF (l_OKL_TAX_LINES_rec.attribute7 = OKC_API.G_MISS_CHAR ) THEN
519: l_OKL_TAX_LINES_rec.attribute7 := NULL;
520: END IF;
521: IF (l_OKL_TAX_LINES_rec.attribute8 = OKC_API.G_MISS_CHAR ) THEN
522: l_OKL_TAX_LINES_rec.attribute8 := NULL;
515: IF (l_OKL_TAX_LINES_rec.attribute6 = OKC_API.G_MISS_CHAR ) THEN
516: l_OKL_TAX_LINES_rec.attribute6 := NULL;
517: END IF;
518: IF (l_OKL_TAX_LINES_rec.attribute7 = OKC_API.G_MISS_CHAR ) THEN
519: l_OKL_TAX_LINES_rec.attribute7 := NULL;
520: END IF;
521: IF (l_OKL_TAX_LINES_rec.attribute8 = OKC_API.G_MISS_CHAR ) THEN
522: l_OKL_TAX_LINES_rec.attribute8 := NULL;
523: END IF;
517: END IF;
518: IF (l_OKL_TAX_LINES_rec.attribute7 = OKC_API.G_MISS_CHAR ) THEN
519: l_OKL_TAX_LINES_rec.attribute7 := NULL;
520: END IF;
521: IF (l_OKL_TAX_LINES_rec.attribute8 = OKC_API.G_MISS_CHAR ) THEN
522: l_OKL_TAX_LINES_rec.attribute8 := NULL;
523: END IF;
524: IF (l_OKL_TAX_LINES_rec.attribute9 = OKC_API.G_MISS_CHAR ) THEN
525: l_OKL_TAX_LINES_rec.attribute9 := NULL;
518: IF (l_OKL_TAX_LINES_rec.attribute7 = OKC_API.G_MISS_CHAR ) THEN
519: l_OKL_TAX_LINES_rec.attribute7 := NULL;
520: END IF;
521: IF (l_OKL_TAX_LINES_rec.attribute8 = OKC_API.G_MISS_CHAR ) THEN
522: l_OKL_TAX_LINES_rec.attribute8 := NULL;
523: END IF;
524: IF (l_OKL_TAX_LINES_rec.attribute9 = OKC_API.G_MISS_CHAR ) THEN
525: l_OKL_TAX_LINES_rec.attribute9 := NULL;
526: END IF;
520: END IF;
521: IF (l_OKL_TAX_LINES_rec.attribute8 = OKC_API.G_MISS_CHAR ) THEN
522: l_OKL_TAX_LINES_rec.attribute8 := NULL;
523: END IF;
524: IF (l_OKL_TAX_LINES_rec.attribute9 = OKC_API.G_MISS_CHAR ) THEN
525: l_OKL_TAX_LINES_rec.attribute9 := NULL;
526: END IF;
527: IF (l_OKL_TAX_LINES_rec.attribute10 = OKC_API.G_MISS_CHAR ) THEN
528: l_OKL_TAX_LINES_rec.attribute10 := NULL;
521: IF (l_OKL_TAX_LINES_rec.attribute8 = OKC_API.G_MISS_CHAR ) THEN
522: l_OKL_TAX_LINES_rec.attribute8 := NULL;
523: END IF;
524: IF (l_OKL_TAX_LINES_rec.attribute9 = OKC_API.G_MISS_CHAR ) THEN
525: l_OKL_TAX_LINES_rec.attribute9 := NULL;
526: END IF;
527: IF (l_OKL_TAX_LINES_rec.attribute10 = OKC_API.G_MISS_CHAR ) THEN
528: l_OKL_TAX_LINES_rec.attribute10 := NULL;
529: END IF;
523: END IF;
524: IF (l_OKL_TAX_LINES_rec.attribute9 = OKC_API.G_MISS_CHAR ) THEN
525: l_OKL_TAX_LINES_rec.attribute9 := NULL;
526: END IF;
527: IF (l_OKL_TAX_LINES_rec.attribute10 = OKC_API.G_MISS_CHAR ) THEN
528: l_OKL_TAX_LINES_rec.attribute10 := NULL;
529: END IF;
530: IF (l_OKL_TAX_LINES_rec.attribute11 = OKC_API.G_MISS_CHAR ) THEN
531: l_OKL_TAX_LINES_rec.attribute11 := NULL;
524: IF (l_OKL_TAX_LINES_rec.attribute9 = OKC_API.G_MISS_CHAR ) THEN
525: l_OKL_TAX_LINES_rec.attribute9 := NULL;
526: END IF;
527: IF (l_OKL_TAX_LINES_rec.attribute10 = OKC_API.G_MISS_CHAR ) THEN
528: l_OKL_TAX_LINES_rec.attribute10 := NULL;
529: END IF;
530: IF (l_OKL_TAX_LINES_rec.attribute11 = OKC_API.G_MISS_CHAR ) THEN
531: l_OKL_TAX_LINES_rec.attribute11 := NULL;
532: END IF;
526: END IF;
527: IF (l_OKL_TAX_LINES_rec.attribute10 = OKC_API.G_MISS_CHAR ) THEN
528: l_OKL_TAX_LINES_rec.attribute10 := NULL;
529: END IF;
530: IF (l_OKL_TAX_LINES_rec.attribute11 = OKC_API.G_MISS_CHAR ) THEN
531: l_OKL_TAX_LINES_rec.attribute11 := NULL;
532: END IF;
533: IF (l_OKL_TAX_LINES_rec.attribute12 = OKC_API.G_MISS_CHAR ) THEN
534: l_OKL_TAX_LINES_rec.attribute12 := NULL;
527: IF (l_OKL_TAX_LINES_rec.attribute10 = OKC_API.G_MISS_CHAR ) THEN
528: l_OKL_TAX_LINES_rec.attribute10 := NULL;
529: END IF;
530: IF (l_OKL_TAX_LINES_rec.attribute11 = OKC_API.G_MISS_CHAR ) THEN
531: l_OKL_TAX_LINES_rec.attribute11 := NULL;
532: END IF;
533: IF (l_OKL_TAX_LINES_rec.attribute12 = OKC_API.G_MISS_CHAR ) THEN
534: l_OKL_TAX_LINES_rec.attribute12 := NULL;
535: END IF;
529: END IF;
530: IF (l_OKL_TAX_LINES_rec.attribute11 = OKC_API.G_MISS_CHAR ) THEN
531: l_OKL_TAX_LINES_rec.attribute11 := NULL;
532: END IF;
533: IF (l_OKL_TAX_LINES_rec.attribute12 = OKC_API.G_MISS_CHAR ) THEN
534: l_OKL_TAX_LINES_rec.attribute12 := NULL;
535: END IF;
536: IF (l_OKL_TAX_LINES_rec.attribute13 = OKC_API.G_MISS_CHAR ) THEN
537: l_OKL_TAX_LINES_rec.attribute13 := NULL;
530: IF (l_OKL_TAX_LINES_rec.attribute11 = OKC_API.G_MISS_CHAR ) THEN
531: l_OKL_TAX_LINES_rec.attribute11 := NULL;
532: END IF;
533: IF (l_OKL_TAX_LINES_rec.attribute12 = OKC_API.G_MISS_CHAR ) THEN
534: l_OKL_TAX_LINES_rec.attribute12 := NULL;
535: END IF;
536: IF (l_OKL_TAX_LINES_rec.attribute13 = OKC_API.G_MISS_CHAR ) THEN
537: l_OKL_TAX_LINES_rec.attribute13 := NULL;
538: END IF;
532: END IF;
533: IF (l_OKL_TAX_LINES_rec.attribute12 = OKC_API.G_MISS_CHAR ) THEN
534: l_OKL_TAX_LINES_rec.attribute12 := NULL;
535: END IF;
536: IF (l_OKL_TAX_LINES_rec.attribute13 = OKC_API.G_MISS_CHAR ) THEN
537: l_OKL_TAX_LINES_rec.attribute13 := NULL;
538: END IF;
539: IF (l_OKL_TAX_LINES_rec.attribute14 = OKC_API.G_MISS_CHAR ) THEN
540: l_OKL_TAX_LINES_rec.attribute14 := NULL;
533: IF (l_OKL_TAX_LINES_rec.attribute12 = OKC_API.G_MISS_CHAR ) THEN
534: l_OKL_TAX_LINES_rec.attribute12 := NULL;
535: END IF;
536: IF (l_OKL_TAX_LINES_rec.attribute13 = OKC_API.G_MISS_CHAR ) THEN
537: l_OKL_TAX_LINES_rec.attribute13 := NULL;
538: END IF;
539: IF (l_OKL_TAX_LINES_rec.attribute14 = OKC_API.G_MISS_CHAR ) THEN
540: l_OKL_TAX_LINES_rec.attribute14 := NULL;
541: END IF;
535: END IF;
536: IF (l_OKL_TAX_LINES_rec.attribute13 = OKC_API.G_MISS_CHAR ) THEN
537: l_OKL_TAX_LINES_rec.attribute13 := NULL;
538: END IF;
539: IF (l_OKL_TAX_LINES_rec.attribute14 = OKC_API.G_MISS_CHAR ) THEN
540: l_OKL_TAX_LINES_rec.attribute14 := NULL;
541: END IF;
542: IF (l_OKL_TAX_LINES_rec.attribute15 = OKC_API.G_MISS_CHAR ) THEN
543: l_OKL_TAX_LINES_rec.attribute15 := NULL;
536: IF (l_OKL_TAX_LINES_rec.attribute13 = OKC_API.G_MISS_CHAR ) THEN
537: l_OKL_TAX_LINES_rec.attribute13 := NULL;
538: END IF;
539: IF (l_OKL_TAX_LINES_rec.attribute14 = OKC_API.G_MISS_CHAR ) THEN
540: l_OKL_TAX_LINES_rec.attribute14 := NULL;
541: END IF;
542: IF (l_OKL_TAX_LINES_rec.attribute15 = OKC_API.G_MISS_CHAR ) THEN
543: l_OKL_TAX_LINES_rec.attribute15 := NULL;
544: END IF;
538: END IF;
539: IF (l_OKL_TAX_LINES_rec.attribute14 = OKC_API.G_MISS_CHAR ) THEN
540: l_OKL_TAX_LINES_rec.attribute14 := NULL;
541: END IF;
542: IF (l_OKL_TAX_LINES_rec.attribute15 = OKC_API.G_MISS_CHAR ) THEN
543: l_OKL_TAX_LINES_rec.attribute15 := NULL;
544: END IF;
545: IF (l_OKL_TAX_LINES_rec.created_by = OKC_API.G_MISS_NUM ) THEN
546: l_OKL_TAX_LINES_rec.created_by := NULL;
539: IF (l_OKL_TAX_LINES_rec.attribute14 = OKC_API.G_MISS_CHAR ) THEN
540: l_OKL_TAX_LINES_rec.attribute14 := NULL;
541: END IF;
542: IF (l_OKL_TAX_LINES_rec.attribute15 = OKC_API.G_MISS_CHAR ) THEN
543: l_OKL_TAX_LINES_rec.attribute15 := NULL;
544: END IF;
545: IF (l_OKL_TAX_LINES_rec.created_by = OKC_API.G_MISS_NUM ) THEN
546: l_OKL_TAX_LINES_rec.created_by := NULL;
547: END IF;
541: END IF;
542: IF (l_OKL_TAX_LINES_rec.attribute15 = OKC_API.G_MISS_CHAR ) THEN
543: l_OKL_TAX_LINES_rec.attribute15 := NULL;
544: END IF;
545: IF (l_OKL_TAX_LINES_rec.created_by = OKC_API.G_MISS_NUM ) THEN
546: l_OKL_TAX_LINES_rec.created_by := NULL;
547: END IF;
548: IF (l_OKL_TAX_LINES_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
549: l_OKL_TAX_LINES_rec.creation_date := NULL;
542: IF (l_OKL_TAX_LINES_rec.attribute15 = OKC_API.G_MISS_CHAR ) THEN
543: l_OKL_TAX_LINES_rec.attribute15 := NULL;
544: END IF;
545: IF (l_OKL_TAX_LINES_rec.created_by = OKC_API.G_MISS_NUM ) THEN
546: l_OKL_TAX_LINES_rec.created_by := NULL;
547: END IF;
548: IF (l_OKL_TAX_LINES_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
549: l_OKL_TAX_LINES_rec.creation_date := NULL;
550: END IF;
544: END IF;
545: IF (l_OKL_TAX_LINES_rec.created_by = OKC_API.G_MISS_NUM ) THEN
546: l_OKL_TAX_LINES_rec.created_by := NULL;
547: END IF;
548: IF (l_OKL_TAX_LINES_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
549: l_OKL_TAX_LINES_rec.creation_date := NULL;
550: END IF;
551: IF (l_OKL_TAX_LINES_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
552: l_OKL_TAX_LINES_rec.last_updated_by := NULL;
545: IF (l_OKL_TAX_LINES_rec.created_by = OKC_API.G_MISS_NUM ) THEN
546: l_OKL_TAX_LINES_rec.created_by := NULL;
547: END IF;
548: IF (l_OKL_TAX_LINES_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
549: l_OKL_TAX_LINES_rec.creation_date := NULL;
550: END IF;
551: IF (l_OKL_TAX_LINES_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
552: l_OKL_TAX_LINES_rec.last_updated_by := NULL;
553: END IF;
547: END IF;
548: IF (l_OKL_TAX_LINES_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
549: l_OKL_TAX_LINES_rec.creation_date := NULL;
550: END IF;
551: IF (l_OKL_TAX_LINES_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
552: l_OKL_TAX_LINES_rec.last_updated_by := NULL;
553: END IF;
554: IF (l_OKL_TAX_LINES_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
555: l_OKL_TAX_LINES_rec.last_update_date := NULL;
548: IF (l_OKL_TAX_LINES_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
549: l_OKL_TAX_LINES_rec.creation_date := NULL;
550: END IF;
551: IF (l_OKL_TAX_LINES_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
552: l_OKL_TAX_LINES_rec.last_updated_by := NULL;
553: END IF;
554: IF (l_OKL_TAX_LINES_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
555: l_OKL_TAX_LINES_rec.last_update_date := NULL;
556: END IF;
550: END IF;
551: IF (l_OKL_TAX_LINES_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
552: l_OKL_TAX_LINES_rec.last_updated_by := NULL;
553: END IF;
554: IF (l_OKL_TAX_LINES_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
555: l_OKL_TAX_LINES_rec.last_update_date := NULL;
556: END IF;
557: IF (l_OKL_TAX_LINES_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
558: l_OKL_TAX_LINES_rec.last_update_login := NULL;
551: IF (l_OKL_TAX_LINES_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
552: l_OKL_TAX_LINES_rec.last_updated_by := NULL;
553: END IF;
554: IF (l_OKL_TAX_LINES_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
555: l_OKL_TAX_LINES_rec.last_update_date := NULL;
556: END IF;
557: IF (l_OKL_TAX_LINES_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
558: l_OKL_TAX_LINES_rec.last_update_login := NULL;
559: END IF;
553: END IF;
554: IF (l_OKL_TAX_LINES_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
555: l_OKL_TAX_LINES_rec.last_update_date := NULL;
556: END IF;
557: IF (l_OKL_TAX_LINES_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
558: l_OKL_TAX_LINES_rec.last_update_login := NULL;
559: END IF;
560: RETURN(l_OKL_TAX_LINES_rec);
561: END null_out_defaults;
554: IF (l_OKL_TAX_LINES_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
555: l_OKL_TAX_LINES_rec.last_update_date := NULL;
556: END IF;
557: IF (l_OKL_TAX_LINES_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
558: l_OKL_TAX_LINES_rec.last_update_login := NULL;
559: END IF;
560: RETURN(l_OKL_TAX_LINES_rec);
561: END null_out_defaults;
562: ---------------------------------
556: END IF;
557: IF (l_OKL_TAX_LINES_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
558: l_OKL_TAX_LINES_rec.last_update_login := NULL;
559: END IF;
560: RETURN(l_OKL_TAX_LINES_rec);
561: END null_out_defaults;
562: ---------------------------------
563: -- Validate_Attributes for: ID --
564: ---------------------------------
656: ---------------------------------------------------------------------------
657: -- FUNCTION Validate_Attributes
658: ---------------------------------------------------------------------------
659: ---------------------------------------------
660: -- Validate_Attributes for:OKL_TAX_LINES_V --
661: ---------------------------------------------
662: FUNCTION Validate_Attributes (
663: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type
664: ) RETURN VARCHAR2 IS
659: ---------------------------------------------
660: -- Validate_Attributes for:OKL_TAX_LINES_V --
661: ---------------------------------------------
662: FUNCTION Validate_Attributes (
663: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type
664: ) RETURN VARCHAR2 IS
665: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
666: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
667: BEGIN
670: -----------------------------
671: -- ***
672: -- id
673: -- ***
674: validate_id(x_return_status, p_OKL_TAX_LINES_rec.id);
675: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
676: l_return_status := x_return_status;
677: RAISE G_EXCEPTION_HALT_VALIDATION;
678: END IF;
679:
680: -- ***
681: -- khr_id
682: -- ***
683: validate_khr_id(x_return_status, p_OKL_TAX_LINES_rec.khr_id);
684: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
685: l_return_status := x_return_status;
686: RAISE G_EXCEPTION_HALT_VALIDATION;
687: END IF;
688:
689: -- ***
690: -- tax_line_type
691: -- ***
692: validate_tax_line_type(x_return_status, p_OKL_TAX_LINES_rec.tax_line_type);
693: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
694: l_return_status := x_return_status;
695: RAISE G_EXCEPTION_HALT_VALIDATION;
696: END IF;
712: ---------------------------------------------------------------------------
713: -- PROCEDURE Validate_Record
714: ---------------------------------------------------------------------------
715: -----------------------------------------
716: -- Validate Record for:OKL_TAX_LINES_V --
717: -----------------------------------------
718: FUNCTION Validate_Record (
719: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type,
720: p_db_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type
715: -----------------------------------------
716: -- Validate Record for:OKL_TAX_LINES_V --
717: -----------------------------------------
718: FUNCTION Validate_Record (
719: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type,
720: p_db_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type
721: ) RETURN VARCHAR2 IS
722: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
723: ------------------------------------
716: -- Validate Record for:OKL_TAX_LINES_V --
717: -----------------------------------------
718: FUNCTION Validate_Record (
719: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type,
720: p_db_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type
721: ) RETURN VARCHAR2 IS
722: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
723: ------------------------------------
724: -- FUNCTION validate_foreign_keys --
723: ------------------------------------
724: -- FUNCTION validate_foreign_keys --
725: ------------------------------------
726: FUNCTION validate_foreign_keys (
727: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type,
728: p_db_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type
729: ) RETURN VARCHAR2 IS
730: item_not_found_error EXCEPTION;
731: --Fixed Bug#5484903
724: -- FUNCTION validate_foreign_keys --
725: ------------------------------------
726: FUNCTION validate_foreign_keys (
727: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type,
728: p_db_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type
729: ) RETURN VARCHAR2 IS
730: item_not_found_error EXCEPTION;
731: --Fixed Bug#5484903
732: CURSOR okl_taxv_fnd_fk_csr (p_lookup_code IN VARCHAR2) IS
744:
745: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
746: l_row_notfound BOOLEAN := TRUE;
747: BEGIN
748: IF ((p_OKL_TAX_LINES_rec.TAX_LINE_TYPE IS NOT NULL)
749: AND
750: (p_OKL_TAX_LINES_rec.TAX_LINE_TYPE <> p_db_OKL_TAX_LINES_rec.TAX_LINE_TYPE))
751: THEN
752: OPEN okl_taxv_trqv_fk_csr (p_OKL_TAX_LINES_rec.TRQ_ID);
746: l_row_notfound BOOLEAN := TRUE;
747: BEGIN
748: IF ((p_OKL_TAX_LINES_rec.TAX_LINE_TYPE IS NOT NULL)
749: AND
750: (p_OKL_TAX_LINES_rec.TAX_LINE_TYPE <> p_db_OKL_TAX_LINES_rec.TAX_LINE_TYPE))
751: THEN
752: OPEN okl_taxv_trqv_fk_csr (p_OKL_TAX_LINES_rec.TRQ_ID);
753: FETCH okl_taxv_trqv_fk_csr INTO l_okl_taxv_trqv_fk;
754: l_row_notfound := okl_taxv_trqv_fk_csr%NOTFOUND;
748: IF ((p_OKL_TAX_LINES_rec.TAX_LINE_TYPE IS NOT NULL)
749: AND
750: (p_OKL_TAX_LINES_rec.TAX_LINE_TYPE <> p_db_OKL_TAX_LINES_rec.TAX_LINE_TYPE))
751: THEN
752: OPEN okl_taxv_trqv_fk_csr (p_OKL_TAX_LINES_rec.TRQ_ID);
753: FETCH okl_taxv_trqv_fk_csr INTO l_okl_taxv_trqv_fk;
754: l_row_notfound := okl_taxv_trqv_fk_csr%NOTFOUND;
755: CLOSE okl_taxv_trqv_fk_csr;
756: IF (l_row_notfound) THEN
756: IF (l_row_notfound) THEN
757: RAISE item_not_found_error;
758: END IF;
759: END IF;
760: IF ((p_OKL_TAX_LINES_rec.TAX_LINE_TYPE IS NOT NULL)
761: AND
762: (p_OKL_TAX_LINES_rec.TAX_LINE_TYPE <> p_db_OKL_TAX_LINES_rec.TAX_LINE_TYPE))
763: THEN
764: OPEN okl_taxv_fnd_fk_csr (p_OKL_TAX_LINES_rec.TAX_LINE_TYPE);
758: END IF;
759: END IF;
760: IF ((p_OKL_TAX_LINES_rec.TAX_LINE_TYPE IS NOT NULL)
761: AND
762: (p_OKL_TAX_LINES_rec.TAX_LINE_TYPE <> p_db_OKL_TAX_LINES_rec.TAX_LINE_TYPE))
763: THEN
764: OPEN okl_taxv_fnd_fk_csr (p_OKL_TAX_LINES_rec.TAX_LINE_TYPE);
765: FETCH okl_taxv_fnd_fk_csr INTO l_okl_taxv_fnd_fk;
766: l_row_notfound := okl_taxv_fnd_fk_csr%NOTFOUND;
760: IF ((p_OKL_TAX_LINES_rec.TAX_LINE_TYPE IS NOT NULL)
761: AND
762: (p_OKL_TAX_LINES_rec.TAX_LINE_TYPE <> p_db_OKL_TAX_LINES_rec.TAX_LINE_TYPE))
763: THEN
764: OPEN okl_taxv_fnd_fk_csr (p_OKL_TAX_LINES_rec.TAX_LINE_TYPE);
765: FETCH okl_taxv_fnd_fk_csr INTO l_okl_taxv_fnd_fk;
766: l_row_notfound := okl_taxv_fnd_fk_csr%NOTFOUND;
767: CLOSE okl_taxv_fnd_fk_csr;
768: IF (l_row_notfound) THEN
776: l_return_status := OKC_API.G_RET_STS_ERROR;
777: RETURN (l_return_status);
778: END validate_foreign_keys;
779: BEGIN
780: l_return_status := validate_foreign_keys(p_OKL_TAX_LINES_rec, p_db_OKL_TAX_LINES_rec);
781: RETURN (l_return_status);
782: END Validate_Record;
783: FUNCTION Validate_Record (
784: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type
780: l_return_status := validate_foreign_keys(p_OKL_TAX_LINES_rec, p_db_OKL_TAX_LINES_rec);
781: RETURN (l_return_status);
782: END Validate_Record;
783: FUNCTION Validate_Record (
784: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type
785: ) RETURN VARCHAR2 IS
786: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
787: l_db_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type := get_rec(p_OKL_TAX_LINES_rec);
788: BEGIN
783: FUNCTION Validate_Record (
784: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type
785: ) RETURN VARCHAR2 IS
786: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
787: l_db_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type := get_rec(p_OKL_TAX_LINES_rec);
788: BEGIN
789: l_return_status := Validate_Record(p_OKL_TAX_LINES_rec => p_OKL_TAX_LINES_rec,
790: p_db_OKL_TAX_LINES_rec => l_db_OKL_TAX_LINES_rec);
791: RETURN (l_return_status);
785: ) RETURN VARCHAR2 IS
786: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
787: l_db_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type := get_rec(p_OKL_TAX_LINES_rec);
788: BEGIN
789: l_return_status := Validate_Record(p_OKL_TAX_LINES_rec => p_OKL_TAX_LINES_rec,
790: p_db_OKL_TAX_LINES_rec => l_db_OKL_TAX_LINES_rec);
791: RETURN (l_return_status);
792: END Validate_Record;
793:
786: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
787: l_db_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type := get_rec(p_OKL_TAX_LINES_rec);
788: BEGIN
789: l_return_status := Validate_Record(p_OKL_TAX_LINES_rec => p_OKL_TAX_LINES_rec,
790: p_db_OKL_TAX_LINES_rec => l_db_OKL_TAX_LINES_rec);
791: RETURN (l_return_status);
792: END Validate_Record;
793:
794: ---------------------------------------------------------------------------
794: ---------------------------------------------------------------------------
795: -- PROCEDURE Migrate
796: ---------------------------------------------------------------------------
797: PROCEDURE migrate (
798: p_from IN OKL_TAX_LINES_rec_type,
799: p_to IN OUT NOCOPY tax_rec_type
800: ) IS
801: BEGIN
802: p_to.id := p_from.id;
851: p_to.last_update_login := p_from.last_update_login;
852: END migrate;
853: PROCEDURE migrate (
854: p_from IN tax_rec_type,
855: p_to IN OUT NOCOPY OKL_TAX_LINES_rec_type
856: ) IS
857: BEGIN
858: p_to.id := p_from.id;
859: p_to.khr_id := p_from.khr_id;
909: ---------------------------------------------------------------------------
910: -- PROCEDURE validate_row
911: ---------------------------------------------------------------------------
912: --------------------------------------
913: -- validate_row for:OKL_TAX_LINES_V --
914: --------------------------------------
915: PROCEDURE validate_row(
916: p_api_version IN NUMBER,
917: p_init_msg_list IN VARCHAR2,
917: p_init_msg_list IN VARCHAR2,
918: x_return_status OUT NOCOPY VARCHAR2,
919: x_msg_count OUT NOCOPY NUMBER,
920: x_msg_data OUT NOCOPY VARCHAR2,
921: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type) IS
922:
923: l_api_version CONSTANT NUMBER := 1;
924: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
925: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
922:
923: l_api_version CONSTANT NUMBER := 1;
924: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
925: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
926: l_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type := p_OKL_TAX_LINES_rec;
927: l_tax_rec tax_rec_type;
928: l_tax_rec tax_rec_type;
929: BEGIN
930: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
939: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
940: RAISE OKC_API.G_EXCEPTION_ERROR;
941: END IF;
942: --- Validate all non-missing attributes (Item Level Validation)
943: l_return_status := Validate_Attributes(l_OKL_TAX_LINES_rec);
944: --- If any errors happen abort API
945: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
946: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
947: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
946: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
947: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
948: RAISE OKC_API.G_EXCEPTION_ERROR;
949: END IF;
950: l_return_status := Validate_Record(l_OKL_TAX_LINES_rec);
951: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
952: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
953: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
954: RAISE OKC_API.G_EXCEPTION_ERROR;
986: '_PVT'
987: );
988: END validate_row;
989: -------------------------------------------------
990: -- PL/SQL TBL validate_row for:OKL_TAX_LINES_V --
991: -------------------------------------------------
992: PROCEDURE validate_row(
993: p_api_version IN NUMBER,
994: p_init_msg_list IN VARCHAR2,
994: p_init_msg_list IN VARCHAR2,
995: x_return_status OUT NOCOPY VARCHAR2,
996: x_msg_count OUT NOCOPY NUMBER,
997: x_msg_data OUT NOCOPY VARCHAR2,
998: p_OKL_TAX_LINES_tbl IN OKL_TAX_LINES_tbl_type,
999: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
1000:
1001: l_api_version CONSTANT NUMBER := 1;
1002: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_validate_row';
1003: i NUMBER := 0;
1004: BEGIN
1005: OKC_API.init_msg_list(p_init_msg_list);
1006: -- Make sure PL/SQL table has records in it before passing
1007: IF (p_OKL_TAX_LINES_tbl.COUNT > 0) THEN
1008: i := p_OKL_TAX_LINES_tbl.FIRST;
1009: LOOP
1010: DECLARE
1011: l_error_rec OKC_API.ERROR_REC_TYPE;
1004: BEGIN
1005: OKC_API.init_msg_list(p_init_msg_list);
1006: -- Make sure PL/SQL table has records in it before passing
1007: IF (p_OKL_TAX_LINES_tbl.COUNT > 0) THEN
1008: i := p_OKL_TAX_LINES_tbl.FIRST;
1009: LOOP
1010: DECLARE
1011: l_error_rec OKC_API.ERROR_REC_TYPE;
1012: BEGIN
1018: p_init_msg_list => OKC_API.G_FALSE,
1019: x_return_status => l_error_rec.error_type,
1020: x_msg_count => l_error_rec.msg_count,
1021: x_msg_data => l_error_rec.msg_data,
1022: p_OKL_TAX_LINES_rec => p_OKL_TAX_LINES_tbl(i));
1023: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
1024: l_error_rec.sqlcode := SQLCODE;
1025: load_error_tbl(l_error_rec, px_error_tbl);
1026: ELSE
1040: l_error_rec.error_type := 'OTHERS';
1041: l_error_rec.sqlcode := SQLCODE;
1042: load_error_tbl(l_error_rec, px_error_tbl);
1043: END;
1044: EXIT WHEN (i = p_OKL_TAX_LINES_tbl.LAST);
1045: i := p_OKL_TAX_LINES_tbl.NEXT(i);
1046: END LOOP;
1047: END IF;
1048: -- Loop through the error_tbl to find the error with the highest severity
1041: l_error_rec.sqlcode := SQLCODE;
1042: load_error_tbl(l_error_rec, px_error_tbl);
1043: END;
1044: EXIT WHEN (i = p_OKL_TAX_LINES_tbl.LAST);
1045: i := p_OKL_TAX_LINES_tbl.NEXT(i);
1046: END LOOP;
1047: END IF;
1048: -- Loop through the error_tbl to find the error with the highest severity
1049: -- and return it.
1082: );
1083: END validate_row;
1084:
1085: -------------------------------------------------
1086: -- PL/SQL TBL validate_row for:OKL_TAX_LINES_V --
1087: -------------------------------------------------
1088: PROCEDURE validate_row(
1089: p_api_version IN NUMBER,
1090: p_init_msg_list IN VARCHAR2,
1090: p_init_msg_list IN VARCHAR2,
1091: x_return_status OUT NOCOPY VARCHAR2,
1092: x_msg_count OUT NOCOPY NUMBER,
1093: x_msg_data OUT NOCOPY VARCHAR2,
1094: p_OKL_TAX_LINES_tbl IN OKL_TAX_LINES_tbl_type) IS
1095:
1096: l_api_version CONSTANT NUMBER := 1;
1097: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
1098: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1099: l_error_tbl OKC_API.ERROR_TBL_TYPE;
1100: BEGIN
1101: OKC_API.init_msg_list(p_init_msg_list);
1102: -- Make sure PL/SQL table has records in it before passing
1103: IF (p_OKL_TAX_LINES_tbl.COUNT > 0) THEN
1104: validate_row (
1105: p_api_version => p_api_version,
1106: p_init_msg_list => OKC_API.G_FALSE,
1107: x_return_status => x_return_status,
1106: p_init_msg_list => OKC_API.G_FALSE,
1107: x_return_status => x_return_status,
1108: x_msg_count => x_msg_count,
1109: x_msg_data => x_msg_data,
1110: p_OKL_TAX_LINES_tbl => p_OKL_TAX_LINES_tbl,
1111: px_error_tbl => l_error_tbl);
1112: END IF;
1113: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1114: EXCEPTION
1147: ---------------------------------------------------------------------------
1148: -- PROCEDURE insert_row
1149: ---------------------------------------------------------------------------
1150: ----------------------------------
1151: -- insert_row for:OKL_TAX_LINES --
1152: ----------------------------------
1153: PROCEDURE insert_row(
1154: p_init_msg_list IN VARCHAR2,
1155: x_return_status OUT NOCOPY VARCHAR2,
1163: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1164: l_tax_rec tax_rec_type := p_tax_rec;
1165: l_def_tax_rec tax_rec_type;
1166: --------------------------------------
1167: -- Set_Attributes for:OKL_TAX_LINES --
1168: --------------------------------------
1169: FUNCTION Set_Attributes (
1170: p_tax_rec IN tax_rec_type,
1171: x_tax_rec OUT NOCOPY tax_rec_type
1194: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1195: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1196: RAISE OKC_API.G_EXCEPTION_ERROR;
1197: END IF;
1198: INSERT INTO OKL_TAX_LINES(
1199: id,
1200: khr_id,
1201: kle_id,
1202: asset_id,
1333: '_PVT'
1334: );
1335: END insert_row;
1336: -------------------------------------
1337: -- insert_row for :OKL_TAX_LINES_V --
1338: -------------------------------------
1339: PROCEDURE insert_row(
1340: p_api_version IN NUMBER,
1341: p_init_msg_list IN VARCHAR2,
1341: p_init_msg_list IN VARCHAR2,
1342: x_return_status OUT NOCOPY VARCHAR2,
1343: x_msg_count OUT NOCOPY NUMBER,
1344: x_msg_data OUT NOCOPY VARCHAR2,
1345: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type,
1346: x_OKL_TAX_LINES_rec OUT NOCOPY OKL_TAX_LINES_rec_type) IS
1347:
1348: l_api_version CONSTANT NUMBER := 1;
1349: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1342: x_return_status OUT NOCOPY VARCHAR2,
1343: x_msg_count OUT NOCOPY NUMBER,
1344: x_msg_data OUT NOCOPY VARCHAR2,
1345: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type,
1346: x_OKL_TAX_LINES_rec OUT NOCOPY OKL_TAX_LINES_rec_type) IS
1347:
1348: l_api_version CONSTANT NUMBER := 1;
1349: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1350: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1347:
1348: l_api_version CONSTANT NUMBER := 1;
1349: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1350: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1351: l_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type := p_OKL_TAX_LINES_rec;
1352: l_def_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type;
1353: l_tax_rec tax_rec_type;
1354: lx_tax_rec tax_rec_type;
1355: -------------------------------
1348: l_api_version CONSTANT NUMBER := 1;
1349: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1350: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1351: l_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type := p_OKL_TAX_LINES_rec;
1352: l_def_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type;
1353: l_tax_rec tax_rec_type;
1354: lx_tax_rec tax_rec_type;
1355: -------------------------------
1356: -- FUNCTION fill_who_columns --
1355: -------------------------------
1356: -- FUNCTION fill_who_columns --
1357: -------------------------------
1358: FUNCTION fill_who_columns (
1359: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type
1360: ) RETURN OKL_TAX_LINES_rec_type IS
1361: l_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type := p_OKL_TAX_LINES_rec;
1362: BEGIN
1363: l_OKL_TAX_LINES_rec.CREATION_DATE := SYSDATE;
1356: -- FUNCTION fill_who_columns --
1357: -------------------------------
1358: FUNCTION fill_who_columns (
1359: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type
1360: ) RETURN OKL_TAX_LINES_rec_type IS
1361: l_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type := p_OKL_TAX_LINES_rec;
1362: BEGIN
1363: l_OKL_TAX_LINES_rec.CREATION_DATE := SYSDATE;
1364: l_OKL_TAX_LINES_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1357: -------------------------------
1358: FUNCTION fill_who_columns (
1359: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type
1360: ) RETURN OKL_TAX_LINES_rec_type IS
1361: l_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type := p_OKL_TAX_LINES_rec;
1362: BEGIN
1363: l_OKL_TAX_LINES_rec.CREATION_DATE := SYSDATE;
1364: l_OKL_TAX_LINES_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1365: l_OKL_TAX_LINES_rec.LAST_UPDATE_DATE := l_OKL_TAX_LINES_rec.CREATION_DATE;
1359: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type
1360: ) RETURN OKL_TAX_LINES_rec_type IS
1361: l_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type := p_OKL_TAX_LINES_rec;
1362: BEGIN
1363: l_OKL_TAX_LINES_rec.CREATION_DATE := SYSDATE;
1364: l_OKL_TAX_LINES_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1365: l_OKL_TAX_LINES_rec.LAST_UPDATE_DATE := l_OKL_TAX_LINES_rec.CREATION_DATE;
1366: l_OKL_TAX_LINES_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1367: l_OKL_TAX_LINES_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1360: ) RETURN OKL_TAX_LINES_rec_type IS
1361: l_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type := p_OKL_TAX_LINES_rec;
1362: BEGIN
1363: l_OKL_TAX_LINES_rec.CREATION_DATE := SYSDATE;
1364: l_OKL_TAX_LINES_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1365: l_OKL_TAX_LINES_rec.LAST_UPDATE_DATE := l_OKL_TAX_LINES_rec.CREATION_DATE;
1366: l_OKL_TAX_LINES_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1367: l_OKL_TAX_LINES_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1368: RETURN(l_OKL_TAX_LINES_rec);
1361: l_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type := p_OKL_TAX_LINES_rec;
1362: BEGIN
1363: l_OKL_TAX_LINES_rec.CREATION_DATE := SYSDATE;
1364: l_OKL_TAX_LINES_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1365: l_OKL_TAX_LINES_rec.LAST_UPDATE_DATE := l_OKL_TAX_LINES_rec.CREATION_DATE;
1366: l_OKL_TAX_LINES_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1367: l_OKL_TAX_LINES_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1368: RETURN(l_OKL_TAX_LINES_rec);
1369: END fill_who_columns;
1362: BEGIN
1363: l_OKL_TAX_LINES_rec.CREATION_DATE := SYSDATE;
1364: l_OKL_TAX_LINES_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1365: l_OKL_TAX_LINES_rec.LAST_UPDATE_DATE := l_OKL_TAX_LINES_rec.CREATION_DATE;
1366: l_OKL_TAX_LINES_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1367: l_OKL_TAX_LINES_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1368: RETURN(l_OKL_TAX_LINES_rec);
1369: END fill_who_columns;
1370: ----------------------------------------
1363: l_OKL_TAX_LINES_rec.CREATION_DATE := SYSDATE;
1364: l_OKL_TAX_LINES_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1365: l_OKL_TAX_LINES_rec.LAST_UPDATE_DATE := l_OKL_TAX_LINES_rec.CREATION_DATE;
1366: l_OKL_TAX_LINES_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1367: l_OKL_TAX_LINES_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1368: RETURN(l_OKL_TAX_LINES_rec);
1369: END fill_who_columns;
1370: ----------------------------------------
1371: -- Set_Attributes for:OKL_TAX_LINES_V --
1364: l_OKL_TAX_LINES_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1365: l_OKL_TAX_LINES_rec.LAST_UPDATE_DATE := l_OKL_TAX_LINES_rec.CREATION_DATE;
1366: l_OKL_TAX_LINES_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1367: l_OKL_TAX_LINES_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1368: RETURN(l_OKL_TAX_LINES_rec);
1369: END fill_who_columns;
1370: ----------------------------------------
1371: -- Set_Attributes for:OKL_TAX_LINES_V --
1372: ----------------------------------------
1367: l_OKL_TAX_LINES_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1368: RETURN(l_OKL_TAX_LINES_rec);
1369: END fill_who_columns;
1370: ----------------------------------------
1371: -- Set_Attributes for:OKL_TAX_LINES_V --
1372: ----------------------------------------
1373: FUNCTION Set_Attributes (
1374: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type,
1375: x_OKL_TAX_LINES_rec OUT NOCOPY OKL_TAX_LINES_rec_type
1370: ----------------------------------------
1371: -- Set_Attributes for:OKL_TAX_LINES_V --
1372: ----------------------------------------
1373: FUNCTION Set_Attributes (
1374: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type,
1375: x_OKL_TAX_LINES_rec OUT NOCOPY OKL_TAX_LINES_rec_type
1376: ) RETURN VARCHAR2 IS
1377: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1378: BEGIN
1371: -- Set_Attributes for:OKL_TAX_LINES_V --
1372: ----------------------------------------
1373: FUNCTION Set_Attributes (
1374: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type,
1375: x_OKL_TAX_LINES_rec OUT NOCOPY OKL_TAX_LINES_rec_type
1376: ) RETURN VARCHAR2 IS
1377: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1378: BEGIN
1379: x_OKL_TAX_LINES_rec := p_OKL_TAX_LINES_rec;
1375: x_OKL_TAX_LINES_rec OUT NOCOPY OKL_TAX_LINES_rec_type
1376: ) RETURN VARCHAR2 IS
1377: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1378: BEGIN
1379: x_OKL_TAX_LINES_rec := p_OKL_TAX_LINES_rec;
1380: RETURN(l_return_status);
1381: END Set_Attributes;
1382: BEGIN
1383: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1391: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1392: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1393: RAISE OKC_API.G_EXCEPTION_ERROR;
1394: END IF;
1395: l_OKL_TAX_LINES_rec := null_out_defaults(p_OKL_TAX_LINES_rec);
1396: -- Set primary key value
1397: l_OKL_TAX_LINES_rec.ID := get_seq_id;
1398: -- Setting item attributes
1399: l_return_Status := Set_Attributes(
1393: RAISE OKC_API.G_EXCEPTION_ERROR;
1394: END IF;
1395: l_OKL_TAX_LINES_rec := null_out_defaults(p_OKL_TAX_LINES_rec);
1396: -- Set primary key value
1397: l_OKL_TAX_LINES_rec.ID := get_seq_id;
1398: -- Setting item attributes
1399: l_return_Status := Set_Attributes(
1400: l_OKL_TAX_LINES_rec, -- IN
1401: l_def_OKL_TAX_LINES_rec); -- OUT
1396: -- Set primary key value
1397: l_OKL_TAX_LINES_rec.ID := get_seq_id;
1398: -- Setting item attributes
1399: l_return_Status := Set_Attributes(
1400: l_OKL_TAX_LINES_rec, -- IN
1401: l_def_OKL_TAX_LINES_rec); -- OUT
1402: --- If any errors happen abort API
1403: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1404: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1397: l_OKL_TAX_LINES_rec.ID := get_seq_id;
1398: -- Setting item attributes
1399: l_return_Status := Set_Attributes(
1400: l_OKL_TAX_LINES_rec, -- IN
1401: l_def_OKL_TAX_LINES_rec); -- OUT
1402: --- If any errors happen abort API
1403: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1404: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1405: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1404: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1405: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1406: RAISE OKC_API.G_EXCEPTION_ERROR;
1407: END IF;
1408: l_def_OKL_TAX_LINES_rec := fill_who_columns(l_def_OKL_TAX_LINES_rec);
1409: --- Validate all non-missing attributes (Item Level Validation)
1410: l_return_status := Validate_Attributes(l_def_OKL_TAX_LINES_rec);
1411: --- If any errors happen abort API
1412: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1406: RAISE OKC_API.G_EXCEPTION_ERROR;
1407: END IF;
1408: l_def_OKL_TAX_LINES_rec := fill_who_columns(l_def_OKL_TAX_LINES_rec);
1409: --- Validate all non-missing attributes (Item Level Validation)
1410: l_return_status := Validate_Attributes(l_def_OKL_TAX_LINES_rec);
1411: --- If any errors happen abort API
1412: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1413: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1414: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1413: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1414: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1415: RAISE OKC_API.G_EXCEPTION_ERROR;
1416: END IF;
1417: l_return_status := Validate_Record(l_def_OKL_TAX_LINES_rec);
1418: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1419: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1420: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1421: RAISE OKC_API.G_EXCEPTION_ERROR;
1422: END IF;
1423: -----------------------------------------
1424: -- Move VIEW record to "Child" records --
1425: -----------------------------------------
1426: migrate(l_def_OKL_TAX_LINES_rec, l_tax_rec);
1427: -----------------------------------------------
1428: -- Call the INSERT_ROW for each child record --
1429: -----------------------------------------------
1430: insert_row(
1439: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1440: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1441: RAISE OKC_API.G_EXCEPTION_ERROR;
1442: END IF;
1443: migrate(lx_tax_rec, l_def_OKL_TAX_LINES_rec);
1444: -- Set OUT values
1445: x_OKL_TAX_LINES_rec := l_def_OKL_TAX_LINES_rec;
1446: x_return_status := l_return_status;
1447: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1441: RAISE OKC_API.G_EXCEPTION_ERROR;
1442: END IF;
1443: migrate(lx_tax_rec, l_def_OKL_TAX_LINES_rec);
1444: -- Set OUT values
1445: x_OKL_TAX_LINES_rec := l_def_OKL_TAX_LINES_rec;
1446: x_return_status := l_return_status;
1447: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1448: EXCEPTION
1449: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1477: '_PVT'
1478: );
1479: END insert_row;
1480: ---------------------------------------------------
1481: -- PL/SQL TBL insert_row for:OKL_TAX_LINES_V_TBL --
1482: ---------------------------------------------------
1483: PROCEDURE insert_row(
1484: p_api_version IN NUMBER,
1485: p_init_msg_list IN VARCHAR2,
1485: p_init_msg_list IN VARCHAR2,
1486: x_return_status OUT NOCOPY VARCHAR2,
1487: x_msg_count OUT NOCOPY NUMBER,
1488: x_msg_data OUT NOCOPY VARCHAR2,
1489: p_OKL_TAX_LINES_tbl IN OKL_TAX_LINES_tbl_type,
1490: x_OKL_TAX_LINES_tbl OUT NOCOPY OKL_TAX_LINES_tbl_type,
1491: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
1492:
1493: l_api_version CONSTANT NUMBER := 1;
1486: x_return_status OUT NOCOPY VARCHAR2,
1487: x_msg_count OUT NOCOPY NUMBER,
1488: x_msg_data OUT NOCOPY VARCHAR2,
1489: p_OKL_TAX_LINES_tbl IN OKL_TAX_LINES_tbl_type,
1490: x_OKL_TAX_LINES_tbl OUT NOCOPY OKL_TAX_LINES_tbl_type,
1491: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
1492:
1493: l_api_version CONSTANT NUMBER := 1;
1494: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
1495: i NUMBER := 0;
1496: BEGIN
1497: OKC_API.init_msg_list(p_init_msg_list);
1498: -- Make sure PL/SQL table has records in it before passing
1499: IF (p_OKL_TAX_LINES_tbl.COUNT > 0) THEN
1500: i := p_OKL_TAX_LINES_tbl.FIRST;
1501: LOOP
1502: DECLARE
1503: l_error_rec OKC_API.ERROR_REC_TYPE;
1496: BEGIN
1497: OKC_API.init_msg_list(p_init_msg_list);
1498: -- Make sure PL/SQL table has records in it before passing
1499: IF (p_OKL_TAX_LINES_tbl.COUNT > 0) THEN
1500: i := p_OKL_TAX_LINES_tbl.FIRST;
1501: LOOP
1502: DECLARE
1503: l_error_rec OKC_API.ERROR_REC_TYPE;
1504: BEGIN
1510: p_init_msg_list => OKC_API.G_FALSE,
1511: x_return_status => l_error_rec.error_type,
1512: x_msg_count => l_error_rec.msg_count,
1513: x_msg_data => l_error_rec.msg_data,
1514: p_OKL_TAX_LINES_rec => p_OKL_TAX_LINES_tbl(i),
1515: x_OKL_TAX_LINES_rec => x_OKL_TAX_LINES_tbl(i));
1516: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
1517: l_error_rec.sqlcode := SQLCODE;
1518: load_error_tbl(l_error_rec, px_error_tbl);
1511: x_return_status => l_error_rec.error_type,
1512: x_msg_count => l_error_rec.msg_count,
1513: x_msg_data => l_error_rec.msg_data,
1514: p_OKL_TAX_LINES_rec => p_OKL_TAX_LINES_tbl(i),
1515: x_OKL_TAX_LINES_rec => x_OKL_TAX_LINES_tbl(i));
1516: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
1517: l_error_rec.sqlcode := SQLCODE;
1518: load_error_tbl(l_error_rec, px_error_tbl);
1519: ELSE
1533: l_error_rec.error_type := 'OTHERS';
1534: l_error_rec.sqlcode := SQLCODE;
1535: load_error_tbl(l_error_rec, px_error_tbl);
1536: END;
1537: EXIT WHEN (i = p_OKL_TAX_LINES_tbl.LAST);
1538: i := p_OKL_TAX_LINES_tbl.NEXT(i);
1539: END LOOP;
1540: END IF;
1541: -- Loop through the error_tbl to find the error with the highest severity
1534: l_error_rec.sqlcode := SQLCODE;
1535: load_error_tbl(l_error_rec, px_error_tbl);
1536: END;
1537: EXIT WHEN (i = p_OKL_TAX_LINES_tbl.LAST);
1538: i := p_OKL_TAX_LINES_tbl.NEXT(i);
1539: END LOOP;
1540: END IF;
1541: -- Loop through the error_tbl to find the error with the highest severity
1542: -- and return it.
1575: );
1576: END insert_row;
1577:
1578: ---------------------------------------------------
1579: -- PL/SQL TBL insert_row for:OKL_TAX_LINES_V_TBL --
1580: ---------------------------------------------------
1581: -- This procedure is the same as the one above except it does not have a "px_error_tbl" argument.
1582: -- This procedure was create for backward compatibility and simply is a wrapper for the one above.
1583: PROCEDURE insert_row(
1585: p_init_msg_list IN VARCHAR2,
1586: x_return_status OUT NOCOPY VARCHAR2,
1587: x_msg_count OUT NOCOPY NUMBER,
1588: x_msg_data OUT NOCOPY VARCHAR2,
1589: p_OKL_TAX_LINES_tbl IN OKL_TAX_LINES_tbl_type,
1590: x_OKL_TAX_LINES_tbl OUT NOCOPY OKL_TAX_LINES_tbl_type) IS
1591:
1592: l_api_version CONSTANT NUMBER := 1;
1593: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1586: x_return_status OUT NOCOPY VARCHAR2,
1587: x_msg_count OUT NOCOPY NUMBER,
1588: x_msg_data OUT NOCOPY VARCHAR2,
1589: p_OKL_TAX_LINES_tbl IN OKL_TAX_LINES_tbl_type,
1590: x_OKL_TAX_LINES_tbl OUT NOCOPY OKL_TAX_LINES_tbl_type) IS
1591:
1592: l_api_version CONSTANT NUMBER := 1;
1593: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1594: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1595: l_error_tbl OKC_API.ERROR_TBL_TYPE;
1596: BEGIN
1597: OKC_API.init_msg_list(p_init_msg_list);
1598: -- Make sure PL/SQL table has records in it before passing
1599: IF (p_OKL_TAX_LINES_tbl.COUNT > 0) THEN
1600: insert_row (
1601: p_api_version => p_api_version,
1602: p_init_msg_list => OKC_API.G_FALSE,
1603: x_return_status => x_return_status,
1602: p_init_msg_list => OKC_API.G_FALSE,
1603: x_return_status => x_return_status,
1604: x_msg_count => x_msg_count,
1605: x_msg_data => x_msg_data,
1606: p_OKL_TAX_LINES_tbl => p_OKL_TAX_LINES_tbl,
1607: x_OKL_TAX_LINES_tbl => x_OKL_TAX_LINES_tbl,
1608: px_error_tbl => l_error_tbl);
1609: END IF;
1610: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1603: x_return_status => x_return_status,
1604: x_msg_count => x_msg_count,
1605: x_msg_data => x_msg_data,
1606: p_OKL_TAX_LINES_tbl => p_OKL_TAX_LINES_tbl,
1607: x_OKL_TAX_LINES_tbl => x_OKL_TAX_LINES_tbl,
1608: px_error_tbl => l_error_tbl);
1609: END IF;
1610: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1611: EXCEPTION
1644: ---------------------------------------------------------------------------
1645: -- PROCEDURE lock_row
1646: ---------------------------------------------------------------------------
1647: --------------------------------
1648: -- lock_row for:OKL_TAX_LINES --
1649: --------------------------------
1650: PROCEDURE lock_row(
1651: p_init_msg_list IN VARCHAR2,
1652: x_return_status OUT NOCOPY VARCHAR2,
1657: E_Resource_Busy EXCEPTION;
1658: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1659: CURSOR lock_csr (p_tax_rec IN tax_rec_type) IS
1660: SELECT *
1661: FROM OKL_TAX_LINES
1662: WHERE ID = p_tax_rec.id
1663: FOR UPDATE NOWAIT;
1664:
1665: l_api_version CONSTANT NUMBER := 1;
1931: '_PVT'
1932: );
1933: END lock_row;
1934: -----------------------------------
1935: -- lock_row for: OKL_TAX_LINES_V --
1936: -----------------------------------
1937: PROCEDURE lock_row(
1938: p_api_version IN NUMBER,
1939: p_init_msg_list IN VARCHAR2,
1939: p_init_msg_list IN VARCHAR2,
1940: x_return_status OUT NOCOPY VARCHAR2,
1941: x_msg_count OUT NOCOPY NUMBER,
1942: x_msg_data OUT NOCOPY VARCHAR2,
1943: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type) IS
1944:
1945: l_api_version CONSTANT NUMBER := 1;
1946: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1947: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1961: END IF;
1962: -----------------------------------------
1963: -- Move VIEW record to "Child" records --
1964: -----------------------------------------
1965: migrate(p_OKL_TAX_LINES_rec, l_tax_rec);
1966: ---------------------------------------------
1967: -- Call the LOCK_ROW for each child record --
1968: ---------------------------------------------
1969: lock_row(
2012: '_PVT'
2013: );
2014: END lock_row;
2015: -------------------------------------------------
2016: -- PL/SQL TBL lock_row for:OKL_TAX_LINES_V_TBL --
2017: -------------------------------------------------
2018: PROCEDURE lock_row(
2019: p_api_version IN NUMBER,
2020: p_init_msg_list IN VARCHAR2,
2020: p_init_msg_list IN VARCHAR2,
2021: x_return_status OUT NOCOPY VARCHAR2,
2022: x_msg_count OUT NOCOPY NUMBER,
2023: x_msg_data OUT NOCOPY VARCHAR2,
2024: p_OKL_TAX_LINES_tbl IN OKL_TAX_LINES_tbl_type,
2025: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
2026:
2027: l_api_version CONSTANT NUMBER := 1;
2028: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_lock_row';
2029: i NUMBER := 0;
2030: BEGIN
2031: OKC_API.init_msg_list(p_init_msg_list);
2032: -- Make sure PL/SQL table has recrods in it before passing
2033: IF (p_OKL_TAX_LINES_tbl.COUNT > 0) THEN
2034: i := p_OKL_TAX_LINES_tbl.FIRST;
2035: LOOP
2036: DECLARE
2037: l_error_rec OKC_API.ERROR_REC_TYPE;
2030: BEGIN
2031: OKC_API.init_msg_list(p_init_msg_list);
2032: -- Make sure PL/SQL table has recrods in it before passing
2033: IF (p_OKL_TAX_LINES_tbl.COUNT > 0) THEN
2034: i := p_OKL_TAX_LINES_tbl.FIRST;
2035: LOOP
2036: DECLARE
2037: l_error_rec OKC_API.ERROR_REC_TYPE;
2038: BEGIN
2044: p_init_msg_list => OKC_API.G_FALSE,
2045: x_return_status => l_error_rec.error_type,
2046: x_msg_count => l_error_rec.msg_count,
2047: x_msg_data => l_error_rec.msg_data,
2048: p_OKL_TAX_LINES_rec => p_OKL_TAX_LINES_tbl(i));
2049: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
2050: l_error_rec.sqlcode := SQLCODE;
2051: load_error_tbl(l_error_rec, px_error_tbl);
2052: ELSE
2066: l_error_rec.error_type := 'OTHERS';
2067: l_error_rec.sqlcode := SQLCODE;
2068: load_error_tbl(l_error_rec, px_error_tbl);
2069: END;
2070: EXIT WHEN (i = p_OKL_TAX_LINES_tbl.LAST);
2071: i := p_OKL_TAX_LINES_tbl.NEXT(i);
2072: END LOOP;
2073: END IF;
2074: -- Loop through the error_tbl to find the error with the highest severity
2067: l_error_rec.sqlcode := SQLCODE;
2068: load_error_tbl(l_error_rec, px_error_tbl);
2069: END;
2070: EXIT WHEN (i = p_OKL_TAX_LINES_tbl.LAST);
2071: i := p_OKL_TAX_LINES_tbl.NEXT(i);
2072: END LOOP;
2073: END IF;
2074: -- Loop through the error_tbl to find the error with the highest severity
2075: -- and return it.
2107: '_PVT'
2108: );
2109: END lock_row;
2110: -------------------------------------------------
2111: -- PL/SQL TBL lock_row for:OKL_TAX_LINES_V_TBL --
2112: -------------------------------------------------
2113: PROCEDURE lock_row(
2114: p_api_version IN NUMBER,
2115: p_init_msg_list IN VARCHAR2,
2115: p_init_msg_list IN VARCHAR2,
2116: x_return_status OUT NOCOPY VARCHAR2,
2117: x_msg_count OUT NOCOPY NUMBER,
2118: x_msg_data OUT NOCOPY VARCHAR2,
2119: p_OKL_TAX_LINES_tbl IN OKL_TAX_LINES_tbl_type) IS
2120:
2121: l_api_version CONSTANT NUMBER := 1;
2122: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
2123: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2124: l_error_tbl OKC_API.ERROR_TBL_TYPE;
2125: BEGIN
2126: OKC_API.init_msg_list(p_init_msg_list);
2127: -- Make sure PL/SQL table has recrods in it before passing
2128: IF (p_OKL_TAX_LINES_tbl.COUNT > 0) THEN
2129: lock_row(
2130: p_api_version => p_api_version,
2131: p_init_msg_list => OKC_API.G_FALSE,
2132: x_return_status => x_return_status,
2131: p_init_msg_list => OKC_API.G_FALSE,
2132: x_return_status => x_return_status,
2133: x_msg_count => x_msg_count,
2134: x_msg_data => x_msg_data,
2135: p_OKL_TAX_LINES_tbl => p_OKL_TAX_LINES_tbl,
2136: px_error_tbl => l_error_tbl);
2137: END IF;
2138: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2139: EXCEPTION
2171: ---------------------------------------------------------------------------
2172: -- PROCEDURE update_row
2173: ---------------------------------------------------------------------------
2174: ----------------------------------
2175: -- update_row for:OKL_TAX_LINES --
2176: ----------------------------------
2177: PROCEDURE update_row(
2178: p_init_msg_list IN VARCHAR2,
2179: x_return_status OUT NOCOPY VARCHAR2,
2406: END IF;
2407: RETURN(l_return_status);
2408: END populate_new_record;
2409: --------------------------------------
2410: -- Set_Attributes for:OKL_TAX_LINES --
2411: --------------------------------------
2412: FUNCTION Set_Attributes (
2413: p_tax_rec IN tax_rec_type,
2414: x_tax_rec OUT NOCOPY tax_rec_type
2443: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2444: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2445: RAISE OKC_API.G_EXCEPTION_ERROR;
2446: END IF;
2447: UPDATE OKL_TAX_LINES
2448: SET KHR_ID = l_def_tax_rec.khr_id,
2449: KLE_ID = l_def_tax_rec.kle_id,
2450: ASSET_ID = l_def_tax_rec.asset_id,
2451: ASSET_NUMBER = l_def_tax_rec.asset_number,
2531: '_PVT'
2532: );
2533: END update_row;
2534: ------------------------------------
2535: -- update_row for:OKL_TAX_LINES_V --
2536: ------------------------------------
2537: PROCEDURE update_row(
2538: p_api_version IN NUMBER,
2539: p_init_msg_list IN VARCHAR2,
2539: p_init_msg_list IN VARCHAR2,
2540: x_return_status OUT NOCOPY VARCHAR2,
2541: x_msg_count OUT NOCOPY NUMBER,
2542: x_msg_data OUT NOCOPY VARCHAR2,
2543: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type,
2544: x_OKL_TAX_LINES_rec OUT NOCOPY OKL_TAX_LINES_rec_type) IS
2545:
2546: l_api_version CONSTANT NUMBER := 1;
2547: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2540: x_return_status OUT NOCOPY VARCHAR2,
2541: x_msg_count OUT NOCOPY NUMBER,
2542: x_msg_data OUT NOCOPY VARCHAR2,
2543: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type,
2544: x_OKL_TAX_LINES_rec OUT NOCOPY OKL_TAX_LINES_rec_type) IS
2545:
2546: l_api_version CONSTANT NUMBER := 1;
2547: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2548: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2545:
2546: l_api_version CONSTANT NUMBER := 1;
2547: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2548: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2549: l_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type := p_OKL_TAX_LINES_rec;
2550: l_def_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type;
2551: l_db_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type;
2552: l_tax_rec tax_rec_type;
2553: lx_tax_rec tax_rec_type;
2546: l_api_version CONSTANT NUMBER := 1;
2547: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2548: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2549: l_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type := p_OKL_TAX_LINES_rec;
2550: l_def_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type;
2551: l_db_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type;
2552: l_tax_rec tax_rec_type;
2553: lx_tax_rec tax_rec_type;
2554: -------------------------------
2547: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2548: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2549: l_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type := p_OKL_TAX_LINES_rec;
2550: l_def_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type;
2551: l_db_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type;
2552: l_tax_rec tax_rec_type;
2553: lx_tax_rec tax_rec_type;
2554: -------------------------------
2555: -- FUNCTION fill_who_columns --
2554: -------------------------------
2555: -- FUNCTION fill_who_columns --
2556: -------------------------------
2557: FUNCTION fill_who_columns (
2558: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type
2559: ) RETURN OKL_TAX_LINES_rec_type IS
2560: l_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type := p_OKL_TAX_LINES_rec;
2561: BEGIN
2562: l_OKL_TAX_LINES_rec.LAST_UPDATE_DATE := SYSDATE;
2555: -- FUNCTION fill_who_columns --
2556: -------------------------------
2557: FUNCTION fill_who_columns (
2558: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type
2559: ) RETURN OKL_TAX_LINES_rec_type IS
2560: l_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type := p_OKL_TAX_LINES_rec;
2561: BEGIN
2562: l_OKL_TAX_LINES_rec.LAST_UPDATE_DATE := SYSDATE;
2563: l_OKL_TAX_LINES_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2556: -------------------------------
2557: FUNCTION fill_who_columns (
2558: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type
2559: ) RETURN OKL_TAX_LINES_rec_type IS
2560: l_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type := p_OKL_TAX_LINES_rec;
2561: BEGIN
2562: l_OKL_TAX_LINES_rec.LAST_UPDATE_DATE := SYSDATE;
2563: l_OKL_TAX_LINES_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2564: l_OKL_TAX_LINES_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2558: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type
2559: ) RETURN OKL_TAX_LINES_rec_type IS
2560: l_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type := p_OKL_TAX_LINES_rec;
2561: BEGIN
2562: l_OKL_TAX_LINES_rec.LAST_UPDATE_DATE := SYSDATE;
2563: l_OKL_TAX_LINES_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2564: l_OKL_TAX_LINES_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2565: RETURN(l_OKL_TAX_LINES_rec);
2566: END fill_who_columns;
2559: ) RETURN OKL_TAX_LINES_rec_type IS
2560: l_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type := p_OKL_TAX_LINES_rec;
2561: BEGIN
2562: l_OKL_TAX_LINES_rec.LAST_UPDATE_DATE := SYSDATE;
2563: l_OKL_TAX_LINES_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2564: l_OKL_TAX_LINES_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2565: RETURN(l_OKL_TAX_LINES_rec);
2566: END fill_who_columns;
2567: ----------------------------------
2560: l_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type := p_OKL_TAX_LINES_rec;
2561: BEGIN
2562: l_OKL_TAX_LINES_rec.LAST_UPDATE_DATE := SYSDATE;
2563: l_OKL_TAX_LINES_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2564: l_OKL_TAX_LINES_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2565: RETURN(l_OKL_TAX_LINES_rec);
2566: END fill_who_columns;
2567: ----------------------------------
2568: -- FUNCTION populate_new_record --
2561: BEGIN
2562: l_OKL_TAX_LINES_rec.LAST_UPDATE_DATE := SYSDATE;
2563: l_OKL_TAX_LINES_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2564: l_OKL_TAX_LINES_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2565: RETURN(l_OKL_TAX_LINES_rec);
2566: END fill_who_columns;
2567: ----------------------------------
2568: -- FUNCTION populate_new_record --
2569: ----------------------------------
2567: ----------------------------------
2568: -- FUNCTION populate_new_record --
2569: ----------------------------------
2570: FUNCTION populate_new_record (
2571: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type,
2572: x_OKL_TAX_LINES_rec OUT NOCOPY OKL_TAX_LINES_rec_type
2573: ) RETURN VARCHAR2 IS
2574: l_row_notfound BOOLEAN := TRUE;
2575: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2568: -- FUNCTION populate_new_record --
2569: ----------------------------------
2570: FUNCTION populate_new_record (
2571: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type,
2572: x_OKL_TAX_LINES_rec OUT NOCOPY OKL_TAX_LINES_rec_type
2573: ) RETURN VARCHAR2 IS
2574: l_row_notfound BOOLEAN := TRUE;
2575: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2576: BEGIN
2573: ) RETURN VARCHAR2 IS
2574: l_row_notfound BOOLEAN := TRUE;
2575: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2576: BEGIN
2577: x_OKL_TAX_LINES_rec := p_OKL_TAX_LINES_rec;
2578: -- Get current database values
2579: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
2580: -- so it may be verified through LOCK_ROW.
2581: l_db_OKL_TAX_LINES_rec := get_rec(p_OKL_TAX_LINES_rec, l_return_status);
2577: x_OKL_TAX_LINES_rec := p_OKL_TAX_LINES_rec;
2578: -- Get current database values
2579: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
2580: -- so it may be verified through LOCK_ROW.
2581: l_db_OKL_TAX_LINES_rec := get_rec(p_OKL_TAX_LINES_rec, l_return_status);
2582: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2583: IF (x_OKL_TAX_LINES_rec.id = OKC_API.G_MISS_NUM)
2584: THEN
2585: x_OKL_TAX_LINES_rec.id := l_db_OKL_TAX_LINES_rec.id;
2579: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
2580: -- so it may be verified through LOCK_ROW.
2581: l_db_OKL_TAX_LINES_rec := get_rec(p_OKL_TAX_LINES_rec, l_return_status);
2582: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2583: IF (x_OKL_TAX_LINES_rec.id = OKC_API.G_MISS_NUM)
2584: THEN
2585: x_OKL_TAX_LINES_rec.id := l_db_OKL_TAX_LINES_rec.id;
2586: END IF;
2587: IF (x_OKL_TAX_LINES_rec.khr_id = OKC_API.G_MISS_NUM)
2581: l_db_OKL_TAX_LINES_rec := get_rec(p_OKL_TAX_LINES_rec, l_return_status);
2582: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2583: IF (x_OKL_TAX_LINES_rec.id = OKC_API.G_MISS_NUM)
2584: THEN
2585: x_OKL_TAX_LINES_rec.id := l_db_OKL_TAX_LINES_rec.id;
2586: END IF;
2587: IF (x_OKL_TAX_LINES_rec.khr_id = OKC_API.G_MISS_NUM)
2588: THEN
2589: x_OKL_TAX_LINES_rec.khr_id := l_db_OKL_TAX_LINES_rec.khr_id;
2583: IF (x_OKL_TAX_LINES_rec.id = OKC_API.G_MISS_NUM)
2584: THEN
2585: x_OKL_TAX_LINES_rec.id := l_db_OKL_TAX_LINES_rec.id;
2586: END IF;
2587: IF (x_OKL_TAX_LINES_rec.khr_id = OKC_API.G_MISS_NUM)
2588: THEN
2589: x_OKL_TAX_LINES_rec.khr_id := l_db_OKL_TAX_LINES_rec.khr_id;
2590: END IF;
2591: IF (x_OKL_TAX_LINES_rec.kle_id = OKC_API.G_MISS_NUM)
2585: x_OKL_TAX_LINES_rec.id := l_db_OKL_TAX_LINES_rec.id;
2586: END IF;
2587: IF (x_OKL_TAX_LINES_rec.khr_id = OKC_API.G_MISS_NUM)
2588: THEN
2589: x_OKL_TAX_LINES_rec.khr_id := l_db_OKL_TAX_LINES_rec.khr_id;
2590: END IF;
2591: IF (x_OKL_TAX_LINES_rec.kle_id = OKC_API.G_MISS_NUM)
2592: THEN
2593: x_OKL_TAX_LINES_rec.kle_id := l_db_OKL_TAX_LINES_rec.kle_id;
2587: IF (x_OKL_TAX_LINES_rec.khr_id = OKC_API.G_MISS_NUM)
2588: THEN
2589: x_OKL_TAX_LINES_rec.khr_id := l_db_OKL_TAX_LINES_rec.khr_id;
2590: END IF;
2591: IF (x_OKL_TAX_LINES_rec.kle_id = OKC_API.G_MISS_NUM)
2592: THEN
2593: x_OKL_TAX_LINES_rec.kle_id := l_db_OKL_TAX_LINES_rec.kle_id;
2594: END IF;
2595: IF (x_OKL_TAX_LINES_rec.asset_id = OKC_API.G_MISS_NUM)
2589: x_OKL_TAX_LINES_rec.khr_id := l_db_OKL_TAX_LINES_rec.khr_id;
2590: END IF;
2591: IF (x_OKL_TAX_LINES_rec.kle_id = OKC_API.G_MISS_NUM)
2592: THEN
2593: x_OKL_TAX_LINES_rec.kle_id := l_db_OKL_TAX_LINES_rec.kle_id;
2594: END IF;
2595: IF (x_OKL_TAX_LINES_rec.asset_id = OKC_API.G_MISS_NUM)
2596: THEN
2597: x_OKL_TAX_LINES_rec.asset_id := l_db_OKL_TAX_LINES_rec.asset_id;
2591: IF (x_OKL_TAX_LINES_rec.kle_id = OKC_API.G_MISS_NUM)
2592: THEN
2593: x_OKL_TAX_LINES_rec.kle_id := l_db_OKL_TAX_LINES_rec.kle_id;
2594: END IF;
2595: IF (x_OKL_TAX_LINES_rec.asset_id = OKC_API.G_MISS_NUM)
2596: THEN
2597: x_OKL_TAX_LINES_rec.asset_id := l_db_OKL_TAX_LINES_rec.asset_id;
2598: END IF;
2599: IF (x_OKL_TAX_LINES_rec.asset_number = OKC_API.G_MISS_CHAR)
2593: x_OKL_TAX_LINES_rec.kle_id := l_db_OKL_TAX_LINES_rec.kle_id;
2594: END IF;
2595: IF (x_OKL_TAX_LINES_rec.asset_id = OKC_API.G_MISS_NUM)
2596: THEN
2597: x_OKL_TAX_LINES_rec.asset_id := l_db_OKL_TAX_LINES_rec.asset_id;
2598: END IF;
2599: IF (x_OKL_TAX_LINES_rec.asset_number = OKC_API.G_MISS_CHAR)
2600: THEN
2601: x_OKL_TAX_LINES_rec.asset_number := l_db_OKL_TAX_LINES_rec.asset_number;
2595: IF (x_OKL_TAX_LINES_rec.asset_id = OKC_API.G_MISS_NUM)
2596: THEN
2597: x_OKL_TAX_LINES_rec.asset_id := l_db_OKL_TAX_LINES_rec.asset_id;
2598: END IF;
2599: IF (x_OKL_TAX_LINES_rec.asset_number = OKC_API.G_MISS_CHAR)
2600: THEN
2601: x_OKL_TAX_LINES_rec.asset_number := l_db_OKL_TAX_LINES_rec.asset_number;
2602: END IF;
2603: IF (x_OKL_TAX_LINES_rec.tax_line_type = OKC_API.G_MISS_CHAR)
2597: x_OKL_TAX_LINES_rec.asset_id := l_db_OKL_TAX_LINES_rec.asset_id;
2598: END IF;
2599: IF (x_OKL_TAX_LINES_rec.asset_number = OKC_API.G_MISS_CHAR)
2600: THEN
2601: x_OKL_TAX_LINES_rec.asset_number := l_db_OKL_TAX_LINES_rec.asset_number;
2602: END IF;
2603: IF (x_OKL_TAX_LINES_rec.tax_line_type = OKC_API.G_MISS_CHAR)
2604: THEN
2605: x_OKL_TAX_LINES_rec.tax_line_type := l_db_OKL_TAX_LINES_rec.tax_line_type;
2599: IF (x_OKL_TAX_LINES_rec.asset_number = OKC_API.G_MISS_CHAR)
2600: THEN
2601: x_OKL_TAX_LINES_rec.asset_number := l_db_OKL_TAX_LINES_rec.asset_number;
2602: END IF;
2603: IF (x_OKL_TAX_LINES_rec.tax_line_type = OKC_API.G_MISS_CHAR)
2604: THEN
2605: x_OKL_TAX_LINES_rec.tax_line_type := l_db_OKL_TAX_LINES_rec.tax_line_type;
2606: END IF;
2607: IF (x_OKL_TAX_LINES_rec.sel_id = OKC_API.G_MISS_NUM)
2601: x_OKL_TAX_LINES_rec.asset_number := l_db_OKL_TAX_LINES_rec.asset_number;
2602: END IF;
2603: IF (x_OKL_TAX_LINES_rec.tax_line_type = OKC_API.G_MISS_CHAR)
2604: THEN
2605: x_OKL_TAX_LINES_rec.tax_line_type := l_db_OKL_TAX_LINES_rec.tax_line_type;
2606: END IF;
2607: IF (x_OKL_TAX_LINES_rec.sel_id = OKC_API.G_MISS_NUM)
2608: THEN
2609: x_OKL_TAX_LINES_rec.sel_id := l_db_OKL_TAX_LINES_rec.sel_id;
2603: IF (x_OKL_TAX_LINES_rec.tax_line_type = OKC_API.G_MISS_CHAR)
2604: THEN
2605: x_OKL_TAX_LINES_rec.tax_line_type := l_db_OKL_TAX_LINES_rec.tax_line_type;
2606: END IF;
2607: IF (x_OKL_TAX_LINES_rec.sel_id = OKC_API.G_MISS_NUM)
2608: THEN
2609: x_OKL_TAX_LINES_rec.sel_id := l_db_OKL_TAX_LINES_rec.sel_id;
2610: END IF;
2611: IF (x_OKL_TAX_LINES_rec.tax_due_date = OKC_API.G_MISS_DATE)
2605: x_OKL_TAX_LINES_rec.tax_line_type := l_db_OKL_TAX_LINES_rec.tax_line_type;
2606: END IF;
2607: IF (x_OKL_TAX_LINES_rec.sel_id = OKC_API.G_MISS_NUM)
2608: THEN
2609: x_OKL_TAX_LINES_rec.sel_id := l_db_OKL_TAX_LINES_rec.sel_id;
2610: END IF;
2611: IF (x_OKL_TAX_LINES_rec.tax_due_date = OKC_API.G_MISS_DATE)
2612: THEN
2613: x_OKL_TAX_LINES_rec.tax_due_date := l_db_OKL_TAX_LINES_rec.tax_due_date;
2607: IF (x_OKL_TAX_LINES_rec.sel_id = OKC_API.G_MISS_NUM)
2608: THEN
2609: x_OKL_TAX_LINES_rec.sel_id := l_db_OKL_TAX_LINES_rec.sel_id;
2610: END IF;
2611: IF (x_OKL_TAX_LINES_rec.tax_due_date = OKC_API.G_MISS_DATE)
2612: THEN
2613: x_OKL_TAX_LINES_rec.tax_due_date := l_db_OKL_TAX_LINES_rec.tax_due_date;
2614: END IF;
2615: IF (x_OKL_TAX_LINES_rec.tax_type = OKC_API.G_MISS_NUM)
2609: x_OKL_TAX_LINES_rec.sel_id := l_db_OKL_TAX_LINES_rec.sel_id;
2610: END IF;
2611: IF (x_OKL_TAX_LINES_rec.tax_due_date = OKC_API.G_MISS_DATE)
2612: THEN
2613: x_OKL_TAX_LINES_rec.tax_due_date := l_db_OKL_TAX_LINES_rec.tax_due_date;
2614: END IF;
2615: IF (x_OKL_TAX_LINES_rec.tax_type = OKC_API.G_MISS_NUM)
2616: THEN
2617: x_OKL_TAX_LINES_rec.tax_type := l_db_OKL_TAX_LINES_rec.tax_type;
2611: IF (x_OKL_TAX_LINES_rec.tax_due_date = OKC_API.G_MISS_DATE)
2612: THEN
2613: x_OKL_TAX_LINES_rec.tax_due_date := l_db_OKL_TAX_LINES_rec.tax_due_date;
2614: END IF;
2615: IF (x_OKL_TAX_LINES_rec.tax_type = OKC_API.G_MISS_NUM)
2616: THEN
2617: x_OKL_TAX_LINES_rec.tax_type := l_db_OKL_TAX_LINES_rec.tax_type;
2618: END IF;
2619: IF (x_OKL_TAX_LINES_rec.tax_rate_code_id = OKC_API.G_MISS_NUM)
2613: x_OKL_TAX_LINES_rec.tax_due_date := l_db_OKL_TAX_LINES_rec.tax_due_date;
2614: END IF;
2615: IF (x_OKL_TAX_LINES_rec.tax_type = OKC_API.G_MISS_NUM)
2616: THEN
2617: x_OKL_TAX_LINES_rec.tax_type := l_db_OKL_TAX_LINES_rec.tax_type;
2618: END IF;
2619: IF (x_OKL_TAX_LINES_rec.tax_rate_code_id = OKC_API.G_MISS_NUM)
2620: THEN
2621: x_OKL_TAX_LINES_rec.tax_rate_code_id := l_db_OKL_TAX_LINES_rec.tax_rate_code_id;
2615: IF (x_OKL_TAX_LINES_rec.tax_type = OKC_API.G_MISS_NUM)
2616: THEN
2617: x_OKL_TAX_LINES_rec.tax_type := l_db_OKL_TAX_LINES_rec.tax_type;
2618: END IF;
2619: IF (x_OKL_TAX_LINES_rec.tax_rate_code_id = OKC_API.G_MISS_NUM)
2620: THEN
2621: x_OKL_TAX_LINES_rec.tax_rate_code_id := l_db_OKL_TAX_LINES_rec.tax_rate_code_id;
2622: END IF;
2623: IF (x_OKL_TAX_LINES_rec.tax_rate_code = OKC_API.G_MISS_CHAR)
2617: x_OKL_TAX_LINES_rec.tax_type := l_db_OKL_TAX_LINES_rec.tax_type;
2618: END IF;
2619: IF (x_OKL_TAX_LINES_rec.tax_rate_code_id = OKC_API.G_MISS_NUM)
2620: THEN
2621: x_OKL_TAX_LINES_rec.tax_rate_code_id := l_db_OKL_TAX_LINES_rec.tax_rate_code_id;
2622: END IF;
2623: IF (x_OKL_TAX_LINES_rec.tax_rate_code = OKC_API.G_MISS_CHAR)
2624: THEN
2625: x_OKL_TAX_LINES_rec.tax_rate_code := l_db_OKL_TAX_LINES_rec.tax_rate_code;
2619: IF (x_OKL_TAX_LINES_rec.tax_rate_code_id = OKC_API.G_MISS_NUM)
2620: THEN
2621: x_OKL_TAX_LINES_rec.tax_rate_code_id := l_db_OKL_TAX_LINES_rec.tax_rate_code_id;
2622: END IF;
2623: IF (x_OKL_TAX_LINES_rec.tax_rate_code = OKC_API.G_MISS_CHAR)
2624: THEN
2625: x_OKL_TAX_LINES_rec.tax_rate_code := l_db_OKL_TAX_LINES_rec.tax_rate_code;
2626: END IF;
2627: IF (x_OKL_TAX_LINES_rec.taxable_amount = OKC_API.G_MISS_NUM)
2621: x_OKL_TAX_LINES_rec.tax_rate_code_id := l_db_OKL_TAX_LINES_rec.tax_rate_code_id;
2622: END IF;
2623: IF (x_OKL_TAX_LINES_rec.tax_rate_code = OKC_API.G_MISS_CHAR)
2624: THEN
2625: x_OKL_TAX_LINES_rec.tax_rate_code := l_db_OKL_TAX_LINES_rec.tax_rate_code;
2626: END IF;
2627: IF (x_OKL_TAX_LINES_rec.taxable_amount = OKC_API.G_MISS_NUM)
2628: THEN
2629: x_OKL_TAX_LINES_rec.taxable_amount := l_db_OKL_TAX_LINES_rec.taxable_amount;
2623: IF (x_OKL_TAX_LINES_rec.tax_rate_code = OKC_API.G_MISS_CHAR)
2624: THEN
2625: x_OKL_TAX_LINES_rec.tax_rate_code := l_db_OKL_TAX_LINES_rec.tax_rate_code;
2626: END IF;
2627: IF (x_OKL_TAX_LINES_rec.taxable_amount = OKC_API.G_MISS_NUM)
2628: THEN
2629: x_OKL_TAX_LINES_rec.taxable_amount := l_db_OKL_TAX_LINES_rec.taxable_amount;
2630: END IF;
2631: IF (x_OKL_TAX_LINES_rec.tax_exemption_id = OKC_API.G_MISS_NUM)
2625: x_OKL_TAX_LINES_rec.tax_rate_code := l_db_OKL_TAX_LINES_rec.tax_rate_code;
2626: END IF;
2627: IF (x_OKL_TAX_LINES_rec.taxable_amount = OKC_API.G_MISS_NUM)
2628: THEN
2629: x_OKL_TAX_LINES_rec.taxable_amount := l_db_OKL_TAX_LINES_rec.taxable_amount;
2630: END IF;
2631: IF (x_OKL_TAX_LINES_rec.tax_exemption_id = OKC_API.G_MISS_NUM)
2632: THEN
2633: x_OKL_TAX_LINES_rec.tax_exemption_id := l_db_OKL_TAX_LINES_rec.tax_exemption_id;
2627: IF (x_OKL_TAX_LINES_rec.taxable_amount = OKC_API.G_MISS_NUM)
2628: THEN
2629: x_OKL_TAX_LINES_rec.taxable_amount := l_db_OKL_TAX_LINES_rec.taxable_amount;
2630: END IF;
2631: IF (x_OKL_TAX_LINES_rec.tax_exemption_id = OKC_API.G_MISS_NUM)
2632: THEN
2633: x_OKL_TAX_LINES_rec.tax_exemption_id := l_db_OKL_TAX_LINES_rec.tax_exemption_id;
2634: END IF;
2635: IF (x_OKL_TAX_LINES_rec.manually_entered_flag = OKC_API.G_MISS_CHAR)
2629: x_OKL_TAX_LINES_rec.taxable_amount := l_db_OKL_TAX_LINES_rec.taxable_amount;
2630: END IF;
2631: IF (x_OKL_TAX_LINES_rec.tax_exemption_id = OKC_API.G_MISS_NUM)
2632: THEN
2633: x_OKL_TAX_LINES_rec.tax_exemption_id := l_db_OKL_TAX_LINES_rec.tax_exemption_id;
2634: END IF;
2635: IF (x_OKL_TAX_LINES_rec.manually_entered_flag = OKC_API.G_MISS_CHAR)
2636: THEN
2637: x_OKL_TAX_LINES_rec.manually_entered_flag := l_db_OKL_TAX_LINES_rec.manually_entered_flag;
2631: IF (x_OKL_TAX_LINES_rec.tax_exemption_id = OKC_API.G_MISS_NUM)
2632: THEN
2633: x_OKL_TAX_LINES_rec.tax_exemption_id := l_db_OKL_TAX_LINES_rec.tax_exemption_id;
2634: END IF;
2635: IF (x_OKL_TAX_LINES_rec.manually_entered_flag = OKC_API.G_MISS_CHAR)
2636: THEN
2637: x_OKL_TAX_LINES_rec.manually_entered_flag := l_db_OKL_TAX_LINES_rec.manually_entered_flag;
2638: END IF;
2639: IF (x_OKL_TAX_LINES_rec.overridden_flag = OKC_API.G_MISS_CHAR)
2633: x_OKL_TAX_LINES_rec.tax_exemption_id := l_db_OKL_TAX_LINES_rec.tax_exemption_id;
2634: END IF;
2635: IF (x_OKL_TAX_LINES_rec.manually_entered_flag = OKC_API.G_MISS_CHAR)
2636: THEN
2637: x_OKL_TAX_LINES_rec.manually_entered_flag := l_db_OKL_TAX_LINES_rec.manually_entered_flag;
2638: END IF;
2639: IF (x_OKL_TAX_LINES_rec.overridden_flag = OKC_API.G_MISS_CHAR)
2640: THEN
2641: x_OKL_TAX_LINES_rec.overridden_flag := l_db_OKL_TAX_LINES_rec.overridden_flag;
2635: IF (x_OKL_TAX_LINES_rec.manually_entered_flag = OKC_API.G_MISS_CHAR)
2636: THEN
2637: x_OKL_TAX_LINES_rec.manually_entered_flag := l_db_OKL_TAX_LINES_rec.manually_entered_flag;
2638: END IF;
2639: IF (x_OKL_TAX_LINES_rec.overridden_flag = OKC_API.G_MISS_CHAR)
2640: THEN
2641: x_OKL_TAX_LINES_rec.overridden_flag := l_db_OKL_TAX_LINES_rec.overridden_flag;
2642: END IF;
2643: IF (x_OKL_TAX_LINES_rec.calculated_tax_amount = OKC_API.G_MISS_NUM)
2637: x_OKL_TAX_LINES_rec.manually_entered_flag := l_db_OKL_TAX_LINES_rec.manually_entered_flag;
2638: END IF;
2639: IF (x_OKL_TAX_LINES_rec.overridden_flag = OKC_API.G_MISS_CHAR)
2640: THEN
2641: x_OKL_TAX_LINES_rec.overridden_flag := l_db_OKL_TAX_LINES_rec.overridden_flag;
2642: END IF;
2643: IF (x_OKL_TAX_LINES_rec.calculated_tax_amount = OKC_API.G_MISS_NUM)
2644: THEN
2645: x_OKL_TAX_LINES_rec.calculated_tax_amount := l_db_OKL_TAX_LINES_rec.calculated_tax_amount;
2639: IF (x_OKL_TAX_LINES_rec.overridden_flag = OKC_API.G_MISS_CHAR)
2640: THEN
2641: x_OKL_TAX_LINES_rec.overridden_flag := l_db_OKL_TAX_LINES_rec.overridden_flag;
2642: END IF;
2643: IF (x_OKL_TAX_LINES_rec.calculated_tax_amount = OKC_API.G_MISS_NUM)
2644: THEN
2645: x_OKL_TAX_LINES_rec.calculated_tax_amount := l_db_OKL_TAX_LINES_rec.calculated_tax_amount;
2646: END IF;
2647: IF (x_OKL_TAX_LINES_rec.tax_rate = OKC_API.G_MISS_NUM)
2641: x_OKL_TAX_LINES_rec.overridden_flag := l_db_OKL_TAX_LINES_rec.overridden_flag;
2642: END IF;
2643: IF (x_OKL_TAX_LINES_rec.calculated_tax_amount = OKC_API.G_MISS_NUM)
2644: THEN
2645: x_OKL_TAX_LINES_rec.calculated_tax_amount := l_db_OKL_TAX_LINES_rec.calculated_tax_amount;
2646: END IF;
2647: IF (x_OKL_TAX_LINES_rec.tax_rate = OKC_API.G_MISS_NUM)
2648: THEN
2649: x_OKL_TAX_LINES_rec.tax_rate := l_db_OKL_TAX_LINES_rec.tax_rate;
2643: IF (x_OKL_TAX_LINES_rec.calculated_tax_amount = OKC_API.G_MISS_NUM)
2644: THEN
2645: x_OKL_TAX_LINES_rec.calculated_tax_amount := l_db_OKL_TAX_LINES_rec.calculated_tax_amount;
2646: END IF;
2647: IF (x_OKL_TAX_LINES_rec.tax_rate = OKC_API.G_MISS_NUM)
2648: THEN
2649: x_OKL_TAX_LINES_rec.tax_rate := l_db_OKL_TAX_LINES_rec.tax_rate;
2650: END IF;
2651: IF (x_OKL_TAX_LINES_rec.tax_amount = OKC_API.G_MISS_NUM)
2645: x_OKL_TAX_LINES_rec.calculated_tax_amount := l_db_OKL_TAX_LINES_rec.calculated_tax_amount;
2646: END IF;
2647: IF (x_OKL_TAX_LINES_rec.tax_rate = OKC_API.G_MISS_NUM)
2648: THEN
2649: x_OKL_TAX_LINES_rec.tax_rate := l_db_OKL_TAX_LINES_rec.tax_rate;
2650: END IF;
2651: IF (x_OKL_TAX_LINES_rec.tax_amount = OKC_API.G_MISS_NUM)
2652: THEN
2653: x_OKL_TAX_LINES_rec.tax_amount := l_db_OKL_TAX_LINES_rec.tax_amount;
2647: IF (x_OKL_TAX_LINES_rec.tax_rate = OKC_API.G_MISS_NUM)
2648: THEN
2649: x_OKL_TAX_LINES_rec.tax_rate := l_db_OKL_TAX_LINES_rec.tax_rate;
2650: END IF;
2651: IF (x_OKL_TAX_LINES_rec.tax_amount = OKC_API.G_MISS_NUM)
2652: THEN
2653: x_OKL_TAX_LINES_rec.tax_amount := l_db_OKL_TAX_LINES_rec.tax_amount;
2654: END IF;
2655: IF (x_OKL_TAX_LINES_rec.sales_tax_id = OKC_API.G_MISS_NUM)
2649: x_OKL_TAX_LINES_rec.tax_rate := l_db_OKL_TAX_LINES_rec.tax_rate;
2650: END IF;
2651: IF (x_OKL_TAX_LINES_rec.tax_amount = OKC_API.G_MISS_NUM)
2652: THEN
2653: x_OKL_TAX_LINES_rec.tax_amount := l_db_OKL_TAX_LINES_rec.tax_amount;
2654: END IF;
2655: IF (x_OKL_TAX_LINES_rec.sales_tax_id = OKC_API.G_MISS_NUM)
2656: THEN
2657: x_OKL_TAX_LINES_rec.sales_tax_id := l_db_OKL_TAX_LINES_rec.sales_tax_id;
2651: IF (x_OKL_TAX_LINES_rec.tax_amount = OKC_API.G_MISS_NUM)
2652: THEN
2653: x_OKL_TAX_LINES_rec.tax_amount := l_db_OKL_TAX_LINES_rec.tax_amount;
2654: END IF;
2655: IF (x_OKL_TAX_LINES_rec.sales_tax_id = OKC_API.G_MISS_NUM)
2656: THEN
2657: x_OKL_TAX_LINES_rec.sales_tax_id := l_db_OKL_TAX_LINES_rec.sales_tax_id;
2658: END IF;
2659: IF (x_OKL_TAX_LINES_rec.source_trx_id = OKC_API.G_MISS_NUM)
2653: x_OKL_TAX_LINES_rec.tax_amount := l_db_OKL_TAX_LINES_rec.tax_amount;
2654: END IF;
2655: IF (x_OKL_TAX_LINES_rec.sales_tax_id = OKC_API.G_MISS_NUM)
2656: THEN
2657: x_OKL_TAX_LINES_rec.sales_tax_id := l_db_OKL_TAX_LINES_rec.sales_tax_id;
2658: END IF;
2659: IF (x_OKL_TAX_LINES_rec.source_trx_id = OKC_API.G_MISS_NUM)
2660: THEN
2661: x_OKL_TAX_LINES_rec.source_trx_id := l_db_OKL_TAX_LINES_rec.source_trx_id;
2655: IF (x_OKL_TAX_LINES_rec.sales_tax_id = OKC_API.G_MISS_NUM)
2656: THEN
2657: x_OKL_TAX_LINES_rec.sales_tax_id := l_db_OKL_TAX_LINES_rec.sales_tax_id;
2658: END IF;
2659: IF (x_OKL_TAX_LINES_rec.source_trx_id = OKC_API.G_MISS_NUM)
2660: THEN
2661: x_OKL_TAX_LINES_rec.source_trx_id := l_db_OKL_TAX_LINES_rec.source_trx_id;
2662: END IF;
2663: IF (x_OKL_TAX_LINES_rec.org_id = OKC_API.G_MISS_NUM)
2657: x_OKL_TAX_LINES_rec.sales_tax_id := l_db_OKL_TAX_LINES_rec.sales_tax_id;
2658: END IF;
2659: IF (x_OKL_TAX_LINES_rec.source_trx_id = OKC_API.G_MISS_NUM)
2660: THEN
2661: x_OKL_TAX_LINES_rec.source_trx_id := l_db_OKL_TAX_LINES_rec.source_trx_id;
2662: END IF;
2663: IF (x_OKL_TAX_LINES_rec.org_id = OKC_API.G_MISS_NUM)
2664: THEN
2665: x_OKL_TAX_LINES_rec.org_id := l_db_OKL_TAX_LINES_rec.org_id;
2659: IF (x_OKL_TAX_LINES_rec.source_trx_id = OKC_API.G_MISS_NUM)
2660: THEN
2661: x_OKL_TAX_LINES_rec.source_trx_id := l_db_OKL_TAX_LINES_rec.source_trx_id;
2662: END IF;
2663: IF (x_OKL_TAX_LINES_rec.org_id = OKC_API.G_MISS_NUM)
2664: THEN
2665: x_OKL_TAX_LINES_rec.org_id := l_db_OKL_TAX_LINES_rec.org_id;
2666: END IF;
2667: IF (x_OKL_TAX_LINES_rec.history_yn = OKC_API.G_MISS_CHAR)
2661: x_OKL_TAX_LINES_rec.source_trx_id := l_db_OKL_TAX_LINES_rec.source_trx_id;
2662: END IF;
2663: IF (x_OKL_TAX_LINES_rec.org_id = OKC_API.G_MISS_NUM)
2664: THEN
2665: x_OKL_TAX_LINES_rec.org_id := l_db_OKL_TAX_LINES_rec.org_id;
2666: END IF;
2667: IF (x_OKL_TAX_LINES_rec.history_yn = OKC_API.G_MISS_CHAR)
2668: THEN
2669: x_OKL_TAX_LINES_rec.history_yn := l_db_OKL_TAX_LINES_rec.history_yn;
2663: IF (x_OKL_TAX_LINES_rec.org_id = OKC_API.G_MISS_NUM)
2664: THEN
2665: x_OKL_TAX_LINES_rec.org_id := l_db_OKL_TAX_LINES_rec.org_id;
2666: END IF;
2667: IF (x_OKL_TAX_LINES_rec.history_yn = OKC_API.G_MISS_CHAR)
2668: THEN
2669: x_OKL_TAX_LINES_rec.history_yn := l_db_OKL_TAX_LINES_rec.history_yn;
2670: END IF;
2671: IF (x_OKL_TAX_LINES_rec.actual_yn = OKC_API.G_MISS_CHAR)
2665: x_OKL_TAX_LINES_rec.org_id := l_db_OKL_TAX_LINES_rec.org_id;
2666: END IF;
2667: IF (x_OKL_TAX_LINES_rec.history_yn = OKC_API.G_MISS_CHAR)
2668: THEN
2669: x_OKL_TAX_LINES_rec.history_yn := l_db_OKL_TAX_LINES_rec.history_yn;
2670: END IF;
2671: IF (x_OKL_TAX_LINES_rec.actual_yn = OKC_API.G_MISS_CHAR)
2672: THEN
2673: x_OKL_TAX_LINES_rec.actual_yn := l_db_OKL_TAX_LINES_rec.actual_yn;
2667: IF (x_OKL_TAX_LINES_rec.history_yn = OKC_API.G_MISS_CHAR)
2668: THEN
2669: x_OKL_TAX_LINES_rec.history_yn := l_db_OKL_TAX_LINES_rec.history_yn;
2670: END IF;
2671: IF (x_OKL_TAX_LINES_rec.actual_yn = OKC_API.G_MISS_CHAR)
2672: THEN
2673: x_OKL_TAX_LINES_rec.actual_yn := l_db_OKL_TAX_LINES_rec.actual_yn;
2674: END IF;
2675: IF (x_OKL_TAX_LINES_rec.source_name = OKC_API.G_MISS_CHAR)
2669: x_OKL_TAX_LINES_rec.history_yn := l_db_OKL_TAX_LINES_rec.history_yn;
2670: END IF;
2671: IF (x_OKL_TAX_LINES_rec.actual_yn = OKC_API.G_MISS_CHAR)
2672: THEN
2673: x_OKL_TAX_LINES_rec.actual_yn := l_db_OKL_TAX_LINES_rec.actual_yn;
2674: END IF;
2675: IF (x_OKL_TAX_LINES_rec.source_name = OKC_API.G_MISS_CHAR)
2676: THEN
2677: x_OKL_TAX_LINES_rec.source_name := l_db_OKL_TAX_LINES_rec.source_name;
2671: IF (x_OKL_TAX_LINES_rec.actual_yn = OKC_API.G_MISS_CHAR)
2672: THEN
2673: x_OKL_TAX_LINES_rec.actual_yn := l_db_OKL_TAX_LINES_rec.actual_yn;
2674: END IF;
2675: IF (x_OKL_TAX_LINES_rec.source_name = OKC_API.G_MISS_CHAR)
2676: THEN
2677: x_OKL_TAX_LINES_rec.source_name := l_db_OKL_TAX_LINES_rec.source_name;
2678: END IF;
2679: IF (x_OKL_TAX_LINES_rec.trq_id = OKC_API.G_MISS_NUM)
2673: x_OKL_TAX_LINES_rec.actual_yn := l_db_OKL_TAX_LINES_rec.actual_yn;
2674: END IF;
2675: IF (x_OKL_TAX_LINES_rec.source_name = OKC_API.G_MISS_CHAR)
2676: THEN
2677: x_OKL_TAX_LINES_rec.source_name := l_db_OKL_TAX_LINES_rec.source_name;
2678: END IF;
2679: IF (x_OKL_TAX_LINES_rec.trq_id = OKC_API.G_MISS_NUM)
2680: THEN
2681: x_OKL_TAX_LINES_rec.trq_id := l_db_OKL_TAX_LINES_rec.trq_id;
2675: IF (x_OKL_TAX_LINES_rec.source_name = OKC_API.G_MISS_CHAR)
2676: THEN
2677: x_OKL_TAX_LINES_rec.source_name := l_db_OKL_TAX_LINES_rec.source_name;
2678: END IF;
2679: IF (x_OKL_TAX_LINES_rec.trq_id = OKC_API.G_MISS_NUM)
2680: THEN
2681: x_OKL_TAX_LINES_rec.trq_id := l_db_OKL_TAX_LINES_rec.trq_id;
2682: END IF;
2683: IF (x_OKL_TAX_LINES_rec.program_id = OKC_API.G_MISS_NUM)
2677: x_OKL_TAX_LINES_rec.source_name := l_db_OKL_TAX_LINES_rec.source_name;
2678: END IF;
2679: IF (x_OKL_TAX_LINES_rec.trq_id = OKC_API.G_MISS_NUM)
2680: THEN
2681: x_OKL_TAX_LINES_rec.trq_id := l_db_OKL_TAX_LINES_rec.trq_id;
2682: END IF;
2683: IF (x_OKL_TAX_LINES_rec.program_id = OKC_API.G_MISS_NUM)
2684: THEN
2685: x_OKL_TAX_LINES_rec.program_id := l_db_OKL_TAX_LINES_rec.program_id;
2679: IF (x_OKL_TAX_LINES_rec.trq_id = OKC_API.G_MISS_NUM)
2680: THEN
2681: x_OKL_TAX_LINES_rec.trq_id := l_db_OKL_TAX_LINES_rec.trq_id;
2682: END IF;
2683: IF (x_OKL_TAX_LINES_rec.program_id = OKC_API.G_MISS_NUM)
2684: THEN
2685: x_OKL_TAX_LINES_rec.program_id := l_db_OKL_TAX_LINES_rec.program_id;
2686: END IF;
2687: IF (x_OKL_TAX_LINES_rec.request_id = OKC_API.G_MISS_NUM)
2681: x_OKL_TAX_LINES_rec.trq_id := l_db_OKL_TAX_LINES_rec.trq_id;
2682: END IF;
2683: IF (x_OKL_TAX_LINES_rec.program_id = OKC_API.G_MISS_NUM)
2684: THEN
2685: x_OKL_TAX_LINES_rec.program_id := l_db_OKL_TAX_LINES_rec.program_id;
2686: END IF;
2687: IF (x_OKL_TAX_LINES_rec.request_id = OKC_API.G_MISS_NUM)
2688: THEN
2689: x_OKL_TAX_LINES_rec.request_id := l_db_OKL_TAX_LINES_rec.request_id;
2683: IF (x_OKL_TAX_LINES_rec.program_id = OKC_API.G_MISS_NUM)
2684: THEN
2685: x_OKL_TAX_LINES_rec.program_id := l_db_OKL_TAX_LINES_rec.program_id;
2686: END IF;
2687: IF (x_OKL_TAX_LINES_rec.request_id = OKC_API.G_MISS_NUM)
2688: THEN
2689: x_OKL_TAX_LINES_rec.request_id := l_db_OKL_TAX_LINES_rec.request_id;
2690: END IF;
2691: IF (x_OKL_TAX_LINES_rec.program_application_id = OKC_API.G_MISS_NUM)
2685: x_OKL_TAX_LINES_rec.program_id := l_db_OKL_TAX_LINES_rec.program_id;
2686: END IF;
2687: IF (x_OKL_TAX_LINES_rec.request_id = OKC_API.G_MISS_NUM)
2688: THEN
2689: x_OKL_TAX_LINES_rec.request_id := l_db_OKL_TAX_LINES_rec.request_id;
2690: END IF;
2691: IF (x_OKL_TAX_LINES_rec.program_application_id = OKC_API.G_MISS_NUM)
2692: THEN
2693: x_OKL_TAX_LINES_rec.program_application_id := l_db_OKL_TAX_LINES_rec.program_application_id;
2687: IF (x_OKL_TAX_LINES_rec.request_id = OKC_API.G_MISS_NUM)
2688: THEN
2689: x_OKL_TAX_LINES_rec.request_id := l_db_OKL_TAX_LINES_rec.request_id;
2690: END IF;
2691: IF (x_OKL_TAX_LINES_rec.program_application_id = OKC_API.G_MISS_NUM)
2692: THEN
2693: x_OKL_TAX_LINES_rec.program_application_id := l_db_OKL_TAX_LINES_rec.program_application_id;
2694: END IF;
2695: IF (x_OKL_TAX_LINES_rec.program_update_date = OKC_API.G_MISS_DATE)
2689: x_OKL_TAX_LINES_rec.request_id := l_db_OKL_TAX_LINES_rec.request_id;
2690: END IF;
2691: IF (x_OKL_TAX_LINES_rec.program_application_id = OKC_API.G_MISS_NUM)
2692: THEN
2693: x_OKL_TAX_LINES_rec.program_application_id := l_db_OKL_TAX_LINES_rec.program_application_id;
2694: END IF;
2695: IF (x_OKL_TAX_LINES_rec.program_update_date = OKC_API.G_MISS_DATE)
2696: THEN
2697: x_OKL_TAX_LINES_rec.program_update_date := l_db_OKL_TAX_LINES_rec.program_update_date;
2691: IF (x_OKL_TAX_LINES_rec.program_application_id = OKC_API.G_MISS_NUM)
2692: THEN
2693: x_OKL_TAX_LINES_rec.program_application_id := l_db_OKL_TAX_LINES_rec.program_application_id;
2694: END IF;
2695: IF (x_OKL_TAX_LINES_rec.program_update_date = OKC_API.G_MISS_DATE)
2696: THEN
2697: x_OKL_TAX_LINES_rec.program_update_date := l_db_OKL_TAX_LINES_rec.program_update_date;
2698: END IF;
2699: IF (x_OKL_TAX_LINES_rec.attribute_category = OKC_API.G_MISS_CHAR)
2693: x_OKL_TAX_LINES_rec.program_application_id := l_db_OKL_TAX_LINES_rec.program_application_id;
2694: END IF;
2695: IF (x_OKL_TAX_LINES_rec.program_update_date = OKC_API.G_MISS_DATE)
2696: THEN
2697: x_OKL_TAX_LINES_rec.program_update_date := l_db_OKL_TAX_LINES_rec.program_update_date;
2698: END IF;
2699: IF (x_OKL_TAX_LINES_rec.attribute_category = OKC_API.G_MISS_CHAR)
2700: THEN
2701: x_OKL_TAX_LINES_rec.attribute_category := l_db_OKL_TAX_LINES_rec.attribute_category;
2695: IF (x_OKL_TAX_LINES_rec.program_update_date = OKC_API.G_MISS_DATE)
2696: THEN
2697: x_OKL_TAX_LINES_rec.program_update_date := l_db_OKL_TAX_LINES_rec.program_update_date;
2698: END IF;
2699: IF (x_OKL_TAX_LINES_rec.attribute_category = OKC_API.G_MISS_CHAR)
2700: THEN
2701: x_OKL_TAX_LINES_rec.attribute_category := l_db_OKL_TAX_LINES_rec.attribute_category;
2702: END IF;
2703: IF (x_OKL_TAX_LINES_rec.attribute1 = OKC_API.G_MISS_CHAR)
2697: x_OKL_TAX_LINES_rec.program_update_date := l_db_OKL_TAX_LINES_rec.program_update_date;
2698: END IF;
2699: IF (x_OKL_TAX_LINES_rec.attribute_category = OKC_API.G_MISS_CHAR)
2700: THEN
2701: x_OKL_TAX_LINES_rec.attribute_category := l_db_OKL_TAX_LINES_rec.attribute_category;
2702: END IF;
2703: IF (x_OKL_TAX_LINES_rec.attribute1 = OKC_API.G_MISS_CHAR)
2704: THEN
2705: x_OKL_TAX_LINES_rec.attribute1 := l_db_OKL_TAX_LINES_rec.attribute1;
2699: IF (x_OKL_TAX_LINES_rec.attribute_category = OKC_API.G_MISS_CHAR)
2700: THEN
2701: x_OKL_TAX_LINES_rec.attribute_category := l_db_OKL_TAX_LINES_rec.attribute_category;
2702: END IF;
2703: IF (x_OKL_TAX_LINES_rec.attribute1 = OKC_API.G_MISS_CHAR)
2704: THEN
2705: x_OKL_TAX_LINES_rec.attribute1 := l_db_OKL_TAX_LINES_rec.attribute1;
2706: END IF;
2707: IF (x_OKL_TAX_LINES_rec.attribute2 = OKC_API.G_MISS_CHAR)
2701: x_OKL_TAX_LINES_rec.attribute_category := l_db_OKL_TAX_LINES_rec.attribute_category;
2702: END IF;
2703: IF (x_OKL_TAX_LINES_rec.attribute1 = OKC_API.G_MISS_CHAR)
2704: THEN
2705: x_OKL_TAX_LINES_rec.attribute1 := l_db_OKL_TAX_LINES_rec.attribute1;
2706: END IF;
2707: IF (x_OKL_TAX_LINES_rec.attribute2 = OKC_API.G_MISS_CHAR)
2708: THEN
2709: x_OKL_TAX_LINES_rec.attribute2 := l_db_OKL_TAX_LINES_rec.attribute2;
2703: IF (x_OKL_TAX_LINES_rec.attribute1 = OKC_API.G_MISS_CHAR)
2704: THEN
2705: x_OKL_TAX_LINES_rec.attribute1 := l_db_OKL_TAX_LINES_rec.attribute1;
2706: END IF;
2707: IF (x_OKL_TAX_LINES_rec.attribute2 = OKC_API.G_MISS_CHAR)
2708: THEN
2709: x_OKL_TAX_LINES_rec.attribute2 := l_db_OKL_TAX_LINES_rec.attribute2;
2710: END IF;
2711: IF (x_OKL_TAX_LINES_rec.attribute3 = OKC_API.G_MISS_CHAR)
2705: x_OKL_TAX_LINES_rec.attribute1 := l_db_OKL_TAX_LINES_rec.attribute1;
2706: END IF;
2707: IF (x_OKL_TAX_LINES_rec.attribute2 = OKC_API.G_MISS_CHAR)
2708: THEN
2709: x_OKL_TAX_LINES_rec.attribute2 := l_db_OKL_TAX_LINES_rec.attribute2;
2710: END IF;
2711: IF (x_OKL_TAX_LINES_rec.attribute3 = OKC_API.G_MISS_CHAR)
2712: THEN
2713: x_OKL_TAX_LINES_rec.attribute3 := l_db_OKL_TAX_LINES_rec.attribute3;
2707: IF (x_OKL_TAX_LINES_rec.attribute2 = OKC_API.G_MISS_CHAR)
2708: THEN
2709: x_OKL_TAX_LINES_rec.attribute2 := l_db_OKL_TAX_LINES_rec.attribute2;
2710: END IF;
2711: IF (x_OKL_TAX_LINES_rec.attribute3 = OKC_API.G_MISS_CHAR)
2712: THEN
2713: x_OKL_TAX_LINES_rec.attribute3 := l_db_OKL_TAX_LINES_rec.attribute3;
2714: END IF;
2715: IF (x_OKL_TAX_LINES_rec.attribute4 = OKC_API.G_MISS_CHAR)
2709: x_OKL_TAX_LINES_rec.attribute2 := l_db_OKL_TAX_LINES_rec.attribute2;
2710: END IF;
2711: IF (x_OKL_TAX_LINES_rec.attribute3 = OKC_API.G_MISS_CHAR)
2712: THEN
2713: x_OKL_TAX_LINES_rec.attribute3 := l_db_OKL_TAX_LINES_rec.attribute3;
2714: END IF;
2715: IF (x_OKL_TAX_LINES_rec.attribute4 = OKC_API.G_MISS_CHAR)
2716: THEN
2717: x_OKL_TAX_LINES_rec.attribute4 := l_db_OKL_TAX_LINES_rec.attribute4;
2711: IF (x_OKL_TAX_LINES_rec.attribute3 = OKC_API.G_MISS_CHAR)
2712: THEN
2713: x_OKL_TAX_LINES_rec.attribute3 := l_db_OKL_TAX_LINES_rec.attribute3;
2714: END IF;
2715: IF (x_OKL_TAX_LINES_rec.attribute4 = OKC_API.G_MISS_CHAR)
2716: THEN
2717: x_OKL_TAX_LINES_rec.attribute4 := l_db_OKL_TAX_LINES_rec.attribute4;
2718: END IF;
2719: IF (x_OKL_TAX_LINES_rec.attribute5 = OKC_API.G_MISS_CHAR)
2713: x_OKL_TAX_LINES_rec.attribute3 := l_db_OKL_TAX_LINES_rec.attribute3;
2714: END IF;
2715: IF (x_OKL_TAX_LINES_rec.attribute4 = OKC_API.G_MISS_CHAR)
2716: THEN
2717: x_OKL_TAX_LINES_rec.attribute4 := l_db_OKL_TAX_LINES_rec.attribute4;
2718: END IF;
2719: IF (x_OKL_TAX_LINES_rec.attribute5 = OKC_API.G_MISS_CHAR)
2720: THEN
2721: x_OKL_TAX_LINES_rec.attribute5 := l_db_OKL_TAX_LINES_rec.attribute5;
2715: IF (x_OKL_TAX_LINES_rec.attribute4 = OKC_API.G_MISS_CHAR)
2716: THEN
2717: x_OKL_TAX_LINES_rec.attribute4 := l_db_OKL_TAX_LINES_rec.attribute4;
2718: END IF;
2719: IF (x_OKL_TAX_LINES_rec.attribute5 = OKC_API.G_MISS_CHAR)
2720: THEN
2721: x_OKL_TAX_LINES_rec.attribute5 := l_db_OKL_TAX_LINES_rec.attribute5;
2722: END IF;
2723: IF (x_OKL_TAX_LINES_rec.attribute6 = OKC_API.G_MISS_CHAR)
2717: x_OKL_TAX_LINES_rec.attribute4 := l_db_OKL_TAX_LINES_rec.attribute4;
2718: END IF;
2719: IF (x_OKL_TAX_LINES_rec.attribute5 = OKC_API.G_MISS_CHAR)
2720: THEN
2721: x_OKL_TAX_LINES_rec.attribute5 := l_db_OKL_TAX_LINES_rec.attribute5;
2722: END IF;
2723: IF (x_OKL_TAX_LINES_rec.attribute6 = OKC_API.G_MISS_CHAR)
2724: THEN
2725: x_OKL_TAX_LINES_rec.attribute6 := l_db_OKL_TAX_LINES_rec.attribute6;
2719: IF (x_OKL_TAX_LINES_rec.attribute5 = OKC_API.G_MISS_CHAR)
2720: THEN
2721: x_OKL_TAX_LINES_rec.attribute5 := l_db_OKL_TAX_LINES_rec.attribute5;
2722: END IF;
2723: IF (x_OKL_TAX_LINES_rec.attribute6 = OKC_API.G_MISS_CHAR)
2724: THEN
2725: x_OKL_TAX_LINES_rec.attribute6 := l_db_OKL_TAX_LINES_rec.attribute6;
2726: END IF;
2727: IF (x_OKL_TAX_LINES_rec.attribute7 = OKC_API.G_MISS_CHAR)
2721: x_OKL_TAX_LINES_rec.attribute5 := l_db_OKL_TAX_LINES_rec.attribute5;
2722: END IF;
2723: IF (x_OKL_TAX_LINES_rec.attribute6 = OKC_API.G_MISS_CHAR)
2724: THEN
2725: x_OKL_TAX_LINES_rec.attribute6 := l_db_OKL_TAX_LINES_rec.attribute6;
2726: END IF;
2727: IF (x_OKL_TAX_LINES_rec.attribute7 = OKC_API.G_MISS_CHAR)
2728: THEN
2729: x_OKL_TAX_LINES_rec.attribute7 := l_db_OKL_TAX_LINES_rec.attribute7;
2723: IF (x_OKL_TAX_LINES_rec.attribute6 = OKC_API.G_MISS_CHAR)
2724: THEN
2725: x_OKL_TAX_LINES_rec.attribute6 := l_db_OKL_TAX_LINES_rec.attribute6;
2726: END IF;
2727: IF (x_OKL_TAX_LINES_rec.attribute7 = OKC_API.G_MISS_CHAR)
2728: THEN
2729: x_OKL_TAX_LINES_rec.attribute7 := l_db_OKL_TAX_LINES_rec.attribute7;
2730: END IF;
2731: IF (x_OKL_TAX_LINES_rec.attribute8 = OKC_API.G_MISS_CHAR)
2725: x_OKL_TAX_LINES_rec.attribute6 := l_db_OKL_TAX_LINES_rec.attribute6;
2726: END IF;
2727: IF (x_OKL_TAX_LINES_rec.attribute7 = OKC_API.G_MISS_CHAR)
2728: THEN
2729: x_OKL_TAX_LINES_rec.attribute7 := l_db_OKL_TAX_LINES_rec.attribute7;
2730: END IF;
2731: IF (x_OKL_TAX_LINES_rec.attribute8 = OKC_API.G_MISS_CHAR)
2732: THEN
2733: x_OKL_TAX_LINES_rec.attribute8 := l_db_OKL_TAX_LINES_rec.attribute8;
2727: IF (x_OKL_TAX_LINES_rec.attribute7 = OKC_API.G_MISS_CHAR)
2728: THEN
2729: x_OKL_TAX_LINES_rec.attribute7 := l_db_OKL_TAX_LINES_rec.attribute7;
2730: END IF;
2731: IF (x_OKL_TAX_LINES_rec.attribute8 = OKC_API.G_MISS_CHAR)
2732: THEN
2733: x_OKL_TAX_LINES_rec.attribute8 := l_db_OKL_TAX_LINES_rec.attribute8;
2734: END IF;
2735: IF (x_OKL_TAX_LINES_rec.attribute9 = OKC_API.G_MISS_CHAR)
2729: x_OKL_TAX_LINES_rec.attribute7 := l_db_OKL_TAX_LINES_rec.attribute7;
2730: END IF;
2731: IF (x_OKL_TAX_LINES_rec.attribute8 = OKC_API.G_MISS_CHAR)
2732: THEN
2733: x_OKL_TAX_LINES_rec.attribute8 := l_db_OKL_TAX_LINES_rec.attribute8;
2734: END IF;
2735: IF (x_OKL_TAX_LINES_rec.attribute9 = OKC_API.G_MISS_CHAR)
2736: THEN
2737: x_OKL_TAX_LINES_rec.attribute9 := l_db_OKL_TAX_LINES_rec.attribute9;
2731: IF (x_OKL_TAX_LINES_rec.attribute8 = OKC_API.G_MISS_CHAR)
2732: THEN
2733: x_OKL_TAX_LINES_rec.attribute8 := l_db_OKL_TAX_LINES_rec.attribute8;
2734: END IF;
2735: IF (x_OKL_TAX_LINES_rec.attribute9 = OKC_API.G_MISS_CHAR)
2736: THEN
2737: x_OKL_TAX_LINES_rec.attribute9 := l_db_OKL_TAX_LINES_rec.attribute9;
2738: END IF;
2739: IF (x_OKL_TAX_LINES_rec.attribute10 = OKC_API.G_MISS_CHAR)
2733: x_OKL_TAX_LINES_rec.attribute8 := l_db_OKL_TAX_LINES_rec.attribute8;
2734: END IF;
2735: IF (x_OKL_TAX_LINES_rec.attribute9 = OKC_API.G_MISS_CHAR)
2736: THEN
2737: x_OKL_TAX_LINES_rec.attribute9 := l_db_OKL_TAX_LINES_rec.attribute9;
2738: END IF;
2739: IF (x_OKL_TAX_LINES_rec.attribute10 = OKC_API.G_MISS_CHAR)
2740: THEN
2741: x_OKL_TAX_LINES_rec.attribute10 := l_db_OKL_TAX_LINES_rec.attribute10;
2735: IF (x_OKL_TAX_LINES_rec.attribute9 = OKC_API.G_MISS_CHAR)
2736: THEN
2737: x_OKL_TAX_LINES_rec.attribute9 := l_db_OKL_TAX_LINES_rec.attribute9;
2738: END IF;
2739: IF (x_OKL_TAX_LINES_rec.attribute10 = OKC_API.G_MISS_CHAR)
2740: THEN
2741: x_OKL_TAX_LINES_rec.attribute10 := l_db_OKL_TAX_LINES_rec.attribute10;
2742: END IF;
2743: IF (x_OKL_TAX_LINES_rec.attribute11 = OKC_API.G_MISS_CHAR)
2737: x_OKL_TAX_LINES_rec.attribute9 := l_db_OKL_TAX_LINES_rec.attribute9;
2738: END IF;
2739: IF (x_OKL_TAX_LINES_rec.attribute10 = OKC_API.G_MISS_CHAR)
2740: THEN
2741: x_OKL_TAX_LINES_rec.attribute10 := l_db_OKL_TAX_LINES_rec.attribute10;
2742: END IF;
2743: IF (x_OKL_TAX_LINES_rec.attribute11 = OKC_API.G_MISS_CHAR)
2744: THEN
2745: x_OKL_TAX_LINES_rec.attribute11 := l_db_OKL_TAX_LINES_rec.attribute11;
2739: IF (x_OKL_TAX_LINES_rec.attribute10 = OKC_API.G_MISS_CHAR)
2740: THEN
2741: x_OKL_TAX_LINES_rec.attribute10 := l_db_OKL_TAX_LINES_rec.attribute10;
2742: END IF;
2743: IF (x_OKL_TAX_LINES_rec.attribute11 = OKC_API.G_MISS_CHAR)
2744: THEN
2745: x_OKL_TAX_LINES_rec.attribute11 := l_db_OKL_TAX_LINES_rec.attribute11;
2746: END IF;
2747: IF (x_OKL_TAX_LINES_rec.attribute12 = OKC_API.G_MISS_CHAR)
2741: x_OKL_TAX_LINES_rec.attribute10 := l_db_OKL_TAX_LINES_rec.attribute10;
2742: END IF;
2743: IF (x_OKL_TAX_LINES_rec.attribute11 = OKC_API.G_MISS_CHAR)
2744: THEN
2745: x_OKL_TAX_LINES_rec.attribute11 := l_db_OKL_TAX_LINES_rec.attribute11;
2746: END IF;
2747: IF (x_OKL_TAX_LINES_rec.attribute12 = OKC_API.G_MISS_CHAR)
2748: THEN
2749: x_OKL_TAX_LINES_rec.attribute12 := l_db_OKL_TAX_LINES_rec.attribute12;
2743: IF (x_OKL_TAX_LINES_rec.attribute11 = OKC_API.G_MISS_CHAR)
2744: THEN
2745: x_OKL_TAX_LINES_rec.attribute11 := l_db_OKL_TAX_LINES_rec.attribute11;
2746: END IF;
2747: IF (x_OKL_TAX_LINES_rec.attribute12 = OKC_API.G_MISS_CHAR)
2748: THEN
2749: x_OKL_TAX_LINES_rec.attribute12 := l_db_OKL_TAX_LINES_rec.attribute12;
2750: END IF;
2751: IF (x_OKL_TAX_LINES_rec.attribute13 = OKC_API.G_MISS_CHAR)
2745: x_OKL_TAX_LINES_rec.attribute11 := l_db_OKL_TAX_LINES_rec.attribute11;
2746: END IF;
2747: IF (x_OKL_TAX_LINES_rec.attribute12 = OKC_API.G_MISS_CHAR)
2748: THEN
2749: x_OKL_TAX_LINES_rec.attribute12 := l_db_OKL_TAX_LINES_rec.attribute12;
2750: END IF;
2751: IF (x_OKL_TAX_LINES_rec.attribute13 = OKC_API.G_MISS_CHAR)
2752: THEN
2753: x_OKL_TAX_LINES_rec.attribute13 := l_db_OKL_TAX_LINES_rec.attribute13;
2747: IF (x_OKL_TAX_LINES_rec.attribute12 = OKC_API.G_MISS_CHAR)
2748: THEN
2749: x_OKL_TAX_LINES_rec.attribute12 := l_db_OKL_TAX_LINES_rec.attribute12;
2750: END IF;
2751: IF (x_OKL_TAX_LINES_rec.attribute13 = OKC_API.G_MISS_CHAR)
2752: THEN
2753: x_OKL_TAX_LINES_rec.attribute13 := l_db_OKL_TAX_LINES_rec.attribute13;
2754: END IF;
2755: IF (x_OKL_TAX_LINES_rec.attribute14 = OKC_API.G_MISS_CHAR)
2749: x_OKL_TAX_LINES_rec.attribute12 := l_db_OKL_TAX_LINES_rec.attribute12;
2750: END IF;
2751: IF (x_OKL_TAX_LINES_rec.attribute13 = OKC_API.G_MISS_CHAR)
2752: THEN
2753: x_OKL_TAX_LINES_rec.attribute13 := l_db_OKL_TAX_LINES_rec.attribute13;
2754: END IF;
2755: IF (x_OKL_TAX_LINES_rec.attribute14 = OKC_API.G_MISS_CHAR)
2756: THEN
2757: x_OKL_TAX_LINES_rec.attribute14 := l_db_OKL_TAX_LINES_rec.attribute14;
2751: IF (x_OKL_TAX_LINES_rec.attribute13 = OKC_API.G_MISS_CHAR)
2752: THEN
2753: x_OKL_TAX_LINES_rec.attribute13 := l_db_OKL_TAX_LINES_rec.attribute13;
2754: END IF;
2755: IF (x_OKL_TAX_LINES_rec.attribute14 = OKC_API.G_MISS_CHAR)
2756: THEN
2757: x_OKL_TAX_LINES_rec.attribute14 := l_db_OKL_TAX_LINES_rec.attribute14;
2758: END IF;
2759: IF (x_OKL_TAX_LINES_rec.attribute15 = OKC_API.G_MISS_CHAR)
2753: x_OKL_TAX_LINES_rec.attribute13 := l_db_OKL_TAX_LINES_rec.attribute13;
2754: END IF;
2755: IF (x_OKL_TAX_LINES_rec.attribute14 = OKC_API.G_MISS_CHAR)
2756: THEN
2757: x_OKL_TAX_LINES_rec.attribute14 := l_db_OKL_TAX_LINES_rec.attribute14;
2758: END IF;
2759: IF (x_OKL_TAX_LINES_rec.attribute15 = OKC_API.G_MISS_CHAR)
2760: THEN
2761: x_OKL_TAX_LINES_rec.attribute15 := l_db_OKL_TAX_LINES_rec.attribute15;
2755: IF (x_OKL_TAX_LINES_rec.attribute14 = OKC_API.G_MISS_CHAR)
2756: THEN
2757: x_OKL_TAX_LINES_rec.attribute14 := l_db_OKL_TAX_LINES_rec.attribute14;
2758: END IF;
2759: IF (x_OKL_TAX_LINES_rec.attribute15 = OKC_API.G_MISS_CHAR)
2760: THEN
2761: x_OKL_TAX_LINES_rec.attribute15 := l_db_OKL_TAX_LINES_rec.attribute15;
2762: END IF;
2763: IF (x_OKL_TAX_LINES_rec.created_by = OKC_API.G_MISS_NUM)
2757: x_OKL_TAX_LINES_rec.attribute14 := l_db_OKL_TAX_LINES_rec.attribute14;
2758: END IF;
2759: IF (x_OKL_TAX_LINES_rec.attribute15 = OKC_API.G_MISS_CHAR)
2760: THEN
2761: x_OKL_TAX_LINES_rec.attribute15 := l_db_OKL_TAX_LINES_rec.attribute15;
2762: END IF;
2763: IF (x_OKL_TAX_LINES_rec.created_by = OKC_API.G_MISS_NUM)
2764: THEN
2765: x_OKL_TAX_LINES_rec.created_by := l_db_OKL_TAX_LINES_rec.created_by;
2759: IF (x_OKL_TAX_LINES_rec.attribute15 = OKC_API.G_MISS_CHAR)
2760: THEN
2761: x_OKL_TAX_LINES_rec.attribute15 := l_db_OKL_TAX_LINES_rec.attribute15;
2762: END IF;
2763: IF (x_OKL_TAX_LINES_rec.created_by = OKC_API.G_MISS_NUM)
2764: THEN
2765: x_OKL_TAX_LINES_rec.created_by := l_db_OKL_TAX_LINES_rec.created_by;
2766: END IF;
2767: IF (x_OKL_TAX_LINES_rec.creation_date = OKC_API.G_MISS_DATE)
2761: x_OKL_TAX_LINES_rec.attribute15 := l_db_OKL_TAX_LINES_rec.attribute15;
2762: END IF;
2763: IF (x_OKL_TAX_LINES_rec.created_by = OKC_API.G_MISS_NUM)
2764: THEN
2765: x_OKL_TAX_LINES_rec.created_by := l_db_OKL_TAX_LINES_rec.created_by;
2766: END IF;
2767: IF (x_OKL_TAX_LINES_rec.creation_date = OKC_API.G_MISS_DATE)
2768: THEN
2769: x_OKL_TAX_LINES_rec.creation_date := l_db_OKL_TAX_LINES_rec.creation_date;
2763: IF (x_OKL_TAX_LINES_rec.created_by = OKC_API.G_MISS_NUM)
2764: THEN
2765: x_OKL_TAX_LINES_rec.created_by := l_db_OKL_TAX_LINES_rec.created_by;
2766: END IF;
2767: IF (x_OKL_TAX_LINES_rec.creation_date = OKC_API.G_MISS_DATE)
2768: THEN
2769: x_OKL_TAX_LINES_rec.creation_date := l_db_OKL_TAX_LINES_rec.creation_date;
2770: END IF;
2771: IF (x_OKL_TAX_LINES_rec.last_updated_by = OKC_API.G_MISS_NUM)
2765: x_OKL_TAX_LINES_rec.created_by := l_db_OKL_TAX_LINES_rec.created_by;
2766: END IF;
2767: IF (x_OKL_TAX_LINES_rec.creation_date = OKC_API.G_MISS_DATE)
2768: THEN
2769: x_OKL_TAX_LINES_rec.creation_date := l_db_OKL_TAX_LINES_rec.creation_date;
2770: END IF;
2771: IF (x_OKL_TAX_LINES_rec.last_updated_by = OKC_API.G_MISS_NUM)
2772: THEN
2773: x_OKL_TAX_LINES_rec.last_updated_by := l_db_OKL_TAX_LINES_rec.last_updated_by;
2767: IF (x_OKL_TAX_LINES_rec.creation_date = OKC_API.G_MISS_DATE)
2768: THEN
2769: x_OKL_TAX_LINES_rec.creation_date := l_db_OKL_TAX_LINES_rec.creation_date;
2770: END IF;
2771: IF (x_OKL_TAX_LINES_rec.last_updated_by = OKC_API.G_MISS_NUM)
2772: THEN
2773: x_OKL_TAX_LINES_rec.last_updated_by := l_db_OKL_TAX_LINES_rec.last_updated_by;
2774: END IF;
2775: IF (x_OKL_TAX_LINES_rec.last_update_date = OKC_API.G_MISS_DATE)
2769: x_OKL_TAX_LINES_rec.creation_date := l_db_OKL_TAX_LINES_rec.creation_date;
2770: END IF;
2771: IF (x_OKL_TAX_LINES_rec.last_updated_by = OKC_API.G_MISS_NUM)
2772: THEN
2773: x_OKL_TAX_LINES_rec.last_updated_by := l_db_OKL_TAX_LINES_rec.last_updated_by;
2774: END IF;
2775: IF (x_OKL_TAX_LINES_rec.last_update_date = OKC_API.G_MISS_DATE)
2776: THEN
2777: x_OKL_TAX_LINES_rec.last_update_date := l_db_OKL_TAX_LINES_rec.last_update_date;
2771: IF (x_OKL_TAX_LINES_rec.last_updated_by = OKC_API.G_MISS_NUM)
2772: THEN
2773: x_OKL_TAX_LINES_rec.last_updated_by := l_db_OKL_TAX_LINES_rec.last_updated_by;
2774: END IF;
2775: IF (x_OKL_TAX_LINES_rec.last_update_date = OKC_API.G_MISS_DATE)
2776: THEN
2777: x_OKL_TAX_LINES_rec.last_update_date := l_db_OKL_TAX_LINES_rec.last_update_date;
2778: END IF;
2779: IF (x_OKL_TAX_LINES_rec.last_update_login = OKC_API.G_MISS_NUM)
2773: x_OKL_TAX_LINES_rec.last_updated_by := l_db_OKL_TAX_LINES_rec.last_updated_by;
2774: END IF;
2775: IF (x_OKL_TAX_LINES_rec.last_update_date = OKC_API.G_MISS_DATE)
2776: THEN
2777: x_OKL_TAX_LINES_rec.last_update_date := l_db_OKL_TAX_LINES_rec.last_update_date;
2778: END IF;
2779: IF (x_OKL_TAX_LINES_rec.last_update_login = OKC_API.G_MISS_NUM)
2780: THEN
2781: x_OKL_TAX_LINES_rec.last_update_login := l_db_OKL_TAX_LINES_rec.last_update_login;
2775: IF (x_OKL_TAX_LINES_rec.last_update_date = OKC_API.G_MISS_DATE)
2776: THEN
2777: x_OKL_TAX_LINES_rec.last_update_date := l_db_OKL_TAX_LINES_rec.last_update_date;
2778: END IF;
2779: IF (x_OKL_TAX_LINES_rec.last_update_login = OKC_API.G_MISS_NUM)
2780: THEN
2781: x_OKL_TAX_LINES_rec.last_update_login := l_db_OKL_TAX_LINES_rec.last_update_login;
2782: END IF;
2783: END IF;
2777: x_OKL_TAX_LINES_rec.last_update_date := l_db_OKL_TAX_LINES_rec.last_update_date;
2778: END IF;
2779: IF (x_OKL_TAX_LINES_rec.last_update_login = OKC_API.G_MISS_NUM)
2780: THEN
2781: x_OKL_TAX_LINES_rec.last_update_login := l_db_OKL_TAX_LINES_rec.last_update_login;
2782: END IF;
2783: END IF;
2784: RETURN(l_return_status);
2785: END populate_new_record;
2783: END IF;
2784: RETURN(l_return_status);
2785: END populate_new_record;
2786: ----------------------------------------
2787: -- Set_Attributes for:OKL_TAX_LINES_V --
2788: ----------------------------------------
2789: FUNCTION Set_Attributes (
2790: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type,
2791: x_OKL_TAX_LINES_rec OUT NOCOPY OKL_TAX_LINES_rec_type
2786: ----------------------------------------
2787: -- Set_Attributes for:OKL_TAX_LINES_V --
2788: ----------------------------------------
2789: FUNCTION Set_Attributes (
2790: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type,
2791: x_OKL_TAX_LINES_rec OUT NOCOPY OKL_TAX_LINES_rec_type
2792: ) RETURN VARCHAR2 IS
2793: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2794: BEGIN
2787: -- Set_Attributes for:OKL_TAX_LINES_V --
2788: ----------------------------------------
2789: FUNCTION Set_Attributes (
2790: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type,
2791: x_OKL_TAX_LINES_rec OUT NOCOPY OKL_TAX_LINES_rec_type
2792: ) RETURN VARCHAR2 IS
2793: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2794: BEGIN
2795: x_OKL_TAX_LINES_rec := p_OKL_TAX_LINES_rec;
2791: x_OKL_TAX_LINES_rec OUT NOCOPY OKL_TAX_LINES_rec_type
2792: ) RETURN VARCHAR2 IS
2793: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2794: BEGIN
2795: x_OKL_TAX_LINES_rec := p_OKL_TAX_LINES_rec;
2796: RETURN(l_return_status);
2797: END Set_Attributes;
2798: BEGIN
2799: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2809: RAISE OKC_API.G_EXCEPTION_ERROR;
2810: END IF;
2811: --- Setting item attributes
2812: l_return_status := Set_Attributes(
2813: p_OKL_TAX_LINES_rec, -- IN
2814: x_OKL_TAX_LINES_rec); -- OUT
2815: --- If any errors happen abort API
2816: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2817: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2810: END IF;
2811: --- Setting item attributes
2812: l_return_status := Set_Attributes(
2813: p_OKL_TAX_LINES_rec, -- IN
2814: x_OKL_TAX_LINES_rec); -- OUT
2815: --- If any errors happen abort API
2816: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2817: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2818: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2817: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2818: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2819: RAISE OKC_API.G_EXCEPTION_ERROR;
2820: END IF;
2821: l_return_status := populate_new_record(l_OKL_TAX_LINES_rec, l_def_OKL_TAX_LINES_rec);
2822: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2823: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2824: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2825: RAISE OKC_API.G_EXCEPTION_ERROR;
2823: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2824: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2825: RAISE OKC_API.G_EXCEPTION_ERROR;
2826: END IF;
2827: l_def_OKL_TAX_LINES_rec := fill_who_columns(l_def_OKL_TAX_LINES_rec);
2828: --- Validate all non-missing attributes (Item Level Validation)
2829: l_return_status := Validate_Attributes(l_def_OKL_TAX_LINES_rec);
2830: --- If any errors happen abort API
2831: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2825: RAISE OKC_API.G_EXCEPTION_ERROR;
2826: END IF;
2827: l_def_OKL_TAX_LINES_rec := fill_who_columns(l_def_OKL_TAX_LINES_rec);
2828: --- Validate all non-missing attributes (Item Level Validation)
2829: l_return_status := Validate_Attributes(l_def_OKL_TAX_LINES_rec);
2830: --- If any errors happen abort API
2831: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2832: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2833: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2832: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2833: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2834: RAISE OKC_API.G_EXCEPTION_ERROR;
2835: END IF;
2836: l_return_status := Validate_Record(l_def_OKL_TAX_LINES_rec, l_db_OKL_TAX_LINES_rec);
2837: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2838: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2839: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2840: RAISE OKC_API.G_EXCEPTION_ERROR;
2846: p_init_msg_list => p_init_msg_list,
2847: x_return_status => l_return_status,
2848: x_msg_count => x_msg_count,
2849: x_msg_data => x_msg_data,
2850: p_OKL_TAX_LINES_rec => p_OKL_TAX_LINES_rec);
2851: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2852: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2853: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2854: RAISE OKC_API.G_EXCEPTION_ERROR;
2856:
2857: -----------------------------------------
2858: -- Move VIEW record to "Child" records --
2859: -----------------------------------------
2860: migrate(l_def_OKL_TAX_LINES_rec, l_tax_rec);
2861: -----------------------------------------------
2862: -- Call the UPDATE_ROW for each child record --
2863: -----------------------------------------------
2864: update_row(
2873: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2874: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2875: RAISE OKC_API.G_EXCEPTION_ERROR;
2876: END IF;
2877: migrate(lx_tax_rec, l_def_OKL_TAX_LINES_rec);
2878: x_OKL_TAX_LINES_rec := l_def_OKL_TAX_LINES_rec;
2879: x_return_status := l_return_status;
2880: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2881: EXCEPTION
2874: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2875: RAISE OKC_API.G_EXCEPTION_ERROR;
2876: END IF;
2877: migrate(lx_tax_rec, l_def_OKL_TAX_LINES_rec);
2878: x_OKL_TAX_LINES_rec := l_def_OKL_TAX_LINES_rec;
2879: x_return_status := l_return_status;
2880: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2881: EXCEPTION
2882: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2910: '_PVT'
2911: );
2912: END update_row;
2913: ---------------------------------------------------
2914: -- PL/SQL TBL update_row for:okl_tax_lines_v_tbl --
2915: ---------------------------------------------------
2916: PROCEDURE update_row(
2917: p_api_version IN NUMBER,
2918: p_init_msg_list IN VARCHAR2,
2918: p_init_msg_list IN VARCHAR2,
2919: x_return_status OUT NOCOPY VARCHAR2,
2920: x_msg_count OUT NOCOPY NUMBER,
2921: x_msg_data OUT NOCOPY VARCHAR2,
2922: p_OKL_TAX_LINES_tbl IN OKL_TAX_LINES_tbl_type,
2923: x_OKL_TAX_LINES_tbl OUT NOCOPY OKL_TAX_LINES_tbl_type,
2924: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
2925:
2926: l_api_version CONSTANT NUMBER := 1;
2919: x_return_status OUT NOCOPY VARCHAR2,
2920: x_msg_count OUT NOCOPY NUMBER,
2921: x_msg_data OUT NOCOPY VARCHAR2,
2922: p_OKL_TAX_LINES_tbl IN OKL_TAX_LINES_tbl_type,
2923: x_OKL_TAX_LINES_tbl OUT NOCOPY OKL_TAX_LINES_tbl_type,
2924: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
2925:
2926: l_api_version CONSTANT NUMBER := 1;
2927: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
2928: i NUMBER := 0;
2929: BEGIN
2930: OKC_API.init_msg_list(p_init_msg_list);
2931: -- Make sure PL/SQL table has records in it before passing
2932: IF (p_OKL_TAX_LINES_tbl.COUNT > 0) THEN
2933: i := p_OKL_TAX_LINES_tbl.FIRST;
2934: LOOP
2935: DECLARE
2936: l_error_rec OKC_API.ERROR_REC_TYPE;
2929: BEGIN
2930: OKC_API.init_msg_list(p_init_msg_list);
2931: -- Make sure PL/SQL table has records in it before passing
2932: IF (p_OKL_TAX_LINES_tbl.COUNT > 0) THEN
2933: i := p_OKL_TAX_LINES_tbl.FIRST;
2934: LOOP
2935: DECLARE
2936: l_error_rec OKC_API.ERROR_REC_TYPE;
2937: BEGIN
2943: p_init_msg_list => OKC_API.G_FALSE,
2944: x_return_status => l_error_rec.error_type,
2945: x_msg_count => l_error_rec.msg_count,
2946: x_msg_data => l_error_rec.msg_data,
2947: p_OKL_TAX_LINES_rec => p_OKL_TAX_LINES_tbl(i),
2948: x_OKL_TAX_LINES_rec => x_OKL_TAX_LINES_tbl(i));
2949: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
2950: l_error_rec.sqlcode := SQLCODE;
2951: load_error_tbl(l_error_rec, px_error_tbl);
2944: x_return_status => l_error_rec.error_type,
2945: x_msg_count => l_error_rec.msg_count,
2946: x_msg_data => l_error_rec.msg_data,
2947: p_OKL_TAX_LINES_rec => p_OKL_TAX_LINES_tbl(i),
2948: x_OKL_TAX_LINES_rec => x_OKL_TAX_LINES_tbl(i));
2949: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
2950: l_error_rec.sqlcode := SQLCODE;
2951: load_error_tbl(l_error_rec, px_error_tbl);
2952: ELSE
2966: l_error_rec.error_type := 'OTHERS';
2967: l_error_rec.sqlcode := SQLCODE;
2968: load_error_tbl(l_error_rec, px_error_tbl);
2969: END;
2970: EXIT WHEN (i = p_OKL_TAX_LINES_tbl.LAST);
2971: i := p_OKL_TAX_LINES_tbl.NEXT(i);
2972: END LOOP;
2973: END IF;
2974: -- Loop through the error_tbl to find the error with the highest severity
2967: l_error_rec.sqlcode := SQLCODE;
2968: load_error_tbl(l_error_rec, px_error_tbl);
2969: END;
2970: EXIT WHEN (i = p_OKL_TAX_LINES_tbl.LAST);
2971: i := p_OKL_TAX_LINES_tbl.NEXT(i);
2972: END LOOP;
2973: END IF;
2974: -- Loop through the error_tbl to find the error with the highest severity
2975: -- and return it.
3008: );
3009: END update_row;
3010:
3011: ---------------------------------------------------
3012: -- PL/SQL TBL update_row for:OKL_TAX_LINES_V_TBL --
3013: ---------------------------------------------------
3014: -- This procedure is the same as the one above except it does not have a "px_error_tbl" argument.
3015: -- This procedure was create for backward compatibility and simply is a wrapper for the one above.
3016: PROCEDURE update_row(
3018: p_init_msg_list IN VARCHAR2,
3019: x_return_status OUT NOCOPY VARCHAR2,
3020: x_msg_count OUT NOCOPY NUMBER,
3021: x_msg_data OUT NOCOPY VARCHAR2,
3022: p_OKL_TAX_LINES_tbl IN OKL_TAX_LINES_tbl_type,
3023: x_OKL_TAX_LINES_tbl OUT NOCOPY OKL_TAX_LINES_tbl_type) IS
3024:
3025: l_api_version CONSTANT NUMBER := 1;
3026: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
3019: x_return_status OUT NOCOPY VARCHAR2,
3020: x_msg_count OUT NOCOPY NUMBER,
3021: x_msg_data OUT NOCOPY VARCHAR2,
3022: p_OKL_TAX_LINES_tbl IN OKL_TAX_LINES_tbl_type,
3023: x_OKL_TAX_LINES_tbl OUT NOCOPY OKL_TAX_LINES_tbl_type) IS
3024:
3025: l_api_version CONSTANT NUMBER := 1;
3026: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
3027: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3028: l_error_tbl OKC_API.ERROR_TBL_TYPE;
3029: BEGIN
3030: OKC_API.init_msg_list(p_init_msg_list);
3031: -- Make sure PL/SQL table has records in it before passing
3032: IF (p_OKL_TAX_LINES_tbl.COUNT > 0) THEN
3033: update_row (
3034: p_api_version => p_api_version,
3035: p_init_msg_list => OKC_API.G_FALSE,
3036: x_return_status => x_return_status,
3035: p_init_msg_list => OKC_API.G_FALSE,
3036: x_return_status => x_return_status,
3037: x_msg_count => x_msg_count,
3038: x_msg_data => x_msg_data,
3039: p_OKL_TAX_LINES_tbl => p_OKL_TAX_LINES_tbl,
3040: x_OKL_TAX_LINES_tbl => x_OKL_TAX_LINES_tbl,
3041: px_error_tbl => l_error_tbl);
3042: END IF;
3043: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3036: x_return_status => x_return_status,
3037: x_msg_count => x_msg_count,
3038: x_msg_data => x_msg_data,
3039: p_OKL_TAX_LINES_tbl => p_OKL_TAX_LINES_tbl,
3040: x_OKL_TAX_LINES_tbl => x_OKL_TAX_LINES_tbl,
3041: px_error_tbl => l_error_tbl);
3042: END IF;
3043: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3044: EXCEPTION
3077: ---------------------------------------------------------------------------
3078: -- PROCEDURE delete_row
3079: ---------------------------------------------------------------------------
3080: ----------------------------------
3081: -- delete_row for:OKL_TAX_LINES --
3082: ----------------------------------
3083: PROCEDURE delete_row(
3084: p_init_msg_list IN VARCHAR2,
3085: x_return_status OUT NOCOPY VARCHAR2,
3102: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3103: RAISE OKC_API.G_EXCEPTION_ERROR;
3104: END IF;
3105:
3106: DELETE FROM OKL_TAX_LINES
3107: WHERE ID = p_tax_rec.id;
3108:
3109: x_return_status := l_return_status;
3110: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3140: '_PVT'
3141: );
3142: END delete_row;
3143: ------------------------------------
3144: -- delete_row for:OKL_TAX_LINES_V --
3145: ------------------------------------
3146: PROCEDURE delete_row(
3147: p_api_version IN NUMBER,
3148: p_init_msg_list IN VARCHAR2,
3148: p_init_msg_list IN VARCHAR2,
3149: x_return_status OUT NOCOPY VARCHAR2,
3150: x_msg_count OUT NOCOPY NUMBER,
3151: x_msg_data OUT NOCOPY VARCHAR2,
3152: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type) IS
3153:
3154: l_api_version CONSTANT NUMBER := 1;
3155: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3156: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3153:
3154: l_api_version CONSTANT NUMBER := 1;
3155: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3156: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3157: l_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type := p_OKL_TAX_LINES_rec;
3158: l_tax_rec tax_rec_type;
3159: BEGIN
3160: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
3161: G_PKG_NAME,
3171: END IF;
3172: -----------------------------------------
3173: -- Move VIEW record to "Child" records --
3174: -----------------------------------------
3175: migrate(l_OKL_TAX_LINES_rec, l_tax_rec);
3176: -----------------------------------------------
3177: -- Call the DELETE_ROW for each child record --
3178: -----------------------------------------------
3179: delete_row(
3222: '_PVT'
3223: );
3224: END delete_row;
3225: -----------------------------------------------
3226: -- PL/SQL TBL delete_row for:OKL_TAX_LINES_V --
3227: -----------------------------------------------
3228: PROCEDURE delete_row(
3229: p_api_version IN NUMBER,
3230: p_init_msg_list IN VARCHAR2,
3230: p_init_msg_list IN VARCHAR2,
3231: x_return_status OUT NOCOPY VARCHAR2,
3232: x_msg_count OUT NOCOPY NUMBER,
3233: x_msg_data OUT NOCOPY VARCHAR2,
3234: p_OKL_TAX_LINES_tbl IN OKL_TAX_LINES_tbl_type,
3235: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
3236:
3237: l_api_version CONSTANT NUMBER := 1;
3238: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
3239: i NUMBER := 0;
3240: BEGIN
3241: OKC_API.init_msg_list(p_init_msg_list);
3242: -- Make sure PL/SQL table has records in it before passing
3243: IF (p_OKL_TAX_LINES_tbl.COUNT > 0) THEN
3244: i := p_OKL_TAX_LINES_tbl.FIRST;
3245: LOOP
3246: DECLARE
3247: l_error_rec OKC_API.ERROR_REC_TYPE;
3240: BEGIN
3241: OKC_API.init_msg_list(p_init_msg_list);
3242: -- Make sure PL/SQL table has records in it before passing
3243: IF (p_OKL_TAX_LINES_tbl.COUNT > 0) THEN
3244: i := p_OKL_TAX_LINES_tbl.FIRST;
3245: LOOP
3246: DECLARE
3247: l_error_rec OKC_API.ERROR_REC_TYPE;
3248: BEGIN
3254: p_init_msg_list => OKC_API.G_FALSE,
3255: x_return_status => l_error_rec.error_type,
3256: x_msg_count => l_error_rec.msg_count,
3257: x_msg_data => l_error_rec.msg_data,
3258: p_OKL_TAX_LINES_rec => p_OKL_TAX_LINES_tbl(i));
3259: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
3260: l_error_rec.sqlcode := SQLCODE;
3261: load_error_tbl(l_error_rec, px_error_tbl);
3262: ELSE
3276: l_error_rec.error_type := 'OTHERS';
3277: l_error_rec.sqlcode := SQLCODE;
3278: load_error_tbl(l_error_rec, px_error_tbl);
3279: END;
3280: EXIT WHEN (i = p_OKL_TAX_LINES_tbl.LAST);
3281: i := p_OKL_TAX_LINES_tbl.NEXT(i);
3282: END LOOP;
3283: END IF;
3284: -- Loop through the error_tbl to find the error with the highest severity
3277: l_error_rec.sqlcode := SQLCODE;
3278: load_error_tbl(l_error_rec, px_error_tbl);
3279: END;
3280: EXIT WHEN (i = p_OKL_TAX_LINES_tbl.LAST);
3281: i := p_OKL_TAX_LINES_tbl.NEXT(i);
3282: END LOOP;
3283: END IF;
3284: -- Loop through the error_tbl to find the error with the highest severity
3285: -- and return it.
3318: );
3319: END delete_row;
3320:
3321: -----------------------------------------------
3322: -- PL/SQL TBL delete_row for:OKL_TAX_LINES_V --
3323: -----------------------------------------------
3324: PROCEDURE delete_row(
3325: p_api_version IN NUMBER,
3326: p_init_msg_list IN VARCHAR2,
3326: p_init_msg_list IN VARCHAR2,
3327: x_return_status OUT NOCOPY VARCHAR2,
3328: x_msg_count OUT NOCOPY NUMBER,
3329: x_msg_data OUT NOCOPY VARCHAR2,
3330: p_OKL_TAX_LINES_tbl IN OKL_TAX_LINES_tbl_type) IS
3331:
3332: l_api_version CONSTANT NUMBER := 1;
3333: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
3334: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3335: l_error_tbl OKC_API.ERROR_TBL_TYPE;
3336: BEGIN
3337: OKC_API.init_msg_list(p_init_msg_list);
3338: -- Make sure PL/SQL table has records in it before passing
3339: IF (p_OKL_TAX_LINES_tbl.COUNT > 0) THEN
3340: delete_row (
3341: p_api_version => p_api_version,
3342: p_init_msg_list => OKC_API.G_FALSE,
3343: x_return_status => x_return_status,
3342: p_init_msg_list => OKC_API.G_FALSE,
3343: x_return_status => x_return_status,
3344: x_msg_count => x_msg_count,
3345: x_msg_data => x_msg_data,
3346: p_OKL_TAX_LINES_tbl => p_OKL_TAX_LINES_tbl,
3347: px_error_tbl => l_error_tbl);
3348: END IF;
3349: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3350: EXCEPTION