eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POR_CONTRACTOR_NOTIFY dependencies on PO_VENDOR_SITES

Line 304: L_VENDOR_SITE_CODE PO_VENDOR_SITES.VENDOR_SITE_CODE%TYPE;

300: IS
301:
302: X_PROGRESS VARCHAR2(300);
303: L_DOC_STRING VARCHAR2(200);
304: L_VENDOR_SITE_CODE PO_VENDOR_SITES.VENDOR_SITE_CODE%TYPE;
305: L_VENDOR_SITE_ID NUMBER;
306: L_VENDOR_CONTACT_ID NUMBER;
307: L_VENDOR_SITE_LANG PO_VENDOR_SITES.LANGUAGE%TYPE;
308: L_ADHOCUSER_LANG WF_LANGUAGES.NLS_LANGUAGE%TYPE;

Line 307: L_VENDOR_SITE_LANG PO_VENDOR_SITES.LANGUAGE%TYPE;

303: L_DOC_STRING VARCHAR2(200);
304: L_VENDOR_SITE_CODE PO_VENDOR_SITES.VENDOR_SITE_CODE%TYPE;
305: L_VENDOR_SITE_ID NUMBER;
306: L_VENDOR_CONTACT_ID NUMBER;
307: L_VENDOR_SITE_LANG PO_VENDOR_SITES.LANGUAGE%TYPE;
308: L_ADHOCUSER_LANG WF_LANGUAGES.NLS_LANGUAGE%TYPE;
309: L_ADHOCUSER_TERRITORY WF_LANGUAGES.NLS_TERRITORY%TYPE;
310: L_EMAIL_PERFORMER WF_USER_ROLES.ROLE_NAME%TYPE := NULL;
311: L_EMAIL_ADDRESS VARCHAR2(2000) := NULL;

Line 327: FROM PO_REQUISITION_SUPPLIERS PRS, PO_VENDOR_SITES_ALL PVS

323: IF (L_REQ_SUPPLIER_ID IS NOT NULL) THEN
324:
325: SELECT PRS.VENDOR_SITE_ID, PRS.VENDOR_CONTACT_ID, PVS.VENDOR_SITE_CODE, PVS.LANGUAGE
326: INTO L_VENDOR_SITE_ID, L_VENDOR_CONTACT_ID, L_VENDOR_SITE_CODE, L_VENDOR_SITE_LANG
327: FROM PO_REQUISITION_SUPPLIERS PRS, PO_VENDOR_SITES_ALL PVS
328: WHERE PRS.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID
329: AND PRS.REQUISITION_SUPPLIER_ID = L_REQ_SUPPLIER_ID;
330:
331: ELSIF (L_REQ_LINE_ID IS NOT NULL) THEN

Line 335: FROM PO_REQUISITION_LINES PRL, PO_VENDOR_SITES_ALL PVS

331: ELSIF (L_REQ_LINE_ID IS NOT NULL) THEN
332:
333: SELECT PRL.VENDOR_SITE_ID, PRL.VENDOR_CONTACT_ID, PVS.VENDOR_SITE_CODE, PVS.LANGUAGE
334: INTO L_VENDOR_SITE_ID, L_VENDOR_CONTACT_ID, L_VENDOR_SITE_CODE, L_VENDOR_SITE_LANG
335: FROM PO_REQUISITION_LINES PRL, PO_VENDOR_SITES_ALL PVS
336: WHERE PRL.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID
337: AND PRL.REQUISITION_LINE_ID = L_REQ_LINE_ID;
338:
339: END IF;

Line 358: FROM PO_VENDOR_SITES_ALL

354: --GET EMAIL ADDRESS FROM SUPPLIER SITE
355: BEGIN
356: SELECT EMAIL_ADDRESS
357: INTO L_EMAIL_ADDRESS
358: FROM PO_VENDOR_SITES_ALL
359: WHERE VENDOR_SITE_ID = L_VENDOR_SITE_ID;
360: EXCEPTION
361: WHEN NO_DATA_FOUND THEN
362: L_EMAIL_ADDRESS := NULL;