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_ADJUSTMENTS

Line 453: FROM ASO_PRICE_ADJUSTMENTS adj

449:
450: SELECT adj.PRICE_ADJUSTMENT_ID
451: BULK COLLECT INTO
452: l_adj_id_tbl
453: FROM ASO_PRICE_ADJUSTMENTS adj
454: WHERE adj.quote_header_id = p_qte_header_rec.quote_header_id
455: AND adj.price_adjustment_id NOT IN (SELECT column_value
456: FROM TABLE (CAST(l_qte_adj_id_tbl AS JTF_NUMBER_TABLE)) passed_adj);
457:

Line 493: FROM ASO_PRICE_ADJUSTMENTS

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);
496:
497: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

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

495: AND quote_line_id IS NOT NULL);
496:
497: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
498: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Rltd adj Lines deleted '||sql%ROWCOUNT,1,'Y');
499: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJUSTMENTS', 1, 'Y');
500: END IF;
501:
502: DELETE FROM ASO_PRICE_ADJUSTMENTS
503: WHERE quote_header_id = p_qte_header_rec.quote_header_id;

Line 502: DELETE FROM ASO_PRICE_ADJUSTMENTS

498: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Rltd adj Lines deleted '||sql%ROWCOUNT,1,'Y');
499: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJUSTMENTS', 1, 'Y');
500: END IF;
501:
502: DELETE FROM ASO_PRICE_ADJUSTMENTS
503: WHERE quote_header_id = p_qte_header_rec.quote_header_id;
504: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
505: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Adjustment Lines deleted '||sql%ROWCOUNT,1,'Y');
506: END IF;

Line 863: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Deleting from ASO_PRICE_ADJUSTMENTS if p_qte_line_tbl.count = 0',1,'Y');

859:
860: -- Added this code to delete all the adjustments when there are no items in the cart
861: IF NVL(p_qte_line_tbl.count,0) = 0 THEN
862: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
863: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Deleting from ASO_PRICE_ADJUSTMENTS if p_qte_line_tbl.count = 0',1,'Y');
864: END IF;
865:
866: IF p_control_rec.pricing_event = 'BATCH' THEN
867: DELETE FROM aso_price_adjustments

Line 867: DELETE FROM aso_price_adjustments

863: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Deleting from ASO_PRICE_ADJUSTMENTS if p_qte_line_tbl.count = 0',1,'Y');
864: END IF;
865:
866: IF p_control_rec.pricing_event = 'BATCH' THEN
867: DELETE FROM aso_price_adjustments
868: WHERE quote_header_id = p_qte_header_rec.quote_header_id
869: AND quote_line_id IS NULL;
870: End if;--p_control_rec.pricing_event = 'BATCH'
871:

Line 1283: FROM ASO_PRICE_ADJUSTMENTS

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);
1286:
1287: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

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

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');
1296: END IF;
1297:
1298: DELETE FROM ASO_PRICE_ADJUSTMENTS
1299: WHERE quote_line_id = l_qte_line_tbl(i).quote_line_id;

Line 1298: DELETE FROM ASO_PRICE_ADJUSTMENTS

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');
1296: END IF;
1297:
1298: DELETE FROM ASO_PRICE_ADJUSTMENTS
1299: WHERE quote_line_id = l_qte_line_tbl(i).quote_line_id;
1300: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1301: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Adjustment Lines deleted '||sql%ROWCOUNT,1,'Y');
1302: END IF;

Line 2053: FROM ASO_PRICE_ADJUSTMENTS adj

2049: If l_qte_adj_id_tbl.EXISTS(1) then
2050: SELECT adj.PRICE_ADJUSTMENT_ID
2051: BULK COLLECT INTO
2052: l_adj_id_tbl
2053: FROM ASO_PRICE_ADJUSTMENTS adj
2054: WHERE adj.quote_header_id = p_qte_header_rec.quote_header_id
2055: AND adj.price_adjustment_id NOT IN (SELECT column_value
2056: FROM TABLE (CAST(l_qte_adj_id_tbl AS JTF_NUMBER_TABLE)) passed_adj);
2057:

Line 2066: FROM ASO_PRICE_ADJUSTMENTS adj

