eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_GEOGRAPHY_STRUCTURE_PUB dependencies on HZ_GEOGRAPHY_TYPES_B

Line 98: l_geography_type hz_geography_types_b.GEOGRAPHY_TYPE%TYPE := UPPER(p_geography_type_rec.geography_type);

94: x_return_status IN OUT NOCOPY VARCHAR2
95: ) IS
96:
97: --l_geography_type_rec GEOGRAPHY_TYPE_REC_TYPE := p_geography_type_rec;
98: l_geography_type hz_geography_types_b.GEOGRAPHY_TYPE%TYPE := UPPER(p_geography_type_rec.geography_type);
99: l_count NUMBER;
100: l_rowid VARCHAR2(64);
101: l_object_id NUMBER;
102: --l_dummy VARCHAR2(1);

Line 122: FROM hz_geography_types_b

118:
119: -- check for geography type uniqueness
120: SELECT 1
121: INTO l_count
122: FROM hz_geography_types_b
123: WHERE GEOGRAPHY_TYPE = l_geography_type;
124:
125: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
126: FND_MESSAGE.SET_TOKEN('COLUMN', 'geography_type');

Line 209: l_geography_type hz_geography_types_b.GEOGRAPHY_TYPE%TYPE :=p_geo_rel_type_rec.geography_type;

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;
213: x_msg_count NUMBER;

Line 210: l_parent_geography_type hz_geography_types_b.GEOGRAPHY_TYPE%TYPE :=p_geo_rel_type_rec.parent_geography_type;

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;
213: x_msg_count NUMBER;
214: x_msg_data VARCHAR2(2000);

Line 211: l_geography_use hz_geography_types_b.GEOGRAPHY_USE%TYPE;

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;
213: x_msg_count NUMBER;
214: x_msg_data VARCHAR2(2000);
215:

Line 236: FROM hz_geography_types_b

232: BEGIN
233: -- derive geography use of parent geography type which will be the relationship type
234: SELECT GEOGRAPHY_USE
235: INTO l_geography_use
236: FROM hz_geography_types_b
237: WHERE GEOGRAPHY_TYPE = l_parent_geography_type;
238:
239: EXCEPTION
240: WHEN NO_DATA_FOUND THEN

Line 315: --l_relationship_type_id hz_geography_types_b.GEOGRAPHY_TYPE%TYPE :=p_relationship_type_id;

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);
319: l_count NUMBER;

Line 819: FROM hz_geography_types_b

815: WHERE hg.geography_id = hgr.master_ref_geography_id ) = l_country_code;
816:
817: CURSOR c_get_zone_types IS
818: SELECT geography_type
819: FROM hz_geography_types_b
820: WHERE limited_by_geography_id = l_geography_id
821: AND geography_use = 'TAX';
822:
823: BEGIN

Line 1026: hz_geography_types_b hgt,hz_geographies hg

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
1027: where hgt.limited_by_geography_id = hg.geography_id
1028: and hgt.geography_use = 'TAX'
1029: and hg.country_code = l_country_code ))
1030: or (subject_type = p_geography_type

Line 1032: hz_geography_types_b hgt,hz_geographies hg

1028: and hgt.geography_use = 'TAX'
1029: and hg.country_code = l_country_code ))
1030: or (subject_type = p_geography_type
1031: and object_type in (select hgt.geography_type from
1032: hz_geography_types_b hgt,hz_geographies hg
1033: where hgt.limited_by_geography_id = hg.geography_id
1034: and hgt.geography_use = 'TAX'
1035: and hg.country_code = l_country_code )));
1036:

Line 1098: update hz_geography_types_b hgt

1094:
1095: end loop;
1096: CLOSE c_get_ranges;
1097:
1098: update hz_geography_types_b hgt
1099: set postal_code_range_flag = 'N'
1100: where geography_use = 'TAX'
1101: and limited_by_geography_id is not null
1102: and (select country_code

Line 1134: DELETE hz_geography_types_b

1130: LOOP
1131: FETCH c_get_zone_types INTO l_zone_type;
1132: EXIT WHEN c_get_zone_types%NOTFOUND ;
1133:
1134: DELETE hz_geography_types_b
1135: WHERE geography_type = l_zone_type
1136: AND geography_use = 'TAX';
1137:
1138: -- delete identifiers and relationships for tax zones to be deleted

Line 1495: FROM HZ_GEOGRAPHY_TYPES_B

1491: l_rowid,
1492: l_geography_type,
1493: l_postal_code_range_flag,
1494: l_limited_by_geo_id
1495: FROM HZ_GEOGRAPHY_TYPES_B
1496: WHERE GEOGRAPHY_TYPE = p_GEOGRAPHY_TYPE
1497: FOR UPDATE OF GEOGRAPHY_TYPE NOWAIT;
1498:
1499:

Line 1503: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_geography_types_b');

1499:
1500: --validate object_version_number
1501: IF l_object_version_number <> p_object_version_number THEN
1502: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1503: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_geography_types_b');
1504: FND_MSG_PUB.ADD;
1505: RAISE FND_API.G_EXC_ERROR;
1506: ELSE
1507: p_object_version_number := l_object_version_number + 1;

Line 1781: IF p_index_name = 'HZ_GEOGRAPHY_TYPES_B_U1' THEN

1777: WHEN DUP_VAL_ON_INDEX THEN
1778: ROLLBACK TO create_geography_type;
1779: x_return_status := FND_API.G_RET_STS_ERROR;
1780: HZ_UTILITY_V2PUB.find_index_name(p_index_name);
1781: IF p_index_name = 'HZ_GEOGRAPHY_TYPES_B_U1' THEN
1782: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
1783: FND_MESSAGE.SET_TOKEN('COLUMN', 'geography_type');
1784: FND_MSG_PUB.ADD;
1785: END IF;

Line 2432: IF p_index_name = 'HZ_GEOGRAPHY_TYPES_B_U1' THEN

2428: WHEN DUP_VAL_ON_INDEX THEN
2429: ROLLBACK TO create_zone_type;
2430: x_return_status := FND_API.G_RET_STS_ERROR;
2431: HZ_UTILITY_V2PUB.find_index_name(p_index_name);
2432: IF p_index_name = 'HZ_GEOGRAPHY_TYPES_B_U1' THEN
2433: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
2434: FND_MESSAGE.SET_TOKEN('COLUMN', 'geography_type');
2435: FND_MSG_PUB.ADD;
2436: END IF;