155:
156: OPEN get_lines_det_factors(p_transaction_rec);
157: LOOP
158: FETCH get_lines_det_factors BULK COLLECT INTO
159: zx_global_structures_pkg.trx_line_dist_tbl.APPLICATION_ID,
160: zx_global_structures_pkg.trx_line_dist_tbl.ENTITY_CODE,
161: zx_global_structures_pkg.trx_line_dist_tbl.EVENT_CLASS_CODE,
162: zx_global_structures_pkg.trx_line_dist_tbl.EVENT_TYPE_CODE,
163: zx_global_structures_pkg.trx_line_dist_tbl.LINE_LEVEL_ACTION,
156: OPEN get_lines_det_factors(p_transaction_rec);
157: LOOP
158: FETCH get_lines_det_factors BULK COLLECT INTO
159: zx_global_structures_pkg.trx_line_dist_tbl.APPLICATION_ID,
160: zx_global_structures_pkg.trx_line_dist_tbl.ENTITY_CODE,
161: zx_global_structures_pkg.trx_line_dist_tbl.EVENT_CLASS_CODE,
162: zx_global_structures_pkg.trx_line_dist_tbl.EVENT_TYPE_CODE,
163: zx_global_structures_pkg.trx_line_dist_tbl.LINE_LEVEL_ACTION,
164: zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID,
157: LOOP
158: FETCH get_lines_det_factors BULK COLLECT INTO
159: zx_global_structures_pkg.trx_line_dist_tbl.APPLICATION_ID,
160: zx_global_structures_pkg.trx_line_dist_tbl.ENTITY_CODE,
161: zx_global_structures_pkg.trx_line_dist_tbl.EVENT_CLASS_CODE,
162: zx_global_structures_pkg.trx_line_dist_tbl.EVENT_TYPE_CODE,
163: zx_global_structures_pkg.trx_line_dist_tbl.LINE_LEVEL_ACTION,
164: zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID,
165: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_ID,
158: FETCH get_lines_det_factors BULK COLLECT INTO
159: zx_global_structures_pkg.trx_line_dist_tbl.APPLICATION_ID,
160: zx_global_structures_pkg.trx_line_dist_tbl.ENTITY_CODE,
161: zx_global_structures_pkg.trx_line_dist_tbl.EVENT_CLASS_CODE,
162: zx_global_structures_pkg.trx_line_dist_tbl.EVENT_TYPE_CODE,
163: zx_global_structures_pkg.trx_line_dist_tbl.LINE_LEVEL_ACTION,
164: zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID,
165: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_ID,
166: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LEVEL_TYPE,
159: zx_global_structures_pkg.trx_line_dist_tbl.APPLICATION_ID,
160: zx_global_structures_pkg.trx_line_dist_tbl.ENTITY_CODE,
161: zx_global_structures_pkg.trx_line_dist_tbl.EVENT_CLASS_CODE,
162: zx_global_structures_pkg.trx_line_dist_tbl.EVENT_TYPE_CODE,
163: zx_global_structures_pkg.trx_line_dist_tbl.LINE_LEVEL_ACTION,
164: zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID,
165: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_ID,
166: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LEVEL_TYPE,
167: zx_global_structures_pkg.trx_line_dist_tbl.DEFAULT_TAXATION_COUNTRY,
160: zx_global_structures_pkg.trx_line_dist_tbl.ENTITY_CODE,
161: zx_global_structures_pkg.trx_line_dist_tbl.EVENT_CLASS_CODE,
162: zx_global_structures_pkg.trx_line_dist_tbl.EVENT_TYPE_CODE,
163: zx_global_structures_pkg.trx_line_dist_tbl.LINE_LEVEL_ACTION,
164: zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID,
165: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_ID,
166: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LEVEL_TYPE,
167: zx_global_structures_pkg.trx_line_dist_tbl.DEFAULT_TAXATION_COUNTRY,
168: zx_global_structures_pkg.trx_line_dist_tbl.DOCUMENT_SUB_TYPE,
161: zx_global_structures_pkg.trx_line_dist_tbl.EVENT_CLASS_CODE,
162: zx_global_structures_pkg.trx_line_dist_tbl.EVENT_TYPE_CODE,
163: zx_global_structures_pkg.trx_line_dist_tbl.LINE_LEVEL_ACTION,
164: zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID,
165: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_ID,
166: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LEVEL_TYPE,
167: zx_global_structures_pkg.trx_line_dist_tbl.DEFAULT_TAXATION_COUNTRY,
168: zx_global_structures_pkg.trx_line_dist_tbl.DOCUMENT_SUB_TYPE,
169: zx_global_structures_pkg.trx_line_dist_tbl.TAX_INVOICE_DATE,
162: zx_global_structures_pkg.trx_line_dist_tbl.EVENT_TYPE_CODE,
163: zx_global_structures_pkg.trx_line_dist_tbl.LINE_LEVEL_ACTION,
164: zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID,
165: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_ID,
166: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LEVEL_TYPE,
167: zx_global_structures_pkg.trx_line_dist_tbl.DEFAULT_TAXATION_COUNTRY,
168: zx_global_structures_pkg.trx_line_dist_tbl.DOCUMENT_SUB_TYPE,
169: zx_global_structures_pkg.trx_line_dist_tbl.TAX_INVOICE_DATE,
170: zx_global_structures_pkg.trx_line_dist_tbl.TAX_INVOICE_NUMBER,
163: zx_global_structures_pkg.trx_line_dist_tbl.LINE_LEVEL_ACTION,
164: zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID,
165: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_ID,
166: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LEVEL_TYPE,
167: zx_global_structures_pkg.trx_line_dist_tbl.DEFAULT_TAXATION_COUNTRY,
168: zx_global_structures_pkg.trx_line_dist_tbl.DOCUMENT_SUB_TYPE,
169: zx_global_structures_pkg.trx_line_dist_tbl.TAX_INVOICE_DATE,
170: zx_global_structures_pkg.trx_line_dist_tbl.TAX_INVOICE_NUMBER,
171: zx_global_structures_pkg.trx_line_dist_tbl.LINE_INTENDED_USE ,
164: zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID,
165: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_ID,
166: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LEVEL_TYPE,
167: zx_global_structures_pkg.trx_line_dist_tbl.DEFAULT_TAXATION_COUNTRY,
168: zx_global_structures_pkg.trx_line_dist_tbl.DOCUMENT_SUB_TYPE,
169: zx_global_structures_pkg.trx_line_dist_tbl.TAX_INVOICE_DATE,
170: zx_global_structures_pkg.trx_line_dist_tbl.TAX_INVOICE_NUMBER,
171: zx_global_structures_pkg.trx_line_dist_tbl.LINE_INTENDED_USE ,
172: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_FISC_CLASSIFICATION ,
165: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_ID,
166: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LEVEL_TYPE,
167: zx_global_structures_pkg.trx_line_dist_tbl.DEFAULT_TAXATION_COUNTRY,
168: zx_global_structures_pkg.trx_line_dist_tbl.DOCUMENT_SUB_TYPE,
169: zx_global_structures_pkg.trx_line_dist_tbl.TAX_INVOICE_DATE,
170: zx_global_structures_pkg.trx_line_dist_tbl.TAX_INVOICE_NUMBER,
171: zx_global_structures_pkg.trx_line_dist_tbl.LINE_INTENDED_USE ,
172: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_FISC_CLASSIFICATION ,
173: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_TYPE ,
166: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LEVEL_TYPE,
167: zx_global_structures_pkg.trx_line_dist_tbl.DEFAULT_TAXATION_COUNTRY,
168: zx_global_structures_pkg.trx_line_dist_tbl.DOCUMENT_SUB_TYPE,
169: zx_global_structures_pkg.trx_line_dist_tbl.TAX_INVOICE_DATE,
170: zx_global_structures_pkg.trx_line_dist_tbl.TAX_INVOICE_NUMBER,
171: zx_global_structures_pkg.trx_line_dist_tbl.LINE_INTENDED_USE ,
172: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_FISC_CLASSIFICATION ,
173: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_TYPE ,
174: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_CATEGORY ,
167: zx_global_structures_pkg.trx_line_dist_tbl.DEFAULT_TAXATION_COUNTRY,
168: zx_global_structures_pkg.trx_line_dist_tbl.DOCUMENT_SUB_TYPE,
169: zx_global_structures_pkg.trx_line_dist_tbl.TAX_INVOICE_DATE,
170: zx_global_structures_pkg.trx_line_dist_tbl.TAX_INVOICE_NUMBER,
171: zx_global_structures_pkg.trx_line_dist_tbl.LINE_INTENDED_USE ,
172: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_FISC_CLASSIFICATION ,
173: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_TYPE ,
174: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_CATEGORY ,
175: zx_global_structures_pkg.trx_line_dist_tbl.USER_DEFINED_FISC_CLASS,
168: zx_global_structures_pkg.trx_line_dist_tbl.DOCUMENT_SUB_TYPE,
169: zx_global_structures_pkg.trx_line_dist_tbl.TAX_INVOICE_DATE,
170: zx_global_structures_pkg.trx_line_dist_tbl.TAX_INVOICE_NUMBER,
171: zx_global_structures_pkg.trx_line_dist_tbl.LINE_INTENDED_USE ,
172: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_FISC_CLASSIFICATION ,
173: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_TYPE ,
174: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_CATEGORY ,
175: zx_global_structures_pkg.trx_line_dist_tbl.USER_DEFINED_FISC_CLASS,
176: zx_global_structures_pkg.trx_line_dist_tbl.ASSESSABLE_VALUE,
169: zx_global_structures_pkg.trx_line_dist_tbl.TAX_INVOICE_DATE,
170: zx_global_structures_pkg.trx_line_dist_tbl.TAX_INVOICE_NUMBER,
171: zx_global_structures_pkg.trx_line_dist_tbl.LINE_INTENDED_USE ,
172: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_FISC_CLASSIFICATION ,
173: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_TYPE ,
174: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_CATEGORY ,
175: zx_global_structures_pkg.trx_line_dist_tbl.USER_DEFINED_FISC_CLASS,
176: zx_global_structures_pkg.trx_line_dist_tbl.ASSESSABLE_VALUE,
177: zx_global_structures_pkg.trx_line_dist_tbl.INPUT_TAX_CLASSIFICATION_CODE,
170: zx_global_structures_pkg.trx_line_dist_tbl.TAX_INVOICE_NUMBER,
171: zx_global_structures_pkg.trx_line_dist_tbl.LINE_INTENDED_USE ,
172: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_FISC_CLASSIFICATION ,
173: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_TYPE ,
174: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_CATEGORY ,
175: zx_global_structures_pkg.trx_line_dist_tbl.USER_DEFINED_FISC_CLASS,
176: zx_global_structures_pkg.trx_line_dist_tbl.ASSESSABLE_VALUE,
177: zx_global_structures_pkg.trx_line_dist_tbl.INPUT_TAX_CLASSIFICATION_CODE,
178: zx_global_structures_pkg.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE,
171: zx_global_structures_pkg.trx_line_dist_tbl.LINE_INTENDED_USE ,
172: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_FISC_CLASSIFICATION ,
173: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_TYPE ,
174: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_CATEGORY ,
175: zx_global_structures_pkg.trx_line_dist_tbl.USER_DEFINED_FISC_CLASS,
176: zx_global_structures_pkg.trx_line_dist_tbl.ASSESSABLE_VALUE,
177: zx_global_structures_pkg.trx_line_dist_tbl.INPUT_TAX_CLASSIFICATION_CODE,
178: zx_global_structures_pkg.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE,
179: zx_global_structures_pkg.trx_line_dist_tbl.USER_UPD_DET_FACTORS_FLAG,
172: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_FISC_CLASSIFICATION ,
173: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_TYPE ,
174: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_CATEGORY ,
175: zx_global_structures_pkg.trx_line_dist_tbl.USER_DEFINED_FISC_CLASS,
176: zx_global_structures_pkg.trx_line_dist_tbl.ASSESSABLE_VALUE,
177: zx_global_structures_pkg.trx_line_dist_tbl.INPUT_TAX_CLASSIFICATION_CODE,
178: zx_global_structures_pkg.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE,
179: zx_global_structures_pkg.trx_line_dist_tbl.USER_UPD_DET_FACTORS_FLAG,
180: zx_global_structures_pkg.trx_line_dist_tbl.TAX_EVENT_CLASS_CODE
173: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_TYPE ,
174: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_CATEGORY ,
175: zx_global_structures_pkg.trx_line_dist_tbl.USER_DEFINED_FISC_CLASS,
176: zx_global_structures_pkg.trx_line_dist_tbl.ASSESSABLE_VALUE,
177: zx_global_structures_pkg.trx_line_dist_tbl.INPUT_TAX_CLASSIFICATION_CODE,
178: zx_global_structures_pkg.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE,
179: zx_global_structures_pkg.trx_line_dist_tbl.USER_UPD_DET_FACTORS_FLAG,
180: zx_global_structures_pkg.trx_line_dist_tbl.TAX_EVENT_CLASS_CODE
181: LIMIT G_LINES_PER_FETCH;
174: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_CATEGORY ,
175: zx_global_structures_pkg.trx_line_dist_tbl.USER_DEFINED_FISC_CLASS,
176: zx_global_structures_pkg.trx_line_dist_tbl.ASSESSABLE_VALUE,
177: zx_global_structures_pkg.trx_line_dist_tbl.INPUT_TAX_CLASSIFICATION_CODE,
178: zx_global_structures_pkg.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE,
179: zx_global_structures_pkg.trx_line_dist_tbl.USER_UPD_DET_FACTORS_FLAG,
180: zx_global_structures_pkg.trx_line_dist_tbl.TAX_EVENT_CLASS_CODE
181: LIMIT G_LINES_PER_FETCH;
182:
175: zx_global_structures_pkg.trx_line_dist_tbl.USER_DEFINED_FISC_CLASS,
176: zx_global_structures_pkg.trx_line_dist_tbl.ASSESSABLE_VALUE,
177: zx_global_structures_pkg.trx_line_dist_tbl.INPUT_TAX_CLASSIFICATION_CODE,
178: zx_global_structures_pkg.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE,
179: zx_global_structures_pkg.trx_line_dist_tbl.USER_UPD_DET_FACTORS_FLAG,
180: zx_global_structures_pkg.trx_line_dist_tbl.TAX_EVENT_CLASS_CODE
181: LIMIT G_LINES_PER_FETCH;
182:
183: FOR l_trx_line_index IN 1 .. nvl(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.internal_organization_id.LAST,0)
176: zx_global_structures_pkg.trx_line_dist_tbl.ASSESSABLE_VALUE,
177: zx_global_structures_pkg.trx_line_dist_tbl.INPUT_TAX_CLASSIFICATION_CODE,
178: zx_global_structures_pkg.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE,
179: zx_global_structures_pkg.trx_line_dist_tbl.USER_UPD_DET_FACTORS_FLAG,
180: zx_global_structures_pkg.trx_line_dist_tbl.TAX_EVENT_CLASS_CODE
181: LIMIT G_LINES_PER_FETCH;
182:
183: FOR l_trx_line_index IN 1 .. nvl(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.internal_organization_id.LAST,0)
184: LOOP
179: zx_global_structures_pkg.trx_line_dist_tbl.USER_UPD_DET_FACTORS_FLAG,
180: zx_global_structures_pkg.trx_line_dist_tbl.TAX_EVENT_CLASS_CODE
181: LIMIT G_LINES_PER_FETCH;
182:
183: FOR l_trx_line_index IN 1 .. nvl(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.internal_organization_id.LAST,0)
184: LOOP
185: IF p_taxation_country <> ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DEFAULT_TAXATION_COUNTRY(l_trx_line_index) THEN
186:
187: --Call TRD service to default the determining attributes again
181: LIMIT G_LINES_PER_FETCH;
182:
183: FOR l_trx_line_index IN 1 .. nvl(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.internal_organization_id.LAST,0)
184: LOOP
185: IF p_taxation_country <> ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DEFAULT_TAXATION_COUNTRY(l_trx_line_index) THEN
186:
187: --Call TRD service to default the determining attributes again
188: ZX_DEFAULT_AUTOMATION_PKG.default_tax_attribs (p_trx_line_index => l_trx_line_index,
189: p_event_class_rec => p_event_class_rec,
201: END IF;
202: RETURN;
203: END IF;
204: ELSE
205: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DEFAULT_TAXATION_COUNTRY(l_trx_line_index) := p_taxation_country;
206: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DOCUMENT_SUB_TYPE(l_trx_line_index) := p_document_subtype;
207: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TAX_INVOICE_DATE(l_trx_line_index) := p_tax_invoice_date;
208: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TAX_INVOICE_NUMBER(l_trx_line_index) := p_tax_invoice_number;
209: END IF;--taxation country is different
202: RETURN;
203: END IF;
204: ELSE
205: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DEFAULT_TAXATION_COUNTRY(l_trx_line_index) := p_taxation_country;
206: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DOCUMENT_SUB_TYPE(l_trx_line_index) := p_document_subtype;
207: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TAX_INVOICE_DATE(l_trx_line_index) := p_tax_invoice_date;
208: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TAX_INVOICE_NUMBER(l_trx_line_index) := p_tax_invoice_number;
209: END IF;--taxation country is different
210: END LOOP;
203: END IF;
204: ELSE
205: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DEFAULT_TAXATION_COUNTRY(l_trx_line_index) := p_taxation_country;
206: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DOCUMENT_SUB_TYPE(l_trx_line_index) := p_document_subtype;
207: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TAX_INVOICE_DATE(l_trx_line_index) := p_tax_invoice_date;
208: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TAX_INVOICE_NUMBER(l_trx_line_index) := p_tax_invoice_number;
209: END IF;--taxation country is different
210: END LOOP;
211: EXIT WHEN get_lines_det_factors%NOTFOUND OR get_lines_det_factors%NOTFOUND IS NULL;
204: ELSE
205: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DEFAULT_TAXATION_COUNTRY(l_trx_line_index) := p_taxation_country;
206: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DOCUMENT_SUB_TYPE(l_trx_line_index) := p_document_subtype;
207: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TAX_INVOICE_DATE(l_trx_line_index) := p_tax_invoice_date;
208: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TAX_INVOICE_NUMBER(l_trx_line_index) := p_tax_invoice_number;
209: END IF;--taxation country is different
210: END LOOP;
211: EXIT WHEN get_lines_det_factors%NOTFOUND OR get_lines_det_factors%NOTFOUND IS NULL;
212: END LOOP;
212: END LOOP;
213: CLOSE get_lines_det_factors;
214:
215:
216: FORALL i IN ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id.FIRST .. ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id.LAST
217: UPDATE ZX_LINES_DET_FACTORS SET
218: default_taxation_country = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.default_taxation_country(i),
219: document_sub_type = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.document_sub_type(i),
220: line_intended_use = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_intended_use(i),
214:
215:
216: FORALL i IN ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id.FIRST .. ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id.LAST
217: UPDATE ZX_LINES_DET_FACTORS SET
218: default_taxation_country = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.default_taxation_country(i),
219: document_sub_type = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.document_sub_type(i),
220: line_intended_use = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_intended_use(i),
221: user_defined_fisc_class = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.user_defined_fisc_class(i),
222: product_fisc_classification = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.product_fisc_classification(i),
215:
216: FORALL i IN ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id.FIRST .. ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id.LAST
217: UPDATE ZX_LINES_DET_FACTORS SET
218: default_taxation_country = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.default_taxation_country(i),
219: document_sub_type = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.document_sub_type(i),
220: line_intended_use = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_intended_use(i),
221: user_defined_fisc_class = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.user_defined_fisc_class(i),
222: product_fisc_classification = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.product_fisc_classification(i),
223: product_category = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.product_category(i),
216: FORALL i IN ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id.FIRST .. ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id.LAST
217: UPDATE ZX_LINES_DET_FACTORS SET
218: default_taxation_country = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.default_taxation_country(i),
219: document_sub_type = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.document_sub_type(i),
220: line_intended_use = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_intended_use(i),
221: user_defined_fisc_class = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.user_defined_fisc_class(i),
222: product_fisc_classification = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.product_fisc_classification(i),
223: product_category = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.product_category(i),
224: assessable_value = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.assessable_value(i),
217: UPDATE ZX_LINES_DET_FACTORS SET
218: default_taxation_country = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.default_taxation_country(i),
219: document_sub_type = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.document_sub_type(i),
220: line_intended_use = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_intended_use(i),
221: user_defined_fisc_class = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.user_defined_fisc_class(i),
222: product_fisc_classification = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.product_fisc_classification(i),
223: product_category = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.product_category(i),
224: assessable_value = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.assessable_value(i),
225: input_tax_classification_code = decode(p_display_tax_classif_flag,'Y',ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.input_tax_classification_code(i),
218: default_taxation_country = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.default_taxation_country(i),
219: document_sub_type = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.document_sub_type(i),
220: line_intended_use = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_intended_use(i),
221: user_defined_fisc_class = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.user_defined_fisc_class(i),
222: product_fisc_classification = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.product_fisc_classification(i),
223: product_category = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.product_category(i),
224: assessable_value = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.assessable_value(i),
225: input_tax_classification_code = decode(p_display_tax_classif_flag,'Y',ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.input_tax_classification_code(i),
226: input_tax_classification_code),
219: document_sub_type = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.document_sub_type(i),
220: line_intended_use = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_intended_use(i),
221: user_defined_fisc_class = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.user_defined_fisc_class(i),
222: product_fisc_classification = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.product_fisc_classification(i),
223: product_category = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.product_category(i),
224: assessable_value = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.assessable_value(i),
225: input_tax_classification_code = decode(p_display_tax_classif_flag,'Y',ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.input_tax_classification_code(i),
226: input_tax_classification_code),
227: tax_invoice_date = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_invoice_date(i),
220: line_intended_use = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_intended_use(i),
221: user_defined_fisc_class = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.user_defined_fisc_class(i),
222: product_fisc_classification = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.product_fisc_classification(i),
223: product_category = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.product_category(i),
224: assessable_value = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.assessable_value(i),
225: input_tax_classification_code = decode(p_display_tax_classif_flag,'Y',ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.input_tax_classification_code(i),
226: input_tax_classification_code),
227: tax_invoice_date = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_invoice_date(i),
228: tax_invoice_number = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_invoice_number(i),
221: user_defined_fisc_class = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.user_defined_fisc_class(i),
222: product_fisc_classification = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.product_fisc_classification(i),
223: product_category = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.product_category(i),
224: assessable_value = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.assessable_value(i),
225: input_tax_classification_code = decode(p_display_tax_classif_flag,'Y',ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.input_tax_classification_code(i),
226: input_tax_classification_code),
227: tax_invoice_date = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_invoice_date(i),
228: tax_invoice_number = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_invoice_number(i),
229: user_upd_det_factors_flag ='Y',
223: product_category = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.product_category(i),
224: assessable_value = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.assessable_value(i),
225: input_tax_classification_code = decode(p_display_tax_classif_flag,'Y',ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.input_tax_classification_code(i),
226: input_tax_classification_code),
227: tax_invoice_date = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_invoice_date(i),
228: tax_invoice_number = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_invoice_number(i),
229: user_upd_det_factors_flag ='Y',
230: tax_processing_completed_flag ='N',
231: object_version_number = object_version_number+1,
224: assessable_value = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.assessable_value(i),
225: input_tax_classification_code = decode(p_display_tax_classif_flag,'Y',ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.input_tax_classification_code(i),
226: input_tax_classification_code),
227: tax_invoice_date = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_invoice_date(i),
228: tax_invoice_number = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_invoice_number(i),
229: user_upd_det_factors_flag ='Y',
230: tax_processing_completed_flag ='N',
231: object_version_number = object_version_number+1,
232: line_level_action = decode(line_level_action,'SYNCHRONIZE', 'UPDATE', line_level_action)