APPS.OE_HEADER_ADJ_UTIL dependencies on OE_PRICE_ADJS_HISTORY

Line 3292: DELETE FROM OE_PRICE_ADJS_HISTORY

3288: OE_Line_Adj_Assocs_Util.delete_row(
3289: p_price_adjustment_id=>l_adj.price_adjustment_id);
3290: END LOOP;
3291: /* Start Audit Trail */
3292: DELETE FROM OE_PRICE_ADJS_HISTORY
3293: WHERE HEADER_ID = p_header_id;
3294: /* End Audit Trail */
3295:
3296: DELETE FROM OE_PRICE_ADJUSTMENTS

Line 3352: DELETE FROM OE_PRICE_ADJS_HISTORY

3348: OE_Line_Adj_Assocs_Util.delete_row(
3349: p_price_adjustment_id=>p_price_adjustment_id);
3350:
3351: /* Start Audit Trail (modified for 11.5.10) */
3352: DELETE FROM OE_PRICE_ADJS_HISTORY
3353: WHERE PRICE_ADJUSTMENT_ID = p_price_adjustment_id
3354: AND NVL(AUDIT_FLAG, 'Y') = 'Y'
3355: AND NVL(VERSION_FLAG, 'N') = 'N'
3356: AND NVL(PHASE_CHANGE_FLAG, 'N') = 'N';

Line 3358: UPDATE OE_PRICE_ADJS_HISTORY

3354: AND NVL(AUDIT_FLAG, 'Y') = 'Y'
3355: AND NVL(VERSION_FLAG, 'N') = 'N'
3356: AND NVL(PHASE_CHANGE_FLAG, 'N') = 'N';
3357:
3358: UPDATE OE_PRICE_ADJS_HISTORY
3359: SET AUDIT_FLAG = 'N'
3360: WHERE PRICE_ADJUSTMENT_ID = p_price_adjustment_id
3361: AND NVL(AUDIT_FLAG, 'Y') = 'Y'
3362: AND (NVL(VERSION_FLAG, 'N') = 'Y'