DBA Data[Home] [Help]

APPS.OE_VERSIONING_UTIL dependencies on OE_ORDER_HEADERS_ALL

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

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

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

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

Line 447: FROM OE_ORDER_HEADERS_ALL

443: END IF;
444: --End of Addition for Bug# 14084432
445: SELECT LOCK_CONTROL
446: INTO l_lock_control
447: FROM OE_ORDER_HEADERS_ALL
448: WHERE HEADER_ID = p_header_id;
449:
450: IF OE_ORDER_UTIL.G_HEADER_REC.VERSION_NUMBER = OE_ORDER_UTIL.G_OLD_HEADER_REC.VERSION_NUMBER
451: OR OE_ORDER_UTIL.G_HEADER_REC.VERSION_NUMBER IS NULL

Line 455: UPDATE OE_ORDER_HEADERS_ALL

451: OR OE_ORDER_UTIL.G_HEADER_REC.VERSION_NUMBER IS NULL
452: OR OE_ORDER_UTIL.G_HEADER_REC.VERSION_NUMBER = FND_API.G_MISS_NUM
453: OR OE_ORDER_UTIL.G_OLD_HEADER_REC.VERSION_NUMBER IS NULL
454: OR OE_ORDER_UTIL.G_OLD_HEADER_REC.VERSION_NUMBER = FND_API.G_MISS_NUM THEN
455: UPDATE OE_ORDER_HEADERS_ALL
456: SET VERSION_NUMBER = l_version_number + 1,
457: LOCK_CONTROL = l_lock_control + 1
458: WHERE HEADER_ID = p_header_id;
459:

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

653: END IF;
654:
655: IF OE_ORDER_UTIL.g_old_header_rec.version_number IS NULL
656: OR OE_ORDER_UTIL.g_old_header_rec.version_number = FND_API.G_MISS_NUM THEN
657: select version_number into l_version_number from oe_order_headers_all where header_id = l_header_id;
658: ELSE
659: l_version_number := OE_ORDER_UTIL.g_old_header_rec.version_number;
660: END IF;
661: