APPS.HZ_PERSON_LANGUAGE_PKG dependencies on HZ_PERSON_LANGUAGE_S

Line 52: DECODE( X_LANGUAGE_USE_REFERENCE_ID, FND_API.G_MISS_NUM, HZ_PERSON_LANGUAGE_S.NEXTVAL, NULL, HZ_PERSON_LANGUAGE_S.NEXTVAL, X_LANGUAGE_USE_REFERENCE_ID ),

48: CREATED_BY_MODULE,
49: APPLICATION_ID
50: )
51: VALUES (
52: DECODE( X_LANGUAGE_USE_REFERENCE_ID, FND_API.G_MISS_NUM, HZ_PERSON_LANGUAGE_S.NEXTVAL, NULL, HZ_PERSON_LANGUAGE_S.NEXTVAL, X_LANGUAGE_USE_REFERENCE_ID ),
53: DECODE( X_LANGUAGE_NAME, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_NAME ),
54: DECODE( X_PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
55: DECODE( X_NATIVE_LANGUAGE, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_NATIVE_LANGUAGE ),
56: DECODE( X_PRIMARY_LANGUAGE_INDICATOR, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_LANGUAGE_INDICATOR ),

Line 92: SELECT HZ_PERSON_LANGUAGE_S.NEXTVAL

88: l_dummy VARCHAR2(1);
89: BEGIN
90: l_count := 1;
91: WHILE l_count > 0 LOOP
92: SELECT HZ_PERSON_LANGUAGE_S.NEXTVAL
93: INTO X_LANGUAGE_USE_REFERENCE_ID FROM dual;
94: BEGIN
95: SELECT 'Y' INTO l_dummy
96: FROM HZ_PERSON_LANGUAGE

Line 134: UPDATE HZ_PERSON_LANGUAGE SET

130: ) IS
131:
132: BEGIN
133:
134: UPDATE HZ_PERSON_LANGUAGE SET
135: LANGUAGE_USE_REFERENCE_ID = DECODE( X_LANGUAGE_USE_REFERENCE_ID, NULL, LANGUAGE_USE_REFERENCE_ID, FND_API.G_MISS_NUM, NULL, X_LANGUAGE_USE_REFERENCE_ID ),
136: LANGUAGE_NAME = DECODE( X_LANGUAGE_NAME, NULL, LANGUAGE_NAME, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_NAME ),
137: PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
138: NATIVE_LANGUAGE = DECODE( X_NATIVE_LANGUAGE, NULL, NATIVE_LANGUAGE, FND_API.G_MISS_CHAR, 'N', X_NATIVE_LANGUAGE ),