[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
02/03/99 115.3 PDas Deleted date and
enabled_flag check for hr_lookups
02/08/99 115.4 PDas Moved function get_value to benxutil.pkb
02/10/99 115.5 PDas Modified Calc_Smart_Total
Procedure
- added p_frmt_mask_cd paramater
02/16/99 115.6 PDas Modified Calc_Smart_Total
08/06/99 115.7 ASen Added messages : Entering, Exiting.
10/03/99 115.8 Thayden Rewrote to handle multiple conditions.
01/04/99 115.9 Thayden Fixed format mask bugs.
02/24/00 115.10 Shdas changed the dynamic sql for calculating
smart totals.
01/30/01 115.11 tilak error message is changed , the messages is
sent instead of the name
08/10/01 115.12 ikasire Bug 1928211 changed the l_smart_ttl_string
as per the details in bug resolution
02/10/02 115.13 tjesumic Fraction Amount is not taken care in
SUM function . added in translation - 2012562
02/10/02 115.14 tjesumic dbdrv fixed
03/13/02 115.15 ikasire UTF8 Changes
12/23/02 115.16 lakrish NOCOPY changes
12/23/02 115.17 tjesumic closing ')' moved below the lop
# 2729093
06/14/04 115.18 tjesumic 3691826 fixed by creating str with format mask
06/15/04 115.19 tjesumic 3691826
03/22/05 115.20 tjesumic new parameter group_val_01,02 added for
sub grouping calcaultion for subheader
10/10/06 115.21 tjesumic ben_Ext_frmt,format_mask function called to
apply the format maks so {} format are taken care
*/
--
--
-- ----------------------------------------------------------------------------
-- |-------------------------< get_where_params >------------------------------|
-- ----------------------------------------------------------------------------
--
-- This procedure finds the necessary column in ben_ext_rslt_dtl
-- for where clause
--
Procedure get_where_params(p_ext_rcd_id in number,
p_cond_ext_data_elmt_id in number,
p_data_elmt_seq_num out nocopy varchar2
) IS
--
l_proc varchar2(72) := g_package||'.get_where_params';
SELECT xdr.seq_num
FROM ben_ext_data_elmt_in_rcd xdr
WHERE xdr.ext_data_elmt_id = p_cond_ext_data_elmt_id
and xdr.ext_rcd_id = p_ext_rcd_id;
SELECT c.seq_num,
d.frmt_mask_cd
FROM ben_ext_data_elmt_in_rcd c,
ben_ext_data_elmt d
WHERE c.ext_rcd_id = p_ext_rcd_id
AND c.ext_data_elmt_id = p_ttl_sum_ext_data_elmt_id
AND d.ext_data_elmt_id = c.ext_data_elmt_id;
SELECT meaning
FROM hr_lookups
WHERE lookup_type = 'BEN_EXT_FRMT_MASK'
AND lookup_code = l_frmt_mask_cd;
select xwc.oper_cd,
xwc.val,
xwc.and_or_cd,
xwc.cond_ext_data_elmt_id
from ben_ext_where_clause xwc
where xwc.ext_data_elmt_id = p_ext_data_elmt_id
order by xwc.seq_num;
l_smart_ttl_string := 'select to_char(sum(to_number(
translate(replace(val_'||l_sum_column||',
'';'',''''),''0123456789''||replace(translate(val_'||
l_smart_ttl_string := 'select to_char(sum(to_number(
translate(replace(val_'||l_sum_column||',
'';'',''''),''-0123456789.''||replace(translate(val_'||
l_smart_ttl_string := 'select (sum(to_number(val_'||l_sum_column||', '''|| l_sum_col_frmt_mask|| ''')))'||
' from ben_ext_rslt_dtl'
|| l_where_string;
l_smart_ttl_string := 'select to_char(count(*)) from ben_ext_rslt_dtl'||
l_where_string;