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 63: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;

59: IS
60:
61:
62: TYPE ATTRIBUTE1_TBL is TABLE OF
63: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
64:
65: TYPE ATTRIBUTE2_TBL is TABLE OF
66: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER;
67:

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

62: TYPE ATTRIBUTE1_TBL is TABLE OF
63: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
64:
65: TYPE ATTRIBUTE2_TBL is TABLE OF
66: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER;
67:
68: TYPE ATTRIBUTE3_TBL is TABLE OF
69: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;
70:

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

65: TYPE ATTRIBUTE2_TBL is TABLE OF
66: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER;
67:
68: TYPE ATTRIBUTE3_TBL is TABLE OF
69: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;
70:
71: TYPE ATTRIBUTE4_TBL is TABLE OF
72: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;
73:

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

68: TYPE ATTRIBUTE3_TBL is TABLE OF
69: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;
70:
71: TYPE ATTRIBUTE4_TBL is TABLE OF
72: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;
73:
74: TYPE ATTRIBUTE5_TBL is TABLE OF
75: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;
76:

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

71: TYPE ATTRIBUTE4_TBL is TABLE OF
72: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;
73:
74: TYPE ATTRIBUTE5_TBL is TABLE OF
75: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;
76:
77: TYPE ATTRIBUTE6_TBL is TABLE OF
78: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;
79:

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

74: TYPE ATTRIBUTE5_TBL is TABLE OF
75: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;
76:
77: TYPE ATTRIBUTE6_TBL is TABLE OF
78: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;
79:
80: TYPE ATTRIBUTE7_TBL is TABLE OF
81: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;
82:

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

77: TYPE ATTRIBUTE6_TBL is TABLE OF
78: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;
79:
80: TYPE ATTRIBUTE7_TBL is TABLE OF
81: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;
82:
83: TYPE ATTRIBUTE8_TBL is TABLE OF
84: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER;
85:

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

80: TYPE ATTRIBUTE7_TBL is TABLE OF
81: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;
82:
83: TYPE ATTRIBUTE8_TBL is TABLE OF
84: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER;
85:
86: TYPE ATTRIBUTE9_TBL is TABLE OF
87: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER;
88:

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

83: TYPE ATTRIBUTE8_TBL is TABLE OF
84: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER;
85:
86: TYPE ATTRIBUTE9_TBL is TABLE OF
87: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER;
88:
89: TYPE ATTRIBUTE11_TBL is TABLE OF
90: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER;
91:

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

86: TYPE ATTRIBUTE9_TBL is TABLE OF
87: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER;
88:
89: TYPE ATTRIBUTE11_TBL is TABLE OF
90: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER;
91:
92: TYPE ATTRIBUTE12_TBL is TABLE OF
93: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER;
94:

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

89: TYPE ATTRIBUTE11_TBL is TABLE OF
90: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER;
91:
92: TYPE ATTRIBUTE12_TBL is TABLE OF
93: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER;
94:
95: TYPE ATTRIBUTE13_TBL is TABLE OF
96: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER;
97:

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

92: TYPE ATTRIBUTE12_TBL is TABLE OF
93: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER;
94:
95: TYPE ATTRIBUTE13_TBL is TABLE OF
96: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER;
97:
98: TYPE ATTRIBUTE23_TBL is TABLE OF
99: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE23%TYPE INDEX BY BINARY_INTEGER;
100:

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

95: TYPE ATTRIBUTE13_TBL is TABLE OF
96: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER;
97:
98: TYPE ATTRIBUTE23_TBL is TABLE OF
99: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE23%TYPE INDEX BY BINARY_INTEGER;
100:
101: TYPE ATTRIBUTE24_TBL is TABLE OF
102: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE24%TYPE INDEX BY BINARY_INTEGER;
103:

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

98: TYPE ATTRIBUTE23_TBL is TABLE OF
99: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE23%TYPE INDEX BY BINARY_INTEGER;
100:
101: TYPE ATTRIBUTE24_TBL is TABLE OF
102: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE24%TYPE INDEX BY BINARY_INTEGER;
103:
104: TYPE ATTRIBUTE25_TBL is TABLE OF
105: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE25%TYPE INDEX BY BINARY_INTEGER;
106:

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

101: TYPE ATTRIBUTE24_TBL is TABLE OF
102: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE24%TYPE INDEX BY BINARY_INTEGER;
103:
104: TYPE ATTRIBUTE25_TBL is TABLE OF
105: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE25%TYPE INDEX BY BINARY_INTEGER;
106:
107: TYPE ATTRIBUTE26_TBL is TABLE OF
108: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE26%TYPE INDEX BY BINARY_INTEGER;
109:

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

104: TYPE ATTRIBUTE25_TBL is TABLE OF
105: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE25%TYPE INDEX BY BINARY_INTEGER;
106:
107: TYPE ATTRIBUTE26_TBL is TABLE OF
108: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE26%TYPE INDEX BY BINARY_INTEGER;
109:
110: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
111: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
112: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;

Line 200: INSERT INTO ZX_REP_TRX_JX_EXT_T

196:
197:
198: IF l_detail_tax_line_id_tbl.count <> 0 THEN
199:
200: INSERT INTO ZX_REP_TRX_JX_EXT_T
201: (detail_tax_line_ext_id,
202: detail_tax_line_id,
203: attribute9,
204: attribute11,

Line 214: SELECT zx_rep_trx_jx_ext_t_s.nextval,

210: last_updated_by,
211: last_update_date,
212: last_update_login,
213: request_id)
214: SELECT zx_rep_trx_jx_ext_t_s.nextval,
215: itf1.detail_tax_line_id,
216: decode (ra_cust.global_attribute_category,
217: 'JE.ES.ARXTWMAI.MODELO347PR', ra_cust.global_attribute2,
218: 'JE.ES.ARXTWMAI.MODELO415_347PR', ra_cust.global_attribute2,

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

391:
392: IF (g_level_unexpected >= g_current_runtime_level ) THEN
393: FND_LOG.STRING(g_level_unexpected,
394: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
395: 'Before Updating ZX_REP_TRX_JX_EXT_T with attribute columns obtained ' );
396: END IF;
397:
398: IF ( l_count > 0 ) THEN
399:

Line 401: UPDATE ZX_REP_TRX_JX_EXT_T

397:
398: IF ( l_count > 0 ) THEN
399:
400: FORALL i IN 1 .. L_DETAIL_TAX_LINE_ID_TBL.count
401: UPDATE ZX_REP_TRX_JX_EXT_T
402: SET
403: TAX_STATUS_MNG = L_TAX_STATUS_CODE_TBL(i),
404: TRX_BUSINESS_CATEGORY_MNG = L_TRX_BUSINESS_CATEGORY_TBL(i),
405: DOCUMENT_SUB_TYPE_MNG = L_DOCUMENT_SUB_TYPE_TBL(i),

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

417:
418: IF (g_level_unexpected >= g_current_runtime_level ) THEN
419: FND_LOG.STRING(g_level_unexpected,
420: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
421: 'After Updating ZX_REP_TRX_JX_EXT_T with attribute columns obtained ' );
422: END IF;
423: -- exit when get_rep_entity_info_cur%NOTFOUND;
424: ELSE
425: EXIT ;

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

475: )
476:
477: IS
478: TYPE ATTRIBUTE1_TBL is TABLE OF
479: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
480: TYPE ATTRIBUTE2_TBL is TABLE OF
481: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER;
482: TYPE ATTRIBUTE3_TBL is TABLE OF
483: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;

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

477: IS
478: TYPE ATTRIBUTE1_TBL is TABLE OF
479: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
480: TYPE ATTRIBUTE2_TBL is TABLE OF
481: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER;
482: TYPE ATTRIBUTE3_TBL is TABLE OF
483: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;
484: TYPE ATTRIBUTE4_TBL is TABLE OF
485: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;

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

479: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
480: TYPE ATTRIBUTE2_TBL is TABLE OF
481: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER;
482: TYPE ATTRIBUTE3_TBL is TABLE OF
483: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;
484: TYPE ATTRIBUTE4_TBL is TABLE OF
485: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;
486: TYPE ATTRIBUTE5_TBL is TABLE OF
487: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;

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

