1 PACKAGE AMW_LOAD_AP_DATA AUTHID CURRENT_USER AS
2 /* $Header: amwaplds.pls 120.0 2005/05/31 22:21:46 appldev noship $ */
3
4 PROCEDURE create_audit_procedures (
5 ERRBUF OUT NOCOPY VARCHAR2
6 ,RETCODE OUT NOCOPY VARCHAR2
7 ,p_batch_id IN NUMBER
8 ,p_user_id IN NUMBER
9 );
10
11 PROCEDURE update_interface_with_error (
12 p_err_msg IN VARCHAR2
13 ,p_table_name IN VARCHAR2
14 ,p_interface_id IN NUMBER
15 );
16
17 ---
18 ---03.01.2005 npanandi: add Audit Procedure Owner privilege here for data security
19 ---
20 procedure add_owner_privilege(
21 p_role_name in varchar2
22 ,p_object_name in varchar2
23 ,p_grantee_type in varchar2
24 ,p_instance_set_id in number default null
25 ,p_instance_pk1_value in varchar2
26 ,p_instance_pk2_value in varchar2 default null
27 ,p_instance_pk3_value in varchar2 default null
28 ,p_instance_pk4_value in varchar2 default null
29 ,p_instance_pk5_value in varchar2 default null
30 ,p_user_id in number
31 ,p_start_date in date default sysdate
32 ,p_end_date in date default null);
33
34 ---
35 ---03.01.2005 npanandi: function to check access privilege for this Audit Procedure
36 ---
37 function check_function(
38 p_function in varchar2
39 ,p_object_name in varchar2
40 ,p_instance_pk1_value in number
41 ,p_instance_pk2_value in number default null
42 ,p_instance_pk3_value in number default null
43 ,p_instance_pk4_value in number default null
44 ,p_instance_pk5_value in number default null
45 ,p_user_id in number) return varchar2;
46 END amw_load_ap_data;