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 87: l_event_name WF_EVENTS_VL.NAME%type;

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

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

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

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

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

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

145: --if l_requested_by_user_id is null then
146: wf_event.addParametertoList('REQUESTED_BY_USER_ID', FND_GLOBAL.USER_ID, l_parameter_list);
147: --end if;
148:
149: wf_event.addParametertoList('UMX_PARENT_ITEM_TYPE', UMX_REGISTRATION_UTIL.G_ITEM_TYPE, l_parameter_list);
150: wf_event.addParametertoList('UMX_PARENT_ITEM_KEY', l_item_key, l_parameter_list);
151: if WF_ITEM.ITEM_EXIST('UMXREGWF', L_ITEM_KEY) then
152: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
153: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'fnd.plsql.UMXVREGB.doProcessRequest', 'Error: UMXREGWF with the Item Key -' ||L_ITEM_KEY ||' already exists');

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

146: wf_event.addParametertoList('REQUESTED_BY_USER_ID', FND_GLOBAL.USER_ID, l_parameter_list);
147: --end if;
148:
149: wf_event.addParametertoList('UMX_PARENT_ITEM_TYPE', UMX_REGISTRATION_UTIL.G_ITEM_TYPE, l_parameter_list);
150: wf_event.addParametertoList('UMX_PARENT_ITEM_KEY', l_item_key, l_parameter_list);
151: if WF_ITEM.ITEM_EXIST('UMXREGWF', L_ITEM_KEY) then
152: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
153: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'fnd.plsql.UMXVREGB.doProcessRequest', 'Error: UMXREGWF with the Item Key -' ||L_ITEM_KEY ||' already exists');
154: end if;

Line 156: WF_EVENT.RAISE(L_EVENT_NAME,L_ITEM_KEY,null,L_PARAMETER_LIST,sysdate);

152: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
153: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'fnd.plsql.UMXVREGB.doProcessRequest', 'Error: UMXREGWF with the Item Key -' ||L_ITEM_KEY ||' already exists');
154: end if;
155: else
156: WF_EVENT.RAISE(L_EVENT_NAME,L_ITEM_KEY,null,L_PARAMETER_LIST,sysdate);
157: end if;
158: wf_engine.iteminfo (itemtype => 'UMXREGWF',
159: itemkey => l_item_key,
160: status => l_status,

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

294:
295: end format_address_lov;
296:
297:
298: function get_event_name (p_event_guid WF_EVENTS.guid%type) return wf_events.name%type is
299:
300: CURSOR get_event_name_cursor is
301: select name
302: from wf_events

Line 302: from wf_events

298: function get_event_name (p_event_guid WF_EVENTS.guid%type) return wf_events.name%type is
299:
300: CURSOR get_event_name_cursor is
301: select name
302: from wf_events
303: where guid = HEXTORAW(p_event_guid);
304:
305: x_event_name wf_events.name%type;
306:

Line 305: x_event_name wf_events.name%type;

301: select name
302: from wf_events
303: where guid = HEXTORAW(p_event_guid);
304:
305: x_event_name wf_events.name%type;
306:
307: begin
308: open get_event_name_cursor;
309: fetch get_event_name_cursor into x_event_name;

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

324: x_wf_role_name out nocopy UMX_REG_SERVICES_VL.WF_ROLE_NAME%type,
325: x_ame_application_id out nocopy UMX_REG_SERVICES_VL.AME_APPLICATION_ID%type,
326: x_ame_transaction_type_id out nocopy UMX_REG_SERVICES_VL.AME_TRANSACTION_TYPE_ID%type,
327: x_justification out nocopy UMX_REG_REQUESTS.JUSTIFICATION%type,
328: x_wf_notification_event_name out nocopy WF_EVENTS.NAME%type,
329: x_email_verification_flag out nocopy UMX_REG_SERVICES_VL.EMAIL_VERIFICATION_FLAG%type,
330: x_application_id out nocopy UMX_REG_SERVICES_VL.APPLICATION_ID%type,
331: x_reg_function_name out nocopy FND_FORM_FUNCTIONS.FUNCTION_NAME%type,
332: x_display_name out nocopy UMX_REG_SERVICES_VL.DISPLAY_NAME%type,

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

330: x_application_id out nocopy UMX_REG_SERVICES_VL.APPLICATION_ID%type,
331: x_reg_function_name out nocopy FND_FORM_FUNCTIONS.FUNCTION_NAME%type,
332: x_display_name out nocopy UMX_REG_SERVICES_VL.DISPLAY_NAME%type,
333: x_description out nocopy UMX_REG_SERVICES_VL.DESCRIPTION%type,
334: x_wf_bus_logic_event_name out nocopy WF_EVENTS.NAME%type) is
335:
336: CURSOR get_request_data is
337: SELECT regreq.WF_ROLE_NAME, regreq.REG_SERVICE_TYPE, regser.APPLICATION_ID,
338: regreq.AME_APPLICATION_ID, regreq.AME_TRANSACTION_TYPE_ID,

