[Home] [Help]
181: l_count_pvr_null,
182: l_count_rate_id_null
183: FROM ZX_IMPORT_TAX_LINES_GT;
184:
185: SELECT count(1) INTO l_count_link_gt FROM ZX_TRX_TAX_LINK_GT;
186:
187: IF ( g_level_statement >= g_current_runtime_level) THEN
188:
189: SELECT count(1) INTO l_count_header FROM zx_trx_headers_gt;
205: 'Count of ZX_IMPORT_TAX_LINES_GT - Tax Lines with Tax Provider ID : '||to_char(l_count_pvr_null));
206: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
207: 'Count of ZX_IMPORT_TAX_LINES_GT - Tax Lines with Tax Rate ID : '||to_char(l_count_rate_id_null));
208: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
209: 'Count of ZX_TRX_TAX_LINK_GT : '||to_char(l_count_link_gt));
210: END IF;
211:
212: ---------------------------------------------------------------------------------
213: -- Select First Party Organization to be used for validations and defaulting
696: AND lines.trx_line_id =
697: (
698: SELECT
699: MIN(trx_line_id)
700: FROM zx_trx_tax_link_gt link_gt
701: WHERE link_gt.TRX_ID = taxlines_gt.trx_id
702: AND link_gt.application_id = taxlines_gt.application_id
703: AND link_gt.entity_code = taxlines_gt.entity_code
704: AND link_gt.event_class_code = taxlines_gt.event_class_code
870: --AND lines.trx_line_id =
871: --(
872: --SELECT
873: --MIN(trx_line_id)
874: --FROM zx_trx_tax_link_gt link_gt
875: --WHERE link_gt.TRX_ID = taxlines_gt.trx_id
876: --AND link_gt.application_id = taxlines_gt.application_id
877: --AND link_gt.entity_code = taxlines_gt.entity_code
878: --AND link_gt.event_class_code = taxlines_gt.event_class_code
1002: --AND lines.trx_line_id =
1003: --(
1004: --SELECT
1005: --MIN(trx_line_id)
1006: --FROM zx_trx_tax_link_gt link_gt
1007: --WHERE link_gt.TRX_ID = taxlines_gt.trx_id
1008: --AND link_gt.application_id = taxlines_gt.application_id
1009: --AND link_gt.entity_code = taxlines_gt.entity_code
1010: --AND link_gt.event_class_code = taxlines_gt.event_class_code
1132: --AND lines.trx_line_id =
1133: --(
1134: --SELECT
1135: --MIN(trx_line_id)
1136: --FROM zx_trx_tax_link_gt link_gt
1137: --WHERE link_gt.TRX_ID = TaxLines.trx_id
1138: --AND link_gt.application_id = TaxLines.application_id
1139: --AND link_gt.entity_code = TaxLines.entity_code
1140: --AND link_gt.event_class_code = TaxLines.event_class_code
1273: --AND lines.trx_line_id =
1274: --(
1275: --SELECT
1276: --MIN(trx_line_id)
1277: --FROM zx_trx_tax_link_gt link_gt
1278: --WHERE link_gt.TRX_ID = TaxLines.trx_id
1279: --AND link_gt.application_id = TaxLines.application_id
1280: --AND link_gt.entity_code = TaxLines.entity_code
1281: --AND link_gt.event_class_code = TaxLines.event_class_code
1381: --AND lines.trx_line_id =
1382: --(
1383: --SELECT
1384: --MIN(trx_line_id)
1385: --FROM zx_trx_tax_link_gt link_gt
1386: --WHERE link_gt.TRX_ID = TaxLines.trx_id
1387: --AND link_gt.application_id = TaxLines.application_id
1388: --AND link_gt.entity_code = TaxLines.entity_code
1389: --AND link_gt.event_class_code = TaxLines.event_class_code
1556: --( TaxLines.trx_line_id IS NULL
1557: --AND TaxLines.tax_line_allocation_flag = 'Y'
1558: --AND lines.trx_line_id =
1559: --(SELECT MIN(trx_line_id)
1560: --FROM zx_trx_tax_link_gt link_gt
1561: --WHERE link_gt.TRX_ID = TaxLines.trx_id
1562: --AND link_gt.application_id = TaxLines.application_id
1563: --AND link_gt.entity_code = TaxLines.entity_code
1564: --AND link_gt.event_class_code = TaxLines.event_class_code
1750: TaxLines.tax_amt_included_flag,
1751: TaxLink.line_amt,
1752: TaxLines.trx_id,
1753: TaxLines.trx_line_id
1754: FROM ZX_TRX_TAX_LINK_GT TaxLink,
1755: ZX_IMPORT_TAX_LINES_GT TaxLines,
1756: ZX_TRX_HEADERS_GT Header,
1757: ZX_TRANSACTION_LINES_GT Lines,
1758: ZX_TAXES_B tax,
1788: AND lines.trx_line_id =
1789: (
1790: SELECT
1791: MIN(trx_line_id)
1792: FROM zx_trx_tax_link_gt link_gt
1793: WHERE link_gt.TRX_ID = TaxLines.trx_id
1794: AND link_gt.application_id = TaxLines.application_id
1795: AND link_gt.entity_code = TaxLines.entity_code
1796: AND link_gt.event_class_code = TaxLines.event_class_code
2062: AND lines_gt.trx_line_id =
2063: (
2064: SELECT
2065: MIN(trx_line_id)
2066: FROM zx_trx_tax_link_gt link_gt
2067: WHERE link_gt.TRX_ID = taxlines_gt.trx_id
2068: AND link_gt.application_id = taxlines_gt.application_id
2069: AND link_gt.entity_code = taxlines_gt.entity_code
2070: AND link_gt.event_class_code = taxlines_gt.event_class_code
2210: trx_id,
2211: trx_line_id,
2212: trx_level_type,
2213: summary_tax_line_number
2214: FROM zx_trx_tax_link_gt;
2215:
2216: BEGIN
2217: x_return_status := FND_API.G_RET_STS_SUCCESS;
2218: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4452: -- then no tax lines should be allocated to that line
4453:
4454: CASE WHEN (lines_gt.CTRL_TOTAL_LINE_TX_AMT IS NOT NULL AND
4455: EXISTS (SELECT 1
4456: from zx_trx_tax_link_gt
4457: WHERE application_id = lines_gt.application_id
4458: AND entity_code = lines_gt.entity_code
4459: AND event_class_code = lines_gt.event_class_code
4460: AND trx_id = lines_gt.trx_id
5387: -- Tax lines with Tax Line Allocation flag as Y should have at least one allocation
5388: -- line in the Link GTT
5389: CASE WHEN (taxlines_gt.tax_line_allocation_flag = 'Y' AND
5390: NOT EXISTS (SELECT 1
5391: FROM zx_trx_tax_link_gt
5392: WHERE application_id = taxlines_gt.application_id
5393: AND entity_code = taxlines_gt.entity_code
5394: AND event_class_code = taxlines_gt.event_class_code
5395: AND trx_id = taxlines_gt.trx_id
5469: --taxlines_gt.trx_line_id IS NULL
5470: --AND taxlines_gt.tax_line_allocation_flag = 'Y'
5471: --AND lines_gt.trx_line_id =
5472: --(
5473: --SELECT /*+ index(link_gt ZX_TRX_TAX_LINK_GT_U1) */
5474: --MIN(trx_line_id)
5475: --FROM zx_trx_tax_link_gt link_gt
5476: --WHERE link_gt.TRX_ID = taxlines_gt.trx_id
5477: --AND link_gt.application_id = taxlines_gt.application_id
5471: --AND lines_gt.trx_line_id =
5472: --(
5473: --SELECT /*+ index(link_gt ZX_TRX_TAX_LINK_GT_U1) */
5474: --MIN(trx_line_id)
5475: --FROM zx_trx_tax_link_gt link_gt
5476: --WHERE link_gt.TRX_ID = taxlines_gt.trx_id
5477: --AND link_gt.application_id = taxlines_gt.application_id
5478: --AND link_gt.entity_code = taxlines_gt.entity_code
5479: --AND link_gt.event_class_code = taxlines_gt.event_class_code
5881: -- --taxlines_gt is multi alloc
5882: -- (taxlines_gt.trx_line_id IS NULL AND
5883: -- taxlines_gt.tax_line_allocation_flag = 'Y' AND
5884: -- EXISTS (SELECT 1
5885: -- FROM zx_trx_tax_link_gt link_gt
5886: -- WHERE link_gt.trx_id = taxlines_gt.trx_id
5887: -- AND link_gt.application_id = taxlines_gt.application_id
5888: -- AND link_gt.entity_code = taxlines_gt.entity_code
5889: -- AND link_gt.event_class_code = taxlines_gt.event_class_code
5909: imptaxes_gt1.tax_line_allocation_flag = 'Y' AND
5910: ( --taxlines_gt is one to one alloc
5911: (taxlines_gt.trx_line_id IS NOT NULL AND
5912: EXISTS (SELECT 1
5913: FROM zx_trx_tax_link_gt link_gt
5914: WHERE link_gt.trx_id = imptaxes_gt1.trx_id
5915: AND link_gt.application_id = imptaxes_gt1.application_id
5916: AND link_gt.entity_code = imptaxes_gt1.entity_code
5917: AND link_gt.event_class_code = imptaxes_gt1.event_class_code
5936: -- AND --taxlines_gt is multi alloc
5937: -- (taxlines_gt.trx_line_id IS NULL AND
5938: -- taxlines_gt.tax_line_allocation_flag = 'Y' AND
5939: -- EXISTS (SELECT 1
5940: -- FROM zx_trx_tax_link_gt link_gt1,
5941: -- zx_trx_tax_link_gt link_gt2
5942: -- WHERE link_gt1.trx_id = imptaxes_gt1.trx_id
5943: -- AND link_gt1.application_id = imptaxes_gt1.application_id
5944: -- AND link_gt1.entity_code = imptaxes_gt1.entity_code
5937: -- (taxlines_gt.trx_line_id IS NULL AND
5938: -- taxlines_gt.tax_line_allocation_flag = 'Y' AND
5939: -- EXISTS (SELECT 1
5940: -- FROM zx_trx_tax_link_gt link_gt1,
5941: -- zx_trx_tax_link_gt link_gt2
5942: -- WHERE link_gt1.trx_id = imptaxes_gt1.trx_id
5943: -- AND link_gt1.application_id = imptaxes_gt1.application_id
5944: -- AND link_gt1.entity_code = imptaxes_gt1.entity_code
5945: -- AND link_gt1.event_class_code = imptaxes_gt1.event_class_code
5966: --
5967: CASE
5968: WHEN lines_gt.line_level_action = 'LINE_INFO_TAX_ONLY'
5969: AND EXISTS
5970: (SELECT /*+ INDEX(zx_trx_tax_link_gt ZX_TRX_TAX_LINK_GT_U1) */ 1
5971: FROM zx_trx_tax_link_gt
5972: WHERE application_id = taxlines_gt.application_id
5973: AND entity_code = taxlines_gt.entity_code
5974: AND event_class_code = taxlines_gt.event_class_code
5967: CASE
5968: WHEN lines_gt.line_level_action = 'LINE_INFO_TAX_ONLY'
5969: AND EXISTS
5970: (SELECT /*+ INDEX(zx_trx_tax_link_gt ZX_TRX_TAX_LINK_GT_U1) */ 1
5971: FROM zx_trx_tax_link_gt
5972: WHERE application_id = taxlines_gt.application_id
5973: AND entity_code = taxlines_gt.entity_code
5974: AND event_class_code = taxlines_gt.event_class_code
5975: AND trx_id = taxlines_gt.trx_id
5986: --
5987: CASE
5988: WHEN lines_gt.line_level_action = 'LINE_INFO_TAX_ONLY'
5989: AND EXISTS
5990: (SELECT /*+ INDEX(zx_trx_tax_link_gt ZX_TRX_TAX_LINK_GT_U1) */ 1
5991: FROM zx_trx_tax_link_gt
5992: WHERE application_id = taxlines_gt.application_id
5993: AND entity_code = taxlines_gt.entity_code
5994: AND event_class_code = taxlines_gt.event_class_code
5987: CASE
5988: WHEN lines_gt.line_level_action = 'LINE_INFO_TAX_ONLY'
5989: AND EXISTS
5990: (SELECT /*+ INDEX(zx_trx_tax_link_gt ZX_TRX_TAX_LINK_GT_U1) */ 1
5991: FROM zx_trx_tax_link_gt
5992: WHERE application_id = taxlines_gt.application_id
5993: AND entity_code = taxlines_gt.entity_code
5994: AND event_class_code = taxlines_gt.event_class_code
5995: AND trx_id = taxlines_gt.trx_id
6041: AND --Multi Alloc
6042: (tax_gt.trx_line_id IS NULL AND
6043: tax_gt.tax_line_allocation_flag = 'Y' AND
6044: EXISTS (SELECT 1
6045: FROM zx_trx_tax_link_gt link_gt
6046: WHERE link_gt.trx_id = tax_gt.trx_id
6047: AND link_gt.application_id = tax_gt.application_id
6048: AND link_gt.entity_code = tax_gt.entity_code
6049: AND link_gt.event_class_code = tax_gt.event_class_code
6129: AND --Multi Alloc
6130: (tax_gt.trx_line_id IS NULL AND
6131: tax_gt.tax_line_allocation_flag = 'Y' AND
6132: EXISTS (SELECT 1
6133: FROM zx_trx_tax_link_gt link_gt
6134: WHERE link_gt.trx_id = tax_gt.trx_id
6135: AND link_gt.application_id = tax_gt.application_id
6136: AND link_gt.entity_code = tax_gt.entity_code
6137: AND link_gt.event_class_code = tax_gt.event_class_code
6360: (taxlines_gt.trx_line_id IS NULL AND
6361: taxlines_gt.tax_line_allocation_flag = 'Y' AND
6362: -- in case of tax only line, trx_line_id = summary_tax_line_number
6363: NOT EXISTS (SELECT 1
6364: FROM zx_trx_tax_link_gt link_gt
6365: WHERE link_gt.trx_id = taxlines_gt.trx_id
6366: AND link_gt.application_id = taxlines_gt.application_id
6367: AND link_gt.entity_code = taxlines_gt.entity_code
6368: AND link_gt.event_class_code = taxlines_gt.event_class_code
6411: --taxlines_gt is multi alloc
6412: (taxlines_gt.trx_line_id IS NULL AND
6413: taxlines_gt.tax_line_allocation_flag = 'Y' AND
6414: EXISTS (SELECT 1
6415: FROM zx_trx_tax_link_gt link_gt
6416: WHERE link_gt.trx_id = taxlines_gt.trx_id
6417: AND link_gt.application_id = taxlines_gt.application_id
6418: AND link_gt.entity_code = taxlines_gt.entity_code
6419: AND link_gt.event_class_code = taxlines_gt.event_class_code
6439: -- imptaxes_gt1.tax_line_allocation_flag = 'Y' AND
6440: -- ( --taxlines_gt is one to one alloc
6441: -- (taxlines_gt.trx_line_id IS NOT NULL AND
6442: -- EXISTS (SELECT 1
6443: -- FROM zx_trx_tax_link_gt link_gt
6444: -- WHERE link_gt.trx_id = imptaxes_gt1.trx_id
6445: -- AND link_gt.application_id = imptaxes_gt1.application_id
6446: -- AND link_gt.entity_code = imptaxes_gt1.entity_code
6447: -- AND link_gt.event_class_code = imptaxes_gt1.event_class_code
6470: AND --taxlines_gt is multi alloc
6471: (taxlines_gt.trx_line_id IS NULL AND
6472: taxlines_gt.tax_line_allocation_flag = 'Y' AND
6473: EXISTS (SELECT 1
6474: FROM zx_trx_tax_link_gt link_gt1,
6475: zx_trx_tax_link_gt link_gt2
6476: WHERE link_gt1.trx_id = imptaxes_gt1.trx_id
6477: AND link_gt1.application_id = imptaxes_gt1.application_id
6478: AND link_gt1.entity_code = imptaxes_gt1.entity_code
6471: (taxlines_gt.trx_line_id IS NULL AND
6472: taxlines_gt.tax_line_allocation_flag = 'Y' AND
6473: EXISTS (SELECT 1
6474: FROM zx_trx_tax_link_gt link_gt1,
6475: zx_trx_tax_link_gt link_gt2
6476: WHERE link_gt1.trx_id = imptaxes_gt1.trx_id
6477: AND link_gt1.application_id = imptaxes_gt1.application_id
6478: AND link_gt1.entity_code = imptaxes_gt1.entity_code
6479: AND link_gt1.event_class_code = imptaxes_gt1.event_class_code
6501: --
6502: CASE
6503: WHEN lines_gt.line_level_action = 'LINE_INFO_TAX_ONLY'
6504: AND EXISTS
6505: (SELECT /*+ INDEX(zx_trx_tax_link_gt ZX_TRX_TAX_LINK_GT_U1) */ 1
6506: FROM zx_trx_tax_link_gt
6507: WHERE application_id = taxlines_gt.application_id
6508: AND entity_code = taxlines_gt.entity_code
6509: AND event_class_code = taxlines_gt.event_class_code
6502: CASE
6503: WHEN lines_gt.line_level_action = 'LINE_INFO_TAX_ONLY'
6504: AND EXISTS
6505: (SELECT /*+ INDEX(zx_trx_tax_link_gt ZX_TRX_TAX_LINK_GT_U1) */ 1
6506: FROM zx_trx_tax_link_gt
6507: WHERE application_id = taxlines_gt.application_id
6508: AND entity_code = taxlines_gt.entity_code
6509: AND event_class_code = taxlines_gt.event_class_code
6510: AND trx_id = taxlines_gt.trx_id
6523: --
6524: CASE
6525: WHEN lines_gt.line_level_action = 'LINE_INFO_TAX_ONLY'
6526: AND EXISTS
6527: (SELECT /*+ INDEX(zx_trx_tax_link_gt ZX_TRX_TAX_LINK_GT_U1) */ 1
6528: FROM zx_trx_tax_link_gt
6529: WHERE application_id = taxlines_gt.application_id
6530: AND entity_code = taxlines_gt.entity_code
6531: AND event_class_code = taxlines_gt.event_class_code
6524: CASE
6525: WHEN lines_gt.line_level_action = 'LINE_INFO_TAX_ONLY'
6526: AND EXISTS
6527: (SELECT /*+ INDEX(zx_trx_tax_link_gt ZX_TRX_TAX_LINK_GT_U1) */ 1
6528: FROM zx_trx_tax_link_gt
6529: WHERE application_id = taxlines_gt.application_id
6530: AND entity_code = taxlines_gt.entity_code
6531: AND event_class_code = taxlines_gt.event_class_code
6532: AND trx_id = taxlines_gt.trx_id
6580: AND --Multi Alloc
6581: (tax_gt.trx_line_id IS NULL AND
6582: tax_gt.tax_line_allocation_flag = 'Y' AND
6583: EXISTS (SELECT 1
6584: FROM zx_trx_tax_link_gt link_gt
6585: WHERE link_gt.trx_id = tax_gt.trx_id
6586: AND link_gt.application_id = tax_gt.application_id
6587: AND link_gt.entity_code = tax_gt.entity_code
6588: AND link_gt.event_class_code = tax_gt.event_class_code
6668: AND --Multi Alloc
6669: (tax_gt.trx_line_id IS NULL AND
6670: tax_gt.tax_line_allocation_flag = 'Y' AND
6671: EXISTS (SELECT 1
6672: FROM zx_trx_tax_link_gt link_gt
6673: WHERE link_gt.trx_id = tax_gt.trx_id
6674: AND link_gt.application_id = tax_gt.application_id
6675: AND link_gt.entity_code = tax_gt.entity_code
6676: AND link_gt.event_class_code = tax_gt.event_class_code
6726: taxlines_gt.trx_line_id IS NULL
6727: AND taxlines_gt.tax_line_allocation_flag = 'Y'
6728: AND lines_gt.trx_line_id =
6729: (
6730: SELECT /*+ index(link_gt ZX_TRX_TAX_LINK_GT_U1) */
6731: MIN(trx_line_id)
6732: FROM zx_trx_tax_link_gt link_gt
6733: WHERE link_gt.TRX_ID = taxlines_gt.trx_id
6734: AND link_gt.application_id = taxlines_gt.application_id
6728: AND lines_gt.trx_line_id =
6729: (
6730: SELECT /*+ index(link_gt ZX_TRX_TAX_LINK_GT_U1) */
6731: MIN(trx_line_id)
6732: FROM zx_trx_tax_link_gt link_gt
6733: WHERE link_gt.TRX_ID = taxlines_gt.trx_id
6734: AND link_gt.application_id = taxlines_gt.application_id
6735: AND link_gt.entity_code = taxlines_gt.entity_code
6736: AND link_gt.event_class_code = taxlines_gt.event_class_code
6963: -- --taxlines_gt is multi alloc
6964: -- (taxlines_gt.trx_line_id IS NULL AND
6965: -- taxlines_gt.tax_line_allocation_flag = 'Y' AND
6966: -- EXISTS (SELECT 1
6967: -- FROM zx_trx_tax_link_gt link_gt
6968: -- WHERE link_gt.trx_id = taxlines_gt.trx_id
6969: -- AND link_gt.application_id = taxlines_gt.application_id
6970: -- AND link_gt.entity_code = taxlines_gt.entity_code
6971: -- AND link_gt.event_class_code = taxlines_gt.event_class_code
6990: (imptaxes_gt1.trx_line_id IS NULL AND
6991: imptaxes_gt1.tax_line_allocation_flag = 'Y' AND
6992: -- in case of tax only line, trx_line_id = summary_tax_line_number
6993: (NOT EXISTS (SELECT 1
6994: FROM zx_trx_tax_link_gt link_gt
6995: WHERE link_gt.trx_id = imptaxes_gt1.trx_id
6996: AND link_gt.application_id = imptaxes_gt1.application_id
6997: AND link_gt.entity_code = imptaxes_gt1.entity_code
6998: AND link_gt.event_class_code = imptaxes_gt1.event_class_code
7005: -- so there is no need to check One-To-One Alloc of taxlines_gt
7006: -- ( --taxlines_gt is one to one alloc
7007: -- (taxlines_gt.trx_line_id IS NOT NULL AND
7008: -- EXISTS (SELECT 1
7009: -- FROM zx_trx_tax_link_gt link_gt
7010: -- WHERE link_gt.trx_id = imptaxes_gt1.trx_id
7011: -- AND link_gt.application_id = imptaxes_gt1.application_id
7012: -- AND link_gt.entity_code = imptaxes_gt1.entity_code
7013: -- AND link_gt.event_class_code = imptaxes_gt1.event_class_code
7031: -- AND --taxlines_gt is multi alloc
7032: -- (taxlines_gt.trx_line_id IS NULL AND
7033: -- taxlines_gt.tax_line_allocation_flag = 'Y' AND
7034: -- EXISTS (SELECT 1
7035: -- FROM zx_trx_tax_link_gt link_gt1,
7036: -- zx_trx_tax_link_gt link_gt2
7037: -- WHERE link_gt1.trx_id = imptaxes_gt1.trx_id
7038: -- AND link_gt1.application_id = imptaxes_gt1.application_id
7039: -- AND link_gt1.entity_code = imptaxes_gt1.entity_code
7032: -- (taxlines_gt.trx_line_id IS NULL AND
7033: -- taxlines_gt.tax_line_allocation_flag = 'Y' AND
7034: -- EXISTS (SELECT 1
7035: -- FROM zx_trx_tax_link_gt link_gt1,
7036: -- zx_trx_tax_link_gt link_gt2
7037: -- WHERE link_gt1.trx_id = imptaxes_gt1.trx_id
7038: -- AND link_gt1.application_id = imptaxes_gt1.application_id
7039: -- AND link_gt1.entity_code = imptaxes_gt1.entity_code
7040: -- AND link_gt1.event_class_code = imptaxes_gt1.event_class_code
7060: --
7061: CASE
7062: WHEN lines_gt.line_level_action = 'LINE_INFO_TAX_ONLY'
7063: AND EXISTS
7064: (SELECT /*+ INDEX(zx_trx_tax_link_gt ZX_TRX_TAX_LINK_GT_U1) */ 1
7065: FROM zx_trx_tax_link_gt
7066: WHERE application_id = taxlines_gt.application_id
7067: AND entity_code = taxlines_gt.entity_code
7068: AND event_class_code = taxlines_gt.event_class_code
7061: CASE
7062: WHEN lines_gt.line_level_action = 'LINE_INFO_TAX_ONLY'
7063: AND EXISTS
7064: (SELECT /*+ INDEX(zx_trx_tax_link_gt ZX_TRX_TAX_LINK_GT_U1) */ 1
7065: FROM zx_trx_tax_link_gt
7066: WHERE application_id = taxlines_gt.application_id
7067: AND entity_code = taxlines_gt.entity_code
7068: AND event_class_code = taxlines_gt.event_class_code
7069: AND trx_id = taxlines_gt.trx_id
7080: --
7081: CASE
7082: WHEN lines_gt.line_level_action = 'LINE_INFO_TAX_ONLY'
7083: AND EXISTS
7084: (SELECT /*+ INDEX(zx_trx_tax_link_gt ZX_TRX_TAX_LINK_GT_U1) */ 1
7085: FROM zx_trx_tax_link_gt
7086: WHERE application_id = taxlines_gt.application_id
7087: AND entity_code = taxlines_gt.entity_code
7088: AND event_class_code = taxlines_gt.event_class_code
7081: CASE
7082: WHEN lines_gt.line_level_action = 'LINE_INFO_TAX_ONLY'
7083: AND EXISTS
7084: (SELECT /*+ INDEX(zx_trx_tax_link_gt ZX_TRX_TAX_LINK_GT_U1) */ 1
7085: FROM zx_trx_tax_link_gt
7086: WHERE application_id = taxlines_gt.application_id
7087: AND entity_code = taxlines_gt.entity_code
7088: AND event_class_code = taxlines_gt.event_class_code
7089: AND trx_id = taxlines_gt.trx_id
7135: AND --Multi Alloc
7136: (tax_gt.trx_line_id IS NULL AND
7137: tax_gt.tax_line_allocation_flag = 'Y' AND
7138: EXISTS (SELECT 1
7139: FROM zx_trx_tax_link_gt link_gt
7140: WHERE link_gt.trx_id = tax_gt.trx_id
7141: AND link_gt.application_id = tax_gt.application_id
7142: AND link_gt.entity_code = tax_gt.entity_code
7143: AND link_gt.event_class_code = tax_gt.event_class_code
7223: AND --Multi Alloc
7224: (tax_gt.trx_line_id IS NULL AND
7225: tax_gt.tax_line_allocation_flag = 'Y' AND
7226: EXISTS (SELECT 1
7227: FROM zx_trx_tax_link_gt link_gt
7228: WHERE link_gt.trx_id = tax_gt.trx_id
7229: AND link_gt.application_id = tax_gt.application_id
7230: AND link_gt.entity_code = tax_gt.entity_code
7231: AND link_gt.event_class_code = tax_gt.event_class_code
7518: --AND lines_gt.trx_line_id =
7519: --(
7520: --SELECT
7521: --MIN(trx_line_id)
7522: --FROM zx_trx_tax_link_gt link_gt
7523: --WHERE link_gt.TRX_ID = taxlines_gt.trx_id
7524: --AND link_gt.application_id = taxlines_gt.application_id
7525: --AND link_gt.entity_code = taxlines_gt.entity_code
7526: --AND link_gt.event_class_code = taxlines_gt.event_class_code
7917: --AND lines_gt.trx_line_id =
7918: --(
7919: --SELECT
7920: --MIN(trx_line_id)
7921: --FROM zx_trx_tax_link_gt link_gt
7922: --WHERE link_gt.TRX_ID = taxlines_gt.trx_id
7923: --AND link_gt.application_id = taxlines_gt.application_id
7924: --AND link_gt.entity_code = taxlines_gt.entity_code
7925: --AND link_gt.event_class_code = taxlines_gt.event_class_code
8194: --AND lines_gt.trx_line_id =
8195: --(
8196: --SELECT
8197: --MIN(trx_line_id)
8198: --FROM zx_trx_tax_link_gt link_gt
8199: --WHERE link_gt.TRX_ID = taxlines_gt.trx_id
8200: --AND link_gt.application_id = taxlines_gt.application_id
8201: --AND link_gt.entity_code = taxlines_gt.entity_code
8202: --AND link_gt.event_class_code = taxlines_gt.event_class_code
8277: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
8278: 'No. of Rows inserted : '|| to_char(sql%ROWCOUNT) );
8279: END IF;
8280:
8281: -- Validations for zx_trx_tax_link_gt link_gt
8282: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8283: IF ( g_level_event >= g_current_runtime_level) THEN
8284: FND_LOG.STRING(g_level_event,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
8285: 'Validations for ZX_TRX_TAX_LINK_GT');
8281: -- Validations for zx_trx_tax_link_gt link_gt
8282: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8283: IF ( g_level_event >= g_current_runtime_level) THEN
8284: FND_LOG.STRING(g_level_event,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
8285: 'Validations for ZX_TRX_TAX_LINK_GT');
8286: END IF;
8287:
8288: -- Select the key columns and write into fnd log for debug purpose
8289: IF ( g_level_statement >= g_current_runtime_level) THEN
8334: END IF; -- End of debug checking
8335:
8336: IF ( g_level_event >= g_current_runtime_level) THEN
8337: FND_LOG.STRING(g_level_event,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
8338: 'Running Line-Tax Link related Validations : ZX_TRX_TAX_LINK_GT');
8339: END IF;
8340:
8341: INSERT ALL
8342: WHEN (ZX_INVALID_TRX_LINE_ID = 'Y') THEN
8427: AND trx_level_type = link_gt.trx_level_type*/ -- Bug 4703541
8428: THEN 'Y'
8429: ELSE NULL
8430: END ZX_INVALID_SUMMARY_TAX_LINE_ID
8431: FROM zx_trx_tax_link_gt link_gt;
8432:
8433: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8434: IF ( g_level_statement >= g_current_runtime_level) THEN
8435: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',