1 PACKAGE BODY ASO_BI_QOT_PMV_PVT AS
2 /* $Header: asovbiqpmvb.pls 115.38 2003/10/23 07:43:55 krsundar noship $*/
3
4
5 -- This will return the SQL Query for Current/Previous VALUES,
6 -- COUNT of the OPEN QUOTES based on As OF DATE.
7 PROCEDURE GET_OPEN_QUOTE_SQL(
8 p_pmv_parameters 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 IS
13 BEGIN
14
15 NULL;
16
17 END GET_OPEN_QUOTE_SQL;
18
19
20 -- The query returns Open Quotes and Converted Quotes values for different
21 -- Resource Groups, Direct Resource-Ids and for different XTD and
22 -- Comparision types.
23 PROCEDURE GET_QUOTE_CONVERSION_sql(
24 p_pmv_parameters 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 IS
29 BEGIN
30
31 NULL;
32
33 END GET_QUOTE_CONVERSION_SQL;
34
35
36 -- Returns query which aggregates the values across Time and Sales Group
37 -- Dimensions tot_conv_value
38 PROCEDURE GET_NEW_CONV_QUOTE_SQL(
39 p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,
40 x_custom_sql OUT NOCOPY VARCHAR2,
41 x_custom_output OUT NOCOPY bis_query_attributes_TBL
42 )
43 IS
44 BEGIN
45
46 NULL;
47
48 END GET_NEW_CONV_QUOTE_SQL;
49
50 -- This will return SQL Query for the Current/Previous VALUES of the
51 -- OPEN QUOTES
52 PROCEDURE GET_OPEN_QUOTE_GRAPH_SQL(
53 p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_TBL,
54 x_custom_sql OUT NOCOPY VARCHAR2,
55 x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
56 IS
57 BEGIN
58
59 NULL;
60
61 END GET_OPEN_QUOTE_GRAPH_SQL ;
62
63 -- Returns query which aggregates the values for Converted/New Quotes
64 -- across Time and Sales Group Dimensions
65 PROCEDURE GET_QUOTE_TO_ORDER_GRAPH_SQL(
66 p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_TBL,
67 x_custom_sql OUT NOCOPY VARCHAR2,
68 x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
69 )
70 IS
71 BEGIN
72
73 NULL;
74
75 END GET_QUOTE_TO_ORDER_GRAPH_SQL;
76
77 END ASO_BI_QOT_PMV_PVT;