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_PSPLSODL_XMLP_PKG dependencies on FND_PROFILE

Line 330: RETURN (FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'));

326: END BEFOREPFORM;
327:
328: FUNCTION CF_DATE_FORMATFORMULA RETURN CHAR IS
329: BEGIN
330: RETURN (FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'));
331: END CF_DATE_FORMATFORMULA;
332:
333: FUNCTION CF_DEFAULT_BEGIN_DATEFORMULA(DEFAULT_BEGIN_DATE IN DATE
334: ,CF_DATE_FORMAT IN VARCHAR2) RETURN CHAR IS

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

474:
475: PROCEDURE PUT(NAME IN VARCHAR2
476: ,VAL IN VARCHAR2) IS
477: BEGIN
478: /* STPROC.INIT('begin FND_PROFILE.PUT(:NAME, :VAL); end;');
479: STPROC.BIND_I(NAME);
480: STPROC.BIND_I(VAL);
481: STPROC.EXECUTE;*/NULL;
482: END PUT;

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

483:
484: FUNCTION DEFINED(NAME IN VARCHAR2) RETURN BOOLEAN IS
485: X0 BOOLEAN;
486: BEGIN
487: /* STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := FND_PROFILE.DEFINED(:NAME); :X0 := sys.diutil.bool_to_int(X0rv); end;');
488: STPROC.BIND_I(NAME);
489: STPROC.BIND_O(X0);
490: STPROC.EXECUTE;
491: STPROC.RETRIEVE(2

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

495:
496: PROCEDURE GET(NAME IN VARCHAR2
497: ,VAL OUT NOCOPY VARCHAR2) IS
498: BEGIN
499: /*STPROC.INIT('begin FND_PROFILE.GET(:NAME, :VAL); end;');
500: STPROC.BIND_I(NAME);
501: STPROC.BIND_O(VAL);
502: STPROC.EXECUTE;
503: STPROC.RETRIEVE(2

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

506:
507: FUNCTION VALUE(NAME IN VARCHAR2) RETURN VARCHAR2 IS
508: X0 VARCHAR2(2000);
509: BEGIN
510: /*STPROC.INIT('begin :X0 := FND_PROFILE.VALUE(:NAME); end;');
511: STPROC.BIND_O(X0);
512: STPROC.BIND_I(NAME);
513: STPROC.EXECUTE;
514: STPROC.RETRIEVE(1

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

519: FUNCTION SAVE_USER(X_NAME IN VARCHAR2
520: ,X_VALUE IN VARCHAR2) RETURN BOOLEAN IS
521: X0 BOOLEAN;
522: BEGIN
523: /*STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := FND_PROFILE.SAVE_USER(:X_NAME, :X_VALUE); :X0 := sys.diutil.bool_to_int(X0rv); end;');
524: STPROC.BIND_I(X_NAME);
525: STPROC.BIND_I(X_VALUE);
526: STPROC.BIND_O(X0);
527: STPROC.EXECUTE;

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

536: ,X_LEVEL_VALUE IN VARCHAR2
537: ,X_LEVEL_VALUE_APP_ID IN VARCHAR2) RETURN BOOLEAN IS
538: X0 BOOLEAN;
539: BEGIN
540: /*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;');
541: STPROC.BIND_I(X_NAME);
542: STPROC.BIND_I(X_VALUE);
543: STPROC.BIND_I(X_LEVEL_NAME);
544: STPROC.BIND_I(X_LEVEL_VALUE);

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

557: ,VAL_Z OUT NOCOPY VARCHAR2
558: ,DEFINED_Z OUT NOCOPY BOOLEAN) IS
559: BEGIN
560: /*STPROC.INIT('declare DEFINED_Z BOOLEAN; begin DEFINED_Z := sys.diutil.int_to_bool(:DEFINED_Z);
561: FND_PROFILE.GET_SPECIFIC(:NAME_Z, :USER_ID_Z, :RESPONSIBILITY_ID_Z, :APPLICATION_ID_Z, :VAL_Z, DEFINED_Z);
562: :DEFINED_Z := sys.diutil.bool_to_int(DEFINED_Z); end;');
563: STPROC.BIND_O(DEFINED_Z);
564: STPROC.BIND_I(NAME_Z);
565: STPROC.BIND_I(USER_ID_Z);

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

578: ,RESPONSIBILITY_ID IN NUMBER
579: ,APPLICATION_ID IN NUMBER) RETURN VARCHAR2 IS
580: X0 VARCHAR2(2000);
581: BEGIN
582: /*STPROC.INIT('begin :X0 := FND_PROFILE.VALUE_SPECIFIC(:NAME, :USER_ID, :RESPONSIBILITY_ID, :APPLICATION_ID); end;');
583: STPROC.BIND_O(X0);
584: STPROC.BIND_I(NAME);
585: STPROC.BIND_I(USER_ID);
586: STPROC.BIND_I(RESPONSIBILITY_ID);

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

595: ,RESPONSIBILITY_ID_Z IN NUMBER
596: ,APPLICATION_ID_Z IN NUMBER
597: ,SITE_ID_Z IN NUMBER) IS
598: BEGIN
599: /*STPROC.INIT('begin FND_PROFILE.INITIALIZE(:USER_ID_Z, :RESPONSIBILITY_ID_Z, :APPLICATION_ID_Z, :SITE_ID_Z); end;');
600: STPROC.BIND_I(USER_ID_Z);
601: STPROC.BIND_I(RESPONSIBILITY_ID_Z);
602: STPROC.BIND_I(APPLICATION_ID_Z);
603: STPROC.BIND_I(SITE_ID_Z);

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

607: PROCEDURE PUTMULTIPLE(NAMES IN VARCHAR2
608: ,VALS IN VARCHAR2
609: ,NUM IN NUMBER) IS
610: BEGIN
611: /*STPROC.INIT('begin FND_PROFILE.PUTMULTIPLE(:NAMES, :VALS, :NUM); end;');
612: STPROC.BIND_I(NAMES);
613: STPROC.BIND_I(VALS);
614: STPROC.BIND_I(NUM);
615: STPROC.EXECUTE;*/NULL;