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_JE_EXTRACT_PKG dependencies on ZX_REP_TRX_JX_EXT_T

Line 168: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;

164: IS
165:
166:
167: TYPE ATTRIBUTE1_TBL is TABLE OF
168: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
169:
170: TYPE ATTRIBUTE2_TBL is TABLE OF
171: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER;
172:

Line 171: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER;

167: TYPE ATTRIBUTE1_TBL is TABLE OF
168: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
169:
170: TYPE ATTRIBUTE2_TBL is TABLE OF
171: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER;
172:
173: TYPE ATTRIBUTE3_TBL is TABLE OF
174: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;
175:

Line 174: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;

170: TYPE ATTRIBUTE2_TBL is TABLE OF
171: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER;
172:
173: TYPE ATTRIBUTE3_TBL is TABLE OF
174: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;
175:
176: TYPE ATTRIBUTE4_TBL is TABLE OF
177: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;
178:

Line 177: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;

173: TYPE ATTRIBUTE3_TBL is TABLE OF
174: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;
175:
176: TYPE ATTRIBUTE4_TBL is TABLE OF
177: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;
178:
179: TYPE ATTRIBUTE5_TBL is TABLE OF
180: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;
181:

Line 180: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;

176: TYPE ATTRIBUTE4_TBL is TABLE OF
177: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;
178:
179: TYPE ATTRIBUTE5_TBL is TABLE OF
180: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;
181:
182: TYPE ATTRIBUTE6_TBL is TABLE OF
183: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;
184:

Line 183: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;

179: TYPE ATTRIBUTE5_TBL is TABLE OF
180: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;
181:
182: TYPE ATTRIBUTE6_TBL is TABLE OF
183: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;
184:
185: TYPE ATTRIBUTE7_TBL is TABLE OF
186: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;
187:

Line 186: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;

182: TYPE ATTRIBUTE6_TBL is TABLE OF
183: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;
184:
185: TYPE ATTRIBUTE7_TBL is TABLE OF
186: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;
187:
188: TYPE ATTRIBUTE8_TBL is TABLE OF
189: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER;
190:

Line 189: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER;

185: TYPE ATTRIBUTE7_TBL is TABLE OF
186: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;
187:
188: TYPE ATTRIBUTE8_TBL is TABLE OF
189: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER;
190:
191: TYPE ATTRIBUTE9_TBL is TABLE OF
192: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER;
193:

Line 192: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER;

188: TYPE ATTRIBUTE8_TBL is TABLE OF
189: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER;
190:
191: TYPE ATTRIBUTE9_TBL is TABLE OF
192: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER;
193:
194: TYPE ATTRIBUTE11_TBL is TABLE OF
195: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER;
196:

Line 195: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER;

191: TYPE ATTRIBUTE9_TBL is TABLE OF
192: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER;
193:
194: TYPE ATTRIBUTE11_TBL is TABLE OF
195: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER;
196:
197: TYPE ATTRIBUTE12_TBL is TABLE OF
198: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER;
199:

Line 198: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER;

194: TYPE ATTRIBUTE11_TBL is TABLE OF
195: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER;
196:
197: TYPE ATTRIBUTE12_TBL is TABLE OF
198: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER;
199:
200: TYPE ATTRIBUTE13_TBL is TABLE OF
201: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER;
202:

Line 201: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER;

197: TYPE ATTRIBUTE12_TBL is TABLE OF
198: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER;
199:
200: TYPE ATTRIBUTE13_TBL is TABLE OF
201: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER;
202:
203: TYPE ATTRIBUTE23_TBL is TABLE OF
204: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE23%TYPE INDEX BY BINARY_INTEGER;
205:

Line 204: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE23%TYPE INDEX BY BINARY_INTEGER;

200: TYPE ATTRIBUTE13_TBL is TABLE OF
201: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER;
202:
203: TYPE ATTRIBUTE23_TBL is TABLE OF
204: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE23%TYPE INDEX BY BINARY_INTEGER;
205:
206: TYPE ATTRIBUTE24_TBL is TABLE OF
207: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE24%TYPE INDEX BY BINARY_INTEGER;
208:

Line 207: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE24%TYPE INDEX BY BINARY_INTEGER;

203: TYPE ATTRIBUTE23_TBL is TABLE OF
204: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE23%TYPE INDEX BY BINARY_INTEGER;
205:
206: TYPE ATTRIBUTE24_TBL is TABLE OF
207: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE24%TYPE INDEX BY BINARY_INTEGER;
208:
209: TYPE ATTRIBUTE25_TBL is TABLE OF
210: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE25%TYPE INDEX BY BINARY_INTEGER;
211:

Line 210: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE25%TYPE INDEX BY BINARY_INTEGER;

206: TYPE ATTRIBUTE24_TBL is TABLE OF
207: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE24%TYPE INDEX BY BINARY_INTEGER;
208:
209: TYPE ATTRIBUTE25_TBL is TABLE OF
210: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE25%TYPE INDEX BY BINARY_INTEGER;
211:
212: TYPE ATTRIBUTE26_TBL is TABLE OF
213: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE26%TYPE INDEX BY BINARY_INTEGER;
214:

Line 213: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE26%TYPE INDEX BY BINARY_INTEGER;

209: TYPE ATTRIBUTE25_TBL is TABLE OF
210: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE25%TYPE INDEX BY BINARY_INTEGER;
211:
212: TYPE ATTRIBUTE26_TBL is TABLE OF
213: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE26%TYPE INDEX BY BINARY_INTEGER;
214:
215: TYPE ATTRIBUTE27_TBL is TABLE OF
216: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE27%TYPE INDEX BY BINARY_INTEGER;
217:

Line 216: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE27%TYPE INDEX BY BINARY_INTEGER;

212: TYPE ATTRIBUTE26_TBL is TABLE OF
213: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE26%TYPE INDEX BY BINARY_INTEGER;
214:
215: TYPE ATTRIBUTE27_TBL is TABLE OF
216: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE27%TYPE INDEX BY BINARY_INTEGER;
217:
218: TYPE ATTRIBUTE28_TBL is TABLE OF
219: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE28%TYPE INDEX BY BINARY_INTEGER;
220:

Line 219: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE28%TYPE INDEX BY BINARY_INTEGER;

215: TYPE ATTRIBUTE27_TBL is TABLE OF
216: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE27%TYPE INDEX BY BINARY_INTEGER;
217:
218: TYPE ATTRIBUTE28_TBL is TABLE OF
219: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE28%TYPE INDEX BY BINARY_INTEGER;
220:
221: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
222: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
223: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;

Line 409: INSERT INTO ZX_REP_TRX_JX_EXT_T

405:
406:
407: IF l_detail_tax_line_id_tbl.count <> 0 THEN
408:
409: INSERT INTO ZX_REP_TRX_JX_EXT_T
410: (detail_tax_line_ext_id,
411: detail_tax_line_id,
412: attribute9,
413: attribute11,

Line 423: SELECT zx_rep_trx_jx_ext_t_s.nextval,

419: last_updated_by,
420: last_update_date,
421: last_update_login,
422: request_id)
423: SELECT zx_rep_trx_jx_ext_t_s.nextval,
424: itf1.detail_tax_line_id,
425: CASE WHEN (itf1.entity_code = 'TRANSACTIONS' AND itf1.event_class_code IN ('INVOICE','DEBIT_MEMO','CREDIT_MEMO')) THEN
426: (SELECT decode (ra_cust.global_attribute_category,
427: 'JE.ES.ARXTWMAI.MODELO347PR', ra_cust.global_attribute2,

Line 643: 'Before Updating ZX_REP_TRX_JX_EXT_T with attribute columns obtained ' );

639:
640: IF (g_level_statement >= g_current_runtime_level ) THEN
641: FND_LOG.STRING(g_level_statement,
642: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
643: 'Before Updating ZX_REP_TRX_JX_EXT_T with attribute columns obtained ' );
644: END IF;
645:
646: IF ( l_count > 0 ) THEN
647:

Line 649: UPDATE ZX_REP_TRX_JX_EXT_T

645:
646: IF ( l_count > 0 ) THEN
647:
648: FORALL i IN 1 .. L_DETAIL_TAX_LINE_ID_TBL.count
649: UPDATE ZX_REP_TRX_JX_EXT_T
650: SET
651: TAX_STATUS_MNG = L_TAX_STATUS_CODE_TBL(i),
652: TRX_BUSINESS_CATEGORY_MNG = L_TRX_BUSINESS_CATEGORY_TBL(i),
653: DOCUMENT_SUB_TYPE_MNG = L_DOCUMENT_SUB_TYPE_TBL(i),

Line 671: 'After Updating ZX_REP_TRX_JX_EXT_T with attribute columns obtained ' );

