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 1397: FROM cs_incident_links cil,

1393: inc.incident_owner_id,
1394: cil.object_id,
1395: cil.link_type_id,
1396: cilt.name link_type_name
1397: FROM cs_incident_links cil,
1398: cs_incidents_all_b inc,
1399: CS_SR_LINK_TYPES_VL cilt
1400: WHERE cil.subject_id = l_request_id
1401: and cil.object_id = l_notify_subject_id

Line 1512: FROM cs_incident_links cil,

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

Line 4431: FROM cs_incident_links cil,

4427: SELECT
4428: cil.object_id,
4429: cil.link_id,
4430: inc.incident_owner_id
4431: FROM cs_incident_links cil,
4432: cs_incidents_all_b inc
4433: WHERE cil.subject_id = l_request_id
4434: and inc.incident_id = cil.object_id
4435: and cil.object_id > l_subject_id

Line 4443: FROM cs_incident_links cil,

4439: SELECT
4440: cil.object_id,
4441: cil.link_id,
4442: inc.incident_owner_id
4443: FROM cs_incident_links cil,
4444: cs_incidents_all_b inc
4445: WHERE cil.subject_id = l_request_id
4446: AND cil.link_type_id = l_relationship_type_id
4447: AND inc.incident_id = cil.object_id

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

4899: result OUT NOCOPY VARCHAR2 ) IS
4900:
4901: l_event_action VARCHAR2(50);
4902: l_actions_list VARCHAR2(4000);
4903: --l_link_id CS_INCIDENT_LINKS.LINK_ID%TYPE;
4904: --l_subject_id CS_INCIDENT_LINKS.SUBJECT_ID%TYPE;
4905: --l_link_type_code CS_INCIDENT_LINKS.LINK_TYPE_CODE%TYPE;
4906:
4907: l_update_conditions_list VARCHAR2(4000);

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

4900:
4901: l_event_action VARCHAR2(50);
4902: l_actions_list VARCHAR2(4000);
4903: --l_link_id CS_INCIDENT_LINKS.LINK_ID%TYPE;
4904: --l_subject_id CS_INCIDENT_LINKS.SUBJECT_ID%TYPE;
4905: --l_link_type_code CS_INCIDENT_LINKS.LINK_TYPE_CODE%TYPE;
4906:
4907: l_update_conditions_list VARCHAR2(4000);
4908: l_update_actions_list VARCHAR2(4000);

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

4901: l_event_action VARCHAR2(50);
4902: l_actions_list VARCHAR2(4000);
4903: --l_link_id CS_INCIDENT_LINKS.LINK_ID%TYPE;
4904: --l_subject_id CS_INCIDENT_LINKS.SUBJECT_ID%TYPE;
4905: --l_link_type_code CS_INCIDENT_LINKS.LINK_TYPE_CODE%TYPE;
4906:
4907: l_update_conditions_list VARCHAR2(4000);
4908: l_update_actions_list VARCHAR2(4000);
4909: l_event_condition_id CS_SR_ACTION_TRIGGERS.event_condition_id%TYPE;

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

5002: l_event_action VARCHAR2(50);
5003: l_actions_list VARCHAR2(4000);
5004: --l_link_id VARCHAR2(20);
5005:
5006: --l_subject_id CS_INCIDENT_LINKS.SUBJECT_ID%TYPE;
5007: l_subject_id VARCHAR2(30);
5008: --l_link_type_code CS_INCIDENT_LINKS.LINK_TYPE_CODE%TYPE;
5009: l_event_condition_id CS_SR_ACTION_TRIGGERS.event_condition_id%TYPE;
5010: l_action_code CS_SR_ACTION_DETAILS.action_code%TYPE;

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

5004: --l_link_id VARCHAR2(20);
5005:
5006: --l_subject_id CS_INCIDENT_LINKS.SUBJECT_ID%TYPE;
5007: l_subject_id VARCHAR2(30);
5008: --l_link_type_code CS_INCIDENT_LINKS.LINK_TYPE_CODE%TYPE;
5009: l_event_condition_id CS_SR_ACTION_TRIGGERS.event_condition_id%TYPE;
5010: l_action_code CS_SR_ACTION_DETAILS.action_code%TYPE;
5011:
5012: l_new_request_status VARCHAR2(30);

Line 5061: FROM cs_incident_links cil

5057: CURSOR sel_link_csr IS
5058: SELECT cil.link_type_id,
5059: cil.object_id,
5060: cil.link_id
5061: FROM cs_incident_links cil
5062: WHERE cil.subject_id = l_request_id
5063: AND cil.link_type_id = l_relationship_type_id
5064: ORDER BY cil.object_id;
5065:

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

5238: actid IN NUMBER,
5239: funmode IN VARCHAR2,
5240: result OUT NOCOPY VARCHAR2 ) IS
5241:
5242: --l_subject_id CS_INCIDENT_LINKS.SUBJECT_ID%TYPE;
5243: --l_subject_id VARCHAR2(30);
5244:
5245: l_linked_subject_list VARCHAR2(4000);
5246: l_element VARCHAR2(100);

Line 5319: l_subject_id CS_INCIDENT_LINKS.SUBJECT_ID%TYPE;

5315: actid IN NUMBER,
5316: funmode IN VARCHAR2,
5317: result OUT NOCOPY VARCHAR2 ) IS
5318:
5319: l_subject_id CS_INCIDENT_LINKS.SUBJECT_ID%TYPE;
5320: --l_link_type_code CS_INCIDENT_LINKS.LINK_TYPE_CODE%TYPE;
5321: l_subject_status_id CS_SR_ACTION_DETAILS.incident_status_id%TYPE;
5322: l_resolution_code CS_SR_ACTION_DETAILS.resolution_code%TYPE;
5323: l_close_flag VARCHAR2(1);

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

5316: funmode IN VARCHAR2,
5317: result OUT NOCOPY VARCHAR2 ) IS
5318:
5319: l_subject_id CS_INCIDENT_LINKS.SUBJECT_ID%TYPE;
5320: --l_link_type_code CS_INCIDENT_LINKS.LINK_TYPE_CODE%TYPE;
5321: l_subject_status_id CS_SR_ACTION_DETAILS.incident_status_id%TYPE;
5322: l_resolution_code CS_SR_ACTION_DETAILS.resolution_code%TYPE;
5323: l_close_flag VARCHAR2(1);
5324: l_link_id CS_INCIDENT_LINKS.LINK_ID%TYPE;

Line 5324: l_link_id CS_INCIDENT_LINKS.LINK_ID%TYPE;

5320: --l_link_type_code CS_INCIDENT_LINKS.LINK_TYPE_CODE%TYPE;
5321: l_subject_status_id CS_SR_ACTION_DETAILS.incident_status_id%TYPE;
5322: l_resolution_code CS_SR_ACTION_DETAILS.resolution_code%TYPE;
5323: l_close_flag VARCHAR2(1);
5324: l_link_id CS_INCIDENT_LINKS.LINK_ID%TYPE;
5325:
5326: l_action_code CS_SR_ACTION_DETAILS.action_code%TYPE;
5327: l_sr_updated NUMBER;
5328: l_incident_status_id NUMBER;

Line 5335: FROM cs_incident_links cil,

5331: --l_err_txt VARCHAR2(30);
5332:
5333: CURSOR sel_related_sr_cur(lv_incident_id IN NUMBER) IS
5334: SELECT cil.link_id
5335: FROM cs_incident_links cil,
5336: cs_incidents_all_b inc
5337: WHERE cil.subject_id = lv_incident_id
5338: -- Hard coded values for 'CAUSED BY' (2) and 'DUPLICATE OF' (3).
5339: AND cil.link_type_id = 2

Line 5506: l_subject_id CS_INCIDENT_LINKS.SUBJECT_ID%TYPE;

5502: result OUT NOCOPY VARCHAR2 ) IS
5503:
5504: l_request_number VARCHAR2(64);
5505: l_request_id NUMBER;
5506: l_subject_id CS_INCIDENT_LINKS.SUBJECT_ID%TYPE;
5507: l_subject_status_id CS_SR_ACTION_DETAILS.incident_status_id%TYPE;
5508: l_resolution_code CS_SR_ACTION_DETAILS.resolution_code%TYPE;
5509: l_service_request_rec CS_ServiceRequest_PVT.service_request_rec_type;
5510: l_object_version_number NUMBER;

Line 5747: l_subject_id CS_INCIDENT_LINKS.SUBJECT_ID%TYPE;

5743: result OUT NOCOPY VARCHAR2 ) IS
5744:
5745: l_request_number VARCHAR2(64);
5746: l_request_id NUMBER;
5747: l_subject_id CS_INCIDENT_LINKS.SUBJECT_ID%TYPE;
5748: l_subject_status_id CS_SR_ACTION_DETAILS.incident_status_id%TYPE;
5749: l_action_code CS_SR_ACTION_DETAILS.action_code%TYPE;
5750: l_subject_owner_id NUMBER;
5751:

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

5880: funmode IN VARCHAR2,
5881: result OUT NOCOPY VARCHAR2 ) IS
5882:
5883: l_linked_subject_list VARCHAR2(4000);
5884: --l_link_type_code CS_INCIDENT_LINKS.LINK_TYPE_CODE%TYPE;
5885: --l_event_condition_id CS_SR_ACTION_TRIGGERS.event_condition_id%TYPE;
5886: --l_action_code CS_SR_ACTION_DETAILS.action_code%TYPE;
5887: l_relationship_type_id CS_SR_ACTION_DETAILS.relationship_type_id%TYPE;
5888: l_relationship_type_name VARCHAR2(240);

Line 5900: FROM cs_incident_links cil,

5896: CURSOR sel_link_csr IS
5897: SELECT cil.link_type_id,
5898: cil.object_id,
5899: cil.link_id
5900: FROM cs_incident_links cil,
5901: CS_SR_LINK_TYPES_VL cilt
5902: WHERE cil.subject_id = l_request_id
5903: AND cil.link_type_id = cilt.link_type_id
5904: AND cilt.name = l_relationship_type_name

Line 6066: FROM cs_incident_links cil

6062: and (csad.incident_status_id IS NOT NULL OR
6063: csad.resolution_code IS NOT NULL)
6064: and csat.relationship_type_id IN
6065: ( select cil.link_type_id
6066: FROM cs_incident_links cil
6067: WHERE cil.subject_id = l_request_id)
6068: AND TO_CHAR(csad.event_condition_id) || csad.action_code >
6069: TO_CHAR(l_event_condition_id) || l_action_code
6070: UNION

Line 6091: FROM cs_incident_links cil

6087: and csat.incident_status_id IS NOT NULL
6088: and csad.action_code NOT like 'NOTIFY%'
6089: and csad.relationship_type_id IN
6090: ( select cil.link_type_id
6091: FROM cs_incident_links cil
6092: WHERE cil.subject_id = l_request_id)
6093: AND TO_CHAR(csad.event_condition_id) || csad.action_code >
6094: TO_CHAR(l_event_condition_id) || l_action_code
6095: ORDER BY index_cols;