APPS.CONVERT_TEST dependencies on MTL_PERIOD_SUMMARY

Line 257: type period_summary_tbl is table of mtl_period_summary%rowtype

253: declare
254:
255: */
256:
257: type period_summary_tbl is table of mtl_period_summary%rowtype
258: index by binary_integer;
259:
260: /*
261: ** --------------------------------------------------------

Line 272: from mtl_period_summary

268: acct_period_id
269: , inventory_type
270: , cost_group_id
271: , sum(inventory_value) inventory_value
272: from mtl_period_summary
273: where organization_id = l_organization_id
274: group by
275: acct_period_id
276: , organization_id

Line 290: from mtl_period_summary

286: is
287: select
288: rowid
289: , secondary_inventory
290: from mtl_period_summary
291: where
292: (
293: cost_group_id is null AND
294: organization_id = l_organization_id

Line 329: l_table_name := 'mtl_period_summary';

325:
326: begin
327: -- Stamp cost group
328:
329: l_table_name := 'mtl_period_summary';
330: for c1 in mps_cursor
331: loop
332: /*
333: ** Load cursor output into local variables

Line 350: update mtl_period_summary

346: , p_organization_id => l_organization_id
347: , p_subinventory => l_secondary_inventory);
348:
349: if (l_cost_group_id > 0) then
350: update mtl_period_summary
351: set cost_group_id = l_cost_group_id
352: where rowid = l_rowid;
353: end if;
354: else

Line 362: update mtl_period_summary

358: , x_msg_data => l_msg_data
359: , p_organization_id => l_organization_id);
360:
361: if (l_cost_group_id > 0) then
362: update mtl_period_summary
363: set cost_group_id = l_cost_group_id
364: where rowid = l_rowid;
365: end if;
366: end if;

Line 371: l_table_name := 'mtl_period_summary';

367: end loop;
368:
369: l_counter := 0;
370:
371: l_table_name := 'mtl_period_summary';
372:
373: for c2 in group_cursor
374: loop
375: l_counter := l_counter + 1;

Line 388: delete mtl_period_summary WHERE organization_id = l_organization_id;

384:
385: /*
386: ** Delete data. It will be reloaded from memory in just a second
387: */
388: delete mtl_period_summary WHERE organization_id = l_organization_id;
389:
390: select sysdate into l_date from dual;
391:
392: l_user_id := fnd_global.user_id;

Line 412: insert into mtl_period_summary(

408: /*
409: ** Reload grouped data from memory
410: */
411:
412: insert into mtl_period_summary(
413: ACCT_PERIOD_ID
414: , ORGANIZATION_ID
415: , INVENTORY_TYPE
416: , SECONDARY_INVENTORY

Line 465: l_return_err := 'mtl_period_summary cost group upgrade:'||l_msg_data;

461: );
462:
463: l_msg_data := replace(l_msg_data,chr(0),' ');
464:
465: l_return_err := 'mtl_period_summary cost group upgrade:'||l_msg_data;
466:
467: INS_ERROR( p_table_name => l_table_name,
468: p_ROWID => l_rowid_info,
469: p_org_id => l_organization_id,

Line 492: l_return_err := 'mtl_period_summary cost group upgrade:'||l_msg_data;

488: );
489:
490: l_msg_data := replace(l_msg_data,chr(0),' ');
491:
492: l_return_err := 'mtl_period_summary cost group upgrade:'||l_msg_data;
493:
494: INS_ERROR( p_table_name => l_table_name,
495: p_ROWID => l_rowid_info,
496: p_org_id => l_organization_id,

Line 521: l_return_err := 'mtl_period_summary cost group upgrade:'||

517: p_org_id => l_organization_id,
518: p_error_msg => l_msg_data,
519: p_proc_name => l_procedure_name);
520:
521: l_return_err := 'mtl_period_summary cost group upgrade:'||
522: substrb(sqlerrm,1,55);
523: raise_application_error(-20000,l_return_err);
524:
525: end INVMPSSB;