APPS.HZ_ADAPTER_PUB dependencies on HZ_ADAPTERS

Line 41: HZ_ADAPTERS_PKG.Insert_Row (

37: ELSIF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
38: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
39: END IF;
40:
41: HZ_ADAPTERS_PKG.Insert_Row (
42: x_adapter_id => l_adapter_rec.adapter_id
43: ,x_adapter_content_source => l_adapter_rec.adapter_content_source
44: ,x_enabled_flag => l_adapter_rec.enabled_flag
45: ,x_synchronous_flag => l_adapter_rec.synchronous_flag

Line 216: FROM HZ_ADAPTERS

212: l_adapter_id := p_adapter_rec.adapter_id;
213:
214: SELECT ROWID, OBJECT_VERSION_NUMBER
215: INTO l_rowid, l_object_version_number
216: FROM HZ_ADAPTERS
217: WHERE ADAPTER_ID = l_adapter_id
218: FOR UPDATE NOWAIT;
219:
220: IF NOT (

Line 227: FND_MESSAGE.SET_TOKEN( 'TABLE', 'HZ_ADAPTERS' );

223: l_object_version_number IS NOT NULL AND
224: px_object_version_number = l_object_version_number ) )
225: THEN
226: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
227: FND_MESSAGE.SET_TOKEN( 'TABLE', 'HZ_ADAPTERS' );
228: FND_MSG_PUB.ADD;
229: RAISE FND_API.G_EXC_ERROR;
230: END IF;
231:

Line 254: HZ_ADAPTERS_PKG.Update_Row(

250: ELSIF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
252: END IF;
253:
254: HZ_ADAPTERS_PKG.Update_Row(
255: x_rowid => l_rowid
256: ,x_adapter_id => p_adapter_rec.adapter_id
257: ,x_adapter_content_source => p_adapter_rec.adapter_content_source
258: ,x_enabled_flag => p_adapter_rec.enabled_flag

Line 339: FND_MESSAGE.SET_TOKEN( 'TABLE', 'HZ_ADAPTERS' );

335: l_object_version_number IS NOT NULL AND
336: px_object_version_number = l_object_version_number ) )
337: THEN
338: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
339: FND_MESSAGE.SET_TOKEN( 'TABLE', 'HZ_ADAPTERS' );
340: FND_MSG_PUB.ADD;
341: RAISE FND_API.G_EXC_ERROR;
342: END IF;
343:

Line 584: from HZ_ADAPTERS

580: l_default_flag VARCHAR2(1);
581:
582: CURSOR check_adapter(l_adapter_id NUMBER) IS
583: select 'X'
584: from HZ_ADAPTERS
585: where adapter_id = l_adapter_id;
586:
587: CURSOR check_terr(l_territory_code VARCHAR2) IS
588: select 'X'

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