Line 350: l_wf_notification_event_guid wf_events.guid%type;

346: WHERE regser.reg_function_id = func.function_id (+)
347: AND regreq.REG_SERVICE_CODE = regser.REG_SERVICE_CODE
348: AND regreq.reg_request_id = p_reg_request_id;
349:
350: l_wf_notification_event_guid wf_events.guid%type;
351: l_wf_bus_logic_event_guid wf_events.guid%type;
352:
353: begin
354:

Line 351: l_wf_bus_logic_event_guid wf_events.guid%type;

347: AND regreq.REG_SERVICE_CODE = regser.REG_SERVICE_CODE
348: AND regreq.reg_request_id = p_reg_request_id;
349:
350: l_wf_notification_event_guid wf_events.guid%type;
351: l_wf_bus_logic_event_guid wf_events.guid%type;
352:
353: begin
354:
355: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

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

401: x_reg_service_type out nocopy UMX_REG_SERVICES_VL.REG_SERVICE_TYPE%type,
402: x_wf_role_name out nocopy UMX_REG_SERVICES_VL.WF_ROLE_NAME%type,
403: x_ame_application_id out nocopy UMX_REG_SERVICES_VL.AME_APPLICATION_ID%type,
404: x_ame_transaction_type_id out nocopy UMX_REG_SERVICES_VL.AME_TRANSACTION_TYPE_ID%type,
405: x_wf_notification_event_name out nocopy WF_EVENTS.NAME%type,
406: x_email_verification_flag out nocopy UMX_REG_SERVICES_VL.EMAIL_VERIFICATION_FLAG%type,
407: x_application_id out nocopy UMX_REG_SERVICES_VL.APPLICATION_ID%type,
408: x_reg_function_name out nocopy FND_FORM_FUNCTIONS.FUNCTION_NAME%type,
409: x_display_name out nocopy UMX_REG_SERVICES_VL.DISPLAY_NAME%type,

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

407: x_application_id out nocopy UMX_REG_SERVICES_VL.APPLICATION_ID%type,
408: x_reg_function_name out nocopy FND_FORM_FUNCTIONS.FUNCTION_NAME%type,
409: x_display_name out nocopy UMX_REG_SERVICES_VL.DISPLAY_NAME%type,
410: x_description out nocopy UMX_REG_SERVICES_VL.DESCRIPTION%type,
411: x_wf_bus_logic_event_name out nocopy WF_EVENTS.NAME%type) is
412:
413: CURSOR get_req_svc_data IS
414: SELECT regser.WF_ROLE_NAME, regser.REG_SERVICE_TYPE, regser.APPLICATION_ID,
415: regser.wf_notification_event_guid, regser.AME_APPLICATION_ID,

Line 423: l_wf_notification_event_guid wf_events.guid%type;

419: FROM UMX_REG_SERVICES_VL regser, fnd_form_functions func
420: WHERE regser.reg_function_id = func.function_id (+)
421: AND REG_SERVICE_CODE = p_reg_service_code;
422:
423: l_wf_notification_event_guid wf_events.guid%type;
424: l_wf_bus_logic_event_guid wf_events.guid%type;
425:
426: begin
427:

Line 424: l_wf_bus_logic_event_guid wf_events.guid%type;

