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

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