DBA Data[Home] [Help]

APPS.MSC_BUDGET_DETAILS dependencies on DBMS_OUTPUT

Line 159: dbms_output.put_line('date is ' || l_detail_date);

155: fetch get_mbid_date_c into l_detail_date;
156: close get_mbid_date_c;
157:
158:
159: dbms_output.put_line('date is ' || l_detail_date);
160: if p_violation_level = plan_level then
161: dbms_output.put_line('level is ' || p_violation_level || ' plan_level ');
162: open bis_inv_details_plan_c(p_tot_inv,
163: l_detail_date,

Line 161: dbms_output.put_line('level is ' || p_violation_level || ' plan_level ');

157:
158:
159: dbms_output.put_line('date is ' || l_detail_date);
160: if p_violation_level = plan_level then
161: dbms_output.put_line('level is ' || p_violation_level || ' plan_level ');
162: open bis_inv_details_plan_c(p_tot_inv,
163: l_detail_date,
164: l_bucket_type);
165: elsif p_violation_level = org_level then

Line 200: dbms_output.put_line('item is ' || l_inv_item ||

196: l_inv_value,
197: l_percent_inv_value;
198: exit when bis_inv_details_cat_c%notfound;
199: end if;
200: dbms_output.put_line('item is ' || l_inv_item ||
201: ' inv val ' || l_inv_value ||
202: ' percetn inv valu ' || l_percent_inv_value);
203: -- get item name
204: l_item_name := substr(msc_get_name.item_name(l_inv_item, null, null, null),1,10);