DBA Data[Home] [Help]

APPS.AP_VENDOR_PUB_PKG dependencies on HZ_PARTY_SITE_NUMBER_S

Line 8606: SELECT HZ_PARTY_SITE_NUMBER_S.Nextval

8602: -- udhenuko Bug 6823885 start
8603: --We need to populate the party site number based on profile value.
8604: fnd_profile.get('HZ_GENERATE_PARTY_SITE_NUMBER', l_party_site_num);
8605: IF nvl(l_party_site_num, 'Y') = 'N' THEN
8606: SELECT HZ_PARTY_SITE_NUMBER_S.Nextval
8607: INTO l_party_site_rec.party_site_number
8608: FROM DUAL;
8609: END IF;
8610: -- udhenuko Bug 6823885 End

Line 14201: SELECT HZ_PARTY_SITE_NUMBER_S.Nextval

14197: l_party_site_rec.party_id := l_vendor_contact_rec.rel_party_id;
14198: -- udhenuko Bug 6823885 start. Party site number populated based on profile.
14199: fnd_profile.get('HZ_GENERATE_PARTY_SITE_NUMBER', l_party_site_num);
14200: IF nvl(l_party_site_num, 'Y') = 'N' THEN
14201: SELECT HZ_PARTY_SITE_NUMBER_S.Nextval
14202: INTO l_party_site_rec.party_site_number
14203: FROM DUAL;
14204: END IF;
14205: -- udhenuko Bug 6823885 End