1 PACKAGE PJI_PMV_UTIL AS
2 -- $Header: PJIRX04S.pls 120.10 2007/11/16 15:07:06 vvjoshi ship $
3
4 FUNCTION Get_Labor_Unit
5 RETURN VARCHAR2;
6
7 FUNCTION Get_Projects ( p_person_id IN NUMBER
8 ,p_exp_org_id IN NUMBER
9 ,p_date IN DATE)
10 RETURN VARCHAR2;
11
12
13 FUNCTION Get_Available_From (p_person_id IN NUMBER
14 ,p_exp_org_id IN NUMBER
15 ,p_from_date IN NUMBER
16 ,p_as_of_date IN NUMBER
17 ,p_threshold IN NUMBER)
18 RETURN VARCHAR2;
19
20 FUNCTION Get_Next_Asgmt_Date (p_person_id IN NUMBER
21 ,p_exp_org_id IN NUMBER
22 ,p_to_date IN NUMBER
23 ,p_as_of_date IN NUMBER
24 ,p_threshold IN NUMBER)
25 RETURN VARCHAR2;
26
27 -- Table added by V Gautam
28 TYPE Measure_Label_Code_Tbl IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
29 TYPE Measure_Label_Tbl IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;
30
31 -- Function Added by V Gautam
32 FUNCTION GetTimeLevelLabel( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
33 , p_Label_Code VARCHAR2 DEFAULT NULL
34 , p_Bit_Mode VARCHAR2 DEFAULT '1')
35 RETURN VARCHAR2;
36
37 FUNCTION GetPriorLabel( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
38 RETURN VARCHAR2;
39
40 -- Procedure added by adabdull
41 PROCEDURE Redirect_RA2_RA5 (p_date IN VARCHAR2,
42 p_week IN VARCHAR2,
43 p_organization IN VARCHAR2,
44 p_operating_unit IN VARCHAR2,
45 p_threshold IN VARCHAR2
46 );
47
48 PROCEDURE Redirect_RA1_RA4 (p_organization IN VARCHAR2,
49 p_operating_unit IN VARCHAR2 DEFAULT NULL,
50 p_threshold IN VARCHAR2,
51 p_period_type IN VARCHAR2,
52 p_start_time IN VARCHAR2
53 );
54
55 PROCEDURE Redirect_RA4_RA5 (p_week IN VARCHAR2,
56 p_organization IN VARCHAR2,
57 p_operating_unit IN VARCHAR2,
58 p_threshold IN VARCHAR2
59 );
60
61 FUNCTION PJI_ORGANIZATION_LOV RETURN PJI_ORGANIZATION_LIST_TBL;
62
63 PROCEDURE Redirect_RA1_RA5 (p_organization IN VARCHAR2,
64 p_operating_unit IN VARCHAR2 DEFAULT NULL,
65 p_threshold IN VARCHAR2,
66 p_period_type IN VARCHAR2,
67 p_start_time IN VARCHAR2,
68 p_end_time IN VARCHAR2
69 );
70
71 PROCEDURE SEED_PJI_STATS;
72
73 FUNCTION GET_JOB_LEVEL ( p_person_id NUMBER,
74 p_as_of_date DATE )
75 RETURN NUMBER;
76
77
78 FUNCTION RA2_RA5_URL (p_date IN NUMBER,
79 p_week IN VARCHAR2,
80 p_organization IN VARCHAR2,
81 p_operating_unit IN VARCHAR2,
82 p_threshold IN NUMBER)
83
84 RETURN VARCHAR;
85
86
87 FUNCTION RA4_RA5_URL (p_week IN VARCHAR2,
88 p_organization IN VARCHAR2,
89 p_operating_unit IN VARCHAR2,
90 p_threshold IN NUMBER,
91 p_period_type IN VARCHAR2)
92
93 RETURN VARCHAR;
94
95 FUNCTION Drill_To_Proj_Perf_URL( PROJECT_ID IN NUMBER
96 ,p_Currency_Record_Type IN NUMBER
97 ,p_As_of_Date IN NUMBER
98 ,p_Period_Type IN VARCHAR2)
99 RETURN VARCHAR2;
100
101 PROCEDURE INIT;
102
103 PROCEDURE hide_parameter (
104 p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
105 hide OUT NOCOPY VARCHAR2);
106
107 FUNCTION PJI_ORGANIZATION_EXISTS(p_org_id IN NUMBER) RETURN NUMBER;
108
109 PROCEDURE get_top_org_details
110 (x_top_org_id OUT nocopy per_security_profiles.organization_id%TYPE,
111 x_top_org_name OUT nocopy hr_all_organization_units_tl.name%TYPE,
112 x_user_assmt_flag OUT nocopy VARCHAR2,
113 x_insert_top_org_flag OUT nocopy VARCHAR2 ); -- Added for bug#6623113
114
115 END PJI_PMV_UTIL;