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