DBA Data[Home] [Help]

APPS.HR_JPDRB dependencies on HR_JPRTS

Line 204: if l_dimension_name = hr_jprts.g_asg_run then

200: end if;
201: --
202: l_dimension_jp_type := RTRIM( SUBSTRB(l_dimension_name,31,15),' ');
203: --
204: if l_dimension_name = hr_jprts.g_asg_run then
205: /* --run balance, so call period expiry */
206: if p_effective_date > expired_period_date(p_assignment_action_id) then
207: l_expired := TRUE;
208: end if;

Line 209: elsif l_dimension_name = hr_jprts.g_asg_proc_ptd then

205: /* --run balance, so call period expiry */
206: if p_effective_date > expired_period_date(p_assignment_action_id) then
207: l_expired := TRUE;
208: end if;
209: elsif l_dimension_name = hr_jprts.g_asg_proc_ptd then
210: /* --period balance, so call period expiry */
211: if p_effective_date > expired_period_date(p_assignment_action_id) then
212: l_expired := TRUE;
213: end if;

Line 215: elsif l_dimension_name = hr_jprts.g_asg_fytd_jp THEN

211: if p_effective_date > expired_period_date(p_assignment_action_id) then
212: l_expired := TRUE;
213: end if;
214: --
215: elsif l_dimension_name = hr_jprts.g_asg_fytd_jp THEN
216: /* -- Do not add the function add_months for l_return_date.
217: -- Because add_months(1999/02/28,12) => 2000/02/29(actual next term date is 2000/02/28)
218: --
219: -- Ignore p_action_effective_date because it is not unique to get date_earned

Line 221: l_return_date := hr_jprts.dimension_reset_date_userdef(

217: -- Because add_months(1999/02/28,12) => 2000/02/29(actual next term date is 2000/02/28)
218: --
219: -- Ignore p_action_effective_date because it is not unique to get date_earned
220: -- while using effective_date (not action id). Always use action id at that time. */
221: l_return_date := hr_jprts.dimension_reset_date_userdef(
222: l_dimension_name,
223: add_months(l_date_earned,12),
224: 'FLEX',
225: null,

Line 228: --l_return_date := hr_jprts.dimension_reset_date_userdef(

224: 'FLEX',
225: null,
226: l_business_group_id);
227: /* -- it's wrong because return date must be next term date.
228: --l_return_date := hr_jprts.dimension_reset_date_userdef(
229: -- l_dimension_name,
230: -- l_date_earned,
231: -- 'FLEX',
232: -- null,

Line 242: elsif l_dimension_name = hr_jprts.g_retro then

238: l_expired := TRUE;
239: end if;
240: --
241: /* -- Actually, this function is not used so that hr_routes.retro_jp does not exist. */
242: elsif l_dimension_name = hr_jprts.g_retro then
243: if p_effective_date > expired_period_date(p_assignment_action_id) then
244: l_expired := TRUE;
245: end if;
246: elsif l_dimension_name = hr_jprts.g_payment then

Line 246: elsif l_dimension_name = hr_jprts.g_payment then

242: elsif l_dimension_name = hr_jprts.g_retro then
243: if p_effective_date > expired_period_date(p_assignment_action_id) then
244: l_expired := TRUE;
245: end if;
246: elsif l_dimension_name = hr_jprts.g_payment then
247: if p_effective_date > expired_period_date(p_assignment_action_id) then
248: l_expired := TRUE;
249: end if;
250: /* -- the following treatment does not include ITD. */

Line 253: l_return_date := hr_jprts.dimension_reset_last_date(

249: end if;
250: /* -- the following treatment does not include ITD. */
251: else
252: IF l_dimension_jp_type = 'EFFECTIVE_DATE' then
253: l_return_date := hr_jprts.dimension_reset_last_date(
254: l_dimension_name,
255: nvl(p_action_effective_date,(get_action_date(p_assignment_action_id)))) + 1;
256: --
257: if p_effective_date >= l_return_date

Line 262: l_return_date := hr_jprts.dimension_reset_last_date(l_dimension_name,l_date_earned) + 1;

258: or l_return_date is null then
259: l_expired := TRUE;
260: end if;
261: ELSIF l_dimension_jp_type = 'DATE_EARNED' then
262: l_return_date := hr_jprts.dimension_reset_last_date(l_dimension_name,l_date_earned) + 1;
263: --
264: -- if calling function is Date Mode, p_effective_date is session_date. */
265: if p_effective_date >= l_return_date
266: or l_return_date is null then