DBA Data[Home] [Help]

APPS.HZ_PARTY_SITE_BO_PUB dependencies on HZ_SMS_CP_BO_TBL

Line 155: l_sms_objs HZ_SMS_CP_BO_TBL;

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:

Line 736: l_sms_objs HZ_SMS_CP_BO_TBL;

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