APPS.JTY_TERR_ENGINE_GEN_PVT dependencies on JTY_TERR_DENORM_RULES_PVT

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

283: ,a.matching_sql_flag
284: ,a.hier_processing_flag
285: ,b.rank
286: ,b.parent_territory_id
287: ,JTY_TERR_DENORM_RULES_PVT.get_level_from_root(a.terr_id)
288: ,b.num_winners
289: ,b.org_id
290: ,c.num_winners
291: ,b.start_date_active

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

477: ,a.matching_sql_flag
478: ,a.hier_processing_flag
479: ,b.rank
480: ,b.parent_territory_id
481: ,JTY_TERR_DENORM_RULES_PVT.get_level_from_root(a.terr_id)
482: ,b.num_winners
483: ,b.org_id
484: ,c.num_winners
485: ,b.start_date_active

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

824: ,NVL(jta1.rank, 999999999) rank
825: ,jta1.num_winners num_winners
826: ,jta1.org_id org_id
827: ,jta1.parent_territory_id parent_territory_id
828: ,JTY_TERR_DENORM_RULES_PVT.get_level_from_root(jta1.terr_id) level_from_root
829: ,jta2.num_winners parent_num_winners
830: ,'Y' rank_calc_flag
831: ,'I' attr_processing_flag
832: ,'I' hier_processing_flag

Line 1050: JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank (

1046: 'Number of territories to be processed : ' || l_no_of_records);
1047:
1048: IF (l_no_of_records > 0) THEN
1049: /* Calculate rank, denormalize hierarchy and qualifier values */
1050: JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank (
1051: p_source_id => p_source_id,
1052: p_mode => p_mode,
1053: p_terr_change_tab => l_terr_change_tab,
1054: errbuf => errbuf,

Line 1151: JTY_TERR_DENORM_RULES_PVT.CREATE_DNMVAL_INDEX (

1147: EXECUTE IMMEDIATE 'SELECT count(*) FROM ' || l_table_name || ' where ROWNUM = 1' INTO l_denorm_count;
1148: /* Create index on the denorm value table */
1149: /* Dont create the index on the denorm table if the there are no rows in the denorm table*/
1150: IF ( l_denorm_count = 1 ) THEN
1151: JTY_TERR_DENORM_RULES_PVT.CREATE_DNMVAL_INDEX (
1152: p_table_name => l_table_name,
1153: p_source_id => p_source_id,
1154: p_mode => p_mode,
1155: x_Return_Status => l_Return_Status);

Line 1159: JTY_TERR_DENORM_RULES_PVT.CREATE_DNMVAL_INDEX (

1155: x_Return_Status => l_Return_Status);
1156: END IF;
1157: ELSE
1158: /* Create index on the denorm value table */
1159: JTY_TERR_DENORM_RULES_PVT.CREATE_DNMVAL_INDEX (
1160: p_table_name => l_table_name,
1161: p_source_id => p_source_id,
1162: p_mode => p_mode,
1163: x_Return_Status => l_Return_Status);

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

1166: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1167: -- debug message
1168: jty_log(FND_LOG.LEVEL_EXCEPTION,
1169: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.CREATE_DNMVAL_INDEX',
1170: 'JTY_TERR_DENORM_RULES_PVT.CREATE_DNMVAL_INDEX API has failed');
1171:
1172: RAISE FND_API.G_EXC_ERROR;
1173: END IF;
1174: