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 UMX_REG_SERVICES_VL

Line 319: x_reg_service_type out nocopy UMX_REG_SERVICES_VL.REG_SERVICE_TYPE%type,

315:
316: procedure get_req_data_from_req_id (
317: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%type,
318: p_reg_service_code in UMX_REG_SERVICES_B.REG_SERVICE_CODE%type,
319: x_reg_service_type out nocopy UMX_REG_SERVICES_VL.REG_SERVICE_TYPE%type,
320: x_requested_by_user_id out nocopy UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%type,
321: x_requested_for_user_id out nocopy UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%type,
322: x_requested_for_party_id out nocopy UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%type,
323: x_requested_username out nocopy UMX_REG_REQUESTS.REQUESTED_USERNAME%type,

Line 324: x_wf_role_name out nocopy UMX_REG_SERVICES_VL.WF_ROLE_NAME%type,

320: x_requested_by_user_id out nocopy UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%type,
321: x_requested_for_user_id out nocopy UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%type,
322: x_requested_for_party_id out nocopy UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%type,
323: x_requested_username out nocopy UMX_REG_REQUESTS.REQUESTED_USERNAME%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,

Line 325: x_ame_application_id out nocopy UMX_REG_SERVICES_VL.AME_APPLICATION_ID%type,

321: x_requested_for_user_id out nocopy UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%type,
322: x_requested_for_party_id out nocopy UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%type,
323: x_requested_username out nocopy UMX_REG_REQUESTS.REQUESTED_USERNAME%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,

Line 326: x_ame_transaction_type_id out nocopy UMX_REG_SERVICES_VL.AME_TRANSACTION_TYPE_ID%type,

322: x_requested_for_party_id out nocopy UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%type,
323: x_requested_username out nocopy UMX_REG_REQUESTS.REQUESTED_USERNAME%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,

Line 329: x_email_verification_flag out nocopy UMX_REG_SERVICES_VL.EMAIL_VERIFICATION_FLAG%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,
333: x_description out nocopy UMX_REG_SERVICES_VL.DESCRIPTION%type,

Line 330: x_application_id out nocopy UMX_REG_SERVICES_VL.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,
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

Line 332: x_display_name out nocopy UMX_REG_SERVICES_VL.DISPLAY_NAME%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,
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

Line 333: x_description out nocopy UMX_REG_SERVICES_VL.DESCRIPTION%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,
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,

Line 344: FROM UMX_REG_SERVICES_VL regser, fnd_form_functions func,

340: regser.DESCRIPTION, regreq.JUSTIFICATION, regreq.REQUESTED_BY_USER_ID,
341: regreq.REQUESTED_FOR_USER_ID, regreq.REQUESTED_FOR_PARTY_ID,
342: regreq.REQUESTED_USERNAME, regser.wf_notification_event_guid,
343: regser.wf_bus_logic_event_guid
344: FROM UMX_REG_SERVICES_VL regser, fnd_form_functions func,
345: UMX_REG_REQUESTS regreq
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;

Line 401: x_reg_service_type out nocopy UMX_REG_SERVICES_VL.REG_SERVICE_TYPE%type,

397:
398:
399: procedure get_req_data_from_req_sv_code (
400: p_reg_service_code in UMX_REG_SERVICES_B.REG_SERVICE_CODE%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,

Line 402: x_wf_role_name out nocopy UMX_REG_SERVICES_VL.WF_ROLE_NAME%type,

398:
399: procedure get_req_data_from_req_sv_code (
400: p_reg_service_code in UMX_REG_SERVICES_B.REG_SERVICE_CODE%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,

Line 403: x_ame_application_id out nocopy UMX_REG_SERVICES_VL.AME_APPLICATION_ID%type,

399: procedure get_req_data_from_req_sv_code (
400: p_reg_service_code in UMX_REG_SERVICES_B.REG_SERVICE_CODE%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,

Line 404: x_ame_transaction_type_id out nocopy UMX_REG_SERVICES_VL.AME_TRANSACTION_TYPE_ID%type,

400: p_reg_service_code in UMX_REG_SERVICES_B.REG_SERVICE_CODE%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,

Line 406: x_email_verification_flag out nocopy UMX_REG_SERVICES_VL.EMAIL_VERIFICATION_FLAG%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,
410: x_description out nocopy UMX_REG_SERVICES_VL.DESCRIPTION%type,

Line 407: x_application_id out nocopy UMX_REG_SERVICES_VL.APPLICATION_ID%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,
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

Line 409: x_display_name out nocopy UMX_REG_SERVICES_VL.DISPLAY_NAME%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,
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

Line 410: x_description out nocopy UMX_REG_SERVICES_VL.DESCRIPTION%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,
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,

Line 419: FROM UMX_REG_SERVICES_VL regser, fnd_form_functions func

415: regser.wf_notification_event_guid, regser.AME_APPLICATION_ID,
416: regser.AME_TRANSACTION_TYPE_ID, regser.EMAIL_VERIFICATION_FLAG,
417: func.FUNCTION_NAME, regser.DISPLAY_NAME, regser.DESCRIPTION,
418: regser.wf_bus_logic_event_guid
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;

Line 463: p_wf_role_name in UMX_REG_SERVICES_VL.WF_ROLE_NAME%type,

459: end if;
460: end get_req_data_from_req_sv_code;
461:
462: procedure get_req_data_from_role_name (
463: p_wf_role_name in UMX_REG_SERVICES_VL.WF_ROLE_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,

Line 465: x_reg_service_type out nocopy UMX_REG_SERVICES_VL.REG_SERVICE_TYPE%type,

461:
462: procedure get_req_data_from_role_name (
463: p_wf_role_name in UMX_REG_SERVICES_VL.WF_ROLE_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,

Line 466: x_ame_application_id out nocopy UMX_REG_SERVICES_VL.AME_APPLICATION_ID%type,

462: procedure get_req_data_from_role_name (
463: p_wf_role_name in UMX_REG_SERVICES_VL.WF_ROLE_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,

Line 467: x_ame_transaction_type_id out nocopy UMX_REG_SERVICES_VL.AME_TRANSACTION_TYPE_ID%type,

463: p_wf_role_name in UMX_REG_SERVICES_VL.WF_ROLE_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

Line 469: x_email_verification_flag out nocopy UMX_REG_SERVICES_VL.EMAIL_VERIFICATION_FLAG%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:
473: CURSOR get_reg_svc_code_from_role (p_reg_serivce_type in varchar2) IS

Line 530: l_wf_role_name UMX_REG_SERVICES_VL.WF_ROLE_NAME%TYPE;

526: procedure POPULATE_REG_DATA (p_registration_data IN OUT NOCOPY UMX_REGISTRATION_DATA_TBL) IS
527: l_reg_request_id UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE;
528: l_reg_service_code UMX_REG_SERVICES_B.REG_SERVICE_CODE%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;

Line 531: l_reg_service_type UMX_REG_SERVICES_VL.REG_SERVICE_TYPE%TYPE;

527: l_reg_request_id UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE;
528: l_reg_service_code UMX_REG_SERVICES_B.REG_SERVICE_CODE%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;

Line 532: l_application_id UMX_REG_SERVICES_VL.APPLICATION_ID%TYPE;

528: l_reg_service_code UMX_REG_SERVICES_B.REG_SERVICE_CODE%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;

Line 534: l_ame_application_id UMX_REG_SERVICES_VL.AME_APPLICATION_ID%TYPE;

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;
538: l_display_name UMX_REG_SERVICES_VL.DISPLAY_NAME%TYPE;

Line 535: l_ame_transaction_type_id UMX_REG_SERVICES_VL.AME_TRANSACTION_TYPE_ID%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;
538: l_display_name UMX_REG_SERVICES_VL.DISPLAY_NAME%TYPE;
539: l_description UMX_REG_SERVICES_VL.DESCRIPTION%TYPE;

Line 536: l_email_verification_flag UMX_REG_SERVICES_VL.EMAIL_VERIFICATION_FLAG%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;
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;

Line 538: l_display_name UMX_REG_SERVICES_VL.DISPLAY_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;
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;

Line 539: l_description UMX_REG_SERVICES_VL.DESCRIPTION%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;
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;

Line 866: l_email_verification_flag UMX_REG_SERVICES_VL.EMAIL_VERIFICATION_FLAG%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;
870: l_description UMX_REG_SERVICES_VL.DESCRIPTION%TYPE;

Line 867: l_application_id UMX_REG_SERVICES_VL.APPLICATION_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;
870: l_description UMX_REG_SERVICES_VL.DESCRIPTION%TYPE;
871:

Line 869: l_display_name UMX_REG_SERVICES_VL.DISPLAY_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;
870: l_description UMX_REG_SERVICES_VL.DESCRIPTION%TYPE;
871:
872: cursor get_username_from_userid (l_userid in fnd_user.user_id%type) is
873: select user_name

Line 870: l_description UMX_REG_SERVICES_VL.DESCRIPTION%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;
870: l_description UMX_REG_SERVICES_VL.DESCRIPTION%TYPE;
871:
872: cursor get_username_from_userid (l_userid in fnd_user.user_id%type) is
873: select user_name
874: from fnd_user