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.CSM_NOTIFICATION_EVENT_PKG dependencies on WF_EVENT_T

Line 273: FUNCTION NOTIFICATION_ATTR_WF_EVENT_SUB(p_subscription_guid IN RAW, p_event IN OUT NOCOPY WF_EVENT_T)

269:
270:
271: --Bug 5337816
272: -- subscription to the NOTIFICATION_ATTR_INS_RECEIVE WF event
273: FUNCTION NOTIFICATION_ATTR_WF_EVENT_SUB(p_subscription_guid IN RAW, p_event IN OUT NOCOPY WF_EVENT_T)
274: RETURN VARCHAR2
275: IS
276: l_sqlerrno VARCHAR2(20);
277: l_sqlerrmsg VARCHAR2(4000);

Line 310: FUNCTION NOTIFICATION_DEL_WF_EVENT_SUB(p_subscription_guid IN RAW, p_event IN OUT NOCOPY WF_EVENT_T)

306: RETURN 'ERROR';
307: END NOTIFICATION_ATTR_WF_EVENT_SUB;
308:
309: --Bug 5337816
310: FUNCTION NOTIFICATION_DEL_WF_EVENT_SUB(p_subscription_guid IN RAW, p_event IN OUT NOCOPY WF_EVENT_T)
311: RETURN VARCHAR2
312: IS
313: l_sqlerrno VARCHAR2(20);
314: l_sqlerrmsg VARCHAR2(4000);

Line 568: FUNCTION invoke_WF_NotifyProcess (p_recipient_role IN VARCHAR2, p_wf_param IN wf_event_t) return NUMBER

564:
565: END get_Mailer_EmailId;
566:
567: --Bug 9435049
568: FUNCTION invoke_WF_NotifyProcess (p_recipient_role IN VARCHAR2, p_wf_param IN wf_event_t) return NUMBER
569: IS
570:
571: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
572: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';

Line 908: l_wf_param wf_event_t;

904: FUNCTION send_email(b_user_name IN VARCHAR2, subject VARCHAR2, message_body VARCHAR2) return NUMBER
905: IS
906: role_name VARCHAR2(30);
907: l_err_msg VARCHAR2(2000);
908: l_wf_param wf_event_t;
909: BEGIN
910:
911: IF CSM_UTIL_PKG.is_new_mmu_user(b_user_name) THEN
912: CSM_UTIL_PKG.LOG(b_user_name||' is a new or not a mobile user, so skip sending notification.','CSM_NOTIFICATION_EVENT_PKG.SEND_EMAIL',FND_LOG.LEVEL_PROCEDURE);

Line 922: wf_event_t.initialize(l_wf_param);

918: ELSE
919: role_name := 'CSM_'||b_user_name||'_ROLE';
920: END IF;
921:
922: wf_event_t.initialize(l_wf_param);
923: l_wf_param.AddParameterToList('TEMPLATE','DOWNLOAD_INIT_MSG');
924: l_wf_param.AddParameterToList('SUBJECT',subject);
925: l_wf_param.AddParameterToList('MESSAGE_BODY',message_body);
926:

Line 959: l_wf_param wf_event_t;

955: END;
956:
957: PROCEDURE NOTIFY_USER(entity varchar2, pk_value varchar2,p_mode varchar2)
958: IS
959: l_wf_param wf_event_t;
960: BEGIN
961: wf_event_t.initialize(l_wf_param);
962: l_wf_param.AddParameterToList('ENTITY',entity);
963: l_wf_param.AddParameterToList('PK_VALUE',pk_value);

Line 961: wf_event_t.initialize(l_wf_param);

957: PROCEDURE NOTIFY_USER(entity varchar2, pk_value varchar2,p_mode varchar2)
958: IS
959: l_wf_param wf_event_t;
960: BEGIN
961: wf_event_t.initialize(l_wf_param);
962: l_wf_param.AddParameterToList('ENTITY',entity);
963: l_wf_param.AddParameterToList('PK_VALUE',pk_value);
964: l_wf_param.AddParameterToList('MODE',p_mode);
965: csm_notification_event_pkg.notify_user(l_wf_param);

Line 1081: PROCEDURE NOTIFY_USER(p_wf_param wf_event_t)

1077: WHEN OTHERS THEN
1078: RETURN FALSE;
1079: END is_personal_task;
1080:
1081: PROCEDURE NOTIFY_USER(p_wf_param wf_event_t)
1082: IS
1083:
1084: CURSOR c_user_task_assigned(b_task_ass_id NUMBER)
1085: IS

Line 1278: l_wftimer wf_event_t;

1274: l_uname_tab l_name_type;
1275: l_not_tab l_tab_type;
1276: l_usr_tab l_tab_type;
1277: l_cnt NUMBER :=0;
1278: l_wftimer wf_event_t;
1279: l_timeout NUMBER;
1280: l_resp_id NUMBER;
1281: l_app_id NUMBER;
1282: BEGIN

Line 1553: wf_event_t.initialize(l_wftimer);

1549: l_timeout := to_number(fnd_profile.value_specific('CSM_ALERT_TIMEOUT_1',l_usr_tab(I),l_resp_id,l_app_id));
1550:
1551: IF l_timeout > 0 THEN
1552: --timer logic - Fixed 3 tries + 1 original email
1553: wf_event_t.initialize(l_wftimer);
1554: l_wftimer.AddParameterToList('NOTIFICATION_ID',to_char(l_not_tab(I)));
1555: l_wftimer.AddParameterToList('SENT_TO','CSM_'||l_uname_tab(I)||'_ROLE');
1556: l_wftimer.AddParameterToList('TRIES','1');
1557:

Line 1616: FUNCTION NOTIFICATION_TIMER_SUB(p_subscription_guid IN RAW, p_event IN OUT NOCOPY WF_EVENT_T)

1612:
1613:
1614:
1615: --Subscription to event "oracle.apps.csm.download.timer"
1616: FUNCTION NOTIFICATION_TIMER_SUB(p_subscription_guid IN RAW, p_event IN OUT NOCOPY WF_EVENT_T)
1617: RETURN VARCHAR2
1618: IS
1619: l_nid NUMBER;
1620: l_try NUMBER;

Line 1621: l_wftimer wf_event_t;

1617: RETURN VARCHAR2
1618: IS
1619: l_nid NUMBER;
1620: l_try NUMBER;
1621: l_wftimer wf_event_t;
1622: CURSOR c_response(b_nid NUMBER) IS
1623: SELECT 1
1624: FROM WF_NOTIFICATIONS
1625: WHERE NOTIFICATION_ID=b_nid

Line 1688: wf_event_t.initialize(l_wftimer);

1684: WHERE NOTIFICATION_ID=l_nid;
1685:
1686: l_try := l_try + 1;
1687:
1688: wf_event_t.initialize(l_wftimer);
1689: l_wftimer.AddParameterToList('NOTIFICATION_ID',to_char(l_nid));
1690: l_wftimer.AddParameterToList('TRIES',l_try);
1691: l_wftimer.AddParameterToList('SENT_TO',l_role);
1692: wf_event.raise(p_event_name=>'oracle.apps.csm.download.timer',

Line 1700: wf_event_t.initialize(l_wftimer);

1696:
1697: CSM_UTIL_PKG.LOG('Email Id '||l_nid||' is not answered by '||substr(l_role,5,length(l_role)-9),
1698: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFICATION_TIMER_SUB',FND_LOG.LEVEL_PROCEDURE);
1699:
1700: wf_event_t.initialize(l_wftimer);
1701: l_wftimer.AddParameterToList('NOTIFICATION_ID',to_char(l_nid));
1702: l_wftimer.AddParameterToList('RECIPIENT',substr(l_role,5,length(l_role)-9));
1703: wf_event.raise(p_event_name=>'oracle.apps.csm.download.noResponse',
1704: p_event_key=>to_char(l_nid),p_parameters=>l_wftimer.getParameterList,

Line 1800: l_wf_param wf_event_t;

1796: l_notification_id NUMBER;
1797:
1798: l_sql_err_msg VARCHAR2(2000);
1799: l_sql_code NUMBER;
1800: l_wf_param wf_event_t;
1801: BEGIN
1802:
1803: OPEN c_get_deferred_data(p_tracking_id);
1804: FETCH c_get_deferred_data INTO l_tran_id,l_seq, l_client_id,l_dev_type,l_disp_name,

Line 1829: wf_event_t.initialize(l_wf_param);

1825: END IF;
1826:
1827: l_user_list := asg_download.get_listfrom_string(upper(l_user_string));
1828:
1829: wf_event_t.initialize(l_wf_param);
1830: l_wf_param.AddParameterToList('TEMPLATE','DEFERRED_ERROR_REPORT');
1831:
1832: l_wf_param.AddParameterToList( 'USER_NAME', l_client_id);
1833: l_wf_param.AddParameterToList( 'TRAN_ID', to_char(l_tran_id));

Line 1963: l_wftimer wf_event_t;

1959: SELECT APP_ID,RESPONSIBILITY_ID
1960: FROM ASG_USER
1961: WHERE USER_NAME=b_user_name;
1962:
1963: l_wftimer wf_event_t;
1964: l_timeout NUMBER;
1965: l_resp_id NUMBER;
1966: l_app_id NUMBER;
1967:

Line 2099: wf_event_t.initialize(l_wftimer);

2095: l_timeout := to_number(fnd_profile.value_specific('CSM_ALERT_TIMEOUT_1',asg_base.get_user_id(p_user_name),l_resp_id,l_app_id));
2096:
2097: IF l_timeout > 0 THEN
2098: --timer logic - Fixed 3 tries + 1 original email
2099: wf_event_t.initialize(l_wftimer);
2100: l_wftimer.AddParameterToList('NOTIFICATION_ID',to_char(l_notification_id));
2101: l_wftimer.AddParameterToList('SENT_TO','CSM_'||p_user_name||'_ROLE');
2102: l_wftimer.AddParameterToList('TRIES','1');
2103:

Line 2181: FUNCTION EMAIL_SYNC_ERROR_ADMIN_SUB(p_subscription_guid IN RAW, p_event IN OUT NOCOPY WF_EVENT_T)

2177:
2178: END PURGE_USER;
2179:
2180: --Subscription to event "oracle.apps.asg.sync.failure"
2181: FUNCTION EMAIL_SYNC_ERROR_ADMIN_SUB(p_subscription_guid IN RAW, p_event IN OUT NOCOPY WF_EVENT_T)
2182: RETURN VARCHAR2
2183: IS
2184:
2185: l_session_id NUMBER;

Line 2207: l_wf_param wf_event_t;

2203:
2204: l_sql VARCHAR2(1000);
2205: l_sql_err_msg VARCHAR2(2000);
2206: l_sql_code NUMBER;
2207: l_wf_param wf_event_t;
2208: BEGIN
2209:
2210: l_session_id := to_number(p_event.GetValueForParameter('SESSION_ID'));
2211: l_tran_id := to_number(p_event.GetValueForParameter('TRAN_ID'));

Line 2253: wf_event_t.initialize(l_wf_param);

2249: END;
2250:
2251: l_user_list := asg_download.get_listfrom_string(upper(l_user_string));
2252:
2253: wf_event_t.initialize(l_wf_param);
2254: l_wf_param.AddParameterToList('TEMPLATE','SYNC_ERROR_REPORT');
2255:
2256: l_wf_param.AddParameterToList('SESSION_ID', l_session_id);
2257: l_wf_param.AddParameterToList('TRAN_ID', l_tran_id);

Line 2333: l_wf_param wf_event_t;

2329:
2330: type t_curs is ref cursor;
2331: cur t_curs;
2332:
2333: l_wf_param wf_event_t;
2334: BEGIN
2335:
2336: SELECT NVL(LAST_RUN_DATE,TO_DATE(1,'J')) INTO l_last_run_date
2337: FROM jtm_con_request_data

Line 2406: wf_event_t.initialize(l_wf_param);

2402: l_user_list := asg_download.get_listfrom_string(upper(l_user_string));
2403:
2404: END IF;
2405:
2406: wf_event_t.initialize(l_wf_param);
2407: l_wf_param.AddParameterToList('TEMPLATE','SYNC_ERROR_REPORT');
2408:
2409: l_wf_param.AddParameterToList('SESSION_ID', to_char(l_session_id));
2410: l_wf_param.AddParameterToList('USER_NAME', l_client_id);