913:
914: CURSOR get_rec_from_value ( c_country_name VARCHAR2 )
915: IS
916: SELECT DISTINCT territory_code
917: FROM FND_TERRITORIES_VL
918: WHERE territory_short_name = c_country_name;
919:
920: CURSOR get_rec_from_id ( c_country_code VARCHAR2 )
921: IS
919:
920: CURSOR get_rec_from_id ( c_country_code VARCHAR2 )
921: IS
922: SELECT DISTINCT territory_code
923: FROM FND_TERRITORIES_VL
924: WHERE territory_code = c_country_code;
925:
926: BEGIN
927: x_return_status := FND_API.G_RET_STS_SUCCESS;