[Home] [Help]
160: END IF;
161:
162: SELECT count(1) INTO l_count_header FROM zx_trx_headers_gt;
163:
164: SELECT count(1) INTO l_count_lines FROM ZX_TRANSACTION_LINES_GT;
165:
166: SELECT count(1) INTO l_count_tax_lines FROM ZX_IMPORT_TAX_LINES_GT;
167:
168: SELECT count(1) INTO l_count_link_gt FROM ZX_TRX_TAX_LINK_GT;
170: IF ( g_level_statement >= g_current_runtime_level) THEN
171: FND_LOG.STRING(g_level_statement,'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
172: 'Count of ZX_TRX_HEADERS_GT '||to_char(l_count_header));
173: FND_LOG.STRING(g_level_statement,'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
174: 'Count of ZX_TRANSACTION_LINES_GT '||to_char(l_count_lines));
175: FND_LOG.STRING(g_level_statement,'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
176: 'Count of ZX_IMPORT_TAX_LINES_GT '||to_char(l_count_tax_lines));
177: FND_LOG.STRING(g_level_statement,'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
178: 'Count of ZX_TRX_TAX_LINK_GT '||to_char(l_count_link_gt));
411: l_org_id ZX_TRX_HEADERS_GT.internal_organization_id%Type;
412: l_effective_date Date;
413: l_return_status varchar2(30);
414:
415: --Bug 5018766 : Added for Defaulting the Tax Dates on the Newly added columns in zx_transaction_lines_gt
416: c_lines_per_commit CONSTANT NUMBER := ZX_TDS_CALC_SERVICES_PUB_PKG.G_LINES_PER_COMMIT;
417: l_application_id_tbl APPLICATION_ID_TBL;
418: l_entity_code_tbl ENTITY_CODE_TBL;
419: l_event_class_code_tbl EVENT_CLASS_CODE_TBL;
440: header.provnl_tax_determination_date,
441: Lines.adjusted_doc_date,
442: header.trx_date) subscription_date
443: from zx_trx_headers_gt header,
444: zx_transaction_lines_gt lines
445: where header.application_id = lines.application_id
446: and header.ENTITY_CODE = lines.ENTITY_CODE
447: and header.EVENT_CLASS_CODE = lines.EVENT_CLASS_CODE
448: and header.TRX_ID = lines.TRX_ID ;
462: IF (g_level_statement >= g_current_runtime_level ) THEN
463: FND_LOG.STRING(g_level_statement,
464: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
465: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR:
466: Stamping the Dates onto zx_transaction_lines_gt');
467: END IF;
468:
469: OPEN c_lines;
470: loop
483:
484: -- Stamp the tax_date , tax_determine_date and tax_point_date to the same value
485: if ( l_count > 0 ) THEN
486: FORALL i IN 1 .. l_count
487: update zx_transaction_lines_gt
488: set tax_date = l_trx_date_tbl(i),
489: tax_determine_date = l_trx_date_tbl(i),
490: tax_point_date = l_trx_date_tbl(i),
491: subscription_date = l_subscription_date_tb1(i)
551: TaxLines_gt.summary_tax_line_number summary_tax_line_number
552: FROM ZX_FC_COUNTRY_DEFAULTS ContDef,
553: ZX_IMPORT_TAX_LINES_GT TaxLines_gt,
554: ZX_TRX_HEADERS_GT Header,
555: ZX_TRANSACTION_LINES_GT Lines,
556: ZX_RATES_B rates,
557: ZX_SUBSCRIPTION_DETAILS sd_rates
558: WHERE TaxLines_gt.tax_rate_code = rates.tax_rate_code(+)
559: AND (Taxlines_gt.tax_rate_code IS NOT NULL OR Taxlines_gt.tax_rate_id IS NOT NULL)
599: AND lines.trx_line_id =
600: (
601: SELECT
602: MIN(trx_line_id)
603: FROM zx_transaction_lines_gt trans_line_gt
604: WHERE trans_line_gt.trx_id = taxlines_gt.trx_id
605: AND trans_line_gt.application_id = taxlines_gt.application_id
606: AND trans_line_gt.entity_code = taxlines_gt.entity_code
607: AND trans_line_gt.event_class_code = taxlines_gt.event_class_code
668: TaxLines_gt.summary_tax_line_number summary_tax_line_number
669: FROM ZX_FC_COUNTRY_DEFAULTS ContDef,
670: ZX_IMPORT_TAX_LINES_GT TaxLines_gt,
671: ZX_TRX_HEADERS_GT Header,
672: ZX_TRANSACTION_LINES_GT Lines,
673: ZX_RATES_B rates,
674: ZX_SUBSCRIPTION_DETAILS sd_rates
675: WHERE TaxLines_gt.tax_rate_id = rates.tax_rate_id(+)
676: AND (Taxlines_gt.tax_rate_code IS NOT NULL OR Taxlines_gt.tax_rate_id IS NOT NULL)
716: AND lines.trx_line_id =
717: (
718: SELECT
719: MIN(trx_line_id)
720: FROM zx_transaction_lines_gt trans_line_gt
721: WHERE trans_line_gt.trx_id = taxlines_gt.trx_id
722: AND trans_line_gt.application_id = taxlines_gt.application_id
723: AND trans_line_gt.entity_code = taxlines_gt.entity_code
724: AND trans_line_gt.event_class_code = taxlines_gt.event_class_code
783: SET tax_status_code =
784: (SELECT Status.tax_status_code
785: FROM ZX_STATUS_B Status,
786: ZX_TRX_HEADERS_GT Header,
787: ZX_TRANSACTION_LINES_GT Lines,
788: ZX_SUBSCRIPTION_DETAILS sd_status,
789: ZX_RATES_B rates,
790: ZX_SUBSCRIPTION_DETAILS sd_rates
791: WHERE Status.tax_regime_code = TaxLines.tax_regime_code
836: AND lines.trx_line_id =
837: (
838: SELECT
839: MIN(trx_line_id)
840: FROM zx_transaction_lines_gt trans_line_gt
841: WHERE trans_line_gt.trx_id = TaxLines.trx_id
842: AND trans_line_gt.application_id = TaxLines.application_id
843: AND trans_line_gt.entity_code = TaxLines.entity_code
844: AND trans_line_gt.event_class_code = TaxLines.event_class_code
924: (SELECT srvc.srvc_provider_id
925: FROM ZX_SRVC_SUBSCRIPTIONS srvc,
926: ZX_REGIMES_USAGES reg,
927: ZX_TRX_HEADERS_GT Header,
928: ZX_TRANSACTION_LINES_GT Lines,
929: ZX_EVNT_CLS_MAPPINGS mapp
930: WHERE reg.tax_regime_code = TaxLines.tax_regime_code
931: AND srvc.regime_usage_id = reg.regime_usage_id
932: AND srvc.enabled_flag = 'Y'
972: AND lines.trx_line_id =
973: (
974: SELECT
975: MIN(trx_line_id)
976: FROM zx_transaction_lines_gt trans_line_gt
977: WHERE trans_line_gt.trx_id = TaxLines.trx_id
978: AND trans_line_gt.application_id = TaxLines.application_id
979: AND trans_line_gt.entity_code = TaxLines.entity_code
980: AND trans_line_gt.event_class_code = TaxLines.event_class_code
1012: SET tax_jurisdiction_code =
1013: (SELECT jur.TAX_JURISDICTION_CODE
1014: FROM ZX_JURISDICTIONS_B Jur,
1015: ZX_TRX_HEADERS_GT Header,
1016: ZX_TRANSACTION_LINES_GT Lines,
1017: ZX_RATES_B rates,
1018: ZX_SUBSCRIPTION_DETAILS sd_rates
1019: WHERE
1020: Jur.tax = TaxLines.Tax
1069: AND lines.trx_line_id =
1070: (
1071: SELECT
1072: MIN(trx_line_id)
1073: FROM zx_transaction_lines_gt trans_line_gt
1074: WHERE trans_line_gt.trx_id = TaxLines.trx_id
1075: AND trans_line_gt.application_id = TaxLines.application_id
1076: AND trans_line_gt.entity_code = TaxLines.entity_code
1077: AND trans_line_gt.event_class_code = TaxLines.event_class_code
1142: TaxLines.trx_id trx_id,
1143: TaxLines.summary_tax_line_number summary_tax_line_number
1144: FROM zx_rates_b rates,
1145: zx_trx_headers_gt header,
1146: zx_transaction_lines_gt lines,
1147: zx_subscription_details sd_rates,
1148: zx_import_tax_lines_gt taxlines
1149: WHERE TaxLines.tax_regime_Code = rates.tax_regime_code(+)
1150: -- AND (Taxlines.tax_rate_code IS NOT NULL OR Taxlines.tax_rate_id IS NOT NULL)
1232: ( TaxLines.trx_line_id IS NULL
1233: AND TaxLines.tax_line_allocation_flag = 'N'
1234: AND lines.trx_line_id =
1235: (SELECT MIN(trx_line_id)
1236: FROM zx_transaction_lines_gt trans_line_gt
1237: WHERE trans_line_gt.trx_id = TaxLines.trx_id
1238: AND trans_line_gt.application_id = TaxLines.application_id
1239: AND trans_line_gt.entity_code = TaxLines.entity_code
1240: AND trans_line_gt.event_class_code = TaxLines.event_class_code
1254: TaxLines.trx_id trx_id,
1255: TaxLines.summary_tax_line_number summary_tax_line_number
1256: FROM zx_rates_b rates,
1257: zx_trx_headers_gt header,
1258: zx_transaction_lines_gt lines,
1259: zx_subscription_details sd_rates,
1260: zx_import_tax_lines_gt taxlines
1261: WHERE TaxLines.tax_regime_Code = rates.tax_regime_code(+)
1262: -- AND (Taxlines.tax_rate_code IS NOT NULL OR Taxlines.tax_rate_id IS NOT NULL)
1344: ( TaxLines.trx_line_id IS NULL
1345: AND TaxLines.tax_line_allocation_flag = 'N'
1346: AND lines.trx_line_id =
1347: (SELECT MIN(trx_line_id)
1348: FROM zx_transaction_lines_gt trans_line_gt
1349: WHERE trans_line_gt.trx_id = TaxLines.trx_id
1350: AND trans_line_gt.application_id = TaxLines.application_id
1351: AND trans_line_gt.entity_code = TaxLines.entity_code
1352: AND trans_line_gt.event_class_code = TaxLines.event_class_code
1411: TaxLines.trx_line_id
1412: FROM ZX_TRX_TAX_LINK_GT TaxLink,
1413: ZX_IMPORT_TAX_LINES_GT TaxLines,
1414: ZX_TRX_HEADERS_GT Header,
1415: ZX_TRANSACTION_LINES_GT Lines,
1416: ZX_TAXES_B tax,
1417: zx_rates_b rate,
1418: zx_subscription_details sd_tax,
1419: zx_subscription_details sd_rates
1463: AND lines.trx_line_id =
1464: (
1465: SELECT
1466: MIN(trx_line_id)
1467: FROM zx_transaction_lines_gt trans_line_gt
1468: WHERE trans_line_gt.trx_id = TaxLines.trx_id
1469: AND trans_line_gt.application_id = TaxLines.application_id
1470: AND trans_line_gt.entity_code = TaxLines.entity_code
1471: AND trans_line_gt.event_class_code = TaxLines.event_class_code
1621:
1622: FROM
1623: ZX_TRX_HEADERS_GT header,
1624: ZX_EVNT_CLS_MAPPINGS evntmap,
1625: ZX_TRANSACTION_LINES_GT lines_gt,
1626: ZX_FC_PRODUCT_CATEGORIES_V fc_prodcat,
1627: ZX_FC_CODES_B fc_user,
1628: ZX_FC_DOCUMENT_FISCAL_V fc_doc,
1629: ZX_FC_BUSINESS_CATEGORIES_V fc_trx,
1679: -- ZX_RATES_B rate ,
1680: -- zx_rates_b off_rate,
1681: -- zx_import_tax_lines_gt temp_gt,
1682: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
1683: zx_transaction_lines_gt lines_gt,
1684: ZX_JURISDICTIONS_B jur,
1685: zx_subscription_details sd_reg,
1686: zx_subscription_details sd_tax,
1687: zx_subscription_details sd_status
1742: AND lines_gt.trx_line_id =
1743: (
1744: SELECT
1745: MIN(trx_line_id)
1746: FROM zx_transaction_lines_gt trans_line_gt
1747: WHERE trans_line_gt.trx_id = taxlines_gt.trx_id
1748: AND trans_line_gt.application_id = taxlines_gt.application_id
1749: AND trans_line_gt.entity_code = taxlines_gt.entity_code
1750: AND trans_line_gt.event_class_code = taxlines_gt.event_class_code
1895: 'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR.BEGIN',
1896: 'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR(+)');
1897: END IF;
1898:
1899: --Validations for ZX_TRX_HEADERS_GT, ZX_TRANSACTION_LINES_GT
1900: IF ( g_level_event >= g_current_runtime_level) THEN
1901: FND_LOG.STRING(g_level_event,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
1902: 'Validations for zx_trx_headers_gt and zx_transaction_lines_gt');
1903: END IF;
1898:
1899: --Validations for ZX_TRX_HEADERS_GT, ZX_TRANSACTION_LINES_GT
1900: IF ( g_level_event >= g_current_runtime_level) THEN
1901: FND_LOG.STRING(g_level_event,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
1902: 'Validations for zx_trx_headers_gt and zx_transaction_lines_gt');
1903: END IF;
1904:
1905: -- Select the key columns and write into fnd log for debug purpose
1906: IF ( g_level_statement >= g_current_runtime_level) THEN
1978: END IF; -- End of debug checking
1979:
1980: IF ( g_level_statement >= g_current_runtime_level) THEN
1981: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
1982: 'Before insertion into ZX_VALIDATION_ERRORS_GT - zx_trx_headers_gt and zx_transaction_lines_gt');
1983: END IF;
1984:
1985: /******************** Split the Header and Line Level Validations : Bug 4703541******/
1986: /** 1. Validations for the zx_trx_headers_gt related **/
2253:
2254: -- Check for existence of Control tax amount
2255: nvl2(header.ctrl_total_hdr_tx_amt,
2256: CASE WHEN ( NOT EXISTS
2257: (SELECT 1 FROM ZX_TRANSACTION_LINES_GT lines1
2258: WHERE lines1.ctrl_hdr_tx_appl_flag = 'Y'
2259: AND lines1.trx_id = header.trx_id
2260: AND lines1.application_id = header.application_id
2261: AND lines1.entity_code = header.entity_code
2339: --Bug 4703541
2340: CASE WHEN (header.TRX_CURRENCY_CODE is NULL
2341: AND header.precision is NULL )
2342: AND EXISTS
2343: ( SELECT 1 FROM zx_transaction_lines_gt
2344: WHERE application_id = header.application_id
2345: AND entity_code = header.entity_code
2346: AND event_class_code = header.event_class_code
2347: AND trx_id = header.trx_id
2383: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
2384: 'No. of Rows inserted for Header Realted Validations '|| to_char(sql%ROWCOUNT) );
2385: END IF;
2386:
2387: /** 2. Validating for the Line Related Validations : zx_transaction_lines_gt **/
2388: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2389: IF ( g_level_statement >= g_current_runtime_level) THEN
2390: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
2391: 'Validating for the Line Related Validations : zx_transaction_lines_gt');
2387: /** 2. Validating for the Line Related Validations : zx_transaction_lines_gt **/
2388: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2389: IF ( g_level_statement >= g_current_runtime_level) THEN
2390: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
2391: 'Validating for the Line Related Validations : zx_transaction_lines_gt');
2392: END IF;
2393:
2394: INSERT ALL
2395:
3728: fc_doc.effective_from AND
3729: nvl(fc_doc.effective_to, lines_gt.tax_date)
3730: AND
3731: (NOT EXISTS
3732: (SELECT 1 FROM ZX_TRANSACTION_LINES_GT
3733: WHERE application_id = lines_gt.application_id
3734: AND entity_code = lines_gt.entity_code
3735: AND event_class_code = lines_gt.event_class_code
3736: AND trx_id = lines_gt.trx_id
4153: END TAX_RATE_CODE_NOT_ACTIVE
4154: FROM
4155: ZX_TRX_HEADERS_GT header,
4156: ZX_EVNT_CLS_MAPPINGS evntmap,
4157: ZX_TRANSACTION_LINES_GT lines_gt,
4158: ZX_FC_PRODUCT_CATEGORIES_V fc_prodcat,
4159: ZX_FC_CODES_B fc_user,
4160: ZX_FC_DOCUMENT_FISCAL_V fc_doc,
4161: ZX_FC_BUSINESS_CATEGORIES_V fc_trx,
5305: --All Alloc
5306: (tax_gt.trx_line_id IS NULL AND
5307: tax_gt.tax_line_allocation_flag = 'N' AND
5308: EXISTS (SELECT 1
5309: FROM zx_transaction_lines_gt trans_line_gt
5310: WHERE trans_line_gt.trx_id = tax_gt.trx_id
5311: AND trans_line_gt.application_id = tax_gt.application_id
5312: AND trans_line_gt.entity_code = tax_gt.entity_code
5313: AND trans_line_gt.event_class_code = tax_gt.event_class_code
5367: --All Alloc
5368: (tax_gt.trx_line_id IS NULL AND
5369: tax_gt.tax_line_allocation_flag = 'N' AND
5370: EXISTS (SELECT 1
5371: FROM zx_transaction_lines_gt trans_line_gt
5372: WHERE trans_line_gt.trx_id = tax_gt.trx_id
5373: AND trans_line_gt.application_id = tax_gt.application_id
5374: AND trans_line_gt.entity_code = tax_gt.entity_code
5375: AND trans_line_gt.event_class_code = tax_gt.event_class_code
5399: -- ZX_RATES_B rate ,
5400: -- zx_rates_b off_rate,
5401: -- zx_import_tax_lines_gt temp_gt,
5402: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
5403: zx_transaction_lines_gt lines_gt,
5404: ZX_JURISDICTIONS_B jur,
5405: zx_subscription_details sd_reg,
5406: zx_subscription_details sd_tax,
5407: zx_subscription_details sd_status
5466: AND lines_gt.trx_line_id =
5467: (
5468: SELECT
5469: MIN(trx_line_id)
5470: FROM zx_transaction_lines_gt trans_line_gt
5471: WHERE trans_line_gt.trx_id = taxlines_gt.trx_id
5472: AND trans_line_gt.application_id = taxlines_gt.application_id
5473: AND trans_line_gt.entity_code = taxlines_gt.entity_code
5474: AND trans_line_gt.event_class_code = taxlines_gt.event_class_code
5765: ) THEN 'Y' ELSE 'N' END
5766: ELSE 'N' END STATUS_SUBSCR_NOT_EFFECTIVE
5767: from
5768: zx_trx_headers_gt header,
5769: zx_transaction_lines_gt lines_gt,
5770: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
5771: ZX_REGIMES_B regime ,
5772: ZX_TAXES_B tax ,
5773: ZX_STATUS_B status ,
5812: AND lines_gt.trx_line_id =
5813: (
5814: SELECT
5815: MIN(trx_line_id)
5816: FROM zx_transaction_lines_gt trans_line_gt
5817: WHERE trans_line_gt.trx_id = taxlines_gt.trx_id
5818: AND trans_line_gt.application_id = taxlines_gt.application_id
5819: AND trans_line_gt.entity_code = taxlines_gt.entity_code
5820: AND trans_line_gt.event_class_code = taxlines_gt.event_class_code
6162: ZX_RATES_B rate ,
6163: zx_rates_b off_rate,
6164: zx_import_tax_lines_gt temp_gt,
6165: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
6166: zx_transaction_lines_gt lines_gt,
6167: zx_subscription_details sd_rates
6168: WHERE taxlines_gt.trx_id = header.trx_id
6169: AND taxlines_gt.application_id = Header.application_id
6170: AND taxlines_gt.entity_code = Header.entity_code
6205: AND lines_gt.trx_line_id =
6206: (
6207: SELECT
6208: MIN(trx_line_id)
6209: FROM zx_transaction_lines_gt trans_line_gt
6210: WHERE trans_line_gt.trx_id = taxlines_gt.trx_id
6211: AND trans_line_gt.application_id = taxlines_gt.application_id
6212: AND trans_line_gt.entity_code = taxlines_gt.entity_code
6213: AND trans_line_gt.event_class_code = taxlines_gt.event_class_code
6422: ZX_RATES_B rate ,
6423: zx_rates_b off_rate,
6424: zx_import_tax_lines_gt temp_gt,
6425: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
6426: zx_transaction_lines_gt lines_gt,
6427: zx_subscription_details sd_rates
6428: WHERE taxlines_gt.trx_id = header.trx_id
6429: AND taxlines_gt.application_id = Header.application_id
6430: AND taxlines_gt.entity_code = Header.entity_code
6465: AND lines_gt.trx_line_id =
6466: (
6467: SELECT
6468: MIN(trx_line_id)
6469: FROM zx_transaction_lines_gt trans_line_gt
6470: WHERE trans_line_gt.trx_id = taxlines_gt.trx_id
6471: AND trans_line_gt.application_id = taxlines_gt.application_id
6472: AND trans_line_gt.entity_code = taxlines_gt.entity_code
6473: AND trans_line_gt.event_class_code = taxlines_gt.event_class_code
6697: summary_tax_line_number,
6698: trx_level_type,
6699: interface_tax_entity_code,
6700: interface_tax_line_id,
6701: -- Check if the Trx Lines present in Link GTT are also present in ZX_TRANSACTION_LINES_GT or not
6702: CASE WHEN NOT EXISTS (SELECT 1
6703: FROM zx_transaction_lines_gt
6704: WHERE application_id = link_gt.application_id
6705: AND entity_code = link_gt.entity_code
6699: interface_tax_entity_code,
6700: interface_tax_line_id,
6701: -- Check if the Trx Lines present in Link GTT are also present in ZX_TRANSACTION_LINES_GT or not
6702: CASE WHEN NOT EXISTS (SELECT 1
6703: FROM zx_transaction_lines_gt
6704: WHERE application_id = link_gt.application_id
6705: AND entity_code = link_gt.entity_code
6706: AND event_class_code = link_gt.event_class_code
6707: AND trx_id = link_gt.trx_id
6795: lines_gt.trx_line_id,
6796: lines_gt.trx_level_type
6797:
6798: FROM ZX_TRX_HEADERS_GT header,
6799: ZX_TRANSACTION_LINES_GT lines_gt
6800:
6801: WHERE lines_gt.application_id = header.application_id
6802: AND lines_gt.entity_code = header.entity_code
6803: AND lines_gt.event_class_code = header.event_class_code
7146: AND entity_code = header.related_doc_entity_code
7147: AND event_class_code = header.related_doc_event_class_code
7148: AND trx_id = header.related_doc_trx_id))
7149: AND ( NOT EXISTS
7150: (SELECT 1 FROM ZX_TRANSACTION_LINES_GT
7151: WHERE application_id = lines_gt.application_id
7152: AND entity_code = lines_gt.entity_code
7153: AND event_class_code = lines_gt.event_class_code
7154: AND trx_id = lines_gt.trx_id
7174: AND trx_id = lines_gt.ref_doc_trx_id
7175: AND trx_line_id = lines_gt.ref_doc_line_id
7176: AND trx_level_type = lines_gt.ref_doc_trx_level_type))
7177: AND ( NOT EXISTS
7178: (SELECT 1 FROM ZX_TRANSACTION_LINES_GT
7179: WHERE application_id = lines_gt.ref_doc_application_id
7180: AND entity_code = lines_gt.ref_doc_entity_code
7181: AND event_class_code = lines_gt.ref_doc_event_class_code
7182: AND trx_id = lines_gt.ref_doc_trx_id
7196: AND trx_id = lines_gt.applied_from_trx_id
7197: AND trx_line_id = lines_gt.applied_from_line_id
7198: AND trx_level_type = lines_gt.applied_from_trx_level_type))
7199: AND ( NOT EXISTS
7200: (SELECT 1 FROM ZX_TRANSACTION_LINES_GT
7201: WHERE application_id = lines_gt.applied_from_application_id
7202: AND entity_code = lines_gt.applied_from_entity_code
7203: AND event_class_code = lines_gt.applied_from_event_class_code
7204: AND trx_id = lines_gt.applied_from_trx_id
7218: AND trx_id = lines_gt.adjusted_doc_trx_id
7219: AND trx_line_id = lines_gt.adjusted_doc_line_id
7220: AND trx_level_type = lines_gt.adjusted_doc_trx_level_type))
7221: AND ( NOT EXISTS
7222: (SELECT 1 FROM ZX_TRANSACTION_LINES_GT
7223: WHERE application_id = lines_gt.adjusted_doc_application_id
7224: AND entity_code = lines_gt.adjusted_doc_entity_code
7225: AND event_class_code = lines_gt.adjusted_doc_event_class_code
7226: AND trx_id = lines_gt.adjusted_doc_trx_id
7244: AND trx_id = lines_gt.applied_to_trx_id
7245: AND trx_line_id = lines_gt.applied_to_trx_line_id
7246: AND trx_level_type = lines_gt.applied_to_trx_level_type))
7247: AND ( NOT EXISTS
7248: (SELECT 1 FROM ZX_TRANSACTION_LINES_GT
7249: WHERE application_id = lines_gt.applied_to_application_id
7250: AND entity_code = lines_gt.applied_to_entity_code
7251: AND event_class_code = lines_gt.applied_to_event_class_code
7252: AND trx_id = lines_gt.applied_to_trx_id
7282: AND line.trx_id = lines_gt.source_trx_id
7283: AND line.trx_line_id = lines_gt.source_line_id
7284: AND line.trx_level_type = lines_gt.source_trx_level_type))
7285: AND ( NOT EXISTS
7286: (SELECT 1 FROM ZX_TRANSACTION_LINES_GT line,
7287: zx_evnt_cls_mappings map
7288: WHERE lines_gt.application_id = map.application_id
7289: AND lines_gt.entity_code = map.entity_code
7290: AND lines_gt.event_class_code = map.event_class_code
7308: ELSE NULL END,
7309: NULL) ZX_SOURCE_DOC_MISSING
7310:
7311: FROM ZX_TRX_HEADERS_GT header,
7312: ZX_TRANSACTION_LINES_GT lines_gt
7313:
7314: WHERE lines_gt.application_id = header.application_id
7315: AND lines_gt.entity_code = header.entity_code
7316: AND lines_gt.event_class_code = header.event_class_code
7473: L.defaulting_attribute10
7474: -- L.input_tax_classification_code, --Bug 4919842
7475: -- L.output_tax_classification_code --Bug 4919842
7476: FROM ZX_TRX_HEADERS_GT H,
7477: ZX_TRANSACTION_LINES_GT L
7478: WHERE L.application_id = H.application_id
7479: AND L.entity_code = H.entity_code
7480: AND L.event_class_code = H.event_class_code
7481: AND L.trx_id = H.trx_id
7573: l_definforec := l_definforec_null;
7574:
7575: --
7576: -- populate fields in the record with values
7577: -- from zx_trx_headers_gt and zx_transaction_lines_gt
7578: --
7579: -- Bug#4310278- replace line_location_id with
7580: -- ref_doc columns
7581:
7655: END IF;
7656:
7657: --
7658: -- store returned tax classification code for update to
7659: -- zx_transaction_lines_gt later
7660: --
7661: l_input_tax_classif_code_tbl(i) := l_definforec.input_tax_classification_code;
7662: l_output_tax_classif_code_tbl(i) := l_definforec.output_tax_classification_code;
7663: -- END IF ; -- end if for the conditional call
7667: EXIT;
7668: END IF;
7669:
7670: --
7671: -- update zx_transaction_lines_gt with the default
7672: -- tax classification code found
7673: --
7674: IF (g_level_statement >= g_current_runtime_level ) THEN
7675: FND_LOG.STRING(g_level_statement,
7673: --
7674: IF (g_level_statement >= g_current_runtime_level ) THEN
7675: FND_LOG.STRING(g_level_statement,
7676: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.pop_def_tax_classif_code',
7677: 'update zx_transaction_lines_gt with the default tax classification code found ');
7678: END IF;
7679:
7680: FORALL i IN 1 .. l_count
7681: UPDATE ZX_TRANSACTION_LINES_GT
7677: 'update zx_transaction_lines_gt with the default tax classification code found ');
7678: END IF;
7679:
7680: FORALL i IN 1 .. l_count
7681: UPDATE ZX_TRANSACTION_LINES_GT
7682: SET input_tax_classification_code =
7683: l_input_tax_classif_code_tbl(i),
7684: output_tax_classification_code =
7685: l_output_tax_classif_code_tbl(i)
8153: INTERFACE_LINE_ID ,
8154: HISTORICAL_TAX_CODE_ID ,
8155: USER_UPD_DET_FACTORS_FLAG -- Bug 4703541
8156: FROM
8157: ZX_TRANSACTION_LINES_GT Lines,
8158: ZX_TRX_HEADERS_GT Header
8159:
8160: WHERE
8161:
8691:
8692: END IF;
8693:
8694: END LOOP;
8695: -- update zx_transaction_lines_gt with the default
8696: -- tax attributes found
8697:
8698: IF (g_level_statement >= g_current_runtime_level ) THEN
8699: FND_LOG.STRING(g_level_statement,
8697:
8698: IF (g_level_statement >= g_current_runtime_level ) THEN
8699: FND_LOG.STRING(g_level_statement,
8700: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',
8701: 'updating zx_transaction_lines_gt with tax attributes found');
8702: END IF;
8703:
8704: FORALL i IN 1..nvl(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INTERNAL_ORGANIZATION_ID.last,0)
8705:
8702: END IF;
8703:
8704: FORALL i IN 1..nvl(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INTERNAL_ORGANIZATION_ID.last,0)
8705:
8706: UPDATE /*+ INDEX (z,ZX_TRANSACTION_LINES_GT_U1) */ ZX_TRANSACTION_LINES_GT z
8707: SET trx_business_category =
8708: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_business_category(i),
8709: product_category =
8710: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.product_category(i),