DBA Data[Home] [Help]

APPS.HZ_PERSON_LANGUAGE_PKG dependencies on FND_API

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 53: DECODE( X_LANGUAGE_NAME, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_NAME ),

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 ),
57: DECODE( X_READS_LEVEL, FND_API.G_MISS_CHAR, NULL, X_READS_LEVEL ),

Line 54: DECODE( X_PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_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 ),
57: DECODE( X_READS_LEVEL, FND_API.G_MISS_CHAR, NULL, X_READS_LEVEL ),
58: DECODE( X_SPEAKS_LEVEL, FND_API.G_MISS_CHAR, NULL, X_SPEAKS_LEVEL ),

Line 55: DECODE( X_NATIVE_LANGUAGE, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_NATIVE_LANGUAGE ),

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 ),
57: DECODE( X_READS_LEVEL, FND_API.G_MISS_CHAR, NULL, X_READS_LEVEL ),
58: DECODE( X_SPEAKS_LEVEL, FND_API.G_MISS_CHAR, NULL, X_SPEAKS_LEVEL ),
59: DECODE( X_WRITES_LEVEL, FND_API.G_MISS_CHAR, NULL, X_WRITES_LEVEL ),

Line 56: DECODE( X_PRIMARY_LANGUAGE_INDICATOR, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_LANGUAGE_INDICATOR ),

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 ),
57: DECODE( X_READS_LEVEL, FND_API.G_MISS_CHAR, NULL, X_READS_LEVEL ),
58: DECODE( X_SPEAKS_LEVEL, FND_API.G_MISS_CHAR, NULL, X_SPEAKS_LEVEL ),
59: DECODE( X_WRITES_LEVEL, FND_API.G_MISS_CHAR, NULL, X_WRITES_LEVEL ),
60: DECODE( X_SPOKEN_COMPREHENSION_LEVEL, FND_API.G_MISS_CHAR, NULL, X_SPOKEN_COMPREHENSION_LEVEL ),

Line 57: DECODE( X_READS_LEVEL, FND_API.G_MISS_CHAR, NULL, X_READS_LEVEL ),

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 ),
57: DECODE( X_READS_LEVEL, FND_API.G_MISS_CHAR, NULL, X_READS_LEVEL ),
58: DECODE( X_SPEAKS_LEVEL, FND_API.G_MISS_CHAR, NULL, X_SPEAKS_LEVEL ),
59: DECODE( X_WRITES_LEVEL, FND_API.G_MISS_CHAR, NULL, X_WRITES_LEVEL ),
60: DECODE( X_SPOKEN_COMPREHENSION_LEVEL, FND_API.G_MISS_CHAR, NULL, X_SPOKEN_COMPREHENSION_LEVEL ),
61: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

Line 58: DECODE( X_SPEAKS_LEVEL, FND_API.G_MISS_CHAR, NULL, X_SPEAKS_LEVEL ),

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 ),
57: DECODE( X_READS_LEVEL, FND_API.G_MISS_CHAR, NULL, X_READS_LEVEL ),
58: DECODE( X_SPEAKS_LEVEL, FND_API.G_MISS_CHAR, NULL, X_SPEAKS_LEVEL ),
59: DECODE( X_WRITES_LEVEL, FND_API.G_MISS_CHAR, NULL, X_WRITES_LEVEL ),
60: DECODE( X_SPOKEN_COMPREHENSION_LEVEL, FND_API.G_MISS_CHAR, NULL, X_SPOKEN_COMPREHENSION_LEVEL ),
61: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
62: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

Line 59: DECODE( X_WRITES_LEVEL, FND_API.G_MISS_CHAR, NULL, X_WRITES_LEVEL ),

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 ),
57: DECODE( X_READS_LEVEL, FND_API.G_MISS_CHAR, NULL, X_READS_LEVEL ),
58: DECODE( X_SPEAKS_LEVEL, FND_API.G_MISS_CHAR, NULL, X_SPEAKS_LEVEL ),
59: DECODE( X_WRITES_LEVEL, FND_API.G_MISS_CHAR, NULL, X_WRITES_LEVEL ),
60: DECODE( X_SPOKEN_COMPREHENSION_LEVEL, FND_API.G_MISS_CHAR, NULL, X_SPOKEN_COMPREHENSION_LEVEL ),
61: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
62: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
63: HZ_UTILITY_V2PUB.CREATED_BY,

Line 60: DECODE( X_SPOKEN_COMPREHENSION_LEVEL, FND_API.G_MISS_CHAR, NULL, X_SPOKEN_COMPREHENSION_LEVEL ),

56: DECODE( X_PRIMARY_LANGUAGE_INDICATOR, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_LANGUAGE_INDICATOR ),
57: DECODE( X_READS_LEVEL, FND_API.G_MISS_CHAR, NULL, X_READS_LEVEL ),
58: DECODE( X_SPEAKS_LEVEL, FND_API.G_MISS_CHAR, NULL, X_SPEAKS_LEVEL ),
59: DECODE( X_WRITES_LEVEL, FND_API.G_MISS_CHAR, NULL, X_WRITES_LEVEL ),
60: DECODE( X_SPOKEN_COMPREHENSION_LEVEL, FND_API.G_MISS_CHAR, NULL, X_SPOKEN_COMPREHENSION_LEVEL ),
61: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
62: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
63: HZ_UTILITY_V2PUB.CREATED_BY,
64: HZ_UTILITY_V2PUB.CREATION_DATE,

Line 70: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),

66: HZ_UTILITY_V2PUB.REQUEST_ID,
67: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
68: HZ_UTILITY_V2PUB.PROGRAM_ID,
69: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
70: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
71: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
72: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
73: HZ_UTILITY_V2PUB.APPLICATION_ID
74: ) RETURNING

Line 71: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),

67: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
68: HZ_UTILITY_V2PUB.PROGRAM_ID,
69: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
70: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
71: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
72: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
73: HZ_UTILITY_V2PUB.APPLICATION_ID
74: ) RETURNING
75: LANGUAGE_USE_REFERENCE_ID

Line 72: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),

68: HZ_UTILITY_V2PUB.PROGRAM_ID,
69: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
70: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
71: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
72: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
73: HZ_UTILITY_V2PUB.APPLICATION_ID
74: ) RETURNING
75: LANGUAGE_USE_REFERENCE_ID
76: INTO

Line 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 ),

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 ),
139: PRIMARY_LANGUAGE_INDICATOR = DECODE( X_PRIMARY_LANGUAGE_INDICATOR, NULL, PRIMARY_LANGUAGE_INDICATOR, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_LANGUAGE_INDICATOR ),

Line 136: LANGUAGE_NAME = DECODE( X_LANGUAGE_NAME, NULL, LANGUAGE_NAME, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_NAME ),

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 ),
139: PRIMARY_LANGUAGE_INDICATOR = DECODE( X_PRIMARY_LANGUAGE_INDICATOR, NULL, PRIMARY_LANGUAGE_INDICATOR, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_LANGUAGE_INDICATOR ),
140: READS_LEVEL = DECODE( X_READS_LEVEL, NULL, READS_LEVEL, FND_API.G_MISS_CHAR, NULL, X_READS_LEVEL ),

Line 137: PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),

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 ),
139: PRIMARY_LANGUAGE_INDICATOR = DECODE( X_PRIMARY_LANGUAGE_INDICATOR, NULL, PRIMARY_LANGUAGE_INDICATOR, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_LANGUAGE_INDICATOR ),
140: READS_LEVEL = DECODE( X_READS_LEVEL, NULL, READS_LEVEL, FND_API.G_MISS_CHAR, NULL, X_READS_LEVEL ),
141: SPEAKS_LEVEL = DECODE( X_SPEAKS_LEVEL, NULL, SPEAKS_LEVEL, FND_API.G_MISS_CHAR, NULL, X_SPEAKS_LEVEL ),

Line 138: NATIVE_LANGUAGE = DECODE( X_NATIVE_LANGUAGE, NULL, NATIVE_LANGUAGE, FND_API.G_MISS_CHAR, 'N', X_NATIVE_LANGUAGE ),

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 ),
139: PRIMARY_LANGUAGE_INDICATOR = DECODE( X_PRIMARY_LANGUAGE_INDICATOR, NULL, PRIMARY_LANGUAGE_INDICATOR, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_LANGUAGE_INDICATOR ),
140: READS_LEVEL = DECODE( X_READS_LEVEL, NULL, READS_LEVEL, FND_API.G_MISS_CHAR, NULL, X_READS_LEVEL ),
141: SPEAKS_LEVEL = DECODE( X_SPEAKS_LEVEL, NULL, SPEAKS_LEVEL, FND_API.G_MISS_CHAR, NULL, X_SPEAKS_LEVEL ),
142: WRITES_LEVEL = DECODE( X_WRITES_LEVEL, NULL, WRITES_LEVEL, FND_API.G_MISS_CHAR, NULL, X_WRITES_LEVEL ),

