4264: AS
4265: CURSOR chk_cntry_code(cp_country_code VARCHAR2)
4266: IS
4267: SELECT territory_short_name
4268: FROM fnd_territories_vl
4269: WHERE territory_code = cp_country_code;
4270:
4271: l_country_name fnd_territories_vl.territory_short_name%TYPE ;
4272:
4267: SELECT territory_short_name
4268: FROM fnd_territories_vl
4269: WHERE territory_code = cp_country_code;
4270:
4271: l_country_name fnd_territories_vl.territory_short_name%TYPE ;
4272:
4273: BEGIN
4274: l_country_name := NULL;
4275: