APPS.JTS_CONFIG_VER_STATUS_PVT dependencies on FND_LOOKUP_VALUES

Line 110: l_replay_status FND_LOOKUP_VALUES.meaning%TYPE;

106: l_full_name CONSTANT VARCHAR2 (60) := G_PKG_NAME || '.' || l_api_name;
107: l_versions_csr JTS_CONFIG_UTIL_PVT.Versions_Csr_Type;
108: l_version_id JTS_CONFIG_VERSIONS_B.version_id%TYPE;
109: l_status_code JTS_CONFIG_VERSION_STATUSES.status_code%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;

Line 112: l_version_status FND_LOOKUP_VALUES.meaning%TYPE;

108: l_version_id JTS_CONFIG_VERSIONS_B.version_id%TYPE;
109: l_status_code JTS_CONFIG_VERSION_STATUSES.status_code%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;

Line 173: l_meaning FND_LOOKUP_VALUES.meaning%TYPE;

169: l_api_version CONSTANT NUMBER := 1.0;
170: l_api_name CONSTANT VARCHAR2 (30) := 'GET_VERSION_STATUS_DATA';
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;

Line 182: fnd_lookup_values l,

178:
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