1 package ghr_validate_perwsdpo AUTHID CURRENT_USER AS
2 /* $Header: ghrwsdpo.pkh 120.3 2011/10/31 06:39:44 utokachi ship $ */
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 --Begin bug# 12706943
19 function chk_det_pos_exists (p_position_id in number) return boolean;
20
21 function chk_detail_next (p_position_id in number,
22 p_effective_date in date) return boolean;
23 --bug 13261734
24 FUNCTION chk_det_parei_exists (p_position_id in number) RETURN BOOLEAN;
25 --End bug# 12706943
26 pragma restrict_references (chk_par_exists, WNDS);
27
28 -- Bug 3501968: Added below, function chk_par_exists_f_per.
29 -- This functions returns if a given has atleast one PA request record.
30 function chk_par_exists_f_per (p_person_id in number) return boolean;
31
32 -- ---------------------------------------------------------------------------
33 -- ---------------------------< Function: return_upd_hr_vert_status >-------------
34 -- ---------------------------------------------------------------------------
35 function return_upd_hr_vert_status return boolean;
36
37 -- ---------------------------------------------------------------------------
38 -- ---------------------------< Function: chk_location_assigned >-------------
39 -- ---------------------------------------------------------------------------
40 function chk_location_assigned (p_location_id in number) return boolean;
41 pragma restrict_references (chk_location_assigned , WNDS);
42
43 -- ---------------------------------------------------------------------------
44 -- ---------------------------< Function: chk_postion_assigned >--------------
45 -- ---------------------------------------------------------------------------
46 function chk_position_assigned (p_position_id in number) return boolean;
47 pragma restrict_references (chk_position_assigned , WNDS);
48
49 -- ---------------------------------------------------------------------------
50 -- ---------------------------< Function: chk_postion_assigned_date >--------------
51 -- ---------------------------------------------------------------------------
52 function chk_position_assigned_date (p_position_id in number
53 ,p_date in date)
54 return boolean;
55 pragma restrict_references (chk_position_assigned , WNDS);
56
57 -- ---------------------------------------------------------------------------
58 -- ---------------------------< Function: chk_position_assigned_other >--------------
59 -- ---------------------------------------------------------------------------
60 function chk_position_assigned_other (p_position_id in number
61 ,p_assignment_id in number
62 ,p_date in date)
63 return boolean;
64 pragma restrict_references (chk_position_assigned , WNDS);
65
66 -- ---------------------------------------------------------------------------
67 -- ---------------------------< Function: chk_position_assigned_cwk >--------------
68 -- ---------------------------------------------------------------------------
69 function chk_position_assigned_cwk (p_position_id in number
70 ,p_date in date)
71 return boolean;
72 pragma restrict_references (chk_position_assigned , WNDS);
73
74
75
76 -- This function checks if there are any future PA Request actions for a given position
77 -- that have been completed.
78 FUNCTION check_pend_future_pars (p_position_id IN NUMBER
79 ,p_effective_date IN DATE)
80 RETURN VARCHAR2;
81
82 -- Bug#2458573
83 -- This function checks if the element is created through RPA or through element entry screen
84 -- If the element is created through RPA, function returns TRUE; Otherwise it returns FALSE.
85 FUNCTION is_rpa_element(p_element_entry_id IN NUMBER)
86 RETURN BOOLEAN;
87
88 -- --------------------------------------------------------------------------
89 -- ---------------------------< Function: chk_future_assigned >--------------
90 -- --------------------------------------------------------------------------
91 function chk_future_assigned (p_position_id in number
92 ,p_date in date)
93 return boolean;
94
95 -- --------------------------------------------------------------------------
96 -- ---------------------------< Function: chk_rpa_sourced_next>--------------
97 -- --------------------------------------------------------------------------
98 Function chk_rpa_sourced_next(p_position_id in number
99 ,p_effective_end_date in date)
100
101 return boolean;
102
103 -- --------------------------------------------------------------------------
104 -- ---------------------------< Function: chk_rpa_sourced_all>--------------
105 -- --------------------------------------------------------------------------
106 Function chk_rpa_sourced_all(p_position_id in number
107 ,p_effective_end_date in date)
108
109 return boolean;
110
111 -- --------------------------------------------------------------------------
112 -- ------------------------ < Function: get_position_eff_date>---------------
113 -- --------------------------------------------------------------------------
114 Function get_position_eff_date(p_position_id in number)
115 return date;
116
117 end ghr_validate_perwsdpo;
118