420: WHERE regser.reg_function_id = func.function_id (+)
421: AND REG_SERVICE_CODE = p_reg_service_code;
422:
423: l_wf_notification_event_guid wf_events.guid%type;
424: l_wf_bus_logic_event_guid wf_events.guid%type;
425:
426: begin
427:
428: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

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

464: x_reg_service_code out nocopy UMX_REG_SERVICES_B.REG_SERVICE_CODE%type,
465: x_reg_service_type out nocopy UMX_REG_SERVICES_VL.REG_SERVICE_TYPE%type,
466: x_ame_application_id out nocopy UMX_REG_SERVICES_VL.AME_APPLICATION_ID%type,
467: x_ame_transaction_type_id out nocopy UMX_REG_SERVICES_VL.AME_TRANSACTION_TYPE_ID%type,
468: x_wf_notification_event_name out nocopy WF_EVENTS.NAME%type,
469: x_email_verification_flag out nocopy UMX_REG_SERVICES_VL.EMAIL_VERIFICATION_FLAG%type,
470: x_reg_function_name out nocopy FND_FORM_FUNCTIONS.FUNCTION_NAME%type,
471: x_wf_bus_logic_event_name out nocopy WF_EVENTS.NAME%type) is
472:

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

467: x_ame_transaction_type_id out nocopy UMX_REG_SERVICES_VL.AME_TRANSACTION_TYPE_ID%type,
468: x_wf_notification_event_name out nocopy WF_EVENTS.NAME%type,
469: x_email_verification_flag out nocopy UMX_REG_SERVICES_VL.EMAIL_VERIFICATION_FLAG%type,
470: x_reg_function_name out nocopy FND_FORM_FUNCTIONS.FUNCTION_NAME%type,
471: x_wf_bus_logic_event_name out nocopy WF_EVENTS.NAME%type) is
472:
473: CURSOR get_reg_svc_code_from_role (p_reg_serivce_type in varchar2) IS
474: select REG_SERVICE_TYPE, REG_SERVICE_CODE, AME_APPLICATION_ID,
475: AME_TRANSACTION_TYPE_ID, REG_FUNCTION_ID,

Line 482: l_wf_notification_event_guid wf_events.guid%type;

478: from UMX_REG_SERVICES_B
479: where WF_ROLE_NAME = p_wf_role_name
480: and reg_service_type = p_reg_serivce_type;
481:
482: l_wf_notification_event_guid wf_events.guid%type;
483: l_wf_bus_logic_event_guid wf_events.guid%type;
484:
485: begin
486:

Line 483: l_wf_bus_logic_event_guid wf_events.guid%type;

479: where WF_ROLE_NAME = p_wf_role_name
480: and reg_service_type = p_reg_serivce_type;
481:
482: l_wf_notification_event_guid wf_events.guid%type;
483: l_wf_bus_logic_event_guid wf_events.guid%type;
484:
485: begin
486:
487: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

Line 533: l_wf_notification_event_name wf_events.name%TYPE;

529: j number;
530: l_wf_role_name UMX_REG_SERVICES_VL.WF_ROLE_NAME%TYPE;
531: l_reg_service_type UMX_REG_SERVICES_VL.REG_SERVICE_TYPE%TYPE;
532: l_application_id UMX_REG_SERVICES_VL.APPLICATION_ID%TYPE;
533: l_wf_notification_event_name wf_events.name%TYPE;
534: l_ame_application_id UMX_REG_SERVICES_VL.AME_APPLICATION_ID%TYPE;
535: l_ame_transaction_type_id UMX_REG_SERVICES_VL.AME_TRANSACTION_TYPE_ID%TYPE;
536: l_email_verification_flag UMX_REG_SERVICES_VL.EMAIL_VERIFICATION_FLAG%TYPE;
537: l_reg_function_name fnd_form_functions.FUNCTION_NAME%TYPE;

Line 540: l_wf_bus_logic_event_name wf_events.name%TYPE;

