DBA Data[Home] [Help]

APPS.IBE_M_MIGRATION_PVT dependencies on IBE_DSP_CONTEXT_B

Line 112: FROM IBE_DSP_CONTEXT_B

108: IS
109: -- Migrate the seed data too
110: CURSOR c_get_context_csr IS
111: SELECT CONTEXT_ID, ACCESS_NAME, COMPONENT_TYPE_CODE
112: FROM IBE_DSP_CONTEXT_B
113: WHERE CONTEXT_TYPE_CODE = 'MEDIA'
114: AND (COMPONENT_TYPE_CODE IS NULL
115: OR CONTEXT_ID < 10000);
116: -- AND CONTEXT_ID >= 10000

Line 217: UPDATE IBE_DSP_CONTEXT_B

213: IF p_mode = 'EXECUTION' THEN
214: IF (l_i > 0) THEN
215: FOR l_j IN 1..l_i LOOP
216: -- No update on last_updated_by based on the review feedback
217: UPDATE IBE_DSP_CONTEXT_B
218: SET COMPONENT_TYPE_CODE
219: = NVL(l_content_component_tbl(l_j).component_type_code,
220: COMPONENT_TYPE_CODE),
221: LAST_UPDATE_DATE = SYSDATE