APPS.PO_AUTOCREATE_DOC dependencies on PO_VENDOR_SITES

Line 1391: --Changed the query to go against po_vendor_sites_all

1387:
1388: begin
1389:
1390: --
1391: --Changed the query to go against po_vendor_sites_all
1392: --instead of po_supplier_sites_val_v.
1393: select 'Y',
1394: vendor_site_code
1395: into x_valid_vendor_site,

Line 1397: from po_vendor_sites_all

1393: select 'Y',
1394: vendor_site_code
1395: into x_valid_vendor_site,
1396: x_vendor_site
1397: from po_vendor_sites_all
1398: where vendor_id = x_vendor_id
1399: and vendor_site_id = x_suggested_vendor_site_id
1400: --
1401: and purchasing_site_flag = 'Y'

Line 5474: PO_VENDOR_SITES_SV.Get_Transmission_Defaults(

5470: if (x_auto_approve_doc = 'Y' AND l_return_status = FND_API.G_RET_STS_SUCCESS) then --
5471:
5472: --Start of code changes for the bug 14243104 fix
5473: l_preparer_id := NULL;
5474: PO_VENDOR_SITES_SV.Get_Transmission_Defaults(
5475: p_document_id => l_document_id,
5476: p_document_type => l_doc_type,
5477: p_document_subtype => l_doc_subtype,
5478: p_preparer_id => l_preparer_id,

Line 5668: * PO_VENDOR_SITES_SV.Get_Transmission_Defaults which does this now.

5664: * Deleted the code which gets teh preparer_id if it is null since
5665: * x_preparer_id will be derived in get_transmission_defaults if
5666: * this is null. Also deleted the code which gets the default supplier
5667: * communication method from po_vendor_site and now call
5668: * PO_VENDOR_SITES_SV.Get_Transmission_Defaults which does this now.
5669: * Also deleted the code which defaults item_type, item_key from
5670: * po_document_types as this is done now in start_wf_process.
5671: */
5672:

Line 5701: po_vendor_sites pvs,

5697: into l_tp_header_id,
5698: l_edi_flag,
5699: x_preparer_id
5700: from ece_tp_details etd,
5701: po_vendor_sites pvs,
5702: po_vendors pv,
5703: po_headers ph
5704: where pv.vendor_id = pvs.vendor_id
5705: and pvs.tp_header_id = etd.tp_header_id

Line 5729: po_vendor_sites pvs,

5725: into l_tp_header_id,
5726: l_edi_flag,
5727: x_preparer_id
5728: from ece_tp_details etd,
5729: po_vendor_sites pvs,
5730: po_vendors pv,
5731: po_headers ph ,
5732: po_releases pr
5733: where pv.vendor_id = pvs.vendor_id

Line 5765: PO_VENDOR_SITES_SV.Get_Transmission_Defaults(

5761: else
5762: /* bug 4638656 - end */
5763:
5764:
5765: PO_VENDOR_SITES_SV.Get_Transmission_Defaults(
5766: p_document_id => x_doc_id,
5767: p_document_type => x_doc_type,
5768: p_document_subtype => x_doc_subtype,
5769: p_preparer_id => x_preparer_id,

Line 7637: l_suggested_vendor_site_id PO_VENDOR_SITES_ALL.vendor_site_id%TYPE;

7633: l_item_id NUMBER;
7634: l_cons_from_supp_flag VARCHAR2(1);
7635: x_progress VARCHAR2 (300);
7636: l_suggested_vendor_id PO_VENDORS.vendor_id%TYPE;
7637: l_suggested_vendor_site_id PO_VENDOR_SITES_ALL.vendor_site_id%TYPE;
7638:
7639: l_return_status VARCHAR2(1);
7640: l_msg_count NUMBER;
7641: l_msg_data VARCHAR2(2000);

Line 7803: FROM po_vendor_sites_all

7799: IF p_suggested_vendor_site_id IS NOT NULL THEN
7800: BEGIN
7801: SELECT org_id
7802: INTO l_purchasing_org_id
7803: FROM po_vendor_sites_all
7804: WHERE vendor_site_id = p_suggested_vendor_site_id;
7805: EXCEPTION
7806: WHEN NO_DATA_FOUND THEN
7807: l_purchasing_org_id := p_org_id;