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_ALL

Line 419: from jtf_terr_all

415: END IF;
416:
417: select max(level)
418: into l_level
419: from jtf_terr_all
420: START WITH terr_id = p_terr_id
421: CONNECT BY PRIOR parent_territory_id = terr_id AND terr_id <> 1;
422:
423: RETURN (l_level+1);

Line 515: -- , (SELECT absolute_rank from jtf_terr_all where terr_id = p_terr_id_tbl(i))

511: , G_PROGRAM_ID
512: , G_SYSDATE
513: , p_org_id_tbl(i)
514: , 'N'
515: -- , (SELECT absolute_rank from jtf_terr_all where terr_id = p_terr_id_tbl(i))
516: );
517:
518: -- debug message
519: jty_log(FND_LOG.LEVEL_STATEMENT,

Line 572: -- , (SELECT absolute_rank from jtf_terr_all where terr_id = p_terr_id_tbl(i))

568: , G_PROGRAM_APPL_ID
569: , G_PROGRAM_ID
570: , G_SYSDATE
571: , p_org_id_tbl(i)
572: -- , (SELECT absolute_rank from jtf_terr_all where terr_id = p_terr_id_tbl(i))
573: );
574:
575: -- debug message
576: jty_log(FND_LOG.LEVEL_STATEMENT,

Line 630: -- , (SELECT absolute_rank from jtf_terr_all where terr_id = p_terr_id_tbl(i))

626: , G_PROGRAM_APPL_ID
627: , G_PROGRAM_ID
628: , G_SYSDATE
629: , p_org_id_tbl(i)
630: -- , (SELECT absolute_rank from jtf_terr_all where terr_id = p_terr_id_tbl(i))
631: );
632:
633: -- debug message
634: jty_log(FND_LOG.LEVEL_STATEMENT,

Line 660: /* This procedure updates the relative rank in the table jtf_terr_all */

656: substr(errbuf, 1, 4000));
657:
658: END update_denorm_table;
659:
660: /* This procedure updates the relative rank in the table jtf_terr_all */
661: PROCEDURE update_relative_rank (
662: p_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
663: p_relative_rank_tbl IN OUT NOCOPY jtf_terr_number_list,
664: errbuf OUT NOCOPY VARCHAR2,

Line 677: /* update the relative rank of the territory in jtf_terr_all */

673: 'Start of the procedure JTY_TERR_DENORM_RULES_PVT.update_relative_rank ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
674:
675: l_no_of_records := p_terr_id_tbl.COUNT;
676:
677: /* update the relative rank of the territory in jtf_terr_all */
678: IF (l_no_of_records > 0) THEN
679:
680: /* disable the trigger before update */
681: BEGIN

Line 689: UPDATE jtf_terr_all

685: NULL;
686: END;
687:
688: FORALL i IN p_terr_id_tbl.FIRST .. p_terr_id_tbl.LAST
689: UPDATE jtf_terr_all
690: SET relative_rank = p_relative_rank_tbl(i)
691: WHERE terr_id = p_terr_id_tbl(i);
692:
693: /* enable the trigger after update */

Line 704: 'Number of records updated in jtf_terr_all for relative rank : ' || l_no_of_records);

700:
701: -- debug message
702: jty_log(FND_LOG.LEVEL_STATEMENT,
703: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_relative_rank.num_rows_updated',
704: 'Number of records updated in jtf_terr_all for relative rank : ' || l_no_of_records);
705:
706: END IF; /* end IF (l_no_of_records > 0) */
707:
708: -- debug message

Line 725: /* This procedure updates the absolute rank in the table jtf_terr_all */

721: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_relative_rank.others',
722: substr(errbuf, 1, 4000));
723: END update_relative_rank;
724:
725: /* This procedure updates the absolute rank in the table jtf_terr_all */
726: PROCEDURE update_absolute_rank (
727: p_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
728: p_mode IN VARCHAR2,
729: p_table_name IN VARCHAR2,

Line 743: /* update the relative rank of the territory in jtf_terr_all */

739: 'Start of the procedure JTY_TERR_DENORM_RULES_PVT.update_absolute_rank ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
740:
741: l_no_of_records := p_terr_id_tbl.COUNT;
742:
743: /* update the relative rank of the territory in jtf_terr_all */
744: IF (l_no_of_records > 0) THEN
745:
746: /* disable the trigger before update */
747: BEGIN

Line 756: UPDATE jtf_terr_all jta1

752: END;
753:
754: /* calculate the absolute rank */
755: FORALL i IN p_terr_id_tbl.FIRST .. p_terr_id_tbl.LAST
756: UPDATE jtf_terr_all jta1
757: SET jta1.ABSOLUTE_RANK = (
758: SELECT SUM(jta2.relative_rank)
759: FROM jtf_terr_all jta2
760: WHERE jta2.terr_id IN (

Line 759: FROM jtf_terr_all jta2

755: FORALL i IN p_terr_id_tbl.FIRST .. p_terr_id_tbl.LAST
756: UPDATE jtf_terr_all jta1
757: SET jta1.ABSOLUTE_RANK = (
758: SELECT SUM(jta2.relative_rank)
759: FROM jtf_terr_all jta2
760: WHERE jta2.terr_id IN (
761: SELECT jt.terr_id
762: FROM jtf_terr_all jt
763: CONNECT BY PRIOR jt.parent_territory_id = jt.terr_id AND jt.terr_id <> 1

Line 762: FROM jtf_terr_all jt

758: SELECT SUM(jta2.relative_rank)
759: FROM jtf_terr_all jta2
760: WHERE jta2.terr_id IN (
761: SELECT jt.terr_id
762: FROM jtf_terr_all jt
763: CONNECT BY PRIOR jt.parent_territory_id = jt.terr_id AND jt.terr_id <> 1
764: START WITH jt.terr_id = p_terr_id_tbl(i))),
765: jta1.last_update_date = g_sysdate
766: WHERE jta1.terr_id = p_terr_id_tbl(i);

Line 772: ' FROM jtf_terr_all ' ||

768: l_dyn_str :=
769: 'UPDATE ' || p_table_name || ' ' ||
770: 'SET absolute_rank = ( ' ||
771: ' SELECT absolute_rank ' ||
772: ' FROM jtf_terr_all ' ||
773: ' WHERE terr_id = :1 ) ' ||
774: 'WHERE terr_id = :2 ';
775:
776: IF (p_mode = 'INCREMENTAL') THEN

Line 795: 'Number of records updated in jtf_terr_all for absolute rank : ' || l_no_of_records);

791:
792: -- debug message
793: jty_log(FND_LOG.LEVEL_STATEMENT,
794: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_absolute_rank.num_rows_updated',
795: 'Number of records updated in jtf_terr_all for absolute rank : ' || l_no_of_records);
796:
797: END IF; /* end IF (l_no_of_records > 0) */
798:
799: -- debug message

Line 859: FROM jtf_terr_all jta,

855: jta.absolute_rank,
856: jtdr.start_date,
857: jtdr.end_date,
858: count(*) over(partition by jtqa.qual_usg_id)
859: FROM jtf_terr_all jta,
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,

Line 916: FROM jtf_terr_all jta,

912: jta.absolute_rank,
913: jtdr.start_date,
914: jtdr.end_date,
915: count(*) over(partition by jtqa.qual_usg_id)
916: FROM jtf_terr_all jta,
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,

Line 979: FROM jtf_terr_all jta,

975: jta.absolute_rank,
976: jtdr.start_date,
977: jtdr.end_date,
978: count(*) over(partition by jtqa.qual_usg_id)
979: FROM jtf_terr_all jta,
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,

Line 1033: FROM jtf_terr_all jta,

1029: jta.absolute_rank,
1030: jtdr.start_date,
1031: jtdr.end_date,
1032: count(*) over(partition by jtqa.qual_usg_id)
1033: FROM jtf_terr_all jta,
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,

Line 1081: FROM JTF_TERR_QUAL_ALL jtqa, JTF_TERR_USGS_ALL jtua, JTF_TERR_ALL jta

1077:
1078:
1079: CURSOR c_actual_tab_reference is
1080: SELECT COUNT(*)
1081: FROM JTF_TERR_QUAL_ALL jtqa, JTF_TERR_USGS_ALL jtua, JTF_TERR_ALL jta
1082: WHERE jtqa.QUAL_USG_ID NOT IN
1083: (-1040, -1041, -1042, -1044, -1744, -1734, -1048, -1096, -1038, -1061, -1060, -1043,
1084: -1095, -1051, -1050, -1037, -1210, -1045, -1046, -1206, -1213, -1039, -1218)
1085: AND JTQA.TERR_ID = JTUA.TERR_ID

Line 1091: TYPE l_qtype_terr_id_tbl_type IS TABLE OF jtf_terr_all.terr_id%TYPE;

1087: AND JTA.TERR_ID = JTUA.TERR_ID
1088: AND SYSDATE BETWEEN JTA.START_DATE_ACTIVE AND JTA.END_DATE_ACTIVE;
1089:
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;

Line 1815: , jtf_terr_all j2

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
1819: AND j1.source_id = p_source_id;

Line 1963: FROM jtf_terr_all jt

1959: END IF;
1960: ELSE
1961: SELECT jt.terr_id, NVL(jt.num_winners, 1)
1962: INTO l_top_level_terr_id_tbl(l_rows_inserted1), l_num_winners_tbl(l_rows_inserted1)
1963: FROM jtf_terr_all jt
1964: WHERE jt.parent_territory_id = 1
1965: AND (jt.org_id <> -3114 OR jt.org_id IS NULL)
1966: CONNECT BY PRIOR jt.parent_territory_id = jt.terr_id AND jt.terr_id <> 1
1967: START WITH jt.terr_id = p_terr_change_tab.terr_id(i);

Line 2037: FROM jtf_terr_all TR1, jtf_terr_all TR2

2033: /* insert rows for the other parents */
2034: LOOP
2035: SELECT /*+ index(TR1 JTF_TERR_U1) */ DISTINCT TR1.PARENT_TERRITORY_ID, TR2.NUM_WINNERS
2036: INTO l_new_parent_territory_id, l_new_parent_num_winners
2037: FROM jtf_terr_all TR1, jtf_terr_all TR2
2038: WHERE TR2.terr_id = TR1.parent_territory_id
2039: AND TR1.TERR_ID <> 1
2040: AND TR1.TERR_ID = l_parent_terr_id;
2041:

Line 2182: UPDATE jtf_terr_all jta1

2178: END;*/
2179:
2180: /* calculate the absolute rank */
2181: /*FORALL i IN l_terr_id_tbl2.FIRST .. l_terr_id_tbl2.LAST
2182: UPDATE jtf_terr_all jta1
2183: SET jta1.ABSOLUTE_RANK = (
2184: SELECT SUM(jta2.relative_rank)
2185: FROM jtf_terr_all jta2
2186: WHERE jta2.terr_id IN (

Line 2185: FROM jtf_terr_all jta2

2181: /*FORALL i IN l_terr_id_tbl2.FIRST .. l_terr_id_tbl2.LAST
2182: UPDATE jtf_terr_all jta1
2183: SET jta1.ABSOLUTE_RANK = (
2184: SELECT SUM(jta2.relative_rank)
2185: FROM jtf_terr_all jta2
2186: WHERE jta2.terr_id IN (
2187: SELECT jt.terr_id
2188: FROM jtf_terr_all jt
2189: CONNECT BY PRIOR jt.parent_territory_id = jt.terr_id AND jt.terr_id <> 1

Line 2188: FROM jtf_terr_all jt

2184: SELECT SUM(jta2.relative_rank)
2185: FROM jtf_terr_all jta2
2186: WHERE jta2.terr_id IN (
2187: SELECT jt.terr_id
2188: FROM jtf_terr_all jt
2189: CONNECT BY PRIOR jt.parent_territory_id = jt.terr_id AND jt.terr_id <> 1
2190: START WITH jt.terr_id = l_terr_id_tbl2(i))),
2191: jta1.last_update_date = g_sysdate
2192: WHERE jta1.terr_id = l_terr_id_tbl2(i);

Line 2198: ' FROM jtf_terr_all ' ||

2194: l_dyn_str :=
2195: 'UPDATE ' || p_table_name || ' ' ||
2196: 'SET absolute_rank = ( ' ||
2197: ' SELECT absolute_rank ' ||
2198: ' FROM jtf_terr_all ' ||
2199: ' WHERE terr_id = :1 ) ' ||
2200: 'WHERE terr_id = :2 ';
2201:
2202: IF (p_mode = 'INCREMENTAL') THEN