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_SR_ACTION_DETAILS

Line 101: l_action_code CS_SR_ACTION_DETAILS.action_code%TYPE;

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);
104: l_update_conditions_list VARCHAR2(4000);
105: l_update_actions_list VARCHAR2(4000);

Line 122: CS_SR_ACTION_DETAILS csad,

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
126: and csat.EVENT_CODE = cec.EVENT_CODE

Line 150: CS_SR_ACTION_DETAILS csad,

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
154: and csat.EVENT_CODE = cec.EVENT_CODE

Line 188: CS_SR_ACTION_DETAILS csad,

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
192: in a cartesian join

Line 492: l_action_code CS_SR_ACTION_DETAILS.action_code%TYPE;

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:
496: BEGIN

Line 588: l_action_code CS_SR_ACTION_DETAILS.action_code%TYPE;

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);
592: l_recipient_role_list VARCHAR2(4000);

Line 603: l_relationship_type_id CS_SR_ACTION_DETAILS.relationship_type_id%TYPE;

599: l_msg_data VARCHAR2(2000);
600: l_owner_role VARCHAR2(320);
601: l_owner_name VARCHAR2(240);
602: l_char_subject_id VARCHAR2(30);
603: l_relationship_type_id CS_SR_ACTION_DETAILS.relationship_type_id%TYPE;
604:
605: l_trigger_link_type VARCHAR2(240);
606: l_trigger_link_type_id NUMBER;
607:

Line 624: CS_SR_ACTION_DETAILS csad,

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
628: and csat.EVENT_CODE = cec.EVENT_CODE

Line 1067: l_action_code CS_SR_ACTION_DETAILS.action_code%TYPE;

1063: funmode IN VARCHAR2,
1064: result OUT NOCOPY VARCHAR2 ) IS
1065:
1066: l_request_number VARCHAR2(64);
1067: l_action_code CS_SR_ACTION_DETAILS.action_code%TYPE;
1068: l_notify_recipient VARCHAR2(100);
1069: l_notification_template_id VARCHAR2(30);
1070: l_linked_subject_list VARCHAR2(4000);
1071: l_element VARCHAR2(100);

Line 1674: FROM cs_sr_action_details

1670: -- Cursor to check if the HTML notification is required.
1671:
1672: CURSOR c_check_html_notification IS
1673: SELECT NVL(html_notification,'N')
1674: FROM cs_sr_action_details
1675: WHERE event_condition_id = l_event_condition_id
1676: AND action_code = l_action_code ;
1677:
1678:

Line 4396: l_action_code CS_SR_ACTION_DETAILS.action_code%TYPE;

4392: actid IN NUMBER,
4393: funmode IN VARCHAR2,
4394: result OUT NOCOPY VARCHAR2 ) IS
4395:
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;

Line 4399: l_relationship_type_id CS_SR_ACTION_DETAILS.relationship_type_id%TYPE;

4395:
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);

Line 4415: FROM CS_SR_ACTION_DETAILS csad

4411: SELECT csad.event_condition_id,
4412: csad.action_code,
4413: csad.notification_template_id, /** this is the WF message name **/
4414: csad.relationship_type_id detail_link_type
4415: FROM CS_SR_ACTION_DETAILS csad
4416: WHERE csad.event_condition_id = l_event_condition_id
4417: and csad.action_code = l_action_code
4418: and TRUNC(SYSDATE) BETWEEN TRUNC(NVL(csad.start_date_active, SYSDATE))
4419: and TRUNC(NVL(csad.end_date_active, SYSDATE))

Line 4734: l_action_code CS_SR_ACTION_DETAILS.action_code%TYPE;

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);
4736: l_notify_actions_list VARCHAR2(4000);
4737: l_overflow_flag VARCHAR2(1);
4738:

Line 4745: CS_SR_ACTION_DETAILS csad,

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
4749: and csat.EVENT_CODE = cec.EVENT_CODE

Line 4910: l_action_code CS_SR_ACTION_DETAILS.action_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);
4914:

Line 5010: l_action_code CS_SR_ACTION_DETAILS.action_code%TYPE;

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);
5014: l_request_status VARCHAR2(30);

Line 5017: l_relationship_type_id CS_SR_ACTION_DETAILS.relationship_type_id%TYPE;

5013: l_old_request_status VARCHAR2(30);
5014: l_request_status VARCHAR2(30);
5015: l_request_status_temp VARCHAR2(30);
5016: l_request_number VARCHAR2(64);
5017: l_relationship_type_id CS_SR_ACTION_DETAILS.relationship_type_id%TYPE;
5018: l_relationship_type_name VARCHAR2(240);
5019: l_linked_subject_list VARCHAR2(4000);
5020:
5021: l_request_id NUMBER;

Line 5039: CS_SR_ACTION_DETAILS csad

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
5043: and TRUNC(SYSDATE) BETWEEN TRUNC(NVL(csat.start_date_active, SYSDATE))

Line 5321: l_subject_status_id CS_SR_ACTION_DETAILS.incident_status_id%TYPE;

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;
5325:

Line 5322: l_resolution_code CS_SR_ACTION_DETAILS.resolution_code%TYPE;

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;
5325:
5326: l_action_code CS_SR_ACTION_DETAILS.action_code%TYPE;

Line 5326: l_action_code CS_SR_ACTION_DETAILS.action_code%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;
5329: l_UNHANDLED_ACTION EXCEPTION;
5330:

Line 5507: l_subject_status_id CS_SR_ACTION_DETAILS.incident_status_id%TYPE;

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;
5511: l_action_code CS_SR_ACTION_DETAILS.action_code%TYPE;

Line 5508: l_resolution_code CS_SR_ACTION_DETAILS.resolution_code%TYPE;

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;
5511: l_action_code CS_SR_ACTION_DETAILS.action_code%TYPE;
5512:

Line 5511: l_action_code CS_SR_ACTION_DETAILS.action_code%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;
5511: l_action_code CS_SR_ACTION_DETAILS.action_code%TYPE;
5512:
5513: --l_request_id NUMBER;
5514: l_subject_owner_id NUMBER;
5515: l_close_flag VARCHAR2(1);

Line 5748: l_subject_status_id CS_SR_ACTION_DETAILS.incident_status_id%TYPE;

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:
5752: l_return_status VARCHAR2(1);

Line 5749: l_action_code CS_SR_ACTION_DETAILS.action_code%TYPE;

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:
5752: l_return_status VARCHAR2(1);
5753: l_msg_count NUMBER;

Line 5886: --l_action_code CS_SR_ACTION_DETAILS.action_code%TYPE;

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;
5890: l_char_subject_id VARCHAR2(30);

Line 5887: l_relationship_type_id CS_SR_ACTION_DETAILS.relationship_type_id%TYPE;

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;
5890: l_char_subject_id VARCHAR2(30);
5891: l_request_number VARCHAR2(64);

Line 6040: l_action_code CS_SR_ACTION_DETAILS.action_code%TYPE;

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);
6043: l_request_id NUMBER;
6044:

Line 6050: CS_SR_ACTION_DETAILS csad,

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
6054: and csat.EVENT_CODE = cec.EVENT_CODE

Line 6075: CS_SR_ACTION_DETAILS csad,

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
6079: and csat.EVENT_CODE = cec.EVENT_CODE