DBA Data[Home] [Help]

APPS.UMX_REGISTRATION_UTIL dependencies on WF_ACTIVITY_ATTRIBUTES

Line 335: l_rby_userid_string WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;

331: l_reg_svc_code UMX_REG_SERVICES_B.REG_SERVICE_CODE%TYPE;
332: l_reg_svc_type UMX_REG_SERVICES_B.REG_SERVICE_TYPE%TYPE;
333: l_requested_by_user_id fnd_user.user_id%type;
334: l_requested_for_user_id fnd_user.user_id%type;
335: l_rby_userid_string WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
336: l_rfor_userid_string WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
337: l_launch_workflow boolean := false;
338:
339: BEGIN

Line 336: l_rfor_userid_string WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;

332: l_reg_svc_type UMX_REG_SERVICES_B.REG_SERVICE_TYPE%TYPE;
333: l_requested_by_user_id fnd_user.user_id%type;
334: l_requested_for_user_id fnd_user.user_id%type;
335: l_rby_userid_string WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
336: l_rfor_userid_string WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
337: l_launch_workflow boolean := false;
338:
339: BEGIN
340: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 1522: l_person_first_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;

1518: resultout out NOCOPY varchar2) is
1519:
1520: l_user_name fnd_user.user_name%type;
1521: l_email_address fnd_user.email_address%type;
1522: l_person_first_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1523: l_person_last_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1524: l_person_middle_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1525: l_prefix WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1526: l_suffix WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;

Line 1523: l_person_last_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;

1519:
1520: l_user_name fnd_user.user_name%type;
1521: l_email_address fnd_user.email_address%type;
1522: l_person_first_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1523: l_person_last_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1524: l_person_middle_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1525: l_prefix WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1526: l_suffix WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1527: l_requested_for_user_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;

Line 1524: l_person_middle_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;

1520: l_user_name fnd_user.user_name%type;
1521: l_email_address fnd_user.email_address%type;
1522: l_person_first_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1523: l_person_last_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1524: l_person_middle_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1525: l_prefix WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1526: l_suffix WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1527: l_requested_for_user_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1528: l_reg_svc_type WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;

Line 1525: l_prefix WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;

1521: l_email_address fnd_user.email_address%type;
1522: l_person_first_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1523: l_person_last_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1524: l_person_middle_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1525: l_prefix WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1526: l_suffix WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1527: l_requested_for_user_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1528: l_reg_svc_type WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1529:

Line 1526: l_suffix WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;

1522: l_person_first_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1523: l_person_last_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1524: l_person_middle_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1525: l_prefix WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1526: l_suffix WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1527: l_requested_for_user_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1528: l_reg_svc_type WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1529:
1530: l_return_status varchar2 (10);

Line 1527: l_requested_for_user_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;

1523: l_person_last_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1524: l_person_middle_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1525: l_prefix WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1526: l_suffix WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1527: l_requested_for_user_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1528: l_reg_svc_type WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1529:
1530: l_return_status varchar2 (10);
1531: l_msg_count number;

Line 1528: l_reg_svc_type WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;

1524: l_person_middle_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1525: l_prefix WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1526: l_suffix WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1527: l_requested_for_user_id WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1528: l_reg_svc_type WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1529:
1530: l_return_status varchar2 (10);
1531: l_msg_count number;
1532: l_msg_data varchar2 (280);

Line 1537: l_ad_hoc_role WF_ACTIVITY_ATTRIBUTES.text_default%type;

1533: l_formatted_name varchar2 (300);
1534: l_formatted_lines_cnt number;
1535: l_formatted_name_tbl hz_format_pub.string_tbl_type;
1536:
1537: l_ad_hoc_role WF_ACTIVITY_ATTRIBUTES.text_default%type;
1538:
1539: BEGIN
1540:
1541: if (command = 'RUN') then

Line 1739: l_adhoc_role_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;

1735: activity_id in number,
1736: command in varchar2,
1737: resultout out NOCOPY varchar2) is
1738:
1739: l_adhoc_role_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1740: l_reg_svc_type WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1741:
1742: begin
1743:

Line 1740: l_reg_svc_type WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;

1736: command in varchar2,
1737: resultout out NOCOPY varchar2) is
1738:
1739: l_adhoc_role_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1740: l_reg_svc_type WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1741:
1742: begin
1743:
1744: if (command = 'RUN') then

Line 1939: l_custom_event_context WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;

1935: command in varchar2,
1936: resultout out NOCOPY varchar2) is
1937:
1938: l_custom_event wf_events.name%type;
1939: l_custom_event_context WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1940: l_parameter_list wf_parameter_list_t;
1941: l_event wf_event_t;
1942: l_event_key number;
1943: l_reg_svc_type UMX_REG_SERVICES_B.REG_SERVICE_TYPE%TYPE;