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.HZ_GNR_PVT dependencies on HZ_GEO_STRUCT_MAP

Line 1000: l_geo_rec_tab_col hz_geo_struct_map_dtl.loc_component%TYPE;

996:
997: geo_struct_tbl HZ_GNR_PVT.geo_struct_tbl_type;
998: geo_suggest_tbl HZ_GNR_PVT.geo_suggest_tbl_type;
999:
1000: l_geo_rec_tab_col hz_geo_struct_map_dtl.loc_component%TYPE;
1001: l_geo_rec_geo_type hz_geo_struct_map_dtl.geography_type%TYPE;
1002: l_geo_rec_geo_name hz_geographies.geography_name%TYPE;
1003: l_geo_rec_geo_id hz_geographies.geography_id%TYPE;
1004: l_geo_rec_geo_code hz_geographies.geography_code%TYPE;

Line 1001: l_geo_rec_geo_type hz_geo_struct_map_dtl.geography_type%TYPE;

997: geo_struct_tbl HZ_GNR_PVT.geo_struct_tbl_type;
998: geo_suggest_tbl HZ_GNR_PVT.geo_suggest_tbl_type;
999:
1000: l_geo_rec_tab_col hz_geo_struct_map_dtl.loc_component%TYPE;
1001: l_geo_rec_geo_type hz_geo_struct_map_dtl.geography_type%TYPE;
1002: l_geo_rec_geo_name hz_geographies.geography_name%TYPE;
1003: l_geo_rec_geo_id hz_geographies.geography_id%TYPE;
1004: l_geo_rec_geo_code hz_geographies.geography_code%TYPE;
1005: l_geo_rec_country_code hz_geographies.country_code%TYPE;

Line 4018: FROM hz_geo_struct_map smap

4014: CURSOR c_full_struct_not_null (ll_country_code VARCHAR2, ll_address_style VARCHAR2,
4015: ll_table_name VARCHAR2)
4016: IS
4017: SELECT dmap.loc_component, dmap.geography_type, dmap.geo_element_col, dmap.loc_seq_num
4018: FROM hz_geo_struct_map smap
4019: ,hz_geo_struct_map_dtl dmap
4020: WHERE smap.address_style = ll_address_style
4021: AND SMAP.country_code = ll_country_code
4022: AND SMAP.loc_tbl_name = ll_table_name

Line 4019: ,hz_geo_struct_map_dtl dmap

4015: ll_table_name VARCHAR2)
4016: IS
4017: SELECT dmap.loc_component, dmap.geography_type, dmap.geo_element_col, dmap.loc_seq_num
4018: FROM hz_geo_struct_map smap
4019: ,hz_geo_struct_map_dtl dmap
4020: WHERE smap.address_style = ll_address_style
4021: AND SMAP.country_code = ll_country_code
4022: AND SMAP.loc_tbl_name = ll_table_name
4023: AND smap.map_id = dmap.map_id

Line 4029: FROM hz_geo_struct_map smap

4025:
4026: CURSOR c_full_struct_for_null (ll_country_code VARCHAR2, ll_table_name VARCHAR2)
4027: IS
4028: SELECT dmap.loc_component, dmap.geography_type, dmap.geo_element_col, dmap.loc_seq_num
4029: FROM hz_geo_struct_map smap
4030: ,hz_geo_struct_map_dtl dmap
4031: WHERE smap.address_style IS NULL
4032: AND SMAP.country_code = ll_country_code
4033: AND SMAP.loc_tbl_name = ll_table_name

Line 4030: ,hz_geo_struct_map_dtl dmap

4026: CURSOR c_full_struct_for_null (ll_country_code VARCHAR2, ll_table_name VARCHAR2)
4027: IS
4028: SELECT dmap.loc_component, dmap.geography_type, dmap.geo_element_col, dmap.loc_seq_num
4029: FROM hz_geo_struct_map smap
4030: ,hz_geo_struct_map_dtl dmap
4031: WHERE smap.address_style IS NULL
4032: AND SMAP.country_code = ll_country_code
4033: AND SMAP.loc_tbl_name = ll_table_name
4034: AND smap.map_id = dmap.map_id

Line 4041: FROM hz_geo_struct_map smap

4037: CURSOR c_usage_not_null (ll_country_code VARCHAR2, ll_address_style VARCHAR2,
4038: ll_table_name VARCHAR2, ll_usage VARCHAR2)
4039: IS
4040: SELECT haud.geography_type
4041: FROM hz_geo_struct_map smap
4042: ,hz_geo_struct_map_dtl dmap
4043: ,hz_address_usages hau
4044: ,hz_address_usage_dtls haud
4045: WHERE smap.address_style = ll_address_style

Line 4042: ,hz_geo_struct_map_dtl dmap

4038: ll_table_name VARCHAR2, ll_usage VARCHAR2)
4039: IS
4040: SELECT haud.geography_type
4041: FROM hz_geo_struct_map smap
4042: ,hz_geo_struct_map_dtl dmap
4043: ,hz_address_usages hau
4044: ,hz_address_usage_dtls haud
4045: WHERE smap.address_style = ll_address_style
4046: AND SMAP.country_code = ll_country_code

Line 4060: FROM hz_geo_struct_map smap

4056: CURSOR c_usage_for_null (ll_country_code VARCHAR2,
4057: ll_table_name VARCHAR2, ll_usage VARCHAR2)
4058: IS
4059: SELECT haud.geography_type
4060: FROM hz_geo_struct_map smap
4061: ,hz_geo_struct_map_dtl dmap
4062: ,hz_address_usages hau
4063: ,hz_address_usage_dtls haud
4064: WHERE smap.address_style IS NULL

Line 4061: ,hz_geo_struct_map_dtl dmap

4057: ll_table_name VARCHAR2, ll_usage VARCHAR2)
4058: IS
4059: SELECT haud.geography_type
4060: FROM hz_geo_struct_map smap
4061: ,hz_geo_struct_map_dtl dmap
4062: ,hz_address_usages hau
4063: ,hz_address_usage_dtls haud
4064: WHERE smap.address_style IS NULL
4065: AND SMAP.country_code = ll_country_code