1 PACKAGE PAY_US_BALANCE_FEEDS_HOOK AS
2 /* $Header: pyuspbfr.pkh 120.0 2006/03/05 22:07:13 rdhingra 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_BALANCE_FEEDS_HOOK
21 File Name : pyuspbfr.pkb
22
23 Description : This package is called from the AFTER INSERT User Hook.
24 The following are the functionalities present in this
25 User Hook
26
27 1. Puts time_definition_type as 'G' in pay_element_types_f
28 whenever that element feeds a balance for which defined
29 balance exists with dimensions:
30 _ASG_GRE_TD_RUN
31 _ASG_GRE_TD_BD_RUN
32
33 Change List
34 -----------
35 Name Date Version Bug Text
36 -------------- ----------- ------- ------- -----------------------------
37 rdhingra 06-MAR-2006 115.0 5073515 Created
38
39 ******************************************************************************/
40
41
42 /******************************************************************************
43 Name : INSERT_USER_HOOK (After Insert User Hook Call)
44 User Hook Type : This is AFTER INSERT Row Level handler User Hook and is
45 called from user hook provided in PAY_BALANCE_FEEDS_API.
46 (PAY_PBF_RKI.AFTER_INSERT)
47 Description : This is a generalized USER HOOK at Balance Feeds level.
48 Any functionality to be implemented via Balance Feeds User
49 Hook can be added in this User Hook as a Procedural call
50 to a procedure implemented in this package.
51 ******************************************************************************/
52 PROCEDURE INSERT_USER_HOOK(
53 p_effective_date IN DATE
54 ,p_balance_type_id IN NUMBER
55 ,p_input_value_id IN NUMBER
56 ,p_scale IN NUMBER DEFAULT NULL
57 ,p_business_group_id IN NUMBER DEFAULT NULL
58 ,p_legislation_code IN VARCHAR2 DEFAULT NULL
59 );
60
61
62 END PAY_US_BALANCE_FEEDS_HOOK;