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 306: x_reg_service_type out nocopy UMX_REG_SERVICES_VL.REG_SERVICE_TYPE%type,

302:
303: procedure get_req_data_from_req_id (
304: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%type,
305: p_reg_service_code in UMX_REG_SERVICES_B.REG_SERVICE_CODE%type,
306: x_reg_service_type out nocopy UMX_REG_SERVICES_VL.REG_SERVICE_TYPE%type,
307: x_requested_by_user_id out nocopy UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%type,
308: x_requested_for_user_id out nocopy UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%type,
309: x_requested_for_party_id out nocopy UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%type,
310: x_requested_username out nocopy UMX_REG_REQUESTS.REQUESTED_USERNAME%type,

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

307: x_requested_by_user_id out nocopy UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%type,
308: x_requested_for_user_id out nocopy UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%type,
309: x_requested_for_party_id out nocopy UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%type,
310: x_requested_username out nocopy UMX_REG_REQUESTS.REQUESTED_USERNAME%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,

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

308: x_requested_for_user_id out nocopy UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%type,
309: x_requested_for_party_id out nocopy UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%type,
310: x_requested_username out nocopy UMX_REG_REQUESTS.REQUESTED_USERNAME%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,

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

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

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

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

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

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

Line 331: FROM UMX_REG_SERVICES_VL regser, fnd_form_functions func,

327: regser.DESCRIPTION, regreq.JUSTIFICATION, regreq.REQUESTED_BY_USER_ID,
328: regreq.REQUESTED_FOR_USER_ID, regreq.REQUESTED_FOR_PARTY_ID,
329: regreq.REQUESTED_USERNAME, regser.wf_notification_event_guid,
330: regser.wf_bus_logic_event_guid
331: FROM UMX_REG_SERVICES_VL regser, fnd_form_functions func,
332: UMX_REG_REQUESTS regreq
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;

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

384:
385:
386: procedure get_req_data_from_req_sv_code (
387: p_reg_service_code in UMX_REG_SERVICES_B.REG_SERVICE_CODE%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,

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

385:
386: procedure get_req_data_from_req_sv_code (
387: p_reg_service_code in UMX_REG_SERVICES_B.REG_SERVICE_CODE%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,

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

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

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

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

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

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

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

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

Line 406: FROM UMX_REG_SERVICES_VL regser, fnd_form_functions func

402: regser.wf_notification_event_guid, regser.AME_APPLICATION_ID,
403: regser.AME_TRANSACTION_TYPE_ID, regser.EMAIL_VERIFICATION_FLAG,
404: func.FUNCTION_NAME, regser.DISPLAY_NAME, regser.DESCRIPTION,
405: regser.wf_bus_logic_event_guid
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;

Line 450: p_wf_role_name in UMX_REG_SERVICES_VL.WF_ROLE_NAME%type,

446: end if;
447: end get_req_data_from_req_sv_code;
448:
449: procedure get_req_data_from_role_name (
450: p_wf_role_name in UMX_REG_SERVICES_VL.WF_ROLE_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,

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

448:
449: procedure get_req_data_from_role_name (
450: p_wf_role_name in UMX_REG_SERVICES_VL.WF_ROLE_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,

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

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

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

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

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

Line 517: l_wf_role_name UMX_REG_SERVICES_VL.WF_ROLE_NAME%TYPE;

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

Line 518: l_reg_service_type UMX_REG_SERVICES_VL.REG_SERVICE_TYPE%TYPE;

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

Line 519: l_application_id UMX_REG_SERVICES_VL.APPLICATION_ID%TYPE;

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

Line 521: l_ame_application_id UMX_REG_SERVICES_VL.AME_APPLICATION_ID%TYPE;

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

Line 522: l_ame_transaction_type_id UMX_REG_SERVICES_VL.AME_TRANSACTION_TYPE_ID%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;
525: l_display_name UMX_REG_SERVICES_VL.DISPLAY_NAME%TYPE;
526: l_description UMX_REG_SERVICES_VL.DESCRIPTION%TYPE;

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

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

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

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

Line 852: l_application_id UMX_REG_SERVICES_VL.APPLICATION_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;
855: l_description UMX_REG_SERVICES_VL.DESCRIPTION%TYPE;
856:

Line 854: l_display_name UMX_REG_SERVICES_VL.DISPLAY_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;
855: l_description UMX_REG_SERVICES_VL.DESCRIPTION%TYPE;
856:
857: cursor get_username_from_userid (l_userid in fnd_user.user_id%type) is
858: select user_name

Line 855: l_description UMX_REG_SERVICES_VL.DESCRIPTION%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;
855: l_description UMX_REG_SERVICES_VL.DESCRIPTION%TYPE;
856:
857: cursor get_username_from_userid (l_userid in fnd_user.user_id%type) is
858: select user_name
859: from fnd_user