APPS.OE_ACKNOWLEDGMENT_PUB dependencies on OE_HEADER_ACKS

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

776: End If;
777:
778:
779:
780: Insert Into OE_HEADER_ACKS (header_id, acknowledgment_type, last_ack_code, request_id, sold_to_org_id, change_sequence)
781: Values (p_header_rec.header_id, p_ack_type, l_header_status, p_itemkey, --p_header_rec.request_id
782: p_header_rec.sold_to_org_id, p_header_rec.change_sequence);
783:
784: if sql%rowcount > 0 then

Line 1327: from oe_header_acks

1323: If p_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_PROC Then
1324:
1325: Select last_ack_code
1326: into l_header_last_ack_code
1327: from oe_header_acks
1328: where acknowledgment_type = p_transaction_type
1329: and header_id = l_header_id
1330: and request_id = l_request_id;
1331: