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 578: -- Write the Forecast Items Details to MRP_FORECAST_ITEMS.

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

Line 663: p_table_name => 'MRP_FORECAST_ITEMS',

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

Line 669: INSERT INTO mrp_forecast_items (

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

Line 712: p_table_name => 'MRP_FORECAST_ITEMS',

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