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_VENDOR_PUB_PKG dependencies on PO_VENDOR_SITES_ALL

Line 230: --FROM po_vendor_sites_all SITE

226: IF x_org_id is NOT NULL THEN
227: SELECT count(*)
228: INTO l_dup_count_org_id
229: -- bug 7430783 Changing validation table to ap_supplier_sites_all
230: --FROM po_vendor_sites_all SITE
231: FROM ap_supplier_sites_all SITE
232: WHERE SITE.vendor_id = x_vendor_id
233: AND SITE.org_id = x_org_id
234: AND UPPER(SITE.vendor_site_code) = UPPER(x_vendor_site_code);

Line 240: --FROM po_vendor_sites_all SITE, HR_OPERATING_UNITS ORG

236: ELSIF (x_org_id is NULL and x_org_name is NOT NULL) THEN
237: SELECT count(*)
238: INTO l_dup_count_org_name
239: -- bug 7430783 Changing validation table to ap_supplier_sites_all
240: --FROM po_vendor_sites_all SITE, HR_OPERATING_UNITS ORG
241: FROM ap_supplier_sites_all SITE, HR_OPERATING_UNITS ORG
242: WHERE SITE.vendor_id = x_vendor_id
243: AND ORG.name = x_org_name
244: AND UPPER(vendor_site_code) = UPPER(x_vendor_site_code)

Line 1761: l_dummy po_vendor_sites_all.vendor_site_id%TYPE;

1757: p_vendor_id IN NUMBER,
1758: p_org_id IN NUMBER,
1759: x_valid OUT NOCOPY BOOLEAN
1760: ) IS
1761: l_dummy po_vendor_sites_all.vendor_site_id%TYPE;
1762:
1763: BEGIN
1764: x_valid := TRUE;
1765:

Line 1768: FROM po_vendor_sites_all

1764: x_valid := TRUE;
1765:
1766: SELECT vendor_site_id
1767: INTO l_dummy
1768: FROM po_vendor_sites_all
1769: WHERE vendor_id = p_vendor_id
1770: AND vendor_site_id = p_default_pay_site_id
1771: AND org_id = p_org_id
1772: AND nvl(inactive_date, sysdate +1 ) > sysdate

Line 2432: FROM po_vendor_sites_all

2428: IF p_selling_company_identifier is not null THEN
2429:
2430: SELECT COUNT(vendor_id)
2431: INTO l_vendor_count
2432: FROM po_vendor_sites_all
2433: WHERE selling_company_identifier = p_selling_company_identifier
2434: AND vendor_id <> p_vendor_id;
2435:
2436: IF l_vendor_count > 0 THEN

Line 2837: l_dummy po_vendor_sites_all.vendor_site_id%TYPE;

2833: p_int_table IN VARCHAR2,
2834: p_int_key IN VARCHAR2,
2835: x_valid OUT NOCOPY BOOLEAN) IS
2836:
2837: l_dummy po_vendor_sites_all.vendor_site_id%TYPE;
2838: l_api_name CONSTANT VARCHAR2(30) := 'Check_Vendor_Site_Id';
2839: BEGIN
2840:
2841: x_valid := TRUE;

Line 2845: FROM po_vendor_sites_all

2841: x_valid := TRUE;
2842:
2843: SELECT vendor_site_id
2844: INTO l_dummy
2845: FROM po_vendor_sites_all
2846: WHERE vendor_site_id = p_vendor_site_id
2847: AND nvl(inactive_date, sysdate +1 ) > sysdate;
2848:
2849: EXCEPTION

Line 2903: l_vendor_site_code PO_VENDOR_SITES_ALL.vendor_site_code%TYPE;

2899: x_valid OUT NOCOPY BOOLEAN) IS
2900:
2901: l_org_id HR_OPERATING_UNITS.organization_id%TYPE;
2902: l_org_name HR_OPERATING_UNITS.name%TYPE;
2903: l_vendor_site_code PO_VENDOR_SITES_ALL.vendor_site_code%TYPE;
2904: l_api_name CONSTANT VARCHAR2(30) := 'Check_Org_Id_Name_Site_Code';
2905: l_match_count NUMBER;
2906: BEGIN
2907: x_valid := TRUE;

Line 2914: FROM po_vendor_sites_all

2910: BEGIN
2911: if(p_vendor_site_id is not null) then
2912: SELECT vendor_site_code, vendor_site_id
2913: INTO l_vendor_site_code,p_vendor_site_id
2914: FROM po_vendor_sites_all
2915: WHERE vendor_site_code = p_vendor_site_code
2916: AND vendor_site_id=p_vendor_site_id;
2917: else
2918: SELECT count(1) into l_match_count

Line 2919: FROM po_vendor_sites_all

2915: WHERE vendor_site_code = p_vendor_site_code
2916: AND vendor_site_id=p_vendor_site_id;
2917: else
2918: SELECT count(1) into l_match_count
2919: FROM po_vendor_sites_all
2920: WHERE vendor_site_code = p_vendor_site_code
2921: AND vendor_id=p_vendor_id;
2922: IF l_match_count <> 1 THEN
2923: x_valid := FALSE;

Line 2950: FROM PO_VENDOR_SITES_ALL

2946: END IF;
2947: ELSE
2948: SELECT vendor_site_code, vendor_site_id
2949: INTO l_vendor_site_code,p_vendor_site_id
2950: FROM PO_VENDOR_SITES_ALL
2951: WHERE vendor_site_code = p_vendor_site_code
2952: AND vendor_id = p_vendor_id;
2953: END IF;
2954: end if;

Line 2995: FROM PO_VENDOR_SITES_ALL

2991: the vendor-site-code,we have split the statement into two cases*/
2992: if(p_vendor_site_id is not null) then
2993: SELECT vendor_site_code, vendor_site_id
2994: INTO l_vendor_site_code,p_vendor_site_id
2995: FROM PO_VENDOR_SITES_ALL
2996: WHERE org_id = p_org_id
2997: AND vendor_site_code = p_vendor_site_code
2998: AND vendor_site_id=p_vendor_site_id;
2999: else

Line 3002: FROM PO_VENDOR_SITES_ALL

2998: AND vendor_site_id=p_vendor_site_id;
2999: else
3000: SELECT vendor_site_code, vendor_site_id
3001: INTO l_vendor_site_code,p_vendor_site_id
3002: FROM PO_VENDOR_SITES_ALL
3003: WHERE org_id = p_org_id
3004: AND vendor_site_code=p_vendor_site_code
3005: AND vendor_id=p_vendor_id; /* Bug 9844445 */
3006: end if;

Line 3047: FROM PO_VENDOR_SITES_ALL SITE, HR_OPERATING_UNITS ORG

3043:
3044: BEGIN
3045: SELECT SITE.vendor_site_code,vendor_site_id
3046: INTO l_vendor_site_code,p_vendor_site_id
3047: FROM PO_VENDOR_SITES_ALL SITE, HR_OPERATING_UNITS ORG
3048: WHERE ORG.name = p_org_name
3049: AND SITE.org_id = ORG.organization_id
3050: AND SITE.vendor_site_code = p_vendor_site_code;
3051:

Line 9271: FROM po_vendor_sites_all pvs

9267:
9268: --get org_id from existing record
9269: SELECT org_id
9270: INTO l_org_id
9271: FROM po_vendor_sites_all pvs
9272: WHERE pvs.vendor_site_id = p_vendor_site_id;
9273:
9274: l_org_context := mo_global.get_access_mode;
9275:

Line 9833: FROM po_vendor_sites_all pvs

9829: ,l_vendor_site_rec.DEBARMENT_START_DATE
9830: ,l_vendor_site_rec.DEBARMENT_END_DATE
9831: -- Ending the Changes for CLM reference data management bug#9499174
9832:
9833: FROM po_vendor_sites_all pvs
9834: WHERE pvs.vendor_site_id = p_vendor_site_id;
9835:
9836: ap_vendor_sites_pkg.update_row(
9837: p_vendor_site_rec => l_vendor_site_rec,

Line 15125: FROM HZ_Party_Sites hps, po_vendor_sites_all pvs

15121: SELECT hps.party_id,
15122: hps.location_id
15123: INTO x_org_party_id,
15124: x_location_id
15125: FROM HZ_Party_Sites hps, po_vendor_sites_all pvs
15126: WHERE pvs.vendor_site_id = p_vendor_contact_rec.vendor_site_id
15127: AND pvs.party_site_id = hps.party_site_id;
15128:
15129: SELECT party_site_id

Line 15159: FROM HZ_Party_Sites hps, po_vendor_sites_all pvs

15155: SELECT hps.party_id,
15156: hps.location_id
15157: INTO x_org_party_id,
15158: x_location_id
15159: FROM HZ_Party_Sites hps, po_vendor_sites_all pvs
15160: WHERE pvs.vendor_site_id = p_vendor_contact_rec.vendor_site_id
15161: AND pvs.party_site_id = hps.party_site_id;
15162:
15163: SELECT party_site_id

Line 15165: FROM po_vendor_sites_all

15161: AND pvs.party_site_id = hps.party_site_id;
15162:
15163: SELECT party_site_id
15164: INTO p_vendor_contact_rec.org_party_site_id
15165: FROM po_vendor_sites_all
15166: WHERE vendor_site_id = p_vendor_contact_rec.vendor_site_id;
15167: -- end B# 8219586
15168: END IF;
15169: END IF;

Line 17035: FROM Po_Vendor_Sites_All

17031: ext_payee_rec.payee_party_site_id := l_party_site_id;
17032:
17033: SELECT org_id
17034: INTO ext_payee_rec.payer_org_id
17035: FROM Po_Vendor_Sites_All
17036: WHERE vendor_site_id = l_vendor_site_id;
17037:
17038: -- As per the discussion with Omar/Jayanta, we will only
17039: -- have payables payment function and no more employee expenses