APPS.FV_CCR_UTIL_PVT dependencies on FV_CCR_VENDORS

Line 871: UPDATE fv_ccr_vendors

867: IF(p_bank_branch_id =0 AND l_bank_branch_id IS NOT NULL) THEN
868: insert_for_report(l_duns_for_report,14,null,p_bank_branch_name,
869: p_bank_num,null,null);
870: END IF;
871: UPDATE fv_ccr_vendors
872: SET bank_branch_id = l_bank_branch_id
873: ,enabled ='Y',last_update_date=sysdate,
874: last_updated_by=l_user_id,last_update_login=l_login_id
875: WHERE ccr_id = p_ccr_id;

Line 1000: UPDATE fv_ccr_vendors

996: END IF;
997: END;
998: END IF;
999: BEGIN
1000: UPDATE fv_ccr_vendors
1001: SET vendor_id = p_vendor_id,
1002: last_update_date=sysdate,
1003: last_updated_by =l_user_id,
1004: last_update_login=l_login_id

Line 1097: UPDATE fv_ccr_vendors

1093: --insert_for_report(p_duns,12,null,p_legal_bus_name,
1094: insert_for_report(p_duns,12,null,l_legal_bus_name,
1095: p_taxpayer_number,null,null);
1096: IF(p_vendor_id = 0) THEN
1097: UPDATE fv_ccr_vendors
1098: SET vendor_id =l_vendor_id,
1099: last_update_date=sysdate,
1100: last_updated_by=l_user_id,
1101: last_update_login=l_login_id

Line 1131: UPDATE fv_ccr_vendors

1127: WHERE ccr_id = p_ccr_id
1128: AND org_id=p_org_id;
1129: END IF;
1130: IF(p_header_conc_req_status = 'S' AND p_ccr_id <> p_prev_ccr_id) THEN
1131: UPDATE fv_ccr_vendors
1132: SET conc_request_status=l_header_conc_req_status,
1133: last_update_date=sysdate,
1134: last_updated_by=l_user_id,
1135: last_update_login=l_login_id

Line 1142: UPDATE fv_ccr_vendors

1138: RAISE;
1139: END;
1140: ELSE
1141: BEGIN
1142: UPDATE fv_ccr_vendors
1143: SET vendor_id =l_vendor_id,
1144: last_update_date=sysdate,
1145: last_updated_by=l_user_id,
1146: last_update_login=l_login_id

Line 1562: UPDATE fv_ccr_vendors

1558: IF(l_pay_site_id = 0) THEN l_pay_site_id := null; END IF;
1559: IF(l_main_add_site_id = 0) THEN l_main_add_site_id := null; END IF;
1560: IF(l_new_bank_account_id=0) THEN l_new_bank_account_id := null; END IF;
1561: IF(p_header_conc_req_status = 'S' AND p_ccr_id <> p_prev_ccr_id) THEN
1562: UPDATE fv_ccr_vendors
1563: SET conc_request_status=l_header_conc_req_status,
1564: last_update_date=sysdate,
1565: last_updated_by=l_user_id,
1566: last_update_login=l_login_id

Line 1707: UPDATE fv_ccr_vendors

1703: insert_for_report(l_duns_for_report,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);
1704: END;
1705: END IF;
1706: IF(p_header_conc_req_status = 'S' AND p_ccr_id <> p_prev_ccr_id) THEN
1707: UPDATE fv_ccr_vendors
1708: SET conc_request_status=l_header_conc_req_status,
1709: last_update_date=sysdate,
1710: last_updated_by=l_user_id,
1711: last_update_login=l_login_id

Line 1793: update fv_ccr_vendors

1789: BEGIN
1790: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.delete_plusfour_assignments';
1791:
1792: --unassign plus_four's vendor_id (supplier)
1793: update fv_ccr_vendors
1794: set vendor_id = null
1795: where duns = (select duns from fv_ccr_vendors where ccr_id = p_ccrid)
1796: and plus_four is not null;
1797:

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

1791:
1792: --unassign plus_four's vendor_id (supplier)
1793: update fv_ccr_vendors
1794: set vendor_id = null
1795: where duns = (select duns from fv_ccr_vendors where ccr_id = p_ccrid)
1796: and plus_four is not null;
1797:
1798: --delete plus_four assignments
1799: select plus_four into v_plus_four

Line 1800: from fv_ccr_vendors

1796: and plus_four is not null;
1797:
1798: --delete plus_four assignments
1799: select plus_four into v_plus_four
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

Line 1807: from fv_ccr_vendors

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 =
1809: p_ccrid)
1810: and plus_four is not null);
1811: end if;

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

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 =
1809: p_ccrid)
1810: and plus_four is not null);
1811: end if;
1812: