eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_ANALYSIS_BUDGET dependencies on DBMS_OUTPUT

Line 230: dbms_output.put('plan_id,instance_id,org_id,org_name,plan_name,cat_id,cat_name,bucket_type,');

226: BEGIN
227: IF do_debug = FALSE THEN
228: RETURN;
229: END IF;
230: dbms_output.put('plan_id,instance_id,org_id,org_name,plan_name,cat_id,cat_name,bucket_type,');
231: dbms_output.put_line('detail_level,start_date,end_date,period_nr,achieved_budget_dollars,record_type,required_qty,delivered_qty,target_sl_qty,nr_target_sl,week_nr,period_start_date');
232: END;
233:
234: PROCEDURE schedule_dump_record(aRecord BUCKET)

Line 231: dbms_output.put_line('detail_level,start_date,end_date,period_nr,achieved_budget_dollars,record_type,required_qty,delivered_qty,target_sl_qty,nr_target_sl,week_nr,period_start_date');

227: IF do_debug = FALSE THEN
228: RETURN;
229: END IF;
230: dbms_output.put('plan_id,instance_id,org_id,org_name,plan_name,cat_id,cat_name,bucket_type,');
231: dbms_output.put_line('detail_level,start_date,end_date,period_nr,achieved_budget_dollars,record_type,required_qty,delivered_qty,target_sl_qty,nr_target_sl,week_nr,period_start_date');
232: END;
233:
234: PROCEDURE schedule_dump_record(aRecord BUCKET)
235: IS

Line 240: dbms_output.put('"'||aRecord.plan_id || '","' || aRecord.instance_id || '",');

236: BEGIN
237: IF do_debug = FALSE THEN
238: RETURN;
239: END IF;
240: dbms_output.put('"'||aRecord.plan_id || '","' || aRecord.instance_id || '",');
241: dbms_output.put('"'|| aRecord.org_id || '",');
242: DBMS_OUTPUT.put('"' || aRecord.org_name || '","' || aRecord.plan_name || '",');
243: dbms_output.put('"' || aRecord.sr_category_id || '","' || aRecord.category_name || '",');
244: DBMS_OUTPUT.put('"' || aRecord.bucket_type || '",');

Line 241: dbms_output.put('"'|| aRecord.org_id || '",');

237: IF do_debug = FALSE THEN
238: RETURN;
239: END IF;
240: dbms_output.put('"'||aRecord.plan_id || '","' || aRecord.instance_id || '",');
241: dbms_output.put('"'|| aRecord.org_id || '",');
242: DBMS_OUTPUT.put('"' || aRecord.org_name || '","' || aRecord.plan_name || '",');
243: dbms_output.put('"' || aRecord.sr_category_id || '","' || aRecord.category_name || '",');
244: DBMS_OUTPUT.put('"' || aRecord.bucket_type || '",');
245: DBMS_OUTPUT.put('"' || aRecord.detail_level || '",');

Line 242: DBMS_OUTPUT.put('"' || aRecord.org_name || '","' || aRecord.plan_name || '",');

238: RETURN;
239: END IF;
240: dbms_output.put('"'||aRecord.plan_id || '","' || aRecord.instance_id || '",');
241: dbms_output.put('"'|| aRecord.org_id || '",');
242: DBMS_OUTPUT.put('"' || aRecord.org_name || '","' || aRecord.plan_name || '",');
243: dbms_output.put('"' || aRecord.sr_category_id || '","' || aRecord.category_name || '",');
244: DBMS_OUTPUT.put('"' || aRecord.bucket_type || '",');
245: DBMS_OUTPUT.put('"' || aRecord.detail_level || '",');
246: dbms_output.put('"' || aRecord.bkt_start_date || '",');

Line 243: dbms_output.put('"' || aRecord.sr_category_id || '","' || aRecord.category_name || '",');

239: END IF;
240: dbms_output.put('"'||aRecord.plan_id || '","' || aRecord.instance_id || '",');
241: dbms_output.put('"'|| aRecord.org_id || '",');
242: DBMS_OUTPUT.put('"' || aRecord.org_name || '","' || aRecord.plan_name || '",');
243: dbms_output.put('"' || aRecord.sr_category_id || '","' || aRecord.category_name || '",');
244: DBMS_OUTPUT.put('"' || aRecord.bucket_type || '",');
245: DBMS_OUTPUT.put('"' || aRecord.detail_level || '",');
246: dbms_output.put('"' || aRecord.bkt_start_date || '",');
247: dbms_output.put('"' || aRecord.bkt_end_date || '",');

Line 244: DBMS_OUTPUT.put('"' || aRecord.bucket_type || '",');

