1 PACKAGE PAY_PAYROLL_ACTIONS_PKG AS
2 /* $Header: pypra02t.pkh 120.0.12010000.1 2008/07/27 23:26:42 appldev ship $ */
3 --
4 procedure update_row(p_rowid in varchar2,
5 p_action_status in varchar2 ) ;
6 --
7 procedure delete_row ( p_rowid in varchar2 ) ;
8 --
9 procedure lock_row (p_rowid in varchar2,
10 p_action_status in varchar2 ) ;
11 --
12 -- Functions to support the views used in the PAYWSACT form
13 --
14 function v_action_status ( p_payroll_action_id in number,
15 p_payroll_action_status in varchar2,
16 p_request_id in number ) return varchar2;
17 -- pragma restrict_references(v_action_status, WNPS, WNDS);
18 --
19 function v_action_status ( p_payroll_action_id in number,
20 p_payroll_action_status in varchar2,
21 p_request_id in number,
22 p_force in boolean) return varchar2;
23 -- pragma restrict_references(v_action_status, WNPS, WNDS);
24 --
25 function v_messages_exist(p_payroll_action_id in number) return varchar2 ;
26 pragma restrict_references(v_messages_exist, WNPS,WNDS);
27 --
28 function v_name(p_payroll_action_id in number,
29 p_action_type in varchar2,
30 p_consolidation_set_id in number,
31 p_display_run_number in number,
32 p_element_set_id in number,
33 p_assignment_set_id in number,
34 p_effective_date in date ) return varchar2 ;
35 -- pragma restrict_references(v_name, WNPS,WNDS);
36 --
37 function v_name(p_payroll_action_id in number,
38 p_action_type in varchar2,
39 p_consolidation_set_id in number,
40 p_display_run_number in number,
41 p_element_set_id in number,
42 p_assignment_set_id in number,
43 p_effective_date in date,
44 p_force in boolean ) return varchar2 ;
45 -- pragma restrict_references(v_name, WNPS,WNDS);
46
47
48 -- DK
49 -- Bug 643154
50 -- The following functions allow numeric and date bind values to be
51 -- passed through to a view. In a future release it is likely that this
52 -- mechanism will be genericised and put into a common code area.
53 --
54 -- Name
55 -- set_query_bindvar
56 -- Purpose
57 -- Sets a constant value from the client to server side
58 -- Arguments
59 --
60 -- p_context_name name of the context to be supported.
61 -- See package body for the list of those supported.
62 --
63 -- p_context_value value of the context.
64 --
65 procedure set_query_bindvar( p_context_name in varchar2,
66 p_context_value in varchar2 ) ;
67
68 -- Name
69 -- get_num_bindvar
70 -- Purpose
71 -- Returns the the given context as a number
72 -- Arguments
73 -- p_context_name
74 --
75 function get_num_bindvar( p_context_name in varchar2 ) return number ;
76 pragma restrict_references(get_num_bindvar, WNPS,WNDS);
77
78 -- Name
79 -- get_date_bindvar
80 -- Purpose
81 -- Returns the the given context as a date
82 -- Arguments
83 -- p_context_name
84 --
85 function get_date_bindvar( p_context_name in varchar2 ) return date ;
86 pragma restrict_references(get_date_bindvar, WNPS,WNDS);
87
88 -- Name
89 -- get_char_bindvar
90 -- Purpose
91 -- Returns the the given context in varchar2
92 -- Arguments
93 -- p_context_name
94 --
95 function get_char_bindvar ( p_context_name in varchar2 ) return varchar2;
96 pragma restrict_references(get_char_bindvar, WNPS,WNDS);
97
98 -- Name
99 -- set_where
100 -- Purpose
101 -- Sets query criteria passed from the Payroll Process results block as
102 -- package variables using the set_query_bindvar routines above.
103 -- Arguments
104 -- See below
105 --
106 procedure set_where ( p_payroll_id in number,
107 p_date_from in date ,
108 p_date_to in date,
109 p_action_type in varchar2 );
110
111 procedure set_where ( p_payroll_id in number,
112 p_date_from in date ,
113 p_date_to in date,
114 p_action_type in varchar2,
115 p_server_validate in varchar2 default 'Y' ) ;
116 -- Name
117 -- latest_balance_exists
118 -- Purpose
119 -- Identifies latest balances for rows returned in pay_balances_v and
120 -- is defined as a function for performance reasons.
121 -- Arguments
122 -- See below
123 function latest_balance_exists (p_assignment_action_id in number
124 ,p_defined_balance_id in number) return varchar2;
125
126 -- Name
127 -- decode_cheque_type
128 -- Purpose
129 -- Returns the correct action type for the cheque writer process depending on
130 -- the legislation code associated with the business_group_id passed in.
131 -- ie. GB => "Cheque Writer", US => "Check Writer"
132 -- Arguments
133 -- p_business_group_id
134 --
135 function decode_cheque_type ( p_business_group_id in number ) return varchar2;
136 --
137 END PAY_PAYROLL_ACTIONS_PKG;