APPS.PSP_PSPRCDLS_XMLP_PKG dependencies on FND_PROFILE

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

632:
633: PROCEDURE PUT(NAME IN VARCHAR2
634: ,VAL IN VARCHAR2) IS
635: BEGIN
636: /* STPROC.INIT('begin FND_PROFILE.PUT(:NAME, :VAL); end;');
637: STPROC.BIND_I(NAME);
638: STPROC.BIND_I(VAL);
639: STPROC.EXECUTE;*/null;
640: END PUT;

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

641:
642: FUNCTION DEFINED(NAME IN VARCHAR2) RETURN BOOLEAN IS
643: X0 BOOLEAN;
644: BEGIN
645: /* STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := FND_PROFILE.DEFINED(:NAME); :X0 := sys.diutil.bool_to_int(X0rv); end;');
646: STPROC.BIND_I(NAME);
647: STPROC.BIND_O(X0);
648: STPROC.EXECUTE;
649: STPROC.RETRIEVE(2

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

653:
654: PROCEDURE GET(NAME IN VARCHAR2
655: ,VAL OUT NOCOPY VARCHAR2) IS
656: BEGIN
657: /* STPROC.INIT('begin FND_PROFILE.GET(:NAME, :VAL); end;');
658: STPROC.BIND_I(NAME);
659: STPROC.BIND_O(VAL);
660: STPROC.EXECUTE;
661: STPROC.RETRIEVE(2

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

660: STPROC.EXECUTE;
661: STPROC.RETRIEVE(2
662: ,VAL);*/
663:
664: FND_PROFILE.GET(NAME, VAL);
665: END GET;
666:
667: FUNCTION VALUE(NAME IN VARCHAR2) RETURN VARCHAR2 IS
668: X0 VARCHAR2(2000);

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

666:
667: FUNCTION VALUE(NAME IN VARCHAR2) RETURN VARCHAR2 IS
668: X0 VARCHAR2(2000);
669: BEGIN
670: /* STPROC.INIT('begin :X0 := FND_PROFILE.VALUE(:NAME); end;');
671: STPROC.BIND_O(X0);
672: STPROC.BIND_I(NAME);
673: STPROC.EXECUTE;
674: STPROC.RETRIEVE(1

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

679: FUNCTION SAVE_USER(X_NAME IN VARCHAR2
680: ,X_VALUE IN VARCHAR2) RETURN BOOLEAN IS
681: X0 BOOLEAN;
682: BEGIN
683: /* STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := FND_PROFILE.SAVE_USER(:X_NAME, :X_VALUE); :X0 := sys.diutil.bool_to_int(X0rv); end;');
684: STPROC.BIND_I(X_NAME);
685: STPROC.BIND_I(X_VALUE);
686: STPROC.BIND_O(X0);
687: STPROC.EXECUTE;

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

696: ,X_LEVEL_VALUE IN VARCHAR2
697: ,X_LEVEL_VALUE_APP_ID IN VARCHAR2) RETURN BOOLEAN IS
698: X0 BOOLEAN;
699: BEGIN
700: /* 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;');
701: STPROC.BIND_I(X_NAME);
702: STPROC.BIND_I(X_VALUE);
703: STPROC.BIND_I(X_LEVEL_NAME);
704: STPROC.BIND_I(X_LEVEL_VALUE);

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

718: ,DEFINED_Z OUT NOCOPY BOOLEAN) IS
719: BEGIN
720: /* STPROC.INIT('declare DEFINED_Z BOOLEAN; begin
721: DEFINED_Z := sys.diutil.int_to_bool(:DEFINED_Z);
722: FND_PROFILE.GET_SPECIFIC(:NAME_Z, :USER_ID_Z, :RESPONSIBILITY_ID_Z, :APPLICATION_ID_Z, :VAL_Z, DEFINED_Z);
723: :DEFINED_Z := sys.diutil.bool_to_int(DEFINED_Z); end;');
724: STPROC.BIND_O(DEFINED_Z);
725: STPROC.BIND_I(NAME_Z);
726: STPROC.BIND_I(USER_ID_Z);

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

739: ,RESPONSIBILITY_ID IN NUMBER
740: ,APPLICATION_ID IN NUMBER) RETURN VARCHAR2 IS
741: X0 VARCHAR2(2000);
742: BEGIN
743: /* STPROC.INIT('begin :X0 := FND_PROFILE.VALUE_SPECIFIC(:NAME, :USER_ID, :RESPONSIBILITY_ID, :APPLICATION_ID); end;');
744: STPROC.BIND_O(X0);
745: STPROC.BIND_I(NAME);
746: STPROC.BIND_I(USER_ID);
747: STPROC.BIND_I(RESPONSIBILITY_ID);

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

756: ,RESPONSIBILITY_ID_Z IN NUMBER
757: ,APPLICATION_ID_Z IN NUMBER
758: ,SITE_ID_Z IN NUMBER) IS
759: BEGIN
760: /*STPROC.INIT('begin FND_PROFILE.INITIALIZE(:USER_ID_Z, :RESPONSIBILITY_ID_Z, :APPLICATION_ID_Z, :SITE_ID_Z); end;');
761: STPROC.BIND_I(USER_ID_Z);
762: STPROC.BIND_I(RESPONSIBILITY_ID_Z);
763: STPROC.BIND_I(APPLICATION_ID_Z);
764: STPROC.BIND_I(SITE_ID_Z);

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

768: PROCEDURE PUTMULTIPLE(NAMES IN VARCHAR2
769: ,VALS IN VARCHAR2
770: ,NUM IN NUMBER) IS
771: BEGIN
772: /* STPROC.INIT('begin FND_PROFILE.PUTMULTIPLE(:NAMES, :VALS, :NUM); end;');
773: STPROC.BIND_I(NAMES);
774: STPROC.BIND_I(VALS);
775: STPROC.BIND_I(NUM);
776: STPROC.EXECUTE;*/null;