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.MRP_MRPRPROP_XMLP_PKG dependencies on FND_PROFILE

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

880:
881: PROCEDURE PUT(NAME IN VARCHAR2
882: ,VAL IN VARCHAR2) IS
883: BEGIN
884: /*STPROC.INIT('begin FND_PROFILE.PUT(:NAME, :VAL); end;');
885: STPROC.BIND_I(NAME);
886: STPROC.BIND_I(VAL);
887: STPROC.EXECUTE;*/
888: FND_PROFILE.PUT(NAME, VAL);

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

884: /*STPROC.INIT('begin FND_PROFILE.PUT(:NAME, :VAL); end;');
885: STPROC.BIND_I(NAME);
886: STPROC.BIND_I(VAL);
887: STPROC.EXECUTE;*/
888: FND_PROFILE.PUT(NAME, VAL);
889: END PUT;
890:
891: FUNCTION DEFINED(NAME IN VARCHAR2) RETURN BOOLEAN IS
892: X0 BOOLEAN;

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

891: FUNCTION DEFINED(NAME IN VARCHAR2) RETURN BOOLEAN IS
892: X0 BOOLEAN;
893: --X0rv BOOLEAN;
894: BEGIN
895: /*STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := FND_PROFILE.DEFINED(:NAME); :X0 := sys.diutil.bool_to_int(X0rv); end;');
896: STPROC.BIND_I(NAME);
897: STPROC.BIND_O(X0);
898: STPROC.EXECUTE;
899: STPROC.RETRIEVE(2

Line 901: X0 := FND_PROFILE.DEFINED(NAME);

897: STPROC.BIND_O(X0);
898: STPROC.EXECUTE;
899: STPROC.RETRIEVE(2
900: ,X0);*/
901: X0 := FND_PROFILE.DEFINED(NAME);
902: --X0 := sys.diutil.bool_to_int(X0rv);
903: RETURN X0;
904: END DEFINED;
905:

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

905:
906: PROCEDURE GET(NAME IN VARCHAR2
907: ,VAL OUT NOCOPY VARCHAR2) IS
908: BEGIN
909: /* STPROC.INIT('begin FND_PROFILE.GET(:NAME, :VAL); end;');
910: STPROC.BIND_I(NAME);
911: STPROC.BIND_O(VAL);
912: STPROC.EXECUTE;
913: STPROC.RETRIEVE(2

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

911: STPROC.BIND_O(VAL);
912: STPROC.EXECUTE;
913: STPROC.RETRIEVE(2
914: ,VAL);*/
915: FND_PROFILE.GET(NAME, VAL);
916: END GET;
917:
918: FUNCTION VALUE(NAME IN VARCHAR2) RETURN VARCHAR2 IS
919: X0 VARCHAR2(2000);

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

917:
918: FUNCTION VALUE(NAME IN VARCHAR2) RETURN VARCHAR2 IS
919: X0 VARCHAR2(2000);
920: BEGIN
921: /* STPROC.INIT('begin :X0 := FND_PROFILE.VALUE(:NAME); end;');
922: STPROC.BIND_O(X0);
923: STPROC.BIND_I(NAME);
924: STPROC.EXECUTE;
925: STPROC.RETRIEVE(1

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

923: STPROC.BIND_I(NAME);
924: STPROC.EXECUTE;
925: STPROC.RETRIEVE(1
926: ,X0);*/
927: X0 := FND_PROFILE.VALUE(NAME);
928: RETURN X0;
929: END VALUE;
930:
931: FUNCTION SAVE_USER(X_NAME IN VARCHAR2

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

932: ,X_VALUE IN VARCHAR2) RETURN BOOLEAN IS
933: X0 BOOLEAN;
934:
935: BEGIN
936: /* STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := FND_PROFILE.SAVE_USER(:X_NAME, :X_VALUE); :X0 := sys.diutil.bool_to_int(X0rv); end;');
937: STPROC.BIND_I(X_NAME);
938: STPROC.BIND_I(X_VALUE);
939: STPROC.BIND_O(X0);
940: STPROC.EXECUTE;

Line 943: X0 := FND_PROFILE.SAVE_USER(X_NAME, X_VALUE);

939: STPROC.BIND_O(X0);
940: STPROC.EXECUTE;
941: STPROC.RETRIEVE(3
942: ,X0);*/
943: X0 := FND_PROFILE.SAVE_USER(X_NAME, X_VALUE);
944:
945: RETURN X0;
946: END SAVE_USER;
947:

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

952: ,X_LEVEL_VALUE_APP_ID IN VARCHAR2) RETURN BOOLEAN IS
953: X0 BOOLEAN;
954: --X0rv BOOLEAN;
955: BEGIN
956: /*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;');
957: STPROC.BIND_I(X_NAME);
958: STPROC.BIND_I(X_VALUE);
959: STPROC.BIND_I(X_LEVEL_NAME);
960: STPROC.BIND_I(X_LEVEL_VALUE);

Line 966: X0 := FND_PROFILE.SAVE(X_NAME, X_VALUE,X_LEVEL_NAME, X_LEVEL_VALUE, X_LEVEL_VALUE_APP_ID);

962: STPROC.BIND_O(X0);
963: STPROC.EXECUTE;
964: STPROC.RETRIEVE(6
965: ,X0);*/
966: X0 := FND_PROFILE.SAVE(X_NAME, X_VALUE,X_LEVEL_NAME, X_LEVEL_VALUE, X_LEVEL_VALUE_APP_ID);
967: -- X0 := sys.diutil.bool_to_int(X0rv);
968: RETURN X0;
969: END SAVE;
970:

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

