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_GEO_STRUCTURE_LEVELS

Line 67: FROM HZ_GEO_STRUCTURE_LEVELS

63: )IS
64:
65: CURSOR c_geo_parent IS
66: SELECT parent_geography_type,geography_element_column
67: FROM HZ_GEO_STRUCTURE_LEVELS
68: WHERE geography_type = p_geography_type
69: AND geography_id = p_geography_id;
70:
71: l_geo_parent c_geo_parent%ROWTYPE;

Line 429: SELECT count(*) INTO l_count FROM hz_geo_structure_levels

425: -- see whether this geography_element_column to be created is already being used with in this country
426: -- for another geography_type. if yes, do not create
427:
428: /* commented the validation per bug :2911108
429: SELECT count(*) INTO l_count FROM hz_geo_structure_levels
430: WHERE geography_element_column = p_geo_structure_rec.geography_element_column
431: AND geography_type <> p_geo_structure_rec.geography_type
432: AND geography_id = p_geo_structure_rec.geography_id
433: AND rownum < 2;

Line 444: SELECT geography_element_column into l_geo_element_col FROM hz_geo_structure_levels

440: END IF;*/
441:
442: BEGIN
443:
444: SELECT geography_element_column into l_geo_element_col FROM hz_geo_structure_levels
445: WHERE geography_id=p_geo_structure_rec.geography_id
446: AND geography_type=p_geo_structure_rec.geography_type
447: AND rownum < 2;
448:

Line 453: FROM hz_geo_structure_levels

449: EXCEPTION WHEN no_data_found THEN
450: BEGIN
451: SELECT 'GEOGRAPHY_ELEMENT'||NVL(max(substr(geography_element_column,18))+1,2) geo_element_col
452: into l_geo_element_col
453: FROM hz_geo_structure_levels
454: WHERE geography_id = p_geo_structure_rec.geography_id;
455:
456: EXCEPTION WHEN no_data_found THEN
457: l_geo_element_col:='GEOGRAPHY_ELEMENT2';

Line 506: -- call table handler to insert a row in HZ_GEO_STRUCTURE_LEVELS

