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.

[Home] [Help]

APPS.CS_WF_AUTO_NTFY_UPDATE_PKG dependencies on CS_SR_ACTION_TRIGGERS

Line 99: --l_event_condition_id CS_SR_ACTION_TRIGGERS.event_condition_id%TYPE;

95: l_event_name VARCHAR2(240);
96: --l_action_code VARCHAR2(30);
97: l_request_number VARCHAR2(64);
98: l_request_id NUMBER;
99: --l_event_condition_id CS_SR_ACTION_TRIGGERS.event_condition_id%TYPE;
100: l_event_condition_id VARCHAR2(30);
101: l_action_code CS_SR_ACTION_DETAILS.action_code%TYPE;
102: l_notify_conditions_list VARCHAR2(4000);
103: l_notify_actions_list VARCHAR2(4000);

Line 121: FROM CS_SR_ACTION_TRIGGERS csat,

117: to_char(null) notification_template_id,
118: to_char(csad.event_condition_id) || csad.action_code index_cols,
119: to_char(null) role_group_type,
120: to_char(null) role_group_code
121: FROM CS_SR_ACTION_TRIGGERS csat,
122: CS_SR_ACTION_DETAILS csad,
123: CS_SR_EVENT_CODES_B cec
124: WHERE
125: cec.WF_BUSINESS_EVENT_ID = l_event_name

Line 149: FROM CS_SR_ACTION_TRIGGERS csat,

145: to_char(null) notification_template_id,
146: to_char(csad.event_condition_id) || csad.action_code index_cols,
147: to_char(null) role_group_type,
148: to_char(null) role_group_code
149: FROM CS_SR_ACTION_TRIGGERS csat,
150: CS_SR_ACTION_DETAILS csad,
151: CS_SR_EVENT_CODES_B cec
152: WHERE
153: cec.WF_BUSINESS_EVENT_ID = l_event_name

Line 187: FROM CS_SR_ACTION_TRIGGERS csat,

