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.PQP_SERVICE_HISTORY_CALC_PKG dependencies on PQP_SERVICE_HISTORY_CALC_PKG

Line 1: Package Body pqp_service_history_calc_pkg as

1: Package Body pqp_service_history_calc_pkg as
2: /* $Header: pqshpcal.pkb 120.0 2005/05/29 02:11:33 appldev noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- |-------------------------< calculate_period >-----------------------------|

Line 14: l_proc VARCHAR2(60) := 'pqp_service_history_calc_pkg.calculate_period';

10: ) IS
11: --
12: -- Calculate the number of days for given dates
13: --
14: l_proc VARCHAR2(60) := 'pqp_service_history_calc_pkg.calculate_period';
15: l_start_date DATE := trunc(p_start_date);
16: l_end_date DATE := trunc(p_end_date);
17: l_days NUMBER(12);
18: --

Line 68: l_func VARCHAR2(60) := 'pqp_service_history_calc_pkg.calculate_current_service';

64: AND trunc(shp.end_date)
65: AND shp.assignment_id = p_assignment_id
66: AND shp.continuous_service = NVL(p_continuous_service, shp.continuous_service));
67: --
68: l_func VARCHAR2(60) := 'pqp_service_history_calc_pkg.calculate_current_service';
69: l_days NUMBER(12) := 0 ;
70: --
71: BEGIN
72: hr_utility.set_location('Entering: '||l_func, 10);

Line 100: l_proc VARCHAR2(60) := 'pqp_service_history_calc_pkg.convert_years_to_days';

96: PROCEDURE convert_years_to_days (p_start_date in date
97: ,p_period_years in number
98: ,p_days out nocopy number) IS
99: --
100: l_proc VARCHAR2(60) := 'pqp_service_history_calc_pkg.convert_years_to_days';
101: l_days NUMBER(12) := 0 ;
102: l_end_date DATE;
103: --
104: BEGIN

Line 150: l_proc VARCHAR2(60) := 'pqp_service_history_calc_pkg.check_overlap_curr_serv';

146: AND trunc(p_calculation_date) between trunc(asg.effective_start_date)
147: and trunc(asg.effective_end_date)
148: AND asg.assignment_id = p_assignment_id ;
149: --
150: l_proc VARCHAR2(60) := 'pqp_service_history_calc_pkg.check_overlap_curr_serv';
151: l_days NUMBER(12) := 0 ;
152: l_exists VARCHAR2(1);
153: --
154: BEGIN

Line 281: l_func VARCHAR2(60) := 'pqp_service_history_calc_pkg.calculate_service_history';

277: and trunc(shp2.end_date)
278: or trunc(shp1.end_date) between trunc(shp2.start_date)
279: and trunc(shp2.end_date)));
280: --
281: l_func VARCHAR2(60) := 'pqp_service_history_calc_pkg.calculate_service_history';
282: l_days NUMBER(12);
283: l_tot_days NUMBER(12) := 0;
284: --
285: BEGIN

Line 377: l_func VARCHAR2(80) := 'pqp_service_history_calc_pkg.calculate_all_service_history';

373: ,period_days
374: FROM pqp_service_history_periods shp1
375: WHERE shp1.assignment_id = p_assignment_id;
376: --
377: l_func VARCHAR2(80) := 'pqp_service_history_calc_pkg.calculate_all_service_history';
378: l_days NUMBER(12);
379: l_tot_days NUMBER(12) := 0;
380: --
381: BEGIN

Line 495: l_func VARCHAR2(60) := 'pqp_service_history_calc_pkg.calculate_continuous_service';

491: and trunc(shp2.end_date)
492: or trunc(shp1.end_date) between trunc(shp2.start_date)
493: and trunc(shp2.end_date)));
494: --
495: l_func VARCHAR2(60) := 'pqp_service_history_calc_pkg.calculate_continuous_service';
496: l_days NUMBER(12);
497: l_tot_days NUMBER(12) := 0;
498: --
499: BEGIN

Line 588: l_func VARCHAR2(80) := 'pqp_service_history_calc_pkg.calculate_all_continuous_serv';

584: FROM pqp_service_history_periods shp1
585: WHERE shp1.assignment_id = p_assignment_id
586: AND shp1.continuous_service = 'Y';
587: --
588: l_func VARCHAR2(80) := 'pqp_service_history_calc_pkg.calculate_all_continuous_serv';
589: l_days NUMBER(12);
590: l_tot_days NUMBER(12) := 0;
591: --
592: BEGIN

Line 658: l_proc VARCHAR2(60) := 'pqp_service_history_calc_pkg.calculate_service_hist_period';

654: -- This procedure should calculate the duration of a particular period of
655: -- service history.
656: -- The result should be returned in years and days.
657: --
658: l_proc VARCHAR2(60) := 'pqp_service_history_calc_pkg.calculate_service_hist_period';
659: l_start_date DATE := trunc(p_start_date);
660: l_new_start_date DATE;
661: -- include the end date so set the date to +1
662: l_end_date DATE := trunc(p_end_date) + 1;

Line 736: END pqp_service_history_calc_pkg;

732:
733:
734: END calculate_service_hist_period;
735: --
736: END pqp_service_history_calc_pkg;