DBA Data[Home] [Help]

APPS.OE_ORDER_PURGE_PVT dependencies on OE_ORDER_PRICE_ATTRIBS

Line 3044: FROM OE_ORDER_PRICE_ATTRIBS

3040: IS
3041:
3042: CURSOR c_order_price_attribs IS
3043: SELECT ORDER_PRICE_ATTRIB_ID
3044: FROM OE_ORDER_PRICE_ATTRIBS
3045: WHERE HEADER_ID = p_header_id;
3046:
3047: l_order_price_attrib_id NUMBER;
3048: l_lock_price_attrib_id NUMBER;

Line 3065: FROM oe_order_price_attribs

3061:
3062: -- Lock the sales credits record.
3063: SELECT ORDER_PRICE_ATTRIB_ID
3064: INTO l_lock_price_attrib_id
3065: FROM oe_order_price_attribs
3066: WHERE ORDER_PRICE_ATTRIB_ID = l_order_price_attrib_id
3067: FOR UPDATE NOWAIT;
3068:
3069: DELETE FROM OE_ORDER_PRICE_ATTRIBS

Line 3069: DELETE FROM OE_ORDER_PRICE_ATTRIBS

3065: FROM oe_order_price_attribs
3066: WHERE ORDER_PRICE_ATTRIB_ID = l_order_price_attrib_id
3067: FOR UPDATE NOWAIT;
3068:
3069: DELETE FROM OE_ORDER_PRICE_ATTRIBS
3070: WHERE ORDER_PRICE_ATTRIB_ID = l_order_price_attrib_id;
3071:
3072: END LOOP;
3073: