APPS.OE_ORDER_PURGE_PVT dependencies on OE_AUDIT_ATTR_HISTORY

Line 2166: FROM OE_AUDIT_ATTR_HISTORY

2162:
2163: --16193599 Audit History Purge Start
2164: CURSOR c_lock_audit_hist_ent1 IS
2165: SELECT entity_id -- Lock all rows to be purged
2166: FROM OE_AUDIT_ATTR_HISTORY
2167: WHERE (entity_id,entity_number) IN (SELECT 1,header_id FROM oe_order_headers_all WHERE header_id=p_header_id)
2168: FOR UPDATE NOWAIT;
2169:
2170: CURSOR c_lock_audit_hist_ent2 IS

Line 2172: FROM OE_AUDIT_ATTR_HISTORY

2168: FOR UPDATE NOWAIT;
2169:
2170: CURSOR c_lock_audit_hist_ent2 IS
2171: SELECT entity_id -- Lock all rows to be purged
2172: FROM OE_AUDIT_ATTR_HISTORY
2173: WHERE (entity_id,entity_number) IN (SELECT 2,line_id FROM oe_order_lines_all WHERE header_id=p_header_id)
2174: FOR UPDATE NOWAIT;
2175:
2176: CURSOR c_lock_audit_hist_ent6_8 IS

Line 2178: FROM OE_AUDIT_ATTR_HISTORY

2174: FOR UPDATE NOWAIT;
2175:
2176: CURSOR c_lock_audit_hist_ent6_8 IS
2177: SELECT entity_id -- Lock all rows to be purged
2178: FROM OE_AUDIT_ATTR_HISTORY
2179: WHERE (entity_id,entity_number) IN (SELECT DECODE(line_id,null,6,8),price_adjustment_id FROM oe_price_adjustments WHERE header_id=p_header_id )
2180: FOR UPDATE NOWAIT;
2181:
2182: CURSOR c_lock_audit_hist_ent5_7 IS

Line 2184: FROM OE_AUDIT_ATTR_HISTORY

2180: FOR UPDATE NOWAIT;
2181:
2182: CURSOR c_lock_audit_hist_ent5_7 IS
2183: SELECT entity_id -- Lock all rows to be purged
2184: FROM OE_AUDIT_ATTR_HISTORY
2185: WHERE (entity_id,entity_number) IN ( SELECT DECODE(line_id,null,5,7),sales_credit_id FROM oe_sales_credits WHERE header_id=p_header_id)
2186: FOR UPDATE NOWAIT;
2187: --16193599 Audit History Purge End
2188:

Line 2207: FROM OE_AUDIT_ATTR_HISTORY

2203: --16193599 Audit History Purge Start
2204: OPEN c_lock_audit_hist_ent1;
2205: CLOSE c_lock_audit_hist_ent1;
2206: DELETE
2207: FROM OE_AUDIT_ATTR_HISTORY
2208: WHERE (entity_id,entity_number) IN (SELECT 1,header_id FROM oe_order_headers_all WHERE header_id=p_header_id);
2209:
2210: OPEN c_lock_audit_hist_ent2;
2211: CLOSE c_lock_audit_hist_ent2;

Line 2213: FROM OE_AUDIT_ATTR_HISTORY

2209:
2210: OPEN c_lock_audit_hist_ent2;
2211: CLOSE c_lock_audit_hist_ent2;
2212: DELETE
2213: FROM OE_AUDIT_ATTR_HISTORY
2214: WHERE (entity_id,entity_number) IN (SELECT 2,line_id FROM oe_order_lines_all WHERE header_id=p_header_id);
2215:
2216:
2217: OPEN c_lock_audit_hist_ent6_8;

Line 2220: FROM OE_AUDIT_ATTR_HISTORY

2216:
2217: OPEN c_lock_audit_hist_ent6_8;
2218: CLOSE c_lock_audit_hist_ent6_8;
2219: DELETE
2220: FROM OE_AUDIT_ATTR_HISTORY
2221: WHERE (entity_id,entity_number) IN (SELECT DECODE(line_id,null,6,8),price_adjustment_id FROM oe_price_adjustments WHERE header_id=p_header_id );
2222:
2223:
2224: OPEN c_lock_audit_hist_ent5_7;

Line 2227: FROM OE_AUDIT_ATTR_HISTORY

2223:
2224: OPEN c_lock_audit_hist_ent5_7;
2225: CLOSE c_lock_audit_hist_ent5_7;
2226: DELETE
2227: FROM OE_AUDIT_ATTR_HISTORY
2228: WHERE (entity_id,entity_number) IN ( SELECT DECODE(line_id,null,5,7),sales_credit_id FROM oe_sales_credits WHERE header_id=p_header_id);
2229: --16193599 Audit History Purge End
2230:
2231: OPEN c_lock_header; -- Lock all rows to be purged