APPS.PON_OPEN_INTERFACE_PVT dependencies on AP_SUPPLIERS

Line 1675: FROM AP_SUPPLIERS

1671: -- If the vendor_name and vendor_id is not null
1672: IF (L_VENDOR_NAME IS NOT NULL) THEN
1673: SELECT VENDOR_ID, PARTY_ID
1674: INTO L_VENDOR_ID, l_TRADING_PARTNER_ID
1675: FROM AP_SUPPLIERS
1676: WHERE VENDOR_NAME=L_VENDOR_NAME;
1677: -- if vendor_name is null and vendor_id is not null
1678: ELSIF (L_VENDOR_ID IS NOT NULL) THEN
1679: SELECT VENDOR_NAME, PARTY_ID

Line 1681: FROM AP_SUPPLIERS

1677: -- if vendor_name is null and vendor_id is not null
1678: ELSIF (L_VENDOR_ID IS NOT NULL) THEN
1679: SELECT VENDOR_NAME, PARTY_ID
1680: INTO L_VENDOR_NAME, l_TRADING_PARTNER_ID
1681: FROM AP_SUPPLIERS
1682: WHERE VENDOR_ID=L_VENDOR_ID;
1683: END IF;
1684:
1685: /****** Get Outcome Operating Unit Id ******/

Line 1834: AND NOT EXISTS(SELECT 1 FROM AP_SUPPLIERS

1830: l_cp_user_id,
1831: SYSDATE,
1832: l_cp_login_id)
1833: WHEN (sel_vendor_name IS NOT NULL AND sel_vendor_id IS NOT NULL
1834: AND NOT EXISTS(SELECT 1 FROM AP_SUPPLIERS
1835: WHERE VENDOR_NAME=sel_vendor_name AND VENDOR_ID=sel_vendor_id))
1836: THEN INTO PON_INTERFACE_ERRORS
1837: (
1838: INTERFACE_TYPE ,

Line 1863: AND NOT EXISTS(SELECT 1 FROM AP_SUPPLIERS

1859: l_cp_user_id,
1860: SYSDATE,
1861: l_cp_login_id)
1862: WHEN (sel_vendor_id IS NOT NULL
1863: AND NOT EXISTS(SELECT 1 FROM AP_SUPPLIERS
1864: WHERE VENDOR_ID=sel_vendor_id))
1865: THEN INTO PON_INTERFACE_ERRORS
1866: (
1867: INTERFACE_TYPE ,

Line 1892: AND NOT EXISTS(SELECT 1 FROM AP_SUPPLIERS

1888: l_cp_user_id,
1889: SYSDATE,
1890: l_cp_login_id)
1891: WHEN (sel_vendor_NAME IS NOT NULL
1892: AND NOT EXISTS(SELECT 1 FROM AP_SUPPLIERS
1893: WHERE VENDOR_NAME=sel_vendor_NAME))
1894: THEN INTO PON_INTERFACE_ERRORS
1895: (
1896: INTERFACE_TYPE ,