APPS.HZ_ADAPTER_PUB dependencies on HZ_ADAPTER_TERRITORIES

Line 152: HZ_ADAPTER_TERRITORIES_PKG.Insert_Row (

148: ELSIF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
150: END IF;
151:
152: HZ_ADAPTER_TERRITORIES_PKG.Insert_Row (
153: x_adapter_id => p_adapter_terr_rec.adapter_id
154: ,x_territory_code => p_adapter_terr_rec.territory_code
155: ,x_enabled_flag => p_adapter_terr_rec.enabled_flag
156: ,x_default_flag => p_adapter_terr_rec.default_flag

Line 327: FROM HZ_ADAPTER_TERRITORIES

323: l_territory_code := p_adapter_terr_rec.territory_code;
324:
325: SELECT ROWID, OBJECT_VERSION_NUMBER
326: INTO l_rowid, l_object_version_number
327: FROM HZ_ADAPTER_TERRITORIES
328: WHERE ADAPTER_ID = l_adapter_id
329: AND TERRITORY_CODE = l_territory_code
330: FOR UPDATE NOWAIT;
331:

Line 366: HZ_ADAPTER_TERRITORIES_PKG.Update_Row(

362: ELSIF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
364: END IF;
365:
366: HZ_ADAPTER_TERRITORIES_PKG.Update_Row(
367: x_rowid => l_rowid
368: ,x_adapter_id => p_adapter_terr_rec.adapter_id
369: ,x_territory_code => p_adapter_terr_rec.territory_code
370: ,x_enabled_flag => p_adapter_terr_rec.enabled_flag

Line 594: from HZ_ADAPTERS la, HZ_ADAPTER_TERRITORIES lat

590: where territory_code = l_territory_code;
591:
592: CURSOR check_terr_default(l_adapter_id NUMBER, l_territory_code VARCHAR2) IS
593: select 'X'
594: from HZ_ADAPTERS la, HZ_ADAPTER_TERRITORIES lat
595: where la.adapter_id = lat.adapter_id
596: and lat.default_flag = 'Y'
597: and lat.enabled_flag = 'Y'
598: and lat.territory_code = l_territory_code