APPS.PSP_PSPLDDFA_XMLP_PKG dependencies on FND_PROFILE

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

455:
456: PROCEDURE PUT(NAME IN VARCHAR2
457: ,VAL IN VARCHAR2) IS
458: BEGIN
459: /* STPROC.INIT('begin FND_PROFILE.PUT(:NAME, :VAL); end;');
460: STPROC.BIND_I(NAME);
461: STPROC.BIND_I(VAL);
462: STPROC.EXECUTE;*/null;
463: END PUT;

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

464:
465: FUNCTION DEFINED(NAME IN VARCHAR2) RETURN BOOLEAN IS
466: X0 BOOLEAN;
467: BEGIN
468: /* STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := FND_PROFILE.DEFINED(:NAME); :X0 := sys.diutil.bool_to_int(X0rv); end;');
469: STPROC.BIND_I(NAME);
470: STPROC.BIND_O(X0);
471: STPROC.EXECUTE;
472: STPROC.RETRIEVE(2

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

476:
477: PROCEDURE GET(NAME IN VARCHAR2
478: ,VAL OUT NOCOPY VARCHAR2) IS
479: BEGIN
480: /* STPROC.INIT('begin FND_PROFILE.GET(:NAME, :VAL); end;');
481: STPROC.BIND_I(NAME);
482: STPROC.BIND_O(VAL);
483: STPROC.EXECUTE;
484: STPROC.RETRIEVE(2

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

487:
488: FUNCTION VALUE(NAME IN VARCHAR2) RETURN VARCHAR2 IS
489: X0 VARCHAR2(2000);
490: BEGIN
491: /* STPROC.INIT('begin :X0 := FND_PROFILE.VALUE(:NAME); end;');
492: STPROC.BIND_O(X0);
493: STPROC.BIND_I(NAME);
494: STPROC.EXECUTE;
495: STPROC.RETRIEVE(1

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

493: STPROC.BIND_I(NAME);
494: STPROC.EXECUTE;
495: STPROC.RETRIEVE(1
496: ,X0);*/
497: X0 := FND_PROFILE.VALUE(NAME);
498: RETURN X0;
499: END VALUE;
500:
501: FUNCTION SAVE_USER(X_NAME IN VARCHAR2

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

501: FUNCTION SAVE_USER(X_NAME IN VARCHAR2
502: ,X_VALUE IN VARCHAR2) RETURN BOOLEAN IS
503: X0 BOOLEAN;
504: BEGIN
505: /* STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := FND_PROFILE.SAVE_USER(:X_NAME, :X_VALUE); :X0 := sys.diutil.bool_to_int(X0rv); end;');
506: STPROC.BIND_I(X_NAME);
507: STPROC.BIND_I(X_VALUE);
508: STPROC.BIND_O(X0);
509: STPROC.EXECUTE;

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

518: ,X_LEVEL_VALUE IN VARCHAR2
519: ,X_LEVEL_VALUE_APP_ID IN VARCHAR2) RETURN BOOLEAN IS
520: X0 BOOLEAN;
521: BEGIN
522: /* 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;');
523: STPROC.BIND_I(X_NAME);
524: STPROC.BIND_I(X_VALUE);
525: STPROC.BIND_I(X_LEVEL_NAME);
526: STPROC.BIND_I(X_LEVEL_VALUE);

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

539: ,VAL_Z OUT NOCOPY VARCHAR2
540: ,DEFINED_Z OUT NOCOPY BOOLEAN) IS
541: BEGIN
542: /* STPROC.INIT('declare DEFINED_Z BOOLEAN; begin DEFINED_Z := sys.diutil.int_to_bool(:DEFINED_Z);
543: FND_PROFILE.GET_SPECIFIC(:NAME_Z, :USER_ID_Z, :RESPONSIBILITY_ID_Z, :APPLICATION_ID_Z, :VAL_Z, DEFINED_Z);
544: :DEFINED_Z := sys.diutil.bool_to_int(DEFINED_Z); end;');
545: STPROC.BIND_O(DEFINED_Z);
546: STPROC.BIND_I(NAME_Z);
547: STPROC.BIND_I(USER_ID_Z);

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

560: ,RESPONSIBILITY_ID IN NUMBER
561: ,APPLICATION_ID IN NUMBER) RETURN VARCHAR2 IS
562: X0 VARCHAR2(2000);
563: BEGIN
564: /* STPROC.INIT('begin :X0 := FND_PROFILE.VALUE_SPECIFIC(:NAME, :USER_ID, :RESPONSIBILITY_ID, :APPLICATION_ID); end;');
565: STPROC.BIND_O(X0);
566: STPROC.BIND_I(NAME);
567: STPROC.BIND_I(USER_ID);
568: STPROC.BIND_I(RESPONSIBILITY_ID);

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

577: ,RESPONSIBILITY_ID_Z IN NUMBER
578: ,APPLICATION_ID_Z IN NUMBER
579: ,SITE_ID_Z IN NUMBER) IS
580: BEGIN
581: /*STPROC.INIT('begin FND_PROFILE.INITIALIZE(:USER_ID_Z, :RESPONSIBILITY_ID_Z, :APPLICATION_ID_Z, :SITE_ID_Z); end;');
582: STPROC.BIND_I(USER_ID_Z);
583: STPROC.BIND_I(RESPONSIBILITY_ID_Z);
584: STPROC.BIND_I(APPLICATION_ID_Z);
585: STPROC.BIND_I(SITE_ID_Z);

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

589: PROCEDURE PUTMULTIPLE(NAMES IN VARCHAR2
590: ,VALS IN VARCHAR2
591: ,NUM IN NUMBER) IS
592: BEGIN
593: /* STPROC.INIT('begin FND_PROFILE.PUTMULTIPLE(:NAMES, :VALS, :NUM); end;');
594: STPROC.BIND_I(NAMES);
595: STPROC.BIND_I(VALS);
596: STPROC.BIND_I(NUM);
597: STPROC.EXECUTE;*/null;