APPS.PO_RELGEN_PKG dependencies on PO_HEADERS_ALL

Line 3280: FROM po_headers_all

3276: -- SQL Why: need to check vendor site registration status below
3277: BEGIN
3278: SELECT vendor_id, vendor_site_id
3279: INTO l_vendor_id, l_vendor_site_id
3280: FROM po_headers_all
3281: WHERE po_header_id = p_po_header_id;
3282: EXCEPTION
3283: WHEN OTHERS THEN
3284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3625: p_vendor_id IN po_headers_all.vendor_id%TYPE,

3621: */
3622: FUNCTION get_asl_id( p_item_id IN po_requisition_lines_all.item_id%TYPE,
3623: p_category_id IN po_requisition_lines_all.category_id%TYPE,
3624: p_destination_organization_id IN po_requisition_lines_all.destination_organization_id%TYPE,
3625: p_vendor_id IN po_headers_all.vendor_id%TYPE,
3626: p_vendor_site_id IN po_headers_all.vendor_site_id%TYPE )
3627: return number
3628: as
3629:

Line 3626: p_vendor_site_id IN po_headers_all.vendor_site_id%TYPE )

3622: FUNCTION get_asl_id( p_item_id IN po_requisition_lines_all.item_id%TYPE,
3623: p_category_id IN po_requisition_lines_all.category_id%TYPE,
3624: p_destination_organization_id IN po_requisition_lines_all.destination_organization_id%TYPE,
3625: p_vendor_id IN po_headers_all.vendor_id%TYPE,
3626: p_vendor_site_id IN po_headers_all.vendor_site_id%TYPE )
3627: return number
3628: as
3629:
3630: l_progress VARCHAR2(3) := '000';