DBA Data[Home] [Help]

APPS.INV_RCV_INTEGRATION_PVT dependencies on PO_REQ_DISTRIBUTIONS_ALL

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

4875: WHEN no_data_found THEN
4876: l_project_id := NULL;
4877: l_task_id := NULL;
4878: END;
4879: -- Bug# 7154105 Picking up the Praject and Task from po_req_distributions_all when
4880: -- a distribution is specified in the Internal Requisition. There can be just one
4881: -- distribution for internally sourced documents
4882: ELSIF p_req_distribution_id IS NOT NULL THEN
4883: BEGIN

Line 4886: from po_req_distributions_all

4882: ELSIF p_req_distribution_id IS NOT NULL THEN
4883: BEGIN
4884: select project_id, task_id
4885: into l_project_id, l_task_id
4886: from po_req_distributions_all
4887: where distribution_id = p_req_distribution_id;
4888:
4889: 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);
4890: EXCEPTION