667:
668: IF (g_level_statement >= g_current_runtime_level ) THEN
669: FND_LOG.STRING(g_level_statement,
670: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
671: 'After Updating ZX_REP_TRX_JX_EXT_T with attribute columns obtained ' );
672: END IF;
673: -- exit when get_rep_entity_info_cur%NOTFOUND;
674: ELSE
675: EXIT ;

Line 729: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;

725: )
726:
727: IS
728: TYPE ATTRIBUTE1_TBL is TABLE OF
729: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
730: TYPE ATTRIBUTE2_TBL is TABLE OF
731: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER;
732: TYPE ATTRIBUTE3_TBL is TABLE OF
733: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;

Line 731: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER;

727: IS
728: TYPE ATTRIBUTE1_TBL is TABLE OF
729: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
730: TYPE ATTRIBUTE2_TBL is TABLE OF
731: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER;
732: TYPE ATTRIBUTE3_TBL is TABLE OF
733: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;
734: TYPE ATTRIBUTE4_TBL is TABLE OF
735: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;

Line 733: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;

729: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
730: TYPE ATTRIBUTE2_TBL is TABLE OF
731: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER;
732: TYPE ATTRIBUTE3_TBL is TABLE OF
733: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;
734: TYPE ATTRIBUTE4_TBL is TABLE OF
735: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;
736: TYPE ATTRIBUTE5_TBL is TABLE OF
737: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;

Line 735: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;

731: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER;
732: TYPE ATTRIBUTE3_TBL is TABLE OF
733: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;
734: TYPE ATTRIBUTE4_TBL is TABLE OF
735: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;
736: TYPE ATTRIBUTE5_TBL is TABLE OF
737: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;
738: TYPE ATTRIBUTE6_TBL is TABLE OF
739: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;

Line 737: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;

733: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;
734: TYPE ATTRIBUTE4_TBL is TABLE OF
735: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;
736: TYPE ATTRIBUTE5_TBL is TABLE OF
737: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;
738: TYPE ATTRIBUTE6_TBL is TABLE OF
739: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;
740: TYPE ATTRIBUTE7_TBL is TABLE OF
741: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;

Line 739: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;

735: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;
736: TYPE ATTRIBUTE5_TBL is TABLE OF
737: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;
738: TYPE ATTRIBUTE6_TBL is TABLE OF
739: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;
740: TYPE ATTRIBUTE7_TBL is TABLE OF
741: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;
742: TYPE REPORTING_TYPE_ID_TBL is TABLE OF
743: ZX_REPORTING_TYPES_B.REPORTING_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 741: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;

737: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;
738: TYPE ATTRIBUTE6_TBL is TABLE OF
739: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;
740: TYPE ATTRIBUTE7_TBL is TABLE OF
741: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;
742: TYPE REPORTING_TYPE_ID_TBL is TABLE OF
743: ZX_REPORTING_TYPES_B.REPORTING_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
744: TYPE ATTRIBUTE8_TBL is TABLE OF
745: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER;

Line 745: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER;

741: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;
742: TYPE REPORTING_TYPE_ID_TBL is TABLE OF
743: ZX_REPORTING_TYPES_B.REPORTING_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
744: TYPE ATTRIBUTE8_TBL is TABLE OF
745: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER;
746: TYPE ATTRIBUTE10_TBL is TABLE OF
747: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER;
748: TYPE ATTRIBUTE11_TBL is TABLE OF
749: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER;

Line 747: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER;

743: ZX_REPORTING_TYPES_B.REPORTING_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
744: TYPE ATTRIBUTE8_TBL is TABLE OF
745: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER;
746: TYPE ATTRIBUTE10_TBL is TABLE OF
747: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER;
748: TYPE ATTRIBUTE11_TBL is TABLE OF
749: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER;
750: TYPE ATTRIBUTE12_TBL is TABLE OF
751: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER;

Line 749: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER;

745: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER;
746: TYPE ATTRIBUTE10_TBL is TABLE OF
747: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER;
748: TYPE ATTRIBUTE11_TBL is TABLE OF
749: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER;
750: TYPE ATTRIBUTE12_TBL is TABLE OF
751: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER;
752: TYPE ATTRIBUTE13_TBL is TABLE OF
753: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER;

