1 package PAY_FR_DUCS AUTHID CURRENT_USER as
2 /* $Header: pyfraduc.pkh 115.4 2002/11/27 14:39:51 aparkes ship $ */
3
4 --
5 FUNCTION get_parameter (
6 p_parameter_string in varchar2
7 ,p_token in varchar2
8 ,p_segment_number in number default null) return varchar2;
9 --
10 PROCEDURE get_all_parameters (
11 p_payroll_action_id in number
12 ,p_business_group_id out nocopy number
13 ,p_company_id out nocopy number
14 ,p_period_type out nocopy varchar2
15 ,p_period_start_date out nocopy date
16 ,p_effective_date out nocopy date
17 ,p_english_base out nocopy varchar2
18 ,p_english_rate out nocopy varchar2
19 ,p_english_pay_value out nocopy varchar2
20 ,p_english_contrib_code out nocopy varchar2
21 ,p_french_base out nocopy varchar2
22 ,p_french_rate out nocopy varchar2
23 ,p_french_pay_value out nocopy varchar2
24 ,p_french_contrib_code out nocopy varchar2);
25
26 --
27 PROCEDURE get_lookup(
28 p_lookup_type in varchar2
29 ,p_lookup_code in varchar2
30 ,p_lookup_meaning out nocopy varchar2
31 ,p_lookup_tag out nocopy varchar2);
32 --
33 PROCEDURE get_count_emps(p_payroll_action_id in number
34 ,p_page_identifier in number
35 ,p_page_type in varchar2
36 ,p_contribution_emps out nocopy number
37 ,p_month_end_male out nocopy number
38 ,p_month_end_female out nocopy number
39 ,p_month_end_total out nocopy number
40 ,p_total_actions out nocopy number);
41
42 --
43 PROCEDURE process_payment(
44 p_name in varchar2
45 ,p_total_payment in number
46 ,p_payment1_type in varchar2
47 ,p_payment1_limit in number
48 ,p_payment1_value out nocopy number
49 ,p_payment2_type in varchar2
50 ,p_payment2_limit in number
51 ,p_payment2_value out nocopy number
52 ,p_payment3_type in varchar2
53 ,p_payment3_limit in number
54 ,p_payment3_value out nocopy number);
55 --
56 PROCEDURE process_contributions(
57 p_payroll_action_id in number
58 ,p_page_identifier in number
59 ,p_page_type in varchar2
60 ,p_total_contributions out nocopy number);
61
62 --
63 PROCEDURE recalculate_payment(
64 errbuf out nocopy varchar2
65 ,retcode out nocopy varchar2
66 ,p_company_id in number
67 ,p_period_end_date in varchar2
68 ,p_period_type in varchar2
69 ,p_override_information_id in number default null);
70 --
71
72 PROCEDURE range_code(
73 p_payroll_action_id in number
74 ,sqlstr out nocopy varchar2);
75 --
76 PROCEDURE assignment_action_code (
77 p_payroll_action_id in number
78 ,p_start_person_id in number
79 ,p_end_person_id in number
80 ,p_chunk in number);
81 --
82 PROCEDURE archinit(p_payroll_action_id IN NUMBER);
83 --
84 PROCEDURE archive_code (
85 p_assignment_action_id in number
86 ,p_effective_date in date);
87 --
88 PROCEDURE retrieve_contributions(
89 p_assignment_action_id in number
90 ,p_effective_date in date
91 ,p_tax_unit_id in number default null);
92 --
93 PROCEDURE deinitialize_code(
94 p_payroll_action_id in number);
95 --
96
97
98
99 end PAY_FR_DUCS;