APPS.CS_SERVICEREQUEST_PVT dependencies on CS_INCIDENTS_AUDIT_TL

Line 8947: INSERT INTO cs_incidents_audit_tl (

8943: l_audit_vals_rec.MAINT_ORGANIZATION_ID
8944: )
8945: RETURNING incident_audit_id INTO l_Incident_Audit_Id;
8946:
8947: INSERT INTO cs_incidents_audit_tl (
8948: incident_audit_id,
8949: incident_id,
8950: LANGUAGE,
8951: source_lang,

Line 8971: FROM cs_incidents_audit_tl t

8967: FROM FND_LANGUAGES L
8968: WHERE l.installed_flag IN ('I', 'B')
8969: AND NOT EXISTS
8970: (SELECT NULL
8971: FROM cs_incidents_audit_tl t
8972: WHERE t.incident_audit_id = l_incident_audit_id
8973: AND t.LANGUAGE = l.language_code
8974: ) ;
8975:

Line 19127: DELETE FROM CS_INCIDENTS_AUDIT_TL T

19123: WHERE T.INCIDENT_ID = B.INCIDENT_ID
19124: AND T.LANGUAGE = L.LANGUAGE_CODE);
19125:
19126: -- This is for the incident_audit_table
19127: DELETE FROM CS_INCIDENTS_AUDIT_TL T
19128: WHERE NOT EXISTS
19129: (SELECT NULL
19130: FROM CS_INCIDENTS_AUDIT_B B
19131: WHERE B.INCIDENT_AUDIT_ID = T.INCIDENT_AUDIT_ID

Line 19134: UPDATE CS_INCIDENTS_AUDIT_TL T SET (

19130: FROM CS_INCIDENTS_AUDIT_B B
19131: WHERE B.INCIDENT_AUDIT_ID = T.INCIDENT_AUDIT_ID
19132: );
19133:
19134: UPDATE CS_INCIDENTS_AUDIT_TL T SET (
19135: CHANGE_DESCRIPTION
19136: ) = (SELECT
19137: B.CHANGE_DESCRIPTION
19138: FROM CS_INCIDENTS_AUDIT_TL B

Line 19138: FROM CS_INCIDENTS_AUDIT_TL B

19134: UPDATE CS_INCIDENTS_AUDIT_TL T SET (
19135: CHANGE_DESCRIPTION
19136: ) = (SELECT
19137: B.CHANGE_DESCRIPTION
19138: FROM CS_INCIDENTS_AUDIT_TL B
19139: WHERE B.INCIDENT_AUDIT_ID = T.INCIDENT_AUDIT_ID
19140: AND B.LANGUAGE = T.SOURCE_LANG)
19141: WHERE (
19142: T.INCIDENT_AUDIT_ID,

Line 19147: FROM CS_INCIDENTS_AUDIT_TL SUBB, CS_INCIDENTS_AUDIT_TL SUBT

19143: T.LANGUAGE
19144: ) IN (SELECT
19145: SUBT.INCIDENT_AUDIT_ID,
19146: SUBT.LANGUAGE
19147: FROM CS_INCIDENTS_AUDIT_TL SUBB, CS_INCIDENTS_AUDIT_TL SUBT
19148: WHERE SUBB.INCIDENT_AUDIT_ID = SUBT.INCIDENT_AUDIT_ID
19149: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
19150: AND (SUBB.CHANGE_DESCRIPTION <> SUBT.CHANGE_DESCRIPTION
19151: OR (SUBB.CHANGE_DESCRIPTION IS NULL AND SUBT.CHANGE_DESCRIPTION IS NOT NULL)

Line 19155: INSERT INTO CS_INCIDENTS_AUDIT_TL (

19151: OR (SUBB.CHANGE_DESCRIPTION IS NULL AND SUBT.CHANGE_DESCRIPTION IS NOT NULL)
19152: OR (SUBB.CHANGE_DESCRIPTION IS NOT NULL AND SUBT.CHANGE_DESCRIPTION IS NULL)
19153: ));
19154:
19155: INSERT INTO CS_INCIDENTS_AUDIT_TL (
19156: INCIDENT_AUDIT_ID,
19157: INCIDENT_ID,
19158: LAST_UPDATE_DATE,
19159: LAST_UPDATED_BY,

Line 19177: FROM CS_INCIDENTS_AUDIT_TL B, FND_LANGUAGES L

19173: B.LAST_UPDATE_LOGIN,
19174: B.CHANGE_DESCRIPTION,
19175: L.LANGUAGE_CODE,
19176: B.SOURCE_LANG
19177: FROM CS_INCIDENTS_AUDIT_TL B, FND_LANGUAGES L
19178: WHERE L.INSTALLED_FLAG IN ('I', 'B')
19179: AND B.LANGUAGE = USERENV('LANG')
19180: AND NOT EXISTS
19181: (SELECT NULL

Line 19182: FROM CS_INCIDENTS_AUDIT_TL T

19178: WHERE L.INSTALLED_FLAG IN ('I', 'B')
19179: AND B.LANGUAGE = USERENV('LANG')
19180: AND NOT EXISTS
19181: (SELECT NULL
19182: FROM CS_INCIDENTS_AUDIT_TL T
19183: WHERE T.INCIDENT_AUDIT_ID = B.INCIDENT_AUDIT_ID
19184: AND T.LANGUAGE = L.LANGUAGE_CODE);
19185:
19186: