APPS.HZ_PARTY_SITE_V2PUB dependencies on HZ_LOCATIONS

Line 225: -- hz_party_sites from hz_locations.

221: l_dummy VARCHAR2(1);
222: l_debug_prefix VARCHAR2(30) := '';
223:
224: -- Bug 2197181: Added l_loc_actual_content_source to denormalize actual_content_source into
225: -- hz_party_sites from hz_locations.
226:
227: l_loc_actual_content_source hz_locations.actual_content_source%TYPE;
228: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
229: l_msg_count NUMBER;

Line 227: l_loc_actual_content_source hz_locations.actual_content_source%TYPE;

223:
224: -- Bug 2197181: Added l_loc_actual_content_source to denormalize actual_content_source into
225: -- hz_party_sites from hz_locations.
226:
227: l_loc_actual_content_source hz_locations.actual_content_source%TYPE;
228: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
229: l_msg_count NUMBER;
230: l_msg_data VARCHAR2(2000);
231: l_country_code hz_parties.country%type;--4742586

Line 316: -- actual_content_source into hz_party_sites from hz_locations.

312:
313: x_party_site_number := l_party_site_number;
314:
315: -- Bug 2197181: Added l_loc_actual_content_source to denormalize
316: -- actual_content_source into hz_party_sites from hz_locations.
317:
318: HZ_REGISTRY_VALIDATE_V2PUB.validate_party_site(
319: 'C',
320: p_party_site_rec,

Line 339: p_entity_name => 'HZ_LOCATIONS',

335: IF /*NVL(g_pst_mixnmatch_enabled, 'N') = 'Y' AND*/
336: l_loc_actual_content_source = G_MISS_CONTENT_SOURCE_TYPE
337: THEN
338: HZ_MIXNM_UTILITY.CheckUserCreationPrivilege (
339: p_entity_name => 'HZ_LOCATIONS',
340: p_entity_attr_id => g_pst_entity_attr_id,
341: p_mixnmatch_enabled => g_pst_mixnmatch_enabled,
342: p_actual_content_source => l_loc_actual_content_source,
343: x_return_status => x_return_status );

Line 531: Select country into l_country_code from hz_locations

527: x_party_site_id := p_party_site_rec.party_site_id;
528: x_party_site_number := p_party_site_rec.party_site_number;
529: --Bug No. 4742586
530: BEGIN
531: Select country into l_country_code from hz_locations
532: where location_id = p_party_site_rec.location_id;
533:
534: EXCEPTION
535: WHEN OTHERS THEN l_country_code := null;

Line 655: l_loc_actual_content_source hz_locations.actual_content_source%TYPE;

651: db_party_id NUMBER;
652: db_location_id NUMBER;
653: db_status VARCHAR2(1);
654: l_identifying_location_id NUMBER;
655: l_loc_actual_content_source hz_locations.actual_content_source%TYPE;
656: l_dummy VARCHAR2(1);
657: l_debug_prefix VARCHAR2(30) := '';
658:
659: BEGIN

Line 1408: SELECT * FROM hz_locations

1404: p_location_id IN NUMBER
1405: ) IS
1406:
1407: CURSOR c_loc IS
1408: SELECT * FROM hz_locations
1409: WHERE location_id = p_location_id;
1410:
1411: CURSOR c_party IS
1412: SELECT 'Y'

Line 1767: p_entity_name => 'HZ_LOCATIONS',

1763: /* SSM SST Integration and Extension
1764: * For non-profile entities, the concept of select/de-select data-sources is obsoleted.
1765:
1766: HZ_MIXNM_UTILITY.LoadDataSources(
1767: p_entity_name => 'HZ_LOCATIONS',
1768: p_entity_attr_id => g_pst_entity_attr_id,
1769: p_mixnmatch_enabled => g_pst_mixnmatch_enabled,
1770: p_selected_datasources => g_pst_selected_datasources );
1771: */

Line 2107: p_entity_name => 'HZ_LOCATIONS',

2103: /* SSM SST Integration and Extension
2104: * For non-profile entities, the concept of select/de-select data-sources is obsoleted.
2105:
2106: HZ_MIXNM_UTILITY.LoadDataSources(
2107: p_entity_name => 'HZ_LOCATIONS',
2108: p_entity_attr_id => g_pst_entity_attr_id,
2109: p_mixnmatch_enabled => g_pst_mixnmatch_enabled,
2110: p_selected_datasources => g_pst_selected_datasources );
2111: */