1 Package pqp_service_history_calc_pkg AUTHID CURRENT_USER as
2 /* $Header: pqshpcal.pkh 115.2 2003/02/14 19:21:22 tmehra noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |-----------------------< calculate_service_history >----------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 FUNCTION calculate_service_history (p_assignment_id in number
9 ,p_calculation_date in date
10 )
11 RETURN number;
12
13 --
14 -- This function is required to calculate the length of previous service
15 -- in days.
16 --
17 -- Added this new function
18 -- PS Bug 2028104 for details
19 -- ----------------------------------------------------------------------------
20 -- |-----------------------< calculate_all_service_history >------------------|
21 -- ----------------------------------------------------------------------------
22 --
23 FUNCTION calculate_all_service_history (p_assignment_id in number
24 )
25 RETURN number;
26 --
27 -- ----------------------------------------------------------------------------
28 -- |---------------------< calculate_continuous_service >---------------------|
29 -- ----------------------------------------------------------------------------
30 FUNCTION calculate_continuous_service (p_assignment_id in number
31 ,p_calculation_date in date
32 )
33 RETURN number;
34
35 --
36 -- This function is required to calculate the total continuous service in days --
37 --
38 -- Added this new function
39 -- PS Bug 2028104 for details
40 -- ----------------------------------------------------------------------------
41 -- |---------------------< calculate_all_continuous_serv >--------------------|
42 -- ----------------------------------------------------------------------------
43 FUNCTION calculate_all_continuous_serv (p_assignment_id in number
44 )
45 RETURN number;
46 --
47 -- ----------------------------------------------------------------------------
48 -- |-------------------< calculate_service_hist_period >----------------------|
49 -- ----------------------------------------------------------------------------
50 PROCEDURE calculate_service_hist_period (p_start_date in date
51 ,p_end_date in date
52 ,p_years out nocopy number
53 ,p_days out nocopy number
54 );
55 --
56 -- This procedure is required to calculate the duration of a particular
57 -- period of service history in years and days.
58 -------------------------------
59 END pqp_service_history_calc_pkg;