Line 751: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER;

747: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER;
748: TYPE ATTRIBUTE11_TBL is TABLE OF
749: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER;
750: TYPE ATTRIBUTE12_TBL is TABLE OF
751: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER;
752: TYPE ATTRIBUTE13_TBL is TABLE OF
753: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER;
754: TYPE ATTRIBUTE14_TBL is TABLE OF
755: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER;

Line 753: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER;

749: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER;
750: TYPE ATTRIBUTE12_TBL is TABLE OF
751: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER;
752: TYPE ATTRIBUTE13_TBL is TABLE OF
753: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER;
754: TYPE ATTRIBUTE14_TBL is TABLE OF
755: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER;
756: TYPE ATTRIBUTE15_TBL is TABLE OF
757: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER;

Line 755: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER;

751: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER;
752: TYPE ATTRIBUTE13_TBL is TABLE OF
753: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER;
754: TYPE ATTRIBUTE14_TBL is TABLE OF
755: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER;
756: TYPE ATTRIBUTE15_TBL is TABLE OF
757: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER;
758: TYPE ATTRIBUTE16_TBL is TABLE OF
759: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE16%TYPE INDEX BY BINARY_INTEGER;

Line 757: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER;

753: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER;
754: TYPE ATTRIBUTE14_TBL is TABLE OF
755: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER;
756: TYPE ATTRIBUTE15_TBL is TABLE OF
757: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER;
758: TYPE ATTRIBUTE16_TBL is TABLE OF
759: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE16%TYPE INDEX BY BINARY_INTEGER;
760: TYPE ATTRIBUTE17_TBL is TABLE OF
761: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE17%TYPE INDEX BY BINARY_INTEGER;

Line 759: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE16%TYPE INDEX BY BINARY_INTEGER;

755: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER;
756: TYPE ATTRIBUTE15_TBL is TABLE OF
757: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER;
758: TYPE ATTRIBUTE16_TBL is TABLE OF
759: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE16%TYPE INDEX BY BINARY_INTEGER;
760: TYPE ATTRIBUTE17_TBL is TABLE OF
761: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE17%TYPE INDEX BY BINARY_INTEGER;
762: TYPE ATTRIBUTE18_TBL is TABLE OF
763: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE18%TYPE INDEX BY BINARY_INTEGER;

Line 761: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE17%TYPE INDEX BY BINARY_INTEGER;

757: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER;
758: TYPE ATTRIBUTE16_TBL is TABLE OF
759: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE16%TYPE INDEX BY BINARY_INTEGER;
760: TYPE ATTRIBUTE17_TBL is TABLE OF
761: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE17%TYPE INDEX BY BINARY_INTEGER;
762: TYPE ATTRIBUTE18_TBL is TABLE OF
763: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE18%TYPE INDEX BY BINARY_INTEGER;
764: TYPE ATTRIBUTE19_TBL is TABLE OF
765: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE19%TYPE INDEX BY BINARY_INTEGER;

Line 763: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE18%TYPE INDEX BY BINARY_INTEGER;

759: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE16%TYPE INDEX BY BINARY_INTEGER;
760: TYPE ATTRIBUTE17_TBL is TABLE OF
761: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE17%TYPE INDEX BY BINARY_INTEGER;
762: TYPE ATTRIBUTE18_TBL is TABLE OF
763: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE18%TYPE INDEX BY BINARY_INTEGER;
764: TYPE ATTRIBUTE19_TBL is TABLE OF
765: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE19%TYPE INDEX BY BINARY_INTEGER;
766: TYPE ATTRIBUTE20_TBL is TABLE OF
767: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE20%TYPE INDEX BY BINARY_INTEGER;

Line 765: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE19%TYPE INDEX BY BINARY_INTEGER;

761: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE17%TYPE INDEX BY BINARY_INTEGER;
762: TYPE ATTRIBUTE18_TBL is TABLE OF
763: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE18%TYPE INDEX BY BINARY_INTEGER;
764: TYPE ATTRIBUTE19_TBL is TABLE OF
765: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE19%TYPE INDEX BY BINARY_INTEGER;
766: TYPE ATTRIBUTE20_TBL is TABLE OF
767: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE20%TYPE INDEX BY BINARY_INTEGER;
768: TYPE DETAIL_TAX_LINE_ID_TBL is TABLE OF
769: ZX_REP_TRX_JX_EXT_T.DETAIL_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 767: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE20%TYPE INDEX BY BINARY_INTEGER;

