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.AP_IMPORT_VALIDATION_PKG dependencies on PO_VENDORS

Line 70: l_vendor_id PO_VENDORS.VENDOR_ID%TYPE;

66: check_inv_validation_failure EXCEPTION;
67: import_invoice_failure EXCEPTION;
68:
69: l_current_invoice_status VARCHAR2(1) := 'Y';
70: l_vendor_id PO_VENDORS.VENDOR_ID%TYPE;
71: l_vendor_site_id PO_VENDOR_SITES.VENDOR_SITE_ID%TYPE;
72: l_vendor_site_id_per_po PO_VENDOR_SITES.VENDOR_SITE_ID%TYPE;
73: l_invoice_num AP_INVOICES.INVOICE_NUM%TYPE;
74: l_inv_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;

Line 1449: l_invoice_vendor_name po_vendors.vendor_name%TYPE := '';

1445: l_vendor_site_id NUMBER;
1446: l_po_exists_flag VARCHAR2(1) := 'N';
1447: current_calling_sequence VARCHAR2(2000);
1448: debug_info VARCHAR2(500);
1449: l_invoice_vendor_name po_vendors.vendor_name%TYPE := '';
1450: l_closed_code VARCHAR2(25); /* 1Off Bug 10288184 / 11i Bug 8410175 */
1451:
1452: BEGIN
1453: -- Update the calling sequence

Line 1522: FROM po_vendors

1518: BEGIN
1519: -- Get contextual Information for XML Gateway
1520: SELECT vendor_name
1521: INTO l_invoice_vendor_name
1522: FROM po_vendors
1523: WHERE vendor_id = p_invoice_rec.vendor_id;
1524:
1525: IF (AP_IMPORT_UTILITIES_PKG.insert_rejections
1526: (AP_IMPORT_INVOICES_PKG.g_invoices_table,

Line 1645: l_vendor_id PO_VENDORS.VENDOR_ID%TYPE :=

1641: p_calling_sequence IN VARCHAR2)
1642: RETURN BOOLEAN IS
1643:
1644: supplier_check_failure EXCEPTION;
1645: l_vendor_id PO_VENDORS.VENDOR_ID%TYPE :=
1646: p_invoice_rec.vendor_id;
1647: l_vendor_id_per_num PO_VENDORS.VENDOR_ID%TYPE;
1648: l_vendor_id_per_name PO_VENDORS.VENDOR_ID%TYPE;
1649: l_current_invoice_status VARCHAR2(1) := 'Y';

Line 1647: l_vendor_id_per_num PO_VENDORS.VENDOR_ID%TYPE;

1643:
1644: supplier_check_failure EXCEPTION;
1645: l_vendor_id PO_VENDORS.VENDOR_ID%TYPE :=
1646: p_invoice_rec.vendor_id;
1647: l_vendor_id_per_num PO_VENDORS.VENDOR_ID%TYPE;
1648: l_vendor_id_per_name PO_VENDORS.VENDOR_ID%TYPE;
1649: l_current_invoice_status VARCHAR2(1) := 'Y';
1650: return_vendor_id NUMBER(15);
1651: current_calling_sequence VARCHAR2(2000);

Line 1648: l_vendor_id_per_name PO_VENDORS.VENDOR_ID%TYPE;

1644: supplier_check_failure EXCEPTION;
1645: l_vendor_id PO_VENDORS.VENDOR_ID%TYPE :=
1646: p_invoice_rec.vendor_id;
1647: l_vendor_id_per_num PO_VENDORS.VENDOR_ID%TYPE;
1648: l_vendor_id_per_name PO_VENDORS.VENDOR_ID%TYPE;
1649: l_current_invoice_status VARCHAR2(1) := 'Y';
1650: return_vendor_id NUMBER(15);
1651: current_calling_sequence VARCHAR2(2000);
1652: debug_info VARCHAR2(500);

Line 1708: FROM po_vendors pv

1704: END IF;
1705:
1706: SELECT vendor_id
1707: INTO l_vendor_id
1708: FROM po_vendors pv
1709: WHERE vendor_id = p_invoice_rec.vendor_id
1710: AND nvl(trunc(PV.START_DATE_ACTIVE),
1711: AP_IMPORT_INVOICES_PKG.g_inv_sysdate)
1712: <= AP_IMPORT_INVOICES_PKG.g_inv_sysdate

Line 1734: FROM po_vendors PV

1730: END IF;
1731:
1732: SELECT vendor_id
1733: INTO l_vendor_id_per_num
1734: FROM po_vendors PV
1735: WHERE segment1 = p_invoice_rec.vendor_num
1736: AND nvl(trunc(PV.START_DATE_ACTIVE),
1737: AP_IMPORT_INVOICES_PKG.g_inv_sysdate)
1738: <= AP_IMPORT_INVOICES_PKG.g_inv_sysdate

Line 1760: FROM po_vendors PV

1756: END IF;
1757:
1758: SELECT vendor_id
1759: INTO l_vendor_id_per_name
1760: FROM po_vendors PV
1761: WHERE vendor_name = p_invoice_rec.vendor_name
1762: AND nvl(trunc(PV.START_DATE_ACTIVE),
1763: AP_IMPORT_INVOICES_PKG.g_inv_sysdate)
1764: <= AP_IMPORT_INVOICES_PKG.g_inv_sysdate

Line 7336: -- invoices do not have a valid employee_id in PO_vendors

7332: END IF;
7333:
7334: -- Since vendor is already validated
7335: -- Rejection should happen only if the Project Related
7336: -- invoices do not have a valid employee_id in PO_vendors
7337:
7338: IF (l_temp_line_status = 'N') THEN
7339: l_current_invoice_status := l_temp_line_status;
7340: END IF;

Line 9160: l_invoice_vendor_name po_vendors.vendor_name%TYPE := '';

9156: debug_info VARCHAR2(500);
9157:
9158: -- Contextual Information for XML Gateway
9159: l_po_currency_code VARCHAR2(15) := '';
9160: l_invoice_vendor_name po_vendors.vendor_name%TYPE := '';
9161:
9162: l_price_correct_inv_id NUMBER;
9163: l_pc_inv_valid VARCHAR2(1);
9164: l_base_match_amount NUMBER;

Line 12118: FROM po_vendors

12114: BEGIN
12115:
12116: SELECT vendor_name
12117: INTO l_invoice_vendor_name
12118: FROM po_vendors
12119: WHERE vendor_id = p_invoice_rec.vendor_id;
12120:
12121: IF (AP_IMPORT_UTILITIES_PKG.insert_rejections(
12122: AP_IMPORT_INVOICES_PKG.g_invoice_lines_table,

Line 20639: From po_vendors pov

20635:
20636: -- Bug 7599916
20637: Cursor c_type_1099(c_vendor_id NUMBER) Is
20638: Select pov.type_1099
20639: From po_vendors pov
20640: Where pov.vendor_id = c_vendor_id;
20641: -- Bug 7599916
20642:
20643: BEGIN

Line 23272: from po_vendors

23268: if p_invoice_rec.party_id is not null and p_invoice_rec.vendor_id is not null then
23269: begin
23270: select 'x'
23271: into l_dummy
23272: from po_vendors
23273: where vendor_id = p_invoice_rec.vendor_id
23274: and party_id = p_invoice_rec.party_id;
23275: exception
23276: when no_data_found then

Line 23389: from po_vendors

23385: if p_invoice_rec.vendor_id is not null and p_invoice_rec.party_id is null then
23386: Begin
23387: select party_id
23388: into p_invoice_rec.party_id
23389: from po_vendors
23390: where vendor_id = p_invoice_rec.vendor_id;
23391: Exception
23392: when no_data_found then
23393: IF (AP_IMPORT_UTILITIES_PKG.insert_rejections