1 PACKAGE PA_REP_UTIL_SCREEN AUTHID CURRENT_USER AS
2 /* $Header: PARRSCRS.pls 115.7 2002/03/04 04:51:17 pkm ship $ */
3
4
5 /*
6 * Procedures.
7 */
8
9 PROCEDURE poplt_screen_tmp_table(
10 p_Organization_ID IN NUMBER
11 , p_Manager_ID IN NUMBER
12 , p_Period_Type IN VARCHAR2
13 , p_Period_Year IN NUMBER
14 , p_Period_Quarter IN NUMBER
15 , p_Period_Name IN VARCHAR2
16 , p_Global_Week_End_Date IN DATE
17 , p_Assignment_Status IN VARCHAR2
18 , p_Show_Percentage_By IN VARCHAR2
19 , p_Utilization_Method IN VARCHAR2
20 , p_Utilization_Category_Id IN NUMBER
21 , p_Calling_Mode IN VARCHAR2
22 );
23
24 PROCEDURE poplt_u1_screen_tmp_table(
25 p_Organization_ID IN NUMBER
26 , p_Period_Type IN VARCHAR2
27 , p_Period_Year IN VARCHAR2
28 , p_Period_Quarter IN VARCHAR2
29 , p_Period_Name IN VARCHAR2
30 , p_Global_Week_End_Date IN VARCHAR2
31 , p_Show_Percentage_By IN VARCHAR2
32 );
33
34
35 /*
36 * Functions.
37 */
38
39 FUNCTION calculate_capacity(
40 p_ORG_ID IN NUMBER
41 , p_Balance_Type_Code IN VARCHAR2
42 , p_Entity_ID IN NUMBER
43 , p_Version_ID IN NUMBER
44 , p_Period_Type IN VARCHAR2
45 , p_Period_Set_Name IN VARCHAR2
46 , p_Period_Name IN VARCHAR2
47 , p_Global_Exp_Period_End_Date IN DATE
48 , p_Amount_ID_Resource_Hours IN NUMBER
49 , p_Amount_ID_Capacity IN NUMBER
50 , p_Amount_ID_Reduced_Capacity IN NUMBER
51 , p_Show_Percentage_By IN VARCHAR2
52 , p_Organization_Id IN NUMBER DEFAULT NULL
53 , p_Period_Year IN NUMBER DEFAULT NULL
54 , p_Quarter_Or_Month_Number IN NUMBER DEFAULT NULL
55 )
56 RETURN NUMBER;
57
58 END PA_REP_UTIL_SCREEN;