[Home] [Help]
PACKAGE: APPS.BEN_EXT_FMT
Source
1 Package ben_ext_fmt as
2 /* $Header: benxfrmt.pkh 120.0.12000000.1 2007/01/19 19:25:00 appldev noship $ */
3 --
4 --
5 -- ----------------------------------------------------------------------------
6 -- |------------------------< process_ext_recs >------------------------------|
7 -- ----------------------------------------------------------------------------
8 --
9 g_person_id number(15);
10 g_elmt_name ben_ext_data_elmt.name%type ;
11 --
12 --
13 TYPE ValTabTyp IS varray(300) Of ben_Ext_rslt_dtl.val_01%type ;
14 --
15 g_val_tab ValTabTyp;
16 --
17 Procedure process_ext_recs(p_ext_rslt_id in number,
18 p_ext_file_id in number,
19 p_data_typ_cd in varchar2,
20 p_ext_typ_cd in varchar2,
21 p_rcd_typ_cd in varchar2,
22 p_low_lvl_cd in varchar2 default null,
23 p_person_id in number default null,
24 p_chg_evt_cd in varchar2 default null,
25 p_business_group_id in number,
26 p_ext_per_bg_id in number default null ,
27 p_effective_date in date
28 );
29 --
30 function get_error_msg(p_err_no in number ,
31 p_err_name in varchar2 ,
32 p_token1 in varchar2 default null,
33 p_token2 in varchar2 default null ) return varchar2 ;
34 --
35 Function apply_format_mask(p_value date, p_format_mask varchar2
36 )Return Varchar2;
37 --
38 Function apply_format_mask(p_value number, p_format_mask varchar2
39 ) Return Varchar2;
40 --
41 Function apply_format_mask(p_value varchar2, p_format_mask varchar2
42 ) Return Varchar2;
43 --
44 Function apply_format_function(p_value varchar2, p_format_mask varchar2
45 ) Return Varchar2;
46 --
47
48 Function apply_decode(p_value varchar2,
49 p_ext_data_elmt_id number,
50 p_default varchar2,
51 p_short_name varchar2 default null
52 ) Return Varchar2;
53 --
54 Function sprs_or_incl(p_ext_rcd_in_file_id number,
55 p_ext_data_elmt_in_rcd_id number,
56 p_chg_evt_cd varchar2
57 ) Return Varchar2;
58
59
60 function Calculate_calc_value
61 (p_firtst_value in number
62 ,p_second_value in number
63 ,p_calc in varchar2 )
64 return number ;
65
66 --
67 function get_element_value
68 (
69 p_seq_num number
70 , p_ext_data_elmt_id number
71 , p_data_elmt_typ_cd varchar2
72 , p_name varchar2
73 , p_frmt_mask_cd varchar2
74 , p_dflt_val varchar2
75 , p_short_name varchar2
76 , p_two_char_substr varchar2
77 , p_one_char_substr varchar2
78 , p_lookup_type varchar2
79 , p_frmt_mask_lookup_cd varchar2 default null
80 ) return varchar2 ;
81 --
82 --
83 end ben_ext_fmt;