1298: (p_territory_id IN NUMBER,
1299: x_return_status OUT NOCOPY VARCHAR2
1300: ) IS
1301:
1302: l_territory_id ra_territories.territory_id%TYPE;
1303:
1304: CURSOR c_territory_id IS
1305: SELECT territory_id
1306: FROM ra_territories
1302: l_territory_id ra_territories.territory_id%TYPE;
1303:
1304: CURSOR c_territory_id IS
1305: SELECT territory_id
1306: FROM ra_territories
1307: WHERE territory_id = p_territory_id;
1308:
1309: BEGIN
1310: x_return_status := fnd_api.g_ret_sts_success;