481: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER;
482: TYPE ATTRIBUTE3_TBL is TABLE OF
483: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;
484: TYPE ATTRIBUTE4_TBL is TABLE OF
485: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;
486: TYPE ATTRIBUTE5_TBL is TABLE OF
487: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;
488: TYPE ATTRIBUTE6_TBL is TABLE OF
489: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;

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

483: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;
484: TYPE ATTRIBUTE4_TBL is TABLE OF
485: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;
486: TYPE ATTRIBUTE5_TBL is TABLE OF
487: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;
488: TYPE ATTRIBUTE6_TBL is TABLE OF
489: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;
490: TYPE ATTRIBUTE7_TBL is TABLE OF
491: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;

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

485: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;
486: TYPE ATTRIBUTE5_TBL is TABLE OF
487: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;
488: TYPE ATTRIBUTE6_TBL is TABLE OF
489: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;
490: TYPE ATTRIBUTE7_TBL is TABLE OF
491: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;
492: TYPE REPORTING_TYPE_ID_TBL is TABLE OF
493: ZX_REPORTING_TYPES_B.REPORTING_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

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

487: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;
488: TYPE ATTRIBUTE6_TBL is TABLE OF
489: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;
490: TYPE ATTRIBUTE7_TBL is TABLE OF
491: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;
492: TYPE REPORTING_TYPE_ID_TBL is TABLE OF
493: ZX_REPORTING_TYPES_B.REPORTING_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
494: TYPE ATTRIBUTE8_TBL is TABLE OF
495: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER;

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

491: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;
492: TYPE REPORTING_TYPE_ID_TBL is TABLE OF
493: ZX_REPORTING_TYPES_B.REPORTING_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
494: TYPE ATTRIBUTE8_TBL is TABLE OF
495: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER;
496: TYPE ATTRIBUTE10_TBL is TABLE OF
497: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER;
498: TYPE ATTRIBUTE11_TBL is TABLE OF
499: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER;

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

493: ZX_REPORTING_TYPES_B.REPORTING_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
494: TYPE ATTRIBUTE8_TBL is TABLE OF
495: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER;
496: TYPE ATTRIBUTE10_TBL is TABLE OF
497: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER;
498: TYPE ATTRIBUTE11_TBL is TABLE OF
499: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER;
500: TYPE ATTRIBUTE12_TBL is TABLE OF
501: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER;

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

495: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER;
496: TYPE ATTRIBUTE10_TBL is TABLE OF
497: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER;
498: TYPE ATTRIBUTE11_TBL is TABLE OF
499: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER;
500: TYPE ATTRIBUTE12_TBL is TABLE OF
501: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER;
502: TYPE ATTRIBUTE13_TBL is TABLE OF
503: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER;

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

497: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER;
498: TYPE ATTRIBUTE11_TBL is TABLE OF
499: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER;
500: TYPE ATTRIBUTE12_TBL is TABLE OF
501: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER;
502: TYPE ATTRIBUTE13_TBL is TABLE OF
503: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER;
504: TYPE ATTRIBUTE14_TBL is TABLE OF
505: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER;

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

499: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER;
500: TYPE ATTRIBUTE12_TBL is TABLE OF
501: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER;
502: TYPE ATTRIBUTE13_TBL is TABLE OF
503: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER;
504: TYPE ATTRIBUTE14_TBL is TABLE OF
505: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER;
506: TYPE ATTRIBUTE15_TBL is TABLE OF
507: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER;

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

501: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER;
502: TYPE ATTRIBUTE13_TBL is TABLE OF
503: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER;
504: TYPE ATTRIBUTE14_TBL is TABLE OF
505: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER;
506: TYPE ATTRIBUTE15_TBL is TABLE OF
507: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER;
508: TYPE ATTRIBUTE16_TBL is TABLE OF
509: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE16%TYPE INDEX BY BINARY_INTEGER;

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

