APPS.CUG_INCIDNT_ATTR_VALS_PKG dependencies on CUG_INCIDNT_ATTR_VALS_B

Line 33: cursor C is select ROWID from CUG_INCIDNT_ATTR_VALS_B

29: X_LAST_UPDATE_DATE in DATE,
30: X_LAST_UPDATED_BY in NUMBER,
31: X_LAST_UPDATE_LOGIN in NUMBER
32: ) is
33: cursor C is select ROWID from CUG_INCIDNT_ATTR_VALS_B
34: where INCIDNT_ATTR_VAL_ID = X_INCIDNT_ATTR_VAL_ID
35: ;
36: begin
37: insert into CUG_INCIDNT_ATTR_VALS_B (

Line 37: insert into CUG_INCIDNT_ATTR_VALS_B (

33: cursor C is select ROWID from CUG_INCIDNT_ATTR_VALS_B
34: where INCIDNT_ATTR_VAL_ID = X_INCIDNT_ATTR_VAL_ID
35: ;
36: begin
37: insert into CUG_INCIDNT_ATTR_VALS_B (
38: INCIDNT_ATTR_VAL_ID,
39: OBJECT_VERSION_NUMBER,
40: INCIDENT_ID,
41: SR_ATTRIBUTE_CODE,

Line 177: from CUG_INCIDNT_ATTR_VALS_B

173: ATTRIBUTE13,
174: ATTRIBUTE14,
175: ATTRIBUTE15,
176: ATTRIBUTE_CATEGORY
177: from CUG_INCIDNT_ATTR_VALS_B
178: where INCIDNT_ATTR_VAL_ID = X_INCIDNT_ATTR_VAL_ID
179: for update of INCIDNT_ATTR_VAL_ID nowait;
180: recinfo c%rowtype;
181:

Line 287: update CUG_INCIDNT_ATTR_VALS_B set

283: X_LAST_UPDATED_BY in NUMBER,
284: X_LAST_UPDATE_LOGIN in NUMBER
285: ) is
286: begin
287: update CUG_INCIDNT_ATTR_VALS_B set
288: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
289: INCIDENT_ID = X_INCIDENT_ID,
290: SR_ATTRIBUTE_CODE = X_SR_ATTRIBUTE_CODE,
291: OVERRIDE_ADDR_VALID_FLAG = X_OVERRIDE_ADDR_VALID_FLAG,

Line 342: delete from CUG_INCIDNT_ATTR_VALS_B

338: if (sql%notfound) then
339: raise no_data_found;
340: end if;
341:
342: delete from CUG_INCIDNT_ATTR_VALS_B
343: where INCIDNT_ATTR_VAL_ID = X_INCIDNT_ATTR_VAL_ID;
344:
345: if (sql%notfound) then
346: raise no_data_found;

Line 356: from CUG_INCIDNT_ATTR_VALS_B B

352: begin
353: delete from CUG_INCIDNT_ATTR_VALS_TL T
354: where not exists
355: (select NULL
356: from CUG_INCIDNT_ATTR_VALS_B B
357: where B.INCIDNT_ATTR_VAL_ID = T.INCIDNT_ATTR_VAL_ID
358: );
359:
360: update CUG_INCIDNT_ATTR_VALS_TL T set (