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

1285: AND QUOTE_LINE_ID = l_qte_line_tbl(i).quote_line_id);
1286:
1287: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1288: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Adj Attribs Lines deleted '||sql%ROWCOUNT,1,'Y');
1289: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS', 1, 'Y');
1290: END IF;
1291: DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS
1292: WHERE QUOTE_LINE_ID = l_qte_line_tbl(i).quote_line_id;
1293: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 1291: DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS

1287: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1288: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Adj Attribs Lines deleted '||sql%ROWCOUNT,1,'Y');
1289: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS', 1, 'Y');
1290: END IF;
1291: DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS
1292: WHERE QUOTE_LINE_ID = l_qte_line_tbl(i).quote_line_id;
1293: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1294: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Rltd adj Lines deleted '||sql%ROWCOUNT,1,'Y');
1295: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJUSTMENTS', 1, 'Y');

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

2106: -- End Deleting of attributes
2107:
2108: if l_complete_qte_flag = 'Y' then
2109: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2110: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS', 1, 'Y');
2111: END IF;
2112: DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS
2113: WHERE QUOTE_LINE_ID in (SELECT quote_line_id
2114: FROM ASO_PRICE_ADJUSTMENTS

Line 2112: DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS

2108: if l_complete_qte_flag = 'Y' then
2109: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2110: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS', 1, 'Y');
2111: END IF;
2112: DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS
2113: WHERE QUOTE_LINE_ID in (SELECT quote_line_id
2114: FROM ASO_PRICE_ADJUSTMENTS
2115: WHERE quote_header_id = p_qte_header_rec.quote_header_id
2116: AND quote_line_id IS NOT NULL);

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

2130: --l_complete_qte_flag is 'N'
2131:
2132: IF l_Qte_Line_id_tbl.EXISTS(1) THEN
2133: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2134: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS', 1, 'Y');
2135: For i in 1..l_qte_line_id_tbl.count loop
2136: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE for l_qte_line_id_tbl(i):'
2137: ||l_qte_line_id_tbl(i), 1, 'Y');
2138: end loop;

Line 2141: DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS

2137: ||l_qte_line_id_tbl(i), 1, 'Y');
2138: end loop;
2139: END IF;
2140:
2141: DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS
2142: WHERE quote_line_id IN (SELECT column_value
2143: FROM TABLE (CAST(l_qte_line_id_tbl AS JTF_NUMBER_TABLE)));
2144:
2145: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN