APPS.FV_CCR_UTIL_PVT dependencies on FV_CCR_ORGS

Line 1122: UPDATE fv_ccr_orgs

1118: || SQLERRM);
1119: insert_for_report(p_duns,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);
1120: if(l_new_bank_account_id IS NOT NULL AND
1121: l_new_bank_account_id<>0) THEN
1122: UPDATE fv_ccr_orgs
1123: SET bank_account_id = l_new_bank_account_id,
1124: last_update_date=sysdate,
1125: last_updated_by=l_user_id,
1126: last_update_login=l_login_id

Line 1574: UPDATE FV_CCR_ORGS

1570: l_assgn_conc_req_status:=p_assgn_conc_req_status;
1571: END IF;
1572:
1573:
1574: UPDATE FV_CCR_ORGS
1575: SET pay_site_id = l_pay_site_id,
1576: main_address_site_id = l_main_add_site_id,
1577: bank_account_id = l_new_bank_account_id,
1578: conc_request_status=l_assgn_conc_req_status,

Line 1715: UPDATE fv_ccr_orgs

1711: last_update_login=l_login_id
1712: WHERE ccr_id=p_ccr_id;
1713: END IF;
1714: IF(p_assgn_conc_req_status = 'S') THEN
1715: UPDATE fv_ccr_orgs
1716: SET conc_request_status=l_assgn_conc_req_status,
1717: last_update_date=sysdate,
1718: last_updated_by=l_user_id,
1719: last_update_login=l_login_id

Line 1804: delete from fv_ccr_orgs

1800: from fv_ccr_vendors
1801: where ccr_id = p_ccrid;
1802:
1803: if v_plus_four is null then
1804: delete from fv_ccr_orgs
1805: where ccr_id in (
1806: select ccr_id
1807: from fv_ccr_vendors
1808: where duns = (select duns from fv_ccr_vendors where ccr_id =

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

1826:
1827: --v_org_id := fv_ccr_util_pvt.get_profile_option('ORG_ID');
1828: IF p_org_id is NOT NULL THEN
1829: for crec in (select pay_site_id
1830: from fv_ccr_orgs o, hr_organization_units ou, ap_supplier_sites_all vs
1831: where o.pay_site_id is not null
1832: and o.pay_site_id = vs.VENDOR_SITE_ID
1833: and vs.ORG_ID = ou.organization_id
1834: and ou.organization_id = nvl(p_org_id,ou.organization_id)

Line 1862: from fv_ccr_orgs o, hr_organization_units ou, po_vendor_sites_all vs

1858:
1859: --v_org_id := fv_ccr_util_pvt.get_profile_option('ORG_ID');
1860: IF p_org_id is NOT NULL THEN
1861: for crec in (select main_address_site_id
1862: from fv_ccr_orgs o, hr_organization_units ou, po_vendor_sites_all vs
1863: where o.main_address_site_id is not null
1864: and o.main_address_site_flag = 'Y'
1865: and o.main_address_site_id = vs.VENDOR_SITE_ID
1866: and vs.ORG_ID = ou.organization_id

Line 1940: FROM fv_ccr_orgs fco

1936: l_count := 0;
1937:
1938: SELECT COUNT(*)
1939: INTO l_count
1940: FROM fv_ccr_orgs fco
1941: WHERE fco.ccr_id = p_ccr_id
1942: AND mo_global.check_access(fco.org_id)<>'Y';
1943:
1944: