APPS.CUG_SR_TYPE_ATTR_MAPS_PKG dependencies on CUG_SR_TYPE_ATTR_MAPS_B

Line 44: cursor C is select ROWID from CUG_SR_TYPE_ATTR_MAPS_B

40: X_LAST_UPDATE_DATE in DATE,
41: X_LAST_UPDATED_BY in NUMBER,
42: X_LAST_UPDATE_LOGIN in NUMBER
43: ) is
44: cursor C is select ROWID from CUG_SR_TYPE_ATTR_MAPS_B
45: where SR_TYPE_ATTR_MAP_ID = X_SR_TYPE_ATTR_MAP_ID
46: ;
47: begin
48: insert into CUG_SR_TYPE_ATTR_MAPS_B (

Line 48: insert into CUG_SR_TYPE_ATTR_MAPS_B (

44: cursor C is select ROWID from CUG_SR_TYPE_ATTR_MAPS_B
45: where SR_TYPE_ATTR_MAP_ID = X_SR_TYPE_ATTR_MAP_ID
46: ;
47: begin
48: insert into CUG_SR_TYPE_ATTR_MAPS_B (
49: SR_TYPE_ATTR_SEQ_NUM,
50: SR_TYPE_ATTR_MAP_ID,
51: OBJECT_VERSION_NUMBER,
52: INCIDENT_TYPE_ID,

Line 233: from CUG_SR_TYPE_ATTR_MAPS_B

229: TEMPLATE_ID,
230: REQD_FOR_CLOSE_FLAG,
231: SHOW_ON_UPDATE_FLAG,
232: UPDATE_ALLOWED_FLAG
233: from CUG_SR_TYPE_ATTR_MAPS_B
234: where SR_TYPE_ATTR_MAP_ID = X_SR_TYPE_ATTR_MAP_ID
235: for update of SR_TYPE_ATTR_MAP_ID nowait;
236: recinfo c%rowtype;
237:

Line 373: update CUG_SR_TYPE_ATTR_MAPS_B set

369: X_LAST_UPDATED_BY in NUMBER,
370: X_LAST_UPDATE_LOGIN in NUMBER
371: ) is
372: begin
373: update CUG_SR_TYPE_ATTR_MAPS_B set
374: SR_TYPE_ATTR_SEQ_NUM = X_SR_TYPE_ATTR_SEQ_NUM,
375: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
376: INCIDENT_TYPE_ID = X_INCIDENT_TYPE_ID,
377: SR_ATTRIBUTE_CODE = X_SR_ATTRIBUTE_CODE,

Line 439: delete from CUG_SR_TYPE_ATTR_MAPS_B

435: if (sql%notfound) then
436: raise no_data_found;
437: end if;
438:
439: delete from CUG_SR_TYPE_ATTR_MAPS_B
440: where SR_TYPE_ATTR_MAP_ID = X_SR_TYPE_ATTR_MAP_ID;
441:
442: if (sql%notfound) then
443: raise no_data_found;

Line 453: from CUG_SR_TYPE_ATTR_MAPS_B B

449: begin
450: delete from CUG_SR_TYPE_ATTR_MAPS_TL T
451: where not exists
452: (select NULL
453: from CUG_SR_TYPE_ATTR_MAPS_B B
454: where B.SR_TYPE_ATTR_MAP_ID = T.SR_TYPE_ATTR_MAP_ID
455: );
456:
457: update CUG_SR_TYPE_ATTR_MAPS_TL T set (