DBA Data[Home] [Help]

APPS.HZ_PERSON_LANGUAGE_PKG dependencies on HZ_UTILITY_V2PUB

Line 61: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

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,
65: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

Line 62: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

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,
65: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
66: HZ_UTILITY_V2PUB.REQUEST_ID,

Line 63: HZ_UTILITY_V2PUB.CREATED_BY,

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,
65: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
66: HZ_UTILITY_V2PUB.REQUEST_ID,
67: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

Line 64: HZ_UTILITY_V2PUB.CREATION_DATE,

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,
65: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
66: HZ_UTILITY_V2PUB.REQUEST_ID,
67: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
68: HZ_UTILITY_V2PUB.PROGRAM_ID,

Line 65: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

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,
65: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
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,

Line 66: HZ_UTILITY_V2PUB.REQUEST_ID,

62: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
63: HZ_UTILITY_V2PUB.CREATED_BY,
64: HZ_UTILITY_V2PUB.CREATION_DATE,
65: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
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 ),

Line 67: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

63: HZ_UTILITY_V2PUB.CREATED_BY,
64: HZ_UTILITY_V2PUB.CREATION_DATE,
65: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
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 ),

Line 68: HZ_UTILITY_V2PUB.PROGRAM_ID,

64: HZ_UTILITY_V2PUB.CREATION_DATE,
65: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
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 ),

Line 69: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

65: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
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

Line 73: HZ_UTILITY_V2PUB.APPLICATION_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
77: X_LANGUAGE_USE_REFERENCE_ID;

Line 144: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

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,
148: -- CREATION_DATE = HZ_UTILITY_V2PUB.CREATION_DATE,

Line 145: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

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,
148: -- CREATION_DATE = HZ_UTILITY_V2PUB.CREATION_DATE,
149: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

Line 147: -- CREATED_BY = HZ_UTILITY_V2PUB.CREATED_BY,

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,
148: -- CREATION_DATE = HZ_UTILITY_V2PUB.CREATION_DATE,
149: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
150: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
151: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

Line 148: -- CREATION_DATE = HZ_UTILITY_V2PUB.CREATION_DATE,

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,
148: -- CREATION_DATE = HZ_UTILITY_V2PUB.CREATION_DATE,
149: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
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,

Line 149: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

145: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
146: -- Bug 3032780
147: -- CREATED_BY = HZ_UTILITY_V2PUB.CREATED_BY,
148: -- CREATION_DATE = HZ_UTILITY_V2PUB.CREATION_DATE,
149: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
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,

Line 150: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,

146: -- Bug 3032780
147: -- CREATED_BY = HZ_UTILITY_V2PUB.CREATED_BY,
148: -- CREATION_DATE = HZ_UTILITY_V2PUB.CREATION_DATE,
149: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
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 ),

Line 151: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

147: -- CREATED_BY = HZ_UTILITY_V2PUB.CREATED_BY,
148: -- CREATION_DATE = HZ_UTILITY_V2PUB.CREATION_DATE,
149: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
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 ),

Line 152: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,

148: -- CREATION_DATE = HZ_UTILITY_V2PUB.CREATION_DATE,
149: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
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 ),

Line 153: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

149: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
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 )