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