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 364: l_distribution_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE;

360:
361: l_return_status VARCHAR2(1);
362: l_msg_data VARCHAR2(2000);
363: l_msg_count NUMBER;
364: l_distribution_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE;
365:
366: --
367: l_transaction_line_rec_type ZX_API_PUB.transaction_line_rec_type;
368: l_distribution_type PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;

Line 368: l_distribution_type PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;

364: l_distribution_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE;
365:
366: --
367: l_transaction_line_rec_type ZX_API_PUB.transaction_line_rec_type;
368: l_distribution_type PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;
369: l_line_location_id PO_DISTRIBUTIONS_ALL.line_location_id%TYPE;
370: l_po_header_id PO_DISTRIBUTIONS_ALL.po_header_id%TYPE;
371: l_po_release_id PO_DISTRIBUTIONS_ALL.po_release_id%TYPE;
372: l_distribution_count NUMBER;

Line 369: l_line_location_id PO_DISTRIBUTIONS_ALL.line_location_id%TYPE;

365:
366: --
367: l_transaction_line_rec_type ZX_API_PUB.transaction_line_rec_type;
368: l_distribution_type PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;
369: l_line_location_id PO_DISTRIBUTIONS_ALL.line_location_id%TYPE;
370: l_po_header_id PO_DISTRIBUTIONS_ALL.po_header_id%TYPE;
371: l_po_release_id PO_DISTRIBUTIONS_ALL.po_release_id%TYPE;
372: l_distribution_count NUMBER;
373: l_org_id PO_DISTRIBUTIONS_ALL.org_id%type;

Line 370: l_po_header_id PO_DISTRIBUTIONS_ALL.po_header_id%TYPE;

366: --
367: l_transaction_line_rec_type ZX_API_PUB.transaction_line_rec_type;
368: l_distribution_type PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;
369: l_line_location_id PO_DISTRIBUTIONS_ALL.line_location_id%TYPE;
370: l_po_header_id PO_DISTRIBUTIONS_ALL.po_header_id%TYPE;
371: l_po_release_id PO_DISTRIBUTIONS_ALL.po_release_id%TYPE;
372: l_distribution_count NUMBER;
373: l_org_id PO_DISTRIBUTIONS_ALL.org_id%type;
374: --

Line 371: l_po_release_id PO_DISTRIBUTIONS_ALL.po_release_id%TYPE;

367: l_transaction_line_rec_type ZX_API_PUB.transaction_line_rec_type;
368: l_distribution_type PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;
369: l_line_location_id PO_DISTRIBUTIONS_ALL.line_location_id%TYPE;
370: l_po_header_id PO_DISTRIBUTIONS_ALL.po_header_id%TYPE;
371: l_po_release_id PO_DISTRIBUTIONS_ALL.po_release_id%TYPE;
372: l_distribution_count NUMBER;
373: l_org_id PO_DISTRIBUTIONS_ALL.org_id%type;
374: --
375:

Line 373: l_org_id PO_DISTRIBUTIONS_ALL.org_id%type;

369: l_line_location_id PO_DISTRIBUTIONS_ALL.line_location_id%TYPE;
370: l_po_header_id PO_DISTRIBUTIONS_ALL.po_header_id%TYPE;
371: l_po_release_id PO_DISTRIBUTIONS_ALL.po_release_id%TYPE;
372: l_distribution_count NUMBER;
373: l_org_id PO_DISTRIBUTIONS_ALL.org_id%type;
374: --
375:
376: BEGIN
377: DELETE FROM PO_DISTRIBUTIONS

Line 396: FROM po_distributions_all pd

392: IF l_distribution_type IN ('STANDARD','PLANNED','BLANKET','SCHEDULED') THEN
393:
394: -- count number of distributions
395: SELECT COUNT(1) INTO l_distribution_count
396: FROM po_distributions_all pd
397: WHERE pd.line_location_id=l_line_location_id;
398:
399: IF (l_distribution_count = 0) THEN -- there are no sibling distributions
400: