DBA Data[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;