1 PACKAGE pay_ip_payroll_arch AUTHID CURRENT_USER AS
2 /* $Header: payippayrollarch.pkh 120.1.12020000.1 2012/08/30 08:16:12 schowl noship $ */
3 --
4
5 PROCEDURE get_payroll_action_info(p_payroll_action_id in NUMBER
6 ,p_end_date OUT NOCOPY DATE
7 ,p_start_date OUT NOCOPY DATE
8 ,p_business_group_id OUT NOCOPY NUMBER
9 ,p_cons_set_id OUT NOCOPY NUMBER
10 ,p_payroll_id OUT NOCOPY NUMBER
11 );
12
13 FUNCTION get_element_payment_hours
14 (
15 p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,
16 p_element_type_id IN pay_element_entries_f.element_entry_id%TYPE,
17 p_pay_bases_id IN per_all_assignments_f.pay_basis_id%TYPE,
18 p_run_result_id IN pay_run_results.run_result_ID%TYPE,
19 p_effective_date IN pay_payroll_actions.effective_date%TYPE
20 )
21 RETURN NUMBER;
22
23 PROCEDURE range_code(p_payroll_action_id IN NUMBER
24 ,p_sqlstr OUT NOCOPY VARCHAR2);
25
26 PROCEDURE assignment_action_code(p_payroll_action_id IN NUMBER
27 ,p_start_person_id IN NUMBER
28 ,p_end_person_id IN NUMBER
29 ,p_chunk IN NUMBER);
30
31 PROCEDURE archive_code(p_xfr_action_id IN NUMBER,
32 p_effective_date IN DATE);
33
34
35 PROCEDURE initialization_code(p_payroll_action_id IN NUMBER);
36
37 gv_act_param_val VARCHAR2(240);
38 gn_np_sepchk_run_type_id NUMBER ;
39 gn_sepchk_run_type_id NUMBER ;
40 run_bal_stat pay_ac_action_arch.run_bal_stat_tab;
41 gv_legislation_code VARCHAR2(2);
42
43 TYPE def_bal IS RECORD ( act_info_category pay_action_information.action_information_category%TYPE,
44 bal_name pay_balance_types.reporting_name%TYPE,
45 bal_type_id NUMBER(10),
46 def_bal_id NUMBER(10),
47 dimension pay_balance_dimensions.database_item_suffix%TYPE,
48 attribute_name pay_bal_attribute_definitions.attribute_name%TYPE);
49
50 TYPE def_bal_tbl IS TABLE OF def_bal INDEX BY BINARY_INTEGER;
51
52 END pay_ip_payroll_arch;