APPS.MSC_NETCHANGE_PKG dependencies on DUAL

Line 172: from dual;

168: order by lookup_code;
169:
170: select msc_form_query_s.nextval
171: into g_options_query_id
172: from dual;
173:
174: option_query_id :=g_options_query_id;
175: compare_options;
176: compare_aggregate;

Line 392: from dual;

388: 1, -- options
389: a,
390: plan_a_rec(a),
391: plan_b_rec(a)
392: from dual;
393: -- end if;
394: end loop;
395:
396: End compare_options;

Line 425: 1, g_misc(20), --'Individual',

421: decode(mp.PERIOD_ITEM_AGGREGATION_LEVEL,
422: 1, g_misc(18), --'Items',
423: 2, g_misc(19)), --'Product Family'),
424: decode(mp.DAILY_RES_AGGREGATION_LEVEL,
425: 1, g_misc(20), --'Individual',
426: 2, g_misc(21))||', '|| --'Aggregate')||','||
427: decode(mp.WEEKLY_RES_AGGREGATION_LEVEL,
428: 1, g_misc(20), --'Individual',
429: 2, g_misc(21))||', '|| --'Aggregate') ||','||

Line 428: 1, g_misc(20), --'Individual',

424: decode(mp.DAILY_RES_AGGREGATION_LEVEL,
425: 1, g_misc(20), --'Individual',
426: 2, g_misc(21))||', '|| --'Aggregate')||','||
427: decode(mp.WEEKLY_RES_AGGREGATION_LEVEL,
428: 1, g_misc(20), --'Individual',
429: 2, g_misc(21))||', '|| --'Aggregate') ||','||
430: decode(mp.PERIOD_RES_AGGREGATION_LEVEL,
431: 1, g_misc(20), --'Individual',
432: 2, g_misc(21)), --'Aggregate'),

Line 431: 1, g_misc(20), --'Individual',

427: decode(mp.WEEKLY_RES_AGGREGATION_LEVEL,
428: 1, g_misc(20), --'Individual',
429: 2, g_misc(21))||', '|| --'Aggregate') ||','||
430: decode(mp.PERIOD_RES_AGGREGATION_LEVEL,
431: 1, g_misc(20), --'Individual',
432: 2, g_misc(21)), --'Aggregate'),
433: decode(mp.DAILY_RTG_AGGREGATION_LEVEL,
434: 1,g_misc(22), --'Routings',
435: 2, g_misc(22))||', '|| --'BOR') ||','||

Line 497: from dual;

493: 2, -- aggregate
494: a,
495: plan_a_rec(a),
496: plan_b_rec(a)
497: from dual;
498: end loop;
499:
500: End compare_aggregate;
501:

Line 581: from dual;

577: 3, -- optimize
578: a,
579: plan_a_rec(a),
580: plan_b_rec(a)
581: from dual;
582:
583: end loop;
584:
585: End compare_optimize;

Line 702: from dual;

698: 7, -- constraints
699: a,
700: plan_a_rec(a),
701: plan_b_rec(a)
702: from dual;
703:
704: end loop;
705:
706: end compare_constraints;

Line 767: from dual;

763: 8, -- optimize
764: a,
765: plan_a_rec(a),
766: plan_b_rec(a)
767: from dual;
768: end loop;
769:
770: end compare_goalprog;
771:

Line 1188: from dual;

1184:
1185: if g_need_insert_temp then
1186: select msc_form_query_s.nextval
1187: into g_excp_query_id
1188: from dual;
1189: else
1190: g_excp_query_id := p_report_id;
1191: end if;
1192:

Line 1918: from dual;

1914: checkPlanStatus(p_from_plan, p_to_plan,p_plan_status,p_report_id);
1915: if p_plan_status = NOT_COMPARED then
1916: select msc_nec_compare_plans_s.nextval
1917: into p_report_id
1918: from dual;
1919:
1920: insert into msc_nec_compare_plans
1921: (report_id,
1922: from_plan,