PACKAGE: APPS.FPA_PORTFOLIO_PVT

Source

1 PACKAGE FPA_PORTFOLIO_PVT as
2 /* $Header: FPAVPTFS.pls 120.1 2005/08/18 11:47:23 appldev noship $ */
3 
4 TYPE portfolio_rec_type IS RECORD
5 (
6 
7     portfolio_id            VARCHAR2(30),
8     portfolio_name          VARCHAR2(55),
9     portfolio_desc          VARCHAR2(240),
10     Portfolio_owner_id      VARCHAR2(30),
11     portfolio_type          VARCHAR2(30),
12     Portfolio_start_org_id  Varchar2(30)
13 );
14 
15 
16    PROCEDURE Create_Portfolio
17      (
18     	p_api_version		IN		NUMBER,
19 	    p_portfolio_rec		IN		FPA_Portfolio_PVT.portfolio_rec_type,
20 	    x_portfolio_id	    OUT NOCOPY	VARCHAR2,
21 	    x_return_status		OUT NOCOPY	VARCHAR2,
22 	    x_msg_data			OUT NOCOPY	VARCHAR2,
23 	    x_msg_count			OUT NOCOPY	NUMBER
24 	);
25 
26   PROCEDURE Delete_Portfolio
27      (
28        p_api_version		IN		    NUMBER,
29        p_portfolio_id       IN          NUMBER,
30        x_return_status		OUT NOCOPY	VARCHAR2,
31 	   x_msg_data			OUT NOCOPY	VARCHAR2,
32 	   x_msg_count			OUT NOCOPY	NUMBER
33     ) ;
34 
35 
36    PROCEDURE Upadate_Portfolio_Descr
37         (
38 	    p_api_version		IN		NUMBER,
39 	    p_portfolio_rec		IN		FPA_Portfolio_PVT.portfolio_rec_type,
40 	    x_return_status		OUT NOCOPY	VARCHAR2,
41 	    x_msg_data			OUT NOCOPY	VARCHAR2,
42 	    x_msg_count			OUT NOCOPY	NUMBER
43 	    );
44 
45     PROCEDURE Upadate_Portfolio_type
46         (
47         p_api_version		    IN		NUMBER,
48   	    p_portfolio_id          IN      NUMBER,
49   	    p_portfolio_class_code	IN		NUMBER,
50 	    x_return_status		    OUT NOCOPY	VARCHAR2,
51 	    x_msg_data			    OUT NOCOPY	VARCHAR2,
52 	    x_msg_count			    OUT NOCOPY	NUMBER
53 	    );
54 
55       PROCEDURE Upadate_Portfolio_organization
56         (
57 	    p_api_version		        IN		NUMBER,
58 	    p_portfolio_id              IN      NUMBER,
59   	    p_portfolio_organization	IN		NUMBER,
60 	    x_return_status		        OUT NOCOPY	VARCHAR2,
61 	    x_msg_data			        OUT NOCOPY	VARCHAR2,
62 	    x_msg_count			        OUT NOCOPY	NUMBER
63 	    );
64 
65 
66 
67    FUNCTION Check_Portfolio_name
68      (
69        p_api_version		IN		    NUMBER,
70        p_portfolio_id       IN          NUMBER,
71        p_portfolio_name		IN		    VARCHAR2,
72 	   x_return_status		OUT NOCOPY	VARCHAR2,
73 	   x_msg_data			OUT NOCOPY	VARCHAR2,
74 	   x_msg_count			OUT NOCOPY	NUMBER
75     ) RETURN NUMBER;
76 
77 
78 
79 
80 
81 END; -- Package spec