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 553: /*STPROC.INIT('begin FND_PROFILE.PUT(:NAME, :VAL); end;');

549:
550: PROCEDURE PUT(NAME IN VARCHAR2
551: ,VAL IN VARCHAR2) IS
552: BEGIN
553: /*STPROC.INIT('begin FND_PROFILE.PUT(:NAME, :VAL); end;');
554: STPROC.BIND_I(NAME);
555: STPROC.BIND_I(VAL);
556: STPROC.EXECUTE;*/
557: FND_PROFILE.PUT(NAME, VAL);

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

553: /*STPROC.INIT('begin FND_PROFILE.PUT(:NAME, :VAL); end;');
554: STPROC.BIND_I(NAME);
555: STPROC.BIND_I(VAL);
556: STPROC.EXECUTE;*/
557: FND_PROFILE.PUT(NAME, VAL);
558: END PUT;
559:
560: FUNCTION DEFINED(NAME IN VARCHAR2) RETURN BOOLEAN IS
561: X0 BOOLEAN;

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

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

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

579:
580: PROCEDURE GET(NAME IN VARCHAR2
581: ,VAL OUT NOCOPY VARCHAR2) IS
582: BEGIN
583: /*STPROC.INIT('begin FND_PROFILE.GET(:NAME, :VAL); end;');
584: STPROC.BIND_I(NAME);
585: STPROC.BIND_O(VAL);
586: STPROC.EXECUTE;
587: STPROC.RETRIEVE(2

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

585: STPROC.BIND_O(VAL);
586: STPROC.EXECUTE;
587: STPROC.RETRIEVE(2
588: ,VAL);*/
589: FND_PROFILE.GET(NAME, VAL);
590: END GET;
591:
592: FUNCTION VALUE(NAME IN VARCHAR2) RETURN VARCHAR2 IS
593: X0 VARCHAR2(2000);

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

591:
592: FUNCTION VALUE(NAME IN VARCHAR2) RETURN VARCHAR2 IS
593: X0 VARCHAR2(2000);
594: BEGIN
595: /*STPROC.INIT('begin :X0 := FND_PROFILE.VALUE(:NAME); end;');
596: STPROC.BIND_O(X0);
597: STPROC.BIND_I(NAME);
598: STPROC.EXECUTE;
599: STPROC.RETRIEVE(1

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

599: STPROC.RETRIEVE(1
600: ,X0);
601: RETURN X0;*/
602:
603: X0 := FND_PROFILE.VALUE(NAME);
604: RETURN X0;
605: END VALUE;
606:
607: FUNCTION SAVE_USER(X_NAME IN VARCHAR2

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

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

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

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

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

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

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

691: ,RESPONSIBILITY_ID IN NUMBER
692: ,APPLICATION_ID IN NUMBER) RETURN VARCHAR2 IS
693: X0 VARCHAR2(2000);
694: BEGIN
695: /*STPROC.INIT('begin :X0 := FND_PROFILE.VALUE_SPECIFIC(:NAME, :USER_ID, :RESPONSIBILITY_ID, :APPLICATION_ID); end;');
696: STPROC.BIND_O(X0);
697: STPROC.BIND_I(NAME);
698: STPROC.BIND_I(USER_ID);
699: STPROC.BIND_I(RESPONSIBILITY_ID);

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

702: STPROC.RETRIEVE(1
703: ,X0);
704: RETURN X0;*/
705:
706: X0 := FND_PROFILE.VALUE_SPECIFIC(NAME, USER_ID, RESPONSIBILITY_ID, APPLICATION_ID);
707: RETURN X0;
708: END VALUE_SPECIFIC;
709:
710: PROCEDURE INITIALIZE(USER_ID_Z IN NUMBER

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

711: ,RESPONSIBILITY_ID_Z IN NUMBER
712: ,APPLICATION_ID_Z IN NUMBER
713: ,SITE_ID_Z IN NUMBER) IS
714: BEGIN
715: /*STPROC.INIT('begin FND_PROFILE.INITIALIZE(:USER_ID_Z, :RESPONSIBILITY_ID_Z, :APPLICATION_ID_Z, :SITE_ID_Z); end;');
716: STPROC.BIND_I(USER_ID_Z);
717: STPROC.BIND_I(RESPONSIBILITY_ID_Z);
718: STPROC.BIND_I(APPLICATION_ID_Z);
719: STPROC.BIND_I(SITE_ID_Z);

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

718: STPROC.BIND_I(APPLICATION_ID_Z);
719: STPROC.BIND_I(SITE_ID_Z);
720: STPROC.EXECUTE;*/
721:
722: FND_PROFILE.INITIALIZE(USER_ID_Z, RESPONSIBILITY_ID_Z, APPLICATION_ID_Z, SITE_ID_Z);
723: END INITIALIZE;
724:
725: PROCEDURE PUTMULTIPLE(NAMES IN VARCHAR2
726: ,VALS IN VARCHAR2

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

725: PROCEDURE PUTMULTIPLE(NAMES IN VARCHAR2
726: ,VALS IN VARCHAR2
727: ,NUM IN NUMBER) IS
728: BEGIN
729: /*STPROC.INIT('begin FND_PROFILE.PUTMULTIPLE(:NAMES, :VALS, :NUM); end;');
730: STPROC.BIND_I(NAMES);
731: STPROC.BIND_I(VALS);
732: STPROC.BIND_I(NUM);
733: STPROC.EXECUTE;*/

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

731: STPROC.BIND_I(VALS);
732: STPROC.BIND_I(NUM);
733: STPROC.EXECUTE;*/
734:
735: FND_PROFILE.PUTMULTIPLE(NAMES, VALS, NUM);
736: END PUTMULTIPLE;
737:
738:
739: function C_ext_cost_fmtFormula(p_source_code varchar2, p_source_line_id number, unit_of_measure varchar2,