APPS.CS_INCIDENT_TYPES_PKG dependencies on CS_INCIDENT_TYPES_B

Line 51: cursor C is select ROWID from CS_INCIDENT_TYPES_B

47: X_MAINTENANCE_FLAG in VARCHAR2,
48: X_IMAGE_FILE_NAME in VARCHAR2,
49: p_DETAILED_ERECORD_REQ_FLAG IN VARCHAR2
50: ) is
51: cursor C is select ROWID from CS_INCIDENT_TYPES_B
52: where INCIDENT_TYPE_ID = X_INCIDENT_TYPE_ID
53: ;
54:
55:

Line 72: insert into CS_INCIDENT_TYPES_B (

68:
69: begin
70:
71:
72: insert into CS_INCIDENT_TYPES_B (
73: ATTRIBUTE11,
74: ATTRIBUTE12,
75: ATTRIBUTE13,
76: ATTRIBUTE14,

Line 360: from CS_INCIDENT_TYPES_B

356: CMRO_FLAG ,
357: MAINTENANCE_FLAG,
358: IMAGE_FILE_NAME,
359: DETAILED_ERECORD_REQ_FLAG
360: from CS_INCIDENT_TYPES_B
361: where INCIDENT_TYPE_ID = X_INCIDENT_TYPE_ID
362: for update of INCIDENT_TYPE_ID nowait;
363: recinfo c%rowtype;
364:

Line 549: l_old_srtype_rec CS_INCIDENT_TYPES_B%ROWTYPE;

545: p_DETAILED_ERECORD_REQ_FLAG IN VARCHAR2
546: ) is
547:
548: -- start for security
549: l_old_srtype_rec CS_INCIDENT_TYPES_B%ROWTYPE;
550: mapping_exist number;
551:
552: cursor c_create_map_csr IS
553: select *

Line 563: from cs_incident_types_b

559: begin
560:
561: select *
562: into l_old_srtype_rec
563: from cs_incident_types_b
564: where incident_type_id = X_INCIDENT_TYPE_ID;
565:
566:
567: update CS_INCIDENT_TYPES_B set

Line 567: update CS_INCIDENT_TYPES_B set

563: from cs_incident_types_b
564: where incident_type_id = X_INCIDENT_TYPE_ID;
565:
566:
567: update CS_INCIDENT_TYPES_B set
568: ATTRIBUTE11 = X_ATTRIBUTE11,
569: ATTRIBUTE12 = X_ATTRIBUTE12,
570: ATTRIBUTE13 = X_ATTRIBUTE13,
571: ATTRIBUTE14 = X_ATTRIBUTE14,

Line 901: delete from CS_INCIDENT_TYPES_B

897: if (sql%notfound) then
898: raise no_data_found;
899: end if;
900:
901: delete from CS_INCIDENT_TYPES_B
902: where INCIDENT_TYPE_ID = X_INCIDENT_TYPE_ID;
903:
904: if (sql%notfound) then
905: raise no_data_found;

Line 915: from CS_INCIDENT_TYPES_B B

911: begin
912: delete from CS_INCIDENT_TYPES_TL T
913: where not exists
914: (select NULL
915: from CS_INCIDENT_TYPES_B B
916: where B.INCIDENT_TYPE_ID = T.INCIDENT_TYPE_ID
917: );
918:
919: update CS_INCIDENT_TYPES_TL T set (