503: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER;
504: TYPE ATTRIBUTE14_TBL is TABLE OF
505: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER;
506: TYPE ATTRIBUTE15_TBL is TABLE OF
507: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER;
508: TYPE ATTRIBUTE16_TBL is TABLE OF
509: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE16%TYPE INDEX BY BINARY_INTEGER;
510: TYPE ATTRIBUTE17_TBL is TABLE OF
511: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE17%TYPE INDEX BY BINARY_INTEGER;

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

505: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER;
506: TYPE ATTRIBUTE15_TBL is TABLE OF
507: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER;
508: TYPE ATTRIBUTE16_TBL is TABLE OF
509: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE16%TYPE INDEX BY BINARY_INTEGER;
510: TYPE ATTRIBUTE17_TBL is TABLE OF
511: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE17%TYPE INDEX BY BINARY_INTEGER;
512: TYPE ATTRIBUTE18_TBL is TABLE OF
513: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE18%TYPE INDEX BY BINARY_INTEGER;

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

507: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER;
508: TYPE ATTRIBUTE16_TBL is TABLE OF
509: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE16%TYPE INDEX BY BINARY_INTEGER;
510: TYPE ATTRIBUTE17_TBL is TABLE OF
511: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE17%TYPE INDEX BY BINARY_INTEGER;
512: TYPE ATTRIBUTE18_TBL is TABLE OF
513: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE18%TYPE INDEX BY BINARY_INTEGER;
514: TYPE ATTRIBUTE19_TBL is TABLE OF
515: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE19%TYPE INDEX BY BINARY_INTEGER;

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

509: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE16%TYPE INDEX BY BINARY_INTEGER;
510: TYPE ATTRIBUTE17_TBL is TABLE OF
511: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE17%TYPE INDEX BY BINARY_INTEGER;
512: TYPE ATTRIBUTE18_TBL is TABLE OF
513: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE18%TYPE INDEX BY BINARY_INTEGER;
514: TYPE ATTRIBUTE19_TBL is TABLE OF
515: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE19%TYPE INDEX BY BINARY_INTEGER;
516: TYPE ATTRIBUTE20_TBL is TABLE OF
517: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE20%TYPE INDEX BY BINARY_INTEGER;

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

511: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE17%TYPE INDEX BY BINARY_INTEGER;
512: TYPE ATTRIBUTE18_TBL is TABLE OF
513: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE18%TYPE INDEX BY BINARY_INTEGER;
514: TYPE ATTRIBUTE19_TBL is TABLE OF
515: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE19%TYPE INDEX BY BINARY_INTEGER;
516: TYPE ATTRIBUTE20_TBL is TABLE OF
517: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE20%TYPE INDEX BY BINARY_INTEGER;
518: TYPE DETAIL_TAX_LINE_ID_TBL is TABLE OF
519: ZX_REP_TRX_JX_EXT_T.DETAIL_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

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

513: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE18%TYPE INDEX BY BINARY_INTEGER;
514: TYPE ATTRIBUTE19_TBL is TABLE OF
515: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE19%TYPE INDEX BY BINARY_INTEGER;
516: TYPE ATTRIBUTE20_TBL is TABLE OF
517: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE20%TYPE INDEX BY BINARY_INTEGER;
518: TYPE DETAIL_TAX_LINE_ID_TBL is TABLE OF
519: ZX_REP_TRX_JX_EXT_T.DETAIL_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
520: TYPE ATTRIBUTE21_TBL is TABLE OF
521: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE21%TYPE INDEX BY BINARY_INTEGER;

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

515: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE19%TYPE INDEX BY BINARY_INTEGER;
516: TYPE ATTRIBUTE20_TBL is TABLE OF
517: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE20%TYPE INDEX BY BINARY_INTEGER;
518: TYPE DETAIL_TAX_LINE_ID_TBL is TABLE OF
519: ZX_REP_TRX_JX_EXT_T.DETAIL_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
520: TYPE ATTRIBUTE21_TBL is TABLE OF
521: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE21%TYPE INDEX BY BINARY_INTEGER;
522: TYPE ATTRIBUTE22_TBL is TABLE OF
523: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE22%TYPE INDEX BY BINARY_INTEGER;

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

