315: l_return_status VARCHAR2(1000);
316: l_msg_count NUMBER;
317: l_msg_data VARCHAR2(1000);
318: l_tax_line_id NUMBER;
319: l_tax_reporting_flag ZX_EVNT_CLS_MAPPINGS.tax_reporting_flag%TYPE;
320: l_report_status_tracking ZX_LINES.legal_reporting_status%TYPE;
321: l_offset_tax_rate_code VARCHAR2(100);
322: l_offset_flag VARCHAR2(10);
323: l_offset_tax_flag VARCHAR2(100);
358: END IF;
359:
360: BEGIN
361: select tax_reporting_flag into l_tax_reporting_flag
362: from zx_evnt_cls_mappings
363: where entity_code = p_entity_code
364: and event_class_code = p_event_class_code
365: and application_id = p_application_id;
366: EXCEPTION WHEN NO_DATA_FOUND THEN
3676: EXCEPTION
3677: WHEN NO_DATA_FOUND THEN
3678: SELECT CTRL_EFF_OVRD_CALC_LINES_FLAG
3679: INTO l_ctrl_ef_ov_cal_line_flag
3680: FROM ZX_EVNT_CLS_MAPPINGS
3681: WHERE EVENT_CLASS_CODE = p_event_class_code
3682: AND APPLICATION_ID = p_application_id
3683: AND ENTITY_CODE = p_entity_code;
3684: