[Home] [Help]
1121: )
1122: select p_new_work_item_temp_id, competence_id, work_type, category_type, priority_type, optional_yn,
1123: option_wait_time, option_wait_time_uom, pre_execution_wait, post_execution_wait, execution_time_uom,
1124: closure_time_limit, closure_time_uom, workflow_item_type, same_resource_yn,
1125: sysdate, fnd_global.user_id, fnd_global.user_id, sysdate, fnd_global.user_id, 1.0,
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:
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,
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:
1142: (work_skill_id, WORK_ITEM_TEMP_ID,competence_id,
1143: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,LAST_UPDATED_BY, object_version_number
1144: )
1145: select iex_strategy_work_skills_s.NEXTVAL, p_new_work_item_temp_id, a.competence_id,
1146: sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,fnd_global.user_id, a.object_version_number
1147: from iex_strategy_work_skills a
1148: where a.work_item_temp_id = p_work_item_temp_id;
1149:
1150: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1217:
1218:
1219:
1220: begin
1221: G_USER_ID := FND_GLOBAL.User_Id;
1222: PG_DEBUG := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1223: END IEX_STRY_API_PUB ;
1224:
1225: