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.FV_CCR_UTIL_PVT dependencies on FV_CCR_VENDORS

Line 922: 'Updating fv_ccr_vendors with bank_branch_id: '||l_bank_branch_id);

918: p_bank_num,null,null);
919: END IF;
920:
921: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
922: 'Updating fv_ccr_vendors with bank_branch_id: '||l_bank_branch_id);
923:
924: UPDATE fv_ccr_vendors
925: SET bank_branch_id = l_bank_branch_id
926: ,enabled ='Y',last_update_date=sysdate,

Line 924: UPDATE fv_ccr_vendors

920:
921: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
922: 'Updating fv_ccr_vendors with bank_branch_id: '||l_bank_branch_id);
923:
924: UPDATE fv_ccr_vendors
925: SET bank_branch_id = l_bank_branch_id
926: ,enabled ='Y',last_update_date=sysdate,
927: last_updated_by=l_user_id,last_update_login=l_login_id
928: WHERE ccr_id = p_ccr_id;

Line 974: from fv_ccr_vendors fcv, fv_ccr_orgs fco

970:
971: l_update_tin_prf := get_profile_option('FV_CCR_UPDATE_TIN');
972:
973: select count(*) into l_vendor_cnt
974: from fv_ccr_vendors fcv, fv_ccr_orgs fco
975: where fcv.ccr_id = fco.ccr_id
976: and fcv.DUNS <> p_duns and fcv.vendor_id = p_vendor_id
977: and (fco.pay_site_id is not null or fco.MAIN_ADDRESS_SITE_ID is not null);
978:

Line 1079: UPDATE fv_ccr_vendors

1075: END;
1076: end if;
1077: END IF;
1078: BEGIN
1079: UPDATE fv_ccr_vendors
1080: SET vendor_id = p_vendor_id,
1081: last_update_date=sysdate,
1082: last_updated_by =l_user_id,
1083: last_update_login=l_login_id

Line 1176: UPDATE fv_ccr_vendors