763: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE18%TYPE INDEX BY BINARY_INTEGER;
764: TYPE ATTRIBUTE19_TBL is TABLE OF
765: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE19%TYPE INDEX BY BINARY_INTEGER;
766: TYPE ATTRIBUTE20_TBL is TABLE OF
767: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE20%TYPE INDEX BY BINARY_INTEGER;
768: TYPE DETAIL_TAX_LINE_ID_TBL is TABLE OF
769: ZX_REP_TRX_JX_EXT_T.DETAIL_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
770: TYPE ATTRIBUTE21_TBL is TABLE OF
771: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE21%TYPE INDEX BY BINARY_INTEGER;

Line 769: ZX_REP_TRX_JX_EXT_T.DETAIL_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

765: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE19%TYPE INDEX BY BINARY_INTEGER;
766: TYPE ATTRIBUTE20_TBL is TABLE OF
767: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE20%TYPE INDEX BY BINARY_INTEGER;
768: TYPE DETAIL_TAX_LINE_ID_TBL is TABLE OF
769: ZX_REP_TRX_JX_EXT_T.DETAIL_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
770: TYPE ATTRIBUTE21_TBL is TABLE OF
771: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE21%TYPE INDEX BY BINARY_INTEGER;
772: TYPE ATTRIBUTE22_TBL is TABLE OF
773: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE22%TYPE INDEX BY BINARY_INTEGER;

Line 771: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE21%TYPE INDEX BY BINARY_INTEGER;

767: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE20%TYPE INDEX BY BINARY_INTEGER;
768: TYPE DETAIL_TAX_LINE_ID_TBL is TABLE OF
769: ZX_REP_TRX_JX_EXT_T.DETAIL_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
770: TYPE ATTRIBUTE21_TBL is TABLE OF
771: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE21%TYPE INDEX BY BINARY_INTEGER;
772: TYPE ATTRIBUTE22_TBL is TABLE OF
773: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE22%TYPE INDEX BY BINARY_INTEGER;
774: TYPE ATTRIBUTE23_TBL is TABLE OF
775: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE23%TYPE INDEX BY BINARY_INTEGER;

Line 773: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE22%TYPE INDEX BY BINARY_INTEGER;

769: ZX_REP_TRX_JX_EXT_T.DETAIL_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
770: TYPE ATTRIBUTE21_TBL is TABLE OF
771: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE21%TYPE INDEX BY BINARY_INTEGER;
772: TYPE ATTRIBUTE22_TBL is TABLE OF
773: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE22%TYPE INDEX BY BINARY_INTEGER;
774: TYPE ATTRIBUTE23_TBL is TABLE OF
775: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE23%TYPE INDEX BY BINARY_INTEGER;
776: TYPE ATTRIBUTE24_TBL is TABLE OF
777: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE24%TYPE INDEX BY BINARY_INTEGER;

Line 775: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE23%TYPE INDEX BY BINARY_INTEGER;

771: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE21%TYPE INDEX BY BINARY_INTEGER;
772: TYPE ATTRIBUTE22_TBL is TABLE OF
773: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE22%TYPE INDEX BY BINARY_INTEGER;
774: TYPE ATTRIBUTE23_TBL is TABLE OF
775: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE23%TYPE INDEX BY BINARY_INTEGER;
776: TYPE ATTRIBUTE24_TBL is TABLE OF
777: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE24%TYPE INDEX BY BINARY_INTEGER;
778: TYPE ATTRIBUTE25_TBL is TABLE OF
779: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE25%TYPE INDEX BY BINARY_INTEGER;

Line 777: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE24%TYPE INDEX BY BINARY_INTEGER;

773: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE22%TYPE INDEX BY BINARY_INTEGER;
774: TYPE ATTRIBUTE23_TBL is TABLE OF
775: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE23%TYPE INDEX BY BINARY_INTEGER;
776: TYPE ATTRIBUTE24_TBL is TABLE OF
777: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE24%TYPE INDEX BY BINARY_INTEGER;
778: TYPE ATTRIBUTE25_TBL is TABLE OF
779: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE25%TYPE INDEX BY BINARY_INTEGER;
780: TYPE ATTRIBUTE26_TBL is TABLE OF
781: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE26%TYPE INDEX BY BINARY_INTEGER;

