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

Line 180: --STPROC.INIT('begin FND_PROFILE.PUT(:NAME, :VAL); end;');

176: END RP_COMPANY_NAME_P;
177: PROCEDURE PUT(NAME IN VARCHAR2
178: ,VAL IN VARCHAR2) IS
179: BEGIN
180: --STPROC.INIT('begin FND_PROFILE.PUT(:NAME, :VAL); end;');
181: begin FND_PROFILE.PUT(NAME, VAL);
182: end;
183: --STPROC.BIND_I(NAME);
184: --STPROC.BIND_I(VAL);

Line 181: begin FND_PROFILE.PUT(NAME, VAL);

177: PROCEDURE PUT(NAME IN VARCHAR2
178: ,VAL IN VARCHAR2) IS
179: BEGIN
180: --STPROC.INIT('begin FND_PROFILE.PUT(:NAME, :VAL); end;');
181: begin FND_PROFILE.PUT(NAME, VAL);
182: end;
183: --STPROC.BIND_I(NAME);
184: --STPROC.BIND_I(VAL);
185: --STPROC.EXECUTE;

Line 192: begin X0rv := FND_PROFILE.DEFINED(NAME);

188: X0 NUMBER;
189: BEGIN
190: /*declare
191: X0rv BOOLEAN;
192: begin X0rv := FND_PROFILE.DEFINED(NAME);
193: X0 := sys.diutil.bool_to_int(X0rv);
194: end;
195: STPROC.INIT('declare X0rv BOOLEAN;
196: begin X0rv := FND_PROFILE.DEFINED(:NAME); :X0 := sys.diutil.bool_to_int(X0rv); end;');

Line 196: begin X0rv := FND_PROFILE.DEFINED(:NAME); :X0 := sys.diutil.bool_to_int(X0rv); end;');

192: begin X0rv := FND_PROFILE.DEFINED(NAME);
193: X0 := sys.diutil.bool_to_int(X0rv);
194: end;
195: STPROC.INIT('declare X0rv BOOLEAN;
196: begin X0rv := FND_PROFILE.DEFINED(:NAME); :X0 := sys.diutil.bool_to_int(X0rv); end;');
197: STPROC.BIND_I(NAME);
198: STPROC.BIND_O(X0);
199: STPROC.EXECUTE;
200: STPROC.RETRIEVE(2

Line 208: /* STPROC.INIT('begin FND_PROFILE.GET(:NAME, :VAL); end;');

204: END DEFINED;
205: PROCEDURE GET(NAME IN VARCHAR2
206: ,VAL OUT NOCOPY VARCHAR2) IS
207: BEGIN
208: /* STPROC.INIT('begin FND_PROFILE.GET(:NAME, :VAL); end;');
209: STPROC.BIND_I(NAME);
210: STPROC.BIND_O(VAL);
211: STPROC.EXECUTE;
212: STPROC.RETRIEVE(2

Line 215: FND_PROFILE.GET(NAME, VAL);

211: STPROC.EXECUTE;
212: STPROC.RETRIEVE(2
213: ,VAL);*/
214: begin
215: FND_PROFILE.GET(NAME, VAL);
216: end;
217: END GET;
218: FUNCTION VALUE(NAME IN VARCHAR2) RETURN VARCHAR2 IS
219: X0 VARCHAR2(2000);

Line 221: /* STPROC.INIT('begin :X0 := FND_PROFILE.VALUE(:NAME); end;');

217: END GET;
218: FUNCTION VALUE(NAME IN VARCHAR2) RETURN VARCHAR2 IS
219: X0 VARCHAR2(2000);
220: BEGIN
221: /* STPROC.INIT('begin :X0 := FND_PROFILE.VALUE(:NAME); end;');
222: STPROC.BIND_O(X0);
223: STPROC.BIND_I(NAME);
224: STPROC.EXECUTE;
225: STPROC.RETRIEVE(1

Line 228: X0 := FND_PROFILE.VALUE(NAME);

224: STPROC.EXECUTE;
225: STPROC.RETRIEVE(1
226: ,X0);
227: begin
228: X0 := FND_PROFILE.VALUE(NAME);
229: end;
230: RETURN X0;*/
231: return null;
232: END VALUE;

