9: --
10:
11: /*============================= PO_INQ_SV ===============================*/
12: /* Local procedure */
13: PROCEDURE get_lookup_dsp(p_lookup_type IN PO_LOOKUP_CODES.lookup_type%TYPE,
14: p_lookup_code IN PO_LOOKUP_CODES.lookup_code%TYPE,
15: x_displayed_field OUT NOCOPY PO_LOOKUP_CODES.displayed_field%TYPE);
16:
17: /*===========================================================================
10:
11: /*============================= PO_INQ_SV ===============================*/
12: /* Local procedure */
13: PROCEDURE get_lookup_dsp(p_lookup_type IN PO_LOOKUP_CODES.lookup_type%TYPE,
14: p_lookup_code IN PO_LOOKUP_CODES.lookup_code%TYPE,
15: x_displayed_field OUT NOCOPY PO_LOOKUP_CODES.displayed_field%TYPE);
16:
17: /*===========================================================================
18:
11: /*============================= PO_INQ_SV ===============================*/
12: /* Local procedure */
13: PROCEDURE get_lookup_dsp(p_lookup_type IN PO_LOOKUP_CODES.lookup_type%TYPE,
14: p_lookup_code IN PO_LOOKUP_CODES.lookup_code%TYPE,
15: x_displayed_field OUT NOCOPY PO_LOOKUP_CODES.displayed_field%TYPE);
16:
17: /*===========================================================================
18:
19: PROCEDURE NAME: get_action_history_values()
2002: -- The displayed value - translated value for the lookup code
2003: --Testing:
2004: --End of Comments
2005: ---------------------------------------------------------------------------
2006: PROCEDURE get_lookup_dsp (p_lookup_type IN PO_LOOKUP_CODES.lookup_type%TYPE,
2007: p_lookup_code IN PO_LOOKUP_CODES.lookup_code%TYPE,
2008: x_displayed_field OUT NOCOPY PO_LOOKUP_CODES.displayed_field%TYPE)
2009: IS
2010:
2003: --Testing:
2004: --End of Comments
2005: ---------------------------------------------------------------------------
2006: PROCEDURE get_lookup_dsp (p_lookup_type IN PO_LOOKUP_CODES.lookup_type%TYPE,
2007: p_lookup_code IN PO_LOOKUP_CODES.lookup_code%TYPE,
2008: x_displayed_field OUT NOCOPY PO_LOOKUP_CODES.displayed_field%TYPE)
2009: IS
2010:
2011: BEGIN
2004: --End of Comments
2005: ---------------------------------------------------------------------------
2006: PROCEDURE get_lookup_dsp (p_lookup_type IN PO_LOOKUP_CODES.lookup_type%TYPE,
2007: p_lookup_code IN PO_LOOKUP_CODES.lookup_code%TYPE,
2008: x_displayed_field OUT NOCOPY PO_LOOKUP_CODES.displayed_field%TYPE)
2009: IS
2010:
2011: BEGIN
2012:
2011: BEGIN
2012:
2013: SELECT polc.displayed_field
2014: INTO x_displayed_field
2015: FROM po_lookup_codes polc
2016: WHERE lookup_type = p_lookup_type
2017: AND lookup_code = p_lookup_code;
2018:
2019: Exception