APPS.PER_PERIODS_OF_SERVICE_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 1: PACKAGE BODY PER_PERIODS_OF_SERVICE_PKG AS

1: PACKAGE BODY PER_PERIODS_OF_SERVICE_PKG AS
2: /* $Header: pepds01t.pkb 120.1 2005/11/03 06:25:01 bshukla noship $ */
3: ----------------------------------------------------------------------------
4:
5: ----------------------------------------------------------------------------

Line 63: from PER_PERIODS_OF_SERVICE

59: select trunc(months_between(least(nvl(ACTUAL_TERMINATION_DATE + 1, p_session_date + 1),
60: p_session_date+ 1), DATE_START) / 12, 0) tp_years,
61: trunc(mod(months_between(least(nvl(ACTUAL_TERMINATION_DATE + 1, p_session_date + 1),
62: p_session_date + 1), DATE_START), 12) ,0) tp_months
63: from PER_PERIODS_OF_SERVICE
64: where DATE_START <= p_session_date
65: and PERIOD_OF_SERVICE_ID = p_period_of_service_id;
66: --
67: cursor C_TY1 is

Line 72: from PER_PERIODS_OF_SERVICE

68: select trunc(sum(months_between(least(nvl(ACTUAL_TERMINATION_DATE + 1, p_session_date + 1),
69: p_session_date + 1), DATE_START)) / 12 ,0) total_years,
70: trunc(mod(sum(months_between(least(nvl(ACTUAL_TERMINATION_DATE + 1, p_session_date + 1),
71: p_session_date + 1), DATE_START)) , 12),0) total_months
72: from PER_PERIODS_OF_SERVICE
73: where PERSON_ID = p_person_id
74: and business_group_id + 0 = p_business_group_id
75: and DATE_START <= p_session_date
76: and PERIOD_OF_SERVICE_ID <= p_period_of_service_id;

Line 129: delete from per_periods_of_service

125: procedure delete_row(p_row_id VARCHAR2) is
126: --
127: begin
128: --
129: delete from per_periods_of_service
130: where rowid=chartorowid(p_row_id);
131: --
132: end;
133: --

Line 186: select per_periods_of_service_s.nextval

182: -- END WWBUG fix for 1390173
183: --
184: begin
185: begin
186: select per_periods_of_service_s.nextval
187: into l_period_of_service_id
188: from sys.dual;
189: end;
190: insert into per_periods_of_service (

Line 190: insert into per_periods_of_service (

186: select per_periods_of_service_s.nextval
187: into l_period_of_service_id
188: from sys.dual;
189: end;
190: insert into per_periods_of_service (
191: period_of_service_id
192: ,business_group_id
193: ,person_id
194: ,date_start

Line 372: from per_periods_of_service

368: ,p_pds_information30 VARCHAR2
369: ,p_adjusted_svc_date DATE
370: ) is
371: cursor pps is select *
372: from per_periods_of_service
373: where rowid = chartorowid(p_row_id)
374: for update nowait;
375: pps_rec pps%rowtype;
376: begin

Line 929: from per_periods_of_service

925: select date_start,
926: actual_termination_date,
927: final_process_date,
928: leaving_reason
929: from per_periods_of_service
930: where period_of_service_id = p_period_of_service_id;
931:
932: -- Added for Bug 1150185
933: --

Line 1161: per_periods_of_service_pkg.update_row(p_row_id => p_row_id

1157: --
1158: --
1159: -- VT #1364630 08/23/00
1160: -- 3665620 Removed the code to clear of DFF during Reverse Termination
1161: per_periods_of_service_pkg.update_row(p_row_id => p_row_id
1162: ,p_period_of_service_id => p_period_of_service_id
1163: ,p_business_group_id => p_business_group_id
1164: ,p_person_id => p_person_id
1165: ,p_date_start => p_date_start

Line 1268: per_periods_of_service_pkg.delete_per_pay_proposals(

1264: /* This delete is now doen in hrempter.terminate_employee so that the
1265: deletion of pay proposals can be kept in step with the deletion
1266: of elements.
1267:
1268: per_periods_of_service_pkg.delete_per_pay_proposals(
1269: p_period_of_service_id => p_period_of_service_id
1270: ,p_actual_termination_date => p_actual_termination_date);
1271: */
1272: hrempter.terminate_employee('POST_UPDATE'

Line 1558: from per_periods_of_service

1554: -- START WWBUG fix for 1390173
1555: --
1556: cursor c1 is
1557: select *
1558: from per_periods_of_service
1559: where rowid = chartorowid(p_row_id);
1560: --
1561: l_c1 c1%rowtype;
1562: --

Line 1615: update per_periods_of_service pps

1611: --
1612: --
1613: -- END WWBUG fix for 1390173
1614: --
1615: update per_periods_of_service pps
1616: set pps.period_of_service_id = p_period_of_service_id
1617: ,pps.business_group_id = p_business_group_id
1618: ,pps.person_id = p_person_id
1619: ,pps.date_start = p_date_start

Line 1752: per_periods_of_service pps

1748: --
1749: cursor terminated_by is
1750: select p.full_name,nvl(p.employee_number, p.npw_number)
1751: from per_all_people_f p,
1752: per_periods_of_service pps
1753: where p.person_id = pps.termination_accepted_person_id
1754: and (p.business_group_id = p_business_group_id OR
1755: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N') = 'Y')
1756: and pps.period_of_service_id = p_period_of_service_id

Line 1761: per_periods_of_service_pkg.get_years_months(p_session_date => p_session_date

1757: and nvl(pps.accepted_termination_date,p_session_date)
1758: between p.effective_start_date and p.effective_end_date ;
1759: --
1760: begin
1761: per_periods_of_service_pkg.get_years_months(p_session_date => p_session_date
1762: ,p_period_of_service_id => p_period_of_service_id
1763: ,p_business_group_id => p_business_group_id
1764: ,p_person_id => p_person_id
1765: ,p_tp_years => p_tp_years

Line 1770: per_periods_of_service_pkg.populate_status(p_person_id => p_person_id

1766: ,p_tp_months => p_tp_months
1767: ,p_total_years => p_total_years
1768: ,p_total_months => p_total_months);
1769: if p_actual_termination_date is not null then
1770: per_periods_of_service_pkg.populate_status(p_person_id => p_person_id
1771: ,p_status => p_status
1772: ,p_assignment_status_id => p_assignment_status_id);
1773: end if;
1774: if p_termination_accepted_id is not null then

Line 1781: END PER_PERIODS_OF_SERVICE_PKG;

1777: close terminated_by;
1778: end if;
1779: end form_post_query;
1780:
1781: END PER_PERIODS_OF_SERVICE_PKG;