[Home] [Help]
PACKAGE: APPS.FPA_SCENARIO_PVT
Source
1 PACKAGE fpa_scenario_pvt AUTHID CURRENT_USER AS
2 /* $Header: FPAVSCES.pls 120.2 2011/08/03 22:14:26 skkoppul ship $ */
3
4 TYPE scenario_rec_type IS RECORD
5 (
6 sce_shortname VARCHAR2(30), -- shortname of scenario.
7 sce_name VARCHAR2(50), -- name of scenario.
8 sce_description VARCHAR2(255), -- description of scenario.
9 sce_status VARCHAR2(30), -- status of scenario.
10 sce_planning_cycle VARCHAR2(30), -- planning cycle of scenario.
11 sce_org_id VARCHAR2(30), -- Organization shortname
12 copy_flag VARCHAR2(1), -- flag used to tell the API new scenario
13 sce_new_capital number -- value for new capital.
14 );
15
16 -- Creates a new scenario
17 PROCEDURE create_scenario
18 (
19 p_api_version IN NUMBER,
20 p_scenario_name IN VARCHAR2,
21 p_scenario_desc IN VARCHAR2,
22 p_pc_id IN NUMBER,
23 x_scenario_id OUT NOCOPY NUMBER,
24 x_return_status OUT NOCOPY VARCHAR2,
25 x_msg_count OUT NOCOPY NUMBER,
26 x_msg_data OUT NOCOPY VARCHAR2
27 );
28
29 PROCEDURE copy_scenario_data
30 (
31 p_api_version IN NUMBER,
32 p_scenario_id_source IN NUMBER,
33 p_scenario_id_target IN NUMBER,
34 p_copy_proposed_proj IN VARCHAR2,
35 x_return_status OUT NOCOPY VARCHAR2,
36 x_msg_count OUT NOCOPY NUMBER,
37 x_msg_data OUT NOCOPY VARCHAR2
38 );
39
40 PROCEDURE lock_scenario
41 (
42 p_commit IN VARCHAR2 := FND_API.G_FALSE,
43 p_scenario_rec IN fpa_scenario_pvt.scenario_rec_type,
44 x_return_status OUT NOCOPY VARCHAR2,
45 x_msg_count OUT NOCOPY NUMBER,
46 x_msg_data OUT NOCOPY VARCHAR2
47 );
48
49 function check_scenario_name
50 (
51 p_scenario_name IN VARCHAR2,
52 p_pc_id IN NUMBER,
53 x_return_status OUT NOCOPY VARCHAR2,
54 x_msg_count OUT NOCOPY NUMBER,
55 x_msg_data OUT NOCOPY VARCHAR2
56 ) RETURN NUMBER;
57
58 PROCEDURE update_scen_approved_flag
59 (
60 p_scenario_id IN NUMBER,
61 p_approved_flag IN VARCHAR2 :='NA',
62 x_return_status OUT NOCOPY VARCHAR2,
63 x_msg_count OUT NOCOPY NUMBER,
64 x_msg_data OUT NOCOPY VARCHAR2
65 );
66
67 procedure update_scenario_disc_rate
68 (
69 p_api_version IN NUMBER,
70 p_scenario_id IN NUMBER,
71 p_discount_rate IN NUMBER,
72 x_return_status OUT NOCOPY VARCHAR2,
73 x_msg_count OUT NOCOPY NUMBER,
74 x_msg_data OUT NOCOPY VARCHAR2
75 );
76
77 procedure update_scenario_funds_avail
78 (
79 p_api_version IN NUMBER,
80 p_scenario_id IN NUMBER,
81 p_scenario_funds IN NUMBER,
82 x_return_status OUT NOCOPY VARCHAR2,
83 x_msg_count OUT NOCOPY NUMBER,
84 x_msg_data OUT NOCOPY VARCHAR2
85 );
86
87 procedure update_scenario_initial_flag
88 (
89 p_api_version IN NUMBER,
90 p_scenario_id IN NUMBER,
91 x_return_status OUT NOCOPY VARCHAR2,
92 x_msg_count OUT NOCOPY NUMBER,
93 x_msg_data OUT NOCOPY VARCHAR2
94 );
95
96 procedure update_scenario_working_flag
97 (
98 p_api_version IN NUMBER,
99 p_scenario_id IN NUMBER,
100 x_return_status OUT NOCOPY VARCHAR2,
101 x_msg_count OUT NOCOPY NUMBER,
102 x_msg_data OUT NOCOPY VARCHAR2
103 );
104
105 procedure update_scenario_reccom_flag
106 (
107 p_api_version IN NUMBER,
108 p_scenario_id IN NUMBER,
109 p_scenario_reccom_status IN VARCHAR2,
110 x_return_status OUT NOCOPY VARCHAR2,
111 x_msg_count OUT NOCOPY NUMBER,
112 x_msg_data OUT NOCOPY VARCHAR2
113 );
114
115 procedure update_scenario_reccom_status
116 (
117 p_api_version IN NUMBER,
118 p_scenario_id IN NUMBER,
119 p_project_id IN VARCHAR2,
120 p_scenario_reccom_value IN VARCHAR2,
121 x_return_status OUT NOCOPY VARCHAR2,
122 x_msg_count OUT NOCOPY NUMBER,
123 x_msg_data OUT NOCOPY VARCHAR2
124 );
125
126 PROCEDURE copy_sce_project_data
127 (
128 p_api_version IN NUMBER,
129 p_commit IN VARCHAR2,
130 p_target_scen_id IN NUMBER,
131 p_project_id_str IN VARCHAR2,
132 x_return_status OUT NOCOPY VARCHAR2,
133 x_msg_count OUT NOCOPY NUMBER,
134 x_msg_data OUT NOCOPY VARCHAR2
135 );
136
137 PROCEDURE remove_project_from_scenario
138 (
139 p_api_version IN NUMBER,
140 p_commit IN VARCHAR2,
141 p_scenario_id IN NUMBER,
142 p_project_id IN NUMBER,
143 x_return_status OUT NOCOPY VARCHAR2,
144 x_msg_count OUT NOCOPY NUMBER,
145 x_msg_data OUT NOCOPY VARCHAR2
146 );
147
148 PROCEDURE Update_Proj_User_Ranks
149 (
150 p_api_version IN NUMBER,
151 p_proj_metrics IN fpa_scen_proj_userrank_tbl,
152 x_return_status OUT NOCOPY VARCHAR2,
153 x_msg_data OUT NOCOPY VARCHAR2,
154 x_msg_count OUT NOCOPY NUMBER
155 );
156
157 PROCEDURE calc_scenario_data
158 (
159 p_api_version IN NUMBER,
160 p_scenario_id IN NUMBER,
161 p_project_id IN NUMBER,
162 p_class_code_id IN NUMBER,
163 p_data_to_calc IN VARCHAR2,
164 x_return_status OUT NOCOPY VARCHAR2,
165 x_msg_count OUT NOCOPY NUMBER,
166 x_msg_data OUT NOCOPY VARCHAR2
167 );
168
169 END fpa_scenario_pvt;