eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_LINES_DET_FACTORS_PKG dependencies on ZX_GLOBAL_STRUCTURES_PKG

Line 159: zx_global_structures_pkg.trx_line_dist_tbl.APPLICATION_ID,

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,

Line 160: zx_global_structures_pkg.trx_line_dist_tbl.ENTITY_CODE,

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,

Line 161: zx_global_structures_pkg.trx_line_dist_tbl.EVENT_CLASS_CODE,

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,

Line 162: zx_global_structures_pkg.trx_line_dist_tbl.EVENT_TYPE_CODE,

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,

Line 163: zx_global_structures_pkg.trx_line_dist_tbl.LINE_LEVEL_ACTION,

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,

Line 164: zx_global_structures_pkg.trx_line_dist_tbl.TRX_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,
168: zx_global_structures_pkg.trx_line_dist_tbl.DOCUMENT_SUB_TYPE,

Line 165: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_ID,

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,

Line 166: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LEVEL_TYPE,

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,

Line 167: zx_global_structures_pkg.trx_line_dist_tbl.DEFAULT_TAXATION_COUNTRY,

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 ,

Line 168: zx_global_structures_pkg.trx_line_dist_tbl.DOCUMENT_SUB_TYPE,

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 ,

Line 169: zx_global_structures_pkg.trx_line_dist_tbl.TAX_INVOICE_DATE,

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 ,

Line 170: zx_global_structures_pkg.trx_line_dist_tbl.TAX_INVOICE_NUMBER,

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 ,

Line 171: zx_global_structures_pkg.trx_line_dist_tbl.LINE_INTENDED_USE ,

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,

Line 172: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_FISC_CLASSIFICATION ,

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,

Line 173: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_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,
177: zx_global_structures_pkg.trx_line_dist_tbl.INPUT_TAX_CLASSIFICATION_CODE,

Line 174: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_CATEGORY ,

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,

Line 175: zx_global_structures_pkg.trx_line_dist_tbl.USER_DEFINED_FISC_CLASS,

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,

Line 176: zx_global_structures_pkg.trx_line_dist_tbl.ASSESSABLE_VALUE,

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

Line 177: zx_global_structures_pkg.trx_line_dist_tbl.INPUT_TAX_CLASSIFICATION_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;

Line 178: zx_global_structures_pkg.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE,

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:

Line 179: zx_global_structures_pkg.trx_line_dist_tbl.USER_UPD_DET_FACTORS_FLAG,

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)

Line 180: zx_global_structures_pkg.trx_line_dist_tbl.TAX_EVENT_CLASS_CODE

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

Line 183: FOR l_trx_line_index IN 1 .. nvl(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.internal_organization_id.LAST,0)

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

Line 185: IF p_taxation_country <> ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DEFAULT_TAXATION_COUNTRY(l_trx_line_index) THEN

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,

Line 205: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DEFAULT_TAXATION_COUNTRY(l_trx_line_index) := p_taxation_country;

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

Line 206: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DOCUMENT_SUB_TYPE(l_trx_line_index) := p_document_subtype;

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;

Line 207: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TAX_INVOICE_DATE(l_trx_line_index) := p_tax_invoice_date;

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;

Line 208: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TAX_INVOICE_NUMBER(l_trx_line_index) := p_tax_invoice_number;

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;

Line 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

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

Line 218: default_taxation_country = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.default_taxation_country(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),

Line 219: document_sub_type = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.document_sub_type(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),

Line 220: line_intended_use = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_intended_use(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),

Line 221: user_defined_fisc_class = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.user_defined_fisc_class(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),

Line 222: product_fisc_classification = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.product_fisc_classification(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),

Line 223: product_category = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.product_category(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),
227: tax_invoice_date = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_invoice_date(i),

Line 224: assessable_value = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.assessable_value(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),

Line 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),

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',

Line 227: tax_invoice_date = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_invoice_date(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',
230: tax_processing_completed_flag ='N',
231: object_version_number = object_version_number+1,

Line 228: tax_invoice_number = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_invoice_number(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,
232: line_level_action = decode(line_level_action,'SYNCHRONIZE', 'UPDATE', line_level_action)