Line 779: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE25%TYPE INDEX BY BINARY_INTEGER;

775: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE23%TYPE INDEX BY BINARY_INTEGER;
776: TYPE ATTRIBUTE24_TBL is TABLE OF
777: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE24%TYPE INDEX BY BINARY_INTEGER;
778: TYPE ATTRIBUTE25_TBL is TABLE OF
779: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE25%TYPE INDEX BY BINARY_INTEGER;
780: TYPE ATTRIBUTE26_TBL is TABLE OF
781: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE26%TYPE INDEX BY BINARY_INTEGER;
782: TYPE ATTRIBUTE27_TBL is TABLE OF
783: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE27%TYPE INDEX BY BINARY_INTEGER;

Line 781: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE26%TYPE INDEX BY BINARY_INTEGER;

777: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE24%TYPE INDEX BY BINARY_INTEGER;
778: TYPE ATTRIBUTE25_TBL is TABLE OF
779: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE25%TYPE INDEX BY BINARY_INTEGER;
780: TYPE ATTRIBUTE26_TBL is TABLE OF
781: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE26%TYPE INDEX BY BINARY_INTEGER;
782: TYPE ATTRIBUTE27_TBL is TABLE OF
783: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE27%TYPE INDEX BY BINARY_INTEGER;
784: TYPE ATTRIBUTE28_TBL is TABLE OF
785: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE28%TYPE INDEX BY BINARY_INTEGER;

Line 783: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE27%TYPE INDEX BY BINARY_INTEGER;

779: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE25%TYPE INDEX BY BINARY_INTEGER;
780: TYPE ATTRIBUTE26_TBL is TABLE OF
781: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE26%TYPE INDEX BY BINARY_INTEGER;
782: TYPE ATTRIBUTE27_TBL is TABLE OF
783: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE27%TYPE INDEX BY BINARY_INTEGER;
784: TYPE ATTRIBUTE28_TBL is TABLE OF
785: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE28%TYPE INDEX BY BINARY_INTEGER;
786:
787: l_detail_tax_line_id_tbl DETAIL_TAX_LINE_ID_TBL;

Line 785: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE28%TYPE INDEX BY BINARY_INTEGER;

781: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE26%TYPE INDEX BY BINARY_INTEGER;
782: TYPE ATTRIBUTE27_TBL is TABLE OF
783: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE27%TYPE INDEX BY BINARY_INTEGER;
784: TYPE ATTRIBUTE28_TBL is TABLE OF
785: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE28%TYPE INDEX BY BINARY_INTEGER;
786:
787: l_detail_tax_line_id_tbl DETAIL_TAX_LINE_ID_TBL;
788: l_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
789: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;

Line 950: INSERT INTO ZX_REP_TRX_JX_EXT_T

946: FND_LOG.STRING(g_level_statement,
947: 'ZX.TRL.je_tax_extract.populate_je_ap',
948: 'POPULATE_JE_AP - Rows extracted : '||to_char(l_tax_line_id_tbl.count));
949: END IF;
950: INSERT INTO ZX_REP_TRX_JX_EXT_T
951: (detail_tax_line_ext_id,
952: detail_tax_line_id,
953: tax_status_mng,
954: trx_business_category_mng,

Line 969: SELECT zx_rep_trx_jx_ext_t_s.nextval,

965: last_updated_by,
966: last_update_date,
967: last_update_login,
968: request_id)
969: SELECT zx_rep_trx_jx_ext_t_s.nextval,
970: itf1.detail_tax_line_id,
971: itf1.tax_status_code,
972: itf1.trx_business_category,
973: itf1.document_sub_type,

Line 1013: 'No. of rows inserted into ZX_REP_TRX_JX_EXT_T : '||to_char(SQL%ROWCOUNT) );

1009: and itf1.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID;
1010:
1011: IF ( g_level_statement>= g_current_runtime_level ) THEN
1012: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JE_AP',
1013: 'No. of rows inserted into ZX_REP_TRX_JX_EXT_T : '||to_char(SQL%ROWCOUNT) );
1014: END IF;
1015:
1016: open get_rep_entity_info_cur ;
1017:

Line 1176: 'Before Updating ZX_REP_TRX_JX_EXT_T with attribute columns obtained ' );

