1 PACKAGE PAY_US_ELEMENT_ENTRY_HOOK AS
2 /* $Header: pyuseehd.pkh 120.0 2005/09/29 14:07:24 vmehta noship $ */
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 Name : PAY_US_ELEMENT_ENTRY_HOOK
21 File Name : pyuseehd.pkb
22
23 Description : This package is called from the AFTER INSERT/UPDATE/DELETE
24 User Hooks. The following are the functionalities present
25 in User Hook
26
27 1. Create/Update/Delete Recurring Element Entries for
28 Augment Elements
29 2. Create Tax Records for the Employee if Jurisdiction
30 code is entered.
31
32 Change List
33 -----------
34 Name Date Version Bug Text
35 -------------- ----------- ------- ------- -----------------------------
36 kvsankar 26-JUL-2005 115.2 Included New Global
37 Variables for Penny issue
38 kvsankar 20-JUL-2005 115.1 Modified dbdrv
39 kvsankar 19-JUL-2005 115.0 FLSA Created
40 ******************************************************************************/
41
42 type number_table is table of number not null
43 index by binary_integer;
44 type varchar2_table is table of varchar2(80)
45 index by binary_integer;
46 type date_table is table of date
47 index by binary_integer;
48
49 -- Global Variables used in the package
50 gd_start_date_tbl date_table;
51 gd_end_date_tbl date_table;
52 gn_link_id_tbl number_table;
53 gn_ele_ent_num number;
54 gn_daily_amount number;
55
56 /******************************************************************************
57 Name : INSERT_USER_HOOK (After Insert User Hook Call)
58 User Hook Type : This is AFTER INSERT Row Level handler User Hook and is
59 called from user hook provided in HR_ENTRY_API.
60 (PAY_ELE_RKI.AFTER_INSERT)
61 Description : This is a generalized USER HOOK at Element Entry level.
62 Any functionality to be implemented via Element User Hook
63 can be added in this User Hook as a Procedural call to a
64 procedure implemented in this package.
65 ******************************************************************************/
66 PROCEDURE INSERT_USER_HOOK(
67 p_element_entry_id in number
68 ,p_effective_start_date in date
69 ,p_effective_end_date in date
70 ,p_assignment_id in number
71 ,p_element_link_id in number
72 ,p_original_entry_id in number
73 ,p_creator_type in varchar2
74 ,p_entry_type in varchar2
75 ,p_entry_information_category in varchar2);
76
77 /******************************************************************************
78 Name : UPDATE_USER_HOOK (After Update User Hook Call)
79 User Hook Type : This is AFTER UPDATE Row Level handler User Hook and is
80 called from user hook provided in HR_ENTRY_API.
81 (PAY_ELE_RKU.AFTER_UPDATE)
82 Description : This is a generalized USER HOOK at Element Entry level.
83 Any functionality to be implemented via Element User Hook
84 can be added in this User Hook as a Procedural call to a
85 procedure implemented in this package.
86 ******************************************************************************/
87 PROCEDURE UPDATE_USER_HOOK(
88 p_element_entry_id in number
89 ,p_effective_start_date in date
90 ,p_effective_end_date in date
91 ,p_assignment_id_o in number
92 ,p_element_link_id_o in number
93 ,p_original_entry_id_o in number
94 ,p_creator_type_o in varchar2
95 ,p_entry_type_o in varchar2
96 ,p_entry_information_category_o in varchar2);
97
98 /******************************************************************************
99 Name : DELETE_USER_HOOK (After Delete User Hook Call)
100 User Hook Type : This is AFTER DELETE Row Level handler User Hook and is
101 called from user hook provided in HR_ENTRY_API.
102 (PAY_ELE_RKD.AFTER_DELETE)
103 Description : This is a generalized USER HOOK at Element Entry level.
104 Any functionality to be implemented via Element User Hook
105 can be added in this User Hook as a Procedural call to a
106 procedure implemented in this package.
107 ******************************************************************************/
108 PROCEDURE DELETE_USER_HOOK(
109 p_element_entry_id in number
110 ,p_effective_start_date in date
111 ,p_effective_end_date in date
112 ,p_assignment_id_o in number
113 ,p_element_link_id_o in number
114 ,p_original_entry_id_o in number
115 ,p_creator_type_o in varchar2
116 ,p_entry_type_o in varchar2
117 ,p_entry_information_category_o in varchar2);
118
119 END PAY_US_ELEMENT_ENTRY_HOOK;