APPS.GMP_FORECAST_MIGRATION dependencies on MRP_FORECAST_INTERFACE

Line 41: TYPE quantity IS TABLE OF mrp_forecast_interface.quantity%TYPE

37: TYPE forward_update_time_fence IS TABLE OF mrp_forecast_designators.foreward_update_time_fence%TYPE
38: INDEX BY BINARY_INTEGER;
39: i_forward_update_time_fence forward_update_time_fence ;
40:
41: TYPE quantity IS TABLE OF mrp_forecast_interface.quantity%TYPE
42: INDEX BY BINARY_INTEGER;
43: f_int_quantity quantity ;
44:
45: TYPE forecast_date IS TABLE OF mrp_forecast_interface.forecast_date%TYPE

Line 45: TYPE forecast_date IS TABLE OF mrp_forecast_interface.forecast_date%TYPE

41: TYPE quantity IS TABLE OF mrp_forecast_interface.quantity%TYPE
42: INDEX BY BINARY_INTEGER;
43: f_int_quantity quantity ;
44:
45: TYPE forecast_date IS TABLE OF mrp_forecast_interface.forecast_date%TYPE
46: INDEX BY BINARY_INTEGER;
47: f_int_forecast_date forecast_date ;
48:
49: TYPE fcst_hdr_rec IS RECORD (

Line 592: -- Write Forecast Dates and Qty Details to Interface Table MRP_FORECAST_INTERFACE.

588:
589: IF fcst_dtl_tbl(lp_cnt).write_row_flag = 1 THEN
590: fcst_itrf_counter := fcst_itrf_counter + 1;
591:
592: -- Write Forecast Dates and Qty Details to Interface Table MRP_FORECAST_INTERFACE.
593: f_int_index := f_int_index + 1 ;
594: f_int_organization_id(f_int_index) := fcst_dtl_tbl(lp_cnt).organization_id ;
595: f_int_inventory_item_id(f_int_index) := fcst_dtl_tbl(lp_cnt).inventory_item_id ;
596: f_int_forecast_date(f_int_index) := fcst_dtl_tbl(lp_cnt).trans_date ;

Line 729: p_table_name => 'MRP_FORECAST_INTERFACE',

725: GMA_COMMON_LOGGING.gma_migration_central_log (
726: p_run_id => P_migration_run_id,
727: p_log_level => FND_LOG.LEVEL_PROCEDURE,
728: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
729: p_table_name => 'MRP_FORECAST_INTERFACE',
730: p_context => 'FORECAST',
731: p_app_short_name => 'GMP');
732:
733: FOR i IN f_int_organization_id.FIRST..f_int_index

Line 735: INSERT INTO mrp_forecast_interface (

731: p_app_short_name => 'GMP');
732:
733: FOR i IN f_int_organization_id.FIRST..f_int_index
734: LOOP
735: INSERT INTO mrp_forecast_interface (
736: organization_id,
737: inventory_item_id,
738: forecast_date,
739: quantity,

Line 777: p_table_name => 'MRP_FORECAST_INTERFACE',

773: GMA_COMMON_LOGGING.gma_migration_central_log (
774: p_run_id => P_migration_run_id,
775: p_log_level => FND_LOG.LEVEL_PROCEDURE,
776: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
777: p_table_name => 'MRP_FORECAST_INTERFACE',
778: p_context => 'FORECAST',
779: p_app_short_name => 'GMP');
780: END IF;
781: