[Home] [Help]
38: p_tax_id IN zx_taxes_b.tax_id%TYPE,
39: p_tax_determine_date IN DATE,
40: p_event_class_rec IN zx_api_pub.event_class_rec_type,
41: p_trx_line_index IN BINARY_INTEGER,
42: x_direct_rate_result_rec OUT NOCOPY zx_process_results%ROWTYPE,
43: x_direct_rate_result_id OUT NOCOPY NUMBER,
44: x_return_status OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
45:
46: PROCEDURE populate_registration_info(
989: p_tax_id IN zx_taxes_b.tax_id%TYPE,
990: p_tax_determine_date IN DATE,
991: p_event_class_rec IN zx_api_pub.event_class_rec_type,
992: p_trx_line_index IN BINARY_INTEGER,
993: x_direct_rate_result_rec OUT NOCOPY zx_process_results%ROWTYPE,
994: x_direct_rate_result_id OUT NOCOPY NUMBER,
995: x_return_status OUT NOCOPY VARCHAR2) RETURN BOOLEAN IS
996:
997: l_tax_service_type_code zx_rules_b.service_type_code%TYPE;
2268: l_place_of_supply_type_code zx_taxes_b.def_place_of_supply_type_code%TYPE;
2269: l_place_of_supply_result_id NUMBER;
2270: l_applicability_result_id NUMBER;
2271:
2272: l_applicability_result zx_process_results.alphanumeric_result%TYPE;
2273:
2274: l_direct_rate_result_id NUMBER;
2275:
2276: l_direct_rate_result_rec zx_process_results%ROWTYPE;
2272: l_applicability_result zx_process_results.alphanumeric_result%TYPE;
2273:
2274: l_direct_rate_result_id NUMBER;
2275:
2276: l_direct_rate_result_rec zx_process_results%ROWTYPE;
2277: l_tax_applicable BOOLEAN;
2278:
2279: /* Commented out as part of restructuring for STCC (bug 4959835)
2280: l_last_manual_entry zx_lines.last_manual_entry%TYPE;
6078: x_alphanumeric_result OUT NOCOPY VARCHAR2,
6079: x_result_id OUT NOCOPY NUMBER,
6080: x_return_status OUT NOCOPY VARCHAR2 ) IS
6081:
6082: l_tax_result_rec zx_process_results%ROWTYPE;
6083: l_error_buffer VARCHAR2(2000);
6084: l_structure_name VARCHAR2(30);
6085:
6086: BEGIN
7964: pr.condition_set_id,
7965: pr.exception_set_id,
7966: pr.result_id,
7967: 1 query_num
7968: FROM ZX_PROCESS_RESULTS pr,
7969: ZX_SCO_RULES_B_V rl
7970: --ZX_SCO_RATES_B_V rt
7971: WHERE (pr.CONDITION_GROUP_CODE = c_condition_group_code or
7972: pr.CONDITION_GROUP_CODE like c_condition_group_code ||'~'||'%')
8154: l_tbl_index BINARY_INTEGER;
8155: l_rate_exists_same_prod_family BOOLEAN;
8156: l_tax_applicable BOOLEAN;
8157: l_applicability_result_id NUMBER;
8158: l_applicability_result zx_process_results.alphanumeric_result%TYPE;
8159: l_exception_rate zx_lines.exception_rate%TYPE;
8160:
8161: BEGIN
8162: