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_WF_AUTO_NTFY_UPDATE_PKG dependencies on CS_INCIDENT_LINKS

Line 137: FROM cs_incident_links cil

133: and (csad.incident_status_id IS NOT NULL OR
134: csad.resolution_code IS NOT NULL)
135: and csat.relationship_type_id IN
136: ( select cil.link_type_id
137: FROM cs_incident_links cil
138: WHERE cil.subject_id = l_request_id)
139: -- We need to add this to differentiate it from notification rules.
140: -- We may have a ntfxn rule without a template_id (partially created).
141: and csad.action_code NOT like 'NOTIFY%'

Line 168: FROM cs_incident_links cil

164: -- We may have a ntfxn rule without a template_id (partially created).
165: and csad.action_code NOT like 'NOTIFY%'
166: and csad.relationship_type_id IN
167: ( select cil.link_type_id
168: FROM cs_incident_links cil
169: WHERE cil.subject_id = l_request_id)
170: /******************
171: -- For 11.5.9, we are not supporting any Update Rules defined by the user.
172: -- So csad.relationship_type_id will always have a value as defined from the

Line 234: cs_incident_links

230: */
231:
232: CURSOR check_if_rel_is_sr_csr IS
233: SELECT subject_type FROM
234: cs_incident_links
235: WHERE subject_id = l_request_number;
236: l_subject_type VARCHAR2(35) := null;
237:
238:

Line 649: FROM cs_incident_links cil,

645: SELECT
646: cil.object_id,
647: cil.link_id,
648: inc.incident_owner_id
649: FROM cs_incident_links cil,
650: cs_incidents_all_b inc
651: WHERE cil.subject_id = l_request_id
652: and inc.incident_id = cil.object_id
653: ORDER BY cil.object_id;

Line 662: FROM cs_incident_links cil,

658: SELECT
659: cil.object_id,
660: cil.link_id,
661: inc.incident_owner_id
662: FROM cs_incident_links cil,
663: cs_incidents_all_b inc
664: WHERE cil.subject_id = l_request_id
665: AND cil.link_type_id = l_relationship_type_id
666: AND inc.incident_id = cil.object_id

Line 1393: FROM cs_incident_links cil,

1389: inc.incident_owner_id,
1390: cil.object_id,
1391: cil.link_type_id,
1392: cilt.name link_type_name
1393: FROM cs_incident_links cil,
1394: cs_incidents_all_b inc,
1395: CS_SR_LINK_TYPES_VL cilt
1396: WHERE cil.subject_id = l_request_id
1397: and cil.object_id = l_notify_subject_id

Line 1508: FROM cs_incident_links cil,

1504: -- The following cursor is needed to fill in the 1 NEW WF item attributes:
1505: -- 1. NTFY_LINK_TYPE
1506: CURSOR sel_linked_sr_type_csr IS
1507: SELECT cilt.name link_type_name
1508: FROM cs_incident_links cil,
1509: CS_SR_LINK_TYPES_VL cilt
1510: WHERE cilt.link_type_id = cil.link_type_id AND
1511: cil.subject_id = l_notify_subject_id AND
1512: cil.object_id = l_request_id;

Line 4369: FROM cs_incident_links cil,

4365: SELECT
4366: cil.object_id,
4367: cil.link_id,
4368: inc.incident_owner_id
4369: FROM cs_incident_links cil,
4370: cs_incidents_all_b inc
4371: WHERE cil.subject_id = l_request_id
4372: and inc.incident_id = cil.object_id
4373: and cil.object_id > l_subject_id

Line 4381: FROM cs_incident_links cil,

4377: SELECT
4378: cil.object_id,
4379: cil.link_id,
4380: inc.incident_owner_id
4381: FROM cs_incident_links cil,
4382: cs_incidents_all_b inc
4383: WHERE cil.subject_id = l_request_id
4384: AND cil.link_type_id = l_relationship_type_id
4385: AND inc.incident_id = cil.object_id

Line 4841: --l_link_id CS_INCIDENT_LINKS.LINK_ID%TYPE;

4837: result OUT NOCOPY VARCHAR2 ) IS
4838:
4839: l_event_action VARCHAR2(50);
4840: l_actions_list VARCHAR2(4000);
4841: --l_link_id CS_INCIDENT_LINKS.LINK_ID%TYPE;
4842: --l_subject_id CS_INCIDENT_LINKS.SUBJECT_ID%TYPE;
4843: --l_link_type_code CS_INCIDENT_LINKS.LINK_TYPE_CODE%TYPE;
4844:
4845: l_update_conditions_list VARCHAR2(4000);

Line 4842: --l_subject_id CS_INCIDENT_LINKS.SUBJECT_ID%TYPE;

