APPS.CS_ALW_STS_TRANSITIONS_PVT dependencies on CS_SR_STATUS_TRANSITIONS

Line 37: FROM CS_SR_STATUS_TRANSITIONS

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

Line 185: --Insert a new record into CS_SR_STATUS_TRANSITIONS

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

Line 219: INSERT INTO CS_SR_STATUS_TRANSITIONS(

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

Line 243: CS_SR_STATUS_TRANSITIONS_S.nextval,

239: c_statusTransitions_rec.end_date,
240: sysdate,
241: FND_GLOBAL.LOGIN_ID,
242: FND_GLOBAL.USER_ID,
243: CS_SR_STATUS_TRANSITIONS_S.nextval,
244: l_from_allowed_status_id,
245: l_to_allowed_status_id,
246: c_StatusTransitions_rec.from_incident_status_id,
247: c_StatusTransitions_rec.to_incident_status_id,

Line 271: FROM cs_sr_status_transitions

267: IS
268:
269: CURSOR c_Findstatus(p_allowed_status_id number,p_statusGroupId number) IS
270: SELECT start_date
271: FROM cs_sr_status_transitions
272: WHERE (from_allowed_status_id = p_allowed_status_id
273: OR to_allowed_status_id = p_allowed_status_id)
274: AND status_group_id = p_statusGroupId;
275:

Line 306: FROM cs_sr_status_transitions

302: IS
303:
304: CURSOR c_FindEndDate(p_allowed_status_id number,p_statusGroupId number) IS
305: SELECT end_date,status_group_id
306: FROM cs_sr_status_transitions
307: WHERE (from_allowed_status_id = p_allowed_status_id
308: OR to_allowed_status_id = p_allowed_status_id)
309: AND status_group_id = p_statusGroupId;
310:

Line 467: FROM cs_sr_status_transitions

463:
464: BEGIN
465: SELECT count(0)
466: INTO Status_Transition_Counter
467: FROM cs_sr_status_transitions
468: WHERE status_group_id = p_statusGroupId;
469:
470: IF (Status_Transition_Counter > 0) THEN
471: Indicator := 'Y';