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.WF_NOTIFICATION dependencies on WF_LOCAL_ROLES

Line 306: role_info_tbl wf_directory.wf_local_roles_tbl_type;

302: i pls_integer;
303: p1 pls_integer;
304: p2 pls_integer;
305: not_empty boolean := true;
306: role_info_tbl wf_directory.wf_local_roles_tbl_type;
307:
308: l_delim varchar2(1);
309: cells tdType;
310: result varchar2(32000);

Line 568: role_info_tbl wf_directory.wf_local_roles_tbl_type;

564: l_owner varchar2(320);
565: l_begin_date date;
566: i pls_integer;
567: j pls_integer;
568: role_info_tbl wf_directory.wf_local_roles_tbl_type;
569:
570: l_table_direction varchar2(1);
571: l_delim varchar2(1) := ':';
572: cells tdType;

Line 928: l_role_info_tbl wf_directory.wf_local_roles_tbl_type;

924: l_orig_sys varchar2(30);
925: l_orig_sysid number;
926: l_start pls_integer;
927: l_end pls_integer;
928: l_role_info_tbl wf_directory.wf_local_roles_tbl_type;
929:
930: begin
931: -- Stripping off unwanted info from email
932: l_start := instr(from_email, '<', 1, 1);

Line 965: from WF_LOCAL_ROLES wlr, WF_USER_ROLE_ASSIGNMENTS_V wurav

961: select NAME
962: into user_name
963: from (select wlr.NAME,
964: decode (wlr.ORIG_SYSTEM, 'PER', 1, 'FND_USR', 2, 3) ORIG_SYS_ORDER
965: from WF_LOCAL_ROLES wlr, WF_USER_ROLE_ASSIGNMENTS_V wurav
966: where wurav.USER_NAME = wlr.NAME and
967: wurav.ROLE_NAME = preferred_name and
968: upper(wlr.EMAIL_ADDRESS)=l_email
969: order by ORIG_SYS_ORDER)

Line 1149: role_info_tbl wf_directory.wf_local_roles_tbl_type;

1145: is
1146: atype varchar2(8);
1147: format varchar2(240);
1148: rname varchar2(320);
1149: role_info_tbl wf_directory.wf_local_roles_tbl_type;
1150: l_parameterlist wf_parameter_list_t := wf_parameter_list_t();
1151: l_language varchar2(30);
1152: l_recipient_role varchar2(320);
1153:

Line 1871: role_info_tbl wf_directory.wf_local_roles_tbl_type;

1867: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME
1868: and WMA.NAME = WNA.NAME
1869: order by decode(wma.type,'URL',length(WNA.NAME),length(WNA.NAME)+1000) desc;
1870:
1871: role_info_tbl wf_directory.wf_local_roles_tbl_type;
1872:
1873: error_name varchar2(30);
1874: error_stack varchar2(32000);
1875: l_dummy boolean;

Line 3717: role_info_tbl wf_directory.wf_local_roles_tbl_type;

3713: l_itemtype varchar2(8);
3714: col1 pls_integer;
3715: col2 pls_integer;
3716: l_language varchar2(30);
3717: role_info_tbl wf_directory.wf_local_roles_tbl_type;
3718: l_new_rcpt_role WF_NOTIFICATIONS.RECIPIENT_ROLE%TYPE;
3719:
3720: cursor message_attrs_cursor(msg_type varchar2, msg_name varchar2) is
3721: select NAME, TYPE, SUBTYPE, VALUE_TYPE,

Line 4065: rorig_system_id WF_LOCAL_ROLES.ORIG_SYSTEM_ID%TYPE;

4061: return number is
4062: dummy pls_integer;
4063: nid WF_NOTIFICATIONS.NOTIFICATION_ID%TYPE;
4064: rorig_system varchar2(30);
4065: rorig_system_id WF_LOCAL_ROLES.ORIG_SYSTEM_ID%TYPE;
4066: --Bug 4050078
4067: itemtype varchar2(8);
4068: itemkey varchar2(240);
4069: actid number;

Line 4187: rorig_system_id WF_LOCAL_ROLES.ORIG_SYSTEM_ID%TYPE;

4183: nid WF_NOTIFICATIONS.NOTIFICATION_ID%TYPE;
4184: gid WF_NOTIFICATIONS.GROUP_ID%TYPE;
4185:
4186: rorig_system varchar2(30);
4187: rorig_system_id WF_LOCAL_ROLES.ORIG_SYSTEM_ID%TYPE;
4188:
4189: cursor role_users_curs is
4190: select WUR.USER_NAME
4191: from WF_USER_ROLES WUR

