91: ,'Item Range : ' || FROM_ITEM || ' - All '
92: ,'Item Range : ' || FROM_ITEM || ' - ' || TO_ITEM))
93: INTO RANGEV
94: FROM
95: DUAL;
96: RETURN (RANGEV);
97: END CF_RANGEFORMULA;
98:
99: FUNCTION USERCFFORMULA RETURN VARCHAR2 IS
114: SELECT
115: 'All'
116: INTO FROM_ITEMCP
117: FROM
118: DUAL;
119: ELSE
120: FROM_ITEMCP := FROM_ITEM;
121: END IF;
122: RETURN (FROM_ITEMCP);
128: SELECT
129: 'All'
130: INTO TO_ITEMCP
131: FROM
132: DUAL;
133: ELSE
134: TO_ITEMCP := TO_ITEM;
135: END IF;
136: RETURN (TO_ITEMCP);
142: SELECT
143: 'All'
144: INTO TO_WHSECP
145: FROM
146: DUAL;
147: ELSE
148: TO_WHSECP := TO_WHSE;
149: END IF;
150: RETURN (TO_WHSECP);
156: SELECT
157: 'All'
158: INTO FROM_WHSECP
159: FROM
160: DUAL;
161: ELSE
162: FROM_WHSECP := FROM_WHSE;
163: END IF;
164: RETURN (FROM_WHSECP);