DBA Data[Home] [Help]

APPS.BNE_INTEGRATOR_UTILS dependencies on BNE_LCT_TOOLS_PKG

Line 5179: BNE_LCT_TOOLS_PKG.GET_APP_ID(VAL_VALUE),

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

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

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

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

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:
5400: IF VV_DUMMY > 0
5401: THEN
5402: RETURN(0);