[Home] [Help]
824: IS
825:
826: CURSOR c_qual_types(cl_source_id in number, cl_terr_id in number) IS
827: SELECT a.qual_type_id
828: FROM jtf_qual_type_usgs_all a,
829: jtf_terr_qtype_usgs_all b
830: WHERE b.terr_id = cl_terr_id
831: AND b.qual_type_usg_id = a.qual_type_usg_id
832: AND a.source_id = cl_source_id;
860: jtf_terr_denorm_rules_all jtdr,
861: jtf_terr_qual_all jtqa,
862: jtf_terr_values_all jtva,
863: jtf_qual_usgs_all jqua,
864: jtf_qual_type_usgs_all jqtu,
865: jtf_qual_type_denorm_v inlv
866: WHERE jta.terr_id = cl_terr_id
867: AND jtdr.terr_id = jta.terr_id
868: AND jtdr.related_terr_id = jtqa.terr_id
917: jtf_terr_denorm_rules_all jtdr,
918: jtf_terr_qual_all jtqa,
919: jtf_terr_values_all jtva,
920: jtf_qual_usgs_all jqua,
921: jtf_qual_type_usgs_all jqtu,
922: jtf_qual_type_denorm_v inlv,
923: jtf_terr_cnr_groups cnrg,
924: jtf_terr_cnr_group_values cnrgv
925: WHERE jta.terr_id = cl_terr_id
980: jty_denorm_dea_rules_all jtdr,
981: jtf_terr_qual_all jtqa,
982: jtf_terr_values_all jtva,
983: jtf_qual_usgs_all jqua,
984: jtf_qual_type_usgs_all jqtu,
985: jtf_qual_type_denorm_v inlv
986: WHERE jta.terr_id = cl_terr_id
987: AND jtdr.terr_id = jta.terr_id
988: AND jtdr.related_terr_id = jtqa.terr_id
1034: jty_denorm_dea_rules_all jtdr,
1035: jtf_terr_qual_all jtqa,
1036: jtf_terr_values_all jtva,
1037: jtf_qual_usgs_all jqua,
1038: jtf_qual_type_usgs_all jqtu,
1039: jtf_qual_type_denorm_v inlv,
1040: jtf_terr_cnr_groups cnrg,
1041: jtf_terr_cnr_group_values cnrgv
1042: WHERE jta.terr_id = cl_terr_id
1093: TYPE l_qtype_source_id_tbl_type IS TABLE OF jtf_sources_all.source_id%TYPE;
1094: TYPE l_qtype_num_qual_tbl_type IS TABLE OF jtf_terr_qtype_usgs_all.num_qual%TYPE;
1095: TYPE l_qtype_qual_prd_tbl_type IS TABLE OF jtf_terr_qtype_usgs_all.qual_relation_product%TYPE;
1096:
1097: TYPE l_qual_type_id_tbl_type IS TABLE OF jtf_qual_type_usgs_all.qual_type_id%TYPE;
1098: TYPE l_qual_usg_id_tbl_type IS TABLE OF jtf_qual_usgs_all.qual_usg_id%TYPE;
1099: TYPE l_qual_rel_fac_tbl_type IS TABLE OF jtf_qual_usgs_all.qual_relation_factor%TYPE;
1100: TYPE l_cop_tbl_type IS TABLE OF jtf_terr_values_all.comparison_operator%TYPE;
1101: TYPE l_lvc_id_tbl_type IS TABLE OF jtf_terr_values_all.low_value_char_id%TYPE;
1549: qual_relation_product = l_qtype_qual_prd_tbl(l)
1550: WHERE terr_id = l_qtype_terr_id_tbl(l)
1551: AND qual_type_usg_id =
1552: (SELECT qual_type_usg_id
1553: FROM jtf_qual_type_usgs_all
1554: WHERE source_id = l_qtype_source_id_tbl(l)
1555: AND qual_type_id = l_qtype_trans_id_tbl(l));
1556:
1557: /* enable the trigger after update */
1692: qual_relation_product = l_qtype_qual_prd_tbl(l)
1693: WHERE terr_id = l_qtype_terr_id_tbl(l)
1694: AND qual_type_usg_id =
1695: (SELECT qual_type_usg_id
1696: FROM jtf_qual_type_usgs_all
1697: WHERE source_id = l_qtype_source_id_tbl(l)
1698: AND qual_type_id = l_qtype_trans_id_tbl(l));
1699:
1700: /* enable the trigger before update */
1794: l_qual_type_id_tbl jtf_terr_number_list := jtf_terr_number_list();
1795:
1796: CURSOR c_get_qual_type_id (cl_source_id IN NUMBER) IS
1797: SELECT qual_type_id
1798: FROM jtf_qual_type_usgs_all
1799: WHERE source_id = cl_source_id
1800: AND qual_type_id <> -1001;
1801:
1802: BEGIN
1809: BEGIN
1810:
1811: SELECT /*+ ORDERED */ nvl(MAX(j2.rank), 99)
1812: INTO l_max_rank
1813: FROM jtf_qual_type_usgs j1
1814: , jtf_terr_qtype_usgs_all j4
1815: , jtf_terr_all j2
1816: WHERE j2.terr_id <> 1
1817: AND j4.terr_id = j2.terr_id
2247: SET o.first_char = SUBSTR(o.low_value_char, 1, 1)
2248: WHERE o.terr_qual_id IN (
2249: SELECT /*+ INDEX (i2 jtf_qual_usgs_n3) */
2250: i1.terr_qual_id
2251: FROM jtf_terr_qual_all i1, jtf_qual_usgs_all i2, jtf_qual_type_usgs_all i3
2252: WHERE i1.qual_usg_id = i2.qual_usg_id
2253: AND i2.display_type = 'CHAR'
2254: AND i2.lov_sql IS NULL
2255: AND i2.org_id = -3113