1 package PAY_RETRO_NOTIF_PKG AUTHID CURRENT_USER as
2 /* $Header: payretno.pkh 120.2 2011/10/11 19:00:25 vpallapo 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 /* Bug 13083098, Quick-Retropay Changes*/
49 procedure generate_dates_and_process(p_assignment_id in number);
50 -------------------------------------------------------------------------------
51 /* Bug 13083098, Quick-Retropay Changes*/
52 procedure initialise_globals(p_event_group in number,
53 p_business_group_id in number,
54 p_payroll_action_id in number,
55 p_payroll_id in number,
56 p_asg_set_name in varchar2,
57 p_adv_flag in varchar2,
58 p_report_date in date
59 );
60 -------------------------------------------------------------------------------
61 Function get_person_name(
62 p_assignment_id IN NUMBER
63 , p_report_date IN DATE
64 , p_business_group_id IN NUMBER
65 , p_legislation_code IN VARCHAR2)
66 Return varchar2;
67 -------------------------------------------------------------------------------
68 Function get_asg_status(
69 p_assignment_id IN NUMBER
70 , p_report_date IN DATE
71 , p_business_group_id IN NUMBER
72 , p_legislation_code IN VARCHAR2)
73 Return varchar2;
74 -------------------------------------------------------------------------------
75 End PAY_RETRO_NOTIF_PKG;