[Home] [Help]
PACKAGE: APPS.PER_PERFRALC_PKG
Source
1 PACKAGE PER_PERFRALC_PKG AUTHID CURRENT_USER AS
2 /*$Header: perfralc.pkh 115.7 2002/11/25 15:56:20 sfmorris ship $*/
3
4 procedure run_process (errbuf out nocopy varchar2,
5 retcode out nocopy number,
6 P_BUSINESS_GROUP_ID in number,
7 P_APPLICATION_ID in number,
8 P_LOOKUP_TYPE in varchar2,
9 P_ROW_TITLE in varchar2,
10 P_FUNCTION_TYPE in varchar2,
11 P_REQUIRED_DEFAULTS in varchar2,
12 P_DEFAULT_VALUE in varchar2,
13 P_LEGISLATION_CODE in varchar2 default null);
14
15
16 -- Procedure clean_pay_tables
17 -- Parameters are : Business_group_id (mandatory)
18 -- : (lookup) table_name (mandatory)
19 procedure clean_pay_tables
20 (cn_business_group_id IN per_business_groups.business_group_id%TYPE,
21 cp_user_table_name IN pay_user_tables.user_table_name%TYPE);
22
23
24
25 -- Procedure Update_instance_value
26 -- parameters are : Business_group (optional)
27 -- Legislation_Code (optional)
28 -- (Lookup) table_name
29 -- Alternative Lookup column_name
30 -- Instance_name
31 -- value to be updated for the instance
32 Procedure Update_Instance_value
33 (cn_business_group_id IN per_business_groups.business_group_id%TYPE,
34 cp_legislation_code IN per_business_groups.legislation_code%TYPE,
35 cp_user_table_name IN pay_user_tables.user_table_name%TYPE ,
36 cp_user_column_name IN pay_user_columns.user_column_name%TYPE ,
37 cp_row_name IN pay_user_rows_f.row_low_range_or_name%TYPE ,
38 cp_value IN pay_user_column_instances_f.value%TYPE);
39
40 end PER_PERFRALC_PKG;