[Home] [Help]
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);
14: l_sql_text2 VARCHAR2(32000);
15: l_sql_text3 VARCHAR2(32000);
41: l_custom_rec BIS_QUERY_ATTRIBUTES;
42:
43: BEGIN
44:
45: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
46: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
47: l_module_name := 'ASO_BI_QOT_SUMMRY_PVT.BY_APPR_RULES';
48:
49: -- Set up the parameters
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);
393: l_sql_text2 VARCHAR2(32000);
394: l_insert_stmt VARCHAR2(3200);
422: BEGIN
423:
424: --Initialise here to get around File.sql.35
425: l_module_name := 'ASO_BI_QOT_SUMMRY_PVT.APPR_BY_SALESGRP_SQL';
426: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
427: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
428:
429: -- Set up the parameters
430: ASO_BI_QOT_UTIL_PVT.GET_PAGE_PARAMS(p_pmv_parameters => p_pmv_parameters,
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);
813: l_SQLTEXT2 VARCHAR2(32000);
814: l_SQLTEXT3 VARCHAR2(32000);
1496: END IF;
1497:
1498: x_custom_sql := l_SQLTEXT11;
1499:
1500: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
1501:
1502: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
1503: l_custom_rec.attribute_value:= 'ORGANIZATION+JTF_ORG_SALES_GROUP';
1504: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
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);
1518: l_orderby_cluase VARCHAR2(2000);
1519: l_sortBy VARCHAR2(200);
1834: END IF;
1835:
1836: -- Return the values
1837: x_custom_sql := l_outer_select;
1838: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
1839: EXCEPTION
1840: WHEN OTHERS THEN
1841: IF(FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1842: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_ERROR ,
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
1855: l_SQLTEXT1 VARCHAR2(32000);
1856: l_insert_stmnt VARCHAR2(32000);
2340: END IF;
2341:
2342: x_custom_sql := l_query;
2343:
2344: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
2345:
2346: --20 binds for range low and range name
2347: l_custom_rec.attribute_name := ':range1_low';
2348: l_custom_rec.attribute_value := l_bucket_rec.range1_low;
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);
2534: l_insert_stmnt VARCHAR2(32000);
2535: l_parameter_name VARCHAR2(3200);
2720: ' ORDER BY '|| l_orderBy ||' '|| l_sortBy ||' , UPPER(ASO_ATTRIBUTE1) NULLS LAST ' ;
2721:
2722:
2723:
2724: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
2725:
2726: l_custom_rec.attribute_name := ':l_sg_id_num';
2727: l_custom_rec.attribute_value := l_sg_id_num;
2728: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;