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.12020000.2 2013/05/30 11:48:48 gjyothi 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 408: delete po_distributions_all /Bug6632095: using base table instead of view /

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

Line 416: delete po_distributions

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

Line 421: delete po_distributions

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

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

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

Line 470: FROM po_distributions POD

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

Line 511: FROM po_distributions POD

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

Line 652: l_creation_date po_distributions_all.creation_date%TYPE;

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

Line 653: l_req_distribution_id po_distributions_all.req_distribution_id%TYPE;

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

Line 654: l_quantity_delivered po_distributions_all.quantity_delivered%TYPE;

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

Line 655: l_amount_delivered po_distributions_all.amount_delivered%TYPE;

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

Line 656: l_encumbered_flag po_distributions_all.encumbered_flag%TYPE;

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

Line 657: l_quantity_billed po_distributions_all.quantity_billed%TYPE;

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

Line 658: l_amount_billed po_distributions_all.amount_billed%TYPE;

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

Line 660: l_po_header_id po_distributions_all.po_header_id%TYPE;

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

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

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

Line 689: FROM po_distributions_all

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

Line 706: FROM po_distributions_all pod

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

Line 760: FROM po_distributions_all pod

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

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

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

Line 784: END po_distributions_sv;

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