APPS.JTF_IH_TOOLS dependencies on JTF_IH_OUTCOMES_B

Line 72: l_Sql := l_Sql||'jtf_ih_outcomes_b outc, '||

68: RAISE e_Error;
69: END IF;
70: --DBMS_OUTPUT.put_line('p_Wrap_Up_Level '|| p_Wrap_Up_Level);
71:
72: l_Sql := l_Sql||'jtf_ih_outcomes_b outc, '||
73: 'jtf_ih_results_b result, '||
74: 'jtf_ih_reasons_b reason '||
75: 'WHERE tbl.outcome_id = outc.outcome_id AND '||
76: 'tbl.result_id = result.result_id(+) AND '||

Line 359: -- If JTF_IH_OUTCOMES_B is empty then raise an exception.

355:
356:
357: savepoint jtf_ih_migrate;
358:
359: -- If JTF_IH_OUTCOMES_B is empty then raise an exception.
360: select count(*) into nCount from jtf_ih_outcomes_b;
361: if nCount = 0 then
362: raise eNoOutcomes;
363: end if;

Line 360: select count(*) into nCount from jtf_ih_outcomes_b;

356:
357: savepoint jtf_ih_migrate;
358:
359: -- If JTF_IH_OUTCOMES_B is empty then raise an exception.
360: select count(*) into nCount from jtf_ih_outcomes_b;
361: if nCount = 0 then
362: raise eNoOutcomes;
363: end if;
364:

Line 370: For curOut in (select outcome_id, result_required from jtf_ih_outcomes_b where active <> 'N' or active is null ) loop

366:
367: --
368: -- Loop over all active outcomes non-campaign based
369: nCnt := 1;
370: For curOut in (select outcome_id, result_required from jtf_ih_outcomes_b where active <> 'N' or active is null ) loop
371: -- add outcome only wrap-up row if no Result is required
372: if curOut.result_required = 'N' or curOut.result_required is null then
373: ttWrpUps(nCnt).Outcome_Id := curOut.outcome_id;
374: ttWrpUps(nCnt).Result_id := null;

Line 434: from jtf_ih_outcomes_b outc, jtf_ih_outcomes_campaigns cmpOut

430:
431: -- loop over the campaign based outcomes and build wrap-ups for them
432: for curOut in (select cmpOut.outcome_id, cmpOut.source_code,
433: outc.result_required
434: from jtf_ih_outcomes_b outc, jtf_ih_outcomes_campaigns cmpOut
435: where outc.outcome_id = cmpOut.outcome_id
436: and (outc.active <> 'N' or outc.active is null)
437: order by outc.outcome_id) loop
438: begin

Line 648: UPDATE jtf_ih_outcomes_b SET active='Y' WHERE active IS NULL;

644: end loop;
645: dbms_sql.close_cursor(iCursor);
646:
647: -- Enh# 3519691
648: UPDATE jtf_ih_outcomes_b SET active='Y' WHERE active IS NULL;
649: UPDATE jtf_ih_results_b SET active='Y' WHERE active IS NULL;
650: UPDATE jtf_ih_reasons_b SET active='Y' WHERE active IS NULL;
651: UPDATE JTF_IH_OUTCOMES_B set RESULT_REQUIRED = 'N' WHERE RESULT_REQUIRED is NULL;
652: UPDATE JTF_IH_RESULTS_B set RESULT_REQUIRED = 'N' WHERE RESULT_REQUIRED is NULL;

Line 651: UPDATE JTF_IH_OUTCOMES_B set RESULT_REQUIRED = 'N' WHERE RESULT_REQUIRED is NULL;

647: -- Enh# 3519691
648: UPDATE jtf_ih_outcomes_b SET active='Y' WHERE active IS NULL;
649: UPDATE jtf_ih_results_b SET active='Y' WHERE active IS NULL;
650: UPDATE jtf_ih_reasons_b SET active='Y' WHERE active IS NULL;
651: UPDATE JTF_IH_OUTCOMES_B set RESULT_REQUIRED = 'N' WHERE RESULT_REQUIRED is NULL;
652: UPDATE JTF_IH_RESULTS_B set RESULT_REQUIRED = 'N' WHERE RESULT_REQUIRED is NULL;
653: COMMIT;
654:
655: JTF_IH_TOOLS.MIGRATE_IH_WRAPUPS('INTERACTION'); -- Add unique combinations based on jtf_ih_interactions table