[Home] [Help]
PACKAGE: APPS.AHL_LTP_SIMUL_PLAN_PUB
Source
1 PACKAGE AHL_LTP_SIMUL_PLAN_PUB AUTHID CURRENT_USER AS
2 /* $Header: AHLPSPNS.pls 115.6 2002/12/04 19:23:22 ssurapan noship $ */
3
4 -----------------------------------------------------------
5 -- PACKAGE
6 -- AHL_LTP_SIMUL_PLAN_PUB
7 --
8 -- PURPOSE
9 -- This package is a Public API for managing Simulation Plans in
10 -- Advanced Services Online. It contains specification for pl/sql records and tables
11 --
12 -- AHL_SIMULATION_PLANS
13 -- Process_Simulation_Plan (see below for specification)
14 --
15 --
16 -- NOTES
17 --
18 --
19 -- HISTORY
20 -- 22-Apr-2002 ssurapan Created.
21 -----------------------------------------------------------
22 -----------------------------------------------------------
23 -- SIMULATION PLAN
24 -----------------------------------------------------------
25
26 -- Record for AHL_SIMULATION_PLANS
27 TYPE Simulation_Plan_Rec IS RECORD (
28 plan_id NUMBER,
29 last_update_date DATE,
30 last_updated_by NUMBER,
31 creation_date DATE,
32 created_by NUMBER,
33 last_update_login NUMBER,
34 primary_plan_flag VARCHAR2(1),
35 plan_name VARCHAR2(80),
36 description VARCHAR2(250),
37 object_version_number NUMBER,
38 attribute_category VARCHAR2(30),
39 attribute1 VARCHAR2(150),
40 attribute2 VARCHAR2(150),
41 attribute3 VARCHAR2(150),
42 attribute4 VARCHAR2(150),
43 attribute5 VARCHAR2(150),
44 attribute6 VARCHAR2(150),
45 attribute7 VARCHAR2(150),
46 attribute8 VARCHAR2(150),
47 attribute9 VARCHAR2(150),
48 attribute10 VARCHAR2(150),
49 attribute11 VARCHAR2(150),
50 attribute12 VARCHAR2(150),
51 attribute13 VARCHAR2(150),
52 attribute14 VARCHAR2(150),
53 attribute15 VARCHAR2(150),
54 operation_flag VARCHAR2(1)
55 );
56
57
58 --Declare table type
59 TYPE Simulation_Plan_Tbl IS TABLE OF Simulation_Plan_Rec
60 INDEX BY BINARY_INTEGER;
61
62 -----------------------------------------------------------
63 -- SIMULATION VISIT
64 -----------------------------------------------------------
65
66 -- Record for AHL_SIMULATION_VISIT
67 TYPE Simulation_Visit_Rec IS RECORD (
68 primary_visit_id NUMBER,
69 primary_ovn NUMBER,
70 plan_id NUMBER,
71 plan_name VARCHAR2(30),
72 plan_ovn NUMBER,
73 visit_id NUMBER,
74 primary_visit_number NUMBER,
75 visit_ovn NUMBER,
76 operation_flag VARCHAR2(1)
77 );
78
79 --Declare table type
80 TYPE Simulation_Visit_Tbl IS TABLE OF Simulation_Visit_Rec
81 INDEX BY BINARY_INTEGER;
82
83 --------------------------------------------------------------------
84 -- PROCEDURE
85 -- Process_Simulation_Plan
86 --
87 -- PURPOSE
88 -- Process Simulation Plan Record
89 --
90 -- PARAMETERS
91 -- p_x_simulation_plan_tbl : Table Representing Simulation_Plan_Tbl
92 --
93 -- NOTES
94 --------------------------------------------------------------------
95 PROCEDURE Process_Simulation_Plan (
96 p_api_version IN NUMBER,
97 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
98 p_commit IN VARCHAR2 := FND_API.g_false,
99 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
100 p_module_type IN VARCHAR2 := 'JSP',
101 p_x_simulation_plan_tbl IN OUT NOCOPY Simulation_Plan_Tbl,
102 x_return_status OUT NOCOPY VARCHAR2,
103 x_msg_count OUT NOCOPY NUMBER,
104 x_msg_data OUT NOCOPY VARCHAR2
105 );
106
107 --------------------------------------------------------------------
108 -- PROCEDURE
109 -- Process_Simulation_Visit
110 --
111 -- PURPOSE
112 -- Process Simulation Visit
113 --
114 -- PARAMETERS
115 -- p_simulation_visit_tbl : Table Representing Simulation_Visit_Tbl
116 --
117 -- NOTES
118 --------------------------------------------------------------------
119 PROCEDURE Process_Simulation_Visit (
120 p_api_version IN NUMBER,
121 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
122 p_commit IN VARCHAR2 := FND_API.g_false,
123 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
124 p_module_type IN VARCHAR2 := 'JSP',
125 p_simulation_visit_tbl IN OUT NOCOPY Simulation_Visit_Tbl,
126 x_return_status OUT NOCOPY VARCHAR2,
127 x_msg_count OUT NOCOPY NUMBER,
128 x_msg_data OUT NOCOPY VARCHAR2
129 );
130
131
132 --------------------------------------------------------------------
133 -- PROCEDURE
134 -- Toggle_Simulation_Delete
135 --
136 -- PURPOSE
137 -- Toggle Simulation Delete/Undelete
138 --
139 -- PARAMETERS
140 -- p_visit_id : Visit Id
141 -- p_visit_object_version_number : Visit Object Version Number
142 --
143 -- NOTES
144 --------------------------------------------------------------------
145 PROCEDURE Toggle_Simulation_Delete (
146 p_api_version IN NUMBER,
147 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
148 p_commit IN VARCHAR2 := FND_API.g_false,
149 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
150 p_module_type IN VARCHAR2 := 'JSP',
151 p_visit_id IN NUMBER,
152 p_visit_object_version_number IN NUMBER,
153 x_return_status OUT NOCOPY VARCHAR2,
154 x_msg_count OUT NOCOPY NUMBER,
155 x_msg_data OUT NOCOPY VARCHAR2
156 );
157
158
159 --------------------------------------------------------------------
160 -- PROCEDURE
161 -- Set_Plan_As_Primary
162 --
163 -- PURPOSE
164 -- Set Plan As Primary
165 --
166 -- PARAMETERS
167 -- p_plan_id : Simulation Plan Id
168 -- p_object_version_number : Plan Object Version Number
169 --
170 -- NOTES
171 --------------------------------------------------------------------
172 PROCEDURE Set_Plan_As_Primary (
173 p_api_version IN NUMBER,
174 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
175 p_commit IN VARCHAR2 := FND_API.g_false,
176 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
177 p_module_type IN VARCHAR2 := 'JSP',
178 p_plan_id IN NUMBER,
179 p_object_version_number IN NUMBER,
180 x_return_status OUT NOCOPY VARCHAR2,
181 x_msg_count OUT NOCOPY NUMBER,
182 x_msg_data OUT NOCOPY VARCHAR2
183 );
184
185 --------------------------------------------------------------------
186 -- PROCEDURE
187 -- Set_Visit_As_Primary
188 --
189 -- PURPOSE
190 -- Set Visit As Primary
191 --
192 -- PARAMETERS
193 -- p_visit_id : Simulation Visit Id
194 -- p_object_version_number : Visit Object Version Number
195 --
196 -- NOTES
197 --------------------------------------------------------------------
198 PROCEDURE Set_Visit_As_Primary (
199 p_api_version IN NUMBER,
200 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
201 p_commit IN VARCHAR2 := FND_API.g_false,
202 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
203 p_module_type IN VARCHAR2 := 'JSP',
204 p_visit_id IN NUMBER,
205 p_plan_id IN NUMBER,
206 p_object_version_number IN NUMBER,
207 x_return_status OUT NOCOPY VARCHAR2,
208 x_msg_count OUT NOCOPY NUMBER,
209 x_msg_data OUT NOCOPY VARCHAR2
210 );
211
212
213
214
215 END AHL_LTP_SIMUL_PLAN_PUB;