APPS.PON_OPEN_INTERFACE_PVT dependencies on AP_SUPPLIER_SITES_ALL

Line 1694: FROM AP_SUPPLIER_SITES_ALL

1690: -- If vendor_site_id and vendor_site_code is not null
1691: IF (L_VENDOR_SITE_ID IS NOT NULL) THEN
1692: SELECT VENDOR_SITE_CODE
1693: INTO L_VENDOR_SITE_CODE
1694: FROM AP_SUPPLIER_SITES_ALL
1695: WHERE VENDOR_SITE_ID=L_VENDOR_SITE_ID
1696: AND ORG_ID =L_ORG_ID;
1697: -- If vendor_site_id is null and vendor_site_code is not null
1698: ELSIF (L_VENDOR_SITE_CODE IS NOT NULL) THEN

Line 1701: FROM AP_SUPPLIER_SITES_ALL

1697: -- If vendor_site_id is null and vendor_site_code is not null
1698: ELSIF (L_VENDOR_SITE_CODE IS NOT NULL) THEN
1699: SELECT VENDOR_SITE_ID
1700: INTO L_VENDOR_SITE_ID
1701: FROM AP_SUPPLIER_SITES_ALL
1702: WHERE VENDOR_SITE_CODE=L_VENDOR_SITE_CODE
1703: AND ORG_ID =L_ORG_ID;
1704: END IF;
1705:

Line 1922: AND NOT EXISTS(SELECT 1 FROM AP_SUPPLIER_SITES_ALL

1918: SYSDATE,
1919: l_cp_login_id)
1920:
1921: WHEN (sel_vendor_site_code IS NOT NULL AND sel_vendor_site_id IS NOT NULL
1922: AND NOT EXISTS(SELECT 1 FROM AP_SUPPLIER_SITES_ALL
1923: WHERE vendor_site_code=sel_vendor_site_code AND vendor_site_id=sel_vendor_site_id))
1924: THEN INTO PON_INTERFACE_ERRORS
1925: (
1926: INTERFACE_TYPE ,

Line 1951: AND NOT EXISTS(SELECT 1 FROM AP_SUPPLIER_SITES_ALL

1947: l_cp_user_id,
1948: SYSDATE,
1949: l_cp_login_id)
1950: WHEN (sel_vendor_site_id IS NOT NULL
1951: AND NOT EXISTS(SELECT 1 FROM AP_SUPPLIER_SITES_ALL
1952: WHERE vendor_site_id=sel_vendor_site_id))
1953: THEN INTO PON_INTERFACE_ERRORS
1954: (
1955: INTERFACE_TYPE ,

Line 1980: AND NOT EXISTS(SELECT 1 FROM AP_SUPPLIER_SITES_ALL

1976: l_cp_user_id,
1977: SYSDATE,
1978: l_cp_login_id)
1979: WHEN (sel_vendor_site_code IS NOT NULL
1980: AND NOT EXISTS(SELECT 1 FROM AP_SUPPLIER_SITES_ALL
1981: WHERE vendor_site_code=sel_vendor_site_code))
1982: THEN INTO PON_INTERFACE_ERRORS
1983: (
1984: INTERFACE_TYPE ,