PACKAGE: APPS.PA_RPT_UTILS

Source

1 PACKAGE PA_RPT_UTILS AUTHID CURRENT_USER AS
2 /* $Header: PARPUTLS.pls 115.2 99/10/28 14:13:27 porting ship  $ */
3 
4 ---------------------------
5 --  GLOBAL VARIABLES
6 --
7 Class_Category1 PA_CLASS_CATEGORIES.CLASS_CATEGORY%type;
8 Class_Category2 PA_CLASS_CATEGORIES.CLASS_CATEGORY%type;
9 Class_Category3 PA_CLASS_CATEGORIES.CLASS_CATEGORY%type;
10 Role_Type1 PA_PROJECT_ROLE_TYPES.PROJECT_ROLE_TYPE%type;
11 Role_Type2 PA_PROJECT_ROLE_TYPES.PROJECT_ROLE_TYPE%type;
12 Role_Type3 PA_PROJECT_ROLE_TYPES.PROJECT_ROLE_TYPE%type;
13 Cost_Budget_TypeCode1 PA_Budget_Types.Budget_type_code%type;
14 Cost_Budget_TypeCode2 PA_Budget_Types.Budget_type_code%type;
15 Revenue_Budget_TypeCode1 PA_Budget_Types.Budget_type_code%type;
16 Revenue_Budget_TypeCode2 PA_Budget_Types.Budget_type_code%type;
17 Unassigned_txt Varchar2(2000);
18 PA_Start_Date  Date;
19 PA_End_Date    Date;
20 
21 
22 ----------------------------
23 --  PROCEDURES AND FUNCTIONS
24 --
25 --
26 --  1. Procedure Name:	DISCOVERER_INIT
27 --  	Usage:		Populates data in tables : PA_PROJ_RPT_ATTRIBS_TEMP
28 --                      Reads the profiles for the responsibility,
29 --                      and accordingly creates records.
30 Procedure DISCOVERER_INIT;
31 
32 -----------------------------------------------------------------------
33 -- 2.  Function Name:   PROJECT_RPT_CLASS
34 --     Usage:           Returns the Class_Code assigned to the project
35 --                      for the given Class_Category.
36 Function PROJECT_RPT_CLASS ( x_Project_ID Number,
37                              x_Class_Category Varchar2 )
38 Return Varchar2;
39 
40 ------------------------------------------------------------------------
41 -- 3.  Function Name:   PROJECT_RPT_KEYMEMBER
42 --     Usage:           Returns the Key member assigned to the project
43 --                      for the given Project Role Type.
44 Function PROJECT_RPT_KEYMEMBER ( x_Project_ID Number,
45                                  x_Project_Role_Type Varchar2 )
46 Return Varchar2;
47 
48 -------------------------------------------------------------------------
49 -- 4.  Function Name:    GET_RPT_CLASS_CATEGORY
50 --     Usage:            Returns the reporting class category attributes
51 --                       Returns the corresponding value.
52 Function GET_RPT_CLASS_CATEGORY ( x_number Number )
53 Return Varchar2;
54 
55 -------------------------------------------------------------------------
56 -- 5.  Function Name:    GET_RPT_ROLE_TYPE
57 --     Usage:            Returns the reporting project role type attributes
58 --                       Returns the corresponding value.
59 Function GET_RPT_ROLE_TYPE ( x_number Number )
60 Return Varchar2;
61 
62 -------------------------------------------------------------------------
63 -- 6.  Function Name:    GET_RPT_BUDGET_TYPE
64 --     Usage:            Returns the reporting budget type attributes
65 --                       Returns the corresponding value.
66 Function GET_RPT_BUDGET_TYPE ( x_type varchar2,
67                              x_number Number )
68 Return Varchar2;
69 
70 -------------------------------------------------------------------------
71 
72 END PA_RPT_UTILS;