1 PACKAGE PER_BF_GEN_DATA_PUMP AUTHID CURRENT_USER AS
2 /* $Header: pebgendp.pkh 115.4 2002/09/06 16:07:29 apholt noship $ */
3
4 -- -------------------------------------------------------------------------
5 -- --------------------< get_input_value_id >-------------------------------
6 -- -------------------------------------------------------------------------
7 -- DESCRIPTION
8 -- This function returns the input_value_id for the backfeed APIs
9 -- It will be used by the datapump API for PER_BF_BALANCE_TYPES
10 -- The reporting name is can be considered unique due to a constraint in the
11 -- database. This maps onto the input value that is used.
12 --
13 FUNCTION get_input_value_id
14 (p_reporting_name IN VARCHAR2
15 ,p_business_group_id IN NUMBER
16 ,p_effective_date IN DATE)
17 RETURN BINARY_INTEGER;
18 PRAGMA RESTRICT_REFERENCES (get_input_value_id, WNDS);
19 -- -------------------------------------------------------------------------
20 -- --------------------< get_balance_type_id >------------------------------
21 -- -------------------------------------------------------------------------
22 -- DESCRIPTION
23 -- This function returns the balance_type_id for the backfeed APIs
24 --
25 FUNCTION get_balance_type_id
26 (p_balance_type_name IN VARCHAR2
27 ,p_business_group_id IN NUMBER
28 ,p_effective_date IN DATE)
29 RETURN BINARY_INTEGER;
30 PRAGMA RESTRICT_REFERENCES (get_balance_type_id, WNDS);
31 --
32 -- -------------------------------------------------------------------------
33 -- --------------------< get_payroll_id >-----------------------------------
34 -- -------------------------------------------------------------------------
35 -- DESCRIPTION
36 -- get_payroll_id
37 -- DESCRIPTION
38 -- Returns a Payroll ID.
39 FUNCTION get_payroll_id
40 (
41 p_payroll_name IN VARCHAR2,
42 p_business_group_id IN NUMBER,
43 p_effective_date IN DATE
44 )
45 RETURN BINARY_INTEGER;
46 PRAGMA RESTRICT_REFERENCES (get_payroll_id, WNDS);
47 -- -------------------------------------------------------------------------
48 -- --------------------< get_payroll_run_id >-------------------------------
49 -- -------------------------------------------------------------------------
50 -- DESCRIPTION
51 -- This function returns the payroll_run_id for the backfeed APIs
52 --
53 FUNCTION get_payroll_run_id
54 (p_payroll_run_user_key IN VARCHAR2)
55 RETURN BINARY_INTEGER;
56 PRAGMA RESTRICT_REFERENCES (get_payroll_run_id, WNDS);
57 --
58 -- -------------------------------------------------------------------------
59 -- --------------------< get_assignment_id >--------------------------------
60 -- -------------------------------------------------------------------------
61 -- DESCRIPTION
62 -- This function returns the assignment_id for the backfeed APIs
63 -- For the Generic implementation, we are assuming that the user is
64 -- only working with the primary assignment so the Employee
65 -- number (which is unique in a business group)is all that is required
66 -- to obtain the ID.
67 --
68 FUNCTION get_assignment_id
69 (p_employee_number IN VARCHAR2
70 ,p_business_group_id IN NUMBER
71 ,p_effective_date IN DATE)
72 RETURN BINARY_INTEGER;
73 PRAGMA RESTRICT_REFERENCES (get_assignment_id, WNDS);
74 --
75 -- -------------------------------------------------------------------------
76 -- ------------------< get_personal_payment_method_id >---------------------
77 -- -------------------------------------------------------------------------
78 -- DESCRIPTION
79 -- This function returns the personal_payment_method_id for the backfeed APIs
80 -- For the generic implementation, we are only working with the primary
81 -- assignment so the Employee number (which is unique in a business group)
82 -- is enough to obtain the assignment_id. The rule is that the highest
83 -- priority personal payment method for the primary assignment for the
84 -- organization payment method (which is passed in) will be selected.
85 -- This means that whilst it is possible to have multiple payment methods
86 -- per primary assignment, the highest priority one will be selected to
87 -- resolve the ID.
88 FUNCTION get_personal_payment_method_id
89 (p_employee_number IN VARCHAR2
90 ,p_business_group_id IN NUMBER
91 ,p_effective_date IN DATE
92 ,p_org_payment_method_name IN VARCHAR2)
93 RETURN BINARY_INTEGER;
94 PRAGMA RESTRICT_REFERENCES (get_personal_payment_method_id, WNDS);
95 END PER_BF_GEN_DATA_PUMP;