APPS.PO_AUTOSOURCE_SV dependencies on PO_VENDOR_CONTACTS

Line 1060: x_vendor_contact_name PO_VENDOR_CONTACTS.last_name%TYPE;

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

Line 1325: (NOT PO_VENDOR_CONTACTS_SV.val_vendor_contact(

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

Line 1329: PO_VENDOR_CONTACTS_SV.get_vendor_contact(

1325: (NOT PO_VENDOR_CONTACTS_SV.val_vendor_contact(
1326: p_vendor_contact_id => x_vendor_contact_id,
1327: p_vendor_site_id => x_vendor_site_id))) THEN
1328:
1329: PO_VENDOR_CONTACTS_SV.get_vendor_contact(
1330: x_vendor_site_id => x_vendor_site_id,
1331: x_vendor_contact_id => x_vendor_contact_id,
1332: x_vendor_contact_name => l_vendor_contact_name);
1333:

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

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

Line 2072: PO_VENDOR_CONTACTS_SV.get_vendor_contact(

2068: x_vendor_site_id :=
2069: PO_GA_PVT.get_vendor_site_id(x_document_header_id);
2070:
2071: IF x_vendor_contact_id is NULL then
2072: PO_VENDOR_CONTACTS_SV.get_vendor_contact(
2073: x_vendor_site_id =>x_vendor_site_id,
2074: x_vendor_contact_id =>x_vendor_contact_id,
2075: x_vendor_contact_name =>l_vendor_contact_name);
2076: END IF;

Line 2269: PO_VENDOR_CONTACTS_SV.get_vendor_contact(

2265: x_vendor_site_id :=
2266: PO_GA_PVT.get_vendor_site_id(x_document_header_id);
2267:
2268: IF x_vendor_contact_id is NULL then
2269: PO_VENDOR_CONTACTS_SV.get_vendor_contact(
2270: x_vendor_site_id =>x_vendor_site_id,
2271: x_vendor_contact_id =>x_vendor_contact_id,
2272: x_vendor_contact_name =>l_vendor_contact_name);
2273: END IF;

Line 3427: x_vendor_contact_name PO_VENDOR_CONTACTS.last_name%TYPE;

3423:
3424: l_is_item_valid BOOLEAN := FALSE;
3425: l_is_org_valid BOOLEAN := FALSE;
3426: l_item_revision PO_LINES_ALL.item_revision%TYPE;
3427: x_vendor_contact_name PO_VENDOR_CONTACTS.last_name%TYPE;
3428: l_current_org_id PO_HEADERS_ALL.org_id%TYPE;
3429: l_purchasing_org_id PO_HEADERS_ALL.org_id%TYPE; --
3430: l_progress VARCHAR2(3) := '000';
3431: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'get_site_id_if_item_on_doc_ok';

Line 3498: PO_VENDOR_CONTACTS_SV.get_vendor_contact(

3494: x_vendor_site_id :=
3495: PO_GA_PVT.get_vendor_site_id(p_document_header_id);
3496:
3497: IF x_vendor_contact_id is NULL then
3498: PO_VENDOR_CONTACTS_SV.get_vendor_contact(
3499: x_vendor_site_id =>x_vendor_site_id,
3500: x_vendor_contact_id =>x_vendor_contact_id,
3501: x_vendor_contact_name =>x_vendor_contact_name);
3502: END IF;

Line 3519: PO_VENDOR_CONTACTS_SV.get_vendor_contact(

3515:
3516: x_vendor_site_id := PO_VENDOR_SITES_SV.get_vendor_site_id(
3517: p_po_header_id => p_document_header_id);
3518:
3519: PO_VENDOR_CONTACTS_SV.get_vendor_contact(
3520: x_vendor_site_id =>x_vendor_site_id,
3521: x_vendor_contact_id =>x_vendor_contact_id,
3522: x_vendor_contact_name =>x_vendor_contact_name);
3523: END IF;