APPS.HZ_PARTY_SITES_PKG dependencies on HZ_PARTY_SITE_NUMBER_S

Line 103: DECODE( X_PARTY_SITE_NUMBER, FND_API.G_MISS_CHAR, TO_CHAR( HZ_PARTY_SITE_NUMBER_S.NEXTVAL ), NULL, TO_CHAR( HZ_PARTY_SITE_NUMBER_S.NEXTVAL ), X_PARTY_SITE_NUMBER ),

99: DUNS_NUMBER_C
100: )
101: VALUES (
102: DECODE( X_PARTY_SITE_ID, FND_API.G_MISS_NUM, HZ_PARTY_SITES_S.NEXTVAL, NULL, HZ_PARTY_SITES_S.NEXTVAL, X_PARTY_SITE_ID ),
103: DECODE( X_PARTY_SITE_NUMBER, FND_API.G_MISS_CHAR, TO_CHAR( HZ_PARTY_SITE_NUMBER_S.NEXTVAL ), NULL, TO_CHAR( HZ_PARTY_SITE_NUMBER_S.NEXTVAL ), X_PARTY_SITE_NUMBER ),
104: DECODE( X_PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
105: DECODE( X_LOCATION_ID, FND_API.G_MISS_NUM, NULL, X_LOCATION_ID ),
106: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
107: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

Line 213: SELECT TO_CHAR( HZ_PARTY_SITE_NUMBER_S.NEXTVAL )

209: RAISE FND_API.G_EXC_ERROR;
210: ELSE
211: l_count := 1;
212: WHILE l_count > 0 LOOP
213: SELECT TO_CHAR( HZ_PARTY_SITE_NUMBER_S.NEXTVAL )
214: INTO X_PARTY_SITE_NUMBER FROM dual;
215: BEGIN
216: SELECT 'Y' INTO l_dummy
217: FROM HZ_PARTY_SITES