APPS.GMI_RIWHM_XMLP_PKG dependencies on DUAL

Line 43: DUAL;

39: ,' Warehouse Range: ' || FROM_WHSE || ' - All '
40: ,' Warehouse Range: ' || FROM_WHSE || ' - ' || TO_WHSE))
41: INTO RANGEV
42: FROM
43: DUAL;
44: ELSIF SORT_BY = 'Description' THEN
45: SELECT
46: DECODE(FROM_DESCRIPTION
47: ,NULL

Line 58: DUAL;

54: ,' Description Range: ' || FROM_DESCRIPTION || ' - All '
55: ,' Description Range: ' || FROM_DESCRIPTION || ' - ' || TO_DESCRIPTION))
56: INTO RANGEV
57: FROM
58: DUAL;
59: ELSIF SORT_BY = 'Region' THEN
60: SELECT
61: DECODE(FROM_REGION
62: ,NULL

Line 73: DUAL;

69: ,' Region Range: ' || FROM_REGION || ' - All '
70: ,' Region Range: ' || FROM_REGION || ' - ' || TO_REGION))
71: INTO RANGEV
72: FROM
73: DUAL;
74: ELSIF SORT_BY = 'Class' THEN
75: SELECT
76: DECODE(FROM_CLASS
77: ,NULL

Line 88: DUAL;

84: ,' class Range: ' || FROM_CLASS || ' - All '
85: ,' class Range: ' || FROM_CLASS || ' - ' || TO_CLASS))
86: INTO RANGEV
87: FROM
88: DUAL;
89: END IF;
90: RETURN (RANGEV);
91: END RANGE1FORMULA;
92:

Line 101: DUAL;

97: SELECT
98: 'Whse'
99: INTO SORT1
100: FROM
101: DUAL;
102: ELSIF SORT_BY = 'Description' THEN
103: SELECT
104: 'Description'
105: INTO SORT1

Line 107: DUAL;

103: SELECT
104: 'Description'
105: INTO SORT1
106: FROM
107: DUAL;
108: ELSIF SORT_BY = 'Region' THEN
109: SELECT
110: 'Region'
111: INTO SORT1

Line 113: DUAL;

109: SELECT
110: 'Region'
111: INTO SORT1
112: FROM
113: DUAL;
114: ELSE
115: SELECT
116: 'Class'
117: INTO SORT1

Line 119: DUAL;

115: SELECT
116: 'Class'
117: INTO SORT1
118: FROM
119: DUAL;
120: END IF;
121: RETURN (SORT1);
122: END SORTCFFORMULA;
123:

Line 173: DUAL;

169: SELECT
170: 'All'
171: INTO FROM_WHSECP
172: FROM
173: DUAL;
174: ELSE
175: FROM_WHSECP := FROM_WHSE;
176: END IF;
177: RETURN (FROM_WHSECP);

Line 187: DUAL;

183: SELECT
184: 'All'
185: INTO FROM_DESCRIPTIONCP
186: FROM
187: DUAL;
188: ELSE
189: FROM_DESCRIPTIONCP := FROM_DESCRIPTION;
190: END IF;
191: RETURN (FROM_DESCRIPTIONCP);

Line 201: DUAL;

197: SELECT
198: 'All'
199: INTO TO_WHSECP
200: FROM
201: DUAL;
202: ELSE
203: TO_WHSECP := TO_WHSE;
204: END IF;
205: RETURN (TO_WHSECP);

Line 215: DUAL;

211: SELECT
212: 'All'
213: INTO TO_DESCRIPTIONCP
214: FROM
215: DUAL;
216: ELSE
217: TO_DESCRIPTIONCP := TO_DESCRIPTION;
218: END IF;
219: RETURN (TO_DESCRIPTIONCP);

Line 236: DUAL;

232: SELECT
233: 'All'
234: INTO FROM_REGIONCP
235: FROM
236: DUAL;
237: ELSE
238: FROM_REGIONCP := FROM_REGION;
239: END IF;
240: RETURN (FROM_REGIONCP);

Line 250: DUAL;

246: SELECT
247: 'All'
248: INTO TO_REGIONCP
249: FROM
250: DUAL;
251: ELSE
252: TO_REGIONCP := TO_REGION;
253: END IF;
254: RETURN (TO_REGIONCP);

Line 264: DUAL;

260: SELECT
261: 'All'
262: INTO FROM_CLASSCP
263: FROM
264: DUAL;
265: ELSE
266: FROM_CLASSCP := FROM_CLASS;
267: END IF;
268: RETURN (FROM_CLASSCP);

Line 278: DUAL;

274: SELECT
275: 'All'
276: INTO TO_CLASSCP
277: FROM
278: DUAL;
279: ELSE
280: TO_CLASSCP := TO_CLASS;
281: END IF;
282: RETURN (TO_CLASSCP);