APPS.JAI_PO_HOOK_PKG dependencies on PO_LINES_ALL

Line 1771: (SELECT po_header_id FROM po_lines_all WHERE from_header_id = p_header_id)

1767: END IF;
1768:
1769: IF p_document_Type = 'GBA_ALL' Then
1770: FOR r_po_rec IN
1771: (SELECT po_header_id FROM po_lines_all WHERE from_header_id = p_header_id)
1772: LOOP
1773: ln_tax_amt := ln_tax_amt + gettaxisp('PO',r_po_rec.po_header_id,null,null);
1774: END LOOP;
1775: RETURN (ln_tax_amt);

Line 1784: (SELECT po_header_id, po_line_id FROM po_lines_all WHERE from_header_id = p_header_id AND from_line_id = p_line_id)

1780: * This Code is Commented : GBA should display only its taxes
1781: * its should not display taxes of releases
1782: IF p_line_id IS NOT NULL THEN
1783: FOR r_po_rec IN
1784: (SELECT po_header_id, po_line_id FROM po_lines_all WHERE from_header_id = p_header_id AND from_line_id = p_line_id)
1785: LOOP
1786: ln_tax_amt := ln_tax_amt + gettaxisp('PO_LINE',r_po_rec.po_header_id,r_po_rec.po_line_id,null);
1787: END LOOP;
1788: ELSE

Line 1790: (SELECT po_header_id FROM po_lines_all WHERE from_header_id = p_header_id)

1786: ln_tax_amt := ln_tax_amt + gettaxisp('PO_LINE',r_po_rec.po_header_id,r_po_rec.po_line_id,null);
1787: END LOOP;
1788: ELSE
1789: FOR r_po_rec IN
1790: (SELECT po_header_id FROM po_lines_all WHERE from_header_id = p_header_id)
1791: LOOP
1792: ln_tax_amt := ln_tax_amt + gettaxisp('PO',r_po_rec.po_header_id,null,null);
1793: END LOOP;
1794: END IF;

Line 1798: (SELECT po_header_id, po_line_id FROM po_lines_all WHERE po_header_id = p_header_id AND po_line_id = p_line_id)

1794: END IF;
1795: */
1796: IF p_line_id IS NOT NULL THEN
1797: FOR r_po_rec IN
1798: (SELECT po_header_id, po_line_id FROM po_lines_all WHERE po_header_id = p_header_id AND po_line_id = p_line_id)
1799: LOOP
1800: ln_tax_amt := ln_tax_amt + gettaxisp('PO_LINE',r_po_rec.po_header_id,r_po_rec.po_line_id,null);
1801: END LOOP;
1802: ELSE

Line 1804: (SELECT po_header_id FROM po_lines_all WHERE po_header_id = p_header_id)

1800: ln_tax_amt := ln_tax_amt + gettaxisp('PO_LINE',r_po_rec.po_header_id,r_po_rec.po_line_id,null);
1801: END LOOP;
1802: ELSE
1803: FOR r_po_rec IN
1804: (SELECT po_header_id FROM po_lines_all WHERE po_header_id = p_header_id)
1805: LOOP
1806: ln_tax_amt := ln_tax_amt + gettaxisp('PO',r_po_rec.po_header_id,null,null);
1807: END LOOP;
1808: END IF;

Line 2763: FROM po_lines_all

2759: IF (pv_document_type = 'GBA_ALL')
2760: THEN
2761: FOR r_po_rec IN
2762: (SELECT po_header_id
2763: FROM po_lines_all
2764: WHERE from_header_id = pn_header_id)
2765: LOOP
2766: ln_tax_amt := ln_tax_amt + Get_Isp_InAndEx_Tax_Total('PO',r_po_rec.po_header_id,null,null, pv_inclusive_tax_flag);
2767: END LOOP; --r_po_rec IN

Line 2779: FROM po_lines_all

2775: THEN
2776: FOR r_po_rec IN (SELECT
2777: po_header_id
2778: , po_line_id
2779: FROM po_lines_all
2780: WHERE po_header_id = pn_header_id
2781: AND po_line_id = pn_line_id)
2782: LOOP
2783: ln_tax_amt := ln_tax_amt + Get_Isp_InAndEx_Tax_Total('PO_LINE',r_po_rec.po_header_id,r_po_rec.po_line_id,null,pv_inclusive_tax_flag);

Line 2787: FROM po_lines_all

2783: ln_tax_amt := ln_tax_amt + Get_Isp_InAndEx_Tax_Total('PO_LINE',r_po_rec.po_header_id,r_po_rec.po_line_id,null,pv_inclusive_tax_flag);
2784: END LOOP; -- r_po_rec IN
2785: ELSE
2786: FOR r_po_rec IN (SELECT po_header_id
2787: FROM po_lines_all
2788: WHERE po_header_id = pn_header_id)
2789: LOOP
2790: ln_tax_amt := ln_tax_amt + Get_Isp_InAndEx_Tax_Total('PO',r_po_rec.po_header_id,null,null,pv_inclusive_tax_flag);
2791: END LOOP; --r_po_rec IN