APPS.GL_AUTO_ALLOC_WF_PKG dependencies on FND_USER

Line 66: fnd_user_name Varchar2(100);

62: l_gl_allow_preparer_approval Varchar2(30);
63: l_continue_next_step Varchar2(1);
64: l_value fnd_profile_option_values.profile_option_value%TYPE;
65: l_WorkFlow_Launch Boolean;
66: fnd_user_name Varchar2(100);
67: Cursor c_set_name IS
68: Select
69: ALLOCATION_SET_ID
70: ,ALLOCATION_SET_NAME

Line 94: FROM fnd_user

90:
91:
92: Cursor f_user_name IS
93: SELECT user_name
94: FROM fnd_user
95: WHERE user_id = l_user_id;
96:
97: Cursor coa_id IS
98: SELECT chart_of_accounts_id

Line 205: fetch f_user_name into fnd_user_name;

201: FND_PROFILE.GET('GL_ALLOW_PREPARER_APPROVAL', l_gl_allow_preparer_approval);
202:
203: -- Get AOL user name
204: Open f_user_name;
205: fetch f_user_name into fnd_user_name;
206: close f_user_name;
207:
208: -- Set the process owner
209: wf_engine.SetItemOwner( itemtype => p_item_type,

Line 211: owner => fnd_user_name );

207:
208: -- Set the process owner
209: wf_engine.SetItemOwner( itemtype => p_item_type,
210: itemkey => p_item_key,
211: owner => fnd_user_name );
212:
213: FND_PROFILE.GET('GL_JRNL_REVW_REQUIRED', l_value);
214: wf_engine.SetItemAttrText( itemtype => p_item_type,
215: itemkey => p_item_key,

Line 1049: ,p_preparer_fnd_user_id => l_user_id

1045: diagn_debug_msg('Launch_JE_Approval: ' || 'Launching journal approval process');
1046: END IF;
1047: GL_WF_JE_APPROVAL_PKG.start_approval_workflow
1048: ( p_je_batch_id => l_gen_batch_id
1049: ,p_preparer_fnd_user_id => l_user_id
1050: ,p_preparer_resp_id => l_resp_id
1051: ,p_je_batch_name => l_gen_batch_name
1052: );
1053: End If;