1172:
1173: IF (g_level_statement >= g_current_runtime_level ) THEN
1174: FND_LOG.STRING(g_level_statement,
1175: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',
1176: 'Before Updating ZX_REP_TRX_JX_EXT_T with attribute columns obtained ' );
1177: END IF;
1178:
1179: IF ( l_count > 0 ) THEN
1180:

Line 1183: 'Before Updating ZX_REP_TRX_JX_EXT_T' );

1179: IF ( l_count > 0 ) THEN
1180:
1181: IF ( g_level_statement>= g_current_runtime_level ) THEN
1182: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JE_AP',
1183: 'Before Updating ZX_REP_TRX_JX_EXT_T' );
1184: END IF;
1185: FORALL i IN 1 .. L_DETAIL_TAX_LINE_ID_TBL.count
1186: UPDATE ZX_REP_TRX_JX_EXT_T
1187: SET ATTRIBUTE10 = L_ATTRIBUTE10_TBL(i),

Line 1186: UPDATE ZX_REP_TRX_JX_EXT_T

1182: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JE_AP',
1183: 'Before Updating ZX_REP_TRX_JX_EXT_T' );
1184: END IF;
1185: FORALL i IN 1 .. L_DETAIL_TAX_LINE_ID_TBL.count
1186: UPDATE ZX_REP_TRX_JX_EXT_T
1187: SET ATTRIBUTE10 = L_ATTRIBUTE10_TBL(i),
1188: ATTRIBUTE1 = L_ATTRIBUTE1_TBL(i),
1189: ATTRIBUTE2 = L_ATTRIBUTE2_TBL(i),
1190: ATTRIBUTE3 = L_ATTRIBUTE3_TBL(i),

Line 1211: 'After Updating ZX_REP_TRX_JX_EXT_T' );

1207:
1208:
1209: IF ( g_level_statement>= g_current_runtime_level ) THEN
1210: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JE_AP',
1211: 'After Updating ZX_REP_TRX_JX_EXT_T' );
1212: END IF;
1213: ELSE
1214: EXIT ;
1215: END IF ;

Line 1268: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;

1264: IS
1265:
1266: --Bug 5636632
1267: TYPE ATTRIBUTE1_TBL is TABLE OF
1268: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
1269:
1270: TYPE ATTRIBUTE2_TBL is TABLE OF
1271: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER;
1272:

Line 1271: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER;

1267: TYPE ATTRIBUTE1_TBL is TABLE OF
1268: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
1269:
1270: TYPE ATTRIBUTE2_TBL is TABLE OF
1271: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER;
1272:
1273: TYPE ATTRIBUTE3_TBL is TABLE OF
1274: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;
1275:

Line 1274: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;

1270: TYPE ATTRIBUTE2_TBL is TABLE OF
1271: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER;
1272:
1273: TYPE ATTRIBUTE3_TBL is TABLE OF
1274: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;
1275:
1276: TYPE ATTRIBUTE4_TBL is TABLE OF
1277: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;
1278:

Line 1277: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;

1273: TYPE ATTRIBUTE3_TBL is TABLE OF
1274: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;
1275:
1276: TYPE ATTRIBUTE4_TBL is TABLE OF
1277: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;
1278:
1279: TYPE ATTRIBUTE5_TBL is TABLE OF
1280: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;
1281:

Line 1280: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;

1276: TYPE ATTRIBUTE4_TBL is TABLE OF
1277: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;
1278:
1279: TYPE ATTRIBUTE5_TBL is TABLE OF
1280: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;
1281:
1282: TYPE ATTRIBUTE6_TBL is TABLE OF
1283: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;
1284:

Line 1283: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;

1279: TYPE ATTRIBUTE5_TBL is TABLE OF
1280: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;
1281:
1282: TYPE ATTRIBUTE6_TBL is TABLE OF
1283: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;
1284:
1285: TYPE ATTRIBUTE7_TBL is TABLE OF
1286: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;
1287:

Line 1286: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;

1282: TYPE ATTRIBUTE6_TBL is TABLE OF
1283: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;
1284:
1285: TYPE ATTRIBUTE7_TBL is TABLE OF
1286: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;
1287:
1288: TYPE ATTRIBUTE25_TBL is TABLE OF
1289: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE25%TYPE INDEX BY BINARY_INTEGER;
1290:

Line 1289: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE25%TYPE INDEX BY BINARY_INTEGER;

1285: TYPE ATTRIBUTE7_TBL is TABLE OF
1286: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;
1287:
1288: TYPE ATTRIBUTE25_TBL is TABLE OF
1289: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE25%TYPE INDEX BY BINARY_INTEGER;
1290:
1291: TYPE ATTRIBUTE26_TBL is TABLE OF
1292: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE26%TYPE INDEX BY BINARY_INTEGER;
1293:

Line 1292: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE26%TYPE INDEX BY BINARY_INTEGER;

1288: TYPE ATTRIBUTE25_TBL is TABLE OF
1289: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE25%TYPE INDEX BY BINARY_INTEGER;
1290:
1291: TYPE ATTRIBUTE26_TBL is TABLE OF
1292: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE26%TYPE INDEX BY BINARY_INTEGER;
1293:
1294: l_attribute1_tbl ATTRIBUTE1_TBL;
1295: l_attribute2_tbl ATTRIBUTE2_TBL;
1296: l_attribute3_tbl ATTRIBUTE3_TBL;

Line 1400: 'Before insertion into ZX_REP_TRX_JX_EXT_T - 1');

1396: 'je_tax_extract.populate_je_gl(+)');
1397:
1398: FND_LOG.STRING(g_level_statement,
1399: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1400: 'Before insertion into ZX_REP_TRX_JX_EXT_T - 1');
1401: END IF;
1402:
1403: SELECT detail_tax_line_id
1404: BULK COLLECT INTO l_detail_tax_line_id_tbl

Line 1416: INSERT INTO ZX_REP_TRX_JX_EXT_T

1412: END IF;
1413:
1414: IF l_detail_tax_line_id_tbl.count <> 0 THEN
1415:
1416: INSERT INTO ZX_REP_TRX_JX_EXT_T
1417: (detail_tax_line_ext_id,
1418: detail_tax_line_id,
1419: created_by,
1420: creation_date,

Line 1426: SELECT zx_rep_trx_jx_ext_t_s.nextval,

1422: last_update_date,
1423: last_update_login,
1424: attribute24,
1425: request_id)
1426: SELECT zx_rep_trx_jx_ext_t_s.nextval,
1427: itf1.detail_tax_line_id,
1428: fnd_global.user_id,
1429: sysdate,
1430: fnd_global.user_id,

Line 1447: 'No. of rows inserted into ZX_REP_TRX_JX_EXT_T - 1'||to_char(sql%ROWCOUNT));

1443:
1444: IF (g_level_statement >= g_current_runtime_level ) THEN
1445: FND_LOG.STRING(g_level_statement,
1446: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1447: 'No. of rows inserted into ZX_REP_TRX_JX_EXT_T - 1'||to_char(sql%ROWCOUNT));
1448: END IF;
1449:
1450: open get_rep_entity_info_cur ;
1451:

Line 1606: 'Before Updating ZX_REP_TRX_JX_EXT_T with attribute columns obtained -GL ' );

1602:
1603: IF (g_level_statement >= g_current_runtime_level ) THEN
1604: FND_LOG.STRING(g_level_statement,
1605: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1606: 'Before Updating ZX_REP_TRX_JX_EXT_T with attribute columns obtained -GL ' );
1607: END IF;
1608:
1609: FORALL i IN 1 .. l_count
1610: UPDATE ZX_REP_TRX_JX_EXT_T

Line 1610: UPDATE ZX_REP_TRX_JX_EXT_T

1606: 'Before Updating ZX_REP_TRX_JX_EXT_T with attribute columns obtained -GL ' );
1607: END IF;
1608:
1609: FORALL i IN 1 .. l_count
1610: UPDATE ZX_REP_TRX_JX_EXT_T
1611: SET
1612: TAX_STATUS_MNG = L_TAX_STATUS_CODE_TBL(i),
1613: TRX_BUSINESS_CATEGORY_MNG = L_TRX_BUSINESS_CATEGORY_TBL(i),
1614: DOCUMENT_SUB_TYPE_MNG = L_DOCUMENT_SUB_TYPE_TBL(i),

Line 1630: 'After Updating ZX_REP_TRX_JX_EXT_T with attribute columns obtained ' );

1626:
1627: IF (g_level_statement >= g_current_runtime_level ) THEN
1628: FND_LOG.STRING(g_level_statement,
1629: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1630: 'After Updating ZX_REP_TRX_JX_EXT_T with attribute columns obtained ' );
1631: END IF;
1632: -- exit when get_rep_entity_info_cur%NOTFOUND;
1633: ELSE
1634: EXIT ;