PACKAGE: APPS.PQP_FTE_UTILITIES

Source

1 PACKAGE pqp_fte_utilities AUTHID CURRENT_USER AS
2 /* $Header: pqftepkg.pkh 120.0 2005/05/29 01:47:56 appldev noship $ */
3 
4 TYPE t_asg_details IS TABLE OF per_all_assignments_f.assignment_id%TYPE
5     INDEX BY BINARY_INTEGER;
6 
7 --
8 -- Set_FTE_Value
9 -- Calculate FTE and write to database.
10 PROCEDURE set_fte_value
11   (p_assignment_id                IN            NUMBER
12   ,p_business_group_id            IN            NUMBER
13   ,p_calculation_date             IN            DATE
14   ,p_fte_value                    IN            NUMBER
15   );
16 
17 
18 -- Get_Fte_Value
19 -- Query and return the effective FTE
20 FUNCTION get_fte_value
21   (p_assignment_id                IN            NUMBER
22   ,p_calculation_date             IN            DATE
23   ) RETURN NUMBER;
24 
25 
26 -- Update_FTE_For_Assignment
27 -- Calculate FTE and write to database for a single assignment
28 PROCEDURE update_fte_for_assignment
29   (p_assignment_id                IN            NUMBER
30   ,p_effective_date               IN            DATE
31   );
32 
33 
34 --  Update_FTE_For_Assignment_Set
35 --  Calculate FTE and write to database for multiple assigments
36 PROCEDURE update_fte_for_assignment_set
37   (ERRBUF                            OUT NOCOPY VARCHAR2
38   ,RETCODE                           OUT NOCOPY NUMBER
39   ,p_contract_type                IN            VARCHAR2
40   ,p_payroll_id                   IN            NUMBER
41   ,p_calculation_date             IN            VARCHAR2
42   ,p_trace                        IN            VARCHAR2
43   );
44 
45 END pqp_fte_utilities;