DBA Data[Home] [Help]

APPS.HZ_GEOGRAPHY_STRUCTURE_PUB dependencies on HZ_RELATIONSHIP_TYPE_V2PUB

Line 208: l_relationship_type_rec HZ_RELATIONSHIP_TYPE_V2PUB.RELATIONSHIP_TYPE_REC_TYPE;

204: x_relationship_type_id OUT NOCOPY NUMBER,
205: x_return_status IN OUT NOCOPY VARCHAR2
206: ) IS
207:
208: l_relationship_type_rec HZ_RELATIONSHIP_TYPE_V2PUB.RELATIONSHIP_TYPE_REC_TYPE;
209: l_geography_type hz_geography_types_b.GEOGRAPHY_TYPE%TYPE :=p_geo_rel_type_rec.geography_type;
210: l_parent_geography_type hz_geography_types_b.GEOGRAPHY_TYPE%TYPE :=p_geo_rel_type_rec.parent_geography_type;
211: l_geography_use hz_geography_types_b.GEOGRAPHY_USE%TYPE;
212: l_count number;

Line 289: HZ_RELATIONSHIP_TYPE_V2PUB.create_relationship_type (

285: l_relationship_type_rec.forward_role :=NULL;
286: l_relationship_type_rec.backward_role :=NULL;
287:
288:
289: HZ_RELATIONSHIP_TYPE_V2PUB.create_relationship_type (
290: p_init_msg_list => 'F',
291: p_relationship_type_rec => l_relationship_type_rec,
292: x_relationship_type_id => x_relationship_type_id,
293: x_return_status => x_return_status,

Line 314: l_relationship_type_rec HZ_RELATIONSHIP_TYPE_V2PUB.RELATIONSHIP_TYPE_REC_TYPE;

310: p_object_version_number IN OUT NOCOPY NUMBER,
311: x_return_status IN OUT NOCOPY VARCHAR2
312: ) IS
313:
314: l_relationship_type_rec HZ_RELATIONSHIP_TYPE_V2PUB.RELATIONSHIP_TYPE_REC_TYPE;
315: --l_relationship_type_id hz_geography_types_b.GEOGRAPHY_TYPE%TYPE :=p_relationship_type_id;
316: --x_return_status VARCHAR2(2000);
317: x_msg_count NUMBER;
318: x_msg_data VARCHAR2(2000);

Line 357: HZ_RELATIONSHIP_TYPE_V2PUB.update_relationship_type(

353: l_relationship_type_rec.created_by_module := NULL;
354: l_relationship_type_rec.application_id := NULL;
355:
356: -- update geography relationship type
357: HZ_RELATIONSHIP_TYPE_V2PUB.update_relationship_type(
358: p_init_msg_list =>'F',
359: p_relationship_type_rec =>l_relationship_type_rec,
360: p_object_version_number =>p_object_version_number,
361: x_return_status =>x_return_status,