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_SV dependencies on PO_DISTRIBUTIONS

Line 1: PACKAGE BODY PO_DISTRIBUTIONS_SV AS

1: PACKAGE BODY PO_DISTRIBUTIONS_SV AS
2: /* $Header: POXPOD1B.pls 120.4 2007/12/04 09:25:43 bisdas ship $ */
3:
4: /*===========================================================================
5:

Line 99: FROM po_distributions

95: INTO l_dummy
96: FROM dual
97: WHERE NOT EXISTS
98: ( SELECT 1
99: FROM po_distributions
100: WHERE line_location_id = p_line_location_id
101: AND distribution_num = p_distribution_num
102: AND (rowid <> p_rowid
103: OR p_rowid IS NULL));

Line 130: from po_distributions

126: max_dist_num NUMBER;
127:
128: cursor C1 is
129: select nvl(max(distribution_num),0)
130: from po_distributions
131: where line_location_id = x_line_location_id;
132:
133: BEGIN
134: x_progress := '001';

Line 166: from po_distributions pod,

162:
163: select nvl(sum(decode(pol.order_type_lookup_code,'RATE',pod.amount_ordered,
164: 'FIXED PRICE',pod.amount_ordered,pod.quantity_ordered)),0)
165: into x_total
166: from po_distributions pod,
167: po_lines pol
168: where pod.po_line_id = pol.po_line_id
169: and pod.line_location_id = x_line_location_id;
170:

Line 407: delete po_distributions_all /Bug6632095: using base table instead of view /

403:
404: x_progress := '010';
405: IF (X_delete_entity = 'RELEASE') THEN
406:
407: delete po_distributions_all /*Bug6632095: using base table instead of view */
408: where line_location_id in
409: (select line_location_id
410: from po_line_locations_all
411: where po_release_id = x_delete_id);

Line 415: delete po_distributions

411: where po_release_id = x_delete_id);
412:
413: ELSIF (X_delete_entity = 'SHIPMENT') THEN
414:
415: delete po_distributions
416: where line_location_id = x_delete_id;
417:
418: ELSIF (X_delete_entity = 'LINE') THEN
419:

Line 420: delete po_distributions

416: where line_location_id = x_delete_id;
417:
418: ELSIF (X_delete_entity = 'LINE') THEN
419:
420: delete po_distributions
421: where line_location_id in
422: (select line_location_id
423: from po_line_locations
424: where po_line_id = x_delete_id

Line 432: DELETE PO_DISTRIBUTIONS_ALL /Bug6632095: using base table instead of view /

428:
429: --
430: --We can have encumbrance distributions tied to a BPA header.
431: --Allow distributions with distribution_type 'AGREEMENT' to be deleted.
432: DELETE PO_DISTRIBUTIONS_ALL /*Bug6632095: using base table instead of view */
433: WHERE po_header_id = x_delete_id
434: AND distribution_type in ('STANDARD', 'PLANNED', 'AGREEMENT');
435: --
436:

Line 469: FROM po_distributions POD

465: X_total_quantity IN OUT NOCOPY NUMBER) IS
466: X_progress varchar2(3) := '';
467: CURSOR C is
468: SELECT sum(POD.quantity_ordered)
469: FROM po_distributions POD
470: WHERE POD.po_distribution_id = X_po_line_location_id;
471: BEGIN
472: --dbms_output.put_line('Before open cursor');
473: if (X_po_line_location_id is not null) then

Line 510: FROM po_distributions POD

506: X_max_distribution_id NUMBER := '';
507: BEGIN
508: SELECT max(POD.po_distribution_id)
509: INTO X_max_distribution_id
510: FROM po_distributions POD
511: WHERE POD.line_location_id = X_po_line_location_id;
512: IF (X_max_distribution_id is null) THEN
513: --dbms_output.put_line('returned false');
514: return(FALSE);

Line 651: l_creation_date po_distributions_all.creation_date%TYPE;

