1 package ghr_validate_perwsdpo AS
2 /* $Header: ghrwsdpo.pkh 120.1 2006/08/30 11:53:30 arbasu noship $ */
3
4 g_bypass_vert boolean :=false; -- Global Vertical Status
5 g_package constant varchar2(33) := ' ghr_validate_perwsdpo.';
6
7 procedure update_posn_status (p_position_id in number,
8 p_effective_date in date );
9
10 procedure validate_perwsdpo (p_position_id in number,
11 p_effective_date in date);
12
13 function chk_position_obligated (p_position_id in number
14 ,p_date in date)
15 return boolean;
16
17 function chk_par_exists (p_position_id in number) return boolean;
18 pragma restrict_references (chk_par_exists, WNDS);
19
20 -- Bug 3501968: Added below, function chk_par_exists_f_per.
21 -- This functions returns if a given has atleast one PA request record.
22 function chk_par_exists_f_per (p_person_id in number) return boolean;
23
24 -- ---------------------------------------------------------------------------
25 -- ---------------------------< Function: return_upd_hr_vert_status >-------------
26 -- ---------------------------------------------------------------------------
27 function return_upd_hr_vert_status return boolean;
28
29 -- ---------------------------------------------------------------------------
30 -- ---------------------------< Function: chk_location_assigned >-------------
31 -- ---------------------------------------------------------------------------
32 function chk_location_assigned (p_location_id in number) return boolean;
33 pragma restrict_references (chk_location_assigned , WNDS);
34
35 -- ---------------------------------------------------------------------------
36 -- ---------------------------< Function: chk_postion_assigned >--------------
37 -- ---------------------------------------------------------------------------
38 function chk_position_assigned (p_position_id in number) return boolean;
39 pragma restrict_references (chk_position_assigned , WNDS);
40
41 -- ---------------------------------------------------------------------------
42 -- ---------------------------< Function: chk_postion_assigned_date >--------------
43 -- ---------------------------------------------------------------------------
44 function chk_position_assigned_date (p_position_id in number
45 ,p_date in date)
46 return boolean;
47 pragma restrict_references (chk_position_assigned , WNDS);
48
49 -- ---------------------------------------------------------------------------
50 -- ---------------------------< Function: chk_position_assigned_other >--------------
51 -- ---------------------------------------------------------------------------
52 function chk_position_assigned_other (p_position_id in number
53 ,p_assignment_id in number
54 ,p_date in date)
55 return boolean;
56 pragma restrict_references (chk_position_assigned , WNDS);
57
58 -- ---------------------------------------------------------------------------
59 -- ---------------------------< Function: chk_position_assigned_cwk >--------------
60 -- ---------------------------------------------------------------------------
61 function chk_position_assigned_cwk (p_position_id in number
62 ,p_date in date)
63 return boolean;
64 pragma restrict_references (chk_position_assigned , WNDS);
65
66
67
68 -- This function checks if there are any future PA Request actions for a given position
69 -- that have been completed.
70 FUNCTION check_pend_future_pars (p_position_id IN NUMBER
71 ,p_effective_date IN DATE)
72 RETURN VARCHAR2;
73
74 -- Bug#2458573
75 -- This function checks if the element is created through RPA or through element entry screen
76 -- If the element is created through RPA, function returns TRUE; Otherwise it returns FALSE.
77 FUNCTION is_rpa_element(p_element_entry_id IN NUMBER)
78 RETURN BOOLEAN;
79
80 -- --------------------------------------------------------------------------
81 -- ---------------------------< Function: chk_future_assigned >--------------
82 -- --------------------------------------------------------------------------
83 function chk_future_assigned (p_position_id in number
84 ,p_date in date)
85 return boolean;
86
87 -- --------------------------------------------------------------------------
88 -- ---------------------------< Function: chk_rpa_sourced_next>--------------
89 -- --------------------------------------------------------------------------
90 Function chk_rpa_sourced_next(p_position_id in number
91 ,p_effective_end_date in date)
92
93 return boolean;
94
95 -- --------------------------------------------------------------------------
96 -- ---------------------------< Function: chk_rpa_sourced_all>--------------
97 -- --------------------------------------------------------------------------
98 Function chk_rpa_sourced_all(p_position_id in number
99 ,p_effective_end_date in date)
100
101 return boolean;
102
103 -- --------------------------------------------------------------------------
104 -- ------------------------ < Function: get_position_eff_date>---------------
105 -- --------------------------------------------------------------------------
106 Function get_position_eff_date(p_position_id in number)
107 return date;
108
109 end ghr_validate_perwsdpo;
110