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 590: -- Write Forecast Dates and Qty Details to Interface Table MRP_FORECAST_INTERFACE.

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

Line 727: p_table_name => 'MRP_FORECAST_INTERFACE',

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

Line 733: INSERT INTO mrp_forecast_interface (

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

Line 775: p_table_name => 'MRP_FORECAST_INTERFACE',

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