PACKAGE: APPS.XDP_PROCEDURE_UTIL

Source

1 PACKAGE XDP_PROCEDURE_UTIL  AUTHID CURRENT_USER AS
2 /* $Header: XDPPUTLS.pls 120.1 2005/06/16 02:27:01 appldev  $ */
3 
4   Function Get_Package_Spec(
5 	p_proc_type IN VARCHAR2) return varchar2;
6 
7   PROCEDURE Create_Package_Spec(
8 	p_proc_name IN VARCHAR2,
9 	p_proc_type IN VARCHAR2,
10 	return_code  OUT NOCOPY NUMBER,
11 	error_string OUT NOCOPY VARCHAR2);
12 
13   PROCEDURE Create_Package_Body(
14 	p_proc_name IN VARCHAR2,
15 	p_proc_type IN VARCHAR2,
16         p_FaID    in NUMBER,
17         p_FeTypeID    in NUMBER,
18 	p_proc_body IN VARCHAR2,
19 	return_code  OUT NOCOPY NUMBER,
20 	error_string OUT NOCOPY VARCHAR2);
21 
22   PROCEDURE Load_Proc_Table(
23 	p_proc_name IN VARCHAR2,
24 	p_proc_type IN VARCHAR2,
25 	p_proc_body IN VARCHAR2,
26 	return_code  OUT NOCOPY NUMBER,
27 	error_string OUT NOCOPY VARCHAR2);
28 
29   PROCEDURE Rollback_Proc(
30 	p_proc_name IN VARCHAR2,
31 	p_proc_type IN VARCHAR2,
32 	p_FaID  IN NUMBER,
33 	p_FeTypeID  IN NUMBER,
34 	return_code OUT NOCOPY NUMBER,
35 	error_string OUT NOCOPY VARCHAR2);
36 
37   procedure get_package_name(p_proc_name IN VARCHAR2,
38                              p_package_name  OUT NOCOPY varchar2,
39                              return_code  OUT NOCOPY NUMBER,
40                              error_string OUT NOCOPY VARCHAR2);
41 
42 function decode_proc_name (ProcName in varchar2) return varchar2;
43 
44 END;