DBA Data[Home] [Help]

APPS.MSC_ATP_REFRESH_MVIEW dependencies on MSC_ATP_PARAMETERS

Line 109: from msc_atp_parameters

105: INTO l_item_hier_init_extent,l_item_hier_next_extent,l_item_hier_pct_inc,
106: l_item_hier_indx_init_extent,l_item_hier_indx_nxt_extent,l_item_hier_indx_pct_inc,
107: l_res_hier_init_extent,l_res_hier_next_extent,l_res_hier_pct_inc,l_res_hier_indx_init_extent,
108: l_res_hier_indx_nxt_extent,l_res_hier_indx_pct_inc
109: from msc_atp_parameters
110: WHERE rownum = 1;
111: EXCEPTION
112: WHEN no_data_found THEN
113: l_item_hier_init_extent := 40;

Line 156: from msc_atp_parameters

152: nvl(ITEM_HIER_INDX_NEXT_EXTENT,2),
153: nvl(ITEM_HIER_INDX_PCT_INCREASE,0)
154: INTO l_item_hier_init_extent,l_item_hier_next_extent,l_item_hier_pct_inc,
155: l_item_hier_indx_init_extent,l_item_hier_indx_nxt_extent,l_item_hier_indx_pct_inc
156: from msc_atp_parameters
157: WHERE rownum = 1;
158: EXCEPTION
159: WHEN NO_DATA_FOUND THEN
160: l_item_hier_init_extent := 40;