[Home] [Help]
740: IS
741:
742: CURSOR c_qual_types(cl_source_id in number, cl_terr_id in number) IS
743: SELECT a.qual_type_id
744: FROM jtf_qual_type_usgs_all a,
745: jtf_terr_qtype_usgs_all b
746: WHERE b.terr_id = cl_terr_id
747: AND b.qual_type_usg_id = a.qual_type_usg_id
748: AND a.source_id = cl_source_id;
776: jtf_terr_denorm_rules_all jtdr,
777: jtf_terr_qual_all jtqa,
778: jtf_terr_values_all jtva,
779: jtf_qual_usgs_all jqua,
780: jtf_qual_type_usgs_all jqtu,
781: jtf_qual_type_denorm_v inlv
782: WHERE jta.terr_id = cl_terr_id
783: AND jtdr.terr_id = jta.terr_id
784: AND jtdr.related_terr_id = jtqa.terr_id
833: jtf_terr_denorm_rules_all jtdr,
834: jtf_terr_qual_all jtqa,
835: jtf_terr_values_all jtva,
836: jtf_qual_usgs_all jqua,
837: jtf_qual_type_usgs_all jqtu,
838: jtf_qual_type_denorm_v inlv,
839: jtf_terr_cnr_groups cnrg,
840: jtf_terr_cnr_group_values cnrgv
841: WHERE jta.terr_id = cl_terr_id
896: jty_denorm_dea_rules_all jtdr,
897: jtf_terr_qual_all jtqa,
898: jtf_terr_values_all jtva,
899: jtf_qual_usgs_all jqua,
900: jtf_qual_type_usgs_all jqtu,
901: jtf_qual_type_denorm_v inlv
902: WHERE jta.terr_id = cl_terr_id
903: AND jtdr.terr_id = jta.terr_id
904: AND jtdr.related_terr_id = jtqa.terr_id
950: jty_denorm_dea_rules_all jtdr,
951: jtf_terr_qual_all jtqa,
952: jtf_terr_values_all jtva,
953: jtf_qual_usgs_all jqua,
954: jtf_qual_type_usgs_all jqtu,
955: jtf_qual_type_denorm_v inlv,
956: jtf_terr_cnr_groups cnrg,
957: jtf_terr_cnr_group_values cnrgv
958: WHERE jta.terr_id = cl_terr_id
996: TYPE l_qtype_source_id_tbl_type IS TABLE OF jtf_sources_all.source_id%TYPE;
997: TYPE l_qtype_num_qual_tbl_type IS TABLE OF jtf_terr_qtype_usgs_all.num_qual%TYPE;
998: TYPE l_qtype_qual_prd_tbl_type IS TABLE OF jtf_terr_qtype_usgs_all.qual_relation_product%TYPE;
999:
1000: TYPE l_qual_type_id_tbl_type IS TABLE OF jtf_qual_type_usgs_all.qual_type_id%TYPE;
1001: TYPE l_qual_usg_id_tbl_type IS TABLE OF jtf_qual_usgs_all.qual_usg_id%TYPE;
1002: TYPE l_qual_rel_fac_tbl_type IS TABLE OF jtf_qual_usgs_all.qual_relation_factor%TYPE;
1003: TYPE l_cop_tbl_type IS TABLE OF jtf_terr_values_all.comparison_operator%TYPE;
1004: TYPE l_lvc_id_tbl_type IS TABLE OF jtf_terr_values_all.low_value_char_id%TYPE;
1409: qual_relation_product = l_qtype_qual_prd_tbl(l)
1410: WHERE terr_id = l_qtype_terr_id_tbl(l)
1411: AND qual_type_usg_id =
1412: (SELECT qual_type_usg_id
1413: FROM jtf_qual_type_usgs_all
1414: WHERE source_id = l_qtype_source_id_tbl(l)
1415: AND qual_type_id = l_qtype_trans_id_tbl(l));
1416:
1417: /* enable the trigger after update */
1550: qual_relation_product = l_qtype_qual_prd_tbl(l)
1551: WHERE terr_id = l_qtype_terr_id_tbl(l)
1552: AND qual_type_usg_id =
1553: (SELECT qual_type_usg_id
1554: FROM jtf_qual_type_usgs_all
1555: WHERE source_id = l_qtype_source_id_tbl(l)
1556: AND qual_type_id = l_qtype_trans_id_tbl(l));
1557:
1558: /* enable the trigger before update */
1662: l_qual_type_id_tbl jtf_terr_number_list := jtf_terr_number_list();
1663:
1664: CURSOR c_get_qual_type_id (cl_source_id IN NUMBER) IS
1665: SELECT qual_type_id
1666: FROM jtf_qual_type_usgs_all
1667: WHERE source_id = cl_source_id
1668: AND qual_type_id <> -1001;
1669:
1670: BEGIN
1679: BEGIN
1680:
1681: SELECT /*+ ORDERED */ nvl(MAX(j2.rank), 99)
1682: INTO l_max_rank
1683: FROM jtf_qual_type_usgs j1
1684: , jtf_terr_qtype_usgs_all j4
1685: , jtf_terr_all j2
1686: WHERE j2.terr_id <> 1
1687: AND j4.terr_id = j2.terr_id
2122: SET o.first_char = SUBSTR(o.low_value_char, 1, 1)
2123: WHERE o.terr_qual_id IN (
2124: SELECT /*+ INDEX (i2 jtf_qual_usgs_n3) */
2125: i1.terr_qual_id
2126: FROM jtf_terr_qual_all i1, jtf_qual_usgs_all i2, jtf_qual_type_usgs_all i3
2127: WHERE i1.qual_usg_id = i2.qual_usg_id
2128: AND i2.display_type = 'CHAR'
2129: AND i2.lov_sql IS NULL
2130: AND i2.org_id = -3113