APPS.PO_INQ_SV dependencies on PO_LOOKUP_CODES

Line 13: PROCEDURE get_lookup_dsp(p_lookup_type IN PO_LOOKUP_CODES.lookup_type%TYPE,

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: /*===========================================================================

Line 14: p_lookup_code IN PO_LOOKUP_CODES.lookup_code%TYPE,

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:

Line 15: x_displayed_field OUT NOCOPY PO_LOOKUP_CODES.displayed_field%TYPE);

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()

Line 2062: PROCEDURE get_lookup_dsp (p_lookup_type IN PO_LOOKUP_CODES.lookup_type%TYPE,

2058: -- The displayed value - translated value for the lookup code
2059: --Testing:
2060: --End of Comments
2061: ---------------------------------------------------------------------------
2062: PROCEDURE get_lookup_dsp (p_lookup_type IN PO_LOOKUP_CODES.lookup_type%TYPE,
2063: p_lookup_code IN PO_LOOKUP_CODES.lookup_code%TYPE,
2064: x_displayed_field OUT NOCOPY PO_LOOKUP_CODES.displayed_field%TYPE)
2065: IS
2066:

Line 2063: p_lookup_code IN PO_LOOKUP_CODES.lookup_code%TYPE,

2059: --Testing:
2060: --End of Comments
2061: ---------------------------------------------------------------------------
2062: PROCEDURE get_lookup_dsp (p_lookup_type IN PO_LOOKUP_CODES.lookup_type%TYPE,
2063: p_lookup_code IN PO_LOOKUP_CODES.lookup_code%TYPE,
2064: x_displayed_field OUT NOCOPY PO_LOOKUP_CODES.displayed_field%TYPE)
2065: IS
2066:
2067: BEGIN

Line 2064: x_displayed_field OUT NOCOPY PO_LOOKUP_CODES.displayed_field%TYPE)

2060: --End of Comments
2061: ---------------------------------------------------------------------------
2062: PROCEDURE get_lookup_dsp (p_lookup_type IN PO_LOOKUP_CODES.lookup_type%TYPE,
2063: p_lookup_code IN PO_LOOKUP_CODES.lookup_code%TYPE,
2064: x_displayed_field OUT NOCOPY PO_LOOKUP_CODES.displayed_field%TYPE)
2065: IS
2066:
2067: BEGIN
2068:

Line 2071: FROM po_lookup_codes polc

2067: BEGIN
2068:
2069: SELECT polc.displayed_field
2070: INTO x_displayed_field
2071: FROM po_lookup_codes polc
2072: WHERE lookup_type = p_lookup_type
2073: AND lookup_code = p_lookup_code;
2074:
2075: Exception