113: BEGIN
114:
115: SELECT COUNT(*)
116: INTO P_COUNT
117: FROM fnd_territories_vl
118: WHERE territory_short_name = P_TERRITORY_SHORT_NAME;
119:
120: IF (P_COUNT = 1) THEN
121: SELECT territory_code
119:
120: IF (P_COUNT = 1) THEN
121: SELECT territory_code
122: INTO P_TERRITORY_CODE
123: FROM fnd_territories_vl
124: WHERE territory_short_name = P_TERRITORY_SHORT_NAME;
125: END IF;
126:
127: END country_of_origin;