DBA Data[Home] [Help]

APPS.WSH_WSHRDINV_XMLP_PKG dependencies on DIUTIL

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

560: FUNCTION DEFINED(NAME IN VARCHAR2) RETURN BOOLEAN IS
561: X0 BOOLEAN;
562: X1 integer;
563: BEGIN
564: /*STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := FND_PROFILE.DEFINED(:NAME); :X0 := sys.diutil.bool_to_int(X0rv); end;');
565: STPROC.BIND_I(NAME);
566: STPROC.BIND_O(X0);
567: STPROC.EXECUTE;
568: STPROC.RETRIEVE(2

Line 575: X1 := sys.diutil.bool_to_int(X0rv);

571: declare
572: X0rv BOOLEAN;
573: begin
574: X0rv := FND_PROFILE.DEFINED(NAME);
575: X1 := sys.diutil.bool_to_int(X0rv);
576: end;
577: RETURN sys.diutil.int_to_bool(X1);
578: END DEFINED;
579:

Line 577: RETURN sys.diutil.int_to_bool(X1);

573: begin
574: X0rv := FND_PROFILE.DEFINED(NAME);
575: X1 := sys.diutil.bool_to_int(X0rv);
576: end;
577: RETURN sys.diutil.int_to_bool(X1);
578: END DEFINED;
579:
580: PROCEDURE GET(NAME IN VARCHAR2
581: ,VAL OUT NOCOPY VARCHAR2) IS

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

608: ,X_VALUE IN VARCHAR2) RETURN BOOLEAN IS
609: X0 BOOLEAN;
610: X1 integer;
611: BEGIN
612: /*STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := FND_PROFILE.SAVE_USER(:X_NAME, :X_VALUE); :X0 := sys.diutil.bool_to_int(X0rv); end;');
613: STPROC.BIND_I(X_NAME);
614: STPROC.BIND_I(X_VALUE);
615: STPROC.BIND_O(X0);
616: STPROC.EXECUTE;

Line 625: X1 := sys.diutil.bool_to_int(X0rv);

621: declare
622: X0rv BOOLEAN;
623: begin
624: X0rv := FND_PROFILE.SAVE_USER(X_NAME, X_VALUE);
625: X1 := sys.diutil.bool_to_int(X0rv);
626: end;
627: RETURN sys.diutil.int_to_bool(X1);
628: END SAVE_USER;
629:

Line 627: RETURN sys.diutil.int_to_bool(X1);

623: begin
624: X0rv := FND_PROFILE.SAVE_USER(X_NAME, X_VALUE);
625: X1 := sys.diutil.bool_to_int(X0rv);
626: end;
627: RETURN sys.diutil.int_to_bool(X1);
628: END SAVE_USER;
629:
630: FUNCTION SAVE(X_NAME IN VARCHAR2
631: ,X_VALUE IN VARCHAR2

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

634: ,X_LEVEL_VALUE_APP_ID IN VARCHAR2) RETURN BOOLEAN IS
635: X0 BOOLEAN;
636: X1 integer;
637: BEGIN
638: /*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;');
639: STPROC.BIND_I(X_NAME);
640: STPROC.BIND_I(X_VALUE);
641: STPROC.BIND_I(X_LEVEL_NAME);
642: STPROC.BIND_I(X_LEVEL_VALUE);

Line 654: X1 := sys.diutil.bool_to_int(X0rv);

650: declare
651: X0rv BOOLEAN;
652: begin
653: X0rv := FND_PROFILE.SAVE(X_NAME, X_VALUE, X_LEVEL_NAME, X_LEVEL_VALUE, X_LEVEL_VALUE_APP_ID);
654: X1 := sys.diutil.bool_to_int(X0rv);
655: end;
656: RETURN sys.diutil.int_to_bool(X1);
657: END SAVE;
658:

Line 656: RETURN sys.diutil.int_to_bool(X1);

652: begin
653: X0rv := FND_PROFILE.SAVE(X_NAME, X_VALUE, X_LEVEL_NAME, X_LEVEL_VALUE, X_LEVEL_VALUE_APP_ID);
654: X1 := sys.diutil.bool_to_int(X0rv);
655: end;
656: RETURN sys.diutil.int_to_bool(X1);
657: END SAVE;
658:
659: PROCEDURE GET_SPECIFIC(NAME_Z IN VARCHAR2
660: ,USER_ID_Z IN NUMBER

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

662: ,APPLICATION_ID_Z IN NUMBER
663: ,VAL_Z OUT NOCOPY VARCHAR2
664: ,DEFINED_Z OUT NOCOPY BOOLEAN) IS
665: BEGIN
666: /*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);
667: :DEFINED_Z := sys.diutil.bool_to_int(DEFINED_Z); end;');
668: STPROC.BIND_O(DEFINED_Z);
669: STPROC.BIND_I(NAME_Z);
670: STPROC.BIND_I(USER_ID_Z);

Line 667: :DEFINED_Z := sys.diutil.bool_to_int(DEFINED_Z); end;');

663: ,VAL_Z OUT NOCOPY VARCHAR2
664: ,DEFINED_Z OUT NOCOPY BOOLEAN) IS
665: BEGIN
666: /*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);
667: :DEFINED_Z := sys.diutil.bool_to_int(DEFINED_Z); end;');
668: STPROC.BIND_O(DEFINED_Z);
669: STPROC.BIND_I(NAME_Z);
670: STPROC.BIND_I(USER_ID_Z);
671: STPROC.BIND_I(RESPONSIBILITY_ID_Z);

Line 683: DEFINED_Z := sys.diutil.int_to_bool(DEFINED_Z1);

679: declare
680: DEFINED_Z BOOLEAN;
681: DEFINED_Z1 integer;
682: begin
683: DEFINED_Z := sys.diutil.int_to_bool(DEFINED_Z1);
684: FND_PROFILE.GET_SPECIFIC(NAME_Z, USER_ID_Z, RESPONSIBILITY_ID_Z, APPLICATION_ID_Z, VAL_Z, DEFINED_Z);
685: DEFINED_Z1 := sys.diutil.bool_to_int(DEFINED_Z);
686: end;
687: END GET_SPECIFIC;

Line 685: DEFINED_Z1 := sys.diutil.bool_to_int(DEFINED_Z);

681: DEFINED_Z1 integer;
682: begin
683: DEFINED_Z := sys.diutil.int_to_bool(DEFINED_Z1);
684: FND_PROFILE.GET_SPECIFIC(NAME_Z, USER_ID_Z, RESPONSIBILITY_ID_Z, APPLICATION_ID_Z, VAL_Z, DEFINED_Z);
685: DEFINED_Z1 := sys.diutil.bool_to_int(DEFINED_Z);
686: end;
687: END GET_SPECIFIC;
688:
689: FUNCTION VALUE_SPECIFIC(NAME IN VARCHAR2