[Home] [Help]
1239:
1240: -- get all reports and type of reports (i.e. ORGNAIZATION, PERSON or CONTACT)
1241: cursor get_all_reports(l_system_date DATE) is
1242: SELECT rpt.lookup_code, substrb(rs.category,1,30)
1243: FROM imc_lookups rpt, imc_reports_summary rs
1244: WHERE rpt.lookup_type = 'COMPLETENESS_REPORTS'
1245: AND rpt.enabled_flag = 'Y'
1246: AND rpt.lookup_code = rs.parent_category
1247: AND rs.report_name = 'COMPLRPT_STATUS'
1251: -- description like HZ_PARTIES.DUNS_NUMBER
1252: cursor get_all_attributes(l_report_name VARCHAR2, l_system_date DATE, l_type VARCHAR2) is
1253: SELECT substrb(t.description,instr(t.description,'.')+1), substrb(t.description,1,instr(t.description,'.')-1)
1254: , t.lookup_code
1255: FROM imc_lookups r, imc_lookups t, imc_lookups a
1256: WHERE r.lookup_type = l_report_name
1257: AND r.enabled_flag = 'Y'
1258: AND r.lookup_code = t.lookup_code
1259: and t.lookup_type = a.lookup_code
1269:
1270: -- check if there is any completeness reports in IMC reports summary table
1271: cursor is_compl_record_exist is
1272: SELECT 'X'
1273: FROM IMC_REPORTS_SUMMARY a, IMC_LOOKUPS b
1274: WHERE a.report_name = b.lookup_code
1275: AND b.lookup_type = 'COMPLETENESS_REPORTS'
1276: AND a.report_type = 'M'
1277: AND rownum = 1;
2856: ) IS
2857:
2858: CURSOR get_meaning IS
2859: SELECT meaning, description, start_date_active
2860: FROM IMC_LOOKUPS
2861: WHERE lookup_type = 'COMPLETENESS_REPORTS'
2862: AND lookup_code = p_report_code;
2863:
2864: l_mean VARCHAR2(80);