Line 236: /* STPROC.INIT('begin :X0 := FND_PROFILE.VALUE_WNPS(:NAME); end;');

232: END VALUE;
233: FUNCTION VALUE_WNPS(NAME IN VARCHAR2) RETURN VARCHAR2 IS
234: X0 VARCHAR2(2000);
235: BEGIN
236: /* STPROC.INIT('begin :X0 := FND_PROFILE.VALUE_WNPS(:NAME); end;');
237: STPROC.BIND_O(X0);
238: STPROC.BIND_I(NAME);
239: STPROC.EXECUTE;
240: STPROC.RETRIEVE(1

Line 243: X0 := FND_PROFILE.VALUE_WNPS(NAME);

239: STPROC.EXECUTE;
240: STPROC.RETRIEVE(1
241: ,X0);*/
242: begin
243: X0 := FND_PROFILE.VALUE_WNPS(NAME);
244: end;
245: RETURN X0;
246: END VALUE_WNPS;
247: FUNCTION SAVE_USER(X_NAME IN VARCHAR2

Line 251: /* STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := FND_PROFILE.SAVE_USER(:X_NAME, :X_VALUE); :X0 := sys.diutil.bool_to_int(X0rv); end;');

247: FUNCTION SAVE_USER(X_NAME IN VARCHAR2
248: ,X_VALUE IN VARCHAR2) RETURN BOOLEAN IS
249: X0 NUMBER;
250: BEGIN
251: /* STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := FND_PROFILE.SAVE_USER(:X_NAME, :X_VALUE); :X0 := sys.diutil.bool_to_int(X0rv); end;');
252: STPROC.BIND_I(X_NAME);
253: STPROC.BIND_I(X_VALUE);
254: STPROC.BIND_O(X0);
255: STPROC.EXECUTE;

Line 260: begin X0rv := FND_PROFILE.SAVE_USER(X_NAME, X_VALUE);

256: STPROC.RETRIEVE(3
257: ,X0);
258: declare
259: X0rv BOOLEAN;
260: begin X0rv := FND_PROFILE.SAVE_USER(X_NAME, X_VALUE);
261: X0 := sys.diutil.bool_to_int(X0rv);
262: end;
263: RETURN X0;*/
264: return null;

Line 273: /* STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := FND_PROFILE.SAVE(:X_NAME, :X_VALUE, :X_LEVEL_NAME, :X_LEVEL_VALUE, :X_LEVEL_VALUE_APP_ID); :X0 := sys.diutil.bool_to_int(X0rv); end;');

269: ,X_LEVEL_VALUE IN VARCHAR2
270: ,X_LEVEL_VALUE_APP_ID IN VARCHAR2) RETURN BOOLEAN IS
271: X0 NUMBER;
272: BEGIN
273: /* STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := FND_PROFILE.SAVE(:X_NAME, :X_VALUE, :X_LEVEL_NAME, :X_LEVEL_VALUE, :X_LEVEL_VALUE_APP_ID); :X0 := sys.diutil.bool_to_int(X0rv); end;');
274: STPROC.BIND_I(X_NAME);
275: STPROC.BIND_I(X_VALUE);
276: STPROC.BIND_I(X_LEVEL_NAME);
277: STPROC.BIND_I(X_LEVEL_VALUE);

Line 285: begin X0rv := FND_PROFILE.SAVE(X_NAME, X_VALUE, X_LEVEL_NAME, X_LEVEL_VALUE, X_LEVEL_VALUE_APP_ID);

281: STPROC.RETRIEVE(6
282: ,X0);
283: declare
284: X0rv BOOLEAN;
285: begin X0rv := FND_PROFILE.SAVE(X_NAME, X_VALUE, X_LEVEL_NAME, X_LEVEL_VALUE, X_LEVEL_VALUE_APP_ID);
286: X0 := sys.diutil.bool_to_int(X0rv);
287: end;
288: RETURN X0;*/
289: return null;

Line 298: /* STPROC.INIT('declare DEFINED_Z BOOLEAN; begin DEFINED_Z := sys.diutil.int_to_bool(:DEFINED_Z); FND_PROFILE.GET_SPECIFIC(:NAME_Z, :USER_ID_Z, :RESPONSIBILITY_ID_Z, :APPLICATION_ID_Z, :VAL_Z, DEFINED_Z);

294: ,APPLICATION_ID_Z IN NUMBER
295: ,VAL_Z OUT NOCOPY VARCHAR2
296: ,DEFINED_Z OUT NOCOPY BOOLEAN) IS
297: BEGIN
298: /* STPROC.INIT('declare DEFINED_Z BOOLEAN; begin DEFINED_Z := sys.diutil.int_to_bool(:DEFINED_Z); FND_PROFILE.GET_SPECIFIC(:NAME_Z, :USER_ID_Z, :RESPONSIBILITY_ID_Z, :APPLICATION_ID_Z, :VAL_Z, DEFINED_Z);
299: :DEFINED_Z := sys.diutil.bool_to_int(DEFINED_Z); end;');
300: STPROC.BIND_O(DEFINED_Z);
301: STPROC.BIND_I(NAME_Z);
302: STPROC.BIND_I(USER_ID_Z);

Line 314: FND_PROFILE.GET_SPECIFIC(NAME_Z, USER_ID_Z, RESPONSIBILITY_ID_Z, APPLICATION_ID_Z, VAL_Z, DEFINED_Z);

310: ,VAL_Z);
311: declare DEFINED_Z BOOLEAN;
312: begin
313: --DEFINED_Z := sys.diutil.int_to_bool(DEFINED_Z);
314: FND_PROFILE.GET_SPECIFIC(NAME_Z, USER_ID_Z, RESPONSIBILITY_ID_Z, APPLICATION_ID_Z, VAL_Z, DEFINED_Z);
315: DEFINED_Z := sys.diutil.bool_to_int(DEFINED_Z);
316: end;*/
317: null;
318: END GET_SPECIFIC;

Line 325: /* STPROC.INIT('begin :X0 := FND_PROFILE.VALUE_SPECIFIC(:NAME, :USER_ID, :RESPONSIBILITY_ID, :APPLICATION_ID); end;');

321: ,RESPONSIBILITY_ID IN NUMBER
322: ,APPLICATION_ID IN NUMBER) RETURN VARCHAR2 IS
323: X0 VARCHAR2(2000);
324: BEGIN
325: /* STPROC.INIT('begin :X0 := FND_PROFILE.VALUE_SPECIFIC(:NAME, :USER_ID, :RESPONSIBILITY_ID, :APPLICATION_ID); end;');
326: STPROC.BIND_O(X0);
327: STPROC.BIND_I(NAME);
328: STPROC.BIND_I(USER_ID);
329: STPROC.BIND_I(RESPONSIBILITY_ID);

Line 335: X0 := FND_PROFILE.VALUE_SPECIFIC(NAME, USER_ID, RESPONSIBILITY_ID, APPLICATION_ID);

331: STPROC.EXECUTE;
332: STPROC.RETRIEVE(1
333: ,X0);
334: begin
335: X0 := FND_PROFILE.VALUE_SPECIFIC(NAME, USER_ID, RESPONSIBILITY_ID, APPLICATION_ID);
336: end;
337: RETURN X0;
338: */
339: return null;

Line 346: /* STPROC.INIT('begin FND_PROFILE.INITIALIZE(:USER_ID_Z, :RESPONSIBILITY_ID_Z, :APPLICATION_ID_Z, :SITE_ID_Z); end;');

342: ,RESPONSIBILITY_ID_Z IN NUMBER
343: ,APPLICATION_ID_Z IN NUMBER
344: ,SITE_ID_Z IN NUMBER) IS
345: BEGIN
346: /* STPROC.INIT('begin FND_PROFILE.INITIALIZE(:USER_ID_Z, :RESPONSIBILITY_ID_Z, :APPLICATION_ID_Z, :SITE_ID_Z); end;');
347: STPROC.BIND_I(USER_ID_Z);
348: STPROC.BIND_I(RESPONSIBILITY_ID_Z);
349: STPROC.BIND_I(APPLICATION_ID_Z);
350: STPROC.BIND_I(SITE_ID_Z);

Line 353: FND_PROFILE.INITIALIZE(USER_ID_Z, RESPONSIBILITY_ID_Z, APPLICATION_ID_Z, SITE_ID_Z);

349: STPROC.BIND_I(APPLICATION_ID_Z);
350: STPROC.BIND_I(SITE_ID_Z);
351: STPROC.EXECUTE;*/
352: begin
353: FND_PROFILE.INITIALIZE(USER_ID_Z, RESPONSIBILITY_ID_Z, APPLICATION_ID_Z, SITE_ID_Z);
354: end;
355: END INITIALIZE;
356: PROCEDURE PUTMULTIPLE(NAMES IN VARCHAR2
357: ,VALS IN VARCHAR2

Line 360: /* STPROC.INIT('begin FND_PROFILE.PUTMULTIPLE(:NAMES, :VALS, :NUM); end;');

356: PROCEDURE PUTMULTIPLE(NAMES IN VARCHAR2
357: ,VALS IN VARCHAR2
358: ,NUM IN NUMBER) IS
359: BEGIN
360: /* STPROC.INIT('begin FND_PROFILE.PUTMULTIPLE(:NAMES, :VALS, :NUM); end;');
361: STPROC.BIND_I(NAMES);
362: STPROC.BIND_I(VALS);
363: STPROC.BIND_I(NUM);
364: STPROC.EXECUTE;*/

Line 365: begin FND_PROFILE.PUTMULTIPLE(NAMES, VALS, NUM);

361: STPROC.BIND_I(NAMES);
362: STPROC.BIND_I(VALS);
363: STPROC.BIND_I(NUM);
364: STPROC.EXECUTE;*/
365: begin FND_PROFILE.PUTMULTIPLE(NAMES, VALS, NUM);
366: end;
367: END PUTMULTIPLE;
368: PROCEDURE CS_GET_COMPANY_NAME(RP_COMPANY_NAME IN OUT NOCOPY VARCHAR2
369: ,P_SOB_ID IN NUMBER) IS