94: ,PRICING_ATTRIBUTE IN VARCHAR2) RETURN CHAR IS
95: X_ATTRIBUTE_CODE VARCHAR2(240);
96: X_SEGMENT_NAME VARCHAR2(240);
97: BEGIN
98: QP_UTIL.GET_ATTRIBUTE_CODE('QP_ATTR_DEFNS_PRICING'
99: ,PRICING_ATTRIBUTE_CONTEXT
100: ,PRICING_ATTRIBUTE
101: ,X_ATTRIBUTE_CODE
102: ,X_SEGMENT_NAME);
107: ,PRICING_ATTRIBUTE1 IN VARCHAR2) RETURN CHAR IS
108: X_ATTRIBUTE_CODE VARCHAR2(240);
109: X_SEGMENT_NAME VARCHAR2(240);
110: BEGIN
111: QP_UTIL.GET_ATTRIBUTE_CODE('QP_ATTR_DEFNS_PRICING'
112: ,PRICING_ATTRIBUTE_CONTEXT1
113: ,PRICING_ATTRIBUTE1
114: ,X_ATTRIBUTE_CODE
115: ,X_SEGMENT_NAME);
150: ,QUALIFIER_ATTR_VALUE IN VARCHAR2
151: ,COMPARISION_OPERATOR_CODE IN VARCHAR2) RETURN CHAR IS
152: L_QUALIFIER_ATTR_VALUE VARCHAR2(240);
153: BEGIN
154: L_QUALIFIER_ATTR_VALUE := QP_UTIL.GET_ATTRIBUTE_VALUE(P_FLEXFIELD_NAME => 'QP_ATTR_DEFNS_QUALIFIER'
155: ,P_CONTEXT_NAME => QUALIFIER_CONTEXT
156: ,P_SEGMENT_NAME => QUALIFIER_ATTRIBUTE
157: ,P_ATTR_VALUE => QUALIFIER_ATTR_VALUE
158: ,P_COMPARISON_OPERATOR_CODE => COMPARISION_OPERATOR_CODE);
206: L_VALUE VARCHAR2(240);
207: BEGIN
208: /*SRW.MESSAGE(1
209: ,' In get_attr ')*/NULL;
210: QP_UTIL.GET_VALUESET_ID_R(P_FLEXFIELD_NAME
211: ,P_CONTEXT_NAME
212: ,P_SEGMENT_NAME
213: ,X_VSID
214: ,X_FORMAT_TYPE
262: ELSIF X_VALIDATION_TYPE = 'F' THEN
263: FND_VSET.GET_VALUESET(X_VSID
264: ,VSET
265: ,FMT);
266: IF (QP_UTIL.VALUE_EXISTS_IN_TABLE(VSET.TABLE_INFO
267: ,L_ATTR_VALUE
268: ,L_ID
269: ,L_VALUE)) THEN
270: IF FMT.HAS_ID THEN
376: ,QUALIFIER_ATTRIBUTE IN VARCHAR2) RETURN CHAR IS
377: X_ATTRIBUTE_CODE VARCHAR2(240);
378: X_SEGMENT_NAME VARCHAR2(240);
379: BEGIN
380: QP_UTIL.GET_ATTRIBUTE_CODE('QP_ATTR_DEFNS_QUALIFIER'
381: ,QUALIFIER_CONTEXT
382: ,QUALIFIER_ATTRIBUTE
383: ,X_ATTRIBUTE_CODE
384: ,X_SEGMENT_NAME);
389: ,PRODUCT_ATTRIBUTE1 IN VARCHAR2) RETURN VARCHAR2 IS
390: X_ATTRIBUTE_CODE VARCHAR2(240);
391: X_SEGMENT_NAME VARCHAR2(240);
392: BEGIN
393: QP_UTIL.GET_ATTRIBUTE_CODE('QP_ATTR_DEFNS_PRICING'
394: ,PRODUCT_ATTRIBUTE_CONTEXT1
395: ,PRODUCT_ATTRIBUTE1
396: ,X_ATTRIBUTE_CODE
397: ,X_SEGMENT_NAME);
450: ,CURR_ATTRIBUTE_CONTEXT IN VARCHAR2) RETURN CHAR IS
451: X_CONTEXT VARCHAR2(80);
452: BEGIN
453: IF CURR_ATTRIBUTE_TYPE = 'QUALIFIER' THEN
454: X_CONTEXT := QP_UTIL.GET_CONTEXT('QP_ATTR_DEFNS_QUALIFIER'
455: ,CURR_ATTRIBUTE_CONTEXT);
456: ELSIF CURR_ATTRIBUTE_TYPE in ('PRICING','PRODUCT') THEN
457: X_CONTEXT := QP_UTIL.GET_CONTEXT('QP_ATTR_DEFNS_PRICING'
458: ,CURR_ATTRIBUTE_CONTEXT);
453: IF CURR_ATTRIBUTE_TYPE = 'QUALIFIER' THEN
454: X_CONTEXT := QP_UTIL.GET_CONTEXT('QP_ATTR_DEFNS_QUALIFIER'
455: ,CURR_ATTRIBUTE_CONTEXT);
456: ELSIF CURR_ATTRIBUTE_TYPE in ('PRICING','PRODUCT') THEN
457: X_CONTEXT := QP_UTIL.GET_CONTEXT('QP_ATTR_DEFNS_PRICING'
458: ,CURR_ATTRIBUTE_CONTEXT);
459: END IF;
460: RETURN (X_CONTEXT);
461: END CF_ATTRIBUTE_CONTEXTFORMULA;
466: X_ATTRIBUTE_CODE VARCHAR2(80);
467: X_SEGMENT_NAME VARCHAR2(80);
468: BEGIN
469: IF CURR_ATTRIBUTE_TYPE = 'QUALIFIER' THEN
470: QP_UTIL.GET_ATTRIBUTE_CODE('QP_ATTR_DEFNS_QUALIFIER'
471: ,CURR_ATTRIBUTE_CONTEXT
472: ,CURR_ATTRIBUTE
473: ,X_ATTRIBUTE_CODE
474: ,X_SEGMENT_NAME);
472: ,CURR_ATTRIBUTE
473: ,X_ATTRIBUTE_CODE
474: ,X_SEGMENT_NAME);
475: ELSIF CURR_ATTRIBUTE_TYPE in ('PRICING','PRODUCT') THEN
476: QP_UTIL.GET_ATTRIBUTE_CODE('QP_ATTR_DEFNS_PRICING'
477: ,CURR_ATTRIBUTE_CONTEXT
478: ,CURR_ATTRIBUTE
479: ,X_ATTRIBUTE_CODE
480: ,X_SEGMENT_NAME);
488: ,CURR_ATTRIBUTE_VALUE IN VARCHAR2) RETURN CHAR IS
489: L_ATTR_VALUE VARCHAR2(240);
490: BEGIN
491: IF CURR_ATTRIBUTE_TYPE = 'QUALIFIER' THEN
492: L_ATTR_VALUE := QP_UTIL.GET_ATTRIBUTE_VALUE(P_FLEXFIELD_NAME => 'QP_ATTR_DEFNS_QUALIFIER'
493: ,P_CONTEXT_NAME => CURR_ATTRIBUTE_CONTEXT
494: ,P_SEGMENT_NAME => CURR_ATTRIBUTE
495: ,P_ATTR_VALUE => CURR_ATTRIBUTE_VALUE
496: ,P_COMPARISON_OPERATOR_CODE => '=');
500: ,P_CONTEXT_NAME => CURR_ATTRIBUTE_CONTEXT
501: ,P_ATTRIBUTE_NAME => CURR_ATTRIBUTE
502: ,P_ATTR_VALUE => CURR_ATTRIBUTE_VALUE);
503: ELSE
504: L_ATTR_VALUE := QP_UTIL.GET_ATTRIBUTE_VALUE(P_FLEXFIELD_NAME => 'QP_ATTR_DEFNS_PRICING'
505: ,P_CONTEXT_NAME => CURR_ATTRIBUTE_CONTEXT
506: ,P_SEGMENT_NAME => CURR_ATTRIBUTE
507: ,P_ATTR_VALUE => CURR_ATTRIBUTE_VALUE
508: ,P_COMPARISON_OPERATOR_CODE => '=');
539: ,QUALIFIER_ATTR_VALUE_TO IN VARCHAR2
540: ,COMPARISION_OPERATOR_CODE IN VARCHAR2) RETURN CHAR IS
541: L_QUALIFIER_ATTR_VALUE_TO VARCHAR2(240);
542: BEGIN
543: L_QUALIFIER_ATTR_VALUE_TO := QP_UTIL.GET_ATTRIBUTE_VALUE(P_FLEXFIELD_NAME => 'QP_ATTR_DEFNS_QUALIFIER'
544: ,P_CONTEXT_NAME => QUALIFIER_CONTEXT
545: ,P_SEGMENT_NAME => QUALIFIER_ATTRIBUTE
546: ,P_ATTR_VALUE => QUALIFIER_ATTR_VALUE_TO
547: ,P_COMPARISON_OPERATOR_CODE => COMPARISION_OPERATOR_CODE);