APPS.OE_ACKNOWLEDGMENT_PUB dependencies on OE_HEADER_ACKS

Line 775: Insert Into OE_HEADER_ACKS (header_id, acknowledgment_type, last_ack_code, request_id, sold_to_org_id, change_sequence)

771: End If;
772:
773:
774:
775: Insert Into OE_HEADER_ACKS (header_id, acknowledgment_type, last_ack_code, request_id, sold_to_org_id, change_sequence)
776: Values (p_header_rec.header_id, p_ack_type, l_header_status, p_itemkey, --p_header_rec.request_id
777: p_header_rec.sold_to_org_id, p_header_rec.change_sequence);
778:
779: if sql%rowcount > 0 then

Line 1322: from oe_header_acks

1318: If p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_PROC Then
1319:
1320: Select last_ack_code
1321: into l_header_last_ack_code
1322: from oe_header_acks
1323: where acknowledgment_type = p_transaction_type
1324: and header_id = l_header_id
1325: and request_id = l_request_id;
1326: