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_VENDOR_SITES

Line 54: l_vendor_site_id PO_VENDOR_SITES.VENDOR_SITE_ID%TYPE;

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;
58: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;

Line 55: l_vendor_site_id_per_po PO_VENDOR_SITES.VENDOR_SITE_ID%TYPE;

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;
58: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
59: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;

Line 75: l_primary_paysite_id PO_VENDOR_SITES.VENDOR_SITE_ID%TYPE;

71: l_po_exists_flag VARCHAR2(1) := 'N';
72: current_calling_sequence VARCHAR2(2000);
73: debug_info VARCHAR2(500);
74: l_terms_date_basis VARCHAR2(25);
75: l_primary_paysite_id PO_VENDOR_SITES.VENDOR_SITE_ID%TYPE;
76: --For bug 2713327 Added temporary variable to hold the value of
77: --vendor_id in the interface table
78: l_temp_vendor_id NUMBER(15) := p_invoice_rec.vendor_id;
79: --Bug 4051803

Line 1902: FROM po_vendor_sites pvs

1898: BEGIN
1899: --validate vendor site id
1900: SELECT vendor_site_id, pay_site_flag, terms_date_basis
1901: INTO l_vendor_site_id, l_pay_site_flag, p_terms_date_basis
1902: FROM po_vendor_sites pvs
1903: WHERE vendor_site_id = p_invoice_rec.vendor_site_id
1904: AND nvl(trunc(PVS.INACTIVE_DATE),
1905: AP_IMPORT_INVOICES_PKG.g_inv_sysdate+1)
1906: > AP_IMPORT_INVOICES_PKG.g_inv_sysdate ;

Line 1913: FROM po_vendor_sites pvs

1909: BEGIN
1910: --Get Primary Pay site
1911: SELECT vendor_site_id, pay_site_flag, terms_date_basis
1912: INTO l_vendor_site_id, l_pay_site_flag, p_terms_date_basis
1913: FROM po_vendor_sites pvs
1914: WHERE vendor_id = p_invoice_rec.vendor_id
1915: AND nvl(Primary_pay_site_flag,'N')='Y'
1916: AND pvs.Org_id=p_invoice_rec.org_id
1917: AND nvl(trunc(PVS.INACTIVE_DATE),

Line 1933: FROM po_vendor_sites pvs

1929: BEGIN
1930: --Get pay site id if only one pay site is present
1931: SELECT vendor_site_id, pay_site_flag, terms_date_basis
1932: INTO l_vendor_site_id, l_pay_site_flag, p_terms_date_basis
1933: FROM po_vendor_sites pvs
1934: WHERE vendor_id = p_invoice_rec.vendor_id
1935: AND pvs.Org_id=p_invoice_rec.org_id
1936: AND NVL(pvs.pay_site_flag,'N')='Y'
1937: AND nvl(trunc(PVS.INACTIVE_DATE),

Line 1984: FROM po_vendor_sites

1980: SELECT vendor_site_id, pay_site_flag,
1981: terms_date_basis
1982: INTO l_vendor_site_id_per_code, l_pay_site_flag_per_code,
1983: p_terms_date_basis
1984: FROM po_vendor_sites
1985: WHERE vendor_site_code = p_invoice_rec.vendor_site_code
1986: AND vendor_id = p_invoice_rec.vendor_id
1987: AND nvl(trunc(INACTIVE_DATE),AP_IMPORT_INVOICES_PKG.g_inv_sysdate+1)
1988: > AP_IMPORT_INVOICES_PKG.g_inv_sysdate ;

Line 2066: FROM po_vendor_sites

2062:
2063: BEGIN
2064: SELECT 'X'
2065: INTO l_valid_vendor
2066: FROM po_vendor_sites
2067: WHERE vendor_site_id = nvl(l_vendor_site_id ,l_vendor_site_id_per_code)
2068: AND vendor_id = p_invoice_rec.vendor_id;
2069:
2070: EXCEPTION

Line 2115: FROM po_vendor_sites

2111:
2112: BEGIN
2113: SELECT distinct vendor_id
2114: INTO l_check_vendor_id
2115: FROM po_vendor_sites
2116: WHERE vendor_site_id IN (l_vendor_site_id, p_vendor_site_id_per_po,
2117: l_vendor_site_id_per_code);
2118:
2119: EXCEPTION

Line 2809: -- If Invoice Currency Code is null ,default from PO Vendor Sites

2805:
2806:
2807: --------------------------------------------------------------------------
2808: -- Step 1
2809: -- If Invoice Currency Code is null ,default from PO Vendor Sites
2810: --------------------------------------------------------------------------
2811: IF (p_invoice_rec.invoice_currency_code IS NULL) Then
2812: debug_info := '(Check Invoice Currency Code 1) Invoice Currency Code is '
2813: ||'null ,default from PO Vendor Sites.';

Line 2813: ||'null ,default from PO Vendor Sites.';

2809: -- If Invoice Currency Code is null ,default from PO Vendor Sites
2810: --------------------------------------------------------------------------
2811: IF (p_invoice_rec.invoice_currency_code IS NULL) Then
2812: debug_info := '(Check Invoice Currency Code 1) Invoice Currency Code is '
2813: ||'null ,default from PO Vendor Sites.';
2814: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
2815: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
2816: debug_info);
2817: END IF;

Line 2833: FROM po_vendor_sites

2829: -- If No curr code in vendor site ,then the default exception
2830: -- will reject.
2831: SELECT Invoice_currency_code
2832: INTO p_inv_currency_code
2833: FROM po_vendor_sites
2834: WHERE vendor_site_id = p_invoice_rec.vendor_site_id;
2835: END IF;
2836:
2837: END IF;

Line 3461: FROM po_vendor_sites

3457: -- Get awt group id from supplier site
3458: BEGIN
3459: SELECT awt_group_id
3460: INTO p_awt_group_id
3461: FROM po_vendor_sites
3462: WHERE vendor_id = p_invoice_rec.vendor_id
3463: AND vendor_site_id = p_invoice_rec.vendor_site_id;
3464: EXCEPTION
3465: WHEN no_data_found THEN

Line 3682: FROM po_vendor_sites

3678: -- Get pay awt group id from supplier site
3679: BEGIN
3680: SELECT pay_awt_group_id
3681: INTO p_pay_awt_group_id
3682: FROM po_vendor_sites
3683: WHERE vendor_id = p_invoice_rec.vendor_id
3684: AND vendor_site_id = p_invoice_rec.vendor_site_id;
3685: EXCEPTION
3686: WHEN no_data_found THEN

Line 4308: FROM po_vendor_sites

4304: END IF;
4305:
4306: SELECT terms_id
4307: INTO l_term_id
4308: FROM po_vendor_sites
4309: WHERE vendor_id = p_invoice_rec.vendor_id
4310: AND vendor_site_id = p_invoice_rec.vendor_site_id;
4311:
4312: ELSIF ( (nvl(l_current_invoice_status,'Y') = 'Y') AND -- not rejected already

Line 5401: FROM po_vendor_sites

5397: SELECT bill_to_location_id,
5398: accts_pay_code_combination_id
5399: INTO l_bill_to_location_id,
5400: l_supp_site_liab_ccid
5401: FROM po_vendor_sites
5402: WHERE vendor_site_id = p_invoice_rec.vendor_site_id;
5403:
5404: l_ccid_to_api := NVL(p_invoice_rec.accts_pay_code_combination_id,
5405: l_supp_site_liab_ccid);

Line 7593: from po_vendor_sites

7589: THEN
7590: begin
7591: select distribution_set_id
7592: into p_invoice_lines_tab(i).distribution_set_id
7593: from po_vendor_sites
7594: where vendor_id=p_invoice_rec.vendor_id
7595: and vendor_site_id=p_invoice_rec.vendor_site_id;
7596: exception
7597: when no_data_found then

Line 20000: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;

19996: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;
19997: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
19998: l_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;
19999: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
20000: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
20001:
20002: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;
20003: l_allow_tax_code_override varchar2(10);
20004: l_dummy number;

Line 21458: from po_vendor_sites

21454: p_invoice_rec.vendor_site_id is not null then
21455: begin
21456: select 'x'
21457: into l_dummy
21458: from po_vendor_sites
21459: where vendor_site_id = p_invoice_rec.vendor_site_id
21460: and party_site_id = p_invoice_rec.party_site_id;
21461: exception
21462: when no_data_found then

Line 21505: from po_vendor_sites

21501: and nvl(p_invoice_rec.invoice_type_lookup_code, 'STANDARD') <> 'EXPENSE REPORT' then
21502: Begin
21503: select party_site_id
21504: into p_invoice_rec.party_site_id
21505: from po_vendor_sites
21506: where vendor_site_id = p_invoice_rec.vendor_site_id;
21507: Exception
21508: when no_data_found then
21509: IF (AP_IMPORT_UTILITIES_PKG.insert_rejections