APPS.FA_ASSET_TRACE_PVT dependencies on FND_PROFILE_OPTION_VALUES

Line 625: l_respid fnd_profile_option_values.level_value%type;

621: PROCEDURE get_system_options (p_sys_opt_tbl IN VARCHAR2,
622: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
623:
624: l_userid NUMBER;
625: l_respid fnd_profile_option_values.level_value%type;
626: l_appid fnd_profile_option_values.level_value_application_id%type;
627: l_resp_name VARCHAR2(100);
628: l_stmt VARCHAR2(32767);
629: l_counter NUMBER :=0;

Line 626: l_appid fnd_profile_option_values.level_value_application_id%type;

622: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
623:
624: l_userid NUMBER;
625: l_respid fnd_profile_option_values.level_value%type;
626: l_appid fnd_profile_option_values.level_value_application_id%type;
627: l_resp_name VARCHAR2(100);
628: l_stmt VARCHAR2(32767);
629: l_counter NUMBER :=0;
630: l_cursor c_stmt;

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

642: l_stmt :=fafsc('fpon.profile_option_name')||fafsc('site_pov.profile_option_value');
643: l_stmt :=l_stmt||fafsc('appl_pov.profile_option_value')||fafsc('resp_pov.profile_option_value');
644: l_stmt :=l_stmt||fafsc('user_pov.profile_option_value');
645: l_stmt :=substr(l_stmt, 1, length(l_stmt) -6)||'||'||''''||''||'''';
646: l_stmt :=l_stmt||' from fnd_profile_options fpon, fnd_profile_option_values user_pov
647: , fnd_profile_option_values resp_pov, fnd_profile_option_values appl_pov
648: , fnd_profile_option_values site_pov
649: where fpon.profile_option_id = user_pov.profile_option_id(+)
650: and fpon.application_id = user_pov.application_id(+)

Line 647: , fnd_profile_option_values resp_pov, fnd_profile_option_values appl_pov

643: l_stmt :=l_stmt||fafsc('appl_pov.profile_option_value')||fafsc('resp_pov.profile_option_value');
644: l_stmt :=l_stmt||fafsc('user_pov.profile_option_value');
645: l_stmt :=substr(l_stmt, 1, length(l_stmt) -6)||'||'||''''||''||'''';
646: l_stmt :=l_stmt||' from fnd_profile_options fpon, fnd_profile_option_values user_pov
647: , fnd_profile_option_values resp_pov, fnd_profile_option_values appl_pov
648: , fnd_profile_option_values site_pov
649: where fpon.profile_option_id = user_pov.profile_option_id(+)
650: and fpon.application_id = user_pov.application_id(+)
651: and fpon.profile_option_id = resp_pov.profile_option_id(+)

Line 648: , fnd_profile_option_values site_pov

644: l_stmt :=l_stmt||fafsc('user_pov.profile_option_value');
645: l_stmt :=substr(l_stmt, 1, length(l_stmt) -6)||'||'||''''||''||'''';
646: l_stmt :=l_stmt||' from fnd_profile_options fpon, fnd_profile_option_values user_pov
647: , fnd_profile_option_values resp_pov, fnd_profile_option_values appl_pov
648: , fnd_profile_option_values site_pov
649: where fpon.profile_option_id = user_pov.profile_option_id(+)
650: and fpon.application_id = user_pov.application_id(+)
651: and fpon.profile_option_id = resp_pov.profile_option_id(+)
652: and fpon.application_id = resp_pov.application_id(+)