APPS.GHR_COMPLAINTS2_PKG dependencies on FND_COMMON_LOOKUPS

Line 724: p_application_id fnd_common_lookups.application_id%TYPE

720: --
721:
722: -- Get Lookup Code
723: FUNCTION get_lookup_code(
724: p_application_id fnd_common_lookups.application_id%TYPE
725: ,p_lookup_type fnd_common_lookups.lookup_type%TYPE
726: ,p_meaning fnd_common_lookups.meaning%TYPE
727: )
728: RETURN VARCHAR2 IS

Line 725: ,p_lookup_type fnd_common_lookups.lookup_type%TYPE

721:
722: -- Get Lookup Code
723: FUNCTION get_lookup_code(
724: p_application_id fnd_common_lookups.application_id%TYPE
725: ,p_lookup_type fnd_common_lookups.lookup_type%TYPE
726: ,p_meaning fnd_common_lookups.meaning%TYPE
727: )
728: RETURN VARCHAR2 IS
729: --

Line 726: ,p_meaning fnd_common_lookups.meaning%TYPE

722: -- Get Lookup Code
723: FUNCTION get_lookup_code(
724: p_application_id fnd_common_lookups.application_id%TYPE
725: ,p_lookup_type fnd_common_lookups.lookup_type%TYPE
726: ,p_meaning fnd_common_lookups.meaning%TYPE
727: )
728: RETURN VARCHAR2 IS
729: --
730: l_ret_val fnd_common_lookups.lookup_code%TYPE := NULL;

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

726: ,p_meaning fnd_common_lookups.meaning%TYPE
727: )
728: RETURN VARCHAR2 IS
729: --
730: l_ret_val fnd_common_lookups.lookup_code%TYPE := NULL;
731:
732: CURSOR cur_loc IS
733: SELECT loc.lookup_code
734: FROM fnd_common_lookups loc

Line 734: FROM fnd_common_lookups loc

730: l_ret_val fnd_common_lookups.lookup_code%TYPE := NULL;
731:
732: CURSOR cur_loc IS
733: SELECT loc.lookup_code
734: FROM fnd_common_lookups loc
735: WHERE loc.application_id = p_application_id
736: AND loc.lookup_type = p_lookup_type
737: AND loc.meaning = p_meaning;
738: --

Line 751: p_application_id fnd_common_lookups.application_id%TYPE

747: END get_lookup_code;
748:
749: -- Get Lookup Meaning
750: FUNCTION get_lookup_meaning(
751: p_application_id fnd_common_lookups.application_id%TYPE
752: ,p_lookup_type fnd_common_lookups.lookup_type%TYPE
753: ,p_lookup_code fnd_common_lookups.lookup_code%TYPE
754: )
755: RETURN VARCHAR2 IS

Line 752: ,p_lookup_type fnd_common_lookups.lookup_type%TYPE

748:
749: -- Get Lookup Meaning
750: FUNCTION get_lookup_meaning(
751: p_application_id fnd_common_lookups.application_id%TYPE
752: ,p_lookup_type fnd_common_lookups.lookup_type%TYPE
753: ,p_lookup_code fnd_common_lookups.lookup_code%TYPE
754: )
755: RETURN VARCHAR2 IS
756: --

Line 753: ,p_lookup_code fnd_common_lookups.lookup_code%TYPE

749: -- Get Lookup Meaning
750: FUNCTION get_lookup_meaning(
751: p_application_id fnd_common_lookups.application_id%TYPE
752: ,p_lookup_type fnd_common_lookups.lookup_type%TYPE
753: ,p_lookup_code fnd_common_lookups.lookup_code%TYPE
754: )
755: RETURN VARCHAR2 IS
756: --
757: l_ret_val fnd_common_lookups.meaning%TYPE := NULL;

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

753: ,p_lookup_code fnd_common_lookups.lookup_code%TYPE
754: )
755: RETURN VARCHAR2 IS
756: --
757: l_ret_val fnd_common_lookups.meaning%TYPE := NULL;
758:
759: CURSOR cur_loc IS
760: SELECT loc.meaning
761: FROM fnd_common_lookups loc

Line 761: FROM fnd_common_lookups loc

757: l_ret_val fnd_common_lookups.meaning%TYPE := NULL;
758:
759: CURSOR cur_loc IS
760: SELECT loc.meaning
761: FROM fnd_common_lookups loc
762: WHERE loc.application_id = p_application_id
763: AND loc.lookup_type = p_lookup_type
764: AND loc.lookup_code = p_lookup_code;
765: --