DBA Data[Home] [Help]

APPS.BNE_INTEGRATOR_UTILS dependencies on BNE_MAPPINGS_B

Line 4796: FROM BNE_MAPPINGS_B

4792: VV_COUNT NUMBER;
4793: BEGIN
4794: SELECT COUNT(*)
4795: INTO VV_COUNT
4796: FROM BNE_MAPPINGS_B
4797: WHERE APPLICATION_ID = P_APPLICATION_ID
4798: AND MAPPING_CODE = P_MAPPING_CODE;
4799:
4800: IF VV_COUNT = 0

Line 4805: DELETE FROM BNE_MAPPINGS_B

4801: THEN
4802: RETURN(0);
4803: END IF;
4804:
4805: DELETE FROM BNE_MAPPINGS_B
4806: WHERE APPLICATION_ID = P_APPLICATION_ID
4807: AND MAPPING_CODE = P_MAPPING_CODE;
4808:
4809: DELETE FROM BNE_MAPPINGS_TL

Line 4843: FROM BNE_MAPPINGS_B

4839: VV_COUNT NUMBER;
4840: BEGIN
4841: VV_COUNT := 0;
4842: FOR I IN (SELECT APPLICATION_ID, MAPPING_CODE
4843: FROM BNE_MAPPINGS_B
4844: WHERE INTEGRATOR_APP_ID = P_APPLICATION_ID
4845: AND INTEGRATOR_CODE = P_INTEGRATOR_CODE)
4846: LOOP
4847: VV_COUNT := VV_COUNT + DELETE_MAPPING(I.APPLICATION_ID, I.MAPPING_CODE);