APPS.JTF_TASK_AUDITS_PVT dependencies on JTF_TASK_AUDITS_TL

Line 2129: insert into JTF_TASK_AUDITS_TL (

2125: X_NEW_DATE_SELECTED,
2126: X_OLD_DATE_SELECTED
2127: );
2128:
2129: insert into JTF_TASK_AUDITS_TL (
2130: TASK_AUDIT_ID,
2131: OLD_TASK_NAME,
2132: NEW_TASK_NAME,
2133: OLD_DESCRIPTION,

Line 2159: from JTF_TASK_AUDITS_TL T

2155: from FND_LANGUAGES L
2156: where L.INSTALLED_FLAG in ('I', 'B')
2157: and not exists
2158: (select NULL
2159: from JTF_TASK_AUDITS_TL T
2160: where T.TASK_AUDIT_ID = X_TASK_AUDIT_ID
2161: and T.LANGUAGE = L.LANGUAGE_CODE);
2162:
2163: open c;

Line 2182: delete from JTF_TASK_AUDITS_TL T

2178: /* The following delete and update statements are commented out */
2179: /* as a quick workaround to fix the time-consuming table handler issue */
2180: /*
2181:
2182: delete from JTF_TASK_AUDITS_TL T
2183: where not exists
2184: (select NULL
2185: from JTF_TASK_AUDITS_B B
2186: where B.TASK_AUDIT_ID = T.TASK_AUDIT_ID

Line 2189: update JTF_TASK_AUDITS_TL T set (

2185: from JTF_TASK_AUDITS_B B
2186: where B.TASK_AUDIT_ID = T.TASK_AUDIT_ID
2187: );
2188:
2189: update JTF_TASK_AUDITS_TL T set (
2190: OLD_TASK_NAME,
2191: NEW_TASK_NAME,
2192: OLD_DESCRIPTION,
2193: NEW_DESCRIPTION

Line 2199: from JTF_TASK_AUDITS_TL B

2195: B.OLD_TASK_NAME,
2196: B.NEW_TASK_NAME,
2197: B.OLD_DESCRIPTION,
2198: B.NEW_DESCRIPTION
2199: from JTF_TASK_AUDITS_TL B
2200: where B.TASK_AUDIT_ID = T.TASK_AUDIT_ID
2201: and B.LANGUAGE = T.SOURCE_LANG)
2202: where (
2203: T.TASK_AUDIT_ID,

Line 2208: from JTF_TASK_AUDITS_TL SUBB, JTF_TASK_AUDITS_TL SUBT

2204: T.LANGUAGE
2205: ) in (select
2206: SUBT.TASK_AUDIT_ID,
2207: SUBT.LANGUAGE
2208: from JTF_TASK_AUDITS_TL SUBB, JTF_TASK_AUDITS_TL SUBT
2209: where SUBB.TASK_AUDIT_ID = SUBT.TASK_AUDIT_ID
2210: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
2211: and (SUBB.OLD_TASK_NAME <> SUBT.OLD_TASK_NAME
2212: or (SUBB.OLD_TASK_NAME is null and SUBT.OLD_TASK_NAME is not null)

Line 2227: insert into JTF_TASK_AUDITS_TL (

2223: )); */
2224:
2225: -- Added hint 'parallel' by SBARAT on 19/01/2006 for perf bug# 4888496
2226:
2227: insert into JTF_TASK_AUDITS_TL (
2228: SECURITY_GROUP_ID,
2229: TASK_AUDIT_ID,
2230: OLD_TASK_NAME,
2231: NEW_TASK_NAME,

Line 2255: from JTF_TASK_AUDITS_TL B, FND_LANGUAGES L

2251: B.LAST_UPDATE_DATE,
2252: B.LAST_UPDATE_LOGIN,
2253: L.LANGUAGE_CODE,
2254: B.SOURCE_LANG
2255: from JTF_TASK_AUDITS_TL B, FND_LANGUAGES L
2256: where L.INSTALLED_FLAG in ('I', 'B')
2257: and B.LANGUAGE = userenv('LANG')
2258: and not exists
2259: (select /*+ parallel(T) */ NULL

Line 2260: from JTF_TASK_AUDITS_TL T

2256: where L.INSTALLED_FLAG in ('I', 'B')
2257: and B.LANGUAGE = userenv('LANG')
2258: and not exists
2259: (select /*+ parallel(T) */ NULL
2260: from JTF_TASK_AUDITS_TL T
2261: where T.TASK_AUDIT_ID = B.TASK_AUDIT_ID
2262: and T.LANGUAGE = L.LANGUAGE_CODE);
2263: end ADD_LANGUAGE;
2264:

Line 2275: update jtf_task_audits_tl set

2271: x_owner in varchar2
2272: )
2273: as
2274: begin
2275: update jtf_task_audits_tl set
2276: old_task_name = nvl(x_old_task_name,old_task_name),
2277: new_task_name = nvl(x_new_task_name,new_task_name),
2278: old_description = nvl(x_old_description,old_description),
2279: new_description = nvl(x_new_description,new_description),