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 53: l_vendor_id PO_VENDORS.VENDOR_ID%TYPE;

49: check_inv_validation_failure EXCEPTION;
50: import_invoice_failure EXCEPTION;
51:
52: l_current_invoice_status VARCHAR2(1) := 'Y';
53: l_vendor_id PO_VENDORS.VENDOR_ID%TYPE;
54: l_vendor_site_id PO_VENDOR_SITES.VENDOR_SITE_ID%TYPE;
55: l_vendor_site_id_per_po PO_VENDOR_SITES.VENDOR_SITE_ID%TYPE;
56: l_invoice_num AP_INVOICES.INVOICE_NUM%TYPE;
57: l_inv_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;

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

1342: l_vendor_site_id NUMBER;
1343: l_po_exists_flag VARCHAR2(1) := 'N';
1344: current_calling_sequence VARCHAR2(2000);
1345: debug_info VARCHAR2(500);
1346: l_invoice_vendor_name po_vendors.vendor_name%TYPE := '';
1347:
1348: BEGIN
1349: -- Update the calling sequence
1350: --

Line 1415: FROM po_vendors

1411: BEGIN
1412: -- Get contextual Information for XML Gateway
1413: SELECT vendor_name
1414: INTO l_invoice_vendor_name
1415: FROM po_vendors
1416: WHERE vendor_id = p_invoice_rec.vendor_id;
1417:
1418: IF (AP_IMPORT_UTILITIES_PKG.insert_rejections
1419: (AP_IMPORT_INVOICES_PKG.g_invoices_table,

Line 1538: l_vendor_id PO_VENDORS.VENDOR_ID%TYPE :=

1534: p_calling_sequence IN VARCHAR2)
1535: RETURN BOOLEAN IS
1536:
1537: supplier_check_failure EXCEPTION;
1538: l_vendor_id PO_VENDORS.VENDOR_ID%TYPE :=
1539: p_invoice_rec.vendor_id;
1540: l_vendor_id_per_num PO_VENDORS.VENDOR_ID%TYPE;
1541: l_vendor_id_per_name PO_VENDORS.VENDOR_ID%TYPE;
1542: l_current_invoice_status VARCHAR2(1) := 'Y';

Line 1540: l_vendor_id_per_num PO_VENDORS.VENDOR_ID%TYPE;

1536:
1537: supplier_check_failure EXCEPTION;
1538: l_vendor_id PO_VENDORS.VENDOR_ID%TYPE :=
1539: p_invoice_rec.vendor_id;
1540: l_vendor_id_per_num PO_VENDORS.VENDOR_ID%TYPE;
1541: l_vendor_id_per_name PO_VENDORS.VENDOR_ID%TYPE;
1542: l_current_invoice_status VARCHAR2(1) := 'Y';
1543: return_vendor_id NUMBER(15);
1544: current_calling_sequence VARCHAR2(2000);

Line 1541: l_vendor_id_per_name PO_VENDORS.VENDOR_ID%TYPE;

1537: supplier_check_failure EXCEPTION;
1538: l_vendor_id PO_VENDORS.VENDOR_ID%TYPE :=
1539: p_invoice_rec.vendor_id;
1540: l_vendor_id_per_num PO_VENDORS.VENDOR_ID%TYPE;
1541: l_vendor_id_per_name PO_VENDORS.VENDOR_ID%TYPE;
1542: l_current_invoice_status VARCHAR2(1) := 'Y';
1543: return_vendor_id NUMBER(15);
1544: current_calling_sequence VARCHAR2(2000);
1545: debug_info VARCHAR2(500);

Line 1601: FROM po_vendors pv

1597: END IF;
1598:
1599: SELECT vendor_id
1600: INTO l_vendor_id
1601: FROM po_vendors pv
1602: WHERE vendor_id = p_invoice_rec.vendor_id
1603: AND nvl(trunc(PV.START_DATE_ACTIVE),
1604: AP_IMPORT_INVOICES_PKG.g_inv_sysdate)
1605: <= AP_IMPORT_INVOICES_PKG.g_inv_sysdate

Line 1627: FROM po_vendors PV

1623: END IF;
1624:
1625: SELECT vendor_id
1626: INTO l_vendor_id_per_num
1627: FROM po_vendors PV
1628: WHERE segment1 = p_invoice_rec.vendor_num
1629: AND nvl(trunc(PV.START_DATE_ACTIVE),
1630: AP_IMPORT_INVOICES_PKG.g_inv_sysdate)
1631: <= AP_IMPORT_INVOICES_PKG.g_inv_sysdate

Line 1653: FROM po_vendors PV

1649: END IF;
1650:
1651: SELECT vendor_id
1652: INTO l_vendor_id_per_name
1653: FROM po_vendors PV
1654: WHERE vendor_name = p_invoice_rec.vendor_name
1655: AND nvl(trunc(PV.START_DATE_ACTIVE),
1656: AP_IMPORT_INVOICES_PKG.g_inv_sysdate)
1657: <= AP_IMPORT_INVOICES_PKG.g_inv_sysdate

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

6790: END IF;
6791:
6792: -- Since vendor is already validated
6793: -- Rejection should happen only if the Project Related
6794: -- invoices do not have a valid employee_id in PO_vendors
6795:
6796: IF (l_temp_line_status = 'N') THEN
6797: l_current_invoice_status := l_temp_line_status;
6798: END IF;

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

8341: debug_info VARCHAR2(500);
8342:
8343: -- Contextual Information for XML Gateway
8344: l_po_currency_code VARCHAR2(15) := '';
8345: l_invoice_vendor_name po_vendors.vendor_name%TYPE := '';
8346:
8347: l_price_correct_inv_id NUMBER;
8348: l_pc_inv_valid VARCHAR2(1);
8349: l_base_match_amount NUMBER;

Line 11000: FROM po_vendors

10996: BEGIN
10997:
10998: SELECT vendor_name
10999: INTO l_invoice_vendor_name
11000: FROM po_vendors
11001: WHERE vendor_id = p_invoice_rec.vendor_id;
11002:
11003: IF (AP_IMPORT_UTILITIES_PKG.insert_rejections(
11004: AP_IMPORT_INVOICES_PKG.g_invoice_lines_table,

Line 18922: From po_vendors pov

18918:
18919: -- Bug 7599916
18920: Cursor c_type_1099(c_vendor_id NUMBER) Is
18921: Select pov.type_1099
18922: From po_vendors pov
18923: Where pov.vendor_id = c_vendor_id;
18924: -- Bug 7599916
18925:
18926: BEGIN

Line 21428: from po_vendors

21424: if p_invoice_rec.party_id is not null and p_invoice_rec.vendor_id is not null then
21425: begin
21426: select 'x'
21427: into l_dummy
21428: from po_vendors
21429: where vendor_id = p_invoice_rec.vendor_id
21430: and party_id = p_invoice_rec.party_id;
21431: exception
21432: when no_data_found then

Line 21531: from po_vendors

21527: if p_invoice_rec.vendor_id is not null and p_invoice_rec.party_id is null then
21528: Begin
21529: select party_id
21530: into p_invoice_rec.party_id
21531: from po_vendors
21532: where vendor_id = p_invoice_rec.vendor_id;
21533: Exception
21534: when no_data_found then
21535: IF (AP_IMPORT_UTILITIES_PKG.insert_rejections