502: RAISE FND_API.G_EXC_ERROR;
503: END IF;*/
504:
505:
506: -- call table handler to insert a row in HZ_GEO_STRUCTURE_LEVELS
507: HZ_GEO_STRUCTURE_LEVELS_PKG.Insert_Row (
508: x_rowid => l_rowid,
509: x_geography_id => p_geo_structure_rec.geography_id,
510: x_geography_type => p_geo_structure_rec.geography_type,

Line 507: HZ_GEO_STRUCTURE_LEVELS_PKG.Insert_Row (

503: END IF;*/
504:
505:
506: -- call table handler to insert a row in HZ_GEO_STRUCTURE_LEVELS
507: HZ_GEO_STRUCTURE_LEVELS_PKG.Insert_Row (
508: x_rowid => l_rowid,
509: x_geography_id => p_geo_structure_rec.geography_id,
510: x_geography_type => p_geo_structure_rec.geography_type,
511: x_parent_geography_type => p_geo_structure_rec.parent_geography_type,

Line 565: -- insert a row in hz_geo_structure_levels with new relationship_type_id

561: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
562: RAISE FND_API.G_EXC_ERROR;
563: END IF;*/
564:
565: -- insert a row in hz_geo_structure_levels with new relationship_type_id
566: HZ_GEO_STRUCTURE_LEVELS_PKG.Insert_Row (
567: x_rowid => l_rowid,
568: x_geography_id => p_geo_structure_rec.geography_id,
569: x_geography_type => p_geo_structure_rec.geography_type,

Line 566: HZ_GEO_STRUCTURE_LEVELS_PKG.Insert_Row (

562: RAISE FND_API.G_EXC_ERROR;
563: END IF;*/
564:
565: -- insert a row in hz_geo_structure_levels with new relationship_type_id
566: HZ_GEO_STRUCTURE_LEVELS_PKG.Insert_Row (
567: x_rowid => l_rowid,
568: x_geography_id => p_geo_structure_rec.geography_id,
569: x_geography_type => p_geo_structure_rec.geography_type,
570: x_parent_geography_type => p_geo_structure_rec.parent_geography_type,

Line 649: SELECT count(*) INTO l_count FROM hz_geo_structure_levels

645:
646: -- see whether this geography_element_column to be updated is already being used with in this country for
647: -- another geography_type . if yes, do not update
648:
649: SELECT count(*) INTO l_count FROM hz_geo_structure_levels
650: WHERE geography_element_column = p_geography_element_column
651: AND geography_type <> p_geography_type
652: AND geography_id = p_geography_id
653: AND rownum < 2;

Line 665: FROM hz_geo_structure_levels

661:
662: BEGIN
663: SELECT country_code,geography_element_column,rowid,object_version_number
664: INTO l_country_code,l_geo_element_col,l_rowid,l_object_version_number
665: FROM hz_geo_structure_levels
666: WHERE geography_id = p_geography_id
667: AND geography_type = p_geography_type
668: AND parent_geography_type = p_parent_geography_type;
669:

Line 672: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_geo_structure_levels');

668: AND parent_geography_type = p_parent_geography_type;
669:
670: IF p_object_version_number <> l_object_version_number THEN
671: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
672: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_geo_structure_levels');
673: FND_MSG_PUB.ADD;
674: RAISE FND_API.G_EXC_ERROR;
675: ELSE
676: p_object_version_number := l_object_version_number+1;

Line 720: HZ_GEO_STRUCTURE_LEVELS_PKG.Update_Row (

716: --dbms_output.put_line('l_count is '|| to_char(l_count));
717: EXCEPTION WHEN NO_DATA_FOUND THEN
718: --dbms_output.put_line('before update');
719: --call table handler to update row
720: HZ_GEO_STRUCTURE_LEVELS_PKG.Update_Row (
721: x_rowid => l_rowid,
722: x_geography_id => p_geography_id,
723: x_geography_type => p_geography_type,
724: x_parent_geography_type => p_parent_geography_type,

Line 851: FROM hz_geo_structure_levels

847: -- get the relationship_type_id for this row
848: BEGIN
849:
850: SELECT relationship_type_id,country_code INTO l_relationship_type_id,l_country_code
851: FROM hz_geo_structure_levels
852: WHERE geography_id = p_geography_id
853: AND geography_type = p_geography_type
854: AND parent_geography_type = p_parent_geography_type;
855:

Line 867: FROM hz_geo_structure_levels

863: -- code added for bug 4730508
864: BEGIN
865:
866: SELECT geography_type into l_child_geography_type
867: FROM hz_geo_structure_levels
868: WHERE geography_id = p_geography_id
869: AND parent_geography_type = p_geography_type;
870:
871: BEGIN

Line 902: UPDATE hz_geo_structure_levels

898: END IF;
899:
900: -- Bug 4543926 : update parent_geography_type for a child level
901: -- before deleting a level to its parent_geography_type
902: UPDATE hz_geo_structure_levels
903: set parent_geography_type = p_parent_geography_type,
904: relationship_type_id = l_new_relationship_type_id
905: where geography_id = p_geography_id
906: and parent_geography_type = p_geography_type;

Line 941: UPDATE hz_geo_structure_levels

937: END IF;
938:
939: -- Bug 4543926 : update parent_geography_type for a child level
940: -- before deleting a level to its parent_geography_type
941: UPDATE hz_geo_structure_levels
942: set parent_geography_type = p_parent_geography_type,
943: relationship_type_id = l_new_relationship_type_id
944: where geography_id = p_geography_id
945: and parent_geography_type = p_geography_type;

Line 956: HZ_GEO_STRUCTURE_LEVELS_PKG.Delete_Row (

952: END;
953:
954:
955: -- call table handler to delete the row
956: HZ_GEO_STRUCTURE_LEVELS_PKG.Delete_Row (
957: x_geography_id => p_geography_id,
958: x_geography_type => p_geography_type,
959: x_parent_geography_type => p_parent_geography_type
960: );

Line 964: FROM hz_geo_structure_levels

960: );
961:
962: -- disable the relationship_type if it is not used by any other structure
963: SELECT count(*) INTO l_count
964: FROM hz_geo_structure_levels
965: WHERE country_code <> l_country_code
966: AND relationship_type_id=l_relationship_type_id
967: AND rownum <3;
968:

Line 1367: FROM hz_geo_structure_levels

1363: WHERE geography_id = p_zone_type_rec.limited_by_geography_id;
1364:
1365: SELECT geography_type
1366: INTO l_valid_geo_type
1367: FROM hz_geo_structure_levels
1368: WHERE country_code = l_country_code
1369: AND geography_type = p_zone_type_rec.included_geography_type(i)
1370: START WITH parent_geography_type = l_limited_by_geo_type
1371: AND country_code = l_country_code

Line 2101: IF p_index_name = 'HZ_GEO_STRUCTURE_LEVELS_U1' THEN

2097:
2098: WHEN DUP_VAL_ON_INDEX THEN
2099: ROLLBACK TO create_geo_structure;
2100: HZ_UTILITY_V2PUB.find_index_name(p_index_name);
2101: IF p_index_name = 'HZ_GEO_STRUCTURE_LEVELS_U1' THEN
2102: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
2103: FND_MESSAGE.SET_TOKEN('COLUMN', 'geography_id,geography_type and parent_geography_type');
2104: FND_MSG_PUB.ADD;
2105: END IF;