1 PACKAGE PAY_US_RULES as
2 /* $Header: pyusrule.pkh 120.6.12010000.1 2008/07/27 23:56:15 appldev 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 *****************************************************************************/
55
56 /****************************************************************************
57 Name : GET_DEFAULT_JUSRIDICTION
58 Description : This function returns the default jurisdiction code which is
59 used for involuntary deduction elements if the end user does
60 not specify jurisdiction input value.
61 *****************************************************************************/
62
63 PROCEDURE get_default_jurisdiction(p_asg_act_id number,
64 p_ee_id number,
65 p_jurisdiction in out nocopy varchar2);
66
67 l_pkg_name varchar2(20);
68
69 -- GLOBAL VARIABLE ADDED
70 lrec pay_ele_tmplt_obj;
71 -- For Procedure get_time_def_for_entry
72 g_current_asg_id NUMBER;
73 g_current_time_def_id NUMBER;
74 g_get_time_def_flag BOOLEAN;
75
76 FUNCTION element_template_pre_process (p_rec IN pay_ele_tmplt_obj)
77 RETURN pay_ele_tmplt_obj;
78
79
80 PROCEDURE element_template_upd_user_stru (p_element_template_id IN NUMBER);
81
82 PROCEDURE element_template_post_process (p_element_template_id IN NUMBER);
83
84 PROCEDURE delete_pre_process(p_element_template_id IN NUMBER);
85
86 PROCEDURE delete_post_process(p_element_template_id IN NUMBER);
87
88 FUNCTION get_obj_id(p_business_group_id IN NUMBER
89 ,p_legislation_code IN VARCHAR2
90 ,p_object_type IN VARCHAR2
91 ,p_object_name IN VARCHAR2
92 ,p_object_id IN NUMBER DEFAULT NULL)
93 RETURN NUMBER;
94
95 FUNCTION work_schedule_total_hours( assignment_action_id IN NUMBER --Context
96 ,assignment_id IN NUMBER --Context
97 ,p_bg_id in NUMBER -- Context
98 ,element_entry_id IN NUMBER --Context
99 ,date_earned IN DATE
100 ,p_range_start IN DATE
101 ,p_range_end IN DATE)
102 RETURN NUMBER ;
103
104 PROCEDURE get_time_def_for_entry (
105 p_element_entry_id IN NUMBER,
106 p_assignment_id IN NUMBER,
107 p_assignment_action_id IN NUMBER,
108 p_business_group_id IN NUMBER,
109 p_time_definition_id IN OUT NOCOPY VARCHAR2
110 );
111
112 FUNCTION get_time_def_for_entry_func(
113 p_element_entry_id IN NUMBER,
114 p_assignment_id IN NUMBER,
115 p_assignment_action_id IN NUMBER,
116 p_business_group_id IN NUMBER,
117 p_time_def_date IN DATE
118 ) RETURN NUMBER;
119
120 pragma restrict_references(get_time_def_for_entry_func, WNDS, WNPS);
121
122 -- Converting Numeric Amounts to Words (To be Displayed on Check Writer)
123 FUNCTION convert_number(IN_NUMERAL INTEGER := 0) RETURN VARCHAR2 ;
124 FUNCTION get_word_value (P_AMOUNT NUMBER) RETURN VARCHAR2 ;
125 FUNCTION CF_word_amountFormula(CP_LN_AMOUNT IN NUMBER) RETURN VARCHAR2 ;
126
127 PROCEDURE add_custom_xml( P_ASSIGNMENT_ACTION_ID IN NUMBER ,
128 P_ACTION_INFORMATION_CATEGORY IN VARCHAR2,
129 P_DOCUMENT_TYPE IN VARCHAR2);
130 -- Added Procedure get_token_names to be used by Global Payslip Printing
131 -- Solution pay_payslip_report.xml_asg
132 procedure get_token_names(p_pa_token out nocopy varchar2
133 ,p_cs_token out nocopy varchar2);
134
135 END PAY_US_RULES;