DBA Data[Home] [Help]

PACKAGE: APPS.AMW_LOAD_AP_DATA

Source


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;