[Home] [Help]
753: x_progress :='0'||l_return_status;
754: if(l_return_status<>FND_API.G_RET_STS_SUCCESS) then
755: raise g_update_data_exp;
756: end if;
757: update po_req_distributions_all
758: set req_line_quantity=p_new_quantity,
759: req_line_amount = p_new_dist_amount,
760: req_line_currency_amount = p_new_currency_dist_amount,
761: recoverable_tax=l_recoverable_tax,
801: l_return_status varchar2(1);
802:
803: cursor l_distributions_csr is
804: select distribution_id
805: from po_req_distributions_all
806: where requisition_line_id=p_req_line_id;
807:
808: begin
809:
827: end if;
828:
829: x_progress :='002-'||to_char(l_distributions_id);
830:
831: update po_req_distributions_all
832: set recoverable_tax=l_recoverable_tax,
833: nonrecoverable_tax=l_nonrecoverable_tax
834: where distribution_id=l_distributions_id;
835: x_progress :='003-'||to_char(l_distributions_id);
1757:
1758:
1759: cursor update_allocation_csr is
1760: select pcr.document_line_id, nvl(sum(pcr.new_amount),sum(pcr.new_quantity))
1761: from po_req_distributions_all prd,
1762: po_change_requests pcr
1763: where pcr.document_distribution_id=prd.DISTRIBUTION_ID
1764: and pcr.change_request_id in
1765: (select parent_change_request_id
2508: open update_allocation_csr ;
2509: fetch update_allocation_csr into l_document_line_id,l_total;
2510: --bug 13917584 starts
2511: IF(update_allocation_csr%FOUND) THEN
2512: update po_req_distributions_all
2513: set ALLOCATION_VALUE= (nvl(REQ_LINE_AMOUNT,REQ_LINE_QUANTITY)/l_total)*100
2514: where ALLOCATION_TYPE='PERCENT'
2515: and REQUISITION_LINE_ID=l_document_line_id;
2516: END IF;
3210: po_requisition_lines_all prl,
3211: po_headers_all poh,
3212: po_releases_all por,
3213: po_distributions_all pod,
3214: po_req_distributions_all prd,
3215: po_lines_all pol
3216: where pcr.change_request_group_id=l_change_request_group_id
3217: and pcr.request_status='MGR_APP'
3218: and pcr.document_distribution_id is not null
4702: -- get old tax and tax dsp
4703: SELECT nvl(sum(nonrecoverable_tax), 0)
4704: into l_tax_amount
4705: FROM po_requisition_lines_all rl,
4706: po_req_distributions_all rd
4707: WHERE rl.requisition_header_id = l_req_header_id
4708: AND rd.requisition_line_id = rl.requisition_line_id
4709: AND NVL(rl.cancel_flag,'N') = 'N'
4710: AND NVL(rl.modified_by_agent_flag, 'N') = 'N';
6524: nvl(pcr1.new_price, prl.unit_price)*
6525: nvl(pcr2.new_quantity,prd.req_line_quantity))), 0)
6526: into l_new_tax_amount, l_new_req_amount
6527: from po_requisition_lines_all prl,
6528: po_req_distributions_all prd,
6529: po_change_requests pcr1,
6530: po_change_requests pcr2
6531: where prl.requisition_line_id=pcr1.document_line_id(+)
6532: and pcr1.change_request_group_id(+)=l_change_request_group_id
8084: -- standard code
8085: SELECT nvl(sum(nvl(nonrecoverable_tax, 0)), 0)
8086: INTO l_new_tax_currency
8087: FROM po_requisition_lines_all rl,
8088: po_req_distributions_all rd
8089: WHERE rl.requisition_header_id = l_document_id
8090: AND rd.requisition_line_id = rl.requisition_line_id
8091: AND NVL(rl.modified_by_agent_flag, 'N') = 'N'
8092: and NVL(rl.cancel_flag, 'N')='N';
8246: --Standard Code
8247: SELECT nvl(sum(nonrecoverable_tax), 0)
8248: into l_tax_amount
8249: FROM po_requisition_lines_all rl,
8250: po_req_distributions_all rd
8251: WHERE rl.requisition_header_id = l_document_id
8252: AND rd.requisition_line_id = rl.requisition_line_id
8253: AND NVL(rl.cancel_flag,'N') = 'N'
8254: AND NVL(rl.modified_by_agent_flag, 'N') = 'N';
12492:
12493: l_req_dist_id number;
12494: CURSOR l_changed_req_dists_csr(req_line_id NUMBER) IS
12495: select DISTRIBUTION_ID
12496: from PO_REQ_DISTRIBUTIONS_ALL
12497: where REQUISITION_LINE_ID= req_line_id;
12498: -- this is inventory line and hence shall select one dist
12499:
12500: CURSOR l_dist_tax_csr(req_line_id NUMBER) IS
12502: prda.distribution_id,
12503: prla.unit_price,
12504: prla.quantity
12505: FROM
12506: po_req_distributions_all prda,
12507: po_requisition_lines_all prla
12508: WHERE
12509: prla.requisition_line_id = req_line_id AND
12510: prla.requisition_line_id = prda.requisition_line_id;
12703:
12704: l_progress := '013';
12705:
12706: -- only one distribution to one internal req line
12707: UPDATE po_req_distributions_all
12708: SET req_line_quantity = req_line_quantity + p_delta_quantity
12709: WHERE requisition_line_id = p_req_line_id ;
12710:
12711: l_progress := '014';
13361: l_prim_uom_cde MTL_SYSTEM_ITEMS_B.PRIMARY_UOM_CODE%TYPE;
13362: l_sec_uom_code MTL_SYSTEM_ITEMS_B.SECONDARY_UOM_CODE%TYPE;
13363: CURSOR l_changed_req_dists_csr(req_line_id NUMBER) IS
13364: select DISTRIBUTION_ID
13365: from PO_REQ_DISTRIBUTIONS_ALL
13366: where REQUISITION_LINE_ID= req_line_id;
13367: -- this is inventory line and hence shall select one dist
13368:
13369: CURSOR l_dist_tax_csr(req_line_id NUMBER) IS
13371: prda.distribution_id,
13372: prla.unit_price,
13373: prla.quantity
13374: FROM
13375: po_req_distributions_all prda,
13376: po_requisition_lines_all prla
13377: WHERE
13378: prla.requisition_line_id = req_line_id AND
13379: prla.requisition_line_id = prda.requisition_line_id;
13618: WHERE requisition_line_id = p_req_line_id ;
13619:
13620: l_progress := '017';
13621: -- only one distribution to one internal req line
13622: UPDATE po_req_distributions_all
13623: SET req_line_quantity = req_line_quantity + p_delta_prim_quantity
13624: WHERE requisition_line_id = p_req_line_id ;
13625:
13626: l_progress := '018';