1 PACKAGE fpa_planningcycle_pvt as
2 /* $Header: FPAVPCPS.pls 120.2 2005/11/09 15:35:30 appldev ship $ */
3 --
4 -- To modify this template, edit file PKGSPEC.TXT in TEMPLATE
5 -- directory of SQL Navigator
6 --
7 -- Purpose: Briefly explain the functionality of the package
8 --
9 -- MODIFICATION HISTORY
10 -- Person Date Comments
11 --Monika Bansal
12 -- --------- ------ ------------------------------------------
13 -- Enter package declarations as shown below
14
15 PROCEDURE Create_Pc
16 ( p_api_version IN NUMBER,
17 p_pc_all_obj IN fpa_pc_all_obj,
18 x_planning_cycle_id OUT NOCOPY NUMBER,
19 x_return_status OUT NOCOPY VARCHAR2,
20 x_msg_data OUT NOCOPY VARCHAR2,
21 x_msg_count OUT NOCOPY NUMBER );
22
23 PROCEDURE Update_Pc_Invest_Mix
24 ( p_api_version IN NUMBER,
25 p_inv_matrix IN fpa_pc_inv_matrix_tbl,
26 x_return_status OUT NOCOPY VARCHAR2,
27 x_msg_data OUT NOCOPY VARCHAR2,
28 x_msg_count OUT NOCOPY NUMBER );
29
30 PROCEDURE Update_Pc_Fin_Targets
31 ( p_api_version IN NUMBER,
32 p_fin_targets_tbl IN fpa_pc_fin_targets_tbl,
33 x_return_status OUT NOCOPY VARCHAR2,
34 x_msg_data OUT NOCOPY VARCHAR2,
35 x_msg_count OUT NOCOPY NUMBER );
36
37 PROCEDURE Update_Pc_Inv_Criteria_Data
38 ( p_api_version IN NUMBER,
39 p_inv_crit_tbl IN fpa_pc_inv_criteria_tbl,
40 x_return_status OUT NOCOPY VARCHAR2,
41 x_msg_data OUT NOCOPY VARCHAR2,
42 x_msg_count OUT NOCOPY NUMBER );
43
44 PROCEDURE Update_Pc_Desc_Fields
45 ( p_api_version IN NUMBER,
46 p_pc_all_obj IN fpa_pc_all_obj,
47 x_return_status OUT NOCOPY VARCHAR2,
48 x_msg_data OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY NUMBER );
50
51 PROCEDURE Update_Pc_Class_Category
52 ( p_api_version IN NUMBER,
53 p_pc_id IN NUMBER,
54 p_catg_id IN NUMBER,
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_data OUT NOCOPY VARCHAR2,
57 x_msg_count OUT NOCOPY NUMBER );
58
59
60 PROCEDURE Update_Pc_Calendar
61 ( p_api_version IN NUMBER,
62 p_pc_info IN fpa_pc_info_obj,
63 x_return_status OUT NOCOPY VARCHAR2,
64 x_msg_data OUT NOCOPY VARCHAR2,
65 x_msg_count OUT NOCOPY NUMBER );
66
67 PROCEDURE Update_Pc_Currency
68 ( p_api_version IN NUMBER,
69 p_pc_info IN fpa_pc_info_obj,
70 x_return_status OUT NOCOPY VARCHAR2,
71 x_msg_data OUT NOCOPY VARCHAR2,
72 x_msg_count OUT NOCOPY NUMBER );
73
74 PROCEDURE Update_Pc_Sub_Due_Date
75 ( p_api_version IN NUMBER,
76 p_pc_info IN fpa_pc_info_obj,
77 x_return_status OUT NOCOPY VARCHAR2,
78 x_msg_data OUT NOCOPY VARCHAR2,
79 x_msg_count OUT NOCOPY NUMBER );
80
81 PROCEDURE Set_Pc_Status
82 ( p_api_version IN NUMBER,
83 p_pc_id IN NUMBER,
84 p_pc_status_code IN VARCHAR2,
85 x_return_status OUT NOCOPY VARCHAR2,
86 x_msg_data OUT NOCOPY VARCHAR2,
87 x_msg_count OUT NOCOPY NUMBER );
88
89 PROCEDURE Set_Pc_Initiate_Date
90 ( p_api_version IN NUMBER,
91 p_pc_id IN NUMBER,
92 x_return_status OUT NOCOPY VARCHAR2,
93 x_msg_data OUT NOCOPY VARCHAR2,
94 x_msg_count OUT NOCOPY NUMBER );
95
96 PROCEDURE Update_Pc_Discount_funds
97 ( p_api_version IN NUMBER,
98 p_disc_funds IN fpa_pc_discount_obj,
99 x_return_status OUT NOCOPY VARCHAR2,
100 x_msg_data OUT NOCOPY VARCHAR2,
101 x_msg_count OUT NOCOPY NUMBER );
102
103 FUNCTION Check_Pc_Name
104 ( p_api_version IN NUMBER,
105 p_portfolio_id IN NUMBER,
106 p_pc_name IN VARCHAR2,
107 p_pc_id IN NUMBER,
108 x_return_status OUT NOCOPY VARCHAR2,
109 x_msg_data OUT NOCOPY VARCHAR2,
110 x_msg_count OUT NOCOPY NUMBER)
111 RETURN number;
112
113 PROCEDURE Pa_Distrb_Lists_Insert_Row (
114 p_api_version IN NUMBER,
115 p_distr_list IN fpa_pc_distr_list_obj,
116 p_list_id IN OUT NOCOPY NUMBER,
117 x_return_status OUT NOCOPY VARCHAR2,
118 x_msg_data OUT NOCOPY VARCHAR2,
119 x_msg_count OUT NOCOPY NUMBER );
120
121 PROCEDURE Pa_Dist_List_Items_Update_Row (
122 p_api_version IN NUMBER,
123 p_distr_list_items_tbl fpa_pc_distr_list_items_tbl,
124 x_return_status OUT NOCOPY VARCHAR2,
125 x_msg_data OUT NOCOPY VARCHAR2,
126 x_msg_count OUT NOCOPY NUMBER );
127
128 PROCEDURE Set_Pc_Investment_Criteria (
129 p_api_version IN NUMBER,
130 p_pc_id IN NUMBER,
131 x_return_status OUT NOCOPY VARCHAR2,
132 x_msg_data OUT NOCOPY VARCHAR2,
133 x_msg_count OUT NOCOPY NUMBER );
134
135 PROCEDURE Set_Pc_Approved_Flag
136 ( p_api_version IN NUMBER,
137 p_pc_id IN NUMBER,
138 x_return_status OUT NOCOPY VARCHAR2,
139 x_msg_data OUT NOCOPY VARCHAR2,
140 x_msg_count OUT NOCOPY NUMBER );
141
142 PROCEDURE Set_Pc_Last_Flag
143 ( p_api_version IN NUMBER,
144 p_pc_id IN NUMBER,
145 x_return_status OUT NOCOPY VARCHAR2,
146 x_msg_data OUT NOCOPY VARCHAR2,
147 x_msg_count OUT NOCOPY NUMBER );
148
149 PROCEDURE Update_Pc_Annual_Disc_Rates
150 ( p_api_version IN NUMBER,
151 p_pc_id IN NUMBER,
152 p_period IN VARCHAR2,
153 p_rate IN VARCHAR2,
154 x_return_status OUT NOCOPY VARCHAR2,
155 x_msg_data OUT NOCOPY VARCHAR2,
156 x_msg_count OUT NOCOPY NUMBER );
157
158 END FPA_PlanningCycle_Pvt; -- Package spec