46: */
47:
48: /* Package Variables for the function to avoid repetative calculations */
49:
50: PV_PMICO_GMA_F_CURR gl_curr_mst.currency_code%TYPE;
51: PV_PMICO_GMA_T_CURR gl_curr_mst.currency_code%TYPE;
52: PV_PMICO_GMA_RATE_DT DATE;
53: PV_PMICO_GMA_SIGN NUMBER;
54: PV_PMICO_GMA_XCNG_RATE NUMBER;
47:
48: /* Package Variables for the function to avoid repetative calculations */
49:
50: PV_PMICO_GMA_F_CURR gl_curr_mst.currency_code%TYPE;
51: PV_PMICO_GMA_T_CURR gl_curr_mst.currency_code%TYPE;
52: PV_PMICO_GMA_RATE_DT DATE;
53: PV_PMICO_GMA_SIGN NUMBER;
54: PV_PMICO_GMA_XCNG_RATE NUMBER;
55:
53: PV_PMICO_GMA_SIGN NUMBER;
54: PV_PMICO_GMA_XCNG_RATE NUMBER;
55:
56: FUNCTION PMICO_GET_MULCURR_AMT(
57: p_From_Curr IN gl_curr_mst.currency_code%TYPE,
58: p_To_Curr IN gl_curr_mst.currency_code%TYPE,
59: p_Rate_date IN DATE,
60: p_amount IN NUMBER)
61: RETURN NUMBER;
54: PV_PMICO_GMA_XCNG_RATE NUMBER;
55:
56: FUNCTION PMICO_GET_MULCURR_AMT(
57: p_From_Curr IN gl_curr_mst.currency_code%TYPE,
58: p_To_Curr IN gl_curr_mst.currency_code%TYPE,
59: p_Rate_date IN DATE,
60: p_amount IN NUMBER)
61: RETURN NUMBER;
62:
78: ###################################################################### */
79:
80: /* Package Variables for the function to avoid repetative calculations */
81:
82: PV_PMICO_CE_F_CURR gl_curr_mst.currency_code%TYPE;
83: PV_PMICO_CE_T_CURR gl_curr_mst.currency_code%TYPE;
84: PV_PMICO_CE_RATE_DT DATE;
85: PV_PMICO_CE_XCNG_ERROR NUMBER;
86:
79:
80: /* Package Variables for the function to avoid repetative calculations */
81:
82: PV_PMICO_CE_F_CURR gl_curr_mst.currency_code%TYPE;
83: PV_PMICO_CE_T_CURR gl_curr_mst.currency_code%TYPE;
84: PV_PMICO_CE_RATE_DT DATE;
85: PV_PMICO_CE_XCNG_ERROR NUMBER;
86:
87: FUNCTION PMICO_CURRCONV_ERROR (
84: PV_PMICO_CE_RATE_DT DATE;
85: PV_PMICO_CE_XCNG_ERROR NUMBER;
86:
87: FUNCTION PMICO_CURRCONV_ERROR (
88: p_From_Curr IN gl_curr_mst.currency_code%TYPE,
89: p_To_Curr IN gl_curr_mst.currency_code%TYPE,
90: p_Rate_date IN DATE)
91: RETURN NUMBER;
92:
85: PV_PMICO_CE_XCNG_ERROR NUMBER;
86:
87: FUNCTION PMICO_CURRCONV_ERROR (
88: p_From_Curr IN gl_curr_mst.currency_code%TYPE,
89: p_To_Curr IN gl_curr_mst.currency_code%TYPE,
90: p_Rate_date IN DATE)
91: RETURN NUMBER;
92:
93: