APPS.CS_INCIDENTS_EXT_PKG dependencies on CS_INCIDENTS_EXT_B

Line 150: cursor C is select ROWID from CS_INCIDENTS_EXT_B

146: X_LAST_UPDATE_DATE in DATE,
147: X_LAST_UPDATED_BY in NUMBER,
148: X_LAST_UPDATE_LOGIN in NUMBER
149: ) is
150: cursor C is select ROWID from CS_INCIDENTS_EXT_B
151: where EXTENSION_ID = X_EXTENSION_ID
152: ;
153: begin
154: insert into CS_INCIDENTS_EXT_B (

Line 154: insert into CS_INCIDENTS_EXT_B (

150: cursor C is select ROWID from CS_INCIDENTS_EXT_B
151: where EXTENSION_ID = X_EXTENSION_ID
152: ;
153: begin
154: insert into CS_INCIDENTS_EXT_B (
155: C_EXT_ATTR47,
156: C_EXT_ATTR48,
157: C_EXT_ATTR49,
158: C_EXT_ATTR50,

Line 758: from CS_INCIDENTS_EXT_B

754: C_EXT_ATTR43,
755: C_EXT_ATTR44,
756: C_EXT_ATTR45,
757: C_EXT_ATTR46
758: from CS_INCIDENTS_EXT_B
759: where EXTENSION_ID = X_EXTENSION_ID
760: for update of EXTENSION_ID nowait;
761: recinfo c%rowtype;
762:

Line 1226: update CS_INCIDENTS_EXT_B set

1222: X_LAST_UPDATED_BY in NUMBER,
1223: X_LAST_UPDATE_LOGIN in NUMBER
1224: ) is
1225: begin
1226: update CS_INCIDENTS_EXT_B set
1227: C_EXT_ATTR47 = X_C_EXT_ATTR47,
1228: C_EXT_ATTR48 = X_C_EXT_ATTR48,
1229: C_EXT_ATTR49 = X_C_EXT_ATTR49,
1230: C_EXT_ATTR50 = X_C_EXT_ATTR50,

Line 1398: delete from CS_INCIDENTS_EXT_B

1394: if (sql%notfound) then
1395: raise no_data_found;
1396: end if;
1397:
1398: delete from CS_INCIDENTS_EXT_B
1399: where EXTENSION_ID = X_EXTENSION_ID;
1400:
1401: if (sql%notfound) then
1402: raise no_data_found;

Line 1412: from CS_INCIDENTS_EXT_B B

1408: begin
1409: delete from CS_INCIDENTS_EXT_TL T
1410: where not exists
1411: (select NULL
1412: from CS_INCIDENTS_EXT_B B
1413: where B.EXTENSION_ID = T.EXTENSION_ID
1414: );
1415:
1416: update CS_INCIDENTS_EXT_TL T set (