536: l_email_verification_flag UMX_REG_SERVICES_VL.EMAIL_VERIFICATION_FLAG%TYPE;
537: l_reg_function_name fnd_form_functions.FUNCTION_NAME%TYPE;
538: l_display_name UMX_REG_SERVICES_VL.DISPLAY_NAME%TYPE;
539: l_description UMX_REG_SERVICES_VL.DESCRIPTION%TYPE;
540: l_wf_bus_logic_event_name wf_events.name%TYPE;
541: l_justification UMX_REG_REQUESTS.JUSTIFICATION%TYPE;
542: l_requested_by_user_id UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%TYPE;
543: l_requested_for_user_id UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%TYPE;
544: l_requested_for_party_id UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%type;

Line 864: l_wf_notification_event_name wf_events.name%TYPE;

860: l_reg_service_code umx_reg_requests.reg_service_code%type;
861: l_ame_application_id umx_reg_requests.ame_application_id%type;
862: l_ame_transaction_type_id umx_reg_requests.ame_transaction_type_id%type;
863: l_justification umx_reg_requests.justification%type;
864: l_wf_notification_event_name wf_events.name%TYPE;
865: l_wf_bus_logic_event_name wf_events.name%TYPE;
866: l_email_verification_flag UMX_REG_SERVICES_VL.EMAIL_VERIFICATION_FLAG%TYPE;
867: l_application_id UMX_REG_SERVICES_VL.APPLICATION_ID%TYPE;
868: l_reg_function_name fnd_form_functions.FUNCTION_NAME%TYPE;

Line 865: l_wf_bus_logic_event_name wf_events.name%TYPE;

861: l_ame_application_id umx_reg_requests.ame_application_id%type;
862: l_ame_transaction_type_id umx_reg_requests.ame_transaction_type_id%type;
863: l_justification umx_reg_requests.justification%type;
864: l_wf_notification_event_name wf_events.name%TYPE;
865: l_wf_bus_logic_event_name wf_events.name%TYPE;
866: l_email_verification_flag UMX_REG_SERVICES_VL.EMAIL_VERIFICATION_FLAG%TYPE;
867: l_application_id UMX_REG_SERVICES_VL.APPLICATION_ID%TYPE;
868: l_reg_function_name fnd_form_functions.FUNCTION_NAME%TYPE;
869: l_display_name UMX_REG_SERVICES_VL.DISPLAY_NAME%TYPE;

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

1166: p_registration_data(l_reg_service_type_i).attr_value := l_reg_service_type;
1167:
1168: i := p_registration_data.first;
1169: while (i <= p_registration_data.last) loop
1170: wf_event.addParametertoList (upper(p_registration_data(i).ATTR_NAME),
1171: p_registration_data(i).ATTR_VALUE,
1172: l_parameter_list);
1173: i := i + 1;
1174: end loop;

Line 1176: -- Raise WF Event

1172: l_parameter_list);
1173: i := i + 1;
1174: end loop;
1175:
1176: -- Raise WF Event
1177: select umx_events_s.nextval into l_event_key from dual;
1178: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1179: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1180: 'fnd.plsql.UMXVREGB.assignRole',

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

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

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

1188:
1189: -- Launch the custom event if the custom event name is not null.
1190: if (l_wf_bus_logic_event_name is not null) then
1191: -- Set the custom event context
1192: wf_event.addParametertoList ('UMX_CUSTOM_EVENT_CONTEXT', 'ROLE APPROVED', l_parameter_list);
1193: -- Finally, raise the custom event.
1194: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1195: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1196: 'fnd.plsql.UMXVREGB.assignRole',

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

1195: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1196: 'fnd.plsql.UMXVREGB.assignRole',
1197: 'Raising ' || l_wf_bus_logic_event_name || ' event with l_event_key=' || l_event_key);
1198: end if;
1199: wf_event.raise (p_event_name => l_wf_bus_logic_event_name,
1200: p_event_key => l_event_key,
1201: p_event_data => null,
1202: p_parameters => l_parameter_list,
1203: p_send_date => sysdate);

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

1229: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1230: 'fnd.plsql.UMXVREGB.assignRole',
1231: 'Raising oracle.apps.fnd.umx.requestapproved event with l_event_key=' || l_event_key);
1232: end if;
1233: wf_event.raise (p_event_name => 'oracle.apps.fnd.umx.requestapproved',
1234: p_event_key => l_event_key,
1235: p_event_data => null,
1236: p_parameters => l_parameter_list,
1237: p_send_date => sysdate);