4838:
4839: l_event_action VARCHAR2(50);
4840: l_actions_list VARCHAR2(4000);
4841: --l_link_id CS_INCIDENT_LINKS.LINK_ID%TYPE;
4842: --l_subject_id CS_INCIDENT_LINKS.SUBJECT_ID%TYPE;
4843: --l_link_type_code CS_INCIDENT_LINKS.LINK_TYPE_CODE%TYPE;
4844:
4845: l_update_conditions_list VARCHAR2(4000);
4846: l_update_actions_list VARCHAR2(4000);

Line 4843: --l_link_type_code CS_INCIDENT_LINKS.LINK_TYPE_CODE%TYPE;

4839: l_event_action VARCHAR2(50);
4840: l_actions_list VARCHAR2(4000);
4841: --l_link_id CS_INCIDENT_LINKS.LINK_ID%TYPE;
4842: --l_subject_id CS_INCIDENT_LINKS.SUBJECT_ID%TYPE;
4843: --l_link_type_code CS_INCIDENT_LINKS.LINK_TYPE_CODE%TYPE;
4844:
4845: l_update_conditions_list VARCHAR2(4000);
4846: l_update_actions_list VARCHAR2(4000);
4847: l_event_condition_id CS_SR_ACTION_TRIGGERS.event_condition_id%TYPE;

Line 4944: --l_subject_id CS_INCIDENT_LINKS.SUBJECT_ID%TYPE;

4940: l_event_action VARCHAR2(50);
4941: l_actions_list VARCHAR2(4000);
4942: --l_link_id VARCHAR2(20);
4943:
4944: --l_subject_id CS_INCIDENT_LINKS.SUBJECT_ID%TYPE;
4945: l_subject_id VARCHAR2(30);
4946: --l_link_type_code CS_INCIDENT_LINKS.LINK_TYPE_CODE%TYPE;
4947: l_event_condition_id CS_SR_ACTION_TRIGGERS.event_condition_id%TYPE;
4948: l_action_code CS_SR_ACTION_DETAILS.action_code%TYPE;

Line 4946: --l_link_type_code CS_INCIDENT_LINKS.LINK_TYPE_CODE%TYPE;

4942: --l_link_id VARCHAR2(20);
4943:
4944: --l_subject_id CS_INCIDENT_LINKS.SUBJECT_ID%TYPE;
4945: l_subject_id VARCHAR2(30);
4946: --l_link_type_code CS_INCIDENT_LINKS.LINK_TYPE_CODE%TYPE;
4947: l_event_condition_id CS_SR_ACTION_TRIGGERS.event_condition_id%TYPE;
4948: l_action_code CS_SR_ACTION_DETAILS.action_code%TYPE;
4949:
4950: l_new_request_status VARCHAR2(30);

Line 4999: FROM cs_incident_links cil

4995: CURSOR sel_link_csr IS
4996: SELECT cil.link_type_id,
4997: cil.object_id,
4998: cil.link_id
4999: FROM cs_incident_links cil
5000: WHERE cil.subject_id = l_request_id
5001: AND cil.link_type_id = l_relationship_type_id
5002: ORDER BY cil.object_id;
5003:

Line 5178: --l_subject_id CS_INCIDENT_LINKS.SUBJECT_ID%TYPE;

5174: actid IN NUMBER,
5175: funmode IN VARCHAR2,
5176: result OUT NOCOPY VARCHAR2 ) IS
5177:
5178: --l_subject_id CS_INCIDENT_LINKS.SUBJECT_ID%TYPE;
5179: --l_subject_id VARCHAR2(30);
5180:
5181: l_linked_subject_list VARCHAR2(4000);
5182: l_element VARCHAR2(100);

Line 5255: l_subject_id CS_INCIDENT_LINKS.SUBJECT_ID%TYPE;

5251: actid IN NUMBER,
5252: funmode IN VARCHAR2,
5253: result OUT NOCOPY VARCHAR2 ) IS
5254:
5255: l_subject_id CS_INCIDENT_LINKS.SUBJECT_ID%TYPE;
5256: --l_link_type_code CS_INCIDENT_LINKS.LINK_TYPE_CODE%TYPE;
5257: l_subject_status_id CS_SR_ACTION_DETAILS.incident_status_id%TYPE;
5258: l_resolution_code CS_SR_ACTION_DETAILS.resolution_code%TYPE;
5259: l_close_flag VARCHAR2(1);

Line 5256: --l_link_type_code CS_INCIDENT_LINKS.LINK_TYPE_CODE%TYPE;

5252: funmode IN VARCHAR2,
5253: result OUT NOCOPY VARCHAR2 ) IS
5254:
5255: l_subject_id CS_INCIDENT_LINKS.SUBJECT_ID%TYPE;
5256: --l_link_type_code CS_INCIDENT_LINKS.LINK_TYPE_CODE%TYPE;
5257: l_subject_status_id CS_SR_ACTION_DETAILS.incident_status_id%TYPE;
5258: l_resolution_code CS_SR_ACTION_DETAILS.resolution_code%TYPE;
5259: l_close_flag VARCHAR2(1);
5260: l_link_id CS_INCIDENT_LINKS.LINK_ID%TYPE;

