DBA Data[Home] [Help]

APPS.FEM_WEBADI_MEMBER_UTILS_PVT dependencies on BNE_INTEGRATORS_B

Line 2380: FROM BNE_INTEGRATORS_B

2376: -----------------------------------------------------------------------------
2377: BEGIN
2378: SELECT 'Y'
2379: INTO l_existed_flag
2380: FROM BNE_INTEGRATORS_B
2381: WHERE APPLICATION_ID = 274
2382: AND INTEGRATOR_CODE = l_integrator_code;
2383: EXCEPTION
2384: WHEN NO_DATA_FOUND THEN NULL;

Line 2391: INSERT INTO BNE_INTEGRATORS_B

2387: -- If the Integrator does not exist then insert the integrator
2388:
2389: IF (l_existed_flag IS NULL) THEN
2390:
2391: INSERT INTO BNE_INTEGRATORS_B
2392: ( APPLICATION_ID
2393: , INTEGRATOR_CODE
2394: , OBJECT_VERSION_NUMBER
2395: , UPLOAD_PARAM_LIST_APP_ID

Line 2666: -- update the object version number in the bne_integrators_b table.

2662: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2663: RAISE FND_API.G_EXC_ERROR ;
2664: END IF;
2665:
2666: -- update the object version number in the bne_integrators_b table.
2667: -- This will fix the new interface caching issue.
2668:
2669: UPDATE BNE_INTEGRATORS_B
2670: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1

Line 2669: UPDATE BNE_INTEGRATORS_B

2665:
2666: -- update the object version number in the bne_integrators_b table.
2667: -- This will fix the new interface caching issue.
2668:
2669: UPDATE BNE_INTEGRATORS_B
2670: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
2671: --, LAST_UPDATE_DATE = last_update_date + 1
2672: WHERE APPLICATION_ID = 274
2673: AND INTEGRATOR_CODE = l_integrator_code;