DBA Data[Home] [Help]

APPS.ZX_TRL_PUB_PKG dependencies on ZX_LINES_SUMMARY

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

132:
133: ELSE --p_event_class_rec.summarization_flag = 'Y'
134:
135: -- Preserve old summary_tax_line_id in g_detail_tax_lines_gt (for UPDATE
136: -- case) if the same summarization criteria exist in zx_lines_summary
137: --
138: IF p_event_class_rec.retain_summ_tax_line_id_flag = 'Y' THEN
139:
140: ZX_TRL_MANAGE_TAX_PKG.update_exist_summary_line_id (

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

405:
406: ELSE --p_event_class_rec.summarization_flag = 'Y'
407:
408: -- Preserve old summary_tax_line_id in g_detail_tax_lines_gt (for UPDATE
409: -- case) if the same summarization criteria exist in zx_lines_summary
410: --
411: IF p_event_class_rec.retain_summ_tax_line_id_flag = 'Y' THEN
412:
413: ZX_TRL_MANAGE_TAX_PKG.update_exist_summary_line_id (

Line 1258: DELETE FROM zx_lines_summary

1254: -- for current phase, just delete all the summary tax lines
1255: -- for this transaction and recreate
1256:
1257: -- delete the summary tax lines for the transaction
1258: DELETE FROM zx_lines_summary
1259: WHERE application_id = p_application_id
1260: AND entity_code = p_entity_code
1261: AND event_class_code = p_event_class_code
1262: AND trx_id = p_trx_id;