DBA Data[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;