[Home] [Help]
PACKAGE: APPS.PSB_WORKSHEET_CONSOLIDATE_PVT
Source
1 PACKAGE PSB_WORKSHEET_CONSOLIDATE_PVT AS
2 /* $Header: PSBPWCDS.pls 120.2 2005/07/13 11:23:03 shtripat ship $ */
3
4 /* ----------------------------------------------------------------------- */
5
6 -- API name : Consolidate_Worksheets
7 -- Type : Private <Interface>
8 -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WORKSHEET_CONSOLIDATE
9 -- Parameters :
10 -- IN : p_api_version IN NUMBER Required
11 -- p_init_msg_list IN VARCHAR2 Optional
12 -- Default = FND_API.G_FALSE
13 -- p_commit IN VARCHAR2 Optional
14 -- Default = FND_API.G_FALSE
15 -- p_validation_level IN NUMBER Optional
16 -- Default = FND_API.G_VALID_LEVEL_NONE
17 -- p_global_worksheet_id IN NUMBER Required
18 -- .
19 -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
20 -- p_msg_count OUT NOCOPY NUMBER
21 -- p_msg_data OUT NOCOPY VARCHAR2(2000)
22 -- .
23 -- Version : Current version 1.0
24 -- Initial version 1.0
25 -- Created 06/06/1999 by Supriyo Ghosh
26 --
27 -- Notes : Consolidate Global Worksheet
28 --
29
30 PROCEDURE Consolidate_Worksheets
31 ( p_api_version IN NUMBER,
32 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
33 p_commit IN VARCHAR2 := FND_API.G_FALSE,
34 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
35 p_return_status OUT NOCOPY VARCHAR2,
36 p_msg_count OUT NOCOPY NUMBER,
37 p_msg_data OUT NOCOPY VARCHAR2,
38 p_global_worksheet_id IN NUMBER
39 );
40
41 /* ----------------------------------------------------------------------- */
42
43 -- API name : Validate_Consolidation
44 -- Type : Private <Interface>
45 -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WORKSHEET_CONSOLIDATE
46 -- Parameters :
47 -- IN : p_api_version IN NUMBER Required
48 -- p_init_msg_list IN VARCHAR2 Optional
49 -- Default = FND_API.G_FALSE
50 -- p_validation_level IN NUMBER Optional
51 -- Default = FND_API.G_VALID_LEVEL_NONE
52 -- p_global_worksheet_id IN NUMBER Required
53 -- .
54 -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
55 -- p_msg_count OUT NOCOPY NUMBER
56 -- p_msg_data OUT NOCOPY VARCHAR2(2000)
57 -- .
58 -- Version : Current version 1.0
59 -- Initial version 1.0
60 -- Created 06/06/1999 by Supriyo Ghosh
61 --
62 -- Notes : Validate the Global Worksheet Consolidation
63 --
64
65 PROCEDURE Validate_Consolidation
66 ( p_api_version IN NUMBER,
67 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
68 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
69 p_return_status OUT NOCOPY VARCHAR2,
70 p_msg_count OUT NOCOPY NUMBER,
71 p_msg_data OUT NOCOPY VARCHAR2,
72 p_global_worksheet_id IN NUMBER
73 );
74
75
76 /* ----------------------------------------------------------------------- */
77 -- fmiao added Insert_Row, Update_Row, Lock_Row, Delete_Row, Check_Unique 07-JUN-99
78 -- fmiao added Worksheet_consolidate_CP
79
80 PROCEDURE Insert_Row
81 (
82 p_api_version IN NUMBER,
83 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
84 p_commit IN VARCHAR2 := FND_API.G_FALSE,
85 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
86 p_return_status OUT NOCOPY VARCHAR2,
87 p_msg_count OUT NOCOPY NUMBER,
88 p_msg_data OUT NOCOPY VARCHAR2,
89
90 p_row_id IN OUT NOCOPY VARCHAR2,
91 p_global_worksheet_id IN NUMBER,
92 p_local_worksheet_id IN NUMBER,
93 p_last_update_date IN DATE,
94 p_last_updated_by IN NUMBER,
95 p_last_update_login IN NUMBER,
96 p_created_by IN NUMBER,
97 p_creation_date IN DATE,
98 p_attribute1 IN VARCHAR2,
99 p_attribute2 IN VARCHAR2,
100 p_attribute3 IN VARCHAR2,
101 p_attribute4 IN VARCHAR2,
102 p_attribute5 IN VARCHAR2,
103 p_attribute6 IN VARCHAR2,
104 p_attribute7 IN VARCHAR2,
105 p_attribute8 IN VARCHAR2,
106 p_attribute9 IN VARCHAR2,
107 p_attribute10 IN VARCHAR2,
108 p_context IN VARCHAR2
109 );
110
111
112 PROCEDURE Lock_Row
113 (
114 p_api_version IN NUMBER,
115 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
116 p_commit IN VARCHAR2 := FND_API.G_FALSE,
117 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
118 p_return_status OUT NOCOPY VARCHAR2,
119 p_msg_count OUT NOCOPY NUMBER,
120 p_msg_data OUT NOCOPY VARCHAR2,
121
122 p_row_id IN VARCHAR2,
123 p_global_worksheet_id IN NUMBER,
124 p_local_worksheet_id IN NUMBER,
125 p_attribute1 IN VARCHAR2,
126 p_attribute2 IN VARCHAR2,
127 p_attribute3 IN VARCHAR2,
128 p_attribute4 IN VARCHAR2,
129 p_attribute5 IN VARCHAR2,
130 p_attribute6 IN VARCHAR2,
131 p_attribute7 IN VARCHAR2,
132 p_attribute8 IN VARCHAR2,
133 p_attribute9 IN VARCHAR2,
134 p_attribute10 IN VARCHAR2,
135 p_context IN VARCHAR2,
136
137 p_row_locked OUT NOCOPY VARCHAR2
138 );
139
140
141 PROCEDURE Update_Row
142 (
143 p_api_version IN NUMBER,
144 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145 p_commit IN VARCHAR2 := FND_API.G_FALSE,
146 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
147 p_return_status OUT NOCOPY VARCHAR2,
148 p_msg_count OUT NOCOPY NUMBER,
149 p_msg_data OUT NOCOPY VARCHAR2,
150
151 p_row_id IN VARCHAR2,
152 p_global_worksheet_id IN NUMBER,
153 p_local_worksheet_id IN NUMBER,
154 p_last_update_date IN DATE,
155 p_last_updated_by IN NUMBER,
156 p_last_update_login IN NUMBER,
157 p_attribute1 IN VARCHAR2,
158 p_attribute2 IN VARCHAR2,
159 p_attribute3 IN VARCHAR2,
160 p_attribute4 IN VARCHAR2,
161 p_attribute5 IN VARCHAR2,
162 p_attribute6 IN VARCHAR2,
163 p_attribute7 IN VARCHAR2,
164 p_attribute8 IN VARCHAR2,
165 p_attribute9 IN VARCHAR2,
166 p_attribute10 IN VARCHAR2,
167 p_context IN VARCHAR2
168 );
169
170
171 PROCEDURE Delete_Row
172 (
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_return_status OUT NOCOPY VARCHAR2,
178 p_msg_count OUT NOCOPY NUMBER,
179 p_msg_data OUT NOCOPY VARCHAR2,
180
181 p_row_id IN VARCHAR2
182 );
183
184
185 PROCEDURE Check_Unique
186 (
187 p_api_version IN NUMBER,
188 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
189 p_commit IN VARCHAR2 := FND_API.G_FALSE,
190 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
191 p_return_status OUT NOCOPY VARCHAR2,
192 p_msg_count OUT NOCOPY NUMBER,
193 p_msg_data OUT NOCOPY VARCHAR2,
194 --
195 p_row_id IN VARCHAR2,
196 p_global_worksheet_id IN NUMBER,
197 p_local_worksheet_id IN NUMBER,
198 p_return_value IN OUT NOCOPY VARCHAR2
199 );
200
201
202 PROCEDURE Worksheet_Consolidate_CP
203 (
204 errbuf OUT NOCOPY VARCHAR2,
205 retcode OUT NOCOPY VARCHAR2,
206 --
207 p_worksheet_id IN NUMBER
208 );
209
210 /* ----------------------------------------------------------------------- */
211
212 END PSB_WORKSHEET_CONSOLIDATE_PVT;