APPS.HZ_FORMAT_PUB dependencies on HZ_LOCATIONS

Line 128: k_addr_table_name CONSTANT VARCHAR2(30) := 'HZ_LOCATIONS';

124: g_profile_country_lang CONSTANT VARCHAR2(4) := FND_PROFILE.VALUE('HZ_LANG_FOR_COUNTRY_DISPLAY');
125: g_profile_def_addr_style CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('HZ_DEFAULT_ADDR_STYLE');
126: g_profile_def_name_style CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('HZ_DEFAULT_NAME_STYLE');
127:
128: k_addr_table_name CONSTANT VARCHAR2(30) := 'HZ_LOCATIONS';
129: k_addr_table_pk CONSTANT VARCHAR2(30) := 'LOCATION_ID';
130: k_name_table_name CONSTANT VARCHAR2(30) := 'HZ_PARTIES';
131: k_name_table_pk CONSTANT VARCHAR2(30) := 'PARTY_ID';
132:

Line 247: | stored in HZ_LOCATIONS.

243: |
244: | DESCRIPTION
245: |
246: | This procedure will format an address of a location that is
247: | stored in HZ_LOCATIONS.
248: |
249: | SCOPE: Public
250: |
251: | ARGUMENTS: (see definition in specification)

Line 285: IS SELECT country FROM HZ_LOCATIONS

281:
282: l_variation_num NUMBER;
283:
284: CURSOR c_location_territory(p_location_id IN NUMBER)
285: IS SELECT country FROM HZ_LOCATIONS
286: WHERE LOCATION_ID = p_location_id;
287:
288: -- Context Information
289:

Line 1125: | stored in HZ_LOCATIONS.

1121: |
1122: | DESCRIPTION
1123: |
1124: | This procedure will format an address layout of a location that is
1125: | stored in HZ_LOCATIONS.
1126: |
1127: | SCOPE: Public
1128: |
1129: | ARGUMENTS: (see definition in specification)

Line 1162: IS SELECT country FROM HZ_LOCATIONS

1158:
1159: l_variation_num NUMBER;
1160:
1161: CURSOR c_location_territory(p_location_id IN NUMBER)
1162: IS SELECT country FROM HZ_LOCATIONS
1163: WHERE LOCATION_ID = p_location_id;
1164:
1165: -- Context Information
1166: