APPS.IEX_STRY_API_PUB dependencies on IEX_STRATEGY_WORK_SKILLS

Line 1141: INSERT INTO iex_strategy_work_skills

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
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,

Line 1145: select iex_strategy_work_skills_s.NEXTVAL, p_new_work_item_temp_id, a.competence_id,

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

Line 1147: from iex_strategy_work_skills a

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
1151: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || 'end.' );