517: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE20%TYPE INDEX BY BINARY_INTEGER;
518: TYPE DETAIL_TAX_LINE_ID_TBL is TABLE OF
519: ZX_REP_TRX_JX_EXT_T.DETAIL_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
520: TYPE ATTRIBUTE21_TBL is TABLE OF
521: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE21%TYPE INDEX BY BINARY_INTEGER;
522: TYPE ATTRIBUTE22_TBL is TABLE OF
523: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE22%TYPE INDEX BY BINARY_INTEGER;
524: TYPE ATTRIBUTE23_TBL is TABLE OF
525: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE23%TYPE INDEX BY BINARY_INTEGER;

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

519: ZX_REP_TRX_JX_EXT_T.DETAIL_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
520: TYPE ATTRIBUTE21_TBL is TABLE OF
521: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE21%TYPE INDEX BY BINARY_INTEGER;
522: TYPE ATTRIBUTE22_TBL is TABLE OF
523: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE22%TYPE INDEX BY BINARY_INTEGER;
524: TYPE ATTRIBUTE23_TBL is TABLE OF
525: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE23%TYPE INDEX BY BINARY_INTEGER;
526:
527: TYPE ATTRIBUTE24_TBL is TABLE OF

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

521: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE21%TYPE INDEX BY BINARY_INTEGER;
522: TYPE ATTRIBUTE22_TBL is TABLE OF
523: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE22%TYPE INDEX BY BINARY_INTEGER;
524: TYPE ATTRIBUTE23_TBL is TABLE OF
525: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE23%TYPE INDEX BY BINARY_INTEGER;
526:
527: TYPE ATTRIBUTE24_TBL is TABLE OF
528: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE24%TYPE INDEX BY BINARY_INTEGER;
529:

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

524: TYPE ATTRIBUTE23_TBL is TABLE OF
525: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE23%TYPE INDEX BY BINARY_INTEGER;
526:
527: TYPE ATTRIBUTE24_TBL is TABLE OF
528: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE24%TYPE INDEX BY BINARY_INTEGER;
529:
530: TYPE ATTRIBUTE25_TBL is TABLE OF
531: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE25%TYPE INDEX BY BINARY_INTEGER;
532:

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

527: TYPE ATTRIBUTE24_TBL is TABLE OF
528: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE24%TYPE INDEX BY BINARY_INTEGER;
529:
530: TYPE ATTRIBUTE25_TBL is TABLE OF
531: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE25%TYPE INDEX BY BINARY_INTEGER;
532:
533: TYPE ATTRIBUTE26_TBL is TABLE OF
534: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE26%TYPE INDEX BY BINARY_INTEGER;
535:

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

530: TYPE ATTRIBUTE25_TBL is TABLE OF
531: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE25%TYPE INDEX BY BINARY_INTEGER;
532:
533: TYPE ATTRIBUTE26_TBL is TABLE OF
534: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE26%TYPE INDEX BY BINARY_INTEGER;
535:
536: l_detail_tax_line_id_tbl DETAIL_TAX_LINE_ID_TBL;
537: l_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
538: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;

Line 664: INSERT INTO ZX_REP_TRX_JX_EXT_T

660: FND_LOG.STRING(g_level_unexpected,
661: 'ZX.TRL.je_tax_extract.populate_je_ap',
662: 'POPULATE_JE_AP - Rows extracted : '||to_char(l_tax_line_id_tbl.count));
663: END IF;
664: INSERT INTO ZX_REP_TRX_JX_EXT_T
665: (detail_tax_line_ext_id,
666: detail_tax_line_id,
667: tax_status_mng,
668: trx_business_category_mng,

Line 685: SELECT zx_rep_trx_jx_ext_t_s.nextval,

681: last_updated_by,
682: last_update_date,
683: last_update_login,
684: request_id)
685: SELECT zx_rep_trx_jx_ext_t_s.nextval,
686: itf1.detail_tax_line_id,
687: itf1.tax_status_code,
688: itf1.trx_business_category,
689: itf1.document_sub_type,

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

