APPS.MSD_DEM_UPLOAD_FORECAST dependencies on MSD_DP_PLANNING_PCT_TMP

Line 2478: FROM MSD_DP_PLANNING_PCT_TMP ORDER BY SERIAL;

2474: var_msd_schema_name varchar2(50);
2475:
2476: CURSOR EXP_VIEW IS
2477: SELECT ITEM, ORGANIZATION, PARENT_ITEM, TOP_ATO_MODEL,DATE_FROM, DATE_TO, PLANNING_FACTOR
2478: FROM MSD_DP_PLANNING_PCT_TMP ORDER BY SERIAL;
2479:
2480: TYPE PLN_FACTOR_RECORD
2481: IS RECORD (ITEM VARCHAR2(240), ORGANIZATION VARCHAR2(240), PARENT_ITEM VARCHAR2(240), TOP_ATO_MODEL NUMBER,
2482: DATE_FROM DATE, DATE_TO DATE, PLANNING_FACTOR NUMBER );

Line 2710: x_small_sql := 'TRUNCATE table ' || var_msd_schema_name ||'.MSD_DP_PLANNING_PCT_TMP';

2706: END IF;
2707:
2708: --truncate temp table
2709: var_boolean := fnd_installation.get_app_info ('MSD', var_dummy1, var_dummy2, var_msd_schema_name);
2710: x_small_sql := 'TRUNCATE table ' || var_msd_schema_name ||'.MSD_DP_PLANNING_PCT_TMP';
2711: EXECUTE IMMEDIATE x_small_sql;
2712:
2713: /* Get Time Info - BEGIN */
2714:

Line 2849: x_insert_clause := 'INSERT into MSD_DP_PLANNING_PCT_TMP' ||

2845: ELSE
2846: x_pctg_column := ' ( decode ( ' || p_parent_item_series_iname || ', null, ' || x_pctg_series_iname || ', 0, '|| x_pctg_series_iname || ', ('|| p_option_item_series_iname || '/' || p_parent_item_series_iname|| ' ) ) ) ';
2847: END IF;
2848:
2849: x_insert_clause := 'INSERT into MSD_DP_PLANNING_PCT_TMP' ||
2850: ' (SERIAL, ITEM, ORGANIZATION, PARENT_ITEM,TOP_ATO_MODEL,DATE_FROM, DATE_TO, PLANNING_FACTOR) ';
2851: x_select_clause := ' SELECT ROWNUM, ITEM, ORGANIZATION, PARENT_ITEM, TOP_ATO_MODEL,DATE_FROM, DATE_TO, PLN_PCT ' ||
2852: ' FROM ( SELECT ' || x_prd_level || ' AS ITEM, ' ||
2853: case when x_is_global_fcst = 1 then '''-1''' else x_org_level end || ' AS ORGANIZATION, ' ||