APPS.INV_CG_UPGRADE dependencies on MTL_PERIOD_SUMMARY

Line 314: type period_summary_tbl is table of mtl_period_summary%rowtype

310: declare
311:
312: */
313:
314: type period_summary_tbl is table of mtl_period_summary%rowtype
315: index by binary_integer;
316:
317: /*
318: ** --------------------------------------------------------

Line 329: from mtl_period_summary

325: acct_period_id
326: , inventory_type
327: , cost_group_id
328: , sum(inventory_value) inventory_value
329: from mtl_period_summary
330: where organization_id = l_organization_id
331: group by
332: acct_period_id
333: , organization_id

Line 361: from mtl_period_summary

357: is
358: select
359: rowid
360: , secondary_inventory
361: from mtl_period_summary
362: where
363: (
364: cost_group_id is null AND
365: organization_id = l_organization_id

Line 400: l_table_name := 'mtl_period_summary';

396: l_details_updated boolean := FALSE;
397: begin
398: -- Stamp cost group
399:
400: l_table_name := 'mtl_period_summary';
401: for c1 in mps_cursor
402: loop
403: /*
404: ** Load cursor output into local variables

Line 424: update mtl_period_summary

420: l_cost_group_id := l_org_cost_group_id ;
421: end if;
422:
423: if (l_cost_group_id > 0) then
424: update mtl_period_summary
425: set cost_group_id = l_cost_group_id
426: where rowid = l_rowid;
427: if ( l_details_updated = FALSE ) then
428: update mtl_per_close_dtls

Line 447: update mtl_period_summary

443: , p_organization_id => l_organization_id
444: , p_subinventory => l_secondary_inventory);
445:
446: if (l_cost_group_id > 0) then
447: update mtl_period_summary
448: set cost_group_id = l_cost_group_id
449: where rowid = l_rowid;
450: end if;
451: else

Line 464: update mtl_period_summary

460: l_cost_group_id := l_org_cost_group_id ;
461: end if;
462:
463: if (l_cost_group_id > 0) then
464: update mtl_period_summary
465: set cost_group_id = l_cost_group_id
466: where rowid = l_rowid;
467: end if;
468: end if;

Line 474: l_table_name := 'mtl_period_summary';

470: end loop;
471:
472: l_counter := 0;
473:
474: l_table_name := 'mtl_period_summary';
475: if ( p_cost_method = 1 ) then
476:
477: for c2 in group_cursor
478: loop

Line 492: delete mtl_period_summary WHERE organization_id = l_organization_id;

488:
489: /*
490: ** Delete data. It will be reloaded from memory in just a second
491: */
492: delete mtl_period_summary WHERE organization_id = l_organization_id;
493:
494: select sysdate into l_date from dual;
495:
496: l_user_id := fnd_global.user_id;

Line 516: insert into mtl_period_summary(

512: /*
513: ** Reload grouped data from memory
514: */
515:
516: insert into mtl_period_summary(
517: ACCT_PERIOD_ID
518: , ORGANIZATION_ID
519: , INVENTORY_TYPE
520: , SECONDARY_INVENTORY

Line 566: delete mtl_period_summary WHERE organization_id = l_organization_id;

562: l_ps_tbl(l_counter).inventory_type := c2.inventory_type;
563: l_ps_tbl(l_counter).cost_group_id := c2.cost_group_id;
564: l_ps_tbl(l_counter).inventory_value := c2.inventory_value;
565: end loop;
566: delete mtl_period_summary WHERE organization_id = l_organization_id;
567: select sysdate into l_date from dual;
568:
569: l_user_id := fnd_global.user_id;
570: l_login_id := fnd_global.login_id;

Line 589: insert into mtl_period_summary(

585: /*
586: ** Reload grouped data from memory
587: */
588:
589: insert into mtl_period_summary(
590: ACCT_PERIOD_ID
591: , ORGANIZATION_ID
592: , INVENTORY_TYPE
593: , SECONDARY_INVENTORY

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

641: );
642:
643: l_msg_data := replace(l_msg_data,chr(0),' ');
644:
645: l_return_err := 'mtl_period_summary cost group upgrade:'||l_msg_data;
646:
647: INS_ERROR( p_table_name => l_table_name,
648: p_ROWID => l_rowid_info,
649: p_org_id => l_organization_id,

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

668: );
669:
670: l_msg_data := replace(l_msg_data,chr(0),' ');
671:
672: l_return_err := 'mtl_period_summary cost group upgrade:'||l_msg_data;
673:
674: INS_ERROR( p_table_name => l_table_name,
675: p_ROWID => l_rowid_info,
676: p_org_id => l_organization_id,

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

697: p_org_id => l_organization_id,
698: p_error_msg => l_msg_data,
699: p_proc_name => l_procedure_name);
700:
701: l_return_err := 'mtl_period_summary cost group upgrade:'||
702: substrb(sqlerrm,1,55);
703: raise_application_error(-20000,l_return_err);
704:
705: end INVMPSSB;