DBA Data[Home] [Help]

APPS.OKL_VENDORMERGE_GRP dependencies on OKL_QUOTE_PARTIES

Line 640: UPDATE OKL_QUOTE_PARTIES QPT

636: --Handle the Termination Quote Parties if both the vendors are parties
637: --to same termination quote
638: --Update the CPL_ID and PARTY_OBJECT1_ID1 of the merged vendor to point to
639: --destination vendor
640: UPDATE OKL_QUOTE_PARTIES QPT
641: SET PARTY_OBJECT1_ID1 = TO_CHAR(p_vendor_id),
642: LAST_UPDATED_BY = l_last_updated_by,
643: LAST_UPDATE_DATE = l_last_update_date,
644: LAST_UPDATE_LOGIN = l_last_update_login,

Line 720: --Update OKL_QUOTE_PARTIES for references of Vendor, which will be identified

716: END LOOP;
717: CLOSE chk_vendor_chr_csr;
718:
719: --Termination Quotes Objects
720: --Update OKL_QUOTE_PARTIES for references of Vendor, which will be identified
721: --based on value for PARTY_JTOT_OBJECT1_CODE
722: --This is needed for the cases in which there is only source vendor added in
723: --the contract.
724: UPDATE OKL_QUOTE_PARTIES

Line 724: UPDATE OKL_QUOTE_PARTIES

720: --Update OKL_QUOTE_PARTIES for references of Vendor, which will be identified
721: --based on value for PARTY_JTOT_OBJECT1_CODE
722: --This is needed for the cases in which there is only source vendor added in
723: --the contract.
724: UPDATE OKL_QUOTE_PARTIES
725: SET PARTY_OBJECT1_ID1 = TO_CHAR(p_vendor_id),
726: LAST_UPDATED_BY = l_last_updated_by,
727: LAST_UPDATE_DATE = l_last_update_date,
728: LAST_UPDATE_LOGIN = l_last_update_login