APPS.HZ_GNR_MAP10000 dependencies on HZ_GNR_MAP10000

Line 1: PACKAGE BODY HZ_GNR_MAP10000 AS

1: PACKAGE BODY HZ_GNR_MAP10000 AS
2:
3: /*=======================================================================+
4: | Copyright (c) 2002 Oracle Corporation Redwood Shores, California, USA|
5: | All rights reserved. |

Line 7: | NAME HZ_GNR_MAP10000

3: /*=======================================================================+
4: | Copyright (c) 2002 Oracle Corporation Redwood Shores, California, USA|
5: | All rights reserved. |
6: +=======================================================================+
7: | NAME HZ_GNR_MAP10000
8: |
9: | DESCRIPTION
10: | This package body is generated by TCA for geoName referencing.
11: |

Line 85: l_module_prefix CONSTANT VARCHAR2(30) := 'HZ:ARHGNRGB:HZ_GNR_MAP10000';

81: l_geography_type VARCHAR2(30);
82: l_geography_id NUMBER;
83: L_MAP_DTLS_TBL HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;
84:
85: l_module_prefix CONSTANT VARCHAR2(30) := 'HZ:ARHGNRGB:HZ_GNR_MAP10000';
86: l_module CONSTANT VARCHAR2(30) := 'ADDRESS_VALIDATION';
87: l_debug_prefix VARCHAR2(30);
88:
89: l_value1 VARCHAR2(360);

Line 506: l_module_prefix CONSTANT VARCHAR2(30) := 'HZ:ARHGNRGB:HZ_GNR_MAP10000';

502: L_MDU_TBL HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;
503: LL_MAP_DTLS_TBL HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;
504: L_MAP_DTLS_TBL HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;
505:
506: l_module_prefix CONSTANT VARCHAR2(30) := 'HZ:ARHGNRGB:HZ_GNR_MAP10000';
507: l_module CONSTANT VARCHAR2(30) := 'ADDRESS_VALIDATION';
508: l_debug_prefix VARCHAR2(30) := p_location_id;
509:
510: l_value1 VARCHAR2(360);

Line 1136: l_module_prefix CONSTANT VARCHAR2(30) := 'HZ:ARHGNRGB:HZ_GNR_MAP10000';

1132: L_MDU_TBL HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;
1133: LL_MAP_DTLS_TBL HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;
1134: L_MAP_DTLS_TBL HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;
1135:
1136: l_module_prefix CONSTANT VARCHAR2(30) := 'HZ:ARHGNRGB:HZ_GNR_MAP10000';
1137: l_module CONSTANT VARCHAR2(30) := 'ADDRESS_VALIDATION';
1138: l_debug_prefix VARCHAR2(30) := p_location_id;
1139:
1140: l_value1 VARCHAR2(360);

Line 1807: END HZ_GNR_MAP10000;

1803: G_MDU_TBL10006(4).LOC_COMPONENT := 'CITY';
1804: G_MDU_TBL10006(4).GEOGRAPHY_TYPE := 'CITY';
1805: G_MDU_TBL10006(4).GEO_ELEMENT_COL := 'GEOGRAPHY_ELEMENT4';
1806:
1807: END HZ_GNR_MAP10000;