APPS.PO_AUTOSOURCE_SV dependencies on PO_VENDOR_CONTACTS

Line 1064: x_vendor_contact_name PO_VENDOR_CONTACTS.last_name%TYPE;

1060: x_ga_flag VARCHAR2(1) := 'N'; -- FPI GA
1061: x_owning_org_id NUMBER; -- FPI GA
1062: x_valid_flag VARCHAR2(1) := 'N';
1063: --
1064: x_vendor_contact_name PO_VENDOR_CONTACTS.last_name%TYPE;
1065: l_sequence_number PO_ASL_DOCUMENTS.sequence_num%TYPE;
1066: l_vendor_site_sourcing_flag VARCHAR2(1) := p_vendor_site_sourcing_flag;
1067: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'document_sourcing';
1068: --

Line 1329: (NOT PO_VENDOR_CONTACTS_SV.val_vendor_contact(

1325: IF x_vendor_site_id is NOT NULL THEN
1326: --If there is no vendor contact or contact is not valid
1327: --Then get the contact from site
1328: IF (x_vendor_contact_id is NULL OR
1329: (NOT PO_VENDOR_CONTACTS_SV.val_vendor_contact(
1330: p_vendor_contact_id => x_vendor_contact_id,
1331: p_vendor_site_id => x_vendor_site_id))) THEN
1332:
1333: PO_VENDOR_CONTACTS_SV.get_vendor_contact(

Line 1333: PO_VENDOR_CONTACTS_SV.get_vendor_contact(

1329: (NOT PO_VENDOR_CONTACTS_SV.val_vendor_contact(
1330: p_vendor_contact_id => x_vendor_contact_id,
1331: p_vendor_site_id => x_vendor_site_id))) THEN
1332:
1333: PO_VENDOR_CONTACTS_SV.get_vendor_contact(
1334: x_vendor_site_id => x_vendor_site_id,
1335: x_vendor_contact_id => x_vendor_contact_id,
1336: x_vendor_contact_name => l_vendor_contact_name);
1337:

Line 1487: l_vendor_contact_name PO_VENDOR_CONTACTS.last_name%TYPE; --Bug 3545698

1483: l_source_doc_purchasing_uom PO_LINES_ALL.unit_meas_lookup_code%TYPE;
1484:
1485: l_item_based_asl VARCHAR2(1):= 'Y'; --
1486: l_item_id NUMBER; --
1487: l_vendor_contact_name PO_VENDOR_CONTACTS.last_name%TYPE; --Bug 3545698
1488: l_noncat_item BOOLEAN := FALSE; /* Bug#4263138 */
1489:
1490:
1491: --

Line 2085: PO_VENDOR_CONTACTS_SV.get_vendor_contact(

2081: x_vendor_site_id :=
2082: PO_GA_PVT.get_vendor_site_id(x_document_header_id);
2083:
2084: IF x_vendor_contact_id is NULL then
2085: PO_VENDOR_CONTACTS_SV.get_vendor_contact(
2086: x_vendor_site_id =>x_vendor_site_id,
2087: x_vendor_contact_id =>x_vendor_contact_id,
2088: x_vendor_contact_name =>l_vendor_contact_name);
2089: END IF;

Line 2282: PO_VENDOR_CONTACTS_SV.get_vendor_contact(

2278: x_vendor_site_id :=
2279: PO_GA_PVT.get_vendor_site_id(x_document_header_id);
2280:
2281: IF x_vendor_contact_id is NULL then
2282: PO_VENDOR_CONTACTS_SV.get_vendor_contact(
2283: x_vendor_site_id =>x_vendor_site_id,
2284: x_vendor_contact_id =>x_vendor_contact_id,
2285: x_vendor_contact_name =>l_vendor_contact_name);
2286: END IF;

Line 3452: x_vendor_contact_name PO_VENDOR_CONTACTS.last_name%TYPE;

3448:
3449: l_is_item_valid BOOLEAN := FALSE;
3450: l_is_org_valid BOOLEAN := FALSE;
3451: l_item_revision PO_LINES_ALL.item_revision%TYPE;
3452: x_vendor_contact_name PO_VENDOR_CONTACTS.last_name%TYPE;
3453: l_vendor_contact_name VARCHAR2(240); --
3454: l_current_org_id PO_HEADERS_ALL.org_id%TYPE;
3455: l_purchasing_org_id PO_HEADERS_ALL.org_id%TYPE; --
3456: l_progress VARCHAR2(3) := '000';

Line 3524: PO_VENDOR_CONTACTS_SV.get_vendor_contact(

3520: x_vendor_site_id :=
3521: PO_GA_PVT.get_vendor_site_id(p_document_header_id);
3522:
3523: IF x_vendor_contact_id is NULL then
3524: PO_VENDOR_CONTACTS_SV.get_vendor_contact(
3525: x_vendor_site_id =>x_vendor_site_id,
3526: x_vendor_contact_id =>x_vendor_contact_id,
3527: x_vendor_contact_name =>l_vendor_contact_name);
3528: END IF;

Line 3545: PO_VENDOR_CONTACTS_SV.get_vendor_contact(

3541:
3542: x_vendor_site_id := PO_VENDOR_SITES_SV.get_vendor_site_id(
3543: p_po_header_id => p_document_header_id);
3544:
3545: PO_VENDOR_CONTACTS_SV.get_vendor_contact(
3546: x_vendor_site_id =>x_vendor_site_id,
3547: x_vendor_contact_id =>x_vendor_contact_id,
3548: x_vendor_contact_name =>l_vendor_contact_name);
3549: END IF;