eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_WSHRDINV_XMLP_PKG dependencies on FND_PROFILE

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

518:
519: PROCEDURE PUT(NAME IN VARCHAR2
520: ,VAL IN VARCHAR2) IS
521: BEGIN
522: /*STPROC.INIT('begin FND_PROFILE.PUT(:NAME, :VAL); end;');
523: STPROC.BIND_I(NAME);
524: STPROC.BIND_I(VAL);
525: STPROC.EXECUTE;*/
526: FND_PROFILE.PUT(NAME, VAL);

Line 526: FND_PROFILE.PUT(NAME, VAL);

522: /*STPROC.INIT('begin FND_PROFILE.PUT(:NAME, :VAL); end;');
523: STPROC.BIND_I(NAME);
524: STPROC.BIND_I(VAL);
525: STPROC.EXECUTE;*/
526: FND_PROFILE.PUT(NAME, VAL);
527: END PUT;
528:
529: FUNCTION DEFINED(NAME IN VARCHAR2) RETURN BOOLEAN IS
530: X0 BOOLEAN;

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 543: X0rv := FND_PROFILE.DEFINED(NAME);

539: RETURN X0;*/
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;

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

548:
549: PROCEDURE GET(NAME IN VARCHAR2
550: ,VAL OUT NOCOPY VARCHAR2) IS
551: BEGIN
552: /*STPROC.INIT('begin FND_PROFILE.GET(:NAME, :VAL); end;');
553: STPROC.BIND_I(NAME);
554: STPROC.BIND_O(VAL);
555: STPROC.EXECUTE;
556: STPROC.RETRIEVE(2

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

554: STPROC.BIND_O(VAL);
555: STPROC.EXECUTE;
556: STPROC.RETRIEVE(2
557: ,VAL);*/
558: FND_PROFILE.GET(NAME, VAL);
559: END GET;
560:
561: FUNCTION VALUE(NAME IN VARCHAR2) RETURN VARCHAR2 IS
562: X0 VARCHAR2(2000);

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

560:
561: FUNCTION VALUE(NAME IN VARCHAR2) RETURN VARCHAR2 IS
562: X0 VARCHAR2(2000);
563: BEGIN
564: /*STPROC.INIT('begin :X0 := FND_PROFILE.VALUE(:NAME); end;');
565: STPROC.BIND_O(X0);
566: STPROC.BIND_I(NAME);
567: STPROC.EXECUTE;
568: STPROC.RETRIEVE(1

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

568: STPROC.RETRIEVE(1
569: ,X0);
570: RETURN X0;*/
571:
572: X0 := FND_PROFILE.VALUE(NAME);
573: RETURN X0;
574: END VALUE;
575:
576: FUNCTION SAVE_USER(X_NAME IN VARCHAR2

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 593: X0rv := FND_PROFILE.SAVE_USER(X_NAME, X_VALUE);

589:
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;

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 622: X0rv := FND_PROFILE.SAVE(X_NAME, X_VALUE, X_LEVEL_NAME, X_LEVEL_VALUE, X_LEVEL_VALUE_APP_ID);

618:
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;

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 653: FND_PROFILE.GET_SPECIFIC(NAME_Z, USER_ID_Z, RESPONSIBILITY_ID_Z, APPLICATION_ID_Z, VAL_Z, DEFINED_Z);

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;
657:

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

660: ,RESPONSIBILITY_ID IN NUMBER
661: ,APPLICATION_ID IN NUMBER) RETURN VARCHAR2 IS
662: X0 VARCHAR2(2000);
663: BEGIN
664: /*STPROC.INIT('begin :X0 := FND_PROFILE.VALUE_SPECIFIC(:NAME, :USER_ID, :RESPONSIBILITY_ID, :APPLICATION_ID); end;');
665: STPROC.BIND_O(X0);
666: STPROC.BIND_I(NAME);
667: STPROC.BIND_I(USER_ID);
668: STPROC.BIND_I(RESPONSIBILITY_ID);

Line 675: X0 := FND_PROFILE.VALUE_SPECIFIC(NAME, USER_ID, RESPONSIBILITY_ID, APPLICATION_ID);

671: STPROC.RETRIEVE(1
672: ,X0);
673: RETURN X0;*/
674:
675: X0 := FND_PROFILE.VALUE_SPECIFIC(NAME, USER_ID, RESPONSIBILITY_ID, APPLICATION_ID);
676: RETURN X0;
677: END VALUE_SPECIFIC;
678:
679: PROCEDURE INITIALIZE(USER_ID_Z IN NUMBER

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

680: ,RESPONSIBILITY_ID_Z IN NUMBER
681: ,APPLICATION_ID_Z IN NUMBER
682: ,SITE_ID_Z IN NUMBER) IS
683: BEGIN
684: /*STPROC.INIT('begin FND_PROFILE.INITIALIZE(:USER_ID_Z, :RESPONSIBILITY_ID_Z, :APPLICATION_ID_Z, :SITE_ID_Z); end;');
685: STPROC.BIND_I(USER_ID_Z);
686: STPROC.BIND_I(RESPONSIBILITY_ID_Z);
687: STPROC.BIND_I(APPLICATION_ID_Z);
688: STPROC.BIND_I(SITE_ID_Z);

Line 691: FND_PROFILE.INITIALIZE(USER_ID_Z, RESPONSIBILITY_ID_Z, APPLICATION_ID_Z, SITE_ID_Z);

687: STPROC.BIND_I(APPLICATION_ID_Z);
688: STPROC.BIND_I(SITE_ID_Z);
689: STPROC.EXECUTE;*/
690:
691: FND_PROFILE.INITIALIZE(USER_ID_Z, RESPONSIBILITY_ID_Z, APPLICATION_ID_Z, SITE_ID_Z);
692: END INITIALIZE;
693:
694: PROCEDURE PUTMULTIPLE(NAMES IN VARCHAR2
695: ,VALS IN VARCHAR2

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

694: PROCEDURE PUTMULTIPLE(NAMES IN VARCHAR2
695: ,VALS IN VARCHAR2
696: ,NUM IN NUMBER) IS
697: BEGIN
698: /*STPROC.INIT('begin FND_PROFILE.PUTMULTIPLE(:NAMES, :VALS, :NUM); end;');
699: STPROC.BIND_I(NAMES);
700: STPROC.BIND_I(VALS);
701: STPROC.BIND_I(NUM);
702: STPROC.EXECUTE;*/

Line 704: FND_PROFILE.PUTMULTIPLE(NAMES, VALS, NUM);

700: STPROC.BIND_I(VALS);
701: STPROC.BIND_I(NUM);
702: STPROC.EXECUTE;*/
703:
704: FND_PROFILE.PUTMULTIPLE(NAMES, VALS, NUM);
705: END PUTMULTIPLE;
706:
707:
708: function C_ext_cost_fmtFormula(source_code varchar2, line_id number, unit_of_measure varchar2,