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.UMX_REGISTRATION_PVT dependencies on WF_EVENT

Line 85: l_event_name WF_EVENTS_VL.NAME%type;

81: l_parameter_list wf_parameter_list_t;
82: j number;
83: l_item_key varchar2(2000);
84: l_requested_by_user_id varchar2(2000);
85: l_event_name WF_EVENTS_VL.NAME%type;
86: l_reg_service_type UMX_REG_SERVICES_B.REG_SERVICE_TYPE%type;
87: l_index_to_add number;
88:
89: l_status varchar2(8);

Line 111: wf_event.addParametertoList(UPPER(p_registration_data(j).ATTR_NAME), p_registration_data(j).ATTR_VALUE,l_parameter_list);

107: while (j <= p_registration_data.LAST) loop
108: -- Add parameter to the event object only if
109: -- the attribute name is not null
110: if p_registration_data(j).ATTR_NAME is not null then
111: wf_event.addParametertoList(UPPER(p_registration_data(j).ATTR_NAME), p_registration_data(j).ATTR_VALUE,l_parameter_list);
112: end if;
113: --insert into chirag_test values(p_registration_data(j).ATTR_NAME, p_registration_data(j).ATTR_VALUE);
114: if p_registration_data(j).ATTR_NAME = 'reg_service_type' then
115: l_reg_service_type := p_registration_data(j).ATTR_VALUE;

Line 144: wf_event.addParametertoList('REQUESTED_BY_USER_ID', FND_GLOBAL.USER_ID, l_parameter_list);

140: p_registration_data(l_index_to_add).ATTR_VALUE := l_item_key;
141: end if;
142:
143: --if l_requested_by_user_id is null then
144: wf_event.addParametertoList('REQUESTED_BY_USER_ID', FND_GLOBAL.USER_ID, l_parameter_list);
145: --end if;
146:
147: wf_event.addParametertoList('UMX_PARENT_ITEM_TYPE', UMX_REGISTRATION_UTIL.G_ITEM_TYPE, l_parameter_list);
148: wf_event.addParametertoList('UMX_PARENT_ITEM_KEY', l_item_key, l_parameter_list);

Line 147: wf_event.addParametertoList('UMX_PARENT_ITEM_TYPE', UMX_REGISTRATION_UTIL.G_ITEM_TYPE, l_parameter_list);

