DBA Data[Home] [Help]

APPS.JTS_CONFIG_VER_STATUS_PVT dependencies on FND_USER

Line 114: l_replayed_by_name FND_USER.user_name%TYPE;

110: l_replay_status FND_LOOKUP_VALUES.meaning%TYPE;
111: l_version_status_code JTS_CONFIG_VERSION_STATUSES.status_code%TYPE;
112: l_version_status FND_LOOKUP_VALUES.meaning%TYPE;
113: l_replayed_date JTS_CONFIG_VERSION_STATUSES.last_update_date%TYPE;
114: l_replayed_by_name FND_USER.user_name%TYPE;
115: l_not_replayed BOOLEAN := TRUE;
116: l_in_replay BOOLEAN := FALSE;
117: BEGIN
118: IF NOT fnd_api.compatible_api_call ( l_api_version,

Line 175: l_replayed_by_name FND_USER.user_name%TYPE;

171: l_full_name CONSTANT VARCHAR2 (60) := G_PKG_NAME || '.' || l_api_name;
172: l_status JTS_CONFIG_VERSION_STATUSES.status_code%TYPE;
173: l_meaning FND_LOOKUP_VALUES.meaning%TYPE;
174: l_replayed_date JTS_CONFIG_VERSION_STATUSES.last_update_date%TYPE;
175: l_replayed_by_name FND_USER.user_name%TYPE;
176: l_replay_done BOOLEAN := FALSE;
177: l_version_done BOOLEAN := FALSE;
178:
179: CURSOR Statuses_Csr IS

Line 183: fnd_user u

179: CURSOR Statuses_Csr IS
180: SELECT vs.status_code, l.meaning, vs.creation_date, u.user_name
181: FROM jts_config_version_statuses vs,
182: fnd_lookup_values l,
183: fnd_user u
184: WHERE version_id = p_version_id
185: AND l.lookup_type = C_STATUS_TYPE
186: AND l.lookup_code = vs.status_code
187: AND u.user_id (+) = vs.created_by