APPS.BNE_INTEGRATOR_UTILS dependencies on BNE_MAPPINGS_B

Line 4887: FROM BNE_MAPPINGS_B

4883: VV_COUNT NUMBER;
4884: BEGIN
4885: SELECT COUNT(*)
4886: INTO VV_COUNT
4887: FROM BNE_MAPPINGS_B
4888: WHERE APPLICATION_ID = P_APPLICATION_ID
4889: AND MAPPING_CODE = P_MAPPING_CODE;
4890:
4891: IF VV_COUNT = 0

Line 4896: DELETE FROM BNE_MAPPINGS_B

4892: THEN
4893: RETURN(0);
4894: END IF;
4895:
4896: DELETE FROM BNE_MAPPINGS_B
4897: WHERE APPLICATION_ID = P_APPLICATION_ID
4898: AND MAPPING_CODE = P_MAPPING_CODE;
4899:
4900: DELETE FROM BNE_MAPPINGS_TL

Line 4934: FROM BNE_MAPPINGS_B

4930: VV_COUNT NUMBER;
4931: BEGIN
4932: VV_COUNT := 0;
4933: FOR I IN (SELECT APPLICATION_ID, MAPPING_CODE
4934: FROM BNE_MAPPINGS_B
4935: WHERE INTEGRATOR_APP_ID = P_APPLICATION_ID
4936: AND INTEGRATOR_CODE = P_INTEGRATOR_CODE)
4937: LOOP
4938: VV_COUNT := VV_COUNT + DELETE_MAPPING(I.APPLICATION_ID, I.MAPPING_CODE);