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: --
12: --This procedure checks if an attribute is g_miss_char, if no then it returns.
13: --otherwise it checks if the given attribute is part of

Line 1133: -- cs_incidents_all_tl table.

1129: -- modified insert to cs_incidents_all_b and passed values for
1130: -- columns org_id and maint_organization_id
1131: -- 05/27/05 smisra Bug 4227769
1132: -- Removed owner and group_owner columns from insert into
1133: -- cs_incidents_all_tl table.
1134: -- 06/07/05 smisra Release 12 changes
1135: -- Raised error msg when maint_organization_id is passed for
1136: -- Non EAM service requests
1137: -- Raised error msg when maint_organization_id is NOT passed

Line 2406: INSERT INTO cs_incidents_all_tl (

2402:
2403: --
2404: -- Insert into _TL table
2405: --
2406: INSERT INTO cs_incidents_all_tl (
2407: incident_id,
2408: creation_date,
2409: created_by,
2410: last_update_date,

Line 2434: FROM cs_incidents_all_tl t

2430: FROM FND_LANGUAGES L
2431: WHERE l.installed_flag IN ('I', 'B')
2432: AND NOT EXISTS
2433: (SELECT NULL
2434: FROM cs_incidents_all_tl t
2435: WHERE t.incident_id = l_request_id
2436: AND t.LANGUAGE = l.language_code
2437: );
2438:

Line 3373: -- cs_incidents_all_tl table.

3369: -- set maint_organization_id and inventory_item_id cols of
3370: -- audit record.
3371: -- 05/27/05 smisra Bug 4227769
3372: -- Removed owner and group_owner columns from update to
3373: -- cs_incidents_all_tl table.
3374: -- 06/07/05 smisra Release 12 changes
3375: -- Raised error msg when maint_organization_id is passed for
3376: -- Non EAM service requests
3377: -- Raised error msg when maint_organization_id is NOT passed

Line 5341: UPDATE cs_incidents_all_tl

5337: IF l_service_request_rec.type_id <> l_old_servicerequest_rec.incident_type_id
5338: OR NVL(l_service_request_rec.inventory_item_id,-99) <> NVL(l_old_servicerequest_rec.inventory_item_id,-99)
5339: OR l_service_request_rec.summary <> l_old_servicerequest_rec.summary THEN
5340:
5341: UPDATE cs_incidents_all_tl
5342: SET summary = l_service_request_rec.summary,
5343: resolution_summary = l_service_request_rec.resolution_summary,
5344: last_update_date = l_service_request_rec.last_update_date,
5345: last_updated_by = l_service_request_rec.last_updated_by,

Line 5354: UPDATE cs_incidents_all_tl

5350: AND userenv('LANG') IN (LANGUAGE, source_lang);
5351:
5352: ELSE
5353:
5354: UPDATE cs_incidents_all_tl
5355: SET summary = l_service_request_rec.summary,
5356: resolution_summary = l_service_request_rec.resolution_summary,
5357: last_update_date = l_service_request_rec.last_update_date,
5358: last_updated_by = l_service_request_rec.last_updated_by,

Line 5367: -- UPDATE cs_incidents_all_tl

5363: END IF;
5364:
5365: -- For bug 3512696 - modified to point the source lang to be updated with userenv('LANG');
5366:
5367: -- UPDATE cs_incidents_all_tl
5368: -- SET summary = l_service_request_rec.summary,
5369: -- resolution_summary = l_service_request_rec.resolution_summary,
5370: -- owner = l_service_request_rec.owner,
5371: -- group_owner = l_service_request_rec.group_owner,

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

7284: -- 03/25/05 smisra Bug 4028675
7285: -- Modified this procedure to determine unassigned indicator
7286: -- and updated SR table with the same
7287: -- 05/27/05 smisra Bug 4227769
7288: -- removed update to cs_incidents_all_tl table because it
7289: -- was updating only obsolete columns owner and group owner.
7290: -- 07/11/05 smisra called get_status_detail for SR status and if disallow
7291: -- request update is Y then raise error
7292: -- 07/11/05 smisra Bug 4489746

Line 14302: FROM cs_incidents_all_b b, cs_incidents_all_tl tl

14298: -- Added for Misc ERs project (11.5.10) --anmukher --08/26/03
14299: B.INCIDENT_LOCATION_TYPE ,
14300: --B.PRIMARY_CONTACT_ID
14301: B.maint_organization_id
14302: FROM cs_incidents_all_b b, cs_incidents_all_tl tl
14303: WHERE b.incident_id = p_request_id
14304: AND b.incident_id = tl.incident_id
14305: AND tl.LANGUAGE = DECODE(l_service_request_rec.LANGUAGE,
14306: FND_API.G_MISS_CHAR, USERENV('LANG'),

Line 19057: DELETE FROM CS_INCIDENTS_ALL_TL T

19053: --Procedure to support MLS
19054: PROCEDURE ADD_LANGUAGE
19055: IS
19056: BEGIN
19057: DELETE FROM CS_INCIDENTS_ALL_TL T
19058: WHERE NOT EXISTS
19059: (SELECT NULL
19060: FROM CS_INCIDENTS_ALL_B B
19061: WHERE B.INCIDENT_ID = T.INCIDENT_ID

Line 19064: UPDATE CS_INCIDENTS_ALL_TL T SET (

19060: FROM CS_INCIDENTS_ALL_B B
19061: WHERE B.INCIDENT_ID = T.INCIDENT_ID
19062: );
19063:
19064: UPDATE CS_INCIDENTS_ALL_TL T SET (
19065: SUMMARY,
19066: RESOLUTION_SUMMARY
19067: --SR_CREATION_CHANNEL
19068: ) = (SELECT

Line 19072: FROM CS_INCIDENTS_ALL_TL B

19068: ) = (SELECT
19069: B.SUMMARY,
19070: B.RESOLUTION_SUMMARY
19071: --B.SR_CREATION_CHANNEL
19072: FROM CS_INCIDENTS_ALL_TL B
19073: WHERE B.INCIDENT_ID = T.INCIDENT_ID
19074: AND B.LANGUAGE = T.SOURCE_LANG)
19075: WHERE (
19076: T.INCIDENT_ID,

Line 19081: FROM CS_INCIDENTS_ALL_TL SUBB, CS_INCIDENTS_ALL_TL SUBT

19077: T.LANGUAGE
19078: ) IN (SELECT
19079: SUBT.INCIDENT_ID,
19080: SUBT.LANGUAGE
19081: FROM CS_INCIDENTS_ALL_TL SUBB, CS_INCIDENTS_ALL_TL SUBT
19082: WHERE SUBB.INCIDENT_ID = SUBT.INCIDENT_ID
19083: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
19084: AND (SUBB.SUMMARY <> SUBT.SUMMARY
19085: OR SUBB.RESOLUTION_SUMMARY <> SUBT.RESOLUTION_SUMMARY

Line 19093: INSERT INTO CS_INCIDENTS_ALL_TL (

19089: --or (SUBB.SR_CREATION_CHANNEL is null and SUBT.SR_CREATION_CHANNEL is not null)
19090: --or (SUBB.SR_CREATION_CHANNEL is not null and SUBT.SR_CREATION_CHANNEL is null)
19091: ));
19092:
19093: INSERT INTO CS_INCIDENTS_ALL_TL (
19094: INCIDENT_ID,
19095: SUMMARY,
19096: RESOLUTION_SUMMARY,
19097: LAST_UPDATE_DATE,

Line 19117: FROM CS_INCIDENTS_ALL_TL B, FND_LANGUAGES L

19113: B.LAST_UPDATE_LOGIN,
19114: --B.SR_CREATION_CHANNEL,
19115: L.LANGUAGE_CODE,
19116: B.SOURCE_LANG
19117: FROM CS_INCIDENTS_ALL_TL B, FND_LANGUAGES L
19118: WHERE L.INSTALLED_FLAG IN ('I', 'B')
19119: AND B.LANGUAGE = USERENV('LANG')
19120: AND NOT EXISTS
19121: (SELECT NULL

Line 19122: FROM CS_INCIDENTS_ALL_TL T

19118: WHERE L.INSTALLED_FLAG IN ('I', 'B')
19119: AND B.LANGUAGE = USERENV('LANG')
19120: AND NOT EXISTS
19121: (SELECT NULL
19122: FROM CS_INCIDENTS_ALL_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