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_DENORM_RULES_ALL

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

378: return 1;
379: END get_level_from_root;
380:
381: /* This procedure inserts the denormalized territory hierarchy informations */
382: /* into the tables jtf_terr_denorm_rules_all, for total and incremental mode */
383: /* and the table jty_denorm_dea_rules_all for date effective mode */
384: PROCEDURE update_denorm_table (
385: p_source_id IN NUMBER,
386: p_mode IN VARCHAR2,

Line 415: /* hierarchy information into jtf_terr_denorm_rules_all */

411: l_no_of_records := p_terr_id_tbl.COUNT;
412:
413: IF (l_no_of_records > 0) THEN
414: /* if mode is total or incremental, insert the denormalized */
415: /* hierarchy information into jtf_terr_denorm_rules_all */
416: IF (p_mode IN ('TOTAL', 'INCREMENTAL')) THEN
417: FORALL i IN p_terr_id_tbl.FIRST .. p_terr_id_tbl.LAST
418: INSERT INTO jtf_terr_denorm_rules_all(
419: source_id

Line 418: INSERT INTO jtf_terr_denorm_rules_all(

414: /* if mode is total or incremental, insert the denormalized */
415: /* hierarchy information into jtf_terr_denorm_rules_all */
416: IF (p_mode IN ('TOTAL', 'INCREMENTAL')) THEN
417: FORALL i IN p_terr_id_tbl.FIRST .. p_terr_id_tbl.LAST
418: INSERT INTO jtf_terr_denorm_rules_all(
419: source_id
420: , qual_type_id
421: , terr_id
422: , rank

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

471: -- debug message
472: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
473: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
474: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_denorm_table.num_rows_inserted',
475: 'Number of records inserted into jtf_terr_denorm_rules_all : ' || l_no_of_records);
476: END IF;
477:
478: ELSE
479: /* if mode is date effective, insert the denormalized */

Line 776: jtf_terr_denorm_rules_all jtdr,

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

Line 833: jtf_terr_denorm_rules_all jtdr,

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

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

1016: TYPE l_value4_id_tbl_type IS TABLE OF jtf_terr_values_all.value4_id%TYPE;
1017: TYPE l_fc_tbl_type IS TABLE OF jtf_terr_values_all.first_char%TYPE;
1018: TYPE l_update_stmt_tbl_type IS TABLE OF jtf_qual_usgs_all.update_attr_val_stmt%TYPE;
1019: TYPE l_insert_stmt_tbl_type IS TABLE OF jtf_qual_usgs_all.insert_attr_val_stmt%TYPE;
1020: TYPE l_top_lvl_terr_id_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.top_level_terr_id%TYPE;
1021: TYPE l_abs_rank_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.absolute_rank%TYPE;
1022: TYPE l_start_date_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.start_date%TYPE;
1023: TYPE l_end_date_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.end_date%TYPE;
1024: TYPE l_no_of_val_tbl_type IS TABLE OF NUMBER;

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

1017: TYPE l_fc_tbl_type IS TABLE OF jtf_terr_values_all.first_char%TYPE;
1018: TYPE l_update_stmt_tbl_type IS TABLE OF jtf_qual_usgs_all.update_attr_val_stmt%TYPE;
1019: TYPE l_insert_stmt_tbl_type IS TABLE OF jtf_qual_usgs_all.insert_attr_val_stmt%TYPE;
1020: TYPE l_top_lvl_terr_id_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.top_level_terr_id%TYPE;
1021: TYPE l_abs_rank_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.absolute_rank%TYPE;
1022: TYPE l_start_date_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.start_date%TYPE;
1023: TYPE l_end_date_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.end_date%TYPE;
1024: TYPE l_no_of_val_tbl_type IS TABLE OF NUMBER;
1025: TYPE l_rowid_tbl_type IS TABLE OF ROWID;

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

1018: TYPE l_update_stmt_tbl_type IS TABLE OF jtf_qual_usgs_all.update_attr_val_stmt%TYPE;
1019: TYPE l_insert_stmt_tbl_type IS TABLE OF jtf_qual_usgs_all.insert_attr_val_stmt%TYPE;
1020: TYPE l_top_lvl_terr_id_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.top_level_terr_id%TYPE;
1021: TYPE l_abs_rank_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.absolute_rank%TYPE;
1022: TYPE l_start_date_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.start_date%TYPE;
1023: TYPE l_end_date_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.end_date%TYPE;
1024: TYPE l_no_of_val_tbl_type IS TABLE OF NUMBER;
1025: TYPE l_rowid_tbl_type IS TABLE OF ROWID;
1026:

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

1019: TYPE l_insert_stmt_tbl_type IS TABLE OF jtf_qual_usgs_all.insert_attr_val_stmt%TYPE;
1020: TYPE l_top_lvl_terr_id_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.top_level_terr_id%TYPE;
1021: TYPE l_abs_rank_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.absolute_rank%TYPE;
1022: TYPE l_start_date_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.start_date%TYPE;
1023: TYPE l_end_date_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.end_date%TYPE;
1024: TYPE l_no_of_val_tbl_type IS TABLE OF NUMBER;
1025: TYPE l_rowid_tbl_type IS TABLE OF ROWID;
1026:
1027: l_qual_type_id_tbl l_qual_type_id_tbl_type;

Line 1705: DELETE jtf_terr_denorm_rules_all

1701: FOR i IN p_terr_change_tab.terr_id.FIRST .. p_terr_change_tab.terr_id.LAST LOOP
1702:
1703: /* if mode is incremental, delete all entries from denorm table for the territory */
1704: IF ((p_terr_change_tab.hier_processing_flag(i) IN ('I', 'D')) AND (p_mode = 'INCREMENTAL')) THEN
1705: DELETE jtf_terr_denorm_rules_all
1706: WHERE terr_id = p_terr_change_tab.terr_id(i);
1707: END IF;
1708:
1709: /* if the # of rows that need to updated for relative rank exceeds */

Line 2311: DELETE jtf_terr_denorm_rules_all

2307: END IF; /* end IF (p_mode = 'DATE EFFECTIVE') */
2308:
2309: /* delete the old records from denormalized tables */
2310: IF (p_mode = 'TOTAL') THEN
2311: DELETE jtf_terr_denorm_rules_all
2312: WHERE source_id = p_source_id;
2313:
2314: /* drop index on denorm value table */
2315: drop_dnmval_table_indexes (

Line 2381: DELETE jtf_terr_denorm_rules_all

2377: EXECUTE IMMEDIATE 'delete ' || l_table_name || ' where source_id = :1 ' USING p_source_id;
2378: ELSIF (p_mode = 'INCREMENTAL') THEN
2379: 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;
2380:
2381: DELETE jtf_terr_denorm_rules_all
2382: WHERE source_id = p_source_id
2383: AND (start_date > g_sysdate
2384: OR end_date < g_sysdate);
2385: