eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OM_REPORTS_MLS_LANG dependencies on FND_REQUEST_INFO

Line 47: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Order Number (From)', parm_number

43:
44: BEGIN
45:
46: -- ORDER NUMBER (From)
47: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Order Number (From)', parm_number
48: );
49:
50: IF (ret_val = -1) THEN
51: p_order_number_lo := NULL;

Line 53: p_order_number_lo := TO_NUMBER(FND_REQUEST_INFO.GET_PARAMETER(parm_number))

49:
50: IF (ret_val = -1) THEN
51: p_order_number_lo := NULL;
52: ELSE
53: p_order_number_lo := TO_NUMBER(FND_REQUEST_INFO.GET_PARAMETER(parm_number))
54: ;
55:
56: END IF;
57:

Line 59: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Order Number (To)', parm_number);

55:
56: END IF;
57:
58: -- ORDER NUMBER (To)
59: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Order Number (To)', parm_number);
60:
61: IF (ret_val = -1) THEN
62: p_order_number_hi := NULL;
63: ELSE

Line 64: p_order_number_hi := TO_NUMBER(FND_REQUEST_INFO.GET_PARAMETER(parm_number))

60:
61: IF (ret_val = -1) THEN
62: p_order_number_hi := NULL;
63: ELSE
64: p_order_number_hi := TO_NUMBER(FND_REQUEST_INFO.GET_PARAMETER(parm_number))
65: ;
66:
67: END IF;
68:

Line 70: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Order Date (From)', parm_number);

66:
67: END IF;
68:
69: -- ORDER DATE(From)
70: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Order Date (From)', parm_number);
71:
72:
73: IF (ret_val = -1) THEN
74: p_order_date_lo := NULL;

Line 76: p_order_date_lo := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER

72:
73: IF (ret_val = -1) THEN
74: p_order_date_lo := NULL;
75: ELSE
76: p_order_date_lo := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER
77: (parm_number));
78:
79: END IF;
80:

Line 82: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Order Date (To)', parm_number)

78:
79: END IF;
80:
81: -- ORDER DATE To
82: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Order Date (To)', parm_number)
83: ;
84:
85: IF (ret_val = -1) THEN
86: p_order_date_hi := NULL;

Line 88: p_order_date_hi := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER

84:
85: IF (ret_val = -1) THEN
86: p_order_date_hi := NULL;
87: ELSE
88: p_order_date_hi := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER
89: (parm_number));
90:
91: END IF;
92:

Line 95: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Schedule Date (From)', parm_number);

91: END IF;
92:
93:
94: --SCHEDULE DATE(From)
95: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Schedule Date (From)', parm_number);
96:
97:
98: IF (ret_val = -1) THEN
99: p_schedule_date_lo := NULL;

Line 101: p_schedule_date_lo := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(parm_number));

97:
98: IF (ret_val = -1) THEN
99: p_schedule_date_lo := NULL;
100: ELSE
101: p_schedule_date_lo := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(parm_number));
102:
103: END IF;
104:
105: -- SCHEDULE DATE To

Line 106: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Schedule Date (To)', parm_number)

102:
103: END IF;
104:
105: -- SCHEDULE DATE To
106: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Schedule Date (To)', parm_number)
107: ;
108:
109: IF (ret_val = -1) THEN
110: p_schedule_date_hi := NULL;

Line 112: p_schedule_date_hi := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(parm_number));

108:
109: IF (ret_val = -1) THEN
110: p_schedule_date_hi := NULL;
111: ELSE
112: p_schedule_date_hi := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(parm_number));
113:
114: END IF;
115:
116: -- PROMISE DATE(From)

Line 117: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Promise Date (From)', parm_number);

113:
114: END IF;
115:
116: -- PROMISE DATE(From)
117: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Promise Date (From)', parm_number);
118:
119:
120: IF (ret_val = -1) THEN
121: p_promise_date_lo := NULL;

Line 123: p_promise_date_lo := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(parm_number));

119:
120: IF (ret_val = -1) THEN
121: p_promise_date_lo := NULL;
122: ELSE
123: p_promise_date_lo := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(parm_number));
124:
125: END IF;
126:
127: -- PROMISE DATE To

Line 128: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Promise Date (To)', parm_number)

124:
125: END IF;
126:
127: -- PROMISE DATE To
128: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Promise Date (To)', parm_number)
129: ;
130:
131: IF (ret_val = -1) THEN
132: p_promise_date_hi := NULL;

