DBA Data[Home] [Help]

APPS.GL_CI_WORKFLOW_PKG dependencies on FND_PROFILE

Line 199: FND_PROFILE.GET('GL_GLCCIT_EMAIL_CONTACT', v_user_name);

195: v_SQL := 'select user_je_source_name from gl_je_sources ' ||
196: 'WHERE je_source_name = :s_name';
197: EXECUTE IMMEDIATE v_SQL INTO l_user_je_source_name USING l_je_source;
198: --+ l_journal_source_name := 'Consolidation';
199: FND_PROFILE.GET('GL_GLCCIT_EMAIL_CONTACT', v_user_name);
200: IF v_user_name IS NOT NULL THEN
201: v_SQL := 'BEGIN '||' :a := ' || applSysSchema ||'.GL_CI_REMOTE_INVOKE_PKG.Get_email_address@' || dblink ||
202: '(:user_name)' ||';'||' END;';
203: EXECUTE IMMEDIATE v_SQL USING OUT l_send_to, IN v_user_name;