APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_VENDOR_SITES

Line 5538: from PO_HEADERS_GT POH, po_vendor_sites povs

5534: substr(l_textline,1,240),
5535: 'PO_PDOI_INVALID_VENDOR_SITE'
5536: FROM dual
5537: where not exists (select 'Y'
5538: from PO_HEADERS_GT POH, po_vendor_sites povs
5539: WHERE POH.po_header_id = l_agreement_id
5540: AND povs.vendor_site_id = poh.vendor_site_id
5541: AND nvl(povs.rfq_only_site_flag,'N') <> 'Y'
5542: AND povs.purchasing_site_flag = 'Y'

Line 7832: from PO_HEADERS_GT POH, po_vendor_sites povs

7828: substr(l_textline,1,240),
7829: 'PO_PDOI_INVALID_VENDOR_SITE'
7830: FROM dual
7831: where not exists (select 'Y'
7832: from PO_HEADERS_GT POH, po_vendor_sites povs
7833: WHERE POH.po_header_id = p_document_id
7834: AND povs.vendor_site_id = poh.vendor_site_id
7835: AND nvl(povs.rfq_only_site_flag,'N') <> 'Y'
7836: AND povs.purchasing_site_flag = 'Y'

Line 8987: FROM po_vendor_sites_all pvs1, po_vendor_sites_all pvs2

8983: --Bug 16573818: Added the 'OR' clause below to match the vendor site code
8984: --for cases in which the vendor site IDs are different, but code is same.
8985: AND (nvl(ASL.vendor_site_id, POH.vendor_site_id) = POH.vendor_site_id
8986: OR EXISTS ( SELECT 'vendor site code matches ASL'
8987: FROM po_vendor_sites_all pvs1, po_vendor_sites_all pvs2
8988: WHERE pvs1. vendor_site_id = ASL.vendor_site_id
8989: and pvs2.vendor_site_id = POH.vendor_site_id
8990: and pvs1.vendor_site_code = pvs2.vendor_site_code) )
8991: AND ASL.item_id = POL.item_id

Line 21891: l_vendor_site_id PO_VENDOR_SITES_ALL.VENDOR_SITE_ID%type;

21887: IS
21888:
21889: l_log_head VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.validate_supplier_debarred';
21890: l_progress VARCHAR2(3) := '000';
21891: l_vendor_site_id PO_VENDOR_SITES_ALL.VENDOR_SITE_ID%type;
21892: l_debar_start_date PO_VENDOR_SITES_ALL.DEBARMENT_START_DATE%type;
21893: l_debar_end_date PO_VENDOR_SITES_ALL.DEBARMENT_END_DATE%type;
21894: debar_status VARCHAR2(50) := NULL;
21895:

Line 21892: l_debar_start_date PO_VENDOR_SITES_ALL.DEBARMENT_START_DATE%type;

21888:
21889: l_log_head VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.validate_supplier_debarred';
21890: l_progress VARCHAR2(3) := '000';
21891: l_vendor_site_id PO_VENDOR_SITES_ALL.VENDOR_SITE_ID%type;
21892: l_debar_start_date PO_VENDOR_SITES_ALL.DEBARMENT_START_DATE%type;
21893: l_debar_end_date PO_VENDOR_SITES_ALL.DEBARMENT_END_DATE%type;
21894: debar_status VARCHAR2(50) := NULL;
21895:
21896: BEGIN

Line 21893: l_debar_end_date PO_VENDOR_SITES_ALL.DEBARMENT_END_DATE%type;

21889: l_log_head VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.validate_supplier_debarred';
21890: l_progress VARCHAR2(3) := '000';
21891: l_vendor_site_id PO_VENDOR_SITES_ALL.VENDOR_SITE_ID%type;
21892: l_debar_start_date PO_VENDOR_SITES_ALL.DEBARMENT_START_DATE%type;
21893: l_debar_end_date PO_VENDOR_SITES_ALL.DEBARMENT_END_DATE%type;
21894: debar_status VARCHAR2(50) := NULL;
21895:
21896: BEGIN
21897: l_progress := '010';

Line 21930: FROM PO_VENDOR_SITES_ALL PVSA

21926: IF l_vendor_site_id IS NOT NULL THEN
21927:
21928: SELECT PVSA.DEBARMENT_START_DATE, PVSA.DEBARMENT_END_DATE
21929: INTO l_debar_start_date, l_debar_end_date
21930: FROM PO_VENDOR_SITES_ALL PVSA
21931: WHERE PVSA.VENDOR_SITE_ID =l_vendor_site_id;
21932:
21933: l_progress := '030';
21934: PO_DEBUG.debug_var(l_log_head,l_progress,'l_debar_start_date', l_debar_start_date);