[Home] [Help]
PACKAGE: APPS.FII_SIZING_UTIL
Source
1 package FII_SIZING_UTIL AS
2 /* $Header: FIISZ01S.pls 120.1 2005/06/07 11:57:10 sgautam noship $ */
3
4 /* Count rows retrieved from the PA REVENUE fact source view */
5 PROCEDURE fii_pa_revenue_f_cnt (p_from_date DATE,
6 p_to_date DATE,
7 p_num_rows OUT NOCOPY /* file.sql.39 change */ NUMBER);
8
9 PROCEDURE fii_pa_revenue_f_len (p_from_date DATE,p_to_date DATE,p_avg_row_len OUT NOCOPY /* file.sql.39 change */ NUMBER);
10
11 /* Count rows retrieved from the PA COST fact source view */
12 PROCEDURE fii_pa_cost_f_cnt (p_from_date DATE,
13 p_to_date DATE,
14 p_num_rows OUT NOCOPY /* file.sql.39 change */ NUMBER);
15
16 PROCEDURE fii_pa_cost_f_len (p_from_date DATE,p_to_date DATE,p_avg_row_len OUT NOCOPY /* file.sql.39 change */ NUMBER);
17
18 /* Count rows retrieved from the PA BUDGET fact source view */
19 PROCEDURE fii_pa_budget_f_cnt (p_from_date DATE,
20 p_to_date DATE,
21 p_num_rows OUT NOCOPY /* file.sql.39 change */ NUMBER);
22
23 PROCEDURE fii_pa_budget_f_len (p_from_date DATE,p_to_date DATE,p_avg_row_len OUT NOCOPY /* file.sql.39 change */ NUMBER);
24
25 /* Count rows retrieved from the Project Budget dimension source view */
26 PROCEDURE fii_pa_budget_m_cnt (p_from_date DATE,
27 p_to_date DATE,
28 p_num_rows OUT NOCOPY /* file.sql.39 change */ NUMBER);
29
30 PROCEDURE fii_pa_budget_m_len (p_from_date DATE,p_to_date DATE,p_avg_row_len OUT NOCOPY /* file.sql.39 change */ NUMBER);
31
32 /* Count rows retrieved from the Project Expenditure Type dimension source view */
33 PROCEDURE fii_pa_exp_type_m_cnt (p_from_date DATE,
34 p_to_date DATE,
35 p_num_rows OUT NOCOPY /* file.sql.39 change */ NUMBER);
36
37 PROCEDURE fii_pa_exp_type_m_len (p_from_date DATE,p_to_date DATE,p_avg_row_len OUT NOCOPY /* file.sql.39 change */ NUMBER);
38
39 /* Count rows retrieved from the Project dimension source view */
40 PROCEDURE edw_project_m_cnt (p_from_date DATE,
41 p_to_date DATE,
42 p_num_rows OUT NOCOPY /* file.sql.39 change */ NUMBER);
43
44 PROCEDURE edw_project_m_len (p_from_date DATE,p_to_date DATE,p_avg_row_len OUT NOCOPY /* file.sql.39 change */ NUMBER);
45
46 /* Estimate average row length and number of rows for FII_AP_INV_ON_HOLD_F */
47 PROCEDURE FII_AP_INV_ON_HOLD_F_CNT (p_from_date DATE,
48 p_to_date DATE,
49 p_num_rows OUT NOCOPY /* file.sql.39 change */ NUMBER);
50
51 PROCEDURE FII_AP_INV_ON_HOLD_F_LEN (p_from_date DATE,p_to_date DATE,p_avg_row_len OUT NOCOPY /* file.sql.39 change */ NUMBER);
52
53 /* Estimate average row length and number of rows for FII_AR_TRX_DIST_F */
54 PROCEDURE FII_AR_TRX_DIST_F_CNT (p_from_date DATE,
55 p_to_date DATE,
56 p_num_rows OUT NOCOPY /* file.sql.39 change */ NUMBER);
57
58 PROCEDURE FII_AR_TRX_DIST_F_LEN (p_from_date DATE,p_to_date DATE,p_avg_row_len OUT NOCOPY /* file.sql.39 change */ NUMBER);
59
60 /* Estimate average row length and number of rows for FII_E_REVENUE_F */
61 PROCEDURE FII_E_REVENUE_F_CNT (p_from_date DATE,
62 p_to_date DATE,
63 p_num_rows OUT NOCOPY /* file.sql.39 change */ NUMBER);
64
65 PROCEDURE FII_E_REVENUE_F_LEN (p_from_date DATE,p_to_date DATE,p_avg_row_len OUT NOCOPY /* file.sql.39 change */ NUMBER);
66
67 /* Estimate average row length and number of rows for EDW_AR_DOC_NUM_M */
68 PROCEDURE EDW_AR_DOC_NUM_M_CNT (p_from_date DATE,
69 p_to_date DATE,
70 p_num_rows OUT NOCOPY /* file.sql.39 change */ NUMBER);
71
72 PROCEDURE EDW_AR_DOC_NUM_M_LEN (p_from_date DATE,p_to_date DATE,p_avg_row_len OUT NOCOPY /* file.sql.39 change */ NUMBER);
73
74 /* Estimate average row length and number of rows for EDW_TIME_M */
75 PROCEDURE EDW_TIME_M_CNT (p_from_date DATE,
76 p_to_date DATE,
77 p_num_rows OUT NOCOPY /* file.sql.39 change */ NUMBER);
78
79 PROCEDURE EDW_TIME_M_LEN (p_from_date DATE,p_to_date DATE,p_avg_row_len OUT NOCOPY /* file.sql.39 change */ NUMBER);
80
81 /* Estimate average row length and number of rows for FII_AP_INV_LINES_F */
82 PROCEDURE FII_AP_INV_LINES_F_CNT (p_from_date DATE,
83 p_to_date DATE,
84 p_num_rows OUT NOCOPY /* file.sql.39 change */ NUMBER);
85
86 PROCEDURE FII_AP_INV_LINES_F_LEN (p_from_date DATE,p_to_date DATE,p_avg_row_len OUT NOCOPY /* file.sql.39 change */ NUMBER);
87
88 /* Estimate average row length and number of rows for FII_AP_SCH_PAYMTS_F */
89 PROCEDURE FII_AP_SCH_PAYMTS_F_CNT (p_from_date DATE,
90 p_to_date DATE,
91 p_num_rows OUT NOCOPY /* file.sql.39 change */ NUMBER);
92
93 PROCEDURE FII_AP_SCH_PAYMTS_F_LEN (p_from_date DATE,p_to_date DATE,p_avg_row_len OUT NOCOPY /* file.sql.39 change */ NUMBER);
94
95 /* Estimate average row length and number of rows for FII_AP_INV_PAYMTS_F */
96 PROCEDURE FII_AP_INV_PAYMTS_F_CNT (p_from_date DATE,
97 p_to_date DATE,
98 p_num_rows OUT NOCOPY /* file.sql.39 change */ NUMBER);
99
100 PROCEDURE FII_AP_INV_PAYMTS_F_LEN (p_from_date DATE,p_to_date DATE,p_avg_row_len OUT NOCOPY /* file.sql.39 change */ NUMBER);
101
102 /* Estimate average row length and number of rows for FII_AP_HOLD_DATA_F */
103 PROCEDURE FII_AP_HOLD_DATA_F_CNT (p_from_date DATE,
104 p_to_date DATE,
105 p_num_rows OUT NOCOPY /* file.sql.39 change */ NUMBER);
106
107 PROCEDURE FII_AP_HOLD_DATA_F_LEN (p_from_date DATE,p_to_date DATE,p_avg_row_len OUT NOCOPY /* file.sql.39 change */ NUMBER);
108
109 /* Estimate average row length and number of rows for EDW_AP_PAYMENT_M */
110 PROCEDURE EDW_AP_PAYMENT_M_CNT (p_from_date DATE,
111 p_to_date DATE,
112 p_num_rows OUT NOCOPY /* file.sql.39 change */ NUMBER);
113
114 PROCEDURE EDW_AP_PAYMENT_M_LEN (p_from_date DATE,p_to_date DATE,p_avg_row_len OUT NOCOPY /* file.sql.39 change */ NUMBER);
115
116 /* Estimate average row length and number of rows for EDW_INV_TYPE_M */
117 PROCEDURE EDW_INV_TYPE_M_CNT (p_from_date DATE,
118 p_to_date DATE,
119 p_num_rows OUT NOCOPY /* file.sql.39 change */ NUMBER);
120
121 PROCEDURE EDW_INV_TYPE_M_LEN (p_from_date DATE,p_to_date DATE,p_avg_row_len OUT NOCOPY /* file.sql.39 change */ NUMBER);
122
123 END;