DBA Data[Home] [Help]

APPS.OE_VERSIONING_UTIL dependencies on OE_BLANKET_HEADERS_ALL

Line 241: FROM OE_BLANKET_HEADERS_ALL

237: IF (l_version_flag = 'Y') THEN
238:
239: SELECT LOCK_CONTROL, VERSION_NUMBER
240: INTO l_lock_control, l_version_number
241: FROM OE_BLANKET_HEADERS_ALL
242: WHERE HEADER_ID = p_header_id;
243:
244: IF l_version_number = OE_Blanket_Util.g_old_header_hist_rec.version_number THEN
245:

Line 246: UPDATE OE_BLANKET_HEADERS_ALL

242: WHERE HEADER_ID = p_header_id;
243:
244: IF l_version_number = OE_Blanket_Util.g_old_header_hist_rec.version_number THEN
245:
246: UPDATE OE_BLANKET_HEADERS_ALL
247: SET VERSION_NUMBER = l_version_number + 1,
248: LOCK_CONTROL = l_lock_control + 1
249: WHERE HEADER_ID = p_header_id;
250:

Line 256: FROM OE_BLANKET_HEADERS_ALL

252: UPDATE OE_BLANKET_HEADERS_EXT
253: SET REVISION_CHANGE_DATE = sysdate
254: WHERE ORDER_NUMBER IN
255: (SELECT ORDER_NUMBER
256: FROM OE_BLANKET_HEADERS_ALL
257: WHERE HEADER_ID = p_header_id
258: );
259:
260: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;