[Home] [Help]
966: )
967: select p_new_work_item_temp_id, competence_id, work_type, category_type, priority_type, optional_yn,
968: option_wait_time, option_wait_time_uom, pre_execution_wait, post_execution_wait, execution_time_uom,
969: closure_time_limit, closure_time_uom, workflow_item_type, same_resource_yn,
970: sysdate, fnd_global.user_id, fnd_global.user_id, sysdate, fnd_global.user_id, 1.0,
971: fulfil_temp_id, escalate_yn, notify_yn, schedule_wait, schedule_uom, enabled_flag, xdo_template_id
972: from iex_stry_temp_work_items_b
973: where work_item_temp_id = p_work_item_temp_id;
974:
976: (WORK_ITEM_TEMP_ID,NAME,DESCRIPTION,LANGUAGE,SOURCE_LANG,
977: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,LAST_UPDATED_BY
978: )
979: select p_new_work_item_temp_id, 'Copy of ' || b.name,b.description,l.language_code ,b.SOURCE_LANG,
980: sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,fnd_global.user_id
981: from iex_stry_temp_work_items_tl B, FND_LANGUAGES L
982: where L.INSTALLED_FLAG in ('I', 'B') and B.LANGUAGE = userenv('LANG')
983: and b.work_item_temp_id = p_work_item_temp_id;
984:
986: (work_skill_id, WORK_ITEM_TEMP_ID,competence_id,
987: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,LAST_UPDATED_BY, object_version_number
988: )
989: select iex_strategy_work_skills_s.NEXTVAL, p_new_work_item_temp_id, a.competence_id,
990: sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,fnd_global.user_id, a.object_version_number
991: from iex_strategy_work_skills a
992: where a.work_item_temp_id = p_work_item_temp_id;
993:
994: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1061:
1062:
1063:
1064: begin
1065: G_USER_ID := FND_GLOBAL.User_Id;
1066: PG_DEBUG := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1067: END IEX_STRY_API_PUB ;
1068:
1069: