APPS.OE_XML_PROCESS_UTIL dependencies on OE_HEADER_ACKS

Line 734: Delete from OE_HEADER_ACKS

730: oe_debug_pub.add( 'CUSTOMER KEY PROFILE SETTING = '||l_customer_key_profile ) ;
731: END IF;
732: End If;
733:
734: Delete from OE_HEADER_ACKS
735: Where orig_sys_document_ref = p_orig_sys_document_ref
736: And acknowledgment_type = p_ack_type
737: And decode(l_customer_key_profile, 'Y',
738: nvl(sold_to_org_id, -999), 1)

Line 745: oe_debug_pub.add( 'DELETED OE_HEADER_ACKS ENTRIES FOR ORIG_SYS_DOCUMENT_REF => ' || P_ORIG_SYS_DOCUMENT_REF ||

741: And nvl(change_sequence, ' ')
742: = nvl(p_change_sequence, ' ')
743: And request_id = p_request_id;
744: IF l_debug_level > 0 THEN
745: oe_debug_pub.add( 'DELETED OE_HEADER_ACKS ENTRIES FOR ORIG_SYS_DOCUMENT_REF => ' || P_ORIG_SYS_DOCUMENT_REF ||
746: ' AND ACKNOWLEDGMENT_TYPE => ' || P_ACK_TYPE || ' AND REQUEST_ID => ' || P_REQUEST_ID ||
747: ' AND SOLD_TO_ORG_ID => ' || P_SOLD_TO_ORG_ID ||
748: ' AND CHANGE_SEQUENCE => ' || P_CHANGE_SEQUENCE);
749: END IF;