APPS.PA_CI_SECURITY_PKG dependencies on PA_CI_TYPES_B

Line 24: l_class_code pa_ci_types_b.ci_type_class_code%TYPE;

20: p_user_id NUMBER DEFAULT fnd_global.user_id,
21: p_resp_id NUMBER DEFAULT fnd_global.resp_id)
22: RETURN VARCHAR2
23: IS
24: l_class_code pa_ci_types_b.ci_type_class_code%TYPE;
25: BEGIN
26: IF G_user_id <> p_user_id THEN
27: G_user_id := p_user_id;
28: G_resp_id := p_resp_id;

Line 46: FROM pa_ci_types_b cit,

42: END IF;
43:
44: SELECT ci_type_class_code
45: INTO l_class_code
46: FROM pa_ci_types_b cit,
47: pa_control_items ci
48: WHERE ci.ci_id = p_ci_id
49: AND cit.ci_type_id = ci.ci_type_id;
50:

Line 91: l_class_code pa_ci_types_b.ci_type_class_code%TYPE;

87: p_user_id NUMBER DEFAULT fnd_global.user_id,
88: p_resp_id NUMBER DEFAULT fnd_global.resp_id)
89: RETURN VARCHAR2
90: IS
91: l_class_code pa_ci_types_b.ci_type_class_code%TYPE;
92: BEGIN
93: IF G_user_id <> p_user_id THEN
94: G_user_id := p_user_id;
95: G_resp_id := p_resp_id;

Line 742: FROM pa_ci_types_b

738: END IF;
739:
740: SELECT allow_all_usage_flag
741: INTO l_allow_all_usage_flag
742: FROM pa_ci_types_b
743: WHERE ci_type_id = p_ci_type_id;
744:
745: IF l_allow_all_usage_flag = 'N' THEN
746: BEGIN