[Home] [Help]
736: x_progress :='0'||l_return_status;
737: if(l_return_status<>FND_API.G_RET_STS_SUCCESS) then
738: raise g_update_data_exp;
739: end if;
740: update po_req_distributions_all
741: set req_line_quantity=p_new_quantity,
742: req_line_amount = p_new_dist_amount,
743: req_line_currency_amount = p_new_currency_dist_amount,
744: recoverable_tax=l_recoverable_tax,
784: l_return_status varchar2(1);
785:
786: cursor l_distributions_csr is
787: select distribution_id
788: from po_req_distributions_all
789: where requisition_line_id=p_req_line_id;
790:
791: begin
792:
810: end if;
811:
812: x_progress :='002-'||to_char(l_distributions_id);
813:
814: update po_req_distributions_all
815: set recoverable_tax=l_recoverable_tax,
816: nonrecoverable_tax=l_nonrecoverable_tax
817: where distribution_id=l_distributions_id;
818: x_progress :='003-'||to_char(l_distributions_id);
3079: po_requisition_lines_all prl,
3080: po_headers_all poh,
3081: po_releases_all por,
3082: po_distributions_all pod,
3083: po_req_distributions_all prd,
3084: po_lines_all pol
3085: where pcr.change_request_group_id=l_change_request_group_id
3086: and pcr.request_status='MGR_APP'
3087: and pcr.document_distribution_id is not null
4528: -- get old tax and tax dsp
4529: SELECT nvl(sum(nonrecoverable_tax), 0)
4530: into l_tax_amount
4531: FROM po_requisition_lines_all rl,
4532: po_req_distributions_all rd
4533: WHERE rl.requisition_header_id = l_req_header_id
4534: AND rd.requisition_line_id = rl.requisition_line_id
4535: AND NVL(rl.cancel_flag,'N') = 'N'
4536: AND NVL(rl.modified_by_agent_flag, 'N') = 'N';
6305: nvl(pcr1.new_price, prl.unit_price)*
6306: nvl(pcr2.new_quantity,prd.req_line_quantity))), 0)
6307: into l_new_tax_amount, l_new_req_amount
6308: from po_requisition_lines_all prl,
6309: po_req_distributions_all prd,
6310: po_change_requests pcr1,
6311: po_change_requests pcr2
6312: where prl.requisition_line_id=pcr1.document_line_id(+)
6313: and pcr1.change_request_group_id(+)=l_change_request_group_id
7814:
7815: SELECT nvl(sum(nvl(nonrecoverable_tax, 0)), 0)
7816: INTO l_new_tax_currency
7817: FROM po_requisition_lines_all rl,
7818: po_req_distributions_all rd
7819: WHERE rl.requisition_header_id = l_document_id
7820: AND rd.requisition_line_id = rl.requisition_line_id
7821: AND NVL(rl.modified_by_agent_flag, 'N') = 'N'
7822: and NVL(rl.cancel_flag, 'N')='N';
7947: -- get new tax and tax disp
7948: SELECT nvl(sum(nonrecoverable_tax), 0)
7949: into l_tax_amount
7950: FROM po_requisition_lines_all rl,
7951: po_req_distributions_all rd
7952: WHERE rl.requisition_header_id = l_document_id
7953: AND rd.requisition_line_id = rl.requisition_line_id
7954: AND NVL(rl.cancel_flag,'N') = 'N'
7955: AND NVL(rl.modified_by_agent_flag, 'N') = 'N';
12053:
12054: l_req_dist_id number;
12055: CURSOR l_changed_req_dists_csr(req_line_id NUMBER) IS
12056: select DISTRIBUTION_ID
12057: from PO_REQ_DISTRIBUTIONS_ALL
12058: where REQUISITION_LINE_ID= req_line_id;
12059: -- this is inventory line and hence shall select one dist
12060:
12061: CURSOR l_dist_tax_csr(req_line_id NUMBER) IS
12063: prda.distribution_id,
12064: prla.unit_price,
12065: prla.quantity
12066: FROM
12067: po_req_distributions_all prda,
12068: po_requisition_lines_all prla
12069: WHERE
12070: prla.requisition_line_id = req_line_id AND
12071: prla.requisition_line_id = prda.requisition_line_id;
12263:
12264: l_progress := '013';
12265:
12266: -- only one distribution to one internal req line
12267: UPDATE po_req_distributions_all
12268: SET req_line_quantity = req_line_quantity + p_delta_quantity
12269: WHERE requisition_line_id = p_req_line_id ;
12270:
12271: l_progress := '014';