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_RELATIONSHIPS

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

485:
486: end if;
487:
488: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
489: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS', 1, 'Y');
490: END IF;
491: DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS
492: WHERE QUOTE_LINE_ID in (SELECT quote_line_id
493: FROM ASO_PRICE_ADJUSTMENTS

Line 491: DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS

487:
488: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
489: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS', 1, 'Y');
490: END IF;
491: DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS
492: WHERE QUOTE_LINE_ID in (SELECT quote_line_id
493: FROM ASO_PRICE_ADJUSTMENTS
494: WHERE quote_header_id = p_qte_header_rec.quote_header_id
495: AND quote_line_id IS NOT NULL);

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

1463: AND QUOTE_LINE_ID = l_qte_line_tbl(i).quote_line_id);
1464:
1465: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1466: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Adj Attribs Lines deleted '||sql%ROWCOUNT,1,'Y');
1467: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS', 1, 'Y');
1468: END IF;
1469: DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS
1470: WHERE QUOTE_LINE_ID = l_qte_line_tbl(i).quote_line_id;
1471: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 1469: DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS

1465: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1466: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Adj Attribs Lines deleted '||sql%ROWCOUNT,1,'Y');
1467: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS', 1, 'Y');
1468: END IF;
1469: DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS
1470: WHERE QUOTE_LINE_ID = l_qte_line_tbl(i).quote_line_id;
1471: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1472: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Rltd adj Lines deleted '||sql%ROWCOUNT,1,'Y');
1473: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJUSTMENTS', 1, 'Y');

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

2346: -- End Deleting of attributes
2347:
2348: if l_complete_qte_flag = 'Y' then
2349: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2350: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS', 1, 'Y');
2351: END IF;
2352: DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS
2353: WHERE QUOTE_LINE_ID in (SELECT quote_line_id
2354: FROM ASO_PRICE_ADJUSTMENTS

Line 2352: DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS

2348: if l_complete_qte_flag = 'Y' then
2349: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2350: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS', 1, 'Y');
2351: END IF;
2352: DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS
2353: WHERE QUOTE_LINE_ID in (SELECT quote_line_id
2354: FROM ASO_PRICE_ADJUSTMENTS
2355: WHERE quote_header_id = p_qte_header_rec.quote_header_id
2356: AND quote_line_id IS NOT NULL);

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

2370: --l_complete_qte_flag is 'N'
2371:
2372: IF l_Qte_Line_id_tbl.EXISTS(1) THEN
2373: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2374: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS', 1, 'Y');
2375: For i in 1..l_qte_line_id_tbl.count loop
2376: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE for l_qte_line_id_tbl(i):'
2377: ||l_qte_line_id_tbl(i), 1, 'Y');
2378: end loop;

Line 2381: DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS

2377: ||l_qte_line_id_tbl(i), 1, 'Y');
2378: end loop;
2379: END IF;
2380:
2381: DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS
2382: WHERE quote_line_id IN (SELECT column_value
2383: FROM TABLE (CAST(l_qte_line_id_tbl AS JTF_NUMBER_TABLE)));
2384:
2385: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN