APPS.FV_CCR_UTIL_PVT dependencies on AP_SUPPLIER_SITES_ALL

Line 226: FROM ap_supplier_sites_all pavs, hz_party_sites hps

222: --WHERE vendor_id=p_supp_id
223: --AND vendor_site_code=p_site_name
224: --AND org_id=p_org;
225: SELECT pavs.vendor_site_id, hps.duns_number_c
226: FROM ap_supplier_sites_all pavs, hz_party_sites hps
227: WHERE pavs.vendor_id = p_supp_id
228: AND pavs.vendor_site_code = p_site_name
229: AND pavs.org_id = p_org
230: AND pavs.party_site_id = hps.party_site_id;

Line 260: FROM ap_supplier_sites_all

256: BEGIN
257: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_vendor_site_code';
258: SELECT vendor_site_code INTO x_site_code
259: --FROM po_vendor_sites_all
260: FROM ap_supplier_sites_all
261: WHERE vendor_site_id = p_vendor_site_id;
262: EXCEPTION
263: WHEN OTHERS THEN
264: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,sqlerrm);

Line 749: FROM ap_supplier_sites_all

745: city ,
746: state ,
747: country ,
748: zip
749: FROM ap_supplier_sites_all
750: WHERE vendor_id =p_exist_vendor_id
751: AND vendor_site_code=p_existing_vendor_site_code
752: AND org_id =p_existing_org_id;
753:

Line 1449: FROM ap_supplier_sites_all

1445: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'Before address comparision: whether new and old site address same or not -> ');
1446: IF(NVL(l_vendor_id,0) <> 0 AND NVL(p_pay_site_id,0) <> 0) THEN
1447: SELECT COUNT(*)
1448: INTO l_supplier_sites_count
1449: FROM ap_supplier_sites_all
1450: WHERE vendor_id=l_vendor_id
1451: AND org_id =p_org_id;
1452:
1453: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_supplier_sites_count-> '||l_supplier_sites_count);

Line 1513: UPDATE ap_supplier_sites_all

1509: when others then
1510: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text|| ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);
1511: end;
1512:
1513: UPDATE ap_supplier_sites_all
1514: SET inactive_date = sysdate,
1515: vendor_site_code=substr('old_'||VENDOR_SITE_ID||'_'||p_duns,0,15)
1516: WHERE duns_number=p_duns
1517: AND vendor_id =l_vendor_id

Line 1721: UPDATE ap_supplier_sites_all

1717: /* Code for bug 9320586 Starting */
1718: /*Updating to move to new pay address*/
1719: IF(l_change_pay_site_flg='Y') THEN
1720:
1721: UPDATE ap_supplier_sites_all
1722: SET duns_number=0,
1723: party_site_id=0
1724: WHERE vendor_site_code='old_'||p_duns
1725: AND vendor_id =l_vendor_id

Line 2051: from fv_ccr_orgs o, hr_organization_units ou, ap_supplier_sites_all vs

2047:
2048: --v_org_id := fv_ccr_util_pvt.get_profile_option('ORG_ID');
2049: IF p_org_id is NOT NULL THEN
2050: for crec in (select pay_site_id
2051: from fv_ccr_orgs o, hr_organization_units ou, ap_supplier_sites_all vs
2052: where o.pay_site_id is not null
2053: and o.pay_site_id = vs.VENDOR_SITE_ID
2054: and vs.ORG_ID = ou.organization_id
2055: and ou.organization_id = nvl(p_org_id,ou.organization_id)

Line 2371: -- in ap_supplier_sites_all table

2367: BEGIN
2368: --Bug9790495
2369: -- Logic to check if user is ISP UI is available or not.
2370: -- If ISP UI is not available then not include populate attributs
2371: -- in ap_supplier_sites_all table
2372: IF (PO_ISPCODELEVEL_PVT.get_curr_isp_supp_code_level
2373: >= PO_ISPCODELEVEL_PVT.G_ISP_SUP_CODE_LEVEL_CLM_BASE) THEN
2374:
2375:

Line 2592: FROM ap_supplier_sites_all

2588: BEGIN
2589:
2590: SELECT party_site_id,location_id
2591: INTO l_party_site_id,l_location_id
2592: FROM ap_supplier_sites_all
2593: WHERE vendor_site_id = p_vendor_site_id;
2594:
2595: x_party_site_id := l_party_site_id;
2596:

Line 3050: FROM ap_supplier_sites_all

3046: FROM ap_suppliers
3047: WHERE vendor_id=p_vendor_id;
3048:
3049: SELECT party_site_id INTO l_party_site_id
3050: FROM ap_supplier_sites_all
3051: WHERE vendor_site_id = p_pay_site_id;
3052:
3053: if(nvl(l_party_id,0) <> 0 and nvl(p_new_bank_account_id,0) <> 0) THEN
3054: add_owner_party(l_party_id,p_new_bank_account_id);