[Home] [Help]
141: -- SQL Where: For the distribution rows represented in p_dist_changes_rec
142: -- Also, for Scheduled Releases, update the information on the
143: -- backing Planned PO distribution row as well
144: FORALL i IN 1..p_dist_changes_rec.po_distribution_id_tbl.COUNT
145: UPDATE po_distributions_all pod
146: SET quantity_billed =
147: DECODE(p_dist_changes_rec.quantity_billed_tbl(i)
148: , NULL, quantity_billed
149: , nvl(quantity_billed, 0) + p_dist_changes_rec.quantity_billed_tbl(i)),
180: WHERE pod.po_distribution_id = p_dist_changes_rec.po_distribution_id_tbl(i)
181: OR (pod.distribution_type = 'PLANNED'
182: AND pod.po_distribution_id =
183: (SELECT pod2.source_distribution_id
184: FROM po_distributions pod2
185: WHERE pod2.distribution_type = 'SCHEDULED'
186: AND pod2.po_distribution_id = p_dist_changes_rec.po_distribution_id_tbl(i)))
187: ;
188:
479: --End of Comments
480: ----------------------------------------------------------------------------------------
481:
482: PROCEDURE get_po_dist_amounts (p_api_version IN NUMBER,
483: p_po_distribution_id IN PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE,
484: x_dist_amt_ordered OUT NOCOPY PO_DISTRIBUTIONS_ALL.amount_ordered%TYPE,
485: x_dist_amt_cancelled OUT NOCOPY PO_DISTRIBUTIONS_ALL.amount_cancelled%TYPE,
486: x_ret_status OUT NOCOPY VARCHAR2,
487: x_msg_count OUT NOCOPY NUMBER,
480: ----------------------------------------------------------------------------------------
481:
482: PROCEDURE get_po_dist_amounts (p_api_version IN NUMBER,
483: p_po_distribution_id IN PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE,
484: x_dist_amt_ordered OUT NOCOPY PO_DISTRIBUTIONS_ALL.amount_ordered%TYPE,
485: x_dist_amt_cancelled OUT NOCOPY PO_DISTRIBUTIONS_ALL.amount_cancelled%TYPE,
486: x_ret_status OUT NOCOPY VARCHAR2,
487: x_msg_count OUT NOCOPY NUMBER,
488: x_msg_data OUT NOCOPY VARCHAR2) IS
481:
482: PROCEDURE get_po_dist_amounts (p_api_version IN NUMBER,
483: p_po_distribution_id IN PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE,
484: x_dist_amt_ordered OUT NOCOPY PO_DISTRIBUTIONS_ALL.amount_ordered%TYPE,
485: x_dist_amt_cancelled OUT NOCOPY PO_DISTRIBUTIONS_ALL.amount_cancelled%TYPE,
486: x_ret_status OUT NOCOPY VARCHAR2,
487: x_msg_count OUT NOCOPY NUMBER,
488: x_msg_data OUT NOCOPY VARCHAR2) IS
489:
500: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN
501: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
502: END IF;
503:
504: -- SQL What : Gets the amountordered and amount cancelled on the PO distributions
505: -- corresponding to the distribution id passed
506: -- SQL Why : These amounts are used for amount based matching of invoices
507:
508: SELECT pod.amount_ordered,
508: SELECT pod.amount_ordered,
509: pod.amount_cancelled
510: INTO x_dist_amt_ordered,
511: x_dist_amt_cancelled
512: FROM po_distributions pod
513: WHERE pod.po_distribution_id = p_po_distribution_id;
514:
515: EXCEPTION
516: WHEN OTHERS THEN
592: --Name: update_po_dist_amounts
593: --
594: --Pre-reqs: None
595: --
596: --Modifies: PO_DISTRIBUTIONS_ALL
597: --
598: --Locks: None
599: --
600: --Function: This procedure updates the amount billed on po distributions during amount matching process
596: --Modifies: PO_DISTRIBUTIONS_ALL
597: --
598: --Locks: None
599: --
600: --Function: This procedure updates the amount billed on po distributions during amount matching process
601: --
602: --
603: --Parameters:
604: --IN:
623: --End of Comments
624: -------------------------------------------------------------------------------------------------------
625:
626: PROCEDURE update_po_dist_amounts (p_api_version IN NUMBER,
627: p_po_distribution_id IN PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE,
628: p_dist_amt_billed IN PO_DISTRIBUTIONS_ALL.amount_billed%TYPE,
629: x_ret_status OUT NOCOPY VARCHAR2,
630: x_msg_count OUT NOCOPY NUMBER,
631: x_msg_data OUT NOCOPY VARCHAR2) IS
624: -------------------------------------------------------------------------------------------------------
625:
626: PROCEDURE update_po_dist_amounts (p_api_version IN NUMBER,
627: p_po_distribution_id IN PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE,
628: p_dist_amt_billed IN PO_DISTRIBUTIONS_ALL.amount_billed%TYPE,
629: x_ret_status OUT NOCOPY VARCHAR2,
630: x_msg_count OUT NOCOPY NUMBER,
631: x_msg_data OUT NOCOPY VARCHAR2) IS
632:
646:
647: -- SQL What : Updates the amount billed on the po distribution
648: -- SQL Why : This is the amount that was billed against this distribution
649:
650: UPDATE po_distributions_all
651: SET amount_billed = nvl(amount_billed,0) + nvl(p_dist_amt_billed,0)
652: WHERE po_distribution_id = p_po_distribution_id;
653:
654: EXCEPTION
675: --IN:
676: -- p_api_version
677: -- Specifies the version of the api. Value that needs to be passed in is 1.0
678: -- p_entity_type
679: -- Possible values: PO_HEADERS, PO_LINES, PO_LINE_LOCATIONS, PO_DISTRIBUTIONS
680: -- PO_LINE_LOCATIONS only supported currently.
681: -- p_entity_id_tbl
682: -- This will have one or more ids that you want to set the final match flag value.
683: -- p_final_match_flag