APPS.PO_INQ_SV dependencies on PO_HEADERS_ALL

Line 611: FROM po_headers_all POH, po_line_locations_all PLL --

607: */
608:
609: SELECT POH.segment1
610: INTO x_po_number
611: FROM po_headers_all POH, po_line_locations_all PLL --
612: WHERE POH.po_header_id = PLL.po_header_id and
613: PLL.line_location_id = x_line_location_id;
614:
615:

Line 1348: from po_headers_all --< Shared Proc FPJ >

1344: where line_location_id = x_po_line_location_id;
1345:
1346: cursor c2 is
1347: select terms_id
1348: from po_headers_all --< Shared Proc FPJ >
1349: where po_header_id = x_po_header_id;
1350:
1351: x_progress varchar2(3) := '000';
1352: x_ship_to_org_id number;

Line 1836: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE,

1832:
1833: ===========================================================================*/
1834: PROCEDURE get_source_info
1835: (
1836: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE,
1837: x_segment1 OUT NOCOPY PO_HEADERS_ALL.segment1%TYPE,
1838: x_type_lookup_code OUT NOCOPY PO_HEADERS_ALL.type_lookup_code%TYPE,
1839: x_global_agreement_flag OUT NOCOPY PO_HEADERS_ALL.global_agreement_flag%TYPE,
1840: x_owning_org_id OUT NOCOPY PO_HEADERS_ALL.org_id%TYPE,

Line 1837: x_segment1 OUT NOCOPY PO_HEADERS_ALL.segment1%TYPE,

1833: ===========================================================================*/
1834: PROCEDURE get_source_info
1835: (
1836: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE,
1837: x_segment1 OUT NOCOPY PO_HEADERS_ALL.segment1%TYPE,
1838: x_type_lookup_code OUT NOCOPY PO_HEADERS_ALL.type_lookup_code%TYPE,
1839: x_global_agreement_flag OUT NOCOPY PO_HEADERS_ALL.global_agreement_flag%TYPE,
1840: x_owning_org_id OUT NOCOPY PO_HEADERS_ALL.org_id%TYPE,
1841: x_quote_vendor_quote_number OUT NOCOPY PO_HEADERS_ALL.quote_vendor_quote_number%TYPE

Line 1838: x_type_lookup_code OUT NOCOPY PO_HEADERS_ALL.type_lookup_code%TYPE,

1834: PROCEDURE get_source_info
1835: (
1836: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE,
1837: x_segment1 OUT NOCOPY PO_HEADERS_ALL.segment1%TYPE,
1838: x_type_lookup_code OUT NOCOPY PO_HEADERS_ALL.type_lookup_code%TYPE,
1839: x_global_agreement_flag OUT NOCOPY PO_HEADERS_ALL.global_agreement_flag%TYPE,
1840: x_owning_org_id OUT NOCOPY PO_HEADERS_ALL.org_id%TYPE,
1841: x_quote_vendor_quote_number OUT NOCOPY PO_HEADERS_ALL.quote_vendor_quote_number%TYPE
1842: )

Line 1839: x_global_agreement_flag OUT NOCOPY PO_HEADERS_ALL.global_agreement_flag%TYPE,

1835: (
1836: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE,
1837: x_segment1 OUT NOCOPY PO_HEADERS_ALL.segment1%TYPE,
1838: x_type_lookup_code OUT NOCOPY PO_HEADERS_ALL.type_lookup_code%TYPE,
1839: x_global_agreement_flag OUT NOCOPY PO_HEADERS_ALL.global_agreement_flag%TYPE,
1840: x_owning_org_id OUT NOCOPY PO_HEADERS_ALL.org_id%TYPE,
1841: x_quote_vendor_quote_number OUT NOCOPY PO_HEADERS_ALL.quote_vendor_quote_number%TYPE
1842: )
1843: IS

Line 1840: x_owning_org_id OUT NOCOPY PO_HEADERS_ALL.org_id%TYPE,

1836: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE,
1837: x_segment1 OUT NOCOPY PO_HEADERS_ALL.segment1%TYPE,
1838: x_type_lookup_code OUT NOCOPY PO_HEADERS_ALL.type_lookup_code%TYPE,
1839: x_global_agreement_flag OUT NOCOPY PO_HEADERS_ALL.global_agreement_flag%TYPE,
1840: x_owning_org_id OUT NOCOPY PO_HEADERS_ALL.org_id%TYPE,
1841: x_quote_vendor_quote_number OUT NOCOPY PO_HEADERS_ALL.quote_vendor_quote_number%TYPE
1842: )
1843: IS
1844: BEGIN

Line 1841: x_quote_vendor_quote_number OUT NOCOPY PO_HEADERS_ALL.quote_vendor_quote_number%TYPE

1837: x_segment1 OUT NOCOPY PO_HEADERS_ALL.segment1%TYPE,
1838: x_type_lookup_code OUT NOCOPY PO_HEADERS_ALL.type_lookup_code%TYPE,
1839: x_global_agreement_flag OUT NOCOPY PO_HEADERS_ALL.global_agreement_flag%TYPE,
1840: x_owning_org_id OUT NOCOPY PO_HEADERS_ALL.org_id%TYPE,
1841: x_quote_vendor_quote_number OUT NOCOPY PO_HEADERS_ALL.quote_vendor_quote_number%TYPE
1842: )
1843: IS
1844: BEGIN
1845:

Line 1856: FROM po_headers_all

1852: x_type_lookup_code,
1853: x_global_agreement_flag,
1854: x_owning_org_id,
1855: x_quote_vendor_quote_number
1856: FROM po_headers_all
1857: WHERE po_header_id = p_po_header_id;
1858:
1859: EXCEPTION
1860: WHEN OTHERS THEN

Line 1913: from po_headers_all POH

1909: x_rate_type OUT NOCOPY varchar2) is
1910: cursor c1 is
1911: select GLDC.USER_CONVERSION_TYPE from GL_DAILY_CONVERSION_TYPES GLDC
1912: where GLDC.CONVERSION_TYPE = (select POH.RATE_TYPE
1913: from po_headers_all POH
1914: where poh.po_header_id = x_header_id);
1915:
1916: BEGIN
1917: