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_REGIMES_B

Line 15: p_tax_regime_precedence IN zx_regimes_b.regime_precedence%TYPE,

11: x_result_id OUT NOCOPY NUMBER,
12: x_return_status OUT NOCOPY VARCHAR2);
13:
14: PROCEDURE add_tax_regime(
15: p_tax_regime_precedence IN zx_regimes_b.regime_precedence%TYPE,
16: p_tax_regime_id IN zx_regimes_b.tax_regime_id%TYPE,
17: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
18: p_parent_regime_code IN zx_regimes_b.parent_regime_code%TYPE,
19: p_country_code IN zx_regimes_b.country_code%TYPE,

Line 16: p_tax_regime_id IN zx_regimes_b.tax_regime_id%TYPE,

12: x_return_status OUT NOCOPY VARCHAR2);
13:
14: PROCEDURE add_tax_regime(
15: p_tax_regime_precedence IN zx_regimes_b.regime_precedence%TYPE,
16: p_tax_regime_id IN zx_regimes_b.tax_regime_id%TYPE,
17: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
18: p_parent_regime_code IN zx_regimes_b.parent_regime_code%TYPE,
19: p_country_code IN zx_regimes_b.country_code%TYPE,
20: p_geography_type IN zx_regimes_b.geography_type%TYPE,

Line 17: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,

13:
14: PROCEDURE add_tax_regime(
15: p_tax_regime_precedence IN zx_regimes_b.regime_precedence%TYPE,
16: p_tax_regime_id IN zx_regimes_b.tax_regime_id%TYPE,
17: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
18: p_parent_regime_code IN zx_regimes_b.parent_regime_code%TYPE,
19: p_country_code IN zx_regimes_b.country_code%TYPE,
20: p_geography_type IN zx_regimes_b.geography_type%TYPE,
21: p_geography_id IN zx_regimes_b.geography_id%TYPE,

Line 18: p_parent_regime_code IN zx_regimes_b.parent_regime_code%TYPE,

14: PROCEDURE add_tax_regime(
15: p_tax_regime_precedence IN zx_regimes_b.regime_precedence%TYPE,
16: p_tax_regime_id IN zx_regimes_b.tax_regime_id%TYPE,
17: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
18: p_parent_regime_code IN zx_regimes_b.parent_regime_code%TYPE,
19: p_country_code IN zx_regimes_b.country_code%TYPE,
20: p_geography_type IN zx_regimes_b.geography_type%TYPE,
21: p_geography_id IN zx_regimes_b.geography_id%TYPE,
22: p_effective_from IN zx_regimes_b.effective_from%TYPE,

Line 19: p_country_code IN zx_regimes_b.country_code%TYPE,

15: p_tax_regime_precedence IN zx_regimes_b.regime_precedence%TYPE,
16: p_tax_regime_id IN zx_regimes_b.tax_regime_id%TYPE,
17: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
18: p_parent_regime_code IN zx_regimes_b.parent_regime_code%TYPE,
19: p_country_code IN zx_regimes_b.country_code%TYPE,
20: p_geography_type IN zx_regimes_b.geography_type%TYPE,
21: p_geography_id IN zx_regimes_b.geography_id%TYPE,
22: p_effective_from IN zx_regimes_b.effective_from%TYPE,
23: p_effective_to IN zx_regimes_b.effective_to%TYPE,

Line 20: p_geography_type IN zx_regimes_b.geography_type%TYPE,

16: p_tax_regime_id IN zx_regimes_b.tax_regime_id%TYPE,
17: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
18: p_parent_regime_code IN zx_regimes_b.parent_regime_code%TYPE,
19: p_country_code IN zx_regimes_b.country_code%TYPE,
20: p_geography_type IN zx_regimes_b.geography_type%TYPE,
21: p_geography_id IN zx_regimes_b.geography_id%TYPE,
22: p_effective_from IN zx_regimes_b.effective_from%TYPE,
23: p_effective_to IN zx_regimes_b.effective_to%TYPE,
24: x_return_status OUT NOCOPY VARCHAR2);

Line 21: p_geography_id IN zx_regimes_b.geography_id%TYPE,

17: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
18: p_parent_regime_code IN zx_regimes_b.parent_regime_code%TYPE,
19: p_country_code IN zx_regimes_b.country_code%TYPE,
20: p_geography_type IN zx_regimes_b.geography_type%TYPE,
21: p_geography_id IN zx_regimes_b.geography_id%TYPE,
22: p_effective_from IN zx_regimes_b.effective_from%TYPE,
23: p_effective_to IN zx_regimes_b.effective_to%TYPE,
24: x_return_status OUT NOCOPY VARCHAR2);
25:

Line 22: p_effective_from IN zx_regimes_b.effective_from%TYPE,

18: p_parent_regime_code IN zx_regimes_b.parent_regime_code%TYPE,
19: p_country_code IN zx_regimes_b.country_code%TYPE,
20: p_geography_type IN zx_regimes_b.geography_type%TYPE,
21: p_geography_id IN zx_regimes_b.geography_id%TYPE,
22: p_effective_from IN zx_regimes_b.effective_from%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(

Line 23: p_effective_to IN zx_regimes_b.effective_to%TYPE,

19: p_country_code IN zx_regimes_b.country_code%TYPE,
20: p_geography_type IN zx_regimes_b.geography_type%TYPE,
21: p_geography_id IN zx_regimes_b.geography_id%TYPE,
22: p_effective_from IN zx_regimes_b.effective_from%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,

Line 60: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,

56: PROCEDURE handle_update_scenarios(
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,

Line 191: country_code zx_regimes_b.country_code%TYPE);

187: p_event_class_rec IN zx_api_pub.event_class_rec_type,
188: x_return_status OUT NOCOPY VARCHAR2) IS
189:
190: TYPE country_rec_type IS RECORD (
191: country_code zx_regimes_b.country_code%TYPE);
192: TYPE geography_rec_type IS RECORD (
193: geography_id hz_geographies.geography_id%TYPE);
194:
195: TYPE country_tab_type IS TABLE OF country_rec_type INDEX BY BINARY_INTEGER;

Line 206: l_country_code zx_regimes_b.country_code%TYPE;

202: TYPE regime_det_level_tab_type IS TABLE OF
203: zx_det_factor_templ_dtl.tax_regime_det_level_code%TYPE INDEX BY BINARY_INTEGER;
204:
205: l_location_id NUMBER;
206: l_country_code zx_regimes_b.country_code%TYPE;
207: l_country_idx NUMBER;
208: table_size NUMBER;
209: l_error_buffer VARCHAR2(256);
210: l_geography_id NUMBER;

Line 252: -- in zx_regimes_b

248:
249: -- Assuming the fact that taxes can be defined only for child regimes, fetch
250: -- all regimes that have taxes defined for a given country p_country_code.
251: -- the following cursor is assuming that tax_regime_precedence is available
252: -- in zx_regimes_b
253: --
254: CURSOR get_tax_regime_info_cur(p_country_code varchar2,
255: p_tax_determine_date DATE) IS
256: SELECT tax_regime_id,

Line 265: FROM ZX_REGIMES_B_V r

261: geography_type,
262: geography_id,
263: effective_from,
264: effective_to
265: FROM ZX_REGIMES_B_V r
266: WHERE country_code = p_country_code
267: AND (p_tax_determine_date >= effective_from AND
268: (p_tax_determine_date <= effective_to OR effective_to IS NULL))
269: AND EXISTS (SELECT /*+ no_unnest */ 1

Line 288: FROM ZX_REGIMES_B_V regime,

284: geography_type,
285: geography_id,
286: effective_from,
287: effective_to
288: FROM ZX_REGIMES_B_V regime,
289: hz_relationships relation
290: WHERE relation.object_id = c_geography_id
291: AND relation.object_type = 'COUNTRY'
292: AND relation.subject_id = regime.geography_id

Line 778: p_tax_regime_precedence IN zx_regimes_b.regime_precedence%TYPE,

774: -- OUT x_return_status
775: ----------------------------------------------------------------------
776:
777: PROCEDURE add_tax_regime (
778: p_tax_regime_precedence IN zx_regimes_b.regime_precedence%TYPE,
779: p_tax_regime_id IN zx_regimes_b.tax_regime_id%TYPE,
780: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
781: p_parent_regime_code IN zx_regimes_b.parent_regime_code%TYPE,
782: p_country_code IN zx_regimes_b.country_code%TYPE,

Line 779: p_tax_regime_id IN zx_regimes_b.tax_regime_id%TYPE,

775: ----------------------------------------------------------------------
776:
777: PROCEDURE add_tax_regime (
778: p_tax_regime_precedence IN zx_regimes_b.regime_precedence%TYPE,
779: p_tax_regime_id IN zx_regimes_b.tax_regime_id%TYPE,
780: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
781: p_parent_regime_code IN zx_regimes_b.parent_regime_code%TYPE,
782: p_country_code IN zx_regimes_b.country_code%TYPE,
783: p_geography_type IN zx_regimes_b.geography_type%TYPE,

Line 780: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,

776:
777: PROCEDURE add_tax_regime (
778: p_tax_regime_precedence IN zx_regimes_b.regime_precedence%TYPE,
779: p_tax_regime_id IN zx_regimes_b.tax_regime_id%TYPE,
780: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
781: p_parent_regime_code IN zx_regimes_b.parent_regime_code%TYPE,
782: p_country_code IN zx_regimes_b.country_code%TYPE,
783: p_geography_type IN zx_regimes_b.geography_type%TYPE,
784: p_geography_id IN zx_regimes_b.geography_id%TYPE,

Line 781: p_parent_regime_code IN zx_regimes_b.parent_regime_code%TYPE,

777: PROCEDURE add_tax_regime (
778: p_tax_regime_precedence IN zx_regimes_b.regime_precedence%TYPE,
779: p_tax_regime_id IN zx_regimes_b.tax_regime_id%TYPE,
780: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
781: p_parent_regime_code IN zx_regimes_b.parent_regime_code%TYPE,
782: p_country_code IN zx_regimes_b.country_code%TYPE,
783: p_geography_type IN zx_regimes_b.geography_type%TYPE,
784: p_geography_id IN zx_regimes_b.geography_id%TYPE,
785: p_effective_from IN zx_regimes_b.effective_from%TYPE,

Line 782: p_country_code IN zx_regimes_b.country_code%TYPE,

778: p_tax_regime_precedence IN zx_regimes_b.regime_precedence%TYPE,
779: p_tax_regime_id IN zx_regimes_b.tax_regime_id%TYPE,
780: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
781: p_parent_regime_code IN zx_regimes_b.parent_regime_code%TYPE,
782: p_country_code IN zx_regimes_b.country_code%TYPE,
783: p_geography_type IN zx_regimes_b.geography_type%TYPE,
784: p_geography_id IN zx_regimes_b.geography_id%TYPE,
785: p_effective_from IN zx_regimes_b.effective_from%TYPE,
786: p_effective_to IN zx_regimes_b.effective_to%TYPE,

Line 783: p_geography_type IN zx_regimes_b.geography_type%TYPE,

779: p_tax_regime_id IN zx_regimes_b.tax_regime_id%TYPE,
780: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
781: p_parent_regime_code IN zx_regimes_b.parent_regime_code%TYPE,
782: p_country_code IN zx_regimes_b.country_code%TYPE,
783: p_geography_type IN zx_regimes_b.geography_type%TYPE,
784: p_geography_id IN zx_regimes_b.geography_id%TYPE,
785: p_effective_from IN zx_regimes_b.effective_from%TYPE,
786: p_effective_to IN zx_regimes_b.effective_to%TYPE,
787: x_return_status OUT NOCOPY VARCHAR2) IS

Line 784: p_geography_id IN zx_regimes_b.geography_id%TYPE,

780: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
781: p_parent_regime_code IN zx_regimes_b.parent_regime_code%TYPE,
782: p_country_code IN zx_regimes_b.country_code%TYPE,
783: p_geography_type IN zx_regimes_b.geography_type%TYPE,
784: p_geography_id IN zx_regimes_b.geography_id%TYPE,
785: p_effective_from IN zx_regimes_b.effective_from%TYPE,
786: p_effective_to IN zx_regimes_b.effective_to%TYPE,
787: x_return_status OUT NOCOPY VARCHAR2) IS
788:

Line 785: p_effective_from IN zx_regimes_b.effective_from%TYPE,

781: p_parent_regime_code IN zx_regimes_b.parent_regime_code%TYPE,
782: p_country_code IN zx_regimes_b.country_code%TYPE,
783: p_geography_type IN zx_regimes_b.geography_type%TYPE,
784: p_geography_id IN zx_regimes_b.geography_id%TYPE,
785: p_effective_from IN zx_regimes_b.effective_from%TYPE,
786: p_effective_to IN zx_regimes_b.effective_to%TYPE,
787: x_return_status OUT NOCOPY VARCHAR2) IS
788:
789: l_next_regime_num number;

Line 786: p_effective_to IN zx_regimes_b.effective_to%TYPE,

782: p_country_code IN zx_regimes_b.country_code%TYPE,
783: p_geography_type IN zx_regimes_b.geography_type%TYPE,
784: p_geography_id IN zx_regimes_b.geography_id%TYPE,
785: p_effective_from IN zx_regimes_b.effective_from%TYPE,
786: p_effective_to IN zx_regimes_b.effective_to%TYPE,
787: x_return_status OUT NOCOPY VARCHAR2) IS
788:
789: l_next_regime_num number;
790:

Line 2253: p_tax_regime_id IN zx_regimes_b.tax_regime_id%TYPE,

2249: -- x_begin_index
2250: -- x_end_index
2251:
2252: PROCEDURE get_applicable_taxes (
2253: p_tax_regime_id IN zx_regimes_b.tax_regime_id%TYPE,
2254: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
2255: p_trx_line_index IN BINARY_INTEGER,
2256: p_event_class_rec IN zx_api_pub.event_class_rec_type,
2257: p_tax_date IN DATE,

Line 2254: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,

2250: -- x_end_index
2251:
2252: PROCEDURE get_applicable_taxes (
2253: p_tax_regime_id IN zx_regimes_b.tax_regime_id%TYPE,
2254: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
2255: p_trx_line_index IN BINARY_INTEGER,
2256: p_event_class_rec IN zx_api_pub.event_class_rec_type,
2257: p_tax_date IN DATE,
2258: p_tax_determine_date IN DATE,

Line 4064: (c_tax_regime_code zx_regimes_b.tax_regime_code%TYPE,

4060:
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

Line 4681: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,

4677: -- x_place_of_supply_result_id
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,

Line 5236: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,

5232: PROCEDURE get_tax_registration_info(
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,

Line 5614: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,

5610: -- x_self_assessment_flg
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,

Line 7123: l_tax_regime_code zx_regimes_b.tax_regime_code%TYPE;

7119: l_tax_rate_rec zx_tds_utilities_pkg.zx_rate_info_rec_type;
7120: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_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;

Line 8055: CURSOR get_tax_info_csr(c_tax_regime_code IN ZX_REGIMES_B.tax_regime_code%TYPE,

8051: AND tax = c_tax
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,

Line 9444: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,

9440: PROCEDURE handle_update_scenarios(
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,