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;
55:
56: FOR c_statusGroups_rec in c_statusGroups(p_statusGroupId) LOOP
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;
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;
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;
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: