1 PACKAGE IEC_COMMON_UTIL_PVT AS
2 /* $Header: IECCMUTS.pls 120.1 2006/03/28 07:32:19 minwang noship $ */
3
4 -----------------------------++++++-------------------------------
5 --
6 -- Start of comments
7 --
8 -- API name : Get_SourceTypeView
9 -- Type : Private
10 -- Pre-reqs : None
11 -- Function : Return the source type view name for specified
12 -- target group. Raises exception if unable to
13 -- locate view.
14 --
15 -- Parameters : p_list_id IN NUMBER Required
16 -- x_source_type_view OUT VARCHAR2 Required
17 --
18 -- Version : Initial version 1.0
19 --
20 -- End of comments
21 --
22 -----------------------------++++++-------------------------------
23 PROCEDURE Get_SourceTypeView
24 ( p_list_id IN NUMBER
25 , x_source_type_view OUT NOCOPY VARCHAR2);
26
27 -----------------------------++++++-------------------------------
28 --
29 -- Start of comments
30 --
31 -- API name : LOCK_SCHEDULE
32 -- Type : Public
33 -- Pre-reqs : None
34 -- Function : Attempt to lock the schedule.
35 -- Parameters : P_SOURCE_ID IN NUMBER Required
36 -- P_SCHED_ID IN NUMBER Required
37 -- P_SERVER_ID IN NUMBER Required
38 -- P_LOCK_ATTEMPTS IN VARCHAR2 Required
39 -- P_ATTEMPT_INTERVAL IN VARCHAR2 Required
40 -- X_SUCCESS_FLAG OUT VARCHAR2 Required
41 -- Future : Not sure this should be an autonomous transaction. Leaving
42 -- for now.
43 --
44 -- Version : Initial version 1.0
45 --
46 -- End of comments
47 --
48 -----------------------------++++++-------------------------------
49 PROCEDURE Lock_Schedule
50 ( P_SOURCE_ID IN NUMBER
51 , P_SCHED_ID IN NUMBER
52 , P_SERVER_ID IN NUMBER
53 , P_LOCK_ATTEMPTS IN NUMBER
54 , P_ATTEMPT_INTERVAL IN NUMBER
55 , X_SUCCESS_FLAG OUT NOCOPY VARCHAR2
56 );
57
58 -----------------------------++++++-------------------------------
59 --
60 -- Start of comments
61 --
62 -- API name : UNLOCK_SCHEDULE
63 -- Type : Public
64 -- Pre-reqs : None
65 -- Function : Attempt to unlock the schedule.
66 -- Parameters : P_SOURCE_ID IN NUMBER Required
67 -- P_SCHED_ID IN NUMBER Required
68 -- P_SERVER_ID IN NUMBER Required
69 -- X_SUCCESS_FLAG OUT VARCHAR2 Required
70 -- Future : Not sure this should be an autonomous transaction. Leaving
71 -- for now.
72 --
73 -- Version : Initial version 1.0
74 --
75 -- End of comments
76 --
77 -----------------------------++++++-------------------------------
78 PROCEDURE Unlock_Schedule
79 ( P_SOURCE_ID IN NUMBER
80 , P_SCHED_ID IN NUMBER
81 , P_SERVER_ID IN NUMBER
82 , X_SUCCESS_FLAG OUT NOCOPY VARCHAR2
83 );
84
85 -----------------------------++++++-------------------------------
86 --
87 -- Start of comments
88 --
89 -- API name : Lock_Schedule
90 -- Type : Public
91 -- Pre-reqs : None
92 -- Function : Either attempt to gain a lock on the schedule or unlock the schedule.
93 --
94 -- Parameters : P_SOURCE_ID IN NUMBER Required
95 -- P_SCHED_ID IN NUMBER Required
96 -- P_SERVER_ID IN NUMBER Required
97 -- P_LOCK_FLAG IN NUMBER Required
98 -- X_SUCCESS_FLAG OUT VARCHAR2 Required
99 --
100 -- Version : Initial version 1.0
101 --
102 -- End of comments
103 --
104 -----------------------------++++++-------------------------------
105 PROCEDURE Lock_Schedule
106 ( P_SOURCE_ID IN NUMBER
107 , P_SCHED_ID IN NUMBER
108 , P_SERVER_ID IN NUMBER
109 , P_LOCK_FLAG IN VARCHAR2
110 , X_SUCCESS_FLAG OUT NOCOPY VARCHAR2
111 );
112
113 -----------------------------++++++-------------------------------
114 --
115 -- Start of comments
116 --
117 -- API name : Get_SubsetName
118 -- Type : Private
119 -- Pre-reqs : None
120 -- Function : Return the name for specified subset.
121 -- Initializes FND_MESSAGE and raises
122 -- exception if unable to locate name.
123 --
124 -- Parameters : p_subset_id IN NUMBER Required
125 -- x_subset_name OUT VARCHAR2 Required
126 --
127 -- Version : Initial version 1.0
128 --
129 -- End of comments
130 --
131 -----------------------------++++++-------------------------------
132 PROCEDURE Get_SubsetName
133 ( p_subset_id IN NUMBER
134 , x_subset_name OUT NOCOPY VARCHAR2);
135
136 -----------------------------++++++-------------------------------
137 --
138 -- Start of comments
139 --
140 -- API name : Get_ListName
141 -- Type : Private
142 -- Pre-reqs : None
143 -- Function : Return the name for specified list.
144 -- Initializes FND_MESSAGE and raises
145 -- exception if unable to locate name.
146 --
147 -- Parameters : p_list_id IN NUMBER Required
148 -- x_list_name OUT VARCHAR2 Required
149 --
150 -- Version : Initial version 1.0
151 --
152 -- End of comments
153 --
154 -----------------------------++++++-------------------------------
155 PROCEDURE Get_ListName
156 ( p_list_id IN NUMBER
157 , x_list_name OUT NOCOPY VARCHAR2);
158
159 -----------------------------++++++-------------------------------
160 --
161 -- Start of comments
162 --
163 -- API name : Get_ScheduleName
164 -- Type : Private
165 -- Pre-reqs : None
166 -- Function : Return the name for specified schedule.
167 -- Initializes FND_MESSAGE and raises
168 -- exception if unable to locate name.
169 --
170 -- Parameters : p_schedule_id IN NUMBER Required
171 -- x_schedule_name OUT VARCHAR2 Required
172 --
173 -- Version : Initial version 1.0
174 --
175 -- End of comments
176 --
177 -----------------------------++++++-------------------------------
178 PROCEDURE Get_ScheduleName
179 ( p_schedule_id IN NUMBER
180 , x_schedule_name OUT NOCOPY VARCHAR2);
181
182 -----------------------------++++++-------------------------------
183 --
184 -- Start of comments
185 --
186 -- API name : Get_ScheduleId
187 -- Type : Private
188 -- Pre-reqs : None
189 -- Function : Return the schedule id for specified list.
190 -- Initializes FND_MESSAGE and raises
191 -- exception if unable to locate name.
192 --
193 -- Parameters : p_list_id IN NUMBER Required
194 -- x_schedule_id OUT NUMBER Required
195 --
196 -- Version : Initial version 1.0
197 --
198 -- End of comments
199 --
200 -----------------------------++++++-------------------------------
201 PROCEDURE Get_ScheduleId
202 ( p_list_id IN NUMBER
203 , x_schedule_id OUT NOCOPY NUMBER);
204
205 -----------------------------++++++-------------------------------
206 --
207 -- Start of comments
208 --
209 -- API name : Get_ListId
210 -- Type : Private
211 -- Pre-reqs : None
212 -- Function : Return the list header id for specified schedule.
213 -- Initializes FND_MESSAGE and raises
214 -- exception if unable to locate name.
215 --
216 -- Parameters : p_schedule_id IN NUMBER Required
217 -- x_list_id OUT NUMBER Required
218 --
219 -- Version : Initial version 1.0
220 --
221 -- End of comments
222 --
223 -----------------------------++++++-------------------------------
224 PROCEDURE Get_ListId
225 ( p_schedule_id IN NUMBER
226 , x_list_id OUT NOCOPY NUMBER);
227
228 END IEC_COMMON_UTIL_PVT;