eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMP_FORECAST_MIGRATION dependencies on MRP_FORECAST_DESIGNATORS

Line 4: TYPE organization_id IS TABLE OF mrp_forecast_designators.organization_id%TYPE

1: PACKAGE BODY GMP_forecast_migration AS
2: /* $Header: GMPFCMIB.pls 120.6 2011/05/06 12:57:34 vkinduri ship $ */
3:
4: TYPE organization_id IS TABLE OF mrp_forecast_designators.organization_id%TYPE
5: INDEX BY BINARY_INTEGER;
6: f_organization_id organization_id;
7: f_int_organization_id organization_id;
8: i_organization_id organization_id;

Line 15: TYPE forecast_designator IS TABLE OF mrp_forecast_designators.forecast_designator%TYPE INDEX BY BINARY_INTEGER;

11: INDEX BY BINARY_INTEGER;
12: f_inventory_item_id inventory_item_id ;
13: f_int_inventory_item_id inventory_item_id ;
14:
15: TYPE forecast_designator IS TABLE OF mrp_forecast_designators.forecast_designator%TYPE INDEX BY BINARY_INTEGER;
16: i_designator forecast_designator ;
17: f_forecast_designator forecast_designator ;
18: f_int_forecast_designator forecast_designator ;
19:

Line 20: TYPE forecast_set IS TABLE OF mrp_forecast_designators.forecast_set%TYPE INDEX BY BINARY_INTEGER;

16: i_designator forecast_designator ;
17: f_forecast_designator forecast_designator ;
18: f_int_forecast_designator forecast_designator ;
19:
20: TYPE forecast_set IS TABLE OF mrp_forecast_designators.forecast_set%TYPE INDEX BY BINARY_INTEGER;
21: i_forecast_set forecast_set;
22:
23: TYPE description IS TABLE OF mrp_forecast_designators.description%TYPE INDEX BY BINARY_INTEGER;
24: i_description description ;

Line 23: TYPE description IS TABLE OF mrp_forecast_designators.description%TYPE INDEX BY BINARY_INTEGER;

19:
20: TYPE forecast_set IS TABLE OF mrp_forecast_designators.forecast_set%TYPE INDEX BY BINARY_INTEGER;
21: i_forecast_set forecast_set;
22:
23: TYPE description IS TABLE OF mrp_forecast_designators.description%TYPE INDEX BY BINARY_INTEGER;
24: i_description description ;
25:
26: TYPE disable_date IS TABLE OF mrp_forecast_designators.disable_date%TYPE INDEX BY BINARY_INTEGER;
27: i_disable_date disable_date ;

Line 26: TYPE disable_date IS TABLE OF mrp_forecast_designators.disable_date%TYPE INDEX BY BINARY_INTEGER;

22:
23: TYPE description IS TABLE OF mrp_forecast_designators.description%TYPE INDEX BY BINARY_INTEGER;
24: i_description description ;
25:
26: TYPE disable_date IS TABLE OF mrp_forecast_designators.disable_date%TYPE INDEX BY BINARY_INTEGER;
27: i_disable_date disable_date ;
28:
29: TYPE tconsume_forecast IS TABLE OF mrp_forecast_designators.consume_forecast%TYPE
30: INDEX BY BINARY_INTEGER;

Line 29: TYPE tconsume_forecast IS TABLE OF mrp_forecast_designators.consume_forecast%TYPE

25:
26: TYPE disable_date IS TABLE OF mrp_forecast_designators.disable_date%TYPE INDEX BY BINARY_INTEGER;
27: i_disable_date disable_date ;
28:
29: TYPE tconsume_forecast IS TABLE OF mrp_forecast_designators.consume_forecast%TYPE
30: INDEX BY BINARY_INTEGER;
31: i_consume_forecast tconsume_forecast ;
32:
33: TYPE backward_update_time_fence IS TABLE OF mrp_forecast_designators.backward_update_time_fence%TYPE

Line 33: TYPE backward_update_time_fence IS TABLE OF mrp_forecast_designators.backward_update_time_fence%TYPE

29: TYPE tconsume_forecast IS TABLE OF mrp_forecast_designators.consume_forecast%TYPE
30: INDEX BY BINARY_INTEGER;
31: i_consume_forecast tconsume_forecast ;
32:
33: TYPE backward_update_time_fence IS TABLE OF mrp_forecast_designators.backward_update_time_fence%TYPE
34: INDEX BY BINARY_INTEGER;
35: i_backward_update_time_fence backward_update_time_fence ;
36:
37: TYPE forward_update_time_fence IS TABLE OF mrp_forecast_designators.foreward_update_time_fence%TYPE

Line 37: TYPE forward_update_time_fence IS TABLE OF mrp_forecast_designators.foreward_update_time_fence%TYPE

33: TYPE backward_update_time_fence IS TABLE OF mrp_forecast_designators.backward_update_time_fence%TYPE
34: INDEX BY BINARY_INTEGER;
35: i_backward_update_time_fence backward_update_time_fence ;
36:
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

Line 388: ' FROM mrp_forecast_designators '||

384:
385: -- BEGIN
386:
387: l_validation_stmt := ' SELECT forecast_designator, forecast_set '||
388: ' FROM mrp_forecast_designators '||
389: ' WHERE (forecast_designator = '|| '''' || fcst_hdr_tbl(fcst_locn).fcst_set || '''' ||
390: ' OR forecast_designator = '|| '''' || fcst_hdr_tbl(fcst_locn).fcst_name|| '''' || ' ) '||
391: ' AND organization_id = '||fcst_dtl_tbl(lp_cnt).organization_id ;
392:

Line 544: -- Write the Forecast Set Details to MRP_FORECAST_DESIGNATORS.

540: prev_fcst_item := fcst_dtl_tbl(lp_cnt).inventory_item_id;
541:
542: IF write_fcst_set AND fcst_dtl_tbl(lp_cnt).write_row_flag = 1 THEN
543:
544: -- Write the Forecast Set Details to MRP_FORECAST_DESIGNATORS.
545: i_index := i_index + 1 ;
546: i_designator(i_index) := fcst_hdr_tbl(fcst_locn).fcst_set ;
547: i_forecast_set(i_index) := to_char(NULL) ;
548: i_organization_id(i_index) := fcst_dtl_tbl(lp_cnt).organization_id ;

Line 562: -- Write the Forecast Details to MRP_FORECAST_DESIGNATORS.

558: END IF ;
559:
560: IF write_fcst AND fcst_dtl_tbl(lp_cnt).write_row_flag = 1 THEN
561:
562: -- Write the Forecast Details to MRP_FORECAST_DESIGNATORS.
563: i_index := i_index + 1 ;
564: i_designator(i_index) := fcst_hdr_tbl(fcst_locn).fcst_name ;
565: i_forecast_set(i_index) := fcst_hdr_tbl(fcst_locn).fcst_set ;
566: i_organization_id(i_index) := fcst_dtl_tbl(lp_cnt).organization_id ;

Line 614: p_table_name => 'MRP_FORECAST_DESIGNATORS',

610: GMA_COMMON_LOGGING.gma_migration_central_log (
611: p_run_id => P_migration_run_id,
612: p_log_level => FND_LOG.LEVEL_PROCEDURE,
613: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
614: p_table_name => 'MRP_FORECAST_DESIGNATORS',
615: p_context => 'FORECAST',
616: p_app_short_name => 'GMP');
617:
618: FOR i IN i_organization_id.FIRST..i_index

Line 620: INSERT INTO mrp_forecast_designators (

616: p_app_short_name => 'GMP');
617:
618: FOR i IN i_organization_id.FIRST..i_index
619: LOOP
620: INSERT INTO mrp_forecast_designators (
621: forecast_designator,
622: forecast_set,
623: organization_id,
624: description,

Line 702: p_table_name => 'MRP_FORECAST_DESIGNATORS',

698: GMA_COMMON_LOGGING.gma_migration_central_log (
699: p_run_id => P_migration_run_id,
700: p_log_level => FND_LOG.LEVEL_PROCEDURE,
701: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
702: p_table_name => 'MRP_FORECAST_DESIGNATORS',
703: p_context => 'FORECAST',
704: p_app_short_name => 'GMP');
705:
706: END IF;