DBA Data[Home] [Help]

APPS.ZX_VALID_INIT_PARAMS_PKG dependencies on ZX_LINES_DET_FACTORS

Line 488: FROM ZX_LINES_DET_FACTORS

484: ELSIF ZX_API_PUB.G_DATA_TRANSFER_MODE = 'WIN' OR
485: ZX_API_PUB.G_PUB_SRVC in ('VALIDATE_DOCUMENT_FOR_TAX','OVERRIDE_TAX') THEN
486: SELECT adjusted_doc_date
487: INTO l_adj_doc_date
488: FROM ZX_LINES_DET_FACTORS
489: WHERE application_id = p_event_class_rec.application_id
490: AND entity_code = p_event_class_rec.entity_code
491: AND event_class_code = p_event_class_rec.event_class_code
492: AND trx_id = p_event_class_rec.trx_id

Line 522: 'No lines exist in zx_transaction_lines_gt/zx_lines_det_factors'||

518: WHEN OTHERS THEN
519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
520: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
521: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,
522: 'No lines exist in zx_transaction_lines_gt/zx_lines_det_factors'||
523: ' which is incorrect or the event information in headers and lines is incorrect.'||
524: SQLERRM);
525: END IF;
526: END determine_effective_date;

Line 691: zx_lines_det_factors det

687: OR (ZX_API_PUB.G_PUB_SRVC ='DETERMINE_RECOVERY') THEN
688: SELECT opt.process_for_applicability_flag
689: INTO p_event_class_rec.source_process_for_appl_flag
690: FROM zx_evnt_cls_options opt,
691: zx_lines_det_factors det
692: WHERE opt.application_id = det.source_application_id
693: AND opt.entity_code = det.source_entity_code
694: AND opt.event_class_code = det.source_event_class_code
695: AND opt.first_pty_org_id = p_event_class_rec.first_pty_org_id

Line 1468: zx_lines_det_factors det

1464: INTO p_event_class_rec.source_event_class_mapping_id,
1465: p_event_class_rec.source_tax_event_class_code,
1466: p_event_class_rec.source_process_for_appl_flag
1467: FROM zx_evnt_cls_mappings mapp,
1468: zx_lines_det_factors det
1469: WHERE mapp.application_id = det.source_application_id
1470: AND mapp.entity_code = det.source_entity_code
1471: AND mapp.event_class_code = det.source_event_class_code
1472: AND det.trx_id = p_event_class_rec.trx_id

Line 1740: FROM ZX_LINES_DET_FACTORS

1736: l_related_doc_date,
1737: l_adjusted_doc_date,
1738: l_trx_date,
1739: l_prov_tax_det_date
1740: FROM ZX_LINES_DET_FACTORS
1741: WHERE application_id = p_event_class_rec.application_id
1742: AND entity_code = p_event_class_rec.entity_code
1743: AND event_class_code = p_event_class_rec.event_class_code
1744: AND trx_id = p_event_class_rec.trx_id

Line 1781: FROM ZX_LINES_DET_FACTORS

1777: l_related_doc_date,
1778: l_adjusted_doc_date,
1779: l_trx_date,
1780: l_prov_tax_det_date
1781: FROM ZX_LINES_DET_FACTORS
1782: WHERE application_id = p_event_class_rec.application_id
1783: AND entity_code = p_event_class_rec.entity_code
1784: AND event_class_code = p_event_class_rec.event_class_code
1785: AND trx_id = p_event_class_rec.trx_id

Line 1893: FROM ZX_LINES_DET_FACTORS

1889: l_related_doc_date,
1890: l_adjusted_doc_date,
1891: l_trx_date,
1892: l_prov_tax_det_date
1893: FROM ZX_LINES_DET_FACTORS
1894: WHERE application_id = p_application_id
1895: AND entity_code = p_entity_code
1896: AND event_class_code = p_event_class_code
1897: AND trx_id = p_trx_id

Line 1934: FROM ZX_LINES_DET_FACTORS

1930: l_related_doc_date,
1931: l_adjusted_doc_date,
1932: l_trx_date,
1933: l_prov_tax_det_date
1934: FROM ZX_LINES_DET_FACTORS
1935: WHERE application_id = p_application_id
1936: AND entity_code = p_entity_code
1937: AND event_class_code = p_event_class_code
1938: AND trx_id = p_trx_id

Line 2044: ZX_LINES_DET_FACTORS zl

2040: l_event_class_code,
2041: l_trx_id
2042: FROM ZX_REV_TRX_HEADERS_GT hdrgt,
2043: ZX_REVERSE_TRX_LINES_GT lngt,
2044: ZX_LINES_DET_FACTORS zl
2045: WHERE hdrgt.reversing_appln_id = p_event_class_rec.application_id
2046: AND hdrgt.reversing_entity_code = p_event_class_rec.entity_code
2047: AND hdrgt.reversing_evnt_cls_code = p_event_class_rec.event_class_code
2048: AND hdrgt.reversing_trx_id = p_event_class_rec.trx_id

Line 2109: ZX_LINES_DET_FACTORS zl

2105: l_event_class_code,
2106: l_trx_id
2107: FROM ZX_REV_TRX_HEADERS_GT hdrgt,
2108: ZX_REVERSE_TRX_LINES_GT lngt,
2109: ZX_LINES_DET_FACTORS zl
2110: WHERE hdrgt.reversing_appln_id = p_event_class_rec.application_id
2111: AND hdrgt.reversing_entity_code = p_event_class_rec.entity_code
2112: AND hdrgt.reversing_evnt_cls_code = p_event_class_rec.event_class_code
2113: AND hdrgt.reversing_trx_id = p_event_class_rec.trx_id

Line 2359: | rounding parties are already available in zx_lines_det_factors. |

2355:
2356: /* ----------------------------------------------------------------------+
2357: | The below logic needs not be executed for calculate tax called by |
2358: | products uptaking the determining factors UI since the values of |
2359: | rounding parties are already available in zx_lines_det_factors. |
2360: + ----------------------------------------------------------------------*/
2361:
2362: /* ----------------------------------------------------------------------+
2363: | Get the locations for parties and their ptp ids |

Line 3595: FROM ZX_LINES_DET_FACTORS

3591: PROVNL_TAX_DETERMINATION_DATE
3592: INTO p_event_class_rec.REL_DOC_DATE,
3593: p_event_class_rec.TRX_DATE ,
3594: p_event_class_rec.PROVNL_TAX_DETERMINATION_DATE
3595: FROM ZX_LINES_DET_FACTORS
3596: WHERE APPLICATION_ID = p_trx_rec.APPLICATION_ID
3597: AND EVENT_CLASS_CODE = p_trx_rec.EVENT_CLASS_CODE
3598: AND ENTITY_CODE = p_trx_rec.ENTITY_CODE
3599: AND TRX_ID = p_trx_rec.TRX_ID