APPS.CS_ALW_STS_TRANSITIONS_PVT dependencies on CS_SR_STATUS_GROUPS_B

Line 50: SELECT CS_SR_STATUS_GROUPS_B_S.nextval INTO lv_new_statusgroupID FROM DUAL;

46: l_to_allowed_status_id NUMBER;
47: l_row_id VARCHAR2(1000);
48: BEGIN
49:
50: SELECT CS_SR_STATUS_GROUPS_B_S.nextval INTO lv_new_statusgroupID FROM DUAL;
51:
52: FND_MESSAGE.SET_NAME('CS','CS_SR_COPY_OF');
53: -- l_copy_of :=FND_MESSAGE.GET || fnd_global.local_CHR(10);
54: l_copy_of :=FND_MESSAGE.GET;

Line 59: -- Create a Status group record in cs_sr_status_groups_b and cs_sr_status_groups_tl table

55:
56: FOR c_statusGroups_rec in c_statusGroups(p_statusGroupId) LOOP
57: lv_copy_of_group_name := l_copy_of||' '||c_statusGroups_rec.group_name||'-'||lv_new_statusgroupID;
58:
59: -- Create a Status group record in cs_sr_status_groups_b and cs_sr_status_groups_tl table
60:
61: -- bug 3625236 - Reverse the parameters passed to start and end date
62: BEGIN
63: CS_SR_STATUS_GROUPS_PKG.INSERT_ROW

Line 91: /*** Commented since the insert into cs_sr_status_groups_b and cs_sr_status_groups_tl will be

87:
88: END ;
89:
90:
91: /*** Commented since the insert into cs_sr_status_groups_b and cs_sr_status_groups_tl will be
92: done using table handlers as above
93:
94: --Insert a new record into CS_SR_STATUS_GROUPS_B
95:

Line 94: --Insert a new record into CS_SR_STATUS_GROUPS_B

90:
91: /*** Commented since the insert into cs_sr_status_groups_b and cs_sr_status_groups_tl will be
92: done using table handlers as above
93:
94: --Insert a new record into CS_SR_STATUS_GROUPS_B
95:
96: INSERT INTO CS_SR_STATUS_GROUPS_B(
97: status_group_id,
98: created_by,

Line 96: INSERT INTO CS_SR_STATUS_GROUPS_B(

92: done using table handlers as above
93:
94: --Insert a new record into CS_SR_STATUS_GROUPS_B
95:
96: INSERT INTO CS_SR_STATUS_GROUPS_B(
97: status_group_id,
98: created_by,
99: creation_date,
100: start_date,

Line 313: FROM cs_sr_status_groups_b

309: AND status_group_id = p_statusGroupId;
310:
311: CURSOR c_def_active (p_statusgroupid number) IS
312: SELECT default_incident_status_id
313: FROM cs_sr_status_groups_b
314: WHERE status_group_id = p_statusgroupid ;
315:
316: BEGIN
317:

Line 476: UPDATE cs_sr_status_groups_b

472: ELSE
473: Indicator := null;
474: END IF;
475:
476: UPDATE cs_sr_status_groups_b
477: SET transition_ind = Indicator
478: WHERE status_group_id = p_statusGroupId;
479:
480: END Set_Transition_Ind;