DBA Data[Home] [Help]

APPS.JG_JGZZRCAK_XMLP_PKG dependencies on FND_CURRENCY

Line 936: X0 := FND_CURRENCY.GET_FORMAT_MASK(CURRENCY_CODE, FIELD_LENGTH);

932: FUNCTION GET_FORMAT_MASK(CURRENCY_CODE IN VARCHAR2
933: ,FIELD_LENGTH IN NUMBER) RETURN VARCHAR2 IS
934: X0 VARCHAR2(2000);
935: BEGIN
936: X0 := FND_CURRENCY.GET_FORMAT_MASK(CURRENCY_CODE, FIELD_LENGTH);
937: /*STPROC.INIT('begin :X0 := FND_CURRENCY.GET_FORMAT_MASK(:CURRENCY_CODE, :FIELD_LENGTH); end;');
938: STPROC.BIND_O(X0);
939: STPROC.BIND_I(CURRENCY_CODE);
940: STPROC.BIND_I(FIELD_LENGTH);

Line 937: /*STPROC.INIT('begin :X0 := FND_CURRENCY.GET_FORMAT_MASK(:CURRENCY_CODE, :FIELD_LENGTH); end;');

933: ,FIELD_LENGTH IN NUMBER) RETURN VARCHAR2 IS
934: X0 VARCHAR2(2000);
935: BEGIN
936: X0 := FND_CURRENCY.GET_FORMAT_MASK(CURRENCY_CODE, FIELD_LENGTH);
937: /*STPROC.INIT('begin :X0 := FND_CURRENCY.GET_FORMAT_MASK(:CURRENCY_CODE, :FIELD_LENGTH); end;');
938: STPROC.BIND_O(X0);
939: STPROC.BIND_I(CURRENCY_CODE);
940: STPROC.BIND_I(FIELD_LENGTH);
941: STPROC.EXECUTE;

Line 951: X0 := FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE, FIELD_LENGTH);

947: FUNCTION SAFE_GET_FORMAT_MASK(CURRENCY_CODE IN VARCHAR2
948: ,FIELD_LENGTH IN NUMBER) RETURN VARCHAR2 IS
949: X0 VARCHAR2(2000);
950: BEGIN
951: X0 := FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE, FIELD_LENGTH);
952: /*STPROC.INIT('begin :X0 := FND_CURRENCY.SAFE_GET_FORMAT_MASK(:CURRENCY_CODE, :FIELD_LENGTH); end;');
953: STPROC.BIND_O(X0);
954: STPROC.BIND_I(CURRENCY_CODE);
955: STPROC.BIND_I(FIELD_LENGTH);

Line 952: /*STPROC.INIT('begin :X0 := FND_CURRENCY.SAFE_GET_FORMAT_MASK(:CURRENCY_CODE, :FIELD_LENGTH); end;');

948: ,FIELD_LENGTH IN NUMBER) RETURN VARCHAR2 IS
949: X0 VARCHAR2(2000);
950: BEGIN
951: X0 := FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE, FIELD_LENGTH);
952: /*STPROC.INIT('begin :X0 := FND_CURRENCY.SAFE_GET_FORMAT_MASK(:CURRENCY_CODE, :FIELD_LENGTH); end;');
953: STPROC.BIND_O(X0);
954: STPROC.BIND_I(CURRENCY_CODE);
955: STPROC.BIND_I(FIELD_LENGTH);
956: STPROC.EXECUTE;

Line 967: FND_CURRENCY.GET_INFO(CURRENCY_CODE, PRECISION, EXT_PRECISION, MIN_ACCT_UNIT);

963: ,PRECISION OUT NOCOPY NUMBER
964: ,EXT_PRECISION OUT NOCOPY NUMBER
965: ,MIN_ACCT_UNIT OUT NOCOPY NUMBER) IS
966: BEGIN
967: FND_CURRENCY.GET_INFO(CURRENCY_CODE, PRECISION, EXT_PRECISION, MIN_ACCT_UNIT);
968: /*STPROC.INIT('begin FND_CURRENCY.GET_INFO(:CURRENCY_CODE, :PRECISION, :EXT_PRECISION, :MIN_ACCT_UNIT); end;');
969: STPROC.BIND_I(CURRENCY_CODE);
970: STPROC.BIND_O(PRECISION);
971: STPROC.BIND_O(EXT_PRECISION);

Line 968: /*STPROC.INIT('begin FND_CURRENCY.GET_INFO(:CURRENCY_CODE, :PRECISION, :EXT_PRECISION, :MIN_ACCT_UNIT); end;');

964: ,EXT_PRECISION OUT NOCOPY NUMBER
965: ,MIN_ACCT_UNIT OUT NOCOPY NUMBER) IS
966: BEGIN
967: FND_CURRENCY.GET_INFO(CURRENCY_CODE, PRECISION, EXT_PRECISION, MIN_ACCT_UNIT);
968: /*STPROC.INIT('begin FND_CURRENCY.GET_INFO(:CURRENCY_CODE, :PRECISION, :EXT_PRECISION, :MIN_ACCT_UNIT); end;');
969: STPROC.BIND_I(CURRENCY_CODE);
970: STPROC.BIND_O(PRECISION);
971: STPROC.BIND_O(EXT_PRECISION);
972: STPROC.BIND_O(MIN_ACCT_UNIT);

Line 992: FND_CURRENCY.BUILD_FORMAT_MASK(FORMAT_MASK, FIELD_LENGTH, PRECISION, MIN_ACCT_UNIT, DISP_GRP_SEP, NEG_FORMAT, POS_FORMAT);

988: ,POS_FORMAT IN VARCHAR2) IS
989: --DISP_GRP_SEP BOOLEAN;
990: begin
991: --DISP_GRP_SEP := sys.diutil.int_to_bool(:DISP_GRP_SEP);
992: FND_CURRENCY.BUILD_FORMAT_MASK(FORMAT_MASK, FIELD_LENGTH, PRECISION, MIN_ACCT_UNIT, DISP_GRP_SEP, NEG_FORMAT, POS_FORMAT);
993: /*STPROC.INIT('declare DISP_GRP_SEP BOOLEAN; begin DISP_GRP_SEP := sys.diutil.int_to_bool(:DISP_GRP_SEP); FND_CURRENCY.BUILD_FORMAT_MASK(:FORMAT_MASK, :FIELD_LENGTH, :PRECISION, :MIN_ACCT_UNIT, DISP_GRP_SEP, :NEG_FORMAT, :POS_FORMAT); end;');
994: STPROC.BIND_I(DISP_GRP_SEP);
995: STPROC.BIND_O(FORMAT_MASK);
996: STPROC.BIND_I(FIELD_LENGTH);

Line 993: /*STPROC.INIT('declare DISP_GRP_SEP BOOLEAN; begin DISP_GRP_SEP := sys.diutil.int_to_bool(:DISP_GRP_SEP); FND_CURRENCY.BUILD_FORMAT_MASK(:FORMAT_MASK, :FIELD_LENGTH, :PRECISION, :MIN_ACCT_UNIT, DISP_GRP_SEP, :NEG_FORMAT, :POS_FORMAT); end;');

989: --DISP_GRP_SEP BOOLEAN;
990: begin
991: --DISP_GRP_SEP := sys.diutil.int_to_bool(:DISP_GRP_SEP);
992: FND_CURRENCY.BUILD_FORMAT_MASK(FORMAT_MASK, FIELD_LENGTH, PRECISION, MIN_ACCT_UNIT, DISP_GRP_SEP, NEG_FORMAT, POS_FORMAT);
993: /*STPROC.INIT('declare DISP_GRP_SEP BOOLEAN; begin DISP_GRP_SEP := sys.diutil.int_to_bool(:DISP_GRP_SEP); FND_CURRENCY.BUILD_FORMAT_MASK(:FORMAT_MASK, :FIELD_LENGTH, :PRECISION, :MIN_ACCT_UNIT, DISP_GRP_SEP, :NEG_FORMAT, :POS_FORMAT); end;');
994: STPROC.BIND_I(DISP_GRP_SEP);
995: STPROC.BIND_O(FORMAT_MASK);
996: STPROC.BIND_I(FIELD_LENGTH);
997: STPROC.BIND_I(PRECISION);

Line 1016: FND_CURRENCY.SAFE_BUILD_FORMAT_MASK(FORMAT_MASK, FIELD_LENGTH, PRECISION, MIN_ACCT_UNIT, DISP_GRP_SEP, NEG_FORMAT, POS_FORMAT);

1012: ,POS_FORMAT IN VARCHAR2) IS
1013: --DISP_GRP_SEP BOOLEAN;
1014: begin
1015: --DISP_GRP_SEP := sys.diutil.int_to_bool(:DISP_GRP_SEP);
1016: FND_CURRENCY.SAFE_BUILD_FORMAT_MASK(FORMAT_MASK, FIELD_LENGTH, PRECISION, MIN_ACCT_UNIT, DISP_GRP_SEP, NEG_FORMAT, POS_FORMAT);
1017: /*STPROC.INIT('declare DISP_GRP_SEP BOOLEAN; begin DISP_GRP_SEP := sys.diutil.int_to_bool(:DISP_GRP_SEP); FND_CURRENCY.SAFE_BUILD_FORMAT_MASK(:FORMAT_MASK, :FIELD_LENGTH, :PRECISION, :MIN_ACCT_UNIT, DISP_GRP_SEP, :NEG_FORMAT, :POS_FORMAT); end;');
1018: STPROC.BIND_I(DISP_GRP_SEP);
1019: STPROC.BIND_O(FORMAT_MASK);
1020: STPROC.BIND_I(FIELD_LENGTH);

Line 1017: /*STPROC.INIT('declare DISP_GRP_SEP BOOLEAN; begin DISP_GRP_SEP := sys.diutil.int_to_bool(:DISP_GRP_SEP); FND_CURRENCY.SAFE_BUILD_FORMAT_MASK(:FORMAT_MASK, :FIELD_LENGTH, :PRECISION, :MIN_ACCT_UNIT, DISP_GRP_SEP, :NEG_FORMAT, :POS_FORMAT); end;');

1013: --DISP_GRP_SEP BOOLEAN;
1014: begin
1015: --DISP_GRP_SEP := sys.diutil.int_to_bool(:DISP_GRP_SEP);
1016: FND_CURRENCY.SAFE_BUILD_FORMAT_MASK(FORMAT_MASK, FIELD_LENGTH, PRECISION, MIN_ACCT_UNIT, DISP_GRP_SEP, NEG_FORMAT, POS_FORMAT);
1017: /*STPROC.INIT('declare DISP_GRP_SEP BOOLEAN; begin DISP_GRP_SEP := sys.diutil.int_to_bool(:DISP_GRP_SEP); FND_CURRENCY.SAFE_BUILD_FORMAT_MASK(:FORMAT_MASK, :FIELD_LENGTH, :PRECISION, :MIN_ACCT_UNIT, DISP_GRP_SEP, :NEG_FORMAT, :POS_FORMAT); end;');
1018: STPROC.BIND_I(DISP_GRP_SEP);
1019: STPROC.BIND_O(FORMAT_MASK);
1020: STPROC.BIND_I(FIELD_LENGTH);
1021: STPROC.BIND_I(PRECISION);