APPS.OE_XML_PROCESS_UTIL dependencies on OE_LINE_ACKS

Line 752: Delete from OE_LINE_ACKS

748: ' AND CHANGE_SEQUENCE => ' || P_CHANGE_SEQUENCE);
749: END IF;
750:
751:
752: Delete from OE_LINE_ACKS
753: Where orig_sys_document_ref = p_orig_sys_document_ref
754: And acknowledgment_type = p_ack_type
755: And decode(l_customer_key_profile, 'Y',
756: nvl(sold_to_org_id, -999), 1)

Line 763: oe_debug_pub.add( 'DELETED OE_LINE_ACKS ENTRIES FOR ORIG_SYS_DOCUMENT_REF => ' || P_ORIG_SYS_DOCUMENT_REF ||

759: And nvl(change_sequence, ' ')
760: = nvl(p_change_sequence, ' ')
761: And request_id = p_request_id;
762: IF l_debug_level > 0 THEN
763: oe_debug_pub.add( 'DELETED OE_LINE_ACKS ENTRIES FOR ORIG_SYS_DOCUMENT_REF => ' || P_ORIG_SYS_DOCUMENT_REF ||
764: ' AND ACKNOWLEDGMENT_TYPE => ' || P_ACK_TYPE || ' AND REQUEST_ID => ' || P_REQUEST_ID ||
765: ' AND SOLD_TO_ORG_ID => ' || P_SOLD_TO_ORG_ID ||
766: ' AND CHANGE_SEQUENCE => ' || P_CHANGE_SEQUENCE);
767: END IF;