APPS.FV_CROSS_DOC_REF dependencies on PO_VENDORS

Line 5: vp_vendor_id po_vendors.vendor_id%TYPE;

1: PACKAGE BODY fv_cross_doc_ref as
2: /* $Header: FVDOCCRB.pls 120.12 2003/12/17 21:20:05 ksriniva ship $ */
3: g_module_name VARCHAR2(100) := 'fv.plsql.fv_cross_doc_ref.';
4:
5: vp_vendor_id po_vendors.vendor_id%TYPE;
6: vp_vendor_site_id po_vendor_sites.vendor_site_id%TYPE;
7: vp_po_header_id po_headers.po_header_id%TYPE;
8: vp_po_date po_headers.creation_date%TYPE;
9: vp_requisition_header_id po_requisition_headers.requisition_header_id%TYPE;

Line 25: vp_supplier_name po_vendors.vendor_name%TYPE;

21: vp_amount ap_checks.amount%TYPE;
22: vp_treasury_pay_number ap_checks.treasury_pay_number%TYPE;
23: vp_treasury_pay_date ap_checks.treasury_pay_date%TYPE;
24: vp_valid_req_supplier NUMBER;
25: vp_supplier_name po_vendors.vendor_name%TYPE;
26: vp_supplier_site po_vendor_sites.vendor_site_code%TYPE;
27: vp_session_id NUMBER;
28:
29: PROCEDURE po_master;

Line 42: p_vendor_id IN po_vendors.vendor_id%TYPE ,

38: ----------------------------------------------------------------------
39:
40: PROCEDURE main
41: (
42: p_vendor_id IN po_vendors.vendor_id%TYPE ,
43: p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE ,
44: p_po_header_id IN po_headers.po_header_id%TYPE,
45: p_po_date IN po_headers.creation_date%TYPE,
46: p_requisition_header_id IN po_requisition_headers.requisition_header_id%TYPE,

Line 62: p_supplier_name IN po_vendors.vendor_name%TYPE,

58: p_amount IN ap_checks.amount%TYPE,
59: p_treasury_pay_number IN ap_checks.treasury_pay_number%TYPE,
60: p_treasury_pay_date IN ap_checks.treasury_pay_date%TYPE,
61: p_valid_req_supplier IN NUMBER,
62: p_supplier_name IN po_vendors.vendor_name%TYPE,
63: p_supplier_site IN po_vendor_sites.vendor_site_code%TYPE,
64: p_result IN VARCHAR2,
65: p_err_code OUT NOCOPY NUMBER,
66: p_session_id IN NUMBER

Line 175: AND NOT EXISTS (SELECT 1 FROM po_vendors pv,po_requisition_lines prl,po_vendor_sites pvs

171: AND plx.po_header_id = ph.po_header_id
172: AND ph.vendor_id = vp_vendor_id
173: AND rh.line_location_id = pll.line_location_id
174: AND ph.vendor_site_id = vp_vendor_site_id
175: AND NOT EXISTS (SELECT 1 FROM po_vendors pv,po_requisition_lines prl,po_vendor_sites pvs
176: WHERE prl.suggested_vendor_name = pv.vendor_name
177: AND prl.suggested_vendor_location = pvs.vendor_site_code
178: AND prl.requisition_line_id = rh.requisition_line_id ));
179:

Line 522: AND NOT EXISTS (SELECT 1 FROM po_vendors pv,po_requisition_lines prl,po_vendor_sites pvs

518: WHERE plx.line_location_id = rh.line_location_id
519: AND plx.po_header_id = ph.po_header_id
520: AND ph.vendor_id = vp_vendor_id
521: AND ph.vendor_site_id = vp_vendor_site_id
522: AND NOT EXISTS (SELECT 1 FROM po_vendors pv,po_requisition_lines prl,po_vendor_sites pvs
523: WHERE prl.suggested_vendor_name = pv.vendor_name
524: AND prl.suggested_vendor_location = pvs.vendor_site_code
525: AND prl.requisition_line_id = rh.requisition_line_id );
526: