1 Package PAY_RETRO_UTILS_PKG AUTHID CURRENT_USER as
2 /* $Header: pyretutl.pkh 120.2.12010000.1 2008/07/27 23:33:06 appldev ship $ */
3 --
4
5 PROCEDURE get_user(itemtype in varchar2,
6 itemkey in varchar2,
7 actid in number,
8 funcmode in varchar2,
9 resultout out nocopy varchar2);
10
11
12 PROCEDURE is_retropay_scheduled(itemtype in varchar2,
13 itemkey in varchar2,
14 actid in number,
15 funcmode in varchar2,
16 resultout out nocopy varchar2);
17
18 -----------------------------
19 -- PROCEDURES FOR CC
20 -----------------------------
21
22 PROCEDURE cc_reqd(itemtype in varchar2,
23 itemkey in varchar2,
24 actid in number,
25 funcmode in varchar2,
26 resultout out nocopy varchar2);
27
28 PROCEDURE cc_perform(itemtype in varchar2,
29 itemkey in varchar2,
30 actid in number,
31 funcmode in varchar2,
32 resultout out nocopy varchar2);
33
34 -----------------------------
35 -- USEFUL UTILS
36 -----------------------------
37 /*
38 Procedure retro_ent_tab_insert(
39 p_retro_assignment_id IN NUMBER
40 , p_element_entry_id IN NUMBER
41 , p_reprocess_date IN DATE
42 , p_eff_date IN DATE);
43 */
44
45 procedure create_super_retro_asg(p_asg_id IN NUMBER
46 ,p_payroll_id IN NUMBER
47 ,p_reprocess_date IN DATE
48 ,p_retro_asg_id OUT nocopy NUMBER);
49 Procedure maintain_retro_asg(
50 p_asg_id IN NUMBER
51 ,p_payroll_id IN NUMBER
52 ,p_min_date IN DATE
53 ,p_eff_date IN DATE
54 ,p_retro_asg_id out nocopy NUMBER) ;
55
56 FUNCTION get_retro_component_id(
57 p_element_entry_id in number,
58 p_ef_date in date,
59 p_element_type_id in number,
60 p_asg_id in number default NULL) return number;
61
62
63 end PAY_RETRO_UTILS_PKG;