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.260.12010000.9 2009/02/05 14:33:21 tsen 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 2268: l_place_of_supply_type_code zx_taxes_b.def_place_of_supply_type_code%TYPE;

2264: -- local varaibles
2265: --
2266: l_new_row_num NUMBER;
2267: l_place_of_supply VARCHAR2(30);
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;

Line 3505: l_applied_amt_handling_flag ZX_TAXES_B.APPLIED_AMT_HANDLING_FLAG%TYPE;

3501: l_begin_index BINARY_INTEGER;
3502: l_error_buffer VARCHAR2(200);
3503: l_line_amt_current NUMBER;
3504: l_status_rec ZX_TDS_UTILITIES_PKG.ZX_STATUS_INFO_REC;
3505: l_applied_amt_handling_flag ZX_TAXES_B.APPLIED_AMT_HANDLING_FLAG%TYPE;
3506:
3507: BEGIN
3508:
3509: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 3585: FROM zx_taxes_b_tmp

3581: l_new_row_num).multiple_jurisdictions_flag :=
3582: tax_line_rec.multiple_jurisdictions_flag;
3583: BEGIN
3584: SELECT applied_amt_handling_flag INTO l_applied_amt_handling_flag
3585: FROM zx_taxes_b_tmp
3586: WHERE tax_id = tax_line_rec.tax_id;
3587:
3588: IF l_applied_amt_handling_flag = 'P' --Bug 5650193
3589: THEN

Line 4065: c_tax zx_taxes_b.tax%TYPE,

4061: -- Bug 5675944 : Retain tax_line_id for UPDATE
4062: -- Bug 7597449 Added Tax apportionment line number to pick the correct tax line id for upgraded invoices which have same regime-tax information.
4063: CURSOR get_key_columns_cur
4064: (c_tax_regime_code zx_regimes_b.tax_regime_code%TYPE,
4065: c_tax zx_taxes_b.tax%TYPE,
4066: c_apportionment_line_number zx_lines.tax_apportionment_line_number%type) IS
4067: SELECT * FROM zx_lines
4068: WHERE application_id = p_event_class_rec.application_id
4069: AND entity_code = p_event_class_rec.entity_code

Line 4682: p_tax_id IN zx_taxes_b.tax_id%TYPE,

4678:
4679: PROCEDURE get_place_of_supply (
4680: p_event_class_rec IN zx_api_pub.event_class_rec_type,
4681: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
4682: p_tax_id IN zx_taxes_b.tax_id%TYPE,
4683: p_tax IN zx_taxes_b.tax%TYPE,
4684: p_tax_determine_date IN DATE,
4685: p_def_place_of_supply_type_cd IN zx_taxes_b.def_place_of_supply_type_code%TYPE,
4686: p_place_of_supply_rule_flag IN zx_taxes_b.place_of_supply_rule_flag%TYPE,

Line 4683: p_tax IN zx_taxes_b.tax%TYPE,

4679: PROCEDURE get_place_of_supply (
4680: p_event_class_rec IN zx_api_pub.event_class_rec_type,
4681: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
4682: p_tax_id IN zx_taxes_b.tax_id%TYPE,
4683: p_tax IN zx_taxes_b.tax%TYPE,
4684: p_tax_determine_date IN DATE,
4685: p_def_place_of_supply_type_cd IN zx_taxes_b.def_place_of_supply_type_code%TYPE,
4686: p_place_of_supply_rule_flag IN zx_taxes_b.place_of_supply_rule_flag%TYPE,
4687: p_applicability_rule_flag IN zx_taxes_b.applicability_rule_flag%TYPE,

Line 4685: p_def_place_of_supply_type_cd IN zx_taxes_b.def_place_of_supply_type_code%TYPE,

4681: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
4682: p_tax_id IN zx_taxes_b.tax_id%TYPE,
4683: p_tax IN zx_taxes_b.tax%TYPE,
4684: p_tax_determine_date IN DATE,
4685: p_def_place_of_supply_type_cd IN zx_taxes_b.def_place_of_supply_type_code%TYPE,
4686: p_place_of_supply_rule_flag IN zx_taxes_b.place_of_supply_rule_flag%TYPE,
4687: p_applicability_rule_flag IN zx_taxes_b.applicability_rule_flag%TYPE,
4688: p_def_reg_type IN zx_taxes_b.def_registr_party_type_code%TYPE,
4689: p_reg_rule_flg IN zx_taxes_b.registration_type_rule_flag%TYPE,

Line 4686: p_place_of_supply_rule_flag IN zx_taxes_b.place_of_supply_rule_flag%TYPE,

4682: p_tax_id IN zx_taxes_b.tax_id%TYPE,
4683: p_tax IN zx_taxes_b.tax%TYPE,
4684: p_tax_determine_date IN DATE,
4685: p_def_place_of_supply_type_cd IN zx_taxes_b.def_place_of_supply_type_code%TYPE,
4686: p_place_of_supply_rule_flag IN zx_taxes_b.place_of_supply_rule_flag%TYPE,
4687: p_applicability_rule_flag IN zx_taxes_b.applicability_rule_flag%TYPE,
4688: p_def_reg_type IN zx_taxes_b.def_registr_party_type_code%TYPE,
4689: p_reg_rule_flg IN zx_taxes_b.registration_type_rule_flag%TYPE,
4690: p_trx_line_index IN BINARY_INTEGER,

Line 4687: p_applicability_rule_flag IN zx_taxes_b.applicability_rule_flag%TYPE,

4683: p_tax IN zx_taxes_b.tax%TYPE,
4684: p_tax_determine_date IN DATE,
4685: p_def_place_of_supply_type_cd IN zx_taxes_b.def_place_of_supply_type_code%TYPE,
4686: p_place_of_supply_rule_flag IN zx_taxes_b.place_of_supply_rule_flag%TYPE,
4687: p_applicability_rule_flag IN zx_taxes_b.applicability_rule_flag%TYPE,
4688: p_def_reg_type IN zx_taxes_b.def_registr_party_type_code%TYPE,
4689: p_reg_rule_flg IN zx_taxes_b.registration_type_rule_flag%TYPE,
4690: p_trx_line_index IN BINARY_INTEGER,
4691: p_direct_rate_result_id IN NUMBER,

Line 4688: p_def_reg_type IN zx_taxes_b.def_registr_party_type_code%TYPE,

4684: p_tax_determine_date IN DATE,
4685: p_def_place_of_supply_type_cd IN zx_taxes_b.def_place_of_supply_type_code%TYPE,
4686: p_place_of_supply_rule_flag IN zx_taxes_b.place_of_supply_rule_flag%TYPE,
4687: p_applicability_rule_flag IN zx_taxes_b.applicability_rule_flag%TYPE,
4688: p_def_reg_type IN zx_taxes_b.def_registr_party_type_code%TYPE,
4689: p_reg_rule_flg IN zx_taxes_b.registration_type_rule_flag%TYPE,
4690: p_trx_line_index IN BINARY_INTEGER,
4691: p_direct_rate_result_id IN NUMBER,
4692: x_jurisdiction_rec OUT NOCOPY ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type,

Line 4689: p_reg_rule_flg IN zx_taxes_b.registration_type_rule_flag%TYPE,

4685: p_def_place_of_supply_type_cd IN zx_taxes_b.def_place_of_supply_type_code%TYPE,
4686: p_place_of_supply_rule_flag IN zx_taxes_b.place_of_supply_rule_flag%TYPE,
4687: p_applicability_rule_flag IN zx_taxes_b.applicability_rule_flag%TYPE,
4688: p_def_reg_type IN zx_taxes_b.def_registr_party_type_code%TYPE,
4689: p_reg_rule_flg IN zx_taxes_b.registration_type_rule_flag%TYPE,
4690: p_trx_line_index IN BINARY_INTEGER,
4691: p_direct_rate_result_id IN NUMBER,
4692: x_jurisdiction_rec OUT NOCOPY ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type,
4693: x_jurisdictions_found OUT NOCOPY VARCHAR2,

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

4690: p_trx_line_index IN BINARY_INTEGER,
4691: p_direct_rate_result_id IN NUMBER,
4692: x_jurisdiction_rec OUT NOCOPY ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type,
4693: x_jurisdictions_found OUT NOCOPY VARCHAR2,
4694: x_place_of_supply_type_code OUT NOCOPY zx_taxes_b.def_place_of_supply_type_code%TYPE,
4695: x_place_of_supply_result_id OUT NOCOPY NUMBER,
4696: x_return_status OUT NOCOPY VARCHAR2) IS
4697:
4698: l_location_id NUMBER;

Line 4709: l_pos_type zx_taxes_b.def_place_of_supply_type_code%TYPE;

4705: l_error_buffer VARCHAR2(256);
4706: l_structure_name varchar2(30);
4707: l_msg_count NUMBER;
4708: l_msg_data VARCHAR2(2000);
4709: l_pos_type zx_taxes_b.def_place_of_supply_type_code%TYPE;
4710:
4711: BEGIN
4712: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4713:

Line 5034: p_pos_type IN zx_taxes_b.def_place_of_supply_type_code%TYPE,

5030: --
5031: -- IN p_pos_type
5032:
5033: FUNCTION get_pos_parameter_name (
5034: p_pos_type IN zx_taxes_b.def_place_of_supply_type_code%TYPE,
5035: x_return_status OUT NOCOPY VARCHAR2
5036: ) RETURN VARCHAR2 IS
5037:
5038: l_loc_tbl VARCHAR2(30);

Line 5237: p_tax IN zx_taxes_b.tax%TYPE,

5233: p_structure_name IN VARCHAR2,
5234: p_structure_index IN BINARY_INTEGER,
5235: p_event_class_rec IN zx_api_pub.event_class_rec_type,
5236: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
5237: p_tax IN zx_taxes_b.tax%TYPE,
5238: p_tax_determine_date IN zx_lines.tax_determine_date%TYPE,
5239: p_jurisdiction_code IN zx_jurisdictions_b.tax_jurisdiction_code%TYPE,
5240: p_reg_party_type IN zx_taxes_b.def_registr_party_type_code%TYPE,
5241: x_registration_rec OUT NOCOPY zx_tcm_control_pkg.zx_registration_info_rec,

Line 5240: p_reg_party_type IN zx_taxes_b.def_registr_party_type_code%TYPE,

5236: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
5237: p_tax IN zx_taxes_b.tax%TYPE,
5238: p_tax_determine_date IN zx_lines.tax_determine_date%TYPE,
5239: p_jurisdiction_code IN zx_jurisdictions_b.tax_jurisdiction_code%TYPE,
5240: p_reg_party_type IN zx_taxes_b.def_registr_party_type_code%TYPE,
5241: x_registration_rec OUT NOCOPY zx_tcm_control_pkg.zx_registration_info_rec,
5242: x_return_status OUT NOCOPY VARCHAR2
5243: ) IS
5244:

Line 5615: p_tax_id IN zx_taxes_b.tax_id%TYPE,

5611:
5612: PROCEDURE get_tax_registration (
5613: p_event_class_rec IN zx_api_pub.event_class_rec_type,
5614: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
5615: p_tax_id IN zx_taxes_b.tax_id%TYPE,
5616: p_tax IN zx_taxes_b.tax%TYPE,
5617: p_tax_determine_date IN DATE,
5618: p_jurisdiction_code IN zx_jurisdictions_b.tax_jurisdiction_code%TYPE,
5619: p_def_reg_type IN zx_taxes_b.def_registr_party_type_code%TYPE,

Line 5616: p_tax IN zx_taxes_b.tax%TYPE,

5612: PROCEDURE get_tax_registration (
5613: p_event_class_rec IN zx_api_pub.event_class_rec_type,
5614: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
5615: p_tax_id IN zx_taxes_b.tax_id%TYPE,
5616: p_tax IN zx_taxes_b.tax%TYPE,
5617: p_tax_determine_date IN DATE,
5618: p_jurisdiction_code IN zx_jurisdictions_b.tax_jurisdiction_code%TYPE,
5619: p_def_reg_type IN zx_taxes_b.def_registr_party_type_code%TYPE,
5620: p_reg_rule_flg IN zx_taxes_b.registration_type_rule_flag%TYPE,

Line 5619: p_def_reg_type IN zx_taxes_b.def_registr_party_type_code%TYPE,

5615: p_tax_id IN zx_taxes_b.tax_id%TYPE,
5616: p_tax IN zx_taxes_b.tax%TYPE,
5617: p_tax_determine_date IN DATE,
5618: p_jurisdiction_code IN zx_jurisdictions_b.tax_jurisdiction_code%TYPE,
5619: p_def_reg_type IN zx_taxes_b.def_registr_party_type_code%TYPE,
5620: p_reg_rule_flg IN zx_taxes_b.registration_type_rule_flag%TYPE,
5621: p_trx_line_index IN BINARY_INTEGER,
5622: x_registration_number IN OUT NOCOPY zx_registrations.registration_number%TYPE,
5623: x_tax_inclusion_flag IN OUT NOCOPY zx_registrations.inclusive_tax_flag%TYPE,

Line 5620: p_reg_rule_flg IN zx_taxes_b.registration_type_rule_flag%TYPE,

5616: p_tax IN zx_taxes_b.tax%TYPE,
5617: p_tax_determine_date IN DATE,
5618: p_jurisdiction_code IN zx_jurisdictions_b.tax_jurisdiction_code%TYPE,
5619: p_def_reg_type IN zx_taxes_b.def_registr_party_type_code%TYPE,
5620: p_reg_rule_flg IN zx_taxes_b.registration_type_rule_flag%TYPE,
5621: p_trx_line_index IN BINARY_INTEGER,
5622: x_registration_number IN OUT NOCOPY zx_registrations.registration_number%TYPE,
5623: x_tax_inclusion_flag IN OUT NOCOPY zx_registrations.inclusive_tax_flag%TYPE,
5624: x_self_assessment_flg IN OUT NOCOPY zx_registrations.self_assess_flag%TYPE,

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

5623: x_tax_inclusion_flag IN OUT NOCOPY zx_registrations.inclusive_tax_flag%TYPE,
5624: x_self_assessment_flg IN OUT NOCOPY zx_registrations.self_assess_flag%TYPE,
5625: x_tax_registration_result_id OUT NOCOPY NUMBER,
5626: x_rounding_rule_code OUT NOCOPY zx_registrations.rounding_rule_code%TYPE,
5627: x_registration_party_type OUT NOCOPY zx_taxes_b.def_registr_party_type_code%TYPE,
5628: x_return_status OUT NOCOPY VARCHAR2) IS
5629:
5630: l_reg_party_type zx_taxes_b.def_registr_party_type_code%TYPE;
5631: l_reg_party_prof_id zx_party_tax_profile.party_tax_profile_id%TYPE;

Line 5630: l_reg_party_type zx_taxes_b.def_registr_party_type_code%TYPE;

5626: x_rounding_rule_code OUT NOCOPY zx_registrations.rounding_rule_code%TYPE,
5627: x_registration_party_type OUT NOCOPY zx_taxes_b.def_registr_party_type_code%TYPE,
5628: x_return_status OUT NOCOPY VARCHAR2) IS
5629:
5630: l_reg_party_type zx_taxes_b.def_registr_party_type_code%TYPE;
5631: l_reg_party_prof_id zx_party_tax_profile.party_tax_profile_id%TYPE;
5632:
5633: l_registration_rec zx_tcm_control_pkg.zx_registration_info_rec;
5634: l_tax_service_type_code zx_rules_b.service_type_code%TYPE;

