APPS.PON_WITH_DRAW_PKG dependencies on AP_SUPPLIER_SITES_ALL

Line 32: L_SUPPLIER_SITE_NAME AP_SUPPLIER_SITES_ALL.VENDOR_SITE_CODE%TYPE:=NULL;

28: L_START_DATE DATE;
29: L_END_DATE DATE;
30: L_SUPPLIER AP_SUPPLIERS.VENDOR_NAME%TYPE;
31: L_SUPPLIER_SITE_ID NUMBER;
32: L_SUPPLIER_SITE_NAME AP_SUPPLIER_SITES_ALL.VENDOR_SITE_CODE%TYPE:=NULL;
33: L_FROM_USER HZ_PARTIES.PARTY_NAME%TYPE;
34: X_VIEW_QUOTE_URL VARCHAR2(2000);
35: X_NOTIFICATION_ID NUMBER;
36: L_NOTIF_SUBSCR_FLAG VARCHAR2(1);

Line 319: AP_SUPPLIER_SITES_ALL APS

315: IF L_SUPPLIER_SITE_ID IS NOT NULL AND L_SUPPLIER_SITE_ID <> -1
316: THEN
317: SELECT APS.VENDOR_SITE_CODE INTO L_SUPPLIER_SITE_NAME
318: FROM
319: AP_SUPPLIER_SITES_ALL APS
320: WHERE
321: APS.VENDOR_SITE_ID=L_SUPPLIER_SITE_ID;
322:
323: END IF;

Line 441: L_SUPPLIER_SITE_NAME AP_SUPPLIER_SITES_ALL.VENDOR_SITE_CODE%TYPE:=NULL;

437: L_START_DATE DATE;
438: L_END_DATE DATE;
439: L_SUPPLIER AP_SUPPLIERS.VENDOR_NAME%TYPE;
440: L_SUPPLIER_SITE_ID NUMBER;
441: L_SUPPLIER_SITE_NAME AP_SUPPLIER_SITES_ALL.VENDOR_SITE_CODE%TYPE:=NULL;
442: L_FROM_USER HZ_PARTIES.PARTY_NAME%TYPE;
443:
444: X_VIEW_QUOTE_URL VARCHAR2(2000);
445: X_NOTIFICATION_ID NUMBER;

Line 716: AP_SUPPLIER_SITES_ALL APS

712: THEN
713:
714: SELECT APS.VENDOR_SITE_CODE INTO L_SUPPLIER_SITE_NAME
715: FROM
716: AP_SUPPLIER_SITES_ALL APS
717: WHERE
718: APS.VENDOR_SITE_ID=L_SUPPLIER_SITE_ID;
719:
720: END IF;