731: and itf1.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID;
732:
733: IF ( g_level_unexpected>= g_current_runtime_level ) THEN
734: FND_LOG.STRING(g_level_unexpected, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JE_AP',
735: 'No. of rows inserted into ZX_REP_TRX_JX_EXT_T : '||to_char(SQL%ROWCOUNT) );
736: END IF;
737:
738: open get_rep_entity_info_cur ;
739:

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

882:
883: IF (g_level_unexpected >= g_current_runtime_level ) THEN
884: FND_LOG.STRING(g_level_unexpected,
885: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',
886: 'Before Updating ZX_REP_TRX_JX_EXT_T with attribute columns obtained ' );
887: END IF;
888:
889: IF ( l_count > 0 ) THEN
890:

Line 893: 'Before Updating ZX_REP_TRX_JX_EXT_T' );

889: IF ( l_count > 0 ) THEN
890:
891: IF ( g_level_statement>= g_current_runtime_level ) THEN
892: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JE_AP',
893: 'Before Updating ZX_REP_TRX_JX_EXT_T' );
894: END IF;
895: FORALL i IN 1 .. L_DETAIL_TAX_LINE_ID_TBL.count
896: UPDATE ZX_REP_TRX_JX_EXT_T
897: SET ATTRIBUTE10 = L_ATTRIBUTE10_TBL(i),

Line 896: UPDATE ZX_REP_TRX_JX_EXT_T

892: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JE_AP',
893: 'Before Updating ZX_REP_TRX_JX_EXT_T' );
894: END IF;
895: FORALL i IN 1 .. L_DETAIL_TAX_LINE_ID_TBL.count
896: UPDATE ZX_REP_TRX_JX_EXT_T
897: SET ATTRIBUTE10 = L_ATTRIBUTE10_TBL(i),
898: ATTRIBUTE1 = L_ATTRIBUTE1_TBL(i),
899: ATTRIBUTE2 = L_ATTRIBUTE2_TBL(i),
900: ATTRIBUTE3 = L_ATTRIBUTE3_TBL(i),

Line 920: 'After Updating ZX_REP_TRX_JX_EXT_T' );

916: --exit when get_rep_entity_info_cur%NOTFOUND;
917:
918: IF ( g_level_unexpected>= g_current_runtime_level ) THEN
919: FND_LOG.STRING(g_level_unexpected, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JE_AP',
920: 'After Updating ZX_REP_TRX_JX_EXT_T' );
921: END IF;
922: ELSE
923: EXIT ;
924: END IF ;

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

973: IS
974:
975: --Bug 5636632
976: TYPE ATTRIBUTE1_TBL is TABLE OF
977: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
978:
979: TYPE ATTRIBUTE2_TBL is TABLE OF
980: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER;
981:

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

976: TYPE ATTRIBUTE1_TBL is TABLE OF
977: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
978:
979: TYPE ATTRIBUTE2_TBL is TABLE OF
980: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER;
981:
982: TYPE ATTRIBUTE3_TBL is TABLE OF
983: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;
984:

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

979: TYPE ATTRIBUTE2_TBL is TABLE OF
980: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER;
981:
982: TYPE ATTRIBUTE3_TBL is TABLE OF
983: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;
984:
985: TYPE ATTRIBUTE4_TBL is TABLE OF
986: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;
987:

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

982: TYPE ATTRIBUTE3_TBL is TABLE OF
983: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;
984:
985: TYPE ATTRIBUTE4_TBL is TABLE OF
986: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;
987:
988: TYPE ATTRIBUTE5_TBL is TABLE OF
989: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;
990:

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

985: TYPE ATTRIBUTE4_TBL is TABLE OF
986: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;
987:
988: TYPE ATTRIBUTE5_TBL is TABLE OF
989: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;
990:
991: TYPE ATTRIBUTE6_TBL is TABLE OF
992: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;
993:

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

988: TYPE ATTRIBUTE5_TBL is TABLE OF
989: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;
990:
991: TYPE ATTRIBUTE6_TBL is TABLE OF
992: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;
993:
994: TYPE ATTRIBUTE7_TBL is TABLE OF
995: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;
996:

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

