PACKAGE BODY: APPS.HRI_OLTP_DISC_JOB

Source

1 PACKAGE BODY hri_oltp_disc_job AS
2 /* $Header: hriodjob.pkb 115.0 2003/02/28 15:13:11 jtitmas noship $ */
3 
4 /******************************************************************************/
5 /* Finds the product category for a given job                                 */
6 /******************************************************************************/
7 FUNCTION lookup_product_category( p_job_id     IN NUMBER )
8      RETURN VARCHAR2 IS
9 
10   l_product_category     VARCHAR2(80);
11 
12 BEGIN
13 
14   l_product_category := hri_bpl_job.lookup_product_category(p_job_id);
15 
16   RETURN l_product_category;
17 
18 EXCEPTION WHEN OTHERS THEN
19 
20   RETURN null;
21 
22 END lookup_product_category;
23 
24 END hri_oltp_disc_job;