Line 4300: l_wf_owner WF_LOCAL_ROLES.NAME%TYPE;

4296: --ER 2714169 variables
4297: l_act_id number;
4298: l_item_type WF_ITEMS.ITEM_TYPE%TYPE;
4299: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
4300: l_wf_owner WF_LOCAL_ROLES.NAME%TYPE;
4301: hash_from_role WF_LOCAL_ROLES.NAME%TYPE;
4302:
4303:
4304: -- Bug 2331070

Line 4301: hash_from_role WF_LOCAL_ROLES.NAME%TYPE;

4297: l_act_id number;
4298: l_item_type WF_ITEMS.ITEM_TYPE%TYPE;
4299: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
4300: l_wf_owner WF_LOCAL_ROLES.NAME%TYPE;
4301: hash_from_role WF_LOCAL_ROLES.NAME%TYPE;
4302:
4303:
4304: -- Bug 2331070
4305: l_from_role varchar2(320);

Line 4319: role_info_tbl wf_directory.wf_local_roles_tbl_type;

4315: l_dummy varchar2(1);
4316:
4317: l_language varchar2(30);
4318: l_recipient_role varchar2(320);
4319: role_info_tbl wf_directory.wf_local_roles_tbl_type;
4320:
4321: -- Bug 3827935
4322: l_charcheck boolean;
4323:

Line 6082: role_info_tbl wf_directory.wf_local_roles_tbl_type;

6078: l_from_user varchar2(360);
6079: l_to_user varchar2(360);
6080: l_subject varchar2(2000);
6081: l_language varchar2(64);
6082: role_info_tbl wf_directory.wf_local_roles_tbl_type;
6083: l_territory varchar2(64);
6084: l_nls_date_format varchar2(64);
6085: l_nls_date_language varchar2(64);
6086: l_nls_calendar varchar2(64);

Line 6103: l_sessionUserInfo wf_directory.wf_local_roles_tbl_type;

6099: l_orig_nlsCalendar varchar2(64);
6100: l_logSTMT boolean;
6101: l_logPRCD boolean;
6102: l_sessionUser varchar2(320);
6103: l_sessionUserInfo wf_directory.wf_local_roles_tbl_type;
6104: l_canDefer boolean;
6105: l_module varchar2(100):=g_plsqlName|| 'Denormalize_Notification()';
6106:
6107: begin

Line 6561: role_info_tbl wf_directory.wf_local_roles_tbl_type;

6557: l_newRole varchar2(2000);
6558: l_sysComment varchar2(320);
6559:
6560: l_language varchar2(30);
6561: role_info_tbl wf_directory.wf_local_roles_tbl_type;
6562:
6563: -- bug 7130745
6564: l_event_name varchar2(240);
6565:

Line 6962: role_info_tbl wf_directory.wf_local_roles_tbl_type;

6958: l_more_info_role varchar2(320);
6959: l_dummy varchar2(1);
6960:
6961: l_language varchar2(30);
6962: role_info_tbl wf_directory.wf_local_roles_tbl_type;
6963:
6964: l_event_name varchar2(240);
6965:
6966: begin

Line 7406: role_info_tbl wf_directory.wf_local_roles_tbl_type;

7402: l_messageType varchar2(8);
7403: l_messageName varchar2(30);
7404: l_groupId number;
7405: l_parameterlist wf_parameter_list_t := wf_parameter_list_t();
7406: role_info_tbl wf_directory.wf_local_roles_tbl_type;
7407: l_username varchar2(320);
7408: l_stat varchar2(8);
7409:
7410: --Bug 3065814

Line 7848: role_info_tbl wf_directory.wf_local_roles_tbl_type;

7844: l_question_role varchar2(320);
7845: l_dummy varchar2(1);
7846: l_orig_recip_role varchar2(320);
7847: l_language varchar2(30);
7848: role_info_tbl wf_directory.wf_local_roles_tbl_type;
7849:
7850: begin
7851: wf_log_pkg.string(WF_LOG_PKG.LEVEL_UNEXPECTED, 'WF_NOTIFICATION.UpdateInfoGuest',
7852: 'NID: '||to_char(nid));

Line 9480: role_info_tbl wf_directory.wf_local_roles_tbl_type;

9476: l_territory varchar2(30);
9477: l_orig_system varchar2(30);
9478: l_orig_system_id number;
9479: l_installed varchar2(1);
9480: role_info_tbl wf_directory.wf_local_roles_tbl_type;
9481:
9482: begin
9483:
9484: begin