Line 139: PRIMARY_LANGUAGE_INDICATOR = DECODE( X_PRIMARY_LANGUAGE_INDICATOR, NULL, PRIMARY_LANGUAGE_INDICATOR, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_LANGUAGE_INDICATOR ),

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 ),
139: PRIMARY_LANGUAGE_INDICATOR = DECODE( X_PRIMARY_LANGUAGE_INDICATOR, NULL, PRIMARY_LANGUAGE_INDICATOR, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_LANGUAGE_INDICATOR ),
140: READS_LEVEL = DECODE( X_READS_LEVEL, NULL, READS_LEVEL, FND_API.G_MISS_CHAR, NULL, X_READS_LEVEL ),
141: SPEAKS_LEVEL = DECODE( X_SPEAKS_LEVEL, NULL, SPEAKS_LEVEL, FND_API.G_MISS_CHAR, NULL, X_SPEAKS_LEVEL ),
142: WRITES_LEVEL = DECODE( X_WRITES_LEVEL, NULL, WRITES_LEVEL, FND_API.G_MISS_CHAR, NULL, X_WRITES_LEVEL ),
143: SPOKEN_COMPREHENSION_LEVEL = DECODE( X_SPOKEN_COMPREHENSION_LEVEL, NULL, SPOKEN_COMPREHENSION_LEVEL, FND_API.G_MISS_CHAR, NULL, X_SPOKEN_COMPREHENSION_LEVEL ),

Line 140: READS_LEVEL = DECODE( X_READS_LEVEL, NULL, READS_LEVEL, FND_API.G_MISS_CHAR, NULL, X_READS_LEVEL ),

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 ),
139: PRIMARY_LANGUAGE_INDICATOR = DECODE( X_PRIMARY_LANGUAGE_INDICATOR, NULL, PRIMARY_LANGUAGE_INDICATOR, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_LANGUAGE_INDICATOR ),
140: READS_LEVEL = DECODE( X_READS_LEVEL, NULL, READS_LEVEL, FND_API.G_MISS_CHAR, NULL, X_READS_LEVEL ),
141: SPEAKS_LEVEL = DECODE( X_SPEAKS_LEVEL, NULL, SPEAKS_LEVEL, FND_API.G_MISS_CHAR, NULL, X_SPEAKS_LEVEL ),
142: WRITES_LEVEL = DECODE( X_WRITES_LEVEL, NULL, WRITES_LEVEL, FND_API.G_MISS_CHAR, NULL, X_WRITES_LEVEL ),
143: SPOKEN_COMPREHENSION_LEVEL = DECODE( X_SPOKEN_COMPREHENSION_LEVEL, NULL, SPOKEN_COMPREHENSION_LEVEL, FND_API.G_MISS_CHAR, NULL, X_SPOKEN_COMPREHENSION_LEVEL ),
144: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

Line 141: SPEAKS_LEVEL = DECODE( X_SPEAKS_LEVEL, NULL, SPEAKS_LEVEL, FND_API.G_MISS_CHAR, NULL, X_SPEAKS_LEVEL ),

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 ),
139: PRIMARY_LANGUAGE_INDICATOR = DECODE( X_PRIMARY_LANGUAGE_INDICATOR, NULL, PRIMARY_LANGUAGE_INDICATOR, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_LANGUAGE_INDICATOR ),
140: READS_LEVEL = DECODE( X_READS_LEVEL, NULL, READS_LEVEL, FND_API.G_MISS_CHAR, NULL, X_READS_LEVEL ),
141: SPEAKS_LEVEL = DECODE( X_SPEAKS_LEVEL, NULL, SPEAKS_LEVEL, FND_API.G_MISS_CHAR, NULL, X_SPEAKS_LEVEL ),
142: WRITES_LEVEL = DECODE( X_WRITES_LEVEL, NULL, WRITES_LEVEL, FND_API.G_MISS_CHAR, NULL, X_WRITES_LEVEL ),
143: SPOKEN_COMPREHENSION_LEVEL = DECODE( X_SPOKEN_COMPREHENSION_LEVEL, NULL, SPOKEN_COMPREHENSION_LEVEL, FND_API.G_MISS_CHAR, NULL, X_SPOKEN_COMPREHENSION_LEVEL ),
144: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
145: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

Line 142: WRITES_LEVEL = DECODE( X_WRITES_LEVEL, NULL, WRITES_LEVEL, FND_API.G_MISS_CHAR, NULL, X_WRITES_LEVEL ),

138: NATIVE_LANGUAGE = DECODE( X_NATIVE_LANGUAGE, NULL, NATIVE_LANGUAGE, FND_API.G_MISS_CHAR, 'N', X_NATIVE_LANGUAGE ),
139: PRIMARY_LANGUAGE_INDICATOR = DECODE( X_PRIMARY_LANGUAGE_INDICATOR, NULL, PRIMARY_LANGUAGE_INDICATOR, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_LANGUAGE_INDICATOR ),
140: READS_LEVEL = DECODE( X_READS_LEVEL, NULL, READS_LEVEL, FND_API.G_MISS_CHAR, NULL, X_READS_LEVEL ),
141: SPEAKS_LEVEL = DECODE( X_SPEAKS_LEVEL, NULL, SPEAKS_LEVEL, FND_API.G_MISS_CHAR, NULL, X_SPEAKS_LEVEL ),
142: WRITES_LEVEL = DECODE( X_WRITES_LEVEL, NULL, WRITES_LEVEL, FND_API.G_MISS_CHAR, NULL, X_WRITES_LEVEL ),
143: SPOKEN_COMPREHENSION_LEVEL = DECODE( X_SPOKEN_COMPREHENSION_LEVEL, NULL, SPOKEN_COMPREHENSION_LEVEL, FND_API.G_MISS_CHAR, NULL, X_SPOKEN_COMPREHENSION_LEVEL ),
144: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
145: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
146: -- Bug 3032780

Line 143: SPOKEN_COMPREHENSION_LEVEL = DECODE( X_SPOKEN_COMPREHENSION_LEVEL, NULL, SPOKEN_COMPREHENSION_LEVEL, FND_API.G_MISS_CHAR, NULL, X_SPOKEN_COMPREHENSION_LEVEL ),

139: PRIMARY_LANGUAGE_INDICATOR = DECODE( X_PRIMARY_LANGUAGE_INDICATOR, NULL, PRIMARY_LANGUAGE_INDICATOR, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_LANGUAGE_INDICATOR ),
140: READS_LEVEL = DECODE( X_READS_LEVEL, NULL, READS_LEVEL, FND_API.G_MISS_CHAR, NULL, X_READS_LEVEL ),
141: SPEAKS_LEVEL = DECODE( X_SPEAKS_LEVEL, NULL, SPEAKS_LEVEL, FND_API.G_MISS_CHAR, NULL, X_SPEAKS_LEVEL ),
142: WRITES_LEVEL = DECODE( X_WRITES_LEVEL, NULL, WRITES_LEVEL, FND_API.G_MISS_CHAR, NULL, X_WRITES_LEVEL ),
143: SPOKEN_COMPREHENSION_LEVEL = DECODE( X_SPOKEN_COMPREHENSION_LEVEL, NULL, SPOKEN_COMPREHENSION_LEVEL, FND_API.G_MISS_CHAR, NULL, X_SPOKEN_COMPREHENSION_LEVEL ),
144: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
145: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
146: -- Bug 3032780
147: -- CREATED_BY = HZ_UTILITY_V2PUB.CREATED_BY,

Line 154: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),

150: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
151: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
152: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
153: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
154: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
155: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
156: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
157: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
158: WHERE ROWID = X_RowId;

Line 155: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),

151: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
152: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
153: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
154: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
155: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
156: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
157: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
158: WHERE ROWID = X_RowId;
159:

Line 156: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),

152: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
153: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
154: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
155: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
156: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
157: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
158: WHERE ROWID = X_RowId;
159:
160: IF ( SQL%NOTFOUND ) THEN

Line 157: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )

153: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
154: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
155: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
156: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
157: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
158: WHERE ROWID = X_RowId;
159:
160: IF ( SQL%NOTFOUND ) THEN
161: RAISE NO_DATA_FOUND;

Line 303: NVL( LANGUAGE_USE_REFERENCE_ID, FND_API.G_MISS_NUM ),

299:
300: BEGIN
301:
302: SELECT
303: NVL( LANGUAGE_USE_REFERENCE_ID, FND_API.G_MISS_NUM ),
304: NVL( LANGUAGE_NAME, FND_API.G_MISS_CHAR ),
305: NVL( PARTY_ID, FND_API.G_MISS_NUM ),
306: NVL( NATIVE_LANGUAGE, FND_API.G_MISS_CHAR ),
307: NVL( PRIMARY_LANGUAGE_INDICATOR, FND_API.G_MISS_CHAR ),

