1 PACKAGE fv_cross_doc_ref AUTHID CURRENT_USER AS
2 /* $Header: FVDOCCRS.pls 120.2 2002/11/10 15:02:52 ksriniva ship $*/
3 procedure main
4 (
5 p_vendor_id IN po_vendors.vendor_id%TYPE ,
6 p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE ,
7 p_po_header_id IN po_headers.po_header_id%TYPE,
8 p_po_date IN po_headers.creation_date%TYPE,
9 p_requisition_header_id IN po_requisition_headers.requisition_header_id%TYPE,
10 p_requisition_line_id IN po_requisition_lines.requisition_line_id%TYPE,
11 p_req_date IN po_requisition_headers.creation_date%TYPE,
12 p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
13 p_receipt_date IN rcv_shipment_headers.creation_date%TYPE,
14 p_buyer IN po_headers.agent_id%TYPE,
15 p_invoice_id IN ap_invoices.invoice_id%TYPE,
16 p_invoice_date IN ap_invoices.invoice_date%TYPE ,
17 p_invoice_amount IN ap_invoices.invoice_amount%TYPE ,
18 p_invoice_type IN ap_invoices.invoice_type_lookup_code%TYPE ,
19 p_check_id IN ap_checks.check_id%TYPE,
20 p_check_date IN ap_checks.creation_date%TYPE,
21 p_amount IN ap_checks.amount%TYPE,
22 p_treasury_pay_number IN ap_checks.treasury_pay_number%TYPE,
23 p_treasury_pay_date IN ap_checks.treasury_pay_date%TYPE,
24 p_valid_req_supplier IN NUMBER,
25 p_supplier_name IN po_vendors.vendor_name%TYPE,
26 p_supplier_site IN po_vendor_sites.vendor_site_code%TYPE,
27 p_result IN VARCHAR2,
28 p_err_code OUT NOCOPY NUMBER,
29 p_session_id IN NUMBER
30 );
31
32 END fv_cross_doc_ref;
[Home] [Help]