APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_VENDOR_SITES_ALL

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);