APPS.OE_SALES_CAN_UTIL dependencies on OE_ORDER_LINES_ALL

Line 2000: oe_order_lines_all ol --bug 4156493

1996: into l_prg_line_count
1997: from oe_price_adjustments opa1,
1998: oe_price_adjustments opa2,
1999: oe_price_adj_assocs opaa,
2000: oe_order_lines_all ol --bug 4156493
2001: where opa1.list_line_type_code = 'PRG'
2002: and opa1.price_adjustment_id = opaa.price_adjustment_id
2003: and opa2.price_adjustment_id = opaa.rltd_price_adj_id
2004: and opa2.line_id = l_line_old_tbl(i).line_id

Line 2145: oe_order_lines_all

2141: IS
2142: l_Ordered_Quantity number ;
2143: Cursor C1 IS
2144: select ordered_quantity from
2145: oe_order_lines_all
2146: where line_id = x_request_rec.entity_id;
2147:
2148: Cursor C2 IS
2149: select ordered_quantity from

Line 2150: oe_order_lines_all

2146: where line_id = x_request_rec.entity_id;
2147:
2148: Cursor C2 IS
2149: select ordered_quantity from
2150: oe_order_lines_all
2151: where header_id = x_request_rec.entity_id
2152: and ordered_quantity <> 0;
2153: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2154:

Line 2200: Update oe_order_lines_all

2196: IF l_ordered_quantity = 0 THEN
2197: if l_debug_level > 0 then
2198: OE_DEBUG_PUB.ADD('Before cancelling line flow ');
2199: end if;
2200: Update oe_order_lines_all
2201: set cancelled_flag = 'Y' where
2202: line_id = x_request_rec.entity_id;
2203:
2204: wf_engine.handleerror(OE_Globals.G_WFI_LIN