eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_DATE_CHK dependencies on HR_DATE_CHK

Line 1: package body hr_date_chk as

1: package body hr_date_chk as
2: /* $Header: pehchchk.pkb 120.1 2006/01/13 13:52:37 irgonzal noship $ */
3: /*
4: ******************************************************************
5: * *

Line 23: Name : hr_date_chk (BODY)

19: * England. *
20: * *
21: ****************************************************************** */
22: /*
23: Name : hr_date_chk (BODY)
24:
25: Description : This package declares procedures required to test when
26: the period of service and application start dates changes
27: are valid. If they are valid then database items which

Line 164: hr_utility.set_location('hr_date_chk.lock_row',1);

160: from per_people_f pa
161: where pa.person_id = p_person_id
162: for update of person_id;
163: begin
164: hr_utility.set_location('hr_date_chk.lock_row',1);
165: open add;
166: loop
167: fetch add into l_dummy;
168: exit when add%NOTFOUND;

Line 172: hr_utility.set_location('hr_date_chk.lock_row',2);

168: exit when add%NOTFOUND;
169: end loop;
170: close add;
171: --
172: hr_utility.set_location('hr_date_chk.lock_row',2);
173: if (p_person_type = 'E') then
174: begin
175: open pay;
176: loop

Line 200: hr_utility.set_location('hr_date_chk.lock_row',3);

196: close cost;
197: end;
198: end if;
199: --
200: hr_utility.set_location('hr_date_chk.lock_row',3);
201: open ass;
202: loop
203: fetch ass into l_dummy;
204: exit when ass%NOTFOUND;

Line 214: hr_utility.set_location('hr_date_chk.lock_row',4);

210: hr_utility.raise_error;
211: end if;
212: close ass;
213: --
214: hr_utility.set_location('hr_date_chk.lock_row',4);
215: open app;
216: loop
217: fetch app into l_dummy;
218: exit when app%NOTFOUND;

Line 222: hr_utility.set_location('hr_date_chk.lock_row',5);

218: exit when app%NOTFOUND;
219: end loop;
220: close app;
221: --
222: hr_utility.set_location('hr_date_chk.lock_row',5);
223: open per;
224: loop
225: fetch per into l_dummy;
226: exit when per%NOTFOUND;

Line 375: hr_utility.set_location('hr_date_chk.check_for_entries',1);

371: ,p_period_of_service_id NUMBER
372: ,p_start_date DATE) is
373: v_dummy number;
374: begin
375: hr_utility.set_location('hr_date_chk.check_for_entries',1);
376: select 1
377: into v_dummy
378: from sys.dual
379: where exists (select null

Line 404: hr_utility.set_location('hr_date_chk.check_sp_placement',1);

400: ,p_start_date DATE) is
401: v_dummy number;
402: --
403: begin
404: hr_utility.set_location('hr_date_chk.check_sp_placement',1);
405: select 1
406: into v_dummy
407: from sys.dual
408: where exists (select 1

Line 436: hr_utility.set_location('hr_date_chk.check_sp_placement',1);

432: ,p_start_date DATE) is
433: v_dummy number;
434: --
435: begin
436: hr_utility.set_location('hr_date_chk.check_sp_placement',1);
437: select 1
438: into v_dummy
439: from sys.dual
440: where exists (select 1

Line 469: hr_utility.set_location('hr_date_chk.check_people_changes',1);

465: ,p_start_date DATE) is
466: v_dummy number;
467: --
468: begin
469: hr_utility.set_location('hr_date_chk.check_people_changes',1);
470: select 1
471: into v_dummy
472: from sys.dual
473: where exists (select 1

Line 499: hr_utility.set_location('hr_date_chk.check_for_ass_st_chg',1);

495: ,p_start_date DATE) is
496: v_dummy number;
497: --
498: begin
499: hr_utility.set_location('hr_date_chk.check_for_ass_st_chg',1);
500: select 1
501: into v_dummy
502: from sys.dual
503: where exists (select 1

Line 536: hr_utility.set_location('hr_date_chk.check_for_ass_chg',1);

532: ,p_start_date DATE) is
533: v_dummy number;
534: --
535: begin
536: hr_utility.set_location('hr_date_chk.check_for_ass_chg',1);
537: select 1
538: into v_dummy
539: from sys.dual
540: where exists (select 1

Line 565: hr_utility.set_location('hr_date_chk.check_for_prev_emp_ass',1);

561: ,p_start_date DATE) is
562: v_dummy number;
563: --
564: begin
565: hr_utility.set_location('hr_date_chk.check_for_prev_emp_ass',1);
566: select 1
567: into v_dummy
568: from sys.dual
569: where exists (select 1

Line 601: hr_utility.set_location('hr_date_chk.check_hire_ref_int',1);

597: begin
598: l_assignment_type:='E';
599: l_later_date:=p_start_date;
600: l_earlier_date:=p_s_start_date;
601: hr_utility.set_location('hr_date_chk.check_hire_ref_int',1);
602: --
603: if p_start_date > p_s_start_date then
604: -- VT 11/27/96 #401587
605: hr_date_chk.check_for_compl_actions(p_person_id

Line 605: hr_date_chk.check_for_compl_actions(p_person_id

601: hr_utility.set_location('hr_date_chk.check_hire_ref_int',1);
602: --
603: if p_start_date > p_s_start_date then
604: -- VT 11/27/96 #401587
605: hr_date_chk.check_for_compl_actions(p_person_id
606: ,p_s_start_date
607: ,p_start_date);
608: --
609: -- VT 11/27/96 #399253

Line 610: hr_date_chk.check_for_contig_pos(p_person_id

606: ,p_s_start_date
607: ,p_start_date);
608: --
609: -- VT 11/27/96 #399253
610: hr_date_chk.check_for_contig_pos(p_person_id
611: ,p_s_start_date
612: ,p_start_date);
613: --
614: hr_date_chk.check_supe_pay(p_period_of_service_id

Line 614: hr_date_chk.check_supe_pay(p_period_of_service_id

610: hr_date_chk.check_for_contig_pos(p_person_id
611: ,p_s_start_date
612: ,p_start_date);
613: --
614: hr_date_chk.check_supe_pay(p_period_of_service_id
615: ,p_start_date);
616: --
617: /* hr_date_chk.check_for_entries(p_person_id
618: ,p_period_of_service_id

Line 617: /* hr_date_chk.check_for_entries(p_person_id

613: --
614: hr_date_chk.check_supe_pay(p_period_of_service_id
615: ,p_start_date);
616: --
617: /* hr_date_chk.check_for_entries(p_person_id
618: ,p_period_of_service_id
619: ,p_start_date); */
620: --
621: hr_date_chk.check_for_sp_placements(p_person_id

Line 621: hr_date_chk.check_for_sp_placements(p_person_id

617: /* hr_date_chk.check_for_entries(p_person_id
618: ,p_period_of_service_id
619: ,p_start_date); */
620: --
621: hr_date_chk.check_for_sp_placements(p_person_id
622: ,p_period_of_service_id
623: ,p_start_date);
624: --
625: hr_date_chk.check_for_cost_alloc(p_person_id

Line 625: hr_date_chk.check_for_cost_alloc(p_person_id

621: hr_date_chk.check_for_sp_placements(p_person_id
622: ,p_period_of_service_id
623: ,p_start_date);
624: --
625: hr_date_chk.check_for_cost_alloc(p_person_id
626: ,p_period_of_service_id
627: ,p_start_date);
628: --
629: hr_date_chk.check_for_ass_st_chg(p_person_id

Line 629: hr_date_chk.check_for_ass_st_chg(p_person_id

625: hr_date_chk.check_for_cost_alloc(p_person_id
626: ,p_period_of_service_id
627: ,p_start_date);
628: --
629: hr_date_chk.check_for_ass_st_chg(p_person_id
630: ,l_earlier_date
631: ,l_later_date
632: ,l_assignment_type
633: ,p_s_start_date);

Line 635: hr_date_chk.check_people_changes(p_person_id

631: ,l_later_date
632: ,l_assignment_type
633: ,p_s_start_date);
634: --
635: hr_date_chk.check_people_changes(p_person_id
636: ,l_earlier_date
637: ,l_later_date
638: ,p_s_start_date);
639: --

Line 640: hr_date_chk.check_for_ass_chg(p_person_id

636: ,l_earlier_date
637: ,l_later_date
638: ,p_s_start_date);
639: --
640: hr_date_chk.check_for_ass_chg(p_person_id
641: ,l_earlier_date
642: ,l_later_date
643: ,l_assignment_type
644: ,p_s_start_date

Line 649: hr_date_chk.check_for_contig_pos(p_person_id

645: ,p_start_date);
646: --
647: else
648: -- VT 01/27/97 #399253
649: hr_date_chk.check_for_contig_pos(p_person_id
650: ,p_s_start_date
651: ,p_start_date);
652: --
653: l_later_date:=p_s_start_date;

Line 657: hr_date_chk.check_supe_pay(p_period_of_service_id

653: l_later_date:=p_s_start_date;
654: l_earlier_date:=p_start_date;
655:
656: --
657: hr_date_chk.check_supe_pay(p_period_of_service_id
658: ,p_start_date);
659: --
660: hr_date_chk.check_people_changes(p_person_id
661: ,l_earlier_date

Line 660: hr_date_chk.check_people_changes(p_person_id

656: --
657: hr_date_chk.check_supe_pay(p_period_of_service_id
658: ,p_start_date);
659: --
660: hr_date_chk.check_people_changes(p_person_id
661: ,l_earlier_date
662: ,l_later_date
663: ,p_s_start_date);
664: --

Line 665: hr_date_chk.check_for_ass_chg(p_person_id

661: ,l_earlier_date
662: ,l_later_date
663: ,p_s_start_date);
664: --
665: hr_date_chk.check_for_ass_chg(p_person_id
666: ,l_earlier_date
667: ,l_later_date
668: ,l_assignment_type
669: ,p_s_start_date

Line 672: hr_date_chk.check_for_prev_emp_ass(p_person_id

668: ,l_assignment_type
669: ,p_s_start_date
670: ,p_start_date);
671: --
672: hr_date_chk.check_for_prev_emp_ass(p_person_id
673: ,l_assignment_type
674: ,p_s_start_date
675: ,p_start_date);
676: end if;

Line 677: hr_date_chk.lock_row(p_person_id =>p_person_id

673: ,l_assignment_type
674: ,p_s_start_date
675: ,p_start_date);
676: end if;
677: hr_date_chk.lock_row(p_person_id =>p_person_id
678: ,p_person_type =>l_assignment_type);
679: exception
680: when others then
681: raise;

Line 770: hr_utility.set_location('hr_date_chk.update_hire_records',1);

766: and abv.effective_start_date = p_s_start_date;
767: --
768:
769: begin
770: hr_utility.set_location('hr_date_chk.update_hire_records',1);
771: -- Update the addresses that start at the old hire date
772: -- Providing that the addresses end date is either equal to
773: -- the new start date or greater than it.
774: update per_addresses a

Line 781: hr_utility.set_location('hr_date_chk.update_hire_records',2);

777: and nvl(a.date_to,p_start_date) >= p_start_date
778: and a.person_id = p_person_id;
779: --
780: --
781: hr_utility.set_location('hr_date_chk.update_hire_records',2);
782: update pay_personal_payment_methods_f p
783: set p.effective_start_date = p_start_date
784: where p.effective_start_date = p_s_start_date
785: and p.effective_end_date >= p_start_date

Line 809: hr_utility.set_location('hr_date_chk.update_hire_records',3);

805: end loop;
806: close ssp;
807: end;
808: --
809: hr_utility.set_location('hr_date_chk.update_hire_records',3);
810: begin
811: open cost;
812: loop
813: fetch cost into l_ca_id;

Line 837: hr_utility.set_location('hr_date_chk.update_hire_records',5);

833: -- This is a wider issue and this code will be left like this until all changes are made.
834: -- SASMITH 8-MAY-1998
835: --
836:
837: hr_utility.set_location('hr_date_chk.update_hire_records',5);
838: begin
839: open abv;
840: loop
841: fetch abv into l_abv_id;

Line 858: hr_utility.set_location('hr_date_chk.update_hire_records',10);

854: close abv;
855: end;
856:
857: --
858: hr_utility.set_location('hr_date_chk.update_hire_records',10);
859: --
860: -- BUG 308000 removed select min (effective_date) code
861: -- and it's reference in following code tm 19-sep-1995.
862: --

Line 879: hr_utility.set_location('hr_date_chk.update_hire_records',12);

875: hr_utility.raise_error;
876: end if;
877: --
878: --
879: hr_utility.set_location('hr_date_chk.update_hire_records',12);
880: -- keep contracts in synch with PER and ASG :
881: hr_contract_api.maintain_contracts
882: (p_person_id
883: ,p_start_date

Line 887: hr_utility.set_location('hr_date_chk.update_hire_records',15);

883: ,p_start_date
884: ,p_s_start_date);
885: --
886: --
887: hr_utility.set_location('hr_date_chk.update_hire_records',15);
888: --
889: -- update the tax records and pull back their effective start date if
890: -- the defaulting tax criteria is met.
891:

Line 920: hr_utility.set_location('hr_date_chk.update_hire_records',20);

916: -- end if; --end if payroll_installed
917:
918:
919: if p_app_number is not null then
920: hr_utility.set_location('hr_date_chk.update_hire_records',20);
921: begin
922: open app_ass;
923: loop
924: fetch app_ass into l_assignment_id;

Line 965: hr_utility.set_location('hr_date_chk.update_hire_records',25);

961: and peo.effective_start_date = p_s_start_date
962: and peo.current_applicant_flag = 'Y');
963: /* End fix for Bug 673066 */
964: --
965: hr_utility.set_location('hr_date_chk.update_hire_records',25);
966:
967: if sql%rowcount <1 then
968: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
969: hr_utility.set_message_token('TABLE','PER_APPLICATIONS');

Line 977: hr_utility.set_location('hr_date_chk.update_hire_records',30);

973: close app;
974: end;
975: end if;
976: --
977: hr_utility.set_location('hr_date_chk.update_hire_records',30);
978: update per_people_f p
979: set p.start_date =decode(p.start_date,p_s_start_date, p_start_date,
980: p.start_date),
981: p.effective_start_date =decode(p.effective_start_date,

Line 1012: hr_utility.set_location('hr_date_chk.check_apl_ref_int',1);

1008: begin
1009: l_assignment_type:='A';
1010: l_later_date:=p_start_date;
1011: l_earlier_date:=p_s_start_date;
1012: hr_utility.set_location('hr_date_chk.check_apl_ref_int',1);
1013: --
1014: if p_start_date > p_s_start_date then
1015: --
1016: hr_date_chk.check_for_ass_st_chg(p_person_id

Line 1016: hr_date_chk.check_for_ass_st_chg(p_person_id

1012: hr_utility.set_location('hr_date_chk.check_apl_ref_int',1);
1013: --
1014: if p_start_date > p_s_start_date then
1015: --
1016: hr_date_chk.check_for_ass_st_chg(p_person_id
1017: ,l_earlier_date
1018: ,l_later_date
1019: ,l_assignment_type
1020: ,p_s_start_date);

Line 1022: hr_date_chk.check_people_changes(p_person_id

1018: ,l_later_date
1019: ,l_assignment_type
1020: ,p_s_start_date);
1021: --
1022: hr_date_chk.check_people_changes(p_person_id
1023: ,l_earlier_date
1024: ,l_later_date
1025: ,p_s_start_date);
1026: --

Line 1027: hr_date_chk.check_for_ass_chg(p_person_id

1023: ,l_earlier_date
1024: ,l_later_date
1025: ,p_s_start_date);
1026: --
1027: hr_date_chk.check_for_ass_chg(p_person_id
1028: ,l_earlier_date
1029: ,l_later_date
1030: ,l_assignment_type
1031: ,p_s_start_date

Line 1039: hr_date_chk.check_people_changes(p_person_id

1035: --
1036: l_later_date:=p_s_start_date;
1037: l_earlier_date:=p_start_date;
1038: --
1039: hr_date_chk.check_people_changes(p_person_id
1040: ,l_earlier_date
1041: ,l_later_date
1042: ,p_s_start_date);
1043: --

Line 1044: hr_date_chk.check_for_ass_chg(p_person_id

1040: ,l_earlier_date
1041: ,l_later_date
1042: ,p_s_start_date);
1043: --
1044: hr_date_chk.check_for_ass_chg(p_person_id
1045: ,l_earlier_date
1046: ,l_later_date
1047: ,l_assignment_type
1048: ,p_s_start_date

Line 1052: hr_date_chk.lock_row(p_person_id =>p_person_id

1048: ,p_s_start_date
1049: ,p_start_date);
1050: --
1051: end if;
1052: hr_date_chk.lock_row(p_person_id =>p_person_id
1053: ,p_person_type =>l_assignment_type);
1054: exception
1055: when others then raise;
1056: end;

Line 1069: hr_utility.set_location('hr_date_chk.update_appl_records',1);

1065: -- Update the addresses that start at the old hire date
1066: -- Providing that the addresses end date is either equal to
1067: -- the new start date or greater than it.
1068: --
1069: hr_utility.set_location('hr_date_chk.update_appl_records',1);
1070: update per_addresses a
1071: set a.date_from = p_start_date
1072: where a.date_from = p_s_start_date
1073: and nvl(a.date_to,p_start_date) >= p_start_date

Line 1077: hr_utility.set_location('hr_date_chk.update_appl_records',2);

1073: and nvl(a.date_to,p_start_date) >= p_start_date
1074: and a.person_id = p_person_id;
1075: --
1076: --
1077: hr_utility.set_location('hr_date_chk.update_appl_records',2);
1078: update per_assignments_f a
1079: set a.effective_start_date = p_start_date,
1080: a.last_update_date = sysdate,
1081: a.last_updated_by = p_user_id,

Line 1100: hr_utility.set_location('hr_date_chk.update_appl_records',3);

1096: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1097: hr_utility.set_message_token('TABLE','PER_ALL_ASSIGNMENTS_F');
1098: hr_utility.raise_error;
1099: end if;
1100: hr_utility.set_location('hr_date_chk.update_appl_records',3);
1101: --
1102: update per_people_f p
1103: set p.start_date =decode(p.start_date,p_s_start_date, p_start_date,
1104: p.start_date),

Line 1127: end hr_date_chk;

1123: ,p_start_date
1124: ,p_s_start_date);
1125: --
1126: end;
1127: end hr_date_chk;
1128: