[Home] [Help]
2546: IF p_revision is not NULL THEN
2547: l_rsv_new.revision := p_revision;
2548: END IF;
2549:
2550: /*Bug 3020166 Assigning p_lpn_id got from rcv_transactions to the lpn_id in the
2551: record type */
2552: IF p_lpn_id is not NULL THEN
2553: l_rsv_new.lpn_id := p_lpn_id;
2554: END IF;
3440: FROM po_distributions_all --
3441: WHERE po_release_id = v_po_header_id;
3442:
3443: CURSOR get_source_doc_code (v_transaction_id IN NUMBER) IS
3444: SELECT source_document_code, organization_id FROM rcv_transactions
3445: WHERE transaction_id = v_transaction_id;
3446:
3447: CURSOR get_rcv_transaction (v_transaction_id IN NUMBER) IS
3448: SELECT decode(a.source_document_code,'PO'
3466: , b.item_id
3467: , b.to_organization_id
3468: , c.project_id
3469: , c.task_id
3470: FROM rcv_transactions a
3471: , rcv_shipment_lines b
3472: , po_distributions_all c
3473: , mtl_units_of_measure d
3474: WHERE transaction_id = v_transaction_id
3514: , b.item_id
3515: , b.to_organization_id
3516: , c.project_id
3517: , c.task_id
3518: FROM rcv_transactions a
3519: , rcv_shipment_lines b
3520: , po_distributions_all c
3521: , mtl_units_of_measure d
3522: WHERE a.transaction_id = v_transaction_id
3549: , b.to_organization_id
3550: , c.project_id
3551: , c.task_id
3552: , d.requisition_header_id
3553: FROM rcv_transactions a
3554: , rcv_shipment_lines b
3555: , po_req_distributions_all c
3556: , po_requisition_lines_all d
3557: , mtl_units_of_measure e
3563: AND d.requisition_line_id = c.requisition_line_id
3564: AND e.unit_of_measure = a.primary_unit_of_measure;
3565:
3566:
3567: --are we sure the req_distribution_id is populated in rcv_transactions ???
3568:
3569: -- Define Constants for API version and API name
3570: C_api_version_number CONSTANT NUMBER := 1.0;
3571: C_api_name CONSTANT VARCHAR2(30) := 'Maintain_Reservation';