APPS.CS_INCIDENTS_PURGE_AUDIT_PKG dependencies on CS_INCIDENTS_PURGE_AUDIT_B

Line 24: cursor C is select ROWID from CS_INCIDENTS_PURGE_AUDIT_B

20: X_LAST_UPDATE_DATE in DATE,
21: X_LAST_UPDATED_BY in NUMBER,
22: X_LAST_UPDATE_LOGIN in NUMBER
23: ) is
24: cursor C is select ROWID from CS_INCIDENTS_PURGE_AUDIT_B
25: where INCIDENT_ID = X_INCIDENT_ID
26: ;
27: begin
28: insert into CS_INCIDENTS_PURGE_AUDIT_B (

Line 28: insert into CS_INCIDENTS_PURGE_AUDIT_B (

24: cursor C is select ROWID from CS_INCIDENTS_PURGE_AUDIT_B
25: where INCIDENT_ID = X_INCIDENT_ID
26: ;
27: begin
28: insert into CS_INCIDENTS_PURGE_AUDIT_B (
29: PURGED_BY,
30: INCIDENT_ID,
31: INCIDENT_NUMBER,
32: INCIDENT_TYPE_ID,

Line 133: from CS_INCIDENTS_PURGE_AUDIT_B

129: INC_CREATION_DATE,
130: INC_LAST_UPDATE_DATE,
131: PURGED_DATE,
132: PURGE_ID
133: from CS_INCIDENTS_PURGE_AUDIT_B
134: where INCIDENT_ID = X_INCIDENT_ID
135: for update of INCIDENT_ID nowait;
136: recinfo c%rowtype;
137:

Line 209: update CS_INCIDENTS_PURGE_AUDIT_B set

205: X_LAST_UPDATED_BY in NUMBER,
206: X_LAST_UPDATE_LOGIN in NUMBER
207: ) is
208: begin
209: update CS_INCIDENTS_PURGE_AUDIT_B set
210: PURGED_BY = X_PURGED_BY,
211: INCIDENT_NUMBER = X_INCIDENT_NUMBER,
212: INCIDENT_TYPE_ID = X_INCIDENT_TYPE_ID,
213: CUSTOMER_ID = X_CUSTOMER_ID,

Line 255: delete from CS_INCIDENTS_PURGE_AUDIT_B

251: if (sql%notfound) then
252: raise no_data_found;
253: end if;
254:
255: delete from CS_INCIDENTS_PURGE_AUDIT_B
256: where INCIDENT_ID = X_INCIDENT_ID;
257:
258: if (sql%notfound) then
259: raise no_data_found;

Line 269: from CS_INCIDENTS_PURGE_AUDIT_B B

265: begin
266: delete from CS_INCIDENTS_PURGE_AUDIT_TL T
267: where not exists
268: (select NULL
269: from CS_INCIDENTS_PURGE_AUDIT_B B
270: where B.INCIDENT_ID = T.INCIDENT_ID
271: );
272:
273: update CS_INCIDENTS_PURGE_AUDIT_TL T set (