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 527: Select country into l_country_code from hz_locations

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

Line 651: l_loc_actual_content_source hz_locations.actual_content_source%TYPE;

647: db_party_id NUMBER;
648: db_location_id NUMBER;
649: db_status VARCHAR2(1);
650: l_identifying_location_id NUMBER;
651: l_loc_actual_content_source hz_locations.actual_content_source%TYPE;
652: l_dummy VARCHAR2(1);
653: l_debug_prefix VARCHAR2(30) := '';
654:
655: BEGIN

Line 1404: SELECT * FROM hz_locations

1400: p_location_id IN NUMBER
1401: ) IS
1402:
1403: CURSOR c_loc IS
1404: SELECT * FROM hz_locations
1405: WHERE location_id = p_location_id;
1406:
1407: CURSOR c_party IS
1408: SELECT 'Y'

Line 1763: p_entity_name => 'HZ_LOCATIONS',

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

Line 2100: p_entity_name => 'HZ_LOCATIONS',

2096: /* SSM SST Integration and Extension
2097: * For non-profile entities, the concept of select/de-select data-sources is obsoleted.
2098:
2099: HZ_MIXNM_UTILITY.LoadDataSources(
2100: p_entity_name => 'HZ_LOCATIONS',
2101: p_entity_attr_id => g_pst_entity_attr_id,
2102: p_mixnmatch_enabled => g_pst_mixnmatch_enabled,
2103: p_selected_datasources => g_pst_selected_datasources );
2104: */