APPS.CS_SERVICEREQUEST_PVT dependencies on CS_INCIDENTS_AUDIT_TL

Line 9959: INSERT INTO cs_incidents_audit_tl (

9955: l_audit_vals_rec.SLA_DURATION_2
9956: )
9957: RETURNING incident_audit_id INTO l_Incident_Audit_Id;
9958:
9959: INSERT INTO cs_incidents_audit_tl (
9960: incident_audit_id,
9961: incident_id,
9962: LANGUAGE,
9963: source_lang,

Line 9983: FROM cs_incidents_audit_tl t

9979: FROM FND_LANGUAGES L
9980: WHERE l.installed_flag IN ('I', 'B')
9981: AND NOT EXISTS
9982: (SELECT NULL
9983: FROM cs_incidents_audit_tl t
9984: WHERE t.incident_audit_id = l_incident_audit_id
9985: AND t.LANGUAGE = l.language_code
9986: ) ;
9987:

Line 20643: DELETE FROM CS_INCIDENTS_AUDIT_TL T

20639: WHERE T.INCIDENT_ID = B.INCIDENT_ID
20640: AND T.LANGUAGE = L.LANGUAGE_CODE);
20641:
20642: -- This is for the incident_audit_table
20643: DELETE FROM CS_INCIDENTS_AUDIT_TL T
20644: WHERE NOT EXISTS
20645: (SELECT NULL
20646: FROM CS_INCIDENTS_AUDIT_B B
20647: WHERE B.INCIDENT_AUDIT_ID = T.INCIDENT_AUDIT_ID

Line 20650: UPDATE CS_INCIDENTS_AUDIT_TL T SET (

20646: FROM CS_INCIDENTS_AUDIT_B B
20647: WHERE B.INCIDENT_AUDIT_ID = T.INCIDENT_AUDIT_ID
20648: );
20649:
20650: UPDATE CS_INCIDENTS_AUDIT_TL T SET (
20651: CHANGE_DESCRIPTION
20652: ) = (SELECT
20653: B.CHANGE_DESCRIPTION
20654: FROM CS_INCIDENTS_AUDIT_TL B

Line 20654: FROM CS_INCIDENTS_AUDIT_TL B

20650: UPDATE CS_INCIDENTS_AUDIT_TL T SET (
20651: CHANGE_DESCRIPTION
20652: ) = (SELECT
20653: B.CHANGE_DESCRIPTION
20654: FROM CS_INCIDENTS_AUDIT_TL B
20655: WHERE B.INCIDENT_AUDIT_ID = T.INCIDENT_AUDIT_ID
20656: AND B.LANGUAGE = T.SOURCE_LANG)
20657: WHERE (
20658: T.INCIDENT_AUDIT_ID,

Line 20663: FROM CS_INCIDENTS_AUDIT_TL SUBB, CS_INCIDENTS_AUDIT_TL SUBT

20659: T.LANGUAGE
20660: ) IN (SELECT
20661: SUBT.INCIDENT_AUDIT_ID,
20662: SUBT.LANGUAGE
20663: FROM CS_INCIDENTS_AUDIT_TL SUBB, CS_INCIDENTS_AUDIT_TL SUBT
20664: WHERE SUBB.INCIDENT_AUDIT_ID = SUBT.INCIDENT_AUDIT_ID
20665: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
20666: AND (SUBB.CHANGE_DESCRIPTION <> SUBT.CHANGE_DESCRIPTION
20667: OR (SUBB.CHANGE_DESCRIPTION IS NULL AND SUBT.CHANGE_DESCRIPTION IS NOT NULL)

Line 20671: INSERT INTO CS_INCIDENTS_AUDIT_TL (

20667: OR (SUBB.CHANGE_DESCRIPTION IS NULL AND SUBT.CHANGE_DESCRIPTION IS NOT NULL)
20668: OR (SUBB.CHANGE_DESCRIPTION IS NOT NULL AND SUBT.CHANGE_DESCRIPTION IS NULL)
20669: ));
20670:
20671: INSERT INTO CS_INCIDENTS_AUDIT_TL (
20672: INCIDENT_AUDIT_ID,
20673: INCIDENT_ID,
20674: LAST_UPDATE_DATE,
20675: LAST_UPDATED_BY,

Line 20693: FROM CS_INCIDENTS_AUDIT_TL B, FND_LANGUAGES L

20689: B.LAST_UPDATE_LOGIN,
20690: B.CHANGE_DESCRIPTION,
20691: L.LANGUAGE_CODE,
20692: B.SOURCE_LANG
20693: FROM CS_INCIDENTS_AUDIT_TL B, FND_LANGUAGES L
20694: WHERE L.INSTALLED_FLAG IN ('I', 'B')
20695: AND B.LANGUAGE = USERENV('LANG')
20696: AND NOT EXISTS
20697: (SELECT NULL

Line 20698: FROM CS_INCIDENTS_AUDIT_TL T

20694: WHERE L.INSTALLED_FLAG IN ('I', 'B')
20695: AND B.LANGUAGE = USERENV('LANG')
20696: AND NOT EXISTS
20697: (SELECT NULL
20698: FROM CS_INCIDENTS_AUDIT_TL T
20699: WHERE T.INCIDENT_AUDIT_ID = B.INCIDENT_AUDIT_ID
20700: AND T.LANGUAGE = L.LANGUAGE_CODE);
20701:
20702: