1 PACKAGE PAY_US_RULES AUTHID CURRENT_USER as
2 /* $Header: pyusrule.pkh 120.10.12020000.2 2012/07/05 03:40:29 amnaraya ship $ */
3 /*
4 ******************************************************************
5 * *
6 * Copyright (C) 1993 Oracle Corporation. *
7 * All rights reserved. *
8 * *
9 * This material has been provided pursuant to an agreement *
10 * containing restrictions on its use. The material is also *
11 * protected by copyright law. No part of this material may *
12 * be copied or distributed, transmitted or transcribed, in *
13 * any form or by any means, electronic, mechanical, magnetic, *
14 * manual, or otherwise, or disclosed to third parties without *
15 * the express written permission of Oracle Corporation, *
16 * 500 Oracle Parkway, Redwood City, CA, 94065. *
17 * *
18 ******************************************************************
19
20 Change List
21 -----------
22 Date Name Vers Bug No Description
23 ----------- ---------- ------ ------- -------------------------------
24 23-APR-2004 sdahiya 115.0 Created.
25 17-APR-2005 rdhingra 115.1 Added Global Variable and
26 Declarations for user exit
27 calls Pre-Process, upd_user_stru
28 and Post-Process made from Global
29 Element Template. Also added
30 declaration of get_obj_id
31 function.
32 28-APR-2005 sodhingr 115.2 Added the function work_schedule
33 _total_hours used by new work
34 schedule functionality
35 29-APR-2005 rdhingra 115.3 FLSA Added Procedure call for
36 get_time_def_for_entry
37 and related Global variables
38 19-JUL-2005 rdhingra 115.4 FLSA2 Added Procedure call for
39 delete_pre_process and
40 delete_post_process
41 11-AUG-2005 kvsankar 115.5 FLSA2 Added a new function
42 get_time_def_for_entry_func
43 which has a pragma restric
44 reference associated with it.
45 13-MAR-2007 kvsankar 115.6 FLSA Added a new global variable
46 g_get_time_def_flag
47 24-May-2007 sausingh 115.7 5635335 Added procedure add_custom_xml
48 for displaying Net Pay Amount in
49 words in (Archived) Check Writer/
50 Deposit Advice.
51 26-Jun-2007 115.8 Modified add_custom_xml to print
52 Check Number and Amount. Added
53 procedure get_token_names.
54 15-Jan-2009 sudedas 115.10 7583387 Added 3 functions for DA(XML) -
55 get_payslip_sort_order1
56 get_payslip_sort_order2
57 get_payslip_sort_order3
58 Added payslip_range_cursor.
59 21-Jan-2009 sudedas 115.11 7583387 Changed Function DAxml_range_cursor
60 to Procedure.
61 115.12 7583387 Added NOCOPY hint for OUT variable.
62 17-Apr-2009 sudedas 115.13 8414024 Added IN OUT parameter to function
63 work_schedule_total_hours.
64 07-May-2012 vvijayku 115.14 13969852 Added the procedure get_custom_xml_routine
65 *****************************************************************************/
66
67 /****************************************************************************
68 Name : GET_DEFAULT_JUSRIDICTION
69 Description : This function returns the default jurisdiction code which is
70 used for involuntary deduction elements if the end user does
71 not specify jurisdiction input value.
72 *****************************************************************************/
73
74 PROCEDURE get_default_jurisdiction(p_asg_act_id number,
75 p_ee_id number,
76 p_jurisdiction in out nocopy varchar2);
77
78 l_pkg_name varchar2(20);
79
80 -- GLOBAL VARIABLE ADDED
81 lrec pay_ele_tmplt_obj;
82 -- For Procedure get_time_def_for_entry
83 g_current_asg_id NUMBER;
84 g_current_time_def_id NUMBER;
85 g_get_time_def_flag BOOLEAN;
86
87 FUNCTION element_template_pre_process (p_rec IN pay_ele_tmplt_obj)
88 RETURN pay_ele_tmplt_obj;
89
90
91 PROCEDURE element_template_upd_user_stru (p_element_template_id IN NUMBER);
92
93 PROCEDURE element_template_post_process (p_element_template_id IN NUMBER);
94
95 PROCEDURE delete_pre_process(p_element_template_id IN NUMBER);
96
97 PROCEDURE delete_post_process(p_element_template_id IN NUMBER);
98
99 FUNCTION get_obj_id(p_business_group_id IN NUMBER
100 ,p_legislation_code IN VARCHAR2
101 ,p_object_type IN VARCHAR2
102 ,p_object_name IN VARCHAR2
103 ,p_object_id IN NUMBER DEFAULT NULL)
104 RETURN NUMBER;
105
106 FUNCTION work_schedule_total_hours(
107 assignment_action_id IN NUMBER --Context
108 ,assignment_id IN NUMBER --Context
109 ,p_bg_id in NUMBER -- Context
110 ,element_entry_id IN NUMBER --Context
111 ,date_earned IN DATE
112 ,p_range_start IN DATE
113 ,p_range_end IN DATE
114 ,p_wk_sch_found IN OUT NOCOPY VARCHAR2)
115 RETURN NUMBER ;
116
117 PROCEDURE get_time_def_for_entry (
118 p_element_entry_id IN NUMBER,
119 p_assignment_id IN NUMBER,
120 p_assignment_action_id IN NUMBER,
121 p_business_group_id IN NUMBER,
122 p_time_definition_id IN OUT NOCOPY VARCHAR2
123 );
124
125 FUNCTION get_time_def_for_entry_func(
126 p_element_entry_id IN NUMBER,
127 p_assignment_id IN NUMBER,
128 p_assignment_action_id IN NUMBER,
129 p_business_group_id IN NUMBER,
130 p_time_def_date IN DATE
131 ) RETURN NUMBER;
132
133 pragma restrict_references(get_time_def_for_entry_func, WNDS, WNPS);
134
135 -- Converting Numeric Amounts to Words (To be Displayed on Check Writer)
136 FUNCTION convert_number(IN_NUMERAL INTEGER := 0) RETURN VARCHAR2 ;
137 FUNCTION get_word_value (P_AMOUNT NUMBER) RETURN VARCHAR2 ;
138 FUNCTION CF_word_amountFormula(CP_LN_AMOUNT IN NUMBER) RETURN VARCHAR2 ;
139
140 PROCEDURE add_custom_xml( P_ASSIGNMENT_ACTION_ID IN NUMBER ,
141 P_ACTION_INFORMATION_CATEGORY IN VARCHAR2,
142 P_DOCUMENT_TYPE IN VARCHAR2);
143 -- Added Procedure get_token_names to be used by Global Payslip Printing
144 -- Solution pay_payslip_report.xml_asg
145 procedure get_token_names(p_pa_token out nocopy varchar2
146 ,p_cs_token out nocopy varchar2);
147
148 --
149 --
150 FUNCTION get_payslip_sort_order1 RETURN VARCHAR2;
151 --
152 FUNCTION get_payslip_sort_order2 RETURN VARCHAR2;
153 --
154 FUNCTION get_payslip_sort_order3 RETURN VARCHAR2;
155 --
156 --
157
158 PROCEDURE payslip_range_cursor(p_pactid in number
159 ,p_sqlstr out NOCOPY varchar2);
160
161 PROCEDURE get_custom_xml_routine(p_document_type in varchar2
162 ,p_xml_routine out NOCOPY varchar2);
163
164 END PAY_US_RULES;