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 913: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Deleting from ASO_PRICE_ADJUSTMENTS if p_qte_line_tbl.count = 0',1,'Y');

909:
910: -- Added this code to delete all the adjustments when there are no items in the cart
911: IF NVL(p_qte_line_tbl.count,0) = 0 THEN
912: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
913: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Deleting from ASO_PRICE_ADJUSTMENTS if p_qte_line_tbl.count = 0',1,'Y');
914: END IF;
915:
916: IF p_control_rec.pricing_event = 'BATCH' THEN
917: DELETE FROM aso_price_adjustments

Line 917: DELETE FROM aso_price_adjustments

913: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Deleting from ASO_PRICE_ADJUSTMENTS if p_qte_line_tbl.count = 0',1,'Y');
914: END IF;
915:
916: IF p_control_rec.pricing_event = 'BATCH' THEN
917: DELETE FROM aso_price_adjustments
918: WHERE quote_header_id = p_qte_header_rec.quote_header_id
919: AND quote_line_id IS NULL;
920: End if;--p_control_rec.pricing_event = 'BATCH'
921:

Line 1461: FROM ASO_PRICE_ADJUSTMENTS

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

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

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');
1474: END IF;
1475:
1476: DELETE FROM ASO_PRICE_ADJUSTMENTS
1477: WHERE quote_line_id = l_qte_line_tbl(i).quote_line_id;

Line 1476: DELETE FROM ASO_PRICE_ADJUSTMENTS

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');
1474: END IF;
1475:
1476: DELETE FROM ASO_PRICE_ADJUSTMENTS
1477: WHERE quote_line_id = l_qte_line_tbl(i).quote_line_id;
1478: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1479: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Adjustment Lines deleted '||sql%ROWCOUNT,1,'Y');
1480: END IF;

Line 2293: FROM ASO_PRICE_ADJUSTMENTS adj

2289: If l_qte_adj_id_tbl.EXISTS(1) then
2290: SELECT adj.PRICE_ADJUSTMENT_ID
2291: BULK COLLECT INTO
2292: l_adj_id_tbl
2293: FROM ASO_PRICE_ADJUSTMENTS adj
2294: WHERE adj.quote_header_id = p_qte_header_rec.quote_header_id
2295: AND adj.price_adjustment_id NOT IN (SELECT column_value
2296: FROM TABLE (CAST(l_qte_adj_id_tbl AS JTF_NUMBER_TABLE)) passed_adj);
2297:

Line 2306: FROM ASO_PRICE_ADJUSTMENTS adj

2302: Elsif (lx_order_status_rec.summary_line_flag = 'Y') Then
2303: SELECT adj.PRICE_ADJUSTMENT_ID
2304: BULK COLLECT INTO
2305: l_adj_id_tbl
2306: FROM ASO_PRICE_ADJUSTMENTS adj
2307: WHERE adj.quote_header_id = p_qte_header_rec.quote_header_id
2308: AND adj.quote_line_id IS NULL;
2309: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2310: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: No. of adjustment lines selected is sql%rowcount(Header): '

Line 2354: FROM ASO_PRICE_ADJUSTMENTS

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

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

2356: AND quote_line_id IS NOT NULL);
2357:
2358: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2359: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Rltd adj Lines deleted '||sql%ROWCOUNT,1,'Y');
2360: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJUSTMENTS', 1, 'Y');
2361: END IF;
2362:
2363: DELETE FROM ASO_PRICE_ADJUSTMENTS
2364: WHERE quote_header_id = p_qte_header_rec.quote_header_id;

Line 2363: DELETE FROM ASO_PRICE_ADJUSTMENTS

2359: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Rltd adj Lines deleted '||sql%ROWCOUNT,1,'Y');
2360: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJUSTMENTS', 1, 'Y');
2361: END IF;
2362:
2363: DELETE FROM ASO_PRICE_ADJUSTMENTS
2364: WHERE quote_header_id = p_qte_header_rec.quote_header_id;
2365: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2366: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Adjustment Lines deleted '||sql%ROWCOUNT,1,'Y');
2367: END IF;

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

2386: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Rltd adj Lines deleted '||sql%ROWCOUNT,1,'Y');
2387: END IF;
2388:
2389: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2390: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJUSTMENTS', 1, 'Y');
2391: END IF;
2392: DELETE FROM ASO_PRICE_ADJUSTMENTS
2393: WHERE quote_line_id IN (SELECT column_value
2394: FROM TABLE (CAST(l_qte_line_id_tbl AS JTF_NUMBER_TABLE)))

Line 2392: DELETE FROM ASO_PRICE_ADJUSTMENTS

2388:
2389: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2390: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJUSTMENTS', 1, 'Y');
2391: END IF;
2392: DELETE FROM ASO_PRICE_ADJUSTMENTS
2393: WHERE quote_line_id IN (SELECT column_value
2394: FROM TABLE (CAST(l_qte_line_id_tbl AS JTF_NUMBER_TABLE)))
2395: AND quote_header_id = p_qte_header_rec.quote_header_id;
2396: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 2400: DELETE FROM ASO_PRICE_ADJUSTMENTS

2396: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2397: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Adjustment Lines deleted '||sql%ROWCOUNT,1,'Y');
2398: END IF;
2399:
2400: DELETE FROM ASO_PRICE_ADJUSTMENTS
2401: WHERE quote_header_id = p_qte_header_rec.quote_header_id
2402: AND quote_line_id is NULL;
2403:
2404: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 2408: DELETE FROM ASO_PRICE_ADJUSTMENTS

2404: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2405: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Header Adjustment deleted '||sql%ROWCOUNT,1,'Y');
2406: END IF;
2407: ELSIF (lx_order_status_rec.summary_line_flag = 'Y') Then
2408: DELETE FROM ASO_PRICE_ADJUSTMENTS
2409: WHERE quote_header_id = p_qte_header_rec.quote_header_id
2410: AND quote_line_id is NULL;
2411:
2412: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 2981: DELETE FROM ASO_PRICE_ADJUSTMENTS

2977: END IF; -- l_qte_line_tbl.count = 0 check.
2978:
2979: -- Delete only the header level adj that are applied or updated because
2980: -- line level modifiers will not change in Calculate only call
2981: DELETE FROM ASO_PRICE_ADJUSTMENTS
2982: WHERE quote_header_id = p_qte_header_rec.quote_header_id
2983: AND quote_line_id IS NULL
2984: AND (applied_flag = 'Y' OR updated_flag = 'Y');
2985: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 2990: FROM ASO_PRICE_ADJUSTMENTS

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