183: csad.notification_template_id,
184: to_char(csad.event_condition_id) || csad.action_code index_cols,
185: role_group_type,
186: role_group_code
187: FROM CS_SR_ACTION_TRIGGERS csat,
188: CS_SR_ACTION_DETAILS csad,
189: CS_SR_EVENT_CODES_B cec
190: /* 03/01/2004 - RHUNGUND - Bug fix for 3412833
191: Commenting the following table from the FROM clause since it was resulting

Line 491: l_event_condition_id CS_SR_ACTION_TRIGGERS.event_condition_id%TYPE;

487: result OUT NOCOPY VARCHAR2 ) IS
488:
489: l_notify_conditions_list VARCHAR2(4000);
490: l_notify_actions_list VARCHAR2(4000);
491: l_event_condition_id CS_SR_ACTION_TRIGGERS.event_condition_id%TYPE;
492: l_action_code CS_SR_ACTION_DETAILS.action_code%TYPE;
493: l_element VARCHAR2(100);
494:
495:

Line 587: l_event_condition_id CS_SR_ACTION_TRIGGERS.event_condition_id%TYPE;

583:
584: l_request_number VARCHAR2(64);
585: l_request_id NUMBER;
586: l_event_name VARCHAR2(240);
587: l_event_condition_id CS_SR_ACTION_TRIGGERS.event_condition_id%TYPE;
588: l_action_code CS_SR_ACTION_DETAILS.action_code%TYPE;
589: l_notify_recipient VARCHAR2(100);
590: l_request_status VARCHAR2(30);
591: l_request_status_temp VARCHAR2(30);

Line 623: FROM CS_SR_ACTION_TRIGGERS csat,

619: csad.role_group_code,
620: csat.from_to_status_code,
621: csat.incident_status_id trigger_incident_status_id,
622: csat.relationship_type_id trigger_link_type
623: FROM CS_SR_ACTION_TRIGGERS csat,
624: CS_SR_ACTION_DETAILS csad,
625: CS_SR_EVENT_CODES_B cec
626: WHERE
627: cec.WF_BUSINESS_EVENT_ID = l_event_name

Line 4400: l_event_condition_id CS_SR_ACTION_TRIGGERS.event_condition_id%TYPE;

4396: l_action_code CS_SR_ACTION_DETAILS.action_code%TYPE;
4397: l_linked_subject_list VARCHAR2(4000);
4398: l_overflow_flag VARCHAR2(1);
4399: l_relationship_type_id CS_SR_ACTION_DETAILS.relationship_type_id%TYPE;
4400: l_event_condition_id CS_SR_ACTION_TRIGGERS.event_condition_id%TYPE;
4401: l_char_subject_id VARCHAR2(30);
4402: l_subject_id NUMBER;
4403: l_request_number VARCHAR2(64);
4404: l_request_id NUMBER;

Line 4731: l_event_condition_id CS_SR_ACTION_TRIGGERS.event_condition_id%TYPE;

4727: funmode IN VARCHAR2,
4728: result OUT NOCOPY VARCHAR2 ) IS
4729:
4730: l_event_name VARCHAR2(240);
4731: l_event_condition_id CS_SR_ACTION_TRIGGERS.event_condition_id%TYPE;
4732: l_char_event_condition_id VARCHAR2(30);
4733:
4734: l_action_code CS_SR_ACTION_DETAILS.action_code%TYPE;
4735: l_notify_conditions_list VARCHAR2(4000);

Line 4744: FROM CS_SR_ACTION_TRIGGERS csat,

4740: CURSOR sel_action_csr IS
4741: SELECT csad.event_condition_id,
4742: csad.action_code,
4743: csad.notification_template_id
4744: FROM CS_SR_ACTION_TRIGGERS csat,
4745: CS_SR_ACTION_DETAILS csad,
4746: CS_SR_EVENT_CODES_B cec
4747: WHERE
4748: cec.WF_BUSINESS_EVENT_ID = l_event_name

Line 4909: l_event_condition_id CS_SR_ACTION_TRIGGERS.event_condition_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;
4910: l_action_code CS_SR_ACTION_DETAILS.action_code%TYPE;
4911:
4912: l_space_pos NUMBER;
4913: l_element VARCHAR2(100);

Line 5009: l_event_condition_id CS_SR_ACTION_TRIGGERS.event_condition_id%TYPE;

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);
5013: l_old_request_status VARCHAR2(30);

Line 5038: CS_SR_ACTION_TRIGGERS csat,

5034: csad.relationship_type_id detail_link_type,
5035: csad.incident_status_id detail_incident_status_id,
5036: csad.resolution_code
5037: FROM CS_SR_EVENT_CODES_B cec,
5038: CS_SR_ACTION_TRIGGERS csat,
5039: CS_SR_ACTION_DETAILS csad
5040: WHERE
5041: cec.WF_BUSINESS_EVENT_ID = l_event_name
5042: and cec.EVENT_CODE = csat.EVENT_CODE

Line 5885: --l_event_condition_id CS_SR_ACTION_TRIGGERS.event_condition_id%TYPE;

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);
5889: l_subject_id NUMBER;

Line 6038: l_event_condition_id CS_SR_ACTION_TRIGGERS.event_condition_id%TYPE;

6034: l_update_actions_list VARCHAR2(4000);
6035: l_event_name VARCHAR2(240);
6036: --l_action_code VARCHAR2(30);
6037: l_request_number VARCHAR2(64);
6038: l_event_condition_id CS_SR_ACTION_TRIGGERS.event_condition_id%TYPE;
6039: l_char_event_condition_id VARCHAR2(30);
6040: l_action_code CS_SR_ACTION_DETAILS.action_code%TYPE;
6041:
6042: l_overflow_flag VARCHAR2(1);

Line 6049: FROM CS_SR_ACTION_TRIGGERS csat,

6045: CURSOR sel_action_csr IS
6046: SELECT csad.event_condition_id,
6047: csad.action_code,
6048: to_char(csad.event_condition_id) || csad.action_code index_cols
6049: FROM CS_SR_ACTION_TRIGGERS csat,
6050: CS_SR_ACTION_DETAILS csad,
6051: CS_SR_EVENT_CODES_B cec
6052: WHERE
6053: cec.WF_BUSINESS_EVENT_ID = l_event_name

Line 6074: FROM CS_SR_ACTION_TRIGGERS csat,

6070: UNION
6071: SELECT csad.event_condition_id,
6072: csad.action_code,
6073: to_char(csad.event_condition_id) || csad.action_code index_cols
6074: FROM CS_SR_ACTION_TRIGGERS csat,
6075: CS_SR_ACTION_DETAILS csad,
6076: CS_SR_EVENT_CODES_B cec
6077: WHERE
6078: cec.WF_BUSINESS_EVENT_ID = l_event_name