[Home] [Help]
53:
54: IF (g_level_statement >= g_current_runtime_level ) THEN
55: FND_LOG.STRING(g_level_statement,
56: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap',
57: 'Inserting data into zx_lines_det_factors and zx_lines_summary');
58: END IF;
59:
60:
61: -- Insert data into zx_lines_det_factors and zx_lines_summary
57: 'Inserting data into zx_lines_det_factors and zx_lines_summary');
58: END IF;
59:
60:
61: -- Insert data into zx_lines_det_factors and zx_lines_summary
62: --
63: INSERT ALL
64: WHEN AP_LINE_LOOKUP_CODE IN ('ITEM', 'PREPAY','FREIGHT','MISCELLANEOUS') OR
65: TAX_ONLY_LINE_FLAG = 'Y'
63: INSERT ALL
64: WHEN AP_LINE_LOOKUP_CODE IN ('ITEM', 'PREPAY','FREIGHT','MISCELLANEOUS') OR
65: TAX_ONLY_LINE_FLAG = 'Y'
66: THEN
67: INTO ZX_LINES_DET_FACTORS (
68: EVENT_ID
69: ,OBJECT_VERSION_NUMBER
70: ,INTERNAL_ORGANIZATION_ID
71: ,APPLICATION_ID
416: ,BILL_THIRD_PTY_ACCT_ID
417: ,BILL_THIRD_PTY_ACCT_SITE_ID
418: )
419: WHEN AP_LINE_LOOKUP_CODE = 'TAX' THEN
420: INTO ZX_LINES_SUMMARY (
421: SUMMARY_TAX_LINE_ID
422: ,INTERNAL_ORGANIZATION_ID
423: ,APPLICATION_ID
424: ,ENTITY_CODE
999: AND NVL(lines.historical_flag, 'N') = 'Y'
1000: AND poll.line_location_id(+) = lines.po_line_location_id
1001: AND ptp.party_type_code = 'OU'
1002: AND ptp.party_id = DECODE(l_multi_org_flag,'N',l_org_id,lines.org_id)
1003: AND NOT EXISTS (SELECT 1 FROM zx_lines_det_factors zxdet --Bug 6738188
1004: WHERE zxdet.application_id = 200
1005: AND zxdet.entity_code = 'AP_INVOICES'
1006: AND zxdet.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
1007: 'STANDARD', 'STANDARD INVOICES',
1022:
1023: IF (g_level_statement >= g_current_runtime_level ) THEN
1024: FND_LOG.STRING(g_level_statement,
1025: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap',
1026: 'Inserting data into zx_lines and zx_rec_nrec_dist');
1027: END IF;
1028:
1029: -- Insert data into zx_lines and zx_rec_nrec_dist
1030: --
1025: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap',
1026: 'Inserting data into zx_lines and zx_rec_nrec_dist');
1027: END IF;
1028:
1029: -- Insert data into zx_lines and zx_rec_nrec_dist
1030: --
1031: INSERT ALL
1032: INTO ZX_REC_NREC_DIST(
1033: TAX_LINE_ID
1197: ,ACCOUNT_SOURCE_TAX_RATE_ID
1198: ,RECOVERY_RATE_ID
1199: )
1200: VALUES(
1201: ZX_LINES_S.NEXTVAL
1202: ,REC_NREC_TAX_DIST_ID
1203: ,REC_NREC_TAX_DIST_NUMBER
1204: ,APPLICATION_ID
1205: ,CONTENT_OWNER_ID
1364: --,TAX_JURISDICTION_ID
1365: ,ACCOUNT_SOURCE_TAX_RATE_ID
1366: ,RECOVERY_RATE_ID
1367: )
1368: INTO ZX_LINES(
1369: TAX_LINE_ID
1370: ,TAX_LINE_NUMBER
1371: ,APPLICATION_ID
1372: ,CONTENT_OWNER_ID
1563: ,LEGAL_REPORTING_STATUS
1564: ,ACCOUNT_SOURCE_TAX_RATE_ID
1565: )
1566: VALUES (
1567: ZX_LINES_S.NEXTVAL
1568: ,TAX_LINE_NUMBER
1569: ,APPLICATION_ID
1570: ,CONTENT_OWNER_ID
1571: ,CURRENCY_CONVERSION_DATE
2110: -- OR taxes.effective_to IS NULL)
2111: AND ptp.party_type_code = 'OU'
2112: AND ptp.party_id = DECODE(l_multi_org_flag,'N', l_org_id, ap_dists.org_id)
2113: AND NOT EXISTS -- Bug 6738188
2114: (SELECT 1 FROM zx_lines zxl
2115: WHERE zxl.application_id = 200
2116: AND zxl.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2117: 'STANDARD', 'STANDARD INVOICES',
2118: 'CREDIT' , 'STANDARD INVOICES',
2195:
2196: IF (g_level_statement >= g_current_runtime_level ) THEN
2197: FND_LOG.STRING(g_level_statement,
2198: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap',
2199: 'Inserting data into zx_lines_det_factors and zx_lines_summary');
2200: END IF;
2201:
2202: -- Insert data into zx_lines_det_factors and zx_lines_summary
2203: --
2198: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap',
2199: 'Inserting data into zx_lines_det_factors and zx_lines_summary');
2200: END IF;
2201:
2202: -- Insert data into zx_lines_det_factors and zx_lines_summary
2203: --
2204: INSERT ALL
2205: WHEN AP_LINE_LOOKUP_CODE IN ('ITEM', 'PREPAY','FREIGHT','MISCELLANEOUS') OR
2206: TAX_ONLY_LINE_FLAG = 'Y'
2204: INSERT ALL
2205: WHEN AP_LINE_LOOKUP_CODE IN ('ITEM', 'PREPAY','FREIGHT','MISCELLANEOUS') OR
2206: TAX_ONLY_LINE_FLAG = 'Y'
2207: THEN
2208: INTO ZX_LINES_DET_FACTORS (
2209: EVENT_ID
2210: ,OBJECT_VERSION_NUMBER
2211: ,INTERNAL_ORGANIZATION_ID
2212: ,APPLICATION_ID
2557: ,BILL_THIRD_PTY_ACCT_ID
2558: ,BILL_THIRD_PTY_ACCT_SITE_ID
2559: )
2560: WHEN AP_LINE_LOOKUP_CODE = 'TAX' THEN
2561: INTO ZX_LINES_SUMMARY (
2562: SUMMARY_TAX_LINE_ID
2563: ,INTERNAL_ORGANIZATION_ID
2564: ,APPLICATION_ID
2565: ,ENTITY_CODE
3147:
3148: IF (g_level_statement >= g_current_runtime_level ) THEN
3149: FND_LOG.STRING(g_level_statement,
3150: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap',
3151: 'Inserting data into zx_lines and zx_rec_nrec_dist');
3152: END IF;
3153:
3154: -- Insert data into zx_lines and zx_rec_nrec_dist
3155: --
3150: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap',
3151: 'Inserting data into zx_lines and zx_rec_nrec_dist');
3152: END IF;
3153:
3154: -- Insert data into zx_lines and zx_rec_nrec_dist
3155: --
3156: INSERT ALL
3157: INTO ZX_REC_NREC_DIST(
3158: TAX_LINE_ID
3322: ,ACCOUNT_SOURCE_TAX_RATE_ID
3323: ,RECOVERY_RATE_ID
3324: )
3325: VALUES(
3326: ZX_LINES_S.NEXTVAL
3327: ,REC_NREC_TAX_DIST_ID
3328: ,REC_NREC_TAX_DIST_NUMBER
3329: ,APPLICATION_ID
3330: ,CONTENT_OWNER_ID
3489: --,TAX_JURISDICTION_ID
3490: ,ACCOUNT_SOURCE_TAX_RATE_ID
3491: ,RECOVERY_RATE_ID
3492: )
3493: INTO ZX_LINES(
3494: TAX_LINE_ID
3495: ,TAX_LINE_NUMBER
3496: ,APPLICATION_ID
3497: ,CONTENT_OWNER_ID
3688: ,LEGAL_REPORTING_STATUS
3689: ,ACCOUNT_SOURCE_TAX_RATE_ID
3690: )
3691: VALUES (
3692: ZX_LINES_S.NEXTVAL
3693: ,TAX_LINE_NUMBER
3694: ,APPLICATION_ID
3695: ,CONTENT_OWNER_ID
3696: ,CURRENCY_CONVERSION_DATE