APPS.ASO_BI_QOT_SUMMRY_PVT dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 9: PROCEDURE BY_APPR_RULES(p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,

5: -- ASO_VALUE1 : Rule description
6: -- ASO_VALUE2 : Percentage of submissions
7: -- ASO_CHANGE1 : Change
8:
9: PROCEDURE BY_APPR_RULES(p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,
10: x_custom_sql OUT NOCOPY VARCHAR2,
11: x_custom_output OUT NOCOPY bis_query_attributes_TBL)
12: AS
13: l_sql_text1 VARCHAR2(32000);

Line 388: PROCEDURE APPR_BY_SALESGRP_SQL(p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,

384: ASO_GRAND_VALUE10 - Grand Total (Prev Number of Approvers)
385: ASO_GRAND_CHANGE5 - Grand Change (Number of Approvers)
386: */
387:
388: PROCEDURE APPR_BY_SALESGRP_SQL(p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,
389: x_custom_sql OUT NOCOPY VARCHAR2,
390: x_custom_output OUT NOCOPY bis_query_attributes_TBL)
391: AS
392: l_sql_text1 VARCHAR2(32000);

Line 808: PROCEDURE BY_SALESGRP_SQL(p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,

804: l_fdcp_date_j : First Date of Current Period
805: l_fdpp_date_j : First Date of Previous Period
806: */
807:
808: PROCEDURE BY_SALESGRP_SQL(p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,
809: x_custom_sql OUT NOCOPY VARCHAR2,
810: x_custom_output OUT NOCOPY bis_query_attributes_TBL)
811: AS
812: l_SQLTEXT1 VARCHAR2(32000);

Line 1513: PROCEDURE BY_PRODUCTCAT_SQL(p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_TBL,

1509: END BY_SALESGRP_SQL;
1510:
1511: -- Quote summary by product category
1512:
1513: PROCEDURE BY_PRODUCTCAT_SQL(p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_TBL,
1514: x_custom_sql OUT NOCOPY VARCHAR2,
1515: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1516: AS
1517: l_orderBy VARCHAR2(200);

Line 1850: p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,

1846: RAISE;
1847: END BY_PRODUCTCAT_SQL;
1848:
1849: PROCEDURE BY_DISCOUNT_SQL(
1850: p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,
1851: x_custom_sql OUT NOCOPY VARCHAR2,
1852: x_custom_output OUT NOCOPY bis_query_attributes_TBL
1853: )
1854: AS

Line 2529: PROCEDURE BY_TOPQUOT_SQL(p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,

2525: ASO_GRAND_VALUE2 - ASO Grand Value2
2526: ASO_GRAND_VALUE3 - ASO Grand Value3
2527: */
2528:
2529: PROCEDURE BY_TOPQUOT_SQL(p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,
2530: x_custom_sql OUT NOCOPY VARCHAR2,
2531: x_custom_output OUT NOCOPY bis_query_attributes_TBL)
2532: AS
2533: l_inner_sql VARCHAR2(32000);