Line 6073: p_tax_id IN zx_taxes_b.tax_id%type,

6069: -- p_trx_line_index
6070: -- p_tax_determine_date
6071:
6072: PROCEDURE rule_base_pos_detm (
6073: p_tax_id IN zx_taxes_b.tax_id%type,
6074: p_tax_determine_date IN DATE,
6075: p_tax_service_type_code IN zx_rules_b.service_type_code%type,
6076: p_event_class_rec IN zx_api_pub.event_class_rec_type,
6077: p_trx_line_index IN BINARY_INTEGER,

Line 6166: p_def_reg_type IN zx_taxes_b.def_registr_party_type_code%TYPE,

6162: PROCEDURE populate_registration_info(
6163: p_event_class_rec IN zx_api_pub.event_class_rec_type,
6164: p_trx_line_index IN NUMBER,
6165: p_rownum IN NUMBER,
6166: p_def_reg_type IN zx_taxes_b.def_registr_party_type_code%TYPE,
6167: p_reg_rule_flg IN zx_taxes_b.registration_type_rule_flag%TYPE,
6168: p_tax_determine_date IN DATE,
6169: x_return_status OUT NOCOPY VARCHAR2) IS
6170:

Line 6167: p_reg_rule_flg IN zx_taxes_b.registration_type_rule_flag%TYPE,

6163: p_event_class_rec IN zx_api_pub.event_class_rec_type,
6164: p_trx_line_index IN NUMBER,
6165: p_rownum IN NUMBER,
6166: p_def_reg_type IN zx_taxes_b.def_registr_party_type_code%TYPE,
6167: p_reg_rule_flg IN zx_taxes_b.registration_type_rule_flag%TYPE,
6168: p_tax_determine_date IN DATE,
6169: x_return_status OUT NOCOPY VARCHAR2) IS
6170:
6171: -- get def_registr_party_type_code and registration_type_rule_flag

