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 71: l_vendor_site_id PO_VENDOR_SITES.VENDOR_SITE_ID%TYPE;

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

Line 72: l_vendor_site_id_per_po PO_VENDOR_SITES.VENDOR_SITE_ID%TYPE;

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

Line 92: l_primary_paysite_id PO_VENDOR_SITES.VENDOR_SITE_ID%TYPE;

88: l_po_exists_flag VARCHAR2(1) := 'N';
89: current_calling_sequence VARCHAR2(2000);
90: debug_info VARCHAR2(500);
91: l_terms_date_basis VARCHAR2(25);
92: l_primary_paysite_id PO_VENDOR_SITES.VENDOR_SITE_ID%TYPE;
93: --For bug 2713327 Added temporary variable to hold the value of
94: --vendor_id in the interface table
95: l_temp_vendor_id NUMBER(15) := p_invoice_rec.vendor_id;
96: --Bug 4051803

Line 2009: FROM po_vendor_sites pvs

2005: BEGIN
2006: --validate vendor site id
2007: SELECT vendor_site_id, pay_site_flag, terms_date_basis
2008: INTO l_vendor_site_id, l_pay_site_flag, p_terms_date_basis
2009: FROM po_vendor_sites pvs
2010: WHERE vendor_site_id = p_invoice_rec.vendor_site_id
2011: AND nvl(trunc(PVS.INACTIVE_DATE),
2012: AP_IMPORT_INVOICES_PKG.g_inv_sysdate+1)
2013: > AP_IMPORT_INVOICES_PKG.g_inv_sysdate ;

Line 2042: FROM po_vendor_sites pvs

