APPS.CS_ALW_STS_TRANSITIONS_PVT dependencies on CS_SR_STATUS_GROUPS_B

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

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

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

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

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

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

Line 95: --Insert a new record into CS_SR_STATUS_GROUPS_B

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

Line 97: INSERT INTO CS_SR_STATUS_GROUPS_B(

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

Line 318: FROM cs_sr_status_groups_b

314: AND status_group_id = p_statusGroupId;
315:
316: CURSOR c_def_active (p_statusgroupid number) IS
317: SELECT default_incident_status_id
318: FROM cs_sr_status_groups_b
319: WHERE status_group_id = p_statusgroupid ;
320:
321: BEGIN
322:

Line 481: UPDATE cs_sr_status_groups_b

477: ELSE
478: Indicator := null;
479: END IF;
480:
481: UPDATE cs_sr_status_groups_b
482: SET transition_ind = Indicator
483: WHERE status_group_id = p_statusGroupId;
484:
485: END Set_Transition_Ind;