240: dbms_output.put('"'||aRecord.plan_id || '","' || aRecord.instance_id || '",');
241: dbms_output.put('"'|| aRecord.org_id || '",');
242: DBMS_OUTPUT.put('"' || aRecord.org_name || '","' || aRecord.plan_name || '",');
243: dbms_output.put('"' || aRecord.sr_category_id || '","' || aRecord.category_name || '",');
244: DBMS_OUTPUT.put('"' || aRecord.bucket_type || '",');
245: DBMS_OUTPUT.put('"' || aRecord.detail_level || '",');
246: dbms_output.put('"' || aRecord.bkt_start_date || '",');
247: dbms_output.put('"' || aRecord.bkt_end_date || '",');
248: dbms_output.put('"' || aRecord.period_nr || '",');

Line 245: DBMS_OUTPUT.put('"' || aRecord.detail_level || '",');

241: dbms_output.put('"'|| aRecord.org_id || '",');
242: DBMS_OUTPUT.put('"' || aRecord.org_name || '","' || aRecord.plan_name || '",');
243: dbms_output.put('"' || aRecord.sr_category_id || '","' || aRecord.category_name || '",');
244: DBMS_OUTPUT.put('"' || aRecord.bucket_type || '",');
245: DBMS_OUTPUT.put('"' || aRecord.detail_level || '",');
246: dbms_output.put('"' || aRecord.bkt_start_date || '",');
247: dbms_output.put('"' || aRecord.bkt_end_date || '",');
248: dbms_output.put('"' || aRecord.period_nr || '",');
249: dbms_output.put('"' || aRecord.achieved_budget_usd || '",');

Line 246: dbms_output.put('"' || aRecord.bkt_start_date || '",');

242: DBMS_OUTPUT.put('"' || aRecord.org_name || '","' || aRecord.plan_name || '",');
243: dbms_output.put('"' || aRecord.sr_category_id || '","' || aRecord.category_name || '",');
244: DBMS_OUTPUT.put('"' || aRecord.bucket_type || '",');
245: DBMS_OUTPUT.put('"' || aRecord.detail_level || '",');
246: dbms_output.put('"' || aRecord.bkt_start_date || '",');
247: dbms_output.put('"' || aRecord.bkt_end_date || '",');
248: dbms_output.put('"' || aRecord.period_nr || '",');
249: dbms_output.put('"' || aRecord.achieved_budget_usd || '",');
250: IF aRecord.record_type = RECORD_BUDGET THEN

Line 247: dbms_output.put('"' || aRecord.bkt_end_date || '",');

243: dbms_output.put('"' || aRecord.sr_category_id || '","' || aRecord.category_name || '",');
244: DBMS_OUTPUT.put('"' || aRecord.bucket_type || '",');
245: DBMS_OUTPUT.put('"' || aRecord.detail_level || '",');
246: dbms_output.put('"' || aRecord.bkt_start_date || '",');
247: dbms_output.put('"' || aRecord.bkt_end_date || '",');
248: dbms_output.put('"' || aRecord.period_nr || '",');
249: dbms_output.put('"' || aRecord.achieved_budget_usd || '",');
250: IF aRecord.record_type = RECORD_BUDGET THEN
251: dbms_output.put('"BUDGET",');

Line 248: dbms_output.put('"' || aRecord.period_nr || '",');

244: DBMS_OUTPUT.put('"' || aRecord.bucket_type || '",');
245: DBMS_OUTPUT.put('"' || aRecord.detail_level || '",');
246: dbms_output.put('"' || aRecord.bkt_start_date || '",');
247: dbms_output.put('"' || aRecord.bkt_end_date || '",');
248: dbms_output.put('"' || aRecord.period_nr || '",');
249: dbms_output.put('"' || aRecord.achieved_budget_usd || '",');
250: IF aRecord.record_type = RECORD_BUDGET THEN
251: dbms_output.put('"BUDGET",');
252: ELSIF aRecord.record_type = RECORD_SERVICE_LEVEL THEN

Line 249: dbms_output.put('"' || aRecord.achieved_budget_usd || '",');

245: DBMS_OUTPUT.put('"' || aRecord.detail_level || '",');
246: dbms_output.put('"' || aRecord.bkt_start_date || '",');
247: dbms_output.put('"' || aRecord.bkt_end_date || '",');
248: dbms_output.put('"' || aRecord.period_nr || '",');
249: dbms_output.put('"' || aRecord.achieved_budget_usd || '",');
250: IF aRecord.record_type = RECORD_BUDGET THEN
251: dbms_output.put('"BUDGET",');
252: ELSIF aRecord.record_type = RECORD_SERVICE_LEVEL THEN
253: dbms_output.put('"SERVICE_LEVEL",');

Line 251: dbms_output.put('"BUDGET",');

247: dbms_output.put('"' || aRecord.bkt_end_date || '",');
248: dbms_output.put('"' || aRecord.period_nr || '",');
249: dbms_output.put('"' || aRecord.achieved_budget_usd || '",');
250: IF aRecord.record_type = RECORD_BUDGET THEN
251: dbms_output.put('"BUDGET",');
252: ELSIF aRecord.record_type = RECORD_SERVICE_LEVEL THEN
253: dbms_output.put('"SERVICE_LEVEL",');
254: ELSIF aRecord.record_type = RECORD_TARGET_SERVICE_LEVEL THEN
255: dbms_output.put('"TARGET_SL",');