Line 134: p_promise_date_hi := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(parm_number));

130:
131: IF (ret_val = -1) THEN
132: p_promise_date_hi := NULL;
133: ELSE
134: p_promise_date_hi := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(parm_number));
135:
136: END IF;
137:
138: --REQUEST DATE(From)

Line 139: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Request Date (From)', parm_number);

135:
136: END IF;
137:
138: --REQUEST DATE(From)
139: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Request Date (From)', parm_number);
140:
141:
142: IF (ret_val = -1) THEN
143: p_request_date_lo := NULL;

Line 145: p_request_date_lo := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(parm_number));

141:
142: IF (ret_val = -1) THEN
143: p_request_date_lo := NULL;
144: ELSE
145: p_request_date_lo := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(parm_number));
146:
147: END IF;
148:
149: -- REQUEST DATE To

Line 150: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Request Date (To)', parm_number)

146:
147: END IF;
148:
149: -- REQUEST DATE To
150: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Request Date (To)', parm_number)
151: ;
152:
153: IF (ret_val = -1) THEN
154: p_request_date_hi := NULL;

Line 156: p_request_date_hi := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(parm_number));

152:
153: IF (ret_val = -1) THEN
154: p_request_date_hi := NULL;
155: ELSE
156: p_request_date_hi := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(parm_number));
157:
158: END IF;
159:
160: -- BILL TO CUSTOMER NAME(From)

Line 161: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Bill To Customer Name (From)', parm_number);

157:
158: END IF;
159:
160: -- BILL TO CUSTOMER NAME(From)
161: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Bill To Customer Name (From)', parm_number);
162:
163: IF (ret_val = -1) THEN
164: p_bill_to_customer_name_lo := NULL;
165: ELSE

Line 166: p_bill_to_customer_name_lo := FND_REQUEST_INFO.GET_PARAMETER(parm_number);

162:
163: IF (ret_val = -1) THEN
164: p_bill_to_customer_name_lo := NULL;
165: ELSE
166: p_bill_to_customer_name_lo := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
167: END IF;
168:
169: -- BILL TO CUSTOMER NAME To
170: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Bill To Customer Name (To)', parm_number);

Line 170: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Bill To Customer Name (To)', parm_number);

166: p_bill_to_customer_name_lo := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
167: END IF;
168:
169: -- BILL TO CUSTOMER NAME To
170: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Bill To Customer Name (To)', parm_number);
171:
172: IF (ret_val = -1) THEN
173: p_bill_to_customer_name_hi := NULL;
174: ELSE

Line 175: p_bill_to_customer_name_hi := FND_REQUEST_INFO.GET_PARAMETER(parm_number);

171:
172: IF (ret_val = -1) THEN
173: p_bill_to_customer_name_hi := NULL;
174: ELSE
175: p_bill_to_customer_name_hi := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
176: END IF;
177:
178: -- SHIP TO CUSTOMER NAME(From)
179: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Ship To Customer Name (From)', parm_number);

Line 179: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Ship To Customer Name (From)', parm_number);

175: p_bill_to_customer_name_hi := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
176: END IF;
177:
178: -- SHIP TO CUSTOMER NAME(From)
179: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Ship To Customer Name (From)', parm_number);
180:
181: IF (ret_val = -1) THEN
182: p_ship_to_customer_name_lo := NULL;
183: ELSE

Line 184: p_ship_to_customer_name_lo := FND_REQUEST_INFO.GET_PARAMETER(parm_number);

180:
181: IF (ret_val = -1) THEN
182: p_ship_to_customer_name_lo := NULL;
183: ELSE
184: p_ship_to_customer_name_lo := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
185: END IF;
186:
187: -- SHIP TO CUSTOMER NAME To
188: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Ship To Customer Name (To)', parm_number);

Line 188: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Ship To Customer Name (To)', parm_number);

184: p_ship_to_customer_name_lo := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
185: END IF;
186:
187: -- SHIP TO CUSTOMER NAME To
188: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Ship To Customer Name (To)', parm_number);
189:
190: IF (ret_val = -1) THEN
191: p_ship_to_customer_name_hi := NULL;
192: ELSE

Line 193: p_ship_to_customer_name_hi := FND_REQUEST_INFO.GET_PARAMETER(parm_number);

