DBA Data[Home] [Help]

APPS.BNE_INTEGRATOR_UTILS dependencies on BNE_LCT_TOOLS_PKG

Line 5270: BNE_LCT_TOOLS_PKG.GET_APP_ID(VAL_VALUE),

5266: -- Determine any referenced BNE Queries which are encoded in
5267: -- the val_type/val_value columns.
5268: BEGIN
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

Line 5271: SUBSTRB(BNE_LCT_TOOLS_PKG.GET_CODE(VAL_VALUE),1,30)

5267: -- the val_type/val_value columns.
5268: BEGIN
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

Line 5489: VAL_VALUE = BNE_LCT_TOOLS_PKG.APP_ID_TO_ASN(P_APPLICATION_ID)||P_QUERY_CODE);

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:
5491: IF VV_DUMMY > 0
5492: THEN
5493: RETURN(0);