DBA Data[Home] [Help]

APPS.OE_VERSIONING_UTIL dependencies on OE_ORDER_HEADERS_ALL

Line 210: select version_number into l_version_number from oe_order_headers_all where header_id = p_header_id;

206: l_phase_change_flag := 'Y';
207: IF (p_document_type <> 'BLANKETS') THEN
208: IF OE_ORDER_UTIL.g_old_header_rec.version_number IS NULL
209: OR OE_ORDER_UTIL.g_old_header_rec.version_number = FND_API.G_MISS_NUM THEN
210: select version_number into l_version_number from oe_order_headers_all where header_id = p_header_id;
211: ELSE
212: l_version_number := OE_ORDER_UTIL.g_old_header_rec.version_number;
213: END IF;
214: END IF;

Line 224: select version_number into l_version_number from oe_order_headers_all where header_id = p_header_id;

220: l_version_flag := 'Y';
221: IF (p_document_type <> 'BLANKETS') THEN
222: IF OE_ORDER_UTIL.g_old_header_rec.version_number IS NULL
223: OR OE_ORDER_UTIL.g_old_header_rec.version_number = FND_API.G_MISS_NUM THEN
224: select version_number into l_version_number from oe_order_headers_all where header_id = p_header_id;
225: ELSE
226: l_version_number := OE_ORDER_UTIL.g_old_header_rec.version_number;
227: END IF;
228: END IF;

Line 424: FROM OE_ORDER_HEADERS_ALL

420: oe_debug_pub.add(' Updating version number, lock control ',1);
421: END IF;
422: SELECT LOCK_CONTROL
423: INTO l_lock_control
424: FROM OE_ORDER_HEADERS_ALL
425: WHERE HEADER_ID = p_header_id;
426:
427: IF OE_ORDER_UTIL.G_HEADER_REC.VERSION_NUMBER = OE_ORDER_UTIL.G_OLD_HEADER_REC.VERSION_NUMBER
428: OR OE_ORDER_UTIL.G_HEADER_REC.VERSION_NUMBER IS NULL

Line 432: UPDATE OE_ORDER_HEADERS_ALL

428: OR OE_ORDER_UTIL.G_HEADER_REC.VERSION_NUMBER IS NULL
429: OR OE_ORDER_UTIL.G_HEADER_REC.VERSION_NUMBER = FND_API.G_MISS_NUM
430: OR OE_ORDER_UTIL.G_OLD_HEADER_REC.VERSION_NUMBER IS NULL
431: OR OE_ORDER_UTIL.G_OLD_HEADER_REC.VERSION_NUMBER = FND_API.G_MISS_NUM THEN
432: UPDATE OE_ORDER_HEADERS_ALL
433: SET VERSION_NUMBER = l_version_number + 1,
434: LOCK_CONTROL = l_lock_control + 1
435: WHERE HEADER_ID = p_header_id;
436:

Line 634: select version_number into l_version_number from oe_order_headers_all where header_id = l_header_id;

630: END IF;
631:
632: IF OE_ORDER_UTIL.g_old_header_rec.version_number IS NULL
633: OR OE_ORDER_UTIL.g_old_header_rec.version_number = FND_API.G_MISS_NUM THEN
634: select version_number into l_version_number from oe_order_headers_all where header_id = l_header_id;
635: ELSE
636: l_version_number := OE_ORDER_UTIL.g_old_header_rec.version_number;
637: END IF;
638: