APPS.HZ_GEO_STRUCT_MAP_PUB dependencies on HZ_GEO_STRUCT_MAP_DTL_PVT

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 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 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 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 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,