APPS.BNE_LCT_TOOLS_PKG dependencies on BNE_ATTRIBUTES

Line 111: FROM BNE_ATTRIBUTES A, BNE_PARAM_LIST_ITEMS I

107: CURSOR C_ATT9(CP_APPLICATION_ID NUMBER,
108: CP_PARAM_LIST_CODE VARCHAR2)
109: IS
110: SELECT ATTRIBUTE9
111: FROM BNE_ATTRIBUTES A, BNE_PARAM_LIST_ITEMS I
112: WHERE A.APPLICATION_ID = I.ATTRIBUTE_APP_ID
113: AND A.ATTRIBUTE_CODE = I.ATTRIBUTE_CODE
114: AND I.APPLICATION_ID = CP_APPLICATION_ID
115: AND I.PARAM_LIST_CODE = CP_PARAM_LIST_CODE

Line 246: function GET_NAMED_ATTRIBUTE(ATTS IN BNE_ATTRIBUTES%ROWTYPE,

242: END LOOP;
243: RETURN(RET);
244: END GET_IMPORT_LISTS;
245:
246: function GET_NAMED_ATTRIBUTE(ATTS IN BNE_ATTRIBUTES%ROWTYPE,
247: NAME IN BNE_ATTRIBUTES.ATTRIBUTE_NAME1%TYPE)
248: RETURN VARCHAR2
249: IS
250: RET BNE_ATTRIBUTES.ATTRIBUTE1%TYPE;

Line 247: NAME IN BNE_ATTRIBUTES.ATTRIBUTE_NAME1%TYPE)

243: RETURN(RET);
244: END GET_IMPORT_LISTS;
245:
246: function GET_NAMED_ATTRIBUTE(ATTS IN BNE_ATTRIBUTES%ROWTYPE,
247: NAME IN BNE_ATTRIBUTES.ATTRIBUTE_NAME1%TYPE)
248: RETURN VARCHAR2
249: IS
250: RET BNE_ATTRIBUTES.ATTRIBUTE1%TYPE;
251: BEGIN

Line 250: RET BNE_ATTRIBUTES.ATTRIBUTE1%TYPE;

246: function GET_NAMED_ATTRIBUTE(ATTS IN BNE_ATTRIBUTES%ROWTYPE,
247: NAME IN BNE_ATTRIBUTES.ATTRIBUTE_NAME1%TYPE)
248: RETURN VARCHAR2
249: IS
250: RET BNE_ATTRIBUTES.ATTRIBUTE1%TYPE;
251: BEGIN
252: if NAME is null
253: THEN
254: return(null);

Line 336: ATTS BNE_ATTRIBUTES%ROWTYPE;

332: X_CDPF_LIST_CODE IN VARCHAR2)
333: RETURN VARCHAR2
334: IS
335: RET VARCHAR2(2000);
336: ATTS BNE_ATTRIBUTES%ROWTYPE;
337: TMP VARCHAR2(2000);
338: COLON_POSITION INTEGER;
339:
340: CURSOR C_LIST_FK(CP_APPLICATION_ID NUMBER,

Line 344: FROM BNE_PARAM_LIST_ITEMS LI, BNE_PARAM_DEFNS_B PD, BNE_ATTRIBUTES A

340: CURSOR C_LIST_FK(CP_APPLICATION_ID NUMBER,
341: CP_PARAM_LIST_CODE VARCHAR2)
342: IS
343: SELECT A.*
344: FROM BNE_PARAM_LIST_ITEMS LI, BNE_PARAM_DEFNS_B PD, BNE_ATTRIBUTES A
345: WHERE LI.PARAM_DEFN_APP_ID = PD.APPLICATION_ID
346: AND LI.PARAM_DEFN_CODE = PD.PARAM_DEFN_CODE
347: AND PD.PARAM_SOURCE = 'WEBADI:ViewerExtension'
348: AND A.APPLICATION_ID = PD.ATTRIBUTE_APP_ID