1 PACKAGE PAY_CC_PROCESS_UTILS AUTHID CURRENT_USER AS
2 /* $Header: pyccutl.pkh 120.0.12010000.1 2008/07/27 22:19:44 appldev ship $ */
3
4 -- Continuous Calculation Process procedures.
5 -- seeded in pay_report_format_mappings and called by pyugen.
6 --
7 procedure action_creation(p_pactid in number,
8 p_stperson in number,
9 p_endperson in number,
10 p_chunk in number);
11
12 procedure archinit(p_payroll_action_id in number);
13 procedure archive_data(p_assactid in number, p_effective_date in date);
14 procedure range_cursor (pactid in number, sqlstr out nocopy varchar2);
15 procedure deinitialise (pactid in number);
16
17 --Developer utils to create/maintain DYT's
18 procedure generate_upd_trigger(p_table_name in varchar2,
19 p_owner in varchar2,
20 p_surr_key_name in varchar2,
21 p_eff_str_name in varchar2,
22 p_eff_end_name in varchar2,
23 p_pkg_proc_name in varchar2 default null,
24 p_bg_select in varchar2 default null,
25 p_mode in varchar2 default 'PROCEDURE');
26 procedure generate_cc_procedure(p_table_name in varchar2,
27 p_surr_key_name in varchar2,
28 p_eff_str_name in varchar2,
29 p_eff_end_name in varchar2,
30 p_owner in varchar2
31 );
32 procedure generate_upd_script(p_table_name in varchar2
33 );
34 FUNCTION get_asg_act_status( p_assignment_action_id in number,
35 p_action_type in varchar2,
36 p_action_status in varchar2) return varchar2;
37
38
39 --Additional helpers for DYT_PKG
40 procedure generate_dyt_pkg_behaviour(p_table_name in varchar2,
41 p_tab_rki_pkg in varchar2,
42 p_tab_rku_pkg in varchar2,
43 p_tab_rkd_pkg in varchar2 );
44 procedure drop_dyt_pkg_behaviour(p_table_name in varchar2);
45
46 procedure reset_dates_for_run( p_asg_id in number,
47 p_sysdate in date,
48 p_assact_id in number);
49
50 END PAY_CC_PROCESS_UTILS;