143: --if l_requested_by_user_id is null then
144: wf_event.addParametertoList('REQUESTED_BY_USER_ID', FND_GLOBAL.USER_ID, l_parameter_list);
145: --end if;
146:
147: wf_event.addParametertoList('UMX_PARENT_ITEM_TYPE', UMX_REGISTRATION_UTIL.G_ITEM_TYPE, l_parameter_list);
148: wf_event.addParametertoList('UMX_PARENT_ITEM_KEY', l_item_key, l_parameter_list);
149: wf_event.raise(l_event_name,l_item_key,null,l_parameter_list,sysdate);
150:
151: wf_engine.iteminfo (itemtype => 'UMXREGWF',

Line 148: wf_event.addParametertoList('UMX_PARENT_ITEM_KEY', l_item_key, l_parameter_list);

144: wf_event.addParametertoList('REQUESTED_BY_USER_ID', FND_GLOBAL.USER_ID, l_parameter_list);
145: --end if;
146:
147: wf_event.addParametertoList('UMX_PARENT_ITEM_TYPE', UMX_REGISTRATION_UTIL.G_ITEM_TYPE, l_parameter_list);
148: wf_event.addParametertoList('UMX_PARENT_ITEM_KEY', l_item_key, l_parameter_list);
149: wf_event.raise(l_event_name,l_item_key,null,l_parameter_list,sysdate);
150:
151: wf_engine.iteminfo (itemtype => 'UMXREGWF',
152: itemkey => l_item_key,

Line 149: wf_event.raise(l_event_name,l_item_key,null,l_parameter_list,sysdate);

145: --end if;
146:
147: wf_event.addParametertoList('UMX_PARENT_ITEM_TYPE', UMX_REGISTRATION_UTIL.G_ITEM_TYPE, l_parameter_list);
148: wf_event.addParametertoList('UMX_PARENT_ITEM_KEY', l_item_key, l_parameter_list);
149: wf_event.raise(l_event_name,l_item_key,null,l_parameter_list,sysdate);
150:
151: wf_engine.iteminfo (itemtype => 'UMXREGWF',
152: itemkey => l_item_key,
153: status => l_status,

Line 285: function get_event_name (p_event_guid WF_EVENTS.guid%type) return wf_events.name%type is

281:
282: end format_address_lov;
283:
284:
285: function get_event_name (p_event_guid WF_EVENTS.guid%type) return wf_events.name%type is
286:
287: CURSOR get_event_name_cursor is
288: select name
289: from wf_events

Line 289: from wf_events

285: function get_event_name (p_event_guid WF_EVENTS.guid%type) return wf_events.name%type is
286:
287: CURSOR get_event_name_cursor is
288: select name
289: from wf_events
290: where guid = HEXTORAW(p_event_guid);
291:
292: x_event_name wf_events.name%type;
293:

Line 292: x_event_name wf_events.name%type;

288: select name
289: from wf_events
290: where guid = HEXTORAW(p_event_guid);
291:
292: x_event_name wf_events.name%type;
293:
294: begin
295: open get_event_name_cursor;
296: fetch get_event_name_cursor into x_event_name;

Line 315: x_wf_notification_event_name out nocopy WF_EVENTS.NAME%type,

311: x_wf_role_name out nocopy UMX_REG_SERVICES_VL.WF_ROLE_NAME%type,
312: x_ame_application_id out nocopy UMX_REG_SERVICES_VL.AME_APPLICATION_ID%type,
313: x_ame_transaction_type_id out nocopy UMX_REG_SERVICES_VL.AME_TRANSACTION_TYPE_ID%type,
314: x_justification out nocopy UMX_REG_REQUESTS.JUSTIFICATION%type,
315: x_wf_notification_event_name out nocopy WF_EVENTS.NAME%type,
316: x_email_verification_flag out nocopy UMX_REG_SERVICES_VL.EMAIL_VERIFICATION_FLAG%type,
317: x_application_id out nocopy UMX_REG_SERVICES_VL.APPLICATION_ID%type,
318: x_reg_function_name out nocopy FND_FORM_FUNCTIONS.FUNCTION_NAME%type,
319: x_display_name out nocopy UMX_REG_SERVICES_VL.DISPLAY_NAME%type,

Line 321: x_wf_bus_logic_event_name out nocopy WF_EVENTS.NAME%type) is

317: x_application_id out nocopy UMX_REG_SERVICES_VL.APPLICATION_ID%type,
318: x_reg_function_name out nocopy FND_FORM_FUNCTIONS.FUNCTION_NAME%type,
319: x_display_name out nocopy UMX_REG_SERVICES_VL.DISPLAY_NAME%type,
320: x_description out nocopy UMX_REG_SERVICES_VL.DESCRIPTION%type,
321: x_wf_bus_logic_event_name out nocopy WF_EVENTS.NAME%type) is
322:
323: CURSOR get_request_data is
324: SELECT regreq.WF_ROLE_NAME, regreq.REG_SERVICE_TYPE, regser.APPLICATION_ID,
325: regreq.AME_APPLICATION_ID, regreq.AME_TRANSACTION_TYPE_ID,

Line 337: l_wf_notification_event_guid wf_events.guid%type;

333: WHERE regser.reg_function_id = func.function_id (+)
334: AND regreq.REG_SERVICE_CODE = regser.REG_SERVICE_CODE
335: AND regreq.reg_request_id = p_reg_request_id;
336:
337: l_wf_notification_event_guid wf_events.guid%type;
338: l_wf_bus_logic_event_guid wf_events.guid%type;
339:
340: begin
341:

Line 338: l_wf_bus_logic_event_guid wf_events.guid%type;

334: AND regreq.REG_SERVICE_CODE = regser.REG_SERVICE_CODE
335: AND regreq.reg_request_id = p_reg_request_id;
336:
337: l_wf_notification_event_guid wf_events.guid%type;
338: l_wf_bus_logic_event_guid wf_events.guid%type;
339:
340: begin
341:
342: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

Line 392: x_wf_notification_event_name out nocopy WF_EVENTS.NAME%type,

388: x_reg_service_type out nocopy UMX_REG_SERVICES_VL.REG_SERVICE_TYPE%type,
389: x_wf_role_name out nocopy UMX_REG_SERVICES_VL.WF_ROLE_NAME%type,
390: x_ame_application_id out nocopy UMX_REG_SERVICES_VL.AME_APPLICATION_ID%type,
391: x_ame_transaction_type_id out nocopy UMX_REG_SERVICES_VL.AME_TRANSACTION_TYPE_ID%type,
392: x_wf_notification_event_name out nocopy WF_EVENTS.NAME%type,
393: x_email_verification_flag out nocopy UMX_REG_SERVICES_VL.EMAIL_VERIFICATION_FLAG%type,
394: x_application_id out nocopy UMX_REG_SERVICES_VL.APPLICATION_ID%type,
395: x_reg_function_name out nocopy FND_FORM_FUNCTIONS.FUNCTION_NAME%type,
396: x_display_name out nocopy UMX_REG_SERVICES_VL.DISPLAY_NAME%type,

Line 398: x_wf_bus_logic_event_name out nocopy WF_EVENTS.NAME%type) is

