APPS.PSP_PSPLDSSA_XMLP_PKG dependencies on FND_PROFILE

Line 13: V_INSTITUTION_ID := FND_Profile.VALUE('PSP_ORG_REPORT');

9: FUNCTION CF_INSTITUTION_NAMEFORMULA RETURN VARCHAR2 IS
10: V_INSTITUTION_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
11: V_INSTITUTION_ID VARCHAR2(30);
12: BEGIN
13: V_INSTITUTION_ID := FND_Profile.VALUE('PSP_ORG_REPORT');
14: IF V_INSTITUTION_ID IS NULL THEN
15: RETURN NULL;
16: END IF;
17: SELECT

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

446:
447: PROCEDURE PUT(NAME IN VARCHAR2
448: ,VAL IN VARCHAR2) IS
449: BEGIN
450: /*STPROC.INIT('begin FND_PROFILE.PUT(:NAME, :VAL); end;');
451: STPROC.BIND_I(NAME);
452: STPROC.BIND_I(VAL);
453: STPROC.EXECUTE;*/ null;
454: END PUT;

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

455:
456: FUNCTION DEFINED(NAME IN VARCHAR2) RETURN BOOLEAN IS
457: X0 BOOLEAN;
458: BEGIN
459: /*STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := FND_PROFILE.DEFINED(:NAME); :X0 := sys.diutil.bool_to_int(X0rv); end;');
460: STPROC.BIND_I(NAME);
461: STPROC.BIND_O(X0);
462: STPROC.EXECUTE;
463: STPROC.RETRIEVE(2

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

467:
468: PROCEDURE GET(NAME IN VARCHAR2
469: ,VAL OUT NOCOPY VARCHAR2) IS
470: BEGIN
471: /*STPROC.INIT('begin FND_PROFILE.GET(:NAME, :VAL); end;');
472: STPROC.BIND_I(NAME);
473: STPROC.BIND_O(VAL);
474: STPROC.EXECUTE;
475: STPROC.RETRIEVE(2

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

478:
479: FUNCTION VALUE(NAME IN VARCHAR2) RETURN VARCHAR2 IS
480: X0 VARCHAR2(2000);
481: BEGIN
482: /*STPROC.INIT('begin :X0 := FND_PROFILE.VALUE(:NAME); end;');
483: STPROC.BIND_O(X0);
484: STPROC.BIND_I(NAME);
485: STPROC.EXECUTE;
486: STPROC.RETRIEVE(1

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

491: FUNCTION SAVE_USER(X_NAME IN VARCHAR2
492: ,X_VALUE IN VARCHAR2) RETURN BOOLEAN IS
493: X0 BOOLEAN;
494: BEGIN
495: /*STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := FND_PROFILE.SAVE_USER(:X_NAME, :X_VALUE); :X0 := sys.diutil.bool_to_int(X0rv); end;');
496: STPROC.BIND_I(X_NAME);
497: STPROC.BIND_I(X_VALUE);
498: STPROC.BIND_O(X0);
499: STPROC.EXECUTE;

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

508: ,X_LEVEL_VALUE IN VARCHAR2
509: ,X_LEVEL_VALUE_APP_ID IN VARCHAR2) RETURN BOOLEAN IS
510: X0 BOOLEAN;
511: BEGIN
512: /*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;');
513: STPROC.BIND_I(X_NAME);
514: STPROC.BIND_I(X_VALUE);
515: STPROC.BIND_I(X_LEVEL_NAME);
516: STPROC.BIND_I(X_LEVEL_VALUE);

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

548: ,RESPONSIBILITY_ID IN NUMBER
549: ,APPLICATION_ID IN NUMBER) RETURN VARCHAR2 IS
550: X0 VARCHAR2(2000);
551: BEGIN
552: /*STPROC.INIT('begin :X0 := FND_PROFILE.VALUE_SPECIFIC(:NAME, :USER_ID, :RESPONSIBILITY_ID, :APPLICATION_ID); end;');
553: STPROC.BIND_O(X0);
554: STPROC.BIND_I(NAME);
555: STPROC.BIND_I(USER_ID);
556: STPROC.BIND_I(RESPONSIBILITY_ID);

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

565: ,RESPONSIBILITY_ID_Z IN NUMBER
566: ,APPLICATION_ID_Z IN NUMBER
567: ,SITE_ID_Z IN NUMBER) IS
568: BEGIN
569: /*STPROC.INIT('begin FND_PROFILE.INITIALIZE(:USER_ID_Z, :RESPONSIBILITY_ID_Z, :APPLICATION_ID_Z, :SITE_ID_Z); end;');
570: STPROC.BIND_I(USER_ID_Z);
571: STPROC.BIND_I(RESPONSIBILITY_ID_Z);
572: STPROC.BIND_I(APPLICATION_ID_Z);
573: STPROC.BIND_I(SITE_ID_Z);

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

577: PROCEDURE PUTMULTIPLE(NAMES IN VARCHAR2
578: ,VALS IN VARCHAR2
579: ,NUM IN NUMBER) IS
580: BEGIN
581: /*STPROC.INIT('begin FND_PROFILE.PUTMULTIPLE(:NAMES, :VALS, :NUM); end;');
582: STPROC.BIND_I(NAMES);
583: STPROC.BIND_I(VALS);
584: STPROC.BIND_I(NUM);
585: STPROC.EXECUTE;*/ null;