DBA Data[Home] [Help]

PACKAGE: APPS.PAY_US_ELEMENT_ENTRY_HOOK

Source


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;