2062: Elsif (lx_order_status_rec.summary_line_flag = 'Y') Then
2063: SELECT adj.PRICE_ADJUSTMENT_ID
2064: BULK COLLECT INTO
2065: l_adj_id_tbl
2066: FROM ASO_PRICE_ADJUSTMENTS adj
2067: WHERE adj.quote_header_id = p_qte_header_rec.quote_header_id
2068: AND adj.quote_line_id IS NULL;
2069: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2070: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: No. of adjustment lines selected is sql%rowcount(Header): '

Line 2114: FROM ASO_PRICE_ADJUSTMENTS

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);
2117:
2118: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

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

2116: AND quote_line_id IS NOT NULL);
2117:
2118: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2119: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Rltd adj Lines deleted '||sql%ROWCOUNT,1,'Y');
2120: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJUSTMENTS', 1, 'Y');
2121: END IF;
2122:
2123: DELETE FROM ASO_PRICE_ADJUSTMENTS
2124: WHERE quote_header_id = p_qte_header_rec.quote_header_id;

Line 2123: DELETE FROM ASO_PRICE_ADJUSTMENTS

2119: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Rltd adj Lines deleted '||sql%ROWCOUNT,1,'Y');
2120: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJUSTMENTS', 1, 'Y');
2121: END IF;
2122:
2123: DELETE FROM ASO_PRICE_ADJUSTMENTS
2124: WHERE quote_header_id = p_qte_header_rec.quote_header_id;
2125: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2126: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Adjustment Lines deleted '||sql%ROWCOUNT,1,'Y');
2127: END IF;

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

2146: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Rltd adj Lines deleted '||sql%ROWCOUNT,1,'Y');
2147: END IF;
2148:
2149: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2150: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJUSTMENTS', 1, 'Y');
2151: END IF;
2152: DELETE FROM ASO_PRICE_ADJUSTMENTS
2153: WHERE quote_line_id IN (SELECT column_value
2154: FROM TABLE (CAST(l_qte_line_id_tbl AS JTF_NUMBER_TABLE)))

Line 2152: DELETE FROM ASO_PRICE_ADJUSTMENTS

2148:
2149: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2150: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJUSTMENTS', 1, 'Y');
2151: END IF;
2152: DELETE FROM ASO_PRICE_ADJUSTMENTS
2153: WHERE quote_line_id IN (SELECT column_value
2154: FROM TABLE (CAST(l_qte_line_id_tbl AS JTF_NUMBER_TABLE)))
2155: AND quote_header_id = p_qte_header_rec.quote_header_id;
2156: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 2160: DELETE FROM ASO_PRICE_ADJUSTMENTS

2156: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2157: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Adjustment Lines deleted '||sql%ROWCOUNT,1,'Y');
2158: END IF;
2159:
2160: DELETE FROM ASO_PRICE_ADJUSTMENTS
2161: WHERE quote_header_id = p_qte_header_rec.quote_header_id
2162: AND quote_line_id is NULL;
2163:
2164: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 2168: DELETE FROM ASO_PRICE_ADJUSTMENTS

2164: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2165: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Header Adjustment deleted '||sql%ROWCOUNT,1,'Y');
2166: END IF;
2167: ELSIF (lx_order_status_rec.summary_line_flag = 'Y') Then
2168: DELETE FROM ASO_PRICE_ADJUSTMENTS
2169: WHERE quote_header_id = p_qte_header_rec.quote_header_id
2170: AND quote_line_id is NULL;
2171:
2172: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 2741: DELETE FROM ASO_PRICE_ADJUSTMENTS

2737: END IF; -- l_qte_line_tbl.count = 0 check.
2738:
2739: -- Delete only the header level adj that are applied or updated because
2740: -- line level modifiers will not change in Calculate only call
2741: DELETE FROM ASO_PRICE_ADJUSTMENTS
2742: WHERE quote_header_id = p_qte_header_rec.quote_header_id
2743: AND quote_line_id IS NULL
2744: AND (applied_flag = 'Y' OR updated_flag = 'Y');
2745: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 2750: FROM ASO_PRICE_ADJUSTMENTS

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
2753: AND (applied_flag = 'Y' OR updated_flag = 'Y'));
2754: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN