DBA Data[Home] [Help]

APPS.OE_BLANKET_UTIL dependencies on OE_BLANKET_HEADERS_HIST

Line 4753: DELETE FROM OE_BLANKET_HEADERS_HIST

4749:
4750: DELETE FROM OE_BLANKET_HEADERS
4751: WHERE header_id = p_header_id;
4752:
4753: DELETE FROM OE_BLANKET_HEADERS_HIST
4754: WHERE header_id = p_header_id;
4755:
4756: --for bug 3348870
4757: DELETE FROM OE_BLANKET_HEADERS_EXT

Line 5502: FROM OE_BLANKET_HEADERS_HIST bh

5498: , new_price_list_id
5499: , new_modifier_list_id
5500: , default_discount_percent
5501: , default_discount_amount
5502: FROM OE_BLANKET_HEADERS_HIST bh
5503: WHERE bh.header_id = p_header_id
5504: AND bh.sales_document_type_code = 'B'
5505: AND bh.version_number = p_version_number
5506: AND (PHASE_CHANGE_FLAG = p_phase_change_flag

Line 8115: INSERT INTO OE_BLANKET_HEADERS_HIST

8111: if l_debug_level > 0 then
8112: oe_debug_pub.ADD('Before inserting blanket history header_id ' || p_header_rec.header_id, 5);
8113: end if;
8114:
8115: INSERT INTO OE_BLANKET_HEADERS_HIST
8116: ( ACCOUNTING_RULE_ID
8117: , AGREEMENT_ID
8118: , ATTRIBUTE1
8119: , ATTRIBUTE10