DBA Data[Home] [Help]

APPS.AP_VENDOR_PUB_PKG dependencies on HZ_PARTY_SITE_NUMBER_S

Line 7581: SELECT HZ_PARTY_SITE_NUMBER_S.Nextval

7577: -- udhenuko Bug 6823885 start
7578: --We need to populate the party site number based on profile value.
7579: fnd_profile.get('HZ_GENERATE_PARTY_SITE_NUMBER', l_party_site_num);
7580: IF nvl(l_party_site_num, 'Y') = 'N' THEN
7581: SELECT HZ_PARTY_SITE_NUMBER_S.Nextval
7582: INTO l_party_site_rec.party_site_number
7583: FROM DUAL;
7584: END IF;
7585: -- udhenuko Bug 6823885 End

Line 11692: SELECT HZ_PARTY_SITE_NUMBER_S.Nextval

11688: l_party_site_rec.party_id := l_vendor_contact_rec.rel_party_id;
11689: -- udhenuko Bug 6823885 start. Party site number populated based on profile.
11690: fnd_profile.get('HZ_GENERATE_PARTY_SITE_NUMBER', l_party_site_num);
11691: IF nvl(l_party_site_num, 'Y') = 'N' THEN
11692: SELECT HZ_PARTY_SITE_NUMBER_S.Nextval
11693: INTO l_party_site_rec.party_site_number
11694: FROM DUAL;
11695: END IF;
11696: -- udhenuko Bug 6823885 End