[Home] [Help]
PACKAGE: APPS.HR_FR_MMO
Source
1 Package hr_fr_mmo AUTHID CURRENT_USER as
2 /* $Header: hrfrmmo.pkh 120.0 2005/05/30 21:03:55 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- | Global Definitions - Internal Development Use Only |
6 -- ----------------------------------------------------------------------------
7 --
8 -- None.
9 --
10 --
11 -- ----------------------------------------------------------------------------
12 -- |------------------------< Get_formula >-----------------------------------|
13 -- ----------------------------------------------------------------------------
14 -- {Start Of Comments}
15 --
16 -- Description:
17 -- This function will return the formula_id of the formula to be used
18 -- to get the starting and leaving reason in the MMO report .. It will either
19 -- be the id for the USER_MMO_REASON or TEMPLATE_MMO_REASON formula
20 --
21 --
22 -- Prerequisites:
23 -- None.
24 --
25 -- In Parameters:
26 -- p_session_date
27 --
28 --
29 -- Post Success:
30 -- Processing continues.
31 --
32 -- Post Failure:
33 -- None.
34 --
35 -- Access Status:
36 -- Internal Row Handler Use Only.
37 --
38 -- {End Of Comments}
39 -- ----------------------------------------------------------------------------
40 Function Get_formula (p_business_group_id IN Number,
41 p_session_date IN date) Return Number;
42 --
43 pragma restrict_references(Get_formula,WNDS,WNPS);
44
45 -- ----------------------------------------------------------------------------
46 -- |------------------------< Get_start_date >--------------------------------|
47 -- ----------------------------------------------------------------------------
48 -- {Start Of Comments}
49 --
50 -- Description:
51 -- This function will return the start date of people found to have left
52 -- the establishment in the period.
53 --
54 -- Prerequisites:
55 -- None.
56 --
57 -- In Parameters:
58 -- person_id
59 -- establishment_id
60 -- end date
61 --
62 -- Post Success:
63 -- Processing continues.
64 --
65 -- Post Failure:
66 -- None.
67 --
68 -- Access Status:
69 -- Internal Row Handler Use Only.
70 --
71 -- {End Of Comments}
72 -- ----------------------------------------------------------------------------
73 Function Get_start_date
74 (p_person_id IN Number,
75 p_establishment_id IN Number,
76 p_end_date IN date,
77 p_include_suspended IN VARCHAR
78 ) RETURN Date;
79 pragma restrict_references(Get_start_date,WNDS,WNPS);
80
81 --
82 -- ----------------------------------------------------------------------------
83 -- |---------------------------< Get_end_date >-------------------------------|
84 -- ----------------------------------------------------------------------------
85 -- {Start Of Comments}
86 --
87 -- Description:
88 -- This function will return the end date of people found to have joined the
89 -- establishment in the period
90 --
91 -- Prerequisites:
92 --
93 --
94 -- In Parameter:
95 -- Person_id
96 -- establishment_id
97 -- Start_date
98 --
99 -- Post Success:
100 --
101 --
102 -- Post Failure:
103 --
104 --
105 -- Developer Implementation Notes:
106 --
107 --
108 --
109 -- Access Status:
110 -- Internal Development Use Only.
111 --
112 -- {End Of Comments}
113 -- ----------------------------------------------------------------------------
114 Function Get_end_date
115 (p_person_id IN Number,
116 p_establishment_id IN Number,
117 p_start_date IN Date,
118 p_include_suspended IN VARCHAR
119 ) RETURN Date;
120 pragma restrict_references(Get_end_date,WNDS,WNPS);
121 --
122 -- ----------------------------------------------------------------------------
123 -- |----------------------------< Get_reason >--------------------------------|
124 -- ----------------------------------------------------------------------------
125 -- {Start Of Comments}
126 --
127 -- Description:
128 -- This function will return the starting reason of a person
129 --
130 -- Prerequisites:
131 -- None.
132 --
133 -- In Parameters:
134 -- assignment_id
135 -- start date
136 -- seeded formula_id to be called
137 -- switch to identify which value for Starting "S" or Leaving "L" we want
138 --
139 -- Post Success:
140 -- Processing continues.
141 --
142 -- Post Failure:
143 -- None.
144 --
145 -- Access Status:
146 -- Internal Row Handler Use Only.
147 --
148 -- {End Of Comments}
149 -- ----------------------------------------------------------------------------
150 Function Get_reason
151 (p_assignment_id IN Number,
152 p_starting_date IN varchar2,
153 p_formula_id IN Number,
154 p_switch_starting_leaving IN varchar2
155 ) RETURN Varchar2;
156 /* pragma restrict_references(Get_starting_reason,WNDS,WNPS); */
157 --
158 -- ----------------------------------------------------------------------------
159 end hr_fr_mmo;