DBA Data[Home] [Help]

APPS.OE_BLANKET_WF_UTIL dependencies on OE_BLANKET_HEADERS

Line 207: update oe_blanket_headers

203: RAISE submit_draft_exception;
204: else
205: x_return_status := l_return_status;
206: l_Last_Updated_By := Nvl(To_Number(FND_PROFILE.VALUE('USER_ID')),-1);--bug6627904
207: update oe_blanket_headers
208: set lock_control = lock_control + 1,
209: Last_Updated_By = l_Last_Updated_By,
210: LAST_UPDATE_DATE = sysdate
211: where header_id = p_header_id;

Line 264: from oe_blanket_headers

260: -- Call Extend API if status is Expired and Date is Changed
261: -- For all other statuses, call Date_Changed API
262: select flow_status_code
263: into l_status
264: from oe_blanket_headers
265: where header_id = p_header_id;
266:
267: IF l_status = 'EXPIRED' THEN
268: oe_blanket_wf.Extend(p_header_id => p_header_id,

Line 777: update oe_blanket_headers

773: p_entity_id => p_header_id,
774: p_header_id => p_header_id);
775: */
776: l_Last_Updated_By := Nvl(To_Number(FND_PROFILE.VALUE('USER_ID')),-1);
777: update oe_blanket_headers
778: set TRANSACTION_PHASE_CODE = 'F',
779: lock_control = lock_control + 1,
780: Last_Updated_By = l_Last_Updated_By,
781: LAST_UPDATE_DATE = sysdate