1 PACKAGE HXC_US_TIME_DEFINITIONS_HOOK AS
2 /* $Header: hxcusottd.pkh 120.1 2006/09/20 17:48:35 asasthan 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 : HXC_US_TIME_DEFINITIONS_HOOK
21 File Name : hxcusottd.pkh
22
23 Description : The package is called from the following places:
24 1. After Insert Row Handler User Hook Call on
25 HXC_PREF_HIERARCHIES
26 2. After Update Row Handler User Hook Call on
27 HXC_PREF_HIERARCHIES
28 3. After Update Row Handler User Hook Call on
29 HXC_RECURRING_PERIODS
30 4. Before Process Business Process User Hook Call
31 on UPDATE_TIME_DEFINITION
32
33 I. The package Creates/Updates rows in pay_time_definitions
34 and per_time_periods as and when rows are created/updated
35 in HXC_PREF_HIERARCHIES
36 II. The package Updates a row in pay_time_definitions as and
37 when a row is updated in HXC_RECURRING_PERIODS
38
39 Change List
40 -----------
41 Name Date Version Bug Text
42 -------------- ----------- ------- ------- -----------------------------
43 rdhingra 24-Jan-2006 115.0 FLSA Created
44 rdhingra 25-Jan-2006 115.1 FLSA Updated dbdrv: checkfile to
45 refer to correct sql
46 rdhingra 25-Jan-2006 115.2 FLSA Changing dbdrv lines as per
47 the recommendations of the
48 release team
49
50 asasthan 20-Sep-2006 115.3 FLSA Changed associated filename
51
52
53 ******************************************************************************/
54 /*Global Variables*/
55 g_from_otl VARCHAR2(1);
56
57 /******************************************************************************
58 Name : INSERT_USER_HOOK_HIERARCHY (After Update User Hook Call)
59 User Hook Type : This is an AFTER INSERT Row Level handler User Hook
60 and is called from user hook provided in
61 HXC_PREF_HIERARCHIES_API.
62 Description : This USER HOOK will only be called from OTL to insert a
63 row in pay_time_definitions
64 ******************************************************************************/
65 PROCEDURE INSERT_USER_HOOK_HIERARCHY(
66 p_business_group_id IN NUMBER
67 ,p_legislation_code IN VARCHAR2 DEFAULT NULL
68 ,p_attribute_category IN VARCHAR2 DEFAULT NULL
69 ,p_attribute1 IN VARCHAR2 DEFAULT NULL
70 ,p_attribute2 IN VARCHAR2 DEFAULT NULL
71 ,p_attribute3 IN VARCHAR2 DEFAULT NULL
72 );
73
74 /******************************************************************************
75 Name : UPDATE_USER_HOOK_HIERARCHY (After Update User Hook Call)
76 User Hook Type : This is an AFTER UPDATE Row Level handler User Hook and is
77 called from user hook provided in
78 HXC_PREF_HIERARCHIES_API.
79 Description : This USER HOOK will only be called from OTL to insert a
80 row in pay_time_definitions
81 ******************************************************************************/
82 PROCEDURE UPDATE_USER_HOOK_HIERARCHY(
83 p_business_group_id IN NUMBER
84 ,p_legislation_code IN VARCHAR2 DEFAULT NULL
85 ,p_attribute_category IN VARCHAR2 DEFAULT NULL
86 ,p_attribute1 IN VARCHAR2 DEFAULT NULL
87 ,p_attribute2 IN VARCHAR2 DEFAULT NULL
88 ,p_attribute3 IN VARCHAR2 DEFAULT NULL
89 );
90
91 /******************************************************************************
92 Name : UPDATE_USER_HOOK_RECURRING (After Update User Hook Call)
93 User Hook Type : This is an AFTER UPDATE Row Level handler User Hook and is
94 called from user hook provided in
95 HXC_RECURRING_PERIODS_API.
96 Description : This USER HOOK will only be called from OTL to update
97 the name in pay_time_definitions
98 ******************************************************************************/
99 PROCEDURE UPDATE_USER_HOOK_RECURRING(
100 p_recurring_period_id IN NUMBER
101 ,p_name IN VARCHAR2
102 );
103
104 /******************************************************************************
105 Name : UPDATE_USER_HOOK_TIMEDEF (Before Process User Hook Call)
106 User Hook Type : This is an Before Process Business Process User Hook and is
107 called from user hook provided in
108 PAY_TIME_DEFINITION_API.
109 Description : This USER HOOK will be called from when a row is getting
110 updated in pay_time_definitions
111 ******************************************************************************/
112 PROCEDURE UPDATE_USER_HOOK_TIMEDEF(
113 p_time_definition_id IN NUMBER
114 ,p_definition_name IN VARCHAR2
115 ,p_period_type IN VARCHAR2
116 ,p_start_date IN DATE
117 ,p_period_time_definition_id IN NUMBER
118 ,p_creator_id IN NUMBER
119 ,p_creator_type IN VARCHAR2
120 );
121
122
123 END HXC_US_TIME_DEFINITIONS_HOOK;