APPS.HZ_CONTACT_PREFERENCES_PKG dependencies on HZ_CONTACT_PREFERENCES_S

Line 70: DECODE( X_CONTACT_PREFERENCE_ID, FND_API.G_MISS_NUM, HZ_CONTACT_PREFERENCES_S.NEXTVAL, NULL, HZ_CONTACT_PREFERENCES_S.NEXTVAL, X_CONTACT_PREFERENCE_ID ),

66: CREATED_BY_MODULE,
67: APPLICATION_ID
68: )
69: VALUES (
70: DECODE( X_CONTACT_PREFERENCE_ID, FND_API.G_MISS_NUM, HZ_CONTACT_PREFERENCES_S.NEXTVAL, NULL, HZ_CONTACT_PREFERENCES_S.NEXTVAL, X_CONTACT_PREFERENCE_ID ),
71: DECODE( X_CONTACT_LEVEL_TABLE, FND_API.G_MISS_CHAR, NULL, X_CONTACT_LEVEL_TABLE ),
72: DECODE( X_CONTACT_LEVEL_TABLE_ID, FND_API.G_MISS_NUM, NULL, X_CONTACT_LEVEL_TABLE_ID ),
73: DECODE( X_CONTACT_TYPE, FND_API.G_MISS_CHAR, NULL, X_CONTACT_TYPE ),
74: DECODE( X_PREFERENCE_CODE, FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_CODE ),

Line 120: SELECT HZ_CONTACT_PREFERENCES_S.NEXTVAL

116: l_dummy VARCHAR2(1);
117: BEGIN
118: l_count := 1;
119: WHILE l_count > 0 LOOP
120: SELECT HZ_CONTACT_PREFERENCES_S.NEXTVAL
121: INTO X_CONTACT_PREFERENCE_ID FROM dual;
122: BEGIN
123: SELECT 'Y' INTO l_dummy
124: FROM HZ_CONTACT_PREFERENCES

Line 170: UPDATE HZ_CONTACT_PREFERENCES SET

166: ) IS
167:
168: BEGIN
169:
170: UPDATE HZ_CONTACT_PREFERENCES SET
171: CONTACT_PREFERENCE_ID = DECODE( X_CONTACT_PREFERENCE_ID, NULL, CONTACT_PREFERENCE_ID, FND_API.G_MISS_NUM, NULL, X_CONTACT_PREFERENCE_ID ),
172: CONTACT_LEVEL_TABLE = DECODE( X_CONTACT_LEVEL_TABLE, NULL, CONTACT_LEVEL_TABLE, FND_API.G_MISS_CHAR, NULL, X_CONTACT_LEVEL_TABLE ),
173: CONTACT_LEVEL_TABLE_ID = DECODE( X_CONTACT_LEVEL_TABLE_ID, NULL, CONTACT_LEVEL_TABLE_ID, FND_API.G_MISS_NUM, NULL, X_CONTACT_LEVEL_TABLE_ID ),
174: CONTACT_TYPE = DECODE( X_CONTACT_TYPE, NULL, CONTACT_TYPE, FND_API.G_MISS_CHAR, NULL, X_CONTACT_TYPE ),