Line 253: dbms_output.put('"SERVICE_LEVEL",');

249: dbms_output.put('"' || aRecord.achieved_budget_usd || '",');
250: IF aRecord.record_type = RECORD_BUDGET THEN
251: dbms_output.put('"BUDGET",');
252: ELSIF aRecord.record_type = RECORD_SERVICE_LEVEL THEN
253: dbms_output.put('"SERVICE_LEVEL",');
254: ELSIF aRecord.record_type = RECORD_TARGET_SERVICE_LEVEL THEN
255: dbms_output.put('"TARGET_SL",');
256: ELSE
257: dbms_output.put('"NULL",');

Line 255: dbms_output.put('"TARGET_SL",');

251: dbms_output.put('"BUDGET",');
252: ELSIF aRecord.record_type = RECORD_SERVICE_LEVEL THEN
253: dbms_output.put('"SERVICE_LEVEL",');
254: ELSIF aRecord.record_type = RECORD_TARGET_SERVICE_LEVEL THEN
255: dbms_output.put('"TARGET_SL",');
256: ELSE
257: dbms_output.put('"NULL",');
258: END IF;
259:

Line 257: dbms_output.put('"NULL",');

253: dbms_output.put('"SERVICE_LEVEL",');
254: ELSIF aRecord.record_type = RECORD_TARGET_SERVICE_LEVEL THEN
255: dbms_output.put('"TARGET_SL",');
256: ELSE
257: dbms_output.put('"NULL",');
258: END IF;
259:
260: dbms_output.put('"' || aRecord.required_quantity || '",');
261: dbms_output.put('"' || aRecord.delivered_quantity || '",');

Line 260: dbms_output.put('"' || aRecord.required_quantity || '",');

256: ELSE
257: dbms_output.put('"NULL",');
258: END IF;
259:
260: dbms_output.put('"' || aRecord.required_quantity || '",');
261: dbms_output.put('"' || aRecord.delivered_quantity || '",');
262: dbms_output.put('"' || aRecord.target_sl || '",');
263: dbms_output.put('"' || aRecord.num_target_sl || '",');
264: dbms_output.put('"' || aRecord.week_nr || '",');

Line 261: dbms_output.put('"' || aRecord.delivered_quantity || '",');

257: dbms_output.put('"NULL",');
258: END IF;
259:
260: dbms_output.put('"' || aRecord.required_quantity || '",');
261: dbms_output.put('"' || aRecord.delivered_quantity || '",');
262: dbms_output.put('"' || aRecord.target_sl || '",');
263: dbms_output.put('"' || aRecord.num_target_sl || '",');
264: dbms_output.put('"' || aRecord.week_nr || '",');
265: dbms_output.put_line('"' || aRecord.period_start_date || '"');

Line 262: dbms_output.put('"' || aRecord.target_sl || '",');

258: END IF;
259:
260: dbms_output.put('"' || aRecord.required_quantity || '",');
261: dbms_output.put('"' || aRecord.delivered_quantity || '",');
262: dbms_output.put('"' || aRecord.target_sl || '",');
263: dbms_output.put('"' || aRecord.num_target_sl || '",');
264: dbms_output.put('"' || aRecord.week_nr || '",');
265: dbms_output.put_line('"' || aRecord.period_start_date || '"');
266: END;

Line 263: dbms_output.put('"' || aRecord.num_target_sl || '",');

259:
260: dbms_output.put('"' || aRecord.required_quantity || '",');
261: dbms_output.put('"' || aRecord.delivered_quantity || '",');
262: dbms_output.put('"' || aRecord.target_sl || '",');
263: dbms_output.put('"' || aRecord.num_target_sl || '",');
264: dbms_output.put('"' || aRecord.week_nr || '",');
265: dbms_output.put_line('"' || aRecord.period_start_date || '"');
266: END;
267:

Line 264: dbms_output.put('"' || aRecord.week_nr || '",');

260: dbms_output.put('"' || aRecord.required_quantity || '",');
261: dbms_output.put('"' || aRecord.delivered_quantity || '",');
262: dbms_output.put('"' || aRecord.target_sl || '",');
263: dbms_output.put('"' || aRecord.num_target_sl || '",');
264: dbms_output.put('"' || aRecord.week_nr || '",');
265: dbms_output.put_line('"' || aRecord.period_start_date || '"');
266: END;
267:
268: PROCEDURE schedule_flush(mainschedule Schedule, query_id NUMBER)

Line 265: dbms_output.put_line('"' || aRecord.period_start_date || '"');

261: dbms_output.put('"' || aRecord.delivered_quantity || '",');
262: dbms_output.put('"' || aRecord.target_sl || '",');
263: dbms_output.put('"' || aRecord.num_target_sl || '",');
264: dbms_output.put('"' || aRecord.week_nr || '",');
265: dbms_output.put_line('"' || aRecord.period_start_date || '"');
266: END;
267:
268: PROCEDURE schedule_flush(mainschedule Schedule, query_id NUMBER)
269: IS