189:
190: IF (ret_val = -1) THEN
191: p_ship_to_customer_name_hi := NULL;
192: ELSE
193: p_ship_to_customer_name_hi := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
194: END IF;
195:
196:
197: -- Deliver TO CUSTOMER NAME(From)

Line 198: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Deliver To Customer (From)', parm_number);

194: END IF;
195:
196:
197: -- Deliver TO CUSTOMER NAME(From)
198: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Deliver To Customer (From)', parm_number);
199:
200: IF (ret_val = -1) THEN
201: p_del_to_customer_name_lo := NULL;
202: ELSE

Line 203: p_del_to_customer_name_lo := FND_REQUEST_INFO.GET_PARAMETER(parm_number);

199:
200: IF (ret_val = -1) THEN
201: p_del_to_customer_name_lo := NULL;
202: ELSE
203: p_del_to_customer_name_lo := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
204: END IF;
205:
206: -- DELIVER TO CUSTOMER NAME To
207: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Deliver To Customer (To)', parm_number);

Line 207: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Deliver To Customer (To)', parm_number);

203: p_del_to_customer_name_lo := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
204: END IF;
205:
206: -- DELIVER TO CUSTOMER NAME To
207: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Deliver To Customer (To)', parm_number);
208:
209: IF (ret_val = -1) THEN
210: p_del_to_customer_name_hi := NULL;
211: ELSE

Line 212: p_del_to_customer_name_hi := FND_REQUEST_INFO.GET_PARAMETER(parm_number);

208:
209: IF (ret_val = -1) THEN
210: p_del_to_customer_name_hi := NULL;
211: ELSE
212: p_del_to_customer_name_hi := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
213: END IF;
214:
215:
216: -- Order Type

Line 217: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Order Type', parm_number);

213: END IF;
214:
215:
216: -- Order Type
217: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Order Type', parm_number);
218:
219:
220: IF (ret_val = -1) THEN
221: p_order_type := NULL;

Line 223: p_order_type := FND_REQUEST_INFO.GET_PARAMETER(parm_number);

219:
220: IF (ret_val = -1) THEN
221: p_order_type := NULL;
222: ELSE
223: p_order_type := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
224:
225: END IF;
226:
227:

Line 229: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Salesperson', parm_number);

225: END IF;
226:
227:
228: -- Salesperson
229: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Salesperson', parm_number);
230:
231:
232: IF (ret_val = -1) THEN
233: p_salesrep := NULL;

Line 235: p_salesrep := FND_REQUEST_INFO.GET_PARAMETER(parm_number);

231:
232: IF (ret_val = -1) THEN
233: p_salesrep := NULL;
234: ELSE
235: p_salesrep := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
236:
237: END IF;
238:
239: -- Open Orders

Line 240: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Open Orders Only', parm_number);

236:
237: END IF;
238:
239: -- Open Orders
240: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Open Orders Only', parm_number);
241:
242:
243: IF (ret_val = -1) THEN
244: p_open_flag := NULL;

Line 246: p_open_flag := FND_REQUEST_INFO.GET_PARAMETER(parm_number);

242:
243: IF (ret_val = -1) THEN
244: p_open_flag := NULL;
245: ELSE
246: p_open_flag := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
247:
248: END IF;
249:
250: -- Booked Status

Line 251: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Booked Status', parm_number);

247:
248: END IF;
249:
250: -- Booked Status
251: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Booked Status', parm_number);
252:
253:
254: IF (ret_val = -1) THEN
255: p_booked_status := NULL;

Line 257: p_booked_status := FND_REQUEST_INFO.GET_PARAMETER(parm_number);

253:
254: IF (ret_val = -1) THEN
255: p_booked_status := NULL;
256: ELSE
257: p_booked_status := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
258:
259: END IF;
260:
261: -- Created By

Line 262: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Created By', parm_number);

258:
259: END IF;
260:
261: -- Created By
262: ret_val := FND_REQUEST_INFO.GET_PARAM_NUMBER('Created By', parm_number);
263:
264:
265: IF (ret_val = -1) THEN
266: p_created_by := NULL;

Line 268: p_created_by := FND_REQUEST_INFO.GET_PARAMETER(parm_number);

264:
265: IF (ret_val = -1) THEN
266: p_created_by := NULL;
267: ELSE
268: p_created_by := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
269:
270: END IF;
271:
272: --Get Base Language