APPS.JTF_TASK_AUDITS_PVT dependencies on JTF_TASK_AUDITS_TL

Line 2054: insert into JTF_TASK_AUDITS_TL (

2050: X_NEW_DATE_SELECTED,
2051: X_OLD_DATE_SELECTED
2052: );
2053:
2054: insert into JTF_TASK_AUDITS_TL (
2055: TASK_AUDIT_ID,
2056: OLD_TASK_NAME,
2057: NEW_TASK_NAME,
2058: OLD_DESCRIPTION,

Line 2084: from JTF_TASK_AUDITS_TL T

2080: from FND_LANGUAGES L
2081: where L.INSTALLED_FLAG in ('I', 'B')
2082: and not exists
2083: (select NULL
2084: from JTF_TASK_AUDITS_TL T
2085: where T.TASK_AUDIT_ID = X_TASK_AUDIT_ID
2086: and T.LANGUAGE = L.LANGUAGE_CODE);
2087:
2088: open c;

Line 2107: delete from JTF_TASK_AUDITS_TL T

2103: /* The following delete and update statements are commented out */
2104: /* as a quick workaround to fix the time-consuming table handler issue */
2105: /*
2106:
2107: delete from JTF_TASK_AUDITS_TL T
2108: where not exists
2109: (select NULL
2110: from JTF_TASK_AUDITS_B B
2111: where B.TASK_AUDIT_ID = T.TASK_AUDIT_ID

Line 2114: update JTF_TASK_AUDITS_TL T set (

2110: from JTF_TASK_AUDITS_B B
2111: where B.TASK_AUDIT_ID = T.TASK_AUDIT_ID
2112: );
2113:
2114: update JTF_TASK_AUDITS_TL T set (
2115: OLD_TASK_NAME,
2116: NEW_TASK_NAME,
2117: OLD_DESCRIPTION,
2118: NEW_DESCRIPTION

Line 2124: from JTF_TASK_AUDITS_TL B

2120: B.OLD_TASK_NAME,
2121: B.NEW_TASK_NAME,
2122: B.OLD_DESCRIPTION,
2123: B.NEW_DESCRIPTION
2124: from JTF_TASK_AUDITS_TL B
2125: where B.TASK_AUDIT_ID = T.TASK_AUDIT_ID
2126: and B.LANGUAGE = T.SOURCE_LANG)
2127: where (
2128: T.TASK_AUDIT_ID,

Line 2133: from JTF_TASK_AUDITS_TL SUBB, JTF_TASK_AUDITS_TL SUBT

2129: T.LANGUAGE
2130: ) in (select
2131: SUBT.TASK_AUDIT_ID,
2132: SUBT.LANGUAGE
2133: from JTF_TASK_AUDITS_TL SUBB, JTF_TASK_AUDITS_TL SUBT
2134: where SUBB.TASK_AUDIT_ID = SUBT.TASK_AUDIT_ID
2135: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
2136: and (SUBB.OLD_TASK_NAME <> SUBT.OLD_TASK_NAME
2137: or (SUBB.OLD_TASK_NAME is null and SUBT.OLD_TASK_NAME is not null)

Line 2152: insert into JTF_TASK_AUDITS_TL (

2148: )); */
2149:
2150: -- Added hint 'parallel' by SBARAT on 19/01/2006 for perf bug# 4888496
2151:
2152: insert into JTF_TASK_AUDITS_TL (
2153: SECURITY_GROUP_ID,
2154: TASK_AUDIT_ID,
2155: OLD_TASK_NAME,
2156: NEW_TASK_NAME,

Line 2180: from JTF_TASK_AUDITS_TL B, FND_LANGUAGES L

2176: B.LAST_UPDATE_DATE,
2177: B.LAST_UPDATE_LOGIN,
2178: L.LANGUAGE_CODE,
2179: B.SOURCE_LANG
2180: from JTF_TASK_AUDITS_TL B, FND_LANGUAGES L
2181: where L.INSTALLED_FLAG in ('I', 'B')
2182: and B.LANGUAGE = userenv('LANG')
2183: and not exists
2184: (select /*+ parallel(T) */ NULL

Line 2185: from JTF_TASK_AUDITS_TL T

2181: where L.INSTALLED_FLAG in ('I', 'B')
2182: and B.LANGUAGE = userenv('LANG')
2183: and not exists
2184: (select /*+ parallel(T) */ NULL
2185: from JTF_TASK_AUDITS_TL T
2186: where T.TASK_AUDIT_ID = B.TASK_AUDIT_ID
2187: and T.LANGUAGE = L.LANGUAGE_CODE);
2188: end ADD_LANGUAGE;
2189:

Line 2200: update jtf_task_audits_tl set

2196: x_owner in varchar2
2197: )
2198: as
2199: begin
2200: update jtf_task_audits_tl set
2201: old_task_name = nvl(x_old_task_name,old_task_name),
2202: new_task_name = nvl(x_new_task_name,new_task_name),
2203: old_description = nvl(x_old_description,old_description),
2204: new_description = nvl(x_new_description,new_description),