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

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

288:
289: PROCEDURE PUT(NAME IN VARCHAR2
290: ,VAL IN VARCHAR2) IS
291: BEGIN
292: /*STPROC.INIT('begin FND_PROFILE.PUT(:NAME, :VAL); end;');
293: STPROC.BIND_I(NAME);
294: STPROC.BIND_I(VAL);
295: STPROC.EXECUTE;*/
296: null;

Line 302: /*STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := FND_PROFILE.DEFINED(:NAME); :X0 := sys.diutil.bool_to_int(X0rv); end;');

298:
299: FUNCTION DEFINED(NAME IN VARCHAR2) RETURN BOOLEAN IS
300: X0 BOOLEAN;
301: BEGIN
302: /*STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := FND_PROFILE.DEFINED(:NAME); :X0 := sys.diutil.bool_to_int(X0rv); end;');
303: STPROC.BIND_I(NAME);
304: STPROC.BIND_O(X0);
305: STPROC.EXECUTE;
306: STPROC.RETRIEVE(2

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

311: PROCEDURE GET(NAME IN VARCHAR2
312: ,VAL OUT NOCOPY VARCHAR2) IS
313: BEGIN
314: /*
315: STPROC.INIT('begin FND_PROFILE.GET(:NAME, :VAL); end;');
316: STPROC.BIND_I(NAME);
317: STPROC.BIND_O(VAL);
318: STPROC.EXECUTE;
319: STPROC.RETRIEVE(2

Line 327: --STPROC.INIT('begin :X0 := FND_PROFILE.VALUE(:NAME); end;');

323:
324: FUNCTION VALUE(NAME IN VARCHAR2) RETURN VARCHAR2 IS
325: X0 VARCHAR2(2000);
326: BEGIN
327: --STPROC.INIT('begin :X0 := FND_PROFILE.VALUE(:NAME); end;');
328: begin
329: X0 := FND_PROFILE.VALUE(NAME);
330: end;
331: /* STPROC.BIND_O(X0);

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

325: X0 VARCHAR2(2000);
326: BEGIN
327: --STPROC.INIT('begin :X0 := FND_PROFILE.VALUE(:NAME); end;');
328: begin
329: X0 := FND_PROFILE.VALUE(NAME);
330: end;
331: /* STPROC.BIND_O(X0);
332: STPROC.BIND_I(NAME);
333: STPROC.EXECUTE;

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

340: ,X_VALUE IN VARCHAR2) RETURN BOOLEAN IS
341: X0 BOOLEAN;
342: BEGIN
343: /*
344: STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := FND_PROFILE.SAVE_USER(:X_NAME, :X_VALUE); :X0 := sys.diutil.bool_to_int(X0rv); end;');
345: STPROC.BIND_I(X_NAME);
346: STPROC.BIND_I(X_VALUE);
347: STPROC.BIND_O(X0);
348: STPROC.EXECUTE;

Line 362: 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;');

358: ,X_LEVEL_VALUE_APP_ID IN VARCHAR2) RETURN BOOLEAN IS
359: X0 BOOLEAN;
360: BEGIN
361: /*
362: 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;');
363: STPROC.BIND_I(X_NAME);
364: STPROC.BIND_I(X_VALUE);
365: STPROC.BIND_I(X_LEVEL_NAME);
366: STPROC.BIND_I(X_LEVEL_VALUE);

Line 382: /* 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);

378: ,APPLICATION_ID_Z IN NUMBER
379: ,VAL_Z OUT NOCOPY VARCHAR2
380: ,DEFINED_Z OUT NOCOPY BOOLEAN) IS
381: BEGIN
382: /* 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);
383: :DEFINED_Z := sys.diutil.bool_to_int(DEFINED_Z); end;');
384: STPROC.BIND_O(DEFINED_Z);
385: STPROC.BIND_I(NAME_Z);
386: STPROC.BIND_I(USER_ID_Z);

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

401: ,APPLICATION_ID IN NUMBER) RETURN VARCHAR2 IS
402: X0 VARCHAR2(2000);
403: BEGIN
404: /*
405: STPROC.INIT('begin :X0 := FND_PROFILE.VALUE_SPECIFIC(:NAME, :USER_ID, :RESPONSIBILITY_ID, :APPLICATION_ID); end;');
406: STPROC.BIND_O(X0);
407: STPROC.BIND_I(NAME);
408: STPROC.BIND_I(USER_ID);
409: STPROC.BIND_I(RESPONSIBILITY_ID);

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

419: ,APPLICATION_ID_Z IN NUMBER
420: ,SITE_ID_Z IN NUMBER) IS
421: BEGIN
422: /*
423: STPROC.INIT('begin FND_PROFILE.INITIALIZE(:USER_ID_Z, :RESPONSIBILITY_ID_Z, :APPLICATION_ID_Z, :SITE_ID_Z); end;');
424: STPROC.BIND_I(USER_ID_Z);
425: STPROC.BIND_I(RESPONSIBILITY_ID_Z);
426: STPROC.BIND_I(APPLICATION_ID_Z);
427: STPROC.BIND_I(SITE_ID_Z);

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

433: ,VALS IN VARCHAR2
434: ,NUM IN NUMBER) IS
435: BEGIN
436: /*
437: STPROC.INIT('begin FND_PROFILE.PUTMULTIPLE(:NAMES, :VALS, :NUM); end;');
438: STPROC.BIND_I(NAMES);
439: STPROC.BIND_I(VALS);
440: STPROC.BIND_I(NUM);
441: STPROC.EXECUTE;*/