[Home] [Help]
PACKAGE: APPS.BEN_EXT_SMART_TOTAL
Source
1 Package ben_ext_smart_total AUTHID CURRENT_USER as
2 /* $Header: benxsttl.pkh 120.0 2005/05/28 09:47:50 appldev noship $ */
3 --------------------------------------------------------------------------------
4 /*
5 +==============================================================================+
6 | Copyright (c) 1997 Oracle Corporation |
7 | Redwood Shores, California, USA |
8 | All rights reserved. |
9 +==============================================================================+
10 --
11 Name
12 Benefit Extract Smart Totals
13 Purpose
14 This package is for totals in the header/trailer
15 History
16 Date Version Who What?
17 11/16/98 115.0 YRathman/PDas Created.
18 12/09/98 115.1 PDas Modified Calc_Smart_Total
19 Procedure
20 12/28/98 115.2 PDas Added get_value procedure
21 02/08/99 115.3 PDas Moved function get_value to benxutil.pkh
22 02/10/99 115.4 PDas Modified Calc_Smart_Total
23 Procedure
24 - added p_frmt_mask_cd paramater
25 10/1/99 115.5 Thayden Added multiple conditions.
26 12/23/02 115.6 Lakrish NOCOPY changes
27 03/22/05 115.6 tjesumic new parameter group_val_01,02 added for
28 sub grouping calcaultion for subheader
29 */
30 --
31 --
32 g_package varchar2(33) := ' ben_ext_smart_total'; -- Global package name
33 --
34 Procedure calc_smart_total(p_ext_rslt_id in number,
35 p_ttl_fnctn_cd in varchar2,
36 p_ttl_sum_ext_data_elmt_id in number,
37 p_ttl_cond_ext_data_elmt_id in number,
38 p_ext_data_elmt_id in number,
39 p_frmt_mask_cd in varchar2,
40 p_ext_file_id in number,
41 p_business_group_id in number,
42 p_group_val_01 in varchar2 default null ,
43 p_group_val_02 in varchar2 default null,
44 p_smart_total out nocopy varchar2
45 );
46 --
47 end ben_ext_smart_total;