Line 6176: FROM ZX_TAXES_B

6172: --
6173: CURSOR get_reg_type_and_rule_flg_cur(p_tax_id NUMBER) IS
6174: SELECT def_registr_party_type_code,
6175: registration_type_rule_flag
6176: FROM ZX_TAXES_B
6177: WHERE tax_id = p_tax_id;
6178:
6179: l_def_reg_type zx_taxes_b.def_registr_party_type_code%TYPE;
6180: l_reg_rule_flg zx_taxes_b.registration_type_rule_flag%TYPE;

Line 6179: l_def_reg_type zx_taxes_b.def_registr_party_type_code%TYPE;

6175: registration_type_rule_flag
6176: FROM ZX_TAXES_B
6177: WHERE tax_id = p_tax_id;
6178:
6179: l_def_reg_type zx_taxes_b.def_registr_party_type_code%TYPE;
6180: l_reg_rule_flg zx_taxes_b.registration_type_rule_flag%TYPE;
6181:
6182: l_tax_id NUMBER;
6183: l_error_buffer VARCHAR2(200);

Line 6180: l_reg_rule_flg zx_taxes_b.registration_type_rule_flag%TYPE;

6176: FROM ZX_TAXES_B
6177: WHERE tax_id = p_tax_id;
6178:
6179: l_def_reg_type zx_taxes_b.def_registr_party_type_code%TYPE;
6180: l_reg_rule_flg zx_taxes_b.registration_type_rule_flag%TYPE;
6181:
6182: l_tax_id NUMBER;
6183: l_error_buffer VARCHAR2(200);
6184: l_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;

Line 7125: l_tax zx_taxes_b.tax%TYPE;

7121: l_rownum BINARY_INTEGER;
7122: l_error_buffer VARCHAR2(200);
7123: l_tax_regime_code zx_regimes_b.tax_regime_code%TYPE;
7124: l_tax_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;
7125: l_tax zx_taxes_b.tax%TYPE;
7126: l_tax_status_code zx_status_b.tax_status_code%TYPE;
7127: l_record_type_code zx_rates_b.record_type_code%TYPE;
7128: l_offset_tax_rate_code zx_rates_b.offset_tax_rate_code%TYPE;
7129: l_tax_found_in_ap_flag VARCHAR2(1);

Line 8056: c_tax IN zx_taxes_b.tax%TYPE,

8052: ORDER BY precedence_level;
8053:
8054:
8055: CURSOR get_tax_info_csr(c_tax_regime_code IN ZX_REGIMES_B.tax_regime_code%TYPE,
8056: c_tax IN zx_taxes_b.tax%TYPE,
8057: c_tax_determine_date IN DATE) IS
8058: SELECT tax_id,
8059: tax,
8060: tax_regime_code,

Line 8138: l_place_of_supply_type_code zx_taxes_b.def_place_of_supply_type_code%TYPE;

8134: l_tax_class zx_rates_b.tax_class%TYPE;
8135: l_temp_num NUMBER;
8136: l_jurisdictions_found VARCHAR2(1);
8137: l_jurisdiction_rec ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type;
8138: l_place_of_supply_type_code zx_taxes_b.def_place_of_supply_type_code%TYPE;
8139: l_place_of_supply_result_id NUMBER;
8140: l_begin_index BINARY_INTEGER;
8141: l_end_index BINARY_INTEGER;
8142: l_regimerownum BINARY_INTEGER;

Line 9445: p_tax IN zx_taxes_b.tax%TYPE,

9441: p_trx_line_index IN BINARY_INTEGER,
9442: p_event_class_rec IN zx_api_pub.event_class_rec_type,
9443: p_row_num IN NUMBER,
9444: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
9445: p_tax IN zx_taxes_b.tax%TYPE,
9446: p_tax_date IN DATE,
9447: p_tax_determine_date IN DATE,
9448: p_tax_point_date IN DATE,
9449: x_self_assessed_flag OUT NOCOPY zx_lines.self_assessed_flag%TYPE,