[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;
2326: l_place_of_supply_type_code zx_taxes_b.def_place_of_supply_type_code%TYPE;
2327: l_place_of_supply_result_id NUMBER;
2328: l_applicability_result_id NUMBER;
2329:
2330: l_applicability_result zx_process_results.alphanumeric_result%TYPE;
2331:
2332: l_direct_rate_result_id NUMBER;
2333:
2334: l_direct_rate_result_rec zx_process_results%ROWTYPE;
2330: l_applicability_result zx_process_results.alphanumeric_result%TYPE;
2331:
2332: l_direct_rate_result_id NUMBER;
2333:
2334: l_direct_rate_result_rec zx_process_results%ROWTYPE;
2335: l_tax_applicable BOOLEAN;
2336:
2337: /* Commented out as part of restructuring for STCC (bug 4959835)
2338: l_last_manual_entry zx_lines.last_manual_entry%TYPE;
6576: x_alphanumeric_result OUT NOCOPY VARCHAR2,
6577: x_result_id OUT NOCOPY NUMBER,
6578: x_return_status OUT NOCOPY VARCHAR2 ) IS
6579:
6580: l_tax_result_rec zx_process_results%ROWTYPE;
6581: l_error_buffer VARCHAR2(2000);
6582: l_structure_name VARCHAR2(30);
6583:
6584: BEGIN
8611: pr.exception_set_id,
8612: pr.result_id,
8613: 1 query_num,
8614: tax.compounding_precedence
8615: FROM ZX_PROCESS_RESULTS pr,
8616: ZX_SCO_RULES_B_V rl,
8617: ZX_SCO_TAXES_B_V tax
8618: --ZX_SCO_RATES_B_V rt
8619: WHERE (pr.CONDITION_GROUP_CODE in (c_condition_group_code
8816: l_tbl_index BINARY_INTEGER;
8817: l_rate_exists_same_prod_family BOOLEAN;
8818: l_tax_applicable BOOLEAN;
8819: l_applicability_result_id NUMBER;
8820: l_applicability_result zx_process_results.alphanumeric_result%TYPE;
8821: l_exception_rate zx_lines.exception_rate%TYPE;
8822:
8823: -- Added for Bug 10184087
8824: l_ref_doc_tax_applicable BOOLEAN;