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

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

Line 1612: FROM cs_sr_action_details

1608: -- Cursor to check if the HTML notification is required.
1609:
1610: CURSOR c_check_html_notification IS
1611: SELECT NVL(html_notification,'N')
1612: FROM cs_sr_action_details
1613: WHERE event_condition_id = l_event_condition_id
1614: AND action_code = l_action_code ;
1615:
1616:

Line 4334: l_action_code CS_SR_ACTION_DETAILS.action_code%TYPE;

4330: actid IN NUMBER,
4331: funmode IN VARCHAR2,
4332: result OUT NOCOPY VARCHAR2 ) IS
4333:
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;

Line 4337: l_relationship_type_id CS_SR_ACTION_DETAILS.relationship_type_id%TYPE;

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

Line 4353: FROM CS_SR_ACTION_DETAILS csad

4349: SELECT csad.event_condition_id,
4350: csad.action_code,
4351: csad.notification_template_id, /** this is the WF message name **/
4352: csad.relationship_type_id detail_link_type
4353: FROM CS_SR_ACTION_DETAILS csad
4354: WHERE csad.event_condition_id = l_event_condition_id
4355: and csad.action_code = l_action_code
4356: and TRUNC(SYSDATE) BETWEEN TRUNC(NVL(csad.start_date_active, SYSDATE))
4357: and TRUNC(NVL(csad.end_date_active, SYSDATE))

Line 4672: l_action_code CS_SR_ACTION_DETAILS.action_code%TYPE;

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);
4674: l_notify_actions_list VARCHAR2(4000);
4675: l_overflow_flag VARCHAR2(1);
4676:

Line 4683: CS_SR_ACTION_DETAILS csad,

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

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

Line 4948: l_action_code CS_SR_ACTION_DETAILS.action_code%TYPE;

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

Line 4955: l_relationship_type_id CS_SR_ACTION_DETAILS.relationship_type_id%TYPE;

4951: l_old_request_status VARCHAR2(30);
4952: l_request_status VARCHAR2(30);
4953: l_request_status_temp VARCHAR2(30);
4954: l_request_number VARCHAR2(64);
4955: l_relationship_type_id CS_SR_ACTION_DETAILS.relationship_type_id%TYPE;
4956: l_relationship_type_name VARCHAR2(240);
4957: l_linked_subject_list VARCHAR2(4000);
4958:
4959: l_request_id NUMBER;

Line 4977: CS_SR_ACTION_DETAILS csad

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

Line 5257: l_subject_status_id CS_SR_ACTION_DETAILS.incident_status_id%TYPE;

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

Line 5258: l_resolution_code CS_SR_ACTION_DETAILS.resolution_code%TYPE;

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

Line 5262: l_action_code CS_SR_ACTION_DETAILS.action_code%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;
5265: l_UNHANDLED_ACTION EXCEPTION;
5266:

Line 5443: l_subject_status_id CS_SR_ACTION_DETAILS.incident_status_id%TYPE;

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

Line 5444: l_resolution_code CS_SR_ACTION_DETAILS.resolution_code%TYPE;

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

Line 5447: l_action_code CS_SR_ACTION_DETAILS.action_code%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;
5447: l_action_code CS_SR_ACTION_DETAILS.action_code%TYPE;
5448:
5449: --l_request_id NUMBER;
5450: l_subject_owner_id NUMBER;
5451: l_close_flag VARCHAR2(1);

Line 5684: l_subject_status_id CS_SR_ACTION_DETAILS.incident_status_id%TYPE;

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

Line 5685: l_action_code CS_SR_ACTION_DETAILS.action_code%TYPE;

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

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

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

Line 5823: l_relationship_type_id CS_SR_ACTION_DETAILS.relationship_type_id%TYPE;

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

Line 5976: l_action_code CS_SR_ACTION_DETAILS.action_code%TYPE;

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);
5979: l_request_id NUMBER;
5980:

Line 5986: CS_SR_ACTION_DETAILS csad,

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

Line 6011: CS_SR_ACTION_DETAILS csad,

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