DBA Data[Home] [Help]

APPS.ZX_TRL_PUB_PKG dependencies on ZX_LINES_SUMMARY

Line 141: -- case) if the same summarization criteria exist in zx_lines_summary

137:
138: ELSE --p_event_class_rec.summarization_flag = 'Y'
139:
140: -- Preserve old summary_tax_line_id in g_detail_tax_lines_gt (for UPDATE
141: -- case) if the same summarization criteria exist in zx_lines_summary
142: --
143: IF p_event_class_rec.retain_summ_tax_line_id_flag = 'Y' THEN
144:
145: ZX_TRL_MANAGE_TAX_PKG.update_exist_summary_line_id (

Line 414: -- case) if the same summarization criteria exist in zx_lines_summary

410:
411: ELSE --p_event_class_rec.summarization_flag = 'Y'
412:
413: -- Preserve old summary_tax_line_id in g_detail_tax_lines_gt (for UPDATE
414: -- case) if the same summarization criteria exist in zx_lines_summary
415: --
416: IF p_event_class_rec.retain_summ_tax_line_id_flag = 'Y' THEN
417:
418: ZX_TRL_MANAGE_TAX_PKG.update_exist_summary_line_id (

Line 1279: DELETE FROM zx_lines_summary

1275: -- for current phase, just delete all the summary tax lines
1276: -- for this transaction and recreate
1277:
1278: -- delete the summary tax lines for the transaction
1279: DELETE FROM zx_lines_summary
1280: WHERE application_id = p_application_id
1281: AND entity_code = p_entity_code
1282: AND event_class_code = p_event_class_code
1283: AND trx_id = p_trx_id;