eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTY_TERR_DENORM_RULES_PVT dependencies on JTF_TERR_QTYPE_USGS_ALL

Line 745: jtf_terr_qtype_usgs_all b

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

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

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

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

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

Line 1407: UPDATE jtf_terr_qtype_usgs_all

1403: END;
1404:
1405: /* update num_qual and qual_relation_product */
1406: FORALL l in l_qtype_terr_id_tbl.FIRST .. l_qtype_terr_id_tbl.LAST
1407: UPDATE jtf_terr_qtype_usgs_all
1408: SET num_qual = l_qtype_num_qual_tbl(l),
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 =

Line 1548: UPDATE jtf_terr_qtype_usgs_all

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

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

1580: -- debug message
1581: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1582: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1583: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.update_num_qual',
1584: 'Done updating jtf_terr_qtype_usgs_all with num_qual and qual_relation_product');
1585: END IF;
1586:
1587: -- debug message
1588: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1684: , jtf_terr_qtype_usgs_all j4

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