DBA Data[Home] [Help]

APPS.GL_PUBLIC_SECTOR dependencies on FND_PROFILE

Line 19: l_value fnd_profile_option_values.profile_option_value%TYPE;

15: l_user_id fnd_user.user_id%TYPE := NULL;
16: l_resp_appl_id fnd_application.application_id%TYPE := FND_GLOBAL.RESP_APPL_ID;
17: l_user_resp_id fnd_responsibility.responsibility_id%TYPE := p_user_resp_id;
18:
19: l_value fnd_profile_option_values.profile_option_value%TYPE;
20: l_defined BOOLEAN;
21:
22: l_gov_message_name fnd_new_messages.message_name%type;
23: l_temp_message_name VARCHAR2(40) := p_message_name||'_G';

Line 32: FND_PROFILE.GET_SPECIFIC('INDUSTRY',

28: IF l_user_resp_id IS NULL THEN
29: l_user_resp_id := FND_GLOBAL.RESP_ID;
30: END IF;
31:
32: FND_PROFILE.GET_SPECIFIC('INDUSTRY',
33: l_user_id,
34: l_user_resp_id,
35: l_resp_appl_id,
36: l_value,