APPS.JTF_MSITE_RESP_PKG dependencies on JTF_MSITE_RESPS_TL

Line 95: INSERT INTO jtf_msite_resps_tl

91: END IF;
92: CLOSE c;
93:
94: -- insert tl
95: INSERT INTO jtf_msite_resps_tl
96: (
97: msite_resp_id,
98: object_version_number,
99: created_by,

Line 131: FROM jtf_msite_resps_tl T

127: FROM fnd_languages L
128: WHERE L.installed_flag IN ('I', 'B')
129: AND NOT EXISTS
130: (SELECT NULL
131: FROM jtf_msite_resps_tl T
132: WHERE T.msite_resp_id = x_msite_resp_id
133: AND T.language = L.language_code);
134:
135: OPEN c;

Line 190: UPDATE jtf_msite_resps_tl SET

186: RAISE NO_DATA_FOUND;
187: END IF;
188:
189: -- update tl
190: UPDATE jtf_msite_resps_tl SET
191: object_version_number = object_version_number + 1,
192: display_name = decode(p_display_name, FND_API.G_MISS_CHAR,
193: display_name, p_display_name),
194: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,

Line 224: DELETE FROM jtf_msite_resps_tl

220: p_msite_resp_id IN NUMBER
221: )
222: IS
223: BEGIN
224: DELETE FROM jtf_msite_resps_tl
225: WHERE msite_resp_id = p_msite_resp_id;
226:
227: IF (sql%NOTFOUND) THEN
228: RAISE NO_DATA_FOUND;

Line 243: delete FROM jtf_msite_resps_tl T

239:
240: PROCEDURE add_language
241: IS
242: BEGIN
243: delete FROM jtf_msite_resps_tl T
244: WHERE NOT EXISTS
245: (SELECT NULL
246: FROM jtf_msite_resps_b B
247: WHERE B.MSITE_RESP_ID = T.MSITE_RESP_ID

Line 250: UPDATE jtf_msite_resps_tl T SET

246: FROM jtf_msite_resps_b B
247: WHERE B.MSITE_RESP_ID = T.MSITE_RESP_ID
248: );
249:
250: UPDATE jtf_msite_resps_tl T SET
251: (
252: DISPLAY_NAME
253: ) = (SELECT
254: B.DISPLAY_NAME

Line 255: FROM jtf_msite_resps_tl B

251: (
252: DISPLAY_NAME
253: ) = (SELECT
254: B.DISPLAY_NAME
255: FROM jtf_msite_resps_tl B
256: WHERE B.MSITE_RESP_ID = T.MSITE_RESP_ID
257: AND B.LANGUAGE = T.SOURCE_LANG)
258: WHERE
259: (

Line 265: FROM jtf_msite_resps_tl SUBB, jtf_msite_resps_tl SUBT

261: T.LANGUAGE
262: ) IN (select
263: SUBT.MSITE_RESP_ID,
264: SUBT.LANGUAGE
265: FROM jtf_msite_resps_tl SUBB, jtf_msite_resps_tl SUBT
266: WHERE SUBB.MSITE_RESP_ID = SUBT.MSITE_RESP_ID
267: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
268: AND (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
269: ));

Line 271: INSERT INTO jtf_msite_resps_tl

267: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
268: AND (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
269: ));
270:
271: INSERT INTO jtf_msite_resps_tl
272: (
273: MSITE_RESP_ID,
274: OBJECT_VERSION_NUMBER,
275: CREATED_BY,

Line 296: FROM jtf_msite_resps_tl B, FND_LANGUAGES L

292: B.DISPLAY_NAME,
293: B.SECURITY_GROUP_ID,
294: L.LANGUAGE_CODE,
295: B.SOURCE_LANG
296: FROM jtf_msite_resps_tl B, FND_LANGUAGES L
297: WHERE L.INSTALLED_FLAG IN ('I', 'B')
298: and B.LANGUAGE = userenv('LANG')
299: and not exists
300: (select NULL

Line 301: FROM jtf_msite_resps_tl T

297: WHERE L.INSTALLED_FLAG IN ('I', 'B')
298: and B.LANGUAGE = userenv('LANG')
299: and not exists
300: (select NULL
301: FROM jtf_msite_resps_tl T
302: WHERE T.MSITE_RESP_ID = B.MSITE_RESP_ID
303: and T.LANGUAGE = L.LANGUAGE_CODE);
304: END add_language;
305: