[Home] [Help]
PACKAGE: APPS.ASO_BI_QOT_SUMMRY_PVT
Source
1 PACKAGE ASO_BI_QOT_SUMMRY_PVT AUTHID CURRENT_USER AS
2 /* $Header: asovbiqsmrys.pls 120.0 2005/05/31 01:26:06 appldev noship $ */
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
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
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
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(
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(
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;