DBA Data[Home] [Help]

APPS.ZX_TCM_GEO_JUR_PKG dependencies on ZX_TCM_GEO_JUR_PKG

Line 1: PACKAGE BODY ZX_TCM_GEO_JUR_PKG AS

1: PACKAGE BODY ZX_TCM_GEO_JUR_PKG AS
2: /* $Header: zxcjurb.pls 120.42.12010000.1 2008/07/28 13:29:06 appldev ship $ */
3:
4: -- Logging Infra
5: G_CURRENT_RUNTIME_LEVEL NUMBER;

Line 12: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'ZX.PLSQL.ZX_TCM_GEO_JUR_PKG';

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:

Line 1496: LOCATION_TYPE_TBL IN ZX_TCM_GEO_JUR_PKG.LOCATION_TYPE_TBL_TYPE,

1492: (EVENT_CLASS_MAPPING_ID IN NUMBER,
1493: TRX_ID IN NUMBER,
1494: TRX_LINE_ID IN NUMBER,
1495: TRX_LEVEL_TYPE IN VARCHAR2,
1496: LOCATION_TYPE_TBL IN ZX_TCM_GEO_JUR_PKG.LOCATION_TYPE_TBL_TYPE,
1497: LOCATION_ID_TBL IN ZX_TCM_GEO_JUR_PKG.LOCATION_ID_TBL_TYPE,
1498: x_return_status OUT NOCOPY VARCHAR2
1499: ) IS
1500: n NUMBER;

Line 1497: LOCATION_ID_TBL IN ZX_TCM_GEO_JUR_PKG.LOCATION_ID_TBL_TYPE,

1493: TRX_ID IN NUMBER,
1494: TRX_LINE_ID IN NUMBER,
1495: TRX_LEVEL_TYPE IN VARCHAR2,
1496: LOCATION_TYPE_TBL IN ZX_TCM_GEO_JUR_PKG.LOCATION_TYPE_TBL_TYPE,
1497: LOCATION_ID_TBL IN ZX_TCM_GEO_JUR_PKG.LOCATION_ID_TBL_TYPE,
1498: x_return_status OUT NOCOPY VARCHAR2
1499: ) IS
1500: n NUMBER;
1501: k BINARY_INTEGER;

Line 1537: ZX_TCM_GEO_JUR_PKG.get_location_table_name(location_type_tbl(i), x_loc_tbl);

1533:
1534: IF location_type_tbl.count > 0 THEN
1535:
1536: FOR i IN location_type_tbl.first..location_type_tbl.last LOOP
1537: ZX_TCM_GEO_JUR_PKG.get_location_table_name(location_type_tbl(i), x_loc_tbl);
1538:
1539: check_location_exists(location_id_tbl(i), x_loc_tbl);
1540:
1541: -- Logging Infra: Statement level: "B" means "B"reak point