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.2 2011/09/16 10:04:54 srannama ship $ */
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: -- Bug 12780960

Line 73: from PER_PERIODS_OF_SERVICE

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

Line 130: delete from per_periods_of_service

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

Line 187: select per_periods_of_service_s.nextval

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

Line 191: insert into per_periods_of_service (

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

Line 373: from per_periods_of_service

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

Line 930: from per_periods_of_service

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

Line 1162: per_periods_of_service_pkg.update_row(p_row_id => p_row_id

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

Line 1269: per_periods_of_service_pkg.delete_per_pay_proposals(

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

Line 1559: from per_periods_of_service

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

Line 1616: update per_periods_of_service pps

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

Line 1753: per_periods_of_service pps

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

Line 1762: per_periods_of_service_pkg.get_years_months(p_session_date => p_session_date

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

Line 1771: per_periods_of_service_pkg.populate_status(p_person_id => p_person_id

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

Line 1782: END PER_PERIODS_OF_SERVICE_PKG;

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