PACKAGE BODY: APPS.BOM_PA_UTIL

Source

1 PACKAGE BODY BOM_PA_Util AS
2 /* $Header: BOMPAUTB.pls 120.1 2006/02/01 04:34:25 arudresh noship $ */
3 /***************************************************************************
4 --
5 --
6 --  FILENAME
7 --
8 --      BOMPAUTB.pls
9 --
10 --  DESCRIPTION
11 --
12 --      Body of package BOM_PA_Util
13 --
14 --  NOTES
15 --
16 --  HISTORY
17 --
18 --  27-JUN-03 Refai Farook  Initial Creation
19 --
20 --
21 ****************************************************************************/
22 
23    Function Get_Lifecycle(p_lifecycle_id NUMBER) RETURN VARCHAR2 is
24      l_name VARCHAR2(240);
25    BEGIN
26      IF p_lifecycle_id IS NULL
27      THEN
28        Return NULL;
29      ELSE
30        SELECT name INTO l_name FROM pa_ego_lifecycles_v WHERE proj_element_id = p_lifecycle_id AND
31         object_type = 'PA_STRUCTURES';
32        Return l_name;
33      END IF;
34     EXCEPTION WHEN OTHERS THEN
35       Return NULL;
36    END;
37 
38    Function Get_Phase(p_phase_id NUMBER) RETURN VARCHAR2 is
39      l_name VARCHAR2(240);
40    BEGIN
41      IF p_phase_id IS NULL
42      THEN
43        Return NULL;
44      ELSE
45        SELECT name INTO l_name FROM pa_ego_phases_v WHERE proj_element_id = p_phase_id AND
46         object_type = 'PA_TASKS';
47        Return l_name;
48      END IF;
49     EXCEPTION WHEN OTHERS THEN
50       Return NULL;
51    END;
52 
53 END BOM_PA_Util;