1 package PAY_RETRO_NOTIF_PKG as
2 /* $Header: payretno.pkh 120.1.12010000.1 2008/07/27 21:52:52 appldev ship $ */
3 --
4
5 procedure run_asg_adv_retronot(
6 p_assignment_id in number,
7 p_business_group_id in number,
8 p_time_started in date default sysdate,
9 p_event_group in number default null);
10
11 procedure run_debug(p_event_group in number,
12 p_start_date in date,
13 p_end_date in date,
14 p_bg_id in number,
15 p_assignment_id in number,
16 p_rownum in number,
17 p_adv_flag in varchar2);
18 -------------------------------------------------------------------------------
19 Procedure get_asg_info(
20 p_assignment_id IN NUMBER
21 , p_report_date IN DATE
22 , p_business_group_id IN NUMBER
23 , p_legislation_code IN VARCHAR2
24 , p_asg_status OUT NOCOPY VARCHAR2
25 , p_person_name OUT NOCOPY VARCHAR2);
26 -------------------------------------------------------------------------------
27 Procedure get_ele_info(
28 p_element_entry_id IN NUMBER
29 , p_report_date IN DATE
30 , p_business_group_id IN NUMBER
31 , p_legislation_code IN VARCHAR2
32 , p_element_name OUT NOCOPY VARCHAR2);
33 -------------------------------------------------------------------------------
34 procedure range_cursor ( pactid in number,
35 sqlstr out nocopy varchar2
36 );
37 procedure action_creation ( pactid in number,
38 stperson in number,
39 endperson in number,
40 chunk in number
41 );
42 procedure archinit(p_payroll_action_id in number);
43 procedure process_action(p_assactid in number,
44 p_effective_date in date
45 );
46 procedure deinitialise (pactid in number);
47 -------------------------------------------------------------------------------
48 Function get_person_name(
49 p_assignment_id IN NUMBER
50 , p_report_date IN DATE
51 , p_business_group_id IN NUMBER
52 , p_legislation_code IN VARCHAR2)
53 Return varchar2;
54 -------------------------------------------------------------------------------
55 Function get_asg_status(
56 p_assignment_id IN NUMBER
57 , p_report_date IN DATE
58 , p_business_group_id IN NUMBER
59 , p_legislation_code IN VARCHAR2)
60 Return varchar2;
61 -------------------------------------------------------------------------------
62 End PAY_RETRO_NOTIF_PKG;