PACKAGE BODY: APPS.HRI_OLTP_VIEW_ASG_STATUS_TYPES

Source

1 PACKAGE BODY HRI_OLTP_VIEW_ASG_STATUS_TYPES AS
2 /* $Header: hrioastp.pkb 115.1 2004/06/03 06:10 prasharm noship $ */
3 --
4 /**************************************************************************
5  *Description: This function gets called from the view
6  *             HRI_JOB_APPLICATIONS for the column applications_status.
7  **************************************************************************/
8 FUNCTION get_asg_user_status
9   (p_asg_type VARCHAR2,
10    p_current_employee_flag VARCHAR2,
11    p_user_status VARCHAR2
12   )
13 RETURN VARCHAR2
14 IS
15 l_status_type		VARCHAR2(4000);
16 --
17 BEGIN
18 	--
19 	l_status_type := hri_bpl_asg_status_types.get_asg_user_status(p_asg_type,
20 	                                                              p_current_employee_flag,
21 	                                                              p_user_status);
22 	return l_status_type;
23 	--
24 --
25 END get_asg_user_status;
26 END HRI_OLTP_VIEW_ASG_STATUS_TYPES;