eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_SERVICEREQUEST_PVT dependencies on CS_INCIDENTS_ALL_TL

Line 9: G_TL_TABLE_NAME CONSTANT VARCHAR2(40) := 'CS_INCIDENTS_ALL_TL';

5: G_INITIALIZED CONSTANT VARCHAR2(1) := 'R';
6: G_SR_SUBTYPE CONSTANT VARCHAR2(5) := 'INC';
7: G_API_REVISION CONSTANT NUMBER := 1.0;
8: G_TABLE_NAME CONSTANT VARCHAR2(40) := 'CS_INCIDENTS_ALL_B';
9: G_TL_TABLE_NAME CONSTANT VARCHAR2(40) := 'CS_INCIDENTS_ALL_TL';
10:
11: --siahmed added for 12.1.2 project where
12: --to prevent multiple query to check weather we are updating onetime address or not
13: G_ONETIME_ADD_CNT NUMBER := 0;

Line 1185: -- cs_incidents_all_tl table.

1181: -- modified insert to cs_incidents_all_b and passed values for
1182: -- columns org_id and maint_organization_id
1183: -- 05/27/05 smisra Bug 4227769
1184: -- Removed owner and group_owner columns from insert into
1185: -- cs_incidents_all_tl table.
1186: -- 06/07/05 smisra Release 12 changes
1187: -- Raised error msg when maint_organization_id is passed for
1188: -- Non EAM service requests
1189: -- Raised error msg when maint_organization_id is NOT passed

Line 2736: INSERT INTO cs_incidents_all_tl (

2732:
2733: --
2734: -- Insert into _TL table
2735: --
2736: INSERT INTO cs_incidents_all_tl (
2737: incident_id,
2738: creation_date,
2739: created_by,
2740: last_update_date,

Line 2764: FROM cs_incidents_all_tl t

2760: FROM FND_LANGUAGES L
2761: WHERE l.installed_flag IN ('I', 'B')
2762: AND NOT EXISTS
2763: (SELECT NULL
2764: FROM cs_incidents_all_tl t
2765: WHERE t.incident_id = l_request_id
2766: AND t.LANGUAGE = l.language_code
2767: );
2768:

Line 3713: -- cs_incidents_all_tl table.

3709: -- set maint_organization_id and inventory_item_id cols of
3710: -- audit record.
3711: -- 05/27/05 smisra Bug 4227769
3712: -- Removed owner and group_owner columns from update to
3713: -- cs_incidents_all_tl table.
3714: -- 06/07/05 smisra Release 12 changes
3715: -- Raised error msg when maint_organization_id is passed for
3716: -- Non EAM service requests
3717: -- Raised error msg when maint_organization_id is NOT passed

Line 6023: UPDATE cs_incidents_all_tl

6019: IF l_service_request_rec.type_id <> l_old_servicerequest_rec.incident_type_id
6020: OR NVL(l_service_request_rec.inventory_item_id,-99) <> NVL(l_old_servicerequest_rec.inventory_item_id,-99)
6021: OR l_service_request_rec.summary <> l_old_servicerequest_rec.summary THEN
6022:
6023: UPDATE cs_incidents_all_tl
6024: SET summary = l_service_request_rec.summary,
6025: resolution_summary = l_service_request_rec.resolution_summary,
6026: last_update_date = l_service_request_rec.last_update_date,
6027: last_updated_by = l_service_request_rec.last_updated_by,

Line 6036: UPDATE cs_incidents_all_tl

6032: AND userenv('LANG') IN (LANGUAGE, source_lang);
6033:
6034: ELSE
6035:
6036: UPDATE cs_incidents_all_tl
6037: SET summary = l_service_request_rec.summary,
6038: resolution_summary = l_service_request_rec.resolution_summary,
6039: last_update_date = l_service_request_rec.last_update_date,
6040: last_updated_by = l_service_request_rec.last_updated_by,

Line 6049: -- UPDATE cs_incidents_all_tl

6045: END IF;
6046:
6047: -- For bug 3512696 - modified to point the source lang to be updated with userenv('LANG');
6048:
6049: -- UPDATE cs_incidents_all_tl
6050: -- SET summary = l_service_request_rec.summary,
6051: -- resolution_summary = l_service_request_rec.resolution_summary,
6052: -- owner = l_service_request_rec.owner,
6053: -- group_owner = l_service_request_rec.group_owner,

Line 8230: -- removed update to cs_incidents_all_tl table because it

8226: -- 03/25/05 smisra Bug 4028675
8227: -- Modified this procedure to determine unassigned indicator
8228: -- and updated SR table with the same
8229: -- 05/27/05 smisra Bug 4227769
8230: -- removed update to cs_incidents_all_tl table because it
8231: -- was updating only obsolete columns owner and group owner.
8232: -- 07/11/05 smisra called get_status_detail for SR status and if disallow
8233: -- request update is Y then raise error
8234: -- 07/11/05 smisra Bug 4489746

Line 15509: FROM cs_incidents_all_b b, cs_incidents_all_tl tl

15505: B.sla_duration_1,
15506: B.sla_duration_2,
15507: --15995804. Add price_list_header_id
15508: B.price_list_header_id
15509: FROM cs_incidents_all_b b, cs_incidents_all_tl tl
15510: WHERE b.incident_id = p_request_id
15511: AND b.incident_id = tl.incident_id
15512: AND tl.LANGUAGE = DECODE(l_service_request_rec.LANGUAGE,
15513: FND_API.G_MISS_CHAR, USERENV('LANG'),

Line 20573: DELETE FROM CS_INCIDENTS_ALL_TL T

20569: --Procedure to support MLS
20570: PROCEDURE ADD_LANGUAGE
20571: IS
20572: BEGIN
20573: DELETE FROM CS_INCIDENTS_ALL_TL T
20574: WHERE NOT EXISTS
20575: (SELECT NULL
20576: FROM CS_INCIDENTS_ALL_B B
20577: WHERE B.INCIDENT_ID = T.INCIDENT_ID

Line 20580: UPDATE CS_INCIDENTS_ALL_TL T SET (

20576: FROM CS_INCIDENTS_ALL_B B
20577: WHERE B.INCIDENT_ID = T.INCIDENT_ID
20578: );
20579:
20580: UPDATE CS_INCIDENTS_ALL_TL T SET (
20581: SUMMARY,
20582: RESOLUTION_SUMMARY
20583: --SR_CREATION_CHANNEL
20584: ) = (SELECT

Line 20588: FROM CS_INCIDENTS_ALL_TL B

20584: ) = (SELECT
20585: B.SUMMARY,
20586: B.RESOLUTION_SUMMARY
20587: --B.SR_CREATION_CHANNEL
20588: FROM CS_INCIDENTS_ALL_TL B
20589: WHERE B.INCIDENT_ID = T.INCIDENT_ID
20590: AND B.LANGUAGE = T.SOURCE_LANG)
20591: WHERE (
20592: T.INCIDENT_ID,

Line 20597: FROM CS_INCIDENTS_ALL_TL SUBB, CS_INCIDENTS_ALL_TL SUBT

20593: T.LANGUAGE
20594: ) IN (SELECT
20595: SUBT.INCIDENT_ID,
20596: SUBT.LANGUAGE
20597: FROM CS_INCIDENTS_ALL_TL SUBB, CS_INCIDENTS_ALL_TL SUBT
20598: WHERE SUBB.INCIDENT_ID = SUBT.INCIDENT_ID
20599: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
20600: AND (SUBB.SUMMARY <> SUBT.SUMMARY
20601: OR SUBB.RESOLUTION_SUMMARY <> SUBT.RESOLUTION_SUMMARY

Line 20609: INSERT INTO CS_INCIDENTS_ALL_TL (

20605: --or (SUBB.SR_CREATION_CHANNEL is null and SUBT.SR_CREATION_CHANNEL is not null)
20606: --or (SUBB.SR_CREATION_CHANNEL is not null and SUBT.SR_CREATION_CHANNEL is null)
20607: ));
20608:
20609: INSERT INTO CS_INCIDENTS_ALL_TL (
20610: INCIDENT_ID,
20611: SUMMARY,
20612: RESOLUTION_SUMMARY,
20613: LAST_UPDATE_DATE,

Line 20633: FROM CS_INCIDENTS_ALL_TL B, FND_LANGUAGES L

20629: B.LAST_UPDATE_LOGIN,
20630: --B.SR_CREATION_CHANNEL,
20631: L.LANGUAGE_CODE,
20632: B.SOURCE_LANG
20633: FROM CS_INCIDENTS_ALL_TL B, FND_LANGUAGES L
20634: WHERE L.INSTALLED_FLAG IN ('I', 'B')
20635: AND B.LANGUAGE = USERENV('LANG')
20636: AND NOT EXISTS
20637: (SELECT NULL

Line 20638: FROM CS_INCIDENTS_ALL_TL T

20634: WHERE L.INSTALLED_FLAG IN ('I', 'B')
20635: AND B.LANGUAGE = USERENV('LANG')
20636: AND NOT EXISTS
20637: (SELECT NULL
20638: FROM CS_INCIDENTS_ALL_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