394: x_application_id out nocopy UMX_REG_SERVICES_VL.APPLICATION_ID%type,
395: x_reg_function_name out nocopy FND_FORM_FUNCTIONS.FUNCTION_NAME%type,
396: x_display_name out nocopy UMX_REG_SERVICES_VL.DISPLAY_NAME%type,
397: x_description out nocopy UMX_REG_SERVICES_VL.DESCRIPTION%type,
398: x_wf_bus_logic_event_name out nocopy WF_EVENTS.NAME%type) is
399:
400: CURSOR get_req_svc_data IS
401: SELECT regser.WF_ROLE_NAME, regser.REG_SERVICE_TYPE, regser.APPLICATION_ID,
402: regser.wf_notification_event_guid, regser.AME_APPLICATION_ID,

Line 410: l_wf_notification_event_guid wf_events.guid%type;

406: FROM UMX_REG_SERVICES_VL regser, fnd_form_functions func
407: WHERE regser.reg_function_id = func.function_id (+)
408: AND REG_SERVICE_CODE = p_reg_service_code;
409:
410: l_wf_notification_event_guid wf_events.guid%type;
411: l_wf_bus_logic_event_guid wf_events.guid%type;
412:
413: begin
414:

Line 411: l_wf_bus_logic_event_guid wf_events.guid%type;

407: WHERE regser.reg_function_id = func.function_id (+)
408: AND REG_SERVICE_CODE = p_reg_service_code;
409:
410: l_wf_notification_event_guid wf_events.guid%type;
411: l_wf_bus_logic_event_guid wf_events.guid%type;
412:
413: begin
414:
415: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

Line 455: x_wf_notification_event_name out nocopy WF_EVENTS.NAME%type,

451: x_reg_service_code out nocopy UMX_REG_SERVICES_B.REG_SERVICE_CODE%type,
452: x_reg_service_type out nocopy UMX_REG_SERVICES_VL.REG_SERVICE_TYPE%type,
453: x_ame_application_id out nocopy UMX_REG_SERVICES_VL.AME_APPLICATION_ID%type,
454: x_ame_transaction_type_id out nocopy UMX_REG_SERVICES_VL.AME_TRANSACTION_TYPE_ID%type,
455: x_wf_notification_event_name out nocopy WF_EVENTS.NAME%type,
456: x_email_verification_flag out nocopy UMX_REG_SERVICES_VL.EMAIL_VERIFICATION_FLAG%type,
457: x_reg_function_name out nocopy FND_FORM_FUNCTIONS.FUNCTION_NAME%type,
458: x_wf_bus_logic_event_name out nocopy WF_EVENTS.NAME%type) is
459:

Line 458: x_wf_bus_logic_event_name out nocopy WF_EVENTS.NAME%type) is

454: x_ame_transaction_type_id out nocopy UMX_REG_SERVICES_VL.AME_TRANSACTION_TYPE_ID%type,
455: x_wf_notification_event_name out nocopy WF_EVENTS.NAME%type,
456: x_email_verification_flag out nocopy UMX_REG_SERVICES_VL.EMAIL_VERIFICATION_FLAG%type,
457: x_reg_function_name out nocopy FND_FORM_FUNCTIONS.FUNCTION_NAME%type,
458: x_wf_bus_logic_event_name out nocopy WF_EVENTS.NAME%type) is
459:
460: CURSOR get_reg_svc_code_from_role (p_reg_serivce_type in varchar2) IS
461: select REG_SERVICE_TYPE, REG_SERVICE_CODE, AME_APPLICATION_ID,
462: AME_TRANSACTION_TYPE_ID, REG_FUNCTION_ID,

Line 469: l_wf_notification_event_guid wf_events.guid%type;

465: from UMX_REG_SERVICES_B
466: where WF_ROLE_NAME = p_wf_role_name
467: and reg_service_type = p_reg_serivce_type;
468:
469: l_wf_notification_event_guid wf_events.guid%type;
470: l_wf_bus_logic_event_guid wf_events.guid%type;
471:
472: begin
473:

Line 470: l_wf_bus_logic_event_guid wf_events.guid%type;

466: where WF_ROLE_NAME = p_wf_role_name
467: and reg_service_type = p_reg_serivce_type;
468:
469: l_wf_notification_event_guid wf_events.guid%type;
470: l_wf_bus_logic_event_guid wf_events.guid%type;
471:
472: begin
473:
474: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

Line 520: l_wf_notification_event_name wf_events.name%TYPE;

516: j number;
517: l_wf_role_name UMX_REG_SERVICES_VL.WF_ROLE_NAME%TYPE;
518: l_reg_service_type UMX_REG_SERVICES_VL.REG_SERVICE_TYPE%TYPE;
519: l_application_id UMX_REG_SERVICES_VL.APPLICATION_ID%TYPE;
520: l_wf_notification_event_name wf_events.name%TYPE;
521: l_ame_application_id UMX_REG_SERVICES_VL.AME_APPLICATION_ID%TYPE;
522: l_ame_transaction_type_id UMX_REG_SERVICES_VL.AME_TRANSACTION_TYPE_ID%TYPE;
523: l_email_verification_flag UMX_REG_SERVICES_VL.EMAIL_VERIFICATION_FLAG%TYPE;
524: l_reg_function_name fnd_form_functions.FUNCTION_NAME%TYPE;

Line 527: l_wf_bus_logic_event_name wf_events.name%TYPE;

523: l_email_verification_flag UMX_REG_SERVICES_VL.EMAIL_VERIFICATION_FLAG%TYPE;
524: l_reg_function_name fnd_form_functions.FUNCTION_NAME%TYPE;
525: l_display_name UMX_REG_SERVICES_VL.DISPLAY_NAME%TYPE;
526: l_description UMX_REG_SERVICES_VL.DESCRIPTION%TYPE;
527: l_wf_bus_logic_event_name wf_events.name%TYPE;
528: l_justification UMX_REG_REQUESTS.JUSTIFICATION%TYPE;
529: l_requested_by_user_id UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%TYPE;
530: l_requested_for_user_id UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%TYPE;
531: l_requested_for_party_id UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%type;

Line 849: l_wf_notification_event_name wf_events.name%TYPE;

845: l_reg_service_code umx_reg_requests.reg_service_code%type;
846: l_ame_application_id umx_reg_requests.ame_application_id%type;
847: l_ame_transaction_type_id umx_reg_requests.ame_transaction_type_id%type;
848: l_justification umx_reg_requests.justification%type;
849: l_wf_notification_event_name wf_events.name%TYPE;
850: l_wf_bus_logic_event_name wf_events.name%TYPE;
851: l_email_verification_flag UMX_REG_SERVICES_VL.EMAIL_VERIFICATION_FLAG%TYPE;
852: l_application_id UMX_REG_SERVICES_VL.APPLICATION_ID%TYPE;
853: l_reg_function_name fnd_form_functions.FUNCTION_NAME%TYPE;

Line 850: l_wf_bus_logic_event_name wf_events.name%TYPE;

846: l_ame_application_id umx_reg_requests.ame_application_id%type;
847: l_ame_transaction_type_id umx_reg_requests.ame_transaction_type_id%type;
848: l_justification umx_reg_requests.justification%type;
849: l_wf_notification_event_name wf_events.name%TYPE;
850: l_wf_bus_logic_event_name wf_events.name%TYPE;
851: l_email_verification_flag UMX_REG_SERVICES_VL.EMAIL_VERIFICATION_FLAG%TYPE;
852: l_application_id UMX_REG_SERVICES_VL.APPLICATION_ID%TYPE;
853: l_reg_function_name fnd_form_functions.FUNCTION_NAME%TYPE;
854: l_display_name UMX_REG_SERVICES_VL.DISPLAY_NAME%TYPE;

Line 1155: wf_event.addParametertoList (upper(p_registration_data(i).ATTR_NAME),

1151: p_registration_data(l_reg_service_type_i).attr_value := l_reg_service_type;
1152:
1153: i := p_registration_data.first;
1154: while (i <= p_registration_data.last) loop
1155: wf_event.addParametertoList (upper(p_registration_data(i).ATTR_NAME),
1156: p_registration_data(i).ATTR_VALUE,
1157: l_parameter_list);
1158: i := i + 1;
1159: end loop;

Line 1161: -- Raise WF Event

1157: l_parameter_list);
1158: i := i + 1;
1159: end loop;
1160:
1161: -- Raise WF Event
1162: select umx_events_s.nextval into l_event_key from dual;
1163: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1164: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1165: 'fnd.plsql.UMXVREGB.assignRole',

Line 1168: wf_event.raise (p_event_name => 'oracle.apps.fnd.umx.rolerequested',

1164: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1165: 'fnd.plsql.UMXVREGB.assignRole',
1166: 'Raising oracle.apps.fnd.umx.rolerequested event with l_event_key=' || l_event_key);
1167: end if;
1168: wf_event.raise (p_event_name => 'oracle.apps.fnd.umx.rolerequested',
1169: p_event_key => l_event_key,
1170: p_event_data => null,
1171: p_parameters => l_parameter_list,
1172: p_send_date => sysdate);

Line 1177: wf_event.addParametertoList ('UMX_CUSTOM_EVENT_CONTEXT', 'ROLE APPROVED', l_parameter_list);

1173:
1174: -- Launch the custom event if the custom event name is not null.
1175: if (l_wf_bus_logic_event_name is not null) then
1176: -- Set the custom event context
1177: wf_event.addParametertoList ('UMX_CUSTOM_EVENT_CONTEXT', 'ROLE APPROVED', l_parameter_list);
1178: -- Finally, raise the custom event.
1179: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1180: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1181: 'fnd.plsql.UMXVREGB.assignRole',

Line 1184: wf_event.raise (p_event_name => l_wf_bus_logic_event_name,

1180: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1181: 'fnd.plsql.UMXVREGB.assignRole',
1182: 'Raising ' || l_wf_bus_logic_event_name || ' event with l_event_key=' || l_event_key);
1183: end if;
1184: wf_event.raise (p_event_name => l_wf_bus_logic_event_name,
1185: p_event_key => l_event_key,
1186: p_event_data => null,
1187: p_parameters => l_parameter_list,
1188: p_send_date => sysdate);

Line 1218: wf_event.raise (p_event_name => 'oracle.apps.fnd.umx.requestapproved',

1214: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1215: 'fnd.plsql.UMXVREGB.assignRole',
1216: 'Raising oracle.apps.fnd.umx.requestapproved event with l_event_key=' || l_event_key);
1217: end if;
1218: wf_event.raise (p_event_name => 'oracle.apps.fnd.umx.requestapproved',
1219: p_event_key => l_event_key,
1220: p_event_data => null,
1221: p_parameters => l_parameter_list,
1222: p_send_date => sysdate);