DBA Data[Home] [Help]

APPS.GHR_COMPLAINTS2_PKG dependencies on FND_COMMON_LOOKUPS

Line 146: FUNCTION get_lookup_code(p_application_id fnd_common_lookups.application_id%TYPE

142: FUNCTION get_window_title(p_complaint_id IN NUMBER
143: ,p_effective_date IN DATE)
144: RETURN VARCHAR2;
145:
146: FUNCTION get_lookup_code(p_application_id fnd_common_lookups.application_id%TYPE
147: ,p_lookup_type fnd_common_lookups.lookup_type%TYPE
148: ,p_meaning fnd_common_lookups.meaning%TYPE)
149: RETURN VARCHAR2;
150:

Line 147: ,p_lookup_type fnd_common_lookups.lookup_type%TYPE

143: ,p_effective_date IN DATE)
144: RETURN VARCHAR2;
145:
146: FUNCTION get_lookup_code(p_application_id fnd_common_lookups.application_id%TYPE
147: ,p_lookup_type fnd_common_lookups.lookup_type%TYPE
148: ,p_meaning fnd_common_lookups.meaning%TYPE)
149: RETURN VARCHAR2;
150:
151: FUNCTION get_lookup_meaning(p_application_id fnd_common_lookups.application_id%TYPE

Line 148: ,p_meaning fnd_common_lookups.meaning%TYPE)

144: RETURN VARCHAR2;
145:
146: FUNCTION get_lookup_code(p_application_id fnd_common_lookups.application_id%TYPE
147: ,p_lookup_type fnd_common_lookups.lookup_type%TYPE
148: ,p_meaning fnd_common_lookups.meaning%TYPE)
149: RETURN VARCHAR2;
150:
151: FUNCTION get_lookup_meaning(p_application_id fnd_common_lookups.application_id%TYPE
152: ,p_lookup_type fnd_common_lookups.lookup_type%TYPE

Line 151: FUNCTION get_lookup_meaning(p_application_id fnd_common_lookups.application_id%TYPE

147: ,p_lookup_type fnd_common_lookups.lookup_type%TYPE
148: ,p_meaning fnd_common_lookups.meaning%TYPE)
149: RETURN VARCHAR2;
150:
151: FUNCTION get_lookup_meaning(p_application_id fnd_common_lookups.application_id%TYPE
152: ,p_lookup_type fnd_common_lookups.lookup_type%TYPE
153: ,p_lookup_code fnd_common_lookups.lookup_code%TYPE)
154: RETURN VARCHAR2;
155:

Line 152: ,p_lookup_type fnd_common_lookups.lookup_type%TYPE

148: ,p_meaning fnd_common_lookups.meaning%TYPE)
149: RETURN VARCHAR2;
150:
151: FUNCTION get_lookup_meaning(p_application_id fnd_common_lookups.application_id%TYPE
152: ,p_lookup_type fnd_common_lookups.lookup_type%TYPE
153: ,p_lookup_code fnd_common_lookups.lookup_code%TYPE)
154: RETURN VARCHAR2;
155:
156: FUNCTION CA_REC_EXISTS(p_complaint_id IN NUMBER)

Line 153: ,p_lookup_code fnd_common_lookups.lookup_code%TYPE)

149: RETURN VARCHAR2;
150:
151: FUNCTION get_lookup_meaning(p_application_id fnd_common_lookups.application_id%TYPE
152: ,p_lookup_type fnd_common_lookups.lookup_type%TYPE
153: ,p_lookup_code fnd_common_lookups.lookup_code%TYPE)
154: RETURN VARCHAR2;
155:
156: FUNCTION CA_REC_EXISTS(p_complaint_id IN NUMBER)
157: RETURN BOOLEAN;