APPS.CS_INCIDENT_STATUSES_PKG dependencies on CS_INCIDENT_STATUSES_B

Line 57: cursor C is select ROWID from CS_INCIDENT_STATUSES_B

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

Line 61: insert into CS_INCIDENT_STATUSES_B (

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

Line 295: from CS_INCIDENT_STATUSES_B

291: PENDING_APPROVAL_FLAG ,
292: INTERMEDIATE_STATUS_ID ,
293: REJECTION_ACTION_STATUS_ID ,
294: APPROVAL_ACTION_STATUS_ID
295: from CS_INCIDENT_STATUSES_B
296: where INCIDENT_STATUS_ID = X_INCIDENT_STATUS_ID
297: for update of INCIDENT_STATUS_ID nowait;
298: recinfo c%rowtype;
299:

Line 486: update CS_INCIDENT_STATUSES_B set

482: p_REJECTION_ACTION_STATUS_ID IN NUMBER,
483: p_APPROVAL_ACTION_STATUS_ID IN NUMBER
484: ) is
485: begin
486: update CS_INCIDENT_STATUSES_B set
487: ATTRIBUTE10 = X_ATTRIBUTE10,
488: ATTRIBUTE11 = X_ATTRIBUTE11,
489: ATTRIBUTE12 = X_ATTRIBUTE12,
490: ATTRIBUTE13 = X_ATTRIBUTE13,

Line 759: delete from CS_INCIDENT_STATUSES_B

755: if (sql%notfound) then
756: raise no_data_found;
757: end if;
758:
759: delete from CS_INCIDENT_STATUSES_B
760: where INCIDENT_STATUS_ID = X_INCIDENT_STATUS_ID;
761:
762: if (sql%notfound) then
763: raise no_data_found;

Line 773: from CS_INCIDENT_STATUSES_B B

769: begin
770: delete from CS_INCIDENT_STATUSES_TL T
771: where not exists
772: (select NULL
773: from CS_INCIDENT_STATUSES_B B
774: where B.INCIDENT_STATUS_ID = T.INCIDENT_STATUS_ID
775: );
776:
777: update CS_INCIDENT_STATUSES_TL T set (