1 PACKAGE EDW_OPI_LOT_MOPM_SZ AS
2 /* $Header: OPIPLTZS.pls 120.1 2005/06/07 03:57:56 appldev $*/
3
4 -- procedure to count Lot Dimension rows.
5
6 PROCEDURE cnt_rows (p_from_date IN DATE,
7 p_to_date IN DATE,
8 p_num_rows OUT NOCOPY NUMBER);
9
10 -- procedure to get average row length Lot Dimension rows.
11
12 PROCEDURE est_row_len (p_from_date IN DATE,
13 p_to_date IN DATE,
14 p_avg_row_len OUT NOCOPY NUMBER);
15 END EDW_OPI_LOT_MOPM_SZ;
16