151: l_errorcode NUMBER;
152: l_cbm VARCHAR2(30);
153: l_edi_objs HZ_EDI_CP_BO_TBL;
154: l_eft_objs HZ_EFT_CP_BO_TBL;
155: l_sms_objs HZ_SMS_CP_BO_TBL;
156: BEGIN
157: -- Standard start of API savepoint
158: SAVEPOINT do_create_party_site_bo_pub;
159:
732: l_errorcode NUMBER;
733: l_cbm VARCHAR2(30);
734: l_edi_objs HZ_EDI_CP_BO_TBL;
735: l_eft_objs HZ_EFT_CP_BO_TBL;
736: l_sms_objs HZ_SMS_CP_BO_TBL;
737:
738: CURSOR get_ovn(l_ps_id NUMBER) IS
739: SELECT ps.object_version_number, loc.object_version_number, ps.party_id, loc.location_id
740: FROM HZ_PARTY_SITES ps, HZ_LOCATIONS loc