DBA Data[Home] [Help]

APPS.ASO_BI_QOT_SUMMRY_PVT dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 9: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL

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:
12:
13: -- This will return the SQL Query for Current/Previous VALUES,

Line 18: x_custom_output OUT NOCOPY bis_query_attributes_TBL

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:
21: );
22:

Line 27: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL

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:
30: -- For Quote Summary By Approvals
31: PROCEDURE APPR_BY_SALESGRP_SQL(

Line 34: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL

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:
37: -- Quote Summary By Product Category
38: PROCEDURE BY_PRODUCTCAT_SQL(

Line 41: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL

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:
44: -- Quote Summary By Discount
45: PROCEDURE BY_DISCOUNT_SQL(

Line 48: x_custom_output OUT NOCOPY bis_query_attributes_TBL

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;