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 370: from jtf_terr_all

366: END IF;
367:
368: select max(level)
369: into l_level
370: from jtf_terr_all
371: START WITH terr_id = p_terr_id
372: CONNECT BY PRIOR parent_territory_id = terr_id AND terr_id <> 1;
373:
374: RETURN (l_level+1);

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

464: , G_PROGRAM_ID
465: , G_SYSDATE
466: , p_org_id_tbl(i)
467: , 'N'
468: -- , (SELECT absolute_rank from jtf_terr_all where terr_id = p_terr_id_tbl(i))
469: );
470:
471: -- debug message
472: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

524: , G_PROGRAM_APPL_ID
525: , G_PROGRAM_ID
526: , G_SYSDATE
527: , p_org_id_tbl(i)
528: -- , (SELECT absolute_rank from jtf_terr_all where terr_id = p_terr_id_tbl(i))
529: );
530:
531: -- debug message
532: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

559: substr(errbuf, 1, 4000));
560: END IF;
561: END update_denorm_table;
562:
563: /* This procedure updates the relative rank in the table jtf_terr_all */
564: PROCEDURE update_relative_rank (
565: p_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
566: p_relative_rank_tbl IN OUT NOCOPY jtf_terr_number_list,
567: errbuf OUT NOCOPY VARCHAR2,

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

578: END IF;
579:
580: l_no_of_records := p_terr_id_tbl.COUNT;
581:
582: /* update the relative rank of the territory in jtf_terr_all */
583: IF (l_no_of_records > 0) THEN
584:
585: /* disable the trigger before update */
586: BEGIN

Line 594: UPDATE jtf_terr_all

590: NULL;
591: END;
592:
593: FORALL i IN p_terr_id_tbl.FIRST .. p_terr_id_tbl.LAST
594: UPDATE jtf_terr_all
595: SET relative_rank = p_relative_rank_tbl(i)
596: WHERE terr_id = p_terr_id_tbl(i);
597:
598: /* enable the trigger after update */

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

606: -- debug message
607: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
608: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
609: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_relative_rank.num_rows_updated',
610: 'Number of records updated in jtf_terr_all for relative rank : ' || l_no_of_records);
611: END IF;
612:
613: END IF; /* end IF (l_no_of_records > 0) */
614:

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

