APPS.OE_HEADER_ADJ_UTIL dependencies on OE_PRICE_ADJS_HISTORY

Line 3351: DELETE FROM OE_PRICE_ADJS_HISTORY

3347: OE_Line_Adj_Assocs_Util.delete_row(
3348: p_price_adjustment_id=>l_adj.price_adjustment_id);
3349: END LOOP;
3350: /* Start Audit Trail */
3351: DELETE FROM OE_PRICE_ADJS_HISTORY
3352: WHERE HEADER_ID = p_header_id;
3353: /* End Audit Trail */
3354:
3355: DELETE FROM OE_PRICE_ADJUSTMENTS

Line 3411: DELETE FROM OE_PRICE_ADJS_HISTORY

3407: OE_Line_Adj_Assocs_Util.delete_row(
3408: p_price_adjustment_id=>p_price_adjustment_id);
3409:
3410: /* Start Audit Trail (modified for 11.5.10) */
3411: DELETE FROM OE_PRICE_ADJS_HISTORY
3412: WHERE PRICE_ADJUSTMENT_ID = p_price_adjustment_id
3413: AND NVL(AUDIT_FLAG, 'Y') = 'Y'
3414: AND NVL(VERSION_FLAG, 'N') = 'N'
3415: AND NVL(PHASE_CHANGE_FLAG, 'N') = 'N';

Line 3417: UPDATE OE_PRICE_ADJS_HISTORY

3413: AND NVL(AUDIT_FLAG, 'Y') = 'Y'
3414: AND NVL(VERSION_FLAG, 'N') = 'N'
3415: AND NVL(PHASE_CHANGE_FLAG, 'N') = 'N';
3416:
3417: UPDATE OE_PRICE_ADJS_HISTORY
3418: SET AUDIT_FLAG = 'N'
3419: WHERE PRICE_ADJUSTMENT_ID = p_price_adjustment_id
3420: AND NVL(AUDIT_FLAG, 'Y') = 'Y'
3421: AND (NVL(VERSION_FLAG, 'N') = 'Y'