[Home] [Help]
860: l_status varchar2(1);
861: l_msg_count number;
862: l_msg_data varchar2(1000);
863: l_reason varchar2(240);
864: l_forward_role wf_roles.name%TYPE;
865: l_valid_user VARCHAR2(1);
866: l_due_date DATE;
867: l_priority NUMBER;
868: l_message_name wf_notifications.message_name%TYPE;
1845: FND_GLOBAL.APPS_INITIALIZE(l_user_id,l_resp_id,l_appl_id);
1846:
1847: --Bug No:5897122.
1848: --Bug No: 6865713. Replaced l_trx_id with p_trx_id.
1849: create_wf_roles(p_trx_id);
1850: --End: 5897122.
1851: wf_engine.SetItemAttrText
1852: (itemtype => 'FUNRMAIN',
1853: itemkey => p_eventkey,
1951: l_activity_name varchar2(30);
1952: l_approver_record ame_util.approverRecord2;
1953: BEGIN
1954: --Bug No:5897122.
1955: create_wf_roles(p_trx_id);
1956: --End: 5897122.
1957: wf_engine.SetItemAttrText
1958: (itemtype => 'FUNRMAIN',
1959: itemkey => p_eventkey,
2061: l_activity_name varchar2(30);
2062: l_approver_record ame_util.approverRecord2;
2063: BEGIN
2064: --Bug No:5897122.
2065: create_wf_roles(p_trx_id);
2066: --End: 5897122.
2067: wf_engine.SetItemAttrText
2068: (itemtype => 'FUNRMAIN',
2069: itemkey => p_eventkey,
4187: END generate_acct_lines;
4188:
4189: -- Bug No:5897122. This cursor will fetch the user names to whom the Notification options is not active and
4190: -- having access to approve the transaction.
4191: procedure create_wf_roles (
4192: trx_id in varchar2)
4193: IS
4194: c_user_name varchar2(100);
4195: -- l_userTable WF_DIRECTORY.UserTable;
4222: role_name => 'FUN_ADHOC_RECI_'||trx_id, role_users => c_user_name);
4223:
4224: END IF;
4225:
4226: END create_wf_roles;
4227: END;