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 1456: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJ_ATTRIBS', 1, 'Y');

1452: p_service_qte_line_id_tbl => l_service_qte_line_id_tbl);
1453:
1454: FOR i IN 1..l_qte_line_tbl.count LOOP
1455: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1456: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJ_ATTRIBS', 1, 'Y');
1457: END IF;
1458: IF p_control_rec.pricing_event = 'BATCH' THEN
1459: DELETE FROM ASO_PRICE_ADJ_ATTRIBS
1460: WHERE PRICE_ADJUSTMENT_ID IN (SELECT PRICE_ADJUSTMENT_ID

Line 1459: DELETE FROM ASO_PRICE_ADJ_ATTRIBS

1455: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1456: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJ_ATTRIBS', 1, 'Y');
1457: END IF;
1458: IF p_control_rec.pricing_event = 'BATCH' THEN
1459: DELETE FROM ASO_PRICE_ADJ_ATTRIBS
1460: WHERE PRICE_ADJUSTMENT_ID IN (SELECT PRICE_ADJUSTMENT_ID
1461: FROM ASO_PRICE_ADJUSTMENTS
1462: WHERE QUOTE_HEADER_ID = p_qte_header_rec.quote_header_id
1463: AND QUOTE_LINE_ID = l_qte_line_tbl(i).quote_line_id);

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

2325: END IF;
2326:
2327: if l_adj_id_tbl.count > 0 then
2328: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2329: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJ_ATTRIBS', 1, 'Y');
2330: END IF;
2331: FORALL i IN l_adj_id_tbl.FIRST..l_adj_id_tbl.LAST
2332: DELETE FROM ASO_PRICE_ADJ_ATTRIBS
2333: WHERE PRICE_ADJUSTMENT_ID = l_adj_id_tbl(i);

Line 2332: DELETE FROM ASO_PRICE_ADJ_ATTRIBS

2328: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2329: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJ_ATTRIBS', 1, 'Y');
2330: END IF;
2331: FORALL i IN l_adj_id_tbl.FIRST..l_adj_id_tbl.LAST
2332: DELETE FROM ASO_PRICE_ADJ_ATTRIBS
2333: WHERE PRICE_ADJUSTMENT_ID = l_adj_id_tbl(i);
2334:
2335: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2336: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:No of adjustment attribute lines deleted is sql%rowcount: '

Line 2988: DELETE FROM ASO_PRICE_ADJ_ATTRIBS

2984: AND (applied_flag = 'Y' OR updated_flag = 'Y');
2985: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2986: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Adjustment Lines deleted '||sql%ROWCOUNT,1,'Y');
2987: END IF;
2988: DELETE FROM ASO_PRICE_ADJ_ATTRIBS
2989: WHERE PRICE_ADJUSTMENT_ID IN (SELECT PRICE_ADJUSTMENT_ID
2990: FROM ASO_PRICE_ADJUSTMENTS
2991: WHERE QUOTE_HEADER_ID = p_qte_header_rec.quote_header_id
2992: AND QUOTE_LINE_ID is NULL