APPS.HZ_PERSON_PROFILES_PKG dependencies on HZ_PERSON_PROFILES_S

Line 167: DECODE( X_PERSON_PROFILE_ID, FND_API.G_MISS_NUM, HZ_PERSON_PROFILES_S.NEXTVAL, NULL, HZ_PERSON_PROFILES_S.NEXTVAL, X_PERSON_PROFILE_ID ),

163: ACTUAL_CONTENT_SOURCE,
164: VERSION_NUMBER
165: )
166: VALUES (
167: DECODE( X_PERSON_PROFILE_ID, FND_API.G_MISS_NUM, HZ_PERSON_PROFILES_S.NEXTVAL, NULL, HZ_PERSON_PROFILES_S.NEXTVAL, X_PERSON_PROFILE_ID ),
168: DECODE( X_PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
169: DECODE( X_PERSON_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME ),
170: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
171: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

Line 264: SELECT HZ_PERSON_PROFILES_S.NEXTVAL

260: l_dummy VARCHAR2(1);
261: BEGIN
262: l_count := 1;
263: WHILE l_count > 0 LOOP
264: SELECT HZ_PERSON_PROFILES_S.NEXTVAL
265: INTO X_PERSON_PROFILE_ID FROM dual;
266: BEGIN
267: SELECT 'Y' INTO l_dummy
268: FROM HZ_PERSON_PROFILES

Line 361: UPDATE HZ_PERSON_PROFILES SET

357: ) IS
358:
359: BEGIN
360:
361: UPDATE HZ_PERSON_PROFILES SET
362: PERSON_PROFILE_ID = DECODE( X_PERSON_PROFILE_ID, NULL, PERSON_PROFILE_ID, FND_API.G_MISS_NUM, NULL, X_PERSON_PROFILE_ID ),
363: PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
364: PERSON_NAME = DECODE( X_PERSON_NAME, NULL, PERSON_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME),
365: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,