DBA Data[Home] [Help]

APPS.AMS_COPYELEMENTS_PVT dependencies on AMS_GEO_AREAS_PVT

Line 657: l_geo_area_rec ams_geo_areas_pvt.geo_area_rec_type;

653: l_return_status VARCHAR2 (1);
654: x_msg_count NUMBER;
655: l_msg_data VARCHAR2 (512);
656: l_act_geo_area_id NUMBER;
657: l_geo_area_rec ams_geo_areas_pvt.geo_area_rec_type;
658: temp_geo_area_rec ams_geo_areas_pvt.geo_area_rec_type;
659: l_lookup_meaning VARCHAR2 (80);
660:
661: CURSOR geo_areas_cur IS

Line 658: temp_geo_area_rec ams_geo_areas_pvt.geo_area_rec_type;

654: x_msg_count NUMBER;
655: l_msg_data VARCHAR2 (512);
656: l_act_geo_area_id NUMBER;
657: l_geo_area_rec ams_geo_areas_pvt.geo_area_rec_type;
658: temp_geo_area_rec ams_geo_areas_pvt.geo_area_rec_type;
659: l_lookup_meaning VARCHAR2 (80);
660:
661: CURSOR geo_areas_cur IS
662: SELECT *

Line 729: ams_geo_areas_pvt.create_geo_area

725: l_geo_area_rec.attribute15 := geo_areas_rec.attribute15;
726: l_geo_area_rec.geo_area_type_code
727: := geo_areas_rec.geo_area_type_code;
728: l_geo_area_rec.geo_hierarchy_id := geo_areas_rec.geo_hierarchy_id;
729: ams_geo_areas_pvt.create_geo_area
730: ( p_api_version => l_api_version,
731: x_return_status => l_return_status,
732: p_init_msg_list => fnd_api.g_true,
733: x_msg_count => x_msg_count,