APPS.CS_INCIDENT_URGENCIES_PKG dependencies on CS_INCIDENT_URGENCIES_B

Line 37: cursor C is select ROWID from CS_INCIDENT_URGENCIES_B

33: X_LAST_UPDATE_DATE in DATE,
34: X_LAST_UPDATED_BY in NUMBER,
35: X_LAST_UPDATE_LOGIN in NUMBER
36: ) is
37: cursor C is select ROWID from CS_INCIDENT_URGENCIES_B
38: where INCIDENT_URGENCY_ID = X_INCIDENT_URGENCY_ID
39: ;
40: begin
41: insert into CS_INCIDENT_URGENCIES_B (

Line 41: insert into CS_INCIDENT_URGENCIES_B (

37: cursor C is select ROWID from CS_INCIDENT_URGENCIES_B
38: where INCIDENT_URGENCY_ID = X_INCIDENT_URGENCY_ID
39: ;
40: begin
41: insert into CS_INCIDENT_URGENCIES_B (
42: ATTRIBUTE13,
43: ATTRIBUTE14,
44: ATTRIBUTE15,
45: CONTEXT,

Line 195: from CS_INCIDENT_URGENCIES_B

191: ATTRIBUTE5,
192: ATTRIBUTE6,
193: ATTRIBUTE7,
194: ATTRIBUTE8
195: from CS_INCIDENT_URGENCIES_B
196: where INCIDENT_URGENCY_ID = X_INCIDENT_URGENCY_ID
197: for update of INCIDENT_URGENCY_ID nowait;
198: recinfo c%rowtype;
199:

Line 316: update CS_INCIDENT_URGENCIES_B set

312: X_LAST_UPDATED_BY in NUMBER,
313: X_LAST_UPDATE_LOGIN in NUMBER
314: ) is
315: begin
316: update CS_INCIDENT_URGENCIES_B set
317: ATTRIBUTE13 = X_ATTRIBUTE13,
318: ATTRIBUTE14 = X_ATTRIBUTE14,
319: ATTRIBUTE15 = X_ATTRIBUTE15,
320: CONTEXT = X_CONTEXT,

Line 375: delete from CS_INCIDENT_URGENCIES_B

371: if (sql%notfound) then
372: raise no_data_found;
373: end if;
374:
375: delete from CS_INCIDENT_URGENCIES_B
376: where INCIDENT_URGENCY_ID = X_INCIDENT_URGENCY_ID;
377:
378: if (sql%notfound) then
379: raise no_data_found;

Line 389: from CS_INCIDENT_URGENCIES_B B

385: begin
386: delete from CS_INCIDENT_URGENCIES_TL T
387: where not exists
388: (select NULL
389: from CS_INCIDENT_URGENCIES_B B
390: where B.INCIDENT_URGENCY_ID = T.INCIDENT_URGENCY_ID
391: );
392:
393: update CS_INCIDENT_URGENCIES_TL T set (