APPS.JTF_TAE_CONTROL_PVT dependencies on JTF_TERR_DENORM_RULES_ALL

Line 44: -- jtf_terr_denorm_rules_all

40: -- 04/02/2002 EIHSU terr analysis for set transactiontype
41: -- 04/04/2002 EIHSU parameterized input table
42: -- 04/08/2002 EIHSU renamed a lot of stuff
43: -- 04/15/2002 SBEHERA added source_id and tran_id to update
44: -- jtf_terr_denorm_rules_all
45: -- 04/16/2002 SBEHERA added source_id and tran_id to delete
46: -- jtf_tae_qual_prod_factors
47: -- 05/03/2002 EIHSU set build_index_flag to 'N' if the index
48: -- does not have any columns in it

Line 134: -- jtf_terr_denorm_rules_all

130: -- Implements Aggregate/Component Relation Key analysis of
131: -- territory/qualifier relations.
132: --
133: -- REQIRES / DEPENDENCIES
134: -- jtf_terr_denorm_rules_all
135: -- jtf_terr_qual_all
136: --
137: -- MODIFIES
138: -- Rows in JTF_TAE_QUAL_FACTORS/JTF_TAE_QUAL_PRODUCTS

Line 218: FROM jtf_terr_denorm_rules_all jtdr

214: ** now use qual_relation_product in jtf_terr_qtype_usgs_all
215: */
216: cursor qual_rel_sets(cl_qual_type_id number) is
217: SELECT count(*) total_count, jtqu.qual_relation_product
218: FROM jtf_terr_denorm_rules_all jtdr
219: ,jtf_terr_qtype_usgs_all jtqu
220: ,jtf_qual_type_usgs_all jqtu
221: WHERE 1=1
222: --and org_id = -3113

Line 313: --UPDATE jtf_terr_denorm_rules_all jtdr

309: WHEN OTHERS THEN
310: NULL;
311: END;
312:
313: --UPDATE jtf_terr_denorm_rules_all jtdr
314: -- SET jtdr.QUAL_RELATION_PRODUCT = 1
315: -- WHERE jtdr.terr_id = related_terr_id
316: -- AND jtdr.source_id = p_source_id
317: -- AND jtdr.qual_type_id = -1; --p_trans_id;

Line 372: FROM jtf_terr_denorm_rules_all ijtdr

368: SET jtqu.QUAL_RELATION_PRODUCT =
369: jtqu.QUAL_RELATION_PRODUCT * qual_rel.qual_relation_factor
370: WHERE jtqu.terr_id IN
371: ( SELECT ijtdr.terr_id
372: FROM jtf_terr_denorm_rules_all ijtdr
373: ,jtf_terr_qtype_usgs_all ijtqu
374: ,jtf_qual_type_usgs_all ijqtu
375: ,jtf_terr_qual_all jtq
376: WHERE ijtdr.source_id = l_source_id

Line 400: UPDATE jtf_terr_denorm_rules_all jtdr

396: NULL;
397: END;
398:
399: /*
400: UPDATE jtf_terr_denorm_rules_all jtdr
401: SET jtdr.QUAL_RELATION_PRODUCT =
402: jtdr.QUAL_RELATION_PRODUCT * qual_rel.qual_relation_factor
403: WHERE jtdr.terr_id IN
404: ( SELECT ijtdr.terr_id

Line 405: FROM jtf_terr_denorm_rules_all ijtdr,

401: SET jtdr.QUAL_RELATION_PRODUCT =
402: jtdr.QUAL_RELATION_PRODUCT * qual_rel.qual_relation_factor
403: WHERE jtdr.terr_id IN
404: ( SELECT ijtdr.terr_id
405: FROM jtf_terr_denorm_rules_all ijtdr,
406: jtf_terr_qual_all jtq
407: WHERE ijtdr.source_id = l_source_id
408: and ijtdr.qual_type_id = -1
409: and ijtdr.related_terr_id = jtq.terr_id

Line 428: 'UPDATE JTF_TERR_DENORM_RULES_ALL.QUAL_RELATION_PRODUCT.';

424:
425: EXCEPTION
426: WHEN NO_DATA_FOUND THEN
427: ERRBUF := 'JTF_TAE_CONTROL.Classify_Territories: [2] NO_DATA_FOUND: ' ||
428: 'UPDATE JTF_TERR_DENORM_RULES_ALL.QUAL_RELATION_PRODUCT.';
429: JTF_TAE_CONTROL_PVT.Write_Log(2, ERRBUF);
430: RAISE FND_API.G_EXC_ERROR;
431:
432: WHEN OTHERS THEN