[Home] [Help]
244: FND_MSG_PUB.ADD;
245: RAISE FND_API.G_EXC_ERROR;
246: END;
247: -- check if geography_type is already 'PARENT_OF' parent_geography_type (bug fix 2838632)
248: SELECT count(*) INTO l_count FROM hz_relationship_types
249: WHERE relationship_type=l_geography_use
250: AND subject_type=l_geography_type
251: AND object_type=l_parent_geography_type
252: AND status = 'A'
322:
323: -- validate relationship_type_id
324: BEGIN
325: select 1 into l_count from
326: hz_relationship_types
327: where relationship_type_id=p_relationship_type_id;
328: EXCEPTION WHEN NO_DATA_FOUND THEN
329: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_RECORD');
330: FND_MESSAGE.SET_TOKEN('TOKEN1', 'Relationship Type');
462:
463: -- Get the relationship_type_id if there exists one for this geography_type and parent_geography_type
464: SELECT relationship_type_id,object_version_number,status
465: INTO l_relationship_type_id,l_object_version_number,l_status
466: FROM HZ_RELATIONSHIP_TYPES
467: WHERE subject_type = p_geo_structure_rec.parent_geography_type
468: AND object_type= p_geo_structure_rec.geography_type
469: AND forward_rel_code = 'PARENT_OF'
470: AND backward_rel_code = 'CHILD_OF'
871: BEGIN
872: -- Get the relationship_type_id if there exists one for this geography_type and parent_geography_type
873: SELECT relationship_type_id,object_version_number,status
874: INTO l_new_relationship_type_id,l_object_version_number,l_status
875: FROM HZ_RELATIONSHIP_TYPES
876: WHERE subject_type = p_parent_geography_type
877: AND object_type= l_child_geography_type
878: AND forward_rel_code = 'PARENT_OF'
879: AND backward_rel_code = 'CHILD_OF'
975: l_geo_rel_type_rec.created_by_module := NULL;
976: l_geo_rel_type_rec.application_id := NULL;*/
977:
978: SELECT object_version_number into l_object_version_number
979: FROM hz_relationship_types
980: WHERE relationship_type_id = l_relationship_type_id;
981:
982: update_geo_rel_type(
983: p_init_msg_list => 'F',
994: END IF;
995:
996: -- disable the backward relationship_type too
997: SELECT object_version_number,relationship_type_id into l_object_version_number,l_relationship_type_id
998: FROM hz_relationship_types
999: WHERE subject_type=p_geography_type
1000: AND object_type=p_parent_geography_type
1001: AND relationship_type='MASTER_REF'
1002: AND forward_rel_code = 'CHILD_OF'
1018:
1019: END IF;
1020:
1021: -- Delete when geography type is checked as included geo type in a tax zone type
1022: delete hz_relationship_types
1023: where relationship_type = 'TAX'
1024: and ((object_type = p_geography_type
1025: and subject_type in (select hgt.geography_type from
1026: hz_geography_types_b hgt,hz_geographies hg
1383: -- check if there exists a relationship_type for this geography_type and included_geography_type
1384: Begin
1385: SELECT status, relationship_type_id, object_version_number
1386: INTO l_rel_status, x_relationship_type_id, l_object_version_number
1387: FROM HZ_RELATIONSHIP_TYPES
1388: WHERE subject_type = p_zone_type_rec.geography_type
1389: AND object_type= p_zone_type_rec.included_geography_type(i)
1390: AND forward_rel_code = 'PARENT_OF'
1391: AND backward_rel_code = 'CHILD_OF'
1456: removed boolean := TRUE;
1457:
1458: cursor included_geo_type is
1459: select relationship_type_id, object_version_number, object_type
1460: from HZ_RELATIONSHIP_TYPES
1461: where subject_type = p_zone_type_rec.geography_type
1462: and forward_rel_code = 'PARENT_OF'
1463: and backward_rel_code = 'CHILD_OF'
1464: and relationship_type = 'TAX'
1606: END IF;
1607: Begin
1608: SELECT status, relationship_type_id, object_version_number
1609: INTO l_rel_status, x_relationship_type_id, l_object_version_number
1610: FROM HZ_RELATIONSHIP_TYPES
1611: WHERE subject_type = p_zone_type_rec.geography_type
1612: AND object_type= p_zone_type_rec.included_geography_type(i)
1613: AND forward_rel_code = 'PARENT_OF'
1614: AND backward_rel_code = 'CHILD_OF'