DBA Data[Home] [Help]

APPS.ZX_VALID_INIT_PARAMS_PKG dependencies on ZX_LINES_DET_FACTORS

Line 493: FROM ZX_LINES_DET_FACTORS

489: SELECT adjusted_doc_date,
490: trx_line_date --Bug 13547362
491: INTO l_adj_doc_date,
492: l_trx_line_date
493: FROM ZX_LINES_DET_FACTORS
494: WHERE application_id = p_event_class_rec.application_id
495: AND entity_code = p_event_class_rec.entity_code
496: AND event_class_code = p_event_class_rec.event_class_code
497: AND trx_id = p_event_class_rec.trx_id

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

525: WHEN OTHERS THEN
526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
527: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
528: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,
529: 'No lines exist in zx_transaction_lines_gt/zx_lines_det_factors'||
530: ' which is incorrect or the event information in headers and lines is incorrect.'||
531: SQLERRM);
532: END IF;
533: END determine_effective_date;

Line 698: zx_lines_det_factors det

694: OR (ZX_API_PUB.G_PUB_SRVC ='DETERMINE_RECOVERY') THEN
695: SELECT opt.process_for_applicability_flag
696: INTO p_event_class_rec.source_process_for_appl_flag
697: FROM zx_evnt_cls_options opt,
698: zx_lines_det_factors det
699: WHERE opt.application_id = det.source_application_id
700: AND opt.entity_code = det.source_entity_code
701: AND opt.event_class_code = det.source_event_class_code
702: AND opt.first_pty_org_id = p_event_class_rec.first_pty_org_id

Line 1490: zx_lines_det_factors det

1486: INTO p_event_class_rec.source_event_class_mapping_id,
1487: p_event_class_rec.source_tax_event_class_code,
1488: p_event_class_rec.source_process_for_appl_flag
1489: FROM zx_evnt_cls_mappings mapp,
1490: zx_lines_det_factors det
1491: WHERE mapp.application_id = det.source_application_id
1492: AND mapp.entity_code = det.source_entity_code
1493: AND mapp.event_class_code = det.source_event_class_code
1494: AND det.trx_id = p_event_class_rec.trx_id

Line 1765: FROM ZX_LINES_DET_FACTORS

1761: l_adjusted_doc_date,
1762: l_trx_date,
1763: l_trx_line_date,
1764: l_prov_tax_det_date
1765: FROM ZX_LINES_DET_FACTORS
1766: WHERE application_id = p_event_class_rec.application_id
1767: AND entity_code = p_event_class_rec.entity_code
1768: AND event_class_code = p_event_class_rec.event_class_code
1769: AND trx_id = p_event_class_rec.trx_id

Line 1808: FROM ZX_LINES_DET_FACTORS

1804: l_adjusted_doc_date,
1805: l_trx_date,
1806: l_trx_line_date,
1807: l_prov_tax_det_date
1808: FROM ZX_LINES_DET_FACTORS
1809: WHERE application_id = p_event_class_rec.application_id
1810: AND entity_code = p_event_class_rec.entity_code
1811: AND event_class_code = p_event_class_rec.event_class_code
1812: AND trx_id = p_event_class_rec.trx_id

Line 1920: FROM ZX_LINES_DET_FACTORS

1916: l_related_doc_date,
1917: l_adjusted_doc_date,
1918: l_trx_date,
1919: l_prov_tax_det_date
1920: FROM ZX_LINES_DET_FACTORS
1921: WHERE application_id = p_application_id
1922: AND entity_code = p_entity_code
1923: AND event_class_code = p_event_class_code
1924: AND trx_id = p_trx_id

Line 1961: FROM ZX_LINES_DET_FACTORS

1957: l_related_doc_date,
1958: l_adjusted_doc_date,
1959: l_trx_date,
1960: l_prov_tax_det_date
1961: FROM ZX_LINES_DET_FACTORS
1962: WHERE application_id = p_application_id
1963: AND entity_code = p_entity_code
1964: AND event_class_code = p_event_class_code
1965: AND trx_id = p_trx_id

Line 2071: ZX_LINES_DET_FACTORS zl

2067: l_event_class_code,
2068: l_trx_id
2069: FROM ZX_REV_TRX_HEADERS_GT hdrgt,
2070: ZX_REVERSE_TRX_LINES_GT lngt,
2071: ZX_LINES_DET_FACTORS zl
2072: WHERE hdrgt.reversing_appln_id = p_event_class_rec.application_id
2073: AND hdrgt.reversing_entity_code = p_event_class_rec.entity_code
2074: AND hdrgt.reversing_evnt_cls_code = p_event_class_rec.event_class_code
2075: AND hdrgt.reversing_trx_id = p_event_class_rec.trx_id

Line 2136: ZX_LINES_DET_FACTORS zl

2132: l_event_class_code,
2133: l_trx_id
2134: FROM ZX_REV_TRX_HEADERS_GT hdrgt,
2135: ZX_REVERSE_TRX_LINES_GT lngt,
2136: ZX_LINES_DET_FACTORS zl
2137: WHERE hdrgt.reversing_appln_id = p_event_class_rec.application_id
2138: AND hdrgt.reversing_entity_code = p_event_class_rec.entity_code
2139: AND hdrgt.reversing_evnt_cls_code = p_event_class_rec.event_class_code
2140: AND hdrgt.reversing_trx_id = p_event_class_rec.trx_id

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

2382:
2383: /* ----------------------------------------------------------------------+
2384: | The below logic needs not be executed for calculate tax called by |
2385: | products uptaking the determining factors UI since the values of |
2386: | rounding parties are already available in zx_lines_det_factors. |
2387: + ----------------------------------------------------------------------*/
2388:
2389: /* ----------------------------------------------------------------------+
2390: | Get the locations for parties and their ptp ids |

Line 3622: FROM ZX_LINES_DET_FACTORS

3618: PROVNL_TAX_DETERMINATION_DATE
3619: INTO p_event_class_rec.REL_DOC_DATE,
3620: p_event_class_rec.TRX_DATE ,
3621: p_event_class_rec.PROVNL_TAX_DETERMINATION_DATE
3622: FROM ZX_LINES_DET_FACTORS
3623: WHERE APPLICATION_ID = p_trx_rec.APPLICATION_ID
3624: AND EVENT_CLASS_CODE = p_trx_rec.EVENT_CLASS_CODE
3625: AND ENTITY_CODE = p_trx_rec.ENTITY_CODE
3626: AND TRX_ID = p_trx_rec.TRX_ID