APPS.CS_ALW_STS_TRANSITIONS_PVT dependencies on CS_SR_ALLOWED_STATUSES

Line 32: FROM CS_SR_ALLOWED_STATUSES

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

Line 152: --Insert a new record into CS_SR_ALLOWED_STATUSES

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

Line 154: INSERT INTO CS_SR_ALLOWED_STATUSES(

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

Line 175: CS_SR_ALLOWED_STATUSES_S.nextval,

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

Line 194: FROM cs_sr_allowed_statuses

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

Line 209: FROM cs_sr_allowed_statuses

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

Line 359: FROM cs_sr_allowed_statuses

355:
356: BEGIN
357: SELECT start_date
358: INTO l_returnStartDate
359: FROM cs_sr_allowed_statuses
360: WHERE allowed_status_id = p_allowed_status_id
361: AND ROWNUM < 2;
362:
363: return l_returnStartDate;

Line 376: FROM cs_sr_allowed_statuses

372:
373: BEGIN
374: SELECT end_date
375: INTO l_returnEndDate
376: FROM cs_sr_allowed_statuses
377: WHERE allowed_status_id = p_allowed_status_id
378: AND ROWNUM < 2;
379:
380: return l_returnEndDate;

Line 434: UPDATE cs_sr_allowed_statuses

430: x_return_code := 'S';
431:
432:
433: IF (p_new_end_date is null) THEN
434: UPDATE cs_sr_allowed_statuses
435: SET end_date = null
436: WHERE allowed_status_id in (p_to_allowed_status_id,p_from_allowed_status_id)
437: AND status_group_id = p_statusGroupId;
438: ELSE