632: substr(errbuf, 1, 4000));
633: END IF;
634: END update_relative_rank;
635:
636: /* This procedure updates the absolute rank in the table jtf_terr_all */
637: PROCEDURE update_absolute_rank (
638: p_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,
639: p_mode IN VARCHAR2,
640: p_table_name IN VARCHAR2,

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

652: END IF;
653:
654: l_no_of_records := p_terr_id_tbl.COUNT;
655:
656: /* update the relative rank of the territory in jtf_terr_all */
657: IF (l_no_of_records > 0) THEN
658:
659: /* disable the trigger before update */
660: BEGIN

Line 669: UPDATE jtf_terr_all jta1

665: END;
666:
667: /* calculate the absolute rank */
668: FORALL i IN p_terr_id_tbl.FIRST .. p_terr_id_tbl.LAST
669: UPDATE jtf_terr_all jta1
670: SET jta1.ABSOLUTE_RANK = (
671: SELECT SUM(jta2.relative_rank)
672: FROM jtf_terr_all jta2
673: WHERE jta2.terr_id IN (

Line 672: FROM jtf_terr_all jta2

668: FORALL i IN p_terr_id_tbl.FIRST .. p_terr_id_tbl.LAST
669: UPDATE jtf_terr_all jta1
670: SET jta1.ABSOLUTE_RANK = (
671: SELECT SUM(jta2.relative_rank)
672: FROM jtf_terr_all jta2
673: WHERE jta2.terr_id IN (
674: SELECT jt.terr_id
675: FROM jtf_terr_all jt
676: CONNECT BY PRIOR jt.parent_territory_id = jt.terr_id AND jt.terr_id <> 1

Line 675: FROM jtf_terr_all jt

671: SELECT SUM(jta2.relative_rank)
672: FROM jtf_terr_all jta2
673: WHERE jta2.terr_id IN (
674: SELECT jt.terr_id
675: FROM jtf_terr_all jt
676: CONNECT BY PRIOR jt.parent_territory_id = jt.terr_id AND jt.terr_id <> 1
677: START WITH jt.terr_id = p_terr_id_tbl(i))),
678: jta1.last_update_date = g_sysdate
679: WHERE jta1.terr_id = p_terr_id_tbl(i);

Line 685: ' FROM jtf_terr_all ' ||

681: l_dyn_str :=
682: 'UPDATE ' || p_table_name || ' ' ||
683: 'SET absolute_rank = ( ' ||
684: ' SELECT absolute_rank ' ||
685: ' FROM jtf_terr_all ' ||
686: ' WHERE terr_id = :1 ) ' ||
687: 'WHERE terr_id = :2 ';
688:
689: IF (p_mode = 'INCREMENTAL') THEN

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

702: -- debug message
703: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
704: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
705: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_absolute_rank.num_rows_updated',
706: 'Number of records updated in jtf_terr_all for absolute rank : ' || l_no_of_records);
707: END IF;
708:
709: END IF; /* end IF (l_no_of_records > 0) */
710:

Line 775: FROM jtf_terr_all jta,

771: jta.absolute_rank,
772: jtdr.start_date,
773: jtdr.end_date,
774: count(*) over(partition by jtqa.qual_usg_id)
775: FROM jtf_terr_all jta,
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,

Line 832: FROM jtf_terr_all jta,

828: jta.absolute_rank,
829: jtdr.start_date,
830: jtdr.end_date,
831: count(*) over(partition by jtqa.qual_usg_id)
832: FROM jtf_terr_all jta,
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,

Line 895: FROM jtf_terr_all jta,

891: jta.absolute_rank,
892: jtdr.start_date,
893: jtdr.end_date,
894: count(*) over(partition by jtqa.qual_usg_id)
895: FROM jtf_terr_all jta,
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,

Line 949: FROM jtf_terr_all jta,

945: jta.absolute_rank,
946: jtdr.start_date,
947: jtdr.end_date,
948: count(*) over(partition by jtqa.qual_usg_id)
949: FROM jtf_terr_all jta,
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,

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

990: 'LAST_UPDATED_BY', 'CREATION_DATE', 'CREATED_BY', 'LAST_UPDATE_LOGIN', 'REQUEST_ID',
991: 'PROGRAM_APPLICATION_ID', 'PROGRAM_ID', 'PROGRAM_UPDATE_DATE', 'DENORM_TERR_ATTR_VALUES_ID',
992: 'DENORM_TERR_DEA_VALUES_ID');
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;

Line 1685: , jtf_terr_all j2

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

Line 1833: FROM jtf_terr_all jt

1829: END IF;
1830: ELSE
1831: SELECT jt.terr_id, NVL(jt.num_winners, 1)
1832: INTO l_top_level_terr_id_tbl(l_rows_inserted1), l_num_winners_tbl(l_rows_inserted1)
1833: FROM jtf_terr_all jt
1834: WHERE jt.parent_territory_id = 1
1835: AND (jt.org_id <> -3114 OR jt.org_id IS NULL)
1836: CONNECT BY PRIOR jt.parent_territory_id = jt.terr_id AND jt.terr_id <> 1
1837: START WITH jt.terr_id = p_terr_change_tab.terr_id(i);

Line 1907: FROM jtf_terr_all TR1, jtf_terr_all TR2

1903: /* insert rows for the other parents */
1904: LOOP
1905: SELECT DISTINCT TR1.PARENT_TERRITORY_ID, TR2.NUM_WINNERS
1906: INTO l_new_parent_territory_id, l_new_parent_num_winners
1907: FROM jtf_terr_all TR1, jtf_terr_all TR2
1908: WHERE TR2.terr_id = TR1.parent_territory_id
1909: AND TR1.TERR_ID <> 1
1910: AND TR1.TERR_ID = l_parent_terr_id;
1911:

Line 2058: UPDATE jtf_terr_all jta1

2054: END;*/
2055:
2056: /* calculate the absolute rank */
2057: /*FORALL i IN l_terr_id_tbl2.FIRST .. l_terr_id_tbl2.LAST
2058: UPDATE jtf_terr_all jta1
2059: SET jta1.ABSOLUTE_RANK = (
2060: SELECT SUM(jta2.relative_rank)
2061: FROM jtf_terr_all jta2
2062: WHERE jta2.terr_id IN (

Line 2061: FROM jtf_terr_all jta2

2057: /*FORALL i IN l_terr_id_tbl2.FIRST .. l_terr_id_tbl2.LAST
2058: UPDATE jtf_terr_all jta1
2059: SET jta1.ABSOLUTE_RANK = (
2060: SELECT SUM(jta2.relative_rank)
2061: FROM jtf_terr_all jta2
2062: WHERE jta2.terr_id IN (
2063: SELECT jt.terr_id
2064: FROM jtf_terr_all jt
2065: CONNECT BY PRIOR jt.parent_territory_id = jt.terr_id AND jt.terr_id <> 1

Line 2064: FROM jtf_terr_all jt

2060: SELECT SUM(jta2.relative_rank)
2061: FROM jtf_terr_all jta2
2062: WHERE jta2.terr_id IN (
2063: SELECT jt.terr_id
2064: FROM jtf_terr_all jt
2065: CONNECT BY PRIOR jt.parent_territory_id = jt.terr_id AND jt.terr_id <> 1
2066: START WITH jt.terr_id = l_terr_id_tbl2(i))),
2067: jta1.last_update_date = g_sysdate
2068: WHERE jta1.terr_id = l_terr_id_tbl2(i);

Line 2074: ' FROM jtf_terr_all ' ||

2070: l_dyn_str :=
2071: 'UPDATE ' || p_table_name || ' ' ||
2072: 'SET absolute_rank = ( ' ||
2073: ' SELECT absolute_rank ' ||
2074: ' FROM jtf_terr_all ' ||
2075: ' WHERE terr_id = :1 ) ' ||
2076: 'WHERE terr_id = :2 ';
2077:
2078: IF (p_mode = 'INCREMENTAL') THEN