APPS.JTF_TAE_CONTROL_PVT dependencies on JTF_TERR_QTYPE_USGS_ALL

Line 214: ** now use qual_relation_product in jtf_terr_qtype_usgs_all

210: ll_counter number := 0;
211: total_terr_all_orgs number := 0;
212:
213: /* ARPATEL: 01/06/2004 bug#3337382
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

Line 219: ,jtf_terr_qtype_usgs_all jtqu

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
223: /* JDOCHERT: 07/29/03: BUG# :

Line 285: ** now use qual_relation_product in jtf_terr_qtype_usgs_all

281: ** added source and trans id sbehera 04/15/2002 */
282: /* ARPATEL: 12/09/2003 Bug#3307414 Sales denorm record no longer striped by TX type, qual_type_id = -1 */
283:
284: /* ARPATEL: 01/06/2004 bug#3337382
285: ** now use qual_relation_product in jtf_terr_qtype_usgs_all
286: */
287:
288: /* ACHANDA 03/08/04 Bug 3373687 : disable the trigger before update */
289: BEGIN

Line 296: UPDATE jtf_terr_qtype_usgs_all jtqu

292: WHEN OTHERS THEN
293: NULL;
294: END;
295:
296: UPDATE jtf_terr_qtype_usgs_all jtqu
297: SET jtqu.QUAL_RELATION_PRODUCT = 1
298: WHERE jtqu.qual_type_usg_id = (
299: SELECT jqtu.qual_type_usg_id
300: FROM jtf_qual_type_usgs_all jqtu

Line 357: ** now use qual_relation_product in jtf_terr_qtype_usgs_all

353:
354: /* ARPATEL: 12/09/2003 Bug#3307414 Sales denorm record no longer striped by TX type, qual_type_id = -1 */
355:
356: /* ARPATEL: 01/06/2004 bug#3337382
357: ** now use qual_relation_product in jtf_terr_qtype_usgs_all
358: */
359: /* ACHANDA 03/08/04 Bug 3373687 : disable the trigger before update */
360: BEGIN
361: EXECUTE IMMEDIATE 'ALTER TRIGGER JTF_TERR_QTYPE_USGS_BIUD DISABLE';

Line 367: UPDATE jtf_terr_qtype_usgs_all jtqu

363: WHEN OTHERS THEN
364: NULL;
365: END;
366:
367: UPDATE jtf_terr_qtype_usgs_all jtqu
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

Line 373: ,jtf_terr_qtype_usgs_all ijtqu

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
377: AND ijqtu.source_id = ijtdr.source_id