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;
75: X_DESCRIPTION => c_statusGroups_rec.description,
76: X_LANGUAGE => c_statusGroups_rec.language ,
77: X_SOURCE_LANG => c_statusGroups_rec.source_lang ,
78: X_CREATION_DATE => sysdate,
79: X_CREATED_BY => FND_GLOBAL.USER_ID ,
80: X_LAST_UPDATE_DATE => sysdate ,
81: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
82: X_LAST_UPDATE_LOGIN => null) ;
83: EXCEPTION
77: X_SOURCE_LANG => c_statusGroups_rec.source_lang ,
78: X_CREATION_DATE => sysdate,
79: X_CREATED_BY => FND_GLOBAL.USER_ID ,
80: X_LAST_UPDATE_DATE => sysdate ,
81: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
82: X_LAST_UPDATE_LOGIN => null) ;
83: EXCEPTION
84: WHEN others THEN
85: x_errorCode := 1;
107: security_group_id,
108: object_version_number)
109: VALUES (
110: lv_new_statusgroupID,
111: FND_GLOBAL.USER_ID,
112: sysdate,
113: c_statusGroups_rec.start_date,
114: c_statusGroups_rec.end_date,
115: sysdate,
112: sysdate,
113: c_statusGroups_rec.start_date,
114: c_statusGroups_rec.end_date,
115: sysdate,
116: FND_GLOBAL.LOGIN_ID,
117: FND_GLOBAL.USER_ID,
118: c_statusGroups_rec.default_incident_status_id,
119: c_statusGroups_rec.security_group_id,
120: 0);
113: c_statusGroups_rec.start_date,
114: c_statusGroups_rec.end_date,
115: sysdate,
116: FND_GLOBAL.LOGIN_ID,
117: FND_GLOBAL.USER_ID,
118: c_statusGroups_rec.default_incident_status_id,
119: c_statusGroups_rec.security_group_id,
120: 0);
121:
133: language,
134: source_lang )
135: VALUES (
136: lv_new_statusgroupID,
137: FND_GLOBAL.USER_ID,
138: sysdate,
139: sysdate,
140: FND_GLOBAL.LOGIN_ID,
141: FND_GLOBAL.USER_ID,
136: lv_new_statusgroupID,
137: FND_GLOBAL.USER_ID,
138: sysdate,
139: sysdate,
140: FND_GLOBAL.LOGIN_ID,
141: FND_GLOBAL.USER_ID,
142: lv_copy_of_group_name,
143: c_statusGroups_rec.description,
144: c_statusGroups_rec.language,
137: FND_GLOBAL.USER_ID,
138: sysdate,
139: sysdate,
140: FND_GLOBAL.LOGIN_ID,
141: FND_GLOBAL.USER_ID,
142: lv_copy_of_group_name,
143: c_statusGroups_rec.description,
144: c_statusGroups_rec.language,
145: c_statusGroups_rec.source_lang );
164: incident_status_id,
165: object_version_number)
166: VALUES (
167: lv_new_statusgroupID,
168: FND_GLOBAL.USER_ID,
169: sysdate,
170: c_allowedStatuses_rec.start_date,
171: c_allowedStatuses_rec.end_date,
172: sysdate,
169: sysdate,
170: c_allowedStatuses_rec.start_date,
171: c_allowedStatuses_rec.end_date,
172: sysdate,
173: FND_GLOBAL.LOGIN_ID,
174: FND_GLOBAL.USER_ID,
175: CS_SR_ALLOWED_STATUSES_S.nextval,
176: c_allowedStatuses_rec.incident_status_id,
177: 0);
170: c_allowedStatuses_rec.start_date,
171: c_allowedStatuses_rec.end_date,
172: sysdate,
173: FND_GLOBAL.LOGIN_ID,
174: FND_GLOBAL.USER_ID,
175: CS_SR_ALLOWED_STATUSES_S.nextval,
176: c_allowedStatuses_rec.incident_status_id,
177: 0);
178: END LOOP;
235: task_template_id, -- 11825540
236: workflow) -- 11825540 )
237: VALUES (
238: lv_new_statusgroupID,
239: FND_GLOBAL.USER_ID,
240: sysdate,
241: c_statusTransitions_rec.start_date,
242: c_statusTransitions_rec.end_date,
243: sysdate,
240: sysdate,
241: c_statusTransitions_rec.start_date,
242: c_statusTransitions_rec.end_date,
243: sysdate,
244: FND_GLOBAL.LOGIN_ID,
245: FND_GLOBAL.USER_ID,
246: CS_SR_STATUS_TRANSITIONS_S.nextval,
247: l_from_allowed_status_id,
248: l_to_allowed_status_id,
241: c_statusTransitions_rec.start_date,
242: c_statusTransitions_rec.end_date,
243: sysdate,
244: FND_GLOBAL.LOGIN_ID,
245: FND_GLOBAL.USER_ID,
246: CS_SR_STATUS_TRANSITIONS_S.nextval,
247: l_from_allowed_status_id,
248: l_to_allowed_status_id,
249: c_StatusTransitions_rec.from_incident_status_id,