Line 5260: l_link_id CS_INCIDENT_LINKS.LINK_ID%TYPE;

5256: --l_link_type_code CS_INCIDENT_LINKS.LINK_TYPE_CODE%TYPE;
5257: l_subject_status_id CS_SR_ACTION_DETAILS.incident_status_id%TYPE;
5258: l_resolution_code CS_SR_ACTION_DETAILS.resolution_code%TYPE;
5259: l_close_flag VARCHAR2(1);
5260: l_link_id CS_INCIDENT_LINKS.LINK_ID%TYPE;
5261:
5262: l_action_code CS_SR_ACTION_DETAILS.action_code%TYPE;
5263: l_sr_updated NUMBER;
5264: l_incident_status_id NUMBER;

Line 5271: FROM cs_incident_links cil,

5267: --l_err_txt VARCHAR2(30);
5268:
5269: CURSOR sel_related_sr_cur(lv_incident_id IN NUMBER) IS
5270: SELECT cil.link_id
5271: FROM cs_incident_links cil,
5272: cs_incidents_all_b inc
5273: WHERE cil.subject_id = lv_incident_id
5274: -- Hard coded values for 'CAUSED BY' (2) and 'DUPLICATE OF' (3).
5275: AND cil.link_type_id = 2

Line 5442: l_subject_id CS_INCIDENT_LINKS.SUBJECT_ID%TYPE;

5438: result OUT NOCOPY VARCHAR2 ) IS
5439:
5440: l_request_number VARCHAR2(64);
5441: l_request_id NUMBER;
5442: l_subject_id CS_INCIDENT_LINKS.SUBJECT_ID%TYPE;
5443: l_subject_status_id CS_SR_ACTION_DETAILS.incident_status_id%TYPE;
5444: l_resolution_code CS_SR_ACTION_DETAILS.resolution_code%TYPE;
5445: l_service_request_rec CS_ServiceRequest_PVT.service_request_rec_type;
5446: l_object_version_number NUMBER;

Line 5683: l_subject_id CS_INCIDENT_LINKS.SUBJECT_ID%TYPE;

5679: result OUT NOCOPY VARCHAR2 ) IS
5680:
5681: l_request_number VARCHAR2(64);
5682: l_request_id NUMBER;
5683: l_subject_id CS_INCIDENT_LINKS.SUBJECT_ID%TYPE;
5684: l_subject_status_id CS_SR_ACTION_DETAILS.incident_status_id%TYPE;
5685: l_action_code CS_SR_ACTION_DETAILS.action_code%TYPE;
5686: l_subject_owner_id NUMBER;
5687:

Line 5820: --l_link_type_code CS_INCIDENT_LINKS.LINK_TYPE_CODE%TYPE;

5816: funmode IN VARCHAR2,
5817: result OUT NOCOPY VARCHAR2 ) IS
5818:
5819: l_linked_subject_list VARCHAR2(4000);
5820: --l_link_type_code CS_INCIDENT_LINKS.LINK_TYPE_CODE%TYPE;
5821: --l_event_condition_id CS_SR_ACTION_TRIGGERS.event_condition_id%TYPE;
5822: --l_action_code CS_SR_ACTION_DETAILS.action_code%TYPE;
5823: l_relationship_type_id CS_SR_ACTION_DETAILS.relationship_type_id%TYPE;
5824: l_relationship_type_name VARCHAR2(240);

Line 5836: FROM cs_incident_links cil,

5832: CURSOR sel_link_csr IS
5833: SELECT cil.link_type_id,
5834: cil.object_id,
5835: cil.link_id
5836: FROM cs_incident_links cil,
5837: CS_SR_LINK_TYPES_VL cilt
5838: WHERE cil.subject_id = l_request_id
5839: AND cil.link_type_id = cilt.link_type_id
5840: AND cilt.name = l_relationship_type_name

Line 6002: FROM cs_incident_links cil

5998: and (csad.incident_status_id IS NOT NULL OR
5999: csad.resolution_code IS NOT NULL)
6000: and csat.relationship_type_id IN
6001: ( select cil.link_type_id
6002: FROM cs_incident_links cil
6003: WHERE cil.subject_id = l_request_id)
6004: AND TO_CHAR(csad.event_condition_id) || csad.action_code >
6005: TO_CHAR(l_event_condition_id) || l_action_code
6006: UNION

Line 6027: FROM cs_incident_links cil

6023: and csat.incident_status_id IS NOT NULL
6024: and csad.action_code NOT like 'NOTIFY%'
6025: and csad.relationship_type_id IN
6026: ( select cil.link_type_id
6027: FROM cs_incident_links cil
6028: WHERE cil.subject_id = l_request_id)
6029: AND TO_CHAR(csad.event_condition_id) || csad.action_code >
6030: TO_CHAR(l_event_condition_id) || l_action_code
6031: ORDER BY index_cols;