[Home] [Help]
1080: SAVEPOINT COPY_WORK_ITEM;
1081:
1082: -- begin Bug 8233425
1083: begin
1084: select b.name into Newworkitemname from iex_stry_temp_work_items_tl B
1085: where B.LANGUAGE = userenv('LANG')
1086: and b.work_item_temp_id = p_work_item_temp_id;
1087:
1088: Newcnt := 1;
1093: Newworkitemname := 'Copy of ' ||Newworkitemname;
1094: iex_debug_pub.LogMessage( 'Inside Loop ... Newworkitemname === '||Newworkitemname );
1095:
1096: select count(name) into Newcnt
1097: from iex_stry_temp_work_items_tl B, FND_LANGUAGES L
1098: where L.INSTALLED_FLAG in ('I', 'B') and B.LANGUAGE = userenv('LANG')
1099: and b.name = Newworkitemname;
1100:
1101: End Loop;
1126: fulfil_temp_id, escalate_yn, notify_yn, schedule_wait, schedule_uom, enabled_flag, xdo_template_id
1127: from iex_stry_temp_work_items_b
1128: where work_item_temp_id = p_work_item_temp_id;
1129:
1130: INSERT INTO IEX_STRY_TEMP_WORK_ITEMS_TL
1131: (WORK_ITEM_TEMP_ID,NAME,DESCRIPTION,LANGUAGE,SOURCE_LANG,
1132: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,LAST_UPDATED_BY
1133: )
1134: -- Bug 8233425 select p_new_work_item_temp_id, 'Copy of ' || b.name,b.description,l.language_code ,b.SOURCE_LANG,
1133: )
1134: -- Bug 8233425 select p_new_work_item_temp_id, 'Copy of ' || b.name,b.description,l.language_code ,b.SOURCE_LANG,
1135: select p_new_work_item_temp_id, Newworkitemname,b.description,l.language_code ,b.SOURCE_LANG,
1136: sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,fnd_global.user_id
1137: from iex_stry_temp_work_items_tl B, FND_LANGUAGES L
1138: where L.INSTALLED_FLAG in ('I', 'B') and B.LANGUAGE = userenv('LANG')
1139: and b.work_item_temp_id = p_work_item_temp_id;
1140:
1141: INSERT INTO iex_strategy_work_skills