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 120.0.12020000.3 2013/02/10 23:14:58 vegajula 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 128: FROM po_vendor_contacts pvc

124: pvc.area_code||pvc.phone )
125:
126: INTO x_vendor_contact_name,
127: x_vendor_phone
128: FROM po_vendor_contacts pvc
129: WHERE pvc.vendor_contact_id = x_vendor_contact_id
130: AND pvc.vendor_site_id = nvl(x_vendor_site_id,pvc.vendor_site_id);
131:
132: EXCEPTION

Line 188: END PO_VENDOR_CONTACTS_SV;

184: return (NULL);
185:
186: END get_vendor_contact_id;
187:
188: END PO_VENDOR_CONTACTS_SV;