2: /* $Header: poadbinegs.pls 120.0 2005/09/30 11:33:15 sriswami noship $ */
3: --
4: PROCEDURE status_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL
5: ,x_custom_sql OUT NOCOPY VARCHAR2
6: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
7: --
8: PROCEDURE awd_status_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL
9: ,x_custom_sql OUT NOCOPY VARCHAR2
10: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
6: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
7: --
8: PROCEDURE awd_status_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL
9: ,x_custom_sql OUT NOCOPY VARCHAR2
10: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
11: --
12: PROCEDURE avg_cycle_time_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL
13: ,x_custom_sql OUT NOCOPY VARCHAR2
14: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
10: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
11: --
12: PROCEDURE avg_cycle_time_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL
13: ,x_custom_sql OUT NOCOPY VARCHAR2
14: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
15: --
16: PROCEDURE realized_status_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL
17: ,x_custom_sql OUT NOCOPY VARCHAR2
18: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
14: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
15: --
16: PROCEDURE realized_status_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL
17: ,x_custom_sql OUT NOCOPY VARCHAR2
18: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
19: --
20: PROCEDURE awd_trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL
21: ,x_custom_sql OUT NOCOPY VARCHAR2
22: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
18: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
19: --
20: PROCEDURE awd_trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL
21: ,x_custom_sql OUT NOCOPY VARCHAR2
22: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
23: --
24: PROCEDURE avg_cycle_trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL
25: ,x_custom_sql OUT NOCOPY VARCHAR2
26: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
22: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
23: --
24: PROCEDURE avg_cycle_trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL
25: ,x_custom_sql OUT NOCOPY VARCHAR2
26: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
27: --
28: PROCEDURE prj_svng_trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL
29: ,x_custom_sql OUT NOCOPY VARCHAR2
30: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
26: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
27: --
28: PROCEDURE prj_svng_trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL
29: ,x_custom_sql OUT NOCOPY VARCHAR2
30: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
31: --
32: PROCEDURE prj_svng_ln_trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL
33: ,x_custom_sql OUT NOCOPY VARCHAR2
34: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
30: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
31: --
32: PROCEDURE prj_svng_ln_trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL
33: ,x_custom_sql OUT NOCOPY VARCHAR2
34: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
35: --
36: PROCEDURE real_svng_trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL
37: ,x_custom_sql OUT NOCOPY VARCHAR2
38: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
34: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
35: --
36: PROCEDURE real_svng_trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL
37: ,x_custom_sql OUT NOCOPY VARCHAR2
38: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
39: --
40: PROCEDURE neg_po_trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL
41: ,x_custom_sql OUT NOCOPY VARCHAR2
42: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
38: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
39: --
40: PROCEDURE neg_po_trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL
41: ,x_custom_sql OUT NOCOPY VARCHAR2
42: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
43: --
44: PROCEDURE dtl_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL
45: ,x_custom_sql OUT NOCOPY VARCHAR2
46: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
42: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
43: --
44: PROCEDURE dtl_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL
45: ,x_custom_sql OUT NOCOPY VARCHAR2
46: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
47: --
48: FUNCTION get_dtl_filter(p_doctype_id IN VARCHAR2, show_rfi IN VARCHAR2) return VARCHAR2;
49: END poa_dbi_neg_pkg;