APPS.BNE_INTEGRATOR_UTILS dependencies on BNE_PARAM_DEFNS_B

Line 5201: FROM BNE_PARAM_LIST_ITEMS I, BNE_PARAM_DEFNS_B D

5197: AND ATTRIBUTE_APP_ID IS NOT NULL
5198: AND ATTRIBUTE_CODE IS NOT NULL
5199: UNION
5200: SELECT D.ATTRIBUTE_APP_ID, D.ATTRIBUTE_CODE
5201: FROM BNE_PARAM_LIST_ITEMS I, BNE_PARAM_DEFNS_B D
5202: WHERE I.APPLICATION_ID = P_APPLICATION_ID
5203: AND I.PARAM_LIST_CODE = P_PARAM_LIST_CODE
5204: AND I.PARAM_DEFN_APP_ID = D.APPLICATION_ID
5205: AND I.PARAM_DEFN_CODE = D.PARAM_DEFN_CODE

Line 5273: FROM BNE_PARAM_DEFNS_B

5269: SELECT
5270: BNE_LCT_TOOLS_PKG.GET_APP_ID(VAL_VALUE),
5271: SUBSTRB(BNE_LCT_TOOLS_PKG.GET_CODE(VAL_VALUE),1,30)
5272: INTO VV_QUERY_APP_ID, VV_QUERY_CODE
5273: FROM BNE_PARAM_DEFNS_B
5274: WHERE APPLICATION_ID = VV_DEFN_KEYS(I).APP_ID
5275: AND PARAM_DEFN_CODE = VV_DEFN_KEYS(I).CODE
5276: AND VAL_TYPE = 4
5277: AND VAL_VALUE IS NOT NULL;

Line 5284: DELETE FROM BNE_PARAM_DEFNS_B

5280: VV_QUERY_APP_ID := NULL;
5281: VV_QUERY_CODE := NULL;
5282: END;
5283:
5284: DELETE FROM BNE_PARAM_DEFNS_B
5285: WHERE APPLICATION_ID = VV_DEFN_KEYS(I).APP_ID
5286: AND PARAM_DEFN_CODE = VV_DEFN_KEYS(I).CODE;
5287:
5288: DELETE FROM BNE_PARAM_DEFNS_TL

Line 5325: FROM BNE_PARAM_DEFNS_B

5321: FROM BNE_PARAM_LIST_ITEMS
5322: WHERE ATTRIBUTE_APP_ID = VV_ATTRIBUTE_KEYS(I).APP_ID
5323: AND ATTRIBUTE_CODE = VV_ATTRIBUTE_KEYS(I).CODE)
5324: AND NOT EXISTS (SELECT 1
5325: FROM BNE_PARAM_DEFNS_B
5326: WHERE ATTRIBUTE_APP_ID = VV_ATTRIBUTE_KEYS(I).APP_ID
5327: AND ATTRIBUTE_CODE = VV_ATTRIBUTE_KEYS(I).CODE)
5328: ;
5329: END LOOP;

Line 5486: FROM BNE_PARAM_DEFNS_B

5482: END IF;
5483:
5484: SELECT COUNT(*)
5485: INTO VV_DUMMY
5486: FROM BNE_PARAM_DEFNS_B
5487: WHERE VAL_TYPE = 4
5488: AND (VAL_VALUE = TO_CHAR(P_APPLICATION_ID)||P_QUERY_CODE OR
5489: VAL_VALUE = BNE_LCT_TOOLS_PKG.APP_ID_TO_ASN(P_APPLICATION_ID)||P_QUERY_CODE);
5490: