APPS.FND_SVC_COMP_REQUESTS_PKG dependencies on FND_SVC_COMP_REQUESTS

Line 1: package body FND_SVC_COMP_REQUESTS_PKG as

1: package body FND_SVC_COMP_REQUESTS_PKG as
2: /* $Header: AFSVCRTB.pls 115.4 2003/01/17 22:20:38 ankung noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out nocopy VARCHAR2,

Line 21: cursor C is select ROWID from FND_SVC_COMP_REQUESTS

17: X_LAST_UPDATE_DATE in DATE,
18: X_LAST_UPDATED_BY in NUMBER,
19: X_LAST_UPDATE_LOGIN in NUMBER
20: ) is
21: cursor C is select ROWID from FND_SVC_COMP_REQUESTS
22: where COMPONENT_REQUEST_ID = X_COMPONENT_REQUEST_ID
23: ;
24: begin
25: insert into FND_SVC_COMP_REQUESTS (

Line 25: insert into FND_SVC_COMP_REQUESTS (

21: cursor C is select ROWID from FND_SVC_COMP_REQUESTS
22: where COMPONENT_REQUEST_ID = X_COMPONENT_REQUEST_ID
23: ;
24: begin
25: insert into FND_SVC_COMP_REQUESTS (
26: COMPONENT_REQUEST_ID,
27: COMPONENT_ID,
28: EVENT_NAME,
29: EVENT_DATE,

Line 67: wf_core.context('FND_SVC_COMP_REQUESTS_PKG', 'Insert_Row', X_COMPONENT_ID, X_EVENT_NAME);

63: close c;
64:
65: exception
66: when others then
67: wf_core.context('FND_SVC_COMP_REQUESTS_PKG', 'Insert_Row', X_COMPONENT_ID, X_EVENT_NAME);
68: raise;
69:
70: end INSERT_ROW;
71:

Line 92: from FND_SVC_COMP_REQUESTS

88: JOB_ID,
89: EVENT_FREQUENCY,
90: OBJECT_VERSION_NUMBER,
91: EVENT_PARAMS
92: from FND_SVC_COMP_REQUESTS
93: where COMPONENT_REQUEST_ID = X_COMPONENT_REQUEST_ID
94: for update of COMPONENT_REQUEST_ID nowait;
95:
96: recinfo c%rowtype;

Line 127: wf_core.context('FND_SVC_COMP_REQUESTS_PKG', 'Lock_Row', X_COMPONENT_REQUEST_ID);

123: return;
124:
125: exception
126: when others then
127: wf_core.context('FND_SVC_COMP_REQUESTS_PKG', 'Lock_Row', X_COMPONENT_REQUEST_ID);
128: raise;
129: end LOCK_ROW;
130:
131: procedure UPDATE_ROW (

Line 159: from FND_SVC_COMP_REQUESTS

155: -- Allow update. Increment the database's OVN by 1
156: --
157: select OBJECT_VERSION_NUMBER
158: into l_object_version_number
159: from FND_SVC_COMP_REQUESTS
160: where COMPONENT_REQUEST_ID = X_COMPONENT_REQUEST_ID;
161:
162: l_object_version_number := l_object_version_number + 1;
163:

Line 176: from FND_SVC_COMP_REQUESTS

172: --
173:
174: select OBJECT_VERSION_NUMBER
175: into l_object_version_number
176: from FND_SVC_COMP_REQUESTS
177: where COMPONENT_REQUEST_ID = X_COMPONENT_REQUEST_ID
178: for update;
179:
180: if (l_object_version_number = X_OBJECT_VERSION_NUMBER) then

Line 192: update FND_SVC_COMP_REQUESTS set

188: end if;
189:
190: end if;
191:
192: update FND_SVC_COMP_REQUESTS set
193: COMPONENT_ID = X_COMPONENT_ID,
194: EVENT_NAME = X_EVENT_NAME,
195: EVENT_DATE = X_EVENT_DATE,
196: REQUESTED_BY_USER = X_REQUESTED_BY_USER,

Line 212: wf_core.context('FND_SVC_COMP_REQUESTS_PKG', 'Update_Row', X_COMPONENT_REQUEST_ID);

208: end if;
209:
210: exception
211: when others then
212: wf_core.context('FND_SVC_COMP_REQUESTS_PKG', 'Update_Row', X_COMPONENT_REQUEST_ID);
213: raise;
214: end UPDATE_ROW;
215:
216: procedure DELETE_ROW (

Line 220: delete from FND_SVC_COMP_REQUESTS

216: procedure DELETE_ROW (
217: X_COMPONENT_REQUEST_ID in NUMBER
218: ) is
219: begin
220: delete from FND_SVC_COMP_REQUESTS
221: where COMPONENT_REQUEST_ID = X_COMPONENT_REQUEST_ID;
222:
223: if (sql%notfound) then
224: raise no_data_found;

Line 229: wf_core.context('FND_SVC_COMP_REQUESTS_PKG', 'Delete_Row', X_COMPONENT_REQUEST_ID);

225: end if;
226:
227: exception
228: when others then
229: wf_core.context('FND_SVC_COMP_REQUESTS_PKG', 'Delete_Row', X_COMPONENT_REQUEST_ID);
230: raise;
231: end DELETE_ROW;
232:
233:

Line 283: FROM fnd_svc_comp_requests

279: -- we're only selecting the first one we find here.
280: --
281: SELECT component_request_id, job_id
282: INTO l_component_request_id, l_job_id
283: FROM fnd_svc_comp_requests
284: WHERE component_id = l_component_id
285: AND rownum = 1
286: AND event_name = X_EVENT_NAME
287: AND event_date = X_EVENT_DATE

Line 292: FND_SVC_COMP_REQUESTS_PKG.UPDATE_ROW (

288: AND ( (event_frequency is NULL AND X_EVENT_FREQUENCY IS NULL)
289: OR (event_frequency = X_EVENT_FREQUENCY));
290:
291:
292: FND_SVC_COMP_REQUESTS_PKG.UPDATE_ROW (
293: X_COMPONENT_REQUEST_ID => l_component_request_id,
294: X_COMPONENT_ID => l_component_id,
295: X_EVENT_NAME => X_EVENT_NAME,
296: X_EVENT_DATE => X_EVENT_DATE,

Line 317: SELECT fnd_svc_comp_requests_s.nextval

313:
314: EXCEPTION
315: WHEN No_Data_Found THEN
316:
317: SELECT fnd_svc_comp_requests_s.nextval
318: INTO l_component_request_id
319: FROM dual;
320:
321: DBMS_JOB.SUBMIT

Line 329: FND_SVC_COMP_REQUESTS_PKG.INSERT_ROW (

325: , next_date => X_EVENT_DATE
326: , interval => l_interval
327: );
328:
329: FND_SVC_COMP_REQUESTS_PKG.INSERT_ROW (
330: X_ROWID => row_id,
331: X_COMPONENT_REQUEST_ID => l_component_request_id,
332: X_COMPONENT_ID => l_component_id,
333: X_EVENT_NAME => X_EVENT_NAME,

Line 348: end FND_SVC_COMP_REQUESTS_PKG;

344:
345: end LOAD_ROW;
346:
347:
348: end FND_SVC_COMP_REQUESTS_PKG;