DBA Data[Home] [Help]

APPS.JTY_TAE_INDEX_CREATION_PVT dependencies on STANDARD

Line 124: * std_dev : array of standard deviation

120: * numcol : number of name
121: * output
122: * v_colname : array of sorted column name by selectivity
123: * o_sel : array of odinal selectivity
124: * std_dev : array of standard deviation
125: */
126: PROCEDURE CAL_SELECTIVITY( p_table_name IN varchar2,
127: v_colname IN OUT NOCOPY name_varray,
128: o_sel IN OUT NOCOPY value_varray,

Line 254: JTY_DEA_ATTR_FACTORS.INPUT_DEVIATION is populated with standard deviation

250: * Parameters :
251: * input JTY_DEA_ATTR_FACTORS.SQUAL_ALIAS
252: * outout JTY_DEA_ATTR_FACTORS.INPUT_SELECTIVITY is populated with selectivity order
253: JTY_DEA_ATTR_FACTORS.INPUT_ORDINAL_SELECTIVITY is populated with ordinal_selectivity
254: JTY_DEA_ATTR_FACTORS.INPUT_DEVIATION is populated with standard deviation
255: */
256:
257: PROCEDURE DEA_SELECTIVITY(p_TABLE_NAME IN VARCHAR2,
258: x_return_status OUT NOCOPY VARCHAR2)

Line 408: JTF_TAE_QUAL_FACTORS.INPUT_DEVIATION is populated with standard deviation

404: * Parameters :
405: * input JTF_TAE_QUAL_FACTORS.SQUAL_ALIAS
406: * outout JTF_TAE_QUAL_FACTORS.INPUT_SELECTIVITY is populated with selectivity order
407: JTF_TAE_QUAL_FACTORS.INPUT_ORDINAL_SELECTIVITY is populated with ordinal_selectivity
408: JTF_TAE_QUAL_FACTORS.INPUT_DEVIATION is populated with standard deviation
409: */
410:
411: PROCEDURE SELECTIVITY(p_TABLE_NAME IN VARCHAR2,
412: p_mode IN VARCHAR2,