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.

[Home] [Help]

APPS.JTY_TERR_DENORM_RULES_PVT dependencies on JTF_TERR_DENORM_RULES_ALL

Line 431: /* into the tables jtf_terr_denorm_rules_all, for total and incremental mode */

427: return 1;
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,

Line 462: /* hierarchy information into jtf_terr_denorm_rules_all */

458: l_no_of_records := p_terr_id_tbl.COUNT;
459:
460: IF (l_no_of_records > 0) THEN
461: /* if mode is total or incremental, insert the denormalized */
462: /* hierarchy information into jtf_terr_denorm_rules_all */
463: IF (p_mode IN ('TOTAL', 'INCREMENTAL')) THEN
464: FORALL i IN p_terr_id_tbl.FIRST .. p_terr_id_tbl.LAST
465: INSERT INTO jtf_terr_denorm_rules_all(
466: source_id

Line 465: INSERT INTO jtf_terr_denorm_rules_all(

461: /* if mode is total or incremental, insert the denormalized */
462: /* hierarchy information into jtf_terr_denorm_rules_all */
463: IF (p_mode IN ('TOTAL', 'INCREMENTAL')) THEN
464: FORALL i IN p_terr_id_tbl.FIRST .. p_terr_id_tbl.LAST
465: INSERT INTO jtf_terr_denorm_rules_all(
466: source_id
467: , qual_type_id
468: , terr_id
469: , rank

Line 521: 'Number of records inserted into jtf_terr_denorm_rules_all : ' || l_no_of_records);

517:
518: -- debug message
519: jty_log(FND_LOG.LEVEL_STATEMENT,
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

Line 860: jtf_terr_denorm_rules_all jtdr,

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

Line 917: jtf_terr_denorm_rules_all jtdr,

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

Line 1117: TYPE l_top_lvl_terr_id_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.top_level_terr_id%TYPE;

1113: TYPE l_value4_id_tbl_type IS TABLE OF jtf_terr_values_all.value4_id%TYPE;
1114: TYPE l_fc_tbl_type IS TABLE OF jtf_terr_values_all.first_char%TYPE;
1115: TYPE l_update_stmt_tbl_type IS TABLE OF jtf_qual_usgs_all.update_attr_val_stmt%TYPE;
1116: TYPE l_insert_stmt_tbl_type IS TABLE OF jtf_qual_usgs_all.insert_attr_val_stmt%TYPE;
1117: TYPE l_top_lvl_terr_id_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.top_level_terr_id%TYPE;
1118: TYPE l_abs_rank_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.absolute_rank%TYPE;
1119: TYPE l_start_date_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.start_date%TYPE;
1120: TYPE l_end_date_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.end_date%TYPE;
1121: TYPE l_no_of_val_tbl_type IS TABLE OF NUMBER;

Line 1118: TYPE l_abs_rank_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.absolute_rank%TYPE;

1114: TYPE l_fc_tbl_type IS TABLE OF jtf_terr_values_all.first_char%TYPE;
1115: TYPE l_update_stmt_tbl_type IS TABLE OF jtf_qual_usgs_all.update_attr_val_stmt%TYPE;
1116: TYPE l_insert_stmt_tbl_type IS TABLE OF jtf_qual_usgs_all.insert_attr_val_stmt%TYPE;
1117: TYPE l_top_lvl_terr_id_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.top_level_terr_id%TYPE;
1118: TYPE l_abs_rank_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.absolute_rank%TYPE;
1119: TYPE l_start_date_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.start_date%TYPE;
1120: TYPE l_end_date_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.end_date%TYPE;
1121: TYPE l_no_of_val_tbl_type IS TABLE OF NUMBER;
1122: TYPE l_rowid_tbl_type IS TABLE OF ROWID;

Line 1119: TYPE l_start_date_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.start_date%TYPE;

1115: TYPE l_update_stmt_tbl_type IS TABLE OF jtf_qual_usgs_all.update_attr_val_stmt%TYPE;
1116: TYPE l_insert_stmt_tbl_type IS TABLE OF jtf_qual_usgs_all.insert_attr_val_stmt%TYPE;
1117: TYPE l_top_lvl_terr_id_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.top_level_terr_id%TYPE;
1118: TYPE l_abs_rank_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.absolute_rank%TYPE;
1119: TYPE l_start_date_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.start_date%TYPE;
1120: TYPE l_end_date_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.end_date%TYPE;
1121: TYPE l_no_of_val_tbl_type IS TABLE OF NUMBER;
1122: TYPE l_rowid_tbl_type IS TABLE OF ROWID;
1123:

Line 1120: TYPE l_end_date_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.end_date%TYPE;

1116: TYPE l_insert_stmt_tbl_type IS TABLE OF jtf_qual_usgs_all.insert_attr_val_stmt%TYPE;
1117: TYPE l_top_lvl_terr_id_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.top_level_terr_id%TYPE;
1118: TYPE l_abs_rank_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.absolute_rank%TYPE;
1119: TYPE l_start_date_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.start_date%TYPE;
1120: TYPE l_end_date_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.end_date%TYPE;
1121: TYPE l_no_of_val_tbl_type IS TABLE OF NUMBER;
1122: TYPE l_rowid_tbl_type IS TABLE OF ROWID;
1123:
1124: l_qual_type_id_tbl l_qual_type_id_tbl_type;

Line 1835: DELETE jtf_terr_denorm_rules_all

1831: FOR i IN p_terr_change_tab.terr_id.FIRST .. p_terr_change_tab.terr_id.LAST LOOP
1832:
1833: /* if mode is incremental, delete all entries from denorm table for the territory */
1834: IF ((p_terr_change_tab.hier_processing_flag(i) IN ('I', 'D')) AND (p_mode = 'INCREMENTAL')) THEN
1835: DELETE jtf_terr_denorm_rules_all
1836: WHERE terr_id = p_terr_change_tab.terr_id(i);
1837: END IF;
1838:
1839: /* if mode is dea incremental, delete all entries from denorm table for the territory */

Line 2442: DELETE jtf_terr_denorm_rules_all

2438: END IF; /* end IF (p_mode = 'DATE EFFECTIVE') */
2439:
2440: /* delete the old records from denormalized tables */
2441: IF (p_mode = 'TOTAL') THEN
2442: DELETE jtf_terr_denorm_rules_all
2443: WHERE source_id = p_source_id;
2444:
2445: /* drop index on denorm value table */
2446: drop_dnmval_table_indexes (

Line 2508: DELETE jtf_terr_denorm_rules_all

2504: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_table_owner || '.' || l_table_name;
2505: ELSIF (p_mode = 'INCREMENTAL') THEN
2506: EXECUTE IMMEDIATE 'delete ' || l_table_name || ' where source_id = :1 and (start_date > :2 or end_date < :3) ' USING p_source_id, g_sysdate, g_sysdate;
2507:
2508: DELETE jtf_terr_denorm_rules_all
2509: WHERE source_id = p_source_id
2510: AND (start_date > g_sysdate
2511: OR end_date < g_sysdate);
2512: