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.

[Home] [Help]

APPS.GML_VALIDATE_PO dependencies on GL_XCHG_RTE

Line 710: (v_exchange_rate OUT gl_xchg_rte.exchange_rate%TYPE,

706: | |
707: ========================================================================*/
708:
709: PROCEDURE get_exchange_rate
710: (v_exchange_rate OUT gl_xchg_rte.exchange_rate%TYPE,
711: v_mul_div_sign OUT gl_xchg_rte.mul_div_sign%TYPE,
712: v_exchange_rate_date OUT gl_xchg_rte.exchange_rate_date%TYPE,
713: v_to_currency IN gl_xchg_rte.to_currency_code%TYPE,
714: v_from_currency IN gl_xchg_rte.from_currency_code%TYPE,

Line 711: v_mul_div_sign OUT gl_xchg_rte.mul_div_sign%TYPE,

707: ========================================================================*/
708:
709: PROCEDURE get_exchange_rate
710: (v_exchange_rate OUT gl_xchg_rte.exchange_rate%TYPE,
711: v_mul_div_sign OUT gl_xchg_rte.mul_div_sign%TYPE,
712: v_exchange_rate_date OUT gl_xchg_rte.exchange_rate_date%TYPE,
713: v_to_currency IN gl_xchg_rte.to_currency_code%TYPE,
714: v_from_currency IN gl_xchg_rte.from_currency_code%TYPE,
715: v_trans_source_type IN gl_srce_mst.trans_source_type%TYPE)

Line 712: v_exchange_rate_date OUT gl_xchg_rte.exchange_rate_date%TYPE,

708:
709: PROCEDURE get_exchange_rate
710: (v_exchange_rate OUT gl_xchg_rte.exchange_rate%TYPE,
711: v_mul_div_sign OUT gl_xchg_rte.mul_div_sign%TYPE,
712: v_exchange_rate_date OUT gl_xchg_rte.exchange_rate_date%TYPE,
713: v_to_currency IN gl_xchg_rte.to_currency_code%TYPE,
714: v_from_currency IN gl_xchg_rte.from_currency_code%TYPE,
715: v_trans_source_type IN gl_srce_mst.trans_source_type%TYPE)
716:

Line 713: v_to_currency IN gl_xchg_rte.to_currency_code%TYPE,

709: PROCEDURE get_exchange_rate
710: (v_exchange_rate OUT gl_xchg_rte.exchange_rate%TYPE,
711: v_mul_div_sign OUT gl_xchg_rte.mul_div_sign%TYPE,
712: v_exchange_rate_date OUT gl_xchg_rte.exchange_rate_date%TYPE,
713: v_to_currency IN gl_xchg_rte.to_currency_code%TYPE,
714: v_from_currency IN gl_xchg_rte.from_currency_code%TYPE,
715: v_trans_source_type IN gl_srce_mst.trans_source_type%TYPE)
716:
717: IS

Line 714: v_from_currency IN gl_xchg_rte.from_currency_code%TYPE,

710: (v_exchange_rate OUT gl_xchg_rte.exchange_rate%TYPE,
711: v_mul_div_sign OUT gl_xchg_rte.mul_div_sign%TYPE,
712: v_exchange_rate_date OUT gl_xchg_rte.exchange_rate_date%TYPE,
713: v_to_currency IN gl_xchg_rte.to_currency_code%TYPE,
714: v_from_currency IN gl_xchg_rte.from_currency_code%TYPE,
715: v_trans_source_type IN gl_srce_mst.trans_source_type%TYPE)
716:
717: IS
718: err_num NUMBER;

Line 725: FROM gl_xchg_rte ex,

721: CURSOR exchange_cur IS
722: SELECT ex.exchange_rate,
723: ex.mul_div_sign,
724: ex.exchange_rate_date
725: FROM gl_xchg_rte ex,
726: gl_srce_mst src
727: WHERE ex.to_currency_code = v_to_currency AND
728: ex.from_currency_code = v_from_currency AND
729: ex.exchange_rate_date <= SYSDATE AND