DBA Data[Home] [Help]

APPS.QP_SECU_CTRL_PVT dependencies on FND_PROFILE

Line 15: l_security_control_prof := nvl(fnd_profile.value(g_security_control_prof), g_security_off);

11: l_security_control_prof varchar2(30);
12: l_stmt varchar2(20000);
13: l_save boolean;
14: begin
15: l_security_control_prof := nvl(fnd_profile.value(g_security_control_prof), g_security_off);
16:
17: if (p_security_control = g_security_off and (l_security_control_prof = g_security_on or p_control = g_y)) then
18: begin
19: l_save := fnd_profile.save(x_name => g_security_control_prof,

Line 19: l_save := fnd_profile.save(x_name => g_security_control_prof,

15: l_security_control_prof := nvl(fnd_profile.value(g_security_control_prof), g_security_off);
16:
17: if (p_security_control = g_security_off and (l_security_control_prof = g_security_on or p_control = g_y)) then
18: begin
19: l_save := fnd_profile.save(x_name => g_security_control_prof,
20: x_value => g_security_off,
21: x_level_name => 'SITE');
22:
23: l_stmt :=

Line 318: l_save := fnd_profile.save(x_name => g_security_control_prof,

314: end;
315:
316: elsif (p_security_control = g_security_on and (l_security_control_prof = g_security_off or p_control = g_y)) then
317: begin
318: l_save := fnd_profile.save(x_name => g_security_control_prof,
319: x_value => g_security_on,
320: x_level_name => 'SITE');
321:
322: l_stmt :=