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 JTY_DENORM_DEA_RULES_ALL

Line 432: /* and the table jty_denorm_dea_rules_all for date effective mode */

428: END get_level_from_root;
429:
430: /* This procedure inserts the denormalized territory hierarchy informations */
431: /* into the tables jtf_terr_denorm_rules_all, for total and incremental mode */
432: /* and the table jty_denorm_dea_rules_all for date effective mode */
433: PROCEDURE update_denorm_table (
434: p_source_id IN NUMBER,
435: p_mode IN VARCHAR2,
436: p_terr_id_tbl IN OUT NOCOPY jtf_terr_number_list,

Line 524: /* hierarchy information into jty_denorm_dea_rules_all */

520: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_denorm_table.num_rows_inserted',
521: 'Number of records inserted into jtf_terr_denorm_rules_all : ' || l_no_of_records);
522: ELSIF (p_mode = 'DEA INCREMENTAL') THEN
523: /* if mode is date effective incremental , insert the denormalized */
524: /* hierarchy information into jty_denorm_dea_rules_all */
525: FORALL i IN p_terr_id_tbl.FIRST .. p_terr_id_tbl.LAST
526: INSERT INTO jty_denorm_dea_rules_all(
527: source_id
528: , terr_id

Line 526: INSERT INTO jty_denorm_dea_rules_all(

522: ELSIF (p_mode = 'DEA INCREMENTAL') THEN
523: /* if mode is date effective incremental , insert the denormalized */
524: /* hierarchy information into jty_denorm_dea_rules_all */
525: FORALL i IN p_terr_id_tbl.FIRST .. p_terr_id_tbl.LAST
526: INSERT INTO jty_denorm_dea_rules_all(
527: source_id
528: , terr_id
529: , rank
530: , level_from_root

Line 578: 'Number of records inserted into jty_denorm_dea_rules_all : ' || l_no_of_records);

574:
575: -- debug message
576: jty_log(FND_LOG.LEVEL_STATEMENT,
577: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_denorm_table.num_rows_inserted',
578: 'Number of records inserted into jty_denorm_dea_rules_all : ' || l_no_of_records);
579:
580: ELSE
581: /* if mode is date effective, insert the denormalized */
582: /* hierarchy information into jty_denorm_dea_rules_all */

Line 582: /* hierarchy information into jty_denorm_dea_rules_all */

578: 'Number of records inserted into jty_denorm_dea_rules_all : ' || l_no_of_records);
579:
580: ELSE
581: /* if mode is date effective, insert the denormalized */
582: /* hierarchy information into jty_denorm_dea_rules_all */
583: FORALL i IN p_terr_id_tbl.FIRST .. p_terr_id_tbl.LAST
584: INSERT INTO jty_denorm_dea_rules_all(
585: source_id
586: , terr_id

Line 584: INSERT INTO jty_denorm_dea_rules_all(

580: ELSE
581: /* if mode is date effective, insert the denormalized */
582: /* hierarchy information into jty_denorm_dea_rules_all */
583: FORALL i IN p_terr_id_tbl.FIRST .. p_terr_id_tbl.LAST
584: INSERT INTO jty_denorm_dea_rules_all(
585: source_id
586: , terr_id
587: , rank
588: , level_from_root

Line 636: 'Number of records inserted into jty_denorm_dea_rules_all : ' || l_no_of_records);

632:
633: -- debug message
634: jty_log(FND_LOG.LEVEL_STATEMENT,
635: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_denorm_table.num_rows_inserted',
636: 'Number of records inserted into jty_denorm_dea_rules_all : ' || l_no_of_records);
637:
638: END IF; /* end IF (p_mode IN ('TOTAL', 'INCREMENTAL')) */
639:
640: END IF; /* end IF (l_no_of_records > 0) */

Line 980: jty_denorm_dea_rules_all jtdr,

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,
984: jtf_qual_type_usgs_all jqtu,

Line 1034: jty_denorm_dea_rules_all jtdr,

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,
1038: jtf_qual_type_usgs_all jqtu,

Line 1841: DELETE jty_denorm_dea_rules_all

1837: END IF;
1838:
1839: /* if mode is dea incremental, delete all entries from denorm table for the territory */
1840: IF ((p_terr_change_tab.hier_processing_flag(i) IN ('I', 'D')) AND (p_mode = 'DEA INCREMENTAL')) THEN
1841: DELETE jty_denorm_dea_rules_all
1842: WHERE terr_id = p_terr_change_tab.terr_id(i);
1843: END IF;
1844:
1845: /* if the # of rows that need to updated for relative rank exceeds */

Line 2474: DELETE jty_denorm_dea_rules_all

2470: WHERE hdr.source_id = p_source_id;
2471:
2472: EXECUTE IMMEDIATE 'truncate table '||l_table_owner || '.' || l_table_name ;
2473: ELSIF (p_mode = 'DATE EFFECTIVE') THEN
2474: DELETE jty_denorm_dea_rules_all
2475: WHERE source_id = p_source_id;
2476:
2477: /* drop index on denorm value table */
2478: drop_dnmval_table_indexes (

Line 2537: DELETE jty_denorm_dea_rules_all

2533: AND a.retcode = 0 ;
2534:
2535: EXECUTE IMMEDIATE 'delete ' || l_table_name || ' where source_id = :1 and (start_date > :2 or end_date < :3) ' USING p_source_id, l_dea_incr_end_date, l_dea_incr_start_date;
2536:
2537: DELETE jty_denorm_dea_rules_all
2538: WHERE source_id = p_source_id
2539: AND (start_date > l_dea_incr_end_date
2540: OR end_date < l_dea_incr_end_date);
2541: