APPS.FA_ASSET_TRACE_PVT dependencies on FND_PROFILE_OPTION_VALUES

Line 618: l_respid fnd_profile_option_values.level_value%type;

614: PROCEDURE get_system_options (p_sys_opt_tbl IN VARCHAR2,
615: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
616:
617: l_userid NUMBER;
618: l_respid fnd_profile_option_values.level_value%type;
619: l_appid fnd_profile_option_values.level_value_application_id%type;
620: l_resp_name VARCHAR2(100);
621: l_stmt VARCHAR2(32767);
622: l_counter NUMBER :=0;

Line 619: l_appid fnd_profile_option_values.level_value_application_id%type;

615: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
616:
617: l_userid NUMBER;
618: l_respid fnd_profile_option_values.level_value%type;
619: l_appid fnd_profile_option_values.level_value_application_id%type;
620: l_resp_name VARCHAR2(100);
621: l_stmt VARCHAR2(32767);
622: l_counter NUMBER :=0;
623: l_cursor c_stmt;

Line 639: l_stmt :=l_stmt||' from fnd_profile_options fpon, fnd_profile_option_values user_pov

635: l_stmt :=fafsc('fpon.profile_option_name')||fafsc('site_pov.profile_option_value');
636: l_stmt :=l_stmt||fafsc('appl_pov.profile_option_value')||fafsc('resp_pov.profile_option_value');
637: l_stmt :=l_stmt||fafsc('user_pov.profile_option_value');
638: l_stmt :=substr(l_stmt, 1, length(l_stmt) -6)||'||'||''''||''||'''';
639: l_stmt :=l_stmt||' from fnd_profile_options fpon, fnd_profile_option_values user_pov
640: , fnd_profile_option_values resp_pov, fnd_profile_option_values appl_pov
641: , fnd_profile_option_values site_pov
642: where fpon.profile_option_id = user_pov.profile_option_id(+)
643: and fpon.application_id = user_pov.application_id(+)

Line 640: , fnd_profile_option_values resp_pov, fnd_profile_option_values appl_pov

636: l_stmt :=l_stmt||fafsc('appl_pov.profile_option_value')||fafsc('resp_pov.profile_option_value');
637: l_stmt :=l_stmt||fafsc('user_pov.profile_option_value');
638: l_stmt :=substr(l_stmt, 1, length(l_stmt) -6)||'||'||''''||''||'''';
639: l_stmt :=l_stmt||' from fnd_profile_options fpon, fnd_profile_option_values user_pov
640: , fnd_profile_option_values resp_pov, fnd_profile_option_values appl_pov
641: , fnd_profile_option_values site_pov
642: where fpon.profile_option_id = user_pov.profile_option_id(+)
643: and fpon.application_id = user_pov.application_id(+)
644: and fpon.profile_option_id = resp_pov.profile_option_id(+)

Line 641: , fnd_profile_option_values site_pov

637: l_stmt :=l_stmt||fafsc('user_pov.profile_option_value');
638: l_stmt :=substr(l_stmt, 1, length(l_stmt) -6)||'||'||''''||''||'''';
639: l_stmt :=l_stmt||' from fnd_profile_options fpon, fnd_profile_option_values user_pov
640: , fnd_profile_option_values resp_pov, fnd_profile_option_values appl_pov
641: , fnd_profile_option_values site_pov
642: where fpon.profile_option_id = user_pov.profile_option_id(+)
643: and fpon.application_id = user_pov.application_id(+)
644: and fpon.profile_option_id = resp_pov.profile_option_id(+)
645: and fpon.application_id = resp_pov.application_id(+)