APPS.CS_ALW_STS_TRANSITIONS_PVT dependencies on CS_SR_ALLOWED_STATUSES

Line 31: FROM CS_SR_ALLOWED_STATUSES

27:
28:
29: CURSOR c_allowedStatuses(p_statusGroupId VARCHAR2) IS
30: SELECT *
31: FROM CS_SR_ALLOWED_STATUSES
32: WHERE status_group_id = p_statusGroupId;
33:
34:
35: CURSOR c_StatusTransitions(p_statusGroupId VARCHAR2) IS

Line 151: --Insert a new record into CS_SR_ALLOWED_STATUSES

147: END LOOP;
148:
149: FOR c_allowedStatuses_rec in c_allowedStatuses(p_statusGroupId) LOOP
150:
151: --Insert a new record into CS_SR_ALLOWED_STATUSES
152:
153: INSERT INTO CS_SR_ALLOWED_STATUSES(
154: status_group_id,
155: created_by,

Line 153: INSERT INTO CS_SR_ALLOWED_STATUSES(

149: FOR c_allowedStatuses_rec in c_allowedStatuses(p_statusGroupId) LOOP
150:
151: --Insert a new record into CS_SR_ALLOWED_STATUSES
152:
153: INSERT INTO CS_SR_ALLOWED_STATUSES(
154: status_group_id,
155: created_by,
156: creation_date,
157: start_date,

Line 174: CS_SR_ALLOWED_STATUSES_S.nextval,

170: c_allowedStatuses_rec.end_date,
171: sysdate,
172: FND_GLOBAL.LOGIN_ID,
173: FND_GLOBAL.USER_ID,
174: CS_SR_ALLOWED_STATUSES_S.nextval,
175: c_allowedStatuses_rec.incident_status_id,
176: 0);
177: END LOOP;
178:

Line 193: FROM cs_sr_allowed_statuses

189: BEGIN
190:
191: SELECT allowed_status_id
192: INTO l_from_allowed_status_id
193: FROM cs_sr_allowed_statuses
194: WHERE status_group_id = lv_new_statusgroupID
195: AND incident_status_id = c_StatusTransitions_rec.from_incident_status_id ;
196:
197: EXCEPTION

Line 208: FROM cs_sr_allowed_statuses

204: BEGIN
205:
206: SELECT allowed_status_id
207: INTO l_to_allowed_status_id
208: FROM cs_sr_allowed_statuses
209: WHERE status_group_id = lv_new_statusgroupID
210: AND incident_status_id = c_StatusTransitions_rec.to_incident_status_id ;
211:
212: EXCEPTION

Line 354: FROM cs_sr_allowed_statuses

350:
351: BEGIN
352: SELECT start_date
353: INTO l_returnStartDate
354: FROM cs_sr_allowed_statuses
355: WHERE allowed_status_id = p_allowed_status_id
356: AND ROWNUM < 2;
357:
358: return l_returnStartDate;

Line 371: FROM cs_sr_allowed_statuses

367:
368: BEGIN
369: SELECT end_date
370: INTO l_returnEndDate
371: FROM cs_sr_allowed_statuses
372: WHERE allowed_status_id = p_allowed_status_id
373: AND ROWNUM < 2;
374:
375: return l_returnEndDate;

Line 429: UPDATE cs_sr_allowed_statuses

425: x_return_code := 'S';
426:
427:
428: IF (p_new_end_date is null) THEN
429: UPDATE cs_sr_allowed_statuses
430: SET end_date = null
431: WHERE allowed_status_id in (p_to_allowed_status_id,p_from_allowed_status_id)
432: AND status_group_id = p_statusGroupId;
433: ELSE