Line 304: NVL( LANGUAGE_NAME, FND_API.G_MISS_CHAR ),

300: BEGIN
301:
302: SELECT
303: NVL( LANGUAGE_USE_REFERENCE_ID, FND_API.G_MISS_NUM ),
304: NVL( LANGUAGE_NAME, FND_API.G_MISS_CHAR ),
305: NVL( PARTY_ID, FND_API.G_MISS_NUM ),
306: NVL( NATIVE_LANGUAGE, FND_API.G_MISS_CHAR ),
307: NVL( PRIMARY_LANGUAGE_INDICATOR, FND_API.G_MISS_CHAR ),
308: NVL( READS_LEVEL, FND_API.G_MISS_CHAR ),

Line 305: NVL( PARTY_ID, FND_API.G_MISS_NUM ),

301:
302: SELECT
303: NVL( LANGUAGE_USE_REFERENCE_ID, FND_API.G_MISS_NUM ),
304: NVL( LANGUAGE_NAME, FND_API.G_MISS_CHAR ),
305: NVL( PARTY_ID, FND_API.G_MISS_NUM ),
306: NVL( NATIVE_LANGUAGE, FND_API.G_MISS_CHAR ),
307: NVL( PRIMARY_LANGUAGE_INDICATOR, FND_API.G_MISS_CHAR ),
308: NVL( READS_LEVEL, FND_API.G_MISS_CHAR ),
309: NVL( SPEAKS_LEVEL, FND_API.G_MISS_CHAR ),

Line 306: NVL( NATIVE_LANGUAGE, FND_API.G_MISS_CHAR ),

302: SELECT
303: NVL( LANGUAGE_USE_REFERENCE_ID, FND_API.G_MISS_NUM ),
304: NVL( LANGUAGE_NAME, FND_API.G_MISS_CHAR ),
305: NVL( PARTY_ID, FND_API.G_MISS_NUM ),
306: NVL( NATIVE_LANGUAGE, FND_API.G_MISS_CHAR ),
307: NVL( PRIMARY_LANGUAGE_INDICATOR, FND_API.G_MISS_CHAR ),
308: NVL( READS_LEVEL, FND_API.G_MISS_CHAR ),
309: NVL( SPEAKS_LEVEL, FND_API.G_MISS_CHAR ),
310: NVL( WRITES_LEVEL, FND_API.G_MISS_CHAR ),

Line 307: NVL( PRIMARY_LANGUAGE_INDICATOR, FND_API.G_MISS_CHAR ),

303: NVL( LANGUAGE_USE_REFERENCE_ID, FND_API.G_MISS_NUM ),
304: NVL( LANGUAGE_NAME, FND_API.G_MISS_CHAR ),
305: NVL( PARTY_ID, FND_API.G_MISS_NUM ),
306: NVL( NATIVE_LANGUAGE, FND_API.G_MISS_CHAR ),
307: NVL( PRIMARY_LANGUAGE_INDICATOR, FND_API.G_MISS_CHAR ),
308: NVL( READS_LEVEL, FND_API.G_MISS_CHAR ),
309: NVL( SPEAKS_LEVEL, FND_API.G_MISS_CHAR ),
310: NVL( WRITES_LEVEL, FND_API.G_MISS_CHAR ),
311: NVL( SPOKEN_COMPREHENSION_LEVEL, FND_API.G_MISS_CHAR ),

Line 308: NVL( READS_LEVEL, FND_API.G_MISS_CHAR ),

304: NVL( LANGUAGE_NAME, FND_API.G_MISS_CHAR ),
305: NVL( PARTY_ID, FND_API.G_MISS_NUM ),
306: NVL( NATIVE_LANGUAGE, FND_API.G_MISS_CHAR ),
307: NVL( PRIMARY_LANGUAGE_INDICATOR, FND_API.G_MISS_CHAR ),
308: NVL( READS_LEVEL, FND_API.G_MISS_CHAR ),
309: NVL( SPEAKS_LEVEL, FND_API.G_MISS_CHAR ),
310: NVL( WRITES_LEVEL, FND_API.G_MISS_CHAR ),
311: NVL( SPOKEN_COMPREHENSION_LEVEL, FND_API.G_MISS_CHAR ),
312: NVL( STATUS, FND_API.G_MISS_CHAR ),

Line 309: NVL( SPEAKS_LEVEL, FND_API.G_MISS_CHAR ),

305: NVL( PARTY_ID, FND_API.G_MISS_NUM ),
306: NVL( NATIVE_LANGUAGE, FND_API.G_MISS_CHAR ),
307: NVL( PRIMARY_LANGUAGE_INDICATOR, FND_API.G_MISS_CHAR ),
308: NVL( READS_LEVEL, FND_API.G_MISS_CHAR ),
309: NVL( SPEAKS_LEVEL, FND_API.G_MISS_CHAR ),
310: NVL( WRITES_LEVEL, FND_API.G_MISS_CHAR ),
311: NVL( SPOKEN_COMPREHENSION_LEVEL, FND_API.G_MISS_CHAR ),
312: NVL( STATUS, FND_API.G_MISS_CHAR ),
313: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),

Line 310: NVL( WRITES_LEVEL, FND_API.G_MISS_CHAR ),

306: NVL( NATIVE_LANGUAGE, FND_API.G_MISS_CHAR ),
307: NVL( PRIMARY_LANGUAGE_INDICATOR, FND_API.G_MISS_CHAR ),
308: NVL( READS_LEVEL, FND_API.G_MISS_CHAR ),
309: NVL( SPEAKS_LEVEL, FND_API.G_MISS_CHAR ),
310: NVL( WRITES_LEVEL, FND_API.G_MISS_CHAR ),
311: NVL( SPOKEN_COMPREHENSION_LEVEL, FND_API.G_MISS_CHAR ),
312: NVL( STATUS, FND_API.G_MISS_CHAR ),
313: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
314: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )

Line 311: NVL( SPOKEN_COMPREHENSION_LEVEL, FND_API.G_MISS_CHAR ),

307: NVL( PRIMARY_LANGUAGE_INDICATOR, FND_API.G_MISS_CHAR ),
308: NVL( READS_LEVEL, FND_API.G_MISS_CHAR ),
309: NVL( SPEAKS_LEVEL, FND_API.G_MISS_CHAR ),
310: NVL( WRITES_LEVEL, FND_API.G_MISS_CHAR ),
311: NVL( SPOKEN_COMPREHENSION_LEVEL, FND_API.G_MISS_CHAR ),
312: NVL( STATUS, FND_API.G_MISS_CHAR ),
313: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
314: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
315: INTO

Line 312: NVL( STATUS, FND_API.G_MISS_CHAR ),

308: NVL( READS_LEVEL, FND_API.G_MISS_CHAR ),
309: NVL( SPEAKS_LEVEL, FND_API.G_MISS_CHAR ),
310: NVL( WRITES_LEVEL, FND_API.G_MISS_CHAR ),
311: NVL( SPOKEN_COMPREHENSION_LEVEL, FND_API.G_MISS_CHAR ),
312: NVL( STATUS, FND_API.G_MISS_CHAR ),
313: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
314: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
315: INTO
316: X_LANGUAGE_USE_REFERENCE_ID,

Line 313: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),

309: NVL( SPEAKS_LEVEL, FND_API.G_MISS_CHAR ),
310: NVL( WRITES_LEVEL, FND_API.G_MISS_CHAR ),
311: NVL( SPOKEN_COMPREHENSION_LEVEL, FND_API.G_MISS_CHAR ),
312: NVL( STATUS, FND_API.G_MISS_CHAR ),
313: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
314: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
315: INTO
316: X_LANGUAGE_USE_REFERENCE_ID,
317: X_LANGUAGE_NAME,

Line 314: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )

310: NVL( WRITES_LEVEL, FND_API.G_MISS_CHAR ),
311: NVL( SPOKEN_COMPREHENSION_LEVEL, FND_API.G_MISS_CHAR ),
312: NVL( STATUS, FND_API.G_MISS_CHAR ),
313: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
314: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
315: INTO
316: X_LANGUAGE_USE_REFERENCE_ID,
317: X_LANGUAGE_NAME,
318: X_PARTY_ID,

Line 337: RAISE FND_API.G_EXC_ERROR;

333: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
334: FND_MESSAGE.SET_TOKEN( 'RECORD', 'person_language_rec');
335: FND_MESSAGE.SET_TOKEN( 'VALUE', TO_CHAR( X_LANGUAGE_USE_REFERENCE_ID ) );
336: FND_MSG_PUB.ADD;
337: RAISE FND_API.G_EXC_ERROR;
338:
339: END Select_Row;
340:
341: PROCEDURE Delete_Row (