DBA Data[Home] [Help]

APPS.OE_LOTS_ACK_UTIL dependencies on OE_LOTSERIAL_ACKS

Line 49: INSERT INTO OE_LOTSERIAL_ACKS

45: IF l_debug_level > 0 THEN
46: oe_debug_pub.add( 'BEFORE LOTSERIAL ACKNOWLEDGMENT INSERT STATEMENT' ) ;
47: END IF;
48:
49: INSERT INTO OE_LOTSERIAL_ACKS
50: ( ACKNOWLEDGMENT_FLAG
51: , ATTRIBUTE1
52: , ATTRIBUTE10
53: , ATTRIBUTE11

Line 178: DELETE FROM OE_LOTSERIAL_ACKS

174: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
175: --
176: BEGIN
177:
178: DELETE FROM OE_LOTSERIAL_ACKS
179: WHERE ORIG_SYS_DOCUMENT_REF = p_orig_sys_document_ref
180: AND CHANGE_SEQUENCE = p_change_sequence
181: AND CHANGE_DATE = p_change_date
182: AND ORIG_SYS_LINE_REF = p_orig_sys_line_ref