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.GML_ORAKRP_XMLP_PKG dependencies on FND_PROFILE

Line 137: FROM_ORDER_NUMBER := FND_PROFILE.VALUE('SY$ALL');

133: IF FROM_ORDER_NUMBER IS NOT NULL AND TO_ORDER_NUMBER IS NOT NULL THEN
134: ORDER_NUMBERCP := ' and ordr_hdr.order_no >= ''' || FROM_ORDER_NUMBER || ''' and ordr_hdr.order_no <= ''' || TO_ORDER_NUMBER || '''';
135: ELSIF FROM_ORDER_NUMBER IS NULL AND TO_ORDER_NUMBER IS NULL THEN
136: ORDER_NUMBERCP := NULL;
137: FROM_ORDER_NUMBER := FND_PROFILE.VALUE('SY$ALL');
138: TO_ORDER_NUMBER := FND_PROFILE.VALUE('SY$ALL');
139: ELSIF FROM_ORDER_NUMBER IS NOT NULL AND TO_ORDER_NUMBER IS NULL THEN
140: ORDER_NUMBERCP := ' and ordr_hdr.order_no >= ''' || FROM_ORDER_NUMBER || '''';
141: TO_ORDER_NUMBER := FND_PROFILE.VALUE('SY$ALL');

Line 138: TO_ORDER_NUMBER := FND_PROFILE.VALUE('SY$ALL');

134: ORDER_NUMBERCP := ' and ordr_hdr.order_no >= ''' || FROM_ORDER_NUMBER || ''' and ordr_hdr.order_no <= ''' || TO_ORDER_NUMBER || '''';
135: ELSIF FROM_ORDER_NUMBER IS NULL AND TO_ORDER_NUMBER IS NULL THEN
136: ORDER_NUMBERCP := NULL;
137: FROM_ORDER_NUMBER := FND_PROFILE.VALUE('SY$ALL');
138: TO_ORDER_NUMBER := FND_PROFILE.VALUE('SY$ALL');
139: ELSIF FROM_ORDER_NUMBER IS NOT NULL AND TO_ORDER_NUMBER IS NULL THEN
140: ORDER_NUMBERCP := ' and ordr_hdr.order_no >= ''' || FROM_ORDER_NUMBER || '''';
141: TO_ORDER_NUMBER := FND_PROFILE.VALUE('SY$ALL');
142: ELSIF FROM_ORDER_NUMBER IS NULL AND TO_ORDER_NUMBER IS NOT NULL THEN

Line 141: TO_ORDER_NUMBER := FND_PROFILE.VALUE('SY$ALL');

137: FROM_ORDER_NUMBER := FND_PROFILE.VALUE('SY$ALL');
138: TO_ORDER_NUMBER := FND_PROFILE.VALUE('SY$ALL');
139: ELSIF FROM_ORDER_NUMBER IS NOT NULL AND TO_ORDER_NUMBER IS NULL THEN
140: ORDER_NUMBERCP := ' and ordr_hdr.order_no >= ''' || FROM_ORDER_NUMBER || '''';
141: TO_ORDER_NUMBER := FND_PROFILE.VALUE('SY$ALL');
142: ELSIF FROM_ORDER_NUMBER IS NULL AND TO_ORDER_NUMBER IS NOT NULL THEN
143: ORDER_NUMBERCP := ' and ordr_hdr.order_no <= ''' || TO_ORDER_NUMBER || '''';
144: FROM_ORDER_NUMBER := FND_PROFILE.VALUE('SY$ALL');
145: END IF;

Line 144: FROM_ORDER_NUMBER := FND_PROFILE.VALUE('SY$ALL');

140: ORDER_NUMBERCP := ' and ordr_hdr.order_no >= ''' || FROM_ORDER_NUMBER || '''';
141: TO_ORDER_NUMBER := FND_PROFILE.VALUE('SY$ALL');
142: ELSIF FROM_ORDER_NUMBER IS NULL AND TO_ORDER_NUMBER IS NOT NULL THEN
143: ORDER_NUMBERCP := ' and ordr_hdr.order_no <= ''' || TO_ORDER_NUMBER || '''';
144: FROM_ORDER_NUMBER := FND_PROFILE.VALUE('SY$ALL');
145: END IF;
146: LTO_ORDER_NUMBER:=TO_ORDER_NUMBER;
147: LFROM_ORDER_NUMBER:=FROM_ORDER_NUMBER;
148: RETURN NULL;

Line 175: FROM_SOLD_TO := FND_PROFILE.VALUE('SY$ALL');

171: ELSIF FROM_SOLD_TO IS NOT NULL AND TO_SOLD_TO IS NOT NULL THEN
172: SOLD_TOCP := ' and soldcust.cust_no between ' || '''' || FROM_SOLD_TO || ''' and ' || '''' || TO_SOLD_TO || '''';
173: ELSIF FROM_SOLD_TO IS NULL AND TO_SOLD_TO IS NULL THEN
174: SOLD_TOCP := NULL;
175: FROM_SOLD_TO := FND_PROFILE.VALUE('SY$ALL');
176: TO_SOLD_TO := FND_PROFILE.VALUE('SY$ALL');
177: ELSIF FROM_SOLD_TO IS NOT NULL AND TO_SOLD_TO IS NULL THEN
178: SOLD_TOCP := 'soldcust.cust_no >= ' || '''' || FROM_SOLD_TO || '''';
179: FROM_SOLD_TO := FND_PROFILE.VALUE('SY$ALL');

Line 176: TO_SOLD_TO := FND_PROFILE.VALUE('SY$ALL');

172: SOLD_TOCP := ' and soldcust.cust_no between ' || '''' || FROM_SOLD_TO || ''' and ' || '''' || TO_SOLD_TO || '''';
173: ELSIF FROM_SOLD_TO IS NULL AND TO_SOLD_TO IS NULL THEN
174: SOLD_TOCP := NULL;
175: FROM_SOLD_TO := FND_PROFILE.VALUE('SY$ALL');
176: TO_SOLD_TO := FND_PROFILE.VALUE('SY$ALL');
177: ELSIF FROM_SOLD_TO IS NOT NULL AND TO_SOLD_TO IS NULL THEN
178: SOLD_TOCP := 'soldcust.cust_no >= ' || '''' || FROM_SOLD_TO || '''';
179: FROM_SOLD_TO := FND_PROFILE.VALUE('SY$ALL');
180: ELSIF FROM_SOLD_TO IS NULL AND TO_SOLD_TO IS NOT NULL THEN

Line 179: FROM_SOLD_TO := FND_PROFILE.VALUE('SY$ALL');

175: FROM_SOLD_TO := FND_PROFILE.VALUE('SY$ALL');
176: TO_SOLD_TO := FND_PROFILE.VALUE('SY$ALL');
177: ELSIF FROM_SOLD_TO IS NOT NULL AND TO_SOLD_TO IS NULL THEN
178: SOLD_TOCP := 'soldcust.cust_no >= ' || '''' || FROM_SOLD_TO || '''';
179: FROM_SOLD_TO := FND_PROFILE.VALUE('SY$ALL');
180: ELSIF FROM_SOLD_TO IS NULL AND TO_SOLD_TO IS NOT NULL THEN
181: SOLD_TOCP := 'and soldcust.cust_no <= ' || '''' || TO_SOLD_TO || '''';
182: TO_SOLD_TO := FND_PROFILE.VALUE('SY$ALL');
183: END IF;

Line 182: TO_SOLD_TO := FND_PROFILE.VALUE('SY$ALL');

178: SOLD_TOCP := 'soldcust.cust_no >= ' || '''' || FROM_SOLD_TO || '''';
179: FROM_SOLD_TO := FND_PROFILE.VALUE('SY$ALL');
180: ELSIF FROM_SOLD_TO IS NULL AND TO_SOLD_TO IS NOT NULL THEN
181: SOLD_TOCP := 'and soldcust.cust_no <= ' || '''' || TO_SOLD_TO || '''';
182: TO_SOLD_TO := FND_PROFILE.VALUE('SY$ALL');
183: END IF;
184: LTO_SOLD_TO:=TO_SOLD_TO;
185: LFROM_SOLD_TO:=FROM_SOLD_TO;
186: RETURN NULL;

Line 198: FROM_BILL_TO := FND_PROFILE.VALUE('SY$ALL');

194: ELSIF FROM_BILL_TO IS NOT NULL AND TO_BILL_TO IS NOT NULL THEN
195: BILL_TOCP := ' and billcust.cust_no between ' || '''' || FROM_BILL_TO || ''' and ' || '''' || TO_BILL_TO || '''';
196: ELSIF FROM_BILL_TO IS NULL AND TO_BILL_TO IS NULL THEN
197: BILL_TOCP := NULL;
198: FROM_BILL_TO := FND_PROFILE.VALUE('SY$ALL');
199: TO_BILL_TO := FND_PROFILE.VALUE('SY$ALL');
200: ELSIF FROM_BILL_TO IS NOT NULL AND TO_BILL_TO IS NULL THEN
201: BILL_TOCP := 'billcust.cust_no >= ' || '''' || FROM_BILL_TO || '''';
202: TO_BILL_TO := FND_PROFILE.VALUE('SY$ALL');

Line 199: TO_BILL_TO := FND_PROFILE.VALUE('SY$ALL');

195: BILL_TOCP := ' and billcust.cust_no between ' || '''' || FROM_BILL_TO || ''' and ' || '''' || TO_BILL_TO || '''';
196: ELSIF FROM_BILL_TO IS NULL AND TO_BILL_TO IS NULL THEN
197: BILL_TOCP := NULL;
198: FROM_BILL_TO := FND_PROFILE.VALUE('SY$ALL');
199: TO_BILL_TO := FND_PROFILE.VALUE('SY$ALL');
200: ELSIF FROM_BILL_TO IS NOT NULL AND TO_BILL_TO IS NULL THEN
201: BILL_TOCP := 'billcust.cust_no >= ' || '''' || FROM_BILL_TO || '''';
202: TO_BILL_TO := FND_PROFILE.VALUE('SY$ALL');
203: ELSIF FROM_BILL_TO IS NULL AND TO_BILL_TO IS NOT NULL THEN

Line 202: TO_BILL_TO := FND_PROFILE.VALUE('SY$ALL');

198: FROM_BILL_TO := FND_PROFILE.VALUE('SY$ALL');
199: TO_BILL_TO := FND_PROFILE.VALUE('SY$ALL');
200: ELSIF FROM_BILL_TO IS NOT NULL AND TO_BILL_TO IS NULL THEN
201: BILL_TOCP := 'billcust.cust_no >= ' || '''' || FROM_BILL_TO || '''';
202: TO_BILL_TO := FND_PROFILE.VALUE('SY$ALL');
203: ELSIF FROM_BILL_TO IS NULL AND TO_BILL_TO IS NOT NULL THEN
204: BILL_TOCP := 'and billcust.cust_no <= ' || '''' || TO_BILL_TO || '''';
205: FROM_BILL_TO := FND_PROFILE.VALUE('SY$ALL');
206: END IF;

Line 205: FROM_BILL_TO := FND_PROFILE.VALUE('SY$ALL');

201: BILL_TOCP := 'billcust.cust_no >= ' || '''' || FROM_BILL_TO || '''';
202: TO_BILL_TO := FND_PROFILE.VALUE('SY$ALL');
203: ELSIF FROM_BILL_TO IS NULL AND TO_BILL_TO IS NOT NULL THEN
204: BILL_TOCP := 'and billcust.cust_no <= ' || '''' || TO_BILL_TO || '''';
205: FROM_BILL_TO := FND_PROFILE.VALUE('SY$ALL');
206: END IF;
207: LFROM_BILL_TO:=FROM_BILL_TO;
208: LTO_BILL_TO:=TO_BILL_TO;
209: RETURN NULL;