1 package pay_ca_rules AUTHID CURRENT_USER as
2 /* $Header: pycarule.pkh 120.7.12020000.5 2013/04/19 13:26:19 sbachu ship $ */
3 /*
4 Copyright (c) Oracle Corporation 1991,1992,1993,1994. All rights reserved
5 --
6 Name : pay_ca_rules
7 --
8 Change List
9 -----------
10 Date Name Vers Description
11 ----------- ---------- ----- -------------------------------------------
12 19-Apr-2013 sbachu 115.12 Bug 16686045. Added functions
13 get_payslip_sort_order1,2,3 to sort
14 CA Dep Adv(XML) properly.
15 07-May-2012 vvijayku 115.11 Bug 13969858. Added the procedure get_custom_xml_routine
16 05-Mar-2012 sbachu 115.10 Bugs 13773808,13773821 and 13773865. Added
17 for Chequewriter, Third party Chequwriter
18 and Deposit Advice(XML) Enhancements
19 07-MAY-2010 sneelapa 115.9 Bug 9692321.
20 Added add_custom_xml procedure without parameters.
21
22 18-MAR-2010 aneghosh 115.8 Bug 9445414. CA PDF payslip Enhancement.
23 Added add_custom_xml procedure with parameters.
24 30-APR-2009 sapalani 115.7 For bug 8459792, Added new IN OUT parameter
25 p_wk_sch_found to function
26 work_schedule_total_hours.
27 10-AUG-2006 pganguly 115.6 Added nocopy in FILE_NO out parameter.
28 10-AUG-2006 pganguly 115.5 Added get_file_creation_number prcedure.
29 Also changed the signature of add_custom
30 _xml procedure.
31 27-OCT-2005 mmukherj 115.4 Added the function work_schedule_total_hours
32 used by new work schedule functionality
33 03-OCT-2005 mmukherj 115.3 Added add_custom_xml procedure
34 10-APR-2003 vpandya 115.2 Added get_multi_tax_unit_pay_flag procedure
35 to get 'Payroll Archiver Level' of the
36 business group to process payroll run.
37 04-SEP-2002 vpandya 115.1 Added get_dynamic_tax_unit procedure for
38 Multi GRE functionality.
39 23-APR-1999 mmukherj 110.0 Created.
40 */
41
42 procedure get_default_jurisdiction(p_asg_act_id number,
43 p_ee_id number,
44 p_jurisdiction in out nocopy varchar2);
45
46 procedure get_dynamic_tax_unit(p_asg_act_id in number,
47 p_run_type_id in number,
48 p_tax_unit_id in out nocopy number);
49
50 procedure get_multi_tax_unit_pay_flag
51 (p_bus_grp in number,
52 p_mtup_flag in out nocopy varchar2);
53
54 PROCEDURE add_custom_xml;
55
56 -- add_custom_xml with parameters is added for CA PDF Payslip enhancement.
57
58 PROCEDURE add_custom_xml(P_ASSIGNMENT_ACTION_ID IN NUMBER ,
59 P_ACTION_INFORMATION_CATEGORY IN VARCHAR2,
60 P_DOCUMENT_TYPE IN VARCHAR2);
61
62 /* Changes for bugs 13773808 and 13773821 starts here*/
63 FUNCTION convert_number(IN_NUMERAL INTEGER := 0) RETURN VARCHAR2 ;
64 FUNCTION get_word_value (P_AMOUNT NUMBER) RETURN VARCHAR2 ;
65 FUNCTION CF_word_amountFormula(CP_LN_AMOUNT IN NUMBER) RETURN VARCHAR2 ;
66 /* Changes for bugs 13773808 and 13773821 ends here*/
67
68 FUNCTION work_schedule_total_hours(
69 assignment_action_id IN NUMBER --Context
70 ,assignment_id IN NUMBER --Context
71 ,p_bg_id in NUMBER -- Context
72 ,element_entry_id IN NUMBER --Context
73 ,date_earned IN DATE
74 ,p_range_start IN DATE
75 ,p_range_end IN DATE
76 ,p_wk_sch_found IN OUT NOCOPY VARCHAR2)
77 RETURN NUMBER ;
78
79 PROCEDURE get_file_creation_no(
80 PACTID IN NUMBER,
81 FILE_NO OUT NOCOPY NUMBER);
82
83 /* Added for CANADIAN DEPOSIT ADVICE XML Enhancement */
84 PROCEDURE payslip_range_cursor(p_pactid in number
85 ,p_sqlstr out NOCOPY varchar2);
86
87
88 /* Added for CANADIAN DEPOSIT ADVICE XML Enhancement */
89 -- Added Procedure get_token_names to be used by Global Payslip Printing
90 -- Solution pay_payslip_report.xml_asg
91 procedure get_token_names(p_pa_token out nocopy varchar2
92 ,p_cs_token out nocopy varchar2);
93
94 PROCEDURE get_custom_xml_routine(p_document_type in varchar2
95 ,p_xml_routine out NOCOPY varchar2);
96
97 /*Bug 16686045 starts here*/
98
99 FUNCTION get_payslip_sort_order1 RETURN VARCHAR2;
100 --
101 FUNCTION get_payslip_sort_order2 RETURN VARCHAR2;
102 --
103 FUNCTION get_payslip_sort_order3 RETURN VARCHAR2;
104
105 /*Bug 16686045 ends here*/
106
107 end pay_ca_rules;