DBA Data[Home] [Help]

APPS.MSC_ATP_REFRESH_MVIEW dependencies on MSC_ATP_PARAMETERS

Line 116: from msc_atp_parameters

112: INTO l_item_hier_init_extent,l_item_hier_next_extent,l_item_hier_pct_inc,
113: l_item_hier_indx_init_extent,l_item_hier_indx_nxt_extent,l_item_hier_indx_pct_inc,
114: l_res_hier_init_extent,l_res_hier_next_extent,l_res_hier_pct_inc,l_res_hier_indx_init_extent,
115: l_res_hier_indx_nxt_extent,l_res_hier_indx_pct_inc
116: from msc_atp_parameters
117: WHERE rownum = 1;
118: EXCEPTION
119: WHEN no_data_found THEN
120: l_item_hier_init_extent := 40;

Line 163: from msc_atp_parameters

159: nvl(ITEM_HIER_INDX_NEXT_EXTENT,2),
160: nvl(ITEM_HIER_INDX_PCT_INCREASE,0)
161: INTO l_item_hier_init_extent,l_item_hier_next_extent,l_item_hier_pct_inc,
162: l_item_hier_indx_init_extent,l_item_hier_indx_nxt_extent,l_item_hier_indx_pct_inc
163: from msc_atp_parameters
164: WHERE rownum = 1;
165: EXCEPTION
166: WHEN NO_DATA_FOUND THEN
167: l_item_hier_init_extent := 40;