APPS.JTF_TERR_DENORM_RULES_PVT dependencies on JTF_TERR_DENORM_RULES_ALL

Line 22: -- it will be inserted in JTF_TERR_DENORM_RULES_ALL

18: -- HISTORY
19: -- 12/13/00 JDOCHERT CREATED
20: -- 04/05/01 JDOCHERT Removed restriction that resource needs
21: -- to be attached to territory record before
22: -- it will be inserted in JTF_TERR_DENORM_RULES_ALL
23: -- 03/04/02 JDOCHERT bug#2250830
24:
25: --
26: -- End of Comments

Line 109: -- FROM jtf_terr_denorm_rules_all jtdr

105: -- start of DENORM Process
106: --
107: -- AND NOT EXISTS(
108: -- SELECT jtdr.terr_id
109: -- FROM jtf_terr_denorm_rules_all jtdr
110: -- WHERE jtdr.terr_id = jt1.terr_id
111: -- AND jtdr.source_id = lp_source_id
112: -- AND jtdr.qual_type_id = lp_qual_type_id )
113: --

Line 226: DELETE FROM jtf_terr_denorm_rules_all jtdr

222: /* delete old records */
223: /* ARPATEL: 12/03: for ORacle Sales denorm records are no longer striped by TX type */
224: if p_source_id = -1001
225: then
226: DELETE FROM jtf_terr_denorm_rules_all jtdr
227: WHERE jtdr.source_id = p_source_id;
228: else
229: DELETE FROM jtf_terr_denorm_rules_all jtdr
230: WHERE jtdr.source_id = p_source_id

Line 229: DELETE FROM jtf_terr_denorm_rules_all jtdr

225: then
226: DELETE FROM jtf_terr_denorm_rules_all jtdr
227: WHERE jtdr.source_id = p_source_id;
228: else
229: DELETE FROM jtf_terr_denorm_rules_all jtdr
230: WHERE jtdr.source_id = p_source_id
231: AND jtdr.qual_type_id = p_qual_type_id;
232: end if;
233:

Line 395: INSERT INTO jtf_terr_denorm_rules_all(

391: END LOOP; /* FOR i IN l_terr_id_tbl.FIRST..l_terr_id_tbl.LAST */
392: END IF;
393:
394: FORALL i IN l_terr_id_tbl.FIRST..l_terr_id_tbl.LAST
395: INSERT INTO jtf_terr_denorm_rules_all(
396: source_id
397: , qual_type_id
398: , terr_id
399: , absolute_rank

Line 480: INSERT INTO jtf_terr_denorm_rules_all (

476:
477: l_level_from_parent_tbl(i) := l_level_from_parent_tbl(i) + 1;
478: l_level_from_root_tbl(i) := l_level_from_root_tbl(i) - 1;
479:
480: INSERT INTO jtf_terr_denorm_rules_all (
481: source_id
482: , qual_type_id
483: , terr_id
484: , absolute_rank

Line 568: INSERT INTO JTF_TERR_DENORM_RULES_ALL (

564: --TO_CHAR(l_new_parent_territory_id));
565: --dbms_output.put_line('parent_num_winners='||
566: --TO_CHAR(l_new_parent_num_winners));
567:
568: INSERT INTO JTF_TERR_DENORM_RULES_ALL (
569: source_id
570: , qual_type_id
571: , terr_id
572: , absolute_rank