123: ,p_org_info VARCHAR2
124: ,p_business_group_id NUMBER
125: ,p_effective_date DATE);
126:
127: FUNCTION chk_entry_in_lookup(p_lookup_type IN hr_lookups.lookup_type%TYPE
128: ,p_entry_val IN hr_lookups.meaning%TYPE
129: ,p_effective_date IN hr_lookups.start_date_active%TYPE
130: ,p_message OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
131: --
124: ,p_business_group_id NUMBER
125: ,p_effective_date DATE);
126:
127: FUNCTION chk_entry_in_lookup(p_lookup_type IN hr_lookups.lookup_type%TYPE
128: ,p_entry_val IN hr_lookups.meaning%TYPE
129: ,p_effective_date IN hr_lookups.start_date_active%TYPE
130: ,p_message OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
131: --
132: FUNCTION get_message(p_product IN VARCHAR2
125: ,p_effective_date DATE);
126:
127: FUNCTION chk_entry_in_lookup(p_lookup_type IN hr_lookups.lookup_type%TYPE
128: ,p_entry_val IN hr_lookups.meaning%TYPE
129: ,p_effective_date IN hr_lookups.start_date_active%TYPE
130: ,p_message OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
131: --
132: FUNCTION get_message(p_product IN VARCHAR2
133: ,p_message_name IN VARCHAR2