647: ,p_line_loc_id IN NUMBER
648: ,p_approved_date IN VARCHAR2
649: ,p_style_disp_name IN VARCHAR2
650: ,x_message_text OUT NOCOPY VARCHAR2) IS
651: l_creation_date po_distributions_all.creation_date%TYPE;
652: l_req_distribution_id po_distributions_all.req_distribution_id%TYPE;
653: l_quantity_delivered po_distributions_all.quantity_delivered%TYPE;
654: l_amount_delivered po_distributions_all.amount_delivered%TYPE;
655: l_encumbered_flag po_distributions_all.encumbered_flag%TYPE;

Line 652: l_req_distribution_id po_distributions_all.req_distribution_id%TYPE;

648: ,p_approved_date IN VARCHAR2
649: ,p_style_disp_name IN VARCHAR2
650: ,x_message_text OUT NOCOPY VARCHAR2) IS
651: l_creation_date po_distributions_all.creation_date%TYPE;
652: l_req_distribution_id po_distributions_all.req_distribution_id%TYPE;
653: l_quantity_delivered po_distributions_all.quantity_delivered%TYPE;
654: l_amount_delivered po_distributions_all.amount_delivered%TYPE;
655: l_encumbered_flag po_distributions_all.encumbered_flag%TYPE;
656: l_quantity_billed po_distributions_all.quantity_billed%TYPE;

Line 653: l_quantity_delivered po_distributions_all.quantity_delivered%TYPE;

649: ,p_style_disp_name IN VARCHAR2
650: ,x_message_text OUT NOCOPY VARCHAR2) IS
651: l_creation_date po_distributions_all.creation_date%TYPE;
652: l_req_distribution_id po_distributions_all.req_distribution_id%TYPE;
653: l_quantity_delivered po_distributions_all.quantity_delivered%TYPE;
654: l_amount_delivered po_distributions_all.amount_delivered%TYPE;
655: l_encumbered_flag po_distributions_all.encumbered_flag%TYPE;
656: l_quantity_billed po_distributions_all.quantity_billed%TYPE;
657: l_amount_billed po_distributions_all.amount_billed%TYPE;

Line 654: l_amount_delivered po_distributions_all.amount_delivered%TYPE;

650: ,x_message_text OUT NOCOPY VARCHAR2) IS
651: l_creation_date po_distributions_all.creation_date%TYPE;
652: l_req_distribution_id po_distributions_all.req_distribution_id%TYPE;
653: l_quantity_delivered po_distributions_all.quantity_delivered%TYPE;
654: l_amount_delivered po_distributions_all.amount_delivered%TYPE;
655: l_encumbered_flag po_distributions_all.encumbered_flag%TYPE;
656: l_quantity_billed po_distributions_all.quantity_billed%TYPE;
657: l_amount_billed po_distributions_all.amount_billed%TYPE;
658: --BUG 5553581

Line 655: l_encumbered_flag po_distributions_all.encumbered_flag%TYPE;

651: l_creation_date po_distributions_all.creation_date%TYPE;
652: l_req_distribution_id po_distributions_all.req_distribution_id%TYPE;
653: l_quantity_delivered po_distributions_all.quantity_delivered%TYPE;
654: l_amount_delivered po_distributions_all.amount_delivered%TYPE;
655: l_encumbered_flag po_distributions_all.encumbered_flag%TYPE;
656: l_quantity_billed po_distributions_all.quantity_billed%TYPE;
657: l_amount_billed po_distributions_all.amount_billed%TYPE;
658: --BUG 5553581
659: l_po_header_id po_distributions_all.po_header_id%TYPE;

Line 656: l_quantity_billed po_distributions_all.quantity_billed%TYPE;

652: l_req_distribution_id po_distributions_all.req_distribution_id%TYPE;
653: l_quantity_delivered po_distributions_all.quantity_delivered%TYPE;
654: l_amount_delivered po_distributions_all.amount_delivered%TYPE;
655: l_encumbered_flag po_distributions_all.encumbered_flag%TYPE;
656: l_quantity_billed po_distributions_all.quantity_billed%TYPE;
657: l_amount_billed po_distributions_all.amount_billed%TYPE;
658: --BUG 5553581
659: l_po_header_id po_distributions_all.po_header_id%TYPE;
660: l_is_complex_work_po BOOLEAN;

Line 657: l_amount_billed po_distributions_all.amount_billed%TYPE;

653: l_quantity_delivered po_distributions_all.quantity_delivered%TYPE;
654: l_amount_delivered po_distributions_all.amount_delivered%TYPE;
655: l_encumbered_flag po_distributions_all.encumbered_flag%TYPE;
656: l_quantity_billed po_distributions_all.quantity_billed%TYPE;
657: l_amount_billed po_distributions_all.amount_billed%TYPE;
658: --BUG 5553581
659: l_po_header_id po_distributions_all.po_header_id%TYPE;
660: l_is_complex_work_po BOOLEAN;
661: l_dummy NUMBER := 0;

Line 659: l_po_header_id po_distributions_all.po_header_id%TYPE;

655: l_encumbered_flag po_distributions_all.encumbered_flag%TYPE;
656: l_quantity_billed po_distributions_all.quantity_billed%TYPE;
657: l_amount_billed po_distributions_all.amount_billed%TYPE;
658: --BUG 5553581
659: l_po_header_id po_distributions_all.po_header_id%TYPE;
660: l_is_complex_work_po BOOLEAN;
661: l_dummy NUMBER := 0;
662: d_pos NUMBER := 0;
663: l_api_name CONSTANT VARCHAR2(30) := 'validate_delete_distribution';

Line 664: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_DISTRIBUTIONS_SV.validate_delete_distribution';

660: l_is_complex_work_po BOOLEAN;
661: l_dummy NUMBER := 0;
662: d_pos NUMBER := 0;
663: l_api_name CONSTANT VARCHAR2(30) := 'validate_delete_distribution';
664: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_DISTRIBUTIONS_SV.validate_delete_distribution';
665:
666: BEGIN
667:
668: IF (PO_LOG.d_proc) THEN

Line 688: FROM po_distributions_all

684: l_amount_delivered,
685: l_encumbered_flag,
686: l_quantity_billed,
687: l_amount_billed
688: FROM po_distributions_all
689: WHERE po_distribution_id = p_po_distribution_id;
690:
691: l_is_complex_work_po := PO_COMPLEX_WORK_PVT.is_complex_work_po(l_po_header_id);
692:

Line 705: FROM po_distributions_all pod

701: ELSE
702: BEGIN --5553581
703: select po_distribution_id
704: into l_dummy
705: FROM po_distributions_all pod
706: WHERE pod.line_location_id = p_line_loc_id
707: AND pod.req_distribution_id = l_req_distribution_id;
708:
709: x_message_text := PO_CORE_S.get_translated_text('PO_PO_DEL_DIST_ONLINE_REQ_NA');

Line 759: FROM po_distributions_all pod

755: -- to delete the distribution
756: BEGIN
757: select po_distribution_id
758: into l_dummy
759: FROM po_distributions_all pod
760: WHERE pod.line_location_id = p_line_loc_id;
761:
762: x_message_text := PO_CORE_S.get_translated_text('PO_CANT_DELETE_ONLY_DIST');
763: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;

Line 776: FND_MSG_PUB.add_exc_msg('PO_DISTRIBUTIONS_SV', l_api_name||':'||d_pos);

772: IF (PO_LOG.d_stmt) THEN
773: PO_LOG.stmt(d_module,d_pos,'x_message_text',x_message_text);
774: END IF;
775: WHEN OTHERS THEN
776: FND_MSG_PUB.add_exc_msg('PO_DISTRIBUTIONS_SV', l_api_name||':'||d_pos);
777: IF PO_LOG.d_exc THEN
778: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in' || d_module);
779: END IF;
780: RAISE;

Line 783: END po_distributions_sv;

779: END IF;
780: RAISE;
781: END validate_delete_distribution;
782:
783: END po_distributions_sv;