APPS.GMP_FORECAST_MIGRATION dependencies on MRP_FORECAST_ITEMS

Line 10: TYPE inventory_item_id IS TABLE OF mrp_forecast_items.inventory_item_id%TYPE

6: f_organization_id organization_id;
7: f_int_organization_id organization_id;
8: i_organization_id organization_id;
9:
10: TYPE inventory_item_id IS TABLE OF mrp_forecast_items.inventory_item_id%TYPE
11: INDEX BY BINARY_INTEGER;
12: f_inventory_item_id inventory_item_id ;
13: f_int_inventory_item_id inventory_item_id ;
14:

Line 580: -- Write the Forecast Items Details to MRP_FORECAST_ITEMS.

576: IF write_fcst_item AND fcst_dtl_tbl(lp_cnt).write_row_flag = 1 THEN
577:
578: fcst_itm_counter := fcst_itm_counter + 1;
579:
580: -- Write the Forecast Items Details to MRP_FORECAST_ITEMS.
581: /* Demands Bulk inserts */
582: fi_index := fi_index + 1 ;
583: f_organization_id(fi_index) := fcst_dtl_tbl(lp_cnt).organization_id ;
584: f_inventory_item_id(fi_index) := fcst_dtl_tbl(lp_cnt).inventory_item_id ;

Line 665: p_table_name => 'MRP_FORECAST_ITEMS',

661: GMA_COMMON_LOGGING.gma_migration_central_log (
662: p_run_id => P_migration_run_id,
663: p_log_level => FND_LOG.LEVEL_PROCEDURE,
664: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
665: p_table_name => 'MRP_FORECAST_ITEMS',
666: p_context => 'FORECAST',
667: p_app_short_name => 'GMP');
668:
669: FOR i IN f_organization_id.FIRST..fi_index

Line 671: INSERT INTO mrp_forecast_items (

667: p_app_short_name => 'GMP');
668:
669: FOR i IN f_organization_id.FIRST..fi_index
670: LOOP
671: INSERT INTO mrp_forecast_items (
672: organization_id,
673: inventory_item_id,
674: forecast_designator,
675: last_update_date, /* Confirm WHO Column values*/

Line 714: p_table_name => 'MRP_FORECAST_ITEMS',

710: GMA_COMMON_LOGGING.gma_migration_central_log (
711: p_run_id => P_migration_run_id,
712: p_log_level => FND_LOG.LEVEL_PROCEDURE,
713: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
714: p_table_name => 'MRP_FORECAST_ITEMS',
715: p_context => 'FORECAST',
716: p_app_short_name => 'GMP');
717:
718: END IF;