DBA Data[Home] [Help]

APPS.INV_RCV_INTEGRATION_PVT dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 4792: -- Bug# 7154105 Picking up the Praject and Task from po_req_distributions_all when

4788: WHEN no_data_found THEN
4789: l_project_id := NULL;
4790: l_task_id := NULL;
4791: END;
4792: -- Bug# 7154105 Picking up the Praject and Task from po_req_distributions_all when
4793: -- a distribution is specified in the Internal Requisition. There can be just one
4794: -- distribution for internally sourced documents
4795: ELSIF p_req_distribution_id IS NOT NULL THEN
4796: BEGIN

Line 4799: from po_req_distributions_all

4795: ELSIF p_req_distribution_id IS NOT NULL THEN
4796: BEGIN
4797: select project_id, task_id
4798: into l_project_id, l_task_id
4799: from po_req_distributions_all
4800: where distribution_id = p_req_distribution_id;
4801:
4802: print_debug('MAINTAIN_MOC_CON - Proj Task Pickup for distributions: Project: '||l_project_id || ' Task : ' ||l_task_id || ' Distibution_id : ' ||p_req_distribution_id,1);
4803: EXCEPTION