APPS.ASO_BI_QOT_PMV_PVT dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 8: p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,

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

Line 24: p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,

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

Line 39: p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,

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

Line 53: p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_TBL,

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

Line 66: p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_TBL,

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