DBA Data[Home] [Help]

APPS.PO_AP_INVOICE_MATCH_GRP dependencies on PO_DISTRIBUTIONS

Line 147: UPDATE po_distributions_all pod

143: -- SQL Where: For the distribution rows represented in p_dist_changes_rec
144: -- Also, for Scheduled Releases, update the information on the
145: -- backing Planned PO distribution row as well
146: FORALL i IN 1..p_dist_changes_rec.po_distribution_id_tbl.COUNT
147: UPDATE po_distributions_all pod
148: SET quantity_billed =
149: DECODE(p_dist_changes_rec.quantity_billed_tbl(i)
150: , NULL, quantity_billed
151: , nvl(quantity_billed, 0) + p_dist_changes_rec.quantity_billed_tbl(i)),

Line 188: FROM po_distributions pod2

184: WHERE pod.po_distribution_id = p_dist_changes_rec.po_distribution_id_tbl(i)
185: OR (pod.distribution_type = 'PLANNED'
186: AND pod.po_distribution_id =
187: (SELECT pod2.source_distribution_id
188: FROM po_distributions pod2
189: WHERE pod2.distribution_type = 'SCHEDULED'
190: AND pod2.po_distribution_id = p_dist_changes_rec.po_distribution_id_tbl(i)))
191: ;
192:

Line 539: p_po_distribution_id IN PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE,

535: --End of Comments
536: ----------------------------------------------------------------------------------------
537:
538: PROCEDURE get_po_dist_amounts (p_api_version IN NUMBER,
539: p_po_distribution_id IN PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE,
540: x_dist_amt_ordered OUT NOCOPY PO_DISTRIBUTIONS_ALL.amount_ordered%TYPE,
541: x_dist_amt_cancelled OUT NOCOPY PO_DISTRIBUTIONS_ALL.amount_cancelled%TYPE,
542: x_ret_status OUT NOCOPY VARCHAR2,
543: x_msg_count OUT NOCOPY NUMBER,

Line 540: x_dist_amt_ordered OUT NOCOPY PO_DISTRIBUTIONS_ALL.amount_ordered%TYPE,

536: ----------------------------------------------------------------------------------------
537:
538: PROCEDURE get_po_dist_amounts (p_api_version IN NUMBER,
539: p_po_distribution_id IN PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE,
540: x_dist_amt_ordered OUT NOCOPY PO_DISTRIBUTIONS_ALL.amount_ordered%TYPE,
541: x_dist_amt_cancelled OUT NOCOPY PO_DISTRIBUTIONS_ALL.amount_cancelled%TYPE,
542: x_ret_status OUT NOCOPY VARCHAR2,
543: x_msg_count OUT NOCOPY NUMBER,
544: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 541: x_dist_amt_cancelled OUT NOCOPY PO_DISTRIBUTIONS_ALL.amount_cancelled%TYPE,

537:
538: PROCEDURE get_po_dist_amounts (p_api_version IN NUMBER,
539: p_po_distribution_id IN PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE,
540: x_dist_amt_ordered OUT NOCOPY PO_DISTRIBUTIONS_ALL.amount_ordered%TYPE,
541: x_dist_amt_cancelled OUT NOCOPY PO_DISTRIBUTIONS_ALL.amount_cancelled%TYPE,
542: x_ret_status OUT NOCOPY VARCHAR2,
543: x_msg_count OUT NOCOPY NUMBER,
544: x_msg_data OUT NOCOPY VARCHAR2) IS
545:

Line 560: -- SQL What : Gets the amountordered and amount cancelled on the PO distributions

556: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN
557: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
558: END IF;
559:
560: -- SQL What : Gets the amountordered and amount cancelled on the PO distributions
561: -- corresponding to the distribution id passed
562: -- SQL Why : These amounts are used for amount based matching of invoices
563:
564: SELECT pod.amount_ordered,

Line 568: FROM po_distributions pod

564: SELECT pod.amount_ordered,
565: pod.amount_cancelled
566: INTO x_dist_amt_ordered,
567: x_dist_amt_cancelled
568: FROM po_distributions pod
569: WHERE pod.po_distribution_id = p_po_distribution_id;
570:
571: EXCEPTION
572: WHEN OTHERS THEN

Line 652: --Modifies: PO_DISTRIBUTIONS_ALL

648: --Name: update_po_dist_amounts
649: --
650: --Pre-reqs: None
651: --
652: --Modifies: PO_DISTRIBUTIONS_ALL
653: --
654: --Locks: None
655: --
656: --Function: This procedure updates the amount billed on po distributions during amount matching process

Line 656: --Function: This procedure updates the amount billed on po distributions during amount matching process

652: --Modifies: PO_DISTRIBUTIONS_ALL
653: --
654: --Locks: None
655: --
656: --Function: This procedure updates the amount billed on po distributions during amount matching process
657: --
658: --
659: --Parameters:
660: --IN:

Line 683: p_po_distribution_id IN PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE,

679: --End of Comments
680: -------------------------------------------------------------------------------------------------------
681:
682: PROCEDURE update_po_dist_amounts (p_api_version IN NUMBER,
683: p_po_distribution_id IN PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE,
684: p_dist_amt_billed IN PO_DISTRIBUTIONS_ALL.amount_billed%TYPE,
685: x_ret_status OUT NOCOPY VARCHAR2,
686: x_msg_count OUT NOCOPY NUMBER,
687: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 684: p_dist_amt_billed IN PO_DISTRIBUTIONS_ALL.amount_billed%TYPE,

680: -------------------------------------------------------------------------------------------------------
681:
682: PROCEDURE update_po_dist_amounts (p_api_version IN NUMBER,
683: p_po_distribution_id IN PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE,
684: p_dist_amt_billed IN PO_DISTRIBUTIONS_ALL.amount_billed%TYPE,
685: x_ret_status OUT NOCOPY VARCHAR2,
686: x_msg_count OUT NOCOPY NUMBER,
687: x_msg_data OUT NOCOPY VARCHAR2) IS
688:

Line 706: UPDATE po_distributions_all

702:
703: -- SQL What : Updates the amount billed on the po distribution
704: -- SQL Why : This is the amount that was billed against this distribution
705:
706: UPDATE po_distributions_all
707: SET amount_billed = nvl(amount_billed,0) + nvl(p_dist_amt_billed,0)
708: WHERE po_distribution_id = p_po_distribution_id;
709:
710: EXCEPTION

Line 735: -- Possible values: PO_HEADERS, PO_LINES, PO_LINE_LOCATIONS, PO_DISTRIBUTIONS

731: --IN:
732: -- p_api_version
733: -- Specifies the version of the api. Value that needs to be passed in is 1.0
734: -- p_entity_type
735: -- Possible values: PO_HEADERS, PO_LINES, PO_LINE_LOCATIONS, PO_DISTRIBUTIONS
736: -- PO_LINE_LOCATIONS only supported currently.
737: -- p_entity_id_tbl
738: -- This will have one or more ids that you want to set the final match flag value.
739: -- p_final_match_flag