APPS.PA_PM_FUNCTION_SECURITY_PUB dependencies on FND_FUNCTION

Line 15: --CURSOR l_fnd_function_csr IS

11: p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
12: p_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
13: p_function_allowed OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
14:
15: --CURSOR l_fnd_function_csr IS
16: --SELECT 'x'
17: --FROM fnd_form_functions ff,
18: -- fnd_resp_functions fr
19: --WHERE ff.function_name = p_function_name

Line 68: IF fnd_function.test(p_function_name) THEN

64: -- row for the cursor , then the function is not allowed
65:
66: /* Commented out the following code for bug 2442069 and replaced the logic. Please see below.
67:
68: IF fnd_function.test(p_function_name) THEN
69: p_function_allowed := 'Y';
70: l_function_allowed := 'Y';
71: ELSE
72: p_function_allowed := 'N';

Line 82: IF fnd_function.test(p_function_name) THEN

78: IF PA_INTERFACE_UTILS_PUB.G_ADVANCED_PROJ_SEC_FLAG = 'N'
79: THEN
80:
81: -- -- dbms_output.put_line( 'Default Function Security is enforced! ' );
82: IF fnd_function.test(p_function_name) THEN
83: p_function_allowed := 'Y';
84: l_function_allowed := 'Y';
85: ELSE
86: p_function_allowed := 'N';

Line 112: -- OPEN l_fnd_function_csr;

108: END IF;
109: END IF;
110: --bug 2442069
111:
112: -- OPEN l_fnd_function_csr;
113: -- FETCH l_fnd_function_csr INTO l_dummy;
114: -- IF l_fnd_function_csr%FOUND THEN
115: -- p_function_allowed := 'N';
116: -- ELSE

Line 113: -- FETCH l_fnd_function_csr INTO l_dummy;

109: END IF;
110: --bug 2442069
111:
112: -- OPEN l_fnd_function_csr;
113: -- FETCH l_fnd_function_csr INTO l_dummy;
114: -- IF l_fnd_function_csr%FOUND THEN
115: -- p_function_allowed := 'N';
116: -- ELSE
117: -- p_function_allowed := 'Y';

Line 114: -- IF l_fnd_function_csr%FOUND THEN

110: --bug 2442069
111:
112: -- OPEN l_fnd_function_csr;
113: -- FETCH l_fnd_function_csr INTO l_dummy;
114: -- IF l_fnd_function_csr%FOUND THEN
115: -- p_function_allowed := 'N';
116: -- ELSE
117: -- p_function_allowed := 'Y';
118: -- END IF;

Line 119: -- CLOSE l_fnd_function_csr;

115: -- p_function_allowed := 'N';
116: -- ELSE
117: -- p_function_allowed := 'Y';
118: -- END IF;
119: -- CLOSE l_fnd_function_csr;
120:
121: -- Included call to Set_Global_Vars, to set the global variables
122: -- which are used in checking if check_function_security procedure has
123: -- already been called. This way, we are avoiding multiple calls to