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_GEO_STRUCT_MAP_PUB dependencies on HZ_GEO_STRUCT_MAP_DTL

Line 456: hz_geo_struct_map_dtl_pvt.insert_row(

452: p_mltbl(m).geo_element_col := l_geo_struct_map_dtl_tbl(i).geo_element_col;
453: p_mltbl(m).loc_compval := null;
454: p_mltbl(m).geography_id := null;
455: --
456: hz_geo_struct_map_dtl_pvt.insert_row(
457: x_map_dtl_row_id,
458: l_map_id,
459: l_geo_struct_map_dtl_tbl(i).loc_seq_num,
460: l_geo_struct_map_dtl_tbl(i).loc_comp,

Line 544: ELSIF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U1' THEN

540: FND_MESSAGE.SET_TOKEN('COUNTRY', p_geo_struct_map_rec.country_code);
541: FND_MESSAGE.SET_TOKEN('ADDRSTYLE', p_geo_struct_map_rec.address_style);
542: FND_MSG_PUB.ADD;
543:
544: ELSIF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U1' THEN
545: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_LOC_SEQ_NUM');
546: FND_MSG_PUB.ADD;
547:
548: ELSIF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U2' THEN

Line 548: ELSIF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U2' THEN

544: ELSIF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U1' THEN
545: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_LOC_SEQ_NUM');
546: FND_MSG_PUB.ADD;
547:
548: ELSIF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U2' THEN
549: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_LOC_COMP');
550: FND_MSG_PUB.ADD;
551:
552: ELSIF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U3' THEN

Line 552: ELSIF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U3' THEN

548: ELSIF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U2' THEN
549: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_LOC_COMP');
550: FND_MSG_PUB.ADD;
551:
552: ELSIF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U3' THEN
553: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_GEO_TYPE');
554: FND_MSG_PUB.ADD;
555: END IF;
556: FND_MSG_PUB.Count_And_Get(

Line 694: FROM hz_geo_struct_map_dtl

690: LOOP
691: BEGIN
692: SELECT count(*)
693: INTO l_count
694: FROM hz_geo_struct_map_dtl
695: WHERE map_id = p_map_id;
696:
697: -- At least two location components is required for the mapping.
698: -- So, if the count is more than 2 we can delete the mapping details.

Line 707: FROM hz_geo_struct_map_dtl

703:
704: BEGIN
705: SELECT geography_type
706: INTO l_del_geo_type
707: FROM hz_geo_struct_map_dtl
708: WHERE map_id = p_map_id
709: AND geography_type <> p_geo_struct_map_dtl_tbl(i).geo_type;
710:
711: l_delete_mapping_also := 'Y';

Line 758: hz_geo_struct_map_dtl_pvt.delete_row(l_map_id,p_geo_struct_map_dtl_tbl(i).geo_type);

754: END IF;
755: END LOOP;
756: CLOSE c_address_usage_dtls;
757:
758: hz_geo_struct_map_dtl_pvt.delete_row(l_map_id,p_geo_struct_map_dtl_tbl(i).geo_type);
759:
760: -- If count is 2 or less, we delete both mapping details (Bug 5096570) Nishant 06-Apr-2006
761: IF (l_del_geo_type) IS NOT NULL THEN
762: -- This is the last mapping which cannot exist on its own

Line 764: hz_geo_struct_map_dtl_pvt.delete_row(l_map_id,l_del_geo_type);

760: -- If count is 2 or less, we delete both mapping details (Bug 5096570) Nishant 06-Apr-2006
761: IF (l_del_geo_type) IS NOT NULL THEN
762: -- This is the last mapping which cannot exist on its own
763: -- delete mapping detail for other remaining record
764: hz_geo_struct_map_dtl_pvt.delete_row(l_map_id,l_del_geo_type);
765: END IF;
766:
767: IF (l_delete_mapping_also = 'Y') THEN
768: -- delete mapping record also

Line 830: FROM hz_geo_struct_map_dtl

826: END LOOP;
827:
828: SELECT count(*)
829: INTO l_count
830: FROM hz_geo_struct_map_dtl
831: WHERE map_id = l_map_id;
832:
833: IF l_count > 0 THEN
834: hz_geo_struct_map_dtl_pvt.delete_row(l_map_id);

Line 834: hz_geo_struct_map_dtl_pvt.delete_row(l_map_id);

830: FROM hz_geo_struct_map_dtl
831: WHERE map_id = l_map_id;
832:
833: IF l_count > 0 THEN
834: hz_geo_struct_map_dtl_pvt.delete_row(l_map_id);
835: END IF;
836: hz_geo_struct_map_pvt.delete_row(l_map_id);
837: END IF;
838:

Line 899: FROM hz_geo_struct_map_dtl

895: WHERE map_id = c_map_id;
896:
897: CURSOR c_map_dtl_count(c_map_id number) IS
898: SELECT count(*)
899: FROM hz_geo_struct_map_dtl
900: WHERE map_id = c_map_id;
901:
902: CURSOR c_determine_geo_element_col(c_geo_type VARCHAR2, c_country VARCHAR2) IS
903: SELECT level+1 seq_num, geography_element_column

Line 1037: hz_geo_struct_map_dtl_pvt.insert_row(

1033: BEGIN --insert row
1034: i := l_geo_struct_map_dtl_tbl.first;
1035: WHILE i IS NOT NULL LOOP
1036:
1037: hz_geo_struct_map_dtl_pvt.insert_row(
1038: x_map_dtl_row_id,
1039: p_map_id,
1040: l_geo_struct_map_dtl_tbl(i).loc_seq_num,
1041: l_geo_struct_map_dtl_tbl(i).loc_comp,

Line 1079: IF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U1' THEN

1075: ROLLBACK TO create_geo_struct_map_dtls;
1076: x_return_status := FND_API.G_RET_STS_ERROR;
1077: HZ_UTILITY_V2PUB.find_index_name(p_index_name);
1078:
1079: IF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U1' THEN
1080: -- FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_LOC_SEQ_NUM');
1081: -- Changed the error message from HZ_GEO_DUP_LOC_SEQ_NUM to HZ_GEO_DUP_GEO_TYPE
1082: -- In the new design we are overriding the LOC_SEQ_NUM passed by the user
1083: -- and deriving it based on GEO_TYPE. So, it is better to display GEO_TYPE

Line 1088: ELSIF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U2' THEN

1084: -- unique index error message for LOC_SEQ_NUM also.
1085: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_GEO_TYPE');
1086: FND_MSG_PUB.ADD;
1087:
1088: ELSIF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U2' THEN
1089: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_LOC_COMP');
1090: FND_MSG_PUB.ADD;
1091:
1092: ELSIF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U3' THEN

Line 1092: ELSIF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U3' THEN

1088: ELSIF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U2' THEN
1089: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_LOC_COMP');
1090: FND_MSG_PUB.ADD;
1091:
1092: ELSIF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U3' THEN
1093: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_GEO_TYPE');
1094: FND_MSG_PUB.ADD;
1095: END IF;
1096:

Line 1145: FROM hz_geo_struct_map_dtl

1141: WHERE map_id = c_map_id;
1142:
1143: CURSOR c_struct_map_dtl(c_geography_type varchar2) IS
1144: SELECT rowid, loc_seq_num,geo_element_col
1145: FROM hz_geo_struct_map_dtl
1146: WHERE map_id = p_map_id
1147: AND geography_type = c_geography_type;
1148:
1149: BEGIN

Line 1208: hz_geo_struct_map_dtl_pvt.Update_Row (

1204: EXIT;
1205: END IF;
1206: END IF;
1207:
1208: hz_geo_struct_map_dtl_pvt.Update_Row (
1209: x_rowid => l_rowid,
1210: x_map_id => p_map_id,
1211: x_loc_seq_num => l_loc_seq_num,
1212: x_loc_component => p_geo_struct_map_dtl_tbl(i).loc_comp,

Line 1278: IF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U1' THEN

1274: ROLLBACK TO update_geo_struct_map_dtls;
1275: x_return_status := FND_API.G_RET_STS_ERROR;
1276: HZ_UTILITY_V2PUB.find_index_name(p_index_name);
1277:
1278: IF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U1' THEN
1279: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_LOC_SEQ_NUM');
1280: FND_MSG_PUB.ADD;
1281:
1282: ELSIF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U2' THEN

Line 1282: ELSIF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U2' THEN

1278: IF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U1' THEN
1279: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_LOC_SEQ_NUM');
1280: FND_MSG_PUB.ADD;
1281:
1282: ELSIF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U2' THEN
1283: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_LOC_COMP');
1284: FND_MSG_PUB.ADD;
1285:
1286: ELSIF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U3' THEN

Line 1286: ELSIF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U3' THEN

1282: ELSIF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U2' THEN
1283: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_LOC_COMP');
1284: FND_MSG_PUB.ADD;
1285:
1286: ELSIF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U3' THEN
1287: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_GEO_TYPE');
1288: FND_MSG_PUB.ADD;
1289: END IF;
1290: