DBA Data[Home] [Help]

APPS.ASO_BI_QOT_SUMMRY_PVT dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 7: p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_TBL,

3:
4: -- This will Return the Top Quotes --
5:
6: PROCEDURE BY_TOPQUOT_SQL(
7: p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_TBL,
8: x_custom_sql OUT NOCOPY VARCHAR2,
9: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
10: );
11:

Line 16: p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,

12:
13: -- This will return the SQL Query for Current/Previous VALUES,
14: -- COUNT of the Total/Converted QUOTES for Sales Group.
15: PROCEDURE BY_SALESGRP_SQL(
16: p_pmv_parameters 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:

Line 25: p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_TBL,

21: );
22:
23: -- For Approval Rules Summary
24: PROCEDURE BY_APPR_RULES(
25: p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_TBL,
26: x_custom_sql OUT NOCOPY VARCHAR2,
27: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
28: );
29:

Line 32: p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_TBL,

28: );
29:
30: -- For Quote Summary By Approvals
31: PROCEDURE APPR_BY_SALESGRP_SQL(
32: p_pmv_parameters 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:

Line 39: p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_TBL,

35: );
36:
37: -- Quote Summary By Product Category
38: PROCEDURE BY_PRODUCTCAT_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:

Line 46: p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,

42: );
43:
44: -- Quote Summary By Discount
45: PROCEDURE BY_DISCOUNT_SQL(
46: p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,
47: x_custom_sql OUT NOCOPY VARCHAR2,
48: x_custom_output OUT NOCOPY bis_query_attributes_TBL
49: );
50: END ASO_BI_QOT_SUMMRY_PVT;