[Home] [Help]
1: PACKAGE BODY ZX_TCM_GEO_JUR_PKG AS
2: /* $Header: zxcjurb.pls 120.49.12020000.2 2012/07/23 12:51:34 srajapar noship $ */
3:
4: -- Logging Infra
5: G_CURRENT_RUNTIME_LEVEL NUMBER;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'ZX.PLSQL.ZX_TCM_GEO_JUR_PKG';
13:
14: TYPE geography_id_type is TABLE OF NUMBER INDEX BY BINARY_INTEGER;
15: l_jurisdiction_rec_tmp_tbl tax_jurisdiction_rec_tbl_type;
16:
854: to_char(i);
855: IF ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl.EXISTS(l_zone_indx) THEN
856: IF (g_level_unexpected >= g_current_runtime_level ) THEN
857: FND_LOG.STRING(g_level_unexpected,
858: 'ZX.PLSQL.ZX_TCM_GEO_JUR_PKG.get_zone',
859: 'Caching issue can cause incorrect tax calculation.');
860: END IF;
861: END IF;
862:
1703: (EVENT_CLASS_MAPPING_ID IN NUMBER,
1704: TRX_ID IN NUMBER,
1705: TRX_LINE_ID IN NUMBER,
1706: TRX_LEVEL_TYPE IN VARCHAR2,
1707: LOCATION_TYPE_TBL IN ZX_TCM_GEO_JUR_PKG.LOCATION_TYPE_TBL_TYPE,
1708: LOCATION_ID_TBL IN ZX_TCM_GEO_JUR_PKG.LOCATION_ID_TBL_TYPE,
1709: x_return_status OUT NOCOPY VARCHAR2
1710: ) IS
1711: n NUMBER;
1704: TRX_ID IN NUMBER,
1705: TRX_LINE_ID IN NUMBER,
1706: TRX_LEVEL_TYPE IN VARCHAR2,
1707: LOCATION_TYPE_TBL IN ZX_TCM_GEO_JUR_PKG.LOCATION_TYPE_TBL_TYPE,
1708: LOCATION_ID_TBL IN ZX_TCM_GEO_JUR_PKG.LOCATION_ID_TBL_TYPE,
1709: x_return_status OUT NOCOPY VARCHAR2
1710: ) IS
1711: n NUMBER;
1712: k BINARY_INTEGER;
1744:
1745: IF location_type_tbl.count > 0 THEN
1746:
1747: FOR i IN location_type_tbl.first..location_type_tbl.last LOOP
1748: ZX_TCM_GEO_JUR_PKG.get_location_table_name(location_type_tbl(i), x_loc_tbl);
1749:
1750: check_location_exists(location_id_tbl(i), x_loc_tbl);
1751:
1752: -- Logging Infra: Statement level: "B" means "B"reak point