[Home] [Help]
PACKAGE: APPS.BEN_TCS_COMPENSATION
Source
1 PACKAGE BEN_TCS_COMPENSATION AUTHID CURRENT_USER as
2 /* $Header: betcscmp.pkh 120.2 2006/04/12 04:49 srangasa noship $ */
3
4 TYPE period_rec IS
5 RECORD ( start_date date,
6 end_date date,
7 value varchar2(2000),
8 currency_cd varchar2(30),
9 uom varchar2(30),
10 creator_type varchar2(2000),
11 output_key number,
12 actual_uom varchar2(30)
13 );
14
15 TYPE period_table IS TABLE OF period_rec
16 INDEX BY BINARY_INTEGER;
17
18 procedure get_value_for_item(p_source_cd in varchar2,
19 p_source_key in varchar2,
20 p_perd_st_dt in date,
21 p_perd_en_dt in date,
22 p_person_id in number,
23 p_assignment_id in number,
24 p_effective_date in date,
25 p_comp_typ_cd in varchar2,
26 p_currency_cd in varchar2,
27 p_uom in varchar2,
28 p_result out nocopy period_table,
29 p_status out nocopy varchar2);
30 end BEN_TCS_COMPENSATION;