[Home] [Help]
202: org_cnt,
203: org_pct,
204: time_stamp)
205: SELECT 'INDUSTRY','R',rp_msg_total, nvl(rp_org_cnt,0),'100.00',sysdate
206: FROM dual;
207: */
208:
209: -- INSERT 'Top 5' counts for ORGANIZATION by industry
210:
357: per_pct,
358: time_stamp)
359: SELECT 'COUNTRY','R',rp_msg_total,
360: nvl(rp_org_cnt,0),'100.00',nvl(rp_per_cnt,0),'100.00',sysdate
361: FROM dual;
362:
363:
364: -- INSERT 'Top 5' counts for ORGANIZATION and PERSON by country
365:
598: per_pct,
599: time_stamp)
600: SELECT 'STATE','R', i.parent_category, rp_msg_total,
601: nvl(i.org_total,0),'100.00',nvl(i.per_total,0),'100.00',sysdate
602: FROM dual;
603:
604:
605: -- INSERT 'All Others' row for ORGANIZATION and PERSON by state
606:
838: per_pct,
839: time_stamp)
840: SELECT 'DUPLICATE','R',rp_msg_total, nvl(rp_dupl_org_cnt,0),'100.00',
841: nvl(rp_dupl_per_cnt,0),'100.00', sysdate
842: FROM dual;
843:
844: COMMIT;
845:
846: EXCEPTION
1109: nvl(rp_grth_per_cnt,0),'100.00',
1110: nvl(rp_grth_rel_cnt,0),'100.00',
1111: nvl(rp_grth_total_cnt,0),'100.00',
1112: sysdate
1113: FROM dual;
1114:
1115: COMMIT;
1116:
1117: EXCEPTION
1264: cursor get_system_month_day(l_system_date DATE) is
1265: SELECT decode(to_char(l_system_date,'DD'),'01',1,0),
1266: decode(to_char(l_system_date,'MM'),'01',1,'04',1,'07',1,'10',1,0),
1267: to_char(l_system_date, 'YYYY-MM')
1268: FROM dual;
1269:
1270: -- check if there is any completeness reports in IMC reports summary table
1271: cursor is_compl_record_exist is
1272: SELECT 'X'
1927:
1928: CURSOR get_system_month_day(l_system_date DATE) IS
1929: SELECT decode(to_char(l_system_date,'DD'),'01',1,0),
1930: decode(to_char(l_system_date,'MM'),'01',1,'04',1,'07',1,'10',1,0)
1931: FROM dual;
1932:
1933: CURSOR get_all_period IS
1934: SELECT add_months(to_date(parent_category,'YYYY-MM'),1)-1
1935: , decode(substrb(parent_category,6,2),'03',1,'06',1,'09',1,'12',1,0)