eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_DISTRIBUTIONS_PKG2 dependencies on PO_DISTRIBUTIONS_ALL

Line 612: l_distribution_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE;

608:
609: l_return_status VARCHAR2(1);
610: l_msg_data VARCHAR2(2000);
611: l_msg_count NUMBER;
612: l_distribution_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE;
613:
614: --
615: l_transaction_line_rec_type ZX_API_PUB.transaction_line_rec_type;
616: l_distribution_type PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;

Line 616: l_distribution_type PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;

612: l_distribution_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE;
613:
614: --
615: l_transaction_line_rec_type ZX_API_PUB.transaction_line_rec_type;
616: l_distribution_type PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;
617: l_line_location_id PO_DISTRIBUTIONS_ALL.line_location_id%TYPE;
618: l_po_header_id PO_DISTRIBUTIONS_ALL.po_header_id%TYPE;
619: l_po_release_id PO_DISTRIBUTIONS_ALL.po_release_id%TYPE;
620: l_distribution_count NUMBER;

Line 617: l_line_location_id PO_DISTRIBUTIONS_ALL.line_location_id%TYPE;

613:
614: --
615: l_transaction_line_rec_type ZX_API_PUB.transaction_line_rec_type;
616: l_distribution_type PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;
617: l_line_location_id PO_DISTRIBUTIONS_ALL.line_location_id%TYPE;
618: l_po_header_id PO_DISTRIBUTIONS_ALL.po_header_id%TYPE;
619: l_po_release_id PO_DISTRIBUTIONS_ALL.po_release_id%TYPE;
620: l_distribution_count NUMBER;
621: l_org_id PO_DISTRIBUTIONS_ALL.org_id%type;

Line 618: l_po_header_id PO_DISTRIBUTIONS_ALL.po_header_id%TYPE;

614: --
615: l_transaction_line_rec_type ZX_API_PUB.transaction_line_rec_type;
616: l_distribution_type PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;
617: l_line_location_id PO_DISTRIBUTIONS_ALL.line_location_id%TYPE;
618: l_po_header_id PO_DISTRIBUTIONS_ALL.po_header_id%TYPE;
619: l_po_release_id PO_DISTRIBUTIONS_ALL.po_release_id%TYPE;
620: l_distribution_count NUMBER;
621: l_org_id PO_DISTRIBUTIONS_ALL.org_id%type;
622: --

Line 619: l_po_release_id PO_DISTRIBUTIONS_ALL.po_release_id%TYPE;

615: l_transaction_line_rec_type ZX_API_PUB.transaction_line_rec_type;
616: l_distribution_type PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;
617: l_line_location_id PO_DISTRIBUTIONS_ALL.line_location_id%TYPE;
618: l_po_header_id PO_DISTRIBUTIONS_ALL.po_header_id%TYPE;
619: l_po_release_id PO_DISTRIBUTIONS_ALL.po_release_id%TYPE;
620: l_distribution_count NUMBER;
621: l_org_id PO_DISTRIBUTIONS_ALL.org_id%type;
622: --
623:

Line 621: l_org_id PO_DISTRIBUTIONS_ALL.org_id%type;

617: l_line_location_id PO_DISTRIBUTIONS_ALL.line_location_id%TYPE;
618: l_po_header_id PO_DISTRIBUTIONS_ALL.po_header_id%TYPE;
619: l_po_release_id PO_DISTRIBUTIONS_ALL.po_release_id%TYPE;
620: l_distribution_count NUMBER;
621: l_org_id PO_DISTRIBUTIONS_ALL.org_id%type;
622: --
623:
624: BEGIN
625: DELETE FROM PO_DISTRIBUTIONS

Line 644: FROM po_distributions_all pd

640: IF l_distribution_type IN ('STANDARD','PLANNED','BLANKET','SCHEDULED') THEN
641:
642: -- count number of distributions
643: SELECT COUNT(1) INTO l_distribution_count
644: FROM po_distributions_all pd
645: WHERE pd.line_location_id=l_line_location_id;
646:
647: IF (l_distribution_count = 0) THEN -- there are no sibling distributions
648: