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 4338: l_event_condition_id CS_SR_ACTION_TRIGGERS.event_condition_id%TYPE;

4334: l_action_code CS_SR_ACTION_DETAILS.action_code%TYPE;
4335: l_linked_subject_list VARCHAR2(4000);
4336: l_overflow_flag VARCHAR2(1);
4337: l_relationship_type_id CS_SR_ACTION_DETAILS.relationship_type_id%TYPE;
4338: l_event_condition_id CS_SR_ACTION_TRIGGERS.event_condition_id%TYPE;
4339: l_char_subject_id VARCHAR2(30);
4340: l_subject_id NUMBER;
4341: l_request_number VARCHAR2(64);
4342: l_request_id NUMBER;

Line 4669: l_event_condition_id CS_SR_ACTION_TRIGGERS.event_condition_id%TYPE;

4665: funmode IN VARCHAR2,
4666: result OUT NOCOPY VARCHAR2 ) IS
4667:
4668: l_event_name VARCHAR2(240);
4669: l_event_condition_id CS_SR_ACTION_TRIGGERS.event_condition_id%TYPE;
4670: l_char_event_condition_id VARCHAR2(30);
4671:
4672: l_action_code CS_SR_ACTION_DETAILS.action_code%TYPE;
4673: l_notify_conditions_list VARCHAR2(4000);

Line 4682: FROM CS_SR_ACTION_TRIGGERS csat,

4678: CURSOR sel_action_csr IS
4679: SELECT csad.event_condition_id,
4680: csad.action_code,
4681: csad.notification_template_id
4682: FROM CS_SR_ACTION_TRIGGERS csat,
4683: CS_SR_ACTION_DETAILS csad,
4684: CS_SR_EVENT_CODES_B cec
4685: WHERE
4686: cec.WF_BUSINESS_EVENT_ID = l_event_name

Line 4847: l_event_condition_id CS_SR_ACTION_TRIGGERS.event_condition_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;
4848: l_action_code CS_SR_ACTION_DETAILS.action_code%TYPE;
4849:
4850: l_space_pos NUMBER;
4851: l_element VARCHAR2(100);

Line 4947: l_event_condition_id CS_SR_ACTION_TRIGGERS.event_condition_id%TYPE;

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

Line 4976: CS_SR_ACTION_TRIGGERS csat,

4972: csad.relationship_type_id detail_link_type,
4973: csad.incident_status_id detail_incident_status_id,
4974: csad.resolution_code
4975: FROM CS_SR_EVENT_CODES_B cec,
4976: CS_SR_ACTION_TRIGGERS csat,
4977: CS_SR_ACTION_DETAILS csad
4978: WHERE
4979: cec.WF_BUSINESS_EVENT_ID = l_event_name
4980: and cec.EVENT_CODE = csat.EVENT_CODE

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

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

Line 5974: l_event_condition_id CS_SR_ACTION_TRIGGERS.event_condition_id%TYPE;

5970: l_update_actions_list VARCHAR2(4000);
5971: l_event_name VARCHAR2(240);
5972: --l_action_code VARCHAR2(30);
5973: l_request_number VARCHAR2(64);
5974: l_event_condition_id CS_SR_ACTION_TRIGGERS.event_condition_id%TYPE;
5975: l_char_event_condition_id VARCHAR2(30);
5976: l_action_code CS_SR_ACTION_DETAILS.action_code%TYPE;
5977:
5978: l_overflow_flag VARCHAR2(1);

Line 5985: FROM CS_SR_ACTION_TRIGGERS csat,

5981: CURSOR sel_action_csr IS
5982: SELECT csad.event_condition_id,
5983: csad.action_code,
5984: to_char(csad.event_condition_id) || csad.action_code index_cols
5985: FROM CS_SR_ACTION_TRIGGERS csat,
5986: CS_SR_ACTION_DETAILS csad,
5987: CS_SR_EVENT_CODES_B cec
5988: WHERE
5989: cec.WF_BUSINESS_EVENT_ID = l_event_name

Line 6010: FROM CS_SR_ACTION_TRIGGERS csat,

6006: UNION
6007: SELECT csad.event_condition_id,
6008: csad.action_code,
6009: to_char(csad.event_condition_id) || csad.action_code index_cols
6010: FROM CS_SR_ACTION_TRIGGERS csat,
6011: CS_SR_ACTION_DETAILS csad,
6012: CS_SR_EVENT_CODES_B cec
6013: WHERE
6014: cec.WF_BUSINESS_EVENT_ID = l_event_name