2404: p_error_buffer OUT NOCOPY VARCHAR2) is
2405:
2406: cursor loc_qualifier_csr(c_trx_date DATE) is
2407: select lookup_code
2408: from ar_lookups
2409: where LOOKUP_TYPE = 'ARTAXVDR_LOC_QUALIFIER'
2410: and enabled_flag = 'Y'
2411: and trunc(c_trx_date) between
2412: trunc(start_date_active) and
2424: l_exception_result BOOLEAN;
2425:
2426: l_total_lines NUMBER;
2427:
2428: TYPE qualifier_tbl_type is TABLE of ar_lookups.lookup_code%TYPE index by binary_integer;
2429: l_qualifier_tbl qualifier_tbl_type;
2430: l_code_tax_type VARCHAR2(30);
2431: l_lookup_code ar_lookups.lookup_code%TYPE;
2432: l_tax_compiled_constraint VARCHAR2(2000);
2427:
2428: TYPE qualifier_tbl_type is TABLE of ar_lookups.lookup_code%TYPE index by binary_integer;
2429: l_qualifier_tbl qualifier_tbl_type;
2430: l_code_tax_type VARCHAR2(30);
2431: l_lookup_code ar_lookups.lookup_code%TYPE;
2432: l_tax_compiled_constraint VARCHAR2(2000);
2433: l_tax_compiled_condition VARCHAR2(2000);
2434: l_tax_compiled_exception VARCHAR2(2000);
2435: l_true_compiled_action VARCHAR2(4000);