[Home] [Help]
PACKAGE: APPS.PAY_NZ_REC_PKG
Source
1 package pay_nz_rec_pkg AUTHID CURRENT_USER as
2 /* $Header: pynzrec.pkh 115.2 2002/12/03 05:34:52 srrajago ship $*/
3
4 function period_payment_date
5 (p_time_period_id in pay_payroll_actions.time_period_id%type)
6 return per_time_periods.regular_payment_date%type;
7
8 function first_action_sequence
9 (p_assignment_id in pay_assignment_actions.assignment_id%type,
10 p_time_period_id in pay_payroll_actions.time_period_id%type)
11 return pay_assignment_actions.action_sequence%type;
12
13 function last_action_sequence
14 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
15 p_assignment_id in pay_assignment_actions.assignment_id%type)
16 return pay_assignment_actions.action_sequence%type;
17
18 function result_ptd
19 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
20 p_assignment_id in pay_assignment_actions.assignment_id%type,
21 p_element_type_id in pay_element_types_f.element_type_id%type)
22 return number;
23
24 function result_ytd
25 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
26 p_assignment_id in pay_assignment_actions.assignment_id%type,
27 p_element_type_id in pay_element_types_f.element_type_id%type)
28 return number;
29
30 function single_feed_balance
31 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
32 p_assignment_id in pay_assignment_actions.assignment_id%type,
33 p_element_type_id in pay_element_types_f.element_type_id%type,
34 p_assignment_action_id out nocopy pay_assignment_actions.assignment_action_id%type,
35 p_balance_type_id out nocopy pay_balance_types.balance_type_id%type,
36 p_effective_start_date out nocopy pay_balance_feeds_f.effective_start_date%type)
37 return boolean;
38
39 function value_ptd
40 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
41 p_assignment_id in pay_assignment_actions.assignment_id%type,
42 p_element_type_id in pay_element_types_f.element_type_id%type)
43 return number;
44
45 function value_ytd
46 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
47 p_assignment_id in pay_assignment_actions.assignment_id%type,
48 p_element_type_id in pay_element_types_f.element_type_id%type)
49 return number;
50 end pay_nz_rec_pkg;