DBA Data[Home] [Help]

APPS.JL_JLCOARCR_XMLP_PKG dependencies on FND_CURRENCY

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

702: FUNCTION GET_FORMAT_MASK(CURRENCY_CODE IN VARCHAR2
703: ,FIELD_LENGTH IN NUMBER) RETURN VARCHAR2 IS
704: X0 VARCHAR2(2000);
705: BEGIN
706: STPROC.INIT('begin :X0 := FND_CURRENCY.GET_FORMAT_MASK(:CURRENCY_CODE, :FIELD_LENGTH); end;');
707: STPROC.BIND_O(X0);
708: STPROC.BIND_I(CURRENCY_CODE);
709: STPROC.BIND_I(FIELD_LENGTH);
710: STPROC.EXECUTE;

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

715: FUNCTION SAFE_GET_FORMAT_MASK(CURRENCY_CODE IN VARCHAR2
716: ,FIELD_LENGTH IN NUMBER) RETURN VARCHAR2 IS
717: X0 VARCHAR2(2000);
718: BEGIN
719: STPROC.INIT('begin :X0 := FND_CURRENCY.SAFE_GET_FORMAT_MASK(:CURRENCY_CODE, :FIELD_LENGTH); end;');
720: STPROC.BIND_O(X0);
721: STPROC.BIND_I(CURRENCY_CODE);
722: STPROC.BIND_I(FIELD_LENGTH);
723: STPROC.EXECUTE;

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

729: ,PRECISION OUT NOCOPY NUMBER
730: ,EXT_PRECISION OUT NOCOPY NUMBER
731: ,MIN_ACCT_UNIT OUT NOCOPY NUMBER) IS
732: BEGIN
733: FND_CURRENCY.GET_INFO(CURRENCY_CODE, PRECISION, EXT_PRECISION, MIN_ACCT_UNIT);
734: END GET_INFO;
735: /* PROCEDURE BUILD_FORMAT_MASK(FORMAT_MASK OUT NOCOPY VARCHAR2
736: ,FIELD_LENGTH IN NUMBER
737: ,PRECISION IN NUMBER

Line 743: 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;');

739: ,DISP_GRP_SEP IN BOOLEAN
740: ,NEG_FORMAT IN VARCHAR2
741: ,POS_FORMAT IN VARCHAR2) IS
742: BEGIN
743: 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;');
744: STPROC.BIND_I(DISP_GRP_SEP);
745: STPROC.BIND_O(FORMAT_MASK);
746: STPROC.BIND_I(FIELD_LENGTH);
747: STPROC.BIND_I(PRECISION);

Line 763: 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;');

759: ,DISP_GRP_SEP IN BOOLEAN
760: ,NEG_FORMAT IN VARCHAR2
761: ,POS_FORMAT IN VARCHAR2) IS
762: BEGIN
763: 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;');
764: STPROC.BIND_I(DISP_GRP_SEP);
765: STPROC.BIND_O(FORMAT_MASK);
766: STPROC.BIND_I(FIELD_LENGTH);
767: STPROC.BIND_I(PRECISION);