APPS.HZ_GEOGRAPHY_STRUCTURE_PUB dependencies on HZ_GEOGRAPHY_RANGES

Line 812: FROM hz_geography_ranges hgr

808:
809: CURSOR c_get_ranges is
810: SELECT geography_id,master_ref_geography_id,geography_from,
811: start_date
812: FROM hz_geography_ranges hgr
813: WHERE (SELECT country_code
814: FROM hz_geographies hg
815: WHERE hg.geography_id = hgr.master_ref_geography_id ) = l_country_code;
816:

Line 1073: delete hz_geography_ranges hgr

1069: loop
1070: fetch c_get_ranges into l_zone_id,l_master_ref_geography_id,l_geography_from,l_start_date;
1071: exit when c_get_ranges%NOTFOUND;
1072:
1073: delete hz_geography_ranges hgr
1074: where geography_id = l_zone_id
1075: and geography_from = l_geography_from
1076: and start_date = l_start_date;
1077:

Line 1108: delete hz_geography_ranges

1104: where geography_id = hgt.limited_by_geography_id)
1105: = l_country_code;
1106: end if;
1107: -- delete geogrpahy ranges if any master_ref_geo is deleted
1108: delete hz_geography_ranges
1109: where master_ref_geography_id = l_geography_id;
1110:
1111: -- delete relationships record both for tax and master_ref relationship_type
1112: delete hz_relationships

Line 1534: -- check if there exists any rows in hz_geography_ranges table for this zone_type

1530: --dbms_output.put_line('After validate');
1531:
1532: IF (p_postal_code_range_flag = 'Y' and l_postal_code_range_flag = 'N') THEN
1533:
1534: -- check if there exists any rows in hz_geography_ranges table for this zone_type
1535: -- if yes, then do not allow update
1536:
1537: SELECT count(*) INTO l_count
1538: FROM hz_geography_ranges

Line 1538: FROM hz_geography_ranges

1534: -- check if there exists any rows in hz_geography_ranges table for this zone_type
1535: -- if yes, then do not allow update
1536:
1537: SELECT count(*) INTO l_count
1538: FROM hz_geography_ranges
1539: WHERE geography_id in (SELECT geography_id from hz_geographies
1540: WHERE geography_type=p_geography_type
1541: AND end_date > sysdate)
1542: AND rownum <2;

Line 1547: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'postal_code_range_flag from Y to N as there exists rows in hz_geography_ranges');

1543:
1544: --dbms_output.put_line('l_count is '||to_char(l_count));
1545: IF l_count >0 THEN
1546: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );
1547: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'postal_code_range_flag from Y to N as there exists rows in hz_geography_ranges');
1548: FND_MSG_PUB.ADD;
1549: -- x_return_status := FND_API.G_RET_STS_ERROR;
1550: RAISE FND_API.G_EXC_ERROR;
1551: END IF;