APPS.JTY_TERR_ENGINE_GEN_PVT dependencies on JTY_TERR_DENORM_RULES_PVT

Line 277: ,JTY_TERR_DENORM_RULES_PVT.get_level_from_root(a.terr_id)

273: ,a.matching_sql_flag
274: ,a.hier_processing_flag
275: ,b.rank
276: ,b.parent_territory_id
277: ,JTY_TERR_DENORM_RULES_PVT.get_level_from_root(a.terr_id)
278: ,b.num_winners
279: ,b.org_id
280: ,c.num_winners
281: ,b.start_date_active

Line 591: ,JTY_TERR_DENORM_RULES_PVT.get_level_from_root(jta1.terr_id) level_from_root

587: ,NVL(jta1.rank, 999999999) rank
588: ,jta1.num_winners num_winners
589: ,jta1.org_id org_id
590: ,jta1.parent_territory_id parent_territory_id
591: ,JTY_TERR_DENORM_RULES_PVT.get_level_from_root(jta1.terr_id) level_from_root
592: ,jta2.num_winners parent_num_winners
593: ,'Y' rank_calc_flag
594: ,'I' attr_processing_flag
595: ,'I' hier_processing_flag

Line 764: JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank (

760: END IF;
761:
762: IF (l_no_of_records > 0) THEN
763: /* Calculate rank, denormalize hierarchy and qualifier values */
764: JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank (
765: p_source_id => p_source_id,
766: p_mode => p_mode,
767: p_terr_change_tab => l_terr_change_tab,
768: errbuf => errbuf,

Line 873: JTY_TERR_DENORM_RULES_PVT.CREATE_DNMVAL_INDEX (

869: EXECUTE IMMEDIATE 'SELECT count(*) FROM ' || l_table_name || ' where ROWNUM = 1' INTO l_denorm_count;
870: /* Create index on the denorm value table */
871: /* Dont create the index on the denorm table if the there are no rows in the denorm table*/
872: IF ( l_denorm_count = 1 ) THEN
873: JTY_TERR_DENORM_RULES_PVT.CREATE_DNMVAL_INDEX (
874: p_table_name => l_table_name,
875: p_source_id => p_source_id,
876: p_mode => p_mode,
877: x_Return_Status => l_Return_Status);

Line 881: JTY_TERR_DENORM_RULES_PVT.CREATE_DNMVAL_INDEX (

877: x_Return_Status => l_Return_Status);
878: END IF;
879: ELSE
880: /* Create index on the denorm value table */
881: JTY_TERR_DENORM_RULES_PVT.CREATE_DNMVAL_INDEX (
882: p_table_name => l_table_name,
883: p_source_id => p_source_id,
884: p_mode => p_mode,
885: x_Return_Status => l_Return_Status);

Line 893: 'JTY_TERR_DENORM_RULES_PVT.CREATE_DNMVAL_INDEX API has failed');

889: -- debug message
890: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
891: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
892: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.CREATE_DNMVAL_INDEX',
893: 'JTY_TERR_DENORM_RULES_PVT.CREATE_DNMVAL_INDEX API has failed');
894: END IF;
895:
896: RAISE FND_API.G_EXC_ERROR;
897: END IF;