DBA Data[Home] [Help]

APPS.IEX_STRY_API_PUB dependencies on FND_LANGUAGES

Line 1097: from iex_stry_temp_work_items_tl B, FND_LANGUAGES L

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;

Line 1137: from iex_stry_temp_work_items_tl B, FND_LANGUAGES L

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