APPS.CS_INCIDENT_SEVERITIES_PKG dependencies on CS_INCIDENT_SEVERITIES_B

Line 40: cursor C is select ROWID from CS_INCIDENT_SEVERITIES_B

36: X_LAST_UPDATE_LOGIN in NUMBER,
37: --Added priority code for Misc ERs project (11.5.10) --anmukher --09/01/03
38: X_PRIORITY_CODE in VARCHAR2
39: ) is
40: cursor C is select ROWID from CS_INCIDENT_SEVERITIES_B
41: where INCIDENT_SEVERITY_ID = X_INCIDENT_SEVERITY_ID
42: ;
43: begin
44: insert into CS_INCIDENT_SEVERITIES_B (

Line 44: insert into CS_INCIDENT_SEVERITIES_B (

40: cursor C is select ROWID from CS_INCIDENT_SEVERITIES_B
41: where INCIDENT_SEVERITY_ID = X_INCIDENT_SEVERITY_ID
42: ;
43: begin
44: insert into CS_INCIDENT_SEVERITIES_B (
45: INCIDENT_SEVERITY_ID,
46: DISPLAY_COLOR,
47: ATTRIBUTE6,
48: INCIDENT_SUBTYPE,

Line 211: from CS_INCIDENT_SEVERITIES_B

207: RGB_COLOR,
208: DEFECT_SEVERITY_ID,
209: -- Added priority code --anmukher --09/01/03
210: PRIORITY_CODE
211: from CS_INCIDENT_SEVERITIES_B
212: where INCIDENT_SEVERITY_ID = X_INCIDENT_SEVERITY_ID
213: for update of INCIDENT_SEVERITY_ID nowait;
214: recinfo c%rowtype;
215:

Line 340: update CS_INCIDENT_SEVERITIES_B set

336: --Added priority code for Misc ERs project (11.5.10) --anmukher --09/01/03
337: X_PRIORITY_CODE in VARCHAR2
338: ) is
339: begin
340: update CS_INCIDENT_SEVERITIES_B set
341: DISPLAY_COLOR = X_DISPLAY_COLOR,
342: ATTRIBUTE6 = X_ATTRIBUTE6,
343: INCIDENT_SUBTYPE = X_INCIDENT_SUBTYPE,
344: IMPORTANCE_LEVEL = X_IMPORTANCE_LEVEL,

Line 402: delete from CS_INCIDENT_SEVERITIES_B

398: if (sql%notfound) then
399: raise no_data_found;
400: end if;
401:
402: delete from CS_INCIDENT_SEVERITIES_B
403: where INCIDENT_SEVERITY_ID = X_INCIDENT_SEVERITY_ID;
404:
405: if (sql%notfound) then
406: raise no_data_found;

Line 416: from CS_INCIDENT_SEVERITIES_B B

412: begin
413: delete from CS_INCIDENT_SEVERITIES_TL T
414: where not exists
415: (select NULL
416: from CS_INCIDENT_SEVERITIES_B B
417: where B.INCIDENT_SEVERITY_ID = T.INCIDENT_SEVERITY_ID
418: );
419:
420: update CS_INCIDENT_SEVERITIES_TL T set (