APPS.CS_ALW_STS_TRANSITIONS_PVT dependencies on CS_SR_STATUS_TRANSITIONS

Line 38: FROM CS_SR_STATUS_TRANSITIONS

34:
35:
36: CURSOR c_StatusTransitions(p_statusGroupId VARCHAR2) IS
37: SELECT *
38: FROM CS_SR_STATUS_TRANSITIONS
39: WHERE status_group_id = p_statusGroupId;
40:
41: lv_new_statusgroupID NUMBER:=NULL;
42: --lv_new_allowstatusID NUMBER:=NULL;

Line 186: --Insert a new record into CS_SR_STATUS_TRANSITIONS

182:
183: l_from_allowed_status_id := null;
184: l_to_allowed_status_id := null;
185:
186: --Insert a new record into CS_SR_STATUS_TRANSITIONS
187:
188: -- get from_allowed_status_id from the allowed statuses for the new status group
189:
190: BEGIN

Line 220: INSERT INTO CS_SR_STATUS_TRANSITIONS(

216: x_errorMessage := SUBSTR(SQLERRM,1,280);
217: EXIT ;
218: END ;
219:
220: INSERT INTO CS_SR_STATUS_TRANSITIONS(
221: status_group_id,
222: created_by,
223: creation_date,
224: start_date,

Line 246: CS_SR_STATUS_TRANSITIONS_S.nextval,

242: c_statusTransitions_rec.end_date,
243: sysdate,
244: FND_GLOBAL.LOGIN_ID,
245: FND_GLOBAL.USER_ID,
246: CS_SR_STATUS_TRANSITIONS_S.nextval,
247: l_from_allowed_status_id,
248: l_to_allowed_status_id,
249: c_StatusTransitions_rec.from_incident_status_id,
250: c_StatusTransitions_rec.to_incident_status_id,

Line 276: FROM cs_sr_status_transitions

272: IS
273:
274: CURSOR c_Findstatus(p_allowed_status_id number,p_statusGroupId number) IS
275: SELECT start_date
276: FROM cs_sr_status_transitions
277: WHERE (from_allowed_status_id = p_allowed_status_id
278: OR to_allowed_status_id = p_allowed_status_id)
279: AND status_group_id = p_statusGroupId;
280:

Line 311: FROM cs_sr_status_transitions

307: IS
308:
309: CURSOR c_FindEndDate(p_allowed_status_id number,p_statusGroupId number) IS
310: SELECT end_date,status_group_id
311: FROM cs_sr_status_transitions
312: WHERE (from_allowed_status_id = p_allowed_status_id
313: OR to_allowed_status_id = p_allowed_status_id)
314: AND status_group_id = p_statusGroupId;
315:

Line 472: FROM cs_sr_status_transitions

468:
469: BEGIN
470: SELECT count(0)
471: INTO Status_Transition_Counter
472: FROM cs_sr_status_transitions
473: WHERE status_group_id = p_statusGroupId;
474:
475: IF (Status_Transition_Counter > 0) THEN
476: Indicator := 'Y';