358: BULK COLLECT INTO
359: t_batch_ent_obj_id
360: ,t_system_code
361: FROM Ego_Pub_Bat_Ent_Objs_B EO,
362: EGO_PUB_BAT_SYSTEMS_B SYS
363: WHERE EO.Batch_Id = p_batch_id
364: AND EO.User_Entered = C_NO
365: AND SYS.Batch_Id = EO.Batch_Id;
366:
3206: for i in 1..l_target_systems.count loop
3207: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
3208: ,P_MODULE => L_MODULE_NAME
3209: ,P_MESSAGE => ' system code: ' || l_target_systems(i).SYSTEM_CODE );
3210: insert into EGO_PUB_BAT_SYSTEMS_B (
3211: batch_id,
3212: system_code,
3213: LAST_UPDATE_DATE,
3214: LAST_UPDATED_BY,
3725:
3726: -- build target systems
3727: select SYSTEM_CODE
3728: BULK COLLECT INTO l_system_codes
3729: from EGO_PUB_BAT_SYSTEMS_B where BATCH_ID = l_batch_id;
3730: l_counter := 1;
3731: for i in 1..l_system_codes.COUNT loop
3732: l_target_systems(l_counter).system_code := l_system_codes(i);
3733: l_counter := l_counter + 1;