APPS.JAI_PO_HOOK_PKG dependencies on PO_LINES_ALL

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

1955: END IF;
1956:
1957: IF p_document_Type = 'GBA_ALL' Then
1958: FOR r_po_rec IN
1959: (SELECT po_header_id FROM po_lines_all WHERE from_header_id = p_header_id)
1960: LOOP
1961: ln_tax_amt := ln_tax_amt + gettaxisp('PO',r_po_rec.po_header_id,null,null);
1962: END LOOP;
1963: RETURN (ln_tax_amt);

Line 1972: (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)

1968: * This Code is Commented : GBA should display only its taxes
1969: * its should not display taxes of releases
1970: IF p_line_id IS NOT NULL THEN
1971: FOR r_po_rec IN
1972: (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)
1973: LOOP
1974: ln_tax_amt := ln_tax_amt + gettaxisp('PO_LINE',r_po_rec.po_header_id,r_po_rec.po_line_id,null);
1975: END LOOP;
1976: ELSE

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

1974: ln_tax_amt := ln_tax_amt + gettaxisp('PO_LINE',r_po_rec.po_header_id,r_po_rec.po_line_id,null);
1975: END LOOP;
1976: ELSE
1977: FOR r_po_rec IN
1978: (SELECT po_header_id FROM po_lines_all WHERE from_header_id = p_header_id)
1979: LOOP
1980: ln_tax_amt := ln_tax_amt + gettaxisp('PO',r_po_rec.po_header_id,null,null);
1981: END LOOP;
1982: END IF;

Line 1986: (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)

1982: END IF;
1983: */
1984: IF p_line_id IS NOT NULL THEN
1985: FOR r_po_rec IN
1986: (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)
1987: LOOP
1988: ln_tax_amt := ln_tax_amt + gettaxisp('PO_LINE',r_po_rec.po_header_id,r_po_rec.po_line_id,null);
1989: END LOOP;
1990: ELSE

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

1988: ln_tax_amt := ln_tax_amt + gettaxisp('PO_LINE',r_po_rec.po_header_id,r_po_rec.po_line_id,null);
1989: END LOOP;
1990: ELSE
1991: FOR r_po_rec IN
1992: (SELECT po_header_id FROM po_lines_all WHERE po_header_id = p_header_id)
1993: LOOP
1994: ln_tax_amt := ln_tax_amt + gettaxisp('PO',r_po_rec.po_header_id,null,null);
1995: END LOOP;
1996: END IF;

Line 2965: FROM po_lines_all

2961: IF (pv_document_type = 'GBA_ALL')
2962: THEN
2963: FOR r_po_rec IN
2964: (SELECT po_header_id
2965: FROM po_lines_all
2966: WHERE from_header_id = pn_header_id)
2967: LOOP
2968: ln_tax_amt := ln_tax_amt + Get_Isp_InAndEx_Tax_Total('PO',r_po_rec.po_header_id,null,null, pv_inclusive_tax_flag);
2969: END LOOP; --r_po_rec IN

Line 2981: FROM po_lines_all

2977: THEN
2978: FOR r_po_rec IN (SELECT
2979: po_header_id
2980: , po_line_id
2981: FROM po_lines_all
2982: WHERE po_header_id = pn_header_id
2983: AND po_line_id = pn_line_id)
2984: LOOP
2985: 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 2989: FROM po_lines_all

2985: 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);
2986: END LOOP; -- r_po_rec IN
2987: ELSE
2988: FOR r_po_rec IN (SELECT po_header_id
2989: FROM po_lines_all
2990: WHERE po_header_id = pn_header_id)
2991: LOOP
2992: ln_tax_amt := ln_tax_amt + Get_Isp_InAndEx_Tax_Total('PO',r_po_rec.po_header_id,null,null,pv_inclusive_tax_flag);
2993: END LOOP; --r_po_rec IN