APPS.GHR_COMPLAINTS2_PKG dependencies on FND_COMMON_LOOKUPS

Line 719: p_application_id fnd_common_lookups.application_id%TYPE

715: --
716:
717: -- Get Lookup Code
718: FUNCTION get_lookup_code(
719: p_application_id fnd_common_lookups.application_id%TYPE
720: ,p_lookup_type fnd_common_lookups.lookup_type%TYPE
721: ,p_meaning fnd_common_lookups.meaning%TYPE
722: )
723: RETURN VARCHAR2 IS

Line 720: ,p_lookup_type fnd_common_lookups.lookup_type%TYPE

716:
717: -- Get Lookup Code
718: FUNCTION get_lookup_code(
719: p_application_id fnd_common_lookups.application_id%TYPE
720: ,p_lookup_type fnd_common_lookups.lookup_type%TYPE
721: ,p_meaning fnd_common_lookups.meaning%TYPE
722: )
723: RETURN VARCHAR2 IS
724: --

Line 721: ,p_meaning fnd_common_lookups.meaning%TYPE

717: -- Get Lookup Code
718: FUNCTION get_lookup_code(
719: p_application_id fnd_common_lookups.application_id%TYPE
720: ,p_lookup_type fnd_common_lookups.lookup_type%TYPE
721: ,p_meaning fnd_common_lookups.meaning%TYPE
722: )
723: RETURN VARCHAR2 IS
724: --
725: l_ret_val fnd_common_lookups.lookup_code%TYPE := NULL;

Line 725: l_ret_val fnd_common_lookups.lookup_code%TYPE := NULL;

721: ,p_meaning fnd_common_lookups.meaning%TYPE
722: )
723: RETURN VARCHAR2 IS
724: --
725: l_ret_val fnd_common_lookups.lookup_code%TYPE := NULL;
726:
727: CURSOR cur_loc IS
728: SELECT loc.lookup_code
729: FROM fnd_common_lookups loc

Line 729: FROM fnd_common_lookups loc

725: l_ret_val fnd_common_lookups.lookup_code%TYPE := NULL;
726:
727: CURSOR cur_loc IS
728: SELECT loc.lookup_code
729: FROM fnd_common_lookups loc
730: WHERE loc.application_id = p_application_id
731: AND loc.lookup_type = p_lookup_type
732: AND loc.meaning = p_meaning;
733: --

Line 746: p_application_id fnd_common_lookups.application_id%TYPE

742: END get_lookup_code;
743:
744: -- Get Lookup Meaning
745: FUNCTION get_lookup_meaning(
746: p_application_id fnd_common_lookups.application_id%TYPE
747: ,p_lookup_type fnd_common_lookups.lookup_type%TYPE
748: ,p_lookup_code fnd_common_lookups.lookup_code%TYPE
749: )
750: RETURN VARCHAR2 IS

Line 747: ,p_lookup_type fnd_common_lookups.lookup_type%TYPE

743:
744: -- Get Lookup Meaning
745: FUNCTION get_lookup_meaning(
746: p_application_id fnd_common_lookups.application_id%TYPE
747: ,p_lookup_type fnd_common_lookups.lookup_type%TYPE
748: ,p_lookup_code fnd_common_lookups.lookup_code%TYPE
749: )
750: RETURN VARCHAR2 IS
751: --

Line 748: ,p_lookup_code fnd_common_lookups.lookup_code%TYPE

744: -- Get Lookup Meaning
745: FUNCTION get_lookup_meaning(
746: p_application_id fnd_common_lookups.application_id%TYPE
747: ,p_lookup_type fnd_common_lookups.lookup_type%TYPE
748: ,p_lookup_code fnd_common_lookups.lookup_code%TYPE
749: )
750: RETURN VARCHAR2 IS
751: --
752: l_ret_val fnd_common_lookups.meaning%TYPE := NULL;

Line 752: l_ret_val fnd_common_lookups.meaning%TYPE := NULL;

748: ,p_lookup_code fnd_common_lookups.lookup_code%TYPE
749: )
750: RETURN VARCHAR2 IS
751: --
752: l_ret_val fnd_common_lookups.meaning%TYPE := NULL;
753:
754: CURSOR cur_loc IS
755: SELECT loc.meaning
756: FROM fnd_common_lookups loc

Line 756: FROM fnd_common_lookups loc

752: l_ret_val fnd_common_lookups.meaning%TYPE := NULL;
753:
754: CURSOR cur_loc IS
755: SELECT loc.meaning
756: FROM fnd_common_lookups loc
757: WHERE loc.application_id = p_application_id
758: AND loc.lookup_type = p_lookup_type
759: AND loc.lookup_code = p_lookup_code;
760: --