APPS.ASO_BI_QOT_SUMMRY_PVT dependencies on ASO_BI_QOT_UTIL_PVT

Line 50: ASO_BI_QOT_UTIL_PVT.GET_PAGE_PARAMS(p_pmv_parameters => p_pmv_parameters,

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
50: ASO_BI_QOT_UTIL_PVT.GET_PAGE_PARAMS(p_pmv_parameters => p_pmv_parameters,
51: x_conv_rate => l_conv_rate,
52: x_record_type_id => l_record_type_id,
53: x_sysdate => l_sysdate,
54: x_sg_id => l_sg_id_num,

Line 269: aso_bi_qot_util_pvt.write_query(l_sql_text2,l_module_name);

265: FROM ('|| l_sql_text4 ||')
266: GROUP BY Rule_id ';
267:
268: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
269: aso_bi_qot_util_pvt.write_query(l_sql_text2,l_module_name);
270: END IF;
271:
272: DELETE FROM ASO_BI_RPT_TMP2;
273: l_insert_stmt := 'INSERT INTO ASO_BI_RPT_TMP2(ASO_ATTRIBUTE1,ASO_VALUE1,ASO_VALUE2) ';

Line 430: ASO_BI_QOT_UTIL_PVT.GET_PAGE_PARAMS(p_pmv_parameters => p_pmv_parameters,

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,
431: x_conv_rate => l_conv_rate,
432: x_record_type_id => l_record_type_id,
433: x_sysdate => l_sysdate,
434: x_sg_id => l_sg_id_num,

Line 709: aso_bi_qot_util_pvt.write_query(l_sql_text2,l_module_name);

705: ,DECODE(restl.resource_id,NULL,grptl.group_name,restl.resource_name)
706: ,NVL(restl.resource_id,grptl.group_id) ';
707:
708: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
709: aso_bi_qot_util_pvt.write_query(l_sql_text2,l_module_name);
710: END IF;
711:
712: DELETE FROM ASO_BI_RPT_TMP1;
713: l_insert_stmt := 'INSERT INTO ASO_BI_RPT_TMP1(VIEWBY,VIEWBYID,ASO_URL1,ASO_VALUE1,ASO_VALUE2,ASO_VALUE3,ASO_VALUE4,ASO_VALUE5

Line 851: ASO_BI_QOT_UTIL_PVT.GET_PAGE_PARAMS(p_pmv_parameters => p_pmv_parameters,

847: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
848: l_module_name := 'ASO_BI_QOT_SUMMRY_PVT.BY_SALESGRP_SQL';
849:
850: -- Set up the parameters
851: ASO_BI_QOT_UTIL_PVT.GET_PAGE_PARAMS(p_pmv_parameters => p_pmv_parameters,
852: x_conv_rate => l_conv_rate,
853: x_record_type_id => l_record_type_id,
854: x_sysdate => l_sysdate,
855: x_sg_id => l_sg_id_num,

Line 1129: aso_bi_qot_util_pvt.write_query(l_SQLTEXT10,' Quote Summary From temp table');

1125: GROUP BY Temp.ASO_VALUE12, Res.Resource_Name';
1126: END IF;
1127:
1128: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1129: aso_bi_qot_util_pvt.write_query(l_SQLTEXT10,' Quote Summary From temp table');
1130: END IF;
1131:
1132: /* Mappings...
1133:

Line 1549: ASO_BI_QOT_UTIL_PVT.GET_PAGE_PARAMS(p_pmv_parameters => p_pmv_parameters,

1545: l_module_name := 'ASO_BI_QOT_SUMMRY_PVT.BY_PRODUCTCAT_SQL';
1546: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
1547:
1548: -- Set up the parameters
1549: ASO_BI_QOT_UTIL_PVT.GET_PAGE_PARAMS(p_pmv_parameters => p_pmv_parameters,
1550: x_conv_rate => l_conv_rate,
1551: x_record_type_id => l_record_type_id,
1552: x_sysdate => l_sysdate,
1553: x_sg_id => l_sg_id_num,

Line 1833: aso_bi_qot_util_pvt.write_query(l_outer_select,'Front end Query returned to PMV :');

1829: l_outer_select := REPLACE(l_outer_select,' ',' ');
1830: l_outer_select := REPLACE(l_outer_select,' ',' ');
1831:
1832: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1833: aso_bi_qot_util_pvt.write_query(l_outer_select,'Front end Query returned to PMV :');
1834: END IF;
1835:
1836: -- Return the values
1837: x_custom_sql := l_outer_select;

Line 1898: ASO_BI_QOT_UTIL_PVT.GET_PAGE_PARAMS(p_pmv_parameters => p_pmv_parameters,

1894: l_module_name := 'ASO_BI_QOT_SUMMRY_PVT.BY_DISCOUNT_SQL';
1895: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
1896:
1897: -- Set up the parameters
1898: ASO_BI_QOT_UTIL_PVT.GET_PAGE_PARAMS(p_pmv_parameters => p_pmv_parameters,
1899: x_conv_rate => l_conv_rate,
1900: x_record_type_id => l_record_type_id,
1901: x_sysdate => l_sysdate,
1902: x_sg_id => l_sg_id_num,

Line 2146: aso_bi_qot_util_pvt.write_query(l_query_string,' Query Is : ');

2142: ' UNION ALL '|| l_query_string3||' ) GROUP BY Low';
2143:
2144:
2145: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2146: aso_bi_qot_util_pvt.write_query(l_query_string,' Query Is : ');
2147: END IF;
2148:
2149: -- Clean up the temp table
2150: DELETE FROM ASO_BI_RPT_TMP1;

Line 2332: aso_bi_qot_util_pvt.write_query(l_query,' Outer Query Is : ');

2328:
2329: l_query := replace(l_query_string,' ',' ');
2330:
2331: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2332: aso_bi_qot_util_pvt.write_query(l_query,' Outer Query Is : ');
2333: END IF;
2334:
2335: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2336: FND_LOG.STRING( LOG_LEVEL => FND_LOG.LEVEL_STATEMENT ,