DBA Data[Home] [Help]

APPS.OE_ORDER_PURGE_PVT dependencies on OE_ORDER_PRICE_ATTRIBS

Line 2990: FROM OE_ORDER_PRICE_ATTRIBS

2986: IS
2987:
2988: CURSOR c_order_price_attribs IS
2989: SELECT ORDER_PRICE_ATTRIB_ID
2990: FROM OE_ORDER_PRICE_ATTRIBS
2991: WHERE HEADER_ID = p_header_id;
2992:
2993: l_order_price_attrib_id NUMBER;
2994: l_lock_price_attrib_id NUMBER;

Line 3011: FROM oe_order_price_attribs

3007:
3008: -- Lock the sales credits record.
3009: SELECT ORDER_PRICE_ATTRIB_ID
3010: INTO l_lock_price_attrib_id
3011: FROM oe_order_price_attribs
3012: WHERE ORDER_PRICE_ATTRIB_ID = l_order_price_attrib_id
3013: FOR UPDATE NOWAIT;
3014:
3015: DELETE FROM OE_ORDER_PRICE_ATTRIBS

Line 3015: DELETE FROM OE_ORDER_PRICE_ATTRIBS

3011: FROM oe_order_price_attribs
3012: WHERE ORDER_PRICE_ATTRIB_ID = l_order_price_attrib_id
3013: FOR UPDATE NOWAIT;
3014:
3015: DELETE FROM OE_ORDER_PRICE_ATTRIBS
3016: WHERE ORDER_PRICE_ATTRIB_ID = l_order_price_attrib_id;
3017:
3018: END LOOP;
3019: