DBA Data[Home] [Help]

APPS.FA_VENDORMERGE_GRP dependencies on FA_INS_POLICIES

Line 146: -- Updating FA_INS_POLICIES : VENDOR_ID, VENDOR_SITE_ID

142: where VENDOR_ID = p_dup_vendor_id
143: and nvl(VENDOR_SITE_ID, 0) = decode(VENDOR_SITE_ID, NULL, 0, p_dup_vendor_site_id);
144:
145: -- **********************************************************
146: -- Updating FA_INS_POLICIES : VENDOR_ID, VENDOR_SITE_ID
147: -- **********************************************************
148: l_location := 'FA_INS_POLICIES';
149: update FA_INS_POLICIES
150: set VENDOR_ID = p_vendor_id

Line 148: l_location := 'FA_INS_POLICIES';

144:
145: -- **********************************************************
146: -- Updating FA_INS_POLICIES : VENDOR_ID, VENDOR_SITE_ID
147: -- **********************************************************
148: l_location := 'FA_INS_POLICIES';
149: update FA_INS_POLICIES
150: set VENDOR_ID = p_vendor_id
151: , VENDOR_SITE_ID = decode(VENDOR_SITE_ID, p_dup_vendor_site_id, p_vendor_site_id, VENDOR_SITE_ID)
152: where VENDOR_ID = p_dup_vendor_id

Line 149: update FA_INS_POLICIES

145: -- **********************************************************
146: -- Updating FA_INS_POLICIES : VENDOR_ID, VENDOR_SITE_ID
147: -- **********************************************************
148: l_location := 'FA_INS_POLICIES';
149: update FA_INS_POLICIES
150: set VENDOR_ID = p_vendor_id
151: , VENDOR_SITE_ID = decode(VENDOR_SITE_ID, p_dup_vendor_site_id, p_vendor_site_id, VENDOR_SITE_ID)
152: where VENDOR_ID = p_dup_vendor_id
153: and nvl(VENDOR_SITE_ID, 0) = decode(VENDOR_SITE_ID, NULL, 0, p_dup_vendor_site_id);