APPS.BNE_INTEGRATOR_UTILS dependencies on BNE_PARAM_DEFNS_B

Line 5110: FROM BNE_PARAM_LIST_ITEMS I, BNE_PARAM_DEFNS_B D

5106: AND ATTRIBUTE_APP_ID IS NOT NULL
5107: AND ATTRIBUTE_CODE IS NOT NULL
5108: UNION
5109: SELECT D.ATTRIBUTE_APP_ID, D.ATTRIBUTE_CODE
5110: FROM BNE_PARAM_LIST_ITEMS I, BNE_PARAM_DEFNS_B D
5111: WHERE I.APPLICATION_ID = P_APPLICATION_ID
5112: AND I.PARAM_LIST_CODE = P_PARAM_LIST_CODE
5113: AND I.PARAM_DEFN_APP_ID = D.APPLICATION_ID
5114: AND I.PARAM_DEFN_CODE = D.PARAM_DEFN_CODE

Line 5182: FROM BNE_PARAM_DEFNS_B

5178: SELECT
5179: BNE_LCT_TOOLS_PKG.GET_APP_ID(VAL_VALUE),
5180: SUBSTRB(BNE_LCT_TOOLS_PKG.GET_CODE(VAL_VALUE),1,30)
5181: INTO VV_QUERY_APP_ID, VV_QUERY_CODE
5182: FROM BNE_PARAM_DEFNS_B
5183: WHERE APPLICATION_ID = VV_DEFN_KEYS(I).APP_ID
5184: AND PARAM_DEFN_CODE = VV_DEFN_KEYS(I).CODE
5185: AND VAL_TYPE = 4
5186: AND VAL_VALUE IS NOT NULL;

Line 5193: DELETE FROM BNE_PARAM_DEFNS_B

5189: VV_QUERY_APP_ID := NULL;
5190: VV_QUERY_CODE := NULL;
5191: END;
5192:
5193: DELETE FROM BNE_PARAM_DEFNS_B
5194: WHERE APPLICATION_ID = VV_DEFN_KEYS(I).APP_ID
5195: AND PARAM_DEFN_CODE = VV_DEFN_KEYS(I).CODE;
5196:
5197: DELETE FROM BNE_PARAM_DEFNS_TL

Line 5234: FROM BNE_PARAM_DEFNS_B

5230: FROM BNE_PARAM_LIST_ITEMS
5231: WHERE ATTRIBUTE_APP_ID = VV_ATTRIBUTE_KEYS(I).APP_ID
5232: AND ATTRIBUTE_CODE = VV_ATTRIBUTE_KEYS(I).CODE)
5233: AND NOT EXISTS (SELECT 1
5234: FROM BNE_PARAM_DEFNS_B
5235: WHERE ATTRIBUTE_APP_ID = VV_ATTRIBUTE_KEYS(I).APP_ID
5236: AND ATTRIBUTE_CODE = VV_ATTRIBUTE_KEYS(I).CODE)
5237: ;
5238: END LOOP;

Line 5395: FROM BNE_PARAM_DEFNS_B

5391: END IF;
5392:
5393: SELECT COUNT(*)
5394: INTO VV_DUMMY
5395: FROM BNE_PARAM_DEFNS_B
5396: WHERE VAL_TYPE = 4
5397: AND (VAL_VALUE = TO_CHAR(P_APPLICATION_ID)||P_QUERY_CODE OR
5398: VAL_VALUE = BNE_LCT_TOOLS_PKG.APP_ID_TO_ASN(P_APPLICATION_ID)||P_QUERY_CODE);
5399: