[Home] [Help]
65: --
66: cursor csr_pdp_exists is
67: select 'y' from dual where exists
68: (select 'x'
69: from per_periods_of_placement pdp
70: where pdp.person_id = p_person_id
71: and pdp.date_start = p_old_start_date);
72: --
73: begin
134: --
135: cursor csr_pdp_exists is
136: select 'y' from dual where exists
137: (select 'x'
138: from per_periods_of_placement pdp
139: where pdp.person_id = p_person_id
140: and pdp.actual_termination_date < p_new_start_date
141: and pdp.final_process_date >= p_new_start_date);
142: --
172: -- Fix for 10124468
173: cursor csr_pdp_overlap is
174: select 'y' from dual where exists
175: (select 'x'
176: from per_periods_of_placement pdp
177: where pdp.person_id = p_person_id
178: and p_new_start_date between pdp.date_start
179: and NVL(pdp.actual_termination_date,hr_api.g_eot));
180: -- End of Fix for 10124468
351: ORDER BY date_start;
352: --
353: cursor pdp is
354: select date_start,actual_termination_date
355: from per_periods_of_placement
356: WHERE PERSON_ID = P_PERSON_ID
357: ORDER BY date_start;
358: --
359: begin
421: --
422: cursor assignment_pdp is
423: select a.payroll_id , a.supervisor_id
424: from per_assignments_f a,
425: per_periods_of_placement p
426: where a.period_of_placement_date_start = p.date_start
427: and a.person_id = p.person_id
428: and p.period_of_placement_id = p_pds_or_pdp_id
429: and p_type= 'C'
515: cursor csr_sp_placement_pdp is
516: select 'x' from dual where exists
517: (select 1
518: from per_spinal_point_placements_f sp,
519: per_periods_of_placement p,
520: per_assignments_f a
521: where a.person_id = p_person_id
522: and a.period_of_placement_date_start = p.date_start
523: and p.period_of_placement_id = p_pds_or_pdp_id
579: cursor csr_asg_rates_pdp is
580: select 'x' from dual where exists
581: (select 1
582: from pay_grade_rules_f pgr,
583: per_periods_of_placement p,
584: per_assignments_f a
585: where a.person_id = p_person_id
586: and a.period_of_placement_date_start = p.date_start
587: and p.period_of_placement_id = p_pds_or_pdp_id
661: cursor csr_cost_pdp is
662: select 'x' from dual where exists
663: (select 1
664: from PAY_COST_ALLOCATIONS_F ca,
665: per_periods_of_placement p,
666: per_assignments_f a
667: where a.person_id = p_person_id
668: and a.period_of_placement_date_start = p.date_start
669: and p.period_of_placement_id = p_pds_or_pdp_id
752: cursor csr_budget_pdp is
753: select 'x' from dual where exists
754: (select 1
755: from per_assignment_budget_values_f bud,
756: per_periods_of_placement p,
757: per_assignments_f a
758: where a.person_id = p_person_id
759: and a.period_of_placement_date_start = p.date_start
760: and p.period_of_placement_id = p_pds_or_pdp_id
1292: where person_id = p_person_id
1293: and date_start = p_old_start_date
1294: for update of date_start nowait;
1295: cursor pdp is select *
1296: from per_periods_of_placement pdp
1297: where person_id = p_person_id
1298: and date_start = p_old_start_date
1299: for update of date_start nowait;
1300: --
1339: hr_utility.raise_error;
1340: else
1341: close pdp;
1342: end if;
1343: update per_periods_of_placement
1344: set date_start = p_new_start_date
1345: where period_of_placement_id = pdp_rec.period_of_placement_id
1346: and date_start = p_old_start_date
1347: and person_id = p_person_id;
2443: --
2444: cursor csr_pdp
2445: is
2446: select period_of_placement_id
2447: from per_periods_of_placement
2448: where person_id = p_person_id
2449: and date_start = p_old_start_date;
2450:
2451: --added for bug#9266457
2482: --
2483: -- 115.30,115.33 (END)
2484: --
2485: l_proc varchar2(30):='update_start_date';
2486: l_pds_or_pdp_id per_periods_of_placement.period_of_placement_id%TYPE;
2487: l_old_start_date DATE;
2488: l_new_start_date DATE;
2489: l_earlier_date DATE;
2490: l_later_date DATE;