DBA Data[Home] [Help]

APPS.JTY_TAE_INDEX_CREATION_PVT dependencies on STANDARD

Line 118: * std_dev : array of standard deviation

114: * numcol : number of name
115: * output
116: * v_colname : array of sorted column name by selectivity
117: * o_sel : array of odinal selectivity
118: * std_dev : array of standard deviation
119: */
120: PROCEDURE CAL_SELECTIVITY( p_table_name IN varchar2,
121: v_colname IN OUT NOCOPY name_varray,
122: o_sel IN OUT NOCOPY value_varray,

Line 265: JTY_DEA_ATTR_FACTORS.INPUT_DEVIATION is populated with standard deviation

261: * Parameters :
262: * input JTY_DEA_ATTR_FACTORS.SQUAL_ALIAS
263: * outout JTY_DEA_ATTR_FACTORS.INPUT_SELECTIVITY is populated with selectivity order
264: JTY_DEA_ATTR_FACTORS.INPUT_ORDINAL_SELECTIVITY is populated with ordinal_selectivity
265: JTY_DEA_ATTR_FACTORS.INPUT_DEVIATION is populated with standard deviation
266: */
267:
268: PROCEDURE DEA_SELECTIVITY(p_TABLE_NAME IN VARCHAR2,
269: x_return_status OUT NOCOPY VARCHAR2)

Line 431: JTF_TAE_QUAL_FACTORS.INPUT_DEVIATION is populated with standard deviation

427: * Parameters :
428: * input JTF_TAE_QUAL_FACTORS.SQUAL_ALIAS
429: * outout JTF_TAE_QUAL_FACTORS.INPUT_SELECTIVITY is populated with selectivity order
430: JTF_TAE_QUAL_FACTORS.INPUT_ORDINAL_SELECTIVITY is populated with ordinal_selectivity
431: JTF_TAE_QUAL_FACTORS.INPUT_DEVIATION is populated with standard deviation
432: */
433:
434: PROCEDURE SELECTIVITY(p_TABLE_NAME IN VARCHAR2,
435: p_mode IN VARCHAR2,