APPS.OE_SALES_CAN_UTIL dependencies on OE_ORDER_LINES_ALL

Line 1937: oe_order_lines_all ol --bug 4156493

1933: into l_prg_line_count
1934: from oe_price_adjustments opa1,
1935: oe_price_adjustments opa2,
1936: oe_price_adj_assocs opaa,
1937: oe_order_lines_all ol --bug 4156493
1938: where opa1.list_line_type_code = 'PRG'
1939: and opa1.price_adjustment_id = opaa.price_adjustment_id
1940: and opa2.price_adjustment_id = opaa.rltd_price_adj_id
1941: and opa2.line_id = l_line_old_tbl(i).line_id

Line 2081: oe_order_lines_all

2077: IS
2078: l_Ordered_Quantity number ;
2079: Cursor C1 IS
2080: select ordered_quantity from
2081: oe_order_lines_all
2082: where line_id = x_request_rec.entity_id;
2083:
2084: Cursor C2 IS
2085: select ordered_quantity from

Line 2086: oe_order_lines_all

2082: where line_id = x_request_rec.entity_id;
2083:
2084: Cursor C2 IS
2085: select ordered_quantity from
2086: oe_order_lines_all
2087: where header_id = x_request_rec.entity_id
2088: and ordered_quantity <> 0;
2089: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2090:

Line 2136: Update oe_order_lines_all

2132: IF l_ordered_quantity = 0 THEN
2133: if l_debug_level > 0 then
2134: OE_DEBUG_PUB.ADD('Before cancelling line flow ');
2135: end if;
2136: Update oe_order_lines_all
2137: set cancelled_flag = 'Y' where
2138: line_id = x_request_rec.entity_id;
2139:
2140: wf_engine.handleerror(OE_Globals.G_WFI_LIN