APPS.CS_SR_STATUS_GROUPS_PKG dependencies on CS_SR_STATUS_GROUPS_B

Line 25: cursor C is select ROWID from CS_SR_STATUS_GROUPS_B

21: X_LAST_UPDATED_BY in NUMBER,
22: X_LAST_UPDATE_LOGIN in NUMBER)
23:
24: IS
25: cursor C is select ROWID from CS_SR_STATUS_GROUPS_B
26: where STATUS_GROUP_ID = X_STATUS_GROUP_ID;
27:
28: cursor c1 is
29: select cs_sr_status_groups_b_s.nextval

Line 29: select cs_sr_status_groups_b_s.nextval

25: cursor C is select ROWID from CS_SR_STATUS_GROUPS_B
26: where STATUS_GROUP_ID = X_STATUS_GROUP_ID;
27:
28: cursor c1 is
29: select cs_sr_status_groups_b_s.nextval
30: from dual;
31:
32: l_status_group_id NUMBER ;
33:

Line 41: INSERT INTO CS_SR_STATUS_GROUPS_B (

37: fetch c1 into l_status_group_id;
38: close c1;
39: end if;
40:
41: INSERT INTO CS_SR_STATUS_GROUPS_B (
42: STATUS_GROUP_ID,
43: SECURITY_GROUP_ID,
44: TRANSITION_IND,
45: DEFAULT_INCIDENT_STATUS_ID,

Line 133: from CS_SR_STATUS_GROUPS_B

129: ORIG_SYSTEM_REFERENCE_ID,
130: END_DATE,
131: START_DATE,
132: DEFAULT_INCIDENT_STATUS_ID
133: from CS_SR_STATUS_GROUPS_B
134: where STATUS_GROUP_ID = X_STATUS_GROUP_ID
135: for update of STATUS_GROUP_ID nowait;
136: recinfo c%rowtype;
137:

Line 215: UPDATE CS_SR_STATUS_GROUPS_B set

211: X_LAST_UPDATE_LOGIN in NUMBER) is
212:
213: begin
214:
215: UPDATE CS_SR_STATUS_GROUPS_B set
216: SECURITY_GROUP_ID = X_SECURITY_GROUP_ID,
217: TRANSITION_IND = X_TRANSITION_IND,
218: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
219: ORIG_SYSTEM_REFERENCE_ID = X_ORIG_SYSTEM_REFERENCE_ID,

Line 260: delete from CS_SR_STATUS_GROUPS_B

256: if (sql%notfound) then
257: raise no_data_found;
258: end if;
259:
260: delete from CS_SR_STATUS_GROUPS_B
261: where STATUS_GROUP_ID = X_STATUS_GROUP_ID;
262:
263: if (sql%notfound) then
264: raise no_data_found;

Line 275: from CS_SR_STATUS_GROUPS_B B

271: BEGIN
272:
273: delete from CS_SR_STATUS_GROUPS_TL T
274: where not exists ( select NULL
275: from CS_SR_STATUS_GROUPS_B B
276: where B.STATUS_GROUP_ID = T.STATUS_GROUP_ID );
277:
278: update CS_SR_STATUS_GROUPS_TL T
279: set ( GROUP_NAME,