APPS.JTY_TERR_DENORM_RULES_PVT dependencies on JTF_TERR_QTYPE_USGS_ALL

Line 829: jtf_terr_qtype_usgs_all b

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;
833:

Line 1094: TYPE l_qtype_num_qual_tbl_type IS TABLE OF jtf_terr_qtype_usgs_all.num_qual%TYPE;

1090:
1091: TYPE l_qtype_terr_id_tbl_type IS TABLE OF jtf_terr_all.terr_id%TYPE;
1092: TYPE l_qtype_trans_id_tbl_type IS TABLE OF jtf_qual_types_all.qual_type_id%TYPE;
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;

Line 1095: TYPE l_qtype_qual_prd_tbl_type IS TABLE OF jtf_terr_qtype_usgs_all.qual_relation_product%TYPE;

1091: TYPE l_qtype_terr_id_tbl_type IS TABLE OF jtf_terr_all.terr_id%TYPE;
1092: TYPE l_qtype_trans_id_tbl_type IS TABLE OF jtf_qual_types_all.qual_type_id%TYPE;
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;

Line 1547: UPDATE jtf_terr_qtype_usgs_all

1543: END;
1544:
1545: /* update num_qual and qual_relation_product */
1546: FORALL l in l_qtype_terr_id_tbl.FIRST .. l_qtype_terr_id_tbl.LAST
1547: UPDATE jtf_terr_qtype_usgs_all
1548: SET num_qual = l_qtype_num_qual_tbl(l),
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 =

Line 1690: UPDATE jtf_terr_qtype_usgs_all

1686: END;
1687:
1688: /* update num_qual and qual_relation_product */
1689: FORALL l in l_qtype_terr_id_tbl.FIRST .. l_qtype_terr_id_tbl.LAST
1690: UPDATE jtf_terr_qtype_usgs_all
1691: SET num_qual = l_qtype_num_qual_tbl(l),
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 =

Line 1725: 'Done updating jtf_terr_qtype_usgs_all with num_qual and qual_relation_product');

1721:
1722: -- debug message
1723: jty_log(FND_LOG.LEVEL_STATEMENT,
1724: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.update_num_qual',
1725: 'Done updating jtf_terr_qtype_usgs_all with num_qual and qual_relation_product');
1726:
1727: -- debug message
1728: jty_log(FND_LOG.LEVEL_PROCEDURE,
1729: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.end',

Line 1814: , jtf_terr_qtype_usgs_all j4

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
1818: AND j4.qual_type_usg_id = j1.qual_type_usg_id