APPS.PO_VENDOR_CONTACTS_SV dependencies on PO_VENDOR_CONTACTS

Line 1: PACKAGE BODY PO_VENDOR_CONTACTS_SV AS

1: PACKAGE BODY PO_VENDOR_CONTACTS_SV AS
2: /* $Header: POXVDVCB.pls 115.6 2004/06/22 02:09:24 mbhargav ship $*/
3:
4: /*===========================================================================
5:

Line 24: FROM po_vendor_contacts

20: /* Check if the given Vendor Contact is active */
21:
22: SELECT vendor_contact_id
23: INTO X_vendor_contact_id_v
24: FROM po_vendor_contacts
25: WHERE sysdate < nvl(inactive_date, sysdate + 1)
26: AND vendor_contact_id = p_vendor_contact_id
27: AND vendor_site_id = p_vendor_site_id; --
28:

Line 69: FROM po_vendor_contacts

65: max(vendor_contact_id)
66: INTO X_vendor_contact_count,
67: X_vendor_contact_name,
68: X_vendor_contact_id
69: FROM po_vendor_contacts
70: WHERE vendor_site_id = X_vendor_site_id
71: AND sysdate < nvl(inactive_date, sysdate + 1);
72:
73: /* If there is more than 1 ACTIVE vendor contact for the

Line 127: FROM po_vendor_contacts pvc

123: pvc.area_code||pvc.phone )
124:
125: INTO x_vendor_contact_name,
126: x_vendor_phone
127: FROM po_vendor_contacts pvc
128: WHERE pvc.vendor_contact_id = x_vendor_contact_id;
129:
130: EXCEPTION
131: WHEN NO_DATA_FOUND THEN

Line 186: END PO_VENDOR_CONTACTS_SV;

182: return (NULL);
183:
184: END get_vendor_contact_id;
185:
186: END PO_VENDOR_CONTACTS_SV;