51: END IF;
52:
53: select count(*) into l_prj_count from pa_projects_all where olap_group is null;
54:
55: select ceil(l_prj_count/p_group_size) into l_loop from dual;
56:
57: FOR i in 1..l_loop LOOP
58: select PA_OLAP_GROUP_S.nextval into l_olap_group from dual;
59:
54:
55: select ceil(l_prj_count/p_group_size) into l_loop from dual;
56:
57: FOR i in 1..l_loop LOOP
58: select PA_OLAP_GROUP_S.nextval into l_olap_group from dual;
59:
60: update pa_projects_all
61: set olap_group = l_olap_group --,
62: -- struct_change_flag = 'Y'
211: , sysdate last_update_date
212: , -1 last_updated_by
213: , -1 created_by
214: , -1 last_update_login
215: FROM DUAL;
216:
217: INSERT INTO pji_fp_aggr_pjp1
218: (
219: WORKER_ID,