DBA Data[Home] [Help]

APPS.UMX_REGISTRATION_PVT dependencies on FND_FORM_FUNCTIONS

Line 331: x_reg_function_name out nocopy FND_FORM_FUNCTIONS.FUNCTION_NAME%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
335:

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 408: x_reg_function_name out nocopy FND_FORM_FUNCTIONS.FUNCTION_NAME%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
412:

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 470: x_reg_function_name out nocopy FND_FORM_FUNCTIONS.FUNCTION_NAME%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
474: select REG_SERVICE_TYPE, REG_SERVICE_CODE, AME_APPLICATION_ID,

Line 537: l_reg_function_name fnd_form_functions.FUNCTION_NAME%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;
541: l_justification UMX_REG_REQUESTS.JUSTIFICATION%TYPE;

Line 868: l_reg_function_name fnd_form_functions.FUNCTION_NAME%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:
872: cursor get_username_from_userid (l_userid in fnd_user.user_id%type) is