976: ,DEFINED_Z OUT NOCOPY BOOLEAN) IS
977:
978: BEGIN
979: /*STPROC.INIT('declare DEFINED_Z BOOLEAN; begin DEFINED_Z := sys.diutil.int_to_bool(:DEFINED_Z);
980: FND_PROFILE.GET_SPECIFIC(:NAME_Z, :USER_ID_Z, :RESPONSIBILITY_ID_Z, :APPLICATION_ID_Z, :VAL_Z, DEFINED_Z);
981: :DEFINED_Z := sys.diutil.bool_to_int(DEFINED_Z); end;');
982: STPROC.BIND_O(DEFINED_Z);
983: STPROC.BIND_I(NAME_Z);
984: STPROC.BIND_I(USER_ID_Z);

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

990: ,DEFINED_Z);
991: STPROC.RETRIEVE(6
992: ,VAL_Z);*/
993: --DEFINED_Z1 := sys.diutil.int_to_bool(DEFINED_Z);
994: FND_PROFILE.GET_SPECIFIC(NAME_Z, USER_ID_Z, RESPONSIBILITY_ID_Z, APPLICATION_ID_Z, VAL_Z, DEFINED_Z);
995:
996: --DEFINED_Z := sys.diutil.bool_to_int(DEFINED_Z1);
997: END GET_SPECIFIC;
998:

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

1001: ,RESPONSIBILITY_ID IN NUMBER
1002: ,APPLICATION_ID IN NUMBER) RETURN VARCHAR2 IS
1003: X0 VARCHAR2(2000);
1004: BEGIN
1005: /*STPROC.INIT('begin :X0 := FND_PROFILE.VALUE_SPECIFIC(:NAME, :USER_ID, :RESPONSIBILITY_ID, :APPLICATION_ID); end;');
1006: STPROC.BIND_O(X0);
1007: STPROC.BIND_I(NAME);
1008: STPROC.BIND_I(USER_ID);
1009: STPROC.BIND_I(RESPONSIBILITY_ID);

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

1010: STPROC.BIND_I(APPLICATION_ID);
1011: STPROC.EXECUTE;
1012: STPROC.RETRIEVE(1
1013: ,X0);*/
1014: X0 := FND_PROFILE.VALUE_SPECIFIC(NAME, USER_ID, RESPONSIBILITY_ID, APPLICATION_ID);
1015: RETURN X0;
1016: END VALUE_SPECIFIC;
1017:
1018: PROCEDURE INITIALIZE(USER_ID_Z IN NUMBER

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

1019: ,RESPONSIBILITY_ID_Z IN NUMBER
1020: ,APPLICATION_ID_Z IN NUMBER
1021: ,SITE_ID_Z IN NUMBER) IS
1022: BEGIN
1023: /*STPROC.INIT('begin FND_PROFILE.INITIALIZE(:USER_ID_Z, :RESPONSIBILITY_ID_Z, :APPLICATION_ID_Z, :SITE_ID_Z); end;');
1024: STPROC.BIND_I(USER_ID_Z);
1025: STPROC.BIND_I(RESPONSIBILITY_ID_Z);
1026: STPROC.BIND_I(APPLICATION_ID_Z);
1027: STPROC.BIND_I(SITE_ID_Z);

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

1025: STPROC.BIND_I(RESPONSIBILITY_ID_Z);
1026: STPROC.BIND_I(APPLICATION_ID_Z);
1027: STPROC.BIND_I(SITE_ID_Z);
1028: STPROC.EXECUTE;*/
1029: FND_PROFILE.INITIALIZE(USER_ID_Z, RESPONSIBILITY_ID_Z, APPLICATION_ID_Z, SITE_ID_Z);
1030: END INITIALIZE;
1031:
1032: PROCEDURE PUTMULTIPLE(NAMES IN VARCHAR2
1033: ,VALS IN VARCHAR2

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

1032: PROCEDURE PUTMULTIPLE(NAMES IN VARCHAR2
1033: ,VALS IN VARCHAR2
1034: ,NUM IN NUMBER) IS
1035: BEGIN
1036: /*STPROC.INIT('begin FND_PROFILE.PUTMULTIPLE(:NAMES, :VALS, :NUM); end;');
1037: STPROC.BIND_I(NAMES);
1038: STPROC.BIND_I(VALS);
1039: STPROC.BIND_I(NUM);
1040: STPROC.EXECUTE;*/

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

1037: STPROC.BIND_I(NAMES);
1038: STPROC.BIND_I(VALS);
1039: STPROC.BIND_I(NUM);
1040: STPROC.EXECUTE;*/
1041: FND_PROFILE.PUTMULTIPLE(NAMES, VALS, NUM);
1042: END PUTMULTIPLE;
1043:
1044: PROCEDURE ESTIMATE_LEADTIME(X_ORG_ID IN NUMBER
1045: ,X_FIXED_LEAD IN NUMBER

Line 1751: L_VMI_ENABLED := NVL(FND_PROFILE.VALUE('PO_VMI_ENABLED')

1747: BEGIN
1748: TOTAL := 0;
1749: QTY := 0;
1750: ORG_ID1 := ORG_ID;
1751: L_VMI_ENABLED := NVL(FND_PROFILE.VALUE('PO_VMI_ENABLED')
1752: ,'N');
1753: SCD := TO_CHAR(SUPPLY_CUTOFF_DATE
1754: ,'DD-MON-RRRR');
1755: L_STMT := 'SELECT to_char(nvl(sum(to_org_primary_quantity), 0))