eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_PRICING_FLOWS_PVT dependencies on ASO_PRICE_ADJ_ATTRIBS

Line 476: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJ_ATTRIBS', 1, 'Y');

472: end if;
473:
474: if l_adj_id_tbl.count > 0 then
475: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
476: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJ_ATTRIBS', 1, 'Y');
477: END IF;
478: FORALL i IN l_adj_id_tbl.FIRST..l_adj_id_tbl.LAST
479: DELETE FROM ASO_PRICE_ADJ_ATTRIBS
480: WHERE PRICE_ADJUSTMENT_ID = l_adj_id_tbl(i);

Line 479: DELETE FROM ASO_PRICE_ADJ_ATTRIBS

475: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
476: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJ_ATTRIBS', 1, 'Y');
477: END IF;
478: FORALL i IN l_adj_id_tbl.FIRST..l_adj_id_tbl.LAST
479: DELETE FROM ASO_PRICE_ADJ_ATTRIBS
480: WHERE PRICE_ADJUSTMENT_ID = l_adj_id_tbl(i);
481:
482: if aso_debug_pub.g_debug_flag = 'Y' THEN
483: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:No of adjustment attribute lines deleted is sql%rowcount: '||sql%rowcount,1,'Y');

Line 1278: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJ_ATTRIBS', 1, 'Y');

1274: p_service_qte_line_id_tbl => l_service_qte_line_id_tbl);
1275:
1276: FOR i IN 1..l_qte_line_tbl.count LOOP
1277: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1278: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJ_ATTRIBS', 1, 'Y');
1279: END IF;
1280: IF p_control_rec.pricing_event = 'BATCH' THEN
1281: DELETE FROM ASO_PRICE_ADJ_ATTRIBS
1282: WHERE PRICE_ADJUSTMENT_ID IN (SELECT PRICE_ADJUSTMENT_ID

Line 1281: DELETE FROM ASO_PRICE_ADJ_ATTRIBS

1277: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1278: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJ_ATTRIBS', 1, 'Y');
1279: END IF;
1280: IF p_control_rec.pricing_event = 'BATCH' THEN
1281: DELETE FROM ASO_PRICE_ADJ_ATTRIBS
1282: WHERE PRICE_ADJUSTMENT_ID IN (SELECT PRICE_ADJUSTMENT_ID
1283: FROM ASO_PRICE_ADJUSTMENTS
1284: WHERE QUOTE_HEADER_ID = p_qte_header_rec.quote_header_id
1285: AND QUOTE_LINE_ID = l_qte_line_tbl(i).quote_line_id);

Line 2089: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJ_ATTRIBS', 1, 'Y');

2085: END IF;
2086:
2087: if l_adj_id_tbl.count > 0 then
2088: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2089: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJ_ATTRIBS', 1, 'Y');
2090: END IF;
2091: FORALL i IN l_adj_id_tbl.FIRST..l_adj_id_tbl.LAST
2092: DELETE FROM ASO_PRICE_ADJ_ATTRIBS
2093: WHERE PRICE_ADJUSTMENT_ID = l_adj_id_tbl(i);

Line 2092: DELETE FROM ASO_PRICE_ADJ_ATTRIBS

2088: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2089: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJ_ATTRIBS', 1, 'Y');
2090: END IF;
2091: FORALL i IN l_adj_id_tbl.FIRST..l_adj_id_tbl.LAST
2092: DELETE FROM ASO_PRICE_ADJ_ATTRIBS
2093: WHERE PRICE_ADJUSTMENT_ID = l_adj_id_tbl(i);
2094:
2095: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2096: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:No of adjustment attribute lines deleted is sql%rowcount: '

Line 2748: DELETE FROM ASO_PRICE_ADJ_ATTRIBS

2744: AND (applied_flag = 'Y' OR updated_flag = 'Y');
2745: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2746: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Adjustment Lines deleted '||sql%ROWCOUNT,1,'Y');
2747: END IF;
2748: DELETE FROM ASO_PRICE_ADJ_ATTRIBS
2749: WHERE PRICE_ADJUSTMENT_ID IN (SELECT PRICE_ADJUSTMENT_ID
2750: FROM ASO_PRICE_ADJUSTMENTS
2751: WHERE QUOTE_HEADER_ID = p_qte_header_rec.quote_header_id
2752: AND QUOTE_LINE_ID is NULL