[Home] [Help]
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;