APPS.CS_INCIDENT_STATUSES_PKG dependencies on CS_INCIDENT_STATUSES_B

Line 58: cursor C is select ROWID from CS_INCIDENT_STATUSES_B

54: p_REJECTION_ACTION_STATUS_ID IN NUMBER,
55: p_APPROVAL_ACTION_STATUS_ID IN NUMBER,
56: X_DUP_CHK_FLAG in VARCHAR2
57: ) is
58: cursor C is select ROWID from CS_INCIDENT_STATUSES_B
59: where INCIDENT_STATUS_ID = X_INCIDENT_STATUS_ID
60: ;
61: begin
62: insert into CS_INCIDENT_STATUSES_B (

Line 62: insert into CS_INCIDENT_STATUSES_B (

58: cursor C is select ROWID from CS_INCIDENT_STATUSES_B
59: where INCIDENT_STATUS_ID = X_INCIDENT_STATUS_ID
60: ;
61: begin
62: insert into CS_INCIDENT_STATUSES_B (
63: ATTRIBUTE10,
64: ATTRIBUTE11,
65: ATTRIBUTE12,
66: ATTRIBUTE13,

Line 300: from CS_INCIDENT_STATUSES_B

296: INTERMEDIATE_STATUS_ID ,
297: REJECTION_ACTION_STATUS_ID ,
298: APPROVAL_ACTION_STATUS_ID,
299: DUP_CHK_FLAG --shachoud
300: from CS_INCIDENT_STATUSES_B
301: where INCIDENT_STATUS_ID = X_INCIDENT_STATUS_ID
302: for update of INCIDENT_STATUS_ID nowait;
303: recinfo c%rowtype;
304:

Line 496: update CS_INCIDENT_STATUSES_B set

492: p_APPROVAL_ACTION_STATUS_ID IN NUMBER,
493: X_DUP_CHK_FLAG IN VARCHAR2 --shachoud
494: ) is
495: begin
496: update CS_INCIDENT_STATUSES_B set
497: ATTRIBUTE10 = X_ATTRIBUTE10,
498: ATTRIBUTE11 = X_ATTRIBUTE11,
499: ATTRIBUTE12 = X_ATTRIBUTE12,
500: ATTRIBUTE13 = X_ATTRIBUTE13,

Line 777: delete from CS_INCIDENT_STATUSES_B

773: if (sql%notfound) then
774: raise no_data_found;
775: end if;
776:
777: delete from CS_INCIDENT_STATUSES_B
778: where INCIDENT_STATUS_ID = X_INCIDENT_STATUS_ID;
779:
780: if (sql%notfound) then
781: raise no_data_found;

Line 791: from CS_INCIDENT_STATUSES_B B

787: begin
788: delete from CS_INCIDENT_STATUSES_TL T
789: where not exists
790: (select NULL
791: from CS_INCIDENT_STATUSES_B B
792: where B.INCIDENT_STATUS_ID = T.INCIDENT_STATUS_ID
793: );
794:
795: update CS_INCIDENT_STATUSES_TL T set (