[Home] [Help]
53:
54: IF p_po_header_id IS NOT NULL THEN
55: l_po_header_id := p_po_header_id;
56: elsif p_po_line_id is not null then
57: select l.po_header_id into l_po_header_id from po_lines_all l where l.po_line_id = p_po_line_id;
58: elsif p_po_line_location_id is not null then
59: select s.po_header_id into l_po_header_id from po_line_locations_all s where s.Line_Location_id = p_po_line_location_id;
60: else
61: select d.po_header_id into l_po_header_id from po_distributions_all d where d.po_distribution_id = p_po_distribution_id;
339: x_quantity_delivered,x_amount_delivered,x_quantity_billed,x_amount_billed,
340: x_quantity_cancelled, x_amount_cancelled
341: FROM po_distributions_all pod,
342: po_line_locations_all pll,
343: po_lines_all pl
344: WHERE pll.line_location_id = pod.line_location_id
345: AND pod.po_distribution_id = p_po_distribution_id
346: AND pl.po_line_id = pod.po_line_id;
347:
655: IF NOT (l_funded > 0) THEN
656: BEGIN
657: SELECT 1
658: INTO l_nsp_nc_line
659: FROM po_lines_all l,
660: po_distributions_all d
661: WHERE l.po_line_id = d.po_line_id AND
662: l.cost_constraint IN ('NSP', 'NC') AND
663: d.po_distribution_id = p_distribution_id;
677: IF NOT (l_funded > 0) THEN
678: BEGIN
679: SELECT 1
680: INTO l_nsp_nc_line
681: FROM po_lines_all l,
682: po_line_locations_all ll
683: WHERE l.po_line_id = ll.po_line_id AND
684: l.cost_constraint IN ('NSP', 'NC') AND
685: ll.line_location_id = p_line_location_id;
699: IF NOT (l_funded > 0) THEN
700: BEGIN
701: SELECT 1
702: INTO l_nsp_nc_line
703: FROM po_lines_all l
704: WHERE l.po_line_id = p_line_id AND
705: l.cost_constraint IN ('NSP', 'NC');
706: EXCEPTION
707: WHEN No_Data_Found THEN