APPS.JTF_TASK_AUDITS_PKG dependencies on JTF_TASK_AUDITS_TL

Line 315: insert into JTF_TASK_AUDITS_TL (

311: X_NEW_ESCALATION_LEVEL,
312: X_OLD_ESCALATION_LEVEL
313: );
314:
315: insert into JTF_TASK_AUDITS_TL (
316: TASK_AUDIT_ID,
317: OLD_TASK_NAME,
318: NEW_TASK_NAME,
319: OLD_DESCRIPTION,

Line 345: from JTF_TASK_AUDITS_TL T

341: from FND_LANGUAGES L
342: where L.INSTALLED_FLAG in ('I', 'B')
343: and not exists
344: (select NULL
345: from JTF_TASK_AUDITS_TL T
346: where T.TASK_AUDIT_ID = X_TASK_AUDIT_ID
347: and T.LANGUAGE = L.LANGUAGE_CODE);
348:
349: open c;

Line 556: from JTF_TASK_AUDITS_TL

552: NEW_TASK_NAME,
553: OLD_DESCRIPTION,
554: NEW_DESCRIPTION,
555: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
556: from JTF_TASK_AUDITS_TL
557: where TASK_AUDIT_ID = X_TASK_AUDIT_ID
558: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
559: for update of TASK_AUDIT_ID nowait;
560: begin

Line 971: update JTF_TASK_AUDITS_TL set

967: if (sql%notfound) then
968: raise no_data_found;
969: end if;
970:
971: update JTF_TASK_AUDITS_TL set
972: OLD_TASK_NAME = X_OLD_TASK_NAME,
973: NEW_TASK_NAME = X_NEW_TASK_NAME,
974: OLD_DESCRIPTION = X_OLD_DESCRIPTION,
975: NEW_DESCRIPTION = X_NEW_DESCRIPTION,

Line 992: delete from JTF_TASK_AUDITS_TL

988: procedure DELETE_ROW (
989: X_TASK_AUDIT_ID in NUMBER
990: ) is
991: begin
992: delete from JTF_TASK_AUDITS_TL
993: where TASK_AUDIT_ID = X_TASK_AUDIT_ID;
994:
995: if (sql%notfound) then
996: raise no_data_found;

Line 1010: delete from JTF_TASK_AUDITS_TL T

1006:
1007: procedure ADD_LANGUAGE
1008: is
1009: begin
1010: delete from JTF_TASK_AUDITS_TL T
1011: where not exists
1012: (select NULL
1013: from JTF_TASK_AUDITS_B B
1014: where B.TASK_AUDIT_ID = T.TASK_AUDIT_ID

Line 1017: update JTF_TASK_AUDITS_TL T set (

1013: from JTF_TASK_AUDITS_B B
1014: where B.TASK_AUDIT_ID = T.TASK_AUDIT_ID
1015: );
1016:
1017: update JTF_TASK_AUDITS_TL T set (
1018: OLD_TASK_NAME,
1019: NEW_TASK_NAME,
1020: OLD_DESCRIPTION,
1021: NEW_DESCRIPTION

Line 1027: from JTF_TASK_AUDITS_TL B

1023: B.OLD_TASK_NAME,
1024: B.NEW_TASK_NAME,
1025: B.OLD_DESCRIPTION,
1026: B.NEW_DESCRIPTION
1027: from JTF_TASK_AUDITS_TL B
1028: where B.TASK_AUDIT_ID = T.TASK_AUDIT_ID
1029: and B.LANGUAGE = T.SOURCE_LANG)
1030: where (
1031: T.TASK_AUDIT_ID,

Line 1036: from JTF_TASK_AUDITS_TL SUBB, JTF_TASK_AUDITS_TL SUBT

1032: T.LANGUAGE
1033: ) in (select
1034: SUBT.TASK_AUDIT_ID,
1035: SUBT.LANGUAGE
1036: from JTF_TASK_AUDITS_TL SUBB, JTF_TASK_AUDITS_TL SUBT
1037: where SUBB.TASK_AUDIT_ID = SUBT.TASK_AUDIT_ID
1038: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1039: and (SUBB.OLD_TASK_NAME <> SUBT.OLD_TASK_NAME
1040: or SUBB.NEW_TASK_NAME <> SUBT.NEW_TASK_NAME

Line 1049: insert into JTF_TASK_AUDITS_TL (

1045: or (SUBB.NEW_DESCRIPTION is null and SUBT.NEW_DESCRIPTION is not null)
1046: or (SUBB.NEW_DESCRIPTION is not null and SUBT.NEW_DESCRIPTION is null)
1047: ));
1048:
1049: insert into JTF_TASK_AUDITS_TL (
1050: TASK_AUDIT_ID,
1051: OLD_TASK_NAME,
1052: NEW_TASK_NAME,
1053: OLD_DESCRIPTION,

Line 1075: from JTF_TASK_AUDITS_TL B, FND_LANGUAGES L

1071: B.LAST_UPDATE_DATE,
1072: B.LAST_UPDATE_LOGIN,
1073: L.LANGUAGE_CODE,
1074: B.SOURCE_LANG
1075: from JTF_TASK_AUDITS_TL B, FND_LANGUAGES L
1076: where L.INSTALLED_FLAG in ('I', 'B')
1077: and B.LANGUAGE = userenv('LANG')
1078: and not exists
1079: (select NULL

Line 1080: from JTF_TASK_AUDITS_TL T

1076: where L.INSTALLED_FLAG in ('I', 'B')
1077: and B.LANGUAGE = userenv('LANG')
1078: and not exists
1079: (select NULL
1080: from JTF_TASK_AUDITS_TL T
1081: where T.TASK_AUDIT_ID = B.TASK_AUDIT_ID
1082: and T.LANGUAGE = L.LANGUAGE_CODE);
1083: end ADD_LANGUAGE;
1084: