1 PACKAGE PAY_USER_COLUMN_INSTANCES_PKG AUTHID CURRENT_USER AS
2 /* $Header: pyusi01t.pkh 115.0 99/07/17 06:44:40 porting ship $ */
3 --
4 --
5 procedure insert_row(p_rowid in out varchar2,
6 p_user_column_instance_id in out number,
7 p_effective_start_date in date,
8 p_effective_end_date in date,
9 p_user_row_id in number,
10 p_user_column_id in number,
11 p_business_group_id in number,
12 p_legislation_code in varchar2,
13 p_legislation_subgroup in varchar2,
14 p_value in varchar2 ) ;
15 --
16 procedure update_row(p_rowid in varchar2,
17 p_user_column_instance_id in number,
18 p_effective_start_date in date,
19 p_effective_end_date in date,
20 p_user_row_id in number,
21 p_user_column_id in number,
22 p_business_group_id in number,
23 p_legislation_code in varchar2,
24 p_legislation_subgroup in varchar2,
25 p_value in varchar2 ) ;
26 --
27 procedure delete_row(p_rowid in varchar2) ;
28 --
29 procedure lock_row (p_rowid in varchar2,
30 p_user_column_instance_id in number,
31 p_effective_start_date in date,
32 p_effective_end_date in date,
33 p_user_row_id in number,
34 p_user_column_id in number,
35 p_business_group_id in number,
36 p_legislation_code in varchar2,
37 p_legislation_subgroup in varchar2,
38 p_value in varchar2 ) ;
39 --
40 -- For the given user row return the latest end date. Used by DateTrack
41 -- for checking inserts and deletes
42 function latest_end_date ( p_user_row_id in number ) return date ;
43 --
44 END PAY_USER_COLUMN_INSTANCES_PKG ;