[Home] [Help]
2560: IF p_revision is not NULL THEN
2561: l_rsv_new.revision := p_revision;
2562: END IF;
2563:
2564: /*Bug 3020166 Assigning p_lpn_id got from rcv_transactions to the lpn_id in the
2565: record type */
2566: IF p_lpn_id is not NULL THEN
2567: l_rsv_new.lpn_id := p_lpn_id;
2568: END IF;
3439: FROM po_distributions_all --
3440: WHERE po_release_id = v_po_header_id;
3441:
3442: CURSOR get_source_doc_code (v_transaction_id IN NUMBER) IS
3443: SELECT source_document_code, organization_id FROM rcv_transactions
3444: WHERE transaction_id = v_transaction_id;
3445:
3446: CURSOR get_rcv_transaction (v_transaction_id IN NUMBER) IS
3447: SELECT decode(a.source_document_code,'PO'
3463: , b.item_id
3464: , b.to_organization_id
3465: , c.project_id
3466: , c.task_id
3467: FROM rcv_transactions a
3468: , rcv_shipment_lines b
3469: , po_distributions_all c
3470: , mtl_units_of_measure d
3471: WHERE transaction_id = v_transaction_id
3507: , b.item_id
3508: , b.to_organization_id
3509: , c.project_id
3510: , c.task_id
3511: FROM rcv_transactions a
3512: , rcv_shipment_lines b
3513: , po_distributions_all c
3514: , mtl_units_of_measure d
3515: WHERE a.transaction_id = v_transaction_id
3538: , b.to_organization_id
3539: , c.project_id
3540: , c.task_id
3541: , d.requisition_header_id
3542: FROM rcv_transactions a
3543: , rcv_shipment_lines b
3544: , po_req_distributions_all c
3545: , po_requisition_lines_all d
3546: , mtl_units_of_measure e
3552: AND d.requisition_line_id = c.requisition_line_id
3553: AND e.unit_of_measure = a.primary_unit_of_measure;
3554:
3555:
3556: --are we sure the req_distribution_id is populated in rcv_transactions ???
3557:
3558: -- Define Constants for API version and API name
3559: C_api_version_number CONSTANT NUMBER := 1.0;
3560: C_api_name CONSTANT VARCHAR2(30) := 'Maintain_Reservation';