1172: --insert_for_report(p_duns,12,null,p_legal_bus_name,
1173: insert_for_report(p_duns,12,null,l_legal_bus_name,
1174: p_taxpayer_number,null,null);
1175: IF(p_vendor_id = 0) THEN
1176: UPDATE fv_ccr_vendors
1177: SET vendor_id =l_vendor_id,
1178: last_update_date=sysdate,
1179: last_updated_by=l_user_id,
1180: last_update_login=l_login_id

Line 1210: UPDATE fv_ccr_vendors

1206: WHERE ccr_id = p_ccr_id
1207: AND org_id=p_org_id;
1208: END IF;
1209: IF(p_header_conc_req_status = 'S' AND p_ccr_id <> p_prev_ccr_id) THEN
1210: UPDATE fv_ccr_vendors
1211: SET conc_request_status=l_header_conc_req_status,
1212: last_update_date=sysdate,
1213: last_updated_by=l_user_id,
1214: last_update_login=l_login_id

Line 1221: UPDATE fv_ccr_vendors

1217: RAISE;
1218: END;
1219: ELSE
1220: BEGIN
1221: UPDATE fv_ccr_vendors
1222: SET vendor_id =l_vendor_id,
1223: last_update_date=sysdate,
1224: last_updated_by=l_user_id,
1225: last_update_login=l_login_id

Line 1747: UPDATE fv_ccr_vendors

1743: IF(l_pay_site_id = 0) THEN l_pay_site_id := null; END IF;
1744: IF(l_main_add_site_id = 0) THEN l_main_add_site_id := null; END IF;
1745: IF(l_new_bank_account_id=0) THEN l_new_bank_account_id := null; END IF;
1746: IF(p_header_conc_req_status = 'S' AND p_ccr_id <> p_prev_ccr_id) THEN
1747: UPDATE fv_ccr_vendors
1748: SET conc_request_status=l_header_conc_req_status,
1749: last_update_date=sysdate,
1750: last_updated_by=l_user_id,
1751: last_update_login=l_login_id

Line 1928: UPDATE fv_ccr_vendors

1924: insert_for_report(l_duns_for_report,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);
1925: END;
1926: END IF;
1927: IF(p_header_conc_req_status = 'S' AND p_ccr_id <> p_prev_ccr_id) THEN
1928: UPDATE fv_ccr_vendors
1929: SET conc_request_status=l_header_conc_req_status,
1930: last_update_date=sysdate,
1931: last_updated_by=l_user_id,
1932: last_update_login=l_login_id

Line 2014: update fv_ccr_vendors

2010: BEGIN
2011: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.delete_plusfour_assignments';
2012:
2013: --unassign plus_four's vendor_id (supplier)
2014: update fv_ccr_vendors
2015: set vendor_id = null
2016: where duns = (select duns from fv_ccr_vendors where ccr_id = p_ccrid)
2017: and plus_four is not null;
2018:

Line 2016: where duns = (select duns from fv_ccr_vendors where ccr_id = p_ccrid)

2012:
2013: --unassign plus_four's vendor_id (supplier)
2014: update fv_ccr_vendors
2015: set vendor_id = null
2016: where duns = (select duns from fv_ccr_vendors where ccr_id = p_ccrid)
2017: and plus_four is not null;
2018:
2019: --delete plus_four assignments
2020: select plus_four into v_plus_four

Line 2021: from fv_ccr_vendors

2017: and plus_four is not null;
2018:
2019: --delete plus_four assignments
2020: select plus_four into v_plus_four
2021: from fv_ccr_vendors
2022: where ccr_id = p_ccrid;
2023:
2024: if v_plus_four is null then
2025: delete from fv_ccr_orgs

Line 2028: from fv_ccr_vendors

2024: if v_plus_four is null then
2025: delete from fv_ccr_orgs
2026: where ccr_id in (
2027: select ccr_id
2028: from fv_ccr_vendors
2029: where duns = (select duns from fv_ccr_vendors where ccr_id =
2030: p_ccrid)
2031: and plus_four is not null);
2032: end if;

Line 2029: where duns = (select duns from fv_ccr_vendors where ccr_id =

2025: delete from fv_ccr_orgs
2026: where ccr_id in (
2027: select ccr_id
2028: from fv_ccr_vendors
2029: where duns = (select duns from fv_ccr_vendors where ccr_id =
2030: p_ccrid)
2031: and plus_four is not null);
2032: end if;
2033:

Line 2362: l_cage_code fv_ccr_vendors.cage_code%type;

2358: l_ret_stat varchar2(20);
2359: l_msg_count number;
2360: l_msg_data varchar2(400);
2361: l_location_id number;
2362: l_cage_code fv_ccr_vendors.cage_code%type;
2363: l_legal_bus_name fv_ccr_vendors.legal_bus_name%type;
2364: l_dba_name fv_ccr_vendors.dba_name%type;
2365: l_division_name fv_ccr_vendors.division_name%type;
2366:

Line 2363: l_legal_bus_name fv_ccr_vendors.legal_bus_name%type;

2359: l_msg_count number;
2360: l_msg_data varchar2(400);
2361: l_location_id number;
2362: l_cage_code fv_ccr_vendors.cage_code%type;
2363: l_legal_bus_name fv_ccr_vendors.legal_bus_name%type;
2364: l_dba_name fv_ccr_vendors.dba_name%type;
2365: l_division_name fv_ccr_vendors.division_name%type;
2366:
2367: BEGIN

Line 2364: l_dba_name fv_ccr_vendors.dba_name%type;

2360: l_msg_data varchar2(400);
2361: l_location_id number;
2362: l_cage_code fv_ccr_vendors.cage_code%type;
2363: l_legal_bus_name fv_ccr_vendors.legal_bus_name%type;
2364: l_dba_name fv_ccr_vendors.dba_name%type;
2365: l_division_name fv_ccr_vendors.division_name%type;
2366:
2367: BEGIN
2368: --Bug9790495

Line 2365: l_division_name fv_ccr_vendors.division_name%type;

2361: l_location_id number;
2362: l_cage_code fv_ccr_vendors.cage_code%type;
2363: l_legal_bus_name fv_ccr_vendors.legal_bus_name%type;
2364: l_dba_name fv_ccr_vendors.dba_name%type;
2365: l_division_name fv_ccr_vendors.division_name%type;
2366:
2367: BEGIN
2368: --Bug9790495
2369: -- Logic to check if user is ISP UI is available or not.

Line 2379: from fv_ccr_vendors where duns = p_duns_number and rownum<=1;

2375:
2376: BEGIN
2377: Select cage_code, legal_bus_name, dba_name, division_name
2378: into l_cage_code, l_legal_bus_name, l_dba_name, l_division_name
2379: from fv_ccr_vendors where duns = p_duns_number and rownum<=1;
2380:
2381: EXCEPTION
2382: WHEN NO_DATA_FOUND THEN
2383: null;

Line 2499: l_cage_code fv_ccr_vendors.cage_code%type;

2495: l_location_id number;
2496: l_party_site_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE;
2497: l_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;
2498: l_object_version_number NUMBER;
2499: l_cage_code fv_ccr_vendors.cage_code%type;
2500: l_legal_bus_name fv_ccr_vendors.legal_bus_name%type;
2501: l_dba_name fv_ccr_vendors.dba_name%type;
2502: l_division_name fv_ccr_vendors.division_name%type;
2503: BEGIN

Line 2500: l_legal_bus_name fv_ccr_vendors.legal_bus_name%type;

2496: l_party_site_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE;
2497: l_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;
2498: l_object_version_number NUMBER;
2499: l_cage_code fv_ccr_vendors.cage_code%type;
2500: l_legal_bus_name fv_ccr_vendors.legal_bus_name%type;
2501: l_dba_name fv_ccr_vendors.dba_name%type;
2502: l_division_name fv_ccr_vendors.division_name%type;
2503: BEGIN
2504:

Line 2501: l_dba_name fv_ccr_vendors.dba_name%type;

2497: l_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;
2498: l_object_version_number NUMBER;
2499: l_cage_code fv_ccr_vendors.cage_code%type;
2500: l_legal_bus_name fv_ccr_vendors.legal_bus_name%type;
2501: l_dba_name fv_ccr_vendors.dba_name%type;
2502: l_division_name fv_ccr_vendors.division_name%type;
2503: BEGIN
2504:
2505: --Bug9790495

Line 2502: l_division_name fv_ccr_vendors.division_name%type;

2498: l_object_version_number NUMBER;
2499: l_cage_code fv_ccr_vendors.cage_code%type;
2500: l_legal_bus_name fv_ccr_vendors.legal_bus_name%type;
2501: l_dba_name fv_ccr_vendors.dba_name%type;
2502: l_division_name fv_ccr_vendors.division_name%type;
2503: BEGIN
2504:
2505: --Bug9790495
2506: IF (PO_ISPCODELEVEL_PVT.get_curr_isp_supp_code_level

Line 2511: from fv_ccr_vendors where duns = p_duns_number and rownum<=1;

2507: >= PO_ISPCODELEVEL_PVT.G_ISP_SUP_CODE_LEVEL_CLM_BASE) THEN
2508: BEGIN
2509: Select cage_code, legal_bus_name, dba_name, division_name
2510: into l_cage_code, l_legal_bus_name, l_dba_name, l_division_name
2511: from fv_ccr_vendors where duns = p_duns_number and rownum<=1;
2512:
2513: EXCEPTION
2514: WHEN NO_DATA_FOUND THEN
2515: null;

Line 2719: l_ach_us_phone fv_ccr_vendors.ach_us_phone%type;

2715: l_bank_acct_rec IBY_EXT_BANKACCT_PUB.ExtBankAcct_rec_type;
2716: l_bank_branch_id NUMBER;
2717: l_bank_account_id NUMBER;
2718: l_object_version_number NUMBER;
2719: l_ach_us_phone fv_ccr_vendors.ach_us_phone%type;
2720: l_ach_non_us_phone fv_ccr_vendors.ach_non_us_phone%type;
2721: l_ach_email fv_ccr_vendors.ach_email%type;
2722: l_ach_fax fv_ccr_vendors.ach_fax%type;
2723:

Line 2720: l_ach_non_us_phone fv_ccr_vendors.ach_non_us_phone%type;

2716: l_bank_branch_id NUMBER;
2717: l_bank_account_id NUMBER;
2718: l_object_version_number NUMBER;
2719: l_ach_us_phone fv_ccr_vendors.ach_us_phone%type;
2720: l_ach_non_us_phone fv_ccr_vendors.ach_non_us_phone%type;
2721: l_ach_email fv_ccr_vendors.ach_email%type;
2722: l_ach_fax fv_ccr_vendors.ach_fax%type;
2723:
2724: BANK_EXCEPTION EXCEPTION;

Line 2721: l_ach_email fv_ccr_vendors.ach_email%type;

2717: l_bank_account_id NUMBER;
2718: l_object_version_number NUMBER;
2719: l_ach_us_phone fv_ccr_vendors.ach_us_phone%type;
2720: l_ach_non_us_phone fv_ccr_vendors.ach_non_us_phone%type;
2721: l_ach_email fv_ccr_vendors.ach_email%type;
2722: l_ach_fax fv_ccr_vendors.ach_fax%type;
2723:
2724: BANK_EXCEPTION EXCEPTION;
2725: BEGIN

Line 2722: l_ach_fax fv_ccr_vendors.ach_fax%type;

2718: l_object_version_number NUMBER;
2719: l_ach_us_phone fv_ccr_vendors.ach_us_phone%type;
2720: l_ach_non_us_phone fv_ccr_vendors.ach_non_us_phone%type;
2721: l_ach_email fv_ccr_vendors.ach_email%type;
2722: l_ach_fax fv_ccr_vendors.ach_fax%type;
2723:
2724: BANK_EXCEPTION EXCEPTION;
2725: BEGIN
2726:

Line 2924: into l_ach_us_phone, l_ach_non_us_phone, l_ach_email, l_ach_fax from fv_ccr_vendors

2920: end if;
2921:
2922: BEGIN
2923: select ach_us_phone, ach_non_us_phone, ach_email, ach_fax
2924: into l_ach_us_phone, l_ach_non_us_phone, l_ach_email, l_ach_fax from fv_ccr_vendors
2925: where duns=p_duns_number and rownum<=1;
2926:
2927: EXCEPTION when no_data_found then
2928: null;

Line 3228: select nvl(taxpayer_id, null) into l_ccr_tin from fv_ccr_vendors where duns = p_duns;

3224: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.check_taxpayerid_diff';
3225: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
3226:
3227: begin
3228: select nvl(taxpayer_id, null) into l_ccr_tin from fv_ccr_vendors where duns = p_duns;
3229: select nvl(num_1099, null) into l_supplier_tin from ap_suppliers where vendor_id = p_vendor_id;
3230:
3231: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_ccr_tin: '||l_ccr_tin);
3232: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'l_supplier_tin: '||l_supplier_tin);

Line 3546: l_duns_number fv_ccr_vendors.duns%type;

3542: p_reference_date in date default sysdate,
3543: x_return_status out nocopy varchar2,
3544: x_msg_data varchar2) return boolean
3545: is
3546: l_duns_number fv_ccr_vendors.duns%type;
3547: l_module_name VARCHAR2(60);
3548: l_debar_code fv_ccr_class_codes.code%type;
3549:
3550: begin

Line 3555: from fv_ccr_vendors fcv, fv_ccr_class_codes fcc, fv_ccr_orgs fco

3551: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_supplier_debarred';
3552: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
3553:
3554: select fcc.code into l_debar_code
3555: from fv_ccr_vendors fcv, fv_ccr_class_codes fcc, fv_ccr_orgs fco
3556: where fcv.duns = fcc.duns(+)
3557: and fcv.ccr_id = fco.ccr_id(+)
3558: and fcv.vendor_id = p_supplier_id
3559: and fco.pay_site_id = p_supplier_site_id;