eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_TDS_APPLICABILITY_DETM_PKG dependencies on ZX_TAXES_B

Line 5: p_tax_id IN zx_taxes_b.tax_id%TYPE,

1: PACKAGE BODY ZX_TDS_APPLICABILITY_DETM_PKG AS
2: /* $Header: zxditaxapplipkgb.pls 120.321.12020000.9 2013/03/21 17:51:50 smuthusa ship $ */
3:
4: PROCEDURE rule_base_pos_detm(
5: p_tax_id IN zx_taxes_b.tax_id%TYPE,
6: p_tax_determine_date IN DATE,
7: p_tax_service_type_code IN zx_rules_b.service_type_code%TYPE,
8: p_event_class_rec IN zx_api_pub.event_class_rec_type,
9: p_trx_line_index IN BINARY_INTEGER,

Line 27: p_tax_id IN zx_taxes_b.tax_id%TYPE,

23: p_effective_to IN zx_regimes_b.effective_to%TYPE,
24: x_return_status OUT NOCOPY VARCHAR2);
25:
26: FUNCTION is_tax_applicable(
27: p_tax_id IN zx_taxes_b.tax_id%TYPE,
28: p_tax_determine_date IN DATE,
29: p_applicability_rule_flag IN zx_taxes_b.applicability_rule_flag%TYPE,
30: p_event_class_rec IN zx_api_pub.event_class_rec_type,
31: p_trx_line_index IN BINARY_INTEGER,

Line 29: p_applicability_rule_flag IN zx_taxes_b.applicability_rule_flag%TYPE,

25:
26: FUNCTION is_tax_applicable(
27: p_tax_id IN zx_taxes_b.tax_id%TYPE,
28: p_tax_determine_date IN DATE,
29: p_applicability_rule_flag IN zx_taxes_b.applicability_rule_flag%TYPE,
30: p_event_class_rec IN zx_api_pub.event_class_rec_type,
31: p_trx_line_index IN BINARY_INTEGER,
32: p_applicable_by_default_flag IN zx_taxes_b.applicable_by_default_flag%TYPE,
33: x_applicability_result OUT NOCOPY VARCHAR2,

Line 32: p_applicable_by_default_flag IN zx_taxes_b.applicable_by_default_flag%TYPE,

28: p_tax_determine_date IN DATE,
29: p_applicability_rule_flag IN zx_taxes_b.applicability_rule_flag%TYPE,
30: p_event_class_rec IN zx_api_pub.event_class_rec_type,
31: p_trx_line_index IN BINARY_INTEGER,
32: p_applicable_by_default_flag IN zx_taxes_b.applicable_by_default_flag%TYPE,
33: x_applicability_result OUT NOCOPY VARCHAR2,
34: x_applicability_result_id OUT NOCOPY NUMBER,
35: x_return_status OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
36:

Line 38: p_tax_id IN zx_taxes_b.tax_id%TYPE,

34: x_applicability_result_id OUT NOCOPY NUMBER,
35: x_return_status OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
36:
37: FUNCTION is_direct_rate_applicable(
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,

Line 50: p_def_reg_type IN zx_taxes_b.def_registr_party_type_code%TYPE,

46: PROCEDURE populate_registration_info(
47: p_event_class_rec IN zx_api_pub.event_class_rec_type,
48: p_trx_line_index IN NUMBER,
49: p_rownum IN NUMBER,
50: p_def_reg_type IN zx_taxes_b.def_registr_party_type_code%TYPE,
51: p_reg_rule_flg IN zx_taxes_b.registration_type_rule_flag%TYPE,
52: p_tax_determine_date IN DATE,
53: x_return_status OUT NOCOPY VARCHAR2);
54:

Line 51: p_reg_rule_flg IN zx_taxes_b.registration_type_rule_flag%TYPE,

47: p_event_class_rec IN zx_api_pub.event_class_rec_type,
48: p_trx_line_index IN NUMBER,
49: p_rownum IN NUMBER,
50: p_def_reg_type IN zx_taxes_b.def_registr_party_type_code%TYPE,
51: p_reg_rule_flg IN zx_taxes_b.registration_type_rule_flag%TYPE,
52: p_tax_determine_date IN DATE,
53: x_return_status OUT NOCOPY VARCHAR2);
54:
55: -- Added for bug 4959835

Line 61: p_tax IN zx_taxes_b.tax%TYPE,

57: p_trx_line_index IN BINARY_INTEGER,
58: p_event_class_rec IN zx_api_pub.event_class_rec_type,
59: p_row_num IN NUMBER,
60: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
61: p_tax IN zx_taxes_b.tax%TYPE,
62: p_tax_date IN DATE,
63: p_tax_determine_date IN DATE,
64: p_tax_point_date IN DATE,
65: x_self_assessed_flag OUT NOCOPY zx_lines.self_assessed_flag%TYPE,

Line 854: p_tax_id IN zx_taxes_b.tax_id%TYPE,

850: -- x_applicability_result_id
851: -- x_return_status
852: ----------------------------------------------------------------------
853: FUNCTION is_tax_applicable (
854: p_tax_id IN zx_taxes_b.tax_id%TYPE,
855: p_tax_determine_date IN DATE,
856: p_applicability_rule_flag IN zx_taxes_b.applicability_rule_flag%TYPE,
857: p_event_class_rec IN zx_api_pub.event_class_rec_type,
858: p_trx_line_index IN BINARY_INTEGER,

Line 856: p_applicability_rule_flag IN zx_taxes_b.applicability_rule_flag%TYPE,

852: ----------------------------------------------------------------------
853: FUNCTION is_tax_applicable (
854: p_tax_id IN zx_taxes_b.tax_id%TYPE,
855: p_tax_determine_date IN DATE,
856: p_applicability_rule_flag IN zx_taxes_b.applicability_rule_flag%TYPE,
857: p_event_class_rec IN zx_api_pub.event_class_rec_type,
858: p_trx_line_index IN BINARY_INTEGER,
859: p_applicable_by_default_flag IN zx_taxes_b.applicable_by_default_flag%TYPE,
860: x_applicability_result OUT NOCOPY VARCHAR2,

Line 859: p_applicable_by_default_flag IN zx_taxes_b.applicable_by_default_flag%TYPE,

855: p_tax_determine_date IN DATE,
856: p_applicability_rule_flag IN zx_taxes_b.applicability_rule_flag%TYPE,
857: p_event_class_rec IN zx_api_pub.event_class_rec_type,
858: p_trx_line_index IN BINARY_INTEGER,
859: p_applicable_by_default_flag IN zx_taxes_b.applicable_by_default_flag%TYPE,
860: x_applicability_result OUT NOCOPY VARCHAR2,
861: x_applicability_result_id OUT NOCOPY NUMBER,
862: x_return_status OUT NOCOPY VARCHAR2) RETURN BOOLEAN IS
863:

Line 989: p_tax_id IN zx_taxes_b.tax_id%TYPE,

985: -- x_return_status
986: ----------------------------------------------------------------------
987:
988: FUNCTION is_direct_rate_applicable (
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,

Line 2326: l_place_of_supply_type_code zx_taxes_b.def_place_of_supply_type_code%TYPE;

2322: -- local varaibles
2323: --
2324: l_new_row_num NUMBER;
2325: l_place_of_supply VARCHAR2(30);
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;

Line 3657: l_applied_amt_handling_flag ZX_TAXES_B.APPLIED_AMT_HANDLING_FLAG%TYPE;

3653: l_begin_index BINARY_INTEGER;
3654: l_error_buffer VARCHAR2(200);
3655: l_line_amt_current NUMBER;
3656: l_status_rec ZX_TDS_UTILITIES_PKG.ZX_STATUS_INFO_REC;
3657: l_applied_amt_handling_flag ZX_TAXES_B.APPLIED_AMT_HANDLING_FLAG%TYPE;
3658:
3659: l_orig_amt NUMBER;
3660: l_appl_tax_amt NUMBER;
3661: l_appl_line_amt NUMBER;

Line 3749: FROM zx_taxes_b_tmp

3745: l_new_row_num).multiple_jurisdictions_flag :=
3746: tax_line_rec.multiple_jurisdictions_flag;
3747: BEGIN
3748: SELECT applied_amt_handling_flag INTO l_applied_amt_handling_flag
3749: FROM zx_taxes_b_tmp
3750: WHERE tax_id = tax_line_rec.tax_id;
3751:
3752: IF (g_level_procedure >= g_current_runtime_level ) THEN
3753: FND_LOG.STRING(g_level_procedure,

Line 4386: c_tax zx_taxes_b.tax%TYPE,

4382: -- Bug 5675944 : Retain tax_line_id for UPDATE
4383: -- Bug 7597449 Added Tax apportionment line number to pick the correct tax line id for upgraded invoices which have same regime-tax information.
4384: CURSOR get_key_columns_cur
4385: (c_tax_regime_code zx_regimes_b.tax_regime_code%TYPE,
4386: c_tax zx_taxes_b.tax%TYPE,
4387: c_apportionment_line_number zx_lines.tax_apportionment_line_number%type) IS
4388: SELECT * FROM zx_lines
4389: WHERE application_id = p_event_class_rec.application_id
4390: AND entity_code = p_event_class_rec.entity_code

Line 5180: p_tax_id IN zx_taxes_b.tax_id%TYPE,

5176:
5177: PROCEDURE get_place_of_supply (
5178: p_event_class_rec IN zx_api_pub.event_class_rec_type,
5179: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
5180: p_tax_id IN zx_taxes_b.tax_id%TYPE,
5181: p_tax IN zx_taxes_b.tax%TYPE,
5182: p_tax_determine_date IN DATE,
5183: p_def_place_of_supply_type_cd IN zx_taxes_b.def_place_of_supply_type_code%TYPE,
5184: p_place_of_supply_rule_flag IN zx_taxes_b.place_of_supply_rule_flag%TYPE,

Line 5181: p_tax IN zx_taxes_b.tax%TYPE,

5177: PROCEDURE get_place_of_supply (
5178: p_event_class_rec IN zx_api_pub.event_class_rec_type,
5179: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
5180: p_tax_id IN zx_taxes_b.tax_id%TYPE,
5181: p_tax IN zx_taxes_b.tax%TYPE,
5182: p_tax_determine_date IN DATE,
5183: p_def_place_of_supply_type_cd IN zx_taxes_b.def_place_of_supply_type_code%TYPE,
5184: p_place_of_supply_rule_flag IN zx_taxes_b.place_of_supply_rule_flag%TYPE,
5185: p_applicability_rule_flag IN zx_taxes_b.applicability_rule_flag%TYPE,

Line 5183: p_def_place_of_supply_type_cd IN zx_taxes_b.def_place_of_supply_type_code%TYPE,

5179: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
5180: p_tax_id IN zx_taxes_b.tax_id%TYPE,
5181: p_tax IN zx_taxes_b.tax%TYPE,
5182: p_tax_determine_date IN DATE,
5183: p_def_place_of_supply_type_cd IN zx_taxes_b.def_place_of_supply_type_code%TYPE,
5184: p_place_of_supply_rule_flag IN zx_taxes_b.place_of_supply_rule_flag%TYPE,
5185: p_applicability_rule_flag IN zx_taxes_b.applicability_rule_flag%TYPE,
5186: p_def_reg_type IN zx_taxes_b.def_registr_party_type_code%TYPE,
5187: p_reg_rule_flg IN zx_taxes_b.registration_type_rule_flag%TYPE,

Line 5184: p_place_of_supply_rule_flag IN zx_taxes_b.place_of_supply_rule_flag%TYPE,

5180: p_tax_id IN zx_taxes_b.tax_id%TYPE,
5181: p_tax IN zx_taxes_b.tax%TYPE,
5182: p_tax_determine_date IN DATE,
5183: p_def_place_of_supply_type_cd IN zx_taxes_b.def_place_of_supply_type_code%TYPE,
5184: p_place_of_supply_rule_flag IN zx_taxes_b.place_of_supply_rule_flag%TYPE,
5185: p_applicability_rule_flag IN zx_taxes_b.applicability_rule_flag%TYPE,
5186: p_def_reg_type IN zx_taxes_b.def_registr_party_type_code%TYPE,
5187: p_reg_rule_flg IN zx_taxes_b.registration_type_rule_flag%TYPE,
5188: p_trx_line_index IN BINARY_INTEGER,

Line 5185: p_applicability_rule_flag IN zx_taxes_b.applicability_rule_flag%TYPE,

5181: p_tax IN zx_taxes_b.tax%TYPE,
5182: p_tax_determine_date IN DATE,
5183: p_def_place_of_supply_type_cd IN zx_taxes_b.def_place_of_supply_type_code%TYPE,
5184: p_place_of_supply_rule_flag IN zx_taxes_b.place_of_supply_rule_flag%TYPE,
5185: p_applicability_rule_flag IN zx_taxes_b.applicability_rule_flag%TYPE,
5186: p_def_reg_type IN zx_taxes_b.def_registr_party_type_code%TYPE,
5187: p_reg_rule_flg IN zx_taxes_b.registration_type_rule_flag%TYPE,
5188: p_trx_line_index IN BINARY_INTEGER,
5189: p_direct_rate_result_id IN NUMBER,

Line 5186: p_def_reg_type IN zx_taxes_b.def_registr_party_type_code%TYPE,

5182: p_tax_determine_date IN DATE,
5183: p_def_place_of_supply_type_cd IN zx_taxes_b.def_place_of_supply_type_code%TYPE,
5184: p_place_of_supply_rule_flag IN zx_taxes_b.place_of_supply_rule_flag%TYPE,
5185: p_applicability_rule_flag IN zx_taxes_b.applicability_rule_flag%TYPE,
5186: p_def_reg_type IN zx_taxes_b.def_registr_party_type_code%TYPE,
5187: p_reg_rule_flg IN zx_taxes_b.registration_type_rule_flag%TYPE,
5188: p_trx_line_index IN BINARY_INTEGER,
5189: p_direct_rate_result_id IN NUMBER,
5190: x_jurisdiction_rec OUT NOCOPY ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type,

Line 5187: p_reg_rule_flg IN zx_taxes_b.registration_type_rule_flag%TYPE,

5183: p_def_place_of_supply_type_cd IN zx_taxes_b.def_place_of_supply_type_code%TYPE,
5184: p_place_of_supply_rule_flag IN zx_taxes_b.place_of_supply_rule_flag%TYPE,
5185: p_applicability_rule_flag IN zx_taxes_b.applicability_rule_flag%TYPE,
5186: p_def_reg_type IN zx_taxes_b.def_registr_party_type_code%TYPE,
5187: p_reg_rule_flg IN zx_taxes_b.registration_type_rule_flag%TYPE,
5188: p_trx_line_index IN BINARY_INTEGER,
5189: p_direct_rate_result_id IN NUMBER,
5190: x_jurisdiction_rec OUT NOCOPY ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type,
5191: x_jurisdictions_found OUT NOCOPY VARCHAR2,

Line 5192: x_place_of_supply_type_code OUT NOCOPY zx_taxes_b.def_place_of_supply_type_code%TYPE,

5188: p_trx_line_index IN BINARY_INTEGER,
5189: p_direct_rate_result_id IN NUMBER,
5190: x_jurisdiction_rec OUT NOCOPY ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type,
5191: x_jurisdictions_found OUT NOCOPY VARCHAR2,
5192: x_place_of_supply_type_code OUT NOCOPY zx_taxes_b.def_place_of_supply_type_code%TYPE,
5193: x_place_of_supply_result_id OUT NOCOPY NUMBER,
5194: x_return_status OUT NOCOPY VARCHAR2) IS
5195:
5196: l_location_id NUMBER;

Line 5207: l_pos_type zx_taxes_b.def_place_of_supply_type_code%TYPE;

5203: l_error_buffer VARCHAR2(256);
5204: l_structure_name varchar2(30);
5205: l_msg_count NUMBER;
5206: l_msg_data VARCHAR2(2000);
5207: l_pos_type zx_taxes_b.def_place_of_supply_type_code%TYPE;
5208:
5209: BEGIN
5210: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5211:

Line 5532: p_pos_type IN zx_taxes_b.def_place_of_supply_type_code%TYPE,

5528: --
5529: -- IN p_pos_type
5530:
5531: FUNCTION get_pos_parameter_name (
5532: p_pos_type IN zx_taxes_b.def_place_of_supply_type_code%TYPE,
5533: x_return_status OUT NOCOPY VARCHAR2
5534: ) RETURN VARCHAR2 IS
5535:
5536: l_loc_tbl VARCHAR2(30);

Line 5735: p_tax IN zx_taxes_b.tax%TYPE,

5731: p_structure_name IN VARCHAR2,
5732: p_structure_index IN BINARY_INTEGER,
5733: p_event_class_rec IN zx_api_pub.event_class_rec_type,
5734: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
5735: p_tax IN zx_taxes_b.tax%TYPE,
5736: p_tax_determine_date IN zx_lines.tax_determine_date%TYPE,
5737: p_jurisdiction_code IN zx_jurisdictions_b.tax_jurisdiction_code%TYPE,
5738: p_reg_party_type IN zx_taxes_b.def_registr_party_type_code%TYPE,
5739: x_registration_rec OUT NOCOPY zx_tcm_control_pkg.zx_registration_info_rec,

Line 5738: p_reg_party_type IN zx_taxes_b.def_registr_party_type_code%TYPE,

5734: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
5735: p_tax IN zx_taxes_b.tax%TYPE,
5736: p_tax_determine_date IN zx_lines.tax_determine_date%TYPE,
5737: p_jurisdiction_code IN zx_jurisdictions_b.tax_jurisdiction_code%TYPE,
5738: p_reg_party_type IN zx_taxes_b.def_registr_party_type_code%TYPE,
5739: x_registration_rec OUT NOCOPY zx_tcm_control_pkg.zx_registration_info_rec,
5740: x_return_status OUT NOCOPY VARCHAR2
5741: ) IS
5742:

Line 6113: p_tax_id IN zx_taxes_b.tax_id%TYPE,

6109:
6110: PROCEDURE get_tax_registration (
6111: p_event_class_rec IN zx_api_pub.event_class_rec_type,
6112: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
6113: p_tax_id IN zx_taxes_b.tax_id%TYPE,
6114: p_tax IN zx_taxes_b.tax%TYPE,
6115: p_tax_determine_date IN DATE,
6116: p_jurisdiction_code IN zx_jurisdictions_b.tax_jurisdiction_code%TYPE,
6117: p_def_reg_type IN zx_taxes_b.def_registr_party_type_code%TYPE,

Line 6114: p_tax IN zx_taxes_b.tax%TYPE,

6110: PROCEDURE get_tax_registration (
6111: p_event_class_rec IN zx_api_pub.event_class_rec_type,
6112: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
6113: p_tax_id IN zx_taxes_b.tax_id%TYPE,
6114: p_tax IN zx_taxes_b.tax%TYPE,
6115: p_tax_determine_date IN DATE,
6116: p_jurisdiction_code IN zx_jurisdictions_b.tax_jurisdiction_code%TYPE,
6117: p_def_reg_type IN zx_taxes_b.def_registr_party_type_code%TYPE,
6118: p_reg_rule_flg IN zx_taxes_b.registration_type_rule_flag%TYPE,

Line 6117: p_def_reg_type IN zx_taxes_b.def_registr_party_type_code%TYPE,

6113: p_tax_id IN zx_taxes_b.tax_id%TYPE,
6114: p_tax IN zx_taxes_b.tax%TYPE,
6115: p_tax_determine_date IN DATE,
6116: p_jurisdiction_code IN zx_jurisdictions_b.tax_jurisdiction_code%TYPE,
6117: p_def_reg_type IN zx_taxes_b.def_registr_party_type_code%TYPE,
6118: p_reg_rule_flg IN zx_taxes_b.registration_type_rule_flag%TYPE,
6119: p_trx_line_index IN BINARY_INTEGER,
6120: x_registration_number IN OUT NOCOPY zx_registrations.registration_number%TYPE,
6121: x_tax_inclusion_flag IN OUT NOCOPY zx_registrations.inclusive_tax_flag%TYPE,

Line 6118: p_reg_rule_flg IN zx_taxes_b.registration_type_rule_flag%TYPE,

6114: p_tax IN zx_taxes_b.tax%TYPE,
6115: p_tax_determine_date IN DATE,
6116: p_jurisdiction_code IN zx_jurisdictions_b.tax_jurisdiction_code%TYPE,
6117: p_def_reg_type IN zx_taxes_b.def_registr_party_type_code%TYPE,
6118: p_reg_rule_flg IN zx_taxes_b.registration_type_rule_flag%TYPE,
6119: p_trx_line_index IN BINARY_INTEGER,
6120: x_registration_number IN OUT NOCOPY zx_registrations.registration_number%TYPE,
6121: x_tax_inclusion_flag IN OUT NOCOPY zx_registrations.inclusive_tax_flag%TYPE,
6122: x_self_assessment_flg IN OUT NOCOPY zx_registrations.self_assess_flag%TYPE,

Line 6125: x_registration_party_type OUT NOCOPY zx_taxes_b.def_registr_party_type_code%TYPE,

6121: x_tax_inclusion_flag IN OUT NOCOPY zx_registrations.inclusive_tax_flag%TYPE,
6122: x_self_assessment_flg IN OUT NOCOPY zx_registrations.self_assess_flag%TYPE,
6123: x_tax_registration_result_id OUT NOCOPY NUMBER,
6124: x_rounding_rule_code OUT NOCOPY zx_registrations.rounding_rule_code%TYPE,
6125: x_registration_party_type OUT NOCOPY zx_taxes_b.def_registr_party_type_code%TYPE,
6126: x_return_status OUT NOCOPY VARCHAR2) IS
6127:
6128: l_reg_party_type zx_taxes_b.def_registr_party_type_code%TYPE;
6129: l_reg_party_prof_id zx_party_tax_profile.party_tax_profile_id%TYPE;

Line 6128: l_reg_party_type zx_taxes_b.def_registr_party_type_code%TYPE;

6124: x_rounding_rule_code OUT NOCOPY zx_registrations.rounding_rule_code%TYPE,
6125: x_registration_party_type OUT NOCOPY zx_taxes_b.def_registr_party_type_code%TYPE,
6126: x_return_status OUT NOCOPY VARCHAR2) IS
6127:
6128: l_reg_party_type zx_taxes_b.def_registr_party_type_code%TYPE;
6129: l_reg_party_prof_id zx_party_tax_profile.party_tax_profile_id%TYPE;
6130:
6131: l_registration_rec zx_tcm_control_pkg.zx_registration_info_rec;
6132: l_tax_service_type_code zx_rules_b.service_type_code%TYPE;

Line 6571: p_tax_id IN zx_taxes_b.tax_id%type,

6567: -- p_trx_line_index
6568: -- p_tax_determine_date
6569:
6570: PROCEDURE rule_base_pos_detm (
6571: p_tax_id IN zx_taxes_b.tax_id%type,
6572: p_tax_determine_date IN DATE,
6573: p_tax_service_type_code IN zx_rules_b.service_type_code%type,
6574: p_event_class_rec IN zx_api_pub.event_class_rec_type,
6575: p_trx_line_index IN BINARY_INTEGER,

Line 6664: p_def_reg_type IN zx_taxes_b.def_registr_party_type_code%TYPE,

6660: PROCEDURE populate_registration_info(
6661: p_event_class_rec IN zx_api_pub.event_class_rec_type,
6662: p_trx_line_index IN NUMBER,
6663: p_rownum IN NUMBER,
6664: p_def_reg_type IN zx_taxes_b.def_registr_party_type_code%TYPE,
6665: p_reg_rule_flg IN zx_taxes_b.registration_type_rule_flag%TYPE,
6666: p_tax_determine_date IN DATE,
6667: x_return_status OUT NOCOPY VARCHAR2) IS
6668:

Line 6665: p_reg_rule_flg IN zx_taxes_b.registration_type_rule_flag%TYPE,

6661: p_event_class_rec IN zx_api_pub.event_class_rec_type,
6662: p_trx_line_index IN NUMBER,
6663: p_rownum IN NUMBER,
6664: p_def_reg_type IN zx_taxes_b.def_registr_party_type_code%TYPE,
6665: p_reg_rule_flg IN zx_taxes_b.registration_type_rule_flag%TYPE,
6666: p_tax_determine_date IN DATE,
6667: x_return_status OUT NOCOPY VARCHAR2) IS
6668:
6669: -- get def_registr_party_type_code and registration_type_rule_flag

Line 6674: FROM ZX_TAXES_B

6670: --
6671: CURSOR get_reg_type_and_rule_flg_cur(p_tax_id NUMBER) IS
6672: SELECT def_registr_party_type_code,
6673: registration_type_rule_flag
6674: FROM ZX_TAXES_B
6675: WHERE tax_id = p_tax_id;
6676:
6677: l_def_reg_type zx_taxes_b.def_registr_party_type_code%TYPE;
6678: l_reg_rule_flg zx_taxes_b.registration_type_rule_flag%TYPE;

Line 6677: l_def_reg_type zx_taxes_b.def_registr_party_type_code%TYPE;

6673: registration_type_rule_flag
6674: FROM ZX_TAXES_B
6675: WHERE tax_id = p_tax_id;
6676:
6677: l_def_reg_type zx_taxes_b.def_registr_party_type_code%TYPE;
6678: l_reg_rule_flg zx_taxes_b.registration_type_rule_flag%TYPE;
6679:
6680: l_tax_id NUMBER;
6681: l_error_buffer VARCHAR2(200);

Line 6678: l_reg_rule_flg zx_taxes_b.registration_type_rule_flag%TYPE;

6674: FROM ZX_TAXES_B
6675: WHERE tax_id = p_tax_id;
6676:
6677: l_def_reg_type zx_taxes_b.def_registr_party_type_code%TYPE;
6678: l_reg_rule_flg zx_taxes_b.registration_type_rule_flag%TYPE;
6679:
6680: l_tax_id NUMBER;
6681: l_error_buffer VARCHAR2(200);
6682: l_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;

Line 7668: l_tax zx_taxes_b.tax%TYPE;

7664: l_rownum BINARY_INTEGER;
7665: l_error_buffer VARCHAR2(200);
7666: l_tax_regime_code zx_regimes_b.tax_regime_code%TYPE;
7667: l_tax_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;
7668: l_tax zx_taxes_b.tax%TYPE;
7669: l_tax_status_code zx_status_b.tax_status_code%TYPE;
7670: l_record_type_code zx_rates_b.record_type_code%TYPE;
7671: l_offset_tax_rate_code zx_rates_b.offset_tax_rate_code%TYPE;
7672: l_tax_found_in_ap_flag VARCHAR2(1);

Line 8718: c_tax IN zx_taxes_b.tax%TYPE,

8714: ORDER BY precedence_level;
8715:
8716:
8717: CURSOR get_tax_info_csr(c_tax_regime_code IN ZX_REGIMES_B.tax_regime_code%TYPE,
8718: c_tax IN zx_taxes_b.tax%TYPE,
8719: c_tax_determine_date IN DATE) IS
8720: SELECT tax_id,
8721: tax,
8722: tax_regime_code,

Line 8800: l_place_of_supply_type_code zx_taxes_b.def_place_of_supply_type_code%TYPE;

8796: l_tax_class zx_rates_b.tax_class%TYPE;
8797: l_temp_num NUMBER;
8798: l_jurisdictions_found VARCHAR2(1);
8799: l_jurisdiction_rec ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type;
8800: l_place_of_supply_type_code zx_taxes_b.def_place_of_supply_type_code%TYPE;
8801: l_place_of_supply_result_id NUMBER;
8802: l_begin_index BINARY_INTEGER;
8803: l_end_index BINARY_INTEGER;
8804: l_regimerownum BINARY_INTEGER;

Line 10188: p_tax IN zx_taxes_b.tax%TYPE,

10184: p_trx_line_index IN BINARY_INTEGER,
10185: p_event_class_rec IN zx_api_pub.event_class_rec_type,
10186: p_row_num IN NUMBER,
10187: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
10188: p_tax IN zx_taxes_b.tax%TYPE,
10189: p_tax_date IN DATE,
10190: p_tax_determine_date IN DATE,
10191: p_tax_point_date IN DATE,
10192: x_self_assessed_flag OUT NOCOPY zx_lines.self_assessed_flag%TYPE,