[Home] [Help]
141: --
142: cursor entry_record_exists(p_update_ee_id in number,
143: p_effective_end_date in date) is
144: select effective_end_date
145: from pay_element_entries_f
146: where element_entry_id = p_update_ee_id
147: and effective_start_date = p_effective_date
148: and effective_end_date = p_effective_end_date;
149: --
209: link_id,
210: lookup_type,
211: uom,
212: input_curr
213: from pay_element_entries_f pee,
214: pay_element_links_f pel,
215: pay_element_types_f pet,
216: pay_input_values_f piv,
217: per_all_assignments_f asg
314:
315: /* bug 6655722
316: select max(pee.effective_end_date)
317: into max_effend
318: from pay_element_entries_f pee
319: where pee.element_entry_id = update_ee_id;
320: */
321: --
322: begin
335: -- end date.
336:
337: SELECT effective_end_date
338: INTO l_effective_end_date
339: FROM pay_element_entries_f
340: WHERE element_entry_id = update_ee_id
341: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
342: --
343: /*
340: WHERE element_entry_id = update_ee_id
341: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
342: --
343: /*
344: delete from pay_element_entries_f pee
345: where pee.element_entry_id = update_ee_id
346: and pee.effective_start_date > val_date;
347: */
348: --
402: --
403: close get_entry_values;
404:
405: -- Bug 7194700
406: -- Check if a record exists in PAY_ELEMENT_ENTRIES_F with the same effective_start_date
407: -- and effective_end_date. Proceed with the Update and Insert DMLs only if no such
408: -- record is there.
409:
410: OPEN entry_record_exists(update_ee_id,l_effective_end_date);
414: --
415: -- Now, update the effective_end_date of existing entry.
416: -- Note : using val_date.
417: hr_utility.set_location(c_indent,40);
418: update pay_element_entries_f pee
419: set pee.effective_end_date = (p_effective_date - 1)
420: where pee.element_entry_id = update_ee_id
421: and val_date between
422: pee.effective_start_date and pee.effective_end_date;
428: -- Bugfix 3110853
429: -- Derive the OVN before inserting
430: --
431: ovn := dt_api.get_object_version_number (
432: 'PAY_ELEMENT_ENTRIES_F',
433: 'ELEMENT_ENTRY_ID',
434: update_ee_id
435: );
436: --
433: 'ELEMENT_ENTRY_ID',
434: update_ee_id
435: );
436: --
437: insert into pay_element_entries_f (
438: element_entry_id,
439: effective_start_date,
440: effective_end_date,
441: cost_allocation_keyflex_id,
588: 0,
589: 0,
590: pee.created_by,
591: pee.creation_date
592: from pay_element_entries_f pee
593: where pee.element_entry_id = update_ee_id
594: and (p_effective_date - 1) between
595: pee.effective_start_date and pee.effective_end_date;
596: --
762: select pee.element_entry_id,
763: pel.element_link_id,
764: pee.effective_start_date
765: into stop_ee_id, link_id, stop_ee_start_date
766: from pay_element_entries_f pee,
767: pay_element_links_f pel,
768: per_all_assignments_f asg
769: where asg.assignment_id = p_assignment_id
770: and p_date_earned between
800: into v_error_flag
801: from sys.dual
802: where exists (
803: select null
804: from pay_element_entries_f pee
805: where pee.assignment_id = p_assignment_id
806: and pee.element_link_id = link_id
807: and pee.target_entry_id = stop_ee_id
808: and pee.effective_start_date <= c_eot
832: -- Set the Continuous Calc override flag, so that the trigger points
833: -- are not fired.
834: pay_continuous_calc.g_override_cc := TRUE;
835: --
836: delete from pay_element_entries_f pee
837: where pee.element_entry_id = stop_ee_id
838: and pee.effective_start_date > p_date_earned;
839: --
840: update pay_element_entries_f pee
836: delete from pay_element_entries_f pee
837: where pee.element_entry_id = stop_ee_id
838: and pee.effective_start_date > p_date_earned;
839: --
840: update pay_element_entries_f pee
841: set pee.effective_end_date = p_date_earned,
842: pee.prev_upd_action_id = DECODE(pee.updating_action_type, 'U', pee.updating_action_id),
843: pee.updating_action_id = p_assignment_action_id,
844: pee.updating_action_type = 'S'
3024: and pay_pac.effective_date between
3025: pay_asg.effective_start_date and pay_asg.effective_end_date
3026: and pay_pos.period_of_service_id = pay_asg.period_of_service_id
3027: and exists (select null from
3028: pay_element_entries_f p_pee,
3029: pay_element_entry_values_f p_pev,
3030: pay_element_entry_values_f p_pev2,
3031: pay_input_values_f p_piv,
3032: pay_input_values_f p_piv2
3055: where p_pbg.business_group_id = pay_pac.business_group_id
3056: and p_pbg.legislation_code = p_plr.legislation_code
3057: and TRANSLATE(upper(p_plr.rule_type), ''-'',''_'') = ''PAI_END_DATE'')
3058: and not exists (select null
3059: from pay_element_entries_f p_pe2
3060: where p_pe2.assignment_id = pay_asg.assignment_id
3061: and p_pe2.element_type_id =
3062: (select to_number(p_plr2.rule_mode)
3063: from pay_legislation_rules p_plr2, per_business_groups_perf p_pbg2
3083: pay_asg.effective_start_date and pay_asg.effective_end_date
3084: and pay_pos.period_of_service_id = pay_asg.period_of_service_id
3085: and exists
3086: (select null
3087: from pay_element_entries_f pay_pee,
3088: pay_element_types_f pay_pet,
3089: pay_element_entry_values_f pay_pev,
3090: pay_element_entry_values_f pay_pev2,
3091: pay_input_values_f pay_piv,
3133: and pay_inc.include_or_exclude = ''I''
3134: and pay_pos.period_of_service_id = pay_asg.period_of_service_id
3135: and exists
3136: (select null
3137: from pay_element_entries_f pay_pee,
3138: pay_element_types_f pay_pet,
3139: pay_element_entry_values_f pay_pev,
3140: pay_element_entry_values_f pay_pev2,
3141: pay_input_values_f pay_piv,