991: TYPE ATTRIBUTE6_TBL is TABLE OF
992: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;
993:
994: TYPE ATTRIBUTE7_TBL is TABLE OF
995: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;
996:
997: TYPE ATTRIBUTE25_TBL is TABLE OF
998: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE25%TYPE INDEX BY BINARY_INTEGER;
999:

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

994: TYPE ATTRIBUTE7_TBL is TABLE OF
995: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;
996:
997: TYPE ATTRIBUTE25_TBL is TABLE OF
998: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE25%TYPE INDEX BY BINARY_INTEGER;
999:
1000: TYPE ATTRIBUTE26_TBL is TABLE OF
1001: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE26%TYPE INDEX BY BINARY_INTEGER;
1002:

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

997: TYPE ATTRIBUTE25_TBL is TABLE OF
998: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE25%TYPE INDEX BY BINARY_INTEGER;
999:
1000: TYPE ATTRIBUTE26_TBL is TABLE OF
1001: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE26%TYPE INDEX BY BINARY_INTEGER;
1002:
1003: l_attribute1_tbl ATTRIBUTE1_TBL;
1004: l_attribute2_tbl ATTRIBUTE2_TBL;
1005: l_attribute3_tbl ATTRIBUTE3_TBL;

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

1073: 'je_tax_extract.populate_je_gl(+)');
1074:
1075: FND_LOG.STRING(g_level_unexpected,
1076: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1077: 'Before insertion into ZX_REP_TRX_JX_EXT_T - 1');
1078: END IF;
1079:
1080: SELECT detail_tax_line_id
1081: BULK COLLECT INTO l_detail_tax_line_id_tbl

Line 1093: INSERT INTO ZX_REP_TRX_JX_EXT_T

1089: END IF;
1090:
1091: IF l_detail_tax_line_id_tbl.count <> 0 THEN
1092:
1093: INSERT INTO ZX_REP_TRX_JX_EXT_T
1094: (detail_tax_line_ext_id,
1095: detail_tax_line_id,
1096: created_by,
1097: creation_date,

Line 1103: SELECT zx_rep_trx_jx_ext_t_s.nextval,

1099: last_update_date,
1100: last_update_login,
1101: attribute24,
1102: request_id)
1103: SELECT zx_rep_trx_jx_ext_t_s.nextval,
1104: itf1.detail_tax_line_id,
1105: fnd_global.user_id,
1106: sysdate,
1107: fnd_global.user_id,

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

1118:
1119: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1120: FND_LOG.STRING(g_level_unexpected,
1121: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1122: 'No. of rows inserted into ZX_REP_TRX_JX_EXT_T - 1'||to_char(sql%ROWCOUNT));
1123: END IF;
1124:
1125: open get_rep_entity_info_cur ;
1126:

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

1277:
1278: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1279: FND_LOG.STRING(g_level_unexpected,
1280: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1281: 'Before Updating ZX_REP_TRX_JX_EXT_T with attribute columns obtained -GL ' );
1282: END IF;
1283:
1284: FORALL i IN 1 .. l_count
1285: UPDATE ZX_REP_TRX_JX_EXT_T

Line 1285: UPDATE ZX_REP_TRX_JX_EXT_T

1281: 'Before Updating ZX_REP_TRX_JX_EXT_T with attribute columns obtained -GL ' );
1282: END IF;
1283:
1284: FORALL i IN 1 .. l_count
1285: UPDATE ZX_REP_TRX_JX_EXT_T
1286: SET
1287: TAX_STATUS_MNG = L_TAX_STATUS_CODE_TBL(i),
1288: TRX_BUSINESS_CATEGORY_MNG = L_TRX_BUSINESS_CATEGORY_TBL(i),
1289: DOCUMENT_SUB_TYPE_MNG = L_DOCUMENT_SUB_TYPE_TBL(i),

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

1301:
1302: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1303: FND_LOG.STRING(g_level_unexpected,
1304: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1305: 'After Updating ZX_REP_TRX_JX_EXT_T with attribute columns obtained ' );
1306: END IF;
1307: -- exit when get_rep_entity_info_cur%NOTFOUND;
1308: ELSE
1309: EXIT ;