DBA Data[Home] [Help]

APPS.WSH_WSHRDINV_XMLP_PKG dependencies on DIUTIL

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

529: FUNCTION DEFINED(NAME IN VARCHAR2) RETURN BOOLEAN IS
530: X0 BOOLEAN;
531: X1 integer;
532: BEGIN
533: /*STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := FND_PROFILE.DEFINED(:NAME); :X0 := sys.diutil.bool_to_int(X0rv); end;');
534: STPROC.BIND_I(NAME);
535: STPROC.BIND_O(X0);
536: STPROC.EXECUTE;
537: STPROC.RETRIEVE(2

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

540: declare
541: X0rv BOOLEAN;
542: begin
543: X0rv := FND_PROFILE.DEFINED(NAME);
544: X1 := sys.diutil.bool_to_int(X0rv);
545: end;
546: RETURN sys.diutil.int_to_bool(X1);
547: END DEFINED;
548:

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

542: begin
543: X0rv := FND_PROFILE.DEFINED(NAME);
544: X1 := sys.diutil.bool_to_int(X0rv);
545: end;
546: RETURN sys.diutil.int_to_bool(X1);
547: END DEFINED;
548:
549: PROCEDURE GET(NAME IN VARCHAR2
550: ,VAL OUT NOCOPY VARCHAR2) IS

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

577: ,X_VALUE IN VARCHAR2) RETURN BOOLEAN IS
578: X0 BOOLEAN;
579: X1 integer;
580: BEGIN
581: /*STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := FND_PROFILE.SAVE_USER(:X_NAME, :X_VALUE); :X0 := sys.diutil.bool_to_int(X0rv); end;');
582: STPROC.BIND_I(X_NAME);
583: STPROC.BIND_I(X_VALUE);
584: STPROC.BIND_O(X0);
585: STPROC.EXECUTE;

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

590: declare
591: X0rv BOOLEAN;
592: begin
593: X0rv := FND_PROFILE.SAVE_USER(X_NAME, X_VALUE);
594: X1 := sys.diutil.bool_to_int(X0rv);
595: end;
596: RETURN sys.diutil.int_to_bool(X1);
597: END SAVE_USER;
598:

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

592: begin
593: X0rv := FND_PROFILE.SAVE_USER(X_NAME, X_VALUE);
594: X1 := sys.diutil.bool_to_int(X0rv);
595: end;
596: RETURN sys.diutil.int_to_bool(X1);
597: END SAVE_USER;
598:
599: FUNCTION SAVE(X_NAME IN VARCHAR2
600: ,X_VALUE IN VARCHAR2

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

603: ,X_LEVEL_VALUE_APP_ID IN VARCHAR2) RETURN BOOLEAN IS
604: X0 BOOLEAN;
605: X1 integer;
606: BEGIN
607: /*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;');
608: STPROC.BIND_I(X_NAME);
609: STPROC.BIND_I(X_VALUE);
610: STPROC.BIND_I(X_LEVEL_NAME);
611: STPROC.BIND_I(X_LEVEL_VALUE);

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

619: declare
620: X0rv BOOLEAN;
621: begin
622: X0rv := FND_PROFILE.SAVE(X_NAME, X_VALUE, X_LEVEL_NAME, X_LEVEL_VALUE, X_LEVEL_VALUE_APP_ID);
623: X1 := sys.diutil.bool_to_int(X0rv);
624: end;
625: RETURN sys.diutil.int_to_bool(X1);
626: END SAVE;
627:

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

621: begin
622: X0rv := FND_PROFILE.SAVE(X_NAME, X_VALUE, X_LEVEL_NAME, X_LEVEL_VALUE, X_LEVEL_VALUE_APP_ID);
623: X1 := sys.diutil.bool_to_int(X0rv);
624: end;
625: RETURN sys.diutil.int_to_bool(X1);
626: END SAVE;
627:
628: PROCEDURE GET_SPECIFIC(NAME_Z IN VARCHAR2
629: ,USER_ID_Z IN NUMBER

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

631: ,APPLICATION_ID_Z IN NUMBER
632: ,VAL_Z OUT NOCOPY VARCHAR2
633: ,DEFINED_Z OUT NOCOPY BOOLEAN) IS
634: BEGIN
635: /*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);
636: :DEFINED_Z := sys.diutil.bool_to_int(DEFINED_Z); end;');
637: STPROC.BIND_O(DEFINED_Z);
638: STPROC.BIND_I(NAME_Z);
639: STPROC.BIND_I(USER_ID_Z);

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

632: ,VAL_Z OUT NOCOPY VARCHAR2
633: ,DEFINED_Z OUT NOCOPY BOOLEAN) IS
634: BEGIN
635: /*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);
636: :DEFINED_Z := sys.diutil.bool_to_int(DEFINED_Z); end;');
637: STPROC.BIND_O(DEFINED_Z);
638: STPROC.BIND_I(NAME_Z);
639: STPROC.BIND_I(USER_ID_Z);
640: STPROC.BIND_I(RESPONSIBILITY_ID_Z);

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

648: declare
649: DEFINED_Z BOOLEAN;
650: DEFINED_Z1 integer;
651: begin
652: DEFINED_Z := sys.diutil.int_to_bool(DEFINED_Z1);
653: FND_PROFILE.GET_SPECIFIC(NAME_Z, USER_ID_Z, RESPONSIBILITY_ID_Z, APPLICATION_ID_Z, VAL_Z, DEFINED_Z);
654: DEFINED_Z1 := sys.diutil.bool_to_int(DEFINED_Z);
655: end;
656: END GET_SPECIFIC;

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

650: DEFINED_Z1 integer;
651: begin
652: DEFINED_Z := sys.diutil.int_to_bool(DEFINED_Z1);
653: FND_PROFILE.GET_SPECIFIC(NAME_Z, USER_ID_Z, RESPONSIBILITY_ID_Z, APPLICATION_ID_Z, VAL_Z, DEFINED_Z);
654: DEFINED_Z1 := sys.diutil.bool_to_int(DEFINED_Z);
655: end;
656: END GET_SPECIFIC;
657:
658: FUNCTION VALUE_SPECIFIC(NAME IN VARCHAR2