[Home] [Help]
77:
78: IF (g_level_statement >= g_current_runtime_level ) THEN
79: FND_LOG.STRING(g_level_statement,
80: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap',
81: 'Inserting data into zx_lines_det_factors and zx_lines_summary');
82: END IF;
83:
84:
85: -- Insert data into zx_lines_det_factors and zx_lines_summary
81: 'Inserting data into zx_lines_det_factors and zx_lines_summary');
82: END IF;
83:
84:
85: -- Insert data into zx_lines_det_factors and zx_lines_summary
86: --
87: INSERT ALL
88: WHEN AP_LINE_LOOKUP_CODE IN ('ITEM', 'PREPAY','FREIGHT','MISCELLANEOUS') OR
89: TAX_ONLY_LINE_FLAG = 'Y'
87: INSERT ALL
88: WHEN AP_LINE_LOOKUP_CODE IN ('ITEM', 'PREPAY','FREIGHT','MISCELLANEOUS') OR
89: TAX_ONLY_LINE_FLAG = 'Y'
90: THEN
91: INTO ZX_LINES_DET_FACTORS (
92: EVENT_ID
93: ,OBJECT_VERSION_NUMBER
94: ,INTERNAL_ORGANIZATION_ID
95: ,APPLICATION_ID
440: ,BILL_THIRD_PTY_ACCT_ID
441: ,BILL_THIRD_PTY_ACCT_SITE_ID
442: )
443: WHEN AP_LINE_LOOKUP_CODE = 'TAX' THEN
444: INTO ZX_LINES_SUMMARY (
445: SUMMARY_TAX_LINE_ID
446: ,INTERNAL_ORGANIZATION_ID
447: ,APPLICATION_ID
448: ,ENTITY_CODE
1025: AND NVL(lines.historical_flag, 'N') = 'Y'
1026: AND poll.line_location_id(+) = lines.po_line_location_id
1027: AND ptp.party_type_code = 'OU'
1028: AND ptp.party_id = DECODE(l_multi_org_flag,'N',l_org_id,lines.org_id)
1029: AND NOT EXISTS (SELECT 1 FROM zx_lines_det_factors zxdet --Bug 6738188
1030: WHERE zxdet.application_id = 200
1031: AND zxdet.entity_code = 'AP_INVOICES'
1032: AND zxdet.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
1033: 'STANDARD', 'STANDARD INVOICES',
1048:
1049: IF (g_level_statement >= g_current_runtime_level ) THEN
1050: FND_LOG.STRING(g_level_statement,
1051: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap',
1052: 'Inserting data into zx_lines and zx_rec_nrec_dist');
1053: END IF;
1054:
1055: -- Insert data into zx_lines and zx_rec_nrec_dist
1056: --
1051: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap',
1052: 'Inserting data into zx_lines and zx_rec_nrec_dist');
1053: END IF;
1054:
1055: -- Insert data into zx_lines and zx_rec_nrec_dist
1056: --
1057: INSERT ALL
1058: INTO ZX_REC_NREC_DIST(
1059: TAX_LINE_ID
1223: ,ACCOUNT_SOURCE_TAX_RATE_ID
1224: ,RECOVERY_RATE_ID
1225: )
1226: VALUES(
1227: ZX_LINES_S.NEXTVAL
1228: ,REC_NREC_TAX_DIST_ID
1229: ,REC_NREC_TAX_DIST_NUMBER
1230: ,APPLICATION_ID
1231: ,CONTENT_OWNER_ID
1390: --,TAX_JURISDICTION_ID
1391: ,ACCOUNT_SOURCE_TAX_RATE_ID
1392: ,RECOVERY_RATE_ID
1393: )
1394: INTO ZX_LINES(
1395: TAX_LINE_ID
1396: ,TAX_LINE_NUMBER
1397: ,APPLICATION_ID
1398: ,CONTENT_OWNER_ID
1590: ,LEGAL_REPORTING_STATUS
1591: ,ACCOUNT_SOURCE_TAX_RATE_ID
1592: )
1593: VALUES (
1594: ZX_LINES_S.NEXTVAL
1595: ,TAX_LINE_NUMBER
1596: ,APPLICATION_ID
1597: ,CONTENT_OWNER_ID
1598: ,CURRENCY_CONVERSION_DATE
2159: -- OR taxes.effective_to IS NULL)
2160: AND ptp.party_type_code = 'OU'
2161: AND ptp.party_id = DECODE(l_multi_org_flag,'N', l_org_id, ap_dists.org_id)
2162: AND NOT EXISTS -- Bug 6738188
2163: (SELECT 1 FROM zx_lines zxl
2164: WHERE zxl.application_id = 200
2165: AND zxl.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2166: 'STANDARD', 'STANDARD INVOICES',
2167: 'CREDIT' , 'STANDARD INVOICES',
2244:
2245: IF (g_level_statement >= g_current_runtime_level ) THEN
2246: FND_LOG.STRING(g_level_statement,
2247: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap',
2248: 'Inserting data into zx_lines_det_factors and zx_lines_summary');
2249: END IF;
2250:
2251: -- Insert data into zx_lines_det_factors and zx_lines_summary
2252: --
2247: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap',
2248: 'Inserting data into zx_lines_det_factors and zx_lines_summary');
2249: END IF;
2250:
2251: -- Insert data into zx_lines_det_factors and zx_lines_summary
2252: --
2253: INSERT ALL
2254: WHEN AP_LINE_LOOKUP_CODE IN ('ITEM', 'PREPAY','FREIGHT','MISCELLANEOUS') OR
2255: TAX_ONLY_LINE_FLAG = 'Y'
2253: INSERT ALL
2254: WHEN AP_LINE_LOOKUP_CODE IN ('ITEM', 'PREPAY','FREIGHT','MISCELLANEOUS') OR
2255: TAX_ONLY_LINE_FLAG = 'Y'
2256: THEN
2257: INTO ZX_LINES_DET_FACTORS (
2258: EVENT_ID
2259: ,OBJECT_VERSION_NUMBER
2260: ,INTERNAL_ORGANIZATION_ID
2261: ,APPLICATION_ID
2606: ,BILL_THIRD_PTY_ACCT_ID
2607: ,BILL_THIRD_PTY_ACCT_SITE_ID
2608: )
2609: WHEN AP_LINE_LOOKUP_CODE = 'TAX' THEN
2610: INTO ZX_LINES_SUMMARY (
2611: SUMMARY_TAX_LINE_ID
2612: ,INTERNAL_ORGANIZATION_ID
2613: ,APPLICATION_ID
2614: ,ENTITY_CODE
3198:
3199: IF (g_level_statement >= g_current_runtime_level ) THEN
3200: FND_LOG.STRING(g_level_statement,
3201: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap',
3202: 'Inserting data into zx_lines and zx_rec_nrec_dist');
3203: END IF;
3204:
3205: -- Insert data into zx_lines and zx_rec_nrec_dist
3206: --
3201: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap',
3202: 'Inserting data into zx_lines and zx_rec_nrec_dist');
3203: END IF;
3204:
3205: -- Insert data into zx_lines and zx_rec_nrec_dist
3206: --
3207: INSERT ALL
3208: INTO ZX_REC_NREC_DIST(
3209: TAX_LINE_ID
3373: ,ACCOUNT_SOURCE_TAX_RATE_ID
3374: ,RECOVERY_RATE_ID
3375: )
3376: VALUES(
3377: ZX_LINES_S.NEXTVAL
3378: ,REC_NREC_TAX_DIST_ID
3379: ,REC_NREC_TAX_DIST_NUMBER
3380: ,APPLICATION_ID
3381: ,CONTENT_OWNER_ID
3540: --,TAX_JURISDICTION_ID
3541: ,ACCOUNT_SOURCE_TAX_RATE_ID
3542: ,RECOVERY_RATE_ID
3543: )
3544: INTO ZX_LINES(
3545: TAX_LINE_ID
3546: ,TAX_LINE_NUMBER
3547: ,APPLICATION_ID
3548: ,CONTENT_OWNER_ID
3739: ,LEGAL_REPORTING_STATUS
3740: ,ACCOUNT_SOURCE_TAX_RATE_ID
3741: )
3742: VALUES (
3743: ZX_LINES_S.NEXTVAL
3744: ,TAX_LINE_NUMBER
3745: ,APPLICATION_ID
3746: ,CONTENT_OWNER_ID
3747: ,CURRENCY_CONVERSION_DATE