2038: BEGIN
2039: --Get Primary Pay site
2040: SELECT vendor_site_id, pay_site_flag, terms_date_basis
2041: INTO l_vendor_site_id, l_pay_site_flag, p_terms_date_basis
2042: FROM po_vendor_sites pvs
2043: WHERE vendor_id = p_invoice_rec.vendor_id
2044: AND nvl(Primary_pay_site_flag,'N')='Y'
2045: AND pvs.Org_id=p_invoice_rec.org_id
2046: AND nvl(trunc(PVS.INACTIVE_DATE),

Line 2062: FROM po_vendor_sites pvs

2058: BEGIN
2059: --Get pay site id if only one pay site is present
2060: SELECT vendor_site_id, pay_site_flag, terms_date_basis
2061: INTO l_vendor_site_id, l_pay_site_flag, p_terms_date_basis
2062: FROM po_vendor_sites pvs
2063: WHERE vendor_id = p_invoice_rec.vendor_id
2064: AND pvs.Org_id=p_invoice_rec.org_id
2065: AND NVL(pvs.pay_site_flag,'N')='Y'
2066: AND nvl(trunc(PVS.INACTIVE_DATE),

Line 2114: FROM po_vendor_sites

2110: SELECT vendor_site_id, pay_site_flag,
2111: terms_date_basis
2112: INTO l_vendor_site_id_per_code, l_pay_site_flag_per_code,
2113: p_terms_date_basis
2114: FROM po_vendor_sites
2115: WHERE vendor_site_code = p_invoice_rec.vendor_site_code
2116: AND vendor_id = p_invoice_rec.vendor_id
2117: AND nvl(trunc(INACTIVE_DATE),AP_IMPORT_INVOICES_PKG.g_inv_sysdate+1)
2118: > AP_IMPORT_INVOICES_PKG.g_inv_sysdate ;

Line 2196: FROM po_vendor_sites

2192:
2193: BEGIN
2194: SELECT 'X'
2195: INTO l_valid_vendor
2196: FROM po_vendor_sites
2197: WHERE vendor_site_id = nvl(l_vendor_site_id ,l_vendor_site_id_per_code)
2198: AND vendor_id = p_invoice_rec.vendor_id;
2199:
2200: EXCEPTION

Line 2245: FROM po_vendor_sites

2241:
2242: BEGIN
2243: SELECT distinct vendor_id
2244: INTO l_check_vendor_id
2245: FROM po_vendor_sites
2246: WHERE vendor_site_id IN (l_vendor_site_id, p_vendor_site_id_per_po,
2247: l_vendor_site_id_per_code);
2248:
2249: EXCEPTION

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

2947:
2948:
2949: --------------------------------------------------------------------------
2950: -- Step 1
2951: -- If Invoice Currency Code is null ,default from PO Vendor Sites
2952: --------------------------------------------------------------------------
2953: IF (p_invoice_rec.invoice_currency_code IS NULL) Then
2954: debug_info := '(Check Invoice Currency Code 1) Invoice Currency Code is '
2955: ||'null ,default from PO Vendor Sites.';

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

2951: -- If Invoice Currency Code is null ,default from PO Vendor Sites
2952: --------------------------------------------------------------------------
2953: IF (p_invoice_rec.invoice_currency_code IS NULL) Then
2954: debug_info := '(Check Invoice Currency Code 1) Invoice Currency Code is '
2955: ||'null ,default from PO Vendor Sites.';
2956: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
2957: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
2958: debug_info);
2959: END IF;

Line 2975: FROM po_vendor_sites

2971: -- If No curr code in vendor site ,then the default exception
2972: -- will reject.
2973: SELECT Invoice_currency_code
2974: INTO p_inv_currency_code
2975: FROM po_vendor_sites
2976: WHERE vendor_site_id = p_invoice_rec.vendor_site_id;
2977: END IF;*/ --commented for Bug9184247
2978: --Start Bug9184247
2979: IF p_invoice_rec.vendor_site_id IS NOT NULL

Line 2984: FROM po_vendor_sites

2980: THEN
2981: BEGIN
2982: SELECT Invoice_currency_code
2983: INTO p_inv_currency_code
2984: FROM po_vendor_sites
2985: WHERE vendor_site_id = p_invoice_rec.vendor_site_id;
2986: EXCEPTION
2987: WHEN OTHERS THEN
2988: p_inv_currency_code := null;

Line 3658: FROM po_vendor_sites

3654: -- Get awt group id from supplier site
3655: BEGIN
3656: SELECT awt_group_id
3657: INTO p_awt_group_id
3658: FROM po_vendor_sites
3659: WHERE vendor_id = p_invoice_rec.vendor_id
3660: AND vendor_site_id = p_invoice_rec.vendor_site_id;
3661: EXCEPTION
3662: WHEN no_data_found THEN

Line 3879: FROM po_vendor_sites

3875: -- Get pay awt group id from supplier site
3876: BEGIN
3877: SELECT pay_awt_group_id
3878: INTO p_pay_awt_group_id
3879: FROM po_vendor_sites
3880: WHERE vendor_id = p_invoice_rec.vendor_id
3881: AND vendor_site_id = p_invoice_rec.vendor_site_id;
3882: EXCEPTION
3883: WHEN no_data_found THEN

Line 4575: FROM po_vendor_sites

4571: END IF;
4572:
4573: SELECT terms_id
4574: INTO l_term_id
4575: FROM po_vendor_sites
4576: WHERE vendor_id = p_invoice_rec.vendor_id
4577: AND vendor_site_id = p_invoice_rec.vendor_site_id;
4578:
4579: ELSIF ( (nvl(l_current_invoice_status,'Y') = 'Y') AND -- not rejected already

Line 5839: FROM po_vendor_sites

5835: SELECT bill_to_location_id,
5836: accts_pay_code_combination_id
5837: INTO l_bill_to_location_id,
5838: l_supp_site_liab_ccid
5839: FROM po_vendor_sites
5840: WHERE vendor_site_id = p_invoice_rec.vendor_site_id;
5841:
5842: l_ccid_to_api := NVL(p_invoice_rec.accts_pay_code_combination_id,
5843: l_supp_site_liab_ccid);

Line 8213: from po_vendor_sites

8209: THEN
8210: begin
8211: select distribution_set_id
8212: into p_invoice_lines_tab(i).distribution_set_id
8213: from po_vendor_sites
8214: where vendor_id=p_invoice_rec.vendor_id
8215: and vendor_site_id=p_invoice_rec.vendor_site_id;
8216: exception
8217: when no_data_found then

Line 20882: from po_vendor_sites pvs

20878:
20879: if (l_income_tax_region_flag = 'Y') then
20880: select pvs.state
20881: into l_income_tax_region
20882: from po_vendor_sites pvs
20883: where pvs.vendor_id = p_invoice_rec.vendor_id
20884: and pvs.vendor_site_id = p_invoice_rec.vendor_site_id;
20885: end if;
20886: p_invoice_lines_rec.income_tax_region := l_income_tax_region;

Line 21805: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;

21801: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;
21802: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
21803: l_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;
21804: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
21805: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
21806:
21807: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;
21808: l_allow_tax_code_override varchar2(10);
21809: l_dummy number;

Line 23302: from po_vendor_sites

23298: p_invoice_rec.vendor_site_id is not null then
23299: begin
23300: select 'x'
23301: into l_dummy
23302: from po_vendor_sites
23303: where vendor_site_id = p_invoice_rec.vendor_site_id
23304: and party_site_id = p_invoice_rec.party_site_id;
23305: exception
23306: when no_data_found then

Line 23363: from po_vendor_sites

23359: and nvl(l_vendor_type_lookup_code, 'VENDOR') <> 'EMPLOYEE')) then
23360: Begin
23361: select party_site_id
23362: into p_invoice_rec.party_site_id
23363: from po_vendor_sites
23364: where vendor_site_id = p_invoice_rec.vendor_site_id;
23365: Exception
23366: when no_data_found then
23367: IF (AP_IMPORT_UTILITIES_PKG.insert_rejections