DBA Data[Home] [Help]

APPS.UMX_REGISTRATION_PVT dependencies on FND_FORM_FUNCTIONS

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

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

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

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

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