DBA Data[Home] [Help]

APPS.IEX_STRY_API_PUB dependencies on IEX_STRY_TEMP_WORK_ITEMS_TL

Line 975: INSERT INTO IEX_STRY_TEMP_WORK_ITEMS_TL

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:
975: INSERT INTO IEX_STRY_TEMP_WORK_ITEMS_TL
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,

Line 981: from iex_stry_temp_work_items_tl B, FND